Debugging performance issue on Form
Hi Team
I am facing an interesting issue. On Quick Sales order form, I wrote a Form Personalization that executes a PLSQL package which is a collection of several SQL queries.
When the actions is performed, it is taking approx. 1.5 mins to execute.
I enabled the trace and executed, it executed instantaneously. This behavior is replicable at will. That is with TRACE off, it takes time and with trace ON, it happens with the click of mouse.
Please advice what could be the problem here. Note, query cost is 23 and has no full table scans.