Double them, then see if you still have the problem.
| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Benbart
[mailto:oracledba-ezmlmshield-x30288047.[Email address protected]
Sent: Wednesday, April 27, 2005 5:57 PM
To: LazyDBA Discussion
Subject: Sizing the rollback segments
<P>Hi all,</P>
<P>I am getting ORA-01555 errors on my rollback segments. I know the usual
practice is to resize the rollback segments which in most cases is to
increase the size of your rollback segments. Am not using UNDO tablespaces
and there is no plan to start using one, don't ask why.<BR><BR>While I can
increase the size of the rollback segment, I want to know if anyone have any
SQL or scripts that I can use to make a more intelligent or smart assessment
of how large should I resize my rollback segment to?</P>
<P>Any advise will be greatly appreciated, thanks ...</P>
<P> </P>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page