Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Want to decrease size for ROLLBACK Segments

513596Dec 10 2008 — edited Dec 11 2008

my database is oracle8i. Previous DBA increased rollback size to 18GB. i need space on my unix box.
i want to reduce size of rollback segment and utilized this space for other purpose.

This is my stats

Tablespace Name FILE_NAME SIZE IN MB

ROLLBACK /u01/rbsdata/rbs01.dbf 5000
ROLLBACK /u01/rbsdata/rbs02.dbf 5000
ROLLBACK /u01/rbsdata/rbs03.dbf 6000

There are 12 rollback segments allocated to him

SEGMENT_NAME FILE_NAME SIZE
rbs0 /u01/rbsdata/rbs01.dbf 5000
.
.
rbs12 /u01/rbsdata/rbs01.dbf 5000

Now Could any one suggest to reduxe size with best performing and not affected my production database.

Thanks

Chetan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2009

Added on Dec 10 2008

#general-database-discussions

7 comments

761 views