Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL table question...
If you want to free up the memorry or delete the contents take a look at the
.DELETE built-in for pl/sql tables. This lets you erase the entire contents
of the table or single rows.
Patrick Flahan
flahan_at_earthlink.net
luzny_at_dcit.cz wrote in message <35d97e19.26073139_at_news.cesnet.cz>...
>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 - 22:12:12 CDT