Home » RDBMS Server » Server Administration » ROLLBACK SEGMENTS -SHRINKS
ROLLBACK SEGMENTS -SHRINKS [message #369293] Sat, 05 August 2000 16:52 Go to next message
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 Go to previous message
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
Previous Topic: cannot increase db buffer cache hit ratio
Next Topic: dba-admin-password
Goto Forum:
  


Current Time: Thu Mar 28 12:58:28 CDT 2024