Re: PL/SQL: -- pkg runtime Size Limitations?

Hi Raghav,

The doc states that you should call Oracle Support in case of ORA-7445. If you want to check the memory consumption of the server process that is calling this package, use some O/S utility to measure this (i.e. "top" on UNIX.)

Also, try analyzing the behaviour of the package with DBMS_PROFILER, a supplied package that comes with Oracle 8+.

You MAY have a memory leak or simply inefficient code that swells up in memory. I.e. if you, in your package, have some sub-procedures repeatingly passing parameters by value to each other, you may get bunches of local proc. variables allocated on the stack => big memory consumption. DBMS_PROFILER can help you on tracing this. The solution may then be to use pass-by-reference by means of the NOCOPY hint, which is only available from 8i and forward. (Don't ask me how people lived without the NOCOPY hint in PL/SQL in the days before 8i....and why some still avoid it in 8i+.........).

• Kenneth Koenraadt