12.2.0.1 scheduler tables not being purged

  • From: "Beckstrom, Jeffrey" <jbeckstrom@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 May 2021 18:45:42 +0000

What purges the scheduler tables? We are seeing entries going back to 2011. The 
sys owned purge_log job does show as being scheduled with no failures.


select min (log_date) from dba_scheduler_job_log;

MIN(LOG_DATE)
---------------------------------------------------------------------------
03-OCT-11 10.00.01.100000 PM -04:00

select min (log_date) from sys.SCHEDULER$_EVENT_LOG;

MIN(LOG_DATE)
---------------------------------------------------------------------------
03-OCT-11 10.00.01.100000 PM -04:00

Jeffrey Beckstrom
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

Other related posts: