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

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

Nothing moved beyond its normal range.

All 18 scored metrics sit within their normal range over the prior 4 windows.

18 metrics normal

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

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

Every 1h, 1h windows5 windows

vs prior meanclick a date to pin

All sectionsEvery table of the report

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

DB time per windowaverage active sessions

07:00−4h

08:00−3h

09:00−2h

10:00−1h

11:00current

vs prior mean

0.01013AASnormal 0.00661–0.01707

0.01047

0.01173

0.01554

0.009619

0.01013

▼ 14.4%z −0.7σ

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

Findings18 normalEvery scored metric against its prior windowsEvery scored metric against its prior windows; one table per domain

No finding: every scored metric sits inside its normal range, or moved too little to matter.

Load profile

Metric	Current	Normal range	vs normal, in σ	z	Δ vs mean	Prior mean	Prior sd	n
physical reads ↗ row	5.206	0.4928–1.939	+11.0σ	+11.0σ	▲ ×4.3immaterial	1.216	0.3616	4
session logical reads ↗ row	57.12	46.25–56.89		+2.1σ	▲ 10.8%immaterial	51.57	2.660	4
DB CPU ↗ row	0.5109	0.486–0.6535		−1.4σ	▼ 10.3%	0.5697	0.04188	4
redo size ↗ row	5,371	5,031–5,451		+1.2σ	▲ 2.5%	5,241	53.62	4
user calls ↗ row	3.527	3.462–3.775		−1.2σ	▼ 2.5%	3.618	0.0783	4
parse count (hard) ↗ row	0.008604	0–0.07251		−0.8σ	▼ 68.5%	0.02729	0.02261	4
user commits ↗ row	0.02304	0.02168–0.02611		−0.8σ	▼ 3.6%	0.0239	0.001108	4
DB time ↗ row	1.013	0.661–1.707		−0.7σ	▼ 14.4%	1.184	0.2615	4
physical writes ↗ row	1.846	1.766–1.913		+0.2σ	▲ 0.4%	1.839	0.0324	4

▸ Show 9 normal / improved / flat rows

System metrics

Metric	Current	Normal range	z	Δ vs mean	Prior mean	Prior sd	n
Logical Reads Per Sec twin ↗ row	56.37	46.03–56.99	+1.8σ	▲ 9.4%	51.51	2.739	4
User Commits Per Sec twin ↗ row	0.02239	0.02155–0.02599	−1.2σ	▼ 5.8%	0.02377	0.00111	4
Host CPU Utilization (%) ↗ row	1.256	0.794–2.523	−0.9σ	▼ 24.2%	1.658	0.4322	4
Average Active Sessions twin ↗ row	0.01019	0.006548–0.01711	−0.6σ	▼ 13.9%	0.01183	0.002641	4
SQL Service Response Time ↗ row	0.03822	0.03055–0.05274	−0.6σ	▼ 8.2%	0.04165	0.005548	4
Database Wait Time Ratio ↗ row	41.60	38.13–43.47	+0.6σ	▲ 2.0%	40.80	1.334	4
Database CPU Time Ratio twin ↗ row	58.40	56.53–61.87	−0.6σ	▼ 1.3%	59.20	1.334	4
Session Count ↗ row	108.8	104.9–113.6	−0.2σ	▼ 0.4%σ≈0	109.3	0.8406	4

▸ Show 8 normal / improved / flat rows

Wait classes

Metric	Current	Normal range	z	Δ vs mean	Prior mean	Prior sd	n
Wait class: User I/O ↗ row	0.000097	0.000013–0.000099	+1.9σ	▲ 74.9%	0.000056	0.000021	4
Wait class: Application ↗ row	0.00141	0–0.002335	+0.9σ	▲ 99.8%	0.000706	0.000815	4
Wait class: Concurrency ↗ row	<0.000001	0–0.0001	−0.5σ	▼ 100.0%	0.000021	0.000039	4
Wait class: Commit ↗ row	0.000096	0.000084–0.000111	−0.3σ	▼ 1.9%	0.000098	0.000007	4
Wait class: System I/O ↗ row	0.006035	0.005712–0.006419	−0.2σ	▼ 0.5%	0.006066	0.000177	4

▸ Show 5 normal / improved / flat rows

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

User I/O waitsnormal 0.000013–0.000099 AAS

0.000097 AAS▲ 74.9%

DB CPUnormal 0.00486–0.006535 AAS

0.005109 AAS▼ 10.3%

Redo generatednormal 5.031–5.451 kB/s

5.371 kB/s▲ 2.5%

User callsnormal 3.462–3.775/s

3.527/s▼ 2.5%

Host CPUnormal 0.794–2.523 %

1.256 %▼ 24.2%

Application waitsnormal 0–0.002335 AAS

0.00141 AAS▲ 99.8%

Hard parsesnormal 0–0.07251/s

0.008604/s▼ 68.5%

User commitsnormal 0.02168–0.02611/s

0.02304/s▼ 3.6%

DB timenormal 0.00661–0.01707 AAS

0.01013 AAS▼ 14.4%

SQL response timenormal 0.3055–0.5274 ms/call

0.3822 ms/call▼ 8.2%

Wait time rationormal 38.13–43.47 %

41.60 %▲ 2.0%

Concurrency waitsnormal 0–0.0001 AAS

<0.000001 AAS▼ 100.0%

Commit waitsnormal 0.000084–0.000111 AAS

0.000096 AAS▼ 1.9%

Sessionsnormal 104.9–113.6 sessions

108.8 sessions▼ 0.4%

Physical writesnormal 1.766–1.913/s

1.846/s▲ 0.4%

System I/O waitsnormal 0.005712–0.006419 AAS

0.006035 AAS▼ 0.5%

Moved, too small to matter

Physical readsnormal 0.4928–1.939/s

+11.0σ

5.206/s▲ ×4.3

Logical readsnormal 46.25–56.89/s

57.12/s▲ 10.8%

Improved: none material

Nothing moved materially in the good direction.

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

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

Window	Window start	Window end	Begin snap	End snap	Status
Current	2026-09-18 Fri 11:00	2026-09-18 Fri 12:00	2088	2092	valid
−1h	2026-09-18 Fri 10:00	2026-09-18 Fri 11:00	2084	2088	valid
−2h	2026-09-18 Fri 09:00	2026-09-18 Fri 10:00	2080	2084	valid
−3h	2026-09-18 Fri 08:00	2026-09-18 Fri 09:00	2076	2080	valid
−4h	2026-09-18 Fri 07:00	2026-09-18 Fri 08:00	2072	2076	valid

Generate full AWR reports for these windows

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

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

-- current: 2026-09-18 11:00 -> 2026-09-18 12:00  (dbid 1214129087, snaps 2088 -> 2092)
SPOOL awr_1214129087_all_2088_2092.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1214129087, NULL, 2088, 2092));
SPOOL OFF

-- -1h: 2026-09-18 10:00 -> 2026-09-18 11:00  (dbid 1214129087, snaps 2084 -> 2088)
SPOOL awr_1214129087_all_2084_2088.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1214129087, NULL, 2084, 2088));
SPOOL OFF

-- -2h: 2026-09-18 09:00 -> 2026-09-18 10:00  (dbid 1214129087, snaps 2080 -> 2084)
SPOOL awr_1214129087_all_2080_2084.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1214129087, NULL, 2080, 2084));
SPOOL OFF

-- -3h: 2026-09-18 08:00 -> 2026-09-18 09:00  (dbid 1214129087, snaps 2076 -> 2080)
SPOOL awr_1214129087_all_2076_2080.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1214129087, NULL, 2076, 2080));
SPOOL OFF

-- -4h: 2026-09-18 07:00 -> 2026-09-18 08:00  (dbid 1214129087, snaps 2072 -> 2076)
SPOOL awr_1214129087_all_2072_2076.html
SELECT output FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_GLOBAL_REPORT_HTML(1214129087, NULL, 2072, 2076));
SPOOL OFF

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

Transactions and SQL activity

Metric	Unit	Current	Normal range	z	Δ vs mean	−1h	−2h	−3h	−4h
Transactions / s	Transactions Per Second	0.02295	0.02138–0.02685	−0.9σ	▼ 4.9%	0.02259	0.02361	0.02583	0.02444
Commits / s	Commits Per Second	0.02239	0.02155–0.02599	−1.2σ	▼ 5.8%	0.02259	0.02361	0.02527	0.02361
Rollbacks / s	Rollbacks Per Second	0.000555	0–0.00118	+0.5σ	▲ 60.0%	0	0	0.000555	0.000833
SQL executions / s	Executes Per Second	3.873	2.973–5.415	−0.5σ	▼ 7.6%	3.661	4.643	4.797	3.676
User calls / s	Calls Per Second	3.545	3.431–3.785	−0.7σ	▼ 1.7%	3.554	3.579	3.740	3.559
Parses (total) / s	Parses Per Second	3.496	2.766–4.508	−0.3σ	▼ 3.9%	3.243	3.902	4.111	3.292
Cursors opened / s	Cursors Per Second	3.556	2.630–5.086	−0.5σ	▼ 7.8%	3.314	4.213	4.540	3.365

Connections and sessions

Metric	Unit	Current	Normal range	z	Δ vs mean	−1h	−2h	−3h	−4h
Logons / s	Logons Per Second	0.07505	0.06445–0.1018	−0.9σ	▼ 9.7%	0.07623	0.07915	0.09694	0.08028
Sessions	Sessions	108.8	104.9–113.6	−0.2σ	▼ 0.4%σ≈0	110.4	109.3	109.0	108.3
Logged-on users	Logons	70.06	68.74–74.47	−1.1σ	▼ 2.2%	70.35	70.90	72.12	73.07
Open cursors	Cursors	155.5	134.1–164.5	+0.8σ	▲ 4.2%	158.3	151.5	147.0	140.3

Data and network volume

Metric	Unit	Current	Normal range	vs normal, in σ	z	Δ vs mean	−1h	−2h	−3h	−4h
Logical reads / s	Reads Per Second	56.37	46.03–56.99		+1.8σ	▲ 9.4%	49.25	53.93	53.82	49.03
Physical reads / s	Reads Per Second	5.063	0.4371–1.988	+9.9σ	+9.9σ	▲ ×4.2	0.8901	1.148	1.772	1.040
Physical writes / s	Writes Per Second	1.806	1.765–1.912		−0.9σ	▼ 1.8%	1.827	1.877	1.850	1.800
Block changes / s	Blocks Per Second	13.65	13.55–14.68		−1.6σ	▼ 3.2%	13.90	14.40	14.21	13.94
Redo bytes / s	Bytes Per Second	5,276	5,011–5,428		+0.5σ	▲ 1.1%σ≈0	5,185	5,245	5,263	5,184
I/O MB / s	Megabtyes per Second	0.208	0.1209–0.2136		+1.8σ	▲ 24.4%	0.1434	0.1905	0.1833	0.1517
Network bytes / s	Bytes Per Second	1,703	1,647–1,784		−0.4σ	▼ 0.7%	1,695	1,713	1,757	1,695

Load profileSystem statistics per second, Current against its normal range

Metric	Unit	Current	Normal range	vs normal, in σ	z	Δ vs mean	−1h	−2h	−3h	−4h
DB time	cs/s	1.013	0.661–1.707		−0.7σ	▼ 14.4%	0.9619	1.554	1.173	1.047
DB CPU	cs/s	0.5109	0.486–0.6535		−1.4σ	▼ 10.3%	0.5821	0.5415	0.6234	0.5319
redo size	bytes/s	5,371	5,031–5,451		+1.2σ	▲ 2.5%	5,296	5,203	5,277	5,188
session logical reads	/s	57.12	46.25–56.89		+2.1σ	▲ 10.8%immaterial	49.48	53.76	53.98	49.07
physical reads	/s	5.206	0.4928–1.939	+11.0σ	+11.0σ	▲ ×4.3immaterial	0.9337	1.135	1.744	1.051
physical writes	/s	1.846	1.766–1.913		+0.2σ	▲ 0.4%	1.833	1.876	1.849	1.799
user calls	/s	3.527	3.462–3.775		−1.2σ	▼ 2.5%	3.570	3.577	3.735	3.591
user commits	/s	0.02304	0.02168–0.02611		−0.8σ	▼ 3.6%	0.02314	0.02331	0.02553	0.02359
parse count (hard)	/s	0.008604	0–0.07251		−0.8σ	▼ 68.5%	0.005927	0.05051	0.04274	0.009992

System metricsSYSMETRIC averages per window, Current against its normal range

Metric	Unit	Current	Normal range	z	Δ vs mean	−1h	−2h	−3h	−4h
Average Active Sessions	Active Sessions	0.01019	0.006548–0.01711	−0.6σ	▼ 13.9%	0.009604	0.01555	0.0118	0.01036
Host CPU Utilization (%)	% Busy/(Idle+Busy)	1.256	0.794–2.523	−0.9σ	▼ 24.2%	2.215	1.269	1.780	1.368
Database CPU Time Ratio	% Cpu/DB_Time	58.40	56.53–61.87	−0.6σ	▼ 1.3%	60.76	57.90	59.83	58.30
Database Wait Time Ratio	% Wait/DB_Time	41.60	38.13–43.47	+0.6σ	▲ 2.0%	39.24	42.10	40.17	41.70
Session Count	Sessions	108.8	104.9–113.6	−0.2σ	▼ 0.4%σ≈0	110.4	109.3	109.0	108.3
Logical Reads Per Sec	Reads Per Second	56.37	46.03–56.99	+1.8σ	▲ 9.4%	49.25	53.93	53.82	49.03
User Commits Per Sec	Commits Per Second	0.02239	0.02155–0.02599	−1.2σ	▼ 5.8%	0.02259	0.02361	0.02527	0.02361
SQL Service Response Time	CentiSeconds Per Call	0.03822	0.03055–0.05274	−0.6σ	▼ 8.2%	0.03747	0.04982	0.03955	0.03973

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

Top 10 events — time waited (s)

