Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Report of DBMS_JOBS and resource utilization.
Hi Larry, what about audit_session or a database logoff trigger?
Larry Klein
Hotsos Enterprises, Ltd.
http://www.hotsos.com
630-513-8010 (Chicago office)
630-240-1190 (cellphone)
Upcoming events:
- Performance Diagnosis (3 day class) starting on/in
06/22 Pittsburgh, 07/20 Cleveland, 08/10 Boston 09/14 San Francisco - SQL Optimization (4 day class) starting on/in 06/14 Chicago, 06/28 Denver, 07/26 WashDC 08/16 Minneapolis, 09/20 TBA, 10/18 New Orleans 11/08 Dallas, 12/13 Atlanta
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Wolfson Larry - lwolfs
Sent: Wednesday, June 23, 2004 6:36 PM
To: 'oracle-l_at_freelists.org'
Subject: Report of DBMS_JOBS and resource utilization.
Hi guys!
Anyone have a report that shows resource consumption by scheduled jobs?
Would like to see report of jobs that ran today and their resource consumption. CPU and I/O that is.
Including jobs currently running as we have some jobs that never
end. At least 2 anyway.
And 16 others started and still running today.
TIA Larry Wolfson **********************************************************************The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.