on 2011 Oct 18 4:46 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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?
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.