Databases Reference
In-Depth Information
Purging the job log
Among the factory programmed jobs, Oracle provides a job named
PURGE_LOG.
This job is in charge of purging the job log.
PURGE_LOG
(
A
) is a job owned by
SYS
which generates logs only when it runs, this job belongs to the
DEFAULT_JOB_
CLASS
(
B
) and is scheduled with the
SYS.DAILY_PURGE_SCHEDULE
(
C
), a schedule
configured as a standard schedule to be launched daily at 03:00 a.m.
Name
Schema
Enabled
Description
Type
Procedure Name :dbms_scheduler.auto_purge
:PURGE_LOG_PROG
:SYS
:TRUE
:purge log program
:STORED_PROCEDURE
Schedule
Schema
Schedule Type
Frequency
Interval
Scheduled by
: DAILY_PURGE_SCHEDULE
: SYS
: standard
: DAILY
: 1
: 03h 00m 00s
Default log retention period = 30 days
Program
Schedule
SYS.DAILY_PURGE_SCHEDULE
SYS.PURGE_LOG_PROG
Job
SYS.PURGE_LOG
Search WWH ::
Custom Search