WORKLOAD REPOSITORY COMPARE PERIOD REPORT (root snapshots)

Report Summary

Snapshot Set DB Name DB Id Unique Name DB Role Edition Release Cluster CDB Host Std Block Size

First (1st) ORCL12C 776972821 orcl12c PRIMARY EE 12.2.0.1.0 NO YES localhost.localdomain 8192

Second (2nd) ORCL12C 776972821 orcl12c PRIMARY EE 12.2.0.1.0 NO YES localhost.localdomain 8192

Snapshot Set	DB Name	DB Id	Unique Name	DB Role	Edition	Release	Cluster	CDB	Host	Std Block Size
First (1st)	ORCL12C	776972821	orcl12c	PRIMARY	EE	12.2.0.1.0	NO	YES	localhost.localdomain	8192
Second (2nd)	ORCL12C	776972821	orcl12c	PRIMARY	EE	12.2.0.1.0	NO	YES	localhost.localdomain	8192

Snapshot Set Instance Inst num

First (1st) orcl12c 1

Second (2nd) orcl12c 1

Snapshot Set	Instance	Inst num
First (1st)	orcl12c	1
Second (2nd)	orcl12c	1

Snapshot Set Begin Snap Id Begin Snap Time End Snap Id End Snap Time Avg Active Users Elapsed Time (min) DB time (min)

1st 27 23-Apr-18 01:12:24 (Mon) 28 23-Apr-18 01:30:13 (Mon) 1.0 17.8 17.8

2nd 29 23-Apr-18 01:43:55 (Mon) 30 23-Apr-18 02:00:18 (Mon) 1.0 16.4 16.4

%Diff 0.0 -8.0 -8.0

Snapshot Set	Begin Snap Id	Begin Snap Time	End Snap Id	End Snap Time	Avg Active Users	Elapsed Time (min)	DB time (min)
1st	27	23-Apr-18 01:12:24 (Mon)	28	23-Apr-18 01:30:13 (Mon)	1.0	17.8	17.8
2nd	29	23-Apr-18 01:43:55 (Mon)	30	23-Apr-18 02:00:18 (Mon)	1.0	16.4	16.4
%Diff					0.0	-8.0	-8.0

Open Pluggable Database Counts

Snapshot Set Begin Snap End Snap

1st 1 1

2nd 1 1

Snapshot Set	Begin Snap	End Snap
1st	1	1
2nd	1	1

Container Database List (1st and 2nd)

Container DB Id Container Name Open Time

4079644691 ORCL 14-Apr-18 02:04

Container DB Id	Container Name	Open Time
4079644691	ORCL	14-Apr-18 02:04

Host Configuration Comparison

	1st	2nd	Diff	%Diff
Number of CPUs:	12	12	0	0.0
Number of CPU Cores:	12	12	0	0.0
Number of CPU Sockets:	1	1	0	0.0
Physical Memory:	24868.7M	24868.7M	0M	0.0
Load at Start Snapshot:	.44	.13	-.31	-70.5
Load at End Snapshot:	1.26	1.13	-.13	-10.3
%User Time:	6.2	3.88	-2.32	-37.4
%System Time:	.44	2.07	1.63	370.5
%Idle Time:	93.27	93.99	.72	0.8
%IO Wait Time:	.35	.31	-.04	-11.4

Cache Sizes

	1st (M)	2nd (M)	Diff (M)	%Diff
Memory Target
SGA Target	10,240.0	10,240.0	0.0	0.0
Buffer Cache	7,424.0	7,424.0	0.0	0.0
Shared Pool	2,048.0	2,048.0	0.0	0.0
Large Pool	160.0	160.0	0.0	0.0
Java Pool	64.0	64.0	0.0	0.0
Streams Pool
PGA Target	3,072.0	3,072.0	0.0	0.0
Log Buffer	19.5	19.5	0.0	0.0
In-Memory Area

Load Profile

1st per sec 2nd per sec %Diff 1st per txn 2nd per txn %Diff

DB time: 1.0 1.0 0.0 0.1 0.4 186.7

CPU time: 1.0 1.0 1.0 0.1 0.4 200.0

Background CPU time: 0.0 0.0 0.0 0.0 0.0 0.0

Redo size (bytes): 13,451,965.5 4,591,945.8 -65.9 1,964,928.4 1,954,991.1 -0.5

Logical read (blocks): 56,797.0 19,367.2 -65.9 8,296.3 8,245.4 -0.6

Block changes: 47,084.7 16,120.4 -65.8 6,877.7 6,863.2 -0.2

Physical read (blocks): 0.0 0.0 0.0 0.0 0.0 0.0

Physical write (blocks): 0.0 0.0 0.0 0.0 0.0 0.0

Read IO requests: 0.0 0.0 0.0 0.0 0.0 0.0

Write IO requests: 0.0 0.0 0.0 0.0 0.0 0.0

Read IO (MB): 0.0 0.0 0.0 0.0 0.0 0.0

Write IO (MB): 0.0 0.0 0.0 0.0 0.0 0.0

IM scan rows: 0.0 0.0 0.0 0.0 0.0 0.0

Session Logical Read IM: 0.0 0.0 0.0 0.0 0.0 0.0

User calls: 0.0 0.0 33.3 0.0 0.0 100.0

Parses (SQL): 0.1 0.1 7.7 0.0 0.1 200.0

Hard parses (SQL): 0.0 0.0 0.0 0.0 0.0 0.0

SQL Work Area (MB): 0.1 0.0 -33.3 0.0 0.0 -33.3

Logons: 0.0 0.0 0.0 0.0 0.0 0.0

Executes (SQL): 6,842.2 2,344.7 -65.7 999.4 998.2 -0.1

Transactions: 6.8 2.3 -65.7

1st 2nd Diff

% Blocks changed per Read: 82.9 83.2 0.3

Recursive Call %: 100.0 100.0 -0.0

Rollback per transaction %: 0.0 0.0 0.0

Rows per Sort: 2.9 2.9 0.0

Avg DB time per Call (sec): 30.5 26.5 -4.0

	1st per sec	2nd per sec	%Diff	1st per txn	2nd per txn	%Diff
DB time:	1.0	1.0	0.0	0.1	0.4	186.7
CPU time:	1.0	1.0	1.0	0.1	0.4	200.0
Background CPU time:	0.0	0.0	0.0	0.0	0.0	0.0
Redo size (bytes):	13,451,965.5	4,591,945.8	-65.9	1,964,928.4	1,954,991.1	-0.5
Logical read (blocks):	56,797.0	19,367.2	-65.9	8,296.3	8,245.4	-0.6
Block changes:	47,084.7	16,120.4	-65.8	6,877.7	6,863.2	-0.2
Physical read (blocks):	0.0	0.0	0.0	0.0	0.0	0.0
Physical write (blocks):	0.0	0.0	0.0	0.0	0.0	0.0
Read IO requests:	0.0	0.0	0.0	0.0	0.0	0.0
Write IO requests:	0.0	0.0	0.0	0.0	0.0	0.0
Read IO (MB):	0.0	0.0	0.0	0.0	0.0	0.0
Write IO (MB):	0.0	0.0	0.0	0.0	0.0	0.0
IM scan rows:	0.0	0.0	0.0	0.0	0.0	0.0
Session Logical Read IM:	0.0	0.0	0.0	0.0	0.0	0.0
User calls:	0.0	0.0	33.3	0.0	0.0	100.0
Parses (SQL):	0.1	0.1	7.7	0.0	0.1	200.0
Hard parses (SQL):	0.0	0.0	0.0	0.0	0.0	0.0
SQL Work Area (MB):	0.1	0.0	-33.3	0.0	0.0	-33.3
Logons:	0.0	0.0	0.0	0.0	0.0	0.0
Executes (SQL):	6,842.2	2,344.7	-65.7	999.4	998.2	-0.1
Transactions:	6.8	2.3	-65.7

	1st	2nd	Diff
% Blocks changed per Read:	82.9	83.2	0.3
Recursive Call %:	100.0	100.0	-0.0
Rollback per transaction %:	0.0	0.0	0.0
Rows per Sort:	2.9	2.9	0.0
Avg DB time per Call (sec):	30.5	26.5	-4.0

Top Timed Events

Events with a "-" did not make the Top list in this set of snapshots, but are displayed for comparison purposes

1st						2nd
Event	Wait Class	Waits	Time(s)	Avg Time	%DB time	Event	Wait Class	Waits	Time(s)	Avg Time	%DB time
CPU time			1,054.17		98.82	CPU time			978.26		99.69
log file switch (checkpoint incomplete)	Configuration	75	9.88	131.70ms	0.93	undo segment extension	Configuration	71	1.71	24.14ms	0.17
log file switch completion	Configuration	47	1.37	29.04ms	0.13	reliable message	Other	548	0.80	1.45ms	0.08
log file switch (private strand flush incomplete)	Configuration	18	0.72	39.80ms	0.07	log file switch (private strand flush incomplete)	Configuration	31	0.78	25.20ms	0.08
control file parallel write	System I/O	72	0.47	6.46ms	0.04	enq: CR - block range reuse ckpt	Other	2	0.42	208.94ms	0.04
undo segment extension	Configuration	27	0.23	8.34ms	0.02	control file parallel write	System I/O	68	0.34	4.99ms	0.03
reliable message	Other	164	0.14	876.48us	0.01	log file switch (checkpoint incomplete)	Configuration	1	0.02	23.05ms	0.00
db file sequential read	User I/O	15	0.01	720.07us	0.00	log file sync	Commit	1	0.00	2.32ms	0.00
PGA memory operation	Other	192	0.00	12.35us	0.00	buffer busy waits	Concurrency	11	0.00	199.27us	0.00
db file scattered read	User I/O	2	0.00	621.00us	0.00	PGA memory operation	Other	163	0.00	13.33us	0.00
-log file sync	Commit	1	0.00	413.00us	0.00	-db file sequential read	User I/O	8	0.00	17.75us	0.00
-buffer busy waits	Concurrency	3	0.00	36.33us	0.00	-

