It takes almost two minutes each on the following two queries,
select count(*) from USER_SCHEDULER_JOB_RUN_DETAILS;
select count(*) from USER_SCHEDULER_JOB_LOG;
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.