Re: Undo Usage and Read consistency - ORA-1555

On Tue, Jul 14, 2009 at 8:35 AM, Nancy Iles <nancy_iles@xxxxxxxxxxx> 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

Other related posts: