RE: 12.2.0.1 scheduler tables not being purged

From: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Date: Tue, 25 May 2021 11:42:52 +0000
Message-ID: <DM6PR09MB4677CE5FBC02BF7E13D7BFFDDF259_at_DM6PR09MB4677.namprd09.prod.outlook.com>

Select * from dba_scheduler_global_attribute ;

ATTRIBUTE_NAME

---

VALUE

---

MAX_JOB_SLAVE_PROCESSES LOG_HISTORY
30

DEFAULT_TIMEZONE
US/Eastern

LAST_OBSERVED_EVENT EVENT_EXPIRY_TIME CURRENT_OPEN_WINDOW EMAIL_SERVER EMAIL_SERVER_ENCRYPTION
NONE EMAIL_SERVER_CREDENTIAL EMAIL_SENDER FILE_WATCHER_COUNT
0

11 rows selected.

From: Beckstrom, Jeffrey
Sent: Tuesday, May 25, 2021 7:33 AM
To: Karthikeyan Panchanathan <keyantech_at_gmail.com>; oracle-l_at_freelists.org Subject: RE: 12.2.0.1 scheduler tables not being purged

There is no object called dba_shcheduler_global_Attirbute.

The scheduler shows "purge_log" as running with no failures.

From: Karthikeyan Panchanathan <keyantech_at_gmail.com<mailto:keyantech_at_gmail.com>> Sent: Monday, May 24, 2021 4:32 PM
To: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org<mailto:jbeckstrom_at_gcrta.org>>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: Re: 12.2.0.1 scheduler tables not being purged

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://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Faka.ms%2Fo0ukef&data=04%7C01%7Cjbeckstrom%40gcrta.org%7C3645f5c859224001456608d91ef30261%7Cebe8e20736ec47f48cb8f5f757605f5d%7C1%7C0%7C637574851358670049%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=u16vpoQbSrTCWw6eLX%2FxCwbs4kgeU2u1NSrrcn%2FjgIM%3D&reserved=0>

---

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org<mailto:jbeckstrom_at_gcrta.org>> Sent: Monday, May 24, 2021 2:45:42 PM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> <oracle-l_at_freelists.org<mailto: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 Tue May 25 2021 - 13:42:52 CEST