RE: Report of DBMS_JOBS and resource utilization.
- From: "Larry Klein" <Larry.Klein@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 22:03:55 -0500
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
- Hotsos Symposium 2005 on Oracle System Performance, Dallas, March 6-10
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Wolfson Larry - lwolfs
Sent: Wednesday, June 23, 2004 6:36 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
