Re: 10046 trace and alert log destination full
From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Tue, 17 Mar 2009 22:02:46 -0700
Message-ID: <2ead3a60903172202k56f51650g1634324647ca31c3_at_mail.gmail.com>
>> I plan on activating sys 10046 trace, to find a problem that occurs late
>> at night.
Date: Tue, 17 Mar 2009 22:02:46 -0700
Message-ID: <2ead3a60903172202k56f51650g1634324647ca31c3_at_mail.gmail.com>
>> I plan on activating sys 10046 trace, to find a problem that occurs late
>> at night.
Hi Yechiel,
If this is 10g *and* the application uses DBMS_APPLICATION_INFO to set Module/Program/Action or the Client_ID, you can always use DBMS_MONITOR to selectively start the trace. Is this a Connection Pooled instance? That will also change the way trace would work as it would be difficult to detect *which* session is executing the SQL in question.... In other words, YMMV.
Shalom,
-- John Kanagaraj <>< http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 18 2009 - 00:02:46 CDT