WCP12c: Improve performance of your Search Content Queries
Hi, A year ago I spoke in NL OUG 2017 on how to improve you Oracle WebCenter Portal 12c performance. https://es.slideshare.net/DanielMerchnGarca/nloug-2017-oracle-webcenter-portal-12c-performance Recently, I had a customer who was running a very well tunned Oracle WebCenter Portal 12c platform, but it has been growing a lot during the latest years. I have realised that queries to Oracle WebCenter Content were performing very bad, so I checked the typical: Check the fragmentation of the current OTS index by using the PL/SQL command. It shown a perfect 1% and the PL/SQL job was scheduled for being executed each 3 days. WebCenter Content configuration and AutoSuggestIndexer. All was good... JVM Monitoring and CPU / Memory resources. All good as well. So... what was happening then?. Enabling requestaudit trace in WebCenter Content it was showing response times very high. The query thrown from Oracle WebCenter Portal was giving very bad answer time >requestaudit/6...