WORKLOAD REPOSITORY COMPARE PERIOD REPORT

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

First (1st) PROD 3935593814 PROD 1 11.2.0.2.0 NO prdsrv01 16384

Second (2nd) PROD 3935593814 PROD 1 11.2.0.2.0 NO prdsrv01 16384

Snapshot Set	DB Name	DB Id	Instance	Inst num	Release	Cluster	Host	Std Block Size
First (1st)	PROD	3935593814	PROD	1	11.2.0.2.0	NO	prdsrv01	16384
Second (2nd)	PROD	3935593814	PROD	1	11.2.0.2.0	NO	prdsrv01	16384

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

1st 13747 05-Feb-13 07:00:24 (Tue) 13749 05-Feb-13 09:00:34 (Tue) 0.1 120.2 8.2

2nd 13915 12-Feb-13 07:00:28 (Tue) 13917 12-Feb-13 09:00:38 (Tue) 1.5 120.2 185.1

%Diff 2,100.0 0.0 2,169.2

Snapshot Set	Begin Snap Id	Begin Snap Time	End Snap Id	End Snap Time	Avg Active Users	Elapsed Time (min)	DB time (min)
1st	13747	05-Feb-13 07:00:24 (Tue)	13749	05-Feb-13 09:00:34 (Tue)	0.1	120.2	8.2
2nd	13915	12-Feb-13 07:00:28 (Tue)	13917	12-Feb-13 09:00:38 (Tue)	1.5	120.2	185.1
%Diff					2,100.0	0.0	2,169.2

Host Configuration Comparison

	1st	2nd	Diff	%Diff
Number of CPUs:	24	24	0	0.0
Number of CPU Cores:	12	12	0	0.0
Number of CPU Sockets:	2	2	0	0.0
Physical Memory:	144912.7M	144912.7M	0M	0.0
Load at Start Snapshot:	.04	1.86	1.82	4,550.0
Load at End Snapshot:	1.17	1.73	.56	47.9
%User Time:	.24	2.64	2.4	1,000.0
%System Time:	.14	.52	.37	271.4
%Idle Time:	99.48	96.6	-2.88	-2.9
%IO Wait Time:	.98	.52	-.46	-46.9

Cache Sizes

	1st (M)	2nd (M)	Diff (M)	%Diff
Memory Target
.....SGA Target	8,192.0	8,192.0	0.0	0.0
..........Buffer Cache	2,320.0	2,240.0	-80.0	-3.4
..........Shared Pool	4,800.0	4,880.0	80.0	1.7
..........Large Pool	400.0	400.0	0.0	0.0
..........Java Pool	96.0	96.0	0.0	0.0
..........Streams Pool	16.0	16.0	0.0	0.0
.....PGA Target	3,072.0	3,072.0	0.0	0.0
Log Buffer	8.9	8.9	0.0	0.0

Load Profile

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

DB time: 0.1 1.5 2,100.0 0.4 1.0 185.7

CPU time: 0.0 0.6 1,966.7 0.1 0.4 166.7

Redo size: 5,087.7 2,601,468.8 51,032.8 26,352.4 1,683,752.8 6,289.4

Logical reads: 2,825.6 37,042.1 1,211.0 14,635.6 23,974.8 63.8

Block changes: 32.0 11,206.0 34,918.8 165.7 7,252.9 4,276.1

Physical reads: 431.2 5,009.8 1,061.8 2,233.6 3,242.5 45.2

Physical writes: 1.1 1,235.6 113,259.6 5.6 799.7 14,079.6

User calls: 3.7 62.1 1,573.0 19.2 40.2 109.2

Parses: 9.1 105.2 1,060.9 46.9 68.1 45.0

Hard parses: 0.7 8.8 1,120.8 3.7 5.7 53.4

W/A MB processed: 349,457.7 25,791,822.3 7,280.5 1,810,073.8 16,693,282.4 7,280.5

Logons: 0.3 3.5 1,093.1 1.5 2.2 46.4

Executes: 13.4 181.1 1,253.2 69.3 117.2 69.0

Transactions: 0.2 1.5 715.8

1st 2nd Diff

% Blocks changed per Read: 1.1 30.3 29.1

Recursive Call %: 98.7 97.8 -1.0

Rollback per transaction %: 5.2 5.4 0.1

Rows per Sort: 2,091.7 8,442.2 6,350.5

Avg DB time per Call (sec): 0.0 0.0 0.0

	1st per sec	2nd per sec	%Diff	1st per txn	2nd per txn	%Diff
DB time:	0.1	1.5	2,100.0	0.4	1.0	185.7
CPU time:	0.0	0.6	1,966.7	0.1	0.4	166.7
Redo size:	5,087.7	2,601,468.8	51,032.8	26,352.4	1,683,752.8	6,289.4
Logical reads:	2,825.6	37,042.1	1,211.0	14,635.6	23,974.8	63.8
Block changes:	32.0	11,206.0	34,918.8	165.7	7,252.9	4,276.1
Physical reads:	431.2	5,009.8	1,061.8	2,233.6	3,242.5	45.2
Physical writes:	1.1	1,235.6	113,259.6	5.6	799.7	14,079.6
User calls:	3.7	62.1	1,573.0	19.2	40.2	109.2
Parses:	9.1	105.2	1,060.9	46.9	68.1	45.0
Hard parses:	0.7	8.8	1,120.8	3.7	5.7	53.4
W/A MB processed:	349,457.7	25,791,822.3	7,280.5	1,810,073.8	16,693,282.4	7,280.5
Logons:	0.3	3.5	1,093.1	1.5	2.2	46.4
Executes:	13.4	181.1	1,253.2	69.3	117.2	69.0
Transactions:	0.2	1.5	715.8

	1st	2nd	Diff
% Blocks changed per Read:	1.1	30.3	29.1
Recursive Call %:	98.7	97.8	-1.0
Rollback per transaction %:	5.2	5.4	0.1
Rows per Sort:	2,091.7	8,442.2	6,350.5
Avg DB time per Call (sec):	0.0	0.0	0.0

Top Timed Events

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

