No question at this time
DBA Top 10
1 M. Cadot 6300
2 B. Vroman 2700
3 P. Tsongayinwe 1500
4 P. Wisse 1300
4 J. Péran 1300
6 A. Kavsek 900
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48709
Total active users1322
Act. users last 24h2
Act. users last hour0
Registered user hits last week33
Registered user hits last month217
Go up

PL/SQL lock timer event not result of dbms_lock.sleep
Next thread: upgrade to 19c
Prev thread: Drop Sample Schemas from Oracle Database

Message Score Author Date
I have a strange thing going on. There is a proce...... Kirt Thomas Dec 01, 2021, 16:16
Hi Kirk, May be you have triggers on tables use...... Joël Péran Dec 03, 2021, 10:55

Follow up by mail Click here


Subject: PL/SQL lock timer event not result of dbms_lock.sleep
Author: Kirt Thomas, United States
Date: Dec 01, 2021, 16:16, 362 days ago
Os info: AIX 6.2
Oracle info: 11.2.0.3
Message: I have a strange thing going on. There is a procedure that is getting run, that goes into a pl/sql lock timer event. I know that most of the time this is because the dev has issued a dbms_lock.sleep().

However, in this case nothing in the code has issued a sleep command. The procedure has no child processes, and the sql area txt only shows the call to the procedure.

p1, is zero, so the dbms_lock.sleep(0). Watching active processes, I can see the sequence number increase and logical reads increase.

I seem to remember a system issued sleep, but can't remember why, or if it's real.

Has anyone else seen this behaviour? Or have any insight. Thanks.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: PL/SQL lock timer event not result of dbms_lock.sleep
Author: Joël Péran, France
Date: Dec 03, 2021, 10:55, 360 days ago
Message: Hi Kirk,

May be you have triggers on tables used in the PL/SQL ? Well, I don't really see what your problem is ...
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here