Strange snapshot too old during a select statement 2004-03-11 - By Richard Foote
Strange snapshot too old during a select statementHi Philippe,
Ummm, I must be missing something here ?
Snapshot too old errors occur because Oracle can 't reconstruct a consistent
image of a block for the purposes of a consistent read.
And when do you generally require a consistent read ? During a select ...
And when are you likely to hit a snapshot too old ? During a long running
select as Oracle needs to reconstruct all blocks back to the time the query
started and the likelihood of such being possible diminishes over time.
You 've described the classic scenario when ORA-01555 (See ORA-01555.ora-code.com)s occur.
I think the Oracle Support person who said it 's not possible since this was
only a select statement is smoking some seriously dangerous substances ;)
Cheers
Richard
-- -- Original Message -- --
From: NGUYEN Philippe (Cetelem)
To: 'oracle-l@(protected) '
Sent: Thursday, March 11, 2004 6:46 PM
Subject: Strange snapshot too old during a select statement
Hi list!
we encounter a very strange "ORA-01555 (See ORA-01555.ora-code.com) : snapshot too old :rollback segment
number 3 with name "_SYSSMU3$ " too small "
This is a very long query
With a query that only make a select statement.
We have open a TAR with Oracle Support but they say that it 's not possible
since this only a "select " statement ?!!
Any idea ?
TIA
Philippe
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
