Ref:(Undo rollback segments)

[atkinson]

Hi ,

When undo_management is set to 'auto' , undo_tablesapce='tblsp_01' , database is started , how many number of undo rollback segments are created?.

I red in the metalink , value of processes parameter number of undo rollback segments will be created . We have our processes parameter value set to 5000 , does it mean 5000 number of undo rollback segments will be created or based on the requirement the undo rollback segments are created and maximum value is 5000.

Please advice here ,

Thanks in advance.

[tamilselvan]

During the startup, 10 RBS are created.

Then, based on the number of active transactions, oracle automatically creats additional RBS and drop them retaining the frist 10.

Processes parameter does not play any role in the beginning. My DB has a value of 3500 for processes parameter, and so far I have not seen more than 20 RBS.

Tamil