Symptom
After executing e.g. below command and restarting the Oracle instance, one still can see the parameter with some value assigned.
SQL> alter system reset "optimizer_index_cost_adj" scope=both;
SQL> shutdown immediate:
SQL>startup;
SQL> show parameter optimizer_index_cost_adj
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_index_cost_adj integer 100
Read more...
Environment
- Oracle RDBMS
- SAP Netweaver
- SAP Solution manager
- OS independent
Product
Keywords
oracle, parameter, initialization, default, value, reset, spfile, memory, both , KBA , BC-DB-ORA , Oracle , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.