My Oracle Support Banner

ORA-4030 after enabling Database Vault (Doc ID 2758402.1)

Last updated on MARCH 08, 2021

Applies to:

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

Symptoms


Issue: ORA-04030 or high PGA utilization appears for most of the processes after enabling database vault.

 

 

Changes

 ==>> Enabled Database Vault

 

==>> After enabling a realm related to packages the PGA utilization is growing under Call Heap and mostly towards perm.
 
BEGIN
DBMS_MACADM.DELETE_OBJECT_FROM_REALM(
realm_name => 'REALM_NAME',
object_owner => 'SCHEMA_NAME',
object_name => DBMS_MACUTL.G_ALL_OBJECT,
object_type => 'PACKAGE');
END;

 

==>> When we bring out the packages from realm it works fine and have very less PGA utilization.

 

 

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