Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> very slow query on dba_jobs_running...
Hi!
I've got a query "select job,sid from dba_jobs_running order by job"
which takes really long (10min or longer) on an idle database with at most
2 jobs running in parallel.
Does anyone else have this problem?
I'm using 9.2.0.4.0 on RH linux.
Lots of Greetings!
Volker
Received on Mon Dec 01 2003 - 11:41:01 CST