RE: UNDO poll - was undo segments vs. rbs
- From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 May 2004 14:27:22 -0500
Keith,
thanks a lot.
So I was right, they do go to alert log in 9 or a least some 9s.
What's difference between
event="1555 trace name errorstack level 3"
and
event="1555 trace name errorstack level 5" ?
isn't that usually important?
We changed from 2 to 12 on
#event = "10235 trace name context forever, level 12" #TAR 3030722.995
and Batch jobs ran 10% slower
Thanks
Larry
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Keith Moore
Sent: Friday, May 21, 2004 12:56 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: UNDO poll - was undo segments vs. rbs
-- Attached file included as plaintext by Ecartis --
Well, we just upgraded from Oracle 8 to 9i (finally) and started getting
them. We do not have any of the events set, except the "4031"
Fri May 21 11:24:32 2004
ORA-01555 caused by SQL statement below (Query Duration=3773 sec, SCN:
0x0000.f121fc46):
Fri May 21 11:24:32 2004
SELECT ....
Keith
----- Original Message -----
From: "John Kanagaraj" <john.kanagaraj@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, May 20, 2004 4:12 PM
Subject: RE: UNDO poll - was undo segments vs. rbs
> Larry,
>
> > I haven't seen any, but don't UNDO 1555s get written to
> >alert log
> >now?
> >
> >!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
> >This is no doubt dependent on environment. If we get ORa-1555,
> >they're never reported to me.
> >
> >I don't manage RBS. I don't do anything with them, they seem
> >to work fine as is.
>
>
> 1555s (and 4031 and 1652s as well) do not get automatically written into
> alert log, as they are considered 'User errors' (for whatever clueless
> reason!). You can enable that though by inserting the following 'event'
> entries into your init.ora
>
> event="1555 trace name errorstack level 3"
> event="4031 trace name errorstack level 3"
> event="1652 trace name processstate level 10"
>
> Note though, that you will have to keep *all* event lines TOGETHER in the
> init.ora lines, otherwise only the last ones will take effect. (Same
problem
> with multiple utl_file_dir lines!)
>
> Hth,
> John Kanagaraj <><
> DB Soft Inc
> Phone: 408-970-7002 (W)
>
> Disappointment is inevitable, but Discouragement is optional!
>
> ** The opinions and facts contained in this message are entirely mine and
do
> not reflect those of my employer or customers **
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Attached file included as plaintext by Ecartis --
-- Desc: Signature
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
