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: Alert to trap/anticipate ORA-01555 before its occurence

Re: Alert to trap/anticipate ORA-01555 before its occurence

From: Joel Garry <joel-garry_at_home.com>
Date: 15 Dec 2004 14:24:50 -0800
Message-ID: <1103149490.160642.258160@z14g2000cwz.googlegroups.com> 





No one has mentioned the impact of optimal, so I'll just say turn it
off if you are using it, let the rollbacks grow as much as they want,
watch them to decide on a good size to shrink them to manually.
Assuming you are not using undo, of course.
jg

--
@home.com is bogus.
http://bootchart.sourceforge.net/


Received on Wed Dec 15 2004 - 16:24:50 CST












Original text of this message













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