If you found this problem in a Pluggable Database (PDB), then we might have the same issue. My finding is that AUTOTASK is always triggered… Read More »Scheduled Jobs Running at Wrong Time
Scheduler Time Zone Before doing that, we have make sure the time zone region you want to set is valid for Oracle. Then we change… Read More »How to Set Scheduler Time Zone
PACKAGE DBMS_SCHEDULER I found that some subprograms of DBMS_SCHEDULER package are no listed in the Oracle documentation. However, we get the complete list by describing… Read More »DBMS_SCHEDULER All Available Subprograms
Sometimes, we may find scheduled jobs currently impact other running sessions, we may consider to turn it off right away. Killing the scheduled job sessions… Read More »How to Stop a Running Scheduler Job
What is LAST_DDL_TIME? Generally speaking, LAST_DDL_TIME means the last change date time of the object definition, all by Data Definition Language (DDL). But sometimes, it's… Read More »LAST_DDL_TIME was Changed, Why?
0653-609 Cannot remove Tried to remove some files, but it failed with 0653-609 Cannot remove. Let's see the case. [oracle@primary01 export]$ pwd /backup/export [oracle@primary01 export]$… Read More »How to Resolve rm: 0653-609 Cannot remove