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