RE: Can I index this query? slightly OT-just InterMedia Text opt

Unfortunately Inka, I don't know if I can help you. There are so many other people on this list that are much more adept at perf tuning than I, it ain't even funny. Our single OText index only takes up 70MB total, and the indexed column has very low maintenance with less than 50 inserts/updates per day (no deletes). This is fine for a 6-way HP K570, even though the CPUs are "only" 200Mhz PA-RISC.

If I had to guess, though, I'd say most folks here would have you start with a thourough 10046 trace on the SQL.

Sorry I can't be of more help!

Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Inka Bezdziecka [mailto:IBezdziecka_at_cupe.ca]
> Sent: Wednesday, October 16, 2002 12:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Can I index this query? slightly OT-just InterMedia Text
> option
>
>
> Jesse,
> since you o have such a good experience, could you please
> comment on the following:
> I have installed InterMedia Text (8.1.7 on Win2K sp.2) and
> 400MB has grown to 4.5 GB.
> There are 4 required indices, two for each table - on English
> and French version of varchar2(2000). Number of data base
> objects (user + ctxsys schemas) is 4 times larger.
> Search is perfect, inserts are using 100% CPU and killing the server.
>
> What have I done wrong? Do you have any idea? By the way, I
> have read TFM.
>
> TIA
> inka

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).