Satish Chopra asked 1 year ago
Title : How to alter SQL developer sessions to get Siebel generated SQL execution plan?

Question :

How to alter SQL developer sessions to get Siebel generated SQL execution plan?

1 Answers
Kumar HarshKumar Harsh Staff answered 1 year ago

We need to alter session parameters
ALTER SESSION SET OPTIMIZER_MODE = FIRST_ROWS_10
ALTER SESSION SET _OPTIMIZER_SORTMERGE_JOIN_ENABLED = FALSE
ALTER SESSION SET _OPTIMIZER_JOIN_SEL_SANITY_CHECK = TRUE

Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.