Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how can i increase rollback segments simultaneously??

Re: how can i increase rollback segments simultaneously??

From: Stephen Harris <sweh_at_mpn.com>
Date: 29 Dec 1998 22:22:37 GMT
Message-ID: <76bknd$12b$1@nebula.mpn.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US