_b_tree_bitmap_plans

[Former Member]

Hello experts

I have one oracle parameter that needs to be set in our systems.

The parameter is btree_bitmap_plans = FALSE.

Please share with if this change requiring a stop/start of Oracle.

I am googling around and found out that this can be done on the fly in other forum.

In the sapnotes, I couldn't find any.

However, is the parameter will change back to default value (TRUE) after the oracle restart?

Kindly help.

Regards,

Ace.

[Former Member · Accepted solution]

The answer will depend on whether you are using spfile. Probably you do, because that's the default for newer systems.

Start with SAP note 601157.

But to give a short answer to your question:

In order to change it permanently and without having to restart do this ins sqlplus:

alter system set "_b_tree_bitmap_plans" = FALSE scope = both;

[Former Member · Accepted solution]

Thanks Bo

Does this mean that after the server restart, the value still remains on value FALSE?

regards, Ace

[Former Member · Accepted solution]

Yes.

It is all explained in SAP note 601157.

[Former Member · Accepted solution]

Thanks a lot mate

Regards, N

[Former Member · Accepted solution]

Hello experts

Even though my question is answered, i just relized that note 601157 only for Oracle 9i.

My system use Oracle 10G.

Is this solution also applicable?

Thannks in advanced.

Regards, Ace.

[Former Member]

The previous solution is meant for Oracle 9i.

Need a confirmation whether the solution also applicable for Oracle 10g.

[Former Member]

Yes.

The purpose of this note was to describe the new features of Oracle spfile introduced with Oracle 9.

It is the same for Oracle 10.

I agree, SAP really should consider to adapt the title of this note.

Someone of them reading this perhaps?

regards

[Former Member]

And in case you don't trust me (I might be wrong, agreed):

Have a look at SAP note 830576. It is about parameters for Oracle 10g, and it tells you to look at note 601157 for detailed information.

[fidel_vales]

Hi,

i do not think the note should be adapted.

In oracle 9i the mentioned feature was introduced.

the feature has not changed in 10g, therefore still applies.

if a feature is introduced in oracle 7 and a note explains it, should it be necessary to mention that thee feature does not change in 8, 8i, 9i, 10g?

I do not think so.

I(IMHO) think the note should be adapted only when there are changes in features.

Of course, there are obsolete notes, or incomplete or even notes with mistakes, in that cases the forum is not the place to 'inform' SAP but a message

[Former Member]

Fidel,

I don't think the note itself should be adapted.

I do think however the note's title should be adapted.

Leave away the Oracle9i that is.

It makes people believe that it does not apply to a version > 9i, imho.

But maybe it's only me.

regards

[Former Member]

Thanks to all

Yes. My query is now solved.

To be safe, we did some test in sandbox and it work fine even after DB restart.

Thanks to all again.

Ace Joker.