Database Hung With "kksfbc child completion" and "Cursor: Pin X" Waits (Doc ID 430555.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.

If the issue has occurred in past, then you can confirm by querying DBA_HIST_* tables like following

select e.snap_id, e.total_waits, e.time_waited_micro, s.begin_interval_time
from dba_hist_system_event e, dba_hist_snapshot s
where e.event_name = 'kksfbc child completion'
and s.snap_id = e.snap_id
and e.snap_id between 18980 and 18996
order by snap_id desc;

SNAP_ID TOTAL_WAITS TIME_WAITED_MICRO BEGIN_INTERVAL_TIME
---------- ----------- ----------------- -------------------------------------------------
18996 4587225 225555709866 27.04.07 17:45:16,540
18995 4587194 225554263113 27.04.07 17:30:42,718
18994 4587142 225551789210 27.04.07 17:16:01,808
18993 4587131 225551232538 27.04.07 17:00:34,607
18992 4446095 218603650680 27.04.07 16:45:11,598

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms