RE: How to learn of set (but forgotten) session tracing?

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Wed, 21 Jul 2004 18:15:43 -0500
Message-ID: <003801c46f78$a5954b80$e6ea8640@CVMLAP02>

See the link "How to Activate Extended SQL Trace" on the home page at www.hotsos.com. It's just above the book cover photo in the "From the = Hotsos
Library..." section.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 7/20 Cleveland, 8/10 Boston, 9/14 San = Francisco
- SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 = Hartford
- Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details...

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

From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of J.Velikanovs_at_alise.lv
Sent: Wednesday, July 21, 2004 10:31 AM
To: oracle-l_at_freelists.org
Subject: Re: How to learn of set (but forgotten) session tracing?

We can use dbms_system.read_ev(10046,event_level); for current session,=20 but I am unaware how to get info about other sessions. May be others can comment.

Jurijs
9268222
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D http://otn.oracle.com/ocm/jvelikanovs.html

Branimir Petrovic <BranimirP_at_cpas.com>
Sent by: oracle-l-bounce_at_freelists.org
21.07.2004 18:05
Please respond to oracle-l
=20

        To:     "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
        cc:=20
        Subject:        How to learn of set (but forgotten) session=20

tracing?

Hypothetical situation:

DBA sets session tracing to ON then starts (very) long running=20 heavy-duty batch job but "forgets" about it, say - goes home...=20

Other DBA takes over to see long job running even longer.

Tracing may be set via:

dbms_system.set_sql_trace_in_session or even via
alter session set events '10046....

Disregarding the fact that tracing of long running jobs will create then continiously grow the trace file (which will be sure sign of tracing in progress), is there a way to query Oracle and learn of=20 the fact that tracing is set for some or all of existing sessions?

Branimir=20

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

Received on Wed Jul 21 2004 - 18:14:05 CDT