cursor #0

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Wed, 31 Aug 2005 17:40:18 -0400
Message-ID: <f8c477105083114402d6c2248@mail.gmail.com>

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_at_aya.yale.edu

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 31 2005 - 16:42:20 CDT