RE: Report of DBMS_JOBS and resource utilization.

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Thu, 24 Jun 2004 09:30:19 -0500
Message-ID: <433A07749711884D8032B6A0AB115262C2BC49@conmsx07.corp.acxiom.net>

Hi Larry, Raj,

We think we have a pretty good idea, just hoping to save some time. And, of course if we missed something.

Like Raj said we were going to have a table to keep track of stuff. We were planning to use the logon and logoff triggers. Logoff isn't enough because we want to know what resources were being used today. Some jobs never end and I thought jobs that got killed didn't invoke the logoff trigger either.

I'll take a look at audit_session. Hadn't thought about that.

	Thanks
	Larry

-----Original Message-----
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)
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Raj Jamadagni Sent: Thursday, June 24, 2004 6:25 AM
To: oracle-l_at_freelists.org
Subject: RE: Report of DBMS_JOBS and resource utilization.

I accomplished this (few months ago) using a small table, logoff trigger and v$session and
v$mystat ...

Raj
> -----Original Message-----
> 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.
>

Best Regards
Raj

select mandatory_disclaimer from company_requirements;

Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail

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


**********************************************************************
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
-----------------------------------------------------------------

Received on Thu Jun 24 2004 - 09:29:36 CDT