7 Replies Latest reply: Apr 29, 2014 11:58 AM by J.A. RSS

    Purge Job Tables SCHEDULER$_EVENT_LOG

    J.A.

      Hi Experts

       

      Please I need your help with this issue:

       

      Oracle Rac two Nodes 11gR2

       

      I have one Rac DataBase somehow the Job tables: SCHEDULER$_EVENT_LOG  and SCHEDULER$_JOB_RUN_DETAILS grow a lot.

       

      When I execute a query to see the MyJob details, this query takes a lot of time to finish, because of the size of those tables, also the auto purge delay a few hours to finish and it´s not purging.

       

      Now I want to purge those tables and I´ve done this:

       

      execute DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('log_history','1');

       

      BEGIN

        DBMS_SCHEDULER.purge_log (

          log_history => 1,

          which_log   => 'JOB_LOG',

          job_name    => 'MYJOB' );

      END;

      /

       

      BEGIN

      DBMS_SCHEDULER.purge_log (

          log_history => 1,

          which_log   => 'WINDOW_LOG',

          job_name    => 'MYJOB');

      END;

      /

       

      BEGIN

      DBMS_SCHEDULER.PURGE_LOG(log_history => 1, which_log => 'JOB_LOG');

      END;

      /

       

      I am not able to purge those tables. We run chain Jobs every night.

       

      Any advice is going to be appreciated

       

      Regards

       

      J.A.