Activity, whole spanASH active sessions across every compared window, by wait class and by wait event

These charts are drawn by the page script, so they need JavaScript. ASH is not scored: every scored number is in the tables below.

Physical reads 5.4× normal; DB time up 79.7%, mostly wait.

4 findings
11 metrics moved
30 metrics normal

TimelineDown a column: one window. Across a row: when it started.

The Timeline is drawn by the page script; with JavaScript off it is not drawn, and every number it would show is in the sections below.

Thursday 09:00–10:0013 windows

vs prior meanclick a date to pin

All sectionsEvery table of the report

Database timeDB CPU plus non-idle waits across the full span, by wait class

DB time per windowaverage active sessions

18 Jun−12w

25 Jun−11w

2 Jul−10w

9 Jul−9w

16 Jul−8w

23 Jul−7w

30 Jul−6w

6 Aug−5w

13 Aug−4w

20 Aug−3w

27 Aug−2w

3 Sep−1w

10 Sepcurrent

vs prior mean

20.35AASnormal 8.378–14.27

10.11

9.924

12.74

10.02

10.25

10.33

10.12

10.23

13.07

13.26

12.76

13.08

20.35

▲ 79.7%z +6.1σ

Active sessionsASH by wait class, hourly, 2026-06-18 09:00 → 2026-09-10 10:00; compared windows shaded

4 findingsFindings10 large1 moderate30 normal5 folded11 metrics moved, in 4 familiesEvery scored metric against its prior windows; one table per domain

Large

+31.7σ

Metric	Current	Normal range	vs normal, in σ	z	Δ vs mean
Table scans (long tables)	61.69/s	1.846–2.310	>+99σ	>+99σ	▲ ×29.7
Physical Read Total Bytes Per Sec twin	193.1 MB/s	26.08 M–45.88 M	+31.7σ	+31.7σ	▲ ×5.4
Read I/O requests	16.01 k/s	2,162–3,804	+31.7σ	+31.7σ	▲ ×5.4
Physical read bytes	193.1 MB/s	26.08 M–45.88 M	+31.7σ	+31.7σ	▲ ×5.4
Physical Reads Per Sec twin	22.24 k/s	3,003–5,284	+31.7σ	+31.7σ	▲ ×5.4
User I/O waits	8.285 AAS	1.434–2.512	+23.4σ	+23.4σ	▲ ×4.2
Logical Reads Per Sec twin	987.9 k/s	127.0 k–292.7 k	+18.8σ	+18.8σ	▲ ×4.7
Logical reads	987.9 k/s	127.0 k–292.7 k	+18.8σ	+18.8σ	▲ ×4.7

DB time up 79.7%, mostly wait

20.35AASnormal 8.378–14.27 AAS

10.11

9.924

12.74

10.02

10.25

10.33

10.12

10.23

13.07

13.26

12.76

13.08

20.35

CPU: DB CPU8.584 AAS, normal 7.226 AAS; the rise is wait
Metric: Wait time ratio57.83 %, normal 36.22 %
Metric: SQL response time3.279 ms/call, normal 1.866 ms/call

2 related metrics, 2 twins

Metric	Current	Normal range	vs normal, in σ	z	Δ vs mean
Wait time ratio	57.83 %	33.79–38.65	+17.8σ	+17.8σ	▲ 59.7%
CPU time ratio twin	42.17 %	61.23–66.33	−16.9σ	−16.9σ	▼ 33.9%
SQL response time	3.279 ms/call	1.458–2.275		+6.9σ	▲ 75.7%
Average active sessions twin	20.35 AAS	8.378–14.27		+6.1σ	▲ 79.7%

Large

+57.9σ

Network waits 5.2× normal

1.175AASnormal 0.1947–0.2602 AAS

0.2142

0.2106

0.2393

0.2141

0.2195

0.2261

0.2118

0.2083

0.2442

0.2518

0.2406

0.2487

1.175

Event: SQL*Net more data to client1.146 AAS, normal 0.2087 AAS
Event: SQL*Net more data from client0.02895 AAS, normal 0.01875 AAS

Moderate

Commit waits up 22.5%

0.8687AASnormal 0.5696–0.8484 AAS

0.6889

0.6204

0.7587

0.666

0.6798

0.6271

0.6969

0.6273

0.8299

0.755

0.7755

0.7821

0.8687

Event: log file sync0.8687 AAS, normal 0.709 AAS

Load profile

Metric	Current	Normal range	vs normal, in σ	z	Δ vs mean	Prior mean	Prior sd	n
table scans (long tables) ↗ row	61.69	1.846–2.310	>+99σ	>+99σ	▲ ×29.7	2.078	0.1159	12
physical read total bytes ↗ row	193.1 M	26.08 M–45.88 M	+31.7σ	+31.7σ	▲ ×5.4	35.98 M	4.951 M	12
physical reads ↗ row	22.24 k	3,003–5,284	+31.7σ	+31.7σ	▲ ×5.4	4,143	570.1	12
session logical reads ↗ row	987.9 k	127.0 k–292.7 k	+18.8σ	+18.8σ	▲ ×4.7	209.9 k	41.42 k	12
DB time ↗ row	2,035	837.8–1,427		+6.1σ	▲ 79.7%	1,133	147.3	12
CPU used by this session twin ↗ row	845.5	519.1–904.4		+1.4σ	▲ 18.8%	711.8	96.34	12
DB CPU ↗ row	858.4	527.0–918.2		+1.4σ	▲ 18.8%	722.6	97.80	12
table fetch by rowid ↗ row	204.5 k	195.7 k–238.4 k		−1.2σ	▼ 5.8%	217.1 k	10.66 k	12
redo writes ↗ row	406.7	354.6–422.0		+1.1σ	▲ 4.7%	388.3	16.86	12
user commits ↗ row	648.7	360.4–741.6		+1.0σ	▲ 17.7%	551.0	95.32	12
parse count (failures) ↗ row	0.1623	0.06444–0.195		+1.0σ	▲ 25.1%	0.1297	0.03264	12
redo size ↗ row	3.992 M	2.760 M–4.451 M		+0.9σ	▲ 10.7%	3.606 M	422.9 k	12
user rollbacks ↗ row	3.730	1.839–4.758		+0.6σ	▲ 13.1%	3.298	0.7299	12
user calls ↗ row	6,208	5,499–6,621		+0.5σ	▲ 2.4%	6,060	280.5	12
bytes received via SQL*Net from client ↗ row	2.056 M	1.873 M–2.369 M		−0.5σ	▼ 3.1%	2.121 M	124.1 k	12
physical writes ↗ row	1,772	1,575–2,106		−0.5σ	▼ 3.7%	1,841	132.9	12
physical write total bytes ↗ row	27.58 M	24.51 M–32.79 M		−0.5σ	▼ 3.7%	28.65 M	2.069 M	12
execute count ↗ row	9,274	6,838–10.76 k		+0.5σ	▲ 5.4%	8,800	980.9	12
opened cursors cumulative ↗ row	5,750	4,240–6,672		+0.5σ	▲ 5.4%	5,456	608.2	12
sorts (rows) ↗ row	1.453 M	1.294 M–1.552 M		+0.5σ	▲ 2.1%	1.423 M	64.57 k	12
parse count (total) ↗ row	661.1	493.5–772.4		+0.4σ	▲ 4.5%	632.9	69.73	12
logons cumulative ↗ row	3.925	3.308–4.346		+0.4σ	▲ 2.6%	3.827	0.2597	12
sorts (disk) ↗ row	0.3926	0.3026–0.5194		−0.3σ	▼ 4.5%	0.411	0.0542	12
parse count (hard) ↗ row	2.714	0–22.70		−0.3σ	▼ 50.8%	5.512	8.593	12
bytes sent via SQL*Net to client ↗ row	9.711 M	8.489 M–10.60 M		+0.3σ	▲ 1.8%	9.544 M	527.4 k	12
sorts (memory) ↗ row	2,090	1,877–2,369		−0.3σ	▼ 1.5%	2,123	123.0	12
redo size for lost write detection twin ↗ row	0	0–0	flat, σ = 0	—	—σ≈0	0	0	12

▸ Show 22 normal / improved / flat rows

System metrics

Metric	Current	Normal range	vs normal, in σ	z	Δ vs mean	Prior mean	Prior sd	n
Physical Read Total Bytes Per Sec twin ↗ row	193.1 M	26.08 M–45.88 M	+31.7σ	+31.7σ	▲ ×5.4	35.98 M	4.951 M	12
Physical Read Total IO Requests Per Sec ↗ row	16.01 k	2,162–3,804	+31.7σ	+31.7σ	▲ ×5.4	2,983	410.5	12
Physical Reads Per Sec twin ↗ row	22.24 k	3,003–5,284	+31.7σ	+31.7σ	▲ ×5.4	4,143	570.1	12
Logical Reads Per Sec twin ↗ row	987.9 k	127.0 k–292.7 k	+18.8σ	+18.8σ	▲ ×4.7	209.9 k	41.42 k	12
Database Wait Time Ratio ↗ row	57.83	33.79–38.65	+17.8σ	+17.8σ	▲ 59.7%	36.22	1.214	12
Database CPU Time Ratio twin ↗ row	42.17	61.23–66.33	−16.9σ	−16.9σ	▼ 33.9%	63.78	1.214	12
SQL Service Response Time ↗ row	0.3279	0.1458–0.2275		+6.9σ	▲ 75.7%	0.1866	0.02041	12
Average Active Sessions twin ↗ row	20.35	8.378–14.27		+6.1σ	▲ 79.7%	11.33	1.473	12
Average Synchronous Single-Block Read Latency ↗ row	0.603	0.4509–0.5122		+7.9σ	▲ 25.2%immaterial	0.4816	0.01533	12
Host CPU Utilization (%) ↗ row	71.45	46.18–76.01		+1.4σ	▲ 16.9%	61.10	7.458	12
User Commits Per Sec twin ↗ row	648.7	360.4–741.6		+1.0σ	▲ 17.7%	551.0	95.32	12
Redo Generated Per Sec twin ↗ row	3.992 M	2.760 M–4.451 M		+0.9σ	▲ 10.7%	3.606 M	422.9 k	12
Session Count ↗ row	2,095	1,855–2,195		+0.8σ	▲ 3.5%	2,025	85.01	12
User Rollbacks Per Sec twin ↗ row	3.730	1.839–4.758		+0.6σ	▲ 13.1%	3.298	0.7299	12
User Calls Per Sec twin ↗ row	6,208	5,499–6,621		+0.5σ	▲ 2.4%	6,060	280.5	12
Physical Writes Per Sec twin ↗ row	1,772	1,575–2,106		−0.5σ	▼ 3.7%	1,841	132.9	12
Physical Write Total Bytes Per Sec twin ↗ row	27.58 M	24.51 M–32.79 M		−0.5σ	▼ 3.7%	28.65 M	2.069 M	12
Physical Write Total IO Requests Per Sec ↗ row	974.6	866.1–1,159		−0.5σ	▼ 3.7%	1,012	73.12	12
Executions Per Sec twin ↗ row	9,274	6,838–10.76 k		+0.5σ	▲ 5.4%	8,800	980.9	12
Total Parse Count Per Sec twin ↗ row	661.1	493.5–772.4		+0.4σ	▲ 4.5%	632.9	69.73	12
Logons Per Sec twin ↗ row	3.925	3.308–4.346		+0.4σ	▲ 2.6%	3.827	0.2597	12
Hard Parse Count Per Sec twin ↗ row	2.714	0–22.70		−0.3σ	▼ 50.8%	5.512	8.593	12
Network Traffic Volume Per Sec twin ↗ row	11.77 M	10.46 M–12.87 M		+0.2σ	▲ 0.9%	11.67 M	604.0 k	12

▸ Show 15 normal / improved / flat rows

Wait classes

Metric	Current	Normal range	vs normal, in σ	z	Δ vs mean	Prior mean	Prior sd	n
Wait class: Network ↗ row	1.175	0.1947–0.2602	+57.9σ	+57.9σ	▲ ×5.2	0.2274	0.01637	12
Wait class: User I/O ↗ row	8.285	1.434–2.512	+23.4σ	+23.4σ	▲ ×4.2	1.973	0.2695	12
Wait class: Commit ↗ row	0.8687	0.5696–0.8484		+2.3σ	▲ 22.5%	0.709	0.06971	12
Wait class: Scheduler ↗ row	0.06615	0.02265–0.05121		+4.1σ	▲ 79.1%immaterial	0.03693	0.007139	12
Wait class: System I/O ↗ row	0.09801	0.03146–0.07943		+3.5σ	▲ 76.8%immaterial	0.05545	0.01199	12
Wait class: Other ↗ row	0.09899	0.0468–0.08754		+3.1σ	▲ 47.4%immaterial	0.06717	0.01018	12
Wait class: Configuration ↗ row	0.06598	0.02587–0.0597		+2.7σ	▲ 54.2%immaterial	0.04279	0.008457	12
Wait class: Application ↗ row	0.7118	0.4589–0.8569		+0.5σ	▲ 8.2%	0.6579	0.09949	12
Wait class: Concurrency ↗ row	0.401	0.02219–0.6373		+0.5σ	▲ 21.6%	0.3297	0.1538	12

▸ Show 6 normal / improved / flat rows

Checked and normal30 normalEvery other scored metric, against the same prior windows

DB CPUnormal 5.270–9.182 AAS

8.584 AAS▲ 18.8%

Host CPUnormal 46.18–76.01 %

71.45 %▲ 16.9%

Rowid fetchesnormal 195.7 k–238.4 k/s

204.5 k/s▼ 5.8%

Redo writesnormal 354.6–422.0/s

406.7/s▲ 4.7%

User commitsnormal 360.4–741.6/s

648.7/s▲ 17.7%

Parse failuresnormal 0.06444–0.195/s

0.1623/s▲ 25.1%

Redo generatednormal 2.760–4.451 MB/s

3.992 MB/s▲ 10.7%

Sessionsnormal 1,855–2,195 sessions

2,095 sessions▲ 3.5%

User rollbacksnormal 1.839–4.758/s

3.730/s▲ 13.1%

Application waitsnormal 0.4589–0.8569 AAS

0.7118 AAS▲ 8.2%

User callsnormal 5,499–6,621/s

6,208/s▲ 2.4%

Bytes from clientsnormal 1.873–2.369 MB/s

2.056 MB/s▼ 3.1%

Physical writesnormal 1,575–2,106/s

1,772/s▼ 3.7%

Write volumenormal 24.51–32.79 MB/s

27.58 MB/s▼ 3.7%

Write I/O requestsnormal 866.1–1,159/s

974.6/s▼ 3.7%

Executionsnormal 6,838–10.76 k/s

9,274/s▲ 5.4%

Cursors openednormal 4,240–6,672/s

5,750/s▲ 5.4%

Concurrency waitsnormal 0.02219–0.6373 AAS

0.401 AAS▲ 21.6%

and 7 more normal rows in the Findings tables (All sections).

Moved, too small to matter

Single-block read latencynormal 0.4509–0.5122 ms

0.603 ms▲ 25.2%

Scheduler waitsnormal 0.02265–0.05121 AAS

0.06615 AAS▲ 79.1%

System I/O waitsnormal 0.03146–0.07943 AAS

0.09801 AAS▲ 76.8%

Other waitsnormal 0.0468–0.08754 AAS

0.09899 AAS▲ 47.4%

Configuration waitsnormal 0.02587–0.0597 AAS

0.06598 AAS▲ 54.2%

Improved: none material

Nothing moved materially in the good direction.

Evidence libraryEvery other section, one line each; open a row to read it here

Aligned windowsOne bar per window; dimmed = skipped and left out of every baseline

Window	Window start	Window end	Begin snap	End snap	Status
Current	2026-09-10 Thu 09:00	2026-09-10 Thu 10:00	43433	43434	valid
−1w	2026-09-03 Thu 09:00	2026-09-03 Thu 10:00	43265	43266	valid
−2w	2026-08-27 Thu 09:00	2026-08-27 Thu 10:00	43097	43098	valid
−3w	2026-08-20 Thu 09:00	2026-08-20 Thu 10:00	42929	42930	valid
−4w	2026-08-13 Thu 09:00	2026-08-13 Thu 10:00	42761	42762	valid
−5w	2026-08-06 Thu 09:00	2026-08-06 Thu 10:00	42593	42594	valid
−6w	2026-07-30 Thu 09:00	2026-07-30 Thu 10:00	42425	42426	valid
−7w	2026-07-23 Thu 09:00	2026-07-23 Thu 10:00	42257	42258	valid
−8w	2026-07-16 Thu 09:00	2026-07-16 Thu 10:00	42089	42090	valid
−9w	2026-07-09 Thu 09:00	2026-07-09 Thu 10:00	41921	41922	valid
−10w	2026-07-02 Thu 09:00	2026-07-02 Thu 10:00	41753	41754	valid
−11w	2026-06-25 Thu 09:00	2026-06-25 Thu 10:00	41585	41586	valid
−12w	2026-06-18 Thu 09:00	2026-06-18 Thu 10:00	41417	41418	valid

Generate full AWR reports for these windows

Paste into SQL*Plus for one standard AWR report per window (Diagnostic Pack). Skipped windows are commented out.

-- AWR reports for the compared windows -- generated by awr_timeline_comparison.
-- Run as a user with EXECUTE on DBMS_WORKLOAD_REPOSITORY (Diagnostic Pack).
SET PAGESIZE 0 LINESIZE 1500 LONG 1000000 LONGCHUNKSIZE 1000000
SET TRIMSPOOL ON HEADING OFF FEEDBACK OFF VERIFY OFF ECHO OFF

-- current: 2026-09-10 09:00 -> 2026-09-10 10:00  (dbid 1483726519, snaps 43433 -> 43434)
SPOOL awr_1483726519_all_43433_43434.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 43433, 43434));
SPOOL OFF

-- -1w: 2026-09-03 09:00 -> 2026-09-03 10:00  (dbid 1483726519, snaps 43265 -> 43266)
SPOOL awr_1483726519_all_43265_43266.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 43265, 43266));
SPOOL OFF

-- -2w: 2026-08-27 09:00 -> 2026-08-27 10:00  (dbid 1483726519, snaps 43097 -> 43098)
SPOOL awr_1483726519_all_43097_43098.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 43097, 43098));
SPOOL OFF

-- -3w: 2026-08-20 09:00 -> 2026-08-20 10:00  (dbid 1483726519, snaps 42929 -> 42930)
SPOOL awr_1483726519_all_42929_42930.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 42929, 42930));
SPOOL OFF

-- -4w: 2026-08-13 09:00 -> 2026-08-13 10:00  (dbid 1483726519, snaps 42761 -> 42762)
SPOOL awr_1483726519_all_42761_42762.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 42761, 42762));
SPOOL OFF

-- -5w: 2026-08-06 09:00 -> 2026-08-06 10:00  (dbid 1483726519, snaps 42593 -> 42594)
SPOOL awr_1483726519_all_42593_42594.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 42593, 42594));
SPOOL OFF

-- -6w: 2026-07-30 09:00 -> 2026-07-30 10:00  (dbid 1483726519, snaps 42425 -> 42426)
SPOOL awr_1483726519_all_42425_42426.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 42425, 42426));
SPOOL OFF

-- -7w: 2026-07-23 09:00 -> 2026-07-23 10:00  (dbid 1483726519, snaps 42257 -> 42258)
SPOOL awr_1483726519_all_42257_42258.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 42257, 42258));
SPOOL OFF

-- -8w: 2026-07-16 09:00 -> 2026-07-16 10:00  (dbid 1483726519, snaps 42089 -> 42090)
SPOOL awr_1483726519_all_42089_42090.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 42089, 42090));
SPOOL OFF

-- -9w: 2026-07-09 09:00 -> 2026-07-09 10:00  (dbid 1483726519, snaps 41921 -> 41922)
SPOOL awr_1483726519_all_41921_41922.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 41921, 41922));
SPOOL OFF

-- -10w: 2026-07-02 09:00 -> 2026-07-02 10:00  (dbid 1483726519, snaps 41753 -> 41754)
SPOOL awr_1483726519_all_41753_41754.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 41753, 41754));
SPOOL OFF

-- -11w: 2026-06-25 09:00 -> 2026-06-25 10:00  (dbid 1483726519, snaps 41585 -> 41586)
SPOOL awr_1483726519_all_41585_41586.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 41585, 41586));
SPOOL OFF

-- -12w: 2026-06-18 09:00 -> 2026-06-18 10:00  (dbid 1483726519, snaps 41417 -> 41418)
SPOOL awr_1483726519_all_41417_41418.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1483726519, NULL, 41417, 41418));
SPOOL OFF

