ORA-4030 after enabling Database Vault
(Doc ID 2758402.1)
Last updated on JUNE 10, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Issue: ORA-04030 or high PGA utilization appears for most of the processes after enabling database vault.
==>> Enabled Database Vault
==>> After enabling a realm related to packages the PGA utilization is growing under Call Heap and mostly towards perm.
realm_name => 'REALM_NAME',
object_owner => 'SCHEMA_NAME',
object_name => DBMS_MACUTL.G_ALL_OBJECT,
object_type => 'PACKAGE');
==>> When we bring out the packages from realm it works fine and have very less PGA utilization.
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