CPU Spike

Hi Team,

We are using 19.28 Oracle DB version. At 08:18 AM UTC, there was a CPU spike consuming 43.3% CPU, screenshot attached. Can you please share any query to find out which sql caused this spike. We are using below queries but no output shown.

Server time is in IST

SQL> SELECT sql_id,

COUNT(*) AS samples

FROM   dba_hist_active_sess_history

WHERE  sample_time BETWEEN

2    3    4    5           TO_TIMESTAMP('2026-03-24 13:30:00','YYYY-MM-DD HH24:MI:SS')

6       AND TO_TIMESTAMP('2026-03-24 13:49:00','YYYY-MM-DD HH24:MI:SS')

7    AND  session_state = 'ON CPU'

8  GROUP BY sql_id

9  ORDER BY samples DESC;

no rows selected