Re: PL/SQL procedures won't fit in memory

: I have run into the same problem. I have not confirmed this with anyone
: but I believe that the shared memory pool is getting fragmented. Under
: Oracle 7.1, PL/SQL must load into contiguous memory chunk. To fix, I
: increased my shared pool size. I understand 7.2 (or maybe its 7.3)
: overcomes this problem by allowing PL/SQL to load and run in
: non-contiguous memory.

The trick is to pin the procedures into memory using the 'dbmspool' packaged procedures.

The overview (stored in the package and the dbmspool.sql file) includes such things as:

• WARNING: This procedure may not be supported in the future when
• and if automatic mechanisms are implemented to make this
• unnecessary.

: > Have you ever received and worked around this problem. Please E-mail a
: > response. Many thanks in advance.

I'd rather encourage you to read the newsgroup :)

IAP Received on Sun Jul 21 1996 - 00:00:00 CEST