Statspack Report

From: Oradba Linux <oradba_linux_at_attbi.com>
Date: Wed, 08 Jan 2003 01:23:37 GMT
Message-ID: <pan.2003.01.08.01.25.06.767813@attbi.com>

Hi
On my Statspack report ( oracle 8.1.7.2 on hp-ux 11.0) , Top 5 wait event section , report shows enqueue as most waited event . How do i proceed from here to find out which enqueue it waited for ?

 Event                                               Waits  Time (cs)   Wt Time
-------------------------------------------- ------------ ------------ -------
enqueue                                             1,409      392,916  

87.81

Also from the details section of the report .

Event                               Waits   Timeouts  Time (cs)    (ms)   /txn
---------------------------- ------------ ---------- ----------- ------ ------
enqueue                             1,409      1,204     392,916   2789    0.7

this is from the instance activity stats

enqueue conversions                              0          0.0          0.0
enqueue releases                            42,164          2.0         20.4
enqueue requests                            42,162          2.0         20.4
enqueue timeouts                                 0          0.0          0.0
enqueue waits                                  115          0.0          0.1

Any pointers to documentation as to how to investigate from here ?

Thanks Received on Tue Jan 07 2003 - 19:23:37 CST