rollback segment with optimal size

From: Brian Yan <by999_at_hotmail.com>
Date: Thu, 12 Aug 1999 22:14:11 GMT
Message-ID: <7ovgvc$qcc$1@nnrp1.deja.com>

Hi there,

I have a question about rollback segment with optimal size. For example, a rb has a optimal size equal to 5 extents. A big transaction has forced rb to extend to 20 extents. When will this rb be shrunk to 5 extents?

In Kevin Loney's DBA's Handbook 7.3 P219, it says The next transaction that wrapped into a second extent would force the database to reclaim any space that forced it to exceed its optimal setting.

What if the next transaction needs less than 20 extent and it starts from extent#4 and finishes at extent #10. In this case it was not wrapped, will this rb be shrunk to 5 extents?

Any help would be very much appreciated!

Thank you and you have a nice day!

Brian

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 12 1999 - 17:14:11 CDT