1 Reply Latest reply on Dec 7, 2012 2:42 PM by 972756


      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 - 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.