For "ORA-04030: out of process memory" incident/trace files, we would like to propose to list
Plsql package (both spec and body) names, and amount of respective used memory by each Plsql package.
The selection criteria could be TOP-n Plsql packages (for example, n=10),
or the sum of used memory usage by the listed Plsql packages is greater than Percentage-x
(for example, x=90),
or any package which uses more than KB-m memory (for example, m=1024).
The same list of Plsql packages can be also applied for Event 10261.
(see ORA-00600 [723], [67108952], [pga heap] When Event 10261 Set To Limit The PGA Leak (Doc ID 1162423.1),
and Blog: Limit PGA Memory Usage)
The content of Plsql package usage can be similar to dbms_session.get_package_memory_utilization.
(see Blog:
dbms_session package_memory_utilization)
We often hit such ORA-04030 in big Oracle applications.
It would be a great new feature to facilitate Plsql applications and memory usage investigation.
