Re: Shrinking Rollback Segemnts in a Proc

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3f7e927f$0$30274$afc38c87_at_news.optusnet.com.au...

> house all normal transactional activity (and I think we agree on that). And
> then to have a script which blindly shrinks the segments back to that size
> at midnight, 2am or whatever time seems appropriate. And to have that
> script execute nightly.

An ideal fit for a dbms job entry? At least, that's what I used to do.

> the logfile output from your shrinking procedure to see whether there is a
> continuing problem. If there is, you can get involved manually to try and
> track it down.

Or just grin and ignore if it is caused by a 3rd party that you have absolutely no control of.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam