Re: how is multi user concurrent READ enabled with oracle

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Mar 2006 10:54:48 -0800
Message-ID: <1142967288.705980.250550@i39g2000cwa.googlegroups.com>

Jack, Oracle does not read lock (unless a select for update is issued) and writers do not block readers so even select for update does not stop other readers. How Oracle does this is detailed in the Concpets manual material I referenced. Look up Rollback Segments.

Some buffer pool handling details are provided in the Performance and Tuning manual.

Otherwise as everyone else so far has said you need to restate your question much more specifically.

HTH -- Mark D Powell -- Received on Tue Mar 21 2006 - 12:54:48 CST