Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Wed May 02 2007 - 12:33:57 CDT
![]() |
![]() |