Go up

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, 213 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, 212 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