how to find trace file
902332Mar 8 2013 — edited Mar 8 2013hi all,
i generated a trace file using :
SQL> alter system set events '1940 trace name errorstack level 3';
System altered.
SQL> drop user RHUNTER1;
drop user RHUNTER1
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> alter system set events '1940 trace name errorstack off';
System altered.
it's oracle 10gr2 database. Now i checked for trace file in udump. but there are lot of trace files generating in a minute. how can i find the exact trace file.
please help to find this.
thanks