Thanks, Srivenu. That's a perfect answer for Dexter's question,
assuming he's not using 10g which would have dba_enabled_traces (as
Niall says). Expanding this thread to check whether a non-10046 event
is set in another session, I posted a message before using event
errorstack as an example:
http://groups-beta.google.com/group/comp.databases.oracle.server/msg/b44fcbcef5a55323
The number 604 is arbitrarily chosen. The difference between SQL-trace
(10046) and others such as errorstack is that in the latter case, the
trace file is not immediately created. Therefore oradebug
tracefile_name still does not show a filename in udump, but oradebug
dump events 1 creates a trace file.
Yong Huang
yong321ATyahoo.com
Received on Mon Jan 10 2005 - 22:00:50 CST
