problem creating tracefile level12

From: Helma <>
Date: Mon, 24 Nov 2008 08:31:56 -0800 (PST)
Message-ID: <>

hello everyone,

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

Original text of this message