On 01/21/2004 02:29:26 PM, Cary Millsap wrote:
Jolene,
Mladen's answer is a good one. There is also an in-depth discussion
on
this subject on pp210-217 of the book "Optimizing Oracle
Performance."
I knew that you will immediately recognize "method C"!
--
Please see the official ORACLE-L FAQ: h
Jolene,
Mladen's answer is a good one. There is also an in-depth discussion on
this subject on pp210-217 of the book "Optimizing Oracle Performance."
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL
The result depends on the number of sessions. If you have
session A waiting for a 'enqueue lock' for 10 minutes and session
B waiting for the same lock as session A for another 10 minutes,
then the recorded time is 20 minutes, despite the fact that sessions
are waiting concurrently. If you have, sa