- 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.
WAIT Clause for DMLs in 26.2
-
Oracle 26ai 26.2 now introduces the WAIT (and NOWAIT) Clause for INSERT /
UPDATE / DELETE / MERGE DMLs. We have had a WAIT Clause for SELECT FOR
UPDATE...
Acum 3 săptămâni
Niciun comentariu:
Trimiteți un comentariu