How to Enable Oracle Text Tracing on Specific WebCenter Content Queries (Doc ID 1405144.1)
Last updated on MAY 01, 2017
Oracle WebCenter Content - Version 184.108.40.206.0 and later Information in this document applies to any platform.
When troubleshooting search performance on WebCenter Content, the following note can be used to convert WCC searches into SQL queries.
<Document 1333414.1> - Troubleshooting OracleTextSearch in UCM 10g and 11g: How To Convert UCM Searches into SQL Queries
In addition to using explain plans, Oracle Text tracing options can be enabled to see where the bulk of time is spent searching the index.
Oracle Text provides various trace sections that can be enabled before a CONTAINS query is executed. For WCC, to view specific Oracle Text tracing these options can be turned on before a query is executed in SQL Developer or SQLPlus. Note that the "time" trace sections are in microseconds. (1 million microseconds = 1 second).
For information on specific tracing options, see Oracle Text Reference: Chapter 9: CTX_OUTPUT Package.