Home » RDBMS Server » Server Administration » rollback segments
rollback segments [message #62595] Mon, 02 August 2004 04:23 Go to next message
p anil
Messages: 4
Registered: August 2004
Junior Member
what actually happens when we

shrink an rollback segment?

is it equal to coalescing an tablespace.

Report message to a moderator

Re: rollback segments [message #62596 is a reply to message #62595] Mon, 02 August 2004 05:28 Go to previous messageGo to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
NO

RBS grows as needed, when you shrink, you are making it smaller (may be to its original size).

Report message to a moderator

Re: rollback segments [message #62607 is a reply to message #62595] Mon, 02 August 2004 22:26 Go to previous message
Thomas
Messages: 67
Registered: September 1999
Member
Not really. When you coalesce tablespace - the data still stays intact. You simple remove the blank space between the blocks, if you can.

The rollback segments hold block temporarily, while the transaction commits. When you shirink the RBS - you actually reuses all the segments currently not in use. The RBS segments are re-used over and over - the data is not permanent.

Hope that helps,

clio_usa - OCP DBA 8/8i/9i

Oracle DBA Resources
Oracle DBA Forums
USENET Oracle newsgroups

Report message to a moderator

Previous Topic: How to determine size of database
Next Topic: analyze &DBMS_STAT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 23 15:22:55 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.