Re: Difference between ALTER SYSTEM SET EVENTS and init.ora parameter?

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Fri, 23 Jun 2006 19:24:58 -0700 (PDT)
Message-ID: <20060624022458.34256.qmail@web31904.mail.mud.yahoo.com>

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.       

• Fairlie

"Jesse, Rich" <Rich.Jesse_at_qg.com> wrote:   Howdy all,

I have a support tech telling me that:

alter system set events '6500 trace name processstate level 10';

will NOT produce the same trace file as setting:

event= "6500 trace name processstate level 10"

in the init.ora and bouncing the 9.2.0.5.0 instance. The tech's unable to explain what the difference is, however. I tried testing this by setting event 1652 as above and running a cartesian product with an ORDER BY. The trace was created just fine from what I can see. I can't justify bouncing a production instance because a tech says so (and no way in hell I will without explanation).

Anyone have any ideas what the difference might be, if any?

TIA!
Rich
--

http://www.freelists.org/webpage/oracle-l

          Fairlie Rego
Senior Oracle Consultant   

  http://el-caro.blogspot.com/                      

---

Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 23 2006 - 21:24:58 CDT