My Oracle Support Banner

ORA-4030 User Defined Function Used Far More "kgmtimob: self" Memory On 19c Than On 11.2 (Doc ID 2913782.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

On : 19.10.0.0.0 version, RDBMS

A single SQL contains a user defined function used more than 30GB PGA and eventually hit ORA-4030 error.

ORA-4030 trace shows that most of memory used by "kgmtimob: self "

The same SQL only takes less than 200MB on 11.2.0.4, however it run very slower on 11.2.0.4.

Cause

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
Symptoms
Cause
Solution
References


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