Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: latch contention
> 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