- ORA-04020: deadlock detected while trying to lock object SYS.SCHEDULER$_EVENT_QUEUE
ORA-06512: at "SYS.DBMS_ISCHED", line 7761
ORA-06512: at "SYS.DBMS_SCHEDULER", line 4063
Solution: try to run the same sql statement ( DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION ) as user sys.
Oracle 19c Automatic Indexing: Index Created But Not Actually Used (Because Your Young) - The following is an interesting example of how Oracle Automatic Indexing is currently implemented that can result in an Automatic Index being created b...
Acum o oră