Event	Current (s)	Normal range	vs normal, in σ	z	Δ vs mean	−1h (s)	−2h (s)	−3h (s)	−4h (s)
log file parallel write	21.75 #1	20.57–22.96		+0.0σ	▼ 0.1%	21.82 #1	20.92 #1	22.01 #1	22.30 #1
enq: TX - row lock contention	5.080 #2	0–8.415		+0.9σ	▲ 99.8%	0	0	5.078 #2	5.092 #2
log file sync	0.3453 #3	0.3072–0.3937		−0.2σ	▼ 1.5%	0.3743 #2	0.3512 #2	0.3544 #3	0.3219 #3
db file scattered read	0.1851 #4	0–0.03848	+15.1σ	+15.1σ	▲ ×11.5immaterial	0.03199 #4	0.005919 #4	0.01452 #6	0.01191 #5
db file sequential read	0.1651 #5	0.01204–0.3494		−0.2σ	▼ 8.6%	0.114 #3	0.2929 #3	0.1984 #5	0.1175 #4
library cache: mutex X	0.000002 #6	0–0.0145		−0.5σ	▼ 99.9%	0.01163 #5	0.000089 #6	0.000295 #8	0.000067 #7
latch: shared pool	0	0–0.3599		−0.5σ	▼ 100.0%	0.001054 #6	0.00516 #5	0.2883 #4	0.000259 #6
direct path read	0	0–0.0144		−0.5σ	▼ 100.0%	0	0	0.01152 #7	0

Top 10 events — avg time per wait (ms)

Event	Current (ms)	Normal range	vs normal, in σ	z	Δ vs mean	−1h (ms)	−2h (ms)	−3h (ms)	−4h (ms)
log file parallel write	5.542	5.185–5.885		+0.0σ	▲ 0.1%	5.653	5.291	5.526	5.671
enq: TX - row lock contention	2,540	2,441–2,644	too little history	−0.1σ	▼ 0.1%n < 3σ≈0	—	—	2,539	2,546
log file sync	5.312	3.877–6.134		+0.5σ	▲ 6.1%	5.758	4.390	4.922	4.952
db file scattered read	0.1379	0–0.3248		+0.2σ	▲ 15.5%	0.2734	0.06297	0.06916	0.07219
db file sequential read	0.09894	0.1913–0.2687	−6.8σ	−6.8σ	▼ 57.0%improved	0.2342	0.2253	0.2534	0.2069
library cache: mutex X	0.002	0–2.071		−0.5σ	▼ 99.5%	1.661	0.0178	0.02682	0.01675
latch: shared pool	—	0–3.475	no current value	—	—	0.3513	0.645	2.827	0.1295
direct path read	—	0.2765–0.2995	no current value	—	—σ≈0	—	—	0.288	—

Wait-class rollup — time waited (s)

Wait class	Current (s)	Normal range	vs normal, in σ	z	Δ vs mean	−1h (s)	−2h (s)	−3h (s)	−4h (s)
System I/O	21.75	20.57–22.96		+0.0σ	▼ 0.1%	21.82	20.92	22.01	22.30
Application	5.080	4.882–5.289	too little history	−0.1σ	▼ 0.1%n < 3σ≈0	—	—	5.078	5.092
User I/O	0.3503	0.04366–0.3557		+1.9σ	▲ 75.4%	0.146	0.2988	0.2245	0.1294
Commit	0.3453	0.3072–0.3937		−0.2σ	▼ 1.5%	0.3743	0.3512	0.3544	0.3219
Concurrency	0.000002	0–0.3594		−0.5σ	▼ 100.0%	0.01268	0.005249	0.2886	0.000326

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

Events — time waited (s)

Event	Current (s)	Normal range	vs normal, in σ	z	Δ vs mean	−1h (s)	−2h (s)	−3h (s)	−4h (s)
log file parallel write	21.75 #1	20.56–22.96		+0.0σ	▼ 0.1%	21.82 #1	20.91 #1	22.01 #1	22.31 #1
db file scattered read	0.1833 #2	0–0.03664	+14.5σ	+14.5σ	▲ ×13.9immaterial	0.03038 #4	0.004133 #4	0.008159 #5	0.0102 #4
db file sequential read	0.1563 #3	0.1088–0.1325		+6.0σ	▲ 29.6%immaterial	0.1135 #2	0.1279 #2	0.1198 #2	0.1213 #2
log file sync	0.05677 #4	0.01299–0.06259		+1.5σ	▲ 50.2%	0.04308 #3	0.02402 #3	0.05221 #3	0.03184 #3
latch: shared pool	0	0–0.01102		−0.5σ	▼ 100.0%	0	0	0.008818 #4	0
library cache: mutex X	0	0–0.000276		−0.5σ	▼ 100.0%	0	0	0.000221 #6	0

Events — avg time per wait (ms)

Event	Current (ms)	Normal range	vs normal, in σ	z	Δ vs mean	−1h (ms)	−2h (ms)	−3h (ms)	−4h (ms)
log file parallel write	5.542	5.186–5.884		+0.0σ	▲ 0.1%	5.653	5.292	5.525	5.671
db file scattered read	0.1392	0–0.3955		+0.0σ	▲ 3.4%	0.3302	0.06458	0.07034	0.07336
db file sequential read	0.09468	0.1889–0.2949	−5.6σ	−5.6σ	▼ 60.9%improved	0.242	0.2217	0.2793	0.2247
log file sync	8.110	1.932–8.114		+2.0σ	▲ 61.5%	6.155	3.431	6.527	3.980
latch: shared pool	—	2.822–3.057	no current value	—	—σ≈0	—	—	2.939	—
library cache: mutex X	—	0.2122–0.2298	no current value	—	—σ≈0	—	—	0.221	—

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

By elapsed time

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (s)	−1h	−2h	−3h	−4h	SQL
apkz5my1bt69s	1553775339	3.081 #1	—	—	3.080 #1	3.091 #1	update chaos.locks set v=v+1 where id=2
7jdsnpg2pzzfd	1553775339	2.080 #2	—	—	2.079 #2	2.093 #2	update chaos.locks set v=v+1 where id=1
fhf8upax5cxsz	0	0.9339 #3	1.342 #1	0.9474 #1	1.761 #3	1.014 #3	BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class, :rep_id, :suc); END;
0w26sk6t6gq98	1388734953	0.7192 #4	1.127 #2	0.7563 #4	1.465 #4	0.798 #4	SELECT XMLTYPE(DBMS_REPORT.GET_REPORT_WITH_SUMMARY(:B1 )) FROM DUAL
0za9fv0j1vgkk	3205475971	0.5646 #5	0.8933 #3	0.5938 #5	1.169 #5	0.6303 #5	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…
9pd2ghtwmafzg	0	0.5166 #6	0.6949 #5	0.5198 #6	0.6727 #7	0.5285 #6	BEGIN dbms_drs.do_observe(:indoc, :outdoc); END;
35k8v3jjhv3k6	542043329	0.4687 #7	0.7637 #4	0.8524 #2	0.498 #9	0.4942 #7	WITH cdb_last_failed_jobs AS ( SELECT CON_ID, OWNER, JOB_NAME, MAX(ACTUAL_START_DATE) AS START_DATE FROM CDB_SCHEDULER_JOB_RUN_DETAILS WHERE STATUS = 'FAILED' GROUP BY CON_ID, OWNER, JOB_NAME ) , cdb_last_succeeded_jobs AS ( SELECT CON_ID, OWNER, JOB_NAME, MAX(ACTUAL_START_DATE) AS START_DATE FROM CDB_SCHEDULER_JOB_RUN_DETAILS WHERE STATUS = 'SUCCEEDED' GROUP BY CON_ID, OWNER, JOB_NAME ) , cdb_la…
22356bkgsdcnh	585200625	0.4048 #8	0.3859 #6	0.4507 #7	0.4943 #10	0.4166 #8	SELECT COUNT(*) FROM X$KSPPI A, X$KSPPCV2 B WHERE A.INDX + 1 = KSPFTCTXPN AND KSPPINM = '_deferred_log_dest_is_valid' AND UPPER(KSPFTCTXVL)='TRUE'
1j6tnz8fcm4c3	1200386806	0.2568 #9	—	—	—	—	delete /* QOSH:PURGE_OLD_STS //+ dynamic_sampling(4) */ from sys.wri$_optstat_histgrm_history where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0' and rownum <= :2
1fvsn5j51ugz3	0	0.2063 #10	—	0.2076 #10	—	—	begin dbms_rcvman.resetAll; end;
bxywuzvtp6wjg	—	—	—	0.7906 #3	—	—	call dbms_scheduler.auto_purge ( )
0737hwwanr1qy	—	—	—	—	0.9049 #6	—	with pdbview AS (select con_id, name from v$containers where con_id != 2) SELECT pdb.name, a.name "DB Name", e.property_value "Global Name", replace(b.banner, c.version, c.version_full) "DB Version", c.host_name "Host Name", c.instance_name "Instance Name" , to_char(c.startup_time,'YYYY-MM-DD HH24:MI:SS') "Instance Start Time", decode(c.logins,'RESTRICTED','YES','NO') "Restricted Mode", a.log_mo…
1pzw83n4gngjs	—	—	0.2919 #7	0.2132 #9	—	0.2202 #10	select json_object( 'collected_at' value to_char(sys_extract_utc(systimestamp), 'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"'), 'log_type' value 'oracle_metrics', 'event' value json_object('outcome' value 'success'), 'oracle' value json_object( 'metric' value json_object('type' value 'tablespace'), 'database' value json_object('name' value sys_context('USERENV', 'DB_UNIQUE_NAME')), 'tablesp…
cuhss44nxn0fu	—	—	—	—	0.6389 #8	—	SELECT /+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE SHELFLIFE=30) / "PROPERTY_NAME","PROPERTY_VALUE" FROM "SYS"."DATABASE_PROPERTIES" "K" WHERE "K"."PROPERTY_NAME"='GLOBAL_DB_NAME' AND 1=1
cz8wbmy7k5bxn	—	—	—	0.2767 #8	—	—	begin sys.dbms_aq_inv.internal_purge_queue_table(:1, :2, :3, :4, :5, :6, :7, :8 , FALSE);end;
7kub1nvw8wmq3	—	—	0.2678 #8	—	—	—	insert into wrh$_mvparameter (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, ordinal, value, isdefault, ismodified) select :dbid, sv.con_id, con_id_to_dbid(sv.con_id) con_dbid, :snap_id, :instance_number, sv.hash, sv.ordinal, substr(sv.value, 1, 512), sv.isdefault, sv.ismodified from v$system_parameter2 sv where exists (select 1 from v$system_parameter4 i where …
0pmbxw88n6jsz	—	—	—	—	—	0.3519 #9	UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, partition_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT snap_id + 1, nvl(ownername_kewrseg, owner), nvl(objname_kewrseg, object_name), nvl(subobjname_kewrseg, subobject_name), …
dvu40a9avazf8	—	—	0.2266 #9	—	—	—	select xmlagg( xmlelement("operation", xmlattributes(operation as "name", options as "options", id as "id", depth as "depth", position as "pos"), nvl2(object_na…
28bgqbzpa87xf	—	—	0.2231 #10	—	—	—	declare policy varchar2(512); alldest number := dbms_rcvman.FALSE#; rlgscn number; begin if (:alldest > 0) then alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.setRecoveryDestFile(TRUE); dbms_rcvman.getRedoLogDeletionPolicy(policy => policy); dbms_rcvman.setRedoLogDeletionPolic…

By CPU time

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (s)	−1h	−2h	−3h	−4h	SQL
fhf8upax5cxsz	0	0.8013 #1	1.157 #1	0.839 #1	1.604 #1	0.882 #1	BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class, :rep_id, :suc); END;
0w26sk6t6gq98	1388734953	0.7077 #2	1.039 #2	0.7421 #2	1.421 #2	0.7764 #2	SELECT XMLTYPE(DBMS_REPORT.GET_REPORT_WITH_SUMMARY(:B1 )) FROM DUAL
0za9fv0j1vgkk	3205475971	0.5573 #3	0.838 #3	0.5838 #3	1.137 #3	0.6187 #3	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…
9pd2ghtwmafzg	0	0.5166 #4	0.6448 #4	0.5191 #5	0.6317 #4	0.528 #4	BEGIN dbms_drs.do_observe(:indoc, :outdoc); END;
22356bkgsdcnh	585200625	0.3948 #5	0.3646 #5	0.4396 #6	0.4808 #5	0.4011 #5	SELECT COUNT(*) FROM X$KSPPI A, X$KSPPCV2 B WHERE A.INDX + 1 = KSPFTCTXPN AND KSPPINM = '_deferred_log_dest_is_valid' AND UPPER(KSPFTCTXVL)='TRUE'
1fvsn5j51ugz3	0	0.2014 #6	0.1839 #10	0.2024 #8	—	0.1605 #10	begin dbms_rcvman.resetAll; end;
28bgqbzpa87xf	0	0.1843 #7	0.2193 #8	0.1905 #9	—	0.1889 #7	declare policy varchar2(512); alldest number := dbms_rcvman.FALSE#; rlgscn number; begin if (:alldest > 0) then alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.setRecoveryDestFile(TRUE); dbms_rcvman.getRedoLogDeletionPolicy(policy => policy); dbms_rcvman.setRedoLogDeletionPolic…
7kub1nvw8wmq3	2243849280	0.1831 #8	0.2553 #6	0.1806 #10	0.2419 #9	0.1951 #6	insert into wrh$_mvparameter (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, ordinal, value, isdefault, ismodified) select :dbid, sv.con_id, con_id_to_dbid(sv.con_id) con_dbid, :snap_id, :instance_number, sv.hash, sv.ordinal, substr(sv.value, 1, 512), sv.isdefault, sv.ismodified from v$system_parameter2 sv where exists (select 1 from v$system_parameter4 i where …
1j6tnz8fcm4c3	1200386806	0.1808 #9	—	—	—	—	delete /* QOSH:PURGE_OLD_STS //+ dynamic_sampling(4) */ from sys.wri$_optstat_histgrm_history where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0' and rownum <= :2
1pzw83n4gngjs	3181894540	0.1651 #10	0.2448 #7	—	—	0.1748 #8	select json_object( 'collected_at' value to_char(sys_extract_utc(systimestamp), 'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"'), 'log_type' value 'oracle_metrics', 'event' value json_object('outcome' value 'success'), 'oracle' value json_object( 'metric' value json_object('type' value 'tablespace'), 'database' value json_object('name' value sys_context('USERENV', 'DB_UNIQUE_NAME')), 'tablesp…
bxywuzvtp6wjg	—	—	—	0.572 #4	—	—	call dbms_scheduler.auto_purge ( )
0737hwwanr1qy	—	—	—	—	0.3176 #6	—	with pdbview AS (select con_id, name from v$containers where con_id != 2) SELECT pdb.name, a.name "DB Name", e.property_value "Global Name", replace(b.banner, c.version, c.version_full) "DB Version", c.host_name "Host Name", c.instance_name "Instance Name" , to_char(c.startup_time,'YYYY-MM-DD HH24:MI:SS') "Instance Start Time", decode(c.logins,'RESTRICTED','YES','NO') "Restricted Mode", a.log_mo…
dvu40a9avazf8	—	—	0.2129 #9	—	0.3165 #7	0.1675 #9	select xmlagg( xmlelement("operation", xmlattributes(operation as "name", options as "options", id as "id", depth as "depth", position as "pos"), nvl2(object_na…
cz8wbmy7k5bxn	—	—	—	0.2222 #7	—	—	begin sys.dbms_aq_inv.internal_purge_queue_table(:1, :2, :3, :4, :5, :6, :7, :8 , FALSE);end;
f7b069b8zkhvu	—	—	—	—	0.2613 #8	—	SELECT to_number(value) FROM sys.v$parameter WHERE name = '_qa_lrg_type'
3rdvj2msrkpn0	—	—	—	—	0.2211 #10	—	select T.* from table(dbms_xplan.get_plan_rows(:tab_name, :stmt_id, :plan_id, :format, :fpreds, 1, null)) T

By buffer gets

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (gets)	−1h	−2h	−3h	−4h	SQL
dxh2b8padhfby	3652932668	10.03 k #1	9,800 #1	15.00 k #1	4,956 #5	14.83 k #1	insert into WRH$_SYSSTAT (dbid, per_pdb, con_dbid, snap_id, instance_number, stat_id, value) select /+ use_hash(v$sysstat) / :dbid, sysstat.con_id, con_id_to_dbid(sysstat.con_id) con_dbid, :snap_id, :instance_number, stat_id, value FROM v$sysstat sysstat WHERE (1 = 1) AND ( sysstat.con_id < 4099 )
1j6tnz8fcm4c3	1200386806	9,926 #2	—	—	—	—	delete /* QOSH:PURGE_OLD_STS //+ dynamic_sampling(4) */ from sys.wri$_optstat_histgrm_history where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0' and rownum <= :2
aak3mmhp5a8ft	0	8,575 #3	8,584 #2	8,663 #3	6,597 #1	8,622 #2	BEGIN sys.prvt_hdm.auto_execute( db_id => :bind_dbid, inst_id => :bind_inst, end_snap => :bind_snap, time_left_in_secs => :bind_time); END;
7h6kvx22p1mvc	1561607518	8,078 #4	4,039 #5	8,078 #4	4,039 #6	8,078 #3	SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, SUM(failed_count) AS failed_count , TO_CHAR(MIN(first_occur_time), 'yyyy-mm-dd hh24:mi:ss') AS first_occur_time, TO_CHAR(MAX(last_occur_time), 'yyyy-mm-dd hh24:mi:ss') AS last_occur_time, name FROM (SELECT COUNT(DBUSERNAME) AS failed_count, MIN(event_timestamp) AS first_occur_time, MAX(even…
f705bwx3q0ydq	3322223638	6,314 #5	6,313 #3	6,313 #5	5,764 #2	5,764 #5	select count(*) from dba_autotask_window_clients c, (select window_name, max(log_date) max_log_date from dba_scheduler_window_log where operation = 'OPEN' group by window_name) wo, (select window_name, max(log_date) max_log_date from dba_scheduler_window_log where operation = 'CLOSE' group by window_name) wc where c.window_name = wo.window_name and c.optimizer_stats = 'ENABLED' and wo.window_name …
fbjs6vqydm3xa	2419380041	6,009 #6	—	—	—	—	select s.ts#, s.file#, s.block#, so.object_id, s.spare1, s.type#, s.hwmincr from seg$ s, sys_objects so where bitand(s.spare1,131072) = 0 and s.ts# = so.ts_number and s.file# = so.header_file and s.block# = so.header_block order by s.file# asc
35k8v3jjhv3k6	542043329	5,676 #7	5,848 #4	5,680 #6	5,682 #3	5,809 #4	WITH cdb_last_failed_jobs AS ( SELECT CON_ID, OWNER, JOB_NAME, MAX(ACTUAL_START_DATE) AS START_DATE FROM CDB_SCHEDULER_JOB_RUN_DETAILS WHERE STATUS = 'FAILED' GROUP BY CON_ID, OWNER, JOB_NAME ) , cdb_last_succeeded_jobs AS ( SELECT CON_ID, OWNER, JOB_NAME, MAX(ACTUAL_START_DATE) AS START_DATE FROM CDB_SCHEDULER_JOB_RUN_DETAILS WHERE STATUS = 'SUCCEEDED' GROUP BY CON_ID, OWNER, JOB_NAME ) , cdb_la…
b13g21mgg8y98	2612542848	3,666 #8	3,638 #6	3,674 #8	3,646 #8	3,657 #6	insert /* KSXM:TAKE_SNPSHOT */ into sys.optstat_snapshot$ (obj#, inserts, updates, deletes, timestamp, flags) (select m.obj#, m.inserts, m.updates, m.deletes, systimestamp, dbms_stats_advisor.compute_volatile_flag( m.obj#, m.flags, :flags, m.inserts, m.updates, m.deletes, s.inserts, s.updates, s.deletes, null, nvl(to_number(p.valchar), :global_stale_pcnt), s.gather) flags from sys.mon_mo…
bg8azzm6ms51b	473814785	3,599 #9	3,599 #7	3,660 #9	—	3,599 #7	select json_object( 'collected_at' value to_char(sys_extract_utc(systimestamp), 'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"'), 'log_type' value 'oracle_metrics', 'event' value json_object('outcome' value 'success'), 'log' value json_object('level' value 'INFO'), 'oracle' value json_object( 'metric' value json_object('type' value 'health'), 'database' value json_object( 'name' value d.d…
3dbzmtf9ahvzt	3238164414	2,997 #10	3,050 #8	—	2,998 #10	3,039 #8	merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn or m.obj# in (select ob…
bxywuzvtp6wjg	—	—	—	12.80 k #2	—	—	call dbms_scheduler.auto_purge ( )
2sahsd9rjzy0q	—	—	—	—	4,973 #4	—	select client_name, status from DBA_AUTOTASK_CLIENT
5dqz0hqtp9fru	—	—	—	3,828 #7	3,828 #7	—	select /+ connect_by_filtering index(sysauth$ i_sysauth1) / privilege#, bitand(nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
fhf8upax5cxsz	—	—	—	—	3,422 #9	—	BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class, :rep_id, :suc); END;
8y6q8umcqybwr	—	—	2,813 #10	—	—	2,884 #9	insert into wrh$_parameter (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, value, isdefault, ismodified) select :dbid, sp.con_id, con_id_to_dbid(sp.con_id) con_dbid, :snap_id, :instance_number, hash, substr(value, 1, 512), isdefault, ismodified from v$system_parameter sp
7dhg9ys7r45hx	—	—	2,829 #9	—	—	—	SELECT /+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE SHELFLIFE=30) / "DBUSERNAME","EVENT_TIMESTAMP","ACTION_NAME","RETURN_CODE" FROM "AUDSYS"."UNIFIED_AUDIT_TRAIL" "K" WHERE "K"."ACTION_NAME"='LOGON' AND "K"."RETURN_CODE"<>0 AND SYS_EXTRACT_UTC("K"."EVENT_TIMESTAMP")>=SYS_EXTRACT_UTC(CURRENT_TIMESTAMP(6)-TO_DSINTERVAL('0 0:30:00'))
cz8wbmy7k5bxn	—	—	—	3,637 #10	—	—	begin sys.dbms_aq_inv.internal_purge_queue_table(:1, :2, :3, :4, :5, :6, :7, :8 , FALSE);end;
2jzz7j5bkc3xj	—	—	—	—	—	2,679 #10	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…

By physical reads

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (reads)	−1h	−2h	−3h	−4h	SQL
1j6tnz8fcm4c3	1200386806	9,686 #1	—	—	—	—	delete /* QOSH:PURGE_OLD_STS //+ dynamic_sampling(4) */ from sys.wri$_optstat_histgrm_history where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0' and rownum <= :2
9ux4hcnsp1q8z	3205310162	1,845 #2	—	—	—	—	select /* QOSH:ANLYZ_TIME */ from_tz( cast ((max(analyzetime) - 1) as timestamp), to_char(systimestamp, 'TZH:TZM')) from sys.tab$ where analyzetime is not null
35k8v3jjhv3k6	542043329	1,548 #3	1,550 #1	1,562 #1	1,562 #1	1,557 #1	WITH cdb_last_failed_jobs AS ( SELECT CON_ID, OWNER, JOB_NAME, MAX(ACTUAL_START_DATE) AS START_DATE FROM CDB_SCHEDULER_JOB_RUN_DETAILS WHERE STATUS = 'FAILED' GROUP BY CON_ID, OWNER, JOB_NAME ) , cdb_last_succeeded_jobs AS ( SELECT CON_ID, OWNER, JOB_NAME, MAX(ACTUAL_START_DATE) AS START_DATE FROM CDB_SCHEDULER_JOB_RUN_DETAILS WHERE STATUS = 'SUCCEEDED' GROUP BY CON_ID, OWNER, JOB_NAME ) , cdb_la…
3mkdy3ns38nxf	1225400184	1,484 #4	—	—	—	—	delete /* QOSH:PURGE_OLD_STS //+ dynamic_sampling(4) */ from sys.wri$_optstat_histhead_history where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0' and rownum <= :2
fbjs6vqydm3xa	2419380041	742.0 #5	—	—	—	—	select s.ts#, s.file#, s.block#, so.object_id, s.spare1, s.type#, s.hwmincr from seg$ s, sys_objects so where bitand(s.spare1,131072) = 0 and s.ts# = so.ts_number and s.file# = so.header_file and s.block# = so.header_block order by s.file# asc
b13g21mgg8y98	2612542848	433.0 #6	3.000 #9	—	—	27.00 #6	insert /* KSXM:TAKE_SNPSHOT */ into sys.optstat_snapshot$ (obj#, inserts, updates, deletes, timestamp, flags) (select m.obj#, m.inserts, m.updates, m.deletes, systimestamp, dbms_stats_advisor.compute_volatile_flag( m.obj#, m.flags, :flags, m.inserts, m.updates, m.deletes, s.inserts, s.updates, s.deletes, null, nvl(to_number(p.valchar), :global_stale_pcnt), s.gather) flags from sys.mon_mo…
dxh2b8padhfby	3652932668	156.0 #7	—	286.0 #3	102.0 #4	260.0 #2	insert into WRH$_SYSSTAT (dbid, per_pdb, con_dbid, snap_id, instance_number, stat_id, value) select /+ use_hash(v$sysstat) / :dbid, sysstat.con_id, con_id_to_dbid(sysstat.con_id) con_dbid, :snap_id, :instance_number, stat_id, value FROM v$sysstat sysstat WHERE (1 = 1) AND ( sysstat.con_id < 4099 )
2jzz7j5bkc3xj	4139502717	85.00 #8	106.0 #2	149.0 #5	143.0 #3	231.0 #3	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…
8y6q8umcqybwr	2844803677	47.00 #9	65.00 #3	68.00 #9	—	68.00 #4	insert into wrh$_parameter (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, value, isdefault, ismodified) select :dbid, sp.con_id, con_id_to_dbid(sp.con_id) con_dbid, :snap_id, :instance_number, hash, substr(value, 1, 512), isdefault, ismodified from v$system_parameter sp
f7xnvp44nukp7	0	43.00 #10	42.00 #4	—	53.00 #6	—	insert into wrm$_snapshot_details (snap_id,dbid,instance_number,table_id,begin_time,end_time,step_id) values (:snap_id,:dbid,:instance_number,:bind1,:bind2,:bind3,:step_id)
6vx32zvgf4adx	—	—	—	—	1,262 #2	—	select 'INTER_MEDIA' as name, decode((select username from dba_users where username='ORDSYS'), 'ORDSYS', 'TRUE', 'FALSE') as selected from dual union select 'SPATIAL' as name, decode((select username from dba_users where username='MDSYS'), 'MDSYS', 'TRUE', 'FALSE') as selected from dual union select 'ORACLE_TEXT' as name, decode((select username from dba_users where username='CTXSYS'), 'CTXSYS', …
bxywuzvtp6wjg	—	—	—	611.0 #2	—	—	call dbms_scheduler.auto_purge ( )
cz8wbmy7k5bxn	—	—	—	184.0 #4	—	—	begin sys.dbms_aq_inv.internal_purge_queue_table(:1, :2, :3, :4, :5, :6, :7, :8 , FALSE);end;
6frynf9v1m655	—	—	—	—	61.00 #5	—	call dbms_part.cleanup_gidx_job ( :0,:1 )
aak3mmhp5a8ft	—	—	12.00 #8	—	—	39.00 #5	BEGIN sys.prvt_hdm.auto_execute( db_id => :bind_dbid, inst_id => :bind_inst, end_snap => :bind_snap, time_left_in_secs => :bind_time); END;
f3ww8rgva3hrs	—	—	22.00 #5	—	—	—	update /* KSXM:FLUSH COL */ sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1), like_preds = like_preds + deco…
03guhbfpak0w7	—	—	—	141.0 #6	—	—	select /+ index(idl_ub1$ i_idl_ub11) / piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
drgmqpr5n5ux4	—	—	17.00 #6	—	48.00 #7	—	insert into wrh$_latch (dbid, per_pdb, con_dbid, snap_id, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :dbid, ltch.con_id, con_id_to_dbid(ltch.con_id) con_dbid, :snap_id, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, s…
6xvzxzck50czk	—	—	—	138.0 #7	—	—	select cons.consumer_name from sys.dba_queue_subscribers cons left join sys.user$ us on replace(cons.consumer_name,'SCHED$_AGT2$_')=us.user# where cons.queue_name='SCHEDULER$_EVENT_QUEUE' and cons.consumer_name like 'SCHED$_AGT2$_%' and us.user# is null
f8m7qnkpcg8py	—	—	—	—	—	24.00 #7	insert into WRH$_SERVICE_STAT (dbid, per_pdb, con_dbid, snap_id, instance_number, service_name_hash, stat_id, value) select /+ opt_param('_optimizer_mjc_enabled','false') leading(asvc s m) / :dbid, asvc.con_id, con_id_to_dbid(asvc.con_id) con_dbid, :snap_id, :instance_number, stat.service_name_hash, stat.stat_id, stat.value FROM v$active_services asvc, v$service_stats …
3dbzmtf9ahvzt	—	—	16.00 #7	—	—	—	merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn or m.obj# in (select ob…
3un99a0zwp4vd	—	—	—	72.00 #8	34.00 #9	—	select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,flags,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
0737hwwanr1qy	—	—	—	—	35.00 #8	—	with pdbview AS (select con_id, name from v$containers where con_id != 2) SELECT pdb.name, a.name "DB Name", e.property_value "Global Name", replace(b.banner, c.version, c.version_full) "DB Version", c.host_name "Host Name", c.instance_name "Instance Name" , to_char(c.startup_time,'YYYY-MM-DD HH24:MI:SS') "Instance Start Time", decode(c.logins,'RESTRICTED','YES','NO') "Restricted Mode", a.log_mo…
7kub1nvw8wmq3	—	—	—	—	—	22.00 #8	insert into wrh$_mvparameter (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, ordinal, value, isdefault, ismodified) select :dbid, sv.con_id, con_id_to_dbid(sv.con_id) con_dbid, :snap_id, :instance_number, sv.hash, sv.ordinal, substr(sv.value, 1, 512), sv.isdefault, sv.ismodified from v$system_parameter2 sv where exists (select 1 from v$system_parameter4 i where …
fhf8upax5cxsz	—	—	—	—	—	9.000 #9	BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class, :rep_id, :suc); END;
7tnkfntf8cqvp	—	—	—	65.00 #10	—	—	SELECT 1 from "SYS"."AQ$SCHEDULER$_EVENT_QTAB" qtview WHERE (queue = 'AQ$_SCHEDULER$_EVENT_QTAB_E' ) AND rownum < 2
8swypbbr0m372	—	—	—	—	27.00 #10	—	select order#,columns,types from access$ where d_obj#=:1
0pmbxw88n6jsz	—	—	—	—	—	8.000 #10	UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, partition_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT snap_id + 1, nvl(ownername_kewrseg, owner), nvl(objname_kewrseg, object_name), nvl(subobjname_kewrseg, subobject_name), …
2jg5m3br4mtw0	—	—	2.000 #10	—	—	—	insert into WRH$_MUTEX_SLEEP (dbid, per_pdb, con_dbid, snap_id, instance_number, mutex_type, location, sleeps, wait_time) select :dbid, mslp.con_id, con_id_to_dbid(mslp.con_id) con_dbid, :snap_id, :instance_number, mutex_type, location, sleeps, wait_time FROM v$mutex_sleep mslp WHERE (1 = 1) AND ( mslp.con_id < 4099 ) and sleeps > 0

By executions

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (exec)	−1h	−2h	−3h	−4h	SQL
9pd2ghtwmafzg	0	1,201 #1	1,182 #1	1,200 #1	1,201 #1	1,201 #1	BEGIN dbms_drs.do_observe(:indoc, :outdoc); END;
6xvp6nxs4a9n4	3523134145	873.0 #2	874.0 #2	885.0 #3	886.0 #3	874.0 #2	select nvl(sum(space),0) from recyclebin$ where ts# = :1
csnp95dz2r8ss	2567466223	873.0 #3	874.0 #3	885.0 #4	886.0 #4	874.0 #3	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
5dqz0hqtp9fru	1227530427	623.0 #4	389.0 #7	933.0 #2	933.0 #2	623.0 #4	select /+ connect_by_filtering index(sysauth$ i_sysauth1) / privilege#, bitand(nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
1rpgk59t8pvs6	0	564.0 #5	—	574.0 #5	552.0 #5	—	begin dbms_output.get_line(:line, :status); end;
3dbzmtf9ahvzt	3238164414	498.0 #6	507.0 #4	501.0 #6	499.0 #6	505.0 #5	merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn or m.obj# in (select ob…
f7xnvp44nukp7	0	420.0 #7	420.0 #5	420.0 #7	420.0 #8	420.0 #6	insert into wrm$_snapshot_details (snap_id,dbid,instance_number,table_id,begin_time,end_time,step_id) values (:snap_id,:dbid,:instance_number,:bind1,:bind2,:bind3,:step_id)
a0qc12302fzfk	0	406.0 #8	399.0 #6	408.0 #8	432.0 #7	406.0 #7	begin dbms_application_info.set_module(:1 , :2 ); end;
09tdt28zbb322	0	374.0 #9	—	373.0 #9	362.0 #9	—	declare agedFileRec dbms_rcvman.agedFileRec_t; first boolean := FALSE; alldest number := dbms_rcvman.FALSE#; policy varchar2(512); begin if (:first > 0) then first := TRUE; if (:alldest > 0) then alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.setR…
c398axtp4r62g	4161125554	240.0 #10	236.0 #10	241.0 #10	—	240.0 #8	SELECT nonprimarydb.name as pdbName ,MAX(CASE WHEN takecdbstatus.open_mode LIKE 'MOUNT%' THEN 1 WHEN takecdbstatus.open_mode LIKE 'READ%' THEN 1 ELSE 0 END) as state_num FROM gv$containers nonprimarydb ,gv$containers takecdbstatus WHERE nonprimarydb.name <> 'PDB$SEED' AND takecdbstatus.name = 'CDB$ROOT' AND ((sys_context('USERENV','CURRENT_USER') like 'SYS%' AND takecdbstatus.open_mode LIKE 'MOU…
f3ww8rgva3hrs	—	—	287.0 #8	—	305.0 #10	—	update /* KSXM:FLUSH COL */ sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1), like_preds = like_preds + deco…
gj5r9jj2xad7f	—	—	237.0 #9	—	—	240.0 #9	SELECT 1, status, '',archiver, database_status, active_state FROM v$instance
gjaap3w3qbf8c	—	—	—	—	—	240.0 #10	select count(*) from ilmobj$ where rownum = 1

By per-exec regression

Break down by:

Detail table

SQL ID	Plan hash (Current)	Current (s/exec)	−1h	−2h	−3h	−4h	SQL
dsfnfxkbbvxha	0	0.01212 #1	0.009159	0.00965	0.005849	0.01125	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 )
f3ww8rgva3hrs	477378112	0.000053 #2	0.000044	—	0.00004	0.000048	update /* KSXM:FLUSH COL */ sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1), like_preds = like_preds + deco…
3dbzmtf9ahvzt	3238164414	0.000078 #3	0.000085	0.000068	0.000063	0.000063	merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn or m.obj# in (select ob…
gjaap3w3qbf8c	4233836756	0.00004 #4	0.00004	0.000027	0.000046	0.000026	select count(*) from ilmobj$ where rownum = 1
fs4p95w7yg25b	2313771059	0.000014 #5	0.000012	0.00001	0.000013	0.00001	select pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# and tp.obj# = :oid

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

Per-SQL detail

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

SQL ID

Ranked in

Schema

Plans

Executions

Snapshots

First seen

Text

apkz5my1bt69s ASH MON

SYS

2026-09-09 07:45

update chaos.locks set v=v+1 where id=2

Parsing schema: SYS
Module: sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 5636665338160656674
SQL profile: —
Text length: 39 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1553775339	2026-09-09 07:45	2026-09-23 23:15	29	56	1.646	3.536

update chaos.locks set v=v+1 where id=2

7jdsnpg2pzzfd ASH MON

SYS

2026-09-09 07:45

update chaos.locks set v=v+1 where id=1

Parsing schema: SYS
Module: sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 5636665338160656674
SQL profile: —
Text length: 39 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1553775339	2026-09-09 07:45	2026-09-27 12:00	30	57	1.113	16.23

update chaos.locks set v=v+1 where id=1

fhf8upax5cxsz ASH MON

ECGR

SYS

9,325

2,208

2026-08-23 11:38

BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class, …

0w26sk6t6gq98 ASH MON

SYS

9,149

2,195

2026-08-23 11:38

SELECT XMLTYPE(DBMS_REPORT.GET_REPORT_WITH_SUMMARY(:B1 )) FROM DUAL

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1388734953	2026-08-23 11:38	2026-09-27 16:45	2,195	9,149	0.09254	324.5

SELECT XMLTYPE(DBMS_REPORT.GET_REPORT_WITH_SUMMARY(:B1 )) FROM DUAL

0za9fv0j1vgkk ASH MON

SYS

9,293

2,230

2026-08-23 11:38

