Snapshot too old in 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Snapshot too old in 9i

  1. #1
    Join Date
    Jan 2002
    Posts
    36

    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....


    BEGIN_TIM 27-Jun-03
    END_TIME 27-Jun-03
    UNDOTSN 1
    UNDOBLKS 971
    TXNCOUNT 7373
    MAXQUERYLEN 3127
    MAXCONCURRENCY 4
    UNXPSTEALCNT 0
    UNXPBLKRELCNT 0
    UNXPBLKREUCNT 0
    EXPSTEALCNT 0
    EXPBLKRELCNT 0
    EXPBLKREUCNT 0
    SSOLDERRCNT 74
    NOSPACEERRCNT 0

    Anybody have any tips on troubleshooting?

    Thanks,
    Steven
    Steven
    soestx@aol.com
    OCP DBA 8, 8i; MCDBA; MCSE

  2. #2
    Join Date
    Feb 2001
    Posts
    295
    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:

    http://asktom.oracle.com/pls/ask/f?p...:275215756923,
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width