Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Report of DBMS_JOBS and resource utilization.

RE: Report of DBMS_JOBS and resource utilization.

From: Larry Klein <Larry.Klein_at_Hotsos.com>
Date: Wed, 23 Jun 2004 22:03:55 -0500
Message-ID: <002b01c45997$e3504980$220110ac@lkleinlap>


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_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.
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_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


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 Jun 23 2004 - 22:00:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US