Snapshot too old in 9i
I have a database running on 9i with automated UNDO management but am still getting the "SNAPSHOT TOO OLD" error when running long queries and even with exports. I have changed the UNDO_RETENTION paramater to various levels, reducing it and also increasing it. I have also quadrupled the UNDO tablespace datafiles over the past week and am still getting the error. I have queried the v$undostat view filtering for the largest SSOLDERRCNT and get the following....
Anybody have any tips on troubleshooting?
OCP DBA 8, 8i; MCDBA; MCSE
Look for short DML, try to reduce their commit frequency and, if possible, run your query on another time to avoid concurrency with these DML - or the opposite. Depending of the query (we don't know how it looks like), it may be rewritten to avoid fetch across commits.
Try to read this too:
An ounce of action is worth a ton of theory.
Click Here to Expand Forum to Full Width