Performance tuning Oracle Context

Hello:

We are working on a Context application that indexes about 1,000 large documents (15-18 pages) and about 10,000 small documents (2-3 pages).

Indexing performance seems to be pretty good, but retrieval performance is only OK. We are using two-step queries and the average query is taking about 10 seconds. I would like to get it down to about 2-3 seconds.

The database server is a Sun Enterprise 3500 with 512 Mb of memory, with about a 320 Mb buffer cache, 60 Mb shared pool. We also have SORT_MEMORY SIZE turned up to about 8M to keep most sorts in memory. The datafiles are on an EMC Symmetrix and are distributed across a series of mirrored partitions.

During searches we see a fairly high IO load on the EMC, with almost no CPU utilization.

We have tuned our engine preferences to create large tables for the Context index tables to prevent chaining and fragmentation.

Any ideas on tuning approaches for Context would be appreciated.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 01 1998 - 12:54:39 CST