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.
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