Language:EN
Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
the header the rollback segment transaction table

The header the rollback segment transaction table

426 Part III ✦ Administering Storage for Oracle Objects

4. Why do you need multiple rollback segments?

5. What is the difference between an online and offline rollback segment? 6. What is the significance of the OPTIMAL parameter?

Chapter 10 ✦ Managing Rollback Segments

R they don’t, they wait. Waits for rollback segments can cause serious performance ollback segments are required for every transaction in the database. When users start transactions, they must be able to acquire a rollback segment; if

Once you have a sound understanding of their use, managing rollback segments is really not that difficult. You must make sure that there are enough of them to prevent contention and make sure they are appropriately sized to avoid dynamic extension or, what is worse, running out of space. If a transaction runs out of rollback space, it rolls back. If it took two hours to run out of space, it will probably take another two hours to rollback. Now four hours have elapsed and the
transaction is right back where it started.

The Use of Rollback Segments

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File
img

Uploaded by : Hannah Sawyer

PageId: ELI9F0CB71