1 Reply Latest reply: Dec 7, 2012 8:42 AM by 972756 RSS

    USER_SCHEDULER_JOB_RUN_DETAILS

    975570
      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,