Re: shrinking rbs?

From: <johnt_at_tman.dnsalias.com>
Date: Fri, 01 Jun 2001 19:26:08 GMT
Message-ID: <k%RR6.771$ld7.832182@typhoon.snet.net>

Doug O'Leary <dkoleary_at_ro05-24-29-232-217.ce.mediaone.net> wrote: > 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

But if there is no 'task' using the rbs, wouldn't a read-consistent view already be in the table itself? Therefore, by shrinking a RBS I can't see how you can cause a problem with any query. Received on Fri Jun 01 2001 - 14:26:08 CDT