Re: Fav. Urban Legend...Mem vs Disk

UNIX problem ? If memory is allocated from the HEAP it is never really returned to the OS when we do a free. The free only happens when the process exits. So the question is: Do we need the 200 MB or is it somekind of memory leak ? If we need the 200 MB, remember that we are running on a demand paging systems these days. So we only bring in memory what we need, you need to think about your swap space though .......

Anjo.

"Jack C. Applewhite" wrote:

> A most enjoyable book "Venus on the Half Shell", written by Philip Jose
> Farmer under the pseudonym Kilgore Trout, who was a character in many
> novels - particularly "Breakfast of Champions" - by Kurt Vonnegut, who was a
> good friend of Mr. Farmer - also the author of the "Riverworld" trilogy
> (quadrilogy) and others. Oh, the connections!
>
> But the REAL purpose of this post (to keep it On Topic) is to report that my
> problem with excessive SNPx memory use turned out to be an artifact of
> upgrading from 8.1.6.0.0 - in which the interMedia Text indexing functions
> were handled by ExtProc - to 8.1.7.2.5 - in which the iM Text functions are
> incorporated into the RDBMS kernel.
>
> In 8.1.6 the 200MB used during index resyncs was released by ExtProc when
> the process finished. In 8.1.7 the SNP job runs the resync process and the
> 200MB used is not released. Periodically stopping and restarting the SNPx
> processes releases that memory and is an OK workaround.
>
> Jack
>
> --------------------------------
> Jack C. Applewhite
> Database Administrator/Developer
> OCP Oracle8 DBA
> iNetProfit, Inc.
> Austin, Texas
> www.iNetProfit.com
> japplewhite_at_inetprofit.com
> (512)327-9068
>
> -----Original Message-----
> Eskridge
> Sent: Wednesday, March 20, 2002 9:33 PM
> To: Multiple recipients of list ORACLE-L
>
> ...
>
> Hmmph. More kowtowing to Douglas Adam's cheap rip off on Kilgore
> Trout's epic, "Venus on the Half Shell". Check the name of the FTL
> drive in the latter and compare it to The Question.
>
> Curious though, how the answer is just one more than the maximum ITL
> slots with 2k blocks... (he says in a desperate attempt to get back
> on topic)
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jack C. Applewhite
> INET: japplewhite_at_inetprofit.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.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).