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.