Day profile2 day-wide shifts 6 isolated hours 24 of 24 hours flaggedEach hour of the 24 h ending Thu 2026-09-10 10:00 vs the same hour on the 7 prior days (2026-09-02 → 2026-09-09)

Day-wide shift	Direction	Hours flagged	Median z
logical reads/s	▲ above the prior days	24 of 24	+9.9
physical reads/s	▲ above the prior days	23 of 24	+26.2

Current day (teal) vs prior-day mean (dashed) with the μ ± 2σ band; faint lines are the individual prior days. Arrow keys switch the metric; so does a row label of the heatmap.

Hour	DB time (avg active sessions)	DB CPU (avg CPUs busy)	user calls/s	executions/s	logical reads/s	physical reads/s	physical writes/s	redo bytes/s	commits/s
2026-09-09 10:00	23.93 +4.6σ	9.72	7,156	11,180	1,206,410 +19.3σ	28,062 +36.9σ	2,167	4,565,339	729.71
2026-09-09 11:00	22.51 +3.8σ	9.27	6,873	10,457	1,121,081 +16.7σ	24,804 +34.5σ	1,958	4,226,495	696.15
2026-09-09 12:00	22.48 +4.3σ	9.22	6,718	10,385	1,174,889 +18.2σ	27,114 +31.1σ	2,095	4,388,216	687.20
2026-09-09 13:00	21.74 +4.1σ	8.88	6,449	10,190	1,153,103 +20.3σ	25,859 +34.1σ	1,921	4,113,136	649.27
2026-09-09 14:00	23.90 +3.9σ	9.72	7,002	11,041	1,250,251 +17.0σ	26,820 +27.3σ	2,134	4,443,671	686.13
2026-09-09 15:00	20.54 +3.2σ	8.47	6,463	9,718	1,039,451 +16.4σ	23,925 +35.1σ	2,080	4,052,793	647.65
2026-09-09 16:00	19.55	8.05	5,757	9,201	975,643 +15.7σ	21,315 +26.2σ	1,868	3,763,986	585.08
2026-09-09 17:00	17.60	7.35	5,140	8,134	886,700 +16.4σ	20,742 +37.9σ	1,603	3,414,946	528.22
2026-09-09 18:00	16.59	6.88	5,177	7,898	820,661 +19.4σ	19,272 +36.2σ	1,459	3,200,845	528.14
2026-09-09 19:00	14.67	5.98	4,378	6,686	787,931 +24.5σ	17,225 +37.7σ	1,351	2,837,670	433.23
2026-09-09 20:00	14.76	6.22	4,472	6,943	753,960 +22.8σ	17,658 +53.4σ	1,329	2,738,293	445.61
2026-09-09 21:00	11.23	4.71	3,391	5,152	577,625 +24.2σ	13,428 +47.6σ	1,023	2,105,370	355.39
2026-09-09 22:00	10.92	4.66	2,940	4,828	553,641 +4.1σ	16,038 +3.0σ	954	1,956,412	307.37
2026-09-09 23:00	9.03	3.84	2,704	4,209	452,867 +2.1σ	10,189 +2.0σ	808	1,675,770	277.59
2026-09-10 00:00	7.81	3.22	2,276	3,712	423,062 +2.4σ	10,800 +2.3σ	687	1,467,853	240.89
2026-09-10 01:00	9.47	4.03	2,093	3,151	426,367 +2.4σ	11,732 +2.5σ	3,301	6,687,605	246.07
2026-09-10 02:00	9.37	4.03	1,963	3,113	395,211 +2.3σ	10,647	3,380	6,590,761	240.55
2026-09-10 03:00	8.38	3.54	2,195	3,507	413,095 +2.6σ	10,076 +2.7σ	1,531	3,391,856	260.27
2026-09-10 04:00	7.89	3.31	2,232	3,575	416,753 +3.0σ	10,813 +3.3σ	653	1,450,691	231.88
2026-09-10 05:00	8.92	3.70	2,587	4,088	446,179 +2.3σ	10,899 +2.3σ	748	1,756,451	281.30
2026-09-10 06:00	11.74	4.79	3,235	5,046	594,227 +2.7σ	19,038 +2.7σ	992	1,957,084	364.88
2026-09-10 07:00	14.73	6.12	4,367	6,732	754,419 +2.1σ	17,288 +2.1σ	1,239	2,782,960	448.35
2026-09-10 08:00	17.76	7.26	5,448	8,287	932,026 +2.2σ	20,524 +2.2σ	1,655	3,644,176	574.37
2026-09-10 09:00	20.35	8.58	6,208	9,274	987,894 +2.3σ	22,241 +2.2σ	1,772	3,992,353	648.73

UtilizationHow the applications use this database; a usage overview, not scored

Transactions and SQL activity

Metric	Unit	Current	Normal range	z	Δ vs mean	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
Transactions / s	Transactions Per Second	652.5	362.3–746.2	+1.0σ	▲ 17.7%	696.0	689.2	681.0	662.2	523.7	491.7	504.4	489.7	482.9	454.4	487.4	488.8
Commits / s	Commits Per Second	648.7	360.4–741.6	+1.0σ	▲ 17.7%	692.2	685.1	676.6	657.6	521.0	488.9	501.4	487.3	479.9	451.8	484.2	485.9
Rollbacks / s	Rollbacks Per Second	3.730	1.839–4.758	+0.6σ	▲ 13.1%	3.807	4.165	4.354	4.556	2.685	2.804	3.010	2.453	2.948	2.611	3.263	2.925
SQL executions / s	Executes Per Second	9,274	6,838–10.76 k	+0.5σ	▲ 5.4%	9,979	10.46 k	9,865	10.05 k	8,480	8,046	8,434	8,059	8,283	7,768	8,183	7,987
User calls / s	Calls Per Second	6,208	5,499–6,621	+0.5σ	▲ 2.4%	6,310	6,329	6,344	6,604	6,069	5,902	5,878	6,019	5,947	5,637	5,890	5,788
Parses (total) / s	Parses Per Second	661.1	493.5–772.4	+0.4σ	▲ 4.5%	730.3	744.7	708.9	716.4	570.7	583.9	596.4	614.7	600.1	575.9	584.8	568.1
Cursors opened / s	Cursors Per Second	5,750	4,240–6,672	+0.5σ	▲ 5.4%	6,187	6,486	6,116	6,233	5,258	4,989	5,229	4,996	5,136	4,816	5,074	4,952

Connections and sessions

Metric	Unit	Current	Normal range	z	Δ vs mean	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
Logons / s	Logons Per Second	3.925	3.308–4.346	+0.4σ	▲ 2.6%	3.953	4.024	4.263	4.130	3.810	3.509	3.956	3.780	3.801	3.382	3.538	3.775
Sessions	Sessions	2,095	1,855–2,195	+0.8σ	▲ 3.5%	2,136	2,151	2,111	2,156	1,985	1,953	1,984	1,967	1,965	1,951	1,977	1,964
Logged-on users	Logons	1,948	1,725–2,041	+0.8σ	▲ 3.5%	1,986	2,000	1,963	2,005	1,846	1,816	1,845	1,829	1,827	1,815	1,838	1,827
Open cursors	Cursors	29.75 k	26.34 k–31.17 k	+0.8σ	▲ 3.5%	30.33 k	30.54 k	29.97 k	30.62 k	28.19 k	27.73 k	28.18 k	27.93 k	27.90 k	27.71 k	28.07 k	27.89 k

Data and network volume

Metric	Unit	Current	Normal range	vs normal, in σ	z	Δ vs mean	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
Logical reads / s	Reads Per Second	987.9 k	127.0 k–292.7 k	+18.8σ	+18.8σ	▲ ×4.7	269.9 k	276.0 k	254.9 k	259.6 k	186.3 k	186.3 k	186.1 k	180.7 k	178.9 k	169.0 k	181.2 k	189.4 k
Physical reads / s	Reads Per Second	22.24 k	3,003–5,284	+31.7σ	+31.7σ	▲ ×5.4	4,869	4,810	5,072	4,851	3,768	3,687	3,527	3,867	3,774	3,891	3,767	3,837
Physical writes / s	Writes Per Second	1,772	1,575–2,106		−0.5σ	▼ 3.7%	1,834	1,848	1,959	2,059	1,972	1,800	1,822	1,663	1,959	1,689	1,853	1,629
Block changes / s	Blocks Per Second	24.80 k	21.19 k–26.87 k		+0.5σ	▲ 3.2%	25.59 k	25.43 k	25.58 k	26.34 k	22.43 k	23.06 k	24.09 k	22.37 k	23.49 k	22.43 k	24.41 k	23.12 k
Redo bytes / s	Bytes Per Second	3.992 M	2.760 M–4.451 M		+0.9σ	▲ 10.7%	4.091 M	4.257 M	4.145 M	4.142 M	3.419 M	3.117 M	3.463 M	3.263 M	3.371 M	3.195 M	3.474 M	3.329 M
I/O MB / s	Megabtyes per Second	214.3	52.65–77.49	+24.0σ	+24.0σ	▲ ×3.3	71.45	71.33	75.04	74.68	63.73	60.22	59.55	59.82	63.54	60.33	62.02	59.13
Network bytes / s	Bytes Per Second	11.77 M	10.46 M–12.87 M		+0.2σ	▲ 0.9%	12.55 M	12.44 M	12.22 M	11.86 M	11.78 M	10.75 M	11.57 M	11.28 M	11.27 M	10.64 M	11.89 M	11.74 M

Load profileSystem statistics per second, Current against its normal range

Metric	Unit	Current	Normal range	vs normal, in σ	z	Δ vs mean	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
DB time	cs/s	2,035	837.8–1,427		+6.1σ	▲ 79.7%	1,308	1,276	1,326	1,307	1,023	1,012	1,033	1,025	1,002	1,274	992.4	1,011
DB CPU	cs/s	858.4	527.0–918.2		+1.4σ	▲ 18.8%	854.9	832.5	861.6	830.2	653.1	642.6	659.1	650.6	633.2	773.4	633.6	646.4
redo size	bytes/s	3.992 M	2.760 M–4.451 M		+0.9σ	▲ 10.7%	4.091 M	4.257 M	4.145 M	4.142 M	3.419 M	3.117 M	3.463 M	3.263 M	3.371 M	3.195 M	3.474 M	3.329 M
session logical reads	/s	987.9 k	127.0 k–292.7 k	+18.8σ	+18.8σ	▲ ×4.7	269.9 k	276.0 k	254.9 k	259.6 k	186.3 k	186.3 k	186.1 k	180.7 k	178.9 k	169.0 k	181.2 k	189.4 k
physical reads	/s	22.24 k	3,003–5,284	+31.7σ	+31.7σ	▲ ×5.4	4,869	4,810	5,072	4,851	3,768	3,687	3,527	3,867	3,774	3,891	3,767	3,837
physical read total bytes	bytes/s	193.1 M	26.08 M–45.88 M	+31.7σ	+31.7σ	▲ ×5.4	42.28 M	41.77 M	44.05 M	42.12 M	32.72 M	32.02 M	30.62 M	33.58 M	32.77 M	33.78 M	32.71 M	33.32 M
physical writes	/s	1,772	1,575–2,106		−0.5σ	▼ 3.7%	1,834	1,848	1,959	2,059	1,972	1,800	1,822	1,663	1,959	1,689	1,853	1,629
physical write total bytes	bytes/s	27.58 M	24.51 M–32.79 M		−0.5σ	▼ 3.7%	28.55 M	28.77 M	30.50 M	32.04 M	30.69 M	28.01 M	28.36 M	25.89 M	30.49 M	26.28 M	28.84 M	25.35 M
user calls	/s	6,208	5,499–6,621		+0.5σ	▲ 2.4%	6,310	6,329	6,344	6,604	6,069	5,902	5,878	6,019	5,947	5,637	5,890	5,788
execute count	/s	9,274	6,838–10.76 k		+0.5σ	▲ 5.4%	9,979	10.46 k	9,865	10.05 k	8,480	8,046	8,434	8,059	8,283	7,768	8,183	7,987
user commits	/s	648.7	360.4–741.6		+1.0σ	▲ 17.7%	692.2	685.1	676.6	657.6	521.0	488.9	501.4	487.3	479.9	451.8	484.2	485.9
user rollbacks	/s	3.730	1.839–4.758		+0.6σ	▲ 13.1%	3.807	4.165	4.354	4.556	2.685	2.804	3.010	2.453	2.948	2.611	3.263	2.925
parse count (total)	/s	661.1	493.5–772.4		+0.4σ	▲ 4.5%	730.3	744.7	708.9	716.4	570.7	583.9	596.4	614.7	600.1	575.9	584.8	568.1
parse count (hard)	/s	2.714	0–22.70		−0.3σ	▼ 50.8%	2.728	3.015	3.080	3.046	3.299	2.602	2.982	3.011	3.458	32.79	3.258	2.875
parse count (failures)	/s	0.1623	0.06444–0.195		+1.0σ	▲ 25.1%	0.1545	0.2025	0.1485	0.1136	0.1218	0.1372	0.1332	0.06849	0.14	0.1264	0.1068	0.1037
logons cumulative	/s	3.925	3.308–4.346		+0.4σ	▲ 2.6%	3.953	4.024	4.263	4.130	3.810	3.509	3.956	3.780	3.801	3.382	3.538	3.775
opened cursors cumulative	/s	5,750	4,240–6,672		+0.5σ	▲ 5.4%	6,187	6,486	6,116	6,233	5,258	4,989	5,229	4,996	5,136	4,816	5,074	4,952
redo writes	/s	406.7	354.6–422.0		+1.1σ	▲ 4.7%	393.4	406.4	391.1	413.1	388.8	379.4	395.2	379.6	399.5	346.4	380.4	386.4
sorts (memory)	/s	2,090	1,877–2,369		−0.3σ	▼ 1.5%	2,199	2,257	2,163	2,313	2,163	2,151	2,068	2,111	2,009	1,842	2,154	2,044
sorts (disk)	/s	0.3926	0.3026–0.5194		−0.3σ	▼ 4.5%	0.4052	0.4174	0.3323	0.4734	0.4781	0.4486	0.4524	0.3559	0.4062	0.3428	0.4682	0.3516
sorts (rows)	/s	1.453 M	1.294 M–1.552 M		+0.5σ	▲ 2.1%	1.409 M	1.469 M	1.496 M	1.573 M	1.406 M	1.389 M	1.320 M	1.406 M	1.419 M	1.372 M	1.416 M	1.399 M
table scans (long tables)	/s	61.69	1.846–2.310	>+99σ	>+99σ	▲ ×29.7	2.176	2.317	1.986	2.100	2.201	1.971	1.930	2.029	1.982	1.994	2.104	2.143
table fetch by rowid	/s	204.5 k	195.7 k–238.4 k		−1.2σ	▼ 5.8%	225.5 k	228.8 k	230.4 k	235.0 k	213.7 k	211.4 k	210.3 k	209.6 k	218.7 k	201.8 k	214.7 k	204.7 k
CPU used by this session	cs/s	845.5	519.1–904.4		+1.4σ	▲ 18.8%	842.0	820.0	848.7	817.7	643.3	633.0	649.2	640.9	623.7	761.8	624.1	636.7
bytes received via SQL*Net from client	bytes/s	2.056 M	1.873 M–2.369 M		−0.5σ	▼ 3.1%	2.283 M	2.179 M	2.247 M	2.350 M	2.112 M	2.036 M	2.150 M	2.062 M	2.070 M	1.952 M	2.029 M	1.980 M
bytes sent via SQL*Net to client	bytes/s	9.711 M	8.489 M–10.60 M		+0.3σ	▲ 1.8%	10.27 M	10.26 M	9.971 M	9.505 M	9.668 M	8.711 M	9.422 M	9.219 M	9.195 M	8.686 M	9.856 M	9.765 M
redo size for lost write detection	/s	0	0–0	flat, σ = 0	—	—σ≈0	0	0	0	0	0	0	0	0	0	0	0	0

System metricsSYSMETRIC averages per window, Current against its normal range

Metric	Unit	Current	Normal range	vs normal, in σ	z	Δ vs mean	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
Average Active Sessions	Sessions	20.35	8.378–14.27		+6.1σ	▲ 79.7%	13.08	12.76	13.26	13.07	10.23	10.12	10.33	10.25	10.02	12.74	9.924	10.11
Host CPU Utilization (%)	% Busy/(Idle+Busy)	71.45	46.18–76.01		+1.4σ	▲ 16.9%	71.18	69.48	71.70	69.30	55.80	55.00	56.26	55.61	54.28	64.97	54.31	55.29
Database CPU Time Ratio	% Cpu/DB_Time	42.17	61.23–66.33	−16.9σ	−16.9σ	▼ 33.9%	65.35	65.23	64.97	63.54	63.85	63.49	63.80	63.50	63.17	60.68	63.85	63.93
Database Wait Time Ratio	% Wait/DB_Time	57.83	33.79–38.65	+17.8σ	+17.8σ	▲ 59.7%	34.65	34.77	35.03	36.46	36.15	36.51	36.20	36.50	36.83	39.32	36.15	36.07
Session Count	Sessions	2,095	1,855–2,195		+0.8σ	▲ 3.5%	2,136	2,151	2,111	2,156	1,985	1,953	1,984	1,967	1,965	1,951	1,977	1,964
Redo Generated Per Sec	Bytes Per Second	3.992 M	2.760 M–4.451 M		+0.9σ	▲ 10.7%	4.091 M	4.257 M	4.145 M	4.142 M	3.419 M	3.117 M	3.463 M	3.263 M	3.371 M	3.195 M	3.474 M	3.329 M
Physical Read Total Bytes Per Sec	Bytes Per Second	193.1 M	26.08 M–45.88 M	+31.7σ	+31.7σ	▲ ×5.4	42.28 M	41.77 M	44.05 M	42.12 M	32.72 M	32.02 M	30.62 M	33.58 M	32.77 M	33.78 M	32.71 M	33.32 M
Physical Write Total Bytes Per Sec	Bytes Per Second	27.58 M	24.51 M–32.79 M		−0.5σ	▼ 3.7%	28.55 M	28.77 M	30.50 M	32.04 M	30.69 M	28.01 M	28.36 M	25.89 M	30.49 M	26.28 M	28.84 M	25.35 M
Physical Read Total IO Requests Per Sec	Requests Per Second	16.01 k	2,162–3,804	+31.7σ	+31.7σ	▲ ×5.4	3,506	3,463	3,652	3,493	2,713	2,655	2,539	2,784	2,717	2,801	2,712	2,763
Physical Write Total IO Requests Per Sec	Requests Per Second	974.6	866.1–1,159		−0.5σ	▼ 3.7%	1,009	1,017	1,078	1,132	1,085	989.8	1,002	914.9	1,077	928.8	1,019	895.9
Average Synchronous Single-Block Read Latency	Milliseconds	0.603	0.4509–0.5122		+7.9σ	▲ 25.2%immaterial	0.4993	0.4577	0.4977	0.4829	0.472	0.4734	0.5046	0.4552	0.4837	0.4792	0.4871	0.486
Logical Reads Per Sec	Reads Per Second	987.9 k	127.0 k–292.7 k	+18.8σ	+18.8σ	▲ ×4.7	269.9 k	276.0 k	254.9 k	259.6 k	186.3 k	186.3 k	186.1 k	180.7 k	178.9 k	169.0 k	181.2 k	189.4 k
Executions Per Sec	Executes Per Second	9,274	6,838–10.76 k		+0.5σ	▲ 5.4%	9,979	10.46 k	9,865	10.05 k	8,480	8,046	8,434	8,059	8,283	7,768	8,183	7,987
User Calls Per Sec	Calls Per Second	6,208	5,499–6,621		+0.5σ	▲ 2.4%	6,310	6,329	6,344	6,604	6,069	5,902	5,878	6,019	5,947	5,637	5,890	5,788
User Commits Per Sec	Commits Per Second	648.7	360.4–741.6		+1.0σ	▲ 17.7%	692.2	685.1	676.6	657.6	521.0	488.9	501.4	487.3	479.9	451.8	484.2	485.9
User Rollbacks Per Sec	Rollbacks Per Second	3.730	1.839–4.758		+0.6σ	▲ 13.1%	3.807	4.165	4.354	4.556	2.685	2.804	3.010	2.453	2.948	2.611	3.263	2.925
Hard Parse Count Per Sec	Parses Per Second	2.714	0–22.70		−0.3σ	▼ 50.8%	2.728	3.015	3.080	3.046	3.299	2.602	2.982	3.011	3.458	32.79	3.258	2.875
Total Parse Count Per Sec	Parses Per Second	661.1	493.5–772.4		+0.4σ	▲ 4.5%	730.3	744.7	708.9	716.4	570.7	583.9	596.4	614.7	600.1	575.9	584.8	568.1
Logons Per Sec	Logons Per Second	3.925	3.308–4.346		+0.4σ	▲ 2.6%	3.953	4.024	4.263	4.130	3.810	3.509	3.956	3.780	3.801	3.382	3.538	3.775
Network Traffic Volume Per Sec	Bytes Per Second	11.77 M	10.46 M–12.87 M		+0.2σ	▲ 0.9%	12.55 M	12.44 M	12.22 M	11.86 M	11.78 M	10.75 M	11.57 M	11.28 M	11.27 M	10.64 M	11.89 M	11.74 M
SQL Service Response Time	CentiSeconds Per Call	0.3279	0.1458–0.2275		+6.9σ	▲ 75.7%	0.2073	0.2017	0.2091	0.1979	0.1685	0.1715	0.1757	0.1702	0.1686	0.2261	0.1685	0.1747
Physical Reads Per Sec	Reads Per Second	22.24 k	3,003–5,284	+31.7σ	+31.7σ	▲ ×5.4	4,869	4,810	5,072	4,851	3,768	3,687	3,527	3,867	3,774	3,891	3,767	3,837
Physical Writes Per Sec	Writes Per Second	1,772	1,575–2,106		−0.5σ	▼ 3.7%	1,834	1,848	1,959	2,059	1,972	1,800	1,822	1,663	1,959	1,689	1,853	1,629

