Re: Undo Usage and Read consistency - ORA-1555
- From: fairlie rego <fairlie_r@xxxxxxxxx>
- To: nancy_iles@xxxxxxxxxxx, andrew.kerber@xxxxxxxxx
- Date: Tue, 14 Jul 2009 19:03:29 -0700 (PDT)
A 1555 errorstack will show the snapshot SCN of the query and buffer SCN. Are
you able to generate one?
Is there a lob column on the table?
Fairlie Rego
Senior Oracle Consultant
http://el-caro.blogspot.com/
M: +61 402 792 405
--- On Wed, 15/7/09, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote:
From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
Subject: Re: Undo Usage and Read consistency - ORA-1555
To: nancy_iles@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx, cicciuxdba@xxxxxxxxx
Received: Wednesday, 15 July, 2009, 11:53 AM
How long does it run before you get the ora-1555 message?
On Tue, Jul 14, 2009 at 5:04 PM, Nancy Iles <nancy_iles@xxxxxxxxxxx> wrote:
Yes, the there is an index on CONFIRMATION_NO and I have found that
_OPTIM_PEEK_USER_BINDS=FALSE on all 6 RAC nodes. So, now on to research the
other suggestions! Thanks to everyone for your input.
Nancy
________________________________
> From: jkstill@xxxxxxxxx
> Date: Tue, 14 Jul 2009 08:56:04 -0700
> Subject: Re: Undo Usage and Read consistency - ORA-1555
> To: nancy_iles@xxxxxxxxxxx
> CC: cicciuxdba@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>
> On Tue, Jul 14, 2009 at 8:35 AM, Nancy Iles> wrote:
>
>
>
>
> We have sporadic ora-1555 on an exceptionally simple statement that occurs
> frequently in the application. How can you analyze why this tiny, simple
> statement is causing an ORA-1555? The statement is:
>
>
>
> SELECT RESV_NAME_ID , RESORT FROM RESERVATION_NAME WHERE CONFIRMATION_NO = :1
>
>
>
> Is an appropriate index being used by the SELECT?
>
> Normally I would expect to see something such as CONFIRMATION_NO to
> be accessed via indexed lookup, but it doesn't hurt to confirm that.
>
>
>
> Barring that, have you tried running a 10046 trace on that statement so
> you can see what is taking place to satisfy the query?
>
> Lots of guessing here, because there isn't really much to go on in this post.
>
>
>
> Jared
>
_________________________________________________________________
Lauren found her dream laptop. Find the PC that’s right for you.
http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290--
//www.freelists.org/webpage/oracle-l
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
____________________________________________________________________________________
Access Yahoo!7 Mail on your mobile. Anytime. Anywhere.
Show me how: http://au.mobile.yahoo.com/mail
Other related posts:
