Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: When do system events become effective?
Generally speaking most events set at the system level will take effect only for new sessions.
It is possible to set trace (event 10046) on for an already running session.
How do I switch on sql trace in another session that is already running? http://www.jlcomp.demon.co.uk/faq/alien_trace.html
Oradebug has this capability.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Uwe Küchler
Sent: Wednesday, May 02, 2007 1:34 PM
To: oracle-l_at_freelists.org
Subject: When do system events become effective?
Oracle 9.2.0.6, HP-UX 11.11
Hello world,
today I was trying to track down the SQL causing a full TEMP tablespace by tracing the 1652 event. I tried the following commands:
on a running system, but no trace files have been generated, although the alert log was flooded with this event after enabling trace.
I had the same effect with the 10046 event a while ago and supposed that it only comes in effect when a new session is started, but then "oradebug" would be usesless in this case. This cannot be. Unfortunately (as so often) I didn't have the time to research, but now i need some input from you folks!
So, why is there no tracefile after enabling trace and clearly seeing the traced event happen?
Regards,
Uwe
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 03 2007 - 08:37:57 CDT
![]() |
![]() |