Re: how is multi user concurrent READ enabled with oracle

Jack wrote:
> Hi I wanted to ask what product features and optimizations have been
> built in Oracle to accomodate multi-user concurrent READ against the
> database (setting aside the row level locking and dirty READ avoidance)
>
>
> Thank you,
>
> Jack

The one thing that has become abundantly clear from the responses you have received and your reply is that no one has a clear understanding of what you asked. A category in which I put myself too.

How about some clarification?

It sounds like you are asking about MVCC and if that is the case I'd refer you to Tom Kyte's book "Expert one-on-one Oracle."

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)