SAP Note 830576 - Parameter recommendations for Oracle 10g

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/830576 (SAP Service marketplace login required)

Key words :
init.ora, SPFILE, server parameter file

Related Notes :

1622837Secure connection of AS ABAP to Oracle via SSFS
1527468Oracle 10.2.0.5 underscore spare parameter
1525673Optimizer merge fix for Oracle 10.2.0.5
1487754Add. info.: Upgrade to SAP NW 7.3 ORACLE
1476753NetWeaver BPM: Performance issues on Oracle Database
1475345Oracle 10.2.0.4 underscore spare parameter
1475173Contention with auto-tuned undo retention
1472386ORA-04031 out of memory error in BW systems
1468914ORA-55567 after install SAP Bundle Patch SAP_102044_201005
1431752Oracle 10.2.0: Patches/Patch Collections for 10.2.0.5
1342593Account search: Performance issue with name and address
1336972BW Oracle RSRV parameter COMPATIBLE
1325833Error in Console: The MDM repository is invalid
1289199Information about Oracle parameters
1284478Poor performance when using Btree bitmap plans
1284406MISSING_STATISTICS warning after new installation
1273790kks* merge fix for Oracle 10.2.0.4
1238487Update of threshold values of database system check
1233458Error during startup: ORA-00940: invalid ALTER command
1227227SQL statement runs endlessly or times out (kkompr)
1225732Oracle 10.2 ccNUMA optimization on HP-UX
1171650Automated Oracle DB parameter check
1165319Optimizer merge fix for Oracle 10.2.0.4
1146843
1137346Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4
1122246Central note SAP NetWeaver 7.0 Rapid Installer for SPS 14
111919410.2.0.2: Incorrect result set with Bloom filters
1117785RW: Wrong data / bad performance with ORACLE 10g
1085874Performance in International Financial Reporting Standards
1085873Performance in BaselII Capital Accord
1077887SAP on HP-UX:mount & filesystem options for best performance
1075118SAP on HP-UX: FAQ
1044174Recommendation for CC 5.x running on Oracle 10G Database
1040300Wrong values with Star Transformation Hint 9.2.0.8 /10.2.0.2
1037651Oracle 10.2.0.2: Long parsing times for complex joins
1031682ORA-04031 due to shared pool component "mvobj part des"
1013912FAQ: Oracle BW performance
1013476ORA-600 kcbzpbuf_1 during array insert causes corruption
1009332Central note SAP NetWeaver 2004s Rapid Installer for SPS 11
999524Oracle 10.2 platform support for Async IO
999126Performance improvement for star queries
997889Error ORA-04031 due to "_fix_control"
980805ORA-600 kdtigetrow-2 w/ array insert leads to corruptions
977319Incorrect values in Oracle 10.2 (II)
964858Incorrect vals w/ STAR_TRANSFORMATION_ENABLED in Oracle 10.2
960790Upgrade to SAP NetWeaver 7.1 AS ABAP/AS Java ORACLE
960633Merge Join Cartesian in complex join
949847
948294AIX JFS2: mount options to use with Oracle 10g / 11g
934808SAP Enterprise Portal on Oracle: Advanced Configuration
914177File system reiserfs Oracle parameter filesystemio_options
900345Backward Release of ORACLE 10.2 - Upgrade Information
899070ORA-01406 reported on SELECT against SAP Tables (eg.TRDIR)
885167Add. info.: Upgrade to SAP NetWeaver 7.0 Java ORACLE
848708Oracle Database Configuration for NWDI server
819830Oracle Database 10g: Additional Information on upgrade:UNIX
819655Add. info.: Upgrade to SAP NW 2004s ABAP ORACLE
789011FAQ: Oracle memory areas
755342Incorrect execution plans with bind variable peeking
720886Oracle Database 10g: Integration into the SAP environment
690241The Shared SQL Area in the Shared Pool and large SQL Stmnts
632556Oracle 9.2.0.* database parameterization for BW
619876Oracle9i: Automatic PGA Memory Management
619188FAQ: Oracle wait events
618868FAQ: Oracle performance
617416Oracle9i: Dynamic SGA
601157Oracle9i: Server Parameter File
600141Oracle9i: Automatic UNDO Management
596423Events and SPFILE
596420System standstill during deadlock (ORA-60)
592393FAQ: Oracle
527481tRFC or qRFC calls are not processed
378509Oracle DB parameter setting for APO
192055BRCONNECT warnings despite correct parameter values
180605Oracle database parameter settings for BW
176754Problems with CBO and RBO
132551Overflow log sequence numbers on NT
128221Increased memory consumption with Oracle >8.0.X
124361Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)
79341Checkpoint not complete
1135916Line items: Help for analysis for long runtime
828268Oracle Database 10g: New functions