I was expecting something more complex. This will not prevent ora-1555 at
those times. I have no control over when users submit report jobs and this
is a 24 hours shop.
I gather there is no 100% safe mechanism other than having lots and lots of
rollback segments and make them real big. And that will only be 99.9% safe.
--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address
"Nuno Souto" <nsouto_at_optushome.com.au.nospam> a écrit dans le message de
news: 3c737793.3896674_at_news-vip.optusnet.com.au...
> Syltrem doodled thusly:
>
> >
> >I'll have to manually shrink my rollback segments, won't I?
> >I just can't let them grow forever...
> >
> >What is your approach with this?
> >
>
> PMFJI.
>
>
> Schedule a little job with a single script at about 06:00, another say
> at 12:30 and another at 18:30 to do this. Simple, takes only a few
> seconds and buys you peace.
>
> Of course, make sure none of these times are high database activity
> times in your particular case!
>
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Wed Feb 20 2002 - 08:40:59 CST