WITH MONITOR_DATA AS (SELECT * FROM TABLE(GV$(CURSOR( SELECT USERENV('instance') AS INST_I…

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3205475971	2026-08-23 11:38	2026-09-27 16:45	2,230	9,293	0.0763	167.8

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)

9pd2ghtwmafzg ASH MON

ECX

SYS

662,502

2,232

2026-08-23 11:49

BEGIN dbms_drs.do_observe(:indoc, :outdoc); END;

35k8v3jjhv3k6 ASH MON

EGR

SYS

1,132

1,123

2026-08-23 11:38

WITH cdb_last_failed_jobs AS ( SELECT CON_ID, OWNER, JOB_NAME, MAX(ACTUAL_START_DATE) AS …

Parsing schema: SYS
Module: emagent_SQL_oracle_database
Action: cdbjob_status
Optimizer mode: ALL_ROWS
Force-match sig: 13562461939718721680
SQL profile: —
Text length: 3,039 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
542043329	2026-08-23 11:38	2026-09-27 16:45	1,123	1,132	0.3516	2,073

WITH cdb_last_failed_jobs AS
(
SELECT CON_ID,
OWNER,
JOB_NAME,
MAX(ACTUAL_START_DATE) AS START_DATE
FROM CDB_SCHEDULER_JOB_RUN_DETAILS
WHERE STATUS = 'FAILED'
GROUP BY CON_ID, OWNER, JOB_NAME
)
,
cdb_last_succeeded_jobs AS
(
SELECT CON_ID,
OWNER,
JOB_NAME,
MAX(ACTUAL_START_DATE) AS START_DATE
FROM CDB_SCHEDULER_JOB_RUN_DETAILS
WHERE STATUS = 'SUCCEEDED'
GROUP BY CON_ID, OWNER, JOB_NAME
)
,
cdb_last_failed_jobs_with_earlier_success AS
(
SELECT cdb_last_failed_jobs.CON_ID,
cdb_last_failed_jobs.OWNER,
cdb_last_failed_jobs.JOB_NAME,
cdb_last_failed_jobs.START_DATE
FROM cdb_last_failed_jobs,
cdb_last_succeeded_jobs
WHERE cdb_last_failed_jobs.CON_ID = cdb_last_succeeded_jobs.CON_ID
AND cdb_last_failed_jobs.OWNER = cdb_last_succeeded_jobs.OWNER
AND cdb_last_failed_jobs.JOB_NAME = cdb_last_succeeded_jobs.JOB_NAME
AND cdb_last_failed_jobs.START_DATE < cdb_last_succeeded_jobs.START_DATE
)
,
cdb_last_failed_jobs_without_earlier_success AS
(
SELECT UNIQUE cdb_last_failed_jobs.CON_ID,
cdb_last_failed_jobs.OWNER,
cdb_last_failed_jobs.JOB_NAME,
cdb_last_failed_jobs.START_DATE
FROM cdb_last_failed_jobs, cdb_last_succeeded_jobs
WHERE (cdb_last_failed_jobs.CON_ID != cdb_last_succeeded_jobs.CON_ID)
OR (cdb_last_failed_jobs.OWNER != cdb_last_succeeded_jobs.OWNER)
OR (cdb_last_failed_jobs.JOB_NAME != cdb_last_succeeded_jobs.JOB_NAME)
)
,
cdb_latest_run_failed_jobs AS
(
SELECT CON_ID,
OWNER,
JOB_NAME,
START_DATE
FROM cdb_last_failed_jobs_without_earlier_success
UNION
SELECT CON_ID,
OWNER,
JOB_NAME,
START_DATE
FROM cdb_last_failed_jobs_with_earlier_success
),
cdb_final_latest_run_failed_jobs_set AS
(
SELECT CON_ID,
OWNER,
JOB_NAME,
START_DATE
FROM cdb_latest_run_failed_jobs
WHERE JOB_NAME NOT IN (SELECT JOB_NAME FROM CDB_SCHEDULER_JOBS WHERE STATE IN ('BROKEN', 'DISABLED'))
)
,
cdb_failed_count_job_set AS (
SELECT CON_ID, SUM(sub_fail_count) AS failed_count
FROM (
SELECT CON_ID, count(1) AS sub_fail_count
FROM cdb_final_latest_run_failed_jobs_set
GROUP BY CON_ID

UNION ALL

SELECT CON_ID, count(1) AS sub_fail_count
FROM CDB_JOBS WHERE (broken != 'Y' AND NVL(failures,0) > 0)
GROUP BY CON_ID
)
GROUP BY CON_ID
)
,
cdb_broken_count_job_set AS (
SELECT CON_ID, SUM(sub_broken_count) AS broken_count
FROM (
SELECT CON_ID, count(1) AS sub_broken_count
FROM CDB_SCHEDULER_JOBS
WHERE STATE = 'BROKEN'
GROUP BY CON_ID
UNION ALL
SELECT CON_ID, count(1) AS sub_broken_count
FROM CDB_JOBS
WHERE BROKEN = 'Y'
GROUP BY CON_ID
)
GROUP BY CON_ID
)
,
cdb_final_count_details AS (
SELECT F.CON_ID AS CON_ID,
NVL(F.failed_count,0) AS FAILED,
NVL(B.broken_count,0) AS BROKEN
FROM cdb_failed_count_job_set F LEFT JOIN cdb_broken_count_job_set B
ON F.CON_ID = B.CON_ID
UNION
SELECT B.CON_ID,
NVL(F.failed_count,0) AS FAILED,
NVL(B.broken_count,0) AS BROKEN
FROM cdb_broken_count_job_set B LEFT JOIN cdb_failed_count_job_set F
ON B.CON_ID = F.CON_ID
)
SELECT c.name AS pdb_name,
cdb_final_count_details.broken,
cdb_final_count_details.failed
FROM cdb_final_count_details, v$containers c
WHERE cdb_final_count_details.con_id = TO_NUMBER(c.con_id)

22356bkgsdcnh ASH MON

SYS

6,057

2,179

2026-08-23 11:38

SELECT COUNT(*) FROM X$KSPPI A, X$KSPPCV2 B WHERE A.INDX + 1 = KSPFTCTXPN AND KSPPINM = '_…

Parsing schema: SYS
Module: emagent_SQL_oracle_database
Action: ha_backup_sbt
Optimizer mode: ALL_ROWS
Force-match sig: 4105016950430450626
SQL profile: —
Text length: 146 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
585200625	2026-08-23 11:38	2026-09-27 16:45	2,179	6,057	0.04568	0.05894

SELECT COUNT(*) FROM X$KSPPI A, X$KSPPCV2 B WHERE A.INDX + 1 = KSPFTCTXPN AND KSPPINM = '_deferred_log_dest_is_valid' AND UPPER(KSPFTCTXVL)='TRUE'

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1200386806	2026-08-23 16:46	2026-09-27 13:00	183	205	0.2908	13.72 k

delete /* QOSH:PURGE_OLD_STS *//*+ dynamic_sampling(4) */  from sys.wri$_optstat_histgrm_history      where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0'   and rownum <=  :2

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3246118364	2026-08-23 11:38	2026-09-27 16:00	524	19,712	0.001212	14.70
2334475966	2026-08-26 19:34	2026-08-26 19:44	1	164	0.009374	15.83

select /*+ index(idl_ub1$ i_idl_ub11) */ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

Parsing schema: SYS
Module: emagent_SQL_oracle_database
Action: cdb_dbNInstanceInfo
Optimizer mode: ALL_ROWS
Force-match sig: 15305793011113631743
SQL profile: —
Text length: 2,604 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
576180558	2026-08-24 00:15	2026-09-26 03:45	27	27	0.4936	1,131

with pdbview AS
(select con_id, name from v$containers where con_id != 2)
SELECT  pdb.name,
a.name "DB Name",
e.property_value "Global Name",
replace(b.banner, c.version, c.version_full) "DB Version",
c.host_name "Host Name",
c.instance_name "Instance Name" ,
to_char(c.startup_time,'YYYY-MM-DD HH24:MI:SS') "Instance Start Time",
decode(c.logins,'RESTRICTED','YES','NO') "Restricted Mode",
a.log_mode  "Archive Log Mode" ,
case when pdb.con_id=0
then
decode(a.open_mode,'READ ONLY','YES','NO')
else
decode(vpb.OPEN_MODE,'READ ONLY','YES','NO')
end
"Read Only Mode",
nlsp1.value,
nlsp2.value,
p.property_value,
to_char(a.created,'YYYY-MM-DD HH24:MI:SS') created,
substr(banner,instr(banner,'Oracle Database '),19) release,
nvl(trim(substr(banner,instr(banner,'Oracle Database ')+19,instr(banner,' Release') - instr(banner,'Oracle Database  ') - 19)),decode(instr(banner,'Personal'),0,'','Personal')) edition,
c.version_full dbversion,
DECODE(addr.word_len, 64, '1', '0')  is64bit,
substr(substr(banner, instr(banner, '-') + 2),
instr(substr(banner, instr(banner, '-') + 2),' ')+1)
rel_status,
a.supplemental_log_data_min  as sup_log_data_min,
case when  (select count(*) from cdb_users u where u.username ='DVSYS' and u.user_id = 1279990 and u.con_id = pdb.con_id)  > 0
then
case when (select value from v$option o where o.parameter ='Oracle Database Vault' and (o.con_id = pdb.con_id or o.con_id = 0)) ='TRUE'
then
1 -- Enabled
else
0 --Disabled
end
when (select count(*) from cdb_users u where u.username ='DVSYS' and u.user_id = 1279990 and u.con_id = pdb.con_id) = 0
then
case when (select value from v$option o where parameter ='Oracle Database Vault'  and (o.con_id = pdb.con_id or o.con_id = 0)) = 'TRUE'
then
-1 -- Not Configured
else
-2 -- Not Installed
end
end
dv_status_code
FROM    v$database a,
v$version b,
v$instance c,
CDB_PROPERTIES e,
v$nls_parameters nlsp1,
v$nls_parameters nlsp2,
CDB_PROPERTIES p,
(select length(addr)*4 word_len from v$process where rownum=1) addr,
pdbview pdb,
V$PDBS vpb
WHERE   b.banner LIKE '%Oracle%'
AND   nlsp1.parameter = 'NLS_CHARACTERSET'
AND   nlsp2.parameter = 'NLS_NCHAR_CHARACTERSET'
AND   e.property_name = 'GLOBAL_DB_NAME'
AND   p.property_name = 'DEFAULT_TEMP_TABLESPACE'
AND   (a.con_id = pdb.con_id OR a.con_id = 0)
AND   (b.con_id = pdb.con_id OR b.con_id = 0)
AND   (c.con_id = pdb.con_id OR c.con_id = 0)
AND   (nlsp1.con_id = pdb.con_id OR nlsp1.con_id = 0 OR nlsp1.con_id = 1)
AND   (nlsp2.con_id = pdb.con_id OR nlsp2.con_id = 0 OR nlsp2.con_id = 1)
AND   e.con_id = pdb.con_id
AND   p.con_id = pdb.con_id
AND   vpb.con_id(+) = pdb.con_id

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: CHOOSE
Force-match sig: 7169017389194603904
SQL profile: —
Text length: 2,772 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
815229885	2026-08-23 21:30	2026-09-27 16:00	215	645	0.009733	283.8

  UPDATE  wrh$_seg_stat_obj  ob      SET (snap_id, owner, object_name, subobject_name, tablespace_name,         object_type, partition_type, index_type, base_obj#, base_object_name,           base_object_owner) =       (SELECT snap_id + 1,               nvl(ownername_kewrseg, owner),               nvl(objname_kewrseg, object_name),               nvl(subobjname_kewrseg, subobject_name),               nvl(tsname_kewrseg, tablespace_name),               decode(objtype_kewrseg, 0, object_type,               sys.dbms_swrf_internal.awr_decode_object_type(objtype_kewrseg, 18)),              decode(ptype_kewrseg, 0, partition_type,                      decode(ptype_kewrseg, 0, 'NONE', 1, 'RANGE', 2, 'HASH',                           3, 'SYSTEM', 4, 'LIST',  NULL, 'NONE', 'UNKNOWN')),               decode(indtype_kewrseg, 0, index_type,                   decode(indtype_kewrseg,                       1, 'NORMAL'||                          decode(bitand(iprop_kewrseg, 4), 0, '', 4, '/REV'),                       2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP',                       5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI',                       8, 'LOB', 9, 'DOMAIN')),               coalesce(nullif(bobjn_kewrseg,0), so.base_obj#),               case bobjname_kewrseg                 when NULL then so.base_object_name                 else case length(bobjname_kewrseg)                        when 0 then so.base_object_name                        else bobjname_kewrseg                      end                end,               case bowname_kewrseg                 when NULL then so.base_object_owner                 else case length(bowname_kewrseg)                        when 0 then so.base_object_owner                        else bowname_kewrseg                      end                end               FROM  wrh$_seg_stat_obj                      so JOIN  (select * from x$kewrtsegstat  where con_id = :con_id_01 or (   (:con_id_02 = 1        and con_id = 0)  or (:con_id_03 = 0        and con_id = 1))  )  io ON               (dbid = :dbid and con_dbid = con_dbid_kewrseg                and ts# = tsn_kewrseg and obj# = objn_kewrseg                and dataobj# = objd_kewrseg)          WHERE ob.dbid = so.dbid            AND ob.con_dbid = so.con_dbid            AND ob.ts#  = so.ts#            AND ob.obj# = so.obj#            AND ob.dataobj# = so.dataobj#)    WHERE dbid = :dbid      AND object_name NOT LIKE '%MISSING%'      AND object_name NOT LIKE '%TRANSIENT%'      AND (ts#, obj#, dataobj#, con_dbid) in           (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg, con_dbid_kewrseg              FROM  (select * from x$kewrtsegstat  where con_id = :con_id_04 or (   (:con_id_05 = 1        and con_id = 0)  or (:con_id_06 = 0        and con_id = 1))  ) )

Parsing schema: SYS
Module: sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 935332091860047417
SQL profile: —
Text length: 648 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3181894540	2026-08-29 11:30	2026-09-27 16:45	1,569	23,341	0.004831	27.27

select json_object(
  'collected_at' value to_char(sys_extract_utc(systimestamp), 'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"'),
  'log_type' value 'oracle_metrics',
  'event' value json_object('outcome' value 'success'),
  'oracle' value json_object(
    'metric' value json_object('type' value 'tablespace'),
    'database' value json_object('name' value sys_context('USERENV', 'DB_UNIQUE_NAME')),
    'tablespace' value json_object(
      'name' value tablespace_name,
      'used_pct' value round(used_percent, 2),
      'used_blocks' value used_space,
      'total_blocks' value tablespace_size
    )
  ) returning clob
) from dba_tablespace_usage_metrics

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3915824756	2026-08-27 20:31	2026-09-20 07:45	18	18	0.01372	68.61

insert into  WRH$_MUTEX_SLEEP  (dbid, per_pdb, con_dbid, snap_id, instance_number,     mutex_type, location, sleeps, wait_time) select  :dbid,  mslp.con_id, con_id_to_dbid(mslp.con_id)  con_dbid,  :snap_id, :instance_number,     mutex_type, location, sleeps, wait_time   FROM v$mutex_sleep    mslp  WHERE  (1 = 1)  AND ( mslp.con_id < 4099  )  and    sleeps > 0

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
4139502717	2026-08-23 21:30	2026-09-27 16:45	605	605	0.06736	1,108

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

Parsing schema: SYS
Module: emagent_SQL_oracle_database
Action: db_autotask_client
Optimizer mode: ALL_ROWS
Force-match sig: 16105372920694538533
SQL profile: —
Text length: 54 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3172885606	2026-08-24 00:15	2026-09-26 03:45	27	27	0.1521	3,524

select client_name, status from DBA_AUTOTASK_CLIENT

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: CHOOSE
Force-match sig: 7187657109694262111
SQL profile: —
Text length: 2,323 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3238164414	2026-08-23 16:56	2026-09-27 16:45	2,354	294,561	0.000097	6.078

merge /* KSXM:OPTIM_DML_INF */  into sys.mon_mods_all$ m                   using dual                                                                 on (m.obj# = :objn and                                                         (:pobjn = 0 or                                                              m.obj# = :pobjn or                                                         m.obj# in (select obj#                                                                from tabpart$                                                              where bo# = :pobjn and obj# = :objn                                        union all                                                                  select obj#                                                                from tabcompart$                                                           where bo# = :pobjn and obj# = :objn                                        union all                                                                  select tsp.obj#                                                            from tabsubpart$ tsp, tabcompart$ tcp                                      where tsp.pobj# = tcp.obj#                                                   and (tcp.bo# = :pobjn or tcp.obj# = :pobjn)                                and tsp.obj# = :objn)))                                  when matched then                                                            update                                                                     set inserts = decode(:reset, 1, 0, inserts) + :ins,                            updates = decode(:reset, 1, 0, updates) + :upd,                            deletes = decode(:reset, 1, 0, deletes) + :del,                            flags =  decode(:reset, 1, 0, flags - bitand(flags, :flag)) + :flag,       drop_segments = decode(:reset, 1, 0, drop_segments) + :dropseg,            timestamp = :time                                                    when NOT matched then                                                        insert (obj#, inserts, updates, deletes,                                           timestamp, flags, drop_segments)                                   values (:objn, :ins, :upd, :del, :time, :flag, :dropseg)                   where :ins != 0 or :upd != 0 or :del != 0 or :flag != 0 or :dropseg !=0

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1225400184	2026-08-24 04:30	2026-09-24 03:45	102	106	0.1315	6,938

delete /* QOSH:PURGE_OLD_STS *//*+ dynamic_sampling(4) */   from sys.wri$_optstat_histhead_history     where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0'   and rownum <=  :2

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
307411756	2026-08-23 11:38	2026-09-27 16:45	2,019	22,989	0.004716	0.452

select T.*  from table(dbms_xplan.get_plan_rows(:tab_name, :stmt_id, :plan_id, :format, :fpreds, 1, null)) T

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1475428744	2026-08-23 11:38	2026-09-27 16:15	988	52,321	0.000544	12.71
4184428695	2026-08-26 19:34	2026-08-31 07:00	62	312	0.001502	15.94

select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,flags,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

Parsing schema: SYS
Module: sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)
Action: —
Optimizer mode: CHOOSE
Force-match sig: 15923375254844418634
SQL profile: —
Text length: 226 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1227530427	2026-08-23 11:38	2026-09-27 16:45	1,818	381,872	0.000022	4.120
4147495557	2026-08-23 16:46	2026-08-26 19:44	2	770	0.000033	4.104
1158320201	2026-08-29 14:06	2026-09-09 12:45	77	2,967	0.00017	28.17

select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand(nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

Parsing schema: SYS
Module: emagent_SQL_oracle_database
Action: db_options
Optimizer mode: ALL_ROWS
Force-match sig: 226190071430424382
SQL profile: —
Text length: 2,239 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2476633687	2026-08-24 00:15	2026-09-26 03:45	28	28	0.1482	1,616

select 'INTER_MEDIA' as name, decode((select username from dba_users where username='ORDSYS'), 'ORDSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'SPATIAL' as name, decode((select username from dba_users where username='MDSYS'), 'MDSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'ORACLE_TEXT' as name, decode((select username from dba_users where username='CTXSYS'), 'CTXSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'ULTRA_SEARCH' as name, decode((select username from dba_users where username='WKSYS'), 'WKSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'LABEL_SECURITY' as name, decode((select username from dba_users where username='LBACSYS'), 'LBACSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'SAMPLE_SCHEMA' as name, decode((select count(*) from dba_users where username IN('HR','PM','QS','SH','OE')), 0, 'FALSE', 'TRUE') as selected
from dual
union
select 'JSERVER' as name, decode((select count(*) from sys."_CURRENT_EDITION_OBJ" where type#=29), 0, 'FALSE', 'TRUE') as selected
from dual
union
select 'ORACLE_DATA_MINING' as name, decode((select status from dba_registry where comp_id='ODM'), 'VALID', 'TRUE', 'FALSE') as selected
from dual
union
select 'XDB' as name, decode((select username from dba_users where username='XDB'), 'XDB', 'TRUE', 'FALSE') as selected
from dual
union
select 'EM_REPOSITORY' as name, decode((select username from dba_users where username='SYSMAN'), 'SYSMAN', 'TRUE', 'FALSE') as selected
from dual
UNION
select 'Database Vault' as name, decode((SELECT 1 from (Select count(*) CNT
from dba_users where UPPER(username) in ('DVSYS','DVF') ) where CNT = 2),1,'TRUE','FALSE') as selected from dual
UNION
select 'Audit Vault' as name, decode((SELECT 1 from dba_users where UPPER(username) = 'AVSYS' and rownum = 1), 1, 'TRUE', 'FALSE') as selected
from dual
UNION
select 'Content Database' as name, decode((SELECT 1 from dba_users where UPPER(username) = 'CONTENT' and rownum = 1),1,'TRUE','FALSE') as selected
from dual
UNION
select 'Records Database' as name, decode((SELECT 1 from dba_users where UPPER(username) = 'CONTENT' and rownum = 1),1,'TRUE','FALSE') as selected
from dual
UNION
select parameter as name,value as selected from v$option

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3523134145	2026-08-23 20:41	2026-09-27 16:45	3,733	363,592	0.000023	0.3931
571474032	2026-09-26 05:00	2026-09-27 16:45	98	14,554	0.000042	2.008

select nvl(sum(space),0) from recyclebin$ where ts# = :1

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
389693511	2026-08-28 09:45	2026-09-26 10:00	26	26	0.04476	1,220

select cons.consumer_name 
        from sys.dba_queue_subscribers cons
        left join sys.user$ us
          on replace(cons.consumer_name,'SCHED$_AGT2$_')=us.user#
        where
          cons.queue_name='SCHEDULER$_EVENT_QUEUE' and
          cons.consumer_name like 'SCHED$_AGT2$_%' and
          us.user# is null

Parsing schema: AUDSYS
Module: Oracle Enterprise Manager.Metric Engine
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 5149218935331065413
SQL profile: —
Text length: 339 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1429948838	2026-08-23 11:38	2026-09-27 15:45	130	131	0.04962	1,660
2758041994	2026-08-23 21:15	2026-09-27 15:45	136	136	0.03688	1,405
1784545626	2026-09-02 18:30	2026-09-02 18:45	1	1	0.02248	1,393

SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE SHELFLIFE=30) */ "DBUSERNAME","EVENT_TIMESTAMP","ACTION_NAME","RETURN_CODE" FROM "AUDSYS"."UNIFIED_AUDIT_TRAIL" "K" WHERE "K"."ACTION_NAME"='LOGON' AND "K"."RETURN_CODE"<>0 AND SYS_EXTRACT_UTC("K"."EVENT_TIMESTAMP")>=SYS_EXTRACT_UTC(CURRENT_TIMESTAMP(6)-TO_DSINTERVAL('0 0:30:00'))

Parsing schema: SYS
Module: Oracle Enterprise Manager.Metric Engine
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 15582271173586173236
SQL profile: —
Text length: 1,011 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1561607518	2026-08-23 11:38	2026-09-27 16:45	1,050	1,055	0.05946	4,144

SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD')  AS curr_timestamp, SUM(failed_count) AS failed_count ,   TO_CHAR(MIN(first_occur_time), 'yyyy-mm-dd hh24:mi:ss') AS first_occur_time,    TO_CHAR(MAX(last_occur_time), 'yyyy-mm-dd hh24:mi:ss') AS last_occur_time,  name FROM (SELECT COUNT(DBUSERNAME) AS failed_count,  MIN(event_timestamp) AS first_occur_time, MAX(event_timestamp) AS last_occur_time, c.name  FROM cdb_unified_audit_trail a,  v$containers c  WHERE a.ACTION_NAME='LOGON' and a.return_code <> 0  AND a.event_timestamp >= current_timestamp - TO_DSINTERVAL('0 0:30:00')  AND a.con_id = c.con_id  GROUP BY c.name  UNION  SELECT COUNT(username) AS failed_count,  MIN(timestamp) AS first_occur_time,  MAX(timestamp) AS last_occur_time, c.name  FROM  sys.cdb_audit_session a, v$containers c  WHERE a.returncode != 0  AND  a.ACTION_NAME = 'LOGON'  AND a.timestamp >= current_timestamp - TO_DSINTERVAL('0 0:30:00')  AND a.con_id = c.con_id  GROUP BY c.name ) GROUP BY name

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2243849280	2026-08-23 16:56	2026-09-27 16:45	2,094	2,081	0.05703	15.56
1796491218	2026-08-29 13:59	2026-09-11 04:45	122	14	0.0182	31.93

insert into  wrh$_mvparameter  (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, ordinal, value, isdefault, ismodified)  select  :dbid,  sv.con_id, con_id_to_dbid(sv.con_id)  con_dbid,  :snap_id, :instance_number, sv.hash, sv.ordinal, substr(sv.value, 1, 512), sv.isdefault, sv.ismodified  from v$system_parameter2    sv  where exists (select 1 from v$system_parameter4    i  where i.num = sv.num                    and bitand(i.param_flag,32) = 32)

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
4128444468	2026-08-28 09:45	2026-09-08 10:01	7	7	0.02974	727.9
1505094525	2026-09-12 09:45	2026-09-26 10:00	9	9	0.04616	749.7

SELECT 1 from "SYS"."AQ$SCHEDULER$_EVENT_QTAB" qtview  WHERE (queue = 'AQ$_SCHEDULER$_EVENT_QTAB_E' ) AND rownum < 2

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
570326988	2026-08-23 11:38	2026-09-27 15:30	963	51,918	0.000274	8.685
893970548	2026-08-26 19:34	2026-08-31 07:00	63	312	0.000897	14.17

select order#,columns,types from access$ where d_obj#=:1

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2844803677	2026-08-23 21:30	2026-09-27 16:45	1,756	1,756	0.02394	681.6

insert into  wrh$_parameter  (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, value, isdefault, ismodified)  select  :dbid,  sp.con_id, con_id_to_dbid(sp.con_id)  con_dbid,  :snap_id, :instance_number, hash, substr(value, 1, 512), isdefault, ismodified  from v$system_parameter    sp

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3205310162	2026-08-24 04:30	2026-09-24 03:45	49	49	0.06723	1,863

select /* QOSH:ANLYZ_TIME */     from_tz(      cast ((max(analyzetime) - 1) as timestamp),      to_char(systimestamp, 'TZH:TZM'))  from sys.tab$ where analyzetime is not null

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: CHOOSE
Force-match sig: 17748462609813920007
SQL profile: —
Text length: 1,006 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2612542848	2026-08-23 18:00	2026-09-27 16:00	698	698	0.05148	1,304
2742874602	2026-08-23 21:45	2026-08-28 04:30	14	14	0.02096	742.7
1683025539	2026-09-09 11:00	2026-09-27 16:00	220	220	0.06326	1,695

insert /* KSXM:TAKE_SNPSHOT */ into sys.optstat_snapshot$ (obj#, inserts, updates, deletes, timestamp, flags) (select m.obj#, m.inserts, m.updates, m.deletes, systimestamp,  dbms_stats_advisor.compute_volatile_flag(    m.obj#, m.flags, :flags, m.inserts, m.updates, m.deletes,    s.inserts, s.updates, s.deletes, null,    nvl(to_number(p.valchar), :global_stale_pcnt), s.gather) flags from sys.mon_mods_all$ m, (select si.obj#, max(si.inserts) inserts, max(si.updates) updates,    max(si.deletes) deletes, decode(bitand(max(si.flags), :gather_flag), 0,                               'NO_GATHER', 'GATHER') gather,    max(si.timestamp) timestamp  from sys.optstat_snapshot$ si,  (select obj#, max(timestamp) ts from sys.optstat_snapshot$   group by obj#) sm  where si.obj# = sm.obj# and si.timestamp = sm.ts  group by si.obj#) s, sys.optstat_user_prefs$ p where m.obj# = s.obj#(+)  and m.obj# = p.obj#(+) and pname(+) = 'STALE_PERCENT'  and dbms_stats_advisor.check_mmon_policy_violation(rownum, 6, 2) = 0)

Parsing schema: SYS
Module: sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 1169769593972080845
SQL profile: —
Text length: 2,455 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
473814785	2026-08-29 11:30	2026-09-27 16:45	1,550	22,898	0.003235	51.62

select json_object(
  'collected_at' value to_char(sys_extract_utc(systimestamp), 'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"'),
  'log_type' value 'oracle_metrics',
  'event' value json_object('outcome' value 'success'),
  'log' value json_object('level' value 'INFO'),
  'oracle' value json_object(
    'metric' value json_object('type' value 'health'),
    'database' value json_object(
      'name' value d.db_unique_name,
      'role' value d.database_role,
      'open_mode' value d.open_mode,
      'protection_mode' value d.protection_mode,
      'switchover_status' value d.switchover_status
    ),
    'instance' value json_object(
      'name' value i.instance_name,
      'status' value i.status,
      'database_status' value i.database_status,
      'version' value i.version,
      'startup_time' value to_char(i.startup_time, 'YYYY-MM-DD"T"HH24:MI:SS'),
      'available' value case when i.status = 'OPEN' then 'true' else 'false' end format json
    ),
    'metrics' value json_object(
      'sessions' value json_object(
        'current' value (select current_utilization from v$resource_limit where resource_name = 'sessions'),
        'limit' value (select case when regexp_like(trim(limit_value), '^[0-9]+$') then to_number(trim(limit_value)) end from v$resource_limit where resource_name = 'sessions'),
        'utilization_pct' value (select round(100 * current_utilization / nullif(case when regexp_like(trim(limit_value), '^[0-9]+$') then to_number(trim(limit_value)) end, 0), 2) from v$resource_limit where resource_name = 'sessions')
      ),
      'processes' value json_object(
        'current' value (select current_utilization from v$resource_limit where resource_name = 'processes'),
        'limit' value (select case when regexp_like(trim(limit_value), '^[0-9]+$') then to_number(trim(limit_value)) end from v$resource_limit where resource_name = 'processes'),
        'utilization_pct' value (select round(100 * current_utilization / nullif(case when regexp_like(trim(limit_value), '^[0-9]+$') then to_number(trim(limit_value)) end, 0), 2) from v$resource_limit where resource_name = 'processes')
      ),
      'blocking_sessions' value (select count(*) from v$session where blocking_session is not null),
      'failed_jobs_24h' value (select count(*) from dba_scheduler_job_run_details where status = 'FAILED' and log_date >= systimestamp - interval '1' day)
    )
  ) returning clob
) from v$instance i cross join v$database d

Parsing schema: SYS
Module: emagent_SQL_oracle_database
Action: pdbResponse_cdb
Optimizer mode: ALL_ROWS
Force-match sig: 826682939208367061
SQL profile: —
Text length: 828 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
4161125554	2026-08-23 16:56	2026-09-27 16:45	2,169	129,934	0.000314	0

SELECT nonprimarydb.name as pdbName
,MAX(CASE WHEN takecdbstatus.open_mode LIKE 'MOUNT%' THEN 1
WHEN takecdbstatus.open_mode LIKE 'READ%' THEN 1
ELSE 0
END) as state_num
FROM gv$containers nonprimarydb
,gv$containers takecdbstatus
WHERE nonprimarydb.name <> 'PDB$SEED'
AND   takecdbstatus.name = 'CDB$ROOT'
AND ((sys_context('USERENV','CURRENT_USER') like 'SYS%' AND takecdbstatus.open_mode LIKE 'MOUNT%') OR (takecdbstatus.open_mode LIKE 'READ%'))
AND EXISTS (SELECT 1
FROM v$database
WHERE database_role <> 'PRIMARY')
GROUP BY nonprimarydb.name
UNION ALL
SELECT primarydb.name as pdbName
,MAX(CASE WHEN primarydb.open_mode like 'READ%' THEN 1 ELSE 0 END) as state_num
FROM gv$containers primarydb
WHERE primarydb.name <> 'PDB$SEED'
AND EXISTS (SELECT 1
FROM v$database
WHERE database_role = 'PRIMARY')
GROUP BY primarydb.name

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2567466223	2026-08-23 20:41	2026-09-27 16:45	3,672	363,796	0.000011	0.3927
1329207485	2026-09-26 05:15	2026-09-27 16:45	97	13,505	0.000018	2.013

select file#, block# from recyclebin$ where ts# = :1     and file# != 0 and block# != 0 and space = 0

Parsing schema: SYS
Module: emagent_SQL_oracle_database
Action: cdb_dbNInstanceInfo
Optimizer mode: ALL_ROWS
Force-match sig: 851114820898354883
SQL profile: —
Text length: 195 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2762963881	2026-09-11 08:45	2026-09-20 09:00	13	13	0.2603	192.2

SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE SHELFLIFE=30) */ "PROPERTY_NAME","PROPERTY_VALUE" FROM "SYS"."DATABASE_PROPERTIES" "K" WHERE "K"."PROPERTY_NAME"='GLOBAL_DB_NAME' AND 1=1

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3102754926	2026-08-23 21:30	2026-09-27 16:00	418	418	0.06573	2,428

insert into  wrh$_latch  (dbid, per_pdb, con_dbid, snap_id, instance_number, latch_hash, level#, gets, misses,    sleeps, immediate_gets, immediate_misses, spin_gets, sleep1,    sleep2, sleep3, sleep4, wait_time)  select  :dbid,  ltch.con_id, con_id_to_dbid(ltch.con_id)  con_dbid,  :snap_id, :instance_number,  hash, level#, gets,    misses, sleeps, immediate_gets, immediate_misses, spin_gets,    sleep1, sleep2, sleep3, sleep4, wait_time  FROM v$latch    ltch  WHERE  (1 = 1)  AND ( ltch.con_id < 4099  )

Parsing schema: SYS
Module: —
Action: —
Optimizer mode: ALL_ROWS
Force-match sig: 18260049357392869104
SQL profile: —
Text length: 4,280 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
1660022729	2026-08-23 11:38	2026-09-27 16:45	2,081	24,453	0.006377	2.167

select xmlagg(
                        xmlelement("operation", 
                          xmlattributes(operation as "name",
                                        options  as "options",
                                        id as "id", 
                                        depth as "depth", 
                                        position as "pos"),
                          nvl2(object_name, 
                               xmlelement("object", 
                                          object_name), NULL),
                          decode(:format, 'BASIC', null,
                               nvl2(cardinality, xmlelement("card", cardinality),
                               NULL)),
                          decode(:format, 'BASIC', null,
                               nvl2(bytes, xmlelement("bytes", bytes), NULL)),
                          nvl2(temp_space, xmlelement("temp_space",temp_space),
                               NULL),
                          decode(:format, 'BASIC', null,
                               nvl2(cost, xmlelement("cost", cost), NULL)),
                          nvl2(io_cost, xmlelement("io_cost", io_cost), NULL),
                          nvl2(cpu_cost, xmlelement("cpu_cost",cpu_cost),NULL),
                          decode(:format, 'BASIC', null,
                               nvl2(time, 
                               xmlelement("time", 
                                 sys.dbms_xplan.format_time_s(time)),
                               NULL)),
                          nvl2(partition_start, 
                               xmlelement("partition", 
                                 xmlattributes(partition_start as "start", 
                                               partition_stop as "stop")),
                               NULL),
                          nvl2(object_node, xmlelement("node", object_node), 
                               NULL),
                          nvl2(distribution,xmlelement("distrib",distribution),
                               NULL),
                          nvl2(projection, 
                            xmlelement("project", projection), NULL),
                          nvl2(access_predicates, 
                               xmlelement("predicates", 
                                xmlattributes(decode(substr(options, 1, 8), 
                                                     'STORAGE ', 'storage', 
                                                     'access') as "type"), 
                                              access_predicates),
                               NULL),
                          nvl2(filter_predicates, 
                               xmlelement("predicates", 
                                           xmlattributes('filter' as "type"),
                                           filter_predicates),
                               NULL),
                          nvl2(qblock_name, 
                               xmlelement("qblock", qblock_name), 
                               NULL),
                          nvl2(object_alias,
                               xmlelement("object_alias", object_alias), 
                               NULL),
                         (case when other_xml is null then null 
                                else xmltype(other_xml) end)
                       )
                     ) plan
                 from (select id, parent_id, position, depth, operation, options,
                     object_name, cardinality, bytes, temp_space, cost, 
                     io_cost, cpu_cost, time, pstart as partition_start,
                     pstop as partition_stop, object_node, other_tag,
                     distrib as distribution, projection,
                     access_pred as access_predicates, 
                     filter_pred as filter_predicates, other, qblock_name,
                     object_alias, other_xml, sql_profile,
                     sql_plan_baseline, starts, outrows, crgets, cugets,
                     reads, writes, etime, mem_opt, mem_one, last_mem_used, 
                     last_mem_usage, mem_opt_cnt, mem_one_cnt, mem_multi_cnt,
                     max_tmp_used, last_tmp_used from table(dbms_xplan.get_plan_rows(:tab_name, :stmt_id, :plan_id, :format, :fpreds, 1, null)))

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3652932668	2026-08-23 18:00	2026-09-27 16:45	1,192	1,194	0.03194	4,858

insert into  WRH$_SYSSTAT  (dbid, per_pdb, con_dbid, snap_id, instance_number, stat_id, value)  select /*+ use_hash(v$sysstat) */  :dbid,  sysstat.con_id, con_id_to_dbid(sysstat.con_id)  con_dbid,  :snap_id, :instance_number, stat_id, value  FROM v$sysstat    sysstat  WHERE  (1 = 1)  AND ( sysstat.con_id < 4099  )

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
477378112	2026-08-23 16:46	2026-09-27 14:30	1,113	241,413	0.000062	3.417

update /* KSXM:FLUSH COL */ sys.col_usage$ set                  equality_preds    = equality_preds    + decode(bitand(:flag,1),0,0,1),   equijoin_preds    = equijoin_preds    + decode(bitand(:flag,2),0,0,1),   nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1),   range_preds       = range_preds       + decode(bitand(:flag,8),0,0,1),   like_preds        = like_preds        + decode(bitand(:flag,16),0,0,1),   null_preds        = null_preds        + decode(bitand(:flag,32),0,0,1),   flags             = flags + :flag - bitand(flags,:flag),    timestamp = :time where obj# = :objn and intcol# = :coln

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
3322223638	2026-08-23 16:46	2026-09-27 10:30	452	444	0.009638	2,054
1474981312	2026-08-27 22:00	2026-09-25 22:00	373	21	0.03156	2,138
489053127	2026-09-09 05:00	2026-09-26 10:00	268	13	0.01578	2,616
2762765423	2026-09-09 06:45	2026-09-26 10:00	272	266	0.005819	2,734

select count(*) from dba_autotask_window_clients c, (select window_name, max(log_date) max_log_date from dba_scheduler_window_log where operation = 'OPEN' group by window_name) wo, (select window_name, max(log_date) max_log_date from dba_scheduler_window_log where operation = 'CLOSE' group by window_name) wc where c.window_name = wo.window_name and c.optimizer_stats = 'ENABLED' and wo.window_name = wc.window_name and wo.max_log_date < wc.max_log_date and wc.window_name not in (select h.window_name from dba_autotask_job_history h where h.client_name = 'auto optimizer stats collection' and h.job_start_time between wo.max_log_date and wc.max_log_date)

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
4250213283	2026-08-23 11:38	2026-09-27 16:45	1,968	69,034	0.001635	0.000898

SELECT to_number(value)
         FROM sys.v$parameter
         WHERE name = '_qa_lrg_type'

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
4168499536	2026-08-24 01:30	2026-09-24 05:45	61	61	0.1018	130.2

insert into  WRH$_SERVICE_STAT  (dbid, per_pdb, con_dbid, snap_id, instance_number,  service_name_hash, stat_id, value) select /*+ opt_param('_optimizer_mjc_enabled','false')               leading(asvc s m) */  :dbid,  asvc.con_id, con_id_to_dbid(asvc.con_id)  con_dbid,  :snap_id, :instance_number,  stat.service_name_hash, stat.stat_id, stat.value   FROM v$active_services    asvc, v$service_stats    stat  WHERE  (1 = 1)  AND ( asvc.con_id < 4099  )  AND ((asvc.con_id = stat.con_id))  and  asvc.name_hash = stat.service_name_hash

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2419380041	2026-08-23 22:00	2026-09-27 15:45	239	239	0.02454	6,007

select s.ts#, s.file#, s.block#, so.object_id, s.spare1, s.type#, s.hwmincr from seg$ s, sys_objects so where bitand(s.spare1,131072) = 0 and s.ts# = so.ts_number and s.file# = so.header_file and s.block# = so.header_block order by s.file# asc

Parsing schema: SYS
Module: sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)
Action: —
Optimizer mode: CHOOSE
Force-match sig: —
SQL profile: —
Text length: 102 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
2313771059	2026-08-23 21:00	2026-09-27 16:00	1,425	26,199	0.000022	4.998

select pob.parttype from sys.tabpart$ tp, sys.partobj$ pob  where tp.bo# = pob.obj# and tp.obj# = :oid

Parsing schema: SYS
Module: emagent_SQL_oracle_database
Action: Response
Optimizer mode: ALL_ROWS
Force-match sig: 14841237291181284952
SQL profile: —
Text length: 80 chars

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
4175978637	2026-08-23 16:56	2026-09-27 16:45	2,171	129,942	0.000129	0

SELECT  1, status, '',archiver, database_status, active_state FROM v$instance

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

Plan hash	First seen	Last seen	Snapshots	Executions	Avg s/exec	Avg gets/exec
4233836756	2026-08-23 16:56	2026-09-27 16:45	4,093	122,852	0.00004	1.000

select count(*) from ilmobj$ where rownum = 1

▸ Show 50 more statements

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

5 SQLs below the 5-sample ASH threshold, listed without a chart

0za9fv0j1vgkk (1) · 35k8v3jjhv3k6 (1) · 7h6kvx22p1mvc (1) · 7jdsnpg2pzzfd (1) · apkz5my1bt69s (1)

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

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

69 executions captured in the compared span, but none met the inclusion floor (elapsed ≥ 1 s, an error, or more than one execution plan). The scatter below still plots every captured execution.

Execution scatter (full compared span)

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

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

By physical reads

Break down by:

Detail table

Segment	Type	Current (blocks)	−1h	−2h	−3h	−4h
SYS.TAB$ new	TABLE	1,853 #1	—	—	—	—
SYS.LOB$ new	TABLE	724.0 #2	—	—	—	—
SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P724 new	TABLE PARTITION	691.0 #3	—	—	—	—
SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P911 new	TABLE PARTITION	623.0 #4	—	—	—	—
SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P671 new	TABLE PARTITION	565.0 #5	—	—	—	—
SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P842 new	TABLE PARTITION	565.0 #6	—	—	—	—
SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P853 new	TABLE PARTITION	565.0 #7	—	—	—	—
SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P991 new	TABLE PARTITION	565.0 #8	—	—	—	—
SYS.SYS_TEMP_0FD9D9D6A_851EE3	TABLE	514.0 #9	514.0 #1	514.0 #1	514.0 #2	514.0 #1
SYS.OPTSTAT_SNAPSHOT$ new	TABLE	513.0 #10	—	—	—	—
SYS.OBJ$	TABLE	—	—	—	2,374 #1	—
SYS.SYS_TEMP_0FD9D9D69_851EE3	TABLE	—	508.0 #2	508.0 #2	508.0 #3	508.0 #2
SYS.STATS_ADVISOR_FILTER_OBJ$	TABLE	—	257.0 #3	257.0 #3	257.0 #4	257.0 #3
SYS.SYS_TEMP_0FD9D9D68_851EE3	TABLE	—	257.0 #4	257.0 #4	257.0 #5	257.0 #4
MISSING . MISSING: 78291/78291. MISSING **	UNDEFINED	—	128.0 #5	62.00 #9	82.00 #6	112.0 #5
SYS.WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1214129087_MXSN	TABLE PARTITION	—	—	128.0 #5	62.00 #8	77.00 #7
SYS.WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1214129087_MXSN	INDEX PARTITION	—	—	128.0 #6	62.00 #10	70.00 #8
SYS.WRH$_PROCESS_WAITTIME.WRH$_PROCESS_WAITTIME_1214129087_MXSN	TABLE PARTITION	—	83.00 #6	—	—	—
SYS.WRH$_LATCH.WRH$_LATCH_1214129087_MXSN	TABLE PARTITION	—	—	—	—	82.00 #6
MISSING . MISSING: 78228/78228. MISSING **	UNDEFINED	—	—	98.00 #7	—	—
MISSING . MISSING: 78343/78343. MISSING **	UNDEFINED	—	80.00 #7	—	—	—
SYS.WRH$_CON_SYSMETRIC_SUMMARY	TABLE	—	—	—	62.00 #7	40.00 #9
SYS.WRH$_SYSSTAT.WRH$_SYSSTAT_1214129087_MXSN	TABLE PARTITION	—	—	78.00 #8	62.00 #9	39.00 #10
SYS.WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_1214129087_MXSN	TABLE PARTITION	—	69.00 #8	—	—	—
MISSING . MISSING: 78232/78232. MISSING **	UNDEFINED	—	57.00 #9	—	—	—
SYS.WRH$_SQLSTAT.WRH$_SQLSTAT_1214129087_MXSN	TABLE PARTITION	—	50.00 #10	—	—	—
MISSING . MISSING: 78252/78252. MISSING **	UNDEFINED	—	—	38.00 #10	—	—

By physical writes

Break down by:

Detail table

Segment	Type	Current (blocks)	−1h	−2h	−3h	−4h
SYS.SYS_TEMP_0FD9D9D69_851EE3	TABLE	541.0 #1	627.0 #1	543.0 #1	540.0 #1	557.0 #1
SYS.SYS_TEMP_0FD9D9D6A_851EE3	TABLE	254.0 #2	255.0 #2	254.0 #2	254.0 #2	254.0 #2
MISSING . MISSING: 78291/78291. MISSING **	UNDEFINED	182.0 #3	152.0 #3	152.0 #4	186.0 #3	152.0 #3
SYS.WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1214129087_MXSN	INDEX PARTITION	128.0 #4	74.00 #9	176.0 #3	128.0 #4	123.0 #6
SYS.STATS_ADVISOR_FILTER_OBJ$	TABLE	127.0 #5	127.0 #4	127.0 #7	127.0 #5	127.0 #4
SYS.SYS_TEMP_0FD9D9D68_851EE3	TABLE	127.0 #6	127.0 #5	127.0 #8	127.0 #6	127.0 #5
SYS.WRH$_LATCH.WRH$_LATCH_1214129087_MXSN	TABLE PARTITION	102.0 #7	—	—	95.00 #8	88.00 #9
SYS.WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1214129087_MXSN	TABLE PARTITION	97.00 #8	101.0 #6	130.0 #6	114.0 #7	112.0 #7
SYS.WRH$_SEG_STAT_OBJ	TABLE	85.00 #9	87.00 #8	85.00 #10	—	96.00 #8
MISSING . MISSING: 78343/78343. MISSING **	UNDEFINED	83.00 #10	89.00 #7	—	—	—
MISSING . MISSING: 78228/78228. MISSING **	UNDEFINED	—	—	130.0 #5	—	—
SYS.WRH$_SYSSTAT.WRH$_SYSSTAT_1214129087_MXSN	TABLE PARTITION	—	—	111.0 #9	92.00 #9	—
SYS.WRH$_CON_SYSMETRIC_SUMMARY	TABLE	—	—	—	89.00 #10	—
SYS.WRH$_PROCESS_WAITTIME.WRH$_PROCESS_WAITTIME_1214129087_MXSN	TABLE PARTITION	—	67.00 #10	—	—	—
SYS.WRH$_SQLSTAT_INDEX.WRH$_SQLSTAT_1214129087_MXSN	INDEX PARTITION	—	—	—	—	67.00 #10

By physical read requests

Break down by:

Detail table

Segment	Type	Current (requests)	−1h	−2h	−3h	−4h
SYS.LOB$ new	TABLE	527.0 #1	—	—	—	—
SYS.I_OPTSTAT_SNAPSHOT$ new	INDEX	405.0 #2	—	—	—	—
SYS.OPTSTAT_SNAPSHOT$ new	TABLE	135.0 #3	—	—	—	—
SYS.I_OBJ1 new	INDEX	115.0 #4	—	—	—	—
MISSING . MISSING: 78291/78291. MISSING **	UNDEFINED	82.00 #5	128.0 #1	62.00 #5	82.00 #2	112.0 #1
SYS.WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1214129087_MXSN	INDEX PARTITION	81.00 #6	—	128.0 #2	62.00 #6	70.00 #4
SYS.WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1214129087_MXSN	TABLE PARTITION	75.00 #7	—	128.0 #1	62.00 #4	77.00 #3
SYS.WRH$_SYSSTAT.WRH$_SYSSTAT_1214129087_MXSN	TABLE PARTITION	70.00 #8	—	78.00 #4	62.00 #5	39.00 #6
SYS.TAB$ new	TABLE	59.00 #9	—	—	—	—
SYS.WRH$_LATCH.WRH$_LATCH_1214129087_MXSN	TABLE PARTITION	57.00 #10	28.00 #10	—	46.00 #8	82.00 #2
SYS.OBJ$	TABLE	—	—	—	108.0 #1	—
SYS.WRH$_PROCESS_WAITTIME.WRH$_PROCESS_WAITTIME_1214129087_MXSN	TABLE PARTITION	—	83.00 #2	—	—	—
MISSING . MISSING: 78228/78228. MISSING **	UNDEFINED	—	—	98.00 #3	—	—
MISSING . MISSING: 78343/78343. MISSING **	UNDEFINED	—	80.00 #3	35.00 #8	—	—
SYS.WRH$_CON_SYSMETRIC_SUMMARY	TABLE	—	—	32.00 #10	62.00 #3	40.00 #5
SYS.WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_1214129087_MXSN	TABLE PARTITION	—	69.00 #4	—	—	—
MISSING . MISSING: 78232/78232. MISSING **	UNDEFINED	—	57.00 #5	—	—	—
SYS.WRH$_SQLSTAT.WRH$_SQLSTAT_1214129087_MXSN	TABLE PARTITION	—	50.00 #6	—	—	—
MISSING . MISSING: 78252/78252. MISSING **	UNDEFINED	—	—	38.00 #6	—	—
SYS.SYS_LOB0000011147C00038$$	LOB	—	48.00 #7	—	—	—
SYS.WRH$_CON_SYSMET_SUMMARY_INDEX	INDEX	—	33.00 #9	—	46.00 #7	21.00 #9
SYS.WRH$_SERVICE_STAT_PK.WRH$_SERVICE_STAT_1214129087_MXSN	INDEX PARTITION	—	—	—	46.00 #9	35.00 #7
MISSING . MISSING: 78351/78351. MISSING **	UNDEFINED	—	—	38.00 #7	—	—
SYS.WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_1214129087_MXSN	INDEX PARTITION	—	43.00 #8	—	—	—
SYS.WRH$_SQLSTAT_PK.WRH$_SQLSTAT_1214129087_MXSN	INDEX PARTITION	—	—	—	—	35.00 #8
SYS.WRH$_BG_EVENT_SUMMARY_PK	INDEX	—	—	32.00 #9	—	—
SYS.WRM$_SNAPSHOT_DETAILS	TABLE	—	—	—	34.00 #10	—
SYS.WRH$_IOSTAT_FUNCTION_PK	INDEX	—	—	—	—	20.00 #10

By physical write requests

Break down by:

Detail table

Segment	Type	Current (requests)	−1h	−2h	−3h	−4h
MISSING . MISSING: 78291/78291. MISSING **	UNDEFINED	65.00 #1	78.00 #1	62.00 #1	67.00 #2	60.00 #1
SYS.WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1214129087_MXSN	TABLE PARTITION	62.00 #2	46.00 #6	47.00 #2	71.00 #1	45.00 #6
SYS.WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1214129087_MXSN	INDEX PARTITION	62.00 #3	70.00 #2	45.00 #4	65.00 #3	46.00 #4
MISSING . MISSING: 78228/78228. MISSING **	UNDEFINED	52.00 #4	46.00 #5	39.00 #6	43.00 #5	45.00 #5
SYS.WRH$_SEG_STAT_OBJ	TABLE	45.00 #5	46.00 #7	47.00 #3	50.00 #4	49.00 #2
SYS.WRH$_SYSSTAT.WRH$_SYSSTAT_1214129087_MXSN	TABLE PARTITION	45.00 #6	44.00 #8	39.00 #7	43.00 #6	46.00 #3
SYS.WRH$_LATCH.WRH$_LATCH_1214129087_MXSN	TABLE PARTITION	35.00 #7	48.00 #4	41.00 #5	32.00 #7	35.00 #7
SYS.SYS_TEMP_0FD9D9D6A_851EE3	TABLE	30.00 #8	29.00 #9	29.00 #10	30.00 #8	29.00 #10
MISSING . MISSING: 78351/78351. MISSING ** new	UNDEFINED	29.00 #9	—	—	—	—
MISSING . MISSING: 78252/78252. MISSING **	UNDEFINED	28.00 #10	—	—	27.00 #10	30.00 #8
SYS.SYS_TEMP_0FD9D9D69_851EE3	TABLE	—	63.00 #3	—	—	—
SYS.WRH$_SQL_PLAN	TABLE	—	—	37.00 #8	—	—
MISSING . MISSING: 78343/78343. MISSING **	UNDEFINED	—	—	29.00 #9	29.00 #9	29.00 #9
SYS.WRH$_CON_SYSSTAT.WRH$_CON_SYSSTAT_1214129087_MXSN	TABLE PARTITION	—	26.00 #10	—	—	—

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

By data read (MB)

Break down by:

Detail table

File	Tablespace	Current (MB)	−1h	−2h	−3h	−4h
sysaux01.dbf	SYSAUX	72.12 #1	8.100 #2	10.30 #2	8.600 #2	8.200 #3
sysaux01.dbf	SYSAUX	27.64 #2	0.1 #5	0 #5	0.1 #5	0 #5
temp01.dbf	TEMP	12.02 #3	12.00 #1	12.00 #1	12.00 #1	12.00 #1
undotbs01.dbf	UNDOTBS1	5.500 #4	6.600 #3	3.800 #3	6.400 #3	9.100 #2
undotbs01.dbf	UNDOTBS1	0.4219 #5	0.2 #4	0.1 #4	0.1 #4	0.1 #4
users01.dbf	USERS	—	—	—	0.1 #6	—
o1_mf_shtbs_o8ppqf26_.dbf	SHTBS	—	—	—	0 #7	—
o1_mf_soetbs_o8ppqbr3_.dbf	SOETBS	—	—	—	0 #8	—
chaos_ts01.dbf	CHAOS_TS	—	—	—	0 #9	—
users01.dbf	USERS	—	—	—	0 #10	—

By data written (MB)

Break down by:

Detail table

File	Tablespace	Current (MB)	−1h	−2h	−3h	−4h
sysaux01.dbf	SYSAUX	23.16 #1	21.10 #1	23.20 #1	23.00 #1	21.30 #1
temp01.dbf	TEMP	12.40 #2	13.10 #2	12.40 #2	12.40 #2	12.50 #2
undotbs01.dbf	UNDOTBS1	10.37 #3	10.10 #3	10.80 #3	10.60 #3	10.60 #3
undotbs01.dbf	UNDOTBS1	0.8047 #4	1.000 #4	0.9 #4	0.9 #4	0.9 #4
sysaux01.dbf	SYSAUX	0.3203 #5	0.2 #5	0.2 #5	0.2 #5	0.2 #5
chaos_ts01.dbf new	CHAOS_TS	0.007813 #6	—	—	0 #6	0 #6

By read requests

Break down by:

Detail table

File	Tablespace	Current (requests)	−1h	−2h	−3h	−4h
sysaux01.dbf	SYSAUX	1,771 #1	1,035 #1	1,311 #1	1,070 #1	1,039 #1
sysaux01.dbf	SYSAUX	515.0 #2	13.00 #4	2.000 #5	10.00 #4	5.000 #5
undotbs01.dbf	UNDOTBS1	135.0 #3	173.0 #2	85.00 #2	132.0 #2	183.0 #2
temp01.dbf	TEMP	38.00 #4	38.00 #3	38.00 #3	38.00 #3	38.00 #3
undotbs01.dbf	UNDOTBS1	19.00 #5	13.00 #5	12.00 #4	9.000 #5	11.00 #4
users01.dbf	USERS	—	—	—	7.000 #6	—
o1_mf_shtbs_o8ppqf26_.dbf	SHTBS	—	—	—	2.000 #7	—
o1_mf_soetbs_o8ppqbr3_.dbf	SOETBS	—	—	—	2.000 #8	—
chaos_ts01.dbf	CHAOS_TS	—	—	—	2.000 #9	—
users01.dbf	USERS	—	—	—	2.000 #10	—

By write requests

Break down by:

Detail table

File	Tablespace	Current (requests)	−1h	−2h	−3h	−4h
sysaux01.dbf	SYSAUX	1,870 #1	1,975 #1	1,873 #1	1,909 #1	1,910 #1
undotbs01.dbf	UNDOTBS1	215.0 #2	217.0 #2	282.0 #2	251.0 #2	228.0 #2
undotbs01.dbf	UNDOTBS1	90.00 #3	106.0 #4	105.0 #3	113.0 #3	103.0 #3
temp01.dbf	TEMP	76.00 #4	126.0 #3	75.00 #4	76.00 #4	75.00 #4
sysaux01.dbf	SYSAUX	27.00 #5	24.00 #5	22.00 #5	18.00 #5	18.00 #5
chaos_ts01.dbf	CHAOS_TS	1.000 #6	—	—	1.000 #6	1.000 #6

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

Metric	File type	Current	−1h	−2h	−3h	−4h
Data read (MB)	Control File	364.0 #1	345.0 #1	406.0 #1	374.0 #1	351.0 #1
Data read (MB)	Log File	39.00 #2	—	31.00 #2	40.00 #2	—
Data read (MB)	Other	1.000 #3	1.000 #2	—	1.000 #3	1.000 #2
Data read (MB)	Flashback Log	—	—	1.000 #3	—	—
Data written (MB)	Control File	58.00 #1	53.00 #1	70.00 #1	56.00 #1	55.00 #1
Data written (MB)	Archive Log	39.00 #2	—	31.00 #2	40.00 #2	—
Data written (MB)	Flashback Log	26.00 #3	25.00 #2	29.00 #3	28.00 #3	27.00 #2
Data written (MB)	Log File	20.00 #4	21.00 #3	20.00 #4	20.00 #4	19.00 #3
Data written (MB)	Other	1.000 #5	—	1.000 #5	1.000 #5	1.000 #4
Read requests	Control File	20.21 k #1	19.58 k #1	22.20 k #1	20.84 k #1	19.93 k #1
Read requests	Other	180.0 #2	177.0 #2	180.0 #2	180.0 #2	180.0 #2
Read requests	Log File	45.00 #3	—	120.0 #3	46.00 #3	—
Read requests	Flashback Log	16.00 #4	12.00 #3	16.00 #4	12.00 #4	16.00 #3
Write requests	Log File	3,940 #1	3,886 #1	3,994 #2	3,998 #1	3,949 #1
Write requests	Control File	3,706 #2	3,442 #2	4,432 #1	3,586 #2	3,566 #2
Write requests	Other	240.0 #3	236.0 #3	240.0 #3	240.0 #3	240.0 #3
Write requests	Flashback Log	102.0 #4	102.0 #4	117.0 #4	123.0 #4	117.0 #4
Write requests	Archive Log	39.00 #5	—	43.00 #5	40.00 #5	—

ParametersInitialization parameters whose value differs across the windows

No system parameters changed across the compared windows.

Reading the chartsWhat each chart and glyph on this page encodes

Band

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

▲ ×5.4▲ 22.5%▼ 4.2%

Δ vs mean

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

13-window chart

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

Full-span activity

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

Activity per window

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

Span chart

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

Trend

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

Release marker

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

Step line

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

◆ plan changed✚ first seen▽ DOP downgrade

Glyphs

Drawn in the window where it happened.

Day profile

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

Hover and pin

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

About this reportMethod, sources and thresholds behind every section

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

Run 20260927165633740 · template simple · top_n 10 · generated 2026-09-27 16:56:33 +00:00 by SYS · read-only against DBA_HIST_*, no scratch schema.

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

By wait class

By wait event

Nothing moved beyond its normal range.

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

All sectionsEvery table of the report

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

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

Findings18 normalEvery scored metric against its prior windowsEvery scored metric against its prior windows; one table per domain

Load profile

System metrics

Wait classes

What changed around itPlan and configuration changes under the release flags

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

Moved, too small to matter

Improved: none material

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

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

Generate full AWR reports for these windows

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

Transactions and SQL activity

Connections and sessions

Data and network volume

Load profileSystem statistics per second, Current against its normal range

System metricsSYSMETRIC averages per window, Current against its normal range

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

Top 10 events — time waited (s)

Top 10 events — avg time per wait (ms)

Wait-class rollup — time waited (s)

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

Events — time waited (s)

Events — avg time per wait (ms)

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

By elapsed time

By CPU time

By buffer gets

By physical reads

By executions

By per-exec regression

Per-SQL detail

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

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

Execution scatter (full compared span)

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

By physical reads

By physical writes

By physical read requests

By physical write requests

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

By data read (MB)

By data written (MB)

By read requests

By write requests

ParametersInitialization parameters whose value differs across the windows

Reading the chartsWhat each chart and glyph on this page encodes

Band

Δ vs mean

13-window chart

Full-span activity

Activity per window

Span chart

Trend

Release marker

Step line

Glyphs

Day profile

Hover and pin