3 Replies Latest reply: Mar 30, 2011 3:31 AM by 851526 RSS

    Default Oracle Jobs - Where is the documentation?

    Satish Kandi
      Hi,

      Oracle 10.2.0 has following job linked to schedule 'DAILY_PURGE_SCHEDULE'.

      PURGE_LOG - which is a call to SYS.PURGE_LOG_PROG->DBMS_SCHEDULER.AUTO_PURGE

      Oracle 11.2.0 has following jobs linked to schedule 'DAILY_PURGE_SCHEDULE'.

      PURGE_LOG - which is a call to SYS.PURGE_LOG_PROG->DBMS_SCHEDULER.AUTO_PURGE
      ORA$AUTOTASK_CLEAN - which is a call to SYS.ORA$AGE_AUTOTASK_DATA->dbms_autotask_prvt.age

      The comments read "purge log program" and "deletes obsolete AUTOTASK repository data" respectively.

      I have been searching in Oracle documentation and MOS for details of these procedures (AUTO_PURGE and AGE) - searching for what they do and not the code - but I can't find anything.

      The documentation of DBMS_SCHEDULER does not list AUTO_PURGE as a sub program and documentation for DBMS_AUTOTASK_PRVT does not exist (may be PRVT=private?).

      Is this a documentation miss out or is my search not exhaustive enough?

      And, could anyone share their inputs in this regard and let me know whats these procedures actually do?

      Regards,

      Satish