Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how can i increase rollback segments simultaneously??
MarkP28665 (markp28665_at_aol.com) wrote:
: 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'
Or you can have a large rollback segment that is normally offline, and
then
alter rollback segment largeroll online;
set transaction use rollback segment largeroll;
---blah blah
commit;
alter rollback segment largeroll offline;
careful with thos though - if your database crashes while the largeroll is online you may not be able to perform instance recovery properly...
--
rgds
Stephen
Received on Tue Dec 29 1998 - 16:22:37 CST