1 It would
2 Alter system set events= would do too, and
alter session set events= in an after logon trigger would do the same.
3 Alternatively you could program an on servererror trigger. This won't
capture the statement though, IIRC, but you could (re) RAISE the error
again in your trigger.
4 If you have several events to set they need to adjacent to each other
(with no other parameters in between) to get them all. Other than that,
they can be anywhere.
5 You can set the parameter tracefile_identifier, and this parameter
will be included in the name of your trace file.
Hth
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Nov 10 2005 - 08:36:57 CST
