Ref:(Undo rollback segments)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ref:(Undo rollback segments)

Hybrid View

  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    45

    Ref:(Undo rollback segments)

    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.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width