snapshot too old error

Posted on 2012-08-13
Last Modified: 2012-08-27
How we will resolve snapshot too old error in 9i, 10g and 11g

step by step...
Shall I ask you what are the major causes of snap shot too old error
Question by:tomvv
    LVL 1

    Accepted Solution

    LVL 34

    Assisted Solution

    The major cause of snapshot too old in my experience is fetch across commits.  This is in a PL/SQL procedure where there is a loop that contains a commit and the statements in the loop are updating/deleting the table that is being selected from.

    To correct, a combination of the following are used:

    Increase undo_retention parameter
    Increase the size of the undo tablespace
    Re-write the code

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now