Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query log

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US