Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Would READ Be Block

Re: Would READ Be Block

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 09 Aug 2005 17:33:57 -0700
Message-ID: <1123626794.762032@yasure>


joel-garry_at_home.com wrote:
> 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

I'm confused by your response. I can't see any possible way an ORA-01555 relates to the question nor what you refer to when you stay "wait a long time" nor do I see how a client time-out setting relates. Can you clarify your thinking? Thanks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Aug 09 2005 - 19:33:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US