Foreground waitsWhere foreground sessions waited: top 10 events by time and by average wait, and the wait classes

Top 10 events — time waited (s)

Event	Current (s)	Normal range	vs normal, in σ	z	Δ vs mean	−1w (s)	−2w (s)	−3w (s)	−4w (s)	−5w (s)	−6w (s)	−7w (s)	−8w (s)	−9w (s)	−10w (s)	−11w (s)	−12w (s)
db file scattered read	13.87 k #1	506.0–843.5	>+99σ	>+99σ	▲ ×20.6	686.3 #6	722.1 #6	691.9 #6	673.2 #6	591.2 #6	634.1 #6	660.4 #5	606.2 #5	680.8 #5	905.3 #6	580.9 #6	665.1 #5
direct path read	8,482 #2	437.3–978.6	+57.4σ	+57.4σ	▲ ×12.0	797.6 #5	723.4 #5	824.7 #4	797.3 #5	616.5 #5	707.2 #4	626.0 #6	565.6 #6	556.2 #6	1,024 #4	613.0 #5	643.6 #6
db file sequential read	6,363 #3	3,683–6,610		+1.7σ	▲ 23.6%	6,019 #1	5,913 #1	6,488 #1	5,795 #1	4,835 #1	4,485 #1	4,620 #1	4,563 #1	4,574 #1	5,413 #1	4,536 #1	4,518 #1
SQL*Net more data to client	4,126 #4	652.7–849.9	+68.5σ	+68.5σ	▲ ×5.5	820.2 #4	795.0 #4	820.7 #5	810.8 #4	694.1 #4	705.4 #5	748.5 #4	724.5 #4	709.6 #4	768.6 #7	705.0 #4	713.4 #4
log file sync	3,127 #5	2,050–3,054		+2.3σ	▲ 22.5%	2,816 #2	2,792 #2	2,718 #2	2,988 #3	2,258 #2	2,509 #2	2,258 #3	2,447 #2	2,397 #2	2,731 #2	2,233 #3	2,480 #2
enq: TX - row lock contention	2,503 #6	1,615–3,041		+0.5σ	▲ 7.5%	2,467 #3	2,337 #3	2,290 #3	3,351 #2	2,125 #3	2,084 #3	2,278 #2	2,376 #3	2,282 #3	2,236 #3	2,234 #2	1,875 #3
buffer busy waits	605.4 #7	392.8–593.3		+2.2σ	▲ 22.8%immaterial	556.6 #7	542.2 #7	579.7 #7	532.8 #7	454.3 #7	482.9 #7	471.9 #7	452.1 #7	431.0 #7	509.0 #9	431.0 #7	472.9 #7
db file parallel read	477.0 #8	130.0–325.1		+5.1σ	▲ ×2.1immaterial	225.9 #10	271.6 #8	254.8 #9	278.1 #8	197.6 #8	186.8 #8	213.6 #9	180.6 #8	193.0 #8	338.3 #10	180.7 #8	209.7 #8
control file sequential read	352.8 #9	113.3–286.0		+3.5σ	▲ 76.8%immaterial	180.5	199.5	221.7	220.9	159.5	169.1	218.9 #8	178.5 #9	190.4 #9	316.4	157.0	183.0 #10
latch: cache buffers chains	322.4 #10	108.1–289.4		+2.7σ	▲ 62.2%immaterial	261.9 #8	241.7 #9	259.8 #8	254.4 #9	170.2 #10	156.1	173.8	158.2	146.0	220.4	159.6 #10	183.2 #9
library cache: mutex X	122.3	0–661.1		−0.1σ	▼ 18.1%	87.18	81.23	90.24	95.13	66.80	69.14	62.29	74.37	67.28	961.2 #5	64.48	72.20
cursor: pin S wait on X	81.37	0–447.9		−0.1σ	▼ 17.4%	64.83	52.50	61.07	49.84	46.48	42.59	40.14	38.08	44.68	652.7 #8	41.58	47.52
direct path read temp	304.3	115.5–250.1		+3.6σ	▲ 66.4%immaterial	207.2	204.0	236.5 #10	195.1	167.8	172.2 #9	153.1	165.5	147.0	242.8	149.7	153.2
enq: TX - index contention	266.4	137.8–255.2		+2.4σ	▲ 35.6%immaterial	229.2 #9	231.3 #10	231.5	241.3 #10	173.0 #9	171.7 #10	176.5 #10	170.9 #10	166.3 #10	209.2	175.4 #9	181.6

Top 10 events — avg time per wait (ms)

Event	Current (ms)	Normal range	z	Δ vs mean	−1w (ms)	−2w (ms)	−3w (ms)	−4w (ms)	−5w (ms)	−6w (ms)	−7w (ms)	−8w (ms)	−9w (ms)	−10w (ms)	−11w (ms)	−12w (ms)
db file scattered read	1.642	1.290–1.475	+5.6σ	▲ 18.8%	1.353	1.456	1.353	1.282	1.402	1.344	1.390	1.393	1.423	1.379	1.380	1.434
direct path read	0.9765	0.8484–1.029	+0.8σ	▲ 4.0%	0.8309	0.9553	0.9716	0.8909	0.9382	0.9553	0.9139	0.9489	0.9255	0.9624	0.9609	1.008
db file sequential read	0.603	0.4509–0.5122	+7.9σ	▲ 25.2%	0.4993	0.4577	0.4977	0.4829	0.472	0.4734	0.5046	0.4552	0.4837	0.4792	0.4871	0.486
SQL*Net more data to client	0.04512	0.04225–0.04717	+0.3σ	▲ 0.9%	0.04539	0.04525	0.04338	0.04685	0.04494	0.04317	0.04372	0.04265	0.04509	0.04503	0.04591	0.04511
log file sync	1.918	1.703–2.101	+0.2σ	▲ 0.9%	2.019	1.921	1.831	1.976	1.804	1.712	1.969	1.854	1.805	1.971	2.034	1.928
enq: TX - row lock contention	43.85	43.58–53.67	−1.9σ	▼ 9.8%	48.92	46.69	46.49	55.76	50.59	48.23	47.05	47.99	47.14	47.36	48.55	48.70
buffer busy waits	1.073	1.031–1.196	−1.0σ	▼ 3.7%	1.121	1.085	1.103	1.024	1.095	1.164	1.138	1.149	1.179	1.102	1.107	1.097
db file parallel read	2.671	2.420–2.760	+1.0σ	▲ 3.1%	2.639	2.683	2.643	2.744	2.553	2.646	2.487	2.607	2.535	2.466	2.579	2.502
control file sequential read	0.1957	0.2003–0.2236	−2.8σ	▼ 7.7%immaterial	0.2172	0.2172	0.2079	0.2153	0.2119	0.2155	0.2014	0.207	0.2199	0.206	0.2072	0.2167
latch: cache buffers chains	0.06471	0.0575–0.06495	+1.9σ	▲ 5.7%	0.0599	0.06039	0.06004	0.06061	0.06234	0.06551	0.0629	0.06084	0.05858	0.05954	0.06165	0.06239
library cache: mutex X	0.247	0.2366–0.2585	−0.1σ	▼ 0.2%	0.2485	0.2466	0.2415	0.2483	0.2573	0.2505	0.247	0.2451	0.2566	0.2448	0.2381	0.2461
cursor: pin S wait on X	3.226	2.993–3.361	+0.5σ	▲ 1.5%	3.244	3.215	3.200	3.145	3.217	3.210	3.127	3.221	3.291	3.045	2.968	3.240
direct path read temp	0.724	0.6482–0.7627	+0.6σ	▲ 2.6%	0.7031	0.7345	0.6715	0.7534	0.6623	0.6883	0.6973	0.707	0.7221	0.6744	0.7403	0.7109
enq: TX - index contention	6.087	5.608–6.378	+0.5σ	▲ 1.6%	5.889	5.913	6.106	5.929	6.209	6.243	5.822	6.205	6.087	5.781	6.099	5.639

Wait-class rollup — time waited (s)

Wait class	Current (s)	Normal range	vs normal, in σ	z	Δ vs mean	−1w (s)	−2w (s)	−3w (s)	−4w (s)	−5w (s)	−6w (s)	−7w (s)	−8w (s)	−9w (s)	−10w (s)	−11w (s)	−12w (s)
User I/O	29.83 k	5,161–9,042	+23.4σ	+23.4σ	▲ ×4.2	8,115	7,989	8,681	7,899	6,562	6,327	6,406	6,215	6,291	8,198	6,201	6,339
Network	4,230	700.9–936.7	+57.9σ	+57.9σ	▲ ×5.2	895.2	866.2	906.5	879.1	750.0	762.6	814.1	790.1	770.9	861.5	758.2	771.3
Commit	3,127	2,050–3,054		+2.3σ	▲ 22.5%	2,816	2,792	2,718	2,988	2,258	2,509	2,258	2,447	2,397	2,731	2,233	2,480
Application	2,562	1,652–3,085		+0.5σ	▲ 8.2%	2,512	2,382	2,336	3,393	2,161	2,121	2,313	2,411	2,320	2,303	2,259	1,909
Concurrency	1,444	79.89–2,294		+0.5σ	▲ 21.6%	1,227	1,178	1,248	1,207	933.1	949.2	949.4	918.6	877.1	2,887	890.9	978.8
Other	356.4	168.5–315.1		+3.1σ	▲ 47.4%immaterial	253.2	261.5	287.7	261.1	226.1	218.6	233.6	230.5	199.5	318.8	190.4	220.7
System I/O	352.8	113.3–286.0		+3.5σ	▲ 76.8%immaterial	180.5	199.5	221.7	220.9	159.5	169.1	218.9	178.5	190.4	316.4	157.0	183.0
Scheduler	238.1	81.54–184.3		+4.1σ	▲ 79.1%immaterial	155.4	146.3	163.7	147.3	107.7	110.0	132.6	127.6	116.6	180.2	98.59	109.3
Configuration	237.5	93.14–214.9		+2.7σ	▲ 54.2%immaterial	161.4	159.5	161.7	156.1	152.4	136.6	135.3	147.1	130.2	242.4	127.1	138.6

Background waitsWhere background processes waited, by time and by average wait

Events — time waited (s)

Table-wide shift: 8 of 11 events moved together (▲ 63% ± 0 points) — one throughput-style change, not 8 separate findings. Large rows are demoted to moderate.

Event	Current (s)	Normal range	z	Δ vs mean	−1w (s)	−2w (s)	−3w (s)	−4w (s)	−5w (s)	−6w (s)	−7w (s)	−8w (s)	−9w (s)	−10w (s)	−11w (s)	−12w (s)
db file parallel write	1,127 #1	525.6–858.0	+5.2σ	▲ 62.8%table-wide shift	773.1 #1	781.2 #1	806.5 #1	719.5 #1	592.7 #1	677.1 #1	615.3 #1	635.1 #1	629.5 #1	818.3 #1	627.1 #1	626.1 #1
log file parallel write	976.3 #2	455.5–743.6	+5.2σ	▲ 62.8%table-wide shift	670.0 #2	677.0 #2	699.0 #2	623.6 #2	513.7 #2	586.9 #2	533.3 #2	550.5 #2	545.6 #2	709.2 #2	543.5 #2	542.6 #2
db file async I/O submit	375.5 #3	175.2–286.0	+5.2σ	▲ 62.8%table-wide shift	257.7 #3	260.4 #3	268.8 #3	239.8 #3	197.6 #3	225.7 #3	205.1 #3	211.7 #3	209.8 #3	272.8 #3	209.0 #3	208.7 #3
control file parallel write	225.3 #4	105.1–171.6	+5.2σ	▲ 62.8%table-wide shift	154.6 #4	156.2 #4	161.3 #4	143.9 #4	118.5 #4	135.4 #4	123.1 #4	127.0 #4	125.9 #4	163.7 #4	125.4 #4	125.2 #4
log file sequential read	187.8 #5	87.60–143.0	+5.2σ	▲ 62.8%table-wide shift	128.9 #5	130.2 #5	134.4 #5	119.9 #5	98.79 #5	112.9 #5	102.6 #5	105.9 #5	104.9 #5	136.4 #5	104.5 #5	104.3 #5
direct path write	187.8 #5	87.60–143.0	+5.2σ	▲ 62.8%table-wide shift	128.9 #5	130.2 #5	134.4 #5	119.9 #5	98.79 #5	112.9 #5	102.6 #5	105.9 #5	104.9 #5	136.4 #5	104.5 #5	104.3 #5
control file sequential read	150.2 #7	70.08–114.4	+5.2σ	▲ 62.8%table-wide shift	103.1 #7	104.2 #7	107.5 #7	95.93 #7	79.03 #7	90.29 #7	82.05 #7	84.69 #7	83.93 #7	109.1 #7	83.62 #7	83.48 #7
os thread creation	112.7 #8	52.56–85.80	+5.2σ	▲ 62.8%immaterial	77.31 #8	78.12 #8	80.65 #8	71.95 #8	59.27 #8	67.71 #8	61.53 #8	63.51 #8	62.95 #8	81.83 #8	62.71 #8	62.61 #8
log file switch (checkpoint incomplete)	112.7 #8	52.56–85.80	+5.2σ	▲ 62.8%table-wide shift	77.31 #8	78.12 #8	80.65 #8	71.95 #8	59.27 #8	67.71 #8	61.53 #8	63.51 #8	62.95 #8	81.83 #8	62.71 #8	62.61 #8
LGWR wait for redo copy	75.10 #10	35.04–57.20	+5.2σ	▲ 62.8%immaterial	51.54 #10	52.08 #10	53.77 #10	47.97 #10	39.52 #10	45.14 #10	41.02 #10	42.34 #10	41.97 #10	54.55 #10	41.81 #10	41.74 #10
oracle thread bootstrap	75.10 #10	35.04–57.20	+5.2σ	▲ 62.8%immaterial	51.54 #10	52.08 #10	53.77 #10	47.97 #10	39.52 #10	45.14 #10	41.02 #10	42.34 #10	41.97 #10	54.55 #10	41.81 #10	41.74 #10

Events — avg time per wait (ms)

Event	Current (ms)	Normal range	z	Δ vs mean	−1w (ms)	−2w (ms)	−3w (ms)	−4w (ms)	−5w (ms)	−6w (ms)	−7w (ms)	−8w (ms)	−9w (ms)	−10w (ms)	−11w (ms)	−12w (ms)
db file parallel write	1.527	1.413–1.557	+1.2σ	▲ 2.8%	1.467	1.475	1.551	1.446	1.526	1.490	1.500	1.439	1.497	1.525	1.455	1.449
log file parallel write	0.9218	0.8529–0.9452	+1.0σ	▲ 2.5%	0.8898	0.8657	0.9127	0.9324	0.8633	0.8963	0.9167	0.9153	0.9253	0.9086	0.8866	0.8753
db file async I/O submit	0.6184	0.537–0.6583	+0.7σ	▲ 3.5%	0.652	0.6595	0.5688	0.6005	0.6086	0.5842	0.5918	0.5708	0.5927	0.5706	0.6008	0.5716
control file parallel write	2.740	2.402–2.777	+1.6σ	▲ 5.8%	2.593	2.585	2.656	2.494	2.718	2.517	2.447	2.623	2.473	2.593	2.626	2.748
log file sequential read	0.8139	0.7274–0.8795	+0.3σ	▲ 1.3%	0.7643	0.7985	0.8206	0.7618	0.7675	0.7796	0.7953	0.7783	0.8536	0.8047	0.8827	0.8346
direct path write	1.158	1.065–1.315	−0.5σ	▼ 2.7%	1.114	1.244	1.149	1.249	1.301	1.228	1.159	1.153	1.124	1.174	1.127	1.257
control file sequential read	0.2057	0.1888–0.2158	+0.5σ	▲ 1.7%	0.1993	0.2077	0.2013	0.2017	0.2183	0.201	0.1972	0.2009	0.1899	0.2035	0.2005	0.2064
os thread creation	9.003	8.281–9.632	+0.1σ	▲ 0.5%	8.684	8.332	9.028	8.976	9.016	8.820	9.273	9.046	9.041	8.472	9.514	9.275
log file switch (checkpoint incomplete)	62.96	56.95–62.66	+2.2σ	▲ 5.3%immaterial	60.33	59.14	59.16	57.24	61.23	59.36	61.01	62.34	58.88	58.48	61.13	59.33
LGWR wait for redo copy	0.04177	0.0376–0.04151	+2.3σ	▲ 5.6%immaterial	0.0401	0.03949	0.0376	0.03895	0.03956	0.03897	0.0402	0.04051	0.04139	0.03997	0.03877	0.03912
oracle thread bootstrap	25.84	22.56–27.66	+0.6σ	▲ 2.9%	26.61	25.60	24.52	25.26	26.00	23.39	27.35	24.72	25.60	23.92	23.01	25.33

Top SQLTop 10 statements per ranking and window; ranked, not scored