Supplemental Information

init.ora Parameters
SQL Statements

Time Model Statistics

Ordered by absolute value of 'Diff' column of '% of DB time', descending (DB time statistic first, background statistics last)

Statistic Name	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	%Diff	1st	2nd	%Diff
	% of DB time			% of Total CPU time			Time (seconds)			Time per Trans (seconds)
PL/SQL execution elapsed time	25.36	12.37	-12.99				270.48	121.39	-55.12	0.04	0.05	25.00
DB CPU	98.82	99.69	0.87	100.00	100.00	0.00	1,054.17	978.26	-7.20	0.14	0.42	200.00
sql execute elapsed time	100.00	100.00	-0.00				1,066.72	981.28	-8.01	0.15	0.43	186.67
parse time elapsed	0.00	0.00	0.00				0.02	0.02	0.00	0.00	0.00	0.00
hard parse elapsed time	0.00	0.00	0.00				0.01	0.01	0.00	0.00	0.00	0.00
PL/SQL compilation elapsed time	0.00	0.00	0.00				0.01	0.01	0.00	0.00	0.00	0.00
connection management call elapsed time	0.00	0.00	0.00				0.01	0.01	0.00	0.00	0.00	0.00
repeated bind elapsed time	0.00	0.00	-0.00				0.00	0.00	0.00	0.00	0.00	0.00
DB time							1,066.74	981.32	-8.01	0.15	0.43	186.67
total CPU time	98.82	99.69	0.87				1,054.17	978.26	-7.20	0.14	0.42	194.16

Wait Events

Wait Classes
Wait Events

Wait Classes

Ordered by absolute value of 'Diff' column of '% of DB time' descending

Wait Class	1st	2nd	Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	% of DB time			# Waits/sec (Elapsed Time)			Total Wait Time (sec)			Avg Wait Time
Configuration	1.14	0.26	-0.89	0.16	0.10	-37.50	12.18	2.52	-79.31	72.96ms	24.45ms	-66.49
DB CPU	98.82	99.69	0.87				1,054.17	978.26	-7.20
Other	0.01	0.12	0.11	0.34	0.73	114.71	0.15	1.22	713.33	400.71us	1.69ms	322.50
System I/O	0.04	0.03	-0.01	0.18	0.18	0.00	0.47	0.34	-27.66	2.48ms	1.91ms	-22.98
User I/O	0.00	0.00	-0.00	0.04	0.03	-25.00	0.01	0.00	-100.00	275.85us	33.13us	-89.29
Concurrency	0.00	0.00	0.00	0.01	0.02	100.00	0.00	0.00	0.00	130.13us	228.67us	76.92
Commit	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	413.00us	2.32ms	465.85
Network	0.00	0.00	0.00	0.01	0.01	0.00	0.00	0.00	0.00	923.08ns	1.21us	0.00

Back to Wait Events
Back to Top

Wait Events

Ordered by absolute value of 'Diff' column of '% of DB time' descending (idle events last)

Event	Wait Class	1st	2nd	Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
		% of DB time			# Waits/sec (Elapsed Time)			Total Wait Time (sec)			Avg Wait Time
log file switch (checkpoint incomplete)	Configuration	0.93	0.00	-0.92	0.07	0.00	-100.00	9.88	0.02	-99.80	131.70ms	23.05ms	-82.50
undo segment extension	Configuration	0.02	0.17	0.15	0.03	0.07	133.33	0.23	1.71	643.48	8.34ms	24.14ms	189.45
log file switch completion	Configuration	0.13	0.00	-0.13	0.04	0.00	-100.00	1.37	0.00	-100.00	29.04ms	.00ns	-100.00
reliable message	Other	0.01	0.08	0.07	0.15	0.56	273.33	0.14	0.80	471.43	876.48us	1.45ms	64.77
enq: CR - block range reuse ckpt	Other	0.00	0.04	0.04	0.00	0.00	0.00	0.00	0.42	100.00	.00ns	208.94ms	100.00
log file switch (private strand flush incomplete)	Configuration	0.07	0.08	0.01	0.02	0.03	50.00	0.72	0.78	8.33	39.80ms	25.20ms	-36.68
control file parallel write	System I/O	0.04	0.03	-0.01	0.07	0.07	0.00	0.47	0.34	-27.66	6.46ms	4.99ms	-22.76
db file sequential read	User I/O	0.00	0.00	-0.00	0.01	0.01	0.00	0.01	0.00	-100.00	720.07us	17.75us	-97.22
buffer busy waits	Concurrency	0.00	0.00	0.00	0.00	0.01	100.00	0.00	0.00	0.00	36.33us	199.27us	400.00
log file sync	Commit	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	413.00us	2.32ms	465.85
db file scattered read	User I/O	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	621.00us	.00ns	-100.00
latch: object queue header operation	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	790.00us	.00ns	-100.00
latch free	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	347.00us	.00ns	-100.00
latch: cache buffers chains	Concurrency	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	.00ns	223.00us	100.00
Disk file operations I/O	User I/O	0.00	0.00	-0.00	0.03	0.02	-33.33	0.00	0.00	0.00	38.65us	38.48us	0.00
latch: shared pool	Concurrency	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	231.25us	338.33us	47.83
control file sequential read	System I/O	0.00	0.00	-0.00	0.11	0.11	0.00	0.00	0.00	0.00	8.90us	7.66us	0.00
latch: redo allocation	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	142.00us	84.00us	-42.86
asynch descriptor resize	Other	0.00	0.00	-0.00	0.01	0.01	0.00	0.00	0.00	0.00	7.67us	7.29us	0.00
PGA memory operation	Other	0.00	0.00	-0.00	0.18	0.17	-5.56	0.00	0.00	0.00	12.35us	13.33us	0.00
library cache: mutex X	Concurrency	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	7.00us	.00ns	-100.00
SQL*Net message to client	Network	0.00	0.00	0.00	0.01	0.01	0.00	0.00	0.00	0.00	923.08ns	1.21us	0.00
SQL*Net message from client	Idle	0.00	0.00	0.00	0.01	0.02	100.00	0.01	0.01	0.00	710.07us	819.60us	15.49

Back to Wait Events
Back to Top

Service Statistics

Service Statistics
Service Statistics (RAC)

Service Statistics

Ordered by absolute value of 'Diff' column of '% of DB time' descending
DB time First: 1,066.74 seconds, Second: 981.32 seconds
CPU Time First: 1,054.17 seconds, Second: 978.26 seconds
Physical Reads First: 8, Second: 8
Logical Reads First: 60,696,007, Second: 19,030,472

Service Name	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	Diff
	% of DB time			% CPU Time			% Physical Reads			% Logical Reads
orcl	100.00	100.00	-0.00	99.99	99.99	-0.00	100.00	100.00	0.00	100.00	100.01	0.00

Back to Service Statistics
Back to Top

Service Statistics (RAC)

Ordered by total Diff of '% of CR Blocks Received' and '% of Current Blocks Received'
GC CR Blks Received First: 1, Second: 1
GC CURRENT Blks Received First: 1, Second: 1

Service Name	1st	2nd	Diff	1st	2nd	Diff	Total Diff
	% CR Blks Received			% Current Blks Received
orcl	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Back to Service Statistics
Back to Top

SQL Statistics

Top SQL Comparison by Elapsed Time
Top SQL Comparison by CPU Time
Top SQL Comparison by I/O Time
Top SQL Comparison by Buffer Gets
Top SQL Comparison by Physical Reads
Top SQL Comparison by UnOptimized Read Requests
Top SQL Comparison by Executions
Top SQL Comparison by Parse Calls
Top SQL Comparison by Sharable Memory
Top SQL Comparison by Version Count
Top SQL Comparison by Cluster Wait Time

Top SQL Comparison by Elapsed Time

Ordered by absolute value of 'Diff' column of 'Elapsed Time % of DB time' descending
'#Plans' column indicates the number of distinct execution plans for the statement in 1st and 2nd periods and in Both periods combined
'1st Total' and '2nd Total' show respective running totals for '1st' and '2nd' columns of 'Elapsed Time % of DB time'
DB time First: 1,066.74 seconds, Second: 981.32 seconds
Captured SQL Elapsed Time First: 552.51 seconds, Second: 632.80 seconds
Captured SQL Elapsed Time as a % of DB time First: 51.79%, Second: 64.48%
Captured PL/SQL Elapsed Time as a % of DB time First: 100.18%, Second: 100%
Common SQL Elapsed Time as a % of DB time First: 51.57%, Second: 64.48%

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	1st	2nd	SQL Text
	Elapsed Time % of DB time					Elapsed Time (ms) per Exec		#Exec/sec (DB time)		CPU Time (ms) per Exec		I/O Time (ms) per Exec		Physical Reads per Exec		#Rows Processed per Exec		#Executions		#Plans	Container DB Id
