Oracle-L: RE: Re[2]: Fav. Urban Legend...Mem vs Disk

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Thu, 21 Mar 2002 06:28:22 -0800
Message-ID: <F001.0042FA10.20020321062822@fatcity.com>

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

Received on Thu Mar 21 2002 - 08:28:22 CST