Job queues and CPU usage

From: Martin, Alan (Contractor) (DLIS) <Alan.S.Martin_at_dla.mil>
Date: Wed, 4 Aug 2004 16:03:22 -0400
Message-ID: <F9DC9C3FC34CB14B8682798D6FF1C5AB0109B0C8@btl1s-exch03.USE6.AD.DLA.MIL>

In an 8.1.7 DB, we have 30 job queues of which 16 are consistently busy. I can use DBA_JOBS_RUNNING, but can I correlate to which job queue and the CPU time used? Other ideas?
Thanx,
Alan Martin
Defense Logistics

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Aug 04 2004 - 14:59:39 CDT