Biq Optimization

Only available on StudyMode
  • Download(s) : 312
  • Published : April 25, 2012
Open Document
Text Preview
SAP Note 1431798 Oracle 11.2.0: Database Parameter Settings
Note Language: English Version: 47 Validity:
Valid Since 21.02.2012

Summary
Symptom
This note contains SAP's recommendations for the optimal configuration of Oracle Database Release 11.2. These parameter recommendations are relevant for all SAP products. This note will be updated regularly once a month. Beyond that, changes will only be made in exceptional cases for critical Oracle parameters. Change history: o February 14, 2012: o added _FIX_CONTROL '13077335:ON' for Unix for 11.2.0.3

January 11, 2012: added _FIX_CONTROL '13077335:ON' for Unix for 11.2.0.2

o

December 21, 2011: added parameter reccommendations for 11.2.0.3

o

December 13, 2011: updated reccommendation for parameter remote_os_authent

o

November 10, 2011: updated recommendation for parameter log_buffer (SAP note 1627481) updated recommendation for deprecated parameter remote_os_authent (SAP note 1622837)

-

o

October 27, 2011: add WIN 11.2.0.1 to _OPTIMIZER_USE_CBQT_STAR_TRANSFORMATION

o

October 26, 2011: updated STAR_TRANSFORMATION_ENABLED ( HotNews 1636936 ) added _OPTIMIZER_USE_CBQT_STAR_TRANSFORMATION (HotNews 1621425)

o

September 13, 2011: added _FIX_CONTROL '6055658:OFF' for Windows

o

July 13, 2011: updated setting for LOG_ARCHIVE_DEST_1 for ASM

06.03.2012

Page 1 of

11

SAP Note 1431798 Oracle 11.2.0: Database Parameter Settings o June 10, 2011: added parameter recommendations for Exadata and Grid Infrastructure

o o

May 18, 2011: modified description for _ENABLE_NUMA_SUPPORT May 12, 2011: Parameter recommendations adjusted for Windows 11.2.0.2 adjusted _FIRST_SPARE_PARAMETER for Unix 11.2.0.2 adjusted _FIX_CONTROL '4728348:OFF' for Windows 11.2.0.1 added _FIX_CONTROL '6055658:OFF' for UNIX added _MUTEX_WAIT_TIME and _MUTEX_WAIT_SCHEME for 11.2.0.2

o

April 12, 2011: added parameter _B_TREE_BITMAP_PLANS added event 10995

o

March 18, 2011: corrected the text in brackets for _FIRST_SPARE_PARAMETER and _SECOND_SPARE_PARAMETER corrected the date values for _fix_control = '4728348:OFF'

o o

March 15, 2011: formal change (Change history March 10, 2011) March 10, 2011: _FIRST_SPARE_PARAMETER for UNIX 11.2.0.1 added

_SECOND_SPARE_PARAMETER for UNIX 11.2.0.2 added Parameter recommendations adjusted for Windows based on the Windows Patch Collections and for UNIX based on the SBP: For Windows platforms, the new notation is as follows: n := number of the Windows Patch Collection E.g.: WIN 11.2.0.1.nP ( n >= 3)

For Unix platforms, the new notation is as follows: x := Placeholder for the UNIX PSU (correlates to date) date := Release Date of UNIX SBP

06.03.2012

Page 2 of

11

SAP Note 1431798 Oracle 11.2.0: Database Parameter Settings E.g.: o UNIX SBP 11202x_date ( date >= 201103 )

Feburary 10, 2011: added parameter recommendation for Automatic Storage Management (ASM), modified recommendation for remote_os_authent, added recommendation for _enable_NUMA_support, removed _fix_control '5483301:OFF' January 11, 2011: adjusted _fix_control settings for 11.2.0.1 and 11.2.0.2 November 10, 2010: adjusted _fix_control settings for 11.2.0.2.0 October 18, 2010: mention of ORA-32006 October 12, 2010: removed _OPTIMIZER_BETTER_INLIST_COSTING September 13, 2010: removed DB_RECOVERY_FILE_DEST, DB_RECOVERY_FILE_DEST_SIZE, DB_WRITER_PROCESSES, LOCAL_LISTENER, LOG_ARCHIVE_DEST September 9, 2010: added _FIX_CONTROL '9196440:ON' September 9, 2010: added _FIX_CONTROL '8937971:ON' June 10, 2010: added _FIX_CONTROL '9495669:ON' May 10, 2010: added _FIX_CONTROL '6972291:ON' April 19, 2010: Enhanced syntax for EVENT March 30, 2010: Note released

o

o o o o

o o o o o o

Other terms
init.ora, SPFILE, server parameter file, profile

Reason and Prerequisites
This note contains SAP's recommendations for the optimal configuration of the Oracle database with Release 11.2 in SAP environments. Please note that the...
tracking img