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. …
Días que no existen en Oracle: En 1582…
En el post de hoy queremos compartir una curiosidad que hemos encontrado trabajando con campos de tipo fecha en Oracle. ¡¡¡¡Hay varios días que no existen en la BBDD!!!! Esto …