RE: Determine current event level
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Aug 2004 16:09:20 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
----------------------------------------------------------------
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:
