This discussion is archived
1 Reply Latest reply: Dec 7, 2012 6:42 AM by 972756 RSS

USER_SCHEDULER_JOB_RUN_DETAILS

975570 Newbie
Currently Being Moderated
Hi Folks,

It takes almost two minutes each on the following two queries,

select count(*) from USER_SCHEDULER_JOB_RUN_DETAILS;
162 records

select count(*) from USER_SCHEDULER_JOB_LOG;
171 records

All other USER_* views are fine and come back within miliseconds.

We are running Oracle Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit.

USER_SCHEDULER_JOB_LOG and USER_SCHEDULER_JOB_RUN_DETAILS did gro to millions and purged them about a week ago.

Your comments and suggestions are much appreciated on this.

Thanks,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points