rollback segment & slots-drop/recreate or alter Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: rollback segment & slots-drop/recreate or alter

  1. #1
    Join Date
    Oct 2000
    Could some experts in this forum explain what is the concept of slot in relationship to the rollback segment. I was told by a senior DBA and when in doubt, drop and recreate the rollback segments in stead of alter the storage due to the issue with slot allocation. Could someone comment on /explain this?

  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada

    Life is a journey, not a destination!

  3. #3
    Join Date
    Jun 2001
    For each rollback segment, there is a transaction table. This contains pointers to the extent containing information for a particular transaction. These pointers (and other info) is contained in a structure referred to as a slot. The number of slots is determined by db_block_size.
    Altering the storage parameters for a rollback segment will not be impacted by nor will it impact the slots in the transaction table. Dropping and recreating a rollback segment will create a new segment with the same number of slots. The main difference is that the altered rollback segment will still contain transaction data that may be needed for read consistency.
    Daniel W. Fink

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