Both of which would not be necessary, as the process that we'd be watching is a user connection that hasn't happened yet. And exactly what I thought. Time to make some changes I guess... Thanks Fairlie and Alex! Rich -----Original Message----- From: Alex Gorbachev [mailto:gorbyx@xxxxxxxxx] Sent: Saturday, June 24, 2006 5:11 AM To: fairlie_r@xxxxxxxxx Cc: Jesse, Rich; oracle-l@xxxxxxxxxxxxx Subject: Re: Difference between ALTER SYSTEM SET EVENTS and init.ora parameter? And I guess you can set event for those processes specifically using say ORADEBUG. 2006/6/24, fairlie rego <fairlie_r@xxxxxxxxx>: > > Hi Rich, > > The only difference that I know of is that the processstate will not be > dumped for processes already spawned before this comand is issued should > they encounter the error. > e.g if dbwr encounters 6500 then the processstate of dbwr will not be > dumped. > For any new process spawned its state would be dumped if it encounters an > ora-6500. -- Best regards, Alex Gorbachev http://blog.oracloid.com -- //www.freelists.org/webpage/oracle-l