1st						2nd
Event	Wait Class	Waits	Time(s)	Avg Time(ms)	%DB time	Event	Wait Class	Waits	Time(s)	Avg Time(ms)	%DB time
CPU time			205.90		42.08	Backup: MML create a backup piece	Administrative	96	20,869.65	217,392.17	187.94
direct path read	User I/O	48,843	121.32	2.48	24.79	CPU time			4,470.42		40.26
db file sequential read	User I/O	9,785	20.88	2.13	4.27	Backup: MML commit backup piece	Administrative	96	3,312.03	34,500.33	29.83
db file scattered read	User I/O	802	5.57	6.95	1.14	direct path read	User I/O	577,738	3,026.93	5.24	27.26
control file parallel write	System I/O	3,430	4.94	1.44	1.01	db file async I/O submit	System I/O	49,031	1,876.62	38.27	16.90
-db file async I/O submit	System I/O	1,790	3.38	1.89	0.69	-db file scattered read	User I/O	101,485	168.45	1.66	1.52
-						-control file parallel write	System I/O	39,779	41.88	1.05	0.38
-						-db file sequential read	User I/O	942,324	33.00	0.04	0.30

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	489.37	11,104.61	2,169.16	0.35	1.00	185.71
Java execution elapsed time	26.25	16.23	-10.03	128.48	1,801.98	1,302.54	0.09	0.16	77.78
parse time elapsed	3.71	0.92	-2.79	18.16	102.02	461.78	0.01	0.01	0.00
hard parse elapsed time	2.82	0.50	-2.32	13.78	55.20	300.58	0.01	0.00	-100.00
DB CPU	42.08	40.26	-1.82	205.90	4,470.42	2,071.16	0.15	0.40	166.67
PL/SQL execution elapsed time	1.67	0.60	-1.07	8.19	66.64	713.68	0.01	0.01	0.00
sql execute elapsed time	97.51	98.45	0.94	477.18	10,932.82	2,191.13	0.34	0.98	188.24
hard parse (sharing criteria) elapsed time	0.85	0.02	-0.83	4.17	2.55	-38.85	0.00	0.00	0.00
PL/SQL compilation elapsed time	0.28	0.01	-0.27	1.36	1.16	-14.71	0.00	0.00	0.00
connection management call elapsed time	0.38	0.13	-0.25	1.86	14.66	688.17	0.00	0.00	0.00
RMAN cpu time (backup/restore)	0.00	0.20	0.20	0.00	22.13	100.00	0.00	0.00	0.00
hard parse (bind mismatch) elapsed time	0.16	0.00	-0.16	0.77	0.00	-100.00	0.00	0.00	0.00
failed parse elapsed time	0.02	0.00	-0.02	0.11	0.13	18.18	0.00	0.00	0.00
repeated bind elapsed time	0.01	0.01	-0.00	0.04	0.70	1,650.00	0.00	0.00	0.00
sequence load elapsed time	0.00	0.00	-0.00	0.01	0.04	300.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	43.44	271.13	227.69	212.58	30,108.44	14,063.35	0.15	2.70	1,700.00
background cpu time	32.63	6.82	-25.81	159.67	757.55	374.45	0.11	0.07	-36.36

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	89,343	588,034	182.57	52.95	-71.00	12.39	81.56	558.27	64.18	52.79	-17.75
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	17,213,594	16,714,899	35,175.24	1,505.22	-95.72	2,387.43	2,318.24	-2.90	12,366.09	1,500.44	-87.87
IOWAIT_TIME	169,265	89,132	345.89	8.03	-97.68	23.48	12.36	-47.36	121.60	8.00	-93.42
NICE_TIME	75	57	0.15	0.01	-93.33	0.01	0.01	0.00	0.05	0.01	-80.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	24,783	89,363	50.64	8.05	-84.10	3.44	12.39	260.17	17.80	8.02	-54.94
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	41,015	456,522	83.81	41.11	-50.95	5.69	63.32	1,012.83	29.46	40.98	39.10
VM_IN_BYTES	147,526,695,936	700,014,446,592	301,464,474.67	63,038,196.23	-79.09	20,461,136.35	97,087,227.83	374.50	105,981,821.79	62,837,921.60	-40.71
VM_OUT_BYTES	844,151,808	189,443,632,128	1,724,988.01	17,059,912.00	888.99	117,079.18	26,274,539.28	22,341.68	606,430.90	17,005,712.04	2,704.23

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)
Administrative	0.00	245.24	245.24	0.00	9.28	100.00	0.00	27,233.33	100.00	0.00	407.01	100.00
System I/O	2.76	20.68	17.92	3.31	76.49	2,210.88	13.52	2,296.69	16,887.35	0.57	4.16	629.82
Configuration	0.00	9.33	9.33	0.00	0.32	100.00	0.00	1,035.68	100.00	0.03	450.29	1,500,866.67
User I/O	30.71	34.95	4.24	14.70	454.98	2,995.10	150.27	3,880.64	2,482.44	1.42	1.18	-16.90
Application	0.13	0.99	0.86	0.06	0.81	1,250.00	0.64	110.00	17,087.50	1.53	18.73	1,124.18
Other	0.50	0.99	0.49	1.44	30.70	2,031.94	2.44	110.24	4,418.03	0.23	0.50	117.39
Concurrency	0.57	0.17	-0.40	0.32	7.18	2,143.75	2.78	18.90	579.86	1.20	0.37	-69.17
Network	0.01	0.28	0.27	2.09	120.39	5,660.29	0.05	31.08	62,060.00	0.00	0.04	100.00
Commit	0.47	0.30	-0.16	0.29	3.50	1,106.90	2.30	33.83	1,370.87	1.10	1.34	21.82

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)
Backup: MML create a backup piece	Administrative	0.00	187.94	187.94	0.00	0.01	100.00	0.00	20,869.65	100.00	0.00	217,392.17	100.00
Backup: MML commit backup piece	Administrative	0.00	29.83	29.83	0.00	0.01	100.00	0.00	3,312.03	100.00	0.00	34,500.33	100.00
db file async I/O submit	System I/O	0.69	16.90	16.21	0.25	6.80	2,620.00	3.38	1,876.62	55,421.30	1.89	38.27	1,924.87
Backup: MML query backup piece	Administrative	0.00	15.51	15.51	0.00	0.01	100.00	0.00	1,722.59	100.00	0.00	17,943.65	100.00
Backup: MML write backup piece	Administrative	0.00	11.97	11.97	0.00	9.24	100.00	0.00	1,329.06	100.00	0.00	19.95	100.00
log file switch (checkpoint incomplete)	Configuration	0.00	8.86	8.86	0.00	0.12	100.00	0.00	984.24	100.00	0.00	1,132.61	100.00
db file sequential read	User I/O	4.27	0.30	-3.97	1.36	130.69	9,509.56	20.88	33.00	58.05	2.13	0.04	-98.12
direct path write	User I/O	0.00	3.04	3.04	0.04	75.71	189,175.00	0.02	338.09	1,690,350.00	0.05	0.62	1,140.00
direct path read	User I/O	24.79	27.26	2.47	6.77	80.13	1,083.60	121.32	3,026.93	2,395.00	2.48	5.24	111.29
direct path write temp	User I/O	0.00	2.10	2.10	0.00	29.82	100.00	0.00	233.23	100.00	0.00	1.08	100.00
RMAN backup & recovery I/O	System I/O	0.00	1.27	1.27	0.00	2.33	100.00	0.00	141.40	100.00	0.00	8.40	100.00
enq: KO - fast object checkpoint	Application	0.00	0.79	0.79	0.00	0.03	100.00	0.00	87.88	100.00	0.00	394.06	100.00
control file parallel write	System I/O	1.01	0.38	-0.63	0.48	5.52	1,050.00	4.94	41.88	747.77	1.44	1.05	-27.08
log file parallel write	System I/O	0.95	1.43	0.47	1.06	21.96	1,971.70	4.67	158.39	3,291.65	0.61	1.00	63.93
db file scattered read	User I/O	1.14	1.52	0.38	0.11	14.08	12,700.00	5.57	168.45	2,924.24	6.95	1.66	-76.12
os thread startup	Concurrency	0.38	0.02	-0.35	0.02	0.03	50.00	1.85	2.62	41.62	16.08	14.47	-10.01
log file switch completion	Configuration	0.00	0.32	0.32	0.00	0.05	100.00	0.00	36.04	100.00	0.00	97.14	100.00
log file sequential read	System I/O	0.04	0.36	0.32	0.01	2.94	29,300.00	0.19	39.97	20,936.84	4.35	1.88	-56.78
enq: CR - block range reuse ckpt	Other	0.12	0.40	0.28	0.06	1.46	2,333.33	0.59	44.54	7,449.15	1.31	4.24	223.66
enq: CF - contention	Other	0.12	0.36	0.24	0.02	1.38	6,800.00	0.57	39.88	6,896.49	3.99	4.01	0.50
Log archive I/O	System I/O	0.02	0.26	0.24	0.01	2.65	26,400.00	0.09	28.70	31,788.89	2.30	1.50	-34.78
SQL*Net more data from client	Network	0.00	0.24	0.24	0.01	1.76	17,500.00	0.01	26.77	267,600.00	0.23	2.11	817.39
log file sync	Commit	0.47	0.30	-0.16	0.29	3.50	1,106.90	2.30	33.83	1,370.87	1.10	1.34	21.82
direct path read temp	User I/O	0.00	0.15	0.15	0.00	69.52	100.00	0.00	16.15	100.00	0.00	0.03	100.00
log buffer space	Configuration	0.00	0.13	0.13	0.00	0.06	100.00	0.00	14.90	100.00	0.00	37.44	100.00
utl_file I/O	User I/O	0.18	0.06	-0.12	6.07	50.58	733.28	0.89	7.13	701.12	0.02	0.02	0.00
read by other session	User I/O	0.01	0.11	0.10	0.02	0.40	1,900.00	0.07	12.27	17,428.57	0.61	4.30	604.92
ADR block file read	Other	0.11	0.01	-0.10	0.01	0.02	100.00	0.52	1.05	101.92	13.58	7.86	-42.12
kksfbc child completion	Other	0.00	0.09	0.09	0.00	0.03	100.00	0.00	9.79	100.00	0.00	46.60	100.00
db file parallel read	User I/O	0.17	0.25	0.08	0.00	0.28	100.00	0.81	27.67	3,316.05	38.72	13.55	-65.01
enq: RO - fast object reuse	Application	0.13	0.20	0.07	0.06	0.72	1,100.00	0.64	22.06	3,346.88	1.54	4.26	176.62
library cache: mutex X	Concurrency	0.07	0.01	-0.06	0.27	5.02	1,759.26	0.34	0.61	79.41	0.18	0.02	-88.89
local write wait	User I/O	0.08	0.05	-0.04	0.06	0.71	1,083.33	0.41	5.06	1,134.15	0.89	0.99	11.24
Disk file operations I/O	User I/O	0.03	0.07	0.04	0.26	1.90	630.77	0.15	7.60	4,966.67	0.08	0.55	587.50
control file sequential read	System I/O	0.05	0.09	0.03	1.51	34.17	2,162.91	0.26	9.53	3,565.38	0.02	0.04	100.00
SQL*Net more data to client	Network	0.01	0.04	0.03	0.35	76.76	21,831.43	0.03	4.16	13,766.67	0.01	0.01	0.00
db file single write	User I/O	0.01	0.04	0.03	0.00	1.12	100.00	0.07	4.56	6,414.29	3.80	0.56	-85.26
library cache lock	Concurrency	0.03	0.04	0.02	0.00	0.07	100.00	0.14	4.86	3,371.43	8.58	9.62	12.12
PX Deq: Table Q Get Keys	Other	0.02	0.01	-0.02	0.04	0.41	925.00	0.11	0.80	627.27	0.38	0.27	-28.95
direct path sync	User I/O	0.02	0.00	-0.01	0.01	0.05	400.00	0.09	0.50	455.56	1.23	1.29	4.88
PX Deq: Slave Session Stats	Other	0.07	0.06	-0.01	0.46	6.47	1,306.52	0.36	7.21	1,902.78	0.11	0.15	36.36
PX Deq: Signal ACK RSG	Other	0.00	0.01	0.01	0.08	1.25	1,462.50	0.00	0.94	100.00	0.01	0.10	900.00
cursor: pin S wait on X	Concurrency	0.08	0.09	0.01	0.00	0.07	100.00	0.40	9.92	2,380.00	14.40	18.47	28.26
latch: shared pool	Concurrency	0.01	0.00	-0.01	0.00	0.03	100.00	0.05	0.27	440.00	1.56	1.21	-22.44
latch free	Other	0.00	0.01	0.01	0.02	1.00	4,900.00	0.00	0.65	100.00	0.03	0.09	200.00
enq: BF - allocation contention	Other	0.01	0.00	-0.00	0.00	0.03	100.00	0.03	0.09	200.00	6.92	0.42	-93.93
buffer busy waits	Concurrency	0.00	0.01	0.00	0.00	1.57	100.00	0.00	0.58	100.00	0.09	0.05	-44.44
PX Deq: Signal ACK EXT	Other	0.02	0.02	-0.00	0.23	3.23	1,304.35	0.11	1.97	1,690.91	0.06	0.08	33.33
undo segment extension	Configuration	0.00	0.00	0.00	0.00	0.01	100.00	0.00	0.43	100.00	0.00	11.00	100.00
PX qref latch	Other	0.00	0.00	0.00	0.02	2.57	12,750.00	0.00	0.38	100.00	0.00	0.02	100.00
latch: call allocation	Other	0.00	0.00	-0.00	0.04	0.30	650.00	0.01	0.08	700.00	0.05	0.04	-20.00
enq: PS - contention	Other	0.01	0.00	-0.00	0.07	0.79	1,028.57	0.03	0.45	1,400.00	0.06	0.08	33.33
log file single write	System I/O	0.00	0.00	0.00	0.00	0.12	100.00	0.00	0.21	100.00	2.10	0.24	-88.57
ADR block file write	Other	0.00	0.00	-0.00	0.00	0.01	100.00	0.01	0.08	700.00	0.81	0.77	-4.94
rdbms ipc reply	Other	0.00	0.00	0.00	0.00	0.28	100.00	0.00	0.10	100.00	0.02	0.05	150.00
asynch descriptor resize	Other	0.00	0.00	-0.00	0.19	7.18	3,678.95	0.01	0.06	500.00	0.00	0.00	0.00
reliable message	Other	0.02	0.02	-0.00	0.12	2.58	2,050.00	0.09	1.97	2,088.89	0.10	0.11	10.00
latch: cache buffers chains	Concurrency	0.00	0.00	-0.00	0.01	0.18	1,700.00	0.00	0.02	100.00	0.04	0.02	-50.00
enq: TX - row lock contention	Application	0.00	0.00	0.00	0.00	0.06	100.00	0.00	0.06	100.00	0.18	0.12	-33.33
SQL*Net message to client	Network	0.00	0.00	-0.00	1.73	41.88	2,320.81	0.01	0.15	1,400.00	0.00	0.00	0.00
enq: TX - allocate ITL entry	Configuration	0.00	0.00	0.00	0.00	0.08	100.00	0.00	0.05	100.00	0.09	0.08	-11.11
log file switch (private strand flush incomplete)	Configuration	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.02	100.00	0.00	4.62	100.00
LGWR wait for redo copy	Other	0.00	0.00	0.00	0.03	1.03	3,333.33	0.01	0.16	1,500.00	0.03	0.02	-33.33
latch: object queue header operation	Other	0.00	0.00	0.00	0.00	0.02	100.00	0.00	0.01	100.00	0.00	0.07	100.00
enq: CI - contention	Other	0.00	0.00	0.00	0.00	0.01	100.00	0.00	0.01	100.00	0.00	0.09	100.00
row cache lock	Concurrency	0.00	0.00	0.00	0.00	0.10	100.00	0.00	0.01	100.00	0.01	0.01	0.00
cursor: pin S	Concurrency	0.00	0.00	-0.00	0.01	0.08	700.00	0.00	0.00	0.00	0.01	0.01	0.00
ARCH wait for archivelog lock	Other	0.00	0.00	0.00	0.00	0.06	100.00	0.00	0.00	0.00	0.00	0.00	0.00
PX Deq Credit: free buffer	Other	0.00	0.00	-0.00	0.01	0.12	1,100.00	0.00	0.00	0.00	0.00	0.00	0.00
latch: redo allocation	Other	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.07	100.00
PX Deq: Table Q qref	Other	0.00	0.00	-0.00	0.04	0.42	950.00	0.00	0.01	100.00	0.00	0.00	0.00
ADR file lock	Other	0.00	0.00	-0.00	0.00	0.03	100.00	0.00	0.00	0.00	0.01	0.02	100.00
latch: cache buffers lru chain	Other	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.06	100.00
latch: redo writing	Configuration	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.01	0.02	100.00
buffer deadlock	Other	0.00	0.00	0.00	0.00	0.02	100.00	0.00	0.00	0.00	0.01	0.00	-100.00
latch: parallel query alloc buffer	Other	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.11	100.00
cursor: mutex S	Concurrency	0.00	0.00	0.00	0.00	0.03	100.00	0.00	0.00	0.00	0.00	0.01	100.00
latch: enqueue hash chains	Other	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.03	100.00
latch: row cache objects	Concurrency	0.00	0.00	-0.00	0.00	0.01	100.00	0.00	0.00	0.00	0.02	0.05	150.00
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.04	100.00
latch: checkpoint queue latch	Other	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.02	100.00
latch: messages	Other	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.01	0.02	100.00
SQL*Net message from client	Idle	15,490.13	799.97	-14,690.15	1.78	42.09	2,264.61	75,803.53	88,833.57	17.19	5,904.62	292.72	-95.04
Streams AQ: qmn slave idle wait	Idle	2,941.92	65.08	-2,876.85	0.09	0.04	-55.56	14,396.80	7,226.40	-49.81	22,888.39	28,009.32	22.37
DIAG idle wait	Idle	2,943.91	129.74	-2,814.16	2.00	2.00	0.00	14,406.50	14,407.52	0.01	1,001.01	1,001.01	0.00
PX Idle Wait	Idle	3,308.56	601.73	-2,706.82	0.23	3.25	1,313.04	16,190.97	66,819.91	312.70	9,569.13	2,850.80	-70.21
Space Manager: slave idle wait	Idle	2,681.23	647.01	-2,034.22	0.38	3.35	781.58	13,121.04	71,848.00	447.58	4,848.87	2,978.90	-38.57
shared server idle wait	Idle	1,477.54	64.84	-1,412.70	0.03	0.03	0.00	7,230.59	7,200.61	-0.41	30,002.45	30,002.53	0.00
Streams AQ: qmn coordinator idle wait	Idle	1,470.96	65.08	-1,405.88	0.11	0.11	0.00	7,198.38	7,226.40	0.39	9,372.89	9,336.43	-0.39
JOX Jit Process Sleep	Idle	458.88	51.34	-407.54	0.02	0.06	200.00	2,245.61	5,701.54	153.90	13,446.79	13,047.00	-2.97
jobq slave wait	Idle	196.57	8.63	-187.94	0.27	0.27	0.00	961.94	958.51	-0.36	501.01	500.79	-0.04
PX Deq: Execution Msg	Idle	5.94	56.80	50.87	1.87	45.60	2,338.50	29.05	6,307.50	21,612.56	2.15	19.18	792.09
PX Deq: Table Q Normal	Idle	2.43	51.16	48.72	2.83	648.99	22,832.51	11.90	5,680.65	47,636.55	0.58	1.21	108.62
PX Deq Credit: send blkd	Idle	1.21	28.53	27.32	0.10	148.01	147,910.00	5.90	3,167.62	53,588.47	8.59	2.97	-65.42
PX Deq: Execute Reply	Idle	0.81	12.21	11.40	1.59	88.18	5,445.91	3.94	1,355.54	34,304.57	0.34	2.13	526.47
PX Deq Credit: need buffer	Idle	0.00	0.68	0.67	0.02	20.27	101,250.00	0.01	75.13	751,200.00	0.09	0.51	466.67
PX Deq: Join ACK	Idle	0.06	0.03	-0.03	0.23	3.23	1,304.35	0.31	3.39	993.55	0.19	0.15	-21.05
PX Deq: Parse Reply	Idle	0.12	0.10	-0.01	0.23	3.23	1,304.35	0.57	11.33	1,887.72	0.34	0.49	44.12
PX Deq: Table Q Sample	Idle	0.00	0.01	0.01	0.00	0.07	100.00	0.00	0.72	100.00	0.00	1.40	100.00
class slave wait	Idle	0.00	0.00	-0.00	0.01	0.00	-100.00	0.00	0.00	0.00	0.07	0.07	0.00
PX Deq: Msg Fragment	Idle	0.00	0.00	0.00	0.00	0.05	100.00	0.00	0.00	0.00	0.00	0.00	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: 489.37 seconds, Second: 11,104.61 seconds
CPU Time First: 205.90 seconds, Second: 4,470.42 seconds
Physical Reads First: 3,109,206, Second: 36,121,784
Logical Reads First: 20,372,713, Second: 267,079,454

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	85.63	0.92	-84.71	78.04	1.00	-77.03	99.86	0.79	-99.06	33.81	1.03	-32.78
PROD	14.29	93.03	78.74	21.90	97.63	75.74	0.14	82.94	82.80	65.68	96.46	30.77
PRODXDB	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.00	0.08	0.08	0.45	0.06	-0.39

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
PROD	0.00	0.00	0.00	0.00	0.00	0.00	0.00
PRODXDB	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: 489.37 seconds, Second: 11,104.61 seconds
Captured SQL Elapsed Time First: 283.29 seconds, Second: 2,086.84 seconds
Captured SQL Elapsed Time as a % of DB time First: 57.89%, Second: 18.79%
Captured PL/SQL Elapsed Time as a % of DB time First: 41.77%, Second: 46.59%
Common SQL Elapsed Time as a % of DB time First: 11.14%, Second: 8.26%

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
5p780wzurvqzd			35.81	35.81	35.81		795,214		0.00		256,889		44,557		754,395.20		1.00		5		begin :error_msg := null; :err...
fky21a2j944wr	22.26	22.26			-22.26	15,562		0.01		1,248		73		62.57		1.00		7			begin sp_exec_rel_load; end;
f53dq339tg6ta	14.88	37.14			-14.88	8,091		0.02		3,881		4,551		114,122.56		9.56		9		2// 2	select c.rowid_object, c.full...
crm09z5z1m4vz	6.27	43.41			-6.27	30,678		0.00		1,919		2,543		1,204.00		1.00		1			begin sp_link_dat_to_groups('...
c2t7mvu1f3sbf			4.24	40.04	4.24		117,691		0.00		23,959		844		16,713.25		1.00		4		begin :error_msg := null; :err...
8csym9s53yg2y	3.37	46.78			-3.37	8,255		0.00		3,961		4,630		114,122.00		0.50		2		2// 2	select c.rowid_object, c.full...
gpank43gkh2rx	2.96	49.75			-2.96	439		0.07		427		12		45.70		0.00		33		1// 1	insert into x_bo_dat_grp ( ro...
d6wmw6wbcc2nz	2.54	52.28			-2.54	12,410		0.00		4,463		2,720		1,186.00		1.00		1			BEGIN prdmm.multi_merge( :1, :...
4m1a4b7gwk1br	1.71	53.99	3.78	43.82	2.07	1,046	6,993	0.02	0.01	843	5,265	118	2,178	122.50	28,701.95	1.00	1.00	8	60		BEGIN prdld.maint_rr( :1, :2, ...
ggku786rstp2j	1.83	55.82			-1.83	8,947		0.00		4,061		5,196		114,124.00		0.00		1		1// 1	select c.rowid_object, c.full...
cmvws22p9ckyt	1.77	57.59			-1.77	8,650		0.00		2,405		6,435		4,984.00		1.00		1			begin sp_link_dat_to_groups('...
2vg2pg9vsm9gx	2.47	60.06	0.99	44.81	-1.49	168	175	0.15	0.06	168	175	0	0	0.00	2.21	0.00	0.00	72	627	1/ 1/ 1	delete FROM anon_table_cac...
armw47wdxcsaq	3.10	63.16	1.98	46.79	-1.12	1,893	3,725	0.02	0.01	915	2,890	195	793	180.75	7,674.71	1.00	1.00	8	59		BEGIN prdld.maint_delta( :1, :...
9rt2s2wsfqdcy	1.58	64.73	0.63	47.42	-0.94	107	112	0.15	0.06	107	110	0	2	0.00	7.27	1.00	0.99	72	623	1/ 1/ 1	SELECT COUNT( * ) FROM USER_SO...
dbvkky621gqtr			0.71	48.13	0.71		83		0.09		83		0		0.00		101.99		949	/ 1/ 1	SELECT /+ parallel / EXTRACT...
cckfxmhqnpkvv			0.58	48.71	0.58		32,210		0.00		17,337		14,519		96,467.50		1,000,000.00		2	/ 2/ 2	create table ANONTAB
35cxwq3ftdjc9			0.45	49.16	0.45		25,032		0.00		2,188		23,210		155,875.50		724.00		2	/ 1/ 1	create table ANONTAB
0uduy46y8mdtf			0.45	49.61	0.45		49,988		0.00		18,538		1		120.00		1,000,000.00		1	/ 1/ 1	update ANONTAB

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: 205.90 seconds, Second: 4,470.42 seconds
Captured SQL CPU Time First: 162.55 seconds, Second: 1,030.95 seconds
Captured SQL as a % of Total CPU First: 78.95%, Second: 23.06%
Captured PL/SQL as a % of Total CPU First: 21.78%, Second: 43.68%
Common SQL as a % of Total CPU First: 21.51%, Second: 16.83%

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
5p780wzurvqzd			28.73	28.73	28.73		256,889		44,557		0.00		795,214		754,395.20		1.00		begin :error_msg := null; :err...
f53dq339tg6ta	16.96	16.96			-16.96	3,881		4,551		0.02		8,091		114,122.56		9.56		2// 2	select c.rowid_object, c.full...
gpank43gkh2rx	6.84	23.80			-6.84	427		12		0.07		439		45.70		0.00		1// 1	insert into x_bo_dat_grp ( ro...
fky21a2j944wr	4.24	28.05			-4.24	1,248		73		0.01		15,562		62.57		1.00			begin sp_exec_rel_load; end;
8csym9s53yg2y	3.85	31.89			-3.85	3,961		4,630		0.00		8,255		114,122.00		0.50		2// 2	select c.rowid_object, c.full...
4m1a4b7gwk1br	3.28	35.17	7.07	35.80	3.79	843	5,265	118	2,178	0.02	0.01	1,046	6,993	122.50	28,701.95	1.00	1.00		BEGIN prdld.maint_rr( :1, :2, ...
2vg2pg9vsm9gx	5.87	41.04	2.45	38.25	-3.43	168	175	0	0	0.15	0.06	168	175	0.00	2.21	0.00	0.00	1/ 1/ 1	delete FROM anon_table_cac...
9rt2s2wsfqdcy	3.74	44.79	1.54	39.78	-2.21	107	110	0	2	0.15	0.06	107	112	0.00	7.27	1.00	0.99	1/ 1/ 1	SELECT COUNT( * ) FROM USER_SO...
d6wmw6wbcc2nz	2.17	46.95			-2.17	4,463		2,720		0.00		12,410		1,186.00		1.00			BEGIN prdmm.multi_merge( :1, :...
c2t7mvu1f3sbf			2.14	41.93	2.14		23,959		844		0.00		117,691		16,713.25		1.00		begin :error_msg := null; :err...
7z20v3mu30z1q	2.58	49.54	0.74	42.67	-1.84	104	281	0	0	0.10	0.01	105	281	0.04	0.10	1.00	1.00		BEGIN prdlb.generate_key( :1 )...
dbvkky621gqtr			1.76	44.42	1.76		83		0		0.09		83		0.00		101.99	/ 1/ 1	SELECT /+ parallel / EXTRACT...
cckfxmhqnpkvv			0.78	45.20	0.78		17,337		14,519		0.00		32,210		96,467.50		1,000,000.00	/ 2/ 2	create table ANONTAB
61gh6sk81rxxc			0.71	45.91	0.71		15,802		9,840		0.00		24,586		105,892.50		1,639,552.00	/ 2/ 2	CREATE TABLE ANONTAB
armw47wdxcsaq	3.56	53.09	3.81	49.72	0.26	915	2,890	195	793	0.02	0.01	1,893	3,725	180.75	7,674.71	1.00	1.00		BEGIN prdld.maint_delta( :1, :...

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: 30.71%, Second: 34.95%
Total User I/O Time First: 150.27 seconds, Second: 3,880.64 seconds
Captured SQL I/O Time First: 128.67 seconds, Second: 548.36 seconds
Captured SQL as a % of Total User I/O First: 85.62%, Second: 14.13%
Captured PL/SQL as a % of Total User I/O First: 11.6%, Second: 10.44%
Common SQL as a % of Total User I/O First: .14%, Second: .07%

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
f53dq339tg6ta	8.37	8.37			-8.37	4,551		8,091		0.02		3,881		114,122.56		9.56		9		2// 2	select c.rowid_object, c.full...
5p780wzurvqzd			2.01	2.01	2.01		44,557		795,214		0.00		256,889		754,395.20		1.00		5		begin :error_msg := null; :err...
8csym9s53yg2y	1.89	10.26			-1.89	4,630		8,255		0.00		3,961		114,122.00		0.50		2		2// 2	select c.rowid_object, c.full...
cmvws22p9ckyt	1.31	11.58			-1.31	6,435		8,650		0.00		2,405		4,984.00		1.00		1			begin sp_link_dat_to_groups('...
ggku786rstp2j	1.06	12.64			-1.06	5,196		8,947		0.00		4,061		114,124.00		0.00		1		1// 1	select c.rowid_object, c.full...
4m1a4b7gwk1br	0.19	12.83	1.18	3.18	0.98	118	2,178	1,046	6,993	0.02	0.01	843	5,265	122.50	28,701.95	1.00	1.00	8	60		BEGIN prdld.maint_rr( :1, :2, ...
d6wmw6wbcc2nz	0.56	13.39			-0.56	2,720		12,410		0.00		4,463		1,186.00		1.00		1			BEGIN prdmm.multi_merge( :1, :...
crm09z5z1m4vz	0.52	13.91			-0.52	2,543		30,678		0.00		1,919		1,204.00		1.00		1			begin sp_link_dat_to_groups('...
35cxwq3ftdjc9			0.42	3.60	0.42		23,210		25,032		0.00		2,188		155,875.50		724.00		2	/ 1/ 1	create table ANONTAB
cckfxmhqnpkvv			0.26	3.86	0.26		14,519		32,210		0.00		17,337		96,467.50		1,000,000.00		2	/ 2/ 2	create table ANONTAB
fky21a2j944wr	0.10	14.01			-0.10	73		15,562		0.01		1,248		62.57		1.00		7			begin sp_exec_rel_load; end;
armw47wdxcsaq	0.32	14.33	0.42	4.28	0.10	195	793	1,893	3,725	0.02	0.01	915	2,890	180.75	7,674.71	1.00	1.00	8	59		BEGIN prdld.maint_delta( :1, :...
gpank43gkh2rx	0.08	14.41			-0.08	12		439		0.07		427		45.70		0.00		33		1// 1	insert into x_bo_dat_grp ( ro...
c2t7mvu1f3sbf			0.03	4.31	0.03		844		117,691		0.00		23,959		16,713.25		1.00		4		begin :error_msg := null; :err...
9rt2s2wsfqdcy	0.00	14.41	0.01	4.33	0.01	0	2	107	112	0.15	0.06	107	110	0.00	7.27	1.00	0.99	72	623	1/ 1/ 1	SELECT COUNT( * ) FROM USER_SO...
2vg2pg9vsm9gx	0.00	14.41	0.00	4.33	0.00	0	0	168	175	0.15	0.06	168	175	0.00	2.21	0.00	0.00	72	627	1/ 1/ 1	delete FROM anon_table_cac...
0uduy46y8mdtf			0.00	4.33	0.00		1		49,988		0.00		18,538		120.00		1,000,000.00		1	/ 1/ 1	update ANONTAB
dbvkky621gqtr			0.00	4.33	0.00		0		83		0.09		83		0.00		101.99		949	/ 1/ 1	SELECT /+ parallel / EXTRACT...

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: 20,372,713, Second: 267,079,454
Captured SQL Buffer Gets First: 20,611,226, Second: 212,170,161
Captured SQL % of Total Buffer Gets First: 101.17%, Second: 79.44%
Common SQL % of Total Buffer Gets First: 81.52%, Second: 54.75%

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
5p780wzurvqzd			33.38	33.38	33.38		17,830,268.60		5		795,214		256,889		44,557		754,395.20		1.00		begin :error_msg := null; :err...
2vg2pg9vsm9gx	63.80	63.80	42.89	76.27	-20.91	180,523.00	182,706.00	72	627	168	175	168	175	0	0	0.00	2.21	0.00	0.00	1/ 1/ 1	delete FROM anon_table_cac...
7z20v3mu30z1q	19.14	82.94	9.16	85.44	-9.98	76,451.06	207,391.20	51	118	105	281	104	281	0	0	0.04	0.10	1.00	1.00		BEGIN prdlb.generate_key( :1 )...
fky21a2j944wr	7.79	90.73			-7.79	226,771.86		7		15,562		1,248		73		62.57		1.00			begin sp_exec_rel_load; end;
armw47wdxcsaq	8.63	99.36	2.59	88.02	-6.05	219,836.63	117,094.63	8	59	1,893	3,725	915	2,890	195	793	180.75	7,674.71	1.00	1.00		BEGIN prdld.maint_delta( :1, :...
f53dq339tg6ta	5.06	104.42			-5.06	114,589.22		9		8,091		3,881		4,551		114,122.56		9.56		2// 2	select c.rowid_object, c.full...
fyfxzazwfpbz7			4.75	92.77	4.75		211,231.72		60		527		509		19		117.15		1.00		BEGIN prdut.generate_constrain...
09y8y6k71rhqn			4.58	97.35	4.58		207,548.46		59		298		292		2		3.56		1.00		BEGIN prdut.disable_constraint...
5ypw77s2m96yc	4.03	108.45			-4.03	27,371.20		30		39		39		1		0.00		1.00			BEGIN prdlog.file_rolling (); ...
9rt2s2wsfqdcy	8.72	117.17	5.71	103.06	-3.01	24,666.14	24,468.26	72	623	107	112	107	110	0	2	0.00	7.27	1.00	0.99	1/ 1/ 1	SELECT COUNT( * ) FROM USER_SO...
93b0px38476d3	8.69	125.87	5.70	108.76	-2.99	24,600.38	24,338.47	72	626	51	53	51	50	0	2	0.00	7.17	23,816.57	23,304.81	1/ 1/ 1	select o.obj#, o.type#, u.name...
229gsdj5ps3pn	2.89	128.75			-2.89	587,901.00		1		5,715		4,152		1,534		8,798.00		1.00			begin sp_denormalize_groups('2...
4m1a4b7gwk1br	8.62	137.37	5.85	114.62	-2.76	219,421.50	260,563.42	8	60	1,046	6,993	843	5,265	118	2,178	122.50	28,701.95	1.00	1.00		BEGIN prdld.maint_rr( :1, :2, ...
c2t7mvu1f3sbf			1.24	115.86	1.24		830,511.25		4		117,691		23,959		844		16,713.25		1.00		begin :error_msg := null; :err...

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
f53dq339tg6ta	33.03	33.03			-33.03	114,122.56		9		8,091		3,881		4,551		9.56		2// 2	select c.rowid_object, c.full...
5p780wzurvqzd			10.44	10.44	10.44		754,395.20		5		795,214		256,889		44,557		1.00		begin :error_msg := null; :err...
8csym9s53yg2y	7.34	40.38			-7.34	114,122.00		2		8,255		3,961		4,630		0.50		2// 2	select c.rowid_object, c.full...
4m1a4b7gwk1br	0.03	40.41	4.77	15.21	4.74	122.50	28,701.95	8	60	1,046	6,993	843	5,265	118	2,178	1.00	1.00		BEGIN prdld.maint_rr( :1, :2, ...
ggku786rstp2j	3.67	44.08			-3.67	114,124.00		1		8,947		4,061		5,196		0.00		1// 1	select c.rowid_object, c.full...
05jgbg38fja19	3.67	47.75			-3.67	114,122.00		1		8,337		3,984		4,667		0.00		1// 1	select c.rowid_object, c.full...
0gz3r29t7uxdw	3.67	51.42			-3.67	114,122.00		1		7,892		4,156		4,082		0.00		1// 1	select c.rowid_object, c.full...
0ht163d05xnqf	3.67	55.09			-3.67	114,122.00		1		8,231		4,224		4,387		0.00		1// 1	select c.rowid_object, c.full...
10w62cb6udswr	3.67	58.76			-3.67	114,122.00		1		8,038		3,993		4,367		0.00		1// 1	select c.rowid_object, c.full...
2vw792k09qhht	3.67	62.43			-3.67	114,122.00		1		8,034		4,089		4,324		0.00		1// 1	select c.rowid_object, c.full...
383w76mqhft8a	3.67	66.10			-3.67	114,122.00		1		7,919		4,046		4,205		0.00		1// 1	select c.rowid_object, c.full...
3z4614fqt7uct	3.67	69.77			-3.67	114,122.00		1		7,902		4,002		4,213		1.00		1// 1	select c.rowid_object, c.full...
armw47wdxcsaq	0.05	69.82	1.25	16.46	1.21	180.75	7,674.71	8	59	1,893	3,725	915	2,890	195	793	1.00	1.00		BEGIN prdld.maint_delta( :1, :...
35cxwq3ftdjc9			0.86	17.33	0.86		155,875.50		2		25,032		2,188		23,210		724.00	/ 1/ 1	create table ANONTAB
61gh6sk81rxxc			0.59	17.91	0.59		105,892.50		2		24,586		15,802		9,840		1,639,552.00	/ 2/ 2	CREATE TABLE ANONTAB
cckfxmhqnpkvv			0.53	18.45	0.53		96,467.50		2		32,210		17,337		14,519		1,000,000.00	/ 2/ 2	create table ANONTAB
0z35tvax59u3a			0.43	18.88	0.43		155,901.00		1		23,166		3,019		20,522		2,770.00	/ 1/ 1	create table ANONTAB
d2dccmyz4q092			0.43	19.31	0.43		155,141.00		1		27,451		5,874		21,956		4,008.00	/ 1/ 1	CREATE TABLE ANONTAB
6mbnz0rxzbd5d			0.43	19.74	0.43		154,947.00		1		26,411		5,864		20,923		3,750.00	/ 1/ 1	CREATE TABLE ANONTAB
cckvkdz7xwdt1			0.43	20.17	0.43		154,783.00		1		26,762		5,822		21,328		4,092.00	/ 1/ 1	CREATE TABLE ANONTAB

	% 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
5p780wzurvqzd			46.21	46.21	46.21		199,372.40		996,862		0.00		5		795,214		256,889		44,557		1.00		begin :error_msg := null; :err...
f53dq339tg6ta	27.36	27.36			-27.36	1,809.56		16,286		0.00		9		8,091		3,881		4,551		9.56		2// 2	select c.rowid_object, c.full...
8csym9s53yg2y	6.08	33.44			-6.08	1,809.00		3,618		0.00		2		8,255		3,961		4,630		0.50		2// 2	select c.rowid_object, c.full...
ggku786rstp2j	3.04	36.48			-3.04	1,811.00		1,811		0.00		1		8,947		4,061		5,196		0.00		1// 1	select c.rowid_object, c.full...
05jgbg38fja19	3.04	39.52			-3.04	1,809.00		1,809		0.00		1		8,337		3,984		4,667		0.00		1// 1	select c.rowid_object, c.full...
0gz3r29t7uxdw	3.04	42.56			-3.04	1,809.00		1,809		0.00		1		7,892		4,156		4,082		0.00		1// 1	select c.rowid_object, c.full...
0ht163d05xnqf	3.04	45.60			-3.04	1,809.00		1,809		0.00		1		8,231		4,224		4,387		0.00		1// 1	select c.rowid_object, c.full...
10w62cb6udswr	3.04	48.64			-3.04	1,809.00		1,809		0.00		1		8,038		3,993		4,367		0.00		1// 1	select c.rowid_object, c.full...
2vw792k09qhht	3.04	51.68			-3.04	1,809.00		1,809		0.00		1		8,034		4,089		4,324		0.00		1// 1	select c.rowid_object, c.full...
383w76mqhft8a	3.04	54.72			-3.04	1,809.00		1,809		0.00		1		7,919		4,046		4,205		0.00		1// 1	select c.rowid_object, c.full...
3z4614fqt7uct	3.04	57.75			-3.04	1,809.00		1,809		0.00		1		7,902		4,002		4,213		1.00		1// 1	select c.rowid_object, c.full...
4m1a4b7gwk1br	2.53	60.29	5.42	51.62	2.88	188.50	1,947.83	1,508	116,870	0.00	0.00	8	60	1,046	6,993	843	5,265	118	2,178	1.00	1.00		BEGIN prdld.maint_rr( :1, :2, ...
61gh6sk81rxxc			0.68	52.30	0.68		7,302.00		14,604		0.00		2		24,586		15,802		9,840		1,639,552.00	/ 2/ 2	CREATE TABLE ANONTAB
armw47wdxcsaq	1.60	61.88	1.14	53.44	-0.46	118.75	415.32	950	24,504	0.00	0.00	8	59	1,893	3,725	915	2,890	195	793	1.00	1.00		BEGIN prdld.maint_delta( :1, :...
cckfxmhqnpkvv			0.38	53.82	0.38		4,085.00		8,170		0.00		2		32,210		17,337		14,519		1,000,000.00	/ 2/ 2	create table ANONTAB
35cxwq3ftdjc9			0.25	54.07	0.25		2,715.50		5,431		0.00		2		25,032		2,188		23,210		724.00	/ 1/ 1	create table ANONTAB
d2dccmyz4q092			0.18	54.25	0.18		3,932.00		3,932		0.00		1		27,451		5,874		21,956		4,008.00	/ 1/ 1	CREATE TABLE ANONTAB
6mbnz0rxzbd5d			0.17	54.42	0.17		3,738.00		3,738		0.00		1		26,411		5,864		20,923		3,750.00	/ 1/ 1	CREATE TABLE ANONTAB
cckvkdz7xwdt1			0.17	54.59	0.17		3,572.00		3,572		0.00		1		26,762		5,822		21,328		4,092.00	/ 1/ 1	CREATE TABLE ANONTAB
0z35tvax59u3a			0.13	54.71	0.13		2,702.00		2,702		0.00		1		23,166		3,019		20,522		2,770.00	/ 1/ 1	create table ANONTAB

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: 29,278, Second: 581,358
Captured SQL Elapsed Time First: 283.29 seconds, Second: 2,086.84 seconds
Captured SQL Elapsed Time as a % of DB time First: 57.89%, Second: 18.79%
Captured SQL Executions as a % of Total Executions First: 30.34%, Second: 44.53%
Common SQL Executions as a % of Total Executions First: 27.68%, Second: 35.46%

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
60uw2vh6q9vn2		9.91	9.91		110,060		0		0		0		0.01		1.00		insert into col$(obj#, name, i...
bsa0wjtftg3uw	1.56	7.27	5.71	763	80,756	0	0	0	0	0	0	0.00	0.00	1.93	2.01	2/ 1/ 2	select file# from file$ where ...
86kwhy1f0bttn		2.12	2.12		23,520		0		0		0		0.00		1.00	/ 1/ 1	SELECT /+ ALL_ROWS / COUNT(*...
cm5vu20fhtnq1	1.92		-1.92	941		0		0		0		0.00		0.89		1// 1	select /*+ connect_by_filterin...
7jpt4cpfvcy1k	3.36	1.49	-1.87	1,644	16,552	0	0	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	select ts#, online$ from ts$ w...
9y7s2afnkqs9d	3.01	1.56	-1.45	1,473	17,313	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	delete from idl_ub2$ where obj...
d5jd9b2xct7xz	3.01	1.56	-1.45	1,473	17,313	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	delete from idl_char$ where ob...
dvpfc386d6dmm	3.01	1.56	-1.45	1,473	17,313	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	delete from idl_sb4$ where obj...
gdhz78y24tvnz	3.01	1.56	-1.45	1,473	17,313	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	delete from ncomp_dll$ where o...
gsqxm6zz3w2by	3.01	1.56	-1.45	1,473	17,313	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	delete from idl_ub1$ where obj...
3nkd3g3ju5ph1	2.93	1.58	-1.35	1,434	17,498	0	0	0	0	0	0	0.00	0.00	0.05	0.02	1/ 1/ 1	select obj#, type#, ctime, mti...
0kkhhb2w93cx0	3.04	2.52	-0.53	1,489	27,939	0	0	0	0	0	0	0.00	0.01	1.00	1.00	1/ 1/ 1	update seg$ set type#=:4, bloc...
96g93hntrzjtr	9.48	9.99	0.50	4,640	110,885	0	0	0	0	0	0	0.00	0.00	0.04	0.00	1/ 1/ 1	select /+ rule / bucket_cnt,...

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: 3.71%, Second: .92%
Total Parses First: 65,338, Second: 758,396
Captured SQL Parses First: 21,815, Second: 318,166
Captured SQL Parses % of Total Parses First: 33.39%, Second: 41.95%
Common SQL Parses % of Total Parses First: 31.7%, Second: 43.51%

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st/2nd/Both	SQL Text
	% Total Parses					Parses		#Executions		#Plans
bsa0wjtftg3uw	1.16	1.16	10.76	10.76	9.59	761	81,576	763	80,756	2/ 1/ 2	select file# from file$ where ...
cm5vu20fhtnq1	1.44	2.60			-1.44	941		941		1// 1	select /*+ connect_by_filterin...
7jpt4cpfvcy1k	2.52	5.12	2.18	12.94	-0.33	1,644	16,552	1,644	16,552	1/ 1/ 1	select ts#, online$ from ts$ w...
8w4c8u9udsuyy	1.28	6.40	1.49	14.43	0.21	836	11,332	836	11,332	2/ 1/ 2	select count(*) from ( select ...
ct6c4h224pxgz	1.34	7.74	1.55	15.98	0.21	876	11,760	876	11,760		BEGIN BEGIN IF (sys.is_vpd_ena...
bkjxktgc8afm1	1.33	9.07	1.53	17.52	0.20	868	11,619	868	11,619		DECLARE cnt NUMBER; stmt VARCH...
9y7s2afnkqs9d	2.25	11.32	2.28	19.80	0.03	1,473	17,313	1,473	17,313	1/ 1/ 1	delete from idl_ub2$ where obj...
d5jd9b2xct7xz	2.25	13.58	2.28	22.08	0.03	1,473	17,313	1,473	17,313	1/ 1/ 1	delete from idl_char$ where ob...
dvpfc386d6dmm	2.25	15.83	2.28	24.36	0.03	1,473	17,313	1,473	17,313	1/ 1/ 1	delete from idl_sb4$ where obj...
gdhz78y24tvnz	2.25	18.09	2.28	26.65	0.03	1,473	17,313	1,473	17,313	1/ 1/ 1	delete from ncomp_dll$ where o...
gsqxm6zz3w2by	2.25	20.34	2.28	28.93	0.03	1,473	17,313	1,473	17,313	1/ 1/ 1	delete from idl_ub1$ where obj...

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: 5,033,164,800, Second: 5,117,050,880

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
8gycngut7mkwq	0.57	0.57	0.23	0.23	-0.35	28,747,624	11,533,768	28,747,624	11,533,768		2	/* SQL Analyze(0) / select /...
b398mjk7k7wxj			0.29	0.52	0.29		14,826,145		14,826,145		5	/* SQL Analyze(0) / select /...
cdpujnv16qc8x			0.29	0.80	0.29		14,678,848		14,678,848		9	/* SQL Analyze(0) / select /...
7jarczsb0yzc5			0.28	1.08	0.28		14,292,025		14,292,025		4	/* SQL Analyze(0) / select /...
gb2kz2wr720qc	0.25	0.82			-0.25	12,475,472		12,475,472				create table ANONTAB
80q5hfvumz1db			0.24	1.32	0.24		12,296,359		12,296,359		4	/* SQL Analyze(0) / select /...
6v98v8ux0t9xc			0.17	1.50	0.17		8,927,437		8,927,437		9	create table ANONTAB
7dhd4uf7t3dbw	0.30	1.12	0.13	1.63	-0.17	15,108,416	6,669,937	15,108,416	6,669,937		3	create table ANONTAB
asbucjjc707tn			0.17	1.79	0.17		8,450,768		8,450,768		25	create table ANONTAB
8tdynzm3uxv3r			0.16	1.95	0.16		8,350,373		8,350,373		9	create table ANONTAB
dht82v68h5sj6			0.16	2.11	0.16		8,021,984		8,021,984		4	/* SQL Analyze(0) / select /...
9g5t9p9rvdchn			0.14	2.25	0.14		7,170,985		7,170,985		4	/* SQL Analyze(0) / select /...
d89c1mh5pvbkz	0.13	1.25			-0.13	6,435,072		6,435,072		129		SELECT /+ rule / U.NAME, OT....
31tvs8p54y31d	0.16	1.40	0.06	2.31	-0.10	7,881,048	2,914,087	7,881,048	2,914,087		3	select substrb(dump(val, 16, 0...
0dzypz17rawyn	0.09	1.50			-0.09	4,669,758		4,669,758		1		create table ANONTAB
aa7fqth6y5rhx	0.08	1.58			-0.08	4,199,868		4,199,868		1		create table ANONTAB
4zc5qdcch4b9a	0.08	1.66			-0.08	4,110,250		4,110,250		1		create table ANONTAB
1r8gswtqtxxx7	0.08	1.75	0.04	2.35	-0.05	4,241,904	1,892,795	4,241,904	1,892,795		2	select substrb(dump(val, 16, 0...
buhbzpq7d7r7z	0.09	1.84	0.05	2.39	-0.04	4,517,136	2,442,422	4,517,136	2,442,422		3	select substrb(dump(val, 16, 0...

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
gb2kz2wr720qc	450		-450	450				create table ANONTAB
gjxpqm7s2tf4q	281		-281	281		10		select substrb(dump(val, 16, 0...
6v98v8ux0t9xc		265	265		265		9	create table ANONTAB
8tdynzm3uxv3r		263	263		263		9	create table ANONTAB
8zw484p3sz36d		255	255		255		9	select substrb(dump(val, 16, 0...
azu1ksrdbujgk		252	252		252		8	select substrb(dump(val, 16, 0...
cdpujnv16qc8x		247	247		247		9	/* SQL Analyze(0) / select /...
1r8gswtqtxxx7	282	523	241	282	523		2	select substrb(dump(val, 16, 0...
1gu8t96d0bdmu	156		-156	156		197		select t.ts#, t.file#, t.block...
7dhd4uf7t3dbw	422	576	154	422	576		3	create table ANONTAB
31tvs8p54y31d	611	757	146	611	757		3	select substrb(dump(val, 16, 0...
buhbzpq7d7r7z	407	502	95	407	502		3	select substrb(dump(val, 16, 0...
8gycngut7mkwq	406	497	91	406	497		2	/* SQL Analyze(0) / select /...
3ktacv9r56b51	84		-84	84		97		select owner#, name, namespace...
69k5bhm12sz98	76		-76	76		4		SELECT dbin.instance_number, d...

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: 489.37 seconds, Second: 11,104.61 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
03qzkjk3u3q1g			0.00	0.00	0.00		0.00		0.00		1	/ 1/ 1	CREATE TABLE ANONTAB
03tuga43v3xkg	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	377	4,617		BEGIN aw_drop_proc(ora_dict_ob...
03xmj98vw7aqv	0.00	0.00			0.00	0.00		0.00		62		1// 1	SELECT /*+ leading(u op tcp ts...
05bcrtybfu5rj	0.00	0.00			0.00	0.00		0.00		12		1// 1	SELECT ANONTAB
05jgbg38fja19	0.00	0.00			0.00	0.00		0.00		1		1// 1	select c.rowid_object, c.full...
09y8y6k71rhqn			0.00	0.00	0.00		0.00		0.00		59		BEGIN prdut.disable_constraint...
0a1n8y6rzny10	0.00	0.00			0.00	0.00		0.00		29		1// 1	select dat_grp_id, dat_grp_n...
0cmahs6p5fjc9			0.00	0.00	0.00		0.00		0.00		1	/ 1/ 1	update ANONTAB
0dzypz17rawyn	0.00	0.00			0.00	0.00		0.00		1		1// 1	create table ANONTAB
0f44zztxs6y8y	0.00	0.00			0.00	0.00		0.00		1		1// 1	insert into ANONTAB
0gtmk6w7c653a	0.00	0.00			0.00	0.00		0.00		1			BEGIN prdbv.preview_bvt( :1, :...
0gz3r29t7uxdw	0.00	0.00			0.00	0.00		0.00		1		1// 1	select c.rowid_object, c.full...
0ht163d05xnqf	0.00	0.00			0.00	0.00		0.00		1		1// 1	select c.rowid_object, c.full...
0kkhhb2w93cx0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,489	27,939	1/ 1/ 1	update seg$ set type#=:4, bloc...
0ucq6bhap8869			0.00	0.00	0.00		0.00		0.00		4	/ 1/ 1	/* SQL Analyze(0) / select /...
0uduy46y8mdtf			0.00	0.00	0.00		0.00		0.00		1	/ 1/ 1	update ANONTAB
0xmc93n0tdguk			0.00	0.00	0.00		0.00		0.00		4	/ 1/ 1	select substrb(dump(val, 16, 0...
0z35tvax59u3a			0.00	0.00	0.00		0.00		0.00		1	/ 1/ 1	create table ANONTAB
10d1f1nmcdu3z			0.00	0.00	0.00		0.00		0.00		1	/ 1/ 1	CREATE TABLE ANONTAB

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	230,704	80,797,243	34,922.04	471.43	7,276.01	1,443.39	32.00	11,206.03	34,918.84	165.74	7,252.89	4,276.06
execute count	96,502	1,305,455	1,252.78	197.20	117.56	-40.39	13.38	181.06	1,253.21	69.33	117.19	69.03
logons cumulative	2,125	24,912	1,072.33	4.34	2.24	-48.39	0.29	3.46	1,093.10	1.53	2.24	46.41
opened cursors cumulative	94,266	1,269,929	1,247.18	192.63	114.36	-40.63	13.07	176.13	1,247.59	67.72	114.00	68.34
parse count (total)	65,338	758,396	1,060.73	133.52	68.30	-48.85	9.06	105.18	1,060.93	46.94	68.08	45.04
parse time elapsed	1,477	10,328	599.26	3.02	0.93	-69.21	0.20	1.43	615.00	1.06	0.93	-12.26
physical reads	3,109,206	36,121,784	1,061.77	6,353.53	3,252.86	-48.80	431.23	5,009.84	1,061.76	2,233.63	3,242.53	45.17
physical writes	7,844	8,909,040	113,477.77	16.03	802.28	4,904.87	1.09	1,235.62	113,259.63	5.64	799.73	14,079.61
redo size	36,682,548	18,757,006,424	51,033.32	74,959.21	1,689,119.21	2,153.38	5,087.67	2,601,468.82	51,032.81	26,352.41	1,683,752.82	6,289.37
session cursor cache hits	52,509	784,784	1,394.57	107.30	70.67	-34.14	7.28	108.84	1,395.05	37.72	70.45	86.77
session logical reads	20,372,713	267,079,454	1,210.97	41,630.77	24,051.23	-42.23	2,825.58	37,042.10	1,210.96	14,635.57	23,974.82	63.81
user calls	26,746	447,570	1,573.41	54.65	40.30	-26.26	3.71	62.07	1,573.05	19.21	40.18	109.16
user commits	1,319	10,541	699.17	2.70	0.95	-64.81	0.18	1.46	711.11	0.95	0.95	0.00
user rollbacks	73	599	720.55	0.15	0.05	-66.67	0.01	0.08	700.00	0.05	0.05	0.00
workarea executions - optimal	8,054	74,417	823.98	16.46	6.70	-59.30	1.12	10.32	821.43	5.79	6.68	15.37

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	5	1,586	31,620.00	0.01	0.14	1,300.00	0.00	0.22	100.00	0.00	0.14	100.00
Batched IO block miss count	156	67,678	43,283.33	0.32	6.09	1,803.13	0.02	9.39	46,850.00	0.11	6.08	5,427.27
Batched IO buffer defrag count	4	1,745	43,525.00	0.01	0.16	1,500.00	0.00	0.24	100.00	0.00	0.16	100.00
Batched IO double miss count	13	5,806	44,561.54	0.03	0.52	1,633.33	0.00	0.81	100.00	0.01	0.52	5,100.00
Batched IO same unit count	34	16,090	47,223.53	0.07	1.45	1,971.43	0.00	2.23	100.00	0.02	1.44	7,100.00
Batched IO single block count	4	1,198	29,850.00	0.01	0.11	1,000.00	0.00	0.17	100.00	0.00	0.11	100.00
Batched IO vector block count	118	51,228	43,313.56	0.24	4.61	1,820.83	0.02	7.10	35,400.00	0.08	4.60	5,650.00
Batched IO vector read count	12	2,327	19,291.67	0.02	0.21	950.00	0.00	0.32	100.00	0.01	0.21	2,000.00
Block Cleanout Optim referenced	5	2,714	54,180.00	0.01	0.24	2,300.00	0.00	0.38	100.00	0.00	0.24	100.00
CCursor + sql area evicted	242	2,496	931.40	0.49	0.22	-55.10	0.03	0.35	1,066.67	0.17	0.22	29.41
CPU used by this session	22,179	445,770	1,909.87	45.32	40.14	-11.43	3.08	61.83	1,907.47	15.93	40.02	151.22
CPU used when call started	20,768	444,158	2,038.67	42.44	40.00	-5.75	2.88	61.60	2,038.89	14.92	39.87	167.23
CR blocks created	210	7,900	3,661.90	0.43	0.71	65.12	0.03	1.10	3,566.67	0.15	0.71	373.33
Commit SCN cached	114	244,179	214,092.11	0.23	21.99	9,460.87	0.02	33.87	169,250.00	0.08	21.92	27,300.00
DBWR checkpoint buffers written	3,155	2,629,516	83,244.41	6.45	236.80	3,571.32	0.44	364.70	82,786.36	2.27	236.04	10,298.24
DBWR checkpoints	427	5,962	1,296.25	0.87	0.54	-37.93	0.06	0.83	1,283.33	0.31	0.54	74.19
DBWR object drop buffers written	2,421	47,259	1,852.04	4.95	4.26	-13.94	0.34	6.55	1,826.47	1.74	4.24	143.68
DBWR transaction table writes	182	936	414.29	0.37	0.08	-78.38	0.03	0.13	333.33	0.13	0.08	-38.46
DBWR undo block writes	987	500,446	50,603.75	2.02	45.07	2,131.19	0.14	69.41	49,478.57	0.71	44.92	6,226.76
DDL statements parallelized	158	2,275	1,339.87	0.32	0.20	-37.50	0.02	0.32	1,500.00	0.11	0.20	81.82
DFO trees parallelized	277	4,006	1,346.21	0.57	0.36	-36.84	0.04	0.56	1,300.00	0.20	0.36	80.00
HSC Heap Segment Block Changes	29,343	36,988,289	125,954.90	59.96	3,330.90	5,455.20	4.07	5,130.02	125,944.72	21.08	3,320.31	15,651.00
Heap Segment Array Inserts	247	1,064	330.77	0.50	0.10	-80.00	0.03	0.15	400.00	0.18	0.10	-44.44
Heap Segment Array Updates	1,513	51,428	3,299.07	3.09	4.63	49.84	0.21	7.13	3,295.24	1.09	4.62	323.85
IMU CR rollbacks	694	31,322	4,413.26	1.42	2.82	98.59	0.10	4.34	4,240.00	0.50	2.81	462.00
IMU Flushes	263	3,823	1,353.61	0.54	0.34	-37.04	0.04	0.53	1,225.00	0.19	0.34	78.95
IMU Redo allocation size	242,084	7,584,700	3,033.09	494.69	683.02	38.07	33.58	1,051.95	3,032.67	173.91	680.85	291.50
IMU commits	321	1,773	452.34	0.66	0.16	-75.76	0.04	0.25	525.00	0.23	0.16	-30.43
IMU undo allocation size	1,275,832	10,736,144	741.50	2,607.11	966.82	-62.92	176.95	1,489.03	741.50	916.55	963.75	5.15
Number of read IOs issued	48,843	577,512	1,082.38	99.81	52.01	-47.89	6.77	80.10	1,083.16	35.09	51.84	47.73
PX local messages recv'd	45,401	5,641,862	12,326.74	92.77	508.06	447.66	6.30	782.49	12,320.48	32.62	506.45	1,452.58
PX local messages sent	45,401	5,642,032	12,327.11	92.77	508.08	447.68	6.30	782.51	12,320.79	32.62	506.47	1,452.64
Parallel operations downgraded to serial	44	119	170.45	0.09	0.01	-88.89	0.01	0.02	100.00	0.03	0.01	-66.67
Parallel operations not downgraded	277	4,038	1,357.76	0.57	0.36	-36.84	0.04	0.56	1,300.00	0.20	0.36	80.00
RowCR attempts	6	42,926	715,333.33	0.01	3.87	38,600.00	0.00	5.95	100.00	0.00	3.85	100.00
RowCR hits	12	42,096	350,700.00	0.02	3.79	18,850.00	0.00	5.84	100.00	0.01	3.78	37,700.00
SMON posted for undo segment shrink	1	15	1,400.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
SQL*Net roundtrips to/from client	11,072	296,060	2,573.95	22.63	26.66	17.81	1.54	41.06	2,566.23	7.95	26.58	234.34
active txn count during cleanout	826	31,800	3,749.88	1.69	2.86	69.23	0.11	4.41	3,909.09	0.59	2.85	383.05
background checkpoints completed	1	427	42,600.00	0.00	0.04	100.00	0.00	0.06	100.00	0.00	0.04	100.00
background checkpoints started	1	427	42,600.00	0.00	0.04	100.00	0.00	0.06	100.00	0.00	0.04	100.00
background timeouts	40,043	39,578	-1.16	81.83	3.56	-95.65	5.55	5.49	-1.08	28.77	3.55	-87.66
buffer is not pinned count	15,384,222	173,374,198	1,026.96	31,437.00	15,612.82	-50.34	2,133.71	24,045.82	1,026.95	11,051.88	15,563.21	40.82
buffer is pinned count	8,727,929	79,402,322	809.75	17,835.15	7,150.39	-59.91	1,210.52	11,012.56	809.74	6,270.06	7,127.68	13.68
bytes received via SQL*Net from client	2,489,300	2,386,576,279	95,773.39	5,086.78	214,917.66	4,125.02	345.25	331,001.85	95,773.09	1,788.29	214,234.85	11,879.87
bytes sent via SQL*Net to client	9,494,483	1,456,822,253	15,243.88	19,401.57	131,190.79	576.19	1,316.83	202,051.31	15,243.77	6,820.75	130,773.99	1,817.30
calls to get snapshot scn: kcmgss	99,735	1,430,643	1,334.44	203.80	128.83	-36.79	13.83	198.42	1,334.71	71.65	128.42	79.23
calls to kcmgas	17,973	1,810,944	9,975.91	36.73	163.08	344.00	2.49	251.17	9,987.15	12.91	162.56	1,159.18
calls to kcmgcs	58,178	1,633,397	2,707.59	118.88	147.09	23.73	8.07	226.54	2,707.19	41.79	146.62	250.85
cell physical IO interconnect bytes	51,480,388,608	820,783,090,176	1,494.36	105,197,965.76	73,913,739.57	-29.74	7,140,045.02	113,837,014.74	1,494.35	36,983,037.79	73,678,912.94	99.22
change write time	406	21,130	5,104.43	0.83	1.90	128.92	0.06	2.93	4,783.33	0.29	1.90	555.17
cleanout - number of ktugct calls	865	2,820,822	326,006.59	1.77	254.02	14,251.41	0.12	391.23	325,925.00	0.62	253.22	40,741.94
cleanouts and rollbacks - consistent read gets	132	841	537.12	0.27	0.08	-70.37	0.02	0.12	500.00	0.09	0.08	-11.11
cleanouts only - consistent read gets	20	2,787,974	13,939,770.00	0.04	251.06	627,550.00	0.00	386.67	100.00	0.01	250.27	2,502,600.00
cluster key scan block gets	32,189	546,459	1,597.66	65.78	49.21	-25.19	4.46	75.79	1,599.33	23.12	49.05	112.15
cluster key scans	21,169	403,333	1,805.30	43.26	36.32	-16.04	2.94	55.94	1,802.72	15.21	36.21	138.07
commit batch/immediate performed	879	75,901	8,534.93	1.80	6.84	280.00	0.12	10.53	8,675.00	0.63	6.81	980.95
commit batch/immediate requested	879	75,901	8,534.93	1.80	6.84	280.00	0.12	10.53	8,675.00	0.63	6.81	980.95
commit cleanout failures: callback failure	18	425	2,261.11	0.04	0.04	0.00	0.00	0.06	100.00	0.01	0.04	300.00
commit cleanout failures: cannot pin	5	966	19,220.00	0.01	0.09	800.00	0.00	0.13	100.00	0.00	0.09	100.00
commit cleanouts	23,593	882,698	3,641.36	48.21	79.49	64.88	3.27	122.42	3,643.73	16.95	79.24	367.49
commit cleanouts successfully completed	23,570	880,637	3,636.26	48.16	79.30	64.66	3.27	122.14	3,635.17	16.93	79.05	366.92
commit immediate performed	879	75,901	8,534.93	1.80	6.84	280.00	0.12	10.53	8,675.00	0.63	6.81	980.95
commit immediate requested	879	75,901	8,534.93	1.80	6.84	280.00	0.12	10.53	8,675.00	0.63	6.81	980.95
commit txn count during cleanout	313	2,794,986	892,866.77	0.64	251.70	39,228.13	0.04	387.65	969,025.00	0.22	250.90	113,945.45
consistent changes	4,525	76,980	1,601.22	9.25	6.93	-25.08	0.63	10.68	1,595.24	3.25	6.91	112.62
consistent gets	20,109,392	218,847,681	988.29	41,092.68	19,707.83	-52.04	2,789.06	30,352.68	988.28	14,446.40	19,645.21	35.99
consistent gets - examination	12,268,925	111,764,114	810.95	25,071.02	10,064.66	-59.86	1,701.63	15,500.92	810.95	8,813.88	10,032.69	13.83
consistent gets direct	3,081,294	29,427,732	855.04	6,296.49	2,650.05	-57.91	427.36	4,081.43	855.03	2,213.57	2,641.63	19.34
consistent gets from cache	17,028,098	189,419,949	1,012.40	34,796.19	17,057.78	-50.98	2,361.70	26,271.25	1,012.39	12,232.83	17,003.59	39.00
consistent gets from cache (fastpath)	4,651,496	76,332,717	1,541.04	9,505.13	6,873.97	-27.68	645.14	10,586.83	1,541.01	3,341.59	6,852.13	105.06
cursor authentications	512	5,125	900.98	1.05	0.46	-56.19	0.07	0.71	914.29	0.37	0.46	24.32
data blocks consistent reads - undo records applied	942	41,853	4,342.99	1.92	3.77	96.35	0.13	5.80	4,361.54	0.68	3.76	452.94
db block gets	263,321	48,231,773	18,216.72	538.09	4,343.40	707.19	36.52	6,689.42	18,217.14	189.17	4,329.60	2,188.74
db block gets direct	550	3,104,718	564,394.18	1.12	279.59	24,863.39	0.08	430.60	538,150.00	0.40	278.70	69,575.00
db block gets from cache	262,771	45,127,055	17,073.53	536.96	4,063.81	656.82	36.44	6,258.81	17,075.66	188.77	4,050.90	2,045.94
db block gets from cache (fastpath)	73,273	2,477,510	3,281.20	149.73	223.11	49.01	10.16	343.61	3,281.99	52.64	222.40	322.49
deferred (CURRENT) block cleanout applications	8,674	369,909	4,164.57	17.72	33.31	87.98	1.20	51.30	4,175.00	6.23	33.21	433.07
dirty buffers inspected	92	503,783	547,490.22	0.19	45.37	23,778.95	0.01	69.87	698,600.00	0.07	45.22	64,500.00
enqueue conversions	11,294	144,865	1,182.67	23.08	13.05	-43.46	1.57	20.09	1,179.62	8.11	13.00	60.30
enqueue releases	116,032	1,119,505	864.82	237.11	100.81	-57.48	16.09	155.27	865.01	83.36	100.49	20.55
enqueue requests	116,035	1,120,073	865.29	237.11	100.87	-57.46	16.09	155.35	865.51	83.36	100.55	20.62
enqueue timeouts	3	569	18,866.67	0.01	0.05	400.00	0.00	0.08	100.00	0.00	0.05	100.00
enqueue waits	1,495	32,936	2,103.08	3.05	2.97	-2.62	0.21	4.57	2,076.19	1.07	2.96	176.64
exchange deadlocks	1	149	14,800.00	0.00	0.01	100.00	0.00	0.02	100.00	0.00	0.01	100.00
free buffer inspected	41,282	5,126,788	12,318.94	84.36	461.68	447.27	5.73	711.05	12,309.25	29.66	460.21	1,451.62
free buffer requested	37,362	5,834,212	15,515.36	76.35	525.39	588.13	5.18	809.17	15,521.04	26.84	523.72	1,851.27
heap block compress	124	31,193	25,055.65	0.25	2.81	1,024.00	0.02	4.33	21,550.00	0.09	2.80	3,011.11
hot buffers moved to head of LRU	24,815	1,750,119	6,952.67	50.71	157.60	210.79	3.44	242.73	6,956.10	17.83	157.10	781.10
immediate (CR) block cleanout applications	152	2,788,815	1,834,646.71	0.31	251.14	80,912.90	0.02	386.79	1,933,850.00	0.11	250.34	227,481.82
immediate (CURRENT) block cleanout applications	4,698	110,434	2,250.66	9.60	9.94	3.54	0.65	15.32	2,256.92	3.38	9.91	193.20
index fast full scans (full)	414	2,853	589.13	0.85	0.26	-69.41	0.06	0.40	566.67	0.30	0.26	-13.33
index fetch by key	7,452,732	68,982,313	825.60	15,229.34	6,212.04	-59.21	1,033.65	9,567.38	825.59	5,353.97	6,192.31	15.66
index scans kdiixs1	328,838	21,712,758	6,502.87	671.97	1,955.29	190.98	45.61	3,011.41	6,502.52	236.23	1,949.08	725.08
java call heap collected bytes	633,312	11,644,664	1,738.69	1,294.15	1,048.63	-18.97	87.84	1,615.04	1,738.62	454.97	1,045.30	129.75
java call heap collected count	3,303	185,012	5,501.33	6.75	16.66	146.81	0.46	25.66	5,478.26	2.37	16.61	600.84
java call heap gc count	9	38	322.22	0.02	0.00	-100.00	0.00	0.01	100.00	0.01	0.00	-100.00
java call heap object count	3,303	75,962	2,199.79	6.75	6.84	1.33	0.46	10.54	2,191.30	2.37	6.82	187.76
java call heap object count max	3,303	79,724	2,313.68	6.75	7.18	6.37	0.46	11.06	2,304.35	2.37	7.16	202.11
java call heap total size	11,796,480	15,204,352	28.89	24,105.60	1,369.19	-94.32	1,636.11	2,108.74	28.89	8,474.48	1,364.84	-83.89
java call heap total size max	11,796,480	15,204,352	28.89	24,105.60	1,369.19	-94.32	1,636.11	2,108.74	28.89	8,474.48	1,364.84	-83.89
java call heap used size	633,312	5,259,600	730.49	1,294.15	473.64	-63.40	87.84	729.47	730.45	454.97	472.14	3.77
java call heap used size max	633,312	5,487,280	766.44	1,294.15	494.14	-61.82	87.84	761.05	766.40	454.97	492.57	8.26
java session heap live size	3,096,576	3,735,552	20.63	6,327.72	336.40	-94.68	429.48	518.10	20.63	2,224.55	335.33	-84.93
java session heap live size max	3,096,576	3,735,552	20.63	6,327.72	336.40	-94.68	429.48	518.10	20.63	2,224.55	335.33	-84.93
java session heap used size	3,096,576	3,735,552	20.63	6,327.72	336.40	-94.68	429.48	518.10	20.63	2,224.55	335.33	-84.93
java session heap used size max	3,096,576	3,735,552	20.63	6,327.72	336.40	-94.68	429.48	518.10	20.63	2,224.55	335.33	-84.93
leaf node 90-10 splits	37	493	1,232.43	0.08	0.04	-50.00	0.01	0.07	600.00	0.03	0.04	33.33
leaf node splits	51	864	1,594.12	0.10	0.08	-20.00	0.01	0.12	1,100.00	0.04	0.08	100.00
lob reads	1,883	16,590	781.04	3.85	1.49	-61.30	0.26	2.30	784.62	1.35	1.49	10.37
lob writes	1,114	10,498	842.37	2.28	0.95	-58.33	0.15	1.46	873.33	0.80	0.94	17.50
lob writes unaligned	1,114	10,498	842.37	2.28	0.95	-58.33	0.15	1.46	873.33	0.80	0.94	17.50
max cf enq hold time	720	19,260	2,575.00	1.47	1.73	17.69	0.10	2.67	2,570.00	0.52	1.73	232.69
messages received	56,937	1,532,704	2,591.93	116.35	138.02	18.62	7.90	212.58	2,590.89	40.90	137.59	236.41
messages sent	56,937	1,532,704	2,591.93	116.35	138.02	18.62	7.90	212.58	2,590.89	40.90	137.59	236.41
no buffer to keep pinned count	864	7,611	780.90	1.77	0.69	-61.02	0.12	1.06	783.33	0.62	0.68	9.68
no work - consistent read gets	7,764,138	102,414,555	1,219.07	15,865.68	9,222.71	-41.87	1,076.84	14,204.20	1,219.06	5,577.69	9,193.41	64.82
non-idle wait count	203,970	5,350,012	2,522.94	416.80	481.78	15.59	28.29	742.01	2,522.87	146.53	480.25	227.75
parse count (failures)	64	324	406.25	0.13	0.03	-76.92	0.01	0.04	300.00	0.05	0.03	-40.00
parse count (hard)	5,168	63,366	1,126.12	10.56	5.71	-45.93	0.72	8.79	1,120.83	3.71	5.69	53.37
parse time cpu	881	7,839	789.78	1.80	0.71	-60.56	0.12	1.09	808.33	0.63	0.70	11.11
physical read IO requests	59,524	2,157,351	3,524.34	121.63	194.28	59.73	8.26	299.21	3,522.40	42.76	193.66	352.90
physical read bytes	50,941,231,104	591,819,309,056	1,061.77	104,096,220.53	53,294,931.15	-48.80	7,065,266.86	82,081,300.42	1,061.76	36,595,712.00	53,125,611.23	45.17
physical read total IO requests	70,531	2,450,675	3,374.61	144.13	220.69	53.12	9.78	339.89	3,375.36	50.67	219.99	334.16
physical read total bytes	51,161,033,728	634,655,865,344	1,140.51	104,545,377.76	57,152,479.03	-45.33	7,095,752.26	88,022,438.52	1,140.49	36,753,616.18	56,970,903.53	55.01
physical read total multi block requests	49,247	672,990	1,266.56	100.63	60.60	-39.78	6.83	93.34	1,266.62	35.38	60.41	70.75
physical reads cache	27,912	4,232,969	15,065.41	57.04	381.19	568.29	3.87	587.08	15,070.03	20.05	379.98	1,795.16
physical reads cache prefetch	17,358	3,198,470	18,326.49	35.47	288.03	712.04	2.41	443.61	18,307.05	12.47	287.12	2,202.49
physical reads direct	3,081,294	31,888,815	934.92	6,296.49	2,871.67	-54.39	427.36	4,422.76	934.90	2,213.57	2,862.55	29.32
physical write IO requests	4,410	3,225,577	73,042.34	9.01	290.47	3,123.86	0.61	447.37	73,239.34	3.17	289.55	9,034.07
physical write bytes	128,516,096	145,965,711,360	113,477.77	262,617.13	13,144,607.52	4,905.24	17,824.47	20,244,448.30	113,476.72	92,324.78	13,102,846.62	14,092.12
physical write total IO requests	19,425	3,521,198	18,027.15	39.69	317.09	698.92	2.69	488.37	18,055.02	13.95	316.09	2,165.88
physical write total bytes	319,354,880	186,127,224,832	58,182.25	652,588.00	16,761,260.54	2,468.43	44,292.75	25,814,576.21	58,181.72	229,421.61	16,708,009.41	7,182.67
physical write total multi block requests	251	413,759	164,744.22	0.51	37.26	7,205.88	0.03	57.39	191,200.00	0.18	37.14	20,533.33
physical writes direct	550	5,603,981	1,018,805.64	1.12	504.65	44,958.04	0.08	777.23	971,437.50	0.40	503.05	125,662.50
physical writes from cache	7,294	3,305,059	45,212.02	14.90	297.63	1,897.52	1.01	458.39	45,285.15	5.24	296.68	5,561.83
physical writes non checkpoint	6,133	7,818,534	127,383.03	12.53	704.08	5,519.15	0.85	1,084.38	127,474.12	4.41	701.84	15,814.74
pinned buffers inspected	1	269	26,800.00	0.00	0.02	100.00	0.00	0.04	100.00	0.00	0.02	100.00
prefetched blocks aged out before use	27	119,522	442,574.07	0.06	10.76	17,833.33	0.00	16.58	100.00	0.02	10.73	53,550.00
process last non-idle time	7,200	6,994	-2.86	14.71	0.63	-95.72	1.00	0.97	-3.00	5.17	0.63	-87.81
queries parallelized	107	1,444	1,249.53	0.22	0.13	-40.91	0.01	0.20	1,900.00	0.08	0.13	62.50
recursive calls	2,095,010	19,628,179	836.90	4,281.06	1,767.57	-58.71	290.57	2,722.29	836.88	1,505.04	1,761.96	17.07
recursive cpu usage	6,424	429,453	6,585.13	13.13	38.67	194.52	0.89	59.56	6,592.13	4.61	38.55	736.23
redo KB read	37,204	18,897,243	50,693.58	76.02	1,701.75	2,138.56	5.16	2,620.92	50,693.02	26.73	1,696.34	6,246.20
redo blocks checksummed by FG (exclusive)	11,662	920,980	7,797.27	23.83	82.94	248.05	1.62	127.73	7,784.57	8.38	82.67	886.52
redo blocks written	78,193	37,839,440	48,292.36	159.78	3,407.54	2,032.64	10.84	5,248.07	48,313.93	56.17	3,396.72	5,947.21
redo entries	125,086	41,851,257	33,357.99	255.61	3,768.82	1,374.44	17.35	5,804.48	33,355.22	89.86	3,756.85	4,080.78
redo ordering marks	2,806	569,451	20,194.05	5.73	51.28	794.94	0.39	78.98	20,151.28	2.02	51.12	2,430.69
redo size for direct writes	16,024	31,944,136	199,251.82	32.74	2,876.66	8,686.38	2.22	4,430.43	199,468.92	11.51	2,867.52	24,813.29
redo subscn max counts	5,812	1,582,598	27,129.83	11.88	142.52	1,099.66	0.81	219.50	26,998.77	4.18	142.06	3,298.56
redo synch long waits	177	2,365	1,236.16	0.36	0.21	-41.67	0.02	0.33	1,550.00	0.13	0.21	61.54
redo synch time	149	1,918	1,187.25	0.30	0.17	-43.33	0.02	0.27	1,250.00	0.11	0.17	54.55
redo synch time (usec)	2,314,270	33,974,202	1,368.03	4,729.11	3,059.47	-35.31	320.98	4,711.99	1,368.00	1,662.55	3,049.75	83.44
redo synch writes	2,496	27,859	1,016.15	5.10	2.51	-50.78	0.35	3.86	1,002.86	1.79	2.50	39.66
redo wastage	2,014,536	46,037,972	2,185.29	4,116.62	4,145.84	0.71	279.40	6,385.15	2,185.31	1,447.22	4,132.67	185.56
redo write time	470	15,910	3,285.11	0.96	1.43	48.96	0.07	2.21	3,057.14	0.34	1.43	320.59
redo writes	7,657	158,346	1,967.99	15.65	14.26	-8.88	1.06	21.96	1,971.70	5.50	14.21	158.36
rollback changes - undo records applied	290	3,658	1,161.38	0.59	0.33	-44.07	0.04	0.51	1,175.00	0.21	0.33	57.14
rollbacks only - consistent read gets	52	6,117	11,663.46	0.11	0.55	400.00	0.01	0.85	8,400.00	0.04	0.55	1,275.00
rows fetched via callback	7,373,377	64,520,237	775.04	15,067.18	5,810.22	-61.44	1,022.65	8,948.52	775.03	5,296.97	5,791.76	9.34
session pga memory	25,993,904	11,983,984	-53.90	53,117.43	1,079.19	-97.97	3,605.21	1,662.10	-53.90	18,673.78	1,075.76	-94.24
session pga memory max	41,870,672	20,569,200	-50.87	85,560.92	1,852.31	-97.84	5,807.23	2,852.81	-50.87	30,079.51	1,846.43	-93.86
session uga memory	68,830,873,248	69,998,199,192	1.70	140,652,936.83	6,303,527.36	-95.52	9,546,461.22	9,708,272.66	1.69	49,447,466.41	6,283,500.83	-87.29
session uga memory max	3,049,409,576	102,914,165,792	3,274.89	6,231,337.66	9,267,699.27	48.73	422,936.23	14,273,492.65	3,274.86	2,190,667.80	9,238,255.46	321.71
shared hash latch upgrades - no wait	18,798	493,924	2,527.53	38.41	44.48	15.80	2.61	68.50	2,524.52	13.50	44.34	228.44
shared hash latch upgrades - wait	12	2,300	19,066.67	0.02	0.21	950.00	0.00	0.32	100.00	0.01	0.21	2,000.00
sorts (memory)	14,929	100,445	572.82	30.51	9.05	-70.34	2.07	13.93	572.95	10.72	9.02	-15.86
sorts (rows)	31,226,398	849,406,940	2,620.16	63,809.80	76,491.39	19.87	4,330.93	117,806.95	2,620.13	22,432.76	76,248.38	239.90
sql area evicted	242	14,902	6,057.85	0.49	1.34	173.47	0.03	2.07	6,800.00	0.17	1.34	688.24
sql area purged	395	4,014	916.20	0.81	0.36	-55.56	0.05	0.56	1,020.00	0.28	0.36	28.57
summed dirty queue length	84	1,226,070	1,459,507.14	0.17	110.41	64,847.06	0.01	170.05	1,700,400.00	0.06	110.06	183,333.33
switch current to new buffer	4,211	964,336	22,800.40	8.60	86.84	909.77	0.58	133.75	22,960.34	3.03	86.57	2,757.10
table fetch by rowid	9,774,731	95,985,236	881.97	19,974.24	8,643.73	-56.73	1,355.70	13,312.50	881.97	7,022.08	8,616.27	22.70
table fetch continued row	2,073	10,163	390.26	4.24	0.92	-78.30	0.29	1.41	386.21	1.49	0.91	-38.93
table scan blocks gotten	4,922,239	41,394,571	740.97	10,058.38	3,727.69	-62.94	682.69	5,741.14	740.96	3,536.09	3,715.85	5.08
table scan rows gotten	305,619,419	3,319,880,309	986.28	624,520.17	298,964.21	-52.13	42,387.72	460,444.75	986.27	219,554.18	298,014.39	35.74
table scans (direct read)	27	69,150	256,011.11	0.06	6.23	10,283.33	0.00	9.59	100.00	0.02	6.21	30,950.00
table scans (long tables)	4,801	153,743	3,102.31	9.81	13.84	41.08	0.67	21.32	3,082.09	3.45	13.80	300.00
table scans (rowid ranges)	4,578	151,182	3,202.36	9.35	13.61	45.56	0.63	20.97	3,228.57	3.29	13.57	312.46
table scans (short tables)	14,328	188,916	1,218.51	29.28	17.01	-41.91	1.99	26.20	1,216.58	10.29	16.96	64.82
total cf enq hold time	1,290	46,930	3,537.98	2.64	4.23	60.23	0.18	6.51	3,516.67	0.93	4.21	352.69
total number of cf enq holders	798	35,648	4,367.17	1.63	3.21	96.93	0.11	4.94	4,390.91	0.57	3.20	461.40
total number of times SMON posted	45	981	2,080.00	0.09	0.09	0.00	0.01	0.14	1,300.00	0.03	0.09	200.00
transaction rollbacks	17	909	5,247.06	0.03	0.08	166.67	0.00	0.13	100.00	0.01	0.08	700.00
undo change vector size	13,737,496	7,906,237,172	57,452.24	28,071.98	711,978.06	2,436.26	1,905.31	1,096,541.15	57,451.85	9,868.89	709,716.08	7,091.45
write clones created in background	464	5,113	1,001.94	0.95	0.46	-51.58	0.06	0.71	1,083.33	0.33	0.46	39.39

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
6.77	83.94	1,139.88	0.06	9.17	15,183.33	6.68	68.95	932.19	0.04	24.64	61,500.00	0.02	7.16	35,700.00	0.00	10.40	100.00	0.01	2.58	25,700.00

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
9.78	339.88	3,375.26	1.48	149.10	9,974.32	6.77	149.12	2,102.66	2.69	488.89	18,074.35	0.57	341.58	59,826.32	0.04	93.78	234,350.00	1.13	27.44	2,328.32

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
6.77	83.94	1,139.88	6.74	73.67	993.03	0.00	4.63	100.00	0.04	24.62	61,450.00	0.02	13.90	69,400.00	0.00	5.42	100.00	0.01	2.56	25,500.00

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
9.78	339.89	3,375.36	8.26	230.78	2,693.95	0.00	69.55	100.00	2.69	488.23	18,049.81	0.61	418.54	68,513.11	0.00	29.82	100.00	1.12	26.26	2,244.64

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
PRD_DATA	7.90	96.94	1,127.09	0.09	276.15	306,733.33	56,940	698,957	0.29	0.16	54.51	31.23	681	1,991,106	3	1,115	6.67	7.52	7.99	373.09	365.10
PRD_TEMP	0.08	54.05	67,462.50	0.18	64.97	35,994.44	600	389,726	0.02	0.14	1.42	29.11	1,278	468,463	177	10,109	0.06	0.05	0.26	119.02	118.76
TEMP	0.00	69.55	100.00	0.00	29.82	100.00	0	501,465	0.00	0.00	0.00	4.26	1	215,006	0	0	0.00	0.00	0.00	99.37	99.37
PRD_INDX	0.17	74.71	43,847.06	0.10	19.65	19,550.00	1,220	538,690	4.27	0.04	2.04	1.41	720	141,710	9	1,757	2.22	2.26	0.27	94.37	94.10
UNDOTBS1	0.00	0.02	100.00	0.06	54.72	91,100.00	5	161	0.00	0.06	1.00	1.00	462	394,519	1	581	0.00	0.00	0.06	54.74	54.67
SYSTEM	0.09	2.63	2,822.22	0.07	0.95	1,257.14	645	18,994	6.59	0.42	2.72	2.20	517	6,823	12	3,248	0.83	0.06	0.16	3.58	3.42
SYSAUX	0.02	1.29	6,350.00	0.10	0.98	880.00	111	9,330	4.86	0.12	1.00	1.13	747	7,049	0	0	0.00	0.00	0.12	2.27	2.15

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
TEMP	/u01/app/oracle/oradata/PROD/temp01.dbf	0.00	33.17	100.00	0.00	13.73	100.00	0	239,142	0.00	0.00	0.00	4.52	0	98,976	0	0	0.00	0.00	0.00	46.89	46.89
TEMP	/u01/app/oracle/oradata/PROD/temp03.dbf	0.00	0.08	100.00	0.00	0.07	100.00	0	548	0.00	0.00	0.00	14.69	0	536	0	0	0.00	0.00	0.00	0.15	0.15
TEMP	/u01/app/oracle/oradata/PROD/temp04.dbf	0.00	0.05	100.00	0.00	0.05	100.00	0	358	0.00	0.00	0.00	14.53	0	346	0	0	0.00	0.00	0.00	0.10	0.10

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
PRD_TEMP	/u01/app/oracle/oradata/PROD/DB_TEMP02.dbf	0.00	0.26	0.26	0.00	0.14	187	199,825	0.03	27.71	1.57	28.37	410	239,506	0.06	33.22	27	5,559	0.00	0.01
TEMP	/u01/app/oracle/oradata/PROD/temp01.dbf	0.00	0.00	0.00	0.00	0.00	0	239,142	0.00	33.17	0.00	4.52	0	98,976	0.00	13.73	0	0	0.00	0.00
TEMP	/u01/app/oracle/oradata/PROD/temp03.dbf	0.00	0.00	0.00	0.00	0.00	0	548	0.00	0.08	0.00	14.69	0	536	0.00	0.07	0	0	0.00	0.00
TEMP	/u01/app/oracle/oradata/PROD/temp04.dbf	0.00	0.00	0.00	0.00	0.00	0	358	0.00	0.05	0.00	14.53	0	346	0.00	0.05	0	0	0.00	0.00
TEMP	/u01/app/oracle/oradata/PROD/temp05.dbf	0.00	0.00	0.00	0.00	0.00	0	64,348	0.00	8.92	0.00	2.97	1	22,059	0.00	3.06	0	0	0.00	0.00

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
PRD_DATA	/u01/app/oracle/oradata/PROD/DB_DATA04.dbf	0.00	0.03	0.03	0	370	0.00	0.77	6,339	26,724	0.88	3.71	0.38	0.19	52.76	42.34	30	3,851	0	1
PRD_DATA	/u01/app/oracle/oradata/PROD/DB_DATA03.dbf	0.00	0.02	0.02	0	364	0.00	0.71	33,009	378,656	4.58	52.52	0.30	0.16	54.77	38.03	618	879,879	0	122
PRD_INDX	/u01/app/oracle/oradata/PROD/DB_INDX01.dbf	0.00	0.02	0.02	0	546	0.00	0.32	655	264,177	0.09	36.64	3.83	0.04	1.84	1.40	441	69,951	0	10
PRD_DATA	/u01/app/oracle/oradata/PROD/DB_DATA02.dbf	0.00	0.01	0.01	0	166	0.00	0.78	6,520	233,615	0.90	32.40	0.29	0.15	45.70	17.86	14	1,026,148	0	142

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	9	178	884	197	165,888	197
E1	0	10	823	24,773	41,784	165,888	41,784

B2	0	17	4,039	156,453	165,888	165,888	418,036
E2	0	16	884	165,319	165,888	165,888	501,147

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
100.00	84.62	-15.38	5,114,388	16,513,332	222.88	2,387	174,879	0	68,109,764	100.00	0	31,787

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)
B1	3,072	2,608	379.2	0.0	0.0	0.0	0.0	314,570
E1	3,072	2,589	405.4	0.0	0.0	0.0	0.0	314,570

B2	3,072	2,503	470.0	0.0	0.0	0.0	0.0	314,570
E2	3,072	2,511	447.7	0.0	0.0	0.0	0.0	314,570

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)
data block	0.00	0.00	0.00	0.04	12.58	173	6,905	0.00	0.02	100.00
file header block	0.00	0.00	0.00	0.01	0.49	27	9,311	0.00	0.00	0.00
segment header	0.00	0.00	-0.00	0.01	0.00	1	0	0.10	0.00	-100.00
undo block	0.00	0.00	0.00	0.00	0.00	0	428	0.00	0.00	0.00
undo header	0.00	0.00	0.00	0.00	0.00	1	153	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.00	0.79	0.79	0	88	0	2,007	0	2,007	0	0	0	223	0.00	393.95
CR-Reuse Block Range (block range reuse ckpt)	0.14	0.40	0.27	1	45	4,153	104,768	4,153	104,765	0	0	452	10,510	1.50	4.27
CF-Controlfile Transaction	0.12	0.36	0.24	1	40	4,000	74,980	4,000	74,977	0	4	143	9,946	4.13	4.00
RO-Multiple Object Reuse (fast object reuse)	0.11	0.20	0.09	1	22	3,834	47,808	3,834	47,808	0	0	416	5,183	1.27	4.26

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	1.49	12,050	912	10	18/28.2	0/0	0/0/0/0/0/0
2nd	497.28	233,792	935	14	18.5/30.6	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)
call allocation	52.12	19.86	-32.26	11,200	257,552	1,514	27,131	1,271	25,273	283	2,227	13,554	82,930	69,376
active service list	9.39	37.39	28.00	26,050	145,453	1,090	24,841	1,042	21,099	51	4,193	1,372	252,989	251,617
space background task latch	2.95	14.06	11.12	7,931	53,475	49	4,375	37	2,968	16	1,577	862	256,855	255,993
cache buffers chains	22.10	11.79	-10.31	22,899,550	503,699,329	17,318	4,996,417	17,221	4,993,180	120	1,322	3,795	22,936	19,141
Real-time plan statistics latch	9.39	14.20	4.81	37,806	61,932	639	8,463	589	7,102	51	1,592	850	109,276	108,426
shared pool	5.34	2.11	-3.23	501,100	4,903,169	13,369	188,233	13,340	188,009	29	237	45,244	273,901	228,657
row cache objects	2.03	0.87	-1.15	1,021,889	10,626,357	2,211	243,840	2,200	243,744	11	98	214	4,683	4,469
interrupt manipulation	1.10	0.03	-1.08	11,142	157,917	670	9,915	664	9,912	6	3	183	137	-46
object queue header operation	0.37	1.42	1.05	532,358	32,950,159	115	6,207	113	6,053	2	159	8	10,838	10,830
archive process latch	0.00	0.74	0.74	586	3,565	0	87	0	4	0	83	0	13,798	13,798
enqueues	0.55	0.13	-0.42	165,286	1,138,038	733	26,385	730	26,370	3	15	96	928	832
redo writing	0.55	0.20	-0.36	84,303	1,876,591	516	10,561	513	10,539	3	22	38	464	426
messages	0.55	0.21	-0.34	217,533	3,604,777	2,590	49,856	2,587	49,832	3	24	26	597	571
parallel query stats	0.00	0.32	0.32	2,469	34,854	438	5,411	438	5,375	0	36	0	6,755	6,755
process queue reference	0.00	0.19	0.19	1,048,289	103,454,887	650	22,965	650	22,946	0	21	0	3,756	3,756
session state list latch	0.18	0.34	0.15	4,446	52,317	538	11,116	537	11,082	1	38	4	461	457
sort extent pool	0.00	0.15	0.15	431	41,820	0	140	0	123	0	17	0	435	435
active checkpoint queue latch	0.55	0.40	-0.15	59,861	1,442,908	1,285	19,831	1,282	19,786	3	45	106	720	614
redo allocation	0.00	0.14	0.14	33,858	711,221	78	5,433	78	5,417	0	16	0	1,095	1,095
cache buffers lru chain	0.00	0.07	0.07	39,076	6,448,841	7	3,585	7	3,577	0	8	0	459	459
enqueue hash chains	0.00	0.06	0.06	246,883	2,460,335	146	8,031	146	8,024	0	7	0	186	186
process queue	0.00	0.04	0.04	17,280	234,258	342	3,685	342	3,680	0	5	0	3,315	3,315
SQL memory manager workarea list latch	0.00	0.04	0.04	172,517	332,264	264	2,824	264	2,820	0	4	0	22	22
post/wait queue	0.00	0.04	0.04	2,787	45,285	3	45	3	41	0	4	0	217	217
In memory undo latch	0.00	0.03	0.03	13,027	262,594	0	43	0	40	0	3	0	130	130
dml lock allocation	0.00	0.03	0.03	1,396	38,277	21	1,607	21	1,604	0	3	0	159	159
error message lists	0.00	0.03	0.03	3,585	50,361	358	5,420	358	5,417	0	3	0	449	449
parallel query alloc buffer	0.00	0.03	0.03	28,450	375,476	294	3,449	294	3,446	0	3	0	322	322
qmn task queue latch	0.00	0.02	0.02	1,932	1,566	469	176	469	174	0	2	0	20	20
resmgr:free threads list	0.00	0.02	0.02	4,312	50,058	532	10,950	532	10,948	0	2	0	33	33
checkpoint queue latch	0.00	0.01	0.01	2,704,534	50,281,020	83	1,878	83	1,877	0	1	0	16	16
dummy allocation	0.00	0.01	0.01	4,314	50,060	305	7,642	305	7,641	0	1	0	13	13
object queue header heap	0.00	0.01	0.01	6,583	103,091	0	4	0	3	0	1	0	56	56
simulator lru latch	0.00	0.01	0.01	5,296	2,747,243	0	210	0	209	0	1	0	10	10

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
space background task latch	862	256,855	255,993	7,931	53,475	49	4,375	37	2,968	16	1,577	2.95	14.06	11.12
active service list	1,372	252,989	251,617	26,050	145,453	1,090	24,841	1,042	21,099	51	4,193	9.39	37.39	28.00
shared pool	45,244	273,901	228,657	501,100	4,903,169	13,369	188,233	13,340	188,009	29	237	5.34	2.11	-3.23
Real-time plan statistics latch	850	109,276	108,426	37,806	61,932	639	8,463	589	7,102	51	1,592	9.39	14.20	4.81
call allocation	13,554	82,930	69,376	11,200	257,552	1,514	27,131	1,271	25,273	283	2,227	52.12	19.86	-32.26
cache buffers chains	3,795	22,936	19,141	22,899,550	503,699,329	17,318	4,996,417	17,221	4,993,180	120	1,322	22.10	11.79	-10.31
archive process latch	0	13,798	13,798	586	3,565	0	87	0	4	0	83	0.00	0.74	0.74
object queue header operation	8	10,838	10,830	532,358	32,950,159	115	6,207	113	6,053	2	159	0.37	1.42	1.05
parallel query stats	0	6,755	6,755	2,469	34,854	438	5,411	438	5,375	0	36	0.00	0.32	0.32
row cache objects	214	4,683	4,469	1,021,889	10,626,357	2,211	243,840	2,200	243,744	11	98	2.03	0.87	-1.15
process queue reference	0	3,756	3,756	1,048,289	103,454,887	650	22,965	650	22,946	0	21	0.00	0.19	0.19
process queue	0	3,315	3,315	17,280	234,258	342	3,685	342	3,680	0	5	0.00	0.04	0.04
redo allocation	0	1,095	1,095	33,858	711,221	78	5,433	78	5,417	0	16	0.00	0.14	0.14
enqueues	96	928	832	165,286	1,138,038	733	26,385	730	26,370	3	15	0.55	0.13	-0.42
active checkpoint queue latch	106	720	614	59,861	1,442,908	1,285	19,831	1,282	19,786	3	45	0.55	0.40	-0.15
messages	26	597	571	217,533	3,604,777	2,590	49,856	2,587	49,832	3	24	0.55	0.21	-0.34
cache buffers lru chain	0	459	459	39,076	6,448,841	7	3,585	7	3,577	0	8	0.00	0.07	0.07
session state list latch	4	461	457	4,446	52,317	538	11,116	537	11,082	1	38	0.18	0.34	0.15
error message lists	0	449	449	3,585	50,361	358	5,420	358	5,417	0	3	0.00	0.03	0.03
sort extent pool	0	435	435	431	41,820	0	140	0	123	0	17	0.00	0.15	0.15
redo writing	38	464	426	84,303	1,876,591	516	10,561	513	10,539	3	22	0.55	0.20	-0.36
parallel query alloc buffer	0	322	322	28,450	375,476	294	3,449	294	3,446	0	3	0.00	0.03	0.03
post/wait queue	0	217	217	2,787	45,285	3	45	3	41	0	4	0.00	0.04	0.04
enqueue hash chains	0	186	186	246,883	2,460,335	146	8,031	146	8,024	0	7	0.00	0.06	0.06
dml lock allocation	0	159	159	1,396	38,277	21	1,607	21	1,604	0	3	0.00	0.03	0.03
In memory undo latch	0	130	130	13,027	262,594	0	43	0	40	0	3	0.00	0.03	0.03
object queue header heap	0	56	56	6,583	103,091	0	4	0	3	0	1	0.00	0.01	0.01
interrupt manipulation	183	137	-46	11,142	157,917	670	9,915	664	9,912	6	3	1.10	0.03	-1.08
resmgr:free threads list	0	33	33	4,312	50,058	532	10,950	532	10,948	0	2	0.00	0.02	0.02
SQL memory manager workarea list latch	0	22	22	172,517	332,264	264	2,824	264	2,820	0	4	0.00	0.04	0.04
qmn task queue latch	0	20	20	1,932	1,566	469	176	469	174	0	2	0.00	0.02	0.02
checkpoint queue latch	0	16	16	2,704,534	50,281,020	83	1,878	83	1,877	0	1	0.00	0.01	0.01
dummy allocation	0	13	13	4,314	50,060	305	7,642	305	7,641	0	1	0.00	0.01	0.01
simulator lru latch	0	10	10	5,296	2,747,243	0	210	0	209	0	1	0.00	0.01	0.01

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
PRD_SCM	PRD_DATA	ANONTAB		TABLE	15.41	15.41	0.07	0.07	-15.34	3,138,848	185,552	-94.09	15.68	0.08	-15.60
PRD_SCM	PRD_DATA	ANONTAB		TABLE	36.81	52.22	24.62	24.69	-12.19	7,499,104	65,764,144	776.96	37.47	28.15	-9.32
PRD_SCM	PRD_DATA	ANONTAB		TABLE			9.17	33.86	9.17		24,484,800			10.48	10.48
PRD_SCM	PRD_INDX	PK_COLUMN		INDEX	25.18	77.40	16.80	50.66	-8.38	5,130,272	44,869,600	774.60	25.63	19.21	-6.43
PRD_SCM	PRD_DATA	ANONTAB		TABLE			7.16	57.82	7.16		19,124,176			8.19	8.19
PRD_SCM	PRD_DATA	ANONTAB		TABLE	6.85	84.25			-6.85	1,395,456			6.97		-6.97
SYS	SYSTEM	I_OBJ1		INDEX	8.75	93.00	5.81	63.63	-2.94	1,783,504	15,524,976	770.48	8.91	6.65	-2.27

					% 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
PRD_SCM	PRD_DATA	ANONTAB		TABLE	99.27	99.27	0.37	0.37	-98.90	3,086,547	134,258	-95.65	99.70	0.52	-99.18
PRD_SCM	PRD_DATA	ANONTAB		TABLE			13.52	13.90	13.52		4,885,234			19.08	19.08
PRD_SCM	PRD_DATA	ANONTAB		TABLE			7.67	21.57	7.67		2,771,975			10.83	10.83
PRD_SCM	PRD_DATA	ANONTAB		TABLE			6.84	28.41	6.84		2,470,497			9.65	9.65
PRD_SCM	PRD_DATA	ANONTAB		TABLE			6.12	34.53	6.12		2,211,514			8.64	8.64
PRD_SCM	PRD_DATA	ANONTAB		TABLE			5.55	40.08	5.55		2,003,830			7.83	7.83
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.16	99.43			-0.16	5,061			0.16		-0.16
SYS	SYSTEM	OBJ$		TABLE	0.04	99.47			-0.04	1,178			0.04		-0.04
PRD_SCM	PRD_DATA	SVR1_187A		INDEX	0.03	99.50			-0.03	815			0.03		-0.03
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.02	99.52			-0.02	755			0.02		-0.02

					% 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
PRD_SCM	PRD_DATA	ANONTAB		TABLE	90.88	90.88	1.02	1.02	-89.86	54,096	21,941	-59.44	97.29	2.03	-95.26
PRD_SCM	PRD_DATA	ANONTAB		TABLE			12.81	13.83	12.81		276,374			25.56	25.56
PRD_SCM	PRD_DATA	ANONTAB		TABLE			3.92	17.75	3.92		84,629			7.83	7.83
PRD_SCM	PRD_INDX	SVR1_35WG		INDEX			3.40	21.15	3.40		73,250			6.78	6.78
MISSING	PRD_INDX	** MISSING: 3983472/3983472	MISSING	UNDEFINED			3.40	24.54	3.40		73,244			6.77	6.77
MISSING	PRD_INDX	** MISSING: 3986204/3986204	MISSING	UNDEFINED			3.21	27.75	3.21		69,208			6.40	6.40
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.62	91.50			-0.62	367			0.66		-0.66
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.60	92.10			-0.60	356			0.64		-0.64
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.42	92.52			-0.42	252			0.45		-0.45
PRD_SCM	PRD_DATA	SVR1_187A		INDEX	0.15	92.67			-0.15	87			0.16		-0.16

					% 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
PRD_SCM	PRD_DATA	ANONTAB		TABLE	90.88	90.88	1.02	1.02	-89.86	54,096	21,941	-59.44	97.29	2.03	-95.26
PRD_SCM	PRD_DATA	ANONTAB		TABLE			12.81	13.83	12.81		276,374			25.56	25.56
PRD_SCM	PRD_DATA	ANONTAB		TABLE			3.92	17.75	3.92		84,629			7.83	7.83
PRD_SCM	PRD_INDX	SVR1_35WG		INDEX			3.40	21.15	3.40		73,250			6.78	6.78
MISSING	PRD_INDX	** MISSING: 3983472/3983472	MISSING	UNDEFINED			3.40	24.54	3.40		73,244			6.77	6.77
MISSING	PRD_INDX	** MISSING: 3986204/3986204	MISSING	UNDEFINED			3.21	27.75	3.21		69,208			6.40	6.40
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.62	91.50			-0.62	367			0.66		-0.66
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.60	92.10			-0.60	356			0.64		-0.64
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.42	92.52			-0.42	252			0.45		-0.45
PRD_SCM	PRD_DATA	SVR1_187A		INDEX	0.15	92.67			-0.15	87			0.16		-0.16

					% 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	FET$		TABLE	0.00	0.00			0.00	0		100.00	0.00		0.00
SYS	SYSTEM	I_COL1		INDEX	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSTEM	I_OBJ#		INDEX	0.00	0.00			0.00	0		100.00	0.00		0.00
SYS	SYSTEM	I_OBJ1		INDEX	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSTEM	SEG$		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.00	0.00	0	0	0.00	0.00	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
PRD_SCM	PRD_DATA	ANONTAB		TABLE	100.00	100.00	0.36	0.36	-99.64	3,081,294	114,122	-96.30	100.00	0.50	-99.50
PRD_SCM	PRD_DATA	ANONTAB		TABLE			14.57	14.93	14.57		4,647,373			20.36	20.36
PRD_SCM	PRD_DATA	ANONTAB		TABLE			8.68	23.61	8.68		2,766,482			12.12	12.12
PRD_SCM	PRD_DATA	ANONTAB		TABLE			7.74	31.35	7.74		2,467,988			10.81	10.81
PRD_SCM	PRD_DATA	ANONTAB		TABLE			6.93	38.28	6.93		2,210,004			9.68	9.68
PRD_SCM	PRD_DATA	ANONTAB		TABLE			6.28	44.56	6.28		2,003,712			8.78	8.78
SYS	SYSTEM	FET$		TABLE	0.00	100.00			0.00	0		100.00	0.00		0.00
SYS	SYSTEM	I_OBJ#		INDEX	0.00	100.00			0.00	0		100.00	0.00		0.00
SYS	SYSTEM	SEG$		TABLE	0.00	100.00	0.00	44.56	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSTEM	TAB$		TABLE	0.00	100.00	0.00	44.56	0.00	0	0	0.00	0.00	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: 7,844, Second: 8,909,040
Captured Physical Writes First: 962, Second: 3,934,508
Captured Physical Writes as % of Total First: 12.26%, Second: 44.16%

Owner	Tablespace	Object Name	Subobject 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
PRD_SCM	PRD_DATA	ANONTAB		TABLE			16.85	16.85	16.85		1,500,880			38.15	38.15
PRD_SCM	PRD_DATA	ANONTAB		TABLE			12.51	29.36	12.51		1,114,466			28.33	28.33
SYS	SYSTEM	SEG$		TABLE	1.38	1.38	0.02	29.37	-1.36	108	1,386	1,183.33	11.23	0.04	-11.19
MISSING	PRD_TEMP	** MISSING: 3771736/3771736	MISSING	UNDEFINED	0.68	2.05			-0.68	53			5.51		-5.51
MISSING	PRD_TEMP	** MISSING: 3771964/3771964	MISSING	UNDEFINED	0.65	2.70			-0.65	51			5.30		-5.30
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.65	3.35			-0.65	51			5.30		-5.30
MISSING	PRD_TEMP	** MISSING: 3771907/3771907	MISSING	UNDEFINED	0.64	3.99			-0.64	50			5.20		-5.20
PRD_SCM	PRD_DATA	ANONTAB		TABLE			0.37	29.74	0.37		33,050			0.84	0.84
PRD_SCM	PRD_DATA	ANONTAB		TABLE			0.37	30.11	0.37		33,045			0.84	0.84
PRD_SCM	PRD_DATA	ANONTAB		TABLE			0.37	30.48	0.37		33,039			0.84	0.84

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	Subobject 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
PRD_SCM	PRD_DATA	ANONTAB		TABLE			33.53	33.53	33.53		1,081,604			50.91	50.91
PRD_SCM	PRD_DATA	ANONTAB		TABLE			26.69	60.22	26.69		860,892			40.52	40.52
SYS	SYSTEM	SEG$		TABLE	2.43	2.43	0.04	60.26	-2.39	107	1,139	964.49	15.62	0.05	-15.57
PRD_SCM	PRD_DATA	ANONTAB		TABLE	1.16	3.58			-1.16	51			7.45		-7.45
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.88	4.47			-0.88	39			5.69		-5.69
SYS	SYSTEM	TAB$		TABLE	0.84	5.31	0.01	60.27	-0.83	37	298	705.41	5.40	0.01	-5.39
PRD_SCM	PRD_DATA	ANONTAB		TABLE	0.63	5.94			-0.63	28			4.09		-4.09
PRD_SCM	PRD_INDX	SVR1_35WG		INDEX			0.29	60.56	0.29		9,344			0.44	0.44
PRD_SCM	PRD_INDX	SVR1_35WG		INDEX			0.29	60.85	0.29		9,342			0.44	0.44
MISSING	PRD_INDX	** MISSING: 3982102/3982102	MISSING	UNDEFINED			0.29	61.14	0.29		9,341			0.44	0.44

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: 550, Second: 5,603,981
Captured Direct Writes First: 320, Second: 1,275,373
Captured Direct Writes as % of Total First: 58.18%, Second: 22.76%

Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	Diff
					% of Total Direct Writes					Direct Writes		% of Captured Direct Writes
MISSING	PRD_TEMP	** MISSING: 3771679/3771679	MISSING	UNDEFINED	6.55	6.55			-6.55	36		11.25		-11.25
MISSING	PRD_TEMP	** MISSING: 3771793/3771793	MISSING	UNDEFINED	6.55	13.09			-6.55	36		11.25		-11.25
MISSING	PRD_TEMP	** MISSING: 3771850/3771850	MISSING	UNDEFINED	6.55	19.64			-6.55	36		11.25		-11.25
MISSING	PRD_TEMP	** MISSING: 3771907/3771907	MISSING	UNDEFINED	6.55	26.18			-6.55	36		11.25		-11.25
MISSING	PRD_TEMP	** MISSING: 3771964/3771964	MISSING	UNDEFINED	6.55	32.73			-6.55	36		11.25		-11.25
MISSING	PRD_TEMP	** MISSING: 3983176/3983176	MISSING	UNDEFINED			0.59	0.59	0.59		32,789		2.57	2.57
MISSING	PRD_TEMP	** MISSING: 3984542/3984542	MISSING	UNDEFINED			0.59	1.17	0.59		32,789		2.57	2.57
MISSING	PRD_TEMP	** MISSING: 3985908/3985908	MISSING	UNDEFINED			0.59	1.76	0.59		32,789		2.57	2.57
MISSING	PRD_TEMP	** MISSING: 3987274/3987274	MISSING	UNDEFINED			0.59	2.34	0.59		32,789		2.57	2.57
MISSING	PRD_TEMP	** MISSING: 3981810/3981810	MISSING	UNDEFINED			0.58	2.93	0.58		32,777		2.57	2.57

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: 5,215, Second: 156,596
Captured Table Scans First: 2,481, Second: 40,036
Captured Table Scans as % of Total First: 47.57%, Second: 25.57%

Owner	Tablespace	Object Name	Subobject 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
PRD_SCM	PRD_DATA	ANONTAB		TABLE	17.93	17.93			-17.93	935			37.69		-37.69
PRD_SCM	PRD_DATA	ANONTAB		TABLE	17.91	35.84			-17.91	934			37.65		-37.65
PRD_SCM	PRD_DATA	ANONTAB		TABLE			2.79	2.79	2.79		4,370			10.92	10.92
PRD_SCM	PRD_DATA	ANONTAB		TABLE			1.34	4.14	1.34		2,106			5.26	5.26
PRD_SCM	PRD_DATA	ANONTAB		TABLE			1.19	5.33	1.19		1,871			4.67	4.67
PRD_SCM	PRD_DATA	ANONTAB		TABLE			1.10	6.43	1.10		1,728			4.32	4.32
SYS	SYSTEM	I_OBJ1		INDEX	1.38	37.22	0.40	6.83	-0.98	72	626	769.44	2.90	1.56	-1.34
MISSING	PRD_TEMP	** MISSING: 3771679/3771679	MISSING	UNDEFINED	0.90	38.12			-0.90	47			1.89		-1.89
MISSING	PRD_TEMP	** MISSING: 3771793/3771793	MISSING	UNDEFINED	0.90	39.02			-0.90	47			1.89		-1.89
PRD_SCM	PRD_DATA	g		TABLE			0.88	7.71	0.88		1,379			3.44	3.44

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: 230,704, Second: 80,797,243
Captured DB Block Changes First: 71,248, Second: 38,195,376
Captured DB Block Changes as % of Total First: 30.88%, Second: 47.27%

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
PRD_SCM	PRD_DATA	ANONTAB	TABLE			23.20	23.20	23.20		18,746,240			49.08	49.08
PRD_SCM	PRD_DATA	ANONTAB	TABLE			23.01	46.21	23.01		18,592,672			48.68	48.68
SYS	SYSTEM	TAB$	TABLE	6.75	6.75	0.15	46.36	-6.60	15,568	120,576	674.51	21.85	0.32	-21.53
SYS	SYSTEM	I_COL1	INDEX	5.40	12.15	0.13	46.49	-5.27	12,464	104,320	736.97	17.49	0.27	-17.22
SYS	SYSTEM	I_COL2	INDEX	5.33	17.48	0.13	46.62	-5.20	12,288	101,600	726.82	17.25	0.27	-16.98
SYS	SYSTEM	I_COL3	INDEX	5.22	22.69	0.13	46.74	-5.09	12,032	102,304	750.27	16.89	0.27	-16.62
SYS	SYSTEM	CDEF$	TABLE	1.48	24.18			-1.48	3,424			4.81		-4.81

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: 466
Total TX Row Lock Wait Time First: 0.00 seconds, Second: 0.06 seconds
TX Row Lock Wait Time as % of DB time First: 0%, Second: 0%
Captured Row Lock Waits First: 1, Second: 464

Owner	Tablespace	Object Name	Subobject Name	Type	1st	2nd	Diff	1st	2nd	%Diff	1st	1st Total	2nd	2nd Total	Diff
					% of Total			Row Lock Waits			% of Captured
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	100.00	99.57	-0.43	1	464	46,300.00	100.00	100.00	100.00	100.00	0.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: 597
TX ITL Wait Time First: 0.00 seconds, Second: 0.05 seconds
TX ITL Wait Time as % of DB time First: 0%, Second: 0%
Captured TX ITL Waits First: 1, Second: 591

Owner	Tablespace	Object Name	Subobject Name	Type	1st	2nd	Diff	1st	2nd	%Diff	1st	1st Total	2nd	2nd Total	Diff
					% of Total			ITL Waits			% of Captured
SYS	SYSTEM	SEG$		TABLE	100.00	98.99	-1.01	1	591	59,000.00	100.00	100.00	100.00	100.00	0.00

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: 24, Second: 11,300
Buffer Busy Wait Time First: 0.00 seconds, Second: 0.58 seconds
Buffer Busy Wait Time as % of DB time First: 0%, Second: .01%
Captured Buffer Busy Waits First: 10, Second: 3,300

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	I_FILE#_BLOCK#	INDEX	20.83	20.83	11.19	11.19	-9.64	5	1,265	25,200.00	50.00	38.33	-11.67
SYS	SYSTEM	SEG$	TABLE	20.83	41.67	17.17	28.36	-3.67	5	1,940	38,700.00	50.00	58.79	8.79
PRD_SCM	PRD_DATA	ANONTAB	TABLE			0.10	28.46	0.10		11			0.33	0.33
PRD_SCM	PRD_DATA	ANONTAB	TABLE			0.10	28.56	0.10		11			0.33	0.33
PRD_SCM	PRD_DATA	ANONTAB	TABLE			0.09	28.65	0.09		10			0.30	0.30
SYS	SYSTEM	TAB$	TABLE	0.00	41.67	0.02	28.66	0.02	0	2	100.00	0.00	0.06	0.06

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.27	0.01	-96.30	0.02	0.02	0.00	130	130	0.00	0.00	0	0	0.00	0.00	4	4	1	1
dc_constraints	3.43	1.19	-65.31	0.23	1.83	695.65	1,678	13,187	33.02	33.00	0	0	0.00	0.00	1,662	13,057	40	35
dc_global_oids	1.22	0.12	-90.16	0.08	0.19	137.50	598	1,368	1.17	0.00	0	0	0.00	0.00	0	0	320	300
dc_histogram_data	49.37	13.03	-73.61	3.35	20.06	498.81	24,158	144,643	0.48	0.07	0	0	0.00	0.00	18	1,468	10,077	3,995
dc_histogram_defs	126.48	42.84	-66.13	8.58	65.98	669.00	61,896	475,749	7.50	23.31	0	0	0.00	0.00	997	33,560	11,906	9,367
dc_object_grants	0.07	0.00	-100.00	0.00	0.00	0.00	32	24	0.00	0.00	0	0	0.00	0.00	0	0	288	31
dc_objects	156.42	42.73	-72.68	10.62	65.81	519.68	76,548	474,529	2.59	4.93	0	0	0.00	0.00	2,147	23,517	37,809	59,646
dc_profiles	0.81	0.14	-82.72	0.06	0.21	250.00	398	1,535	0.00	0.00	0	0	0.00	0.00	0	0	1	1
dc_rollback_segments	2.69	0.14	-94.80	0.18	0.22	22.22	1,317	1,579	0.00	0.00	0	0	0.00	0.00	0	0	17	17
dc_segments	54.86	37.93	-30.86	3.72	58.42	1,470.43	26,847	421,206	1.67	2.57	0	0	0.00	0.00	2,409	48,964	3,762	3,877
dc_sequences	0.05	0.02	-60.00	0.00	0.03	100.00	26	187	0.00	1.07	0	0	0.00	0.00	26	187	31	15
dc_table_scns	0.64	0.39	-39.06	0.04	0.60	1,400.00	313	4,330	100.00	100.00	0	0	0.00	0.00	0	0	0	0
dc_tablespace_quotas	7.58	26.48	249.34	0.51	40.78	7,896.08	3,708	294,060	0.00	0.00	0	0	0.00	0.00	0	0	7	6
dc_tablespaces	111.76	55.43	-50.40	7.59	85.37	1,024.77	54,691	615,506	0.00	0.00	0	0	0.00	0.00	0	0	13	13
dc_users	197.21	105.13	-46.69	13.39	161.91	1,109.19	96,510	1,167,386	0.21	0.23	0	0	0.00	0.00	0	0	2,516	4,868
global database name	11.12	0.62	-94.42	0.75	0.95	26.67	5,440	6,830	0.00	0.00	0	0	0.00	0.00	0	0	1	1
outstanding_alerts	0.25	0.01	-96.00	0.02	0.02	0.00	120	120	0.00	0.00	0	0	0.00	0.00	0	0	10	10
sch_lj_oids	0.02	0.00	-100.00	0.00	0.00	0.00	8	8	0.00	0.00	0	0	0.00	0.00	0	0	14	4

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
ACCOUNT_STATUS	1.54	0.27	-82.47	0.10	0.42	320.00	756	3,030	0.00	0.00	0	0			0	0	0	0
BODY	6.79	2.87	-57.73	0.46	4.43	863.04	3,321	31,905	0.00	0.00	5,232	39,747	0.08	0.00	4	0	0	0
CLUSTER	0.32	0.00	-100.00	0.02	0.00	-100.00	157	4	0.00	25.00	157	4	0.00	25.00	0	0	0	0
DBLINK	1.55	0.27	-82.58	0.11	0.42	281.82	760	3,034	0.00	0.00	0	0			0	0	0	0
DIRECTORY	14.93	5.48	-63.30	1.01	8.44	735.64	7,308	60,828	0.00	0.00	7,308	60,828	0.00	0.00	0	0	0	0
EDITION	1.20	0.18	-85.00	0.08	0.28	250.00	586	1,998	0.00	0.00	980	3,529	0.00	0.00	0	0	0	0
INDEX	3.99	1.62	-59.40	0.27	2.49	822.22	1,954	17,958	1.13	0.59	1,961	17,810	19.22	20.89	220	2,092	0	0
JAVA DATA	0.04	0.00	-100.00	0.00	0.00	0.00	21	24	0.00	0.00	0	0			0	0	0	0
OBJECT ID	1.01	0.52	-48.51	0.07	0.80	1,042.86	492	5,768	100.00	100.00	0	0			0	0	0	0
SCHEMA	3.58	1.83	-48.88	0.24	2.82	1,075.00	1,754	20,305	0.00	0.00	0	0			0	0	0	0
SQL AREA	75.03	38.05	-49.29	5.09	58.61	1,051.47	36,718	422,565	3.99	4.18	137,974	1,848,486	6.63	5.47	2,620	22,029	2,273	30,813
SQL AREA BUILD	7.60	3.20	-57.89	0.52	4.93	848.08	3,720	35,547	40.59	42.82	0	0			0	0	0	0
SQL AREA STATS	6.18	3.29	-46.76	0.42	5.06	1,104.76	3,023	36,481	49.12	43.34	3,023	36,481	49.12	43.34	0	0	0	0
TABLE/PROCEDURE	297.87	41.85	-85.95	20.22	64.45	218.74	145,768	464,726	0.60	2.45	184,498	896,264	1.59	3.65	537	3,712	0	0
TRIGGER	18.20	10.11	-44.45	1.24	15.57	1,155.65	8,907	112,238	0.00	0.00	8,907	112,238	0.00	0.00	0	0	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)	183,552.00	192,192.00	4.71	122,240.00	101,632.00	-16.86	-33.40	-47.12
	Used (KB)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Avg Alloc (KB)	8,343.27	5,652.71	-32.25	3,134.36	2,258.49	-27.94	-62.43	-60.05
	Std Dev Alloc (KB)	17,194.36	14,209.13	-17.36	7,272.97	5,343.74	-26.53	-57.70	-62.39
	Max Alloc (KB)	52,160.00	31,424.00	0.00	32,896.00	31,424.00	-4.47	-36.93	-39.75
	Hist Max Alloc (KB)
	Num Procs	22.00	34.00	54.55	39.00	45.00	15.38	77.27	32.35
	Num Alloc	22.00	34.00	54.55	39.00	45.00	15.38	77.27	32.35
JAVA	Alloc (KB)		2,418.01		7,362.07
	Used (KB)		2,410.02		7,340.33
	Avg Alloc (KB)		2,418.01		3,681.04
	Std Dev Alloc (KB)		0.00		1,786.19				100.00
	Max Alloc (KB)				4,944.06
	Hist Max Alloc (KB)		2,859.59		4,944.06
	Num Procs		1.00		2.00
	Num Alloc		1.00		2.00
Other	Alloc (KB)	200,607.67	215,877.02	7.61	345,392.82	351,530.22	1.78	72.17	62.84
	Used (KB)
	Avg Alloc (KB)	4,559.27	3,722.02	-18.36	4,485.62	4,449.75	-0.80	-1.62	19.55
	Std Dev Alloc (KB)	7,468.56	6,658.00	-10.85	7,441.30	7,446.46	0.07	-0.36	11.84
	Max Alloc (KB)	27,814.53	28,902.53	0.00	28,902.53	28,902.53	0.00	3.91	3.91
	Hist Max Alloc (KB)	41,866.97	41,866.97	0.00	44,798.17	44,798.17	0.00	7.00	7.00
	Num Procs	44.00	58.00	31.82	77.00	79.00	2.60	75.00	36.21
	Num Alloc	44.00	58.00	31.82	77.00	79.00	2.60	75.00	36.21
PL/SQL	Alloc (KB)	3,529.06	3,958.03	12.16	5,523.05	4,658.27	-15.66	56.50	17.69
	Used (KB)	853.93	1,185.24	38.80	1,709.85	1,077.08	-37.01	100.23	-9.13
	Avg Alloc (KB)	84.03	70.68	-15.88	73.64	60.50	-17.85	-12.36	-14.41
	Std Dev Alloc (KB)	389.96	344.28	-11.71	311.07	291.97	-6.14	-20.23	-15.19
	Max Alloc (KB)	2,520.48	2,520.48	0.00	2,520.48	2,520.48	0.00	0.00	0.00
	Hist Max Alloc (KB)	2,836.42	2,836.42	0.00	2,836.42	2,836.42	0.00	0.00	0.00
	Num Procs	42.00	56.00	33.33	75.00	77.00	2.67	78.57	37.50
	Num Alloc	42.00	45.00	7.14	63.00	63.00	0.00	50.00	40.00
SQL	Alloc (KB)	617.45	696.02	12.72	793.29	707.06	-10.87	28.48	1.59
	Used (KB)	100.57	77.90	-22.54	140.78	94.38	-32.96	39.98	21.16
	Avg Alloc (KB)	24.70	18.32	-25.84	13.68	11.78	-13.84	-44.62	-35.66
	Std Dev Alloc (KB)	49.77	43.53	-12.54	35.04	32.66	-6.79	-29.60	-24.97
	Max Alloc (KB)	241.36	247.36	0.00	249.43	247.36	-0.83	3.34	2.49
	Hist Max Alloc (KB)	121,546.59	121,546.59	0.00	121,546.59	256,978.51	111.42	0.00	111.42
	Num Procs	25.00	38.00	52.00	58.00	60.00	3.45	132.00	57.89
	Num Alloc	20.00	20.00	0.00	36.00	35.00	-2.78	80.00	75.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,899,968.00	2,899,968.00	0.00	2,818,048.00	2,818,048.00	0.00	-2.82	-2.82
Fixed Size	2,191.02	2,191.02	0.00	2,191.02	2,191.02	0.00	0.00	0.00
Redo Buffers	9,500.00	9,500.00	0.00	9,500.00	9,500.00	0.00	0.00	0.00
Variable Size	5,439,488.98	5,439,488.98	0.00	5,521,408.98	5,521,408.98	0.00	1.51	1.51

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	JOXLE	24,389,568	24,389,568	0.00	24,389,568	24,389,568	0.00	0.00	0.00
java pool	free memory	75,310,080	75,310,080	0.00	75,310,080	75,310,080	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	411,238,400	411,238,400	0.00	411,238,400	411,238,400	0.00	0.00	0.00
shared pool	KGLH0	916,743,000	941,098,688	2.66	855,058,336	838,835,832	-1.90	-6.73	-10.87
shared pool	KGLHD	551,854,440	555,264,384	0.62	589,842,664	591,155,328	0.22	6.88	6.46
shared pool	KQR L PO				64,799,448	66,273,656	2.28
shared pool	SQLA	1,463,850,304	1,604,568,344	9.61	1,997,780,328	1,993,203,752	-0.23	36.47	24.22
shared pool	free memory	1,503,006,312	1,328,160,208	-11.63	1,075,999,368	1,093,926,728	1.67	-28.41	-17.64
shared pool	kglsim object batch	66,248,280	66,248,280	0.00	66,248,280	66,248,280	0.00	0.00	0.00
streams pool	KGH: NO ACCESS	16,760,864	16,760,864	0.00	16,760,864	16,760,864	0.00	0.00	0.00
streams pool	free memory	16,616,440	16,616,440	0.00	16,605,016	16,605,016	0.00	-0.07	-0.07
	buffer_cache	2,432,696,320	2,432,696,320	0.00	2,348,810,240	2,348,810,240	0.00	-3.45	-3.45
	fixed_sga	2,243,608	2,243,608	0.00	2,243,608	2,243,608	0.00	0.00	0.00
	log_buffer	9,728,000	9,728,000	0.00	9,728,000	9,728,000	0.00	0.00	0.00
	shared_io_pool	536,870,912	536,870,912	0.00	536,870,912	536,870,912	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 Coordinator	0.00	0.00	100.00	0.00	0.00	0.00	0.00	0.00	0.00
QMON Slaves	0.00	0.00	100.00	0.00	0.00	100.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.00	0.00	0.00	100.00	0.00	0.00	100.00
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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set by Elapsed Time

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

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
7,209	7,209	-0.00	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

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Only explicitly set parameters are included
Parameters values for the Begin Snapshot are shown only if they differ from those for the 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	End Snap Value
	1st Period		2nd Period
__db_cache_size		2432696320		2348810240
__java_pool_size		100663296
__large_pool_size		419430400
__oracle_base		/d01/oracle
__pga_aggregate_target		3221225472
__sga_target		8589934592
__shared_io_pool_size		536870912
__shared_pool_size		5033164800		5117050880
__streams_pool_size		16777216
audit_file_dest		/u01/app/oracle/admin/PROD/adump
audit_trail		DB
compatible		11.2.0.0.0
control_files		/u01/app/oracle/oradata/PROD
db_block_size		16384
db_cache_size		2147483648
db_domain
db_name		PROD
diagnostic_dest		/d01/oracle
dispatchers		(PROTOCOL=TCP) (SERVICE=PRODXD
large_pool_size		419430400
local_listener		LISTENER_PROD
log_archive_dest_1		LOCATION=/u01/app/oracle/arc
nls_length_semantics		BYTE
open_cursors		1000
pga_aggregate_target		3221225472
processes		1000
recyclebin		OFF
remote_login_passwordfile		EXCLUSIVE
sga_max_size		8589934592
sga_target		8589934592
shared_pool_size		1073741824
undo_tablespace		UNDOTBS1
utl_file_dir		/prod/logs

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

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

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

Back to init.ora Parameters
Back to Top

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