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 188.8.131.52.0 - in which the interMedia Text indexing functions
were handled by ExtProc - to 184.108.40.206.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 C. Applewhite
OCP Oracle8 DBA
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
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Author: Jack C. Applewhite
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).