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

Last updated on JULY 20, 2024

Applies to:

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

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