SAP Note 124361 - Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)

Composant : Backoffice Service Delivery -

Solution : https://service.sap.com/sap/support/notes/124361 (Connexion à SAP Service Marketplace requise)

Mots Clés :
sort_area_retained_size 0 sort_area_size 2097152 timed_statistics true transaction_auditing false _b_tree_bitmap_plans false _eliminate_common_subexpr false, processes #sap work processes 2 + 20 remote_os_authent true replication_dependency_tracking false, achieve error-free database operation, disk areas db_block_buffers size depends, log_archive_start true log_buffer 1048576 log_checkpoint_interval 3000000000, recommendation ------------------------------- ------------------------------------- compatible current release, medium-term expected number, 10 cpus max_dump_file_size 20000 max_rollback_segments >= number, sap/oracle customer systems, note 358921 customer relationsship management

Notes associées :

1429324Improvement of the runtime behavior of RC1PHDEL
1238487Update of threshold values of database system check
1109753Table prefetching produces incorrect result sets
1044174Recommendation for CC 5.x running on Oracle 10G Database
960633Merge Join Cartesian in complex join
936441Oracle settings for R3load based system copy
857081Unicode conversion: downtime estimate
848708Oracle Database Configuration for NWDI server
834343Oracle 9.2 Platform Support for Async IO
830576Parameter recommendations for Oracle 10g
823906Oracle 9 database parameters tuning - EP in NW
806554FAQ: I/O-intensive database operations
778700Bank Analyzer: Database parameter Tool-BW
755342Incorrect execution plans with bind variable peeking
635974Error when upgrading to Oracle 9.2.X - Windows
632556Oracle 9.2.0.* database parameterization for BW
626172Performance problems with Outer Join queries in Oracle 9.2
621349
618868FAQ: Oracle performance
598470Error due to "compatible" parameter
592393FAQ: Oracle
544881Composite SAP note: Time-driven jobs do not run
540021Add. information on migrating/updating to Oracle 9.2.0: UNIX
534729Oracle errors due to network problems
505246Several ora-600 [12333] and ora-4031 errors
485755ORA-03232: unable to allocate an extent of blocks
483856Description of the alerts for Oracle database monitoring
458077For all entries: Performance problems in APO Demand Planning
435290Description of BRCONNECT 6.10 DB check conditions
415900General recommendation for Oracle patch sets
376905Long parsing times and Library Cache Locks
375685Oracle 8.0: Problems due to optimizer_features_enable> 8.0.0
362068Supplement to Oracle migration/upgrade to 8.1.7: UNIX
358921Oracle database parameterization for SEM
358917Oracle DB parameterization for CRM and BBP
334006ABAP short dump SQL 1652 GET_03M_X_X_X
320540Oracle param. no longer supported as of Vers. 8.1
216888Additions: Oracle migr./upgrade to 8.1.6: UNIX
215917Easy change from Rule to Cost-Based Optimizer
192055BRCONNECT warnings despite correct parameter values
184134Current patch set for Oracle 8.0.6
180605Oracle database parameter settings for BW
170989Poor performance under Oracle 8044, 805*, 8.0.6
166833IS-U/CCS: Notes on inst. & prod. system operation
165247Notes on creating rollback segments
161552Generation: SQL error 1652 accessing table DD03M
160063Oracle DB parameter setting for R/3 3.x and Oracle8/Oracle9
132503Update of threshold values for database system chck
131372CBO: Tuning of expensive SQL statements
128648Incorrect path used due to rounding errors
128221Increased memory consumption with Oracle >8.0.X
127715CBO: Optimum parameters for performance
124763DDF, KDF: poor performance with Oracle
114716Performance problems Oracle 8.0.4/all entries