11GR2: PL/SQL lock timer as top event
Hi All,
I need your help in top timed events from spreport. Here is a snapshot of top 5 timed events
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
PL/SQL lock timer 2,326 20,390 8766 55.3
CPU time 10,393 28.2
db file sequential read 11,233,712 2,505 0 6.8
direct path read 21,237,205 1,023 0 2.8
db file scattered read 12,716,541 643 0 1.7
-------------------------------------------------------------
How do I check , which pl sql is the cause of PL/SQL lock timer. This is consistent in all the spreports. We do not have license for AWR (diagnostic) and hence am using spreport for troubleshooting. Any inputs on how to reduce this wait event would be helpful