Snapshot too Old - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Snapshot too Old

  1. #11
    Join Date
    Dec 2001
    Location
    Edmonton, Canada
    Posts
    50
    I have already checked all plans and this is the one i got most optimized.

    Moreover I think The actual problem is with Snaposhot too old error rather than query tunning.
    May be it could be bug with oracle and i need to apply the latest patch for it right now i am running oracle 9.2.0.1.

    I hope this time it won'nt give me snapshot too old error.
    An elephant is a mouse with an operating system.
    Share on Google+

  2. #12
    Join Date
    Dec 2001
    Location
    Edmonton, Canada
    Posts
    50
    The only noticable thing is that, The snapshot too old error occurs just after the full table scan ends and when the sort for order by clause starts.
    An elephant is a mouse with an operating system.
    Share on Google+

  3. #13
    Join Date
    May 2001
    Posts
    73
    U may need to raise your UNDO_RETENTION parameter value.Also check the usage of space in UNDO tablespace while running your query.If neccessary increase the size.
    OCP 7.3,8.0,8i,9i
    Share on Google+

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