Siebel Business Process & Functionality (MOSC)

MOSC Banner

How to call hints from Siebel to improve performance

edited Dec 18, 2015 10:10AM in Siebel Business Process & Functionality (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center