enqueue statspack top5 timed events

From: David <ning_1898_at_yahoo.com>
Date: 22 Jan 2004 13:01:29 -0800
Message-ID: <37032184.0401221301.c4f8c13@posting.google.com>

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
Received on Thu Jan 22 2004 - 15:01:29 CST