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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] 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: [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).
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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] 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: [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).
RE: Can I index this query? slightly OT-just InterMedia Text opt
D'oh! Like my co-worker said "This is cause for a Do-Over." GL! You'll need it... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Inka Bezdziecka [mailto:IBezdziecka@;cupe.ca] > Sent: Wednesday, October 16, 2002 5:14 PM > To: Multiple recipients of list ORACLE-L > Subject: 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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).