Re: PL/SQL table question...

I have read, that to monitor user memory is needed to look into the v$sesstat view for statistic "session uga memory" and "session pga memory". To free unused memory call the procedure free_unused_memory located in the package dbms_session, but remember, that definition of "unused memory" is not clean enough, so you have to experiment.

In case of dedicated server, the unused memory is returned to the OS, in case of MTS it is returned to the shared pool.

Jano Luzny

On Tue, 18 Aug 1998 12:54:29 -0700, Jimmy <96635500G_at_hkpa01.polyu.edu.hk> wrote:

>Hello all,
>
> I create a PL/SQL table in a package.
> I want to know where PL/SQL table is storing in Oracle? In PGA or SGA?
>Is the memory allocated to PL/SQL table is temporary? (i.e. during the
>execution of the package) Or permanent? If permanent, how can I release
>the memory back to Oracle database?
>
>Thanks,
>Jimmy
Received on Tue Aug 18 1998 - 08:25:56 CDT