Re: sqlplus variables
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Tue, 4 Oct 2011 06:13:02 -0700 (PDT)
Message-ID: <5e8f06a5-a14c-4d79-a1b7-e016c6602349_at_g29g2000yqh.googlegroups.com>
On Sep 30, 2:37 pm, geos <g..._at_nowhere.invalid> wrote:
> ddf wrote:
> >> is there a way to do the same, ie. free memory, for sqlplus variables
> >> declared with VAR(iable) keyword?
>
> > Not that I know of; why is it of concern?
>
> thanks David. it's just for learning/understanding purposes.
>
> cheers,
> geos
Date: Tue, 4 Oct 2011 06:13:02 -0700 (PDT)
Message-ID: <5e8f06a5-a14c-4d79-a1b7-e016c6602349_at_g29g2000yqh.googlegroups.com>
On Sep 30, 2:37 pm, geos <g..._at_nowhere.invalid> wrote:
> ddf wrote:
> >> is there a way to do the same, ie. free memory, for sqlplus variables
> >> declared with VAR(iable) keyword?
>
> > Not that I know of; why is it of concern?
>
> thanks David. it's just for learning/understanding purposes.
>
> cheers,
> geos
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.
HTH -- Mark D Powell -- Received on Tue Oct 04 2011 - 08:13:02 CDT