cancel
Showing results for 
Search instead for 
Did you mean: 

Adjusting Oracle Parameters

Former Member
0 Kudos

Hi,

I´m very confused about the adjustment of the oracle parameters. When I execute the sql sentence I get a several oracle parameters, and in the note 830576 says that i need to adjust only the parameters that appears in this note, is right?

The other parameters that differs the IS_VALUE with SHOULD_BE_VALUE, Must to be changed? Or doesn´t affect at oracle db instance?

In the following recommendation what do i need to do?

optimizer_dynamic_sampling add with value "6" IS_VALUE 2 SHOULD_BE_VALUE 6

-

-


>It´s mandatory to change the value of this parameter even in the note 830576 not appear explicity?

disableobjstat_del_broadcast add with value "FALSE" IS_VALUE Empty SHOULD_BE_VALUE FALSE

-

-


>Must to be changed? In the note not appear, but in the script appear that the recommended value should_be_false.

btree_bitmap_plans check if value "FALSE" is suitable (set to FALSE if Winbundle<=2) avoid b*tree conversion to bitmap IS_VALUE FALSE *SHOULD_BE_VALUE *set to FALSE if Winbundle<=2

-

-


>My WinBundle Patch it´s upper that 2, then I´ve to put the parameter in OK??

inmemory_undo check why set but mentioned with other prerequisites/not mentioned in note IS_VALUE FALSE SHOULD_BE_VALUE Empty

-

-


>What do i do?

sessions automatic check ok; doublecheck if value "160" is suitable (2*PROCESSES) IS_VALUE 160 SHOULD_BE_VALUE 2*PROCESSES

-

-


>I don´t understand the doublecheck if value 160 is suitable, what to do?

commit_write ok (is not set; not to be set as explicitly mentioned in note) IS_VALUE Empty SHOULD_BE_VALUE deleted from parameter file

-

-


>I understant that If this parameter it´s not specified in the note not need to configured in the database, correct?

dispatchers ok (is not set; mentioned with other prerequisites/not mentioned in note) IS_VALUE Empty SHOULD_BE_VALUE Empty

-

-


>It´s necessary to do something?

A lot of thanks for your advices!

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi Ruben,

Additionally you may look into the parameter for which column "SET" has value "NO". You may need to set those parameters with appropriate values as suggested by SAP.

Regards,

Deepak Kori

Former Member
0 Kudos

Thanks for your answers.

I need to change only the parameters specified in the note 830576 or I must to change all the parameters that appears in the report for to check the oracle configuration?

And How to delete the value of one parameter? If the IS_VALUE of one parameter is empty, the parameter is disabled?

More thanks

former_member188883
Active Contributor
0 Kudos

Hi Ruben,

You need to evaluate all the parameters listed in the report generated from SAP note 830576

Regards,

Deepak Kori

Former Member
0 Kudos

Thanks deepakkori

It will be a hard work. If I need to put a parameter with the value Do not set!, How can do it?

former_member188883
Active Contributor
0 Kudos

Hi Ruben,

I mentioned to evaluate all the parameter list generated with help from script attached to SAP note.

You need to set those parameters for which column "SET" has value "NO".

You need to adjust those parameters ( either remove or change value) for which column "SET" has value "YES".

If the report says that you need not set a parameter, you need to remove it from your initSID.ora file.

Hope this helps you.

Regards,

Deepak Kori

Former Member
0 Kudos

Ok deepakkori,

But which is the sql sentence for delete or reset the value of one parameter?

I´ve found this sentence

alter system reset some_param scope=both sid='*';

But i´m not sure of execute for the sid*, It´ll be dangeorus

former_member188883
Active Contributor
0 Kudos

Hi Ruben,

You can try either of the options mentione below. Option is preferred.

1) You can use the following command ( identified by you)

alter system reset some_param scope=both ;

2) Incase you have spfile created in the system,

shutdown your database and application

You can directly remove the parameter line from your initSID.ora file;

create spfile from pfile;

startup database and application;

Regards,

Deepak Kori

Former Member
0 Kudos

I´m checking all the parameter and I found this:

aq_tm_processes ok (is not set; mentioned with other prerequisites/not mentioned in note) SET N IS_VALUE 0 SHOULD_BE EmptyQ 1

This parameter is not specified in the note, and it´s differentes the value of is_value and Should_be, What have to do?

Former Member
0 Kudos

I´ve reset to parameters shared_pool_reserved_size and sort_area_size, and they´ve now the previos value i supposed. But in the shoul_be is empty.

What sentence I need to execute to delete this value of the parameter?

former_member188883
Active Contributor
0 Kudos

Hi Ruben,

Open the initSID.ora file in text editor. hash out the parameters which are not required as per SAP recommended note.

Shutdown database

create spfile from pfile;

