Solution : https://service.sap.com/sap/support/notes/712624 (SAP Service marketplace login required)
Summary :
The SAP Note addresses high CPU usage issues linked with Oracle processes in SAP environments. It describes scenarios under which high CPU consumption is normal and symptoms indicating potential problems. The note lists numerous potential causes of high CPU loads, such as intensive SQL operations, parallel queries, specific database functions, and system configurations that may lead to increased CPU demands. Solutions provided include optimizing SQL statement executions, monitoring tools setup, system parameter adjustments, and infrastructure reviews. Effective diagnosis and management of high CPU usage involve a comprehensive understanding of Oracle sessions, transaction codes like ST06 and ST04, and the evaluation of system health through AWR reports.
Key words :
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
Related Notes :
| 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 |