Re: cursor #0

From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
To: paul.baumgartel@xxxxxxxxx
Date: Wed, 31 Aug 2005 22:53:52 +0100

If its Oracle Forms then its likely a client-side PL/SQL cursor. I vaguely 
remember that there might be an event to dump these to the trace file, but I 
could be making this up. 

Niall

On 8/31/05, Paul Baumgartel <paul.baumgartel@xxxxxxxxx> wrote:
> 
> I have a number of waits on cursor #0 in a trace file:
> 
> PARSING IN CURSOR #13 len=51 dep=0 uid=12492 oct=47 lid=12628 
> tim=6250407917 hv=3236665219 ad='bb5d4c70'
> begin TSC_ADMIN.SET_VALIDKEY_CONTEXT(:V00001); end;
> END OF STMT
> PARSE #13:c=0,e=183,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=6250407907
> WAIT #13: nam='SQL*Net message to client' ela= 6 p1=1413697536 p2=1 p3=0
> WAIT #13: nam='SQL*Net message from client' ela= 5544 p1=1413697536 p2=1 
> p3=0
> WAIT #13: nam='SQL*Net message to client' ela= 6 p1=1413697536 p2=1 p3=0
> WAIT #13: nam='SQL*Net message from client' ela= 345 p1=1413697536 p2=1 
> p3=0
> XCTEND rlbk=0, rd_only=1
> EXEC #13:c=0,e=14788,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=6250460315
> WAIT #13: nam='SQL*Net message to client' ela= 7 p1=1413697536 p2=1 p3=0
> WAIT #13: nam='SQL*Net message from client' ela= 1441 p1=1413697536 p2=1 
> p3=0
> WAIT #0: nam='SQL*Net message to client' ela= 6 p1=1413697536 p2=1 p3=0
> WAIT #0: nam='SQL*Net message from client' ela= 860 p1=1413697536 p2=1 
> p3=0
> 
> There are no PARSING IN CURSOR #0 lines in the file...so what's cursor #0?
> 
> 
> -- 
> Paul Baumgartel
> paul.baumgartel@xxxxxxxxxxxx
> 
> 


-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

References:

cursor #0
From: Paul Baumgartel

Re: cursor #0

Other related posts: