problem creating tracefile level12
Date: Mon, 24 Nov 2008 08:31:56 -0800 (PST)
I'm trying to create a level 12 trace for a surtain process. After finding out the sid and serial, i try:
exec dbms_system.set_ev (si=>19, se=>1423,ev=>10046,le=12,nm=>NULL)
or the above with the dbms_support.start_trace_in_session( etc...)
both didn't work on the unix machine.
When i tried it on my windows laptop the tracefile coundn't be moved because '..some other process keeps it open..' and this was AFTER i closed the tracefile creation.
So perhaps oracle keeps the file open even when ordered to stop the trace? I recalled i deleted the udump directory on the unix machine before starting the trace.
So how to create a level 12 of someone elses session?
TIA Received on Mon Nov 24 2008 - 10:31:56 CST