-
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
-
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