Re: Memory Problems with PL/SQL Packages

>Subject: Memory Problems with PL/SQL Packages
>From: manitu_at_tick.cslab.tuwien.ac.at (Christian Greissing)
>Date: 1/20/98 10:59AM GMT
>Message-id: <6a202i$bkj_at_news.tuwien.ac.at>
>
>Hello
>
>I have same major problems with a self written PL/SQL Package
>this packages has about 3000 lines of code, doing just some computation
>and selections from different tables, some updates and inserts.
>The package contains about 150 functions or procedures.
>
>So after some time of use of this package i get the failure
>that no more shared memory is available (sorry haven't the right Error #
>by hand).
>So my thought is that, this package alloces memory everytime a function of it
>is called, but after finishing it doesn't release the memory.
>
>The workaround I have at the moment is, just dropping and creating the
>package again, that works, but isn't good, cause the user, can't do that.
>
>Has anyone the same problem? and is there any solution for it ?
>
>Thanx
>Christian Greissing.
>
>Has anyone the same problem? and is there any solution for it ?
>
>Thanx
>Christian Greissing
>
>
>--
> ___
> / ___ Christian Greissing manitu_at_cslab.tuwien.ac.at
> / / Keplerplatz 9/7 ( also NeXT-Mail )
> /__/ _ 1100 VIENNA Technical University Vienna
> /__/ AUSTRIA http://www.cslab.tuwien.ac.at/~manitu
>
>
>
>
>
>
>
Try pinning the package into the shared pool after database startup. There is a package DBMS_SHARED_POOL which allows you to do this, but I can't remember the specifics. If you contact ORACLE support they can fax you a document which details how to use pinning.

Hope this helps
  Rob Received on Wed Jan 21 1998 - 00:00:00 CET