Access Violation Ora-07445: Exception Encountered: Core Dump [Kfgtablecb()+752] [Sigbus] (Doc ID 1295684.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Example errors include

ORA-07445 [kfgTableCb()+752] [SIGBUS] [ADDR:0x200000008] [PC:0x393xxx] [Non-existent physical address] []

Segment violation when querying x$kfdpartner.


Example Query

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
-
---- Current SQL Statement for this session (sql_id=d9vpnu42sa9q4) -----

/* OracleOEM */
select
g.name,
100*(max(p.pspace)-min(p.pspace))/max(p.pspace),
max(p.cnt)-min(p.cnt),
count(distinct p.fgrp)
from
v$asm_diskgroup_stat g ,
  (
  select
  x.grp grp,
  x.disk disk,
  sum(x.active) cnt,
  greatest(sum(x.total_mb/d.total_mb),0.0001) pspace,
  d.failgroup fgrp
  from
  v$asm_disk_stat d ,
 (
  select
  y.grp grp,
  y.disk disk,
  z.total_mb*y.active_kfdpartner total_mb,                   << --- X$KFDPARTNER
  y.active_kfdpartner active << X$KFDPARTNER
  from
  x$kfdpartner y,
  v$asm_disk_stat z
  where
  y.number_kfdpartner = z.disk_number and                << --- X$KFDPARTNER
  y.grp = z.group_number
  ) x
  where
  d.group_number = x.grp and
  d.disk_number = x.disk and
  d.group_number <> 0 and
  d.state = 'NORMAL' and
  d.mount_status = 'CACHED'
  group by
  x.grp, x.disk, d.failgroup
   ) p
  where
  g.group_number = p.grp
  group by
  g.name


Changes

None Known

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