Re: very slow query on dba_jobs_running...

Volker Hetzer wrote:

> 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

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Dec 1 17:16:37 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production

SQL> select job,sid from dba_jobs_running order by job;

no rows selected

SQL> set timing on
SQL> select job,sid from dba_jobs_running order by job;

no rows selected

Elapsed: 00:00:00.00
SQL> set timing off

This on a W2K box with 512MB RAM. I'd say you have a problem. What are those jobs doing? How much of your resources are being consumed?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)