Home » Server Options » Text & interMedia » Text index performance guidelines (Oracle 10.2)
Text index performance guidelines [message #380980] Wed, 14 January 2009 11:22 Go to next message
Messages: 13
Registered: June 2008
Location: UK
Junior Member
Hi all,

I have a quick question about the performance of Oracle Text indexes:

Are there any guidelines on what the size of DEFAULT_INDEX_MEMORY should be depending on the size of your index?
I assume I have not set DEFAULT_INDEX_MEMORY high enough, as my index is still a little fragmented after rebuilding it.

I have read through all the Oracle documentation on this subject, but I did not find any recommendations for the size I should be using.

If anyone could let me know where I could find more information about this, that would be fantastic.

Thanks in advance,


Re: Text index performance guidelines [message #380990 is a reply to message #380980] Wed, 14 January 2009 13:00 Go to previous message
Barbara Boehmer
Messages: 8737
Registered: November 2002
Location: California, USA
Senior Member
The following is an excerpt from the online documentation:

"You should aim to set the DEFAULT_INDEX_MEMORY value as high as possible, without causing paging."

from the following page:


Previous Topic: getting error ora-29855 AND Error while creating Index on clob data (2 threads merged by bb)
Next Topic: CTX_DOC.Snippet not recognized special characters like ',""
Goto Forum:

Current Time: Sat Aug 19 21:25:06 CDT 2017

Total time taken to generate the page: 0.28799 seconds