RE: Determine current event level

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 19 Aug 2004 16:09:20 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DE86@usahm018.exmi01.exch.eds.com>

Here is a little script I use:

set echo off
--

Use ORADEBUG to dump event settings for system
--
Based on Oracle support metalink rdbms forum post 08/04/2003
by Melissa Holman Subject: Setting Event Trace
--
20030805 Mark D Powell New, capture useful functionality
--
*** 2003-08-05 09:58:20.827
*** SESSION ID:(34.5167) 2003-08-05 09:58:20.781
Dump event group for level PROCESS
TC Addr Evt#(b10) Action TR Addr Arm Life
101D9020 4031 1 101d9080 0 0
--
set echo on ORADEBUG SETMYPID ORADEBUG DUMP EVENTS 2 ORADEBUG TRACEFILE_NAME

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jesse, Rich Sent: Thursday, August 19, 2004 4:01 PM
To: ORACLE-L (E-mail)
Subject: Determine current event level

Hey all,

We've been having sporadic problems in 9.2.0.5 of queries blowing up = with ORA-1555 -- and they should, since they've been running (more = likely waiting for a user to click "OK") two hours or better.

I had set event 1555 to level 1, but that didn't provide any information = on the client. Oracle Support suggested level 3 and I *thought* I did = that, but the last trace looks no different.

How can I determine what level the event is currently set to? I don't = see any V$ views that seem to contain the info, and my X$ content is a = little rusty... :)

Anyone?

TIA,
Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA


----------------------------------------------------------------

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 Thu Aug 19 2004 - 15:05:47 CDT