Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> rollback segment with no optimal question
Hi,
I have rollback segment with no optimal set. the rollback tablespace
has a lot of space. It is a OLTP system with many but small
transactions. So I expect no shrinking. However for one report that
runs around 20 minutes we are getting ora-01555 snapshot too old. the
intial and next are set to 1M which I think is OK for OLTP transaction
size. There are many rollback segments = 40. So how do I go about
increasing the size or the number and on what basis? Thank you
Received on Sat Nov 22 2003 - 12:11:55 CST