startup database.

Follow above mentioned steps to achieve the desired result.

Regards,

Deepak Kori

Former Member
0 Kudos

Are there other option? I not want to edit directly the spfile.

Which will be the sql sentence for do it?

More thanks

Former Member
0 Kudos

Hi Ruben,

There is no specific sequence is following generally.

It depends on the output of the automated parameter check as per the note # 1171650

Since spfile is a binary file, even if you want to modify, the file will gets corrupted.

Use the options suggested by Deekpak Kori

You can try either of the options mentione below. Option is preferred.

1) You can use the following command ( identified by you)

alter system reset some_param scope=both ;

2) Incase you have spfile created in the system,

shutdown your database and application

You can directly remove the parameter line from your initSID.ora file;

create spfile from pfile;

startup database and application;

Br,

Venky

Former Member
0 Kudos

But If i use the sentence:

alter system reset some_param scope=both ;

Only reset the actual value of the paramter, I don´t delete the parameter. How can i delete a paramter?

Former Member
0 Kudos

Ruben,

Reset option should remove the parameter from the spfile.

But, the in case of the static parameter, the change is effective only after the restart.

Check v$parameter or v$system_parameter views, after you execute the statement for a parameter.

Br,

Venky

former_member188883
Active Contributor
0 Kudos

Hi Ruben,

In order to delete the parameter from the file,

You need to open the file initSID.ora in the text editor

hash or remove the line of the parameter name , which you intend to get rid of.

Save the file.

Shutdown your database

run the below command using sql prompt

SQL>create spfile from pfile;

SQL> startup

This will start the database with the updated parameters (either removed or modified).

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi,

I´m adjusting the oracle paramters, but i´ve the next doubt.

In the note 830576 not appear the next oracle parameters

dml_locks

check why set but mentioned with other prerequisites/not mentioned in note IS_VALUE=4000 SHOULD_BE=

job_queue_processes

check why set but mentioned with other prerequisites/not mentioned in note IS_VALUE=1 SHOULD_BE=

The value differs from shoul_be value that it´s empty. I´ve to delete this paramaters?

Thanks

Former Member
0 Kudos

I don´t understanding the next doubt.

I´m applyng the value from several parameters, other values are deleted. The sentence SQL appears in the command line how applied but I shutdown the database, SQL>create spfile from pfile;SQL> startup.

Then I´ve executed the reporta again,and I don´t see any change!!Seems that something doesn´t work. Which will the cause?

Thanks

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Ruben,

Don't be confused. IS_VALUE = Current value, SHOULD_BE_VALUE = SAP recommendation

>> optimizer_dynamic_sampling add with value "6" IS_VALUE 2 SHOULD_BE_VALUE 6

-

-


>It´s mandatory to change the value of this parameter even in the note 830576 not appear explicity?

If the system is OLAP, its value should be set to "6"

>> disableobjstat_del_broadcast add with value "FALSE" IS_VALUE Empty SHOULD_BE_VALUE FALSE

-

-


>Must to be changed? In the note not appear, but in the script appear that the recommended value should_be_false.

If the system is 10.2.0.5 then you should set this parameter to "FALSE"

>> btree_bitmap_plans check if value "FALSE" is suitable (set to FALSE if Winbundle<=2) avoid b*tree conversion to bitmap IS_VALUE FALSE *SHOULD_BE_VALUE *set to FALSE if Winbundle<=2

-

-


>My WinBundle Patch it´s upper that 2, then I´ve to put the parameter in OK??

There are some conditions needs to be met to put this parameter into the profile. So, if the scripts says "FALSE", it is correct to set it in the profile

>> inmemory_undo check why set but mentioned with other prerequisites/not mentioned in note IS_VALUE FALSE SHOULD_BE_VALUE Empty

-

-


>What do i do?

if the database relase is 10.2.0.2, then you should set this parameter. If it is not , delete it.

>> sessions automatic check ok; doublecheck if value "160" is suitable (2PROCESSES) IS_VALUE 160 SHOULD_BE_VALUE 2PROCESSES

-

-


>I don´t understand the doublecheck if value 160 is suitable, what to do?

What is the "processes" value of the database? multiply by 2 this value. Processes value must be calculated with the formula in the same note

>> commit_write ok (is not set; not to be set as explicitly mentioned in note) IS_VALUE Empty SHOULD_BE_VALUE deleted from parameter file

-

-


>I understant that If this parameter it´s not specified in the note not need to configured in the database, correct?

Yes, it shouldn't beconfigured in the database profile

>> dispatchers ok (is not set; mentioned with other prerequisites/not mentioned in note) IS_VALUE Empty SHOULD_BE_VALUE Empty

-

-


>It´s necessary to do something?

Do nothing

I hope that it is clear

Best regards,

Orkun Gedik