Re: shrinking rbs?

Thomas Kyte <tkyte_at_us.oracle.com> wrote:

> The problem is a query doesn't "USE" rbs. It might need the contents of
> rbs at some point to provide a read consistent view of the data -- but
> it is not using rbs. A "write" transaction will use RBS and if it was
> using it -- we would not shrink it.

That's the concept that I was missing - and explains the risk. Thanks alot! Now, I have to go back and reread the sections on optsize parameter to find out how that meshes in.

Thanks again, I appreciate the info!

Doug

-- 
------------------------
Douglas K. O'Leary
Senior System Administrator
dkoleary_at_mediaone.net