Hello,
My developers are reporting, that “PLSQL Developer” (5.1.6) hangs then
debugging some activities.
I have switched on SQL Trace and found session wait on PBSDE.DEBUG_LOOP
call:
PARSING IN CURSOR #13 len=63 dep=1 uid=136 oct=47 lid=136
tim=1062087007884396 hv=4098155192 ad='5a6ff310'
declare ret binary_integer; begin ret := PBSDE.DEBUG_LOOP; end;
END OF STMT
PARSE #13:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1062087007884391
BINDS #13:
WAIT #13: nam='pipe get' ela= 892 p1=1517429476 p2=4096 p3=3600
WAIT #13: nam='pipe get' ela= 1990255 p1=1517429476 p2=4096 p3=3600
WAIT #13: nam='pipe get' ela= 2997978 p1=1517429476 p2=4096 p3=3600
WAIT #13: nam='pipe get' ela= 3994075 p1=1517429476 p2=4096 p3=3600
============================================================
~250 sec.
May be some in this list already knowing solution (reason).
Tanks in advance,
Jurijs
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Jun 21 2004 - 03:07:56 CDT
