AWR Timeline Comparison — run 20260706212304484

Aligned windows

One bar per window. Dimmed = skipped (missing snap, zero-length, or instance restart) and dropped from the z-score baseline.

Hour	Window start	Window end	Begin snap	End snap	Status
Current	2026-07-06 Mon 19:00	2026-07-06 Mon 20:00	3117	3121	valid
−1h	2026-07-06 Mon 18:00	2026-07-06 Mon 19:00	3113	3117	valid
−2h	2026-07-06 Mon 17:00	2026-07-06 Mon 18:00	3109	3113	valid
−3h	2026-07-06 Mon 16:00	2026-07-06 Mon 17:00	3105	3109	valid
−4h	2026-07-06 Mon 15:00	2026-07-06 Mon 16:00	3101	3105	valid

Generate full AWR reports for these windows

Copy into SQL*Plus to spool a standard Oracle AWR report for each window above (Diagnostic Pack required). Skipped windows are commented out; swap _HTML for _TEXT in the call for a plain-text report.

-- 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-07-06 19:00 -> 2026-07-06 20:00  (dbid 1183716798, snaps 3117 -> 3121)
SPOOL awr_1183716798_all_3117_3121.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1183716798, NULL, 3117, 3121));
SPOOL OFF

-- -1h: 2026-07-06 18:00 -> 2026-07-06 19:00  (dbid 1183716798, snaps 3113 -> 3117)
SPOOL awr_1183716798_all_3113_3117.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1183716798, NULL, 3113, 3117));
SPOOL OFF

-- -2h: 2026-07-06 17:00 -> 2026-07-06 18:00  (dbid 1183716798, snaps 3109 -> 3113)
SPOOL awr_1183716798_all_3109_3113.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1183716798, NULL, 3109, 3113));
SPOOL OFF

-- -3h: 2026-07-06 16:00 -> 2026-07-06 17:00  (dbid 1183716798, snaps 3105 -> 3109)
SPOOL awr_1183716798_all_3105_3109.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1183716798, NULL, 3105, 3109));
SPOOL OFF

-- -4h: 2026-07-06 15:00 -> 2026-07-06 16:00  (dbid 1183716798, snaps 3101 -> 3105)
SPOOL awr_1183716798_all_3101_3105.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1183716798, NULL, 3101, 3105));
SPOOL OFF

Load profile — per-second rates

DBA_HIST_SYSSTAT (end − begin) ÷ window seconds. Trend: per-window values, oldest → current. Current cell bar = value ÷ row max.

Metric	Current	−1h	−2h	−3h	−4h
DB time (cs/s, 1/100s)	106.54	100.62	100.31	99.71	99.69
DB CPU (cs/s, 1/100s)	—	—	—	—	—
redo size (bytes/s)	355,173.60	348,416.86	351,981.73	370,894.40	363,003.85
session logical reads (/s)	18,459.94	17,400.10	18,017.63	19,222.33	19,189.86
physical reads (/s)	461.55	432.11	445.23	476.67	468.53
physical read total bytes (bytes/s)	4,477,153.14	4,108,526.22	4,183,062.04	4,455,679.29	4,346,123.66
physical writes (/s)	294.79	281.47	288.67	306.80	302.16
physical write total bytes (bytes/s)	4,623,336.11	4,457,345.99	5,431,190.76	5,679,389.44	4,553,170.06
user calls (/s)	199.11	190.49	197.62	210.70	209.71
execute count (/s)	1,203.56	1,163.79	1,207.05	1,286.59	1,285.66
user commits (/s)	41.73	40.16	41.69	44.58	44.30
user rollbacks (/s)	0.00	0.00	0.00	0.00	0.00
parse count (total) (/s)	89.64	85.49	88.51	94.15	93.58
parse count (hard) (/s)	0.0722	0.0067	0.0275	0.0283	0.0175
parse count (failures) (/s)	0.001667	0.000000	0.000000	0.000000	0.000000
logons cumulative (/s)	0.1764	0.1725	0.1664	0.1719	0.1694
opened cursors cumulative (/s)	1,203.36	1,163.73	1,206.97	1,286.54	1,285.52
redo writes (/s)	42.03	40.43	41.96	44.86	44.60
sorts (memory) (/s)	1.87	1.60	1.62	1.68	1.58
sorts (disk) (/s)	0.00	0.00	0.00	0.00	0.00
sorts (rows) (/s)	64.46	60.14	60.31	61.07	60.47
table scans (long tables) (/s)	0.003611	0.001389	0.001389	0.005278	0.001389
table fetch by rowid (/s)	11,198.65	10,182.90	10,541.62	11,222.97	11,232.40
CPU used by this session (cs/s, 1/100s)	11.35	10.44	10.81	11.53	12.04
bytes received via SQL*Net from client (bytes/s)	19,302.57	18,164.15	18,849.66	20,082.37	19,955.01
bytes sent via SQL*Net to client (bytes/s)	34,587.93	8,519.35	8,827.53	9,383.08	9,287.10
redo size for lost write detection (/s)	26,000.50	33,144.60	34,171.62	36,544.25	35,981.68

System metrics (DBA_HIST_SYSMETRIC_SUMMARY)

AVG(sm.average) over each window. Additive metrics (rates, counters): SUM across instances per snap, then AVG; ratios & latencies: AVG across instances per snap, then AVG. Trend: per-window values, oldest → current. Units per metric name (*_Per_Sec etc.).

Metric	Unit	Current	−1h	−2h	−3h	−4h
Average Active Sessions	Active Sessions	0.9284	0.9110	0.9083	0.9015	0.9005
Host CPU Utilization (%)	% Busy/(Idle+Busy)	9.42	7.99	7.99	8.53	10.02
Database CPU Time Ratio	% Cpu/DB_Time	13.30	12.26	12.77	13.68	14.38
Database Wait Time Ratio	% Wait/DB_Time	86.70	87.74	87.23	86.32	85.62
Session Count	Sessions	105.37	105.97	106.25	107.45	105.80
Redo Generated Per Sec	Bytes Per Second	355,772.43	346,712.83	351,469.81	369,927.50	362,145.31
Physical Read Total Bytes Per Sec	Bytes Per Second	4,471,501.56	4,091,352.91	4,190,069.31	4,434,511.01	4,335,791.45
Physical Write Total Bytes Per Sec	Bytes Per Second	4,600,085.83	4,444,396.94	5,432,364.49	5,659,978.10	4,545,890.77
Physical Read Total IO Requests Per Sec	Requests Per Second	451.12	421.16	434.15	460.38	454.71
Physical Write Total IO Requests Per Sec	Requests Per Second	269.46	254.55	262.95	278.09	272.86
Average Synchronous Single-Block Read Latency	Milliseconds	0.9026	0.9045	0.8487	0.7664	0.7636
Logical Reads Per Sec	Reads Per Second	18,500.03	17,317.97	17,997.80	19,178.96	19,143.51
Executions Per Sec	Executes Per Second	1,206.09	1,158.55	1,205.43	1,283.87	1,282.38
User Calls Per Sec	Calls Per Second	199.53	189.62	197.37	210.23	209.15
User Commits Per Sec	Commits Per Second	41.82	39.96	41.64	44.47	44.19
User Rollbacks Per Sec	Rollbacks Per Second	0.00	0.00	0.00	0.00	0.00
Hard Parse Count Per Sec	Parses Per Second	0.0692	0.0067	0.0275	0.0283	0.0175
Total Parse Count Per Sec	Parses Per Second	89.76	85.13	88.39	93.94	93.32
Logons Per Sec	Logons Per Second	0.1760	0.1720	0.1686	0.1691	0.1692
Network Traffic Volume Per Sec	Bytes Per Second	53,413.46	26,565.74	27,638.71	29,404.38	29,155.21
SQL Service Response Time	CentiSeconds Per Call	0.0693	0.0649	0.0618	0.0577	0.0577
Physical Reads Per Sec	Reads Per Second	462.14	429.98	444.75	475.53	467.36
Physical Writes Per Sec	Writes Per Second	295.18	280.00	288.36	305.97	301.53

Foreground wait events (top 10 by time waited)

DBA_HIST_SYSTEM_EVENT, foreground waits, Idle excluded. Chart stacks wait_class time per window. Tables: top-10 by time_waited (s) and by avg latency (ms = time_waited ÷ total_waits).

Top 10 events — time waited (s)

Event	Current (s)	−1h (s)	−2h (s)	−3h (s)	−4h (s)	Change	z-score	% Δ
db file async I/O submit	2,805.67 #1	2,864.46	2,889.52	2,867.12	2,795.14	typical	-1.18	-1.7%
db file sequential read	1,680.39 #2	1,635.43	1,594.31	1,553.44	1,559.81	moderate	+2.51	+6.0%
log file sync	1,091.38 #3	1,203.17	1,224.21	1,218.36	1,193.29	large	-8.39	-9.8%
log file parallel write	987.16 #4	1,072.05	1,100.77	1,084.15	1,036.78	large	-3.18	-8.0%
Redo Transport MISC	642.77 #5	841.57	842.95	853.36	875.56	large	-13.41	-24.7%
SYNC Remote Write	127.22 #6	161.05	152.85	163.34	187.80	moderate	-2.59	-23.5%
flashback log file write	96.19 #7	97.29	137.43	125.82	86.60	typical	-0.66	-14.0%
db file parallel read	87.96 #8	76.52	77.35	74.47	71.15	large	+4.74	+17.5%
control file parallel write	86.89 #9	89.13	71.80	57.57	45.64	typical	+1.11	+31.6%
log file switch (archiving needed)	79.35 #10	—	—	—	—	insufficient history	—	—
log file switch (checkpoint incomplete)	—	24.55	—	27.14	24.35	insufficient history	—	—
Disk file operations I/O	—	—	26.41	—	—	insufficient history	—	—

Top 10 events — avg time per wait (ms)

Event	Current (ms)	−1h (ms)	−2h (ms)	−3h (ms)	−4h (ms)	Change	z-score	% Δ
db file async I/O submit	383.55	390.63	390.69	371.92	366.00	typical	+0.29	+1.0%
db file sequential read	1.14	1.18	1.11	1.02	1.03	typical	+0.78	+5.5%
log file sync	7.24	8.31	8.14	7.57	7.46	typical	-1.53	-8.1%
log file parallel write	6.52	7.37	7.29	6.71	6.46	typical	-1.00	-6.4%
Redo Transport MISC	3.62	3.60	3.44	3.28	3.47	typical	+1.30	+4.9%
SYNC Remote Write	0.70	0.69	0.62	0.63	0.74	typical	+0.43	+3.7%
flashback log file write	8.14	8.34	9.20	8.36	7.71	typical	-0.43	-3.2%
db file parallel read	4.20	4.00	3.95	3.51	3.42	typical	+1.64	+13.0%
control file parallel write	10.17	10.85	10.61	10.24	9.54	typical	-0.24	-1.3%
log file switch (archiving needed)	19,837.90	—	—	—	—	insufficient history	—	—
log file switch (checkpoint incomplete)	—	663.48	—	733.46	608.83	insufficient history	—	—
Disk file operations I/O	—	—	10.02	—	—	insufficient history	—	—

Wait-class rollup — time waited (s)

Wait class	Current (s)	−1h (s)	−2h (s)	−3h (s)	−4h (s)	Change	z-score	% Δ
System I/O	3,979.68	4,124.47	4,200.91	4,136.24	3,965.87	typical	-1.27	-3.1%
User I/O	1,798.00	1,736.35	1,706.39	1,657.41	1,648.94	moderate	+2.68	+6.6%
Commit	1,091.38	1,203.17	1,224.21	1,218.36	1,193.29	large	-8.39	-9.8%
Other	830.71	1,047.68	1,032.72	1,057.64	1,103.57	large	-7.52	-21.7%
Configuration	118.23	39.88	20.94	31.78	37.20	large	+10.23	+264.4%
Concurrency	1.96	0.19	8.52	2.29	1.24	typical	-0.30	-36.1%
Network	1.17	1.05	1.10	1.17	1.28	typical	+0.17	+1.4%
Application	0.06	0.05	0.05	0.06	0.06	typical	+1.12	+9.4%

