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

--
http://www.freelists.org/webpage/oracle-l