Forgot your password?    
+ Reply to Thread
Results 1 to 3 of 3

Thread: Snapshot too old other solution

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31

    Snapshot too old other solution

    Apart from increasing undo retention What could be another solution or what can we do further?

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    With Automatic Undo Management :

    - Increase the Undo Retention
    - Make sure you have increased the Undo Tabalespace size so that it can hold more undo , as per new undo retention value

    To make sure that one session is not causing the problems on the complete instance
    - Check which program / user is consuming too much of Undo , and ask him to introduce more frequent commits , or not run his program during peak business hours

  3. #3
    Oracle Administrator
    Join Date
    Dec 2011
    Posts
    92
    Hi, You can also guarantee your undo retention.

    what this setting does is it never expires undo data whose age is less than the undo retention period.

    Ex: Check your undo tablespace name

    SQL>show parameter tablespace;

    check whether it is in guarantee mode or not.

    SQL>select tablespace_name, retention from dba_tablespaces
    where tablespace_name = 'UNDOTBS1';


    it will either show a value of "GUARANTEE" or "NOGUARANTEE".

    to put it in guarantee mode execute the following:

    SQL>alter tablespace undotbs1 retention guarantee;

    CAUTION:This feature can cause DML operations to fail if the undo tablespace is not big enough.
    But, with proper settings, long-running queries can complete without risk of receiving the "snapshot too old" message.

+ Reply to Thread

Similar Threads

  1. Oracle Database Row Chaining Solution.
    By ajaychandi in forum Database Performance Management,Database Links,Materialized Views
    Replies: 0
    Last Post: 01-25-2012, 02:49 PM
  2. Replies: 0
    Last Post: 11-02-2011, 08:05 PM
  3. Snapshot backups
    By ajaysingh in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 1
    Last Post: 10-31-2011, 03:16 PM
  4. Maintain Snapshot Information to update and create Snapshots
    By Hemant in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 0
    Last Post: 10-30-2011, 10:21 AM

Tags for this Thread

Posting Permissions

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

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics