Re: snapshot too old error

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Wed, 2 Jun 2010 04:31:32 -0700 (PDT)
Message-ID: <805c3c0e-c24d-40fd-a812-28d904f41611_at_r9g2000vbk.googlegroups.com>



Zigzag:

# I changed default 800 seconds undo_retention to 1 day. I got past that error, but now another error came on a different table:
> ORA-00600: internal error code, arguments: [b], [23786], [121640375], [121640408], Could not find anything on  kdliSyncRead on google or metalink. Looked at trace file, seems like some core dump.

... Oracle 11.1.0.7.1 has all kind sof bugs; problem is now I am in production so cannot back out of this release.

Pretty darn stable for me so far all things considered.

Seems like your plan for testing out your planned release level before moving into production was missing some really big pieces.

Why on earth would one put in a very large undo tablespace with a very small value set for undo_retention unless one had missed many of the important concepts involved here in this very important piece of system architecture? Received on Wed Jun 02 2010 - 06:31:32 CDT

Original text of this message