Re: Is using OPTIMAL in RBS ORA-1555 prone?

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 20 Feb 2002 10:18:42 GMT
Message-ID: <3c737793.3896674@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 - 04:18:42 CST