This content has been marked as final. Show 3 replies
What is the application release?
Please see if these documents help.
Note: 391678.1 - Performance issue on Supplier Item Catalog Search by Suppler Item Number
Note: 429652.1 - Supplier Item Catalog Search By Supplier Item Number Is Too Slow
If none of the above is applicable, please enable trace and generate the TKPROF file.
Thanks for the reply back. Unfortunately, we tried to apply both patches (recommended patch (5404474) v. the previous patch(5567690) but it did not work . We actually have a TAR opened with Oracle support. I'd thought that with this Oracle forum site, other customers may have the similar performance issue and hopefully a recommended resolution. At this point, Oracle support mentioned the issue lies in the parsing segment of the query.
Did you try to setup a trace and see what is the most time consuming statement?