kksfbc child completion

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



--
http://www.freelists.org/webpage/oracle-l

Other related posts: