My mistake. Tracing is done for only new seesion that starts after enabling the trace. I was checking for some quries in the already open session. It works fine after I started a new session. A followup question - Is it possible to get trace for already opened session. If I have to trace for SQls comming through application server connection pooled session, which are already open when application server starts. Any ideas? Or I have restart the application server sessions to get trace. BTW- I think level 4 is the default. Thanks On 1/11/06, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote: > Don't forget to set the level: > > alter session set events '10046 trace name context forever, level x'; > > Where x=1, standard SQL_TRACE=TRUE, no waits or binds > x=4, trace + binds > x=8, trace + waits > x=12, trace + binds + waits > > Your syntax for disabling trace looks fine to me. > > > -Mark > > -- > Mark J. Bobak > Senior Oracle Architect > ProQuest Information & Learning > > "There are 10 types of people in the world: Those who understand > binary, and those who don't." > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sandeep Dubey > Sent: Wednesday, January 11, 2006 1:37 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Database tracing > > Hi, > > Database 10.2, OS Linux > > I used to get the whole database tracing using Alter system set events > '10046 trace name context forever', but now it doesn't seem to work. > > I am doing : > > SQL>Alter system set events '10046 trace name context forever'; > > some sql queries > > SQL>Alter system set events '10046 trace name context off'; > > I don't set any trace file in the user_dump_dest directory. > Timed_statistics is TRUE. > > Am I missing something? > > Thanks > > Sandeep > -- > //www.freelists.org/webpage/oracle-l > > > > > -- //www.freelists.org/webpage/oracle-l