By elapsed time

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (s)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w	SQL
7k2m9dx4qp1zb plan↑	2088341150	27.92 k #1	6,730 #1 plan↑	7,227 #1 plan↑	7,637 #1 plan↑	6,896 #1 plan↑	6,397 #1 plan↑	6,243 #1 plan↑	6,669 #1 plan↑	6,523 #1 plan↑	6,080 #1 plan↑	6,356 #1 plan↑	6,392 #1 plan↑	6,873 #1 plan↑	SELECT o.order_id, o.status, o.total_amount, l.line_no, l.sku, l.qty, l.unit_price FROM orders o JOIN order_lines l ON l.order_id = o.order_id WHERE o.customer_id = :1 AND o.created_at > :2 ORDER BY o.created_at DESC
n7t3q5xc1yj4g	1288463905	6,296 #2	5,170 #2	4,871 #2	4,510 #2	3,608 #4	—	—	—	—	—	—	—	—	SELECT NVL(SUM(points), 0) AS balance, MAX(created_at) AS last_activity FROM loyalty_ledger WHERE customer_id = :1
2yq9jv7c5hm3d	902817346	3,791 #3	4,049 #3	3,844 #3	3,787 #3	5,284 #2	3,613 #2	3,521 #2	3,781 #2	3,979 #2	3,854 #2	3,461 #2	3,732 #2	3,114 #2	UPDATE inventory SET qty_on_hand = qty_on_hand - :1, last_modified = SYSTIMESTAMP WHERE sku = :2 AND warehouse_id = :3
u9d5p3fw2hs8x	1367128900	3,762 #4	3,791 #4	3,614 #4	3,386 #4	4,003 #3	3,397 #3	3,130 #3	3,380 #3	3,249 #3	2,924 #3	2,912 #3	3,132 #3	2,921 #3	SELECT p.sku, p.name, p.list_price, SCORE(1) FROM products p WHERE CONTAINS(p.description, :1, 1) > 0 AND p.active = 'Y' ORDER BY SCORE(1) DESC FETCH FIRST 24 ROWS ONLY
f1p7r4mz8vb2c	4172308451	2,232 #5	2,232 #6	1,887 #6	2,378 #5	2,313 #5	2,093 #5	1,948 #5	2,093 #5	2,032 #5	1,916 #5	1,953 #4	2,043 #5	1,998 #5	SELECT c.customer_id, c.email, c.tier, a.line1, a.city, a.postcode, a.country FROM customers c JOIN addresses a ON a.customer_id = c.customer_id AND a.is_default = 'Y' WHERE c.customer_id = :1
t3h6u1zr9nb8w	3527641099	2,119 #6	2,311 #5	2,160 #5	2,175 #6	2,262 #6	2,238 #4	2,185 #4	2,228 #4	2,344 #4	2,155 #4	1,790 #5	2,456 #4	2,240 #4	SELECT ci.sku, ci.qty, p.name, p.list_price, p.image_url FROM cart_items ci JOIN products p ON p.sku = ci.sku WHERE ci.session_id = :1
b6f4h0kq3ztr8	2611947330	1,040 #7	1,064 #7	1,020 #7	1,174 #7	1,153 #7	1,076 #6	1,108 #6	1,106 #6	1,061 #6	1,105 #6	998.6 #6	1,042 #6	1,104 #6	INSERT INTO order_lines (order_id, line_no, sku, qty, unit_price) VALUES (:1, :2, :3, :4, :5)
j6b1v4nr8xt2p	4034711296	655.9 #8	760.5 #8	742.4 #9	852.2 #8	845.2 #8	701.5 #7	634.3 #9	790.0 #7	675.1 #7	692.3 #7	627.7 #9	737.9 #7	661.4 #8	SELECT s.shipment_id, s.carrier, s.tracking_no, s.status, s.eta FROM shipments s WHERE s.order_id = :1
g3c8w1a2nfy5r	1466803562	644.4 #9	748.8 #9	787.1 #8	759.6 #9	827.7 #9	686.2 #8	677.1 #7	740.1 #8	635.5 #8	618.7 #9	569.6 #10	717.8 #8	680.1 #7	INSERT INTO orders (order_id, customer_id, status, total_amount, created_at, channel) VALUES (orders_seq.NEXTVAL, :1, :2, :3, SYSTIMESTAMP, :4)
c7v3m6hq1kf9e	1090277735	603.9 #10	—	739.6 #10	702.3 #10	—	565.8 #10	659.7 #8	567.3 #10	575.7 #10	574.3 #10	634.5 #8	605.4 #10	624.6 #9	INSERT INTO payments (payment_id, order_id, provider, auth_code, amount, status, created_at) VALUES (payments_seq.NEXTVAL, :1, :2, :3, :4, 'AUTH', SYSTIMESTAMP)
r3z7n1md8ky5c	—	—	631.5 #10	—	—	684.9 #10	618.5 #9	595.3 #10	618.8 #9	619.2 #9	653.2 #8	662.2 #7	640.4 #9	603.6 #10	SELECT sku, warehouse_id, qty_on_hand, last_modified FROM inventory WHERE last_modified > :1

By CPU time

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (s)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w	SQL
n7t3q5xc1yj4g	1288463905	5,352 #1	4,394 #2	4,140 #2	3,833 #2	3,067 #3	—	—	—	—	—	—	—	—	SELECT NVL(SUM(points), 0) AS balance, MAX(created_at) AS last_activity FROM loyalty_ledger WHERE customer_id = :1
7k2m9dx4qp1zb plan↑	2088341150	4,467 #2	4,846 #1 plan↑	5,204 #1 plan↑	5,499 #1 plan↑	4,965 #1 plan↑	4,606 #1 plan↑	4,495 #1 plan↑	4,802 #1 plan↑	4,696 #1 plan↑	4,378 #1 plan↑	4,576 #1 plan↑	4,602 #1 plan↑	4,949 #1 plan↑	SELECT o.order_id, o.status, o.total_amount, l.line_no, l.sku, l.qty, l.unit_price FROM orders o JOIN order_lines l ON l.order_id = o.order_id WHERE o.customer_id = :1 AND o.created_at > :2 ORDER BY o.created_at DESC
u9d5p3fw2hs8x	1367128900	3,386 #3	3,412 #3	3,252 #3	3,047 #3	3,602 #2	3,058 #2	2,817 #2	3,042 #2	2,924 #2	2,631 #2	2,620 #2	2,819 #2	2,628 #2	SELECT p.sku, p.name, p.list_price, SCORE(1) FROM products p WHERE CONTAINS(p.description, :1, 1) > 0 AND p.active = 'Y' ORDER BY SCORE(1) DESC FETCH FIRST 24 ROWS ONLY
f1p7r4mz8vb2c	4172308451	1,786 #4	1,786 #5	1,510 #5	1,902 #4	1,851 #4	1,674 #4	1,558 #4	1,674 #4	1,625 #4	1,532 #4	1,562 #3	1,634 #4	1,598 #4	SELECT c.customer_id, c.email, c.tier, a.line1, a.city, a.postcode, a.country FROM customers c JOIN addresses a ON a.customer_id = c.customer_id AND a.is_default = 'Y' WHERE c.customer_id = :1
t3h6u1zr9nb8w	3527641099	1,653 #5	1,802 #4	1,685 #4	1,696 #5	1,764 #5	1,745 #3	1,704 #3	1,738 #3	1,829 #3	1,681 #3	1,396 #4	1,916 #3	1,747 #3	SELECT ci.sku, ci.qty, p.name, p.list_price, p.image_url FROM cart_items ci JOIN products p ON p.sku = ci.sku WHERE ci.session_id = :1
2yq9jv7c5hm3d	902817346	1,137 #6	1,215 #6	1,153 #6	1,136 #6	1,585 #6	1,084 #5	1,056 #5	1,134 #5	1,194 #5	1,156 #5	1,038 #5	1,120 #5	934.2 #5	UPDATE inventory SET qty_on_hand = qty_on_hand - :1, last_modified = SYSTIMESTAMP WHERE sku = :2 AND warehouse_id = :3
b6f4h0kq3ztr8	2611947330	572.0 #7	585.4 #8	560.9 #9	645.9 #8	634.0 #8	591.5 #6	609.5 #6	608.1 #7	583.7 #6	607.6 #6	549.2 #7	573.0 #8	607.0 #6	INSERT INTO order_lines (order_id, line_no, sku, qty, unit_price) VALUES (:1, :2, :3, :4, :5)
j6b1v4nr8xt2p	4034711296	537.8 #8	623.6 #7	608.7 #7	698.8 #7	693.1 #7	575.2 #7	520.2 #8	647.8 #6	553.6 #8	567.7 #8	514.7 #8	605.1 #6	542.3 #8	SELECT s.shipment_id, s.carrier, s.tracking_no, s.status, s.eta FROM shipments s WHERE s.order_id = :1
r3z7n1md8ky5c	3082517486	518.5 #9	568.4 #9	569.9 #8	538.2 #9	616.4 #9	556.6 #8	535.8 #7	556.9 #8	557.3 #7	587.8 #7	596.0 #6	576.3 #7	543.3 #7	SELECT sku, warehouse_id, qty_on_hand, last_modified FROM inventory WHERE last_modified > :1
m5q1x9cb3rt7h	2475096182	419.1 #10	432.6 #10	430.9 #10	387.3 #10	455.5 #10	396.0 #9	431.8 #9	396.5 #9	385.8 #9	418.1 #9	366.2 #9	406.9 #9	383.9 #9	SELECT COUNT(*) FROM order_lines WHERE order_id = :1
g3c8w1a2nfy5r	—	—	—	—	—	—	308.8 #10	304.7 #10	333.1 #10	286.0 #10	—	—	323.0 #10	306.1 #10	INSERT INTO orders (order_id, customer_id, status, total_amount, created_at, channel) VALUES (orders_seq.NEXTVAL, :1, :2, :3, SYSTIMESTAMP, :4)
q8w4t2ve6ju3y	—	—	—	—	—	—	—	—	—	—	300.0 #10	259.6 #10	—	—	SELECT hour_ts, region_id, revenue, orders, avg_basket FROM mv_sales_hourly WHERE hour_ts >= :1 ORDER BY hour_ts DESC, region_id

By buffer gets

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (gets)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w	SQL
7k2m9dx4qp1zb plan↑	2088341150	2.172 G #1	130.0 M #3 plan↑	129.6 M #3 plan↑	132.6 M #3 plan↑	134.2 M #3 plan↑	120.2 M #2 plan↑	117.2 M #2 plan↑	120.4 M #2 plan↑	122.9 M #2 plan↑	120.3 M #2 plan↑	115.7 M #2 plan↑	110.5 M #2 plan↑	121.8 M #2 plan↑	SELECT o.order_id, o.status, o.total_amount, l.line_no, l.sku, l.qty, l.unit_price FROM orders o JOIN order_lines l ON l.order_id = o.order_id WHERE o.customer_id = :1 AND o.created_at > :2 ORDER BY o.created_at DESC
n7t3q5xc1yj4g	1288463905	257.8 M #2	221.4 M #1	208.2 M #1	187.8 M #1	155.1 M #2	—	—	—	—	—	—	—	—	SELECT NVL(SUM(points), 0) AS balance, MAX(created_at) AS last_activity FROM loyalty_ledger WHERE customer_id = :1
u9d5p3fw2hs8x	1367128900	171.3 M #3	175.6 M #2	179.1 M #2	161.6 M #2	181.3 M #1	166.5 M #1	161.2 M #1	160.5 M #1	156.5 M #1	145.9 M #1	154.5 M #1	168.8 M #1	168.3 M #1	SELECT p.sku, p.name, p.list_price, SCORE(1) FROM products p WHERE CONTAINS(p.description, :1, 1) > 0 AND p.active = 'Y' ORDER BY SCORE(1) DESC FETCH FIRST 24 ROWS ONLY
r3z7n1md8ky5c	3082517486	50.40 M #4	50.40 M #5	50.40 M #5	50.40 M #5	50.40 M #5	50.40 M #4	50.40 M #3	50.40 M #4	50.40 M #3	50.40 M #3	50.40 M #3	50.40 M #4	50.40 M #3	SELECT sku, warehouse_id, qty_on_hand, last_modified FROM inventory WHERE last_modified > :1
t3h6u1zr9nb8w	3527641099	49.48 M #5	54.84 M #4	55.95 M #4	53.12 M #4	56.23 M #4	52.57 M #3	47.99 M #4	50.84 M #3	48.40 M #4	49.09 M #4	46.15 M #4	51.04 M #3	48.98 M #4	SELECT ci.sku, ci.qty, p.name, p.list_price, p.image_url FROM cart_items ci JOIN products p ON p.sku = ci.sku WHERE ci.session_id = :1
f1p7r4mz8vb2c	4172308451	37.17 M #6	37.79 M #6	38.46 M #6	36.93 M #6	39.06 M #6	35.20 M #5	32.39 M #5	36.11 M #5	35.10 M #5	33.50 M #5	35.23 M #5	32.64 M #5	34.04 M #5	SELECT c.customer_id, c.email, c.tier, a.line1, a.city, a.postcode, a.country FROM customers c JOIN addresses a ON a.customer_id = c.customer_id AND a.is_default = 'Y' WHERE c.customer_id = :1
q8w4t2ve6ju3y	651834720	22.22 M #7	22.70 M #7	23.12 M #7	23.41 M #7	23.66 M #7	21.12 M #6	20.08 M #6	22.13 M #6	21.47 M #6	21.91 M #6	21.12 M #6	22.27 M #6	21.07 M #6	SELECT hour_ts, region_id, revenue, orders, avg_basket FROM mv_sales_hourly WHERE hour_ts >= :1 ORDER BY hour_ts DESC, region_id
b6f4h0kq3ztr8	2611947330	19.99 M #8	19.57 M #8	20.37 M #8	20.12 M #8	20.57 M #8	18.83 M #7	18.89 M #7	19.19 M #7	18.25 M #7	18.36 M #7	18.64 M #7	20.04 M #7	18.10 M #7	INSERT INTO order_lines (order_id, line_no, sku, qty, unit_price) VALUES (:1, :2, :3, :4, :5)
m5q1x9cb3rt7h	2475096182	13.27 M #9	13.89 M #9	13.68 M #9	12.60 M #10	13.56 M #9	12.42 M #8	12.45 M #8	12.92 M #8	12.31 M #8	13.24 M #8	12.31 M #8	12.45 M #8	11.97 M #8	SELECT COUNT(*) FROM order_lines WHERE order_id = :1
2yq9jv7c5hm3d	902817346	12.32 M #10	12.39 M #10	12.64 M #10	—	12.37 M #10	11.50 M #10	11.58 M #10	—	11.69 M #9	11.98 M #9	11.07 M #10	11.80 M #9	11.22 M #10	UPDATE inventory SET qty_on_hand = qty_on_hand - :1, last_modified = SYSTIMESTAMP WHERE sku = :2 AND warehouse_id = :3
j6b1v4nr8xt2p	—	—	—	—	12.68 M #9	—	—	—	11.64 M #9	—	—	—	—	—	SELECT s.shipment_id, s.carrier, s.tracking_no, s.status, s.eta FROM shipments s WHERE s.order_id = :1
d8s3n5tw2xk7f	—	—	—	—	—	—	11.60 M #9	11.60 M #9	11.60 M #10	11.60 M #10	11.60 M #10	11.60 M #9	11.60 M #10	11.60 M #9	MERGE INTO inventory i USING (SELECT sku, warehouse_id, qty, last_update FROM inv_feed_stage WHERE batch_id = :1) s ON (i.sku = s.sku AND i.warehouse_id = s.warehouse_id) WHEN MATCHED THEN UPDATE SET i.qty_on_hand = s.qty WHEN NOT MATCHED THEN INSERT (...) VALUES (...)

By physical reads

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (reads)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w	SQL
7k2m9dx4qp1zb plan↑	2088341150	43.43 M #1	3.080 M #2 plan↑	3.070 M #2 plan↑	3.141 M #2 plan↑	3.178 M #2 plan↑	2.847 M #2 plan↑	2.776 M #2 plan↑	2.852 M #2 plan↑	2.910 M #2 plan↑	2.848 M #2 plan↑	2.739 M #2 plan↑	2.618 M #2 plan↑	2.885 M #2 plan↑	SELECT o.order_id, o.status, o.total_amount, l.line_no, l.sku, l.qty, l.unit_price FROM orders o JOIN order_lines l ON l.order_id = o.order_id WHERE o.customer_id = :1 AND o.created_at > :2 ORDER BY o.created_at DESC
9wz2ke6yq4tn1	2789504216	3.650 M #2	3.650 M #1	3.650 M #1	3.650 M #1	3.650 M #1	3.650 M #1	3.650 M #1	3.650 M #1	3.650 M #1	3.650 M #1	3.650 M #1	3.650 M #1	3.650 M #1	SELECT /+ PARALLEL(sf 8) / sf.region_id, sf.channel, TRUNC(sf.sale_ts) AS sale_day, SUM(sf.amount) AS revenue, COUNT(*) AS orders FROM sales_fact sf WHERE sf.sale_ts >= :1 AND sf.sale_ts < :2 GROUP BY sf.region_id, sf.channel, TRUNC(sf.sale_ts)
n7t3q5xc1yj4g	1288463905	2.959 M #3	2.541 M #3	2.390 M #3	2.156 M #3	1.780 M #3	—	—	—	—	—	—	—	—	SELECT NVL(SUM(points), 0) AS balance, MAX(created_at) AS last_activity FROM loyalty_ledger WHERE customer_id = :1
u9d5p3fw2hs8x	1367128900	892.0 k #4	914.4 k #4	933.0 k #4	841.8 k #4	944.2 k #4	867.4 k #3	839.4 k #3	836.0 k #3	815.0 k #3	759.8 k #3	804.5 k #3	879.0 k #3	876.6 k #3	SELECT p.sku, p.name, p.list_price, SCORE(1) FROM products p WHERE CONTAINS(p.description, :1, 1) > 0 AND p.active = 'Y' ORDER BY SCORE(1) DESC FETCH FIRST 24 ROWS ONLY
v8c2l5qs3wd7m	2098345671	610.0 k #5	610.0 k #5	610.0 k #5	610.0 k #5	610.0 k #5	610.0 k #4	610.0 k #4	610.0 k #4	610.0 k #4	610.0 k #4	610.0 k #4	610.0 k #4	610.0 k #4	SELECT i.sku, i.warehouse_id, i.qty_on_hand, i.reorder_level, i.reorder_qty FROM inventory i WHERE i.qty_on_hand < i.reorder_level AND i.active = 'Y'
q8w4t2ve6ju3y	651834720	522.8 k #6	534.0 k #7	543.9 k #7	550.8 k #6	556.6 k #7	496.9 k #6	472.5 k #6	520.7 k #5	505.1 k #5	515.5 k #5	496.9 k #5	523.9 k #5	495.8 k #5	SELECT hour_ts, region_id, revenue, orders, avg_basket FROM mv_sales_hourly WHERE hour_ts >= :1 ORDER BY hour_ts DESC, region_id
t3h6u1zr9nb8w	3527641099	494.8 k #7	548.4 k #6	559.5 k #6	531.2 k #7	562.3 k #6	525.7 k #5	479.9 k #5	508.4 k #6	484.0 k #6	490.9 k #6	461.5 k #6	510.4 k #6	489.8 k #6	SELECT ci.sku, ci.qty, p.name, p.list_price, p.image_url FROM cart_items ci JOIN products p ON p.sku = ci.sku WHERE ci.session_id = :1
f1p7r4mz8vb2c	4172308451	424.8 k #8	431.9 k #8	439.5 k #8	422.1 k #8	446.3 k #8	402.3 k #7	370.2 k #7	412.7 k #7	401.1 k #7	382.8 k #7	402.6 k #7	373.0 k #7	389.0 k #7	SELECT c.customer_id, c.email, c.tier, a.line1, a.city, a.postcode, a.country FROM customers c JOIN addresses a ON a.customer_id = c.customer_id AND a.is_default = 'Y' WHERE c.customer_id = :1
r3z7n1md8ky5c	3082517486	336.0 k #9	336.0 k #9	336.0 k #9	336.0 k #9	336.0 k #9	336.0 k #8	336.0 k #8	336.0 k #8	336.0 k #8	336.0 k #8	336.0 k #8	336.0 k #8	336.0 k #8	SELECT sku, warehouse_id, qty_on_hand, last_modified FROM inventory WHERE last_modified > :1
2yq9jv7c5hm3d	902817346	273.8 k #10	275.4 k #10	281.0 k #10	271.0 k #10	274.9 k #10	255.6 k #9	257.3 k #9	253.9 k #9	259.7 k #9	266.1 k #9	245.9 k #9	262.3 k #9	249.2 k #9	UPDATE inventory SET qty_on_hand = qty_on_hand - :1, last_modified = SYSTIMESTAMP WHERE sku = :2 AND warehouse_id = :3
d8s3n5tw2xk7f	—	—	—	—	—	—	244.0 k #10	244.0 k #10	244.0 k #10	244.0 k #10	244.0 k #10	244.0 k #10	244.0 k #10	244.0 k #10	MERGE INTO inventory i USING (SELECT sku, warehouse_id, qty, last_update FROM inv_feed_stage WHERE batch_id = :1) s ON (i.sku = s.sku AND i.warehouse_id = s.warehouse_id) WHEN MATCHED THEN UPDATE SET i.qty_on_hand = s.qty WHEN NOT MATCHED THEN INSERT (...) VALUES (...)

