Skip to Content

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

How to change optimised hidden parameters in Oracle 10g.

Hello Gurus,

SAP suggested me to change the following parameter values in Oracle database. But I am unable to make change in this parameter.

The parameters are mentioned as below.

Name

1> btree_bitmap_plans

2> sortelimination_cost_ratio

3> optimizermjc_enabled

I am unable to check the current values and chnge it to new value. So please suggest me the proper way to change this parameters.

Regards,

Jayendra.

Former Member
Former Member replied

Hello,

if you use an SPFILE you can use the following command:

alter system set "<underscore_parameter_name>" = <value> scope=spfile;

In case of init<sid>.ora you just specify the parameters in the file itself:

<underscore_parameter_name> = <value>

Regards

Martin

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