Re: Free Unused User Memory

Did some testing on this a year or so ago.

All I remember is that the CPU usage by this call outweighed any gain from the mechanism I was involved in implementing. I also recall that the manuals warn that you should use this call sparingly.

Cheers,

John Thomas

In article <F001.00485D38.20020624135832_at_fatcity.com>, Connor McDonald <hamcdc_at_yahoo.co.uk> writes
>Its unlikely that you'll get any real benefit from
>it..The routine frees up pga memory for reuse, but
>since the PGA is a heap (ie little bits all over the
>place) so the stuff freed up is unlikely to be 'at the
>end'. Maybe under MTS you'd see some benefit (?) but
>for dedicated sessions, the freed up pga will pretty
>much only be available for the same session
>
>hth
>connor
>
> --- "Solomon, Saul M." <ssolomon_at_ppg.com> wrote: >
>Has anyone used
>> dbms_session.free_unused_user_memory;
>> in a production environment?
>>
>> Comments and experiences?
>>
>> Thanks.
>>
>> Saul
>> --
>> Please see the official ORACLE-L FAQ:
>> http://www.orafaq.com
>> --
>> Author: Solomon, Saul M.
>> INET: ssolomon_at_ppg.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX:
>> (858) 538-5051
>> San Diego, California -- Public Internet
>> access / Mailing Lists
>>
>--------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an
>> E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of
>> 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB
>> ORACLE-L
>> (or the name of mailing list you want to be removed
>> from). You may
>> also send the HELP command for other information
>> (like subscribing).
>
>=====
>Connor McDonald
>http://www.oracledba.co.uk
>http://www.oaktable.net
>
>"Remember amateurs built the ark - Professionals built the Titanic"
>
>__________________________________________________
>Do You Yahoo!?
>Everything you'll ever need on one web page
>from News and Sport to Email and Music Charts
>http://uk.my.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
John Thomas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Thomas
  INET: john_at_toronto.demon.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).