Re: dbms_lock.sleep coming from FM11g server?

not a user.

But why sleep 1 minute when Tom said over 10 min was a problem? Maybe they fixed it since then (?).

On Wed, Jan 27, 2016 at 9:27 AM, Patrice sur GMail <patrice.boivin_at_gmail.com
> wrote:

> This is a bit strange
>
> 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
>
> I searched through all the plsql code in the database and didn't find a
> sleep(60) anywhere.
>
> Not helpful. I'll track down the source.
>
> Is it possible FM11g tells sessions to sleep when idle or when the network
> is slow?
>
> I saw a whole discussion on AskTom where he mentioned that anything above
> 10 minutes isn't ideal because it can create problems, loop the sleep
> statements instead. This is set for an hour.
>
> -- Patrice
> My profiles: [image: Facebook]
> <http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
> LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
> Twitter] <http://www.twitter.com/PatriceBoivin>
>

-- 


-- Patrice
My profiles: [image: Facebook]
<http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
Twitter] <http://www.twitter.com/PatriceBoivin>

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