Background wait events

DBA_HIST_BG_EVENT_SUMMARY, Idle excluded. Chart stacks wait_class time per window. Tables: time_waited (s) and avg latency (ms = time_waited ÷ total_waits).

Events — time waited (s)

Event	Current (s)	−1h (s)	−2h (s)	−3h (s)	−4h (s)	Change	z-score	% Δ
db file async I/O submit	2,805.21 #1	2,864.93	2,889.52	2,867.12	2,795.14	typical	-1.20	-1.7%
log file parallel write	987.11 #2	1,072.09	1,100.76	1,084.14	1,036.77	large	-3.18	-8.0%
Redo Transport MISC	642.74 #3	841.60	842.95	853.35	875.57	large	-13.41	-24.7%
SYNC Remote Write	127.22 #4	161.05	152.85	163.34	187.80	moderate	-2.59	-23.5%
flashback log file write	96.19 #5	97.27	137.45	125.82	86.60	typical	-0.65	-14.0%
control file parallel write	86.89 #6	89.13	71.80	57.57	45.64	typical	+1.11	+31.6%
log file switch (archiving needed)	21.40 #7	—	—	—	—	insufficient history	—	—
enq: CR - block range reuse ckpt	18.46 #8	22.77	14.05	18.65	18.33	typical	+0.00	+0.1%
db file sequential read	15.20 #9	—	15.06	16.27	14.26	typical	+0.00	+0.0%
Disk file operations I/O	14.40 #10	15.87	26.39	18.85	—	typical	-1.10	-29.3%
Redo Transport Open	—	14.61	15.57	13.83	12.11	insufficient history	—	—
undo segment extension	—	14.12	—	—	12.18	insufficient history	—	—

Events — avg time per wait (ms)

Event	Current (ms)	−1h (ms)	−2h (ms)	−3h (ms)	−4h (ms)	Change	z-score	% Δ
db file async I/O submit	383.54	390.64	390.69	371.92	366.00	typical	+0.29	+1.0%
log file parallel write	6.52	7.37	7.29	6.71	6.46	typical	-1.00	-6.4%
Redo Transport MISC	3.62	3.60	3.44	3.28	3.47	typical	+1.30	+4.9%
SYNC Remote Write	0.70	0.69	0.62	0.63	0.74	typical	+0.43	+3.7%
flashback log file write	8.14	8.34	9.20	8.36	7.71	typical	-0.44	-3.2%
control file parallel write	10.17	10.85	10.61	10.24	9.54	typical	-0.24	-1.3%
log file switch (archiving needed)	10,701.91	—	—	—	—	insufficient history	—	—
enq: CR - block range reuse ckpt	923.24	734.66	937.00	932.64	872.69	typical	+0.57	+6.2%
db file sequential read	2.28	—	2.24	2.24	1.94	typical	+0.78	+6.3%
Disk file operations I/O	7.62	10.11	17.13	11.34	—	typical	-1.40	-40.8%
Redo Transport Open	—	228.22	243.35	197.50	178.12	insufficient history	—	—
undo segment extension	—	344.34	—	—	380.68	insufficient history	—	—

Top SQL (top 10 per dimension, per window)

Top-10 SQLs per dimension per window from DBA_HIST_SQLSTAT *_DELTA. Bump chart per dimension: each line = one SQL across windows, oldest → current. Use the Break down by toggle to re-aggregate the same metric by SQL_ID, parsing schema, module, or action instead. Detail tables collapsed; click to expand.

By elapsed time

Break down by:

Detail table

