Re: V$system_event

2004-01-21 Thread Mladen Gogala
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

RE: V$system_event

2004-01-21 Thread Cary Millsap
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

Re: V$system_event

2004-01-21 Thread Mladen Gogala
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