My Oracle Support Banner

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

Last updated on MAY 12, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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;

---------- ----------- ----------------- -------------------------------------------------
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



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.