By executions

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (exec)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w	SQL
f1p7r4mz8vb2c	4172308451	5.310 M #1	5.399 M #1	5.494 M #1	5.276 M #1	5.579 M #1	5.029 M #1	4.628 M #1	5.159 M #1	5.014 M #1	4.786 M #1	5.032 M #1	4.663 M #1	4.862 M #1	SELECT c.customer_id, c.email, c.tier, a.line1, a.city, a.postcode, a.country FROM customers c JOIN addresses a ON a.customer_id = c.customer_id AND a.is_default = 'Y' WHERE c.customer_id = :1
t3h6u1zr9nb8w	3527641099	4.124 M #2	4.570 M #2	4.663 M #2	4.427 M #2	4.686 M #2	4.381 M #2	3.999 M #2	4.237 M #2	4.033 M #2	4.091 M #2	3.846 M #2	4.253 M #2	4.081 M #2	SELECT ci.sku, ci.qty, p.name, p.list_price, p.image_url FROM cart_items ci JOIN products p ON p.sku = ci.sku WHERE ci.session_id = :1
m5q1x9cb3rt7h	2475096182	3.318 M #3	3.472 M #3	3.420 M #3	3.151 M #4	3.390 M #4	3.105 M #4	3.114 M #3	3.231 M #3	3.079 M #4	3.309 M #3	3.077 M #3	3.112 M #3	2.993 M #4	SELECT COUNT(*) FROM order_lines WHERE order_id = :1
7k2m9dx4qp1zb plan↑	2088341150	3.102 M #4	3.422 M #4 plan↑	3.411 M #4 plan↑	3.490 M #3 plan↑	3.531 M #3 plan↑	3.163 M #3 plan↑	3.084 M #4 plan↑	3.169 M #4 plan↑	3.234 M #3 plan↑	3.164 M #4 plan↑	3.044 M #4 plan↑	2.909 M #4 plan↑	3.206 M #3 plan↑	SELECT o.order_id, o.status, o.total_amount, l.line_no, l.sku, l.qty, l.unit_price FROM orders o JOIN order_lines l ON l.order_id = o.order_id WHERE o.customer_id = :1 AND o.created_at > :2 ORDER BY o.created_at DESC
n7t3q5xc1yj4g	1288463905	2.315 M #5	2.227 M #5	2.381 M #5	2.487 M #5	2.440 M #5	—	—	—	—	—	—	—	—	SELECT NVL(SUM(points), 0) AS balance, MAX(created_at) AS last_activity FROM loyalty_ledger WHERE customer_id = :1
j6b1v4nr8xt2p	4034711296	1.910 M #6	2.032 M #6	2.039 M #6	2.113 M #6	2.032 M #6	1.897 M #5	1.788 M #5	1.939 M #5	1.887 M #5	1.837 M #5	1.795 M #5	1.814 M #5	1.826 M #5	SELECT s.shipment_id, s.carrier, s.tracking_no, s.status, s.eta FROM shipments s WHERE s.order_id = :1
b6f4h0kq3ztr8	2611947330	1.428 M #7	1.398 M #7	1.455 M #7	1.437 M #7	1.469 M #7	1.345 M #6	1.350 M #6	1.371 M #6	1.304 M #6	1.311 M #7	1.331 M #6	1.432 M #6	1.293 M #6	INSERT INTO order_lines (order_id, line_no, sku, qty, unit_price) VALUES (:1, :2, :3, :4, :5)
2yq9jv7c5hm3d	902817346	1.369 M #8	1.377 M #8	1.405 M #8	1.355 M #8	1.374 M #8	1.278 M #7	1.286 M #7	1.270 M #7	1.298 M #7	1.331 M #6	1.230 M #7	1.311 M #7	1.246 M #7	UPDATE inventory SET qty_on_hand = qty_on_hand - :1, last_modified = SYSTIMESTAMP WHERE sku = :2 AND warehouse_id = :3
s9e4y7mk2cq6v	622053178	719.8 k #9	713.0 k #9	761.6 k #9	778.0 k #9	788.8 k #9	751.3 k #8	747.4 k #8	738.3 k #8	741.4 k #8	724.0 k #8	666.4 k #8	689.2 k #8	729.1 k #8	UPDATE orders SET status = :1, updated_at = SYSTIMESTAMP WHERE order_id = :2
g3c8w1a2nfy5r	1466803562	420.4 k #10	451.9 k #10	458.1 k #10	—	466.1 k #10	421.5 k #9	415.2 k #10	426.1 k #9	413.5 k #9	386.2 k #9	397.4 k #9	422.7 k #9	420.2 k #9	INSERT INTO orders (order_id, customer_id, status, total_amount, created_at, channel) VALUES (orders_seq.NEXTVAL, :1, :2, :3, SYSTIMESTAMP, :4)
c7v3m6hq1kf9e	—	—	—	—	448.5 k #10	—	410.8 k #10	421.9 k #9	397.3 k #10	387.4 k #10	376.6 k #10	393.3 k #10	403.4 k #10	379.2 k #10	INSERT INTO payments (payment_id, order_id, provider, auth_code, amount, status, created_at) VALUES (payments_seq.NEXTVAL, :1, :2, :3, :4, 'AUTH', SYSTIMESTAMP)

By per-exec regression

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (s/exec)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w	SQL
d8s3n5tw2xk7f	3350188817	38.22 #1	36.34	35.82	32.66	40.41	34.75	38.68	37.88	34.55	39.01	38.47	36.87	36.26	MERGE INTO inventory i USING (SELECT sku, warehouse_id, qty, last_update FROM inv_feed_stage WHERE batch_id = :1) s ON (i.sku = s.sku AND i.warehouse_id = s.warehouse_id) WHEN MATCHED THEN UPDATE SET i.qty_on_hand = s.qty WHEN NOT MATCHED THEN INSERT (...) VALUES (...)
7k2m9dx4qp1zb plan↑	2088341150	0.009 #2	0.001967 plan↑	0.002119 plan↑	0.002188 plan↑	0.001953 plan↑	0.002023 plan↑	0.002024 plan↑	0.002104 plan↑	0.002017 plan↑	0.001921 plan↑	0.002088 plan↑	0.002197 plan↑	0.002144 plan↑	SELECT o.order_id, o.status, o.total_amount, l.line_no, l.sku, l.qty, l.unit_price FROM orders o JOIN order_lines l ON l.order_id = o.order_id WHERE o.customer_id = :1 AND o.created_at > :2 ORDER BY o.created_at DESC
z2b5g8wt4dn6p	3814905027	0.09616 #3	0.09397	0.09457	0.07911	0.09195	0.08845	0.09294	0.0984	0.09421	0.09317	0.09807	0.09441	0.09165	select o.obj#, o.type#, o.name, u.name from sys.obj$ o, sys.user$ u where o.owner# = u.user# and o.type# in (1, 2) and bitand(o.flags, 128) = 0
u9d5p3fw2hs8x	1367128900	0.01054 #4	0.01037	0.009683	0.01006	0.0106	0.009791	0.009322	0.01011	0.009967	0.009619	0.009048	0.00891	0.00833	SELECT p.sku, p.name, p.list_price, SCORE(1) FROM products p WHERE CONTAINS(p.description, :1, 1) > 0 AND p.active = 'Y' ORDER BY SCORE(1) DESC FETCH FIRST 24 ROWS ONLY
n7t3q5xc1yj4g	1288463905	0.00272 #5	0.002321	0.002046	0.001813	0.001478	—	—	—	—	—	—	—	—	SELECT NVL(SUM(points), 0) AS balance, MAX(created_at) AS last_activity FROM loyalty_ledger WHERE customer_id = :1
q8w4t2ve6ju3y	651834720	0.006299 #6	0.005985	0.006115	0.006318	0.006335	0.005939	0.006125	0.006542	0.006168	0.006652	0.00597	0.006819	0.005614	SELECT hour_ts, region_id, revenue, orders, avg_basket FROM mv_sales_hourly WHERE hour_ts >= :1 ORDER BY hour_ts DESC, region_id
k4m8v2bn6ws9e	3946117820	0.000939 #7	0.000922	0.000926	0.000924	0.000905	—	—	—	—	—	—	—	—	INSERT INTO loyalty_ledger (ledger_id, customer_id, order_id, points, reason, created_at) VALUES (loyalty_seq.NEXTVAL, :1, :2, :3, :4, SYSTIMESTAMP)
f1p7r4mz8vb2c	4172308451	0.00042 #8	0.000413	0.000344	0.000451	0.000415	0.000416	0.000421	0.000406	0.000405	0.0004	0.000388	0.000438	0.000411	SELECT c.customer_id, c.email, c.tier, a.line1, a.city, a.postcode, a.country FROM customers c JOIN addresses a ON a.customer_id = c.customer_id AND a.is_default = 'Y' WHERE c.customer_id = :1
s9e4y7mk2cq6v	622053178	0.00061 #9	0.000631	0.000626	0.000559	0.000582	0.000654	0.000642	0.000568	0.000605	0.000663	0.0006	0.000583	0.000583	UPDATE orders SET status = :1, updated_at = SYSTIMESTAMP WHERE order_id = :2
y4a7f1sk9cz3n	1730926184	0.000176 #10	0.000159	0.000181	0.00017	0.00018	0.000177	0.000194	0.000178	0.000186	0.000159	0.000178	0.000171	0.000177	SELECT metric_name, value FROM v$sysmetric WHERE group_id = 2 AND metric_name IN (:1, :2, :3, :4)

plan↑ 1 of 20 top SQL had a plan_hash_value change between current and a prior compared window. Look for the plan↑ badges in the SQL ID column and the per-window cells above.

Per-SQL detail

Click a row for the full text, plan summary and per-snapshot timeline (a colour change = a plan switch). Ranked in: Elapsed, CPU, Gets, Reads, eXecutions; solid = in that ranking's current top 3.

SQL ID

Ranked in

Schema

Plans

Executions

Snapshots

First seen

Text

7k2m9dx4qp1zb ASH MON

ECGRX

ORDERS_APP

5,051,375,221

2,435

2026-05-31 23:00

SELECT o.order_id, o.status, o.total_amount, l.line_no, l.sku, l.qty, l.unit_price FROM or…

Parsing schema: ORDERS_APP
Module: OrderService
Action: order-lookup
Optimizer mode: ALL_ROWS
Force-match sig: 8015633327383443268
SQL profile: —
Text length: 216 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3197245811	2026-05-31 23:00	2026-09-08 23:00	2,400	4,975,426,129	0.002098	38.12
2088341150	2026-09-08 23:00	2026-09-10 10:00	35	75,949,092	0.009	700.0

SELECT o.order_id, o.status, o.total_amount, l.line_no, l.sku, l.qty, l.unit_price FROM orders o JOIN order_lines l ON l.order_id = o.order_id WHERE o.customer_id = :1 AND o.created_at > :2 ORDER BY o.created_at DESC

n7t3q5xc1yj4g ASH MON

ECGRX

LOYALTY

1,058,064,375

708

2026-08-11 22:00

SELECT NVL(SUM(points), 0) AS balance, MAX(created_at) AS last_activity FROM loyalty_ledge…

Parsing schema: LOYALTY
Module: LoyaltyService
Action: points-balance
Optimizer mode: ALL_ROWS
Force-match sig: 8162231494179911248
SQL profile: —
Text length: 114 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1288463905	2026-08-11 22:00	2026-09-10 10:00	708	1,058,064,375	0.001983	86.38

SELECT NVL(SUM(points), 0) AS balance, MAX(created_at) AS last_activity FROM loyalty_ledger WHERE customer_id = :1

2yq9jv7c5hm3d ASH MON

ECGRX

ORDERS_APP

2,063,992,540

2,435

2026-05-31 23:00

UPDATE inventory SET qty_on_hand = qty_on_hand - :1, last_modified = SYSTIMESTAMP WHERE sk…

Parsing schema: ORDERS_APP
Module: OrderService
Action: checkout
Optimizer mode: ALL_ROWS
Force-match sig: 2389164923845662112
SQL profile: —
Text length: 118 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
902817346	2026-05-31 23:00	2026-09-10 10:00	2,435	2,063,992,540	0.003	9.000

UPDATE inventory SET qty_on_hand = qty_on_hand - :1, last_modified = SYSTIMESTAMP WHERE sku = :2 AND warehouse_id = :3

u9d5p3fw2hs8x ASH MON

ECGR

ORDERS_APP

532,228,523

2,435

2026-05-31 23:00

