Re: enqueue statspack top5 timed events

ning_1898_at_yahoo.com (David) wrote in message news:<37032184.0401221301.c4f8c13_at_posting.google.com>...
> Hi
>
> Below is a copy of the top 5 timed events from my statspack. Don't
> know how to detect what enqueue waited for what. Don't understand
> Oracle Documentation's description on how to check V$SESSION_WAIT and
> V$LOCK.
>
> Can anyone help me on how to detect the enqueue wait event? Oracle
> just said it means waiting to get access database resources but not
> specifically what resources. Is that memory, freelist or mintran?
>
> Any help is appreciated.
>
> Thanks
>
> David
>
> Top 5 Timed Events
> ~~~~~~~~~~~~~~~~~~
> % Total
> Event Waits Time (s)
> Ela Time
> -------------------------------------------- ------------ -----------
> --------
> enqueue 28 83
> 82.64
> CPU time 15
> 15.11
> db file sequential read 319 2
> 1.61
> control file parallel write 146 0
> .31
> db file parallel write 13 0
> .20

enqueue = locks.
The sid in v$lock joins back to the sid in v$session. The taddr in v$session joins to v$transaction sql_address and sql_hash_value join to address and hash_value in v$sql The various lockmodes are documented.

Sybrand Bakker
Senior Oracle DBA

Senior Oracle DBA Received on Fri Jan 23 2004 - 13:14:33 CET