Databases Reference
In-Depth Information
The
PURGE_LOG
job launches a
Program
named
SYS.PURGE_LOG
which is defined as
a
STORED_PROCEDURE
and whose procedure name is
DBMS_SCHEDULER.AUTO_PURGE
.
This stored program unit receives no arguments and it purges the logs based on
its retention period. The
DEFAULT_JOB_CLASS
has no explicit retention period
declared, so it takes the default value of 30 days. This should be enough to maintain
a reasonable amount of log history for most practical situations, but as the purge
log job has been defined using the standard
DBMS_SCHEDULER
infrastructure you can
tailor it to it your particular log retention needs.
Data dictionary related views
The Oracle Scheduler DBA related data dictionary views are:
View Description
DBA_SCHEDULER_CHAINS
All Scheduler chains in the database.
DBA_SCHEDULER_CHAIN_RULES
All rules from Scheduler chains in the database.
DBA_SCHEDULER_CHAIN_STEPS
All steps of Scheduler chains in the database.
DBA_SCHEDULER_GLOBAL_ATTRIBUTE
All Scheduler global attributes.
DBA_SCHEDULER_JOBS
All Scheduler jobs in the database.
DBA_SCHEDULER_JOB_ARGS
All arguments with set values of all Scheduler
jobs in the database.
DBA_SCHEDULER_JOB_CLASSES
All Scheduler classes in the database.
DBA_SCHEDULER_JOB_LOG
Logged information for all Scheduler jobs.
DBA_SCHEDULER_JOB_RUN_DETAILS
The details of a job run.
DBA_SCHEDULER_PROGRAMS
All Scheduler programs in the database.
DBA_SCHEDULER_PROGRAM_ARGS
All arguments of all Scheduler programs in
the database.
DBA_SCHEDULER_RUNNING_CHAINS
All steps of all running chains in the database.
DBA_SCHEDULER_SCHEDULES
All schedules in the database.
DBA_SCHEDULER_WINDOWS
All Scheduler windows in the database.
DBA_SCHEDULER_WINDOW_DETAILS
The details of a window.
DBA_SCHEDULER_WINDOW_GROUPS
All Scheduler window groups in the database.
DBA_SCHEDULER_WINDOW_LOG
Logged information for all Scheduler windows.
DBA_SCHEDULER_WINGROUP_MEMBERS
Members of all Scheduler window groups in
the database.
V$SCHEDULER_RUNNING_JOBS
Currently running jobs.
DBA_QUEUE_SCHEDULES
Describes the current schedules for
propagating messages.
Search WWH ::
Custom Search