ORA-01551: What does it mean ?

[former_member185954]

Hello Experts,

I ran a Index repair job on our BW system: SAP_INFOCUBE_INDEXES_REPAIR

The job completed successfully rebuilding some of the secondary indexes.

However, I found the following error in system log:

ORA-01551: extended rollback segment, pinned blocks released

The database is alright and from oerr command output, I don't get any information on what it means.

oerr ora 01551
01551, 00000, "extended rollback segment, pinned blocks released"
// *Cause: Doing recursive extent of rollback segment, trapped internally
//        by the system
// *Action: None

I have tried google, however it simply gives me lots of website giving the oerr output.

Has anyone faced this ? Does anyone know about this error message ?

Regards,

Siddhesh

[solution_studio · Accepted solution]

ORA-1551 means out-of-memory. This will occur when you are reading too many records.

There is nothing wronge with your database. No need to worry.

[former_member185954]

Thanks for your responses, sorry i couldn't get back earlier.

[Former Member]

If you are on Oracle 9.2.0.7 and the error happened during an index coalesce this can be Oracle bug 5218288.

[stefan_koehler]

Hello Siddhesh,

this is an internal ORA error and can be "ignored".

If you want some more information about that you can check metalinknote #1030619.6.

> These errors should be handled internally and can be safely ignored. The operation should succeed on later attempts. They indicate that the rollback segments are shrinking.

Regards

Stefan