Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: latch contention

Re: latch contention

From: Alexey Ogol <lesha_at_crgu.com>
Date: Wed, 27 Jun 2001 12:06:33 +0300
Message-ID: <9hc7l7$2l7h$1@pandora.alkar.net>

> Which version of Oracle ?

 8.1.7
>
> How much contention ? Check v$system_event
> for the event 'latch free' to see how much time has
> been lost to latch contention since the database
> started up (assuming timed_statistics=true).
select total_timeouts, time_waited from v$system_event where event='latch free'
Output:
760523 | 8836738

>
> Also, show us the v$latch row for that latch.
select name, gets, misses, sleeps, waits_holding_latch from v$latch where latch#=66
Returns:
cache buffers chains | 18983360432 | 153228 | 753151 | 1091 Received on Wed Jun 27 2001 - 04:06:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US