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.
By default, DAMON runs every Saturday. 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.
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 cleans the following:
You can also dynamically extend DAMON functionality via the user-defined procedure, USER_DEFINED_BACKGROUND.
USESSION_CLEAR_LOGICAL_DELETES Procedure
CLEANUP_LOGICAL_DELETES Procedure
USER_DEFINED_BACKGROUND Procedure
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, September 30, 2016