Re: how can i increase rollback segments simultaneously??

ashesh48_at_my-dejanews.com >>
Hi all, I am running v7.3.3 on NT 3.51 and i when i was refreshing the database i ran into the problem with rollback segments. i have 17 segments and of then 10 is online and when i was loading one segments has reached to 100mb and another has reached to 25 mb!!! which has used my 90% of total table_space for the rollabck segment. Is there any way that i can increase the size of all segments simultaneously OR can i move to another segment insteaad of only increasing the single segment. and how can i refresh the high water mark?? <<<<

1. You can not make them all grow at once, but you can resize them by dropping and re-createing them
2. You can free unneeded extents from your segments manually by using 'alter rollback segment roll_name shrink' command with ver 7.3+
3. Set the optimal parameter on the segments to have allocated, but unused, space automatically freed during normal useage
4. If you are doing an import or other special job, and are the only job on the system, you can take all rollback segments offline except for a special, large segment that you can create to handle special jobs like 'refreshes'
5. You may need more rollback tablespace space, anyway, so you can add another data file to allow rbs segment expansion

I hope these ideas and features help.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Tue Dec 29 1998 - 16:09:33 CST