How to change optimised hidden parameters in Oracle 10g.

[Former Member]

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 · Accepted solution]

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