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

Thank you.

You are lucky, I have an Intel system with 1 CPU and 1 36GB drive. This box is running Oracle 8.1.7, IIS and custom developed applications. The drive is 94% full, there is no support for o/s or IIS or applications. The connection to the database is done over odbc, there are also some dblinks here and there and everywhere.

There is a Web developer, who is the ultimate owner of the sail, the boat and the sailor. Actually there is no sailor. I look after this database out of the goodness of my heart.

-----Original Message-----
Sent: Wednesday, October 16, 2002 3:10 PM To: Multiple recipients of list ORACLE-L 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Inka Bezdziecka
  INET: IBezdziecka_at_cupe.ca

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