I can define user variable in sqlplus using DEFINE keyword. it gets lost
from memory with UNDEFINE keyword.

is there a way to do the same, ie. free memory, for sqlplus variables
declared with VAR(iable) keyword?

thanks
geos

On Sep 29, 2:54*pm, geos <g... (AT) nowhere (DOT) invalid> wrote:
Not that I know of; why is it of concern?


David Fitzjarrell

ddf wrote:
thanks David. it's just for learning/understanding purposes.

cheers,
geos

On Sep 30, 2:37*pm, geos <g... (AT) nowhere (DOT) invalid> 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.

HTH -- Mark D Powell --

Mark D Powell wrote:
Mark, many thanks, I wasn't aware of this possibility.

cheers,
geos