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: Free space in rollback segments?

Re: Free space in rollback segments?

From: Jeff Grimonster <jgrimons_at_pt.lu>
Date: 1997/02/22
Message-ID: <01bc2096$ce752c20$b2c09ac2@jeff>#1/1 







Hi,



If you have large transactions running, it's better not use the optimal
parameter, or least high enough (20 times initial). Instead, you can
manually resize with the command ALTER ROLLBACK SHRINK.



Jeff (jgrimons_at_pt.lu)
Received on Sat Feb 22 1997 - 00:00:00 CST












Original text of this message













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