ROLLBACK SEGMENTS -SHRINKS [message #369293] |
Sat, 05 August 2000 16:52 |
ANUP KUMAR v
Messages: 1 Registered: August 2000
|
Junior Member |
|
|
HI,
Anybody can advice me on this.
Whether we can shrink rollback segments explicitly. How to find a particular rollback segment is reaching is max. extent.
kindly advice and help me on this.
Thanks in advance.
Bye Anup
|
|
|
Re: ROLLBACK SEGMENTS -SHRINKS [message #369316 is a reply to message #369293] |
Mon, 14 August 2000 08:57 |
Alpesh Patel
Messages: 4 Registered: August 2000
|
Junior Member |
|
|
Hi,
We can shrink the rollback segment manually. u can use
ALTER ROLLBACK SEGMENT "rbsname" SHRINK TO size ;
or you can keep optimal size to shrink automatically. you can findout current info abt your rollback segments in v$rollstat view.
Regards,
Alpesh
|
|
|