wraps
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: wraps

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    anybody can tell me when does wrap means and when did it happen (v$rollstat) ?


  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    See wraps happen when Rollback segment writes from one extent to the next available extent.Here the word (AVAILABLE EXTENT) is important as rollback segment will not allocate a new extent but it will write to the next existing extent.
    When the next existing extent is being used by another transaction ,then RBS will allocate a new extent which is called a EXTEND.
    Wrapping is more beneficial and advantageous since Oracle doesnot have to allocate a new extent.RBS will use the next extent if it is free.

    e.g Ur Rollback segment is of following parameters
    initial 1M
    next 1M
    minextents 5
    maxextents 10

    Transacation A is started and will use the extent no 1.The transaction is still running so it will go to the next extent i.e No2 ,if it is free.If it is free then it is called a wrap.
    If it is not free and is used by some other transaction then RBS will allocate another extent and it calls it as extend.

    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards.,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com


  3. #3
    Join Date
    Jun 2001
    Posts
    193
    does that means if we notify lot of wraps, we don't really care.
    but if we notice some extends, we need to figure out if rollback segment is too small.

    am i right?
    guru is on the way!!!!

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