SELECT p.sku, p.name, p.list_price, SCORE(1) FROM products p WHERE CONTAINS(p.description,…

Parsing schema: ORDERS_APP
Module: OrderService
Action: search
Optimizer mode: ALL_ROWS
Force-match sig: 9816179745231494974
SQL profile: —
Text length: 168 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1367128900	2026-05-31 23:00	2026-09-10 10:00	2,435	532,228,523	0.009803	480.0

SELECT p.sku, p.name, p.list_price, SCORE(1) FROM products p WHERE CONTAINS(p.description, :1, 1) > 0 AND p.active = 'Y' ORDER BY SCORE(1) DESC FETCH FIRST 24 ROWS ONLY

f1p7r4mz8vb2c ASH MON

ECGRX

ORDERS_APP

7,880,076,223

2,435

2026-05-31 23:00

SELECT c.customer_id, c.email, c.tier, a.line1, a.city, a.postcode, a.country FROM custome…

Parsing schema: ORDERS_APP
Module: OrderService
Action: customer-profile
Optimizer mode: ALL_ROWS
Force-match sig: 6624276644684659864
SQL profile: —
Text length: 192 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
4172308451	2026-05-31 23:00	2026-09-10 10:00	2,435	7,880,076,223	0.00041	7.000

SELECT c.customer_id, c.email, c.tier, a.line1, a.city, a.postcode, a.country FROM customers c JOIN addresses a ON a.customer_id = c.customer_id AND a.is_default = 'Y' WHERE c.customer_id = :1

t3h6u1zr9nb8w ASH MON

ECGRX

ORDERS_APP

6,542,203,347

2,435

2026-05-31 23:00

SELECT ci.sku, ci.qty, p.name, p.list_price, p.image_url FROM cart_items ci JOIN products …

Parsing schema: ORDERS_APP
Module: OrderService
Action: cart
Optimizer mode: ALL_ROWS
Force-match sig: 4338626751577121552
SQL profile: —
Text length: 134 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3527641099	2026-05-31 23:00	2026-09-10 10:00	2,435	6,542,203,347	0.000519	12.00

SELECT ci.sku, ci.qty, p.name, p.list_price, p.image_url FROM cart_items ci JOIN products p ON p.sku = ci.sku WHERE ci.session_id = :1

b6f4h0kq3ztr8 ASH MON

ECGX

ORDERS_APP

2,134,908,429

2,435

2026-05-31 23:00

INSERT INTO order_lines (order_id, line_no, sku, qty, unit_price) VALUES (:1, :2, :3, :4, …

Parsing schema: ORDERS_APP
Module: OrderService
Action: checkout
Optimizer mode: ALL_ROWS
Force-match sig: 4018391451556981799
SQL profile: —
Text length: 93 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2611947330	2026-05-31 23:00	2026-09-10 10:00	2,435	2,134,908,429	0.000781	14.00

INSERT INTO order_lines (order_id, line_no, sku, qty, unit_price) VALUES (:1, :2, :3, :4, :5)

j6b1v4nr8xt2p ASH MON

ECGX

ORDERS_APP

2,996,006,553

2,435

2026-05-31 23:00

SELECT s.shipment_id, s.carrier, s.tracking_no, s.status, s.eta FROM shipments s WHERE s.o…

Parsing schema: ORDERS_APP
Module: OrderService
Action: order-lookup
Optimizer mode: ALL_ROWS
Force-match sig: 4378119324173324472
SQL profile: —
Text length: 102 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
4034711296	2026-05-31 23:00	2026-09-10 10:00	2,435	2,996,006,553	0.00038	6.000

SELECT s.shipment_id, s.carrier, s.tracking_no, s.status, s.eta FROM shipments s WHERE s.order_id = :1

Parsing schema: ORDERS_APP
Module: OrderService
Action: checkout
Optimizer mode: ALL_ROWS
Force-match sig: 9454948768137366811
SQL profile: —
Text length: 143 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1466803562	2026-05-31 23:00	2026-09-10 10:00	2,435	655,524,009	0.001654	22.00

INSERT INTO orders (order_id, customer_id, status, total_amount, created_at, channel) VALUES (orders_seq.NEXTVAL, :1, :2, :3, SYSTIMESTAMP, :4)

Parsing schema: ORDERS_APP
Module: PaymentGateway
Action: authorize
Optimizer mode: ALL_ROWS
Force-match sig: 6319404877247171934
SQL profile: —
Text length: 160 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1090277735	2026-05-31 23:00	2026-09-10 10:00	2,435	642,856,894	0.001506	16.00

INSERT INTO payments (payment_id, order_id, provider, auth_code, amount, status, created_at) VALUES (payments_seq.NEXTVAL, :1, :2, :3, :4, 'AUTH', SYSTIMESTAMP)

Parsing schema: REPORTING
Module: ReportEngine
Action: daily-sales
Optimizer mode: ALL_ROWS
Force-match sig: 9148360148566288978
SQL profile: —
Text length: 246 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2789504216	2026-05-31 23:00	2026-09-10 10:00	2,435	2,741	258.8	4.100 M

SELECT /*+ PARALLEL(sf 8) */ sf.region_id, sf.channel, TRUNC(sf.sale_ts) AS sale_day, SUM(sf.amount) AS revenue, COUNT(*) AS orders FROM sales_fact sf WHERE sf.sale_ts >= :1 AND sf.sale_ts < :2 GROUP BY sf.region_id, sf.channel, TRUNC(sf.sale_ts)

Parsing schema: INVENTORY
Module: InventorySync
Action: sync
Optimizer mode: ALL_ROWS
Force-match sig: 9974190840206582073
SQL profile: —
Text length: 269 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3350188817	2026-05-31 23:00	2026-09-10 10:00	2,435	9,740	38.09	2.900 M

MERGE INTO inventory i USING (SELECT sku, warehouse_id, qty, last_update FROM inv_feed_stage WHERE batch_id = :1) s ON (i.sku = s.sku AND i.warehouse_id = s.warehouse_id) WHEN MATCHED THEN UPDATE SET i.qty_on_hand = s.qty WHEN NOT MATCHED THEN INSERT (...) VALUES (...)

Parsing schema: LOYALTY
Module: LoyaltyService
Action: points-accrual
Optimizer mode: ALL_ROWS
Force-match sig: 9638562157315240312
SQL profile: —
Text length: 148 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3946117820	2026-08-11 22:00	2026-09-10 10:00	708	192,644,280	0.000927	11.00

INSERT INTO loyalty_ledger (ledger_id, customer_id, order_id, points, reason, created_at) VALUES (loyalty_seq.NEXTVAL, :1, :2, :3, :4, SYSTIMESTAMP)

Parsing schema: ORDERS_APP
Module: OrderService
Action: order-lookup
Optimizer mode: ALL_ROWS
Force-match sig: 3059105648642476202
SQL profile: —
Text length: 52 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2475096182	2026-05-31 23:00	2026-09-10 10:00	2,435	5,016,050,771	0.00014	4.000

SELECT COUNT(*) FROM order_lines WHERE order_id = :1

Parsing schema: REPORTING
Module: ReportEngine
Action: dashboard
Optimizer mode: ALL_ROWS
Force-match sig: 4514115167086161505
SQL profile: —
Text length: 128 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
651834720	2026-05-31 23:00	2026-09-10 10:00	2,435	99,883,693	0.006205	340.0

SELECT hour_ts, region_id, revenue, orders, avg_basket FROM mv_sales_hourly WHERE hour_ts >= :1 ORDER BY hour_ts DESC, region_id

Parsing schema: INVENTORY
Module: InventorySync
Action: sync
Optimizer mode: ALL_ROWS
Force-match sig: 5171112221761324552
SQL profile: —
Text length: 92 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3082517486	2026-05-31 23:00	2026-09-10 10:00	2,435	584,400	2.604	210.0 k

SELECT sku, warehouse_id, qty_on_hand, last_modified FROM inventory WHERE last_modified > :1

Parsing schema: ORDERS_APP
Module: OrderService
Action: order-status
Optimizer mode: ALL_ROWS
Force-match sig: 5563095770776785924
SQL profile: —
Text length: 76 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
622053178	2026-05-31 23:00	2026-09-10 10:00	2,435	1,137,989,138	0.000612	6.000

UPDATE orders SET status = :1, updated_at = SYSTIMESTAMP WHERE order_id = :2

Parsing schema: INVENTORY
Module: DBMS_SCHEDULER
Action: REORDER_CHECK_JOB
Optimizer mode: ALL_ROWS
Force-match sig: 2501257695038655826
SQL profile: —
Text length: 149 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2098345671	2026-05-31 23:00	2026-09-10 10:00	2,435	2,435	40.95	1.240 M

SELECT i.sku, i.warehouse_id, i.qty_on_hand, i.reorder_level, i.reorder_qty FROM inventory i WHERE i.qty_on_hand < i.reorder_level AND i.active = 'Y'

Parsing schema: DBSNMP
Module: emagent_SQL_oracle_database
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 9181832437025353977
SQL profile: —
Text length: 97 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1730926184	2026-05-31 23:00	2026-09-10 10:00	2,435	21,036,235	0.00018	3.000

SELECT metric_name, value FROM v$sysmetric WHERE group_id = 2 AND metric_name IN (:1, :2, :3, :4)

Parsing schema: SYS
Module: sqlplus@prd-ora-01 (TNS V1-V3)
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 9944919902137444223
SQL profile: —
Text length: 143 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3814905027	2026-05-31 23:00	2026-09-10 10:00	2,435	263,013	0.09211	4,100

select o.obj#, o.type#, o.name, u.name from sys.obj$ o, sys.user$ u where o.owner# = u.user# and o.type# in (1, 2) and bitand(o.flags, 128) = 0

▸ Show 12 more statements

Top SQL activityASH samples of each Top SQL statement by wait event, hourly, 2026-06-18 09:00 → 2026-09-10 10:00

7k2m9dx4qp1zb ↗ Top SQL · 935603 ASH samples · dominant: CPU

SELECT o.order_id, o.status, o.total_amount, l.line_no, l.sku, l.qty, l.unit_price FROM orders o JOIN order_lines l ON l.order_id = o.order_id WHERE o.customer_id = :1 AND o.created_at > :2 ORDER BY o

2yq9jv7c5hm3d ↗ Top SQL · 518904 ASH samples · dominant: enq: TX - row lock contention

UPDATE inventory SET qty_on_hand = qty_on_hand - :1, last_modified = SYSTIMESTAMP WHERE sku = :2 AND warehouse_id = :3

u9d5p3fw2hs8x ↗ Top SQL · 434689 ASH samples · dominant: CPU

SELECT p.sku, p.name, p.list_price, SCORE(1) FROM products p WHERE CONTAINS(p.description, :1, 1) > 0 AND p.active = 'Y' ORDER BY SCORE(1) DESC FETCH FIRST 24 ROWS ONLY

t3h6u1zr9nb8w ↗ Top SQL · 283202 ASH samples · dominant: CPU

SELECT ci.sku, ci.qty, p.name, p.list_price, p.image_url FROM cart_items ci JOIN products p ON p.sku = ci.sku WHERE ci.session_id = :1

f1p7r4mz8vb2c ↗ Top SQL · 269064 ASH samples · dominant: CPU

SELECT c.customer_id, c.email, c.tier, a.line1, a.city, a.postcode, a.country FROM customers c JOIN addresses a ON a.customer_id = c.customer_id AND a.is_default = 'Y' WHERE c.customer_id = :1

n7t3q5xc1yj4g ↗ Top SQL · 209795 ASH samples · dominant: CPU

SELECT NVL(SUM(points), 0) AS balance, MAX(created_at) AS last_activity FROM loyalty_ledger WHERE customer_id = :1

b6f4h0kq3ztr8 ↗ Top SQL · 138958 ASH samples · dominant: CPU

INSERT INTO order_lines (order_id, line_no, sku, qty, unit_price) VALUES (:1, :2, :3, :4, :5)

r3z7n1md8ky5c ↗ Top SQL · 125981 ASH samples · dominant: CPU

SELECT sku, warehouse_id, qty_on_hand, last_modified FROM inventory WHERE last_modified > :1

j6b1v4nr8xt2p ↗ Top SQL · 94706 ASH samples · dominant: CPU

SELECT s.shipment_id, s.carrier, s.tracking_no, s.status, s.eta FROM shipments s WHERE s.order_id = :1

g3c8w1a2nfy5r ↗ Top SQL · 90338 ASH samples · dominant: CPU

INSERT INTO orders (order_id, customer_id, status, total_amount, created_at, channel) VALUES (orders_seq.NEXTVAL, :1, :2, :3, SYSTIMESTAMP, :4)

c7v3m6hq1kf9e ↗ Top SQL · 80773 ASH samples · dominant: log file sync

INSERT INTO payments (payment_id, order_id, provider, auth_code, amount, status, created_at) VALUES (payments_seq.NEXTVAL, :1, :2, :3, :4, 'AUTH', SYSTIMESTAMP)

m5q1x9cb3rt7h ↗ Top SQL · 58429 ASH samples · dominant: CPU

SELECT COUNT(*) FROM order_lines WHERE order_id = :1

s9e4y7mk2cq6v ↗ Top SQL · 57964 ASH samples · dominant: CPU

UPDATE orders SET status = :1, updated_at = SYSTIMESTAMP WHERE order_id = :2

q8w4t2ve6ju3y ↗ Top SQL · 51603 ASH samples · dominant: CPU

SELECT hour_ts, region_id, revenue, orders, avg_basket FROM mv_sales_hourly WHERE hour_ts >= :1 ORDER BY hour_ts DESC, region_id

d8s3n5tw2xk7f ↗ Top SQL · 31329 ASH samples · dominant: CPU

MERGE INTO inventory i USING (SELECT sku, warehouse_id, qty, last_update FROM inv_feed_stage WHERE batch_id = :1) s ON (i.sku = s.sku AND i.warehouse_id = s.warehouse_id) WHEN MATCHED THEN UPDATE SET

k4m8v2bn6ws9e ↗ Top SQL · 17882 ASH samples · dominant: CPU

INSERT INTO loyalty_ledger (ledger_id, customer_id, order_id, points, reason, created_at) VALUES (loyalty_seq.NEXTVAL, :1, :2, :3, :4, SYSTIMESTAMP)

z2b5g8wt4dn6p ↗ Top SQL · 2017 ASH samples · dominant: CPU

select o.obj#, o.type#, o.name, u.name from sys.obj$ o, sys.user$ u where o.owner# = u.user# and o.type# in (1, 2) and bitand(o.flags, 128) = 0

SQL MonitorCaptured executions per statement; a sample, not every execution

Per-statement comparison (top 10)

SQL ID

User / module

Plan hash

Current max elapsed (s)

Normal range

vs normal, in σ

Δ vs mean

Trend

Prior mean (s)

Flags

9wz2ke6yq4tn1 ↗ Top SQL

REPORTING / ReportEngine

2789504216

213.3

174.9–248.9

+0.1σ

▲ 0.6%

211.9

DOP downgrade

Per-window detail & drill

Window	n	Max elapsed (s)	Median elapsed (s)	Max I/O (bytes)	DOP req/alloc	Plan hash(es)
Current	1	213.3	213.3	30.50 G	8/8	2789504216
−1w	1	192.5	192.5	30.50 G	8/8	2789504216
−2w	1	191.7	191.7	30.50 G	8/8	2789504216
−3w	1	199.2	199.2	30.50 G	8/8	2789504216
−4w	1	218.0	218.0	30.50 G	8/8	2789504216
−5w	1	237.5	237.5	30.50 G	8/8	2789504216
−6w	1	229.7	229.7	30.50 G	8/8	2789504216
−7w	1	247.5	247.5	30.50 G	8/8	2789504216
−8w	1	206.7	206.7	30.50 G	8/8	2789504216
−9w	1	198.4	198.4	30.50 G	8/8	2789504216
−10w	1	193.8	193.8	30.50 G	8/8	2789504216
−11w	1	213.4	213.4	30.50 G	8/8	2789504216
−12w	1	214.4	214.4	30.50 G	8/8	2789504216

SELECT DBMS_AUTO_REPORT.REPORT_REPOSITORY_DETAIL(rid=>2014506, type=>'ACTIVE') FROM dual;

v8c2l5qs3wd7m ↗ Top SQL

INVENTORY / DBMS_SCHEDULER

2098345671

40.15

29.12–51.03

+0.0σ

▲ 0.2%

40.08

Per-window detail & drill

Window	n	Max elapsed (s)	Median elapsed (s)	Max I/O (bytes)	DOP req/alloc	Plan hash(es)
Current	1	40.15	40.15	5.097 G	0/0	2098345671
−1w	1	46.34	46.34	5.097 G	0/0	2098345671
−2w	1	38.40	38.40	5.097 G	0/0	2098345671
−3w	1	35.81	35.81	5.097 G	0/0	2098345671
−4w	1	45.47	45.47	5.097 G	0/0	2098345671
−5w	1	41.50	41.50	5.097 G	0/0	2098345671
−6w	1	31.18	31.18	5.097 G	0/0	2098345671
−7w	1	31.78	31.78	5.097 G	0/0	2098345671
−8w	1	45.13	45.13	5.097 G	0/0	2098345671
−9w	1	44.00	44.00	5.097 G	0/0	2098345671
−10w	1	39.00	39.00	5.097 G	0/0	2098345671
−11w	1	36.33	36.33	5.097 G	0/0	2098345671
−12w	1	45.97	45.97	5.097 G	0/0	2098345671

SELECT DBMS_AUTO_REPORT.REPORT_REPOSITORY_DETAIL(rid=>2014511, type=>'ACTIVE') FROM dual;

d8s3n5tw2xk7f ↗ Top SQL

INVENTORY / InventorySync

3350188817

40.02

32.46–52.98

−0.5σ

▼ 6.3%

42.72

Per-window detail & drill

Window	n	Max elapsed (s)	Median elapsed (s)	Max I/O (bytes)	DOP req/alloc	Plan hash(es)
Current	4	40.02	38.65	749.6 M	0/0	3350188817
−1w	4	40.96	37.98	749.6 M	0/0	3350188817
−2w	4	39.61	32.46	749.6 M	0/0	3350188817
−3w	4	34.13	30.15	749.6 M	0/0	3350188817
−4w	4	45.37	41.85	749.6 M	0/0	3350188817
−5w	4	41.61	34.04	749.6 M	0/0	3350188817
−6w	4	51.17	38.56	749.6 M	0/0	3350188817
−7w	4	41.07	38.03	749.6 M	0/0	3350188817
−8w	4	39.43	34.42	749.6 M	0/0	3350188817
−9w	4	44.22	38.65	749.6 M	0/0	3350188817
−10w	4	52.83	40.39	749.6 M	0/0	3350188817
−11w	4	41.36	37.95	749.6 M	0/0	3350188817
−12w	4	40.83	38.90	749.6 M	0/0	3350188817

SELECT DBMS_AUTO_REPORT.REPORT_REPOSITORY_DETAIL(rid=>2014510, type=>'ACTIVE') FROM dual;

7k2m9dx4qp1zb ↗ Top SQL

ORDERS_APP / OrderService

plan changed ~~3197245811~~ → 2088341150

8.016

0.9461–2.059

+23.4σ

+23.4σ

▲ ×5.3

1.503

plan changed

Per-window detail & drill

Window	n	Max elapsed (s)	Median elapsed (s)	Max I/O (bytes)	DOP req/alloc	Plan hash(es)
Current	3	8.016	7.944	154.9 M	0/0	2088341150
−1w	1	1.201	1.201	6.636 M	0/0	3197245811
−2w	1	1.882	1.882	6.636 M	0/0	3197245811
−3w	1	1.660	1.660	6.636 M	0/0	3197245811
−4w	1	1.251	1.251	6.636 M	0/0	3197245811
−5w	1	1.905	1.905	6.636 M	0/0	3197245811
−6w	1	1.327	1.327	6.636 M	0/0	3197245811
−7w	1	1.265	1.265	6.636 M	0/0	3197245811
−8w	1	1.806	1.806	6.636 M	0/0	3197245811
−9w	1	1.342	1.342	6.636 M	0/0	3197245811
−10w	1	1.188	1.188	6.636 M	0/0	3197245811
−11w	1	1.454	1.454	6.636 M	0/0	3197245811
−12w	1	1.750	1.750	6.636 M	0/0	3197245811

SELECT DBMS_AUTO_REPORT.REPORT_REPOSITORY_DETAIL(rid=>2014514, type=>'ACTIVE') FROM dual;

Per-window detail & drill

Window	n	Max elapsed (s)	Median elapsed (s)	Max I/O (bytes)	DOP req/alloc	Plan hash(es)	Errors
Current	—	—	—	—	—	—	—
−1w	—	—	—	—	—	—	—
−2w	—	—	—	—	—	—	—
−3w	—	—	—	—	—	—	—
−4w	—	—	—	—	—	—	—
−5w	—	—	—	—	—	—	—
−6w	—	—	—	—	—	—	—
−7w	—	—	—	—	—	—	—
−8w	—	—	—	—	—	—	—
−9w	—	—	—	—	—	—	—
−10w	—	—	—	—	—	—	—
−11w	—	—	—	—	—	—	—
−12w	—	—	—	—	—	—	—

SELECT DBMS_AUTO_REPORT.REPORT_REPOSITORY_DETAIL(rid=>2006561, type=>'ACTIVE') FROM dual;

Per-window detail & drill

Window	n	Max elapsed (s)	Median elapsed (s)	Max I/O (bytes)	DOP req/alloc	Plan hash(es)	Errors
Current	—	—	—	—	—	—	—
−1w	—	—	—	—	—	—	—
−2w	—	—	—	—	—	—	—
−3w	—	—	—	—	—	—	—
−4w	—	—	—	—	—	—	—
−5w	—	—	—	—	—	—	—
−6w	—	—	—	—	—	—	—
−7w	—	—	—	—	—	—	—
−8w	—	—	—	—	—	—	—
−9w	—	—	—	—	—	—	—
−10w	—	—	—	—	—	—	—
−11w	—	—	—	—	—	—	—
−12w	—	—	—	—	—	—	—

SELECT DBMS_AUTO_REPORT.REPORT_REPOSITORY_DETAIL(rid=>2007988, type=>'ACTIVE') FROM dual;

Per-window detail & drill

Window	n	Max elapsed (s)	Median elapsed (s)	Max I/O (bytes)	DOP req/alloc	Plan hash(es)	Errors
Current	—	—	—	—	—	—	—
−1w	—	—	—	—	—	—	—
−2w	—	—	—	—	—	—	—
−3w	—	—	—	—	—	—	—
−4w	—	—	—	—	—	—	—
−5w	—	—	—	—	—	—	—
−6w	—	—	—	—	—	—	—
−7w	—	—	—	—	—	—	—
−8w	—	—	—	—	—	—	—
−9w	—	—	—	—	—	—	—
−10w	—	—	—	—	—	—	—
−11w	—	—	—	—	—	—	—
−12w	—	—	—	—	—	—	—

SELECT DBMS_AUTO_REPORT.REPORT_REPOSITORY_DETAIL(rid=>2009863, type=>'ACTIVE') FROM dual;

Per-window detail & drill

Window	n	Max elapsed (s)	Median elapsed (s)	Max I/O (bytes)	DOP req/alloc	Plan hash(es)	Errors
Current	—	—	—	—	—	—	—
−1w	—	—	—	—	—	—	—
−2w	—	—	—	—	—	—	—
−3w	—	—	—	—	—	—	—
−4w	—	—	—	—	—	—	—
−5w	—	—	—	—	—	—	—
−6w	—	—	—	—	—	—	—
−7w	—	—	—	—	—	—	—
−8w	—	—	—	—	—	—	—
−9w	—	—	—	—	—	—	—
−10w	—	—	—	—	—	—	—
−11w	—	—	—	—	—	—	—
−12w	—	—	—	—	—	—	—

SELECT DBMS_AUTO_REPORT.REPORT_REPOSITORY_DETAIL(rid=>2005162, type=>'ACTIVE') FROM dual;

Per-window detail & drill

Window	n	Max elapsed (s)	Median elapsed (s)	Max I/O (bytes)	DOP req/alloc	Plan hash(es)	Errors
Current	—	—	—	—	—	—	—
−1w	—	—	—	—	—	—	—
−2w	—	—	—	—	—	—	—
−3w	—	—	—	—	—	—	—
−4w	—	—	—	—	—	—	—
−5w	—	—	—	—	—	—	—
−6w	—	—	—	—	—	—	—
−7w	—	—	—	—	—	—	—
−8w	—	—	—	—	—	—	—
−9w	—	—	—	—	—	—	—
−10w	—	—	—	—	—	—	—
−11w	—	—	—	—	—	—	—
−12w	—	—	—	—	—	—	—

SELECT DBMS_AUTO_REPORT.REPORT_REPOSITORY_DETAIL(rid=>2012047, type=>'ACTIVE') FROM dual;

▸ Show 5 more statements (5 without a Current-window execution)

13,205 executions captured in the compared span; 13,205 across 9 statements met the inclusion floor (elapsed ≥ 1 s, an error, or more than one execution plan) and are shown above.

Execution scatter (full compared span)

Every captured execution, x = start time, y = elapsed (log scale). Diamond = error, triangle = a plan different from that sql_id's most common plan, size ∝ requested DOP. Colored series are the top 10 statements by Current-window max elapsed; grey = everything else.

Segment I/OTop 10 segments by I/O per window; ranked, not scored

By physical reads

Break down by:

Detail table

Segment	Type	Current (blocks)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
ORDERS_APP.ORDER_LINES	TABLE	95.07 M #1	9.065 M #1	8.897 M #1	9.026 M #1	8.715 M #1	8.651 M #1	7.857 M #1	9.654 M #1	7.396 M #1	8.353 M #1	7.620 M #1	8.101 M #1	8.527 M #1
ORDERS_APP.ORDER_LINES_PK	INDEX	5.767 M #2	3.938 M #3	4.369 M #3	4.045 M #3	4.482 M #3	3.914 M #3	3.878 M #3	3.950 M #3	3.562 M #3	3.777 M #3	3.694 M #3	3.796 M #3	4.126 M #3
ORDERS_APP.ORDERS	TABLE	5.402 M #3	6.219 M #2	6.009 M #2	5.602 M #2	6.864 M #2	5.281 M #2	5.385 M #2	5.549 M #2	5.188 M #2	5.139 M #2	5.144 M #2	6.159 M #2	6.157 M #2
ORDERS_APP.ORDER_LINES_ORD_IX	INDEX	2.764 M #4	2.163 M #7	1.873 M #8	2.127 M #7	2.359 M #6	2.071 M #7	2.032 M #7	1.827 M #8	2.211 M #6	1.940 M #7	2.146 M #7	2.167 M #7	1.920 M #7
REPORTING.SALES_FACT	TABLE PARTITION	2.414 M #5	2.185 M #6	2.278 M #6	2.369 M #5	2.372 M #5	2.147 M #6	2.168 M #5	2.344 M #5	2.176 M #7	2.360 M #4	2.306 M #5	2.259 M #6	2.240 M #4
ORDERS_APP.CUSTOMERS	TABLE	2.396 M #6	2.474 M #5	2.554 M #4	2.350 M #6	2.237 M #7	2.437 M #4	2.094 M #6	2.321 M #6	2.280 M #5	2.334 M #5	2.251 M #6	2.398 M #4	2.045 M #6
ORDERS_APP.ORDERS_PK	INDEX	2.194 M #7	2.808 M #4	2.326 M #5	2.508 M #4	2.479 M #4	2.310 M #5	2.275 M #4	2.402 M #4	2.298 M #4	2.226 M #6	2.380 M #4	2.351 M #5	2.120 M #5
ORDERS_APP.ORDERS_CUST_CREATED_IX	INDEX	1.983 M #8	2.024 M #8	2.068 M #7	2.063 M #8	1.835 M #8	1.898 M #8	1.771 M #9	1.853 M #7	1.805 M #8	1.668 M #8	1.697 M #8	1.879 M #8	1.819 M #8
ORDERS_APP.INVENTORY	TABLE	1.708 M #9	1.765 M #9	1.764 M #9	1.816 M #9	1.813 M #9	1.688 M #9	1.830 M #8	1.630 M #9	1.387 M #10	1.640 M #9	1.482 M #9	1.472 M #9	1.689 M #9
ORDERS_APP.CART_ITEMS	TABLE	1.644 M #10	—	—	—	1.785 M #10	1.419 M #10	1.543 M #10	1.571 M #10	1.449 M #9	1.401 M #10	1.463 M #10	1.469 M #10	1.406 M #10
LOYALTY.LOYALTY_LEDGER_CUST_IX	INDEX	—	1.534 M #10	1.592 M #10	—	—	—	—	—	—	—	—	—	—
ORDERS_APP.PAYMENTS	TABLE	—	—	—	1.483 M #10	—	—	—	—	—	—	—	—	—

By physical writes

Break down by:

Detail table

Segment	Type	Current (blocks)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
ORDERS_APP.ORDER_LINES	TABLE	1.157 M #1	1.216 M #1	1.065 M #1	1.306 M #1	1.180 M #1	1.141 M #1	981.0 k #1	1.125 M #1	1.090 M #1	1.186 M #1	847.9 k #2	1.095 M #1	1.039 M #1
ORDERS_APP.INVENTORY	TABLE	875.5 k #2	1.029 M #2	1.030 M #2	980.3 k #2	1.090 M #2	1.013 M #2	916.5 k #2	991.0 k #2	914.5 k #2	967.6 k #2	928.4 k #1	978.8 k #2	968.0 k #2
ORDERS_APP.ORDERS	TABLE	677.0 k #3	695.6 k #3	850.5 k #3	720.6 k #3	837.8 k #3	702.0 k #3	646.2 k #3	645.9 k #3	629.8 k #3	673.1 k #3	664.4 k #3	738.1 k #3	714.9 k #3
ORDERS_APP.ORDER_LINES_PK	INDEX	613.7 k #4	631.4 k #4	631.8 k #4	661.9 k #4	683.1 k #4	601.3 k #4	569.7 k #4	590.3 k #4	626.5 k #4	642.7 k #4	647.8 k #4	539.9 k #4	570.1 k #4
LOYALTY.LOYALTY_LEDGER	TABLE	520.7 k #5	596.4 k #5	488.3 k #5	549.6 k #5	594.2 k #5	—	—	—	—	—	—	—	—
ORDERS_APP.ORDER_LINES_ORD_IX	INDEX	440.5 k #6	428.6 k #9	413.9 k #8	425.6 k #6	461.1 k #6	402.9 k #6	398.6 k #5	396.6 k #7	397.8 k #6	404.8 k #7	433.6 k #5	422.8 k #5	390.9 k #6
ORDERS_APP.CART_ITEMS	TABLE	400.2 k #7	431.2 k #8	396.5 k #9	402.0 k #8	424.8 k #8	372.0 k #8	365.4 k #8	387.8 k #8	343.9 k #8	373.5 k #8	340.2 k #8	400.2 k #7	365.2 k #7
ORDERS_APP.PAYMENTS	TABLE	394.9 k #8	434.8 k #7	431.3 k #6	424.6 k #7	448.3 k #7	386.3 k #7	378.7 k #7	403.1 k #6	432.0 k #5	472.0 k #5	399.5 k #6	407.6 k #6	431.1 k #5
REPORTING.SALES_FACT_STAGE	TABLE	385.9 k #9	443.8 k #6	415.1 k #7	353.0 k #10	418.1 k #9	424.8 k #5	384.9 k #6	412.7 k #5	385.6 k #7	423.0 k #6	356.4 k #7	377.2 k #8	333.7 k #9
REPORTING.SALES_FACT	TABLE PARTITION	341.2 k #10	359.5 k #10	—	370.2 k #9	358.2 k #10	367.9 k #9	343.9 k #9	292.8 k #10	300.2 k #10	367.1 k #9	335.0 k #9	333.7 k #9	350.0 k #8
ORDERS_APP.ORDERS_PK	INDEX	—	—	357.3 k #10	—	—	—	311.4 k #10	—	315.5 k #9	330.3 k #10	299.8 k #10	—	302.7 k #10
ORDERS_APP.ORDERS_CUST_CREATED_IX	INDEX	—	—	—	—	—	314.0 k #10	—	310.9 k #9	—	—	—	322.6 k #10	—

By physical read requests

Break down by:

Detail table

Segment	Type	Current (requests)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
ORDERS_APP.ORDER_LINES	TABLE	80.81 M #1	7.706 M #1	7.563 M #1	7.672 M #1	7.408 M #1	7.353 M #1	6.679 M #1	8.205 M #1	6.287 M #1	7.100 M #1	6.477 M #1	6.886 M #1	7.248 M #1
ORDERS_APP.ORDER_LINES_PK	INDEX	4.902 M #2	3.348 M #3	3.714 M #3	3.438 M #3	3.810 M #3	3.327 M #3	3.297 M #3	3.357 M #3	3.027 M #3	3.210 M #3	3.140 M #3	3.226 M #3	3.507 M #3
ORDERS_APP.ORDERS	TABLE	4.592 M #3	5.286 M #2	5.108 M #2	4.762 M #2	5.835 M #2	4.489 M #2	4.577 M #2	4.716 M #2	4.409 M #2	4.368 M #2	4.373 M #2	5.235 M #2	5.233 M #2
ORDERS_APP.ORDER_LINES_ORD_IX	INDEX	2.349 M #4	1.839 M #6	1.592 M #7	1.808 M #6	2.005 M #5	1.761 M #6	1.727 M #6	1.553 M #7	1.879 M #6	1.649 M #6	1.824 M #6	1.842 M #6	1.632 M #6
ORDERS_APP.CUSTOMERS	TABLE	2.037 M #5	2.103 M #5	2.171 M #4	1.998 M #5	1.902 M #6	2.072 M #4	1.780 M #5	1.973 M #5	1.938 M #5	1.984 M #4	1.914 M #5	2.038 M #4	1.738 M #5
ORDERS_APP.ORDERS_PK	INDEX	1.865 M #6	2.386 M #4	1.977 M #5	2.132 M #4	2.108 M #4	1.964 M #5	1.934 M #4	2.042 M #4	1.953 M #4	1.892 M #5	2.023 M #4	1.998 M #5	1.802 M #4
ORDERS_APP.ORDERS_CUST_CREATED_IX	INDEX	1.686 M #7	1.721 M #7	1.758 M #6	1.753 M #7	1.560 M #7	1.613 M #7	1.505 M #8	1.575 M #6	1.534 M #7	1.418 M #7	1.442 M #7	1.597 M #7	1.546 M #7
ORDERS_APP.INVENTORY	TABLE	1.452 M #8	1.500 M #8	1.499 M #8	1.543 M #8	1.541 M #8	1.435 M #8	1.555 M #7	1.385 M #8	1.179 M #9	1.394 M #8	1.259 M #8	1.252 M #8	1.436 M #8
ORDERS_APP.CART_ITEMS	TABLE	1.397 M #9	1.211 M #10	1.244 M #10	1.255 M #10	1.517 M #9	1.206 M #9	1.311 M #9	1.335 M #9	1.232 M #8	1.191 M #9	1.243 M #9	1.249 M #9	1.195 M #9
LOYALTY.LOYALTY_LEDGER_CUST_IX	INDEX	1.303 M #10	1.304 M #9	1.353 M #9	—	1.347 M #10	—	—	—	—	—	—	—	—
ORDERS_APP.PAYMENTS	TABLE	—	—	—	1.261 M #9	—	1.102 M #10	1.220 M #10	1.128 M #10	1.012 M #10	1.126 M #10	1.090 M #10	1.062 M #10	1.065 M #10

By physical write requests

Break down by:

Detail table

Segment	Type	Current (requests)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
ORDERS_APP.ORDER_LINES	TABLE	694.1 k #1	729.8 k #1	639.1 k #1	783.7 k #1	707.9 k #1	684.4 k #1	588.6 k #1	675.2 k #1	654.1 k #1	711.4 k #1	508.8 k #2	656.7 k #1	623.4 k #1
ORDERS_APP.INVENTORY	TABLE	525.3 k #2	617.3 k #2	618.3 k #2	588.2 k #2	654.1 k #2	607.9 k #2	549.9 k #2	594.6 k #2	548.7 k #2	580.5 k #2	557.0 k #1	587.3 k #2	580.8 k #2
ORDERS_APP.ORDERS	TABLE	406.2 k #3	417.3 k #3	510.3 k #3	432.3 k #3	502.7 k #3	421.2 k #3	387.7 k #3	387.5 k #3	377.9 k #3	403.8 k #3	398.6 k #3	442.9 k #3	428.9 k #3
ORDERS_APP.ORDER_LINES_PK	INDEX	368.2 k #4	378.8 k #4	379.1 k #4	397.2 k #4	409.9 k #4	360.8 k #4	341.8 k #4	354.2 k #4	375.9 k #4	385.6 k #4	388.7 k #4	323.9 k #4	342.1 k #4
LOYALTY.LOYALTY_LEDGER	TABLE	312.4 k #5	357.8 k #5	293.0 k #5	329.8 k #5	356.5 k #5	—	—	—	—	—	—	—	—
ORDERS_APP.ORDER_LINES_ORD_IX	INDEX	264.3 k #6	257.2 k #8	248.3 k #7	255.4 k #6	276.6 k #6	241.8 k #5	239.2 k #5	238.0 k #6	238.7 k #6	242.9 k #6	260.2 k #5	253.7 k #5	234.5 k #6
ORDERS_APP.CART_ITEMS	TABLE	240.1 k #7	258.7 k #7	237.9 k #8	241.2 k #8	254.9 k #8	223.2 k #7	219.3 k #7	232.7 k #7	206.4 k #7	224.1 k #7	204.1 k #7	240.1 k #7	219.1 k #7
ORDERS_APP.PAYMENTS	TABLE	236.9 k #8	260.9 k #6	258.8 k #6	254.7 k #7	269.0 k #7	231.8 k #6	227.2 k #6	241.8 k #5	259.2 k #5	283.2 k #5	239.7 k #6	244.6 k #6	258.6 k #5
ORDERS_APP.ORDERS_PK	INDEX	185.8 k #9	194.9 k #9	214.4 k #9	—	213.9 k #9	180.5 k #9	186.8 k #8	171.8 k #9	189.3 k #8	198.2 k #8	179.9 k #8	181.6 k #9	181.6 k #8
LOYALTY.LOYALTY_LEDGER_CUST_IX	INDEX	185.2 k #10	—	197.8 k #10	194.9 k #10	—	—	—	—	—	—	—	—	—
ORDERS_APP.ORDERS_CUST_CREATED_IX	INDEX	—	185.2 k #10	—	196.2 k #9	—	188.4 k #8	184.3 k #9	186.5 k #8	179.3 k #9	173.5 k #9	172.0 k #9	193.6 k #8	175.7 k #9
SYS.WRH$_ACTIVE_SESSION_HISTORY	TABLE PARTITION	—	—	—	—	183.4 k #10	148.5 k #10	—	—	143.3 k #10	156.5 k #10	—	160.9 k #10	145.3 k #10
ORDERS_APP.INVENTORY_PK	INDEX	—	—	—	—	—	—	159.5 k #10	154.6 k #10	—	—	155.4 k #10	—	—

File I/OTop 10 data and temp files by I/O per window, and I/O by file type; ranked, not scored

By data read (MB)

Break down by:

Detail table

File	Tablespace	Current (MB)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
ts_orders_data.301.1131588213	TS_ORDERS_DATA	345.0 k #1	78.28 k #1	77.55 k #1	76.92 k #1	80.56 k #1	72.99 k #1	71.00 k #1	76.85 k #1	67.22 k #1	71.27 k #1	68.06 k #1	73.44 k #1	73.96 k #1
ts_orders_data.302.1131588221	TS_ORDERS_DATA	301.9 k #2	68.50 k #2	67.86 k #2	67.31 k #2	70.49 k #2	63.87 k #2	62.13 k #2	67.24 k #2	58.82 k #2	62.36 k #2	59.55 k #2	64.26 k #2	64.71 k #2
ts_orders_data.303.1136220407	TS_ORDERS_DATA	215.7 k #3	48.93 k #4	48.47 k #4	48.08 k #4	50.35 k #4	45.62 k #4	44.38 k #4	48.03 k #3	42.01 k #4	44.54 k #4	42.54 k #4	45.90 k #4	46.22 k #3
ts_orders_idx.304.1131588239	TS_ORDERS_IDX	57.93 k #4	50.12 k #3	49.29 k #3	49.88 k #3	51.81 k #3	47.29 k #3	46.12 k #3	46.89 k #4	45.32 k #3	44.74 k #3	45.64 k #3	47.19 k #3	45.94 k #4
ts_orders_idx.305.1131588247	TS_ORDERS_IDX	47.39 k #5	41.00 k #5	40.33 k #5	40.81 k #5	42.39 k #5	38.70 k #5	37.74 k #5	38.36 k #5	37.08 k #5	36.60 k #5	37.35 k #5	38.61 k #5	37.59 k #5
ts_loyalty.320.1146701253	TS_LOYALTY	19.39 k #6	19.16 k #6	20.46 k #6	17.82 k #6	20.07 k #6	—	—	—	—	—	—	—	—
ts_dw_data.310.1131590011	TS_DW_DATA	12.83 k #7	11.51 k #9	11.88 k #9	12.35 k #9	12.38 k #9	11.53 k #8	11.70 k #8	12.37 k #8	11.73 k #8	11.96 k #6	11.94 k #6	11.97 k #8	11.80 k #8
ts_dw_data.311.1131590019	TS_DW_DATA	12.83 k #8	11.51 k #10	11.88 k #10	12.35 k #10	12.38 k #10	11.53 k #9	11.70 k #9	12.37 k #9	11.73 k #9	11.96 k #7	11.94 k #7	11.97 k #9	11.80 k #9
temp.259.1128937717	TEMP	11.58 k #9	14.28 k #7	12.40 k #7	12.45 k #7	12.72 k #7	11.65 k #6	14.82 k #6	12.73 k #6	13.12 k #6	11.12 k #8	10.44 k #8	13.67 k #6	12.22 k #6
temp.260.1128937719	TEMP	11.58 k #10	14.28 k #8	12.40 k #8	12.45 k #8	12.72 k #8	11.65 k #7	14.82 k #7	12.73 k #7	13.12 k #7	11.12 k #9	10.44 k #9	13.67 k #7	12.22 k #7
ts_dw_stage.312.1131590027	TS_DW_STAGE	—	—	—	—	—	3,283 #10	3,306 #10	3,314 #10	3,064 #10	3,441 #10	3,472 #10	2,923 #10	3,037 #10

By data written (MB)

Break down by:

Detail table

File	Tablespace	Current (MB)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
ts_orders_data.301.1131588213	TS_ORDERS_DATA	11.93 k #1	12.87 k #3	12.88 k #1	12.93 k #1	13.52 k #1	12.23 k #1	11.21 k #3	12.06 k #3	11.61 k #3	12.41 k #1	10.81 k #1	12.27 k #3	11.91 k #1
temp.259.1128937717	TEMP	11.00 k #2	13.56 k #1	11.78 k #2	11.83 k #2	12.09 k #2	11.06 k #2	14.08 k #1	12.09 k #1	12.46 k #1	10.57 k #3	9,920 #2	12.99 k #1	11.61 k #2
temp.260.1128937719	TEMP	11.00 k #3	13.56 k #2	11.78 k #3	11.83 k #3	12.09 k #3	11.06 k #3	14.08 k #2	12.09 k #2	12.46 k #2	10.57 k #4	9,920 #3	12.99 k #2	11.61 k #3
ts_orders_data.302.1131588221	TS_ORDERS_DATA	10.43 k #4	11.26 k #4	11.27 k #4	11.31 k #4	11.83 k #4	10.70 k #4	9,811 #4	10.56 k #4	10.16 k #4	10.86 k #2	9,461 #4	10.73 k #4	10.42 k #4
undotbs1.258.1128937703	UNDOTBS1	8,971 #5	9,287 #5	9,357 #5	9,919 #5	10.42 k #5	9,983 #5	9,111 #5	9,224 #5	8,421 #5	9,915 #5	8,549 #5	9,382 #5	8,247 #5
ts_orders_idx.304.1131588239	TS_ORDERS_IDX	8,262 #6	8,399 #6	8,597 #6	8,684 #6	8,859 #6	8,017 #6	7,961 #6	7,914 #6	8,038 #6	8,071 #6	8,280 #6	7,966 #6	7,724 #6
ts_orders_data.303.1136220407	TS_ORDERS_DATA	7,453 #7	8,042 #7	8,048 #7	8,082 #7	8,451 #7	7,643 #7	7,008 #7	7,541 #7	7,256 #7	7,758 #7	6,758 #8	7,667 #7	7,446 #7
ts_orders_idx.305.1131588247	TS_ORDERS_IDX	6,760 #8	6,872 #9	7,034 #8	7,105 #8	7,248 #8	6,559 #8	6,514 #8	6,475 #8	6,577 #8	6,604 #8	6,775 #7	6,517 #8	6,320 #8
ts_loyalty.320.1146701253	TS_LOYALTY	6,479 #9	6,879 #8	6,390 #9	6,831 #9	6,788 #9	—	—	—	—	—	—	—	—
ts_dw_stage.312.1131590027	TS_DW_STAGE	3,015 #10	3,467 #10	3,243 #10	—	—	3,319 #9	3,007 #9	3,224 #9	3,013 #9	3,305 #9	2,785 #9	2,947 #10	2,607 #10
sysaux.257.1128937665	SYSAUX	—	—	—	3,207 #10	3,446 #10	2,880 #10	2,907 #10	2,820 #10	2,752 #10	2,923 #10	2,634 #10	3,031 #9	2,845 #9

By read requests

Break down by:

Detail table

File	Tablespace	Current (requests)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
ts_orders_idx.304.1131588239	TS_ORDERS_IDX	7.415 M #1	6.415 M #3	6.309 M #3	6.385 M #3	6.631 M #3	6.054 M #3	5.904 M #3	6.002 M #4	5.801 M #3	5.726 M #3	5.842 M #3	6.040 M #3	5.881 M #4
ts_orders_idx.305.1131588247	TS_ORDERS_IDX	6.066 M #2	5.249 M #5	5.162 M #5	5.224 M #5	5.425 M #5	4.953 M #5	4.830 M #5	4.910 M #5	4.746 M #5	4.685 M #5	4.780 M #5	4.942 M #5	4.811 M #5
ts_orders_data.301.1131588213	TS_ORDERS_DATA	4.907 M #3	10.02 M #1	9.927 M #1	9.846 M #1	10.31 M #1	9.343 M #1	9.088 M #1	9.837 M #1	8.605 M #1	9.123 M #1	8.711 M #1	9.400 M #1	9.467 M #1
ts_orders_data.302.1131588221	TS_ORDERS_DATA	4.294 M #4	8.767 M #2	8.686 M #2	8.615 M #2	9.023 M #2	8.175 M #2	7.952 M #2	8.607 M #2	7.529 M #2	7.982 M #2	7.623 M #2	8.225 M #2	8.283 M #2
ts_orders_data.303.1136220407	TS_ORDERS_DATA	3.067 M #5	6.262 M #4	6.204 M #4	6.154 M #4	6.445 M #4	5.840 M #4	5.680 M #4	6.148 M #3	5.378 M #4	5.702 M #4	5.445 M #4	5.875 M #4	5.917 M #3
ts_loyalty.320.1146701253	TS_LOYALTY	2.481 M #6	2.452 M #6	2.619 M #6	2.281 M #6	2.570 M #6	—	—	—	—	—	—	—	—
ts_dw_data.310.1131590011	TS_DW_DATA	252.6 k #7	226.7 k #7	233.9 k #7	243.3 k #7	243.8 k #7	227.0 k #6	230.5 k #6	243.5 k #6	231.1 k #6	235.6 k #6	235.1 k #6	235.8 k #6	232.4 k #6
ts_dw_data.311.1131590019	TS_DW_DATA	252.6 k #8	226.7 k #8	233.9 k #8	243.3 k #8	243.8 k #8	227.0 k #7	230.5 k #7	243.5 k #7	231.1 k #7	235.6 k #7	235.1 k #7	235.8 k #7	232.4 k #7
temp.259.1128937717	TEMP	105.9 k #9	130.5 k #9	113.3 k #9	113.8 k #9	116.3 k #9	106.5 k #8	135.5 k #8	116.4 k #8	119.9 k #8	101.7 k #8	95.47 k #8	125.0 k #8	111.7 k #8
temp.260.1128937719	TEMP	105.9 k #10	130.5 k #10	113.3 k #10	113.8 k #10	116.3 k #10	106.5 k #9	135.5 k #9	116.4 k #9	119.9 k #9	101.7 k #9	95.47 k #9	125.0 k #9	111.7 k #9
ts_dw_stage.312.1131590027	TS_DW_STAGE	—	—	—	—	—	64.65 k #10	65.10 k #10	65.27 k #10	60.34 k #10	67.76 k #10	68.37 k #10	57.56 k #10	59.80 k #10

By write requests

Break down by:

Detail table

File	Tablespace	Current (requests)	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
ts_orders_data.301.1131588213	TS_ORDERS_DATA	897.9 k #1	968.8 k #1	969.5 k #1	973.6 k #1	1.018 M #1	920.7 k #1	844.2 k #1	908.4 k #1	874.2 k #1	934.6 k #1	814.1 k #1	923.7 k #1	897.1 k #1
ts_orders_data.302.1131588221	TS_ORDERS_DATA	785.7 k #2	847.7 k #2	848.3 k #2	851.9 k #2	890.8 k #2	805.6 k #2	738.7 k #2	794.9 k #2	764.9 k #2	817.8 k #2	712.4 k #2	808.2 k #2	784.9 k #2
undotbs1.258.1128937703	UNDOTBS1	675.4 k #3	699.2 k #3	704.5 k #3	746.9 k #3	784.8 k #3	751.7 k #3	686.0 k #3	694.5 k #3	634.1 k #3	746.6 k #3	643.7 k #3	706.4 k #3	620.9 k #3
ts_orders_idx.304.1131588239	TS_ORDERS_IDX	622.1 k #4	632.4 k #4	647.3 k #4	653.9 k #4	667.0 k #4	603.6 k #4	599.4 k #4	595.9 k #4	605.2 k #4	607.7 k #4	623.4 k #4	599.8 k #4	581.6 k #4
ts_orders_data.303.1136220407	TS_ORDERS_DATA	561.2 k #5	605.5 k #5	605.9 k #5	608.5 k #5	636.3 k #5	575.4 k #5	527.6 k #5	567.8 k #5	546.4 k #5	584.2 k #5	508.8 k #6	577.3 k #5	560.7 k #5
ts_orders_idx.305.1131588247	TS_ORDERS_IDX	509.0 k #6	517.4 k #7	529.6 k #6	535.0 k #6	545.8 k #6	493.9 k #6	490.4 k #6	487.5 k #6	495.2 k #6	497.2 k #6	510.1 k #5	490.7 k #6	475.8 k #6
ts_loyalty.320.1146701253	TS_LOYALTY	487.8 k #7	518.0 k #6	481.1 k #7	514.3 k #7	511.1 k #7	—	—	—	—	—	—	—	—
ts_dw_stage.312.1131590027	TS_DW_STAGE	227.0 k #8	261.0 k #8	244.2 k #8	207.6 k #9	245.9 k #9	249.9 k #7	226.4 k #7	242.8 k #7	226.8 k #7	248.8 k #7	209.7 k #7	221.9 k #8	196.3 k #8
sysaux.257.1128937665	SYSAUX	206.0 k #9	240.4 k #9	243.8 k #9	241.4 k #8	259.5 k #8	216.8 k #8	218.9 k #8	212.3 k #8	207.2 k #8	220.1 k #8	198.3 k #8	228.2 k #7	214.2 k #7
ts_dw_data.310.1131590011	TS_DW_DATA	129.7 k #10	136.4 k #10	136.1 k #10	139.7 k #10	137.7 k #10	138.3 k #9	130.2 k #9	116.1 k #9	114.5 k #9	136.5 k #9	129.4 k #9	128.2 k #9	130.0 k #9
ts_dw_data.311.1131590019	TS_DW_DATA	—	—	—	—	—	138.3 k #10	130.2 k #10	116.1 k #10	114.5 k #10	136.5 k #10	129.4 k #10	128.2 k #10	130.0 k #10

I/O by file type — detail table (all four dimensions)

Metric	File type	Current	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
Data read (MB)	Data File	1.023 M #1	337.6 k #1	335.8 k #1	334.0 k #1	349.0 k #1	299.5 k #1	292.4 k #1	309.8 k #1	281.1 k #1	291.5 k #1	284.6 k #1	300.7 k #1	299.2 k #1
Data read (MB)	Temp File	23.16 k #2	28.55 k #2	24.79 k #2	24.90 k #2	25.45 k #2	23.29 k #2	29.64 k #2	25.46 k #2	26.23 k #2	22.24 k #2	20.88 k #2	27.35 k #2	24.44 k #2
Data read (MB)	Log File	274.0 #3	281.0 #3	292.0 #3	285.0 #3	284.0 #3	235.0 #3	214.0 #3	238.0 #3	224.0 #3	232.0 #3	219.0 #3	239.0 #3	229.0 #3
Data read (MB)	Archive Log	137.0 #4	140.0 #4	146.0 #4	142.0 #4	142.0 #4	117.0 #4	107.0 #4	119.0 #4	112.0 #4	116.0 #4	110.0 #4	119.0 #4	114.0 #4
Data read (MB)	Control File	24.00 #5	25.00 #5	25.00 #5	25.00 #5	25.00 #5	24.00 #5	23.00 #5	24.00 #5	23.00 #5	23.00 #5	23.00 #5	24.00 #5	23.00 #5
Data read (MB)	Other	6.000 #6	6.000 #6	6.000 #6	6.000 #6	6.000 #6	6.000 #6	6.000 #6	6.000 #6	6.000 #6	6.000 #6	6.000 #6	6.000 #6	6.000 #6
Data written (MB)	Data File	69.65 k #1	74.06 k #1	73.84 k #1	74.72 k #1	77.68 k #1	65.18 k #1	61.15 k #1	63.07 k #1	61.02 k #1	65.66 k #1	59.65 k #1	64.09 k #1	61.13 k #1
Data written (MB)	Temp File	22.00 k #2	27.12 k #2	23.55 k #2	23.65 k #2	24.17 k #2	22.13 k #2	28.16 k #2	24.18 k #2	24.92 k #2	21.13 k #2	19.84 k #2	25.98 k #2	23.22 k #2
Data written (MB)	Log File	13.98 k #3	14.33 k #3	14.91 k #3	14.51 k #3	14.51 k #3	11.98 k #3	10.92 k #3	12.13 k #3	11.43 k #3	11.81 k #3	11.19 k #3	12.17 k #3	11.66 k #3
Data written (MB)	Archive Log	13.71 k #4	14.05 k #4	14.62 k #4	14.23 k #4	14.22 k #4	11.74 k #4	10.70 k #4	11.89 k #4	11.20 k #4	11.58 k #4	10.97 k #4	11.93 k #4	11.43 k #4
Data written (MB)	Flashback Log	4,797 #5	4,916 #5	5,115 #5	4,980 #5	4,977 #5	4,109 #5	3,746 #5	4,161 #5	3,921 #5	4,051 #5	3,839 #5	4,175 #5	4,000 #5
Data written (MB)	Control File	13.00 #6	13.00 #6	14.00 #6	13.00 #6	14.00 #6	13.00 #6	13.00 #6	13.00 #6	13.00 #6	13.00 #6	12.00 #6	13.00 #6	13.00 #6
Data written (MB)	Other	2.000 #7	2.000 #7	2.000 #7	2.000 #7	2.000 #7	2.000 #7	2.000 #7	2.000 #7	2.000 #7	2.000 #7	2.000 #7	2.000 #7	2.000 #7
Read requests	Data File	28.93 M #1	39.79 M #1	39.53 M #1	39.16 M #1	41.06 M #1	34.98 M #1	34.07 M #1	36.14 M #1	32.66 M #1	33.85 M #1	33.02 M #1	35.10 M #1	34.96 M #1
Read requests	Control File	1.803 M #2	831.1 k #2	918.8 k #2	1.066 M #2	1.026 M #2	752.4 k #2	784.6 k #2	1.087 M #2	862.1 k #2	865.8 k #2	1.536 M #2	757.7 k #2	844.6 k #2
Read requests	Temp File	211.8 k #3	261.0 k #3	226.7 k #3	227.6 k #3	232.6 k #3	213.0 k #3	271.0 k #3	232.7 k #3	239.8 k #3	203.4 k #3	190.9 k #3	250.1 k #3	223.5 k #3
Read requests	Log File	29.28 k #4	28.33 k #4	29.26 k #4	28.16 k #4	29.74 k #4	27.99 k #4	27.32 k #4	28.45 k #4	27.33 k #4	28.76 k #4	24.94 k #4	27.39 k #4	27.82 k #4
Read requests	Other	905.0 #5	936.0 #5	951.0 #5	938.0 #5	961.0 #5	892.0 #5	855.0 #5	879.0 #5	862.0 #5	873.0 #5	838.0 #5	878.0 #5	858.0 #5
Read requests	Archive Log	40.00 #6	42.00 #6	42.00 #6	42.00 #6	43.00 #6	40.00 #6	38.00 #6	39.00 #6	38.00 #6	39.00 #6	37.00 #6	39.00 #6	38.00 #6
Read requests	Flashback Log	30.00 #7	30.00 #7	30.00 #7	30.00 #7	30.00 #7	30.00 #7	30.00 #7	30.00 #7	30.00 #7	30.00 #7	30.00 #7	30.00 #7	30.00 #7
Write requests	Data File	5.244 M #1	5.576 M #1	5.560 M #1	5.626 M #1	5.849 M #1	4.908 M #1	4.604 M #1	4.749 M #1	4.595 M #1	4.944 M #1	4.491 M #1	4.825 M #1	4.603 M #1
Write requests	Log File	1.464 M #2	1.416 M #2	1.463 M #2	1.408 M #2	1.487 M #2	1.400 M #2	1.366 M #2	1.423 M #2	1.367 M #2	1.438 M #2	1.247 M #2	1.369 M #2	1.391 M #2
Write requests	Temp File	176.0 k #3	217.0 k #3	188.4 k #3	189.2 k #3	193.4 k #3	177.0 k #3	225.3 k #3	193.5 k #3	199.4 k #3	169.0 k #3	158.7 k #3	207.9 k #3	185.8 k #3
Write requests	Control File	82.23 k #4	59.64 k #4	60.44 k #4	60.73 k #4	57.71 k #4	43.62 k #4	53.81 k #4	50.30 k #4	48.44 k #4	50.90 k #4	63.10 k #4	47.76 k #4	45.57 k #4
Write requests	Flashback Log	3,998 #5	4,097 #5	4,263 #5	4,150 #5	4,148 #5	3,424 #5	3,122 #5	3,468 #5	3,268 #5	3,376 #5	3,199 #5	3,479 #5	3,333 #5
Write requests	Archive Log	3,427 #6	3,512 #6	3,654 #6	3,557 #6	3,555 #6	2,935 #6	2,676 #6	2,972 #6	2,801 #6	2,894 #6	2,742 #6	2,982 #6	2,857 #6
Write requests	Other	322.0 #7	333.0 #7	338.0 #7	334.0 #7	342.0 #7	317.0 #7	304.0 #7	312.0 #7	307.0 #7	310.0 #7	298.0 #7	312.0 #7	305.0 #7

ParametersInitialization parameters whose value differs across the windows

Parameter	Current	−1w	−2w	−3w	−4w	−5w	−6w	−7w	−8w	−9w	−10w	−11w	−12w
`cursor_sharing`	`FORCE`	`FORCE`	`FORCE`	`FORCE`	`FORCE`	`FORCE`	`FORCE`	`FORCE`	`FORCE`	`FORCE`	≠ `EXACT`	≠ `EXACT`	≠ `EXACT`
`optimizer_adaptive_plans`	`TRUE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`	≠ `FALSE`
`pga_aggregate_target`	`12884901888`	`12884901888`	`12884901888`	`12884901888`	`12884901888`	≠ `8589934592`	≠ `8589934592`	≠ `8589934592`	≠ `8589934592`	≠ `8589934592`	≠ `8589934592`	≠ `8589934592`	≠ `8589934592`
`sga_target`	`68719476736`	`68719476736`	`68719476736`	`68719476736`	`68719476736`	`68719476736`	`68719476736`	`68719476736`	≠ `51539607552`	≠ `51539607552`	≠ `51539607552`	≠ `51539607552`	≠ `51539607552`

4 parameters changed across the compared windows.

Reading the chartsWhat each chart and glyph on this page encodes

Band

Dot = Current, in σ from the prior mean. Shaded = normal (±1σ, ±2σ); ticks at ±2σ and ±3σ. Filled = finding, hollow = normal; past +8σ the dot pins and prints its z.

▲ ×5.4▲ 22.5%▼ 4.2%

Δ vs mean

×n when Current is at least twice the prior mean, else a percentage. Red or amber only on a finding.

13-window chart

One column per compared window, oldest left; Current last, wider, indigo. Band = normal range, line = mean, dot = finding.

Full-span activity

Top of every view: active sessions over the whole span as stacked areas, hourly (or the shorter cadence), by wait class and by wait event (the 14 largest, the rest as Other events); zoomed to 6 hours or less, the compared windows minute by minute. Stripes = compared windows (Current indigo, pinned amber, skipped grey). Hover for each series’ AAS, drag across either chart to zoom both, double-click to reset; a legend item hides its series, a stripe pins its window. Hover a class or event to highlight it: from the legend it is drawn from zero, its own axis; a class lights its events below. Click its band (or Shift+click the legend) to keep it, Esc clears.

Activity per window

Timeline Activity lane (all sessions) and the DB time card (foreground sessions only, ASH’s estimate of DB time): one stacked column per compared window, same wait classes. Current labels its two largest classes.

Span chart

All sections: active sessions by wait class across the whole span. Compared windows shaded, Current in indigo.

Trend

A table row’s windows as bars from zero, oldest left: shaded = normal range, indigo = Current. Hover a strip for the last four values and the normal range.

Release marker

A release or patch, on the boundary between the two windows it fell between. Its line runs down every chart.

Step line

Parameters and plan hashes step where the value changed. Dot = the change; labels = old and new value.

◆ plan changed✚ first seen▽ DOP downgrade

Glyphs

Drawn in the window where it happened.

Day profile

Last 24 h by hour vs the same hour on the prior days, one row per stat: red above, blue below (signed z). A triangle marks a flagged hour; the line chart below it plots one stat: pick it with its button (the dot and counts say how unusual its day is), a row label, or the arrow keys.

Hover and pin

Timeline: hover a column for its values; click a date or an ASH stripe to pin it. The gutter then compares against it (“vs 13 Aug”); Current or Esc clears it.

About this reportMethod, sources and thresholds behind every section

Scoring: z = (Current − μ) ÷ max(σ, 2% of |μ|) over the prior valid windows. |z| > 3 is large, |z| > 2 moderate, else normal — but only when the move is material: |Δ| ≥ 10% and, for wait classes, ≥ 2% of the Current window’s wait time (otherwise normal, tagged immaterial). Each metric has its own direction and floors (sql/lib/metric_policy.plsql): a move in the good direction is improved, an informational counter is noted — neither is highlighted or counted. Twins (the SYSMETRIC rate of a SYSSTAT counter, the CPU half of the CPU/wait ratio) are shown muted and never counted. Fewer than 3 prior values: Δ only. |z| beyond ±99 is capped for display; σ≈0 flags a baseline that barely moved.
Band and Δ: The band plots Current in σ from the prior mean on one scale for the whole page (−4 to +8σ). Normal range = μ ± 2σ in the row’s own unit. Δ vs mean reads ×n at twice the mean or more, else a percentage.
Windows: One window per step back from 2026-09-10 10:00:00, 1h wide, every 1w. A window is skipped (and dropped from every baseline) when a snapshot is missing, the begin and end snapshot are the same, the instance restarted inside it, it straddles a DBID change, or its nearest snapshot is more than 15 minutes off the window edge.
DB time: DB CPU (dba_hist_sys_time_model, foreground) plus non-idle wait time (dba_hist_system_event, all sessions incl. background) per snapshot interval, stacked by wait class, from the earliest compared window to Current. Not a strict foreground DB-time profile. A snapshot pair across an instance restart is a gap.
Verdict: One sentence from the first two finding cards (the loudest card, then DB time when it is flagged): the lead metric and its move, ×n at twice the mean or more, else a percentage. For DB time, where the extra time went: CPU vs wait from DB CPU against DB time. Likely source: a statement that ran with a new plan in the Current window, else a newcomer in the top SQL by physical reads, else a statement first seen this window, else the segment the extra reads land on. Fixed phrases, no free text.
Finding cards: One card per metric family of the scoring policy (sql/lib/metric_policy.plsql); families that tell one story share a card: Physical I/O (physical and logical reads, long table scans, User I/O waits), DB time (DB time, the CPU / wait ratio, response time), Network (Network waits, SQL*Net bytes), Commit (Commit waits, commits), Parsing, Writes and redo. A card is led by its loudest large, else moderate, metric of the card’s main family. Twins are folded under related metrics and never counted.
DB time strip: DBA_HIST_SYSSTAT DB time per compared window, divided by 100 (centiseconds per second = average active sessions); release markers sit on the boundary between the two windows they fall between.
Checked and normal: Every other scored metric: the normal ones, loudest first; moved, too small to matter = past |z| 2 but under the metric’s materiality floor, or an informational counter; improved = a material move in the good direction. None of them is counted.
What changed around it: Plan change: a statement that ran in the Current window with a plan other than the prior windows’ most frequent one (SQL Monitor). Its bars are its elapsed seconds per window from DBA_HIST_SQLSTAT; the step line is the most frequent captured plan per window, carried over windows with no capture; only the SQL Monitor max elapsed is scored. Configuration: every changed parameter as a step line.
Evidence library: Summary view: every other section as one row with a one-line status and its counts; open a row to read the section in place. All sections shows every section in full.
ASH timeline: dba_hist_active_sess_history over the full span, one scan: hourly (or the cadence) in All sections; at the top of every view (Activity, whole span) on the same grid (coarser only past 10000 buckets), by wait class and by wait event (the 14 events with the most samples, ties by name, the rest summed as Other events), plus each compared window’s own values (samples ÷ 360 ÷ window hours; overlapping windows each count a shared sample) and a 1-minute series inside the compared windows (samples ÷ 6, each minute once; at most 40000 minutes, the most recent windows first), drawn when zoomed to 6 hours or less. ON CPU is CPU in both; Idle excluded. Compared windows shaded. ASH is not scored. Each event carries its wait class from the same scan, so highlighting a class lights its events (and an event its class); a highlighted series is re-stacked from zero on its own y axis, the others faded above it.
Timeline: One column per compared window, one row per metric, from the same values and scoring as the tables: the headline and every flagged load / metric row, flagged wait classes and the top foreground events, the top segments and datafile by reads, the top statements by elapsed (SQL Monitor rows for a plan change or a DOP downgrade), changed parameters. Statement, segment and file rows are ranked, not scored: a plain ratio against the mean of the prior windows they made the top list in. Needs JavaScript; every number is also in All sections.
Day profile: Each hour of the 24 h ending at the report end against the same hour-of-day on the 7 prior days, independent of the report cadence. Per-second rates from DBA_HIST_SYSSTAT snapshot deltas (restart-guarded); an hour covered by less than 30 minutes of snapshots is left blank. Cells are scored like the findings (at least 3 prior values). A stat flagged in 12 or more hours in the same direction is one day-wide shift, not isolated hours. The heatmap shows signed z.
Utilization: Workload volume and shape (transaction, call and logon rates, session counts, data and network volume) from DBA_HIST_SYSMETRIC_SUMMARY, averaged over each window. A usage overview, not a health check: the band is drawn but never scored.
Load profile: DBA_HIST_SYSSTAT (end − begin snapshot) ÷ window seconds, summed across instances. Trend: per-window values as bars, oldest to Current, over the shaded normal range. Current cell bar = value ÷ row maximum.
System metrics: DBA_HIST_SYSMETRIC_SUMMARY averaged over each window. Rates and counters: SUM across instances per snapshot, then AVG; ratios and latencies: AVG across instances per snapshot, then AVG. Units per metric name.
Wait events: Foreground: DBA_HIST_SYSTEM_EVENT; background: DBA_HIST_BG_EVENT_SUMMARY. Idle excluded. Top 10 events by time waited (s) and by average latency (ms = time waited ÷ total waits); the chart stacks wait-class time per window. When five or more flagged events moved together within a narrow band, the table notes one table-wide shift and demotes large rows to moderate.
Top SQL: Top 10 statements per ranking and window from DBA_HIST_SQLSTAT *_DELTA columns; ranked, not scored. The bump chart draws one line per statement across the windows; Break down by re-aggregates by parsing schema, module or action.
Top SQL ASH: For each statement in the Top SQL pool: ASH samples per bucket split by wait event (top 7 per statement, the rest as Other; CPU = ON CPU). Statements with fewer than 5 samples are placeholders.
SQL Monitor: Executions persisted by SQL Monitor (DBA_HIST_REPORTS, component_name='sqlmonitor'), summaries only. Only completed, expensive-enough or parallel executions are persisted, so a statement’s absence does not mean it ran fast and row counts are not execution rates. An execution still running at the report end has no row yet. Rows are attributed to a window by execution start time. The table is scored on max elapsed time (rule above); the scatter plots every captured execution.
Segment and file I/O: Segments: DBA_HIST_SEG_STAT *_DELTA joined to DBA_HIST_SEG_STAT_OBJ; reads and writes in blocks, requests in I/O calls. Files: DBA_HIST_FILESTATXS / DBA_HIST_TEMPSTATXS deltas, blocks scaled to MB by block size; the file-type view is DBA_HIST_IOSTAT_FILETYPE (all database I/O, so its totals differ). Ranked, not scored; the type rollups cover all segments and files.
Parameters: Initialization parameters from dba_hist_parameter whose value differs across the compared windows (value as of each window’s end snapshot, lowest container wins in a CDB). Highlighted cells differ from Current; — = not present at that snapshot; (unset) = present but empty.

Run 20260910101512483 · template comprehensive · top_n 10 · generated 2026-09-10 10:15:12 +02:00 by AWR_READER · read-only against DBA_HIST_*, no scratch schema.

Activity, whole spanASH active sessions across every compared window, by wait class and by wait event

By wait class

By wait event

Physical reads 5.4× normal; DB time up 79.7%, mostly wait.

TimelineDown a column: one window. Across a row: when it started.

All sectionsEvery table of the report

Database timeDB CPU plus non-idle waits across the full span, by wait class

Active sessionsASH by wait class, hourly, 2026-06-18 09:00 → 2026-09-10 10:00; compared windows shaded

4 findingsFindings10 large1 moderate30 normal5 folded11 metrics moved, in 4 familiesEvery scored metric against its prior windows; one table per domain