AWR Timeline Comparison — run 20260706212320547

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

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 writes (/s)	294.79	281.47	288.67	306.80	302.16
user calls (/s)	199.11	190.49	197.62	210.70	209.71
user commits (/s)	41.73	40.16	41.69	44.58	44.30
parse count (hard) (/s)	0.0722	0.0067	0.0275	0.0283	0.0175

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
Logical Reads Per Sec	Reads Per Second	18,500.03	17,317.97	17,997.80	19,178.96	19,143.51
User Commits Per Sec	Commits Per Second	41.82	39.96	41.64	44.47	44.19
SQL Service Response Time	CentiSeconds Per Call	0.0693	0.0649	0.0618	0.0577	0.0577

Event	Current (s)	−1h (s)	−2h (s)	−3h (s)	−4h (s)	Change	z-score	% Δ
db file sequential read	1,680.39 #1	1,635.43	1,594.31	1,553.44	1,559.81	moderate	+2.51	+6.0%
log file sync	1,091.38 #2	1,203.17	1,224.21	1,218.36	1,193.29	large	-8.39	-9.8%
log file parallel write	987.16 #3	1,072.05	1,100.77	1,084.15	1,036.78	large	-3.18	-8.0%
db file scattered read	8.24 #4	5.69	5.72	8.03	5.72	typical	+1.68	+30.9%
direct path read	1.51 #5	—	—	—	—	insufficient history	—	—
cursor: pin S wait on X	0.98 #6	—	—	—	—	insufficient history	—	—
latch: shared pool	0.83 #7	0.03	8.46	2.18	0.42	typical	-0.50	-70.1%
library cache: mutex X	0.11 #8	0.14	0.03	0.06	0.23	typical	-0.03	-2.7%

Event	Current (ms)	−1h (ms)	−2h (ms)	−3h (ms)	−4h (ms)	Change	z-score	% Δ
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%
db file scattered read	1.00	0.78	0.81	1.01	0.81	typical	+1.42	+17.5%
direct path read	2.77	—	—	—	—	insufficient history	—	—
cursor: pin S wait on X	490.18	—	—	—	—	insufficient history	—	—
latch: shared pool	9.88	2.54	497.87	128.06	14.83	typical	-0.65	-93.9%
library cache: mutex X	3.11	3.82	1.09	1.74	7.08	typical	-0.12	-9.4%

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%

Event	Current (s)	−1h (s)	−2h (s)	−3h (s)	−4h (s)	Change	z-score	% Δ
log file parallel write	987.11 #1	1,072.09	1,100.76	1,084.14	1,036.77	large	-3.18	-8.0%
db file sequential read	15.20 #2	11.15	15.06	16.27	14.26	typical	+0.47	+7.2%
db file scattered read	3.83 #3	2.90	3.15	5.53	3.35	typical	+0.08	+2.6%
log file sync	0.23 #4	0.20	0.10	0.13	0.23	typical	+1.04	+37.4%
latch: shared pool	0.10 #5	0.01	8.20	0.32	0.03	typical	-0.51	-95.4%
library cache: mutex X	0.10 #6	0.13	0.03	0.04	0.22	typical	-0.09	-7.8%

Event	Current (ms)	−1h (ms)	−2h (ms)	−3h (ms)	−4h (ms)	Change	z-score	% Δ
log file parallel write	6.52	7.37	7.29	6.71	6.46	typical	-1.00	-6.4%
db file sequential read	2.28	1.76	2.24	2.24	1.94	typical	+0.97	+11.2%
db file scattered read	3.33	2.48	2.78	3.09	2.93	typical	+1.99	+18.1%
log file sync	10.29	8.05	4.71	6.97	10.30	typical	+1.20	+37.1%
latch: shared pool	5.52	2.55	745.08	22.59	2.37	typical	-0.51	-97.1%
library cache: mutex X	3.35	4.47	1.16	1.64	8.53	typical	-0.18	-15.3%

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 )

Change	Metric	Current	Prior mean	Prior sd	n	z-score	% Δ
large	DB time	106.5381	100.0810	0.4627	4	+13.96	+6.5%
large	parse count (hard)	0.0722	0.0200	0.0102	4	+5.14	+261.1%
typical	user commits	41.7317	42.6815	2.1298	4	-0.45	-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	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%

Change	Metric	Current	Prior mean	Prior sd	n	z-score	% Δ
large	Average Active Sessions	0.9284	0.9053	0.0051	4	+4.50	+2.6%
moderate	SQL Service Response Time	0.0693	0.0605	0.0035	4	+2.53	+14.6%
typical	Session Count	105.3740	106.3667	0.7457	4	-1.33	-0.9%
typical	Host CPU Utilization (%)	9.4248	8.6318	0.9622	4	+0.82	+9.2%
typical	User Commits Per Sec	41.8248	42.5673	2.1541	4	-0.34	-1.7%
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%

Change	Metric	Current	Prior mean	Prior sd	n	z-score	% Δ
large	Wait class: Commit	0.3032	0.3360	0.0039	4	-8.39	-9.8%
large	Wait class: System I/O	0.2742	0.2982	0.0075	4	-3.18	-8.0%
moderate	Wait class: User I/O	0.4695	0.4422	0.0103	4	+2.65	+6.2%
typical	Wait class: Concurrency	0.0005	0.0008	0.0011	4	-0.25	-33.4%

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	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)

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

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

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

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

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

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

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

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

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

Aligned windows

Generate full AWR reports for these windows

Load profile — per-second rates

System metrics (DBA_HIST_SYSMETRIC_SUMMARY)

Foreground wait events (top 10 by time waited)

Top 10 events — time waited (s)

Top 10 events — avg time per wait (ms)

Wait-class rollup — time waited (s)

Background wait events

Events — time waited (s)

Events — avg time per wait (ms)

Top SQL (top 10 per dimension, per window)

By elapsed time

By CPU time

By buffer gets

By physical reads

By executions

By per-exec regression

Per-SQL detail

Findings summary

Load profile

System metrics

Wait classes

Headline metrics

ASH timeline (hourly, stacked by wait class)

Database time (full comparison span)

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

Parameter changes

Database utilization — how the applications use this DB

Transactions and SQL activity

Connections and sessions

Data and network volume

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

By physical reads

By physical writes

By physical read requests

By physical write requests

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

By data read (MB)

By data written (MB)

By read requests

By write requests