"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1123626794.762032_at_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)
There is a myth promulgated by MS that Oracle has to do a lot of work to be
read consistent. It is the usual FUD from another vendor when they don't
have a feature their competitor does.
Jim
Received on Tue Aug 09 2005 - 19:54:15 CDT
