Re: How does schema name affect allocation of PGA memory in dedicated server?

It is real important to state the platform and version for these sorts of questions. Search the metalink bug database for pga_aggregate_target ora-4030 for some examples.

Yes, Oracle protects the memory, but that is not necessarily relevant to why one would get memory errors. Bugs and configuration issues can make a big difference. It may just be your package on top of these issues is showing the symptoms.

https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=293128.1 for one methodology.

jg

--
@home.com is bogus.
The big boys are moving in:
http://www.signonsandiego.com/uniontrib/20050722/news_1b22sdge.html