WORKLOAD REPOSITORY COMPARE PERIOD REPORT

Snapshot Set DB Name DB Id Instance Inst num Release Cluster Host Std Block Size

First (1st) PCOE 409011274 PCOE 1 11.2.0.1.0 NO LABM3PCOEDB16.devlab.ad 8192

Second (2nd) PCOE 409011274 PCOE 1 11.2.0.1.0 NO LABM3PCOEDB16.devlab.ad 8192

Snapshot Set	DB Name	DB Id	Instance	Inst num	Release	Cluster	Host	Std Block Size
First (1st)	PCOE	409011274	PCOE	1	11.2.0.1.0	NO	LABM3PCOEDB16.devlab.ad	8192
Second (2nd)	PCOE	409011274	PCOE	1	11.2.0.1.0	NO	LABM3PCOEDB16.devlab.ad	8192

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

1st 2521 10-May-11 15:00:05 (Tue) 2524 10-May-11 18:00:11 (Tue) 0.81 180.10 146.43

2nd 2533 11-May-11 03:00:49 (Wed) 2536 11-May-11 06:00:51 (Wed) 7.22 180.03 1,299.33

%Diff 791.36 -0.04 787.34

Snapshot Set	Begin Snap Id	Begin Snap Time	End Snap Id	End Snap Time	Avg Active Users	Elapsed Time (min)	DB time (min)
1st	2521	10-May-11 15:00:05 (Tue)	2524	10-May-11 18:00:11 (Tue)	0.81	180.10	146.43
2nd	2533	11-May-11 03:00:49 (Wed)	2536	11-May-11 06:00:51 (Wed)	7.22	180.03	1,299.33
%Diff					791.36	-0.04	787.34

Host Configuration Comparison

	1st	2nd	Diff	%Diff
Number of CPUs:	16	16	0	0.0
Number of CPU Cores:	8	8	0	0.0
Number of CPU Sockets:	2	2	0	0.0
Physical Memory:	16047.8M	16047.8M	0M	0.0
Load at Start Snapshot:	2.66	3.08	.42	15.8
Load at End Snapshot:	.76	1.11	.35	46.1
%User Time:	2.73	1.97	-.76	-27.8
%System Time:	.86	.74	-.12	-14.0
%Idle Time:	96.32	97.19	.88	0.9
%IO Wait Time:	2.77	6.33	3.56	128.5

Cache Sizes

	1st (M)	2nd (M)
Memory Target	6,464.0	6,464.0
.....SGA Target	4,224.0	4,224.0
..........Buffer Cache	2,816.0	2,816.0
..........Shared Pool	1,152.0	1,152.0
..........Large Pool	64.0	64.0
..........Java Pool	64.0	64.0
..........Streams Pool	64.0	64.0
.....PGA Target	2,240.0	2,240.0
Log Buffer	31.9	31.9

Load Profile

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

DB time: 0.81 7.22 791.36 0.42 6.00 1,328.57

CPU time: 0.48 0.34 -29.17 0.25 0.29 16.00

Redo size: 5,503,084.11 3,764,074.23 -31.60 2,810,967.82 3,127,401.96 11.26

Logical reads: 84,452.48 55,853.32 -33.86 43,138.21 46,406.04 7.58

Block changes: 62,315.38 42,446.32 -31.88 31,830.61 35,266.76 10.80

Physical reads: 119.86 80.78 -32.60 61.22 67.12 9.64

Physical writes: 566.61 377.90 -33.31 289.42 313.98 8.49

User calls: 44.12 28.87 -34.56 22.54 23.98 6.39

Parses: 18.94 12.80 -32.42 9.68 10.63 9.81

Hard parses: 0.10 0.05 -50.00 0.05 0.04 -20.00

W/A MB processed: 1,668,301.69 1,030,487.76 -38.23 852,166.22 856,186.48 -38.23

Logons: 0.12 0.12 0.00 0.06 0.10 66.67

Executes: 36.29 26.03 -28.27 18.54 21.62 16.61

Transactions: 1.96 1.20 -38.78

1st 2nd Diff

% Blocks changed per Read: 73.79 76.00 2.21

Recursive Call %: 50.57 59.20 8.64

Rollback per transaction %: 0.00 0.00 0.00

Rows per Sort: 53.05 36.85 -16.20

Avg DB time per Call (sec): 0.02 0.25 0.23

	1st per sec	2nd per sec	%Diff	1st per txn	2nd per txn	%Diff
DB time:	0.81	7.22	791.36	0.42	6.00	1,328.57
CPU time:	0.48	0.34	-29.17	0.25	0.29	16.00
Redo size:	5,503,084.11	3,764,074.23	-31.60	2,810,967.82	3,127,401.96	11.26
Logical reads:	84,452.48	55,853.32	-33.86	43,138.21	46,406.04	7.58
Block changes:	62,315.38	42,446.32	-31.88	31,830.61	35,266.76	10.80
Physical reads:	119.86	80.78	-32.60	61.22	67.12	9.64
Physical writes:	566.61	377.90	-33.31	289.42	313.98	8.49
User calls:	44.12	28.87	-34.56	22.54	23.98	6.39
Parses:	18.94	12.80	-32.42	9.68	10.63	9.81
Hard parses:	0.10	0.05	-50.00	0.05	0.04	-20.00
W/A MB processed:	1,668,301.69	1,030,487.76	-38.23	852,166.22	856,186.48	-38.23
Logons:	0.12	0.12	0.00	0.06	0.10	66.67
Executes:	36.29	26.03	-28.27	18.54	21.62	16.61
Transactions:	1.96	1.20	-38.78

	1st	2nd	Diff
% Blocks changed per Read:	73.79	76.00	2.21
Recursive Call %:	50.57	59.20	8.64
Rollback per transaction %:	0.00	0.00	0.00
Rows per Sort:	53.05	36.85	-16.20
Avg DB time per Call (sec):	0.02	0.25	0.23

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(ms)	%DB time	Event	Wait Class	Waits	Time(s)	Avg Time(ms)	%DB time
CPU time			5,209.47		59.29	free buffer waits	Configuration	22,251	52,442.79	2,356.87	67.27
db file sequential read	User I/O	1,190,865	3,168.62	2.66	36.07	db file async I/O submit	System I/O	10,794	17,226.55	1,595.94	22.10
db file async I/O submit	System I/O	27,926	2,836.86	101.59	32.29	log file sync	Commit	12,409	9,775.34	787.76	12.54
log file parallel write	System I/O	138,828	1,218.51	8.78	13.87	log buffer space	Configuration	3,958	6,946.75	1,755.12	8.91
log file sync	Commit	20,400	377.25	18.49	4.29	db file sequential read	User I/O	757,206	4,185.99	5.53	5.37
-log buffer space	Configuration	88	21.36	242.74	0.24	-CPU time			3,719.99		4.77
-						-log file parallel write	System I/O	45,984	3,694.72	80.35	4.74

Report Details

Time Model Statistics
Operating System Statistics
Wait Events
Service Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Advisory Statistics
Wait Stats
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Libarary Cache Statistics
Memory Statistics
Streams Statistics
Shared Server Statistics

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
	% of DB time			Time (seconds)			Time per Trans (seconds)
DB time	100.00	100.00	0.00	8,785.78	77,959.73	787.34	0.42	6.00	1,328.57
DB CPU	59.29	4.77	-54.52	5,209.47	3,719.99	-28.59	0.25	0.29	16.00
sql execute elapsed time	95.24	87.29	-7.95	8,367.80	68,050.87	713.25	0.40	5.23	1,207.50
connection management call elapsed time	0.16	0.79	0.63	13.92	612.30	4,298.71	0.00	0.05	100.00
parse time elapsed	0.45	0.02	-0.42	39.33	19.17	-51.26	0.00	0.00	0.00
hard parse elapsed time	0.37	0.02	-0.35	32.70	15.05	-53.98	0.00	0.00	0.00
hard parse (sharing criteria) elapsed time	0.03	0.00	-0.03	2.76	0.63	-77.17	0.00	0.00	0.00
PL/SQL compilation elapsed time	0.02	0.00	-0.02	1.48	0.29	-80.41	0.00	0.00	0.00
hard parse (bind mismatch) elapsed time	0.01	0.00	-0.01	0.58	0.08	-86.21	0.00	0.00	0.00
PL/SQL execution elapsed time	0.09	0.09	-0.00	8.19	69.93	753.85	0.00	0.01	100.00
sequence load elapsed time	0.00	0.00	0.00	0.01	2.42	24,100.00	0.00	0.00	0.00
repeated bind elapsed time	0.00	0.00	-0.00	0.02	0.01	-50.00	0.00	0.00	0.00
failed parse elapsed time	0.00	0.00	-0.00	0.01	0.01	0.00	0.00	0.00	0.00
Java execution elapsed time	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
RMAN cpu time (backup/restore)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
failed parse (out of shared memory) elapsed time	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
inbound PL/SQL rpc elapsed time	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
background elapsed time	47.67	28.09	-19.58	4,188.40	21,900.83	422.89	0.20	1.68	740.00
background cpu time	3.10	0.29	-2.81	272.48	226.32	-16.94	0.01	0.02	100.00

Operating System Statistics

Ordered by 'Statistic Name'

Statistic Name	1st	2nd	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Value (centi-seconds)		per Second (DB time)			per Second (Elapsed Time)			per Trans
BUSY_TIME	636,977	485,199	72.50	6.22	-91.42	58.95	44.92	-23.80	30.11	37.32	23.95
GLOBAL_RECEIVE_SIZE_MAX	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
GLOBAL_SEND_SIZE_MAX	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
IDLE_TIME	16,648,824	16,783,381	1,894.97	215.28	-88.64	1,540.71	1,553.74	0.85	786.99	1,290.93	64.03
IOWAIT_TIME	478,955	1,092,808	54.51	14.02	-74.28	44.32	101.17	128.27	22.64	84.06	271.29
NICE_TIME	846	890	0.10	0.01	-90.00	0.08	0.08	0.00	0.04	0.07	75.00
RSRC_MGR_CPU_WAIT_TIME	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
SYS_TIME	148,422	126,986	16.89	1.63	-90.35	13.74	11.76	-14.41	7.02	9.77	39.17
TCP_RECEIVE_SIZE_DEFAULT	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
TCP_RECEIVE_SIZE_MAX	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
TCP_RECEIVE_SIZE_MIN	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
TCP_SEND_SIZE_DEFAULT	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
TCP_SEND_SIZE_MAX	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
TCP_SEND_SIZE_MIN	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
USER_TIME	471,619	339,940	53.68	4.36	-91.88	43.64	31.47	-27.89	22.29	26.15	17.32

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 (ms)
Configuration	0.31	76.76	76.45	0.03	2.46	8,100.00	27.06	59,842.46	221,047.30	75.38	2,252.17	2,887.76
User I/O	36.40	5.45	-30.95	110.96	70.83	-36.17	3,198.14	4,249.08	32.86	2.67	5.55	107.87
System I/O	46.35	27.08	-19.27	20.21	10.47	-48.19	4,072.12	21,110.47	418.41	18.65	186.65	900.80
Commit	4.29	12.54	8.25	1.89	1.15	-39.15	377.25	9,775.34	2,491.21	18.49	787.76	4,160.47
Concurrency	0.10	0.98	0.87	0.07	0.17	142.86	9.01	760.23	8,337.62	11.31	411.83	3,541.29
Network	0.39	0.03	-0.36	86.91	54.53	-37.26	34.57	25.15	-27.25	0.04	0.04	0.00
Application	0.01	0.07	0.07	0.07	0.07	0.00	0.55	56.17	10,112.73	0.70	71.91	10,172.86
Other	0.01	0.01	0.00	2.12	4.35	105.19	1.14	11.24	885.96	0.05	0.24	380.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 (ms)
free buffer waits	Configuration	0.00	67.27	67.27	0.00	2.06	100.00	0.00	52,442.79	100.00	0.00	2,356.87	100.00
db file sequential read	User I/O	36.07	5.37	-30.70	110.20	70.10	-36.39	3,168.62	4,185.99	32.11	2.66	5.53	107.89
db file async I/O submit	System I/O	32.29	22.10	-10.19	2.58	1.00	-61.24	2,836.86	17,226.55	507.24	101.59	1,595.94	1,470.96
log file parallel write	System I/O	13.87	4.74	-9.13	12.85	4.26	-66.85	1,218.51	3,694.72	203.22	8.78	80.35	815.15
log buffer space	Configuration	0.24	8.91	8.67	0.01	0.37	3,600.00	21.36	6,946.75	32,422.24	242.74	1,755.12	623.05
log file sync	Commit	4.29	12.54	8.25	1.89	1.15	-39.15	377.25	9,775.34	2,491.21	18.49	787.76	4,160.47
buffer busy waits	Concurrency	0.00	0.96	0.96	0.03	0.09	200.00	0.01	750.96	7,509,500.00	0.03	806.61	2,688,600.00
log file switch (private strand flush incomplete)	Configuration	0.04	0.49	0.45	0.00	0.01	100.00	3.75	383.12	10,116.53	75.00	3,166.27	4,121.69
SQL*Net more data from client	Network	0.36	0.03	-0.33	20.71	14.05	-32.16	31.50	23.40	-25.71	0.14	0.15	7.14
db file parallel read	User I/O	0.10	0.01	-0.10	0.04	0.03	-25.00	9.13	5.23	-42.72	22.94	14.51	-36.75
db file scattered read	User I/O	0.15	0.05	-0.09	0.48	0.49	2.08	13.05	42.62	226.59	2.49	8.02	222.09
os thread startup	Concurrency	0.10	0.01	-0.09	0.04	0.04	0.00	8.91	9.11	2.24	21.56	22.11	2.55
write complete waits	Configuration	0.00	0.09	0.09	0.00	0.00	0.00	0.00	68.09	100.00	0.00	17,021.50	100.00
enq: KO - fast object checkpoint	Application	0.01	0.07	0.07	0.00	0.00	0.00	0.48	56.10	11,587.50	80.70	18,701.05	23,073.54
direct path read	User I/O	0.07	0.01	-0.06	0.04	0.02	-50.00	5.94	5.83	-1.85	13.56	26.60	96.17
control file parallel write	System I/O	0.18	0.24	0.06	0.58	0.53	-8.62	16.25	187.20	1,052.00	2.62	32.73	1,149.24
SQL*Net more data to client	Network	0.03	0.00	-0.03	22.57	12.12	-46.30	2.59	1.41	-45.56	0.01	0.01	0.00
undo segment extension	Configuration	0.02	0.00	-0.01	0.02	0.02	0.00	1.40	1.51	7.86	6.38	6.44	0.94
enq: JD - contention	Other	0.00	0.01	0.01	0.00	0.00	0.00	0.00	7.98	100.00	0.00	7,984.80	100.00
Disk file operations I/O	User I/O	0.01	0.00	-0.01	0.15	0.15	0.00	0.90	1.00	11.11	0.57	0.63	10.53
direct path write temp	User I/O	0.00	0.01	0.01	0.00	0.00	0.00	0.00	6.12	100.00	0.51	156.80	30,645.10
log file switch completion	Configuration	0.01	0.00	-0.01	0.00	0.00	0.00	0.55	0.20	-63.64	546.68	100.68	-81.58
SQL*Net message to client	Network	0.01	0.00	-0.01	43.63	28.36	-35.00	0.48	0.34	-29.17	0.00	0.00	0.00
ADR block file read	Other	0.01	0.00	-0.00	0.01	0.01	0.00	0.46	0.50	8.70	3.16	3.38	6.96
reliable message	Other	0.00	0.00	-0.00	0.07	0.08	14.29	0.40	0.83	107.50	0.54	0.99	83.33
db file single write	User I/O	0.01	0.00	-0.00	0.04	0.03	-25.00	0.46	2.05	345.65	1.04	7.15	587.50
control file sequential read	System I/O	0.00	0.00	-0.00	4.18	4.67	11.72	0.38	1.27	234.21	0.01	0.03	200.00
rdbms ipc reply	Other	0.00	0.00	-0.00	0.07	0.08	14.29	0.17	0.20	17.65	0.24	0.24	0.00
latch: redo allocation	Other	0.00	0.00	0.00	0.01	0.66	6,500.00	0.01	0.84	8,300.00	0.09	0.12	33.33
latch: shared pool	Concurrency	0.00	0.00	-0.00	0.00	0.00	0.00	0.09	0.12	33.33	5.77	7.76	34.49
SQL*Net break/reset to client	Application	0.00	0.00	-0.00	0.07	0.07	0.00	0.06	0.06	0.00	0.08	0.08	0.00
latch: cache buffers lru chain	Other	0.00	0.00	0.00	0.00	0.71	100.00	0.00	0.39	100.00	0.08	0.05	-37.50
log file single write	System I/O	0.00	0.00	-0.00	0.01	0.01	0.00	0.12	0.72	500.00	0.92	8.56	830.43
asynch descriptor resize	Other	0.00	0.00	-0.00	1.88	1.40	-25.53	0.04	0.03	-25.00	0.00	0.00	0.00
SGA: allocation forcing component growth	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.02	0.00	-100.00	22.90	0.00	-100.00
latch free	Other	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.21	100.00	0.12	5.65	4,608.33
enq: CF - contention	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.02	0.00	-100.00	16.78	0.00	-100.00
buffer deadlock	Other	0.00	0.00	0.00	0.00	1.09	100.00	0.00	0.13	100.00	0.00	0.01	100.00
enq: PR - contention	Other	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.05	100.00	0.00	24.35	100.00
LGWR wait for redo copy	Other	0.00	0.00	-0.00	0.07	0.04	-42.86	0.01	0.01	0.00	0.01	0.03	200.00
cr request retry	Other	0.00	0.00	0.00	0.00	0.24	100.00	0.00	0.03	100.00	0.00	0.01	100.00
ADR block file write	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.11	0.11	0.00
direct path sync	User I/O	0.00	0.00	-0.00	0.00	0.00	0.00	0.03	0.20	566.67	6.45	51.20	693.80
latch: call allocation	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.12	0.10	-16.67
latch: cache buffers chains	Concurrency	0.00	0.00	0.00	0.00	0.04	100.00	0.00	0.04	100.00	0.06	0.09	50.00
ADR file lock	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.03	0.01	-66.67
direct path write	User I/O	0.00	0.00	-0.00	0.00	0.00	0.00	0.01	0.04	300.00	1.19	2.17	82.35
Parameter File I/O	User I/O	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.06	0.00	-100.00
log file sequential read	System I/O	0.00	0.00	-0.00	0.01	0.01	0.00	0.00	0.00	0.00	0.01	0.01	0.00
latch: undo global data	Other	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.01	100.00	0.11	0.25	127.27
read by other session	User I/O	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.01	100.00	0.00	5.06	100.00
latch: object queue header operation	Other	0.00	0.00	-0.00	0.00	0.01	100.00	0.00	0.00	0.00	0.05	0.04	-20.00
lock deadlock retry	Other	0.00	0.00	0.00	0.00	0.02	100.00	0.00	0.00	0.00	0.00	0.01	100.00
direct path read temp	User I/O	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.06	0.08	33.33
latch: In memory undo latch	Concurrency	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.39	100.00
library cache: mutex X	Concurrency	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.02	0.02	0.00
SQL*Net message from client	Idle	1,837.08	359.93	-1,477.15	43.68	28.42	-34.94	161,401.73	280,602.21	73.85	341.91	913.97	167.31
DIAG idle wait	Idle	245.79	27.68	-218.11	2.00	2.00	0.00	21,594.22	21,579.79	-0.07	1,000.94	1,000.92	-0.00
jobq slave wait	Idle	126.75	14.50	-112.25	2.06	2.09	1.46	11,135.68	11,302.90	1.50	500.64	500.66	0.00
Streams AQ: qmn slave idle wait	Idle	123.06	13.87	-109.19	0.04	0.04	0.00	10,811.49	10,811.48	-0.00	28,009.03	28,009.02	-0.00
Streams AQ: qmn coordinator idle wait	Idle	123.06	13.87	-109.19	0.07	0.07	0.00	10,811.48	10,811.48	0.00	14,004.51	14,004.51	0.00
Space Manager: slave idle wait	Idle	122.99	13.85	-109.14	0.20	0.20	0.00	10,805.69	10,798.40	-0.07	4,993.39	4,992.33	-0.02
wait for unread message on broadcast channel	Idle	122.96	13.84	-109.12	1.01	1.01	0.00	10,802.98	10,792.61	-0.10	985.85	987.52	0.17
Streams AQ: waiting for messages in the queue	Idle	122.95	13.84	-109.11	0.20	0.20	0.00	10,801.82	10,785.96	-0.15	5,000.84	4,981.97	-0.38
shared server idle wait	Idle	122.93	13.85	-109.08	0.03	0.03	0.00	10,800.53	10,800.60	0.00	30,001.47	30,001.66	0.00
Streams AQ: waiting for time management or cleanup tasks	Idle	19.13	15.15	-3.98	0.00	0.01	100.00	1,681.02	11,813.33	602.75	280,170.19	187,513.24	-33.07
class slave wait	Idle	0.00	0.00	-0.00	0.01	0.01	0.00	0.01	0.01	0.00	0.12	0.12	0.00

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: 8,785.78 seconds, Second: 77,959.73 seconds
CPU Time First: 5,209.47 seconds, Second: 3,719.99 seconds
Physical Reads First: 1,295,195, Second: 872,574
Logical Reads First: 912,588,870, Second: 603,324,895

Service Name	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	Diff
	% of DB time			% CPU Time			% Physical Reads			% Logical Reads
