Parameter recommendations for Oracle 10g?

[Former Member]

Hello,

This note 830576 contains sap`s recommendations for Oracle 10g, but the some parameter information during EarlyWatch Alert do not follow Sap standard recommendations Are not in that note.

These parameters are no longer used?

Can be removed?

Which I attribute value? The note does not have the parameters and values.

Those are the parameter:

pushjoin_predicate

db_block_checksum

hash_join_enabled

log_archive_start

max_rollback_segments

transaction_auditing

Regards,

Antonio Júnior

[Former Member · Accepted solution]

Deleting / unsetting depends on what parameter file you are using (initSID or spfile). In initSID you comment those lines which you don't want. In case of spfile, you could use

ALTER SYSTEM SET parameter = ''; for sting values

For numeric and boolean value parameters, you must specifically set the parameter back to its original default value.

Hope that helps.

thanks

BMG

[fidel_vales · Accepted solution]

Hello,

Sorry, but that information is not correct.

You use "ALTER SYSTEM RESET" command:

> Resetting System Parameters

> You can delete parameter entries from the SPFILE using the following command:

> SQL>ALTER SYSTEM RESET <parameter_name> scope = spfile sid = '*';

more information about setting/resetting parameters on the SPFILE on the note 601157

[Former Member · Accepted solution]

Thanks....

[Former Member · Accepted solution]

Fidel,

I meant to say set first and didn't add the reset statement. thanks for correcting.

BMG

[fidel_vales · Accepted solution]

Hi,

No problem, I wanted to clarify it because for some parameters Oracle behave different if it is set, even when the value set is the same as the default value.

Also, it can happen that Oracle changes the default and you hit problems for having it set

Rgds

Fidel

[Former Member]

Hi ,

Actually the information of the specified parameters are not given in the specified note .But You have to keep the parameters

log_archive_start=FALSE

db_block_checksum=FALSE.

Remaining parameters are not required.You can delete the remaining parameters.

[fidel_vales]

Hello Antonio,

The note 830576 is current.

If the recommendations on the EWA are "wrong" that is an indication that you have an old patch.

a quick note search gives notes

898759 " Various corrections on ORACLE checks for ST-SER_2005_2"

or

944354 -" Various corrections on ORACLE checks for ST-SER_2006_1"

or

1001574 - "Various corrections on ORACLE checks for ST-SER_2006_2"

and more in the middle, depending on your system configuration

Try to install the latest patch to solve the EWA issues.

Edited by: Fidel Vales on Jan 22, 2008 8:36 PM

[Former Member]

Hi,

this Parameters is used in older oracle version <10g

pushjoin_predicate : No need to set in 10g

db_block_checksum : Note 923919 - Advanced Oracle block checking features

hash_join_enabled : No need to set in 10g

log_archive_start : No need to set in 10g

max_rollback_segments : No need to set in 10g

transaction_auditing : No need to set in 10g

regards,

kaushal

[Former Member]

Hi,

The parameters are set, how do I not set?