ORA-01555

[Juarez Guimaraes]

Someone can help me explain how do I increase the rollback area in an Oracle 9.2.0.5?

[MuLtAnI]

Select all

ORA-01555 snapshot too old: rollback segment number string with name "string" 
too small 
Cause: Rollback records needed by a reader for consistent read are overwritten 
by other writers. 
Action: If in Automatic Undo Management mode, increase the setting of 
UNDO_RETENTION. Otherwise, use larger rollback segments.

tries to increase the value of UNDO_RETENTION if I am not mistaken the default is 900 seconds.

You can set it in the startup parameter UNDO_RETENTION = 10
or manually

Select all

ALTER SYSTEM SET UNDO_RETENTION = 5;

: -The

[] 's

[MuLtAnI]

Ahhhh if you need to change the rollback segment,

Select all

ALTER ROLLBACK SEGMENT NOME_DO_SEGMENTO 
STORAGE (MAXEXTENTS NOVO_VALOR_DO_SEGMENTO);

I think that's it aí

[] 's: Wink :