Note 830576 - Parameter recommendations for Oracle 10g
Summary
SymptomThis note contains SAP's recommendations for the configuration of Oracle Database 10g.
Other terms
init.ora, SPFILE, server parameter file
Reason and PrerequisitesThis note contains SAP's recommendations for the optimal configuration of the Oracle database with Release 10g in SAP environments.
Parameter recommendations for Oracle Release 11.2 can be found in SAP Note 1431798.
For Oracle Release 9i or lower, refer to Note 124361 and the notes referenced there.
Note that the recommendations given in this note may be changed. Therefore, we recommend that you check the latest version of this note once a month and make the necessary changes.
Previously, some parameter settings for the Oracle database (for example, for the cost-based optimizer) depended on whether your system was a normal R/3 system or a BW-based system. As of Oracle 10g, there is a uniform parameterization recommendation for all systems, which is described in this note. A few exceptions to this are indicated explicitly.
General recommendationsYou should delete obsolete initialization parameters from the profile. To determine which obsolete parameters are currently set, proceed as follows:
SELECT NAME FROM V$OBSOLETE_PARAMETER WHERE ISSPECIFIED = 'TRUE';
You should not set any parameters that are not explicitly mentioned in this note. Exceptions:
Parameter changes are implemented as required (see patch day).
Change history:
Notation:
n := Number of the Windows patch collection
Example: WIN 10.2.0.4.nP (n >= 11)
x := unspecified placeholder for UNIX PSU
that correlates with the date variable
date := Date of the SBP
Example: UNIX 10205x_date (date >= 201103)
For information about the automatic check of the parameter, see Note 1171650.
For more information on individual parameters, see Note 1289199.
STANDARD PARAMETER RECOMMENDATIONS FOR ORACLE 10.2.0
************************************************
Other terms
init.ora, SPFILE, server parameter file
Reason and PrerequisitesThis note contains SAP's recommendations for the optimal configuration of the Oracle database with Release 10g in SAP environments.
Parameter recommendations for Oracle Release 11.2 can be found in SAP Note 1431798.
For Oracle Release 9i or lower, refer to Note 124361 and the notes referenced there.
Note that the recommendations given in this note may be changed. Therefore, we recommend that you check the latest version of this note once a month and make the necessary changes.
Previously, some parameter settings for the Oracle database (for example, for the cost-based optimizer) depended on whether your system was a normal R/3 system or a BW-based system. As of Oracle 10g, there is a uniform parameterization recommendation for all systems, which is described in this note. A few exceptions to this are indicated explicitly.
General recommendationsYou should delete obsolete initialization parameters from the profile. To determine which obsolete parameters are currently set, proceed as follows:
SELECT NAME FROM V$OBSOLETE_PARAMETER WHERE ISSPECIFIED = 'TRUE';
You should not set any parameters that are not explicitly mentioned in this note. Exceptions:
- The parameter is recommended as the solution or workaround for a problem in another note.
- The parameter is required for implementing an individual configuration (for example, multiple archiver destinations, check functions, special memory settings).
- For detailed information about the maintenance of parameters with SFILEs, see Note 601157.
- If several EVENT parameters are specified in init.ora, they must appear in consecutive rows. You must avoid entering several events separated by ":" in one row.
- You should not set parameters that are indicated with "Do not set!" and parameters that are not mentioned at all in the note (and for which there is no individual customer requirements). In this case, you use the Oracle default value, which then also appears in V$PARAMETER or in the ST04 parameter overview. This is the intended behavior. If you want to ensure that a parameter has not been explicitly set, you can enter the following query ( in lower case):
SELECT ISDEFAULT FROM V$PARAMETER2
WHERE NAME = '';
- You can only optimize memory parameters and resource parameters such as DB_CACHE_SIZE or DB_WRITER_PROCESSES individually. Therefore, this note cannot give any general recommendations. However, you can determine options for optimization on the basis of a database performance analysis (see Notes 618868, 619188, 789011).
- The parameterization described below is directed towards the use of the features of the dynamic SGA (Note 617416) and the automatic PGA administration (Note 619876).
- refers to the value of the environment variable SAPDATA_HOME.
- Paths are given in UNIX syntax. On WINDOWS, you must replace the forward slashes ("/") with back slashes ("\").
- The terms OLAP system and OLTP system have the following meaning:
- OLAP system: These are systems with mainly BW functions (BW / BI, APO with mainly DP usage, SEM-BPS, BW-based SEM-BCS).
- OLTP system: Systems with mainly non-BW functions (this also includes, for example, Bank Analyzer systems)
- Configure systems with a pure Java stack as you would an OLTP system.
- Configure double stack systems (that is, systems with both ABAP and JAVA stacks) as you would an OLTP or OLAP system, depending on degree to which you use BW functions (see above).
- In a few exceptional cases, if you have a system without OLAP, you can refrain from setting OLAP specific parameters such as STAR_TRANSFORMATION_ENABLED, _FIX_CONTROL or _INDEX_JOIN_ENABLED to avoid problems (for example, ORA-04031 due to _FIX_CONTROL, Note 997889) or to use functions (for example, index joins). Note that such scenarios are only relevant in very rare situations. Therefore, you do not usually have to deviate from the standard recommendations.
- If you set parameters depending on a bugfix implementation, the relevant bugfix is specified. The notes referenced contain dependent fixes such as WINDOWS patches or merge fixes.
Parameter changes are implemented as required (see patch day).
Change history:
- 10.11.2011 / 18.11.2011
- Updated recommendation for parameter REMOTE_OS_AUTHENT (Note 1622837)
- 13.09.2011: _DISABLE_OBJSTAT_DEL_BROADCAST = FALSE
- is added for UNIX and Windows with 10.2.0.5.
- 10.08.2011: Note inserted:
- "If 10.2.0.4 or 10.2.0.5 are not mentioned explicitly,
- the parameter recommendation applies to both Oracle versions. Since 10.2.0.2
- is no longer supported, the parameter recommendations for
- 10.2.0.2 are no longer maintained either."
- 12.05.2011:
- _fix_control 6055658:OFF is added for 10.2.0.4 and 10.2.0.5
- _fix_control 4728348:OFF is adjusted for 10.2.0.5
- 12.04.2011:
- _fix_control 4728348:OFF is adjusted for 10.2.0.4
- Restriction to OLTP for _B_TREE_BITMAP_PLANS is removed.
- 11.03.2011:
- Parameter recommendations for Windows based on the Windows patch
Notation:
n := Number of the Windows patch collection
Example: WIN 10.2.0.4.nP (n >= 11)
x := unspecified placeholder for UNIX PSU
that correlates with the date variable
date := Date of the SBP
Example: UNIX 10205x_date (date >= 201103)
- 11.02.2011:
- 10.2.0.5: EVENT 10753 removed
- 11.01.2011:
- 10.2.0.4, 10.2.0.5: _FIX_CONTROL 4728348:OFF, Note 1547676
- 10.2.0.5: EVENT 10753 (Level 2)
- 22.11.2010:
- Parameter recommendations for 10.2.0.5 in general and for
- SBP 10205X_DATE (DATE >=201011) maintained
- 10.10.2010:
- _OPTIMIZER_BETTER_INLIST_COSTING removed
- 10.09.2010: No Changes
- 10.08.2010:
- 10.2.0.4 with Fix 8575528: _CURSOR_FEATURES_ENABLED = 10
- 10.07.2010:
- 10.2.0.4: _FIX_CONTROL 9196440
- 10.06.2010:
- 10.2.0.4: Adjustments _FIRST_SPARE_PARAMETER, _SECOND_SPARE_PARAMETER
- 10.05.2010:
- 10.2.0.4, OLTP: _B_TREE_BITMAP_PLANS = FALSE
- 10.2.0.4 with Fix 9495669: _FIX_CONTROL '9495669:ON'
- 10.04.2010: No Changes
- 10.03.2010: No Changes
- 10.02.2010: No Changes
- 10.01.2010: Do not set NLS_LENGTH_SEMANTICS.
- 10.12.2009: No Changes
- 10.11.2009: No Changes
- 10.10.2009:
- 10.2.0.4: EVENT 10891 no longer necessary
- 10.09.2009: No Changes
- 10.08.2009: No Changes
- 10.07.2009:
- 10.2.0.4: EVENT 10753 (Level 2)
- 10.06.2009:
- 10.2.0.4 without Fix 8366255: EVENT 10753 (Level 2)
- 10.2.0.4 with Fix 5099019: _FIX_CONTROL '5099019:ON'
- 10.05.2009:
- OLTP: Do not set OPTIMIZER_DYNAMIC_SAMPLING
- 10.2.0.4 with Fix 7891471: _FIX_CONTROL '7891471:ON'
- 10.04.2009:
- 10.2.0.x with Fix 6399597: _FIX_CONTROL '6399597:ON'
- 10.2.0.4 with Fix 6795880: _CURSOR_FEATURES_ENABLED = 10
- 10.03.2009:
- 10.2.0.4: _OPTIMIZER_BETTER_INLIST_COSTING = OFF
- 10.2.0.4 with Fix 7692248: _FIX_CONTROL '7692248:ON'
- 10.02.2009:
- 10.2.0.2: _FIX_CONTROL '6120483:OFF' adjusted
- 10.2.0.4: set _FIRST_SPARE_PARAMETER if required
- 10.01.2009:
- 10.2.0.2: _IN_MEMORY_UNDO generally set to FALSE
- 10.2.0.2 with fixes: _FIX_CONTROL '6430500:ON' and '7325597:ON'
- 10.2.0.4: _FIX_CONTROL '6670551:ON'
- 10.12.2008:
- 10.2.0.2: EVENT 44951 (Level 1024)
- 10.2.0.4: Event 10142 (Level 1)
- 10.2.0.4: _FIX_CONTROL 5765456 from Level 7 to Level 3
- 14.11.2008: _FIX_CONTROL changes for 10.2.0.4
- 10.11.2008: OPTIMIZER_INDEX_CACHING Do not generally set
- 10.10.2008: No Changes
- 23.09.2008: EVENT 10049 (LEVEL 2)
- 17.09.2008: "_FIX_CONTROL"='6329318:OFF'
- 25.08.2008: EVENT 10091 (LEVEL 1)
- 14.08.2008: "_FIX_CONTROL"='6120483:OFF'
- 17.07.2008: Parameterization for Oracle 10.2.0.4 is integrated.
- 27.06.2008: HPUX_SCHED_NOAGE = 178, _DB_BLOCK_NUMA = 1, _ENABLE_NUMA_OPTIMIZATION = FALSE
- 21.05.2008: "_FIX_CONTROL"='6626018:ON', "_FIX_CONTROL"='6660162:ON', "_FIX_CONTROL"='6440977:ON'
- 18.04.2008: LOG_ARCHIVE_DEST replaced with LOG_ARCHIVE_DEST_1
- 28.11.2007: _BLOOM_FILTER_ENABLED = FALSE
- 08.11.2007: EVENT 10891 (LEVEL 1)
- 01.11.2007: _TABLE_LOOKUP_PREFETCH_SIZE = 0
- 08.10.2007: EVENT 38087 (LEVEL 1)
- 11.09.2007: "_FIX_CONTROL"='5705630:ON'
For information about the automatic check of the parameter, see Note 1171650.
For more information on individual parameters, see Note 1289199.
STANDARD PARAMETER RECOMMENDATIONS FOR ORACLE 10.2.0
************************************************
| Parameter | Recommendation |
|---|---|
| ------------------------------- | ------------------------------------ |
| BACKGROUND_DUMP_DEST | /saptrace/background |
| COMMIT_WRITE | Do not set |
| COMPATIBLE | 10.2.0 |
| CONTROL_FILES | At least three copies on |
| different disk areas | |
| CONTROL_FILE_RECORD_KEEP_TIME | 30 or higher |
| CORE_DUMP_DEST | /saptrace/background |
| DB_BLOCK_SIZE | 8192 |
| DB_CACHE_SIZE | Size depends on the available |
| memory (Notes 789011, 617416) | |
| DB_FILES | Larger than the number of data files |
| to be expected in the short term | |
| DB_FILE_MULTIBLOCK_READ_COUNT | Do not set |
| DB_NAME | |
| DB_WRITER_PROCESSES | Only set in case of increased |
| DBWR load (Notes 79341, 793113) | |
| EVENT | |
| "10027 trace name context forever, level 1" (Note 596420) | |
| "10028 trace name context forever, level 1" (Note 596420) | |
| "10049 trace name context forever, level 2" (Note 1253845) | |
| WIN 10.2.0.4.nP (5 <= n <= 9) | |
| "10091 trace name context forever, level 1" (Note 1227227, | |
| 10.2.0.2 or 10.2.0.4 without fix 7188932) | |
| UNIX 10.2.0.4 without SBP and without fix 7188932 | |
| WIN 10.2.0.4.nP (n <= 6 and WIN 32bit) | |
| 10.2.0.4.nP (n <= 8 and WIN 64bit) | |
| "10142 trace name context forever, level 1" (Note 1284478) | |
| "10162 trace name context forever, level 1" (Notes 977319, | |
| 1040300, 10.2.0.2) | |
| "10183 trace name context forever, level 1" (Note 128648) | |
| "10191 trace name context forever, level 1" (Note 128221) | |
| "10411 trace name context forever, level 1" (is required to activate | |
| fix 6768114, Note 1137346, 10.2.0.4 or higher) | |
| UNIX 10.2.0.4 and 10.2.0.5 | |
| WIN 10.2.0.4.nP (n >= 2) | |
| 10.2.0.5.nP (n >= 3) | |
| "10629 trace name context forever, level 32" (Note 869521, | |
| other settings of event 10626 or 10629 also allowed) | |
| "10753 trace name context forever, level 2" (Note 1351737, | |
| 10.2.0.4) | |
| UNIX 10.2.0.4 | |
| WIN 10.2.0.4 | |
| "10891 trace name context forever, level 1" (Note 1037651, | |
| 10.2.0.2) | |
| "14532 trace name context forever, level 1" (Note 1031682, | |
| 10.2.0.2 with fix 5618049 or 10.2.0.4 or higher) | |
| "38068 trace name context forever, level 100" (Note 176754) | |
| "38085 trace name context forever, level 1" (Note 176754, | |
| >= 10.2.0.4) | |
| "38087 trace name context forever, level 1" (Note 948197, | |
| 10.2.0.2 with fix 5842686 or 10.2.0.4 or higher) | |
| "44951 trace name context forever, level 1024" (Note 1166242, | |
| 10.2.0.2 with fix 6376915 or 10.2.0.4 or higher) | |
| FILESYSTEMIO_OPTIONS | SETALL (Note the restrictions from |
| Note 999524) | |
| HPUX_SCHED_NOAGE | 178 (HP-UX only, without RAC) |
| LOG_ARCHIVE_DEST | Do not set! |
| LOG_ARCHIVE_DEST_1 | |
| "LOCATION=/oraarch/arch" | |
| LOG_ARCHIVE_FORMAT | %t_%s_%r.dbf |
| LOG_BUFFER | 1048576 (Actual value may |
| be different, see Note 1289199) | |
| LOG_CHECKPOINTS_TO_ALERT | TRUE |
| MAX_DUMP_FILE_SIZE | 20000 |
| NLS_LENGTH_SEMANTICS | Do NOT set |
| OPEN_CURSORS | 800 (up to a maximum of 2000) |
| OPTIMIZER_DYNAMIC_SAMPLING | OLTP: Do not set. |
| OLAP: 6 (>= 10.2.0.4) | |
| OPTIMIZER_FEATURES_ENABLE | Do not set |
| OPTIMIZER_INDEX_CACHING | Do not set! |
| OPTIMIZER_INDEX_COST_ADJ | OLTP: 20 |
| OLAP: Do not set. | |
| OPTIMIZER_MODE | Do not set |
| PARALLEL_EXECUTION_MESSAGE_SIZE | 16384 |
| PARALLEL_MAX_SERVERS | #DB-CPU-Cores * 10 |
| PARALLEL_THREADS_PER_CPU | 1 |
| PGA_AGGREGATE_TARGET | OLTP: 20 % of available memory |
| OLAP: 40 % of available memory | |
| PROCESSES | #ABAP work processes * 2 + |
| #J2EE server processes * | |
| + | |
| PARALLEL_MAX_SERVERS + 40 | |
| QUERY_REWRITE_ENABLED | FALSE |
| RECYCLEBIN | OFF |
| REMOTE_OS_AUTHENT | TRUE (optional; no longer recommended, |
| but still SAP Inst. Default) | |
| Do not set (=FALSE) for | |
| -SAP installations with SSFS for ABAP | |
| (see Note 1622837), or | |
| -SAP installations without ABAP stack, | |
| or | |
| -homogeneous SAP installations on | |
| Windows | |
| REPLICATION_DEPENDENCY_TRACKING | FALSE (if no replication |
| is used) | |
| SESSIONS | 2 * PROCESSES |
| SHARED_POOL_SIZE | 400 MB or greater, refer to Note 690241 |
| STAR_TRANSFORMATION_ENABLED | TRUE |
| UNDO_MANAGEMENT | AUTO (Note 600141) |
| UNDO_RETENTION | set if required (refer to Note 600141) |
| UNDO_TABLESPACE | PSAPUNDO (Note 600141) |
| USER_DUMP_DEST | /saptrace/usertrace |
| _B_TREE_BITMAP_PLANS | FALSE (10.2.0.2) |
| FALSE (10.2.0.4, without fix 9770451, | |
| Note 1461804) | |
| UNIX SBP 10204x_date (date <= 201009) | |
| UNIX 10.2.0.5 without SBP | |
| WIN 10.2.0.4.nP (n <= 39) | |
| 10.2.0.5.nP (n <= 2) | |
| _BLOOM_FILTER_ENABLED | FALSE (10.2.0.2, Note 1119194) |
| _CURSOR_FEATURES_ENABLED | 10 (10.2.0.4 with Fix 8575528 |
| Note 1273790) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| WIN 10.2.0.4.nP (n >= 27) | |
| _DB_BLOCK_NUMA | 1 (HP-UX only, see Note 1225732) |
| _DISABLE_OBJSTAT_DEL_BROADCAST | FALSE |
| UNIX 10.2.0.5 | |
| WIN 10.2.0.5 | |
| _ENABLE_NUMA_OPTIMIZATION | FALSE (HP-UX only, see Note 1225732) |
| _FIRST_SPARE_PARAMETER | 1 (WINDOWS: 10.2.0.4 or higher, w/ fix |
| 6904068 from Note 1273790; | |
| UNIX: 10.2.0.4, w/ fix | |
| 6904068 from Note 1273790 and | |
| without fix 7291739 from Note 1475173 | |
| UNIX: 10.2.0.5, Note 1527468) | |
| UNIX SBP 10205x_date (date >= 201011) | |
| WIN 10.2.0.4.nP (n >= 13) | |
| WIN 10.2.0.5.nP (n >= 3) | |
| _FIX_CONTROL | |
| '4728348:OFF' (10.2.0.2 without fix 5397482 from Note 981875, | |
| refer to Notes 964858 and 997889) | |
| (10.2.0.4, Note 1547676 | |
| 10.2.0.5, Note 1547676) | |
| UNIX SBP 10204x_date (date <= 201103) | |
| UNIX SBP 10205x_date ( date = 201105 or earlier) | |
| WIN 10.2.0.4 | |
| WIN 10.2.0.5.nP (n <= 5) | |
| '5099019:ON' (10.2.0.4 with fix 5099019 from Note 1165319 | |
| and 10.2.0.5) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| UNIX 10.2.0.5 | |
| WIN 10.2.0.4.nP (n >= 16) | |
| WIN 10.2.0.5 | |
| '5705630:ON' (10.2.0.2 with fix 5705630 from Note 981875 | |
| or 10.2.0.4 or higher) | |
| '5765456:3' (>= 10.2.0.4) | |
| '6055658:OFF' (10.2.0.4 with fix 6055658 from Note 1165319, | |
| 10.2.0.5 with fix 6055658 from Note 1525673) | |
| UNIX SBP 10204x_date (date >= 201105) | |
| UNIX SBP 10205x_date (date >= 201105) | |
| '6120483:OFF' (10.2.0.4 or lower with fix 6120483 and without fix 7325597 from | |
| Note 981875 (10.2.0.2) or Note 1165319 (10.2.0.4)) | |
| UNIX 10.2.0.4 | |
| WIN 10.2.0.4.nP (1 <= n <= 10) | |
| '6221403:ON' (10.2.0.4, Note 1165319) | |
| UNIX 10.2.0.4 | |
| WIN 10.2.0.4.nP (n >= 6 and WIN 32bit) | |
| WIN 10.2.0.4.nP (n >= 8 and WIN 64bit) | |
| '6329318:OFF' (10.2.0.4 with fix 6329318 and without fix 7211965 | |
| from Note 1165319) | |
| UNIX 10.2.0.4 without SBP but | |
| with fix 6329318 and without fix 7211965 | |
| WIN 10.2.0.4.nP (6 <= n <= 10 and WIN 32bit) | |
| WIN 10.2.0.4.nP (8 <= n <= 10 and WIN 64bit) | |
| '6329318:ON' (10.2.0.4 with fix 7211965 from Note 1165319) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| WIN 10.2.0.4.nP (n >= 11) | |
| '6399597:ON' (10.2.0.2 with fix 6399597 from Note 981875, | |
| 10.2.0.4 with fix 6399597 from Note 1165319, | |
| 10.2.0.5) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| UNIX 10.2.0.5 | |
| WIN 10.2.0.4.nP (n >= 8) | |
| WIN 10.2.0.5 | |
| '6430500:ON' (10.2.0.2 with fix 6430500 from Note 981875, | |
| 10.2.0.4 with fix 6430500 from Note 1165319) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| UNIX SBP 10205x_date (date >= 201011) | |
| WIN 10.2.0.4.nP (n >= 11) | |
| WIN 10.2.0.5 | |
| '6440977:ON' (10.2.0.2 with fix 6440977 from Note 981875 | |
| or 10.2.0.4 or higher) | |
| UNIX 10.2.0.4 and 10.2.0.5 | |
| WIN 10.2.0.4.nP (n >= 6 and WIN 32bit) | |
| WIN 10.2.0.4.nP (n >= 8 and WIN 64bit) | |
| WIN 10.2.0.5 | |
| '6626018:ON' (10.2.0.2 with fix 6626018 from Note 981875 | |
| or 10.2.0.4 or higher) | |
| UNIX 10.2.0.4 and 10.2.0.5 | |
| WIN 10.2.0.4.nP (n >= 1 and WIN 32bit) | |
| WIN 10.2.0.4.nP (n >= 5 and WIN 64bit) | |
| WIN 10.2.0.5 | |
| '6660162:ON' (10.2.0.2 on UNIX with fix 6660162 from Note 981875) | |
| '6670551:ON' (10.2.0.4 with fix 6670551 from Note 1165319 | |
| 10.2.0.5) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| UNIX 10.2.0.5 | |
| WIN 10.2.0.4.nP (n >= 1 and WIN 32bit) | |
| WIN 10.2.0.4.nP (n >= 5 and WIN 64bit) | |
| WIN 10.2.0.5 | |
| '6972291:ON' (10.2.0.4 or higher, Note 1165319) | |
| UNIX 10.2.0.4 and 10.2.0.5 | |
| WIN 10.2.0.4.nP (n >= 6 and WIN 32bit) | |
| WIN 10.2.0.4.nP (n >= 8 and WIN 64bit) | |
| WIN 10.2.0.5 | |
| '7325597:ON' (10.2.0.2 with fix 7325597 from Note 981875, | |
| 10.2.0.4 with fix 7325597 from Note 1165319) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| WIN 10.2.0.4.nP (n >= 11) | |
| '7692248:ON' (10.2.0.4 with fix 7692248 from Note 1165319 | |
| 10.2.0.5) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| UNIX 10.2.0.5 | |
| WIN 10.2.0.4.nP (n >= 20) | |
| WIN 10.2.0.5 | |
| '7891471:ON' (10.2.0.4 with fix 7891471 from Note 1165319 | |
| 10.2.0.5) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| UNIX 10.2.0.5 | |
| WIN 10.2.0.4.nP (n >= 23) | |
| WIN 10.2.0.5 | |
| '9196440:ON' (10.2.0.4 with fix 9196440 from Note 1165319 | |
| SBP 10205X_DATE (DATE >=201011)) | |
| UNIX SBP 10204x_date (date >= 201007) | |
| UNIX SBP 10205x_date (date >= 201011) | |
| WIN 10.2.0.4.nP (n >= 38) | |
| WIN 10.2.0.5.nP (n >= 2) | |
| '9495669:ON' (10.2.0.4 with fix 9495669 from Note 1165319 | |
| SBP 10205X_DATE (DATE >=201011)) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| UNIX SBP 10205x_date (date >= 201011) | |
| WIN 10.2.0.4.nP (n >= 37) | |
| WIN 10.2.0.5.nP (n >= 2) | |
| _INDEX_JOIN_ENABLED | FALSE (10.2.0.2, refer to Notes |
| 964858 and 1165319) | |
| _IN_MEMORY_UNDO | FALSE (10.2.0.2) |
| _OPTIM_PEEK_USER_BINDS | FALSE (see Note 755342) |
| _OPTIMIZER_MJC_ENABLED | FALSE (Note 176754 (30)) |
| _PUSH_JOIN_UNION_VIEW | FALSE (10.2.0.4, without fix 7155655 |
| from Note 1248584) | |
| UNIX 10.2.0.4 without SBP and | |
| without fix 7155655 | |
| WIN 10.2.0.4.nP (n <= 10) | |
| _SECOND_SPARE_PARAMETER | 1 (UNIX, 10.2.0.4 with fix 6904068 |
| from Note 1273790 and with fix | |
| 7291739 from Note 1475173) | |
| UNIX SBP 10204x_date (date >= 201005) | |
| _SORT_ELIMINATION_COST_RATIO | 10 (see Note 176754 (16)) |
| _TABLE_LOOKUP_PREFETCH_SIZE | 0 (10.2.0.2, refer to Notes |
| 1109753 and 1165319) | |
Header Data
| Release Status: | Released for Customer |
| Released on: | 13.12.2011 12:24:39 |
| Master Language: | German |
| Priority: | Recommendations/additional info |
| Category: | Installation information |
| Primary Component: | BC-DB-ORA Oracle |
RELATED POSTS
Useful links for SAP BW
- SAP BW Notes
- Something about SAP
- Yangchaung
- Way2Sap
- SAP BI Articles
- SAP BW Area
- ERP Howto
- SAP BW Developers Guide
- SAP Help for SAP BI 7.0
- SAP BI - SDN Articles
- SAP BI - How to Guides
No comments:
Post a Comment