kksfbc child completion
- From: "David Kurtz" <info@xxxxxxxxxxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 11 Feb 2007 01:44:50 -0000
Can anyone tell me what is the event 'kksfbc child completion'?
This is an extract from the trace file. It doesn't happen very often, nor
is it consuming a lot of time, but it does tend to occur on frequently
parsed statements. It always occurs after the stat lines, so I infer it is
happening when the cursor is closed.
=====================
PARSING IN CURSOR #1 len=58 dep=0 uid=34 oct=3 lid=34 tim=19072432949703
hv=1732080893 ad='e5f643e0'
SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
END OF STMT
PARSE #1:c=0,e=118,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=19072432947748
EXEC #1:c=0,e=97,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=19072432949922
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=45,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=4,tim=19072432950052
WAIT #1: nam='SQL*Net message from client' ela= 618 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=124516 op='TABLE ACCESS BY INDEX ROWID
PSVERSION '
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=124517 op='INDEX UNIQUE SCAN PS_PSVERSION
'
WAIT #1: nam='kksfbc child completion' ela= 1 p1=0 p2=0 p3=0
WAIT #1: nam='kksfbc child completion' ela= 24265 p1=0 p2=0 p3=0
=====================
regards
_________________________
David Kurtz
--
//www.freelists.org/webpage/oracle-l
Other related posts:
