Find a query in Oracle with stats$sqltext
Hello, today we are going to teach you how to find a query in Oracle with system views. First let’s see what the situation is in which we must analyze …
Scripts in Oracle. Learn how to create them with examples
Hello everyone. Today we wanted to share with you a way to run Oracle commands within Linux scripts. A very convenient way to load environment variables is by using the …
ORA-00600: Error in Query Oracle 12c Using WITH
Hello, today we want to share an ORA-00600 error that has arisen in a client that shows how important it is to know the new functionalities of the application with …
Execution plan. Optimize query in Oracle
Hello, today we are going to share a recent optimization case. While reviewing performance issues for the optimization of an Oracle environment we detected a query that took 29 minutes …
Emcli creación credenciales en Cloud Control
Hola a todos.Hoy nos gustaría compartir con vosotros una forma de crear credenciales y asignar permisos en Cloud Control mediante línea de comando usando el comando emcli. Trabajando con EMCLI …
Create file tnsnames.ora from Cloud Control
Hello everyone! Today we wanted to share with you a script that we have used several times to generate the file tnsnames. ora connection by a query to Cloud Control. …