Re: ORACLE Session Trace.

From: Antoine BRUNEL <antoinebrunel_at_nospam_yahoo.fr>
Date: Mon, 10 Jan 2005 03:13:13 +0100
Message-ID: <41e1e480$0$13469$79c14f64@nan-newsreader-07.noos.net>

Hi from Paris

for the current session, you can know it with DBMS_SYSTEM.READ_EV ...

example on Metalink:

http://support.oracle.co.uk/metalink/plsql/ml2_documents.showNOT?p_id=28446.1&p_showHeader=1&p_showHelp=1

Specification:
procedure read_ev(iev binary_integer, oev out binary_integer);

Get the level of the event 'iev' if set in the current session.

.... but no ideas on how to find this for othe sessions..... certainly through the X$ views... I will try to investigate this on wednesday (no time before)

"Dexter" <vikram_ramakrishnan_at_ieee.org> a écrit dans le message de news: 1105245560.562421.28890_at_c13g2000cwb.googlegroups.com...
> Hi,
>
> how do i find if an oracle session is being traced?.
> If i have lot of sessions running in parallel and want to find all the
> session that are running 10046 level4 trace.how do i do it.
> any help or pointers would be helpuful.
>
> -Thanks,
> Vikram
>
Received on Sun Jan 09 2005 - 20:13:13 CST