My Oracle Support Banner

KUP-600[Kudmcxgg:Grfunc] Seen On Dml Involving External Tables (Doc ID 741083.1)

Last updated on APRIL 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.


The following symptoms are attributed to this issue :-

a) The DB version is >=V11106 on any supported platform
b) Alert log will show errors similar to :-

Errors in file <FILESYSTEM_PATH><full path and file Name>.trc
KUP-00600: internal error, arguments [kudmcxgg:grfunc] [] [] [] []
Incident details in: <FILESYSTEM_PATH><full path and file name>.trc

c) Within the trace file the 'Current SQL' will be shown :-

----- Current SQL Statement for this session (sql_id=2ft90rdbz3fuu) -----

If the use of an 'External Table' is seen in the SQL then this note covers a possible
root cause.  However it does not have to be present in the SQL itself, if not seen
here the 'Explain Plan' section of the trace should be reviewed to see if present there.

The trace file can be searched for the string 'EXTERNAL TABLE', if there is no
mention at all of this then this note is unlikely to provide a resolution.

d) Stack trace will be similar to :-

Function List (to Full stack) (to Summary stack)
kgesinv <- kgesin <- kudmcxgg <- PGOSF2_kudmxo <- kpxsOpen <-
PGOSF299_qxxqOpen <- spefcpfa <- spefmccallstd <- pextproc

'KUDMCXGG' must be present in the stack for this note to be considered  to provide
a possible resolution

e) Within the trace file we may see evidence of ORACLE_LOADER in use :-

SO: 0xb2b1d4b0, type: 70, owner: 0xc2ba99a0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0xc2631f58, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:7981, pg=0
LIBRARY OBJECT LOCK: 0xb2b1d4b0 handle=0xb2c379a0 mod=N
pnc=0xaa5c37d8 pns=(nil) cbb=1 rpr=1 exc=0 ilh=(nil) ctx=(nil)
use=0xc2ba99a0 ses=0xc2ba99a0 cnt=1 flg=PNC/[0002] spn=0x60b
LIBRARY HANDLE:0xb2c379a0 bid=120229 hid=1f7fd5a5 lmd=N pmd=S sta=VALD

If in doubt as to whether or not these symptoms are being met or how to resolve via
this note please raise a SR to ORACLE Support.


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.