kksfbc child completion

From: David Kurtz <info_at_go-faster.co.uk>
Date: Sun, 11 Feb 2007 01:44:50 -0000
Message-ID: <CKEAJBMGFEOCDBFILPJDCEAMIKAA.info@go-faster.co.uk>

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

Received on Sat Feb 10 2007 - 19:44:50 CST