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

Ah. Use an operating system utility like lsof to see if the process =
you're
curious about has an open file handle associated with a file in the
user_dump_dest or background_dump_dest directory.

There's no direct way that I know of from within Oracle.


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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of J.Velikanovs@xxxxxxxx
Sent: Wednesday, July 21, 2004 7:32 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: How to learn of set (but forgotten) session tracing?

Thank you Cary,
It's seems I have missed some thing in document you are pointed on.
Is there information how to see if 10046 event is on for other session=20
then my?

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






"Cary Millsap" <cary.millsap@xxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
22.07.2004 02:15
Please respond to oracle-l
=20
        To:     <oracle-l@xxxxxxxxxxxxx>
        cc:=20
        Subject:        RE: How to learn of set (but forgotten) session=20
tracing?


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 =
=3D
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 =3D
Francisco
- SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 =3D
Hartford
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =3D
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of J.Velikanovs@xxxxxxxx
Sent: Wednesday, July 21, 2004 10:31 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: How to learn of set (but forgotten) session tracing?

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

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






Branimir Petrovic <BranimirP@xxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
21.07.2004 18:05
Please respond to oracle-l
=3D20
        To:     "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
        cc:=3D20
        Subject:        How to learn of set (but forgotten) session=3D20
tracing?


Hypothetical situation:

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

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=3D20
the fact that tracing is set for some or all of existing sessions?

Branimir=3D20
----------------------------------------------------------------
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 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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: