Re: sqlplus variables

From: geos <geos_at_nowhere.invalid>
Date: Wed, 05 Oct 2011 20:43:33 +0200
Message-ID: <j6i8gj$cns$3_at_news.task.gda.pl>



Mark D Powell wrote:
> Goes, while like David I know of no way to free memory held by SQLPlus
> variables other than closing the session I do know a way to free the
> PGA memory held by pl/sql collections (pl/sql arrays and type tables)
> via dbms_session.free_unused_user_memory. This might be of interest
> to you.

Mark, many thanks, I wasn't aware of this possibility.

cheers,
geos Received on Wed Oct 05 2011 - 13:43:33 CDT

Original text of this message