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 [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
