Database Administration (MOSC)

MOSC Banner

Undo retention

Hi,

On 11.2.0.4 on AIX

In alerte log I have:

Wed Jan 24 16:54:55 2024 : ORA-01555 caused by SQL statement below (SQL ID: 1mdghtsrez, Query Duration=9143 sec, SCN: 0x0b1e.7ea89):”

But undo retention is 9882

SQL> show parameter retention

NAME                 TYPE    VALUE

------------------------------------ ----------- ------------------------------

undo_retention            integer   9882

Thanks for any explanation/solution.

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