12.2.0.1 scheduler tables not being purged
From: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Date: Mon, 24 May 2021 18:45:42 +0000
Message-ID: <DM6PR09MB4677B808B7EDC4C182E6B295DF269_at_DM6PR09MB4677.namprd09.prod.outlook.com>
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.
03-OCT-11 10.00.01.100000 PM -04:00 select min (log_date) from sys.SCHEDULER$_EVENT_LOG;
03-OCT-11 10.00.01.100000 PM -04:00 Jeffrey Beckstrom
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
Date: Mon, 24 May 2021 18:45:42 +0000
Message-ID: <DM6PR09MB4677B808B7EDC4C182E6B295DF269_at_DM6PR09MB4677.namprd09.prod.outlook.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 24 2021 - 20:45:42 CEST