Re: Would READ Be Block

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Fri, 05 Aug 2005 13:46:25 +0200
Message-ID: <42f352aa$0$11759$9b4e6d93@newsread4.arcor-online.net>

Ken schrieb:
> In Oracle, writer never blocks reader. That's fine. But, does that
> means I can always assume a read will successful - absolutely no other
> factors could really block a read?
>

There are some few situation where you can be prevented to access some blocks ,in first place ( that's obvious of course) when block itself is corrupt, after direct load in the same session before you commit/rollback , by broken distributed transaction... It has mostly nothing to do with Oracle's concurrency implementation - here you are not blocking the readers...

Best regards

Maxim Received on Fri Aug 05 2005 - 06:46:25 CDT