Home › Discussions › Questions & Answers › Database CPU Spikes: Finding the Culprit SQL

Database CPU Spikes: Finding the Culprit SQL

Avatar photoCustomer February 5, 2022 at 5:05 pm

We are experiencing significant CPU spikes on our database server every morning, causing slowdowns across EBS. How can I quickly pinpoint the specific SQL statements responsible for this high load?

Viewing 4 reply threads
  • Author
    Replies
    • Support February 7, 2022 at 7:11 am  

      You should run the DBA AWR SQL Performance Summary report. This report retrieves summarized execution statistics, focusing on CPU-intensive SQLs, as the default sorting prioritizes maximizing server load optimization.

    • Avatar photoCustomer February 8, 2022 at 11:40 pm  

      Which columns in the report should I focus on to confirm CPU consumption, and how can I narrow down the time frame to match our morning spike?

    • Support February 10, 2022 at 11:11 pm  

      Look primarily at the ‘Cpu Time’ and ‘Buffer IO’ columns; high CPU time often indicates massive amounts of data read from the buffer cache. To target the time window, ensure you filter the report using the snapshot interval parameters corresponding to your morning peak hours.

    • Avatar photoCustomer February 13, 2022 at 1:33 am  

      If the problem SQL is highly CPU intensive, is that a sure sign of inefficient query logic?

    • Support February 13, 2022 at 10:44 pm  

      High CPU time suggests the SQL is reading a lot of data, often due to poor indexing or full table scans. You can drill down using the SQL_ID and Plan Hash Value to analyze the execution path using DBA SGA SQL Execution Plan History.

  • Author
    Replies
Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123992

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 20560

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14853

How to check if a patch is applied in Oracle EBS 12.2 14616

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14264

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 12113

Migration to Java Web Start in Oracle EBS 12.2 instance 10115

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 10071

Securing sensitive data with Oracle VPD 8061

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6638

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2027
2036
2025
2024
2023
2022
2021
2020
2019
2018