Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Parameter recommendations for Oracle 10g?

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

replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question