SAP Note 618868 - FAQ: Oracle performance

Composant : Oracle - Oracle Performance Problems

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

Résumé :
Cette note SAP fournit des instructions pour aborder les problèmes de performance de la base de données Oracle dans un environnement SAP. Elle précise que la FAQ ne peut pas résoudre tous les problèmes de performances mais sert de point de départ. Pour analyser la performance, le paramètre Oracle TIMED_STATISTICS doit être activé en TRUE. Ceci peut être activé dynamiquement via des commandes SQL pour un effet immédiat. L'analyse de performance inclut la revue des données des transactions telles que ST03/N et ST04, où le temps de base de données ne doit pas dominer excessivement le temps de réponse total. La note propose divers diagnostics, comme l'analyse des ratios de temps CPU par rapport aux temps d'attente et des statistiques de session détaillées des vues V$, pour identifier les goulets d'étranglement et les inefficacités de performance. L'accès et l'interprétation des données de performance Oracle dans SAP R/3 sont détaillés avec référence spécifique aux requêtes de base de données directes et aux anomalies statistiques potentielles expliquées. Dans l'ensemble, cette note est une ressource essentielle pour améliorer la performance d'Oracle au sein des systèmes SAP, fournissant à la fois des lignes directrices générales et des directions techniques spécifiques pour l'optimisation de la base de données.

Mots Clés :
loading table <table>bb8 buffer overflow loading table <table>, transaction st04 -> detail analysis menu -> file system requests, earlywatch health check empowering workshop uscp10, includes fully-qualified primary key accesses, parameter dbs/ora/array_buf_size defines, operating system-dependent optimization            solaris, st04 -> detail analysis menu -> display, detail analysis menu -> oracle session, activated traces            activating traces unnecessarily, alter system set timed_statistics = true

Notes associées :

1854524Performance degradation over time for Oracle >=11.2.0.3, AIX
1672954Oracle 11g: Usage of hugepages on Linux
1431798Oracle 11.2.0: Database Parameter Settings
1269911FAQ: Chained Rows
1266771SRM 7.0 Performance Guide
1223360Composite SAP Note: Performance optimization during import
1169088SRM 6.0 Performance Guide
1164043DBSL (Oracle): Maximum buffer size for array operations
1137346Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4
1075118SAP on HP-UX: FAQ
1047734Unrealistic Oracle performance values on Windows/AMD
1037755Performance problems with ASSM tablespaces
1036194OS timers are not synchronized
1020260Delivery of Oracle statistics (Oracle 10g, 11g)
964344FAQ: Oracle mutexes
950658Huge values shown in READTIM, WRITETIM of V$FILESTAT
912918Massive UNDO/REDO generation when you use ASSM
892296Enhancements in update statistics in BRCONNECT 7.00/7.10
881083Blocking factors on Oracle-based systems
871735Current patch set for Oracle 10.2.0
871455Poor performance when accessing DBA and V$ views
871096Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2
869521Oracle <= 10g: TM locks with REBUILD ONLINE / CREATE ONLINE
869006Composite SAP note: ORA-04031
868590Performance issue with SUN/Oracle 8.1.7 client
857973Deleting clients efficiently using Oracle
853576Oracle 10g: Performance analysis w/ ASH and Oracle Advisors
842240FAQ: Backup strategy of large and highly-available databases
838725Oracle dictionary statistics and system statistics
832343FAQ: Clustering factor
830576Parameter recommendations for Oracle 10g
825653Oracle: Common misconceptions
806554FAQ: I/O-intensive database operations
805934FAQ: Database time
797629FAQ: Oracle histograms
793113FAQ: Oracle I/O configuration
789011FAQ: Oracle memory areas
787533Bad performance/ system lockup due to enqueue waits
771929FAQ: Index fragmentation
767414FAQ: Oracle latches
766827Composite SAP note: Performance SCM 4.0
766349FAQ: Oracle SQL optimization
762808FAQ: Keep pool
750205High memory usage with AIX5.2/5.3 and Oracle9.2
745639FAQ: Oracle enqueues
723894Brconnect: Create the statistics for all columns.
717484FAQs: Oracle statspack
716000Database monitor for Oracle 9/Oracle RAC SAP Release 6.X
712624High CPU consumption by Oracle
706478Preventing Basis tables from increasing considerably
705608Database monitor for Oracle 9/Oracle RAC
703035Objects with ERROR status in buffer
689818High Paging Rates during Backup
659946FAQ: Temporary tablespaces
651060FAQ: Oracle Parallel Execution
650631Composite SAP note: ORA-01003
648203Database objects with INVALID status
619188FAQ: Oracle wait events
618861Composite SAP Note: ORA-01013
596420System standstill during deadlock (ORA-60)
592393FAQ: Oracle
588668FAQ: Database statistics
582427Error due to inconsistent Oracle DDIC
579462Runtime parameter of the statistics collection
567745Composite note BW 3.x performance: DB-specific setting
562403FAQ: Oracle Net
558746Better Oracle Data Dictionary BW Performance
539921Current patch set for Oracle 9.2.0
521264Hang situations
500340FAQ: LOBS
421795Report SAP_ANALYZE_ALL_INFOCUBES
378509Oracle DB parameter setting for APO
354080Note collection for Oracle performance problems
332677Rebuilding fragmented indexes
192658Setting parameters for BW systems
184905Collective note Performance BW 2.0
176754Problems with CBO and RBO
160063Oracle DB parameter setting for R/3 3.x and Oracle8/Oracle9
138639Poor DML performance with Oracle DDIC statistics
135048Long runtimes statements w/ ROWNUM <= condition
132861CBO: Statistics creation with SAPDBA or BRCONNECT
124361Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)
122718CBO: Tables with special treatment
47239Behavior of the table buffers
20071Permanent lock after connection termination
4162Missing "end backup"