Skip to Content
avatar image
Former Member

ORA-01555 caused by SQL statement below

Dear all,

How can I treat this error ?

ORA-01555 caused by SQL statement below (SQL ID: 9kh4f608ty7un, Query Duration=88767 sec, SCN: 0x0000.db7b3cef): : Category 1

Any ideas ? I did not touch the DB, so I am not sure why it came.

Thanks in advance,

Daniel.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 09, 2012 at 03:34 AM

    HI ,

    You have to tune the parameter undo_retention.

    for this please have a look Note 185822 - ora-1555 - cause and action

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09, 2012 at 07:38 AM

    Hi,

    Please go through notes detailed explanation is given

    Note 60233 - Oracle rollback segments, more information.

    Note 185822 - ora-1555 - cause and action

    Add comment
    10|10000 characters needed characters exceeded