Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Difference between ALTER SYSTEM SET EVENTS and init.ora parameter?

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

From: Jesse, Rich <Rich.Jesse_at_qg.com>
Date: Mon, 26 Jun 2006 09:55:25 -0500
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697A51E3F@QTEX1.qg.com>


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_at_gmail.com] Sent: Saturday, June 24, 2006 5:11 AM
To: fairlie_r_at_yahoo.com
Cc: Jesse, Rich; oracle-l_at_freelists.org
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_at_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.

-- 
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 26 2006 - 09:55:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US