8kpwagy566cc6	51.56	51.56	64.48	64.48	12.91	0	0	6,856.23	2,348.62	0	0	0	0	0.00	0.00	1.00	1.00	7,313,808	2,304,733		4079644691	4079644691	INSERT INTO DELUDING_TAB VALUE...
g6px76dmjv1jy	0.23	51.79			-0.23	2,406		0.00		2,406		0		0.00		1.00		1		1// 1	4079644691		select count(*) from wri$_opts...
3cjmgxvhv3n2p	100.18	151.97	99.99	164.47	-0.19	1,068,672	981,246	0.00	0.00	1,056,034	978,117	0	0	8.00	8.00	0.00	0.00	1	1		4079644691	4079644691	DECLARE TYPE ID_t IS TABLE OF ...
5pj6mtazkhmdd			0.00	164.47	0.00		16		0.00		16		0		0.00		1.00		2			4079644691	BEGIN /* KSXM:FLUSH DML_MON */...
3kqrku32p6sfn			0.00	164.48	0.00		13		0.00		12		0		0.00		0.00		2	/ 1/ 1		4079644691	MERGE /*+ OPT_PARAM('_parallel...
0qbzfjt00pbsx	0.00	151.97			-0.00	1		0.01		1		0		0.00		1.00		9			4079644691		BEGIN dbms_isched.log_dbms_out...
f705bwx3q0ydq	0.00	151.97			-0.00	4		0.00		4		0		0.00		1.00		1		2// 2	4079644691		select count(*) from dba_autot...
730vdzhng6m6g			0.00	164.48	0.00		0		0.01		1		0		0.00		1.00		8	/ 1/ 1		4079644691	update sys.scheduler$_job set ...
0smupm8p2dhq7	0.00	151.97			-0.00	3		0.00		2		0		0.00		1.00		1		1// 1	4079644691		select count(*) num_windows, s...
1k5c5twx2xr01			0.00	164.48	0.00		0		0.01		0		0		0.00		1.00		7			4079644691	insert into sys.scheduler$_job...
gjaap3w3qbf8c	0.00	151.97	0.00	164.48	-0.00	0	0	0.03	0.03	0	0	0	0	0.00	0.00	1.00	1.00	36	34	1/ 1/ 1	4079644691	4079644691	select count(*) from ilmobj$ w...
c3utnxsnrx8tk	0.00	151.97	0.00	164.48	0.00	0	0	0.01	0.01	0	0	0	0	0.00	0.00	1.00	1.00	10	10	1/ 1/ 1	4079644691	4079644691	update obj$ set obj#=:4, type#...
3dbzmtf9ahvzt	0.00	151.97	0.00	164.48	-0.00	0	0	0.02	0.03	0	0	0	0	0.00	0.00	1.00	1.00	26	26	1/ 1/ 1	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
g4gp07gt2z920	0.00	151.98	0.00	164.48	-0.00	1	1	0.01	0.01	1	1	0	0	0.00	0.00	1.00	1.00	9	9	1/ 1/ 1	4079644691	4079644691	update sys.scheduler$_job set ...

Back to SQL Statistics
Back to Top

Top SQL Comparison by CPU Time

Ordered by absolute value of the 'Diff' column of 'CPU % of DB CPU' descending
'#Plans' column indicates the number of distinct execution plans for the statement in 1st and 2nd periods and in Both periods combined
'1st Total' and '2nd Total' show respective running totals for '1st' and '2nd' columns of 'CPU Time % of DB CPU'
Total CPU Time First: 1,054.17 seconds, Second: 978.26 seconds
Captured SQL CPU Time First: 547.26 seconds, Second: 629.29 seconds
Captured SQL as a % of Total CPU First: 51.91%, Second: 64.33%
Captured PL/SQL as a % of Total CPU First: 100.18%, Second: 99.99%
Common SQL as a % of Total CPU First: 51.68%, Second: 64.32%

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	1st	2nd	SQL Text
	CPU Time % of DB CPU					CPU Time (ms) per Exec		I/O Time (ms) per Exec		#Exec/sec (DB time)		Exec Time (ms) per Exec		Physical Reads per Exec		#Rows Processed per Exec		#Plans	Container DB Id
8kpwagy566cc6	51.68	51.68	64.32	64.32	12.64	0	0	0	0	6,856.23	2,348.62	0	0	0.00	0.00	1.00	1.00		4079644691	4079644691	INSERT INTO DELUDING_TAB VALUE...
g6px76dmjv1jy	0.23	51.91			-0.23	2,406		0		0.00		2,406		0.00		1.00		1// 1	4079644691		select count(*) from wri$_opts...
3cjmgxvhv3n2p	100.18	152.09	99.99	164.31	-0.19	1,056,034	978,117	0	0	0.00	0.00	1,068,672	981,246	8.00	8.00	0.00	0.00		4079644691	4079644691	DECLARE TYPE ID_t IS TABLE OF ...
5pj6mtazkhmdd			0.00	164.31	0.00		16		0		0.00		16		0.00		1.00			4079644691	BEGIN /* KSXM:FLUSH DML_MON */...
3kqrku32p6sfn			0.00	164.31	0.00		12		0		0.00		13		0.00		0.00	/ 1/ 1		4079644691	MERGE /*+ OPT_PARAM('_parallel...
0qbzfjt00pbsx	0.00	152.09			-0.00	1		0		0.01		1		0.00		1.00			4079644691		BEGIN dbms_isched.log_dbms_out...
730vdzhng6m6g			0.00	164.31	0.00		1		0		0.01		0		0.00		1.00	/ 1/ 1		4079644691	update sys.scheduler$_job set ...
1gfaj4z5hn1kf	0.00	152.09	0.00	164.31	-0.00	0	0	0	0	0.02	0.02	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	4079644691	4079644691	delete from dependency$ where ...
f705bwx3q0ydq	0.00	152.09			-0.00	4		0		0.00		4		0.00		1.00		2// 2	4079644691		select count(*) from dba_autot...
fs7h3cb49hs7s	0.00	152.09			-0.00	2		0		0.00		0		0.00		1.00		2// 2	4079644691		select count(*) from stats_adv...
gjaap3w3qbf8c	0.00	152.09	0.00	164.31	-0.00	0	0	0	0	0.03	0.03	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	select count(*) from ilmobj$ w...
b9c6ffh8tc71f			0.00	164.31	0.00		0		0		0.01		0		0.00		1.00			4079644691	BEGIN dbms_output.enable(NULL)...
3dbzmtf9ahvzt	0.00	152.09	0.00	164.31	-0.00	0	0	0	0	0.02	0.03	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
c3utnxsnrx8tk	0.00	152.09	0.00	164.32	0.00	0	0	0	0	0.01	0.01	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	update obj$ set obj#=:4, type#...
g4gp07gt2z920	0.00	152.09	0.00	164.32	-0.00	1	1	0	0	0.01	0.01	1	1	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	update sys.scheduler$_job set ...

Back to SQL Statistics
Back to Top

Top SQL Comparison by I/O Time

Ordered by absolute value of 'Diff' column of 'I/O Time % of DB time' descending
'#Plans' column indicates the number of distinct execution plans for the statement in 1st and 2nd periods and in Both periods combined
'1st Total' and '2nd Total' show respective running totals for '1st' and '2nd' columns of 'I/O Time % of DB time'
User I/O Class Wait Time as a % of DB time First: 0%, Second: 0%
Total User I/O Time First: 0.01 seconds, Second: 0.00 seconds
Captured SQL I/O Time First: 0.00 seconds, Second: 0.00 seconds
Captured SQL as a % of Total User I/O First: 1.84%, Second: 31.35%
Captured PL/SQL as a % of Total User I/O First: 6.61%, Second: 31.35%
Common SQL as a % of Total User I/O First: 1.84%, Second: 31.35%

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	1st	2nd	SQL Text
	I/O Time % of DB time					I/O Time (ms) per Exec		Elapsed Time (ms) per Exec		#Exec/sec (DB time)		CPU Time (ms) per Exec		Physical Reads per Exec		#Rows Processed per Exec		#Executions		#Plans	Container DB Id
0qbzfjt00pbsx	0.00	0.00			-0.00	0		1		0.01		1		0.00		1.00		9			4079644691		BEGIN dbms_isched.log_dbms_out...
3cjmgxvhv3n2p	0.00	0.00	0.00	0.00	0.00	0	0	1,068,672	981,246	0.00	0.00	1,056,034	978,117	8.00	8.00	0.00	0.00	1	1		4079644691	4079644691	DECLARE TYPE ID_t IS TABLE OF ...
8kpwagy566cc6	0.00	0.00	0.00	0.00	0.00	0	0	0	0	6,856.23	2,348.62	0	0	0.00	0.00	1.00	1.00	7,313,808	2,304,733		4079644691	4079644691	INSERT INTO DELUDING_TAB VALUE...
0smupm8p2dhq7	0.00	0.00			0.00	0		3		0.00		2		0.00		1.00		1		1// 1	4079644691		select count(*) num_windows, s...
1gfaj4z5hn1kf	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0.02	0.02	0	0	0.00	0.00	0.00	0.00	19	19	1/ 1/ 1	4079644691	4079644691	delete from dependency$ where ...
1k5c5twx2xr01			0.00	0.00	0.00		0		0		0.01		0		0.00		1.00		7			4079644691	insert into sys.scheduler$_job...
20vv6ttajyjzq	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0.02	0.02	0	0	0.00	0.00	0.00	0.00	19	19	1/ 1/ 1	4079644691	4079644691	delete from access$ where d_ob...
2ajc7pwz9jsx3			0.00	0.00	0.00		0		0		0.01		0		0.00		1.00		8	/ 1/ 1		4079644691	select max(scn) from smon_scn_...
340chgpg8x78v	0.00	0.00			0.00	0		0		0.00		0		0.00		1.00		1		1// 1	4079644691		select count(*) from optstat_h...
3dbzmtf9ahvzt	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0.02	0.03	0	0	0.00	0.00	1.00	1.00	26	26	1/ 1/ 1	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
3kqrku32p6sfn			0.00	0.00	0.00		0		13		0.00		12		0.00		0.00		2	/ 1/ 1		4079644691	MERGE /*+ OPT_PARAM('_parallel...
5pj6mtazkhmdd			0.00	0.00	0.00		0		16		0.00		16		0.00		1.00		2			4079644691	BEGIN /* KSXM:FLUSH DML_MON */...
730vdzhng6m6g			0.00	0.00	0.00		0		0		0.01		1		0.00		1.00		8	/ 1/ 1		4079644691	update sys.scheduler$_job set ...
7am4w4pp3nwtm	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0.02	0.02	0	0	0.00	0.00	1.00	1.00	18	17	1/ 1/ 1	4079644691	4079644691	select count(*) from undo$
9sg6u8xys290z	0.00	0.00			0.00	0		3		0.00		3		0.00		1.00		1		1// 1	4079644691		select count(*) num_enabled, s...

