The second database job is the DAMON data monitor job. The DAMON job runs the majority of the background processing and is responsible for running background clean up processes required by the application that can potentially take a relatively long time to run.
Oracle and DAMON
By default, DAMON runs every night at 1am (database timezone dependent). It uses the Oracle DBMS_SCHEDULER package to schedule the jobs. An Interval setting controls the schedule and accepts the same parameters as the DBMS_SCHEDULER interval. For more information, refer to your Oracle database documentation.
Microsoft SQL Server and DAMON
By default, DAMON runs every Saturday. You can set it to run every two weeks or on a specific day. To run DAMON every two weeks, use the following command to set the interval: -eg 2W
To set DAMON to run on a specific day, use the following setting under namespace: Database.background.Damon DayOfWeek
DAMON Procedures
DAMON cleans the following:
- BGPLOG table containing the background logs
- DBERRLOG table containing details of database related errors
- Logically deleted records
- PAUDIT table
- PKXREF table
- PC_PROCESS_STAT and PC_KEY_XREF tables
- PRMQUEUE table
- REFRDEL table
- Remaining USESSION records
- USESSAUD, the USESSION audit table
- Orphaned data from extended schema (PX) tables.
You can also dynamically extend DAMON functionality via the user-defined procedure, USER_DEFINED_BACKGROUND.