| rollback segment doubt [message #64338] |
Thu, 13 January 2005 11:23  |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
I have 5 rollback segments rbs1…4, which belongs to tablespace tbs_rbs_1 which is DICTIONARY MANAGED. And one Big Rollback segment rbs_5 with belongs to tbs_rbs_2 which is also a DICTIONARY MANAGED tablespace.
I have run the some transaction which made the rbs01(rollback segment) to grow up to 1.5 GB. So now the tablespace tbs_rbs_1 is having 1.5GB.
I wanted to decrease the size of that tablespace back to 320 MB.
So what I did is:
Alter rollback segment rbs_1 shrink to 100K;
Even after resizing the rollback the tablespace is showing 1.5GB, so what should I do now? Should I issue the following command?
Alter database datafile ‘/……/tbs_rbs_1.dbf’ resize 320M;
Just want to make sure before I do anything wrong(Remember Tablespace for the Rollback is Disctionary managed not locally)
Thanks
sidd
|
|
|
|
| Re: rollback segment doubt [message #64347 is a reply to message #64338] |
Sat, 15 January 2005 09:41  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
You need to wait or kill the transactions using RBS_1.
It may also be a good idea to take it offline.
Remember, the success and amount of shrinkage depend
on the available free space in the rollback segment
and how active transactions are holding space in the
rollback segment.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
