rollback consumption
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: rollback consumption

  1. #1
    Join Date
    May 2003
    Posts
    5

    Question rollback consumption

    Hi,

    I have a 100Mb table with 5 indexes totaling 50Mb.
    If a user decides to make a huge delete (truncate is not an option in that case), will the indexes consume Rollback space as well ?

    If it is the case, do you have any reference I could base on to have an idea of how mutch space the indexes will take in the rollbacks ?

    thank you in advance,

    Patrick Hamou
    www.renaps.com
    Patrick Hamou
    Principal Consultant
    Renaps Technology Canada inc.
    http://www.renaps.com

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Why can't you do some simple test?

    Test -1 in a single user mode.
    Assign a rollback segment.
    With index delete some 100 rows.
    From the v$rollstat you can figure out how much data has been written

    Test -2 in a single user mode.
    Drop indexes
    Assign a new rollback segment.
    Delete some 100 rows
    From the v$rollstat you can figure out how much data has been written.

    The diff between Test-1 and Test-2 is your answer.

    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