Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

parameter remove

Hi,

any one can help me how to removed optimizer_index_cost_adj parameter.

Former Member
Former Member replied

Manas . wrote:

SQL>

SQL> SELECT INST_ID, NAME, VALUE, ISDEFAULT from GV$PARAMETER2 WHERE NAME = 'optimizer_index_cost_adj';

INST_ID NAME                           VALUE           ISDEFA

------- ------------------------------ --------------- ------

      1 optimizer_index_cost_adj       100             TRUE

Any process that the parameter remove that means its not show any value.

Hi,

Haven't you read completely my answer?

if so, try to understand.

If you still are so <...> that you can't understand after my two replies, then

NO, THERE IS NO PROCESS TO REMOVE TOTALLY A PARAMETER WHEN ORACLE HAS DECIDED THAT IT MUST HAVE A DEFAULT VALUE.

in your case, ISDEFAULT=TRUE means that the parameter is NOT SET.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question