Check the client app. I have seen programmers toss in a 1 minute wait on
retries when they meant 1 second (when they try to manage wait retries from the
client).
That can make the entire problem APPEAR to be a database problem to a casual
observer.
… and I never proved one suspicious case was intentional at a place where the
folks who had irrational hatred of databases were trying to get rid of sql.
… but I couldn’t rule it out either and some folks were oddly upset that the
problem was removed.
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Patrice sur GMail
Sent: Thursday, January 28, 2016 10:19 AM
To: Jared Still
Cc: ORACLE-L
Subject: Re: dbms_lock.sleep coming from FM11g server?
it's a concern when you don't know where that wait is coming from and users are
complaining that "the app is slow"
On Wed, Jan 27, 2016 at 10:59 AM, Jared Still <jkstill@xxxxxxxxx> wrote:
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
Can you please explain why a wait that does nothing is a concern?
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
--
-- Patrice
My profiles:
<http://www.facebook.com/home.php?#!/profile.php?id=100000206805521> Facebook
<http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9> LinkedIn
<http://www.twitter.com/PatriceBoivin> Twitter
