How to call hints from Siebel to improve performance
Hi Experts,
I need your valuable inputs on the below...
We are facing a serious performance issue in one of the transaction form Siebel, we have identified the exact SQL which cause the issue and identified the hints to be implement to overcome the issue.
I just want to know how to call this hints from Siebel when the particular transaction is triggered and also this hints should be applicable only for that session means transaction.
/*+ opt_param('_NO_OR_EXPANSION','False') */
if use SELECT /*+ opt_param('_NO_OR_EXPANSION','False') */ NAME,DESC FROM SIEBEL.S_EVT_ACT WHERE NAME='TEST'; this give me the out is 2 seconds, without this its taking around 5 mins for output.