Database Tuning (MOSC)

MOSC Banner

Getting ORA-01555 while no space pressure on UNDO tbs nor max query exceeded UNDO_RETENTION

When running dbms_sqlpa, we encounter snapshot too old but we didn't see any issue with free space nor long query duration, we keep running into the same issue (3x) although nothing else running in database except dbms_sqlpa.

SQL> begin dbms_sqlpa.execute_analysis_task(task_name => 'SPA_RAT_C361_R5_FULL', execution_type => 'TEST EXECUTE', execution_name => 'AFTER1-RAT_C361_R5_FULL', execution_desc => 'Creating After1 Trial for SPA_RAT_C361_R5_FULL', execution_params => dbms_advisor.arglist('sqlset_name','SQLSET_RAT_C361_R5_FULL','sqlset_owner','SYS')); end;

/

begin

*

ERROR at line 1:

ORA-01555: snapshot too old: rollback segment number 6 with name

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center