Solution : https://service.sap.com/sap/support/notes/712624 (Connexion à SAP Service Marketplace requise)
Résumé :
La note SAP traite des problèmes de consommation élevée de CPU associés aux processus Oracle dans les environnements SAP. Elle décrit les scénarios où une forte consommation de CPU est normale ainsi que les symptômes indiquant des problèmes potentiels. La note énumère de nombreuses causes possibles de charges élevées de CPU, telles que les opérations SQL intensives, les requêtes parallèles, certaines fonctions de la base de données et les configurations système pouvant entraîner une demande accrue de CPU. Les solutions fournies incluent l'optimisation de l'exécution des instructions SQL, la configuration des outils de surveillance, l'ajustement des paramètres système, et la révision de l'infrastructure. Un diagnostic et une gestion efficaces de la consommation élevée de CPU impliquent une compréhension approfondie des sessions Oracle, des codes de transaction comme ST06 et ST04, et l'évaluation de la santé du système par des rapports AWR.
Mots Clés :
customer component bc-db-ora oracle priority recommendations / additional info category, oracle mutexes 923919 advanced oracle block checking features 913247 performance problems due, 923919 advanced oracle block checking features 1028099 long import runtimes, ora-4031 errors 502782 composite sap note ora-4030 360438 sap relevant patches, long data restriction 1436352 oracle database 11g advanced compression, db hints 515080 importing support packages hangs, sparc 1436352 oracle database 11g advanced compression, sap notes 1818320 oracle 11g advanced compression, sap systems 502782 composite sap note ora-4030 505246, sap systems 1227227 sql statement runs endlessly
Notes associées :
| 1818320 | Oracle 11g Advanced Compression for LONG data restriction |
| 1436352 | Oracle Database 11g Advanced Compression for SAP Systems |
| 1227227 | SQL statement runs endlessly or times out (kkompr) |
| 1093485 | Long parsing times on Oracle |
| 1043381 | Long update runtimes if index located in ASSM tablespace |
| 1037755 | Performance problems with ASSM tablespaces |
| 1028099 | Long import runtimes for large db_cache_size |
| 1013912 | FAQ: Oracle BW performance |
| 986536 | High CPU consumption on Oracle 10g |
| 964344 | FAQ: Oracle mutexes |
| 923919 | Advanced Oracle block checking features |
| 913247 | Performance problems due to open changes |
| 896717 | Problems with tables in ASSM tablespaces |
| 881083 | Blocking factors on Oracle-based systems |
| 871455 | Poor performance when accessing DBA and V$ views |
| 846364 | Parse of star query may spin |
| 793113 | FAQ: Oracle I/O configuration |
| 789011 | FAQ: Oracle memory areas |
| 767414 | FAQ: Oracle latches |
| 766349 | FAQ: Oracle SQL optimization |
| 745639 | FAQ: Oracle enqueues |
| 697483 | Oracle Dynamic SGA on Solaris |
| 651060 | FAQ: Oracle Parallel Execution |
| 634263 | Selects with FOR ALL ENTRIES |
| 626172 | Performance problems with Outer Join queries in Oracle 9.2 |
| 619876 | Oracle9i: Automatic PGA Memory Management |
| 619188 | FAQ: Oracle wait events |
| 618868 | FAQ: Oracle performance |
| 617416 | Oracle9i: Dynamic SGA |
| 613872 | Oracle traces with ORADEBUG |
| 603041 | High CPU consumption and AWE |
| 550585 | SAP relevant patches for Solaris 9 on SPARC |
| 545932 | Performance probl. in CO-PC-OBJ period-end closing: DB hints |
| 515080 | Importing Support Packages hangs. Work process with SEM -17 |
| 505246 | Several ora-600 [12333] and ora-4031 errors |
| 502782 | Composite SAP Note ora-4030 |
| 360438 | SAP relevant patches for Solaris 8 on SPARC |
| 176754 | Problems with CBO and RBO |
| 138639 | Poor DML performance with Oracle DDIC statistics |
| 772497 | FAQ: Oracle Hints |