Re: Would READ Be Block

In addition to what the others say, Oracle's read-consistency mechanism may mean it could take a while for Oracle to actually get all the stuff it needs together to present the data to you. So your read is not blocked, but you might have to _wait_ a long time. Perhaps longer than a client software timeout, for example.

See also ORA-1555 discussions.

A properly configured system shouldn't have such problems. But always is a long time.

jg

--
@home.com is bogus.
http://www.thenonist.com/downloads/thenonist_blog_depression.pdf