Application waiting for a user lock.

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Mon, 16 Feb 2015 22:44:25 -0500
Message-ID: <54E2B919.3070400_at_yahoo.com>

The wait events look like this:
/Event Waits Time (s) (ms) Time

----------------------------------------- ------------ ----------- 
------ ------


*PL/SQL lock timer                                   60       3,601 

60012   52.0


*CPU time 3,233          46.7

db file sequential read 97,875          75      1    1.1
control file sequential read 13,019           5      0     .1
log file parallel write 1,344           4      3 /

Obviously, the application is using DBMS_LOCK. Is there anything that can be done to make it cheaper? Not only is the whole thing horribly slow, it also devours vast amounts of CPU. I cannot go into the source, it's

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 17 2015 - 04:44:25 CET