Database Administration (MOSC)

MOSC Banner

DBMS_SCHEDULER.PURGE_LOG

edited Apr 3, 2019 5:00AM in Database Administration (MOSC) 2 commentsAnswered

This is a branch (side question) from ORA-27412 - need another set of eyes

Looking at why some jobs were not listed in DBA_SCHEDULER_JOB_LOG, I found the answer but that led me to look at record retention for that view.

SQL> select count(*) from dba_scheduler_job_log;  COUNT(*)----------    1266721 row selected.SQL> select min(log_date) from dba_scheduler_job_log;MIN(LOG_DATE)---------------------------------------------------------------------------14-MAR-10 01.23.38.418445 PM -05:001 row selected.SQL> --

So looking for possible ways to do housekeeping and delete obsolete rows, I find DBMS_SCHEDULER.PURGE_LOG.  Which says "By default, the Scheduler automatically purges all rows in the job log and window log that are older than 30 days. The

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center