SYS$USERS	99.85	98.89	-0.96	99.86	99.76	-0.10	99.48	94.05	-5.43	99.97	99.68	-0.29
PCOE	0.19	1.11	0.92	0.14	0.23	0.09	0.11	0.09	-0.02	0.02	0.03	0.01
PCOEXDB	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
SYS$BACKGROUND	0.00	0.00	0.00	0.00	0.00	0.00	0.43	5.95	5.52	0.01	0.24	0.23

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
PCOE	0.00	0.00	0.00	0.00	0.00	0.00	0.00
PCOEXDB	0.00	0.00	0.00	0.00	0.00	0.00	0.00
SYS$BACKGROUND	0.00	0.00	0.00	0.00	0.00	0.00	0.00
SYS$USERS	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: 8,785.78 seconds, Second: 77,959.73 seconds
Captured SQL Elapsed Time First: 8,066.93 seconds, Second: 66,669.95 seconds
Captured SQL Elapsed Time as a % of DB time First: 91.82%, Second: 85.52%
Captured PL/SQL Elapsed Time as a % of DB time First: .06%, Second: .7%
Common SQL Elapsed Time as a % of DB time First: 91.7%, Second: 84.11%

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	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
g9588ypf0j5g3	17.74	17.74	40.25	40.25	22.51	30	1,112	5.83	0.36	30	48	0	0	0.02	0.20	2,118.34	2,611.22	51,250	28,224	1/ 1/ 1	delete from CDM_TMP_OBJID
fqu4btx1ywxy9	14.50	32.24	29.24	69.49	14.75	10	276	14.13	1.06	10	11	0	2	0.00	0.10	873.01	893.93	124,112	82,650		insert into CDM_TMP_OBJID valu...
6xqy3yrv5fqqw	14.46	46.69	4.11	73.60	-10.35	13,231	47,133	0.01	0.00	213	205	13,067	24,305	2,477.44	2,513.91	897.08	873.76	96	68		INSERT INTO CDM_ROOT_1 (CMDB_I...
6quh2na3y0syy	6.55	53.24	1.53	75.13	-5.02	11,280	35,039	0.01	0.00	209	203	11,108	18,971	2,661.20	2,483.03	879.53	859.00	51	34		INSERT INTO CDM_COMPOSITION_1 ...
249asvswu45wf	5.36	58.60	0.34	75.47	-5.02	1,289	1,265	0.04	0.00	1,289	1,264	0	0	0.00	0.00	61,299.48	61,132.00	365	209	1/ 1/ 1	SELECT WINDOWS_SERVICE_1.CMDB_...
6xf2bjhv3f20a	6.90	65.50	3.06	78.53	-3.84	2,835	17,808	0.02	0.00	88	87	2,759	5,115	1,000.49	886.50	894.83	883.82	214	134		INSERT INTO HIST_EVENTS(ID, OB...
105mn0xguw39u	3.43	68.93	0.21	78.74	-3.22	825	822	0.04	0.00	824	822	0	0	0.00	0.00	61,132.00	61,132.00	365	200	1/ 1/ 1	SELECT WINDOWS_SERVICE_1.CMDB_...
b7kc4z2qun912	2.77	71.70	0.20	78.94	-2.58	1,340	1,479	0.02	0.00	1,339	1,371	0	0	0.00	0.00	91,085.18	91,078.16	182	104	1/ 1/ 1	SELECT PROCESS_1.CMDB_ID FROM ...
1jqdcpkxcjggj	3.79	75.50	1.67	80.61	-2.12	1,199	8,352	0.03	0.00	27	28	1,177	2,331	198.71	215.47	959.27	951.42	278	156		INSERT INTO HIST_INF_STR(ID, O...
3h3974yx3tr81	1.92	77.42	0.13	80.74	-1.79	921	1,559	0.02	0.00	920	916	0	0	0.00	0.00	91,085.57	91,078.10	183	63	1/ 1/ 1	SELECT PROCESS_1.CMDB_ID FROM ...
0w1majm70d0tx	1.45	78.86	0.32	81.05	-1.13	70	240	0.21	0.01	69	73	0	0	0.00	0.00	236.99	236.67	1,827	1,026	1/ 1/ 1	SELECT WINOSUSER_1.CMDB_ID, WI...
fnncar3ndasgu	1.83	80.70	0.84	81.89	-0.99	1,269	8,413	0.01	0.00	26	30	1,249	3,374	309.17	349.56	337.51	379.62	127	78		INSERT INTO CDM_LIST_ATTR_PRIM...
5y8amc3t0chff	0.71	81.41	0.46	82.36	-0.25	2,078	20,030	0.00	0.00	472	493	1,659	2,561	7,585.80	7,919.67	3,284.07	3,300.89	30	18	1/ 1/ 1	DELETE FROM CDM_ROOT_1 WHERE E...

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: 5,209.47 seconds, Second: 3,719.99 seconds
Captured SQL CPU Time First: 4,946.99 seconds, Second: 3,559.13 seconds
Captured SQL as a % of Total CPU First: 94.96%, Second: 95.68%
Captured PL/SQL as a % of Total CPU First: .04%, Second: .32%
Common SQL as a % of Total CPU First: 94.84%, Second: 94.2%

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	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
g9588ypf0j5g3	29.45	29.45	36.42	36.42	6.97	30	48	0	0	5.83	0.36	30	1,112	0.02	0.20	2,118.34	2,611.22	1/ 1/ 1	delete from CDM_TMP_OBJID
249asvswu45wf	9.03	38.48	7.10	43.52	-1.93	1,289	1,264	0	0	0.04	0.00	1,289	1,265	0.00	0.00	61,299.48	61,132.00	1/ 1/ 1	SELECT WINDOWS_SERVICE_1.CMDB_...
3h3974yx3tr81	3.23	41.71	1.55	45.07	-1.68	920	916	0	0	0.02	0.00	921	1,559	0.00	0.00	91,085.57	91,078.10	1/ 1/ 1	SELECT PROCESS_1.CMDB_ID FROM ...
fqu4btx1ywxy9	23.84	65.55	25.31	70.38	1.47	10	11	0	2	14.13	1.06	10	276	0.00	0.10	873.01	893.93		insert into CDM_TMP_OBJID valu...
105mn0xguw39u	5.78	71.33	4.42	74.80	-1.36	824	822	0	0	0.04	0.00	825	822	0.00	0.00	61,132.00	61,132.00	1/ 1/ 1	SELECT WINDOWS_SERVICE_1.CMDB_...
b7kc4z2qun912	4.68	76.01	3.83	78.63	-0.85	1,339	1,371	0	0	0.02	0.00	1,340	1,479	0.00	0.00	91,085.18	91,078.16	1/ 1/ 1	SELECT PROCESS_1.CMDB_ID FROM ...
ddtxm9882qb62	3.19	79.20	2.60	81.23	-0.59	913	922	0	0	0.02	0.00	914	922	0.00	0.00	2,568.00	2,568.00	1/ 1/ 1	SELECT INSTALLED_SOFTWARE_1.CM...
0w1majm70d0tx	2.44	81.63	2.00	83.24	-0.44	69	73	0	0	0.21	0.01	70	240	0.00	0.00	236.99	236.67	1/ 1/ 1	SELECT WINOSUSER_1.CMDB_ID, WI...
c6m1m1bhzj4p6	1.88	83.51	1.48	84.72	-0.39	537	541	0	0	0.02	0.00	537	541	0.00	0.00	2,568.00	2,568.00	1/ 1/ 1	SELECT INSTALLED_SOFTWARE_1.CM...
5mxcr3nh0cy2b	1.43	84.94	1.16	85.87	-0.28	204	205	0	0	0.04	0.00	204	256	0.00	0.00	130.00	129.10	2/ 2/ 2	SELECT OSUSER_1.CMDB_ID FROM O...

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: 36.4%, Second: 5.45%
Total User I/O Time First: 3,198.14 seconds, Second: 4,249.08 seconds
Captured SQL I/O Time First: 3,076.43 seconds, Second: 3,995.02 seconds
Captured SQL as a % of Total User I/O First: 96.19%, Second: 94.02%
Captured PL/SQL as a % of Total User I/O First: .08%, Second: .76%
Common SQL as a % of Total User I/O First: 95.96%, Second: 92.47%

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	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
6xqy3yrv5fqqw	14.28	14.28	2.12	2.12	-12.16	13,067	24,305	13,231	47,133	0.01	0.00	213	205	2,477.44	2,513.91	897.08	873.76	96	68		INSERT INTO CDM_ROOT_1 (CMDB_I...
6xf2bjhv3f20a	6.72	21.00	0.88	3.00	-5.84	2,759	5,115	2,835	17,808	0.02	0.00	88	87	1,000.49	886.50	894.83	883.82	214	134		INSERT INTO HIST_EVENTS(ID, OB...
6quh2na3y0syy	6.45	27.45	0.83	3.83	-5.62	11,108	18,971	11,280	35,039	0.01	0.00	209	203	2,661.20	2,483.03	879.53	859.00	51	34		INSERT INTO CDM_COMPOSITION_1 ...
1jqdcpkxcjggj	3.72	31.17	0.47	4.29	-3.26	1,177	2,331	1,199	8,352	0.03	0.00	27	28	198.71	215.47	959.27	951.42	278	156		INSERT INTO HIST_INF_STR(ID, O...
fnncar3ndasgu	1.81	32.97	0.34	4.63	-1.47	1,249	3,374	1,269	8,413	0.01	0.00	26	30	309.17	349.56	337.51	379.62	127	78		INSERT INTO CDM_LIST_ATTR_PRIM...
5y8amc3t0chff	0.57	33.54	0.06	4.69	-0.51	1,659	2,561	2,078	20,030	0.00	0.00	472	493	7,585.80	7,919.67	3,284.07	3,300.89	30	18	1/ 1/ 1	DELETE FROM CDM_ROOT_1 WHERE E...
fqu4btx1ywxy9	0.00	33.54	0.20	4.89	0.20	0	2	10	276	14.13	1.06	10	11	0.00	0.10	873.01	893.93	124,112	82,650		insert into CDM_TMP_OBJID valu...
g9588ypf0j5g3	0.00	33.55	0.01	4.90	0.00	0	0	30	1,112	5.83	0.36	30	48	0.02	0.20	2,118.34	2,611.22	51,250	28,224	1/ 1/ 1	delete from CDM_TMP_OBJID
0w1majm70d0tx	0.00	33.55	0.00	4.90	-0.00	0	0	70	240	0.21	0.01	69	73	0.00	0.00	236.99	236.67	1,827	1,026	1/ 1/ 1	SELECT WINOSUSER_1.CMDB_ID, WI...
105mn0xguw39u	0.00	33.55	0.00	4.90	0.00	0	0	825	822	0.04	0.00	824	822	0.00	0.00	61,132.00	61,132.00	365	200	1/ 1/ 1	SELECT WINDOWS_SERVICE_1.CMDB_...
249asvswu45wf	0.00	33.55	0.00	4.90	0.00	0	0	1,289	1,265	0.04	0.00	1,289	1,264	0.00	0.00	61,299.48	61,132.00	365	209	1/ 1/ 1	SELECT WINDOWS_SERVICE_1.CMDB_...
3h3974yx3tr81	0.00	33.55	0.00	4.90	0.00	0	0	921	1,559	0.02	0.00	920	916	0.00	0.00	91,085.57	91,078.10	183	63	1/ 1/ 1	SELECT PROCESS_1.CMDB_ID FROM ...
b7kc4z2qun912	0.00	33.55	0.00	4.90	0.00	0	0	1,340	1,479	0.02	0.00	1,339	1,371	0.00	0.00	91,085.18	91,078.16	182	104	1/ 1/ 1	SELECT PROCESS_1.CMDB_ID FROM ...

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: 912,588,870, Second: 603,324,895
Captured SQL Buffer Gets First: 894,317,187, Second: 594,260,180
Captured SQL % of Total Buffer Gets First: 98%, Second: 98.5%
Common SQL % of Total Buffer Gets First: 97.82%, Second: 97.89%

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	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
fqu4btx1ywxy9	36.82	36.82	37.83	37.83	1.01	2,707.31	2,761.50	124,112	82,650	10	276	10	11	0	2	0.00	0.10	873.01	893.93		insert into CDM_TMP_OBJID valu...
0w1majm70d0tx	1.54	38.36	1.30	39.13	-0.24	7,672.61	7,617.06	1,827	1,026	70	240	69	73	0	0	0.00	0.00	236.99	236.67	1/ 1/ 1	SELECT WINOSUSER_1.CMDB_ID, WI...
g9588ypf0j5g3	53.13	91.49	53.34	92.47	0.21	9,461.45	11,402.94	51,250	28,224	30	1,112	30	48	0	0	0.02	0.20	2,118.34	2,611.22	1/ 1/ 1	delete from CDM_TMP_OBJID
3h3974yx3tr81	0.36	91.85	0.19	92.66	-0.16	17,817.68	18,556.43	183	63	921	1,559	920	916	0	0	0.00	0.00	91,085.57	91,078.10	1/ 1/ 1	SELECT PROCESS_1.CMDB_ID FROM ...
1bfry68r1cdz8	0.80	92.65	0.66	93.33	-0.14	3,628.73	3,553.88	2,009	1,126	35	62	35	36	0	0	0.00	0.00	321.83	322.79	1/ 1/ 1	SELECT MEMBERSHIP_1.CMDB_ID, M...
105mn0xguw39u	0.64	93.29	0.53	93.86	-0.11	15,997.00	15,997.00	365	200	825	822	824	822	0	0	0.00	0.00	61,132.00	61,132.00	1/ 1/ 1	SELECT WINDOWS_SERVICE_1.CMDB_...
f4kbt6stpwm0w	0.55	93.84	0.45	94.30	-0.10	1,531.12	1,465.54	3,288	1,845	4	5	4	4	0	0	0.00	0.00	223.07	222.58	1/ 1/ 1	SELECT COMPOSITION_1.CMDB_ID, ...
249asvswu45wf	0.64	94.48	0.55	94.86	-0.09	16,040.83	15,997.00	365	209	1,289	1,265	1,289	1,264	0	0	0.00	0.00	61,299.48	61,132.00	1/ 1/ 1	SELECT WINDOWS_SERVICE_1.CMDB_...
by446qja3yanx	0.46	94.94	0.38	95.24	-0.08	2,110.87	2,035.72	2,009	1,126	25	27	25	27	0	0	0.00	0.00	324.56	325.52	1/ 1/ 1	SELECT NT_1.CMDB_ID, NT_1.A_DI...
b7kc4z2qun912	0.36	95.30	0.32	95.55	-0.04	17,892.13	18,298.05	182	104	1,340	1,479	1,339	1,371	0	0	0.00	0.00	91,085.18	91,078.16	1/ 1/ 1	SELECT PROCESS_1.CMDB_ID FROM ...
ddtxm9882qb62	0.27	95.57	0.23	95.79	-0.04	13,452.23	13,365.27	182	105	914	922	913	922	0	0	0.00	0.00	2,568.00	2,568.00	1/ 1/ 1	SELECT INSTALLED_SOFTWARE_1.CM...

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
SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	SQL Text
3zgtq94pd12uq	7.71	7.71	3.67	3.67	-4.05	9,083.82	8,003.25	11	4	2,951	35,110	521	588	2,490	3,379	3,277.73	3,326.00	1/ 1/ 1	DELETE FROM CDM_COMPOSITION_1 ...
6xf2bjhv3f20a	16.53	24.25	13.61	17.28	-2.92	1,000.49	886.50	214	134	2,835	17,808	88	87	2,759	5,115	894.83	883.82		INSERT INTO HIST_EVENTS(ID, OB...
g0kbqx3artq8x	5.70	29.94	3.03	20.31	-2.67	2,460.07	2,640.90	30	10	2,046	13,925	164	176	1,908	6,308	1,635.50	1,720.60	1/ 1/ 1	DELETE FROM CDM_LIST_ATTR_PRIM...
d15cdr0zt3vtp			2.02	22.33	2.02		8,811.00		2		30,473		77		2,375		1.00	/ 1/ 1	SELECT TO_CHAR(current_timesta...
dn4ubmxct9zpf	1.46	31.40	0.12	22.45	-1.34	2,361.75	1,046.00	8	1	3,197	99,361	1,015	212	2,195	19,332	1,500.00	1,500.00	1/ 1/ 2	DELETE FROM CDM_PROCESS_1 WHER...
5y8amc3t0chff	17.57	48.97	16.34	38.79	-1.23	7,585.80	7,919.67	30	18	2,078	20,030	472	493	1,659	2,561	3,284.07	3,300.89	1/ 1/ 1	DELETE FROM CDM_ROOT_1 WHERE E...
6xqy3yrv5fqqw	18.36	67.34	19.59	58.38	1.23	2,477.44	2,513.91	96	68	13,231	47,133	213	205	13,067	24,305	897.08	873.76		INSERT INTO CDM_ROOT_1 (CMDB_I...
9yhdmxbq004j9			0.94	59.32	0.94		8,239.00		1		18,774		3,312		15,508		44,909.00	/ 1/ 1	delete from sys.wri$_optstat_h...
6quh2na3y0syy	10.48	77.81	9.68	69.00	-0.80	2,661.20	2,483.03	51	34	11,280	35,039	209	203	11,108	18,971	879.53	859.00		INSERT INTO CDM_COMPOSITION_1 ...
03vgjmz4qdjw7	0.75	78.56			-0.75	9,702.00		1		6,089		651		5,561		1.00		1// 1	SELECT COUNT(*) FROM COMPOSITI...
1jqdcpkxcjggj	4.27	82.83	3.85	72.85	-0.41	198.71	215.47	278	156	1,199	8,352	27	28	1,177	2,331	959.27	951.42		INSERT INTO HIST_INF_STR(ID, O...
fnncar3ndasgu	3.03	85.86	3.12	75.97	0.09	309.17	349.56	127	78	1,269	8,413	26	30	1,249	3,374	337.51	379.62		INSERT INTO CDM_LIST_ATTR_PRIM...

	% 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
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	SQL Text
3zgtq94pd12uq	8.23	8.23	4.13	4.13	-4.10	9,083.82	8,003.25	99,922	32,013	0.00	0.00	11	4	2,951	35,110	521	588	2,490	3,379	3,277.73	3,326.00	1/ 1/ 1	DELETE FROM CDM_COMPOSITION_1 ...
g0kbqx3artq8x	6.08	14.31	3.41	7.54	-2.67	2,460.07	2,640.90	73,802	26,409	0.00	0.00	30	10	2,046	13,925	164	176	1,908	6,308	1,635.50	1,720.60	1/ 1/ 1	DELETE FROM CDM_LIST_ATTR_PRIM...
6xqy3yrv5fqqw	19.59	33.90	22.06	29.60	2.48	2,477.44	2,513.91	237,834	170,946	0.00	0.00	96	68	13,231	47,133	213	205	13,067	24,305	897.08	873.76		INSERT INTO CDM_ROOT_1 (CMDB_I...
6xf2bjhv3f20a	17.63	51.53	15.33	44.94	-2.30	1,000.49	886.50	214,105	118,791	0.00	0.00	214	134	2,835	17,808	88	87	2,759	5,115	894.83	883.82		INSERT INTO HIST_EVENTS(ID, OB...
dn4ubmxct9zpf	1.56	53.09	0.14	45.07	-1.42	2,361.75	1,046.00	18,894	1,046	0.00	0.00	8	1	3,197	99,361	1,015	212	2,195	19,332	1,500.00	1,500.00	1/ 1/ 2	DELETE FROM CDM_PROCESS_1 WHER...
03vgjmz4qdjw7	0.45	53.54			-0.45	5,473.00		5,473		0.00		1		6,089		651		5,561		1.00		1// 1	SELECT COUNT(*) FROM COMPOSITI...
5y8amc3t0chff	18.74	72.28	18.40	63.47	-0.34	7,585.80	7,919.67	227,574	142,554	0.00	0.00	30	18	2,078	20,030	472	493	1,659	2,561	3,284.07	3,300.89	1/ 1/ 1	DELETE FROM CDM_ROOT_1 WHERE E...
fnncar3ndasgu	3.23	75.51	3.52	66.99	0.29	309.17	349.56	39,264	27,266	0.00	0.00	127	78	1,269	8,413	26	30	1,249	3,374	337.51	379.62		INSERT INTO CDM_LIST_ATTR_PRIM...
6quh2na3y0syy	11.18	86.69	10.90	77.88	-0.28	2,661.20	2,483.03	135,721	84,423	0.00	0.00	51	34	11,280	35,039	209	203	11,108	18,971	879.53	859.00		INSERT INTO CDM_COMPOSITION_1 ...
1jqdcpkxcjggj	4.55	91.24	4.34	82.22	-0.21	198.71	215.47	55,242	33,613	0.00	0.00	278	156	1,199	8,352	27	28	1,177	2,331	959.27	951.42		INSERT INTO HIST_INF_STR(ID, O...
9yhdmxbq004j9			0.15	82.37	0.15		1,137.00		1,137		0.00		1		18,774		3,312		15,508		44,909.00	/ 1/ 1	delete from sys.wri$_optstat_h...
d15cdr0zt3vtp			0.02	82.39	0.02		73.00		146		0.00		2		30,473		77		2,375		1.00	/ 1/ 1	SELECT TO_CHAR(current_timesta...

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: 298,284, Second: 202,224
Captured SQL Elapsed Time First: 8,066.93 seconds, Second: 66,669.95 seconds
Captured SQL Elapsed Time as a % of DB time First: 91.82%, Second: 85.52%
Captured SQL Executions as a % of Total Executions First: 76.07%, Second: 71.93%
Common SQL Executions as a % of Total Executions First: 75.73%, Second: 72.21%

SQL Id	1st	2nd	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st/2nd/Both	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
fqu4btx1ywxy9	14.13	1.06	-13.07	124,112	82,650	10	276	10	11	0	2	0.00	0.10	873.01	893.93		insert into CDM_TMP_OBJID valu...
g9588ypf0j5g3	5.83	0.36	-5.47	51,250	28,224	30	1,112	30	48	0	0	0.02	0.20	2,118.34	2,611.22	1/ 1/ 1	delete from CDM_TMP_OBJID
520mkxqpf15q8	3.72	0.28	-3.44	32,666	21,501	0	0	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	select 1 from dual
0aah7mc3hb44f	2.06	0.13	-1.94	18,111	9,815	0	1	0	0	0	0	0.00	0.01	1.09	0.92	1/ 1/ 1	delete from CDM_TMP_STR
11gawdftpkjdr	2.06	0.13	-1.94	18,111	9,815	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	delete from CDM_TMP_INT
cm5vu20fhtnq1	1.29	0.14	-1.14	11,310	11,133	0	0	0	0	0	0	0.00	0.00	3.05	3.07	1/ 1/ 1	select /*+ connect_by_filterin...
f4kbt6stpwm0w	0.37	0.02	-0.35	3,288	1,845	4	5	4	4	0	0	0.00	0.00	223.07	222.58	1/ 1/ 1	SELECT COMPOSITION_1.CMDB_ID, ...
bgmc2n2121wbv	0.37	0.04	-0.33	3,237	3,221	0	0	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	select * from CUSTOMER_REGISTR...
3972rvxu3knn3	0.29	0.03	-0.26	2,549	2,534	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	delete from sdo_geor_ddl__tabl...
a6u3yjca29nqc	0.29	0.03	-0.26	2,549	2,537	0	0	0	0	0	0	0.00	0.00	1.00	1.00		declare m_stmt varchar2(512); ...
8vwv6hx92ymmm	0.32	0.11	-0.22	2,834	8,379	0	13	0	0	0	0	0.02	0.01	1.00	1.00	2/ 2/ 2	UPDATE MGMT_CURRENT_METRICS SE...

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: .45%, Second: .02%
Total Parses First: 204,677, Second: 138,228
Captured SQL Parses First: 163,896, Second: 104,905
Captured SQL Parses % of Total Parses First: 80.08%, Second: 75.89%
Common SQL Parses % of Total Parses First: 79.6%, Second: 76.86%

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st/2nd/Both	SQL Text
	% Total Parses					Parses		#Executions		#Plans
g9588ypf0j5g3	25.04	25.04	20.42	20.42	-4.62	51,248	28,223	51,250	28,224	1/ 1/ 1	delete from CDM_TMP_OBJID
cm5vu20fhtnq1	5.53	30.56	8.05	28.47	2.53	11,310	11,133	11,310	11,133	1/ 1/ 1	select /*+ connect_by_filterin...
11gawdftpkjdr	8.85	39.41	7.10	35.57	-1.75	18,111	9,816	18,111	9,815	1/ 1/ 1	delete from CDM_TMP_INT
0aah7mc3hb44f	8.85	48.26	7.10	42.67	-1.75	18,110	9,816	18,111	9,815	1/ 1/ 1	delete from CDM_TMP_STR
a6u3yjca29nqc	1.25	49.51	1.84	44.51	0.59	2,549	2,537	2,549	2,537		declare m_stmt varchar2(512); ...
3972rvxu3knn3	1.25	50.75	1.83	46.34	0.59	2,549	2,534	2,549	2,534	1/ 1/ 1	delete from sdo_geor_ddl__tabl...
520mkxqpf15q8	15.96	66.71	15.55	61.90	-0.41	32,666	21,501	32,666	21,501	1/ 1/ 1	select 1 from dual
03tyxm2zh3m7b	0.65	67.36	0.85	62.75	0.20	1,322	1,172	1,439	1,432	1/ 1/ 1	SELECT * FROM CLUSTERS
3aqd8dhufdxcw	0.65	68.00	0.85	63.59	0.20	1,322	1,172	1,439	1,432	1/ 1/ 1	SELECT * FROM CLUSTER_SERVER
by446qja3yanx	0.79	68.79	0.63	64.22	-0.16	1,613	872	2,009	1,126	1/ 1/ 1	SELECT NT_1.CMDB_ID, NT_1.A_DI...
bgmc2n2121wbv	0.91	69.70	1.03	65.25	0.12	1,854	1,419	3,237	3,221	1/ 1/ 1	select * from CUSTOMER_REGISTR...

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
'Sharble 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,207,959,552, Second: 1,207,959,552

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st	2nd	SQL Text
	% Total Sharable Memory					Sharable Memory Used		Sharable Memory Max		#Executions
2gtph74r3crsq	0.41	0.41	0.50	0.50	0.10	4,923,395	6,080,539	4,923,395	6,080,539	18	18	SELECT 'Tablespaces w/ Less Th...
9n1prug34mb98			0.05	0.56	0.05		648,670		648,670		98	SELECT NODE_1.CMDB_ID FROM NOD...
fvmkur9d5du4h			0.05	0.61	0.05		622,302		622,302		104	SELECT NODE_1.CMDB_ID FROM NOD...
cz8rzvjb1n2yj	0.07	0.48	0.03	0.64	-0.03	823,187	416,803	823,187	823,187	62	106	SELECT NODE_1.CMDB_ID FROM NOD...
47htrcm4qp27f	0.06	0.54	0.04	0.68	-0.02	737,769	494,017	737,769	494,017	6	18	select OWNER, SEGMENT_NAME, SE...
6b5qtb0sssh0w	0.07	0.61	0.05	0.74	-0.02	847,806	627,974	847,806	627,974	2	6	SELECT NODE_1.CMDB_ID FROM NOD...
d66y4qmsw550w	0.06	0.66	0.07	0.81	0.02	667,338	878,610	667,338	878,610	61	100	SELECT NODE_1.CMDB_ID FROM NOD...
a8j39qb13tqkr	0.04	0.70	0.05	0.86	0.01	460,650	640,338	460,650	640,338	12	12	SELECT :B1 TASK_ID, F.FINDING_...
23rxv46xhd4r3	0.06	0.76	0.07	0.93	0.01	724,053	825,565	724,053	825,565	18	18	select OWNER, TABLE_NAME, COUN...
7snbnb70wt9uv	0.05	0.81	0.06	0.99	0.01	615,221	693,949	615,221	693,949	183	100	SELECT NODE_1.CMDB_ID FROM NOD...
fmg0rw9awbjtg	0.07	0.88	0.07	1.06	0.00	836,292	882,156	836,292	882,156	18	18	select acc.OWNER, acc.CONSTRAI...
7djnw2g53xwmz	0.06	0.94	0.06	1.12	0.00	671,252	709,420	671,252	709,420	18	18	select OWNER, TABLE_NAME, CONS...

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	SQL Text
	Version Count			Version Count Max		#Executions
32hbap2vtmf53	26		-26	26		389		select position#, sequence#, l...
0fr8zhn4ymu3v	24		-24	24		51		select intcol#, type, flags, l...
53saa2zkr6wc3	24		-24	24		415		select intcol#, nvl(pos#, 0), ...
gx4mv66pvj3xz	24		-24	24		175		select con#, type#, condlength...
8vwv6hx92ymmm		22	22		22		8,379	UPDATE MGMT_CURRENT_METRICS SE...
gjm43un5cy843		18	18		18		3	SELECT SUM(USED), SUM(TOTAL) F...
a8j39qb13tqkr	65	80	15	65	80	12	12	SELECT :B1 TASK_ID, F.FINDING_...
7djnw2g53xwmz	48	60	12	48	60	18	18	select OWNER, TABLE_NAME, CONS...
0zzvnbtpfvt93	32	42	10	32	42	18	18	SELECT event "Event", count(*)...
23rxv46xhd4r3	29	39	10	29	39	18	18	select OWNER, TABLE_NAME, COUN...
0z0pvvfstpq1r	20	26	6	20	26	183	106	SELECT WINOSUSER_1.CMDB_ID FRO...
5mxcr3nh0cy2b	20	26	6	20	26	366	210	SELECT OSUSER_1.CMDB_ID FROM O...
fmg0rw9awbjtg	16	22	6	16	22	18	18	select acc.OWNER, acc.CONSTRAI...
476xnssn6bkb7	18	22	4	18	22	183	103	SELECT NETDEVICE_1.CMDB_ID FRO...

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: 8,785.78 seconds, Second: 77,959.73 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	SQL Text
	% Total Cluster Wait					Cluster Wait Time (sec)		Cluster Wait Time per Exec (sec)		#Executions		#Plans
03tyxm2zh3m7b	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,439	1,432	1/ 1/ 1	SELECT * FROM CLUSTERS
03vgjmz4qdjw7	0.00	0.00			0.00	0.00		0.00		1		1// 1	SELECT COUNT(*) FROM COMPOSITI...
07qkv062tav6g			0.00	0.00	0.00		0.00		0.00		1		INSERT INTO CDM_WINOSUSER_1 (C...
08bqjmf8490s2			0.00	0.00	0.00		0.00		0.00		467	/ 1/ 1	SELECT PARAMETER_VALUE FROM MG...
0aah7mc3hb44f	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	18,111	9,815	1/ 1/ 1	delete from CDM_TMP_STR
0fr8zhn4ymu3v	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	51	3	2/ 2/ 2	select intcol#, type, flags, l...
0k8522rmdzg4k	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	834	837	1/ 1/ 1	select privilege# from sysauth...
0njp59jttu2z9			0.00	0.00	0.00		0.00		0.00		3	/ 1/ 1	DELETE MGMT_METRICS_RAW WHERE ...
0v3dvmc22qnam	0.00	0.00			0.00	0.00		0.00		163			insert into sys.col_usage$ (ob...
0w1majm70d0tx	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,827	1,026	1/ 1/ 1	SELECT WINOSUSER_1.CMDB_ID, WI...
0ws7ahf1d78qa			0.00	0.00	0.00		0.00		0.00		643	/ 1/ 1	select SYS_CONTEXT('USERENV', ...
0y28pyspzu6jj			0.00	0.00	0.00		0.00		0.00		9		INSERT INTO CDM_DAEMON_1 (CMDB...
0z0pvvfstpq1r	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	183	106	2/ 2/ 2	SELECT WINOSUSER_1.CMDB_ID FRO...
0zzvnbtpfvt93	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	18	18	1/ 1/ 1	SELECT event "Event", count(*)...
105mn0xguw39u	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	365	200	1/ 1/ 1	SELECT WINDOWS_SERVICE_1.CMDB_...

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats
Other Instance Activity Stats

Key Instance Activity Stats

Ordered by statistic name

Statistic	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Value			per Second (DB time)			per Second (Elapsed Time)			per Trans
db block changes	673,376,583	458,503,171	-31.91	76,643.94	5,881.28	-92.33	62,315.38	42,446.32	-31.88	31,830.61	35,266.76	10.80
execute count	392,133	281,143	-28.30	44.63	3.61	-91.91	36.29	26.03	-28.27	18.54	21.62	16.61
logons cumulative	1,253	1,254	0.08	0.14	0.02	-85.71	0.12	0.12	0.00	0.06	0.10	66.67
opened cursors cumulative	98,260	94,846	-3.47	11.18	1.22	-89.09	9.09	8.78	-3.41	4.64	7.30	57.33
parse count (total)	204,677	138,228	-32.47	23.30	1.77	-92.40	18.94	12.80	-32.42	9.68	10.63	9.81
parse time elapsed	2,402	1,125	-53.16	0.27	0.01	-96.30	0.22	0.10	-54.55	0.11	0.09	-18.18
physical reads	1,295,195	872,574	-32.63	147.42	11.19	-92.41	119.86	80.78	-32.60	61.22	67.12	9.64
physical writes	6,122,711	4,082,038	-33.33	696.89	52.36	-92.49	566.61	377.90	-33.31	289.42	313.98	8.49
redo size	59,466,024,232	40,659,352,920	-31.63	6,768,442.14	521,543.04	-92.29	5,503,084.11	3,764,074.23	-31.60	2,810,967.82	3,127,401.96	11.26
session cursor cache hits	218,835	25,889	-88.17	24.91	0.33	-98.68	20.25	2.40	-88.15	10.34	1.99	-80.75
session logical reads	912,588,870	603,324,895	-33.89	103,871.16	7,738.93	-92.55	84,452.48	55,853.32	-33.86	43,138.21	46,406.04	7.58
user calls	476,753	311,827	-34.59	54.26	4.00	-92.63	44.12	28.87	-34.56	22.54	23.98	6.39
user commits	21,155	13,001	-38.54	2.41	0.17	-92.95	1.96	1.20	-38.78	1.00	1.00	0.00
workarea executions - onepass	2	2	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
workarea executions - optimal	40,066	29,896	-25.38	4.56	0.38	-91.67	3.71	2.77	-25.34	1.89	2.30	21.69

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Value			per Second (DB time)			per Second (Elapsed Time)			per Trans
Batched IO (bound) vector count	10	1	-90.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO (full) vector count	89	172	93.26	0.01	0.00	-100.00	0.01	0.02	100.00	0.00	0.01	100.00
Batched IO block miss count	18,340	27,787	51.51	2.09	0.36	-82.78	1.70	2.57	51.18	0.87	2.14	145.98
Batched IO buffer defrag count	7	119	1,600.00	0.00	0.00	0.00	0.00	0.01	100.00	0.00	0.01	100.00
Batched IO double miss count	531	15,295	2,780.41	0.06	0.20	233.33	0.05	1.42	2,740.00	0.03	1.18	3,833.33
Batched IO same unit count	249	292	17.27	0.03	0.00	-100.00	0.02	0.03	50.00	0.01	0.02	100.00
Batched IO single block count	11	6	-45.45	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO vector block count	18,179	27,706	52.41	2.07	0.36	-82.61	1.68	2.56	52.38	0.86	2.13	147.67
Batched IO vector read count	344	338	-1.74	0.04	0.00	-100.00	0.03	0.03	0.00	0.02	0.03	50.00
Block Cleanout Optim referenced	242,871	252,911	4.13	27.64	3.24	-88.28	22.48	23.41	4.14	11.48	19.45	69.43
CCursor + sql area evicted	10	2	-80.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
CPU used by this session	517,778	370,659	-28.41	58.93	4.75	-91.94	47.92	34.31	-28.40	24.48	28.51	16.46
CPU used when call started	516,527	369,412	-28.48	58.79	4.74	-91.94	47.80	34.20	-28.45	24.42	28.41	16.34
CR blocks created	10,907	10,689	-2.00	1.24	0.14	-88.71	1.01	0.99	-1.98	0.52	0.82	57.69
Cached Commit SCN referenced	16,227,031	8,670,041	-46.57	1,846.97	111.21	-93.98	1,501.68	802.64	-46.55	767.05	666.87	-13.06
Commit SCN cached	2,545,732	1,519,251	-40.32	289.76	19.49	-93.27	235.59	140.65	-40.30	120.34	116.86	-2.89
DBWR checkpoint buffers written	549,436	258,652	-52.92	62.54	3.32	-94.69	50.85	23.94	-52.92	25.97	19.89	-23.41
DBWR checkpoints	69	45	-34.78	0.01	0.00	-100.00	0.01	0.00	-100.00	0.00	0.00	0.00
DBWR revisited being-written buffer	3	13	333.33	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
DBWR tablespace checkpoint buffers written	20	12	-40.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
DBWR transaction table writes	935	441	-52.83	0.11	0.01	-90.91	0.09	0.04	-55.56	0.04	0.03	-25.00
DBWR undo block writes	4,519,610	3,064,692	-32.19	514.42	39.31	-92.36	418.25	283.72	-32.16	213.64	235.73	10.34
HSC Heap Segment Block Changes	110,381,260	74,831,270	-32.21	12,563.63	959.87	-92.36	10,214.86	6,927.57	-32.18	5,217.74	5,755.81	10.31
Heap Segment Array Inserts	814,057	551,345	-32.27	92.66	7.07	-92.37	75.33	51.04	-32.24	38.48	42.41	10.21
Heap Segment Array Updates	1,385	1,251	-9.68	0.16	0.02	-87.50	0.13	0.12	-7.69	0.07	0.10	42.86
IMU CR rollbacks	2,948	2,829	-4.04	0.34	0.04	-88.24	0.27	0.26	-3.70	0.14	0.22	57.14
IMU Flushes	21,740	13,299	-38.83	2.47	0.17	-93.12	2.01	1.23	-38.81	1.03	1.02	-0.97
IMU Redo allocation size	127,521,404	72,539,416	-43.12	14,514.53	930.47	-93.59	11,801.04	6,715.40	-43.09	6,027.96	5,579.53	-7.44
IMU commits	1,895	1,872	-1.21	0.22	0.02	-90.91	0.18	0.17	-5.56	0.09	0.14	55.56
IMU contention	73	36	-50.68	0.01	0.00	-100.00	0.01	0.00	-100.00	0.00	0.00	0.00
IMU ktichg flush	49	41	-16.33	0.01	0.00	-100.00	0.00	0.00	0.00	0.00	0.00	0.00
IMU pool not allocated	773	1,375	77.88	0.09	0.02	-77.78	0.07	0.13	85.71	0.04	0.11	175.00
IMU undo allocation size	35,114,448	26,594,568	-24.26	3,996.74	341.13	-91.46	3,249.55	2,462.01	-24.24	1,659.87	2,045.58	23.24
IMU- failed to get a private strand	773	1,375	77.88	0.09	0.02	-77.78	0.07	0.13	85.71	0.04	0.11	175.00
Number of read IOs issued	438	219	-50.00	0.05	0.00	-100.00	0.04	0.02	-50.00	0.02	0.02	0.00
RowCR - row contention	12,320	18,351	48.95	1.40	0.24	-82.86	1.14	1.70	49.12	0.58	1.41	143.10
RowCR attempts	1,195,134	688,715	-42.37	136.03	8.83	-93.51	110.60	63.76	-42.35	56.49	52.97	-6.23
RowCR hits	1,185,171	672,502	-43.26	134.90	8.63	-93.60	109.68	62.26	-43.23	56.02	51.73	-7.66
SMON posted for undo segment shrink	110	124	12.73	0.01	0.00	-100.00	0.01	0.01	0.00	0.01	0.01	0.00
SQL*Net roundtrips to/from client	469,828	304,801	-35.12	53.48	3.91	-92.69	43.48	28.22	-35.10	22.21	23.44	5.54
active txn count during cleanout	640,950	730,614	13.99	72.95	9.37	-87.16	59.31	67.64	14.04	30.30	56.20	85.48
background checkpoints completed	64	41	-35.94	0.01	0.00	-100.00	0.01	0.00	-100.00	0.00	0.00	0.00
background checkpoints started	63	42	-33.33	0.01	0.00	-100.00	0.01	0.00	-100.00	0.00	0.00	0.00
background timeouts	48,567	42,695	-12.09	5.53	0.55	-90.05	4.49	3.95	-12.03	2.30	3.28	42.61
branch node splits	50	58	16.00	0.01	0.00	-100.00	0.00	0.01	100.00	0.00	0.00	0.00
buffer is not pinned count	4,831,204	3,237,392	-32.99	549.89	41.53	-92.45	447.09	299.70	-32.97	228.37	249.01	9.04
buffer is pinned count	115,946,401	80,617,566	-30.47	13,197.06	1,034.09	-92.16	10,729.87	7,463.24	-30.44	5,480.80	6,200.87	13.14
bytes received via SQL*Net from client	2,308,206,909	1,559,467,536	-32.44	262,720.86	20,003.50	-92.39	213,605.28	144,369.04	-32.41	109,109.28	119,949.81	9.94
bytes sent via SQL*Net to client	2,254,979,205	1,216,452,894	-46.05	256,662.46	15,603.61	-93.92	208,679.50	112,614.16	-46.03	106,593.20	93,566.10	-12.22
calls to get snapshot scn: kcmgss	775,125	526,542	-32.07	88.22	6.75	-92.35	71.73	48.75	-32.04	36.64	40.50	10.53
calls to kcmgas	4,952,219	3,276,928	-33.83	563.66	42.03	-92.54	458.29	303.36	-33.81	234.09	252.05	7.67
calls to kcmgcs	1,868,662	1,543,157	-17.42	212.69	19.79	-90.70	172.93	142.86	-17.39	88.33	118.70	34.38
cell physical IO interconnect bytes	123,258,547,712	83,703,420,416	-32.09	14,029,327.82	1,073,675.13	-92.35	11,406,549.61	7,748,915.44	-32.07	5,826,449.90	6,438,229.40	10.50
change write time	62,831	747,422	1,089.58	7.15	9.59	34.13	5.81	69.19	1,090.88	2.97	57.49	1,835.69
cleanout - number of ktugct calls	5,273,423	1,108,707	-78.98	600.22	14.22	-97.63	488.01	102.64	-78.97	249.28	85.28	-65.79
cleanouts and rollbacks - consistent read gets	5,804	4,923	-15.18	0.66	0.06	-90.91	0.54	0.46	-14.81	0.27	0.38	40.74
cleanouts only - consistent read gets	427,960	309,112	-27.77	48.71	3.97	-91.85	39.60	28.62	-27.73	20.23	23.78	17.55
cluster key scan block gets	1,066,618	1,066,877	0.02	121.40	13.68	-88.73	98.71	98.77	0.06	50.42	82.06	62.75
cluster key scans	783,676	784,009	0.04	89.20	10.06	-88.72	72.52	72.58	0.08	37.04	60.30	62.80
commit batch/immediate performed	2	6	200.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
commit batch/immediate requested	2	6	200.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
commit cleanout failures: block lost	1,530,381	949,048	-37.99	174.19	12.17	-93.01	141.62	87.86	-37.96	72.34	73.00	0.91
commit cleanout failures: buffer being written	760	4,427	482.50	0.09	0.06	-33.33	0.07	0.41	485.71	0.04	0.34	750.00
commit cleanout failures: callback failure	2,382	857	-64.02	0.27	0.01	-96.30	0.22	0.08	-63.64	0.11	0.07	-36.36
commit cleanouts	2,798,080	1,617,329	-42.20	318.48	20.75	-93.48	258.94	149.73	-42.18	132.27	124.40	-5.95
commit cleanouts successfully completed	1,264,557	662,987	-47.57	143.93	8.50	-94.09	117.02	61.38	-47.55	59.78	51.00	-14.69
commit immediate performed	2	6	200.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
commit immediate requested	2	6	200.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
commit txn count during cleanout	7,422,081	4,224,895	-43.08	844.78	54.19	-93.59	686.85	391.12	-43.06	350.84	324.97	-7.37
consistent changes	333,289,658	225,945,034	-32.21	37,935.14	2,898.23	-92.36	30,843.18	20,917.05	-32.18	15,754.65	17,379.05	10.31
consistent gets	132,317,531	73,760,350	-44.26	15,060.42	946.13	-93.72	12,244.88	6,828.43	-44.23	6,254.67	5,673.44	-9.29
consistent gets - examination	12,255,804	6,884,567	-43.83	1,394.96	88.31	-93.67	1,134.17	637.34	-43.81	579.33	529.54	-8.59
consistent gets direct	52,301	26,455	-49.42	5.95	0.34	-94.29	4.84	2.45	-49.38	2.47	2.03	-17.81
consistent gets from cache	132,265,230	73,733,897	-44.25	15,054.47	945.79	-93.72	12,240.04	6,825.98	-44.23	6,252.20	5,671.40	-9.29
consistent gets from cache (fastpath)	117,815,167	65,180,689	-44.68	13,409.76	836.08	-93.77	10,902.81	6,034.16	-44.66	5,569.14	5,013.51	-9.98
cursor authentications	472	60	-87.29	0.05	0.00	-100.00	0.04	0.01	-75.00	0.02	0.00	-100.00
data blocks consistent reads - undo records applied	207,728	226,773	9.17	23.64	2.91	-87.69	19.22	20.99	9.21	9.82	17.44	77.60
db block gets	780,271,339	529,564,620	-32.13	88,810.74	6,792.80	-92.35	72,207.60	49,024.90	-32.11	36,883.54	40,732.61	10.44
db block gets direct	66	452	584.85	0.01	0.01	0.00	0.01	0.04	300.00	0.00	0.03	100.00
db block gets from cache	780,271,273	529,564,168	-32.13	88,810.73	6,792.79	-92.35	72,207.59	49,024.85	-32.11	36,883.54	40,732.57	10.44
db block gets from cache (fastpath)	2,775,008	1,860,483	-32.96	315.85	23.86	-92.45	256.80	172.24	-32.93	131.18	143.10	9.09
deferred (CURRENT) block cleanout applications	315,048	216,271	-31.35	35.86	2.77	-92.28	29.16	20.02	-31.34	14.89	16.63	11.69
dirty buffers inspected	2,886,202	3,151,112	9.18	328.51	40.42	-87.70	267.09	291.72	9.22	136.43	242.37	77.65
enqueue conversions	4,670	4,951	6.02	0.53	0.06	-88.68	0.43	0.46	6.98	0.22	0.38	72.73
enqueue releases	241,407	231,973	-3.91	27.48	2.98	-89.16	22.34	21.48	-3.85	11.41	17.84	56.35
enqueue requests	241,387	231,991	-3.89	27.47	2.98	-89.15	22.34	21.48	-3.85	11.41	17.84	56.35
enqueue waits	7	6	-14.29	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
failed probes on index block reclamation	95	80	-15.79	0.01	0.00	-100.00	0.01	0.01	0.00	0.00	0.01	100.00
file io service time	378	234	-38.10	0.04	0.00	-100.00	0.03	0.02	-33.33	0.02	0.02	0.00
free buffer inspected	6,407,531	75,318,582	1,075.47	729.31	966.12	32.47	592.96	6,972.68	1,075.91	302.88	5,793.29	1,812.73
free buffer requested	6,191,447	9,005,440	45.45	704.71	115.51	-83.61	572.97	833.69	45.50	292.67	692.67	136.67
heap block compress	386,955	254,446	-34.24	44.04	3.26	-92.60	35.81	23.56	-34.21	18.29	19.57	7.00
hot buffers moved to head of LRU	843,804	1,047,091	24.09	96.04	13.43	-86.02	78.09	96.94	24.14	39.89	80.54	101.91
immediate (CR) block cleanout applications	433,764	314,035	-27.60	49.37	4.03	-91.84	40.14	29.07	-27.58	20.50	24.15	17.80
immediate (CURRENT) block cleanout applications	5,593,600	1,204,740	-78.46	636.67	15.45	-97.57	517.64	111.53	-78.45	264.41	92.67	-64.95
index crx upgrade (positioned)	16,564	16,598	0.21	1.89	0.21	-88.89	1.53	1.54	0.65	0.78	1.28	64.10
index crx upgrade (prefetch)	15	10	-33.33	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
index fast full scans (full)	12,482	7,092	-43.18	1.42	0.09	-93.66	1.16	0.66	-43.10	0.59	0.55	-6.78
index fetch by key	3,517,143	2,616,292	-25.61	400.32	33.56	-91.62	325.48	242.21	-25.58	166.26	201.24	21.04
index scans kdiixs1	740,129	974,530	31.67	84.24	12.50	-85.16	68.49	90.22	31.73	34.99	74.96	114.23
leaf node 90-10 splits	1,369	875	-36.08	0.16	0.01	-93.75	0.13	0.08	-38.46	0.06	0.07	16.67
leaf node splits	17,867	19,312	8.09	2.03	0.25	-87.68	1.65	1.79	8.48	0.84	1.49	77.38
lob reads	733	777	6.00	0.08	0.01	-87.50	0.07	0.07	0.00	0.03	0.06	100.00
lob writes	941	900	-4.36	0.11	0.01	-90.91	0.09	0.08	-11.11	0.04	0.07	75.00
lob writes unaligned	941	900	-4.36	0.11	0.01	-90.91	0.09	0.08	-11.11	0.04	0.07	75.00
messages received	104,074	36,691	-64.75	11.85	0.47	-96.03	9.63	3.40	-64.69	4.92	2.82	-42.68
messages sent	104,074	36,689	-64.75	11.85	0.47	-96.03	9.63	3.40	-64.69	4.92	2.82	-42.68
min active SCN optimization applied on CR	108,877	97,664	-10.30	12.39	1.25	-89.91	10.08	9.04	-10.32	5.15	7.51	45.83
no work - consistent read gets	117,490,664	65,211,713	-44.50	13,372.83	836.48	-93.74	10,872.78	6,037.03	-44.48	5,553.80	5,015.90	-9.69
non-idle wait count	2,423,947	6,456,856	166.38	275.89	82.82	-69.98	224.32	597.75	166.47	114.58	496.64	333.44
parse count (describe)	37	14	-62.16	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
parse count (failures)	72	76	5.56	0.01	0.00	-100.00	0.01	0.01	0.00	0.00	0.01	100.00
parse count (hard)	1,117	537	-51.92	0.13	0.01	-92.31	0.10	0.05	-50.00	0.05	0.04	-20.00
parse time cpu	1,960	350	-82.14	0.22	0.00	-100.00	0.18	0.03	-83.33	0.09	0.03	-66.67
physical read IO requests	1,214,176	774,801	-36.19	138.20	9.94	-92.81	112.36	71.73	-36.16	57.39	59.60	3.85
physical read bytes	10,610,237,440	7,148,126,208	-32.63	1,207,660.66	91,689.98	-92.41	981,888.90	661,743.87	-32.61	501,547.50	549,813.57	9.62
physical read total IO requests	1,260,157	825,875	-34.46	143.43	10.59	-92.62	116.62	76.46	-34.44	59.57	63.52	6.63
physical read total bytes	11,356,516,352	7,979,575,296	-29.74	1,292,602.37	102,355.09	-92.08	1,050,950.78	738,715.98	-29.71	536,824.22	613,766.27	14.33
physical read total multi block requests	607	679	11.86	0.07	0.01	-85.71	0.06	0.06	0.00	0.03	0.05	66.67
physical reads cache	1,242,849	845,034	-32.01	141.46	10.84	-92.34	115.02	78.23	-31.99	58.75	65.00	10.64
physical reads cache prefetch	47,331	82,757	74.85	5.39	1.06	-80.33	4.38	7.66	74.89	2.24	6.37	184.38
physical reads direct	52,346	27,540	-47.39	5.96	0.35	-94.13	4.84	2.55	-47.31	2.47	2.12	-14.17
physical reads direct temporary tablespace	45	1,085	2,311.11	0.01	0.01	0.00	0.00	0.10	100.00	0.00	0.08	100.00
physical write IO requests	2,871,036	2,855,817	-0.53	326.78	36.63	-88.79	265.69	264.38	-0.49	135.71	219.66	61.86
physical write bytes	50,157,248,512	33,440,055,296	-33.33	5,708,914.27	428,940.13	-92.49	4,641,634.63	3,095,741.60	-33.30	2,370,940.61	2,572,114.09	8.48
physical write total IO requests	3,008,329	2,935,294	-2.43	342.41	37.65	-89.00	278.40	271.74	-2.39	142.20	225.77	58.77
physical write total bytes	111,902,031,360	75,723,845,120	-32.33	12,736,725.45	971,320.04	-92.37	10,355,598.83	7,010,199.46	-32.31	5,289,625.68	5,824,463.13	10.11
physical write total multi block requests	156,771	79,436	-49.33	17.84	1.02	-94.28	14.51	7.35	-49.35	7.41	6.11	-17.54
physical writes direct	111	1,537	1,284.68	0.01	0.02	100.00	0.01	0.14	1,300.00	0.01	0.12	1,100.00
physical writes direct temporary tablespace	49	1,089	2,122.45	0.01	0.01	0.00	0.00	0.10	100.00	0.00	0.08	100.00
physical writes from cache	6,122,600	4,080,501	-33.35	696.88	52.34	-92.49	566.60	377.76	-33.33	289.42	313.86	8.44
physical writes non checkpoint	5,731,687	3,841,351	-32.98	652.38	49.27	-92.45	530.42	355.62	-32.96	270.94	295.47	9.05
pinned buffers inspected	3,746	8,148	117.51	0.43	0.10	-76.74	0.35	0.75	114.29	0.18	0.63	250.00
recursive calls	487,699	452,545	-7.21	55.51	5.80	-89.55	45.13	41.89	-7.18	23.05	34.81	51.02
recursive cpu usage	4,832	4,021	-16.78	0.55	0.05	-90.91	0.45	0.37	-17.78	0.23	0.31	34.78
redo blocks checksummed by FG (exclusive)	1,044,077	774,656	-25.80	118.84	9.94	-91.64	96.62	71.71	-25.78	49.35	59.58	20.73
redo blocks written	120,188,417	82,184,323	-31.62	13,679.88	1,054.19	-92.29	11,122.43	7,608.28	-31.60	5,681.32	6,321.38	11.27
redo buffer allocation retries	152	9,381	6,071.71	0.02	0.12	500.00	0.01	0.87	8,600.00	0.01	0.72	7,100.00
redo entries	332,333,123	227,404,288	-31.57	37,826.26	2,916.95	-92.29	30,754.66	21,052.15	-31.55	15,709.44	17,491.29	11.34
redo log space requests	128	4,034	3,051.56	0.01	0.05	400.00	0.01	0.37	3,600.00	0.01	0.31	3,000.00
redo ordering marks	4,468,419	2,920,124	-34.65	508.60	37.46	-92.63	413.51	270.33	-34.63	211.22	224.61	6.34
redo size for direct writes	260	1,040	300.00	0.03	0.01	-66.67	0.02	0.10	400.00	0.01	0.08	700.00
redo subscn max counts	5,610,461	3,768,877	-32.82	638.58	48.34	-92.43	519.20	348.91	-32.80	265.21	289.89	9.31
redo synch time	37,807	977,383	2,485.19	4.30	12.54	191.63	3.50	90.48	2,485.14	1.79	75.18	4,100.00
redo synch writes	20,777	12,514	-39.77	2.36	0.16	-93.22	1.92	1.16	-39.58	0.98	0.96	-2.04
redo wastage	23,117,048	8,595,100	-62.82	2,631.19	110.25	-95.81	2,139.29	795.70	-62.81	1,092.75	661.11	-39.50
redo write time	121,915	369,503	203.08	13.88	4.74	-65.85	11.28	34.21	203.28	5.76	28.42	393.40
redo writes	69,409	23,011	-66.85	7.90	0.30	-96.20	6.42	2.13	-66.82	3.28	1.77	-46.04
rollback changes - undo records applied	40	171	327.50	0.00	0.00	0.00	0.00	0.02	100.00	0.00	0.01	100.00
rollbacks only - consistent read gets	5,094	4,838	-5.03	0.58	0.06	-89.66	0.47	0.45	-4.26	0.24	0.37	54.17
root node splits	1	1	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
rows fetched via callback	1,499,367	818,742	-45.39	170.66	10.50	-93.85	138.75	75.80	-45.37	70.88	62.98	-11.15
session pga memory	493,937,592	492,602,656	-0.27	56,220.14	6,318.68	-88.76	45,709.80	45,603.11	-0.23	23,348.50	37,889.60	62.28
session pga memory max	521,069,496	511,149,344	-1.90	59,308.30	6,556.58	-88.94	48,220.63	47,320.09	-1.87	24,631.03	39,316.16	59.62
session uga memory	876,234,939,776	854,767,160,760	-2.45	99,733,344.64	10,964,214.35	-89.01	81,088,228.73	79,130,797.99	-2.41	41,419,756.08	65,746,262.65	58.73
session uga memory max	2,112,364,552	2,156,113,152	2.07	240,430.02	27,656.76	-88.50	195,481.70	199,604.01	2.11	99,851.79	165,842.10	66.09
shared hash latch upgrades - no wait	1,330,932	828,762	-37.73	151.49	10.63	-92.98	123.17	76.72	-37.71	62.91	63.75	1.34
sorts (memory)	47,052	43,110	-8.38	5.36	0.55	-89.74	4.35	3.99	-8.28	2.22	3.32	49.55
sorts (rows)	2,496,167	1,588,549	-36.36	284.11	20.38	-92.83	231.00	147.06	-36.34	117.99	122.19	3.56
sql area evicted	872	333	-61.81	0.10	0.00	-100.00	0.08	0.03	-62.50	0.04	0.03	-25.00
sql area purged	87	86	-1.15	0.01	0.00	-100.00	0.01	0.01	0.00	0.00	0.01	100.00
summed dirty queue length	6,878,031	16,657,718	142.19	782.86	213.67	-72.71	636.50	1,542.10	142.28	325.13	1,281.26	294.08
switch current to new buffer	425,618	286,453	-32.70	48.44	3.67	-92.42	39.39	26.52	-32.67	20.12	22.03	9.49
table fetch by rowid	4,279,582	3,709,437	-13.32	487.10	47.58	-90.23	396.04	343.40	-13.29	202.30	285.32	41.04
table fetch continued row	2,968	2,680	-9.70	0.34	0.03	-91.18	0.27	0.25	-7.41	0.14	0.21	50.00
table scan blocks gotten	87,763,597	46,649,972	-46.85	9,989.28	598.39	-94.01	8,121.79	4,318.66	-46.83	4,148.60	3,588.18	-13.51
table scan rows gotten	19,785,340,221	10,150,971,577	-48.69	2,251,973.83	130,207.89	-94.22	1,830,968.07	939,734.84	-48.68	935,255.98	780,783.91	-16.52
table scans (direct read)	6	3	-50.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
table scans (long tables)	6	7	16.67	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
table scans (short tables)	114,376	72,605	-36.52	13.02	0.93	-92.86	10.58	6.72	-36.48	5.41	5.58	3.14
temp space allocated (bytes)	23,068,672	143,654,912	522.73	2,625.68	1,842.68	-29.82	2,134.81	13,298.98	522.96	1,090.46	11,049.53	913.29
total cf enq hold time	6,940	57,490	728.39	0.79	0.74	-6.33	0.64	5.32	731.25	0.33	4.42	1,239.39
total number of cf enq holders	766	1,592	107.83	0.09	0.02	-77.78	0.07	0.15	114.29	0.04	0.12	200.00
total number of times SMON posted	110	124	12.73	0.01	0.00	-100.00	0.01	0.01	0.00	0.01	0.01	0.00
transaction rollbacks	2	6	200.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
undo change vector size	35,446,466,816	24,264,650,028	-31.55	4,034,528.33	311,245.96	-92.29	3,280,274.59	2,246,320.64	-31.52	1,675,559.76	1,866,367.97	11.39
write clones created in foreground	878	2,463	180.52	0.10	0.03	-70.00	0.08	0.23	187.50	0.04	0.19	375.00

Back to Instance Activity Statistics
Back to Top

IO Stats

IOStat by Function - Data Rate per Second
IOStat by Function - Requests per Second
IOStat by File Type - Data Rate per Second
IOStat by File Type - Requests per Second
Tablespace IO Stats
Top File Comparison by IO
Top File Comparison by Read Time
Top File Comparison by Buffer Waits

IOStat by Function - Data Rate per Second

Total Reads includes all Functions: Buffer Cache, Direct Reads, ARCH, Data Pump, Others, RMAN, Recovry, Streams/AQ and XDB
Total Writes includes all Functions: DBWR, Direct Writes, LGWR, ARCH, Data Pump, Others, RMAN, Recovry, Streams/AQ and XDB

Total Reads			Buffer Cache Reads			Direct Reads			Total Writes			DBWR			Direct Writes			LGWR
1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
1.00	0.70	-30.00	0.90	0.61	-32.22	0.04	0.02	-50.00	9.87	6.69	-32.22	4.42	2.95	-33.26	0.00	0.00	0.00	5.43	3.72	-31.49

Back to IO Stats
Back to Top

IOStat by Function - Requests per Second

Total Reads includes all Functions: Buffer Cache, Direct Reads, ARCH, Data Pump, Others, RMAN, Recovry, Streams/AQ and XDB
Total Writes includes all Functions: DBWR, Direct Writes, LGWR, ARCH, Data Pump, Others, RMAN, Recovry, Streams/AQ and XDB

Total Reads			Buffer Cache Reads			Direct Reads			Total Writes			DBWR			Direct Writes			LGWR
1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
116.59	76.45	-34.43	112.29	71.70	-36.15	0.04	0.02	-50.00	278.12	271.81	-2.27	265.42	264.62	-0.30	0.00	0.01	100.00	11.62	6.17	-46.90

Back to IO Stats
Back to Top

IOStat by File Type - Data Rate per Second

Total Reads includes all Filetypes: Data File, Temp File, Archive Log, Backups, Control File, Data Pump Dump File, Flashback Log, Log File, Other, etc
Total Writes includes all Filetypes: Data File, Temp File, Log File, Archive Log, Backup, Control File, Data Pump Dump File, Flasbachk Log, Log File, Other, etc

Total Reads			Data File Reads			Temp File Reads			Total Writes			Data File Writes			Temp File Writes			Log File Writes
1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
1.00	0.70	-30.00	0.94	0.62	-34.04	0.00	0.01	100.00	9.87	6.69	-32.22	4.42	2.95	-33.26	0.00	0.01	100.00	5.43	3.72	-31.49

Back to IO Stats
Back to Top

IOStat by File Type - Requests per Second

Total Reads includes all Filetypes: Data File, Temp File, Archive Log, Backups, Control File, Data Pump Dump File, Flashback Log, Log File, Other, etc
Total Writes includes all Filetypes: Data File, Temp File, Log File, Archive Log, Backup, Control File, Data Pump Dump File, Flasbachk Log, Log File, Other, etc

Total Reads			Data File Reads			Temp File Reads			Total Writes			Data File Writes			Temp File Writes			Log File Writes
1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
116.59	76.45	-34.43	112.37	70.99	-36.82	0.03	0.79	2,533.33	278.11	271.80	-2.27	265.35	264.25	-0.41	0.11	0.40	263.64	11.50	6.09	-47.04

Back to IO Stats
Back to Top

Tablespace IO Stats

Ordered by absolute value of 'Diff' of IOs per second descending (IOs per sec: Avg Reads/Sec + Avg Writes/Sec)
Only contains tablespaces with at least 100 IOs
'N/A' indicates the tablespace did not exist in the database for the period

Tablespace	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	Diff
	Avg Reads / Sec			Avg Writes / Sec			Reads		Avg Read Time (ms)		Avg Blocks / Read		Writes		Buffer Waits		Avg Buf Wait Time (ms)		IOs per second
CMS	111.16	69.61	-37.38	122.78	82.57	-32.75	1,201,177	751,946	2.60	5.19	1.02	1.01	1,326,713	891,966	0	4	0.00	267.50	233.94	152.19	-81.75
UNDOTBS1	0.01	0.01	0.00	142.68	180.77	26.70	91	79	0.00	0.00	1.00	1.00	1,541,817	1,952,633	332	1,522	0.06	445.45	142.69	180.77	38.08
TEMP	0.03	0.79	2,533.33	0.11	0.40	263.64	344	8,533	2.35	19.58	3.51	1.73	1,165	4,326	0	0	0.00	0.00	0.14	1.19	1.05
SYSAUX	0.98	1.17	19.39	0.43	0.59	37.21	10,587	12,643	3.98	11.96	1.67	4.73	4,633	6,334	0	7	0.00	782.86	1.41	1.76	0.35
SYSTEM	0.21	0.22	4.76	0.03	0.02	-33.33	2,253	2,359	4.36	3.80	24.08	15.65	290	206	0	85	0.00	780.35	0.24	0.24	0.00

Back to IO Stats
Back to Top

Top File Comparison by IO

Ordered by absolute value of 'Diff' of IOs per second descending (IOs per sec: Avg Reads/Sec + Avg Writes/Sec)
Only contains files with at least 100 IOs

Tablespace	Filename	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	Diff
		Avg Reads / Sec			Avg Writes / Sec			Reads		Avg Read Time (ms)		Avg Blocks / Read		Writes		Buffer Waits		Avg Buf Wait Time (ms)		IOs per second
CMS	/oradata/PCOE/CMS01.DBF	55.68	34.84	-37.43	61.47	41.12	-33.11	601,645	376,294	2.60	5.17	1.02	1.01	664,188	444,154	0	4	0.00	267.50	117.14	75.95	-41.19
CMS	/oradata/PCOE/CMS02.DBF	55.48	34.78	-37.31	61.31	41.46	-32.38	599,532	375,652	2.61	5.21	1.02	1.01	662,525	447,812	0	0	0.00	0.00	116.79	76.23	-40.56
UNDOTBS1	/oradata/PCOE/undotbs01.dbf	0.01	0.01	0.00	142.68	180.77	26.70	91	79	0.00	0.00	1.00	1.00	1,541,817	1,952,633	332	1,522	0.06	445.45	142.69	180.77	38.08
TEMP	/oradata/PCOE/temp01.dbf	0.03	0.79	2,533.33	0.11	0.40	263.64	344	8,533	2.35	19.58	3.51	1.73	1,165	4,326	0	0	0.00	0.00	0.14	1.19	1.05
SYSAUX	/oradata/PCOE/sysaux01.dbf	0.98	1.17	19.39	0.43	0.59	37.21	10,587	12,643	3.98	11.96	1.67	4.73	4,633	6,334	0	7	0.00	782.86	1.41	1.76	0.35
SYSTEM	/oradata/PCOE/system01.dbf	0.21	0.22	4.76	0.03	0.02	-33.33	2,253	2,359	4.36	3.80	24.08	15.65	290	206	0	85	0.00	780.35	0.24	0.24	0.00

Back to IO Stats
Back to Top

		Read Time % of DB time	Avg Read Time (ms)	Reads	Avg Reads per Sec	Avg Blocks per Read	Writes	Avg Writes per Sec	Buffer Waits	Avg Buf Wait Time (ms)
Tablespace	Filename	1st	2nd	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd
CMS	/oradata/PCOE/CMS02.DBF	17.83	2.51	-15.32	2.61	5.21	599,532	375,652	55.48	34.78	1.02	1.01	662,525	447,812	61.31	41.46	0	0	0.00	0.00
CMS	/oradata/PCOE/CMS01.DBF	17.78	2.50	-15.29	2.60	5.17	601,645	376,294	55.68	34.84	1.02	1.01	664,188	444,154	61.47	41.12	0	4	0.00	26.75
SYSAUX	/oradata/PCOE/sysaux01.dbf	0.48	0.19	-0.29	3.98	11.96	10,587	12,643	0.98	1.17	1.67	4.73	4,633	6,334	0.43	0.59	0	7	0.00	78.29
TEMP	/oradata/PCOE/temp01.dbf	0.01	0.21	0.21	2.35	19.58	344	8,533	0.03	0.79	3.51	1.73	1,165	4,326	0.11	0.40	0	0	0.00	0.00
SYSTEM	/oradata/PCOE/system01.dbf	0.11	0.01	-0.10	4.36	3.80	2,253	2,359	0.21	0.22	24.08	15.65	290	206	0.03	0.02	0	85	0.00	78.04
UNDOTBS1	/oradata/PCOE/undotbs01.dbf	0.00	0.00	0.00	0.00	0.00	91	79	0.01	0.01	1.00	1.00	1,541,817	1,952,633	142.68	180.77	332	1,522	0.01	44.54

Top File Comparison by Buffer Waits

Ordered by files with greatest 'Wait Time % of DB time' from either period descending
Contains only entries with at least 1 second of wait time

Tablespace	Filename	1st	2nd	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd
		Wait Time % of DB time			Buffer Waits		Avg Buf Wait Time (ms)		Reads		Avg Reads per Sec		Avg Read Time (ms)		Avg Blocks per Read		Writes		Avg Writes per Sec
UNDOTBS1	/oradata/PCOE/undotbs01.dbf	0.00	0.87	0.87	332	1,522	0.01	44.54	91	79	0.01	0.01	0.00	0.00	1.00	1.00	1,541,817	1,952,633	143	181
SYSTEM	/oradata/PCOE/system01.dbf	0.00	0.09	0.09	0	85	0.00	78.04	2,253	2,359	0.21	0.22	4.36	3.80	24.08	15.65	290	206	0	0
SYSAUX	/oradata/PCOE/sysaux01.dbf	0.00	0.01	0.01	0	7	0.00	78.29	10,587	12,643	0.98	1.17	3.98	11.96	1.67	4.73	4,633	6,334	0	1
CMS	/oradata/PCOE/CMS01.DBF	0.00	0.00	0.00	0	4	0.00	26.75	601,645	376,294	55.68	34.84	2.60	5.17	1.02	1.01	664,188	444,154	61	41

Back to IO Stats
Back to Top

Advisory Statistics

Instance Recovery Stats
PGA Aggregate Summary
PGA Aggr Target Stats

Instance Recovery Stats

B: Begin Snapshot, E: End snapshot

	Target MTTR(s)	Estimated MTTR(s)	Recovery Estimated IOs	Actual Redo Blocks	Target Redo Blocks	Log File Size Redo Blocks	Log Ckpt Timeout Redo Blocks
B1	0	296	160,494	3,531,067	8,493,417	8,493,417	16,162,858
E1	0	200	93,568	3,116,808	8,493,417	8,493,417	16,247,206

B2	0	221	100,301	3,372,503	8,493,417	8,493,417	16,674,667
E2	0	231	74,678	4,042,809	8,493,417	8,493,417	16,069,785

Back to Advisory Statistics
Back to Top

PGA Aggregate Summary

PGA Cache Hit % - percentage of W/A (Work Area) data processed in-memory only

PGA Cache Hit %			W/A Bytes/Sec (DB time)			W/A MB Processed		Read/Written W/A Bytes/Sec (DB time)			Read/Written W/A MB
1st	2nd	Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	%Diff	1st	2nd
99.97	99.79	-0.18	2,051,905	142,783	-93.04	17,192	10,616	680	2,674	293.32	6	22

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B1: 1st Begin Snap E1: 1st End Snap B2: 2nd Begin Snap E2: 2nd End Snap
Data shown in the table represent actual values, i.e. not diffed over the interval
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)

Back to Advisory Statistics
Back to Top

Wait Stats

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

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

Class	1st	2nd	Diff	1st	2nd	1st	2nd	1st	2nd	%Diff
	Wait Time % of DB time			Total Wait Time (s)		# Waits		Avg Wait Time (ms)
undo header	0.00	0.01	0.01	0.02	677.97	332	1,516	0.00	4.47	100.00
data block	0.00	0.00	0.00	0.00	72.88	0	96	0.00	7.59	100.00
file header block	0.00	0.00	0.00	0.00	0.00	0	6	0.00	0.00	0.00

Back to Wait Stats
Back to Top

Enqueue Activity

Ordered by absolute value of 'Diff' Column of 'Wait Time % of DB time ' descending
Contains only entries with total wait time above 1 second

Enqueue Type (Request Reason)	1st	2nd	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd
	Wait Time % of DB time			Wait Time		Requests		Successful Gets		Failed Gets		Waits		Avg Wait Time (ms)
KO-Multiple Object Checkpoint (fast object checkpo	0.01	0.07	0.07	0	56	54	27	54	27	0	0	6	3	81.67	18,696.67
JD-Job Queue Date	0.00	0.01	0.01	0	8	2,358	2,345	2,358	2,345	0	0	0	1	0.00	7,980.00

Back to Wait 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
1st	4,733.23	48,454	784	6	113.9/740.2	0/0	0/0/0/0/0/0
2nd	3,355.12	59,812	1,772	19	117.4/178.1	0/0	0/0/0/0/0/0

Latch Statistics

Latch Sleep Breakdown
Latch Wait Time Breakdown

Latch Sleep Breakdown

Ordered by absolute value of 'Diff' Column of '% of Total Sleeps' descending

Latch Name	1st	2nd	Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	Diff
	% of Total Sleeps			Get Requests		Misses		Spin Gets		Sleeps		Wait Time (cs)
cache buffers lru chain	4.74	49.76	45.01	7,057,253	9,430,720	984	381,942	972	374,340	12	7,752	926	394,510	393,584
cache buffers chains	15.02	3.08	-11.94	3,292,833,458	2,212,014,628	31,909	88,606	31,874	88,137	38	480	2,315	42,857	40,542
call allocation	10.67	0.31	-10.36	5,486	5,495	48	83	22	41	27	48	3,028	4,209	1,181
redo allocation	53.75	46.32	-7.43	356,825	3,149,807	7,732	2,603,397	7,596	2,596,215	136	7,217	11,863	844,412	832,549
shared pool	6.32	0.10	-6.22	238,978	185,850	96	85	81	69	16	16	92,357	124,125	31,768
object queue header operation	5.53	0.47	-5.07	30,624,667	20,539,134	2,949	5,152	2,935	5,081	14	73	730	3,052	2,322
mostly latch-free SCN	1.58	0.01	-1.57	72,582	25,109	595	476	591	474	4	2	613	292	-321
simulator lru latch	1.19	0.01	-1.18	4,962,376	3,467,133	1,604	590	1,601	589	3	1	200	25	-175
active service list	0.79	0.01	-0.78	27,306	27,185	10	12	8	11	2	1	365	38	-327
simulator hash latch	0.40	0.01	-0.39	44,838,403	34,910,980	130	327	129	326	1	1	34	21	-13
undo global data	0.40	0.19	-0.20	12,169,265	7,298,517	284	3,295	283	3,265	1	30	112	7,609	7,497
list of block allocation	0.00	0.14	0.14	806,283	468,440	24	154	24	132	0	22	0	177,202	177,202
FOB s.o list latch	0.00	0.03	0.03	3,149	3,162	0	5	0	0	0	5	0	30,798	30,798
In memory undo latch	0.00	0.02	0.02	148,888	105,158	0	3	0	0	0	3	0	1,168	1,168
Consistent RBA	0.00	0.01	0.01	69,933	23,195	9	6	9	4	0	2	0	186	186
post/wait queue	0.00	0.01	0.01	35,577	9,808,051	0	126,208	0	126,206	0	2	0	63	63
object stats modification	0.00	0.01	0.01	199	1,244	0	1	0	0	0	1	0	580	580

Back to Latch Statistics
Back to Top

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
redo allocation	11,863	844,412	832,549	356,825	3,149,807	7,732	2,603,397	7,596	2,596,215	136	7,217	53.75	46.32	-7.43
cache buffers lru chain	926	394,510	393,584	7,057,253	9,430,720	984	381,942	972	374,340	12	7,752	4.74	49.76	45.01
list of block allocation	0	177,202	177,202	806,283	468,440	24	154	24	132	0	22	0.00	0.14	0.14
cache buffers chains	2,315	42,857	40,542	3,292,833,458	2,212,014,628	31,909	88,606	31,874	88,137	38	480	15.02	3.08	-11.94
shared pool	92,357	124,125	31,768	238,978	185,850	96	85	81	69	16	16	6.32	0.10	-6.22
FOB s.o list latch	0	30,798	30,798	3,149	3,162	0	5	0	0	0	5	0.00	0.03	0.03
undo global data	112	7,609	7,497	12,169,265	7,298,517	284	3,295	283	3,265	1	30	0.40	0.19	-0.20
object queue header operation	730	3,052	2,322	30,624,667	20,539,134	2,949	5,152	2,935	5,081	14	73	5.53	0.47	-5.07
call allocation	3,028	4,209	1,181	5,486	5,495	48	83	22	41	27	48	10.67	0.31	-10.36
In memory undo latch	0	1,168	1,168	148,888	105,158	0	3	0	0	0	3	0.00	0.02	0.02
object stats modification	0	580	580	199	1,244	0	1	0	0	0	1	0.00	0.01	0.01
active service list	365	38	-327	27,306	27,185	10	12	8	11	2	1	0.79	0.01	-0.78
mostly latch-free SCN	613	292	-321	72,582	25,109	595	476	591	474	4	2	1.58	0.01	-1.57
Consistent RBA	0	186	186	69,933	23,195	9	6	9	4	0	2	0.00	0.01	0.01
simulator lru latch	200	25	-175	4,962,376	3,467,133	1,604	590	1,601	589	3	1	1.19	0.01	-1.18
post/wait queue	0	63	63	35,577	9,808,051	0	126,208	0	126,206	0	2	0.00	0.01	0.01
simulator hash latch	34	21	-13	44,838,403	34,910,980	130	327	129	326	1	1	0.40	0.01	-0.39

Back to Latch Statistics
Back to Top

Segment Statistics

Top Segments Comparison by Logical Reads
Top Segments Comparison by Physical Reads
Top Segments Comparison by Physical Read Requests
Top Segments Comparison by UnOptimized Read Requests
Top Segments Comparison by Optimized Read Requests
Top Segments Comparison by Direct Physical Reads
Top Segments Comparison by Physical Writes
Top Segments Comparison by Physical Write Requests
Top Segments Comparison by Direct Physical Writes
Top Segments Comparison by Table Scans
Top Segments Comparison by DB Block Changes
Top Segments by Row Lock Waits
Top Segments by ITL Waits
Top Segments by Buffer Busy Waits
Top Segments by GC Buffer Busy Waits

					% of Total Logical Reads	Logical Reads	% of Captured Logical Reads
Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	19.09	0.00	0.00	-19.09	174,195,584	0	-100.00	19.63	0.00	-19.63
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	36.76	0.00	0.00	-17.67	161,270,576	0	-100.00	18.17	0.00	-18.17
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	55.85	1.51	1.51	-17.57	174,195,584	9,137,968	-94.75	19.63	1.69	-17.94
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	74.94	2.12	3.63	-16.97	174,195,584	12,777,168	-92.67	19.63	2.37	-17.26
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	94.02	2.33	5.97	-16.75	174,195,584	14,085,472	-91.91	19.63	2.61	-17.02
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	113.11	2.91	8.88	-16.18	174,195,584	17,548,320	-89.93	19.63	3.25	-16.38
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	130.78	1.51	10.39	-16.16	161,270,576	9,137,968	-94.33	18.17	1.69	-16.48
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	149.87	3.02	13.41	-16.07	174,195,584	18,196,464	-89.55	19.63	3.37	-16.26
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	165.73	0.00	13.41	-15.86	144,720,992	0	-100.00	16.31	0.00	-16.31
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	184.82	3.44	16.85	-15.65	174,195,584	20,747,984	-88.09	19.63	3.85	-15.78
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	202.49	2.12	18.96	-15.55	161,270,576	12,777,168	-92.08	18.17	2.37	-15.80
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	220.16	2.33	21.30	-15.34	161,270,576	14,085,472	-91.27	18.17	2.61	-15.56
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	239.25	4.26	25.55	-14.83	174,195,584	25,679,952	-85.26	19.63	4.76	-14.87
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	256.92	2.91	28.46	-14.76	161,270,576	17,548,320	-89.12	18.17	3.25	-14.92
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	274.59	3.02	31.48	-14.66	161,270,576	18,196,464	-88.72	18.17	3.37	-14.80
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	290.45	1.51	32.99	-14.34	144,720,992	9,137,968	-93.69	16.31	1.69	-14.61
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	308.12	3.44	36.43	-14.23	161,270,576	20,747,984	-87.13	18.17	3.85	-14.33
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	327.21	5.11	41.54	-13.98	174,195,584	30,825,184	-82.30	19.63	5.71	-13.92
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	346.30	5.18	46.73	-13.90	174,195,584	31,281,888	-82.04	19.63	5.80	-13.83
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	362.16	2.12	48.84	-13.74	144,720,992	12,777,168	-91.17	16.31	2.37	-13.94
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	378.02	2.33	51.18	-13.52	144,720,992	14,085,472	-90.27	16.31	2.61	-13.70
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	397.10	5.62	56.80	-13.47	174,195,584	33,897,568	-80.54	19.63	6.28	-13.35
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	414.78	4.26	61.05	-13.42	161,270,576	25,679,952	-84.08	18.17	4.76	-13.41
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	430.63	2.91	63.96	-12.95	144,720,992	17,548,320	-87.87	16.31	3.25	-13.06
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	446.49	3.02	66.98	-12.84	144,720,992	18,196,464	-87.43	16.31	3.37	-12.94
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	465.58	6.30	73.28	-12.79	174,195,584	38,010,896	-78.18	19.63	7.05	-12.58
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	478.22	0.00	73.28	-12.64	115,388,640	0	-100.00	13.00	0.00	-13.00
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	495.90	5.11	78.39	-12.56	161,270,576	30,825,184	-80.89	18.17	5.71	-12.46
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	513.57	5.18	83.57	-12.49	161,270,576	31,281,888	-80.60	18.17	5.80	-12.37
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	529.43	3.44	87.01	-12.42	144,720,992	20,747,984	-85.66	16.31	3.85	-12.46
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	547.10	5.62	92.63	-12.05	161,270,576	33,897,568	-78.98	18.17	6.28	-11.89
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	562.96	4.26	96.89	-11.60	144,720,992	25,679,952	-82.26	16.31	4.76	-11.55
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	580.63	6.30	103.19	-11.37	161,270,576	38,010,896	-76.43	18.17	7.05	-11.13
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.02	580.65	11.39	114.58	11.37	188,304	68,713,904	36,390.94	0.02	12.74	12.72
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	599.74	7.86	122.43	-11.23	174,195,584	47,415,568	-72.78	19.63	8.79	-10.84
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	612.38	1.51	123.95	-11.13	115,388,640	9,137,968	-92.08	13.00	1.69	-11.31
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.28	612.66	11.39	135.34	11.11	2,542,016	68,713,904	2,603.13	0.29	12.74	12.45
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	628.52	5.11	140.45	-10.75	144,720,992	30,825,184	-78.70	16.31	5.71	-10.59
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	644.38	5.18	145.63	-10.67	144,720,992	31,281,888	-78.38	16.31	5.80	-10.51
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	657.02	2.12	147.75	-10.53	115,388,640	12,777,168	-88.93	13.00	2.37	-10.63
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	669.66	2.33	150.09	-10.31	115,388,640	14,085,472	-87.79	13.00	2.61	-10.39
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	685.52	5.62	155.70	-10.24	144,720,992	33,897,568	-76.58	16.31	6.28	-10.02
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	703.19	7.86	163.56	-9.81	161,270,576	47,415,568	-70.60	18.17	8.79	-9.38
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.02	703.22	9.80	173.36	9.78	188,304	59,112,352	31,291.98	0.02	10.96	10.94
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	715.86	2.91	176.27	-9.74	115,388,640	17,548,320	-84.79	13.00	3.25	-9.75
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	728.50	3.02	179.29	-9.63	115,388,640	18,196,464	-84.23	13.00	3.37	-9.63
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	744.36	6.30	185.59	-9.56	144,720,992	38,010,896	-73.74	16.31	7.05	-9.26
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.28	744.64	9.80	195.38	9.52	2,542,016	59,112,352	2,225.41	0.29	10.96	10.67
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	763.73	9.80	205.18	-9.29	174,195,584	59,112,352	-66.07	19.63	10.96	-8.67
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	776.37	3.44	208.62	-9.21	115,388,640	20,747,984	-82.02	13.00	3.85	-9.16
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	789.02	4.26	212.88	-8.39	115,388,640	25,679,952	-77.74	13.00	4.76	-8.24
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	804.87	7.86	220.74	-8.00	144,720,992	47,415,568	-67.24	16.31	8.79	-7.52
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	822.55	9.80	230.53	-7.87	161,270,576	59,112,352	-63.35	18.17	10.96	-7.22
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.02	822.57	7.86	238.39	7.84	188,304	47,415,568	25,080.33	0.02	8.79	8.77
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	19.09	841.66	11.39	249.78	-7.70	174,195,584	68,713,904	-60.55	19.63	12.74	-6.89
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.28	841.93	7.86	257.64	7.58	2,542,016	47,415,568	1,765.27	0.29	8.79	8.50
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	854.58	5.11	262.75	-7.53	115,388,640	30,825,184	-73.29	13.00	5.71	-7.29
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	867.22	5.18	267.93	-7.46	115,388,640	31,281,888	-72.89	13.00	5.80	-7.20
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	879.87	5.62	273.55	-7.03	115,388,640	33,897,568	-70.62	13.00	6.28	-6.72
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	892.51	6.30	279.85	-6.34	115,388,640	38,010,896	-67.06	13.00	7.05	-5.96
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	17.67	910.18	11.39	291.24	-6.28	161,270,576	68,713,904	-57.39	18.17	12.74	-5.44
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.02	910.20	6.30	297.54	6.28	188,304	38,010,896	20,085.92	0.02	7.05	7.02
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	926.06	9.80	307.34	-6.06	144,720,992	59,112,352	-59.15	16.31	10.96	-5.35
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.28	926.34	6.30	313.64	6.02	2,542,016	38,010,896	1,395.31	0.29	7.05	6.76
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	932.11	0.00	313.64	-5.77	52,675,760	0	-100.00	5.94	0.00	-5.94
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	937.88	11.39	325.03	5.62	52,675,760	68,713,904	30.45	5.94	12.74	6.80
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.02	937.90	5.62	330.65	5.60	188,304	33,897,568	17,901.51	0.02	6.28	6.26
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	0.28	938.18	5.62	336.27	5.34	2,542,016	33,897,568	1,233.49	0.29	6.28	6.00
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	950.83	7.86	344.13	-4.79	115,388,640	47,415,568	-58.91	13.00	8.79	-4.21
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	15.86	966.69	11.39	355.52	-4.47	144,720,992	68,713,904	-52.52	16.31	12.74	-3.57
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	972.46	1.51	357.03	-4.26	52,675,760	9,137,968	-82.65	5.94	1.69	-4.24
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	978.23	9.80	366.83	4.03	52,675,760	59,112,352	12.22	5.94	10.96	5.02
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	984.00	2.12	368.95	-3.65	52,675,760	12,777,168	-75.74	5.94	2.37	-3.57
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	989.77	2.33	371.28	-3.44	52,675,760	14,085,472	-73.26	5.94	2.61	-3.32
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	995.55	2.91	374.19	-2.86	52,675,760	17,548,320	-66.69	5.94	3.25	-2.68
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	1,008.19	9.80	383.99	-2.85	115,388,640	59,112,352	-48.77	13.00	10.96	-2.05
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	1,013.96	3.02	387.00	-2.76	52,675,760	18,196,464	-65.46	5.94	3.37	-2.56
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	1,019.73	3.44	390.44	-2.33	52,675,760	20,747,984	-60.61	5.94	3.85	-2.09
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	1,025.51	7.86	398.30	2.09	52,675,760	47,415,568	-9.99	5.94	8.79	2.85
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	1,031.28	4.26	402.56	-1.52	52,675,760	25,679,952	-51.25	5.94	4.76	-1.18
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	12.64	1,043.92	11.39	413.95	-1.25	115,388,640	68,713,904	-40.45	13.00	12.74	-0.27
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	1,049.69	5.11	419.06	-0.66	52,675,760	30,825,184	-41.48	5.94	5.71	-0.22
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	1,055.47	5.18	424.24	-0.59	52,675,760	31,281,888	-40.61	5.94	5.80	-0.14
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	1,061.24	6.30	430.54	0.53	52,675,760	38,010,896	-27.84	5.94	7.05	1.11
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID		INDEX	5.77	1,067.01	5.62	436.16	-0.15	52,675,760	33,897,568	-35.65	5.94	6.28	0.35

					% of Total Physical Reads	Physical Reads	% of Captured Physical Reads
Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_C_1895019553		INDEX	13.90	13.90	2.16	2.16	-11.74	180,029	18,804	-89.56	25.10	13.35	-11.75
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1372163279		INDEX	9.54	23.44			-9.54	123,567			17.23		-17.23
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1119058614		INDEX	9.37	32.81			-9.37	121,407			16.93		-16.93
CMS_902_14M_CMDB	CMS	PK_CDM_ROOT_1		INDEX	7.60	40.42			-7.60	98,479			13.73		-13.73
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1652243655		INDEX			1.64	3.79	1.64		14,293			10.15	10.15
SYS	SYSTEM	AUD$		TABLE			1.06	4.85	1.06		9,225			6.55	6.55
CMS_902_14M_HIST	CMS	IX1_HIST_INF_STR_OBJECT_ID		INDEX	4.00	44.42	3.63	8.48	-0.37	51,782	31,681	-38.82	7.22	22.49	15.27
CMS_902_14M_CMDB	CMS	PK_CDM_COMPOSITION_1		INDEX	2.08	46.50	2.07	10.55	-0.01	26,988	18,072	-33.04	3.76	12.83	9.07

					% of Total Read Requests	Read Requests	% of Captured Read Requests
Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_C_1895019553		INDEX	14.83	14.83	2.43	2.43	-12.40	180,029	18,804	-89.56	25.83	17.16	-8.67
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1372163279		INDEX	10.18	25.00			-10.18	123,567			17.73		-17.73
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1119058614		INDEX	10.00	35.00			-10.00	121,407			17.42		-17.42
CMS_902_14M_CMDB	CMS	PK_CDM_ROOT_1		INDEX	8.11	43.11			-8.11	98,479			14.13		-14.13
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1652243655		INDEX			1.84	4.27	1.84		14,293			13.04	13.04
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_E_144855667		INDEX	2.28	45.40	0.61	4.88	-1.68	27,723	4,695	-83.06	3.98	4.28	0.31
CMS_902_14M_CMDB	CMS	PK_CDM_COMPOSITION_1		INDEX	1.57	46.97	1.80	6.68	0.23	19,110	13,978	-26.86	2.74	12.75	10.01
CMS_902_14M_HIST	CMS	IX1_HIST_INF_STR_OBJECT_ID		INDEX	4.26	51.24	4.09	10.77	-0.18	51,782	31,681	-38.82	7.43	28.91	21.48

					% of Total UnOptimized Requests	UnOptimized Requests	% of Captured UnOptimized Reqs
Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_C_1895019553		INDEX	14.83	14.83	2.43	2.43	-12.40	180,029	18,804	-89.56	25.83	17.16	-8.67
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1372163279		INDEX	10.18	25.00			-10.18	123,567			17.73		-17.73
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1119058614		INDEX	10.00	35.00			-10.00	121,407			17.42		-17.42
CMS_902_14M_CMDB	CMS	PK_CDM_ROOT_1		INDEX	8.11	43.11			-8.11	98,479			14.13		-14.13
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1652243655		INDEX			1.84	4.27	1.84		14,293			13.04	13.04
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_E_144855667		INDEX	2.28	45.40	0.61	4.88	-1.68	27,723	4,695	-83.06	3.98	4.28	0.31
CMS_902_14M_CMDB	CMS	PK_CDM_COMPOSITION_1		INDEX	1.57	46.97	1.80	6.68	0.23	19,110	13,978	-26.86	2.74	12.75	10.01
CMS_902_14M_HIST	CMS	IX1_HIST_INF_STR_OBJECT_ID		INDEX	4.26	51.24	4.09	10.77	-0.18	51,782	31,681	-38.82	7.43	28.91	21.48

					% of Total Optimized Read Requests	Optimized Requests	% of Captured Optimized Reqs
Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
SYS	SYSTEM	AUD$		TABLE			0.00	0.00	0.00		0			0.00	0.00
SYS	SYSTEM	COL$		TABLE	0.00	0.00			0.00	0		100.00	0.00		0.00
SYS	SYSTEM	JOB$		TABLE			0.00	0.00	0.00		0			0.00	0.00
SYS	SYSTEM	LOB$		TABLE	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSTEM	TAB$		TABLE			0.00	0.00	0.00		0			0.00	0.00
SYS	SYSAUX	WRH$_PGASTAT		TABLE	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSAUX	WRH$_PROCESS_MEMORY_SUMMARY		TABLE	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSAUX	WRI$_ADV_MSG_GRPS_IDX_01		INDEX	0.00	0.00			0.00	0		100.00	0.00		0.00
SYS	SYSAUX	WRI$_OPTSTAT_HISTHEAD_HISTORY		TABLE			0.00	0.00	0.00		0			0.00	0.00

					% of Total Direct Reads	Direct Reads	% of Captured Direct Reads
Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
SYS	SYSTEM	AUD$		TABLE			0.00	0.00	0.00		0			0.00	0.00
SYS	SYSTEM	COL$		TABLE	0.00	0.00			0.00	0		100.00	0.00		0.00
SYS	SYSTEM	JOB$		TABLE			0.00	0.00	0.00		0			0.00	0.00
SYS	SYSTEM	LOB$		TABLE	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSTEM	TAB$		TABLE			0.00	0.00	0.00		0			0.00	0.00
SYS	SYSAUX	WRH$_PGASTAT		TABLE	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSAUX	WRH$_PROCESS_MEMORY_SUMMARY		TABLE	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSAUX	WRI$_ADV_MSG_GRPS_IDX_01		INDEX	0.00	0.00			0.00	0		100.00	0.00		0.00
SYS	SYSAUX	WRI$_OPTSTAT_HISTHEAD_HISTORY		TABLE			0.00	0.00	0.00		0			0.00	0.00

Top Segments Comparison by Physical Writes

Ordered by absolute value of 'Diff' column of '% of Total Physical Writes'
Top 5 Segments from each period are compared
Total Physical Writes First: 6,122,711, Second: 4,082,038
Captured Physical Writes First: 991,695, Second: 206,230
Captured Physical Writes as % of Total First: 16.2%, Second: 5.05%

Owner	Tablespace	Object Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
				% of Total Physical Writes					Physical Writes			% of Captured Physical Writes
CMS_902_14M_CMDB	CMS	PK_CDM_ROOT_1	INDEX	3.07	3.07			-3.07	187,830			18.94		-18.94
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1119058614	INDEX	2.95	6.02			-2.95	180,838			18.24		-18.24
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_C_1895019553	INDEX	3.05	9.07	0.42	0.42	-2.63	186,537	17,186	-90.79	18.81	8.33	-10.48
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1372163279	INDEX	2.08	11.15			-2.08	127,384			12.85		-12.85
CMS_902_14M_HIST	CMS	IX1_HIST_INF_STR_OBJECT_ID	INDEX	1.02	12.17	0.93	1.35	-0.09	62,324	38,035	-38.97	6.28	18.44	12.16
CMS_902_14M_CMDB	CMS	PK_CDM_COMPOSITION_1	INDEX	1.44	13.61	1.41	2.76	-0.03	88,141	57,442	-34.83	8.89	27.85	18.97
CMS_902_14M_CMDB	CMS	IX1_CDM_COMPOSITION_1_END1_ID	INDEX	0.53	14.14	0.52	3.28	-0.02	32,671	21,156	-35.25	3.29	10.26	6.96
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_E_144855667	INDEX	0.58	14.72	0.59	3.86	0.00	35,684	23,881	-33.08	3.60	11.58	7.98

Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Write Requests

Ordered by absolute value of 'Diff' column of '% of Total Write Requests'

Owner	Tablespace	Object Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
				% of Total Write Requests					Write Requests			% of Captured Write Requests
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_C_1895019553	INDEX	6.18	6.18	0.59	0.59	-5.59	177,386	16,773	-90.54	21.85	10.16	-11.69
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1119058614	INDEX	5.32	11.50			-5.32	152,775			18.82		-18.82
CMS_902_14M_CMDB	CMS	PK_CDM_ROOT_1	INDEX	5.18	16.68			-5.18	148,613			18.31		-18.31
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1372163279	INDEX	4.12	20.80			-4.12	118,424			14.59		-14.59
CMS_902_14M_CMDB	CMS	PK_CDM_COMPOSITION_1	INDEX	2.43	23.23	1.70	2.29	-0.73	69,721	48,550	-30.37	8.59	29.41	20.82
CMS_902_14M_HIST	CMS	IX1_HIST_INF_STR_OBJECT_ID	INDEX	1.85	25.08	1.26	3.55	-0.59	53,193	35,924	-32.46	6.55	21.76	15.21
CMS_902_14M_CMDB	CMS	IX1_CDM_ROOT_1_A__1652243655	INDEX			0.52	4.07	0.52		14,929			9.04	9.04
CMS_902_14M_CMDB	CMS	IX1_CDM_COMPOSITION_1_END1_ID	INDEX	1.05	26.13	0.70	4.77	-0.35	30,200	19,952	-33.93	3.72	12.08	8.36

Back to Segment Statistics
Back to Top

Top Segments Comparison by Direct Physical Writes

Ordered by absolute value of 'Diff' column of '% of Total Direct Writes'
Top 5 Segments from each period are compared
Total Direct Writes First: 111, Second: 1,537
Captured Direct Writes First: 62, Second: 445
Captured Direct Writes as % of Total First: 55.86%, Second: 28.95%

Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
					% of Total Direct Writes					Direct Writes			% of Captured Direct Writes
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_409011274_2488	TABLE PARTITION	55.86	55.86	28.95	28.95	-26.90	62	445	617.74	100.00	100.00	0.00
SYS	SYSTEM	AUD$		TABLE			0.00	28.95	0.00		0			0.00	0.00
SYS	SYSTEM	COL$		TABLE	0.00	55.86			0.00	0		100.00	0.00		0.00
SYS	SYSTEM	JOB$		TABLE			0.00	28.95	0.00		0			0.00	0.00
SYS	SYSTEM	LOB$		TABLE	0.00	55.86	0.00	28.95	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSTEM	TAB$		TABLE			0.00	28.95	0.00		0			0.00	0.00
SYS	SYSAUX	WRH$_PGASTAT		TABLE	0.00	55.86	0.00	28.95	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSAUX	WRI$_ADV_MSG_GRPS_IDX_01		INDEX	0.00	55.86			0.00	0		100.00	0.00		0.00

Back to Segment Statistics
Back to Top

Top Segments Comparison by Table Scans

Ordered by absolute value of 'Diff' column of '% of Total Table Scans'
Top 5 Segments from each period are compared
Total Table Scans First: 12,488, Second: 7,099
Captured Table Scans First: 5,678, Second: 1,856
Captured Table Scans as % of Total First: 45.47%, Second: 26.14%

Owner	Tablespace	Object Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
				% of Total Table Scans					Table Scans			% of Captured Table Scans
CMS_902_14M_CMDB	CMS	IX1_CDM_NT_1_A_DI_897432235	INDEX	19.07	19.07			-19.07	2,382			41.95		-41.95
CMS_902_14M_CMDB	CMS	IX1_CDM_WINOSUSER_271951258	INDEX	14.63	33.70	14.40	14.40	-0.23	1,827	1,022	-44.06	32.18	55.06	22.89
CMS_902_14M_CMDB	CMS	IX1_CDM_WINDOWS_S_72912280	INDEX	5.85	39.56	5.78	20.17	-0.08	731	410	-43.91	12.87	22.09	9.22
CMS_902_14M_CMDB	CMS	PK_CDM_COMPOSITION_1	INDEX	0.07	39.63	0.13	20.30	0.05	9	9	0.00	0.16	0.48	0.33
CMS_902_14M_CMDB	CMS	IX1_CDM_INSTALLED_2015003763	INDEX	2.92	42.55	2.90	23.20	-0.02	365	206	-43.56	6.43	11.10	4.67
CMS_902_14M_CMDB	CMS	IX1_CDM_PROCESS_1_1602320258	INDEX	2.91	45.47	2.92	26.12	0.00	364	207	-43.13	6.41	11.15	4.74

Back to Segment Statistics
Back to Top

Top Segments Comparison by DB Block Changes

Ordered by absolute value of 'Diff' column of '% of Total Block Changes'
Top 5 Segments from each period are compared
Total DB Block Changes First: 673,376,583, Second: 458,503,171
Captured DB Block Changes First: 336,517,856, Second: 201,622,480
Captured DB Block Changes as % of Total First: 49.97%, Second: 43.97%

Owner	Tablespace	Object Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
				% of Total Block Changes					DB Block Changes			% of Captured Block Changes
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	8.93	0.00	0.00	-8.93	60,144,800	0	-100.00	17.87	0.00	-17.87
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	17.51	0.00	0.00	-8.58	57,758,512	0	-100.00	17.16	0.00	-17.16
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	26.44	0.72	0.72	-8.21	60,144,800	3,314,096	-94.49	17.87	1.64	-16.23
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	35.37	0.76	1.48	-8.17	60,144,800	3,478,272	-94.22	17.87	1.73	-16.15
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	44.30	1.07	2.55	-7.86	60,144,800	4,910,928	-91.83	17.87	2.44	-15.44
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	52.88	0.72	3.28	-7.85	57,758,512	3,314,096	-94.26	17.16	1.64	-15.52
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	61.46	0.76	4.03	-7.82	57,758,512	3,478,272	-93.98	17.16	1.73	-15.44
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	70.39	1.18	5.21	-7.76	60,144,800	5,391,552	-91.04	17.87	2.67	-15.20
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	78.97	1.07	6.28	-7.51	57,758,512	4,910,928	-91.50	17.16	2.44	-14.73
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	87.55	1.18	7.46	-7.40	57,758,512	5,391,552	-90.67	17.16	2.67	-14.49
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	96.48	1.62	9.08	-7.31	60,144,800	7,433,408	-87.64	17.87	3.69	-14.19
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	105.41	1.67	10.75	-7.26	60,144,800	7,665,360	-87.26	17.87	3.80	-14.07
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	112.57	0.00	10.75	-7.16	48,243,632	0	-100.00	14.34	0.00	-14.34
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	121.15	1.62	12.37	-6.96	57,758,512	7,433,408	-87.13	17.16	3.69	-13.48
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	129.73	1.67	14.04	-6.91	57,758,512	7,665,360	-86.73	17.16	3.80	-13.36
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	138.66	2.25	16.29	-6.68	60,144,800	10,303,008	-82.87	17.87	5.11	-12.76
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	147.59	2.29	18.58	-6.64	60,144,800	10,491,248	-82.56	17.87	5.20	-12.67
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	156.52	2.33	20.91	-6.60	60,144,800	10,705,872	-82.20	17.87	5.31	-12.56
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	165.46	2.41	23.33	-6.52	60,144,800	11,066,256	-81.60	17.87	5.49	-12.38
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	172.62	0.72	24.05	-6.44	48,243,632	3,314,096	-93.13	14.34	1.64	-12.69
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	179.79	0.76	24.81	-6.41	48,243,632	3,478,272	-92.79	14.34	1.73	-12.61
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	188.72	2.59	27.40	-6.34	60,144,800	11,884,336	-80.24	17.87	5.89	-11.98
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	197.29	2.25	29.65	-6.33	57,758,512	10,303,008	-82.16	17.16	5.11	-12.05
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	205.87	2.29	31.94	-6.29	57,758,512	10,491,248	-81.84	17.16	5.20	-11.96
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	214.45	2.33	34.27	-6.24	57,758,512	10,705,872	-81.46	17.16	5.31	-11.85
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	223.03	2.41	36.68	-6.16	57,758,512	11,066,256	-80.84	17.16	5.49	-11.67
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	230.19	1.07	37.75	-6.09	48,243,632	4,910,928	-89.82	14.34	2.44	-11.90
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	236.20	0.00	37.75	-6.01	40,454,320	0	-100.00	12.02	0.00	-12.02
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	243.36	1.18	38.93	-5.99	48,243,632	5,391,552	-88.82	14.34	2.67	-11.66
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	251.94	2.59	41.52	-5.99	57,758,512	11,884,336	-79.42	17.16	5.89	-11.27
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	259.11	1.62	43.14	-5.54	48,243,632	7,433,408	-84.59	14.34	3.69	-10.65
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	266.27	1.67	44.82	-5.49	48,243,632	7,665,360	-84.11	14.34	3.80	-10.53
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.01	266.28	5.35	50.17	5.34	51,440	24,528,752	47,584.20	0.02	12.17	12.15
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	272.29	0.72	50.89	-5.28	40,454,320	3,314,096	-91.81	12.02	1.64	-10.38
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	278.29	0.76	51.65	-5.25	40,454,320	3,478,272	-91.40	12.02	1.73	-10.30
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.11	278.41	5.35	57.00	5.24	755,376	24,528,752	3,147.22	0.22	12.17	11.94
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	287.34	3.97	60.97	-4.96	60,144,800	18,211,344	-69.72	17.87	9.03	-8.84
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.01	287.34	4.97	65.94	4.96	51,440	22,771,616	44,168.30	0.02	11.29	11.28
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	293.35	1.07	67.01	-4.94	40,454,320	4,910,928	-87.86	12.02	2.44	-9.59
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	300.52	2.25	69.25	-4.92	48,243,632	10,303,008	-78.64	14.34	5.11	-9.23
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	307.68	2.29	71.54	-4.88	48,243,632	10,491,248	-78.25	14.34	5.20	-9.13
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.11	307.79	4.97	76.51	4.85	755,376	22,771,616	2,914.61	0.22	11.29	11.07
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	313.80	1.18	77.68	-4.83	40,454,320	5,391,552	-86.67	12.02	2.67	-9.35
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	320.97	2.33	80.02	-4.83	48,243,632	10,705,872	-77.81	14.34	5.31	-9.03
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	328.13	2.41	82.43	-4.75	48,243,632	11,066,256	-77.06	14.34	5.49	-8.85
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	336.71	3.97	86.40	-4.61	57,758,512	18,211,344	-68.47	17.16	9.03	-8.13
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	343.87	2.59	89.00	-4.57	48,243,632	11,884,336	-75.37	14.34	5.89	-8.44
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	349.88	1.62	90.62	-4.39	40,454,320	7,433,408	-81.63	12.02	3.69	-8.33
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	355.89	1.67	92.29	-4.34	40,454,320	7,665,360	-81.05	12.02	3.80	-8.22
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	360.20	0.00	92.29	-4.31	29,031,168	21,056	-99.93	8.63	0.01	-8.62
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	364.51	0.14	92.43	-4.17	29,031,168	641,984	-97.79	8.63	0.32	-8.31
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	368.82	0.22	92.65	-4.09	29,031,168	993,136	-96.58	8.63	0.49	-8.13
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	373.13	0.33	92.98	-3.99	29,031,168	1,490,624	-94.87	8.63	0.74	-7.89
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	382.06	4.97	97.94	-3.97	60,144,800	22,771,616	-62.14	17.87	11.29	-6.58
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.01	382.07	3.97	101.91	3.96	51,440	18,211,344	35,303.08	0.02	9.03	9.02
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	386.38	0.42	102.33	-3.89	29,031,168	1,922,880	-93.38	8.63	0.95	-7.67
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.11	386.50	3.97	106.31	3.86	755,376	18,211,344	2,310.90	0.22	9.03	8.81
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	392.50	2.25	108.55	-3.76	40,454,320	10,303,008	-74.53	12.02	5.11	-6.91
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	398.51	2.29	110.84	-3.72	40,454,320	10,491,248	-74.07	12.02	5.20	-6.82
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	404.52	2.33	113.18	-3.67	40,454,320	10,705,872	-73.54	12.02	5.31	-6.71
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	413.10	4.97	118.14	-3.61	57,758,512	22,771,616	-60.57	17.16	11.29	-5.87
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	419.10	2.41	120.56	-3.59	40,454,320	11,066,256	-72.65	12.02	5.49	-6.53
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.93	428.04	5.35	125.91	-3.58	60,144,800	24,528,752	-59.22	17.87	12.17	-5.71
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	432.35	0.74	126.65	-3.57	29,031,168	3,392,608	-88.31	8.63	1.68	-6.94
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	438.35	2.59	129.24	-3.42	40,454,320	11,884,336	-70.62	12.02	5.89	-6.13
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	442.67	0.99	130.23	-3.32	29,031,168	4,528,896	-84.40	8.63	2.25	-6.38
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	8.58	451.24	5.35	135.57	-3.23	57,758,512	24,528,752	-57.53	17.16	12.17	-5.00
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	458.41	3.97	139.55	-3.19	48,243,632	18,211,344	-62.25	14.34	9.03	-5.30
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	462.72	1.14	140.69	-3.17	29,031,168	5,230,656	-81.98	8.63	2.59	-6.03
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	467.03	1.53	142.21	-2.79	29,031,168	6,995,296	-75.90	8.63	3.47	-5.16
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	471.34	1.55	143.76	-2.76	29,031,168	7,090,048	-75.58	8.63	3.52	-5.11
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	475.65	1.58	145.34	-2.73	29,031,168	7,264,880	-74.98	8.63	3.60	-5.02
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.01	475.66	2.59	147.94	2.58	51,440	11,884,336	23,003.30	0.02	5.89	5.88
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	2.86	478.52	5.35	153.29	2.49	19,268,288	24,528,752	27.30	5.73	12.17	6.44
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.11	478.63	2.59	155.88	2.48	755,376	11,884,336	1,473.30	0.22	5.89	5.67
CMS_902_14M_CMDB	TEMP	CDM_TMP_OBJID	TABLE	4.31	482.94	1.88	157.75	-2.43	29,031,168	8,605,776	-70.36	8.63	4.27	-4.36
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.01	482.95	2.41	160.17	2.41	51,440	11,066,256	21,412.94	0.02	5.49	5.47
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	0.11	483.06	2.41	162.58	2.30	755,376	11,066,256	1,365.00	0.22	5.49	5.26
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	490.23	4.97	167.55	-2.20	48,243,632	22,771,616	-52.80	14.34	11.29	-3.04
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	2.86	493.09	4.97	172.51	2.11	19,268,288	22,771,616	18.18	5.73	11.29	5.57
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	499.10	3.97	176.49	-2.04	40,454,320	18,211,344	-54.98	12.02	9.03	-2.99
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	7.16	506.26	5.35	181.84	-1.81	48,243,632	24,528,752	-49.16	14.34	12.17	-2.17
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	2.86	509.12	3.97	185.81	1.11	19,268,288	18,211,344	-5.49	5.73	9.03	3.31
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	515.13	4.97	190.78	-1.04	40,454,320	22,771,616	-43.71	12.02	11.29	-0.73
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	6.01	521.14	5.35	196.12	-0.66	40,454,320	24,528,752	-39.37	12.02	12.17	0.14
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	2.86	524.00	2.41	198.54	-0.45	19,268,288	11,066,256	-42.57	5.73	5.49	-0.24
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX	2.86	526.86	2.59	201.13	-0.27	19,268,288	11,884,336	-38.32	5.73	5.89	0.17

Back to Segment Statistics
Back to Top

Top Segments by Row Lock Waits

Ordered by absolute value of 'Diff' column' of '% of Captured'
Top 5 Segments from each period are compared
TX Row Lock Waits First: 1, Second: 1
Total TX Row Lock Wait Time First: 0.00 seconds, Second: 0.00 seconds
TX Row Lock Wait Time as % of DB time First: 0%, Second: 0%
Captured Row Lock Waits First: 566, Second: 5,116

Owner	Tablespace	Object Name	Type	1st	2nd	Diff	1st	2nd	%Diff	1st	1st Total	2nd	2nd Total	Diff
				% of Total			Row Lock Waits			% of Captured
CMS_902_14M_HIST	CMS	PK_HIST_INF_STR	INDEX	9400.00		-9400.00	94			16.61	16.61			-16.61
CMS_902_14M_HIST	CMS	PK_HIST_EVENTS	INDEX	7000.00		-7000.00	70			12.37	28.98			-12.37
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_EVENT_TIME	INDEX	5600.00		-5600.00	56			9.89	38.87			-9.89
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_O_631110669	INDEX		49800.00	49800.00		498				9.73	9.73	9.73
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX		44600.00	44600.00		446				8.72	18.45	8.72
CMS_902_14M_HIST	CMS	IX1_HIST_INF_STR_END_TIME	INDEX	7200.00	33000.00	25800.00	72	330	358.33	12.72	51.59	6.45	24.90	-6.27
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX		29400.00	29400.00		294				5.75	30.65	5.75
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_C_1097352370	INDEX	8000.00	67200.00	59200.00	80	672	740.00	14.13	65.72	13.14	43.78	-1.00

Back to Segment Statistics
Back to Top

Top Segments by ITL Waits

Ordered by absolute value of 'Diff' column' of '% of Captured'
Top 5 Segments from each period are compared
Total TX ITL Waits First: 1, Second: 1
TX ITL Wait Time First: 0.00 seconds, Second: 0.00 seconds
TX ITL Wait Time as % of DB time First: 0%, Second: 0%
Captured TX ITL Waits First: 8, Second: 181

Owner	Tablespace	Object Name	Type	1st	2nd	Diff	1st	2nd	%Diff	1st	1st Total	2nd	2nd Total	Diff
				% of Total			ITL Waits			% of Captured
CMS_902_14M_HIST	CMS	PK_HIST_INF_STR	INDEX	600.00	1000.00	400.00	6	10	66.67	75.00	75.00	5.52	5.52	-69.48
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX		4200.00	4200.00		42				23.20	28.73	23.20
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX		3700.00	3700.00		37				20.44	49.17	20.44
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX		3400.00	3400.00		34				18.78	67.96	18.78
CMS_902_14M_CMDB	TEMP	IX1_CDM_TMP_OBJID_CMDB_ID	INDEX		3200.00	3200.00		32				17.68	85.64	17.68
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_EVENT_TIME	INDEX	100.00		-100.00	1			12.50	87.50			-12.50
CMS_902_14M_HIST	CMS	IX1_HIST_EVENTS_E_144855667	INDEX	100.00		-100.00	1			12.50	100.00			-12.50

Back to Segment Statistics
Back to Top

Top Segments by Buffer Busy Waits

Ordered by absolute value of 'Diff' column of '% of Total Buffer Busy Waits'
Top 5 Segments from each period are compared
Total Buffer Busy Waits First: 327, Second: 931
Buffer Busy Wait Time First: 0.01 seconds, Second: 750.96 seconds
Buffer Busy Wait Time as % of DB time First: 0%, Second: .96%
Captured Buffer Busy Waits First: 1, Second: 93

Owner	Tablespace	Object Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
				% of Total Buffer Busy Waits					Buffer Busy Waits			% of Captured Buffer Busy Waits
SYS	SYSTEM	AUD$	TABLE			5.59	5.59	5.59		52			55.91	55.91
SYS	SYSTEM	JOB$	TABLE			3.22	8.81	3.22		30			32.26	32.26
SYS	SYSAUX	SYS_IOT_TOP_12337	INDEX			0.75	9.56	0.75		7			7.53	7.53
CMS_902_14M_CMDB	CMS	CDM_IP_ADDRESS_1	TABLE	0.00	0.00	0.32	9.88	0.32	0	3	100.00	0.00	3.23	3.23
CMS_902_14M_CMDB	CMS	IX1_CDM_PROCESS_1_1602320258	INDEX	0.00	0.00	0.11	9.99	0.11	0	1	100.00	0.00	1.08	1.08

Back to Segment Statistics
Back to Top

Top Segments by GC Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Ordered by Cache

Cache	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd
	Get Requests per Sec (DB time)			Get Requests per Sec (Elapsed Time)			Get Requests		Pct Miss		Scan Requests		Pct Miss		Mod Reqs		Final Usage
dc_awr_control	0.02	0.00	-100.00	0.02	0.02	0.00	195	202	0.00	0.00	0	0	0.00	0.00	6	7	1	1
dc_files	0.02	0.00	-100.00	0.01	0.01	0.00	147	147	0.00	0.00	0	0	0.00	0.00	0	0	7	7
dc_global_oids	1.51	0.17	-88.74	1.23	1.20	-2.44	13,285	12,997	0.04	0.00	0	0	0.00	0.00	0	0	90	102
dc_histogram_data	1.89	0.05	-97.35	1.53	0.33	-78.43	16,584	3,608	0.00	7.46	0	0	0.00	0.00	0	0	2,916	3,554
dc_histogram_defs	2.41	0.05	-97.93	1.96	0.37	-81.12	21,139	4,039	2.15	8.99	0	0	0.00	0.00	0	9	5,824	6,217
dc_object_grants	0.29	0.02	-93.10	0.23	0.14	-39.13	2,518	1,523	0.00	0.00	0	0	0.00	0.00	0	0	208	136
dc_objects	6.90	0.34	-95.07	5.61	2.43	-56.68	60,578	26,225	0.00	1.32	0	0	0.00	0.00	15	18	3,302	3,768
dc_profiles	0.11	0.01	-90.91	0.09	0.09	0.00	996	998	0.00	0.00	0	0	0.00	0.00	0	0	2	2
dc_rollback_segments	0.44	0.05	-88.64	0.36	0.36	0.00	3,893	3,908	0.00	0.00	0	0	0.00	0.00	0	0	30	30
dc_segments	0.72	0.04	-94.44	0.58	0.32	-44.83	6,302	3,466	0.33	3.20	0	0	0.00	0.00	23	20	1,245	1,579
dc_sequences	0.00	0.00	0.00	0.00	0.00	0.00	33	29	0.00	3.45	0	0	0.00	0.00	33	29	6	10
dc_tablespaces	32.04	1.30	-95.94	26.05	9.38	-63.99	281,499	101,358	0.00	0.00	0	0	0.00	0.00	0	0	19	19
dc_users	32.90	1.19	-96.38	26.75	8.57	-67.96	289,063	92,615	0.00	0.00	0	0	0.00	0.00	0	0	134	162
global database name	0.92	0.10	-89.13	0.75	0.74	-1.33	8,091	7,949	0.00	0.00	0	0	0.00	0.00	0	0	1	1
outstanding_alerts	0.01	0.00	-100.00	0.01	0.01	0.00	90	111	0.00	5.41	0	0	0.00	0.00	0	11	5	6
sch_lj_oids	0.00	0.00	0.00	0.00	0.00	0.00	12	13	0.00	0.00	0	0	0.00	0.00	0	0	8	14

Library Cache Activity

Ordered by Namespace

Namespace	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd
	Get Requests per Sec (DB Time)			Get Requests per Sec (Elapsed Time)			Get Requests		Pct Miss		Pin Requests		Pct Miss		Reloads		Invalidations
APP CONTEXT	0.00	0.00	0.00	0.00	0.00	0.00	0	42		0.00	0	42		0.00	0	0	0	0
BODY	0.45	0.06	-86.67	0.37	0.42	13.51	3,972	4,519	0.00	0.00	24,782	25,076	0.13	0.02	31	6	0	0
CLUSTER	0.05	0.00	-100.00	0.04	0.00	-100.00	423	27	0.24	0.00	163	9	0.61	11.11	0	1	0	0
DBLINK	0.15	0.02	-86.67	0.12	0.12	0.00	1,278	1,292	0.00	0.00	0	0			0	0	0	0
EDITION	0.10	0.01	-90.00	0.08	0.08	0.00	885	889	0.00	0.00	1,725	1,731	0.00	0.00	0	0	0	0
INDEX	0.01	0.00	-100.00	0.01	0.01	0.00	116	63	2.59	0.00	116	63	2.59	0.00	0	0	0	0
OBJECT ID	0.00	0.00	0.00	0.00	0.00	0.00	0	1		100.00	0	0			0	0	0	0
QUEUE	2.95	0.33	-88.81	2.40	2.42	0.83	25,961	26,114	0.00	0.00	31,131	31,291	0.00	0.00	0	0	0	0
RULESET	0.00	0.00	0.00	0.00	0.00	0.00	0	11		0.00	0	11		0.00	0	0	0	0
SCHEMA	0.17	0.02	-88.24	0.14	0.15	7.14	1,498	1,617	0.00	0.00	0	0			0	0	0	0
SQL AREA	3.38	0.27	-92.01	2.75	1.96	-28.73	29,713	21,209	4.37	4.59	426,572	311,004	1.00	0.92	1,610	259	87	86
SUBSCRIPTION	0.00	0.00	0.00	0.00	0.01	100.00	41	66	0.00	0.00	41	66	0.00	0.00	0	0	0	0
TABLE/PROCEDURE	3.05	0.23	-92.46	2.48	1.65	-33.47	26,779	17,822	0.01	0.11	70,141	56,479	1.10	0.61	766	171	0	0
TRIGGER	0.31	0.03	-90.32	0.25	0.25	0.00	2,682	2,689	0.00	0.00	2,958	2,940	0.10	0.14	3	4	0	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA Breakdown Difference

Process Memory Summary

All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Category

Category	Summary	Begin Value	End Value	%Diff	Begin Value	End Value	%Diff	Begin Values	End Values
		1st			2nd			% Diff of
Freeable	Alloc (KB)	39,296.00	41,088.00	4.56	51,200.00	49,728.00	-2.88	30.29	21.03
	Used (KB)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Avg Alloc (KB)	1,355.03	1,369.60	1.07	1,347.37	1,308.63	-2.87	-0.57	-4.45
	Std Dev Alloc (KB)	1,634.20	1,602.83	-1.92	1,482.00	1,444.99	-2.50	-9.31	-9.85
	Max Alloc (KB)	6,336.00	6,656.00	0.00	6,400.00	6,656.00	4.00	1.01	5.05
	Hist Max Alloc (KB)
	Num Procs	29.00	30.00	3.45	38.00	38.00	0.00	31.03	26.67
	Num Alloc	29.00	30.00	3.45	38.00	38.00	0.00	31.03	26.67
Other	Alloc (KB)	104,856.64	105,936.55	1.03	121,280.11	124,265.82	2.46	15.66	17.30
	Used (KB)
	Avg Alloc (KB)	2,330.15	2,302.97	-1.17	2,288.30	2,301.22	0.56	-1.80	-0.08
	Std Dev Alloc (KB)	2,268.89	2,258.45	-0.46	2,109.32	2,140.79	1.49	-7.03	-5.21
	Max Alloc (KB)	11,669.10	11,669.10	0.00	11,669.10	11,669.10	0.00	0.00	0.00
	Hist Max Alloc (KB)	18,023.15	18,023.15	0.00	25,511.15	25,511.15	0.00	41.55	41.55
	Num Procs	45.00	46.00	2.22	53.00	54.00	1.89	17.78	17.39
	Num Alloc	45.00	46.00	2.22	53.00	54.00	1.89	17.78	17.39
PL/SQL	Alloc (KB)	14,857.89	14,098.95	-5.11	14,925.68	16,928.41	13.42	0.46	20.07
	Used (KB)	14,467.70	13,735.55	-5.06	14,573.27	16,503.51	13.25	0.73	20.15
	Avg Alloc (KB)	345.53	320.43	-7.26	292.66	325.55	11.24	-15.30	1.60
	Std Dev Alloc (KB)	624.83	618.66	-0.99	590.69	626.54	6.07	-5.46	1.27
	Max Alloc (KB)	2,544.30	2,807.59	2.19	2,759.71	2,807.59	1.74	8.47	7.98
	Hist Max Alloc (KB)	2,570.10	2,633.92	2.48	2,828.88	2,841.41	0.44	10.07	7.88
	Num Procs	43.00	44.00	2.33	51.00	52.00	1.96	18.60	18.18
	Num Alloc	43.00	44.00	2.33	51.00	52.00	1.96	18.60	18.18
SQL	Alloc (KB)	2,075.95	1,140.76	-45.05	1,249.04	2,636.40	111.07	-39.83	131.11
	Used (KB)	1,001.95	587.84	-41.33	690.20	2,002.78	190.17	-31.11	240.70
	Avg Alloc (KB)	66.97	36.80	-45.05	32.03	65.91	105.80	-52.17	79.11
	Std Dev Alloc (KB)	72.90	39.96	-45.18	24.69	202.47	720.14	-66.13	406.64
	Max Alloc (KB)	274.36	1,304.05	-35.26	100.64	1,304.05	1,195.75	-63.32	634.16
	Hist Max Alloc (KB)	244,647.14	244,647.14	0.00	244,647.14	244,647.14	0.00	0.00	0.00
	Num Procs	31.00	31.00	0.00	39.00	40.00	2.56	25.81	29.03
	Num Alloc	26.00	25.00	-3.85	33.00	35.00	6.06	26.92	40.00

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Value (KB)	End Value (KB)	%Diff	Begin Value (KB)	End Value (KB)	%Diff	Begin Values	End Values
	1st			2nd			% Diff of
Database Buffers	2,883,584.00	2,883,584.00	0.00	2,883,584.00	2,883,584.00	0.00	0.00	0.00
Fixed Size	2,162.09	2,162.09	0.00	2,162.09	2,162.09	0.00	0.00	0.00
Redo Buffers	33,812.00	33,812.00	0.00	33,812.00	33,812.00	0.00	0.00	0.00
Variable Size	3,670,017.91	3,670,017.91	0.00	3,670,017.91	3,670,017.91	0.00	0.00	0.00

Back to Memory Statistics
Back to Top

SGA Breakdown Difference

ordered by Pool, Name

Pool	Name	Begin Value	End Value	%Diff	Begin Value	End Value	%Diff	Begin Values	End Values
		1st			2nd			%Diff of
java pool	free memory	67,108,864	67,108,864	0.00	67,108,864	67,108,864	0.00	0.00	0.00
large pool	PX msg pool	8,192,000	8,192,000	0.00	8,192,000	8,192,000	0.00	0.00	0.00
large pool	free memory	58,916,864	58,916,864	0.00	58,916,864	58,916,864	0.00	0.00	0.00
shared pool	ASH buffers	30,408,704	30,408,704	0.00	30,408,704	30,408,704	0.00	0.00	0.00
shared pool	CCUR	39,332,944	42,342,816	7.65	50,408,136	50,606,848	0.39	28.16	19.52
shared pool	FileOpenBlock	52,117,976	52,117,976	0.00	52,117,976	52,117,976	0.00	0.00	0.00
shared pool	KGH: NO ACCESS	200,983,104	200,999,456	0.01	268,092,000	268,092,000	0.00	33.39	33.38
shared pool	KGLHD	18,400,104	20,406,824	10.91	28,876,984	29,334,760	1.59	56.94	43.75
shared pool	KGLS	17,770,056	15,340,752	-13.67	19,616,288	21,530,560	9.76	10.39	40.35
shared pool	PCUR	20,335,544	21,190,920	4.21	27,071,232	27,140,264	0.26	33.12	28.07
shared pool	SQLA	161,057,264	183,276,448	13.80	181,762,280	190,770,720	4.96	12.86	4.09
shared pool	db_block_hash_buckets	23,334,912	23,334,912	0.00	23,334,912	23,334,912	0.00	0.00	0.00
shared pool	event statistics per sess	15,809,024	15,809,024	0.00	15,809,024	15,809,024	0.00	0.00	0.00
shared pool	free memory	633,873,656	607,628,056	-4.14	572,435,824	559,047,608	-2.34	-9.69	-8.00
shared pool	ksunfy : SSO free list	14,646,016	14,646,016	0.00
shared pool	private strands	18,385,920	18,385,920	0.00	18,385,920	18,385,920	0.00	0.00	0.00
streams pool	KTG hash buckets	1,320,432	1,320,432	0.00	1,320,432	1,320,432	0.00	0.00	0.00
streams pool	free memory	65,782,968	65,782,968	0.00	65,782,512	65,782,512	0.00	-0.00	-0.00
	buffer_cache	2,952,790,016	2,952,790,016	0.00	2,952,790,016	2,952,790,016	0.00	0.00	0.00
	fixed_sga	2,213,976	2,213,976	0.00	2,213,976	2,213,976	0.00	0.00	0.00
	log_buffer	34,623,488	34,623,488	0.00	34,623,488	34,623,488	0.00	0.00	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams by CPU Time
Streams by IO Time
Streams Capture
Streams Capture Rate
Streams Apply
Streams Apply Rate
Buffered Queues
Buffered Subscribers
Rule Set by Evaluations
Rule Set by Elapsed Time
Persistent Queues
Persistent Queues Rate
Persistent Queue Subscribers

Streams by CPU Time

Ordered by Absolute value of '%Diff' column of 'CPU Time'
CPU and I/O Time in seconds

Session Type	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	CPU Time (sec)			User I/O Time (sec)			System I/O Time (sec)
QMON Slaves	0.01	0.05	276.90	0.00	0.10	52,256.93	0.00	0.00	0.00
QMON Coordinator	0.00	0.00	-100.00	0.00	0.00	0.00	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Streams by IO Time

Ordered by Absolute value of 'Total %Diff' column of 'IO Time'
CPU and I/O Time in seconds

Session Type	1st User	1st System	1st Total	2nd User	2nd System	2nd Total	Total %Diff	1st	2nd	%Diff
	IO Time (sec)							CPU Time (sec)
QMON Slaves	0.00	0.00	0.00	0.10	0.00	0.10	52,256.93	0.01	0.05	276.90
QMON Coordinator	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	-100.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set by Evaluations

Data accumulates from the most recent instance startup for each interval
Rule prefixed by * indicates Rule Set activity (re)started between Begin/End snapshots
SQL per Eval - average number of SQL statements executed for non-SQL free evals
CPU(s), Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals
Ordered by absolute value of '%Diff' column of 'Evals', descending

Ruleset Name	1st	2nd	%Diff	1st	2nd	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Evals			No-SQL Eval%		SQL Execs			CPU(s)			Ela(s)			Eval/Sec			SQL per Eval			Ela(s) per Eval			CPU(s) per Eval			Reloads
SYS.ALERT_QUE_R		11	100.00		0.00		0	0.00		0.00	0.00		0.00	0.00		0.00	0.00		0.00	0.00		0.00	0.00		0.00	0.00		0	0.00

Back to Streams Statistics
Back to Top

Rule Set by Elapsed Time

Data accumulates from the most recent instance startup for each interval
Rule prefixed by * indicates Rule Set activity (re)started between Begin/End snapshots
SQL per Eval - average number of SQL statements executed for non-SQL free evals
CPU(s), Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals
Ordered by absolute value of '%Diff' column of 'Ela(s)', descending

Ruleset Name	1st	2nd	%Diff	1st	2nd	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Ela(s)			No-SQL Eval%		SQL Execs			CPU(s)			Evals			Eval/Sec			SQL per Eval			Ela(s) per Eval			CPU(s) per Eval			Reloads
SYS.ALERT_QUE_R		0.00	0.00		0.00		0	0.00		0.00	0.00		11	100.00		0.00	0.00		0.00	0.00		0.00	0.00		0.00	0.00		0	0.00

Back to Streams Statistics
Back to Top

Persistent Queues

Data accumulates from the most recent instance startup for each interval
Queue Name prefixed by * indicates queue activity (re)started between Begin/End snapshots
%Exp Msgs - % of msgs enqueued with expiry
%Delay Msgs - % of msgs enqueued with delay
%Trasf Time - % of Enqueue time spent in transformation
%Eval Time - % of Enqueue time spent in rule evaluation
Ordered by absolute value of '%Diff' column of 'Enq Msgs', descending

Queue Name	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd
	Enq Msgs			Deq Msgs			%Delay Msgs		%Exp Msgs		Enq Time(s)			Deq Time(s)			%Transf Time		%Eval Time
SYS.ALERT_QUE(12343)	0	11	100.00	0	11	100.00		100.00		0.00	0.00	0.29	100.00	0.00	9.06	100.00		0.00		0.38
SYSMAN.MGMT_TASK_Q(66573)	200	194	-3.00	200	194	-3.00	0.00	0.00	0.00	0.00	0.05	0.41	720.00	0.25	14.38	5,652.00	0.00	0.00	0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(66903)	0	0	0.00	0	0	0.00					0.00	0.00	0.00	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Data accumulates from the most recent instance startup for each interval
Queue Name prefixed by * indicates queue activity (re)started between Begin/End snapshots
Ordered by absolute value of '%Diff' column of 'Enqueue Msgs/sec', descending

Queue Name	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Enqueue Msgs/sec			Dequeue Msgs/sec			Avg Enqueue sec / msg			Avg Dequeue sec / msg
SYS.ALERT_QUE(12343)	0.00	0.00	0.00	0.00	0.00	0.00		0.03	100.00		0.82	100.00
SYSMAN.MGMT_NOTIFY_Q(66903)	0.00	0.00	0.00	0.00	0.00	0.00			0.00			0.00
SYSMAN.MGMT_TASK_Q(66573)	0.02	0.02	0.00	0.02	0.02	0.00	0.00	0.00	0.00	0.00	0.07	100.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Data accumulates from the most recent instance startup for each interval
Subscriber/Queue Name prefixed by * indicates subscriber activity (re)started between Begin/End snapshots
Ordered by absolute value of '%Diff' column of 'Enq Msgs', descending

Subscriber/Queue Name	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Enqueue Msgs			Dequeue Msgs			Expire Msgs			Enqueue Msgs/sec			Dequeue Msgs/sec			Expire Msgs/sec
LABM3PCOEDB16_3938_PCOE(22)/SYS.ALERT_QUE	0	11	100.00	0	11	100.00	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0.00	0	0	0.00	0	0	0.00			0.00			0.00			0.00

Back to Streams Statistics
Back to Top

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections				Avg Active Connections				Avg Total Shared Servers				Avg Active Shared Servers				Avg Total Dispatchers				Avg Active Dispatchers
1st	2nd	Diff	%Diff	1st	2nd	Diff	%Diff	1st	2nd	Diff	%Diff	1st	2nd	Diff	%Diff	1st	2nd	Diff	%Diff	1st	2nd	Diff	%Diff
0	0	0	0.00	0	0	0	0.00	1	1	0	0.00	0	0	0	0.00	1	1	0	0.00	0	0	0	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec				Dispatcher Queue Per Sec				Server Messages Per Sec				Server KB Per Sec				Common Queue Total			Dispatcher Queue Total			Server Total Messages			Server Total KB
1st	2nd	Diff	%Diff	1st	2nd	Diff	%Diff	1st	2nd	Diff	%Diff	1st	2nd	Diff	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0	0	0.00	0	0	0.00	0	0	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)			%Busy			%Idle			Incoming Net %			Outgoing Net %
1st	2nd	%Diff	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	Diff
10,803	10,792	-0.10	0.00	0.00	0.00	100.00	100.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Avg Connections (per Dispatcher)			Avg %Busy			Avg %Idle			Total Queued (all Dispatchers)			Average Queued per Dispatcher			Average Queued Wait (ms)
1st	2nd	%Diff	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
0.00	0.00	0.00	0.00	0.00	0.00	100.00	100.00	0.00	0	0	0.00	0	0	0.00

Back to Shared Server Statistics
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

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 Bnd 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
	1st Period		2nd Period
__db_cache_size		2952790016
__java_pool_size		67108864
__large_pool_size		67108864
__oracle_base		/u01/app/oracle
__pga_aggregate_target		2348810240
__sga_target		4429185024
__shared_io_pool_size		0
__shared_pool_size		1207959552
__streams_pool_size		67108864
audit_file_dest		/u01/app/oracle/admin/PCOE/adump
audit_trail		DB
compatible		11.2.0.0.0
control_files		/oradata/PCOE/control01.ctl, /u0
db_block_size		8192
db_domain
db_name		PCOE
db_recovery_file_dest		/u01/app/oracle/flash_recovery_a
db_recovery_file_dest_size		4070572032
diagnostic_dest		/u01/app/oracle
dispatchers		(PROTOCOL=TCP) (SERVICE=PCOEXDB)
memory_target		6777995264
open_cursors		1200
processes		800
recyclebin		OFF
remote_login_passwordfile		EXCLUSIVE
sessions		1232
trace_enabled		FALSE
undo_tablespace		UNDOTBS1

Complete List of SQL Text

SQL Id SQL Text

03tyxm2zh3m7b SELECT * FROM CLUSTERS

03vgjmz4qdjw7 SELECT COUNT(*) FROM COMPOSITION_1

07qkv062tav6g INSERT INTO CDM_WINOSUSER_1 (CMDB_ID, A_DATA_TESTISNEW, A_DATA_UPDATED_BY, A_HOMEDIR, A_CITY, A_WINOSUSER_FULL_NAME, A_DATA_OPERATIONCORRSTATE, A_DATA_OPERATIONSTATE, A_WINOSUSER_ISDISABLED, A_TENANTOWNER, A_DATA_OPERATIONISNEW, A_ROOT_CONTAINER, A_DATA_EXTERNALID, A_DATA_ORIGIN, A_DESCRIPTION, A_ACK_CLEARED_TIME, A_LANGUAGE, A_SERIAL_NUMBER, A_DIGEST, A_DATA_CHANGESTATE, A_CODEPAGE, A_DATA_CHANGEISNEW, A_TRACK_CHANGES, A_DISPLAY_LABEL, A_NAME, A_ROOT_ISCANDIDATEFORDELETION, A_ISVIRTUAL, A_WINOSUSER_ISLOCAL, A_DATA_CHANGECORRSTATE, A_WINOSUSER_DOMAIN, A_DATA_ALLOW_AUTO_DISCOVERY, A_USER_LABEL, A_DATA_TESTCORRSTATE, A_ACK_ID, A_ROOT_ICONPROPERTIES, A_COUNTRY, A_DATA_SOURCE, A_DATA_NOTE, A_WINOSUSER_ISLOCKED, A_CREDENTIALS_ID, A_STATE, A_IS_SAVE_PERSISTENCY, A_OSUSER_UID, A_DATA_ADMINSTATE, A_OSUSER_GID, A_DOCUMENT_LIST, A_DATA_TESTSTATE) values ( :v0 , :v1 , :v2 , :v3 , :v4 , :v5 , :v6 , :v7 , :v8 , :v9 , :v10 , :v11 , :v12 , :v13 , :v14 , :v15 , :v16 , :v17 , :v18 , :v19 , :v20 , :v21 , :v22 , :v23 , :v24 , :v25 , :v26 , :v27 , :v28 , :v29 , :v30 , :v31 , :v32 , :v33 , :v34 , :v35 , :v36 , :v37 , :v38 , :v39 , :v40 , :v41 , :v42 , :v43 , :v44 , :v45 , :v46 )

08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

0aah7mc3hb44f delete from CDM_TMP_STR

0fr8zhn4ymu3v select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0njp59jttu2z9 DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1

0v3dvmc22qnam insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)

0w1majm70d0tx SELECT WINOSUSER_1.CMDB_ID, WINOSUSER_1.A_DISPLAY_LABEL, WINOSUSER_1.A_ROOT_ICONPROPERTIES FROM WINOSUSER_1 WHERE EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = WINOSUSER_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0)

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

0y28pyspzu6jj INSERT INTO CDM_DAEMON_1 (CMDB_ID, A_DATA_TESTISNEW, A_DATA_ALLOW_AUTO_DISCOVERY, A_DATA_UPDATED_BY, A_DAEMON_PATH, A_DAEMON_PARAMETERS, A_CITY, A_USER_LABEL, A_DATA_OPERATIONCORRSTATE, A_DAEMON_INSTANCES, A_DATA_TESTCORRSTATE, A_DATA_OPERATIONSTATE, A_TENANTOWNER, A_DATA_OPERATIONISNEW, A_ROOT_CONTAINER, A_ACK_ID, A_ROOT_ICONPROPERTIES, A_DATA_EXTERNALID, A_DATA_ORIGIN, A_COUNTRY, A_DATA_SOURCE, A_DESCRIPTION, A_DATA_NOTE, A_ACK_CLEARED_TIME, A_SERIAL_NUMBER, A_LANGUAGE, A_DIGEST, A_DATA_CHANGESTATE, A_CREDENTIALS_ID, A_IS_SAVE_PERSISTENCY, A_STATE, A_DATA_CHANGEISNEW, A_CODEPAGE, A_DAEMON_REQUIRED, A_TRACK_CHANGES, A_DISPLAY_LABEL, A_NAME, A_DAEMON_PID, A_ROOT_ISCANDIDATEFORDELETION, A_ISVIRTUAL, A_DATA_ADMINSTATE, A_DOCUMENT_LIST, A_DATA_TESTSTATE, A_DATA_CHANGECORRSTATE) values ( :v0 , :v1 , :v2 , :v3 , :v4 , :v5 , :v6 , :v7 , :v8 , :v9 , :v10 , :v11 , :v12 , :v13 , :v14 , :v15 , :v16 , :v17 , :v18 , :v19 , :v20 , :v21 , :v22 , :v23 , :v24 , :v25 , :v26 , :v27 , :v28 , :v29 , :v30 , :v31 , :v32 , :v33 , :v34 , :v35 , :v36 , :v37 , :v38 , :v39 , :v40 , :v41 , :v42 , :v43 )

0z0pvvfstpq1r SELECT WINOSUSER_1.CMDB_ID FROM WINOSUSER_1 WINOSUSER_1 WHERE 1=1 AND EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = WINOSUSER_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0) AND (lower(WINOSUSER_1.A_DISPLAY_LABEL) LIKE lower('%0%4%6%2%' ) escape '@' )

0zzvnbtpfvt93 SELECT event "Event", count(*) "Sessions Waiting For Event" FROM v$session_wait where state='WAITING' GROUP BY event ORDER BY 2 DESC

105mn0xguw39u SELECT WINDOWS_SERVICE_1.CMDB_ID FROM WINDOWS_SERVICE_1 WINDOWS_SERVICE_1 WHERE 1=1 AND (WINDOWS_SERVICE_1.A_DISPLAY_LABEL LIKE '%2%6%9%' escape '@' )

11gawdftpkjdr delete from CDM_TMP_INT

1bfry68r1cdz8 SELECT MEMBERSHIP_1.CMDB_ID, MEMBERSHIP_1.A_DISPLAY_LABEL, MEMBERSHIP_1.A_ROOT_ICONPROPERTIES FROM MEMBERSHIP_1 WHERE EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = MEMBERSHIP_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0)

1jqdcpkxcjggj INSERT INTO HIST_INF_STR(ID, OBJECT_ID, ATTR_ID, ATTR_VALUE, END_TIME, CUSTOMER_ID) values ( :v0 , :v1 , :v2 , :v3 , :v4 , :v5 )

23rxv46xhd4r3 select OWNER, TABLE_NAME, COUNT(*) from dba_indexes where OWNER not in ('SYS', 'SYSTEM', 'XDB', 'FLOWS_030000', 'APEX_030200') group by OWNER, TABLE_NAME having COUNT(*) > 10 order by COUNT(*) desc, OWNER, TABLE_NAME

249asvswu45wf SELECT WINDOWS_SERVICE_1.CMDB_ID FROM WINDOWS_SERVICE_1 WINDOWS_SERVICE_1 WHERE 1=1 AND (lower(WINDOWS_SERVICE_1.A_DISPLAY_LABEL) LIKE lower('%2%6%9%' ) escape '@' )

2gtph74r3crsq SELECT 'Tablespaces w/ Less Than Two Free Extents', COUNT(*) "No. Tablespaces" FROM (SELECT owner, s.tablespace_name, segment_name, s.bytes, next_extent, MAX(f.bytes) largest FROM dba_segments s, dba_free_space f WHERE s.tablespace_name = f.tablespace_name(+) GROUP BY owner, s.tablespace_name, segment_name, s.bytes, next_extent HAVING next_extent*2>max(f.bytes))

32hbap2vtmf53 select position#, sequence#, level#, argument, type#, charsetid, charsetform, properties, nvl(length, 0), nvl(precision#, 0), nvl(scale, 0), nvl(radix, 0), type_owner, type_name, type_subname, type_linkname, pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc

3972rvxu3knn3 delete from sdo_geor_ddl__table$$

3aqd8dhufdxcw SELECT * FROM CLUSTER_SERVER

3h3974yx3tr81 SELECT PROCESS_1.CMDB_ID FROM PROCESS_1 PROCESS_1 WHERE 1=1 AND (PROCESS_1.A_DISPLAY_LABEL LIKE '%4%3%6%' escape '@' )

3zgtq94pd12uq DELETE FROM CDM_COMPOSITION_1 WHERE EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = CDM_COMPOSITION_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0)

476xnssn6bkb7 SELECT NETDEVICE_1.CMDB_ID FROM NETDEVICE_1 NETDEVICE_1 WHERE 1=1 AND EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = NETDEVICE_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0) AND (NETDEVICE_1.A_DISPLAY_LABEL LIKE '%0%' escape '@' )

47htrcm4qp27f select OWNER, SEGMENT_NAME, SEGMENT_TYPE, BYTES from dba_segments where TABLESPACE_NAME IN ('SYSTEM', 'SYSAUX', 'USERS') and OWNER not in ('SYS', 'SYSTEM', 'OUTLN', 'DBSNMP', 'EXFSYS', 'SYSMAN', 'TSMSYS', 'WMSYS', 'WMSYS', 'XDB', 'CTXSYS', 'DMSYS', 'OLAPSYS', 'ORDSYS', 'SCOTT', 'MDSYS', 'FLOWS_030000', 'FLOWS_FILES', 'APEX_030200', 'ORDDATA') order by OWNER, SEGMENT_NAME

520mkxqpf15q8 select 1 from dual

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

5mxcr3nh0cy2b SELECT OSUSER_1.CMDB_ID FROM OSUSER_1 OSUSER_1 WHERE 1=1 AND EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = OSUSER_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0) AND (lower(OSUSER_1.A_DISPLAY_LABEL) LIKE lower('%7%' ) escape '@' )

5y8amc3t0chff DELETE FROM CDM_ROOT_1 WHERE EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = CDM_ROOT_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0)

6b5qtb0sssh0w SELECT NODE_1.CMDB_ID FROM NODE_1 NODE_1 WHERE 1=1 AND (NODE_1.A_DISPLAY_LABEL LIKE '%0%4%5%' escape '@' )

6quh2na3y0syy INSERT INTO CDM_COMPOSITION_1 (CMDB_ID, END1_ID, END2_ID, A_DATA_TESTISNEW, A_DATA_ALLOW_AUTO_DISCOVERY, A_DATA_UPDATED_BY, A_MUST, A_USER_LABEL, A_DATA_OPERATIONCORRSTATE, A_DATA_TESTCORRSTATE, A_DATA_OPERATIONSTATE, A_DATA_OPERATIONISNEW, A_ROOT_CONTAINER, A_ROOT_ICONPROPERTIES, A_DATA_EXTERNALID, A_DATA_ORIGIN, A_DATA_SOURCE, A_DESCRIPTION, A_DATA_NOTE, A_DIGEST, A_DATA_CHANGESTATE, A_DATA_CHANGEISNEW, A_WEIGHT, A_DISPLAY_LABEL, A_NAME, A_ROOT_ISCANDIDATEFORDELETION, A_DATA_ADMINSTATE, A_DATA_TESTSTATE, A_DATA_CHANGECORRSTATE) values ( :v0 , :v1 , :v2 , :v3 , :v4 , :v5 , :v6 , :v7 , :v8 , :v9 , :v10 , :v11 , :v12 , :v13 , :v14 , :v15 , :v16 , :v17 , :v18 , :v19 , :v20 , :v21 , :v22 , :v23 , :v24 , :v25 , :v26 , :v27 , :v28 )

6xf2bjhv3f20a INSERT INTO HIST_EVENTS(ID, OBJECT_ID, OBJECT_CLASS, EVENT_ID, EVENT_TIME, CHANGER_INFO, IS_OBJECT, END1_ID, END2_ID, CUSTOMER_ID, CHANGER_TYPE) values ( :v0 , :v1 , :v2 , :v3 , :v4 , :v5 , :v6 , :v7 , :v8 , :v9 , :v10 )

6xqy3yrv5fqqw INSERT INTO CDM_ROOT_1 (CMDB_ID, A_ROOT_CLASS, A_ROOT_LASTACCESSTIME, A_ROOT_ACTUALDELETETIME, A_ROOT_SYSTEM, A_ROOT_ENABLEAGEING, A_CREATE_TIME, A_CALCULATED_ID, A_GLOBAL_ID, A_ROOT_ISCANDIDATEFORDELETION, A_ROOT_ICONPROPERTIES, A_ROOT_CANDIDATEFORDELETETIME, A_LAST_MODIFIED_TIME, A_ROOT_CONTAINER) values ( :v0 , :v1 , :v2 , :v3 , :v4 , :v5 , :v6 , :v7 , :v8 , :v9 , :v10 , :v11 , :v12 , :v13 )

7djnw2g53xwmz select OWNER, TABLE_NAME, CONSTRAINT_NAME, decode(CONSTRAINT_TYPE, 'C', 'Check', 'P', 'Primary Key', 'U', 'Unique', 'R', 'Foreign Key', 'V', 'With Check Option') CONSTRAINT_TYPE from dba_constraints where STATUS = 'DISABLED' AND owner not in ('SYS', 'SYSTEM', 'XDB', 'SYSMAN', 'WMSYS', 'DBSNMP', 'EXFSYS', 'OUTLN', 'OLAPSYS') order by OWNER, TABLE_NAME, CONSTRAINT_NAME

7snbnb70wt9uv SELECT NODE_1.CMDB_ID FROM NODE_1 NODE_1 WHERE 1=1 AND EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = NODE_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0) AND (NODE_1.A_DISPLAY_LABEL LIKE '%1%4%' escape '@' )

8vwv6hx92ymmm UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1

9n1prug34mb98 SELECT NODE_1.CMDB_ID FROM NODE_1 NODE_1 WHERE 1=1 AND (NODE_1.A_DISPLAY_LABEL LIKE '%6%6%0%' escape '@' )

9yhdmxbq004j9 delete from sys.wri$_optstat_histgrm_history where nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and obj# = nvl(:3, obj#) and intcol# = nvl(:4, intcol#)

a6u3yjca29nqc declare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;

a8j39qb13tqkr SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_FINDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID

b7kc4z2qun912 SELECT PROCESS_1.CMDB_ID FROM PROCESS_1 PROCESS_1 WHERE 1=1 AND (lower(PROCESS_1.A_DISPLAY_LABEL) LIKE lower('%4%3%6%' ) escape '@' )

bgmc2n2121wbv select * from CUSTOMER_REGISTRATION

by446qja3yanx SELECT NT_1.CMDB_ID, NT_1.A_DISPLAY_LABEL, NT_1.A_ROOT_ICONPROPERTIES FROM NT_1 WHERE EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = NT_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0)

c6m1m1bhzj4p6 SELECT INSTALLED_SOFTWARE_1.CMDB_ID FROM INSTALLED_SOFTWARE_1 INSTALLED_SOFTWARE_1 WHERE 1=1 AND EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = INSTALLED_SOFTWARE_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0) AND (INSTALLED_SOFTWARE_1.A_NAME LIKE '%5%9%0%' escape '@' )

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

cz8rzvjb1n2yj SELECT NODE_1.CMDB_ID FROM NODE_1 NODE_1 WHERE 1=1 AND EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = NODE_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0) AND (lower(NODE_1.A_DISPLAY_LABEL) LIKE lower('%1%4%' ) escape '@' )

d15cdr0zt3vtp SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS')

d66y4qmsw550w SELECT NODE_1.CMDB_ID FROM NODE_1 NODE_1 WHERE 1=1 AND EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = NODE_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0) AND (NODE_1.A_DISPLAY_LABEL LIKE '%1%2%' escape '@' )

ddtxm9882qb62 SELECT INSTALLED_SOFTWARE_1.CMDB_ID FROM INSTALLED_SOFTWARE_1 INSTALLED_SOFTWARE_1 WHERE 1=1 AND EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = INSTALLED_SOFTWARE_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0) AND (lower(INSTALLED_SOFTWARE_1.A_NAME) LIKE lower('%5%9%0%' ) escape '@' )

dn4ubmxct9zpf DELETE FROM CDM_PROCESS_1 WHERE EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = CDM_PROCESS_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0)

f4kbt6stpwm0w SELECT COMPOSITION_1.CMDB_ID, COMPOSITION_1.A_DISPLAY_LABEL, COMPOSITION_1.A_ROOT_ICONPROPERTIES FROM COMPOSITION_1 WHERE EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = COMPOSITION_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0)

fmg0rw9awbjtg select acc.OWNER, acc.CONSTRAINT_NAME, acc.COLUMN_NAME, acc.POSITION, 'No Index' from dba_cons_columns acc, dba_constraints ac where ac.CONSTRAINT_NAME = acc.CONSTRAINT_NAME and ac.CONSTRAINT_TYPE = 'R' and acc.OWNER not in ('SYS', 'SYSTEM', 'SYSMAN', 'DBSNMP', 'EXFSYS', 'MDSYS', 'OLAPSYS', 'SCOTT', 'ORDSYS', 'ORDDATA') and not exists ( select 'TRUE' from dba_ind_columns b where b.TABLE_OWNER = acc.OWNER and b.TABLE_NAME = acc.TABLE_NAME and b.COLUMN_NAME = acc.COLUMN_NAME and b.COLUMN_POSITION = acc.POSITION) order by acc.OWNER, acc.CONSTRAINT_NAME, acc.COLUMN_NAME, acc.POSITION

fnncar3ndasgu INSERT INTO CDM_LIST_ATTR_PRIMITIVE_1( PATH, CMDB_ID, ATTR_NAME, ATTR_VALUE) values ( :v0 , :v1 , :v2 , :v3 )

fqu4btx1ywxy9 insert into CDM_TMP_OBJID values( :v0 , :v1 )

fvmkur9d5du4h SELECT NODE_1.CMDB_ID FROM NODE_1 NODE_1 WHERE 1=1 AND EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = NODE_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0) AND (lower(NODE_1.A_DISPLAY_LABEL) LIKE lower('%1%2%' ) escape '@' )

g0kbqx3artq8x DELETE FROM CDM_LIST_ATTR_PRIMITIVE_1 WHERE EXISTS (SELECT 1 FROM CDM_TMP_OBJID WHERE CDM_TMP_OBJID.CMDB_ID = CDM_LIST_ATTR_PRIMITIVE_1.CMDB_ID AND CDM_TMP_OBJID.T_VALUES_INDEX=0)

g9588ypf0j5g3 delete from CDM_TMP_OBJID

gjm43un5cy843 SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)

gx4mv66pvj3xz select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1

WORKLOAD REPOSITORY COMPARE PERIOD REPORT

Top Timed Events

Report Details

Supplemental Information

Time Model Statistics

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

Instance Activity Statistics

Key Instance Activity Stats

Other Instance Activity Stats

IO Stats

IOStat by Function - Data Rate per Second

IOStat by Function - Requests per Second

IOStat by File Type - Data Rate per Second

IOStat by File Type - Requests per Second

Tablespace IO Stats

Top File Comparison by IO

Top File Comparison by Read Time

Top File Comparison by Buffer Waits

Advisory Statistics

Instance Recovery Stats

PGA Aggregate Summary

PGA Aggr Target Stats

Wait Stats

Buffer Wait Statistics

Enqueue Activity

Undo Segment Summary

Latch Statistics

Latch Sleep Breakdown

Latch Wait Time Breakdown

Segment Statistics

Top Segments Comparison by Logical Reads

Top Segments Comparison by Physical Reads

Top Segments Comparison by Physical Read Requests

Top Segments Comparison by UnOptimized Read Requests

Top Segments Comparison by Optimized Read Requests

Top Segments Comparison by Direct Physical Reads

Top Segments Comparison by Physical Writes

Top Segments Comparison by Physical Write Requests

Top Segments Comparison by Direct Physical Writes

Top Segments Comparison by Table Scans

Top Segments Comparison by DB Block Changes

Top Segments by Row Lock Waits

Top Segments by ITL Waits

Top Segments by Buffer Busy Waits

Top Segments by GC Buffer Busy Waits

Dictionary Cache Statistics

Library Cache Activity

Memory Statistics

Process Memory Summary

SGA Memory Summary

SGA Breakdown Difference

Streams Statistics

Streams by CPU Time

Streams by IO Time

Streams Capture

Streams Capture Rate

Streams Apply

Streams Apply Rate

Buffered Queues

Buffered Subscribers

Rule Set by Evaluations

Rule Set by Elapsed Time