RDBMS
5 article(s) tagged with RDBMS
2024-07-25
Oracle Database - Enterprise Edition - Known Issues And Bugs Using the Scheduler
This guide is an attempt to list some tips and tricks, relevant notes, known bugs and issues related to Scheduler usage and try to provide the first steps for analyzing, and listing the relevant notes dependent on the database version and specific scheduler part.
2024-07-25
ORA-20011 ORA-29913 and ORA-29400 with Associated KUP-XXXXX Errors from DBMS_STATS .GATHER_STATS_JOB
When attempting to run GATHER_STATS_JOB the following errors occur: ORA-20011. Usually accompanied with varying other errors such as KUP-11024
2024-07-25
SYS.DBMS_SCHEDULER .CREATE_JOB Encounters ORA-00904: ORA-06512: at "SYS.DBMS_ISCHED" ORA-06512: at "
Error when attempting to create a job via DBMS_SCHEDULER
2024-07-25
Troubleshooting ORA-27300 ORA-27301 ORA-27302 Errors
The errors are usually caused by OS system call error or OS configuration issue.
2024-07-25
How to Diagnose High CPU Utilization of ORACLE.EXE in Windows Environment
On windows Oracle processes are represented as "Threads" of the Oracle process so if one session is using a lot of CPU this is simply displayed as "Oracle using CPU".