On Wed, Jan 27, 2016 at 5:27 AM, Patrice sur GMail <patrice.boivin@xxxxxxxxx
wrote:
We have a slow WAN to begin with, then I noticed waits related to this
plsql package in session waits in the database, turns out it is coming from
a thin jdbc client.
SID SERIAL# INST_ID OSUSER EVENT
P1 P2 P3 SQL_TEXT PROGRAM
---------- ---------- ---------- ------------ --------------------
---------- ---------- ---------- ----------------------------------------
------------------------
166 1 1 oracle PL/SQL lock timer
0 0 0 BEGIN dbms_lock.sleep(60); END; JDBC
Thin Client