PL/SQL lock timer
I found in one of the
trace file as below PL/SQL lock timer is taking 644.58
seconds in the database.
Could you please look into this and let me know the reason for this?
Elapsed times include
waiting on following events:
Event waited on
Times Max. Wait Total Waited
---------------------------------------- Waited ----------
------------
PL/SQL lock
timer 132 4.90
644.58
SQL*Net
message to client 1 0.00 0.00
SQL*Net
message from client 1 0.04
0.04
********************************************************************************
Trace file
============
TKPROF: Release 10.2.0.4.0 - Production on Thu Jun 9 10:48:32 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Trace file: nbsstg04_ora_5115974_stat_RPM12_oracle.trc
Sort options: prsela exeela fchela
********************************************************************************
count = number of times OCI procedure was executed