Re: 12.2.0.1 scheduler tables not being purged

From: Karthikeyan Panchanathan <keyantech_at_gmail.com>
Date: Mon, 24 May 2021 20:32:09 +0000
Message-ID: <SA0PR02MB7484FD81A3DE8CBE298219C1FF269_at_SA0PR02MB7484.namprd02.prod.outlook.com>

Dbms_scheduler.run_job(‘PURGE_LOG’)

That should purge job log.

Please check dba_shcheduler_global_Attirbute where attribute_name=‘LOG_HISTORY’ to see log history value

Get Outlook for iOS<https://aka.ms/o0ukef>

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org> Sent: Monday, May 24, 2021 2:45:42 PM
To: oracle-l_at_freelists.org <oracle-l_at_freelists.org> Subject: 12.2.0.1 scheduler tables not being purged

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-l

Received on Mon May 24 2021 - 22:32:09 CEST