SQL_ID	PHV (cur)	Current (s)	−1h	−2h	−3h	−4h	SQL
3n4tadqgd9b9r	0	1,372.99 #1	1,276.39	1,258.77	1,245.64	1,267.93	BEGIN :1 := orderentry.neworder(:2,:3,:4); END;
g81cbrq5yamf5	2480532011	310.72 #2	287.91	293.71	287.67	287.52	SELECT ADDRESS_ID, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, STREET_NAME, TOWN, COUNTY, COUNTRY, POST_CODE, ZIP_CODE FROM ADDRESSES WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
21ss57x3bykp3	0	302.65 #3	303.49	296.21	289.68	283.18	BEGIN :1 := orderentry.newcustomer(:2,:3,:4,:5,:6,:7,:8,:9,:10); END;
7ws837zynp1zv	3722429161	252.30 #4	248.52	263.86	260.14	243.02	SELECT CARD_ID, CUSTOMER_ID, CARD_TYPE, CARD_NUMBER, EXPIRY_DATE, IS_VALID, SECURITY_CODE FROM CARD_DETAILS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
f7rxuxzt64k87	0	224.95 #5	232.82	201.51	197.71	225.98	INSERT INTO ORDER_ITEMS ( ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, GIFT_WRAP, CONDITION, ESTIMATED_DELIVERY ) VALUES ( :B4 , :B3 , :B2 , :B1 , 1, 'None', 'New', (S…
3fw75k1snsddx	494735477	223.36 #6	216.94	206.68	202.11	205.64	INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, WAREHOUSE_ID, DELIVERY_TYPE, DELIVERY_ADDRESS_ID, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, CUSTO…
5ckxyqfvu60pj	900611645	171.99 #7	173.79	173.58	166.26	168.64	SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSH…
ajjqqrmacwv34	0	140.35 #8	139.77	140.25	137.59	135.18	BEGIN :1 := orderentry.browseandupdateorders(:2,:3,:4); END;
06gapn9jpn8p1	0	137.27 #9	137.33	132.55	129.73	126.04	BEGIN :1 := orderentry.updateCustomerDetails(:2,:3,:4,:5,:6,:7,:8); END;
gh2g2tynpcpv1	0	133.38 #10	—	—	—	—	INSERT INTO CUSTOMERS ( CUSTOMER_ID , CUST_FIRST_NAME , CUST_LAST_NAME , NLS_LANGUAGE , NLS_TERRITORY , CREDIT_LIMIT , CUST_EMAIL , ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, …
9t3n2wpr7my63	—	—	137.48	131.35	130.98	127.58	INSERT INTO ADDRESSES ( ADDRESS_ID, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, STREET_NAME, TOWN, COUNTY, COUNTRY, POST_CODE, ZIP_CODE ) VALUES ( :B6 , :B5 , TRUNC(SYSDATE,'MI'),…

By CPU time

Break down by:

Detail table

SQL_ID	PHV (cur)	Current (s)	−1h	−2h	−3h	−4h	SQL
3n4tadqgd9b9r	0	225.78 #1	211.08	219.01	233.15	246.11	BEGIN :1 := orderentry.neworder(:2,:3,:4); END;
7yhuvsmwggtqn	0	91.24 #2	87.22	90.68	96.17	99.31	BEGIN :1 := orderentry.browseproducts(:2,:3,:4); END;
c13sma6rkr27c	2393254267	63.69 #3	60.66	63.13	67.22	69.19	SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY…
0y1prvxqc2ra9	1905787423	53.93 #4	51.33	53.59	56.54	58.46	SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY…
21ss57x3bykp3	0	28.03 #5	25.57	26.94	28.86	30.30	BEGIN :1 := orderentry.newcustomer(:2,:3,:4,:5,:6,:7,:8,:9,:10); END;
3fw75k1snsddx	494735477	25.80 #6	22.34	22.85	24.31	26.13	INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, WAREHOUSE_ID, DELIVERY_TYPE, DELIVERY_ADDRESS_ID, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, CUSTO…
f7rxuxzt64k87	0	20.32 #7	18.26	18.42	19.58	22.13	INSERT INTO ORDER_ITEMS ( ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, GIFT_WRAP, CONDITION, ESTIMATED_DELIVERY ) VALUES ( :B4 , :B3 , :B2 , :B1 , 1, 'None', 'New', (S…
5ckxyqfvu60pj	900611645	19.85 #8	18.77	19.40	21.12	22.50	SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSH…
g81cbrq5yamf5	2480532011	14.02 #9	13.11	13.98	15.03	16.48	SELECT ADDRESS_ID, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, STREET_NAME, TOWN, COUNTY, COUNTRY, POST_CODE, ZIP_CODE FROM ADDRESSES WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
7ws837zynp1zv	3722429161	12.17 #10	11.39	11.95	12.71	13.39	SELECT CARD_ID, CUSTOMER_ID, CARD_TYPE, CARD_NUMBER, EXPIRY_DATE, IS_VALID, SECURITY_CODE FROM CARD_DETAILS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1

By buffer gets

Break down by:

Detail table

SQL_ID	PHV (cur)	Current (gets)	−1h	−2h	−3h	−4h	SQL
3n4tadqgd9b9r	0	48,512,388.00 #1	46,964,424.00	48,838,267.00	52,053,992.00	51,936,606.00	BEGIN :1 := orderentry.neworder(:2,:3,:4); END;
c13sma6rkr27c	2393254267	36,951,703.00 #2	35,791,098.00	37,225,060.00	39,714,630.00	39,780,793.00	SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY…
0y1prvxqc2ra9	1905787423	13,366,508.00 #3	12,904,543.00	13,413,286.00	14,197,972.00	14,176,237.00	SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY…
7yhuvsmwggtqn	0	13,366,208.00 #4	12,904,904.00	13,413,183.00	14,197,983.00	14,177,198.00	BEGIN :1 := orderentry.browseproducts(:2,:3,:4); END;
f7rxuxzt64k87	0	4,803,391.00 #5	4,640,893.00	4,828,598.00	5,146,426.00	4,968,237.00	INSERT INTO ORDER_ITEMS ( ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, GIFT_WRAP, CONDITION, ESTIMATED_DELIVERY ) VALUES ( :B4 , :B3 , :B2 , :B1 , 1, 'None', 'New', (S…
8z3542ffmp562	1655552467	1,655,349.00 #6	1,605,924.00	1,670,646.00	1,776,063.00	1,780,735.00	SELECT QUANTITY_ON_HAND FROM PRODUCT_INFORMATION P, INVENTORIES I WHERE I.PRODUCT_ID = :B2 AND I.PRODUCT_ID = P.PRODUCT_ID AND I.WAREHOUSE_ID = :B1
3fw75k1snsddx	494735477	1,647,899.00 #7	1,578,756.00	1,621,050.00	1,705,176.00	1,687,058.00	INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, WAREHOUSE_ID, DELIVERY_TYPE, DELIVERY_ADDRESS_ID, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, CUSTO…
21ss57x3bykp3	0	1,524,503.00 #8	1,447,899.00	1,516,977.00	1,618,546.00	1,582,719.00	BEGIN :1 := orderentry.newcustomer(:2,:3,:4,:5,:6,:7,:8,:9,:10); END;
5ckxyqfvu60pj	900611645	1,060,040.00 #9	1,019,940.00	1,066,928.00	1,139,264.00	1,133,860.00	SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSH…
7r7636982atn9	2141863993	1,055,566.00 #10	1,023,886.00	1,064,843.00	1,132,550.00	1,135,821.00	UPDATE INVENTORIES SET QUANTITY_ON_HAND = QUANTITY_ON_HAND - :B1 WHERE PRODUCT_ID = :B3 AND WAREHOUSE_ID = :B2

By physical reads

Break down by:

Detail table

SQL_ID	PHV (cur)	Current (reads)	−1h	−2h	−3h	−4h	SQL
3n4tadqgd9b9r	0	1,055,096.00 #1	1,011,625.00	1,046,032.00	1,110,721.00	1,102,983.00	BEGIN :1 := orderentry.neworder(:2,:3,:4); END;
3fw75k1snsddx	494735477	259,316.00 #2	246,171.00	249,395.00	259,684.00	251,769.00	INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, WAREHOUSE_ID, DELIVERY_TYPE, DELIVERY_ADDRESS_ID, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, CUSTO…
g81cbrq5yamf5	2480532011	237,359.00 #3	229,910.00	238,460.00	254,605.00	254,222.00	SELECT ADDRESS_ID, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, STREET_NAME, TOWN, COUNTY, COUNTRY, POST_CODE, ZIP_CODE FROM ADDRESSES WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
21ss57x3bykp3	0	228,160.00 #4	216,642.00	225,206.00	238,855.00	232,610.00	BEGIN :1 := orderentry.newcustomer(:2,:3,:4,:5,:6,:7,:8,:9,:10); END;
7ws837zynp1zv	3722429161	212,555.00 #5	205,184.00	214,556.00	228,271.00	228,076.00	SELECT CARD_ID, CUSTOMER_ID, CARD_TYPE, CARD_NUMBER, EXPIRY_DATE, IS_VALID, SECURITY_CODE FROM CARD_DETAILS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
f7rxuxzt64k87	0	188,098.00 #6	178,500.00	186,524.00	201,313.00	201,212.00	INSERT INTO ORDER_ITEMS ( ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, GIFT_WRAP, CONDITION, ESTIMATED_DELIVERY ) VALUES ( :B4 , :B3 , :B2 , :B1 , 1, 'None', 'New', (S…
5ckxyqfvu60pj	900611645	179,395.00 #7	172,682.00	179,869.00	191,720.00	191,797.00	SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSH…
06gapn9jpn8p1	0	135,986.00 #8	126,636.00	131,134.00	138,091.00	134,096.00	BEGIN :1 := orderentry.updateCustomerDetails(:2,:3,:4,:5,:6,:7,:8); END;
gh2g2tynpcpv1	0	127,129.00 #9	120,324.00	123,842.00	130,147.00	125,645.00	INSERT INTO CUSTOMERS ( CUSTOMER_ID , CUST_FIRST_NAME , CUST_LAST_NAME , NLS_LANGUAGE , NLS_TERRITORY , CREDIT_LIMIT , CUST_EMAIL , ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, …
8zz6y2yzdqjp0	574689976	106,960.00 #10	99,997.00	103,802.00	109,140.00	106,151.00	SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSH…

By executions

Break down by:

Detail table

SQL_ID	PHV (cur)	Current (exec)	−1h	−2h	−3h	−4h	SQL
0y1prvxqc2ra9	1905787423	1,329,082.00 #1	1,283,140.00	1,333,722.00	1,411,691.00	1,409,554.00	SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY…
c13sma6rkr27c	2393254267	1,056,068.00 #2	1,022,568.00	1,063,909.00	1,134,656.00	1,136,020.00	SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY…
8z3542ffmp562	1655552467	289,512.00 #3	280,942.00	292,339.00	310,688.00	311,416.00	SELECT QUANTITY_ON_HAND FROM PRODUCT_INFORMATION P, INVENTORIES I WHERE I.PRODUCT_ID = :B2 AND I.PRODUCT_ID = P.PRODUCT_ID AND I.WAREHOUSE_ID = :B1
5ckxyqfvu60pj	900611645	265,010.00 #4	254,985.00	266,732.00	284,816.00	283,465.00	SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSH…
f7rxuxzt64k87	0	262,266.00 #5	254,367.00	264,531.00	281,316.00	282,158.00	INSERT INTO ORDER_ITEMS ( ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, GIFT_WRAP, CONDITION, ESTIMATED_DELIVERY ) VALUES ( :B4 , :B3 , :B2 , :B1 , 1, 'None', 'New', (S…
7yhuvsmwggtqn	0	110,586.00 #6	107,113.00	111,432.00	117,888.00	117,465.00	BEGIN :1 := orderentry.browseproducts(:2,:3,:4); END;
g81cbrq5yamf5	2480532011	99,125.00 #7	95,663.00	99,909.00	106,455.00	106,418.00	SELECT ADDRESS_ID, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, STREET_NAME, TOWN, COUNTY, COUNTRY, POST_CODE, ZIP_CODE FROM ADDRESSES WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
7ws837zynp1zv	3722429161	87,991.00 #8	85,038.00	88,807.00	94,492.00	94,541.00	SELECT CARD_ID, CUSTOMER_ID, CARD_TYPE, CARD_NUMBER, EXPIRY_DATE, IS_VALID, SECURITY_CODE FROM CARD_DETAILS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
3fw75k1snsddx	494735477	87,988.00 #9	85,038.00	88,803.00	94,489.00	94,537.00	INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, WAREHOUSE_ID, DELIVERY_TYPE, DELIVERY_ADDRESS_ID, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, CUSTO…
5mddt5kt45rg3	1628223527	87,977.00 #10	—	—	—	—	UPDATE ORDERS SET ORDER_MODE = 'online', ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(0, :B3 )), ORDER_TOTAL = :B2 WHERE ORDER_ID = :B1
3n4tadqgd9b9r	—	—	85,040.00	88,807.00	94,486.00	94,539.00	BEGIN :1 := orderentry.neworder(:2,:3,:4); END;

By per-exec regression

Break down by:

Detail table

SQL_ID	PHV (cur)	Current (s/exec)	−1h	−2h	−3h	−4h	SQL
fhf8upax5cxsz	0	1.14 #1	1.16	0.89	0.81	0.78	BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class, :rep_id, :suc); END;
dsfnfxkbbvxha	0	0.18 #2	0.05	—	—	0.07	INSERT INTO WRP$_REPORTS_DETAILS(SNAP_ID, DBID, INSTANCE_NUMBER, CON_DBID, SESSION_ID, SESSION_SERIAL#, REPORT_ID, GENERATION_TIME, REPORT_COMPRESSED) VALUES(:B9 , :B8 , :B7 , :B6 …
6s1ku6bs9a8xb	65914037	0.22 #3	0.12	0.11	0.19	0.08	WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count(*) as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND a…
awm8fgc8hw28q	863143779	0.22 #4	0.08	0.17	0.16	0.13	select name, ts#, contents$, online$, flags, bitmapped, blocksize, con_id from ( awri$_cdb_ts$ )
df9q7zmq16sxb	2062815065	0.14 #5	0.04	0.09	0.07	0.05	insert into wrh$_sgastat (dbid, per_pdb, con_dbid, snap_id, instance_number, pool, name, bytes) select :dbid, sgastat.con_id, con_id_to_dbid(sgastat.con_id) con_dbid, :snap…
0za9fv0j1vgkk	3205475971	0.66 #6	0.82	0.66	0.50	0.52	WITH MONITOR_DATA AS (SELECT * FROM TABLE(GV$(CURSOR( SELECT USERENV('instance') AS INST_ID, KEY, NVL2(PX_QCSID, NULL, STATUS) STATUS, FIRST_REFRESH_TIME, LAST_REFRESH_TIME, REFRES…
9x2prazfz86dz	2357590557	0.12 #7	0.09	0.08	0.09	0.07	select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, t.obj# from tab$ t, seg$ s where bitand(s.spare1, 4503599627370496) = 4503599627370496 and bitand(s.spare1, 65536) <> 65536 an…
bu4knv99vsx1x	3822037476	0.07 #8	0.04	0.04	0.04	0.02	select nvl(con_id, 0), lobtsn, lobrdba, lobobjid from x$lobstat where lobspcdealloc > 0 and lobcurrtime >= :1 order by lobspcdealloc desc
2jzz7j5bkc3xj	4139502717	0.12 #9	0.06	0.12	0.11	0.08	insert into WRH$_EVENT_HISTOGRAM (dbid, per_pdb, con_dbid, snap_id, instance_number, event_id, wait_time_milli, wait_count ) select :dbid, s.con_id, con_id_to_dbid(s.con_id…
831djp7gnx4hq	3637487201	0.09 #10	0.05	0.04	0.08	0.09	insert into wrh$_con_system_event (dbid, per_pdb, con_dbid, snap_id, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeo…

plan stable No plan_hash_value changes detected for any of the 28 top SQL across the compared windows.

Per-SQL detail

Per SQL_ID listed above: full text, AWR retention range, plan_hash_value summary, and avg sec/exec colored by PHV across every snapshot the SQL appeared in. PHV color change = plan switch.

06gapn9jpn8p1 — 2026-07-06 14:00 → 2026-07-06 21:15 · 0 distinct plans · 175,664 executions across 29 snapshots

Parsing schema: SOE
Module: —
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 73 chars

BEGIN :1 :=  orderentry.updateCustomerDetails(:2,:3,:4,:5,:6,:7,:8); END;

0y1prvxqc2ra9 — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 10,534,859 executions across 29 snapshots

Parsing schema: SOE
Module: Browse Products
Action: getProductDetails
Optimizer mode: ALL_ROWS
Force-match sig: 10881662202605068940
SQL profile: —
Text length: 314 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
1905787423	2026-07-06 14:00	2026-07-06 21:15	29	10,534,859	0.000	10

SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.PRODUCT_ID = :B2 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND ROWNUM < :B1

0za9fv0j1vgkk — 2025-10-11 15:13 → 2026-07-06 21:15 · 2 distinct plans · 390 executions across 180 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 3827900917462555511
SQL profile: —
Text length: 92,634 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
3205475971	2025-10-11 15:13	2026-07-06 21:15	179	382	0.130	403
1003789799	2026-07-04 18:45	2026-07-04 19:00	1	8	0.176	1,145

WITH MONITOR_DATA AS (SELECT * FROM TABLE(GV$(CURSOR( SELECT USERENV('instance') AS INST_ID, KEY, NVL2(PX_QCSID, NULL, STATUS) STATUS, FIRST_REFRESH_TIME, LAST_REFRESH_TIME, REFRESH_COUNT, PROCESS_NAME, SID, SQL_ID, SQL_EXEC_START, SQL_EXEC_ID, DBOP_NAME, DBOP_EXEC_ID, SQL_PLAN_HASH_VALUE, SQL_FULL_PLAN_HASH_VALUE, SESSION_SERIAL#, SQL_TEXT, PX_SERVER#, PX_SERVER_GROUP, PX_SERVER_SET, PX_QCINST_ID, PX_QCSID, CASE WHEN ELAPSED_TIME < (CPU_TIME+ APPLICATION_WAIT_TIME+ CONCURRENCY_WAIT_TIME+ CLUSTER_WAIT_TIME+ USER_IO_WAIT_TIME+ QUEUING_TIME) THEN (CPU_TIME+ APPLICATION_WAIT_TIME+ CONCURRENCY_WAIT_TIME+ CLUSTER_WAIT_TIME+ USER_IO_WAIT_TIME+ QUEUING_TIME) ELSE ELAPSED_TIME END ELAPSED_TIME, QUEUING_TIME, CPU_TIME, APPLICATION_WAIT_TIME, CONCURRENCY_WAIT_TIME, CLUSTER_WAIT_TIME, USER_IO_WAIT_TIME, CASE WHEN ELAPSED_TIME < (CPU_TIME+ APPLICATION_WAIT_TIME+ CONCURRENCY_WAIT_TIME+ CLUSTER_WAIT_TIME+ USER_IO_WAIT_TIME+ QUEUING_TIME) THEN 0 ELSE ELAPSED_TIME - (CPU_TIME+ APPLICATION_WAIT_TIME+ CONCURRENCY_WAIT_TIME+ CLUSTER_WAIT_TIME+ USER_IO_WAIT_TIME+ QUEUING_TIME) END OTHER_WAIT_TIME, PLSQL_EXEC_TIME, JAVA_EXEC_TIME, FETCHES, BUFFER_GETS, IO_INTERCONNECT_BYTES IO_INTER_BYTES, PHYSICAL_READ_REQUESTS READ_REQS, PHYSICAL_READ_BYTES READ_BYTES, PHYSICAL_WRITE_REQUESTS WRITE_REQS, PHYSICAL_WRITE_BYTES WRITE_BYTES, NVL(PHYSICAL_READ_BYTES, 0) + NVL(PHYSICAL_WRITE_BYTES, 0) IO_BYTES, NVL(PHYSICAL_READ_REQUESTS, 0) + NVL(PHYSICAL_WRITE_REQUESTS, 0) IO_REQS, IO_CELL_UNCOMPRESSED_BYTES IO_UNC_BYTES, IO_CELL_OFFLOAD_ELIGIBLE_BYTES IO_ELIG_BYTES, IO_CELL_OFFLOAD_RETURNED_BYTES IO_RET_BYTES, USER# USERID, USERNAME, MODULE, ACTION, SERVICE_NAME, CLIENT_IDENTIFIER, CLIENT_INFO, PROGRAM, PLSQL_OBJECT_ID PL_OID, PLSQL_SUBPROGRAM_ID PL_PROGID, PLSQL_ENTRY_OBJECT_ID PL_ENTRY_OID, PLSQL_ENTRY_SUBPROGRAM_ID PL_ENTRY_PROGID, PX_MAXDOP MAX_DOP, PX_IS_CROSS_INSTANCE, PX_MAXDOP_INSTANCES MAX_DOP_INSTANCES, PX_SERVERS_REQUESTED SERVERS_REQUESTED, PX_SERVERS_ALLOCATED SERVERS_ALLOCATED, ERROR_NUMBER, ERROR_FACILITY, ERROR_MESSAGE, NVL2(OTHER_XML, 'Y', NULL) HAS_OTHER_XML, NVL2(BINDS_XML, 'Y', NULL) HAS_BINDS_XML, NVL2(RM_CONSUMER_GROUP, NVL2(RM_LAST_ACTION_TIME, TO_CHAR(RM_LAST_ACTION_TIME, :B12 ), '00/00/0000 00:00:01') || XMLELEMENT( "rminfo", XMLATTRIBUTES( RM_LAST_ACTION AS "rmlastact", RM_LAST_ACTION_REASON AS "rmlastreason", TO_CHAR(RM_LAST_ACTION_TIME, :B12 ) AS "rmlasttime", RM_CONSUMER_GROUP AS "rmcg")).GETSTRINGVAL(), '00/00/0000 00:00:00') RM_INFO, CON_NAME, CON_ID FROM V$ALL_SQL_MONITOR MO1 WHERE USERENV('INSTANCE') BETWEEN :B11 AND :B10 AND MO1.SQL_ID = NVL(:B9 , MO1.SQL_ID) AND MO1.SQL_EXEC_START = NVL(:B8 , MO1.SQL_EXEC_START) AND MO1.SQL_EXEC_ID = NVL(:B7 , MO1.SQL_EXEC_ID) OR (MO1.DBOP_NAME = NVL(:B6 , MO1.DBOP_NAME) AND MO1.DBOP_EXEC_ID = NVL(:B5 , MO1.DBOP_EXEC_ID)) AND ((:B4 = 1 AND MO1.PX_QCSID IS NULL) OR (MO1.PX_SERVER_GROUP = NVL(:B3 , MO1.PX_SERVER_GROUP) AND MO1.PX_SERVER_SET = NVL(:B2 , MO1.PX_SERVER_SET) AND MO1.PX_SERVER# = NVL(:B1 , MO1.PX_SERVER#))) ))) ), MONITOR_AGG AS (SELECT MAX_PX_QCSID, MAX_KEY, MAX_INST_ID, MAX_SESSION_ID, MAX_SESSION_SERIAL, MAX_PX_DOP, MAX_PX_DOP_INSTANCES, MAX_PX_IS_CROSS_INSTANCE, SUM_SERVERS_REQUESTED, SUM_SERVERS_ALLOCATED, DIST_INST_COUNT, DIST_PX_GROUP_COUNT, DIST_PX_SET_COUNT, MAX_PLAN_HASH_VALUE, MAX_FULL_PLAN_HASH_VALUE, MAX_USERID, MAX_PROGRAM, MAX_USERNAME, MAX_MODULE, MAX_ACTION, MAX_SERVICE_NAME, MAX_CLIENT_ID, MAX_CLIENT_INFO, MAX_ERROR_NUMBER, MAX_ERROR_FACILITY, MAX_ERROR_MESSAGE, QC_HAS_OTHER_XML, QC_HAS_BINDS_XML, MAX_PL_OID, MAX_PL_PROGID, MAX_PL_ENTRY_OID, MAX_PL_ENTRY_PROGID, MAX_SQL_ID, MAX_SQL_EXEC_START, MAX_SQL_EXEC_ID, MAX_LAST_REFRESH_TIME, MAX_DBOP_NAME, MAX_DBOP_EXEC_ID, CASE WHEN MAX_PL_OID IS NOT NULL THEN NVL((SELECT P.OWNER || '.' || P.OBJECT_NAME || DECODE(P.PROCEDURE_NAME, NULL, '', '.' || P.PROCEDURE_NAME) FROM ALL_PROCEDURES P WHERE P.OBJECT_ID = MAX_PL_OID AND P.SUBPROGRAM_ID = MAX_PL_PROGID AND ROWNUM = 1), 'Unavailable') END MAX_PL_NAME, CASE WHEN MAX_PL_ENTRY_OID IS NOT NULL THEN NVL((SELECT P.OWNER || '.' || P.OBJECT_NAME || DECODE(P.PROCEDURE_NAME, NULL, '', '.' || P.PROCEDURE_NAME) FROM ALL_PROCEDURES P WHERE P.OBJECT_ID = MAX_PL_ENTRY_OID AND P.SUBPROGRAM_ID = MAX_PL_ENTRY_PROGID AND ROWNUM = 1), 'Unavailable') END MAX_PL_ENTRY_NAME, MAX_STATUS, SUM_REFRESH_COUNT, MIN_FIRST_REFRESH_TIME, SQLMON_TEXT, SUM_ELAPSED_TIME, MAX_ELAPSED_TIME, MAX_QUEUING_TIME, SUM_CPU_TIME, SUM_USER_IO_WAIT_TIME, SUM_APPLICATION_WAIT_TIME, SUM_CONCURRENCY_WAIT_TIME, SUM_CLUSTER_WAIT_TIME, SUM_PLSQL_EXEC_TIME, SUM_JAVA_EXEC_TIME, SUM_OTHER_WAIT_TIME, SUM_FETCHES, SUM_BUFFER_GETS, SUM_READ_REQS, SUM_READ_BYTES, SUM_WRITE_REQS, SUM_WRITE_BYTES, SUM_IO_BYTES, SUM_IO_INTER_BYTES, SUM_IO_UNC_BYTES, SUM_IO_ELIG_BYTES, SUM_IO_RET_BYTES, DECODE(:B14 , 1, 'db_name', SYS_CONTEXT('userenv', 'db_unique_name')) DB_UNIQUE_NAME, DECODE(:B14 , 1, 'platform_name', SYS.DBMS_UTILITY.PORT_STRING) PLATFORM_NAME, DECODE(:B14 , 1, 'host_name', SYS_CONTEXT('userenv', 'server_host')) HOST_NAME, AGG_RM_INFO MAX_RM_INFO, MAX_CON_NAME, DECODE(MAX_CON_ID, 0, NULL, MAX_CON_ID) MAX_CON_ID FROM (SELECT MAX(PX_QCSID) MAX_PX_QCSID, MAX(CASE WHEN PX_QCSID IS NULL THEN KEY ELSE NULL END) MAX_KEY, MAX(CASE WHEN PX_QCSID IS NULL THEN INST_ID ELSE NULL END) MAX_INST_ID, MAX(CASE WHEN PX_QCSID IS NULL THEN SID ELSE NULL END) MAX_SESSION_ID, MAX(CASE WHEN PX_QCSID IS NULL THEN SESSION_SERIAL# ELSE NULL END) MAX_SESSION_SERIAL, MAX(MAX_DOP) MAX_PX_DOP, MAX(MAX_DOP_INSTANCES) MAX_PX_DOP_INSTANCES, MAX(PX_IS_CROSS_INSTANCE) MAX_PX_IS_CROSS_INSTANCE, SUM(SERVERS_REQUESTED) SUM_SERVERS_REQUESTED, SUM(SERVERS_ALLOCATED) SUM_SERVERS_ALLOCATED, COUNT(DISTINCT INST_ID) DIST_INST_COUNT, COUNT(DISTINCT PX_SERVER_GROUP) DIST_PX_GROUP_COUNT, COUNT(DISTINCT PX_SERVER_SET) DIST_PX_SET_COUNT, MAX(SQL_PLAN_HASH_VALUE) MAX_PLAN_HASH_VALUE, MAX(SQL_FULL_PLAN_HASH_VALUE) MAX_FULL_PLAN_HASH_VALUE, MAX(USERID) MAX_USERID, MAX(PROGRAM) MAX_PROGRAM, MAX(USERNAME) MAX_USERNAME, MAX(MODULE) MAX_MODULE, MAX(ACTION) MAX_ACTION, MAX(SERVICE_NAME) MAX_SERVICE_NAME, MAX(CLIENT_IDENTIFIER) MAX_CLIENT_ID, MAX(CLIENT_INFO) MAX_CLIENT_INFO, MAX(ERROR_NUMBER) MAX_ERROR_NUMBER, MAX(ERROR_FACILITY) MAX_ERROR_FACILITY, MAX(ERROR_MESSAGE) MAX_ERROR_MESSAGE, MAX(NVL2(PX_QCSID, HAS_OTHER_XML, NULL)) QC_HAS_OTHER_XML, MAX(HAS_BINDS_XML) QC_HAS_BINDS_XML, MAX(PL_OID) MAX_PL_OID, MAX(PL_PROGID) MAX_PL_PROGID, MAX(PL_ENTRY_OID) MAX_PL_ENTRY_OID, MAX(PL_ENTRY_PROGID) MAX_PL_ENTRY_PROGID, MAX(SQL_ID) MAX_SQL_ID, MAX(SQL_EXEC_START) MAX_SQL_EXEC_START, MAX(SQL_EXEC_ID) MAX_SQL_EXEC_ID, MAX(LAST_REFRESH_TIME) MAX_LAST_REFRESH_TIME, MAX(STATUS) MAX_STATUS, SUM(REFRESH_COUNT) SUM_REFRESH_COUNT, MIN(FIRST_REFRESH_TIME) MIN_FIRST_REFRESH_TIME, MAX(DBOP_NAME) MAX_DBOP_NAME, MAX(DBOP_EXEC_ID) MAX_DBOP_EXEC_ID, CASE WHEN :B13 = 0 THEN NULL ELSE MAX(SQL_TEXT) END SQLMON_TEXT, SUM(ELAPSED_TIME) SUM_ELAPSED_TIME, MAX(ELAPSED_TIME) MAX_ELAPSED_TIME, MAX(QUEUING_TIME) MAX_QUEUING_TIME, SUM(CPU_TIME) SUM_CPU_TIME, SUM(USER_IO_WAIT_TIME) SUM_USER_IO_WAIT_TIME, SUM(APPLICATION_WAIT_TIME) SUM_APPLICATION_WAIT_TIME, SUM(CONCURRENCY_WAIT_TIME) SUM_CONCURRENCY_WAIT_TIME, SUM(CLUSTER_WAIT_TIME) SUM_CLUSTER_WAIT_TIME, SUM(PLSQL_EXEC_TIME) SUM_PLSQL_EXEC_TIME, SUM(JAVA_EXEC_TIME) SUM_JAVA_EXEC_TIME, SUM(OTHER_WAIT_TIME) SUM_OTHER_WAIT_TIME, SUM(FETCHES) SUM_FETCHES, SUM(BUFFER_GETS) SUM_BUFFER_GETS, SUM(READ_REQS) SUM_READ_REQS, SUM(READ_BYTES) SUM_READ_BYTES, SUM(WRITE_REQS) SUM_WRITE_REQS, SUM(WRITE_BYTES) SUM_WRITE_BYTES, NVL(SUM(READ_BYTES), 0) + NVL(SUM(WRITE_BYTES), 0) SUM_IO_BYTES, SUM(IO_INTER_BYTES) SUM_IO_INTER_BYTES, SUM(IO_UNC_BYTES) SUM_IO_UNC_BYTES, SUM(IO_ELIG_BYTES) SUM_IO_ELIG_BYTES, SUM(IO_RET_BYTES) SUM_IO_RET_BYTES, MAX(RM_INFO) AGG_RM_INFO, MAX(CON_NAME) MAX_CON_NAME, MAX(CON_ID) MAX_CON_ID FROM MONITOR_DATA) MD), ASH_DATA AS (SELECT AD0.INST_ID, AD0.SESSION_ID, AD0.PLAN_LINE_ID, AD0.PLSQL_OBJECT_ID, AD0.PLSQL_SUBPROGRAM_ID, AD0.ACTIVITY_BUCKET_NUM, AD0.PLAN_ACTIVITY_BUCKET_NUM, AD0.SQL, AD0.TOP_
... (truncated, 92634 chars total)

21ss57x3bykp3 — 2026-07-06 14:00 → 2026-07-06 21:15 · 0 distinct plans · 264,177 executions across 29 snapshots

Parsing schema: SOE
Module: JDBC Thin Client
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 70 chars

BEGIN :1 :=  orderentry.newcustomer(:2,:3,:4,:5,:6,:7,:8,:9,:10); END;

2jzz7j5bkc3xj — 2026-06-28 19:35 → 2026-07-06 21:15 · 1 distinct plan · 388 executions across 388 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: CHOOSE
Force-match sig: 14894371175163409544
SQL profile: —
Text length: 417 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
4139502717	2026-06-28 19:35	2026-07-06 21:15	388	388	0.032	613

insert into  WRH$_EVENT_HISTOGRAM  (dbid, per_pdb, con_dbid, snap_id, instance_number,     event_id, wait_time_milli, wait_count ) select  :dbid,  s.con_id, con_id_to_dbid(s.con_id)  con_dbid,  :snap_id, :instance_number,        d.ksledhash, s.kslsesmaxdur/1024,        s.kslsesval   FROM x$kslseshist_micro   s, x$ksled   d  WHERE  (1 = 1)  AND ( s.con_id < 4099  )   and s.kslsesenum = d.indx   and s.kslsesval > 0

3fw75k1snsddx — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 701,672 executions across 29 snapshots

Parsing schema: SOE
Module: New Order
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 405 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
494735477	2026-07-06 14:00	2026-07-06 21:15	29	701,672	0.002	18

INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, WAREHOUSE_ID, DELIVERY_TYPE, DELIVERY_ADDRESS_ID, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, CUSTOMER_CLASS, CARD_ID, INVOICE_ADDRESS_ID ) VALUES ( ORDERS_SEQ.NEXTVAL + :B8 , SYSTIMESTAMP , 'online', :B7 , 1, :B6 , 'Standard', :B1 , DBMS_RANDOM.VALUE(:B5 , :B4 ), 'ship_asap', :B2 , :B3 , :B1 ) RETURNING ORDER_ID INTO :O0

3n4tadqgd9b9r — 2026-07-06 14:00 → 2026-07-06 21:15 · 0 distinct plans · 701,647 executions across 29 snapshots

Parsing schema: SOE
Module: —
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 48 chars

BEGIN :1 :=  orderentry.neworder(:2,:3,:4); END;

5ckxyqfvu60pj — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 2,107,828 executions across 29 snapshots

Parsing schema: SOE
Module: Update Customer Details
Action: getCustomerDetails
Optimizer mode: ALL_ROWS
Force-match sig: 6486229150489758732
SQL profile: —
Text length: 292 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
900611645	2026-07-06 14:00	2026-07-06 21:15	29	2,107,828	0.001	4

SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSHOT, PARTNER_MAILSHOT, PREFERRED_ADDRESS, PREFERRED_CARD FROM CUSTOMERS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1

5mddt5kt45rg3 — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 701,623 executions across 29 snapshots

Parsing schema: SOE
Module: New Order
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 11379765169476978296
SQL profile: —
Text length: 130 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
1628223527	2026-07-06 14:00	2026-07-06 21:15	29	701,623	0.000	10

UPDATE ORDERS SET ORDER_MODE = 'online', ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(0, :B3 )), ORDER_TOTAL = :B2 WHERE ORDER_ID = :B1

6s1ku6bs9a8xb — 2026-07-02 06:44 → 2026-07-06 21:15 · 1 distinct plan · 28 executions across 28 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 2661651228964933557
SQL profile: —
Text length: 3,614 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
65914037	2026-07-02 06:44	2026-07-06 21:15	28	28	0.124	119

 WITH ash as  (SELECT ash.event_id,  sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg,  count(*) as cnt_total  FROM  WRH$_ACTIVE_SESSION_HISTORY ash  WHERE  ash.dbid = :dbid  AND ash.instance_number = :inst  AND ash.snap_id > :bid AND ash.snap_id <= :eid  AND  ash.wait_time = 0  GROUP BY ash.event_id  ),  evts as  (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt,  sum(w_time) as w_time  ,sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg,  sum(w_time_fg) as w_time_fg  FROM (SELECT es.event_id as event_id,  es.total_waits - nvl(bs.total_waits,0) as w_cnt,  es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS,0) as to_cnt,  es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO,0)  as w_time  ,es.total_waits_fg - nvl(bs.total_waits_fg,0)  as w_cnt_fg,  es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG,0)  as to_cnt_fg,  es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG,0)  as w_time_fg  FROM  WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs  WHERE  es.dbid = :dbid  AND es.instance_number = :inst  AND es.snap_id = :eid  AND bs.dbid(+) = :dbid AND bs.instance_number(+) = es.instance_number AND bs.snap_id(+) = :bid  AND  es.instance_number = bs.instance_number(+)  AND  es.event_id = bs.event_id(+)  UNION ALL  SELECT x.event_hash as event_id,  0 as w_cnt, 0 as to_cnt, 0 as w_time  ,0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg  FROM  X$KEHEVTMAP x  )  GROUP BY event_id  ),  awr_names as  (SELECT e.event_id, max(e.event_name) as event_name,          max(e.wait_class_id) as wait_class_id,          max(e.wait_class) as wait_class,          max(e.parameter1) as parameter1,          max(e.parameter2) as parameter2,          max(e.parameter3) as parameter3  FROM  WRH$_EVENT_NAME e  WHERE e.dbid = :dbid GROUP BY e.event_id  ),  named_events as  (SELECT names.event_id as event_id,  names.event_name as event_name,  evts.w_cnt as w_cnt,  evts.to_cnt as to_cnt,  evts.w_time as w_time,  evts.w_cnt_fg as w_cnt_fg,  evts.to_cnt_fg as to_cnt_fg,  evts.w_time_fg as w_time_fg,  names.wait_class_id as wait_class_id,  names.parameter1 as p1,  names.parameter2 as p2,  names.parameter3 as p3  FROM   evts, awr_names names  WHERE  evts.event_id = names.event_id  AND  names.wait_class_id <> 2723168908  ),  data as  (SELECT e.event_id as event_id,  e.event_name as event_name,  e.wait_class_id as wait_class_id,  e.p1 as p1,  e.p2 as p2,  e.p3 as p3,  e.w_cnt as total_w_cnt,  e.to_cnt as total_to_cnt,  e.w_time as total_w_time,  e.w_cnt_fg as fg_w_cnt,  e.to_cnt_fg as fg_to_cnt,  e.w_time_fg as fg_w_time,  nvl(a.cnt_total,0) as total_ash_cnt,  nvl(a.cnt_fg,0) as fg_ash_cnt  FROM   named_events e, ash a  WHERE  e.event_id  = a.event_id(+)  ),  final_query as  (SELECT d.event_name,  d.event_id,  d.p1 as p1,  case when (p1 is null OR p1 = '0')  then 0 else 1 end as p1valid,  d.p2 as p2,  case when (p2 is null OR p2 = '0')  then 0 else 1 end as p2valid,  d.p3 as p3,  case when (p3 is null OR p3 = '0')  then 0 else 1 end as p3valid,  nvl(e.keh_id,0) as keh_evt_id,  c.class# as class_num,  d.wait_class_id as wait_class_id,  c.keh_id as keh_ecl_id,  round(d.total_ash_cnt,0) as total_ash_cnt,  round(d.fg_ash_cnt,0) as fg_ash_cnt,  round(d.fg_w_cnt,0) as fg_w_cnt,  round(d.fg_to_cnt,0) as fg_to_cnt,  round(d.fg_w_time,0) as fg_w_time,  round(d.total_w_cnt,0) as total_w_cnt,  round(d.total_to_cnt,0) as total_to_cnt,  round(d.total_w_time,0) as total_w_time  from data d,  X$KEHEVTMAP e , X$KEHECLMAP c  where d.event_id = e.event_hash(+)  and d.wait_class_id = c.class_hash  )  SELECT *  FROM   final_query  WHERE  keh_evt_id > 0 OR total_w_time > 0  ORDER BY wait_class_id, fg_w_time DESC, event_id

7r7636982atn9 — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 665,142 executions across 29 snapshots

Parsing schema: SOE
Module: New Order
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 8080224161820109919
SQL profile: —
Text length: 111 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
2141863993	2026-07-06 14:00	2026-07-06 21:15	29	665,142	0.000	13

UPDATE INVENTORIES SET QUANTITY_ON_HAND = QUANTITY_ON_HAND - :B1 WHERE PRODUCT_ID = :B3 AND WAREHOUSE_ID = :B2

7ws837zynp1zv — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 701,692 executions across 29 snapshots

Parsing schema: SOE
Module: New Order
Action: getCardDetailsByCustomerID
Optimizer mode: ALL_ROWS
Force-match sig: 11743835683608524663
SQL profile: —
Text length: 149 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
3722429161	2026-07-06 14:00	2026-07-06 21:15	29	701,692	0.003	5

SELECT CARD_ID, CUSTOMER_ID, CARD_TYPE, CARD_NUMBER, EXPIRY_DATE, IS_VALID, SECURITY_CODE FROM CARD_DETAILS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1

7yhuvsmwggtqn — 2026-07-06 14:00 → 2026-07-06 21:15 · 0 distinct plans · 877,946 executions across 29 snapshots

Parsing schema: SOE
Module: —
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 54 chars

BEGIN :1 :=  orderentry.browseproducts(:2,:3,:4); END;

831djp7gnx4hq — 2026-06-28 19:35 → 2026-07-06 21:15 · 1 distinct plan · 370 executions across 370 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: CHOOSE
Force-match sig: 7718736273813680318
SQL profile: —
Text length: 514 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
3637487201	2026-06-28 19:35	2026-07-06 21:15	370	370	0.007	114

insert into  wrh$_con_system_event  (dbid, per_pdb, con_dbid, snap_id, instance_number,    event_id,  total_waits, total_timeouts, time_waited_micro,    total_waits_fg, total_timeouts_fg, time_waited_micro_fg)  select  :dbid,  sysevt.con_id, con_id_to_dbid(sysevt.con_id)  con_dbid,  :snap_id, :instance_number,    event_id, total_waits, total_timeouts, time_waited_micro,    total_waits_fg, total_timeouts_fg, time_waited_micro_fg  FROM v$con_system_event    sysevt  WHERE  (1 = 1)  AND ( sysevt.con_id < 4099  )

8z3542ffmp562 — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 2,311,912 executions across 29 snapshots

Parsing schema: SOE
Module: New Order
Action: getProductQuantity
Optimizer mode: ALL_ROWS
Force-match sig: 17991828121679737456
SQL profile: —
Text length: 148 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
1655552467	2026-07-06 14:00	2026-07-06 21:15	29	2,311,912	0.000	6

SELECT QUANTITY_ON_HAND FROM PRODUCT_INFORMATION P, INVENTORIES I WHERE I.PRODUCT_ID = :B2 AND I.PRODUCT_ID = P.PRODUCT_ID AND I.WAREHOUSE_ID = :B1

8zz6y2yzdqjp0 — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 175,658 executions across 29 snapshots

Parsing schema: SOE
Module: Update Customer Details
Action: findCustomer
Optimizer mode: ALL_ROWS
Force-match sig: 515636143640281320
SQL profile: —
Text length: 351 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
574689976	2026-07-06 14:00	2026-07-06 21:15	29	175,658	0.004	7

SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSHOT, PARTNER_MAILSHOT, PREFERRED_ADDRESS, PREFERRED_CARD FROM CUSTOMERS WHERE LOWER(CUST_LAST_NAME) = LOWER(:B3 ) AND LOWER(CUST_FIRST_NAME) = LOWER(:B2 ) AND ROWNUM < :B1

9t3n2wpr7my63 — 2026-07-06 14:00 → 2026-07-06 21:15 · 0 distinct plans · 342,569 executions across 29 snapshots

Parsing schema: SOE
Module: Update Customer Details
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 267 chars

INSERT INTO ADDRESSES ( ADDRESS_ID, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, STREET_NAME, TOWN, COUNTY, COUNTRY, POST_CODE, ZIP_CODE ) VALUES ( :B6 , :B5 , TRUNC(SYSDATE,'MI'), FLOOR(DBMS_RANDOM.VALUE(1, :B4 )), 'Street Name', :B3 , :B2 , :B1 , 'Postcode', NULL )

9x2prazfz86dz — 2026-06-28 19:35 → 2026-07-06 21:15 · 1 distinct plan · 1,027 executions across 674 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: CHOOSE
Force-match sig: —
SQL profile: —
Text length: 860 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
2357590557	2026-06-28 19:35	2026-07-06 21:15	674	1,027	0.006	279

 select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, t.obj# from tab$ t, seg$ s where bitand(s.spare1, 4503599627370496) = 4503599627370496 and bitand(s.spare1, 65536) <> 65536  and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block# UNION  select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, tab.obj# from tabpart$ t, tab$ tab, seg$ s  where bitand(s.spare1, 4503599627370496) = 4503599627370496 and bitand(s.spare1, 65536) <> 65536  and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block# and tab.obj# = t.bo# UNION  select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr,  tab.obj# from tabsubpart$ t, tab$ tab, tabcompart$ tcp,  seg$ s  where bitand(s.spare1, 4503599627370496) = 4503599627370496 and bitand(s.spare1, 65536) <> 65536  and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block# and t.pobj# = tcp.obj# and tab.obj# = tcp.bo#

ajjqqrmacwv34 — 2026-07-06 14:00 → 2026-07-06 21:15 · 0 distinct plans · 88,120 executions across 29 snapshots

Parsing schema: SOE
Module: —
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 61 chars

BEGIN :1 :=  orderentry.browseandupdateorders(:2,:3,:4); END;

awm8fgc8hw28q — 2026-06-28 19:35 → 2026-07-06 21:15 · 1 distinct plan · 371 executions across 371 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: CHOOSE
Force-match sig: 16536395052899362223
SQL profile: —
Text length: 100 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
863143779	2026-06-28 19:35	2026-07-06 21:15	371	371	0.012	22

select name, ts#, contents$, online$, flags, bitmapped, blocksize, con_id from  (  awri$_cdb_ts$  )

bu4knv99vsx1x — 2026-06-28 20:00 → 2026-07-06 20:00 · 1 distinct plan · 379 executions across 224 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: CHOOSE
Force-match sig: 3264515631038653229
SQL profile: —
Text length: 141 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
3822037476	2026-06-28 20:00	2026-07-06 20:00	224	379	0.002	0

select nvl(con_id, 0), lobtsn, lobrdba, lobobjid from x$lobstat   where lobspcdealloc > 0 and lobcurrtime >= :1   order by lobspcdealloc desc

c13sma6rkr27c — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 8,416,466 executions across 29 snapshots

Parsing schema: SOE
Module: New Order
Action: getProductDetailsByCategory
Optimizer mode: ALL_ROWS
Force-match sig: 18298161888330075667
SQL profile: —
Text length: 350 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
2393254267	2026-07-06 14:00	2026-07-06 21:15	29	8,416,466	0.000	35

SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B3 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND INVENTORIES.WAREHOUSE_ID = :B2 AND ROWNUM < :B1

df9q7zmq16sxb — 2026-06-28 19:35 → 2026-07-06 21:15 · 2 distinct plans · 378 executions across 396 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: CHOOSE
Force-match sig: 14843768049389618802
SQL profile: —
Text length: 867 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
2062815065	2026-06-28 19:35	2026-07-06 21:15	378	378	0.009	27
3635407291	2026-07-02 06:44	2026-07-02 14:45	18	0	—	—

insert into  wrh$_sgastat  (dbid, per_pdb, con_dbid, snap_id, instance_number, pool, name, bytes)   select  :dbid,  sgastat.con_id, con_id_to_dbid(sgastat.con_id)  con_dbid,  :snap_id, :instance_number, pool, name, bytes   from     (select con_id, pool, name, sum(bytes) bytes from       (select con_id, pool, case when (part_pct<1 and pool is not null                                        and con_id <> 0                                        and not name = 'free memory'                                        and not name = 'row cache')       then pool || ' less than 1 percent'       else name end name, bytes from         (select con_id, pool, name, bytes, 100*(bytes) /           (sum(bytes) over (partition by pool)) part_pct  FROM v$sgastat    sga  WHERE  (1 = 1)  AND ( sga.con_id < 4099  )         )       )     group by con_id, pool, name     ) sgastat

dsfnfxkbbvxha — 2025-10-11 15:13 → 2026-07-06 20:45 · 0 distinct plans · 124 executions across 41 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 211 chars

INSERT INTO WRP$_REPORTS_DETAILS(SNAP_ID, DBID, INSTANCE_NUMBER, CON_DBID, SESSION_ID, SESSION_SERIAL#, REPORT_ID, GENERATION_TIME, REPORT_COMPRESSED) VALUES(:B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

f7rxuxzt64k87 — 2026-07-06 14:00 → 2026-07-06 21:15 · 0 distinct plans · 2,093,221 executions across 29 snapshots

Parsing schema: SOE
Module: New Order
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 193 chars

INSERT INTO ORDER_ITEMS ( ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, GIFT_WRAP, CONDITION, ESTIMATED_DELIVERY ) VALUES ( :B4 , :B3 , :B2 , :B1 , 1, 'None', 'New', (SYSDATE + 3) )

fhf8upax5cxsz — 2025-10-11 15:13 → 2026-07-06 21:15 · 0 distinct plans · 386 executions across 181 snapshots

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 147 chars

BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class,                                              :rep_id, :suc); END;

g81cbrq5yamf5 — 2026-07-06 14:00 → 2026-07-06 21:15 · 1 distinct plan · 789,763 executions across 29 snapshots

Parsing schema: SOE
Module: New Order
Action: getAddressDetails
Optimizer mode: ALL_ROWS
Force-match sig: 15722349611718065978
SQL profile: —
Text length: 176 chars

PHV	First seen	Last seen	Snaps	Executions	Avg s/exec	Avg gets/exec
2480532011	2026-07-06 14:00	2026-07-06 21:15	29	789,763	0.003	5

SELECT ADDRESS_ID, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, STREET_NAME, TOWN, COUNTY, COUNTRY, POST_CODE, ZIP_CODE FROM ADDRESSES WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1

gh2g2tynpcpv1 — 2026-07-06 14:00 → 2026-07-06 21:15 · 0 distinct plans · 264,196 executions across 29 snapshots

Parsing schema: SOE
Module: Update Customer Details
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: —
SQL profile: —
Text length: 527 chars

INSERT INTO CUSTOMERS ( CUSTOMER_ID , CUST_FIRST_NAME , CUST_LAST_NAME , NLS_LANGUAGE , NLS_TERRITORY , CREDIT_LIMIT , CUST_EMAIL , ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSHOT, PARTNER_MAILSHOT, PREFERRED_ADDRESS, PREFERRED_CARD ) VALUES ( :B11 , :B6 , :B5 , :B10 , :B9 , FLOOR(DBMS_RANDOM.VALUE(:B8 , :B7 )), :B6 ||'.' ||:B5 ||'@' ||'oracle.com', FLOOR(DBMS_RANDOM.VALUE(:B4 , :B3 )), TRUNC(SYSDATE), 'Occasional', 'Music', TRUNC(SYSDATE - (365*DBMS_RANDOM.VALUE(20, 60))), 'Y', 'N', :B2 , :B1 )

Findings summary

z = (current − μ) ÷ σ over prior valid windows. |z|>3 large, |z|>2 moderate, else typical. n<3 → %-delta only. Heatmap: |z| per (domain × metric); gray = no baseline.

Load profile

Change	Metric	Current	Prior mean	Prior sd	n	z-score	% Δ
large	bytes sent via SQL*Net to client	34,587.9272	9,004.2664	404.0937	4	+63.31	+284.1%
large	DB time	106.5381	100.0810	0.4627	4	+13.96	+6.5%
large	sorts (rows)	64.4606	60.4974	0.4039	4	+9.81	+6.6%
large	redo size for lost write detection	26,000.5033	34,960.5342	1,578.0692	4	-5.68	-25.6%
large	sorts (memory)	1.8683	1.6231	0.0440	4	+5.57	+15.1%
large	parse count (hard)	0.0722	0.0200	0.0102	4	+5.14	+261.1%
moderate	logons cumulative	0.1764	0.1701	0.0028	4	+2.26	+3.7%
flat baseline	parse count (failures)	0.0017	0.0000	0.0000	4	—	—
flat baseline	sorts (disk)	0.0000	0.0000	0.0000	4	—	—
flat baseline	user rollbacks	0.0000	0.0000	0.0000	4	—	—
typical	physical read total bytes	4,477,153.1378	4,273,347.8044	156,906.3076	4	+1.30	+4.8%
typical	table fetch by rowid	11,198.6489	10,794.9733	520.6892	4	+0.78	+3.7%
typical	physical write total bytes	4,623,336.1067	5,030,274.0622	615,889.5383	4	-0.66	-8.1%
typical	table scans (long tables)	0.0036	0.0024	0.0019	4	+0.64	+52.9%
typical	opened cursors cumulative	1,203.3564	1,235.6908	60.7524	4	-0.53	-2.6%
typical	execute count	1,203.5625	1,235.7719	60.7661	4	-0.53	-2.6%
typical	user commits	41.7317	42.6815	2.1298	4	-0.45	-2.2%
typical	redo writes	42.0281	42.9619	2.1374	4	-0.44	-2.2%
typical	redo size	355,173.6033	358,574.2119	10,296.3019	4	-0.33	-0.9%
typical	user calls	199.1125	202.1290	9.7764	4	-0.31	-1.5%
typical	physical reads	461.5522	455.6344	20.5772	4	+0.29	+1.3%
typical	CPU used by this session	11.3475	11.2042	0.7168	4	+0.20	+1.3%
typical	parse count (total)	89.6428	90.4315	4.1560	4	-0.19	-0.9%
typical	bytes received via SQL*Net from client	19,302.5664	19,262.7992	918.0726	4	+0.04	+0.2%
typical	session logical reads	18,459.9375	18,457.4808	900.5404	4	+0.00	+0.0%
typical	physical writes	294.7944	294.7751	11.7412	4	+0.00	+0.0%

System metrics

Change	Metric	Current	Prior mean	Prior sd	n	z-score	% Δ
large	Network Traffic Volume Per Sec	53,413.4635	28,191.0094	1,335.2263	4	+18.89	+89.5%
large	Hard Parse Count Per Sec	0.0692	0.0200	0.0102	4	+4.84	+245.9%
large	Average Active Sessions	0.9284	0.9053	0.0051	4	+4.50	+2.6%
large	Logons Per Sec	0.1760	0.1697	0.0015	4	+4.16	+3.7%
moderate	SQL Service Response Time	0.0693	0.0605	0.0035	4	+2.53	+14.6%
flat baseline	User Rollbacks Per Sec	0.0000	0.0000	0.0000	4	—	—
typical	Physical Read Total Bytes Per Sec	4,471,501.5618	4,262,931.1688	152,201.8538	4	+1.37	+4.9%
typical	Session Count	105.3740	106.3667	0.7457	4	-1.33	-0.9%
typical	Average Synchronous Single-Block Read Latency	0.9026	0.8208	0.0683	4	+1.20	+10.0%
typical	Host CPU Utilization (%)	9.4248	8.6318	0.9622	4	+0.82	+9.2%
typical	Physical Write Total Bytes Per Sec	4,600,085.8312	5,020,657.5761	615,281.2777	4	-0.68	-8.4%
typical	Physical Read Total IO Requests Per Sec	451.1162	442.6007	18.2021	4	+0.47	+1.9%
typical	Executions Per Sec	1,206.0882	1,232.5565	61.4505	4	-0.43	-2.1%
typical	Physical Reads Per Sec	462.1353	454.4063	20.8480	4	+0.37	+1.7%
typical	User Commits Per Sec	41.8248	42.5673	2.1541	4	-0.34	-1.7%
typical	Physical Write Total IO Requests Per Sec	269.4560	267.1125	10.4671	4	+0.22	+0.9%
typical	User Calls Per Sec	199.5304	201.5931	9.8787	4	-0.21	-1.0%
typical	Redo Generated Per Sec	355,772.4285	357,563.8624	10,467.9145	4	-0.17	-0.5%
typical	Total Parse Count Per Sec	89.7625	90.1967	4.1901	4	-0.10	-0.5%
typical	Physical Writes Per Sec	295.1779	293.9654	11.9411	4	+0.10	+0.4%
typical	Logical Reads Per Sec	18,500.0330	18,409.5578	911.3680	4	+0.10	+0.5%
typical	Database CPU Time Ratio	13.2968	13.2719	0.9456	4	+0.03	+0.2%
typical	Database Wait Time Ratio	86.7032	86.7281	0.9456	4	-0.03	-0.0%

Wait classes

Change	Metric	Current	Prior mean	Prior sd	n	z-score	% Δ
large	Wait class: Configuration	0.0328	0.0090	0.0023	4	+10.23	+264.4%
large	Wait class: Commit	0.3032	0.3360	0.0039	4	-8.39	-9.8%
large	Wait class: Other	0.2308	0.2946	0.0085	4	-7.52	-21.7%
moderate	Wait class: User I/O	0.4994	0.4687	0.0115	4	+2.68	+6.6%
flat baseline	Wait class: Administrative	0.0000	0.0000	0.0000	4	—	—
flat baseline	Wait class: Scheduler	0.0000	0.0000	0.0000	4	—	—
typical	Wait class: System I/O	1.1055	1.1408	0.0277	4	-1.27	-3.1%
typical	Wait class: Application	0.0000	0.0000	0.0000	4	+1.12	+9.4%
typical	Wait class: Concurrency	0.0005	0.0008	0.0010	4	-0.30	-36.1%
typical	Wait class: Network	0.0003	0.0003	0.0000	4	+0.17	+1.4%

Headline metrics

Six headline metrics across the compared windows, oldest → current. Badge = z bucket: |z|>3 large, |z|>2 moderate, else typical.

DB time

106.54 cs/s

-4p+0.0%-3p+0.6%-2p+0.3%-1p+5.9%large z=+14.0

Redo generated

355,173.60 B/s

-4p+2.2%-3p-5.1%-2p-1.0%-1p+1.9%typical z=-0.3

Logical reads

18,459.94 /s

-4p+0.2%-3p-6.3%-2p-3.4%-1p+6.1%typical z=+0.0

Average Active Sessions

0.93 AAS

-4p+0.1%-3p+0.8%-2p+0.3%-1p+1.9%large z=+4.5

Wait Time Ratio

86.70 %

-4p+0.8%-3p+1.1%-2p+0.6%-1p-1.2%typical z=-0.0

Hard parses

0.07 /s

-4p+61.9%-3p-2.9%-2p-75.8%-1p+983.3%large z=+5.1

ASH timeline (hourly, stacked by wait class)

dba_hist_active_sess_history, 2026-07-06 15:00 → 2026-07-06 20:00, hourly buckets. ON-CPU → CPU; Idle excluded. Compared windows shaded.

Database time (full comparison span)

DB time per snap interval, stacked by wait_class, earliest compared window → current. CPU: dba_hist_sys_time_model (stat_name=DB CPU). Waits: dba_hist_system_event grouped by wait_class (Idle excluded). Snap-pairs across an instance restart → gap.

Top SQL ASH breakdown (hourly, per SQL, stacked by wait event)

For each SQL in the Top-N pool (union across all ranking dimensions), per-bucket ASH samples split by individual wait event (top 7 per SQL by sample count; remainder grouped as Other; CPU = ON-CPU). dba_hist_active_sess_history, 2026-07-06 15:00 → 2026-07-06 20:00, hourly buckets. Compared windows shaded. SQLs with fewer than 5 samples appear as placeholders.

g81cbrq5yamf5 · 145 ASH samples · dominant: db file sequential read

SELECT ADDRESS_ID, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, STREET_NAME, TOWN, COUNTY, COUNTRY, POST_CODE, ZIP_CODE FROM ADDRESSES WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1

7ws837zynp1zv · 132 ASH samples · dominant: db file sequential read

SELECT CARD_ID, CUSTOMER_ID, CARD_TYPE, CARD_NUMBER, EXPIRY_DATE, IS_VALID, SECURITY_CODE FROM CARD_DETAILS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1

3fw75k1snsddx · 130 ASH samples · dominant: db file sequential read

INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, WAREHOUSE_ID, DELIVERY_TYPE, DELIVERY_ADDRESS_ID, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, CUSTOMER_CLASS, CARD_ID,

f7rxuxzt64k87 · 102 ASH samples · dominant: db file sequential read

INSERT INTO ORDER_ITEMS ( ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY, GIFT_WRAP, CONDITION, ESTIMATED_DELIVERY ) VALUES ( :B4 , :B3 , :B2 , :B1 , 1, 'None', 'New', (SYSDATE + 3) )

5ckxyqfvu60pj · 84 ASH samples · dominant: db file sequential read

SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSHOT, PARTNER_MAILSHOT

9t3n2wpr7my63 · 78 ASH samples · dominant: db file sequential read

INSERT INTO ADDRESSES ( ADDRESS_ID, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, STREET_NAME, TOWN, COUNTY, COUNTRY, POST_CODE, ZIP_CODE ) VALUES ( :B6 , :B5 , TRUNC(SYSDATE,'MI'), FLOOR(DBMS_RANDOM.V

gh2g2tynpcpv1 · 60 ASH samples · dominant: db file sequential read

INSERT INTO CUSTOMERS ( CUSTOMER_ID , CUST_FIRST_NAME , CUST_LAST_NAME , NLS_LANGUAGE , NLS_TERRITORY , CREDIT_LIMIT , CUST_EMAIL , ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MA

0y1prvxqc2ra9 · 39 ASH samples · dominant: CPU

SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUC

c13sma6rkr27c · 39 ASH samples · dominant: CPU

SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUC

3n4tadqgd9b9r · 20 ASH samples · dominant: CPU

BEGIN :1 :=  orderentry.neworder(:2,:3,:4); END;

5mddt5kt45rg3 · 18 ASH samples · dominant: db file sequential read

UPDATE ORDERS SET ORDER_MODE = 'online', ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(0, :B3 )), ORDER_TOTAL = :B2 WHERE ORDER_ID = :B1

7yhuvsmwggtqn · 11 ASH samples · dominant: CPU

BEGIN :1 :=  orderentry.browseproducts(:2,:3,:4); END;

8z3542ffmp562 · 5 ASH samples · dominant: CPU

SELECT QUANTITY_ON_HAND FROM PRODUCT_INFORMATION P, INVENTORIES I WHERE I.PRODUCT_ID = :B2 AND I.PRODUCT_ID = P.PRODUCT_ID AND I.WAREHOUSE_ID = :B1

ajjqqrmacwv34 · 3 ASH samples — insufficient for a stacked timeline

BEGIN :1 :=  orderentry.browseandupdateorders(:2,:3,:4); END;

9x2prazfz86dz · 2 ASH samples — insufficient for a stacked timeline

 select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, t.obj# from tab$ t, seg$ s where bitand(s.spare1, 4503599627370496) = 4503599627370496 and bitand(s.spare1, 65536) <> 65536  and s.file# = t.file#

awm8fgc8hw28q · 2 ASH samples — insufficient for a stacked timeline

select name, ts#, contents$, online$, flags, bitmapped, blocksize, con_id from  (  awri$_cdb_ts$  )

06gapn9jpn8p1 · 1 ASH samples — insufficient for a stacked timeline

BEGIN :1 :=  orderentry.updateCustomerDetails(:2,:3,:4,:5,:6,:7,:8); END;

0za9fv0j1vgkk · 1 ASH samples — insufficient for a stacked timeline

WITH MONITOR_DATA AS (SELECT * FROM TABLE(GV$(CURSOR( SELECT USERENV('instance') AS INST_ID, KEY, NVL2(PX_QCSID, NULL, STATUS) STATUS, FIRST_REFRESH_TIME, LAST_REFRESH_TIME, REFRESH_COUNT, PROCESS_NAM

21ss57x3bykp3 · 1 ASH samples — insufficient for a stacked timeline

BEGIN :1 :=  orderentry.newcustomer(:2,:3,:4,:5,:6,:7,:8,:9,:10); END;

2jzz7j5bkc3xj · 1 ASH samples — insufficient for a stacked timeline

insert into  WRH$_EVENT_HISTOGRAM  (dbid, per_pdb, con_dbid, snap_id, instance_number,     event_id, wait_time_milli, wait_count ) select  :dbid,  s.con_id, con_id_to_dbid(s.con_id)  con_dbid,  :snap_

7r7636982atn9 · 1 ASH samples — insufficient for a stacked timeline

UPDATE INVENTORIES SET QUANTITY_ON_HAND = QUANTITY_ON_HAND - :B1 WHERE PRODUCT_ID = :B3 AND WAREHOUSE_ID = :B2

Showing 13 SQL chart(s); 8 SQL(s) had fewer than 5 ASH samples and are listed as placeholders.

Parameter changes

Initialization parameters from dba_hist_parameter whose value differs across the compared windows (value as of each window’s end snapshot). Only changed parameters are listed; highlighted cells differ from the Current value. — = not present at that snapshot; (unset) = present but empty.

Parameter	Current	−1h	−2h	−3h	−4h
`common_user_prefix`	(unset)	(unset)	(unset)	`C##`	`C##`
`parallel_servers_target`	`40`	`40`	`16`	`40`	`40`
`sga_target`	`0`	`1610612736`	`0`	`0`	`0`
`undo_tablespace`	`UNDOTBS1`	`UNDOTBS1`	`UNDOTBS1`	`UNDOTBS1`	(unset)

4 parameters changed across the compared windows.

Database utilization — how the applications use this DB

Workload volume and shape only — transaction, call and logon rates, session counts, data and network volume (DBA_HIST_SYSMETRIC_SUMMARY, AVG over each window). This is a usage overview, not a health check: movement here usually reflects application behaviour (releases, batch schedules, user load), not database trouble. Trend: per-window values, oldest → current.

Transactions and SQL activity

Metric	Unit	Current	−1h	−2h	−3h	−4h
Transactions / s	Transactions Per Second	41.82	39.96	41.64	44.47	44.19
Commits / s	Commits Per Second	41.82	39.96	41.64	44.47	44.19
Rollbacks / s	Rollbacks Per Second	0.00	0.00	0.00	0.00	0.00
SQL executions / s	Executes Per Second	1,206.09	1,158.55	1,205.43	1,283.87	1,282.38
User calls / s	Calls Per Second	199.53	189.62	197.37	210.23	209.15
Parses (total) / s	Parses Per Second	89.76	85.13	88.39	93.94	93.32
Cursors opened / s	Cursors Per Second	1,205.90	1,158.48	1,205.36	1,283.80	1,282.26

Connections and sessions

Metric	Unit	Current	−1h	−2h	−3h	−4h
Logons / s	Logons Per Second	0.1760	0.1720	0.1686	0.1691	0.1692
Sessions	Sessions	105.37	105.97	106.25	107.45	105.80
Logged-on users	Logons	67.88	67.13	66.90	67.10	66.22
Open cursors	Cursors	130.67	131.63	136.23	142.02	141.02

Data and network volume

Metric	Unit	Current	−1h	−2h	−3h	−4h
Logical reads / s	Reads Per Second	18,500.03	17,317.97	17,997.80	19,178.96	19,143.51
Physical reads / s	Reads Per Second	462.14	429.98	444.75	475.53	467.36
Physical writes / s	Writes Per Second	295.18	280.00	288.36	305.97	301.53
Block changes / s	Blocks Per Second	1,617.38	1,541.08	1,595.43	1,698.28	1,686.50
Redo bytes / s	Bytes Per Second	355,772.43	346,712.83	351,469.81	369,927.50	362,145.31
I/O MB / s	Megabtyes per Second	8.65	8.14	9.18	9.63	8.47
Network bytes / s	Bytes Per Second	53,413.46	26,565.74	27,638.71	29,404.38	29,155.21

Segment I/O (top 10 per dimension, per window)

Segments with the most I/O activity per window, from DBA_HIST_SEG_STAT *_DELTA joined to DBA_HIST_SEG_STAT_OBJ for names. Reads/writes are blocks; requests are I/O calls. Chart per dimension: each line = one segment across windows, oldest → current; toggle to roll the same totals up by object type (the rollup covers all segments, not just the charted top-10). Detail tables collapsed; click to expand.

By physical reads

Break down by:

Detail table

Segment	Type	Current (blocks)	−1h	−2h	−3h	−4h
SOE.CUSTOMERS	TABLE	197,720 #1	188,694	195,494	207,653	205,217
SOE.ADDRESSES	TABLE	147,279 #2	143,602	147,941	158,508	158,075
SOE.ADDRESS_CUST_IX	INDEX	131,041 #3	125,708	130,644	139,583	138,900
SOE.CUSTOMERS_PK	INDEX	129,222 #4	123,835	128,288	137,368	136,152
SOE.CARD_DETAILS	TABLE	129,068 #5	125,032	130,107	138,946	138,868
SOE.ORDER_PK	INDEX	105,952 #6	102,642	106,797	114,284	115,128
SOE.ITEM_ORDER_IX	INDEX	100,651 #7	96,874	100,494	107,797	107,355
SOE.ORD_CUSTOMER_IX	INDEX	99,664 #8	95,586	98,125	103,123	101,375
SOE.ORDER_ITEMS_PK	INDEX	90,316 #9	86,689	89,737	96,558	96,214
SOE.CARDDETAILS_CUST_IX	INDEX	83,710 #10	80,882	84,294	89,603	89,615

By physical writes

Break down by:

Detail table

Segment	Type	Current (blocks)	−1h	−2h	−3h	−4h
SOE.INVENTORIES	TABLE	161,815 #1	160,209	164,781	174,000	174,258
SOE.ORD_CUSTOMER_IX	INDEX	100,577 #2	96,230	97,010	99,829	96,454
SOE.ORDER_PK	INDEX	97,542 #3	94,093	96,525	103,070	103,916
SOE.ORDER_ITEMS_PK	INDEX	85,506 #4	81,040	84,510	91,426	91,597
SOE.ITEM_ORDER_IX	INDEX	85,146 #5	80,989	84,403	90,727	90,982
SOE.ORD_WAREHOUSE_IX	INDEX	75,920 #6	72,130	73,683	78,511	77,321
SOE.ORD_ORDER_DATE_IX	INDEX	73,440 #7	70,184	71,462	74,533	72,619
SOE.ADDRESS_PK	INDEX	43,795 #8	41,597	43,171	46,200	45,357
SOE.ADDRESS_CUST_IX	INDEX	43,481 #9	41,335	43,022	46,082	45,192
SOE.CUST_DOB_IX	INDEX	36,823 #10	34,447	34,918	—	—
SOE.CUSTOMERS_PK	INDEX	—	—	—	36,112	35,471

By physical read requests

Break down by:

Detail table

Segment	Type	Current (reqs)	−1h	−2h	−3h	−4h
SOE.CUSTOMERS	TABLE	197,720 #1	188,694	195,494	207,652	205,217
SOE.ADDRESSES	TABLE	147,279 #2	143,602	147,941	158,508	158,075
SOE.ADDRESS_CUST_IX	INDEX	131,041 #3	125,708	130,644	139,583	138,900
SOE.CUSTOMERS_PK	INDEX	129,222 #4	123,835	128,288	137,368	136,152
SOE.CARD_DETAILS	TABLE	129,067 #5	125,032	130,107	138,946	138,868
SOE.ORDER_PK	INDEX	105,952 #6	102,642	106,797	114,284	115,128
SOE.ITEM_ORDER_IX	INDEX	100,651 #7	96,874	100,494	107,797	107,355
SOE.ORD_CUSTOMER_IX	INDEX	99,664 #8	95,586	98,125	103,123	101,375
SOE.ORDER_ITEMS_PK	INDEX	90,316 #9	86,689	89,737	96,558	96,214
SOE.CARDDETAILS_CUST_IX	INDEX	83,710 #10	80,882	84,294	89,603	89,615

By physical write requests

Break down by:

Detail table

Segment	Type	Current (reqs)	−1h	−2h	−3h	−4h
SOE.ORD_CUSTOMER_IX	INDEX	85,246 #1	81,879	84,310	88,884	88,013
SOE.ORDER_ITEMS_PK	INDEX	84,070 #2	80,901	84,219	90,304	90,435
SOE.ITEM_ORDER_IX	INDEX	83,938 #3	80,876	84,170	90,068	90,207
SOE.ORDER_PK	INDEX	80,569 #4	76,371	78,388	81,267	82,893
SOE.INVENTORIES	TABLE	66,981 #5	63,516	64,883	68,374	67,721
SOE.ORD_ORDER_DATE_IX	INDEX	52,738 #6	49,038	48,127	48,735	45,486
SOE.ADDRESS_PK	INDEX	43,791 #7	41,591	43,158	46,172	45,333
SOE.ADDRESS_CUST_IX	INDEX	42,920 #8	40,794	42,455	45,479	44,579
SOE.ORD_WAREHOUSE_IX	INDEX	38,800 #9	34,962	34,677	36,668	35,376
SOE.CUSTOMERS_PK	INDEX	33,387 #10	32,004	33,482	36,070	35,421

File I/O (top 10 per dimension, per window)

Data and temp files with the most I/O per window, from DBA_HIST_FILESTATXS / DBA_HIST_TEMPSTATXS (end snap minus begin snap; blocks scaled to MB by each file's block size). Chart per dimension: each line = one file across windows, oldest → current; toggle to the per-file-type view from DBA_HIST_IOSTAT_FILETYPE — the AWR report's "IOStat by Filetype" — which covers all database I/O (control file, redo log, archive log, …), so the two modes' totals legitimately differ. Detail tables collapsed; click to expand.

By data read (MB)

Break down by:

Detail table

File	Tablespace	Current (MB)	−1h	−2h	−3h	−4h
o1_mf_soe_ngqd80sr_.dbf	SOE	11,991.3 #1	11,494.5	11,867.1	12,648.6	12,508
sysaux01.dbf	SYSAUX	445.3 #2	185	191.8	230.5	197.3
undotbs01.dbf	UNDOTBS1	423.1 #3	381.2	372	384.8	366.6
undotbs01.dbf	UNDOTBS1	11.5 #4	11.1	11.1	11.6	11.4
sysaux01.dbf	SYSAUX	6 #5	6	6	14.8	6.2
o1_mf_temp_o1bpt2bz_.tmp	TEMP	0 #6	0	0	0	0
o1_mf_temp_o1bpv2kq_.tmp	TEMP	0 #7	0	0	0	0
temp01.dbf	TEMP	0 #8	0	0	0	0
temp01.dbf	TEMP	0 #9	0	0	0	0

By data written (MB)

Break down by:

Detail table

File	Tablespace	Current (MB)	−1h	−2h	−3h	−4h
o1_mf_soe_ngqd80sr_.dbf	SOE	7,805.1 #1	7,489.5	7,709.8	8,194.2	8,073.3
undotbs01.dbf	UNDOTBS1	424.2 #2	382.9	372.9	386.5	368.1
sysaux01.dbf	SYSAUX	40.3 #3	24.1	27.2	28.1	28.5
undotbs01.dbf	UNDOTBS1	12.6 #4	12.3	12.4	12.7	12.6
sysaux01.dbf	SYSAUX	0.6 #5	0.4	0.4	0.6	0.6

By read requests

Break down by:

Detail table

File	Tablespace	Current (reqs)	−1h	−2h	−3h	−4h
o1_mf_soe_ngqd80sr_.dbf	SOE	1,534,888 #1	1,471,298	1,518,995	1,619,023	1,601,022
sysaux01.dbf	SYSAUX	29,126 #2	5,130	5,950	6,026	6,861
undotbs01.dbf	UNDOTBS1	6,785 #3	6,123	5,974	6,186	5,875
undotbs01.dbf	UNDOTBS1	395 #4	341	363	348	372
sysaux01.dbf	SYSAUX	198 #5	194	192	469	218
o1_mf_temp_o1bpt2bz_.tmp	TEMP	6 #6	6	6	6	6
o1_mf_temp_o1bpv2kq_.tmp	TEMP	6 #7	6	6	6	6
temp01.dbf	TEMP	6 #8	6	6	6	6
temp01.dbf	TEMP	6 #9	6	6	6	6

By write requests

Break down by:

Detail table

File	Tablespace	Current (reqs)	−1h	−2h	−3h	−4h
o1_mf_soe_ngqd80sr_.dbf	SOE	777,568 #1	738,365	759,765	806,253	793,225
undotbs01.dbf	UNDOTBS1	4,206 #2	3,622	3,407	3,676	3,256
sysaux01.dbf	SYSAUX	2,745 #3	2,187	2,375	2,426	2,338
undotbs01.dbf	UNDOTBS1	416 #4	431	552	697	591
sysaux01.dbf	SYSAUX	48 #5	35	33	49	49

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

Metric	File type	Current	−1h	−2h	−3h	−4h
Data read (MB)	Log File	1,315 #1	1,265	1,259	1,373	1,332
Data read (MB)	Control File	821 #2	680	574	481	401
Data read (MB)	Archive Log	246 #3	—	—	—	—
Data read (MB)	Flashback Log	4 #4	4	3	34	6
Data read (MB)	Other	1 #5	1	1	—	1
Data written (MB)	Flashback Log	4,706 #1	4,588	7,764	7,964	4,318
Data written (MB)	Archive Log	1,314 #2	1,265	1,258	1,374	1,331
Data written (MB)	Log File	1,296 #3	1,273	1,286	1,356	1,326
Data written (MB)	Control File	267 #4	257	212	176	149
Data written (MB)	Other	1 #5	1	1	1	1
Read requests	Control File	43,680 #1	35,981	28,673	23,535	20,319
Read requests	Log File	1,598 #2	1,472	1,467	1,602	1,554
Read requests	Flashback Log	468 #3	456	382	568	601
Read requests	Archive Log	247 #4	—	—	—	—
Read requests	Other	180 #5	183	180	180	180
Write requests	Log File	152,185 #1	146,149	151,720	162,196	160,994
Write requests	Control File	17,132 #2	16,446	13,538	11,240	9,570
Write requests	Flashback Log	11,840 #3	11,657	14,932	15,055	11,236
Write requests	Archive Log	1,330 #4	1,280	1,275	1,392	1,350
Write requests	Other	240 #5	244	240	240	240