STechno

Note 618868 - FAQ: Oracle performance

Header
Version / Date 175 / 2013-05-08
Priority Recommendations/additional info
Category FAQ
Primary Component BC-DB-ORA Oracle
Secondary Components SV-BO-DB-ORA Oracle Performance Problems

Summary
Symptom
    1. Can I use this FAQ to solve all Oracle performance problems?
    2. Which prerequisites are required for a detailed performance analysis?
    3. How can I determine whether the general database performance can be optimized?
    4. How can I tell how much time a particular transaction spends on the database and on which activity?
    5. How can performance data be accessed by Oracle?
    6. How can Oracle performance data be accessed by R/3?
    7. Is the data from the Oracle V$ views always correct?
    8. In which time unit is performance data usually specified in Oracle and R/3?
    9. What general checks can be carried out in the event of Oracle performance problems?
    10. How do I proceed if I come across lengthy database accesses in SM50 or SM66?
    11. Where can I find an overview of known Oracle performance problems?
    12. Where can I find BW-specific information about database performance?
    13. What do I do if the database hangs completely?
    14. What is the reason for significant differences in runtime when identical database accesses are executed?
    15. What causes poor performance at INSERT statements?
    16. What causes poor performance at COMMIT statements?
    17. What does "Sequential Read" and "Direct Read" mean in SM50/SM66?
    18. How is Data Buffer Quality determined?
    19. How can I improve the performance of reorganizations, index creation, structure validation and similar tasks?
    20. How can I improve the performance of backup, restore and recovery?
    21. How can I monitor the progress of a long-running action?
    22. Where can I find more help about Oracle performance subjects?
Other terms

FAQ, frequently asked questions

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

Key words : oracle performance database data time check buffer statistics table problems reads information transaction insert system analysis read values there than

Related Notes
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