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

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

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    76
    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?
    J.T.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2001
    Posts
    29
    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
    oracledba@ix.netcom.com

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