Re: query log

From: <stevedhoward_at_gmail.com>
Date: 7 Apr 2006 07:50:08 -0700

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: <stevedhoward_at_gmail.com>
</span>
<span id="date"><dfn>Date</dfn>: 7 Apr 2006 07:50:08 -0700</span>
<span id="message-id"><dfn>Message-ID</dfn>: <1144421408.240390.269220_at_g10g2000cwb&#46;<!--nospam-->googlegroups.com>
</span>
</address>

<br>

You could use a logon trigger to selectively trace some sessions. If you are using connection pooling software, this may not prove useful. If you would like, on the fly, you could also issue something like the following from SQL*PLUS...

begin
<br>

  for c in ( select sid,serial#

               from v$session
               where paddr in (select addr
                                 from v$process
                                 where nvl(background,0) != 1) ) loop

    dbms_system.Set_Ev(c.sid,c.serial#,10046,4,'');     DBMS_OUTPUT.PUT_LINE('Turned on level 4 tracing for session ' || c.sid || '...' );
<br>

  end loop;
<br>

end;
<br>

/

This will trace all sessions currently logged in, but not new ones (you can do that as well, if interested). I wouldn't leave it on too long, though, as it can get really verbose, depending on the level of trace. If you do go this route, (we do every once in a while for debuigging as well), make sure your max_dump_file_size is large.

Regards,

Steve
<span id="received"><dfn>Received on</dfn> Fri Apr 07 2006 - 09:50:08 CDT</span>
</div>
Received on Fri Apr 07 2006 - 09:50:08 CDT