Back to SQL Statistics
Back to Top

Top SQL Comparison by Buffer Gets

Ordered by absolute value of 'Diff' column of '% Total Gets' descending
'#Plans' column indicates the number of distinct execution plans for the statement in 1st and 2nd periods and in Both periods combined
'1st Total' and '2nd Total' show respective running totals for '1st' and '2nd' columns of '% Total Gets'
Total SQL Buffer Gets First: 60,696,007, Second: 19,030,472
Captured SQL Buffer Gets First: 60,708,527, Second: 19,036,965
Captured SQL % of Total Buffer Gets First: 100.02%, Second: 100.03%
Common SQL % of Total Buffer Gets First: 100.02%, Second: 100.03%

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	1st	2nd	SQL Text
	% Total Gets					Gets per Exec		#Executions		Exec Time (ms) per Exec		CPU Time (ms) per Exec		I/O Time (ms) per Exec		Physical Reads per Exec		#Rows Processed per Exec		#Plans	Container DB Id
3cjmgxvhv3n2p	100.02	100.02	99.84	99.84	-0.18	60,707,860.00	18,999,449.00	1	1	1,068,672	981,246	1,056,034	978,117	0	0	8.00	8.00	0.00	0.00		4079644691	4079644691	DECLARE TYPE ID_t IS TABLE OF ...
8kpwagy566cc6	100.02	200.04	100.03	199.87	0.01	8.30	8.26	7,313,808	2,304,733	0	0	0	0	0	0	0.00	0.00	1.00	1.00		4079644691	4079644691	INSERT INTO DELUDING_TAB VALUE...
3dbzmtf9ahvzt	0.00	200.04	0.00	199.87	0.00	7.00	7.00	26	26	0	0	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
f705bwx3q0ydq	0.00	200.04			-0.00	279.00		1		4		4		0		0.00		1.00		2// 2	4079644691		select count(*) from dba_autot...
730vdzhng6m6g			0.00	199.87	0.00		10.25		8		0		1		0		0.00		1.00	/ 1/ 1		4079644691	update sys.scheduler$_job set ...
0smupm8p2dhq7	0.00	200.04			-0.00	187.00		1		3		2		0		0.00		1.00		1// 1	4079644691		select count(*) num_windows, s...
5pj6mtazkhmdd			0.00	199.87	0.00		28.00		2		16		16		0		0.00		1.00			4079644691	BEGIN /* KSXM:FLUSH DML_MON */...
g4gp07gt2z920	0.00	200.04	0.00	199.87	0.00	7.00	7.00	9	9	1	1	1	1	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	update sys.scheduler$_job set ...
1k5c5twx2xr01			0.00	199.87	0.00		6.00		7		0		0		0		0.00		1.00			4079644691	insert into sys.scheduler$_job...
1gfaj4z5hn1kf	0.00	200.04	0.00	199.87	0.00	3.00	3.00	19	19	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	4079644691	4079644691	delete from dependency$ where ...
9sg6u8xys290z	0.00	200.04			-0.00	99.00		1		3		3		0		0.00		1.00		1// 1	4079644691		select count(*) num_enabled, s...
c3utnxsnrx8tk	0.00	200.04	0.00	199.87	0.00	4.00	4.00	10	10	0	0	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	update obj$ set obj#=:4, type#...
g6px76dmjv1jy	0.00	200.04			-0.00	87.00		1		2,406		2,406		0		0.00		1.00		1// 1	4079644691		select count(*) from wri$_opts...
20vv6ttajyjzq	0.00	200.04	0.00	199.87	0.00	2.00	2.00	19	19	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	4079644691	4079644691	delete from access$ where d_ob...

Back to SQL Statistics
Back to Top

	% Total Physical Reads	Physical Reads per Exec	#Executions	Exec Time (ms) per Exec	CPU Time (ms) per Exec	I/O Time (ms) per Exec	#Rows Processed per Exec	#Plans	Container DB Id
SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	1st	2nd	SQL Text
0qbzfjt00pbsx	0.00	0.00			0.00	0.00		9		1		1		0		1.00			4079644691		BEGIN dbms_isched.log_dbms_out...
0smupm8p2dhq7	0.00	0.00			0.00	0.00		1		3		2		0		1.00		1// 1	4079644691		select count(*) num_windows, s...
1gfaj4z5hn1kf	0.00	0.00	0.00	0.00	0.00	0.00	0.00	19	19	0	0	0	0	0	0	0.00	0.00	1/ 1/ 1	4079644691	4079644691	delete from dependency$ where ...
1k5c5twx2xr01			0.00	0.00	0.00		0.00		7		0		0		0		1.00			4079644691	insert into sys.scheduler$_job...
20vv6ttajyjzq	0.00	0.00	0.00	0.00	0.00	0.00	0.00	19	19	0	0	0	0	0	0	0.00	0.00	1/ 1/ 1	4079644691	4079644691	delete from access$ where d_ob...
2ajc7pwz9jsx3			0.00	0.00	0.00		0.00		8		0		0		0		1.00	/ 1/ 1		4079644691	select max(scn) from smon_scn_...
340chgpg8x78v	0.00	0.00			0.00	0.00		1		0		0		0		1.00		1// 1	4079644691		select count(*) from optstat_h...
3cjmgxvhv3n2p	100.00	100.00	100.00	100.00	0.00	8.00	8.00	1	1	1,068,672	981,246	1,056,034	978,117	0	0	0.00	0.00		4079644691	4079644691	DECLARE TYPE ID_t IS TABLE OF ...
3dbzmtf9ahvzt	0.00	100.00	0.00	100.00	0.00	0.00	0.00	26	26	0	0	0	0	0	0	1.00	1.00	1/ 1/ 1	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
3kqrku32p6sfn			0.00	100.00	0.00		0.00		2		13		12		0		0.00	/ 1/ 1		4079644691	MERGE /*+ OPT_PARAM('_parallel...
5pj6mtazkhmdd			0.00	100.00	0.00		0.00		2		16		16		0		1.00			4079644691	BEGIN /* KSXM:FLUSH DML_MON */...
730vdzhng6m6g			0.00	100.00	0.00		0.00		8		0		1		0		1.00	/ 1/ 1		4079644691	update sys.scheduler$_job set ...
7am4w4pp3nwtm	0.00	100.00	0.00	100.00	0.00	0.00	0.00	18	17	0	0	0	0	0	0	1.00	1.00	1/ 1/ 1	4079644691	4079644691	select count(*) from undo$
8kpwagy566cc6	100.00	200.00	100.00	200.00	0.00	0.00	0.00	7,313,808	2,304,733	0	0	0	0	0	0	1.00	1.00		4079644691	4079644691	INSERT INTO DELUDING_TAB VALUE...
9sg6u8xys290z	0.00	200.00			0.00	0.00		1		3		3		0		1.00		1// 1	4079644691		select count(*) num_enabled, s...

	% Total UnOptimized Read Requests	Read Requests per Exec	Total Read Requests	%Optimized Reads	#Executions	Exec Time (ms) per Exec	CPU Time (ms) per Exec	I/O Time (ms) per Exec	#Rows Processed per Exec	#Plans	Container DB Id
SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	1st	2nd	SQL Text
0qbzfjt00pbsx	0.00	0.00			0.00	0.00		0				9		1		1		0		1.00			4079644691		BEGIN dbms_isched.log_dbms_out...
0smupm8p2dhq7	0.00	0.00			0.00	0.00		0				1		3		2		0		1.00		1// 1	4079644691		select count(*) num_windows, s...
1gfaj4z5hn1kf	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0	0			19	19	0	0	0	0	0	0	0.00	0.00	1/ 1/ 1	4079644691	4079644691	delete from dependency$ where ...
1k5c5twx2xr01			0.00	0.00	0.00		0.00		0				7		0		0		0		1.00			4079644691	insert into sys.scheduler$_job...
20vv6ttajyjzq	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0	0			19	19	0	0	0	0	0	0	0.00	0.00	1/ 1/ 1	4079644691	4079644691	delete from access$ where d_ob...
2ajc7pwz9jsx3			0.00	0.00	0.00		0.00		0				8		0		0		0		1.00	/ 1/ 1		4079644691	select max(scn) from smon_scn_...
340chgpg8x78v	0.00	0.00			0.00	0.00		0				1		0		0		0		1.00		1// 1	4079644691		select count(*) from optstat_h...
3cjmgxvhv3n2p	100.00	100.00	100.00	100.00	0.00	8.00	8.00	8	8	0.00	0.00	1	1	1,068,672	981,246	1,056,034	978,117	0	0	0.00	0.00		4079644691	4079644691	DECLARE TYPE ID_t IS TABLE OF ...
3dbzmtf9ahvzt	0.00	100.00	0.00	100.00	0.00	0.00	0.00	0	0			26	26	0	0	0	0	0	0	1.00	1.00	1/ 1/ 1	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
3kqrku32p6sfn			0.00	100.00	0.00		0.00		0				2		13		12		0		0.00	/ 1/ 1		4079644691	MERGE /*+ OPT_PARAM('_parallel...
5pj6mtazkhmdd			0.00	100.00	0.00		0.00		0				2		16		16		0		1.00			4079644691	BEGIN /* KSXM:FLUSH DML_MON */...
730vdzhng6m6g			0.00	100.00	0.00		0.00		0				8		0		1		0		1.00	/ 1/ 1		4079644691	update sys.scheduler$_job set ...
7am4w4pp3nwtm	0.00	100.00	0.00	100.00	0.00	0.00	0.00	0	0			18	17	0	0	0	0	0	0	1.00	1.00	1/ 1/ 1	4079644691	4079644691	select count(*) from undo$
8kpwagy566cc6	100.00	200.00	100.00	200.00	0.00	0.00	0.00	8	8	0.00	0.00	7,313,808	2,304,733	0	0	0	0	0	0	1.00	1.00		4079644691	4079644691	INSERT INTO DELUDING_TAB VALUE...
9sg6u8xys290z	0.00	200.00			0.00	0.00		0				1		3		3		0		1.00		1// 1	4079644691		select count(*) num_enabled, s...

Top SQL Comparison by Executions

Ordered by 'Diff' column of '#Executions/sec (DB time)' descending
'#Plans' column indicates the number of distinct execution plans for the statement in 1st and 2nd periods and in Both periods, combined
Captured SQL Executions First: 7,314,024, Second: 2,304,958
Captured SQL Elapsed Time First: 552.51 seconds, Second: 632.80 seconds
Captured SQL Elapsed Time as a % of DB time First: 51.79%, Second: 64.48%
Captured SQL Executions as a % of Total Executions First: 100.03%, Second: 100.04%
Common SQL Executions as a % of Total Executions First: 100.03%, Second: 100.04%

SQL Id	1st	2nd	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	1st	2nd	SQL Text
	#Executions/sec (DB time)			#Executions		Exec Time (ms) per Exec		CPU Time (ms) per Exec		I/O Time (ms) per Exec		Physical Reads per Exec		#Rows Processed per Exec		#Plan	Container DB Id
8kpwagy566cc6	6,856.23	2,348.62	-4,507.62	7,313,808	2,304,733	0	0	0	0	0	0	0.00	0.00	1.00	1.00		4079644691	4079644691	INSERT INTO DELUDING_TAB VALUE...
b9c6ffh8tc71f		0.01	0.01		9		0		0		0		0.00		1.00			4079644691	BEGIN dbms_output.enable(NULL)...
0qbzfjt00pbsx	0.01		-0.01	9		1		1		0		0.00		1.00			4079644691		BEGIN dbms_isched.log_dbms_out...
3dbzmtf9ahvzt	0.02	0.03	0.00	26	26	0	0	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
1gfaj4z5hn1kf	0.02	0.02	0.00	19	19	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	4079644691	4079644691	delete from dependency$ where ...
20vv6ttajyjzq	0.02	0.02	0.00	19	19	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	4079644691	4079644691	delete from access$ where d_ob...
gjaap3w3qbf8c	0.03	0.03	0.00	36	34	0	0	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	select count(*) from ilmobj$ w...
c3utnxsnrx8tk	0.01	0.01	0.00	10	10	0	0	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	update obj$ set obj#=:4, type#...
7am4w4pp3nwtm	0.02	0.02	0.00	18	17	0	0	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	4079644691	4079644691	select count(*) from undo$
f3yqgm464ygss	0.03	0.03	-0.00	36	33	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	4079644691	4079644691	SELECT /*+ NO_STATEMENT_QUEUIN...
fjfm1sbw3k2y6	0.03	0.03	-0.00	36	33	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	4079644691	4079644691	SELECT /*+ NO_STATEMENT_QUEUIN...

Back to SQL Statistics
Back to Top

Top SQL Comparison by Parse Calls

Ordered by absolute value of 'Diff' column of '% Total Parses' descending
'#Plans' column indicates the number of distinct execution plans for the statement in 1st and 2nd periods and in Both periods, combined
'1st Total' and '2nd Total' show respective running totals for '1st' and '2nd' columns of '% Total Parses'
Total Parse Time as a % of DB time First: 0%, Second: 0%
Total Parses First: 142, Second: 141
Captured SQL Parses First: 216, Second: 225
Captured SQL Parses % of Total Parses First: 152.11%, Second: 159.57%
Common SQL Parses % of Total Parses First: 147.18%, Second: 141.84%

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st/2nd/Both	1st	2nd	SQL Text
	% Total Parses					Parses		#Executions		#Plans	Container DB Id
b9c6ffh8tc71f			6.38	6.38	6.38		9		9			4079644691	BEGIN dbms_output.enable(NULL)...
0qbzfjt00pbsx	6.34	6.34			-6.34	9		9			4079644691		BEGIN dbms_isched.log_dbms_out...
f3yqgm464ygss	25.35	31.69	23.40	29.79	-1.95	36	33	36	33	1/ 1/ 1	4079644691	4079644691	SELECT /*+ NO_STATEMENT_QUEUIN...
fjfm1sbw3k2y6	25.35	57.04	23.40	53.19	-1.95	36	33	36	33	1/ 1/ 1	4079644691	4079644691	SELECT /*+ NO_STATEMENT_QUEUIN...
gjaap3w3qbf8c	25.35	82.39	24.11	77.30	-1.24	36	34	36	34	1/ 1/ 1	4079644691	4079644691	select count(*) from ilmobj$ w...
7am4w4pp3nwtm	12.68	95.07	12.06	89.36	-0.62	18	17	18	17	1/ 1/ 1	4079644691	4079644691	select count(*) from undo$
3dbzmtf9ahvzt	18.31	113.38	18.44	107.80	0.13	26	26	26	26	1/ 1/ 1	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
1gfaj4z5hn1kf	13.38	126.76	13.48	121.28	0.09	19	19	19	19	1/ 1/ 1	4079644691	4079644691	delete from dependency$ where ...
20vv6ttajyjzq	13.38	140.14	13.48	134.75	0.09	19	19	19	19	1/ 1/ 1	4079644691	4079644691	delete from access$ where d_ob...
c3utnxsnrx8tk	6.34	146.48	6.38	141.13	0.04	9	9	10	10	1/ 1/ 1	4079644691	4079644691	update obj$ set obj#=:4, type#...
g4gp07gt2z920	6.34	152.82	6.38	147.52	0.04	9	9	9	9	1/ 1/ 1	4079644691	4079644691	update sys.scheduler$_job set ...

Back to SQL Statistics
Back to Top

Top SQL Comparison by Sharable Memory

SQL Statements appearing in the End Snapshot are compared
'Sharable Memory Used' is computed for the End Snapshot
'Sharable Memory Max' is computed for the whole interval
Ordered by absolute value of 'Diff' column of '% Total Sharable Memory' descending
'1st Total' and '2nd Total' show respective running totals for '1st' and '2nd' columns of '% Total Sharable Memory'
Shared Pool at End Snapshot First: 1,633,113,376, Second: 1,632,598,680

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	SQL Text
	% Total Sharable Memory					Sharable Memory Used		Sharable Memory Max		#Executions		Container DB Id
f705bwx3q0ydq	0.05	0.05			-0.05	777,548		777,548		1		4079644691		select count(*) from dba_autot...
9sg6u8xys290z	0.03	0.07			-0.03	422,753		422,753		1		4079644691		select count(*) num_enabled, s...
0smupm8p2dhq7	0.02	0.09			-0.02	345,718		345,718		1		4079644691		select count(*) num_windows, s...
3kqrku32p6sfn			0.01	0.01	0.01		244,822		244,822		2		4079644691	MERGE /*+ OPT_PARAM('_parallel...
fs7h3cb49hs7s	0.01	0.10			-0.01	97,748		97,748		2		4079644691		select count(*) from stats_adv...
340chgpg8x78v	0.01	0.11			-0.01	85,028		85,028		1		4079644691		select count(*) from optstat_h...
g6px76dmjv1jy	0.01	0.11			-0.01	82,244		82,244		1		4079644691		select count(*) from wri$_opts...
b9c6ffh8tc71f			0.00	0.02	0.00		63,125		63,125		9		4079644691	BEGIN dbms_output.enable(NULL)...
730vdzhng6m6g			0.00	0.02	0.00		44,805		44,805		8		4079644691	update sys.scheduler$_job set ...
1k5c5twx2xr01			0.00	0.02	0.00		36,781		36,781		7		4079644691	insert into sys.scheduler$_job...
5pj6mtazkhmdd			0.00	0.03	0.00		32,646		32,646		2		4079644691	BEGIN /* KSXM:FLUSH DML_MON */...
c3utnxsnrx8tk	0.01	0.12	0.01	0.03	0.00	127,594	127,594	127,594	127,594	10	10	4079644691	4079644691	update obj$ set obj#=:4, type#...
3dbzmtf9ahvzt	0.01	0.13	0.01	0.04	0.00	117,812	117,812	117,812	117,812	26	26	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
1gfaj4z5hn1kf	0.00	0.13	0.00	0.04	0.00	46,344	46,344	46,344	46,344	19	19	4079644691	4079644691	delete from dependency$ where ...
20vv6ttajyjzq	0.00	0.13	0.00	0.05	0.00	46,340	46,340	46,340	46,340	19	19	4079644691	4079644691	delete from access$ where d_ob...
g4gp07gt2z920	0.00	0.13	0.00	0.05	0.00	36,537	36,537	36,537	36,537	9	9	4079644691	4079644691	update sys.scheduler$_job set ...

Back to SQL Statistics
Back to Top

Top SQL Comparison by Version Count

SQL Statements appearing in the End Snapshot are compared
'Version Count' is computed for the End Snapshot
'Version Count Max' is computed for the whole interval
Ordered by absolute value of 'Diff' column of 'Version Count' descending

SQL Id	1st	2nd	Diff	1st	2nd	1st	2nd	1st	2nd	SQL Text
	Version Count			Version Count Max		#Executions		Container DB Id
fs7h3cb49hs7s	12		-12	12		2		4079644691		select count(*) from stats_adv...
340chgpg8x78v	6		-6	6		1		4079644691		select count(*) from optstat_h...
f705bwx3q0ydq	6		-6	6		1		4079644691		select count(*) from dba_autot...
b9c6ffh8tc71f		4	4		4		9		4079644691	BEGIN dbms_output.enable(NULL)...
0smupm8p2dhq7	3		-3	3		1		4079644691		select count(*) num_windows, s...
9sg6u8xys290z	3		-3	3		1		4079644691		select count(*) num_enabled, s...
g6px76dmjv1jy	3		-3	3		1		4079644691		select count(*) from wri$_opts...
1k5c5twx2xr01		2	2		2		7		4079644691	insert into sys.scheduler$_job...
3kqrku32p6sfn		2	2		2		2		4079644691	MERGE /*+ OPT_PARAM('_parallel...
5pj6mtazkhmdd		2	2		2		2		4079644691	BEGIN /* KSXM:FLUSH DML_MON */...
730vdzhng6m6g		2	2		2		8		4079644691	update sys.scheduler$_job set ...
1gfaj4z5hn1kf	4	4	0	4	4	19	19	4079644691	4079644691	delete from dependency$ where ...
20vv6ttajyjzq	4	4	0	4	4	19	19	4079644691	4079644691	delete from access$ where d_ob...
3dbzmtf9ahvzt	4	4	0	4	4	26	26	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
7am4w4pp3nwtm	2	2	0	2	2	18	17	4079644691	4079644691	select count(*) from undo$
c3utnxsnrx8tk	3	3	0	3	3	10	10	4079644691	4079644691	update obj$ set obj#=:4, type#...

Back to SQL Statistics
Back to Top

Top SQL Comparison by Cluster Wait Time

Ordered by absolute value of 'Diff' column of '% Total Cluster Wait' descending
'#Plans' column indicates the number of distinct execution plans for the statement in 1st and 2nd periods and in Both periods, combined
'1st Total' and '2nd Total' show respective running totals for '1st' and '2nd' columns of '% Total Cluster Wait'
DB time First: 1,066.74 seconds, Second: 981.32 seconds
Cluster Wait Time First: 0.00 seconds, Second: 0.00 seconds
Cluster Wait Time as a % of DB time First: %, Second: %

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	1st	2nd	SQL Text
	% Total Cluster Wait					Cluster Wait Time (sec)		Cluster Wait Time per Exec (sec)		#Executions		#Plans	Container DB Id
0qbzfjt00pbsx	0.00	0.00			0.00	0.00		0.00		9			4079644691		BEGIN dbms_isched.log_dbms_out...
0smupm8p2dhq7	0.00	0.00			0.00	0.00		0.00		1		1// 1	4079644691		select count(*) num_windows, s...
1gfaj4z5hn1kf	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	19	19	1/ 1/ 1	4079644691	4079644691	delete from dependency$ where ...
1k5c5twx2xr01			0.00	0.00	0.00		0.00		0.00		7			4079644691	insert into sys.scheduler$_job...
20vv6ttajyjzq	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	19	19	1/ 1/ 1	4079644691	4079644691	delete from access$ where d_ob...
2ajc7pwz9jsx3			0.00	0.00	0.00		0.00		0.00		8	/ 1/ 1		4079644691	select max(scn) from smon_scn_...
340chgpg8x78v	0.00	0.00			0.00	0.00		0.00		1		1// 1	4079644691		select count(*) from optstat_h...
3cjmgxvhv3n2p	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1	1		4079644691	4079644691	DECLARE TYPE ID_t IS TABLE OF ...
3dbzmtf9ahvzt	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	26	26	1/ 1/ 1	4079644691	4079644691	merge /* KSXM:OPTIM_DML_INF */...
3kqrku32p6sfn			0.00	0.00	0.00		0.00		0.00		2	/ 1/ 1		4079644691	MERGE /*+ OPT_PARAM('_parallel...
5pj6mtazkhmdd			0.00	0.00	0.00		0.00		0.00		2			4079644691	BEGIN /* KSXM:FLUSH DML_MON */...
730vdzhng6m6g			0.00	0.00	0.00		0.00		0.00		8	/ 1/ 1		4079644691	update sys.scheduler$_job set ...
7am4w4pp3nwtm	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	18	17	1/ 1/ 1	4079644691	4079644691	select count(*) from undo$
8kpwagy566cc6	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	7,313,808	2,304,733		4079644691	4079644691	INSERT INTO DELUDING_TAB VALUE...
9sg6u8xys290z	0.00	0.00			0.00	0.00		0.00		1		1// 1	4079644691		select count(*) num_enabled, s...

Back to SQL Statistics
Back to Top

IO Stats

IOStat by File Type
Tablespace IO Stats
Top File Comparison by IO
Top File Comparison by Read Time
Top File Comparison by Buffer Waits

IOStat by File Type

Ordered by absolute value of IOs per Sec %Diff, 'Total' first

Filetype Name	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd
	Total Requests			IOs per Sec			Reads/s		Writes/s		Total MB			MB per Sec			Read MB/s		Write MB/s		Small Rd Svc Tm		Large Rd Svc Tm
Total	1,035,364	251,849	-75.68	968.85	256.30	-73.55	0.38	0.13	968.47	256.17	10,828	3,201	-70.44	10.13	3.26	-67.82	0.00	0.00	10.13	3.26	27.03us	.00ns		.00ns
Data File	1,035,364	251,849	-75.68	968.85	256.30	-73.55	0.38	0.13	968.47	256.17	10,828	3,201	-70.44	10.13	3.26	-67.82	0.00	0.00	10.13	3.26	27.03us	.00ns		.00ns

Back to IO Stats
Back to Top

Tablespace IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

Top File Comparison by IO

No data exists for this section of the report.

Back to IO Stats
Back to Top

Top File Comparison by Buffer Waits

No data exists for this section of the report.

Back to IO Stats
Back to Top

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
	0.00	0	0	0	0/0	0/0	0/0/0/0/0/0
	0.00	0	0	0	0/0	0/0	0/0/0/0/0/0

Latch Wait Time Breakdown

Ordered by absolute value of 'Diff' Column of 'Wait Time (cs)' descending

Latch Name	1st	2nd	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	Diff
	Wait Time (cs)			Get Requests		Misses		Spin Gets		Sleeps		% of Total Sleeps
space background task latch	36,849	10,500	-26,349	476	390	58	23	20	9	39	14	557.14	280.00	-277.14
undo global data	-12,575	12,575	25,150	12,364,750	-12,522,136	-7	8	-3	4	-4	4	-57.14	80.00	137.14
undo global data	12,575	-12,575	-25,150	-10,691,485	13,045,579	7	-7	3	-3	4	-4	57.14	-80.00	-137.14
undo global data	12,575	0	-12,575	-10,691,485	522,077	7	1	3	1	4	0	57.14	0.00	-57.14
undo global data	0	12,575	12,575	1,671,626	-12,522,136	0	8	0	4	0	4	0.00	80.00	80.00
undo global data	12,575	0	-12,575	-10,691,485	1,366	7	0	3	0	4	0	57.14	0.00	-57.14
undo global data	0	12,575	12,575	1,639	-12,522,136	0	8	0	4	0	4	0.00	80.00	80.00
redo allocation	3,494	500	-2,994	72,607	29,034	244	44	236	42	8	2	114.29	40.00	-74.29
object queue header operation	790	0	-790	5,988,874	1,964,650	234	23	233	23	1	0	14.29	0.00	-14.29
session statistics	687	0	-687	737	598	2	0	1	0	1	0	14.29	0.00	-14.29
simulator lru latch	797	199	-598	1,385,427	410,381	402	38	396	37	6	1	85.71	20.00	-65.71
active service list	568	0	-568	104,679	96,124	20	5	18	5	2	0	28.57	0.00	-28.57
shared pool	1,096	1,540	444	7,368,569	2,343,041	990	332	985	328	5	4	71.43	80.00	8.57
cache buffers chains	0	410	410	203,264,338	64,137,232	13	8	13	6	0	2	0.00	40.00	40.00
messages	357	0	-357	72,030	38,247	12	4	10	4	2	0	28.57	0.00	-28.57
lgwr LWN SCN	347	0	-347	8,876	2,808	4	0	3	0	1	0	14.29	0.00	-14.29
cache buffers lru chain	243	0	-243	1,385,763	411,712	300	27	297	27	3	0	42.86	0.00	-42.86
post/wait queue	113	0	-113	3,642	2,508	9	4	8	4	1	0	14.29	0.00	-14.29
call allocation	165	254	89	1,207	1,018	17	6	16	5	1	1	14.29	20.00	5.71
undo global data	12,575	12,575	0	-10,691,485	-12,522,136	7	8	3	4	4	4	57.14	80.00	22.86

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Only explicitly set parameters are included
Parameters values for the Begin Snapshot are shown only if they differ from those for the End snapshot
Parameters values for the second period are shown only if they differ from those for the first period
Value '(DEFAULT)' indicates that parameter was not set for the period

Parameter Name	Begin Snap Value	End Snap Value	Begin Snap Value	PDB Name
	1st Period		2nd Period
_ash_size		25165824
audit_file_dest		/u01/app/oracle/admin/orcl12c/ad
audit_trail		DB
compatible		12.2.0
connection_brokers		((TYPE=DEDICATED)(BROKERS=1)), (
control_files		/u01/app/oracle/oradata/orcl12c/
db_block_size		8192
db_name		orcl12c
db_recovery_file_dest		/u01/app/oracle/fast_recovery_ar
db_recovery_file_dest_size		5368709120
diagnostic_dest		/u01/app/oracle
dispatchers		(PROTOCOL=TCP) (SERVICE=orcl12cX
enable_pluggable_database		TRUE
local_listener		LISTENER_ORCL12C
max_string_size		EXTENDED
nls_language		AMERICAN
nls_territory		AMERICA
open_cursors		300
pga_aggregate_limit		6442450944
pga_aggregate_target		3221225472
plsql_warnings		DISABLE:ALL
processes		300
remote_login_passwordfile		EXCLUSIVE
sga_max_size		10737418240
sga_target		0		ORCL
sga_target		10737418240
shared_pool_size		0		ORCL
shared_pool_size		2147483648
shared_servers		25
undo_tablespace		UNDOTBS1		ORCL
undo_tablespace		UNDOTBS2

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

This section only displays parameters that have more one value
Only explicitly set parameters are included
Parameters values for the Begin Snapshot are shown only if they differ from those for the End snapshot
Parameters values for the second period are shown only if they differ from those for the first period
Value '(DEFAULT)' indicates that parameter was not set for the period
Value '(NULL)' in the Begin/End snapshot indicates that the parameter value was not set for that period

Parameter Name	Begin Snap Value	End Snap Value	Begin Snap Value
	1st Period		2nd Period
control_files		/u01/app/oracle/fast_recovery_area/orcl12c/control02.ctl
control_files		/u01/app/oracle/oradata/orcl12c/control01.ctl

Back to init.ora Parameters
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0qbzfjt00pbsx BEGIN dbms_isched.log_dbms_output( :logid, :errs, :outputWasEnabled ); END;

0smupm8p2dhq7 select count(*) num_windows, sum(case when jobs_started<>jobs_completed then 1 else 0 end) num_jobs_incomplete from dba_autotask_client_history where client_name = 'auto optimizer stats collection'

1gfaj4z5hn1kf delete from dependency$ where d_obj#=:1

1k5c5twx2xr01 insert into sys.scheduler$_job_run_details (log_id, log_date, req_start_date, start_date, run_duration, instance_id, session_id, slave_pid, cpu_used, error#, additional_info) values (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7, numtodsinterval(:8/100, 'second'), :9, :10)

20vv6ttajyjzq delete from access$ where d_obj#=:1

2ajc7pwz9jsx3 select max(scn) from smon_scn_time

340chgpg8x78v select count(*) from optstat_hist_control$ where sname = :1 and spare4 = :2

3cjmgxvhv3n2p DECLARE TYPE ID_t IS TABLE OF deluding_tab.id%TYPE INDEX BY PLS_INTEGER; TYPE FOO_t IS TABLE OF deluding_tab.foo%TYPE INDEX BY PLS_INTEGER; TYPE BAR_t IS TABLE OF deluding_tab.bar%TYPE INDEX BY PLS_INTEGER; TYPE FOOBAR_t IS TABLE OF deluding_tab.foobar%TYPE INDEX BY PLS_INTEGER; TYPE TYPECODE_t IS TABLE OF deluding_tab.type_code%TYPE INDEX BY PLS_INTEGER; TYPE VALBEGIN_DATE_t IS TABLE OF deluding_tab.validated_begin_date%TYPE INDEX BY PLS_INTEGER; TYPE VALEND_DATE_t IS TABLE OF deluding_tab.validated_end_date%TYPE INDEX BY PLS_INTEGER; IDs ID_t; FOOs FOO_t; BARs BAR_t; FOOBARs FOOBAR_t; TYPECODEs TYPECODE_t; VALBEGIN_DATEs VALBEGIN_DATE_t; VALEND_DATEs VALEND_DATE_t; k PLS_INTEGER := 1; BEGIN FOR i IN 1..8000000 LOOP IDs(k) := TO_CHAR(i, 'FM0000000000000000'); FOOs(k) := 'FOO-'||IDs(k); BARs(k) := RPAD('BAR-'||IDs(k), 320, '-'); FOOBARs(k) := RPAD('FOOBAR-'||IDs(k), 500, '*'); TYPEC ODEs(k) := TO_CHAR(MOD(i, 3), 'FM000'); VALBEGIN_DATEs(k) := TO_DATE('20180101', 'yyyymmdd'); --??????????????????????????? VALEND_DATEs(k) := TO_DATE('20180630', 'yyyymmdd'); --??????????????????????????? k := k + 1; IF MOD(i, 1000) = 0 THEN FOR l in 1..1000 LOOP INSERT INTO deluding_tab VALUES( IDs(l) , FOOs(l) , BARs(l) , FOOBARs(l) , TYPECODEs(l) , VALBEGIN_DATEs(l) , VALEND_DATEs(l) ); END LOOP; COMMIT; k := 1; END IF; END LOOP; END;

3dbzmtf9ahvzt 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 ts p.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

3kqrku32p6sfn MERGE /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ INTO OPTSTAT_USER_PREFS$ D USING ( SELECT * FROM (SELECT O.OBJ#, SYSTIMESTAMP CHGTIME, ROUND(MAX(S.DELTA_READ_IO_BYTES/S.DELTA_TIME), 3) SCANRATE FROM GV$ACTIVE_SESSION_HISTORY S, GV$SQL_PLAN P, OBJ$ O, USER$ U WHERE S.INST_ID = P.INST_ID AND S.SQL_ID = P.SQL_ID AND S.SQL_PLAN_HASH_VALUE = P.PLAN_HASH_VALUE AND S.SQL_PLAN_LINE_ID = P.ID AND P.OBJECT_NAME = O.NAME AND (:B4 IS NULL OR O.OBJ# = :B4 ) AND O.OWNER# = U.USER# AND P.OBJECT_OWNER = U.NAME AND O.TYPE# = 2 AND S.CON_ID = SYS_CONTEXT('userenv', 'con_id') AND P.CON_ID = SYS_CONTEXT('userenv', 'con_id') AND S.SQL_PLAN_OPERATION = 'TABLE ACCESS' AND P.OPERATION = 'TABLE ACCESS' AND S.DELTA_TIME > 0 AND S.DELTA_READ_IO_BYTES > 0 AND FROM_TZ(S.SAMPLE_TIME, :B3 ) > :B2 AND (:B1 = 'ON' OR (:B1 = 'HADOOP_ONLY' AND EXISTS ( SELECT NULL FROM SYS.EXTERNAL_TAB$ ET WHERE ET.OBJ# = O.OBJ# AND TYPE$ IN ('ORACLE_HIVE', 'ORACLE_HDFS', 'ORACLE_BIGDATA')))) GROUP BY O .OBJ#) C WHERE NOT EXISTS (SELECT NULL FROM OPTSTAT_USER_PREFS$ PR WHERE PNAME = 'SCAN_RATE' AND C.OBJ# = PR.OBJ# AND (PR.SPARE1 IS NULL OR C.SCANRATE <= TO_NUMBER(PR.VALCHAR))) ) SRC ON (D.OBJ#=SRC.OBJ# AND D.PNAME = 'SCAN_RATE') WHEN MATCHED THEN UPDATE SET D.VALCHAR= TO_CHAR(SRC.SCANRATE), D.CHGTIME=SRC.CHGTIME, D.SPARE1=1 WHEN NOT MATCHED THEN INSERT (OBJ#, PNAME, VALCHAR, CHGTIME, SPARE1) VALUES(SRC.OBJ#, 'SCAN_RATE', TO_CHAR(SRC.SCANRATE), SRC.CHGTIME, 1)

5pj6mtazkhmdd BEGIN /* KSXM:FLUSH DML_MON */ dbms_stats_internal.gather_scan_rate_by_mmon; END;

730vdzhng6m6g update sys.scheduler$_job set next_run_date = :1, last_end_date = :2, retry_count = :3, run_count = :4, running_instance = :5, running_slave = :6, job_status = :7 where obj# = :8

7am4w4pp3nwtm select count(*) from undo$

8kpwagy566cc6 INSERT INTO DELUDING_TAB VALUES( :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 )

9sg6u8xys290z select count(*) num_enabled, sum(case optimizer_stats when 'ENABLED' then 1 else 0 end) stats_enabled from dba_autotask_window_clients where autotask_status = 'ENABLED'

b9c6ffh8tc71f BEGIN dbms_output.enable(NULL); END;

c3utnxsnrx8tk update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14, spare3=:15, signature=:16, spare7=:17, spare8=:18, spare9=:19, dflcollid=decode(:20, 0, null, :20), creappid=:21, creverid=:22, modappid=:23, modverid=:24, crepatchid=:25, modpatchid=:26 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

f3yqgm464ygss SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=FALSE) */ JOB, LAST_DATE, THIS_DATE, NEXT_DATE, FIELD1 FROM "SYS"."JOB$_REDUCED" "JOB$_REDUCED" WHERE 1=1

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

fjfm1sbw3k2y6 SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=FALSE) */ JOB, NEXT_DATE, FIELD1 FROM "SYS"."JOB$_REDUCED" "JOB$_REDUCED" WHERE 1=1

fs7h3cb49hs7s select count(*) from stats_advisor_filter_obj$ where rule_id = :rule_id and type = :type_expanded

g4gp07gt2z920 update sys.scheduler$_job set last_start_date = :1, running_instance = :2, running_slave = :3, job_status = :4 where obj# = :5

g6px76dmjv1jy select count(*) from wri$_optstat_opr o, wri$_optstat_opr_tasks t where o.id = t.op_id(+) and o.operation = 'gather_database_stats (auto)' and (not regexp_like( extract(xmltype('<notes>' || o.notes || '</notes>'), '//error'), '^<error>ORA-200[0-9][0-9]') or not regexp_like( extract(xmltype('<notes>' || t.notes || '</notes>'), '//error'), '^<error>ORA-200[0-9][0-9]'))

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

SQL Id	SQL Text
0qbzfjt00pbsx	BEGIN dbms_isched.log_dbms_output( :logid, :errs, :outputWasEnabled ); END;
0smupm8p2dhq7	select count(*) num_windows, sum(case when jobs_started<>jobs_completed then 1 else 0 end) num_jobs_incomplete from dba_autotask_client_history where client_name = 'auto optimizer stats collection'
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
1k5c5twx2xr01	insert into sys.scheduler$_job_run_details (log_id, log_date, req_start_date, start_date, run_duration, instance_id, session_id, slave_pid, cpu_used, error#, additional_info) values (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7, numtodsinterval(:8/100, 'second'), :9, :10)
20vv6ttajyjzq	delete from access$ where d_obj#=:1
2ajc7pwz9jsx3	select max(scn) from smon_scn_time
340chgpg8x78v	select count(*) from optstat_hist_control$ where sname = :1 and spare4 = :2
3cjmgxvhv3n2p	DECLARE TYPE ID_t IS TABLE OF deluding_tab.id%TYPE INDEX BY PLS_INTEGER; TYPE FOO_t IS TABLE OF deluding_tab.foo%TYPE INDEX BY PLS_INTEGER; TYPE BAR_t IS TABLE OF deluding_tab.bar%TYPE INDEX BY PLS_INTEGER; TYPE FOOBAR_t IS TABLE OF deluding_tab.foobar%TYPE INDEX BY PLS_INTEGER; TYPE TYPECODE_t IS TABLE OF deluding_tab.type_code%TYPE INDEX BY PLS_INTEGER; TYPE VALBEGIN_DATE_t IS TABLE OF deluding_tab.validated_begin_date%TYPE INDEX BY PLS_INTEGER; TYPE VALEND_DATE_t IS TABLE OF deluding_tab.validated_end_date%TYPE INDEX BY PLS_INTEGER; IDs ID_t; FOOs FOO_t; BARs BAR_t; FOOBARs FOOBAR_t; TYPECODEs TYPECODE_t; VALBEGIN_DATEs VALBEGIN_DATE_t; VALEND_DATEs VALEND_DATE_t; k PLS_INTEGER := 1; BEGIN FOR i IN 1..8000000 LOOP IDs(k) := TO_CHAR(i, 'FM0000000000000000'); FOOs(k) := 'FOO-'\|\|IDs(k); BARs(k) := RPAD('BAR-'\|\|IDs(k), 320, '-'); FOOBARs(k) := RPAD('FOOBAR-'\|\|IDs(k), 500, '*'); TYPEC ODEs(k) := TO_CHAR(MOD(i, 3), 'FM000'); VALBEGIN_DATEs(k) := TO_DATE('20180101', 'yyyymmdd'); --??????????????????????????? VALEND_DATEs(k) := TO_DATE('20180630', 'yyyymmdd'); --??????????????????????????? k := k + 1; IF MOD(i, 1000) = 0 THEN FOR l in 1..1000 LOOP INSERT INTO deluding_tab VALUES( IDs(l) , FOOs(l) , BARs(l) , FOOBARs(l) , TYPECODEs(l) , VALBEGIN_DATEs(l) , VALEND_DATEs(l) ); END LOOP; COMMIT; k := 1; END IF; END LOOP; END;
3dbzmtf9ahvzt	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 ts p.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
3kqrku32p6sfn	MERGE /+ OPT_PARAM('_parallel_syspls_obey_force' 'false') / INTO OPTSTAT_USER_PREFS$ D USING ( SELECT * FROM (SELECT O.OBJ#, SYSTIMESTAMP CHGTIME, ROUND(MAX(S.DELTA_READ_IO_BYTES/S.DELTA_TIME), 3) SCANRATE FROM GV$ACTIVE_SESSION_HISTORY S, GV$SQL_PLAN P, OBJ$ O, USER$ U WHERE S.INST_ID = P.INST_ID AND S.SQL_ID = P.SQL_ID AND S.SQL_PLAN_HASH_VALUE = P.PLAN_HASH_VALUE AND S.SQL_PLAN_LINE_ID = P.ID AND P.OBJECT_NAME = O.NAME AND (:B4 IS NULL OR O.OBJ# = :B4 ) AND O.OWNER# = U.USER# AND P.OBJECT_OWNER = U.NAME AND O.TYPE# = 2 AND S.CON_ID = SYS_CONTEXT('userenv', 'con_id') AND P.CON_ID = SYS_CONTEXT('userenv', 'con_id') AND S.SQL_PLAN_OPERATION = 'TABLE ACCESS' AND P.OPERATION = 'TABLE ACCESS' AND S.DELTA_TIME > 0 AND S.DELTA_READ_IO_BYTES > 0 AND FROM_TZ(S.SAMPLE_TIME, :B3 ) > :B2 AND (:B1 = 'ON' OR (:B1 = 'HADOOP_ONLY' AND EXISTS ( SELECT NULL FROM SYS.EXTERNAL_TAB$ ET WHERE ET.OBJ# = O.OBJ# AND TYPE$ IN ('ORACLE_HIVE', 'ORACLE_HDFS', 'ORACLE_BIGDATA')))) GROUP BY O .OBJ#) C WHERE NOT EXISTS (SELECT NULL FROM OPTSTAT_USER_PREFS$ PR WHERE PNAME = 'SCAN_RATE' AND C.OBJ# = PR.OBJ# AND (PR.SPARE1 IS NULL OR C.SCANRATE <= TO_NUMBER(PR.VALCHAR))) ) SRC ON (D.OBJ#=SRC.OBJ# AND D.PNAME = 'SCAN_RATE') WHEN MATCHED THEN UPDATE SET D.VALCHAR= TO_CHAR(SRC.SCANRATE), D.CHGTIME=SRC.CHGTIME, D.SPARE1=1 WHEN NOT MATCHED THEN INSERT (OBJ#, PNAME, VALCHAR, CHGTIME, SPARE1) VALUES(SRC.OBJ#, 'SCAN_RATE', TO_CHAR(SRC.SCANRATE), SRC.CHGTIME, 1)
5pj6mtazkhmdd	BEGIN /* KSXM:FLUSH DML_MON */ dbms_stats_internal.gather_scan_rate_by_mmon; END;
730vdzhng6m6g	update sys.scheduler$_job set next_run_date = :1, last_end_date = :2, retry_count = :3, run_count = :4, running_instance = :5, running_slave = :6, job_status = :7 where obj# = :8
7am4w4pp3nwtm	select count(*) from undo$
8kpwagy566cc6	INSERT INTO DELUDING_TAB VALUES( :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 )
9sg6u8xys290z	select count(*) num_enabled, sum(case optimizer_stats when 'ENABLED' then 1 else 0 end) stats_enabled from dba_autotask_window_clients where autotask_status = 'ENABLED'
b9c6ffh8tc71f	BEGIN dbms_output.enable(NULL); END;
c3utnxsnrx8tk	update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14, spare3=:15, signature=:16, spare7=:17, spare8=:18, spare9=:19, dflcollid=decode(:20, 0, null, :20), creappid=:21, creverid=:22, modappid=:23, modverid=:24, crepatchid=:25, modpatchid=:26 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
f3yqgm464ygss	SELECT /+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=FALSE) / JOB, LAST_DATE, THIS_DATE, NEXT_DATE, FIELD1 FROM "SYS"."JOB$_REDUCED" "JOB$_REDUCED" WHERE 1=1
f705bwx3q0ydq	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)
fjfm1sbw3k2y6	SELECT /+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=FALSE) / JOB, NEXT_DATE, FIELD1 FROM "SYS"."JOB$_REDUCED" "JOB$_REDUCED" WHERE 1=1
fs7h3cb49hs7s	select count(*) from stats_advisor_filter_obj$ where rule_id = :rule_id and type = :type_expanded
g4gp07gt2z920	update sys.scheduler$_job set last_start_date = :1, running_instance = :2, running_slave = :3, job_status = :4 where obj# = :5
g6px76dmjv1jy	select count(*) from wri$_optstat_opr o, wri$_optstat_opr_tasks t where o.id = t.op_id(+) and o.operation = 'gather_database_stats (auto)' and (not regexp_like( extract(xmltype('<notes>' \|\| o.notes \|\| '</notes>'), '//error'), '^<error>ORA-200[0-9][0-9]') or not regexp_like( extract(xmltype('<notes>' \|\| t.notes \|\| '</notes>'), '//error'), '^<error>ORA-200[0-9][0-9]'))
gjaap3w3qbf8c	select count(*) from ilmobj$ where rownum = 1

WORKLOAD REPOSITORY COMPARE PERIOD REPORT (root snapshots)

Report Summary

Top Timed Events

Report Details

Supplemental Information

Time Model Statistics

Wait Events

Wait Classes

Wait Events

Service Statistics

Service Statistics

Service Statistics (RAC)

SQL Statistics

Top SQL Comparison by Elapsed Time

Top SQL Comparison by CPU Time

Top SQL Comparison by I/O Time

Top SQL Comparison by Buffer Gets

Top SQL Comparison by Physical Reads

Top SQL Comparison by UnOptimized Read Requests

Top SQL Comparison by Executions

Top SQL Comparison by Parse Calls

Top SQL Comparison by Sharable Memory

Top SQL Comparison by Version Count

Top SQL Comparison by Cluster Wait Time

IO Stats

IOStat by File Type

Tablespace IO Stats

Top File Comparison by IO

Top File Comparison by Read Time

Top File Comparison by Buffer Waits

Undo Segment Summary

Latch Wait Time Breakdown

init.ora Parameters

init.ora Parameters

init.ora Multi-Valued Parameters

Complete List of SQL Text