DBMS_JOB

How to Resolve PLS-00201: identifier 'DBMS_SQL' must be declared

by Ed Chen
June 21, 2022June 29, 2022
2 Comments

PLS-00201 We have talked about some common patterns of PLS-00201. Here is another case. Found some packages of CTXSYS are invalid, most compile errors are… Read More »

AWR Report for Standard Edition?

by Ed Chen
April 28, 2018October 7, 2022

AWR for Standard Edition I was assigned to collect some performance data in an unfamiliar database. While I ran AWR report by executing @?/rdbms/admin/awrrpt.sql under… Read More »

How to Resolve ORA-23421: job number is not a job in the job queue

by Ed Chen
January 13, 2018December 11, 2022

ORA-23421 When I tried to remove a given job from the queue, the statement failed with ORA-23421, and ORA-06512 are also in the error stack.… Read More »

How to Fix Broken Statspack Snapshot Jobs

by Ed Chen
December 30, 2016May 30, 2022
2 Comments

Saw a broken statspack snapshot job stopped working for several days. I tried to run the job on the spot but it still failed. So… Read More »