| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of J.Velikanovs_at_alise.lv
Sent: Wednesday, July 21, 2004 7:32 PM
To: oracle-l_at_freelists.org
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_at_hotsos.com>
Sent by: oracle-l-bounce_at_freelists.org
22.07.2004 02:15
Please respond to oracle-l
=20
To: <oracle-l_at_freelists.org>
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_at_freelists.org =3D
[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,=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_at_cpas.com>
Sent by: oracle-l-bounce_at_freelists.org
21.07.2004 18:05
Please respond to oracle-l
=3D20
To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
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:
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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Wed Jul 21 2004 - 19:51:37 CDT
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
 |
 |