What is the overhead for running Oracle Text for content searching?
The overhead for running Oracle Text for content indexing and retrieval depends on a variety of factors, including the number of documents, the size of the documents, and their format. It is important that you allow for enough memory and disk space to accommodate this overhead. Refer to the Oracle9i documentation set for Oracle Text performance tuning guidelines. Most of the overhead for using Oracle Text occurs when new documents are being indexed. In general, you should allow an extra CPU to index binary documents, such as Microsoft Office documents. Users will not be able to search for the documents based on their content until after the indexing process has been completed.
