WORKLOAD REPOSITORY COMPARE PERIOD REPORT

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

First (1st) ORCL 1200893776 orcl 1 11.2.0.1.0 NO 11gR2Base 8192

Second (2nd) ORCL 1200893776 orcl 1 11.2.0.1.0 NO 11gR2Base 8192

Snapshot Set	DB Name	DB Id	Instance	Inst num	Release	Cluster	Host	Std Block Size
First (1st)	ORCL	1200893776	orcl	1	11.2.0.1.0	NO	11gR2Base	8192
Second (2nd)	ORCL	1200893776	orcl	1	11.2.0.1.0	NO	11gR2Base	8192

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

1st 2199 24-Nov-10 11:50:02 (Wed) 2200 24-Nov-10 12:12:32 (Wed) 41.43 22.49 931.72

2nd 2207 24-Nov-10 21:18:33 (Wed) 2208 24-Nov-10 21:56:44 (Wed) 14.08 38.19 537.81

%Diff -66.01 69.81 -42.28

Snapshot Set	Begin Snap Id	Begin Snap Time	End Snap Id	End Snap Time	Avg Active Users	Elapsed Time (min)	DB time (min)
1st	2199	24-Nov-10 11:50:02 (Wed)	2200	24-Nov-10 12:12:32 (Wed)	41.43	22.49	931.72
2nd	2207	24-Nov-10 21:18:33 (Wed)	2208	24-Nov-10 21:56:44 (Wed)	14.08	38.19	537.81
%Diff					-66.01	69.81	-42.28

Host Configuration Comparison

	1st	2nd	Diff	%Diff
Number of CPUs:	2	2	0	0.0
Physical Memory:	2011.4M	2011.4M	0M	0.0
Load at Start Snapshot:	.24	.11	-.13	-54.2
Load at End Snapshot:	23.79	3.55	-20.24	-85.1
%User Time:	13.3	12.02	-1.28	-9.6
%System Time:	32.72	19.26	-13.46	-41.1
%Idle Time:	51.48	67.48	16	31.1
%IO Wait Time:	40.78	59.54	18.76	46.0

Cache Sizes

	1st (M)	2nd (M)	Diff (M)	%Diff
Memory Target
.....SGA Target	752.0	752.0	0.0	0.0
..........Buffer Cache	424.0	396.0	-28.0	-6.6
..........Shared Pool	300.0	328.0	28.0	9.3
..........Large Pool	8.0	8.0	0.0	0.0
..........Java Pool	4.0	4.0	0.0	0.0
..........Streams Pool	4.0	4.0	0.0	0.0
.....PGA Target	152.0	152.0	0.0	0.0
Log Buffer	6.1	6.1	0.0	0.0

Load Profile

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

DB time: 41.43 14.08 -66.01 40.28 145.35 260.85

CPU time: 0.83 0.60 -27.71 0.81 6.16 660.49

Redo size: 6,904.49 1,642.76 -76.21 6,712.85 16,953.95 152.56

Logical reads: 24,587.05 7,758.12 -68.45 23,904.62 80,066.95 234.94

Block changes: 25.33 3.17 -87.49 24.63 32.74 32.93

Physical reads: 23,362.89 12,137.94 -48.05 22,714.44 125,268.41 451.49

Physical writes: 3.56 263.85 7,311.52 3.46 2,723.06 78,601.16

User calls: 155.07 159.99 3.17 150.77 1,651.13 995.13

Parses: 15.47 2.29 -85.20 15.04 23.68 57.45

Hard parses: 4.60 0.01 -99.78 4.47 0.14 -96.87

W/A MB processed: 441,961.12 1,253,416.72 183.60 429,694.16 12,935,763.03 183.60

Logons: 0.18 0.06 -66.67 0.17 0.67 294.12

Executes: 101.02 3.43 -96.60 98.22 35.42 -63.94

Transactions: 1.03 0.10 -90.29

1st 2nd Diff

% Blocks changed per Read: 0.10 0.04 -0.06

Recursive Call %: 42.32 12.66 -29.65

Rollback per transaction %: 4.18 0.00 -4.18

Rows per Sort: 10.76 13,676.49 13,665.73

Avg DB time per Call (sec): 0.27 0.09 -0.18

	1st per sec	2nd per sec	%Diff	1st per txn	2nd per txn	%Diff
DB time:	41.43	14.08	-66.01	40.28	145.35	260.85
CPU time:	0.83	0.60	-27.71	0.81	6.16	660.49
Redo size:	6,904.49	1,642.76	-76.21	6,712.85	16,953.95	152.56
Logical reads:	24,587.05	7,758.12	-68.45	23,904.62	80,066.95	234.94
Block changes:	25.33	3.17	-87.49	24.63	32.74	32.93
Physical reads:	23,362.89	12,137.94	-48.05	22,714.44	125,268.41	451.49
Physical writes:	3.56	263.85	7,311.52	3.46	2,723.06	78,601.16
User calls:	155.07	159.99	3.17	150.77	1,651.13	995.13
Parses:	15.47	2.29	-85.20	15.04	23.68	57.45
Hard parses:	4.60	0.01	-99.78	4.47	0.14	-96.87
W/A MB processed:	441,961.12	1,253,416.72	183.60	429,694.16	12,935,763.03	183.60
Logons:	0.18	0.06	-66.67	0.17	0.67	294.12
Executes:	101.02	3.43	-96.60	98.22	35.42	-63.94
Transactions:	1.03	0.10	-90.29

	1st	2nd	Diff
% Blocks changed per Read:	0.10	0.04	-0.06
Recursive Call %:	42.32	12.66	-29.65
Rollback per transaction %:	4.18	0.00	-4.18
Rows per Sort:	10.76	13,676.49	13,665.73
Avg DB time per Call (sec):	0.27	0.09	-0.18

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
direct path read	User I/O	248,075	46,558.63	187.68	83.28	direct path write temp	User I/O	86,267	17,789.98	206.22	55.13
db file sequential read	User I/O	17,061	4,255.26	249.41	7.61	direct path read	User I/O	139,714	6,874.70	49.21	21.30
db file parallel read	User I/O	481	1,435.91	2,985.26	2.57	direct path read temp	User I/O	1,530,266	6,208.49	4.06	19.24
CPU time			1,122.77		2.01	CPU time			1,366.87		4.24
enq: KO - fast object checkpoint	Application	666	899.74	1,350.96	1.61	db file parallel write	System I/O	750	17.39	23.18	0.05
-db file parallel write	System I/O	546	12.95	23.71	0.02	-db file sequential read	User I/O	346	4.53	13.10	0.01
-						-db file parallel read	User I/O	22	2.13	96.69	0.01

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	55,903.45	32,268.75	-42.28	40.28	145.35	260.85
DB CPU	2.01	4.24	2.23	1,122.77	1,366.87	21.74	0.81	6.16	660.49
parse time elapsed	1.32	0.04	-1.28	738.00	11.37	-98.46	0.53	0.05	-90.57
sql execute elapsed time	99.07	99.83	0.76	55,383.89	32,214.50	-41.83	39.90	145.11	263.68
hard parse elapsed time	0.42	0.01	-0.41	236.26	2.75	-98.84	0.17	0.01	-94.12
hard parse (sharing criteria) elapsed time	0.07	0.00	-0.07	37.33	0.00	-100.00	0.03	0.00	-100.00
PL/SQL compilation elapsed time	0.04	0.00	-0.04	25.05	0.00	-100.00	0.02	0.00	-100.00
hard parse (bind mismatch) elapsed time	0.01	0.00	-0.01	5.71	0.00	-100.00	0.00	0.00	0.00
PL/SQL execution elapsed time	0.07	0.07	-0.01	39.85	21.08	-47.10	0.03	0.09	200.00
connection management call elapsed time	0.00	0.01	0.00	1.66	1.94	16.87	0.00	0.01	100.00
repeated bind elapsed time	0.00	0.00	-0.00	0.04	0.00	-100.00	0.00	0.00	0.00
Java execution elapsed time	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
RMAN cpu time (backup/restore)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
failed parse (out of shared memory) elapsed time	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
failed parse 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
sequence load elapsed time	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
background elapsed time	1.08	0.24	-0.85	606.46	77.36	-87.24	0.44	0.35	-20.45
background cpu time	0.02	0.02	-0.00	13.26	6.80	-48.72	0.01	0.03	200.00

Operating System Statistics

Ordered by 'Statistic Name'

Statistic Name	1st	2nd	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Value (centi-seconds)		per Second (DB time)			per Second (Elapsed Time)			per Trans
BUSY_TIME	128,160	147,738	2.29	4.58	100.00	94.97	64.48	-32.10	92.33	665.49	620.77
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	135,970	306,590	2.43	9.50	290.95	100.76	133.82	32.81	97.96	1,381.04	1,309.80
IOWAIT_TIME	107,711	270,520	1.93	8.38	334.20	79.82	118.07	47.92	77.60	1,218.56	1,470.31
NICE_TIME	0	69	0.00	0.00	0.00	0.00	0.03	100.00	0.00	0.31	100.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	86,415	87,501	1.55	2.71	74.84	64.04	38.19	-40.37	62.26	394.15	533.07
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	35,141	54,621	0.63	1.69	168.25	26.04	23.84	-8.45	25.32	246.04	871.72

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)
Application	1.73	0.00	-1.73	0.85	0.00	-100.00	964.61	0.00	-100.00	839.52	0.00	-100.00
Concurrency	1.54	0.05	-1.49	1.92	0.07	-96.35	860.23	15.15	-98.24	332.13	94.10	-71.67
User I/O	94.51	95.72	1.21	200.39	766.95	282.73	52,834.31	30,888.56	-41.54	195.38	17.58	-91.00
System I/O	0.54	0.12	-0.43	6.19	2.96	-52.18	302.14	37.14	-87.71	36.15	5.48	-84.84
Other	0.28	0.02	-0.26	3.65	0.67	-81.64	158.70	7.31	-95.39	32.20	4.74	-85.28
Commit	0.04	0.01	-0.03	0.90	0.03	-96.67	24.07	4.48	-81.39	19.78	71.06	259.25
Configuration	0.00	0.00	-0.00	0.03	0.00	-100.00	2.25	0.00	-100.00	59.22	0.00	-100.00
Network	0.01	0.01	-0.00	154.99	159.76	3.08	2.88	1.65	-42.71	0.01	0.00	-100.00

Back to Wait Events
Back to Top

Wait Events

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

Event	Wait Class	1st	2nd	Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
		% of DB time			# Waits/sec (Elapsed Time)			Total Wait Time (sec)			Avg Wait Time (ms)
direct path read	User I/O	83.28	21.30	-61.98	183.83	60.98	-66.83	46,558.63	6,874.70	-85.23	187.68	49.21	-73.78
direct path write temp	User I/O	0.00	55.13	55.13	0.00	37.65	100.00	0.00	17,789.98	100.00	0.00	206.22	100.00
direct path read temp	User I/O	0.00	19.24	19.24	0.00	667.91	100.00	0.00	6,208.49	100.00	0.00	4.06	100.00
db file sequential read	User I/O	7.61	0.01	-7.60	12.64	0.15	-98.81	4,255.26	4.53	-99.89	249.41	13.10	-94.75
db file parallel read	User I/O	2.57	0.01	-2.56	0.36	0.01	-97.22	1,435.91	2.13	-99.85	2,985.26	96.69	-96.76
enq: KO - fast object checkpoint	Application	1.61	0.00	-1.61	0.49	0.00	-100.00	899.74	0.00	-100.00	1,350.96	0.00	-100.00
read by other session	User I/O	0.54	0.01	-0.53	1.16	0.02	-98.28	302.55	2.35	-99.22	194.07	52.16	-73.12
db file scattered read	User I/O	0.49	0.00	-0.49	1.06	0.00	-100.00	273.44	0.00	-100.00	191.22	0.00	-100.00
latch: shared pool	Concurrency	0.49	0.00	-0.48	1.21	0.01	-99.17	271.47	0.85	-99.69	166.85	32.70	-80.40
cursor: pin S wait on X	Concurrency	0.47	0.00	-0.47	0.14	0.00	-100.00	260.76	0.00	-100.00	1,379.67	0.00	-100.00
db file async I/O submit	System I/O	0.40	0.00	-0.40	0.62	0.00	-100.00	224.43	0.00	-100.00	268.77	0.00	-100.00
library cache: mutex X	Concurrency	0.22	0.00	-0.22	0.11	0.01	-90.91	124.49	0.59	-99.53	841.16	29.31	-96.52
os thread startup	Concurrency	0.19	0.04	-0.15	0.08	0.04	-50.00	106.92	13.01	-87.83	1,038.09	146.21	-85.92
enq: TX - row lock contention	Application	0.11	0.00	-0.11	0.02	0.00	-100.00	63.22	0.00	-100.00	2,341.66	0.00	-100.00
latch free	Other	0.09	0.00	-0.09	0.19	0.01	-94.74	51.79	0.08	-99.85	203.10	3.61	-98.22
cursor: pin S	Concurrency	0.07	0.00	-0.07	0.01	0.00	-100.00	38.75	0.00	-100.00	2,767.51	0.04	-100.00
enq: PR - contention	Other	0.05	0.00	-0.05	0.00	0.00	0.00	30.31	0.00	-100.00	7,578.24	0.00	-100.00
process diagnostic dump	Other	0.05	0.00	-0.05	0.00	0.00	0.00	30.24	0.00	-100.00	30,236.99	0.00	-100.00
library cache lock	Concurrency	0.05	0.00	-0.05	0.02	0.00	-100.00	27.67	0.00	-100.00	954.03	0.00	-100.00
db file parallel write	System I/O	0.02	0.05	0.03	0.40	0.33	-17.50	12.95	17.39	34.29	23.71	23.18	-2.24
log file sync	Commit	0.04	0.01	-0.03	0.90	0.03	-96.67	24.07	4.48	-81.39	19.78	71.06	259.25
log file parallel write	System I/O	0.05	0.03	-0.03	1.58	0.20	-87.34	30.29	9.09	-69.99	14.18	20.28	43.02
latch: cache buffers chains	Concurrency	0.02	0.00	-0.02	0.19	0.01	-94.74	13.07	0.70	-94.64	50.85	28.02	-44.90
buffer deadlock	Other	0.02	0.00	-0.02	0.00	0.00	0.00	11.76	0.00	-100.00	5,880.56	0.00	-100.00
flashback log file write	System I/O	0.03	0.00	-0.02	0.37	0.03	-91.89	14.15	1.53	-89.19	28.19	23.84	-15.43
flashback log file sync	User I/O	0.00	0.02	0.02	0.01	0.01	0.00	1.30	5.88	352.31	100.30	452.46	351.11
reliable message	Other	0.02	0.00	-0.02	0.51	0.00	-100.00	8.76	0.00	-100.00	12.76	0.00	-100.00
enq: TX - index contention	Concurrency	0.01	0.00	-0.01	0.02	0.00	-100.00	6.29	0.00	-100.00	273.47	0.00	-100.00
Disk file operations I/O	User I/O	0.01	0.00	-0.01	1.28	0.22	-82.81	6.30	0.40	-93.65	3.64	0.79	-78.30
latch: cache buffers lru chain	Other	0.01	0.00	-0.01	0.09	0.00	-100.00	4.88	0.00	-100.00	41.36	0.00	-100.00
control file sequential read	System I/O	0.02	0.01	-0.01	2.19	1.73	-21.00	11.77	4.10	-65.17	3.97	1.04	-73.80
buffer busy waits	Concurrency	0.01	0.00	-0.01	0.05	0.00	-100.00	3.44	0.00	-100.00	53.72	0.00	-100.00
PX Deq: Signal ACK RSG	Other	0.01	0.00	-0.01	0.03	0.00	-100.00	3.43	0.00	-100.00	81.76	0.00	-100.00
library cache load lock	Concurrency	0.01	0.00	-0.01	0.04	0.00	-100.00	3.25	0.00	-100.00	65.05	0.00	-100.00
latch: row cache objects	Concurrency	0.00	0.00	-0.00	0.04	0.00	-100.00	2.70	0.00	-100.00	45.84	0.00	-100.00
enq: HW - contention	Configuration	0.00	0.00	-0.00	0.03	0.00	-100.00	2.25	0.00	-100.00	59.22	0.00	-100.00
SQL*Net break/reset to client	Application	0.00	0.00	-0.00	0.34	0.00	-100.00	1.64	0.00	-100.00	3.61	0.00	-100.00
row cache lock	Concurrency	0.00	0.00	-0.00	0.02	0.00	-100.00	1.42	0.00	-100.00	52.48	0.00	-100.00
enq: CF - contention	Other	0.00	0.00	-0.00	0.00	0.00	0.00	1.02	0.00	-100.00	1,023.54	0.00	-100.00
enq: TX - contention	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.72	0.00	-100.00	55.19	0.00	-100.00
ASM file metadata operation	Other	0.02	0.02	-0.00	0.44	0.28	-36.36	12.45	6.79	-45.46	20.86	10.64	-48.99
Parameter File I/O	User I/O	0.00	0.00	-0.00	0.05	0.00	-100.00	0.63	0.00	-100.00	9.92	0.00	-100.00
PX Deq: Slave Session Stats	Other	0.00	0.00	-0.00	0.11	0.00	-100.00	0.51	0.00	-100.00	3.54	0.00	-100.00
latch: enqueue hash chains	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.47	0.00	-100.00	24.95	0.00	-100.00
asynch descriptor resize	Other	0.00	0.00	-0.00	2.06	0.37	-82.04	0.43	0.03	-93.02	0.15	0.03	-80.00
control file parallel write	System I/O	0.01	0.02	0.00	0.50	0.37	-26.00	8.10	4.89	-39.63	11.92	5.82	-51.17
SQL*Net message to client	Network	0.00	0.01	0.00	154.51	159.74	3.38	2.61	1.64	-37.16	0.01	0.00	-100.00
latch: parallel query alloc buffer	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.20	0.00	-100.00	15.21	0.00	-100.00
SQL*Net more data to client	Network	0.00	0.00	-0.00	0.35	0.01	-97.14	0.16	0.00	-100.00	0.34	0.12	-64.71
PX Deq: Signal ACK EXT	Other	0.00	0.00	-0.00	0.06	0.00	-100.00	0.16	0.00	-100.00	1.89	0.00	-100.00
kfk: async disk IO	System I/O	0.00	0.00	-0.00	0.50	0.30	-40.00	0.16	0.01	-93.75	0.24	0.01	-95.83
enq: FB - contention	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.15	0.00	-100.00	30.64	0.00	-100.00
LGWR wait for redo copy	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.15	0.00	-100.00	9.84	0.11	-98.88
enq: PS - contention	Other	0.00	0.00	-0.00	0.02	0.00	-100.00	0.11	0.00	-100.00	4.87	0.00	-100.00
latch: redo allocation	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.11	0.00	-100.00	27.65	0.00	-100.00
CSS initialization	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.79	0.40	-49.37	112.38	99.17	-11.75
SQL*Net more data from client	Network	0.00	0.00	-0.00	0.13	0.01	-92.31	0.11	0.01	-90.91	0.59	0.54	-8.47
direct path write	User I/O	0.00	0.00	-0.00	0.01	0.00	-100.00	0.28	0.11	-60.71	30.67	18.48	-39.75
latch: object queue header operation	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.09	0.01	-88.89	9.37	4.17	-55.50
enq: BF - allocation contention	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.07	0.00	-100.00	33.32	0.00	-100.00
flashback log file read	System I/O	0.00	0.00	-0.00	0.01	0.01	0.00	0.30	0.15	-50.00	16.52	7.69	-53.45
ADR block file read	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.03	0.00	-100.00	2.15	0.00	-100.00
PX qref latch	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.01	0.00	-100.00	2.13	0.00	-100.00
latch: call allocation	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.01	0.00	-100.00	1.61	0.00	-100.00
CSS operation: action	Other	0.00	0.00	0.00	0.01	0.00	-100.00	0.02	0.02	0.00	2.66	4.21	58.27
rdbms ipc reply	Other	0.00	0.00	-0.00	0.01	0.00	-100.00	0.01	0.00	-100.00	0.54	0.00	-100.00
PX Deq: Table Q qref	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	1.10	0.00	-100.00
ADR block file write	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.39	0.00	-100.00
CSS operation: query	Other	0.00	0.00	0.00	0.03	0.01	-66.67	0.01	0.01	0.00	0.18	0.23	27.78
ADR file lock	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.12	0.00	-100.00
latch: cache buffer handles	Other	0.00	0.00	-0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.03	0.00	-100.00
PX Idle Wait	Idle	10.92	0.00	-10.92	2.32	0.00	-100.00	6,105.10	0.00	-100.00	1,950.51	0.00	-100.00
DIAG idle wait	Idle	4.84	14.20	9.36	2.00	2.00	0.00	2,704.51	4,581.82	69.41	1,000.93	1,000.83	-0.01
jobq slave wait	Idle	2.41	7.48	5.06	2.00	2.10	5.00	1,349.83	2,412.41	78.72	500.86	500.71	-0.03
Streams AQ: qmn slave idle wait	Idle	2.40	7.12	4.71	0.04	0.04	0.00	1,343.47	2,296.38	70.93	27,417.82	27,337.85	-0.29
Streams AQ: qmn coordinator idle wait	Idle	2.40	7.12	4.71	0.07	0.07	0.00	1,344.19	2,296.38	70.84	14,001.99	14,002.34	0.00
ASM background timer	Idle	2.41	7.10	4.69	0.27	0.22	-18.52	1,349.48	2,292.14	69.85	3,667.06	4,503.22	22.80
Space Manager: slave idle wait	Idle	2.42	7.10	4.69	0.20	0.20	0.00	1,352.26	2,292.48	69.53	5,026.99	4,994.51	-0.65
wait for unread message on broadcast channel	Idle	2.42	7.10	4.68	1.00	1.00	0.00	1,353.25	2,291.96	69.37	1,000.92	1,000.86	-0.01
shared server idle wait	Idle	2.42	7.07	4.65	0.03	0.03	0.00	1,350.13	2,280.27	68.89	30,003.00	30,003.57	0.00
SQL*Net message from client	Idle	8.34	5.92	-2.43	154.51	159.75	3.39	4,664.12	1,909.51	-59.06	22.37	5.22	-76.67
PX Deq: Table Q Normal	Idle	2.08	0.00	-2.08	0.67	0.00	-100.00	1,162.98	0.00	-100.00	1,279.41	0.00	-100.00
PX Deq: Execute Reply	Idle	1.03	0.00	-1.03	0.61	0.00	-100.00	577.69	0.00	-100.00	698.53	0.00	-100.00
class slave wait	Idle	2.96	3.71	0.75	0.04	0.01	-75.00	1,653.03	1,195.87	-27.66	33,735.27	45,995.19	36.34
PX Deq: Execution Msg	Idle	0.23	0.00	-0.23	0.66	0.00	-100.00	128.40	0.00	-100.00	144.76	0.00	-100.00
PX Deq Credit: send blkd	Idle	0.02	0.00	-0.02	0.10	0.00	-100.00	10.10	0.00	-100.00	74.24	0.00	-100.00
PX Deq: Parse Reply	Idle	0.01	0.00	-0.01	0.05	0.00	-100.00	6.27	0.00	-100.00	90.91	0.00	-100.00
PX Deq: Join ACK	Idle	0.00	0.00	-0.00	0.06	0.00	-100.00	2.35	0.00	-100.00	30.49	0.00	-100.00
KSV master wait	Idle	0.02	0.02	0.00	0.03	0.01	-66.67	10.25	6.30	-38.54	232.85	314.89	35.23
SGA: MMAN sleep for component shrink	Idle	0.00	0.00	-0.00	0.01	0.00	-100.00	0.05	0.00	-100.00	6.79	0.00	-100.00
PX Deq: Table Q Sample	Idle	0.00	0.00	-0.00	0.00	0.00	0.00	0.01	0.00	-100.00	3.83	0.00	-100.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: 55,903.45 seconds, Second: 32,268.75 seconds
CPU Time First: 1,122.77 seconds, Second: 1,366.87 seconds
Physical Reads First: 31,527,638, Second: 27,809,588
Logical Reads First: 33,179,610, Second: 17,774,862

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	0.18	0.14	-0.04	1.36	0.97	-0.39	0.00	0.00	-0.00	0.09	0.18	0.10
orcl	99.82	99.86	0.04	98.62	99.02	0.40	100.00	100.00	0.00	99.87	99.74	-0.13
ADHOC	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
BATCH_LOW	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
BATCH_STD	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
DSS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
OLTP	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.00	-0.00	0.04	0.08	0.04
orclXDB	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Back to Service Statistics
Back to Top

Service Statistics (RAC)

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

Service Name	1st	2nd	Diff	1st	2nd	Diff	Total Diff
	% CR Blks Received			% Current Blks Received
ADHOC	0.00	0.00	0.00	0.00	0.00	0.00	0.00
BATCH_LOW	0.00	0.00	0.00	0.00	0.00	0.00	0.00
BATCH_STD	0.00	0.00	0.00	0.00	0.00	0.00	0.00
DSS	0.00	0.00	0.00	0.00	0.00	0.00	0.00
OLTP	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
orcl	0.00	0.00	0.00	0.00	0.00	0.00	0.00
orclXDB	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: 55,903.45 seconds, Second: 32,268.75 seconds
Captured SQL Elapsed Time First: 54,988.66 seconds, Second: 29,390.55 seconds
Captured SQL Elapsed Time as a % of DB time First: 98.36%, Second: 91.08%
Captured PL/SQL Elapsed Time as a % of DB time First: 73.27%, Second: .08%
Common SQL Elapsed Time as a % of DB time First: .1%, Second: .08%

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
72vydb3ncbn3s	71.09	71.09			-71.09	537,088		0.00		9,203		526,827		331,989.09		1.00		74			DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w	70.89	141.99			-70.89	535,567		0.00		9,190		526,798		331,989.09		0.00		74		1// 1	SELECT T_ID FROM E_TRADE WHERE...
95rzx549dbvs5			21.69	21.69	21.69		466,584		0.00		25,788		443,120		461,439.00		175.00		15	/ 1/ 1	SELECT NATION, O_YEAR, SUM(AMO...
bqjghjzaphzb2	13.42	155.41			-13.42	13,818		0.01		391		12,456		11,494.98		49.36		543		1// 1	SELECT T_CHRG, T_EXEC_NAME, EX...
1x255a7m968k7			12.49	34.18	12.49		268,618		0.00		9,483		262,445		237,854.13		4.00		15	/ 1/ 1	SELECT supp_nation, cust_natio...
bfk319z4wc782			5.08	39.26	5.08		409,879		0.00		9,885		403,842		270,200.00		5.00		4	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
1gkn6r4rbdkmy			5.02	44.28	5.02		405,253		0.00		9,957		399,255		270,478.25		5.00		4	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
fps40s3v7nd3r			4.44	48.72	4.44		95,447		0.00		4,692		93,133		134,596.00		2.00		15	/ 1/ 1	SELECT O_YEAR, SUM(DECODE(NATI...
2uzp6kw11g1su			3.88	52.59	3.88		416,871		0.00		10,030		410,881		269,115.00		5.00		3	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td			2.63	55.22	2.63		424,651		0.00		9,539		418,723		265,961.50		5.00		2	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
39pvzrsczv31x			2.58	57.80	2.58		415,764		0.00		9,889		409,760		269,678.50		5.00		2	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
agz7fu32m6qn4			2.42	60.22	2.42		390,476		0.00		8,333		386,016		161,508.00		36,811.00		2	/ 1/ 1	SELECT c_custkey, c_name, SUM(...
afy3mzh484trw			2.29	62.51	2.29		369,920		0.00		9,654		361,348		235,011.00		11,382.00		2	/ 1/ 1	SELECT l_orderkey, SUM(l_exten...
2vcn91b1wtmc6	1.52	156.93			-1.52	5,893		0.00		11		5,887		19.04		23.51		144		1// 1	SELECT TH_DTS, TH_ST_ID FROM E...
318ng5h3q5x79	1.43	158.35			-1.43	22,144		0.00		320		19,171		11,654.47		19.44		36		1// 1	Select T_BID_PRICE, T_EXEC_NAM...
8h5jmzqcfpgzb	1.38	159.74			-1.38	11,041		0.00		26		11,006		38.17		18.34		70		1// 1	SELECT CT_AMT, CT_NAME, CT_DTS...
309b84z4mv9jb	1.34	161.08			-1.34	5,201		0.00		12		5,193		19.71		9.72		144		1// 1	SELECT SE_CASH_TYPE, SE_CASH_D...
84nxzpqwn91j5	1.33	162.40			-1.33	325		0.04		1		322		1.29		2.38		2,280		1// 1	Select to_char(TH_DTS, 'mm/dd/...
15p4z9yvdc8ua	1.22	163.62			-1.22	9,735		0.00		32		9,656		50.21		20.00		70		1// 1	SELECT T_EXEC_NAME, T_BID_PRIC...
g4gkdzc5fb01z	1.03	164.65			-1.03	268		0.04		1		264		1.25		0.97		2,141		1// 1	Select CT_AMT, to_char(CT_DTS,...

Back to SQL Statistics
Back to Top

Top SQL Comparison by CPU Time

Ordered by absolute value of the 'Diff' column of 'CPU % of DB CPU' descending
'#Plans' column indicates the number of distinct execution plans for the statement in 1st and 2nd periods and in Both periods combined
'1st Total' and '2nd Total' show respective running totals for '1st' and '2nd' columns of 'CPU Time % of DB CPU'
Total CPU Time First: 1,122.77 seconds, Second: 1,366.87 seconds
Captured SQL CPU Time First: 1,002.88 seconds, Second: 1,142.84 seconds
Captured SQL as a % of Total CPU First: 89.32%, Second: 83.61%
Captured PL/SQL as a % of Total CPU First: 62.32%, Second: .33%
Common SQL as a % of Total CPU First: .6%, Second: .35%

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
72vydb3ncbn3s	60.66	60.66			-60.66	9,203		526,827		0.00		537,088		331,989.09		1.00			DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w	60.57	121.23			-60.57	9,190		526,798		0.00		535,567		331,989.09		0.00		1// 1	SELECT T_ID FROM E_TRADE WHERE...
95rzx549dbvs5			28.30	28.30	28.30		25,788		443,120		0.00		466,584		461,439.00		175.00	/ 1/ 1	SELECT NATION, O_YEAR, SUM(AMO...
bqjghjzaphzb2	18.91	140.14			-18.91	391		12,456		0.01		13,818		11,494.98		49.36		1// 1	SELECT T_CHRG, T_EXEC_NAME, EX...
1x255a7m968k7			10.41	38.71	10.41		9,483		262,445		0.00		268,618		237,854.13		4.00	/ 1/ 1	SELECT supp_nation, cust_natio...
fps40s3v7nd3r			5.15	43.86	5.15		4,692		93,133		0.00		95,447		134,596.00		2.00	/ 1/ 1	SELECT O_YEAR, SUM(DECODE(NATI...
48ay2b94rz41x	4.00	144.14			-4.00	109		727		0.01		1,020		195.33		12.58		1// 1	SELECT DM_DATE, DM_CLOSE, DM_H...
1gkn6r4rbdkmy			2.91	46.77	2.91		9,957		399,255		0.00		405,253		270,478.25		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
bfk319z4wc782			2.89	49.66	2.89		9,885		403,842		0.00		409,879		270,200.00		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
2uzp6kw11g1su			2.20	51.86	2.20		10,030		410,881		0.00		416,871		269,115.00		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
9xcdxpqrhsvmx			1.46	53.32	1.46		9,977		51,505		0.00		77,139		108,845.00		4.00	/ 1/ 1	SELECT l_returnflag, l_linesta...
39pvzrsczv31x			1.45	54.77	1.45		9,889		409,760		0.00		415,764		269,678.50		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
afy3mzh484trw			1.41	56.18	1.41		9,654		361,348		0.00		369,920		235,011.00		11,382.00	/ 1/ 1	SELECT l_orderkey, SUM(l_exten...
c0chxpnujy8td			1.40	57.58	1.40		9,539		418,723		0.00		424,651		265,961.50		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
318ng5h3q5x79	1.02	145.17			-1.02	320		19,171		0.00		22,144		11,654.47		19.44		1// 1	Select T_BID_PRICE, T_EXEC_NAM...
8v93w0n1dm76k	0.72	145.88			-0.72	0		6		0.56		6		0.21		1.00		1// 1	SELECT DM_CLOSE FROM E_DAILY_M...
7rq305gd2gpzw	0.37	146.26			-0.37	0		0		0.56		0		0.00		1.00		1// 1	SELECT S_NUM_OUT FROM E_SECURI...
4j9awnaff2xjr	0.37	146.63			-0.37	0		0		0.56		0		0.00		1.00		1// 1	SELECT LT_PRICE FROM E_LAST_TR...
5pnb5ryzbx5xx	0.37	147.00			-0.37	52		1,422		0.00		3,142		1,324.93		23.96		1// 1	SELECT TH_DTS, T_QTY, T_S_SYMB...
6gvch1xu9ca3g	0.54	147.54	0.31	57.89	-0.23	290	113	496	8	0.00	0.00	2,512	632	34.86	0.34	1.00	1.00		DECLARE job BINARY_INTEGER := ...

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: 94.51%, Second: 95.72%
Total User I/O Time First: 52,834.31 seconds, Second: 30,888.56 seconds
Captured SQL I/O Time First: 52,625.08 seconds, Second: 28,217.89 seconds
Captured SQL as a % of Total User I/O First: 99.6%, Second: 91.35%
Captured PL/SQL as a % of Total User I/O First: 74.43%, Second: 0%
Common SQL as a % of Total User I/O First: 0%, Second: 0%

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
72vydb3ncbn3s	69.74	69.74			-69.74	526,827		537,088		0.00		9,203		331,989.09		1.00		74			DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w	69.73	139.47			-69.73	526,798		535,567		0.00		9,190		331,989.09		0.00		74		1// 1	SELECT T_ID FROM E_TRADE WHERE...
95rzx549dbvs5			20.60	20.60	20.60		443,120		466,584		0.00		25,788		461,439.00		175.00		15	/ 1/ 1	SELECT NATION, O_YEAR, SUM(AMO...
1x255a7m968k7			12.20	32.80	12.20		262,445		268,618		0.00		9,483		237,854.13		4.00		15	/ 1/ 1	SELECT supp_nation, cust_natio...
bqjghjzaphzb2	12.10	151.57			-12.10	12,456		13,818		0.01		391		11,494.98		49.36		543		1// 1	SELECT T_CHRG, T_EXEC_NAME, EX...
bfk319z4wc782			5.01	37.80	5.01		403,842		409,879		0.00		9,885		270,200.00		5.00		4	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
1gkn6r4rbdkmy			4.95	42.75	4.95		399,255		405,253		0.00		9,957		270,478.25		5.00		4	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
fps40s3v7nd3r			4.33	47.08	4.33		93,133		95,447		0.00		4,692		134,596.00		2.00		15	/ 1/ 1	SELECT O_YEAR, SUM(DECODE(NATI...
2uzp6kw11g1su			3.82	50.90	3.82		410,881		416,871		0.00		10,030		269,115.00		5.00		3	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td			2.60	53.50	2.60		418,723		424,651		0.00		9,539		265,961.50		5.00		2	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
39pvzrsczv31x			2.54	56.04	2.54		409,760		415,764		0.00		9,889		269,678.50		5.00		2	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
agz7fu32m6qn4			2.39	58.43	2.39		386,016		390,476		0.00		8,333		161,508.00		36,811.00		2	/ 1/ 1	SELECT c_custkey, c_name, SUM(...
afy3mzh484trw			2.24	60.67	2.24		361,348		369,920		0.00		9,654		235,011.00		11,382.00		2	/ 1/ 1	SELECT l_orderkey, SUM(l_exten...
2vcn91b1wtmc6	1.52	153.08			-1.52	5,887		5,893		0.00		11		19.04		23.51		144		1// 1	SELECT TH_DTS, TH_ST_ID FROM E...
8h5jmzqcfpgzb	1.38	154.46			-1.38	11,006		11,041		0.00		26		38.17		18.34		70		1// 1	SELECT CT_AMT, CT_NAME, CT_DTS...
309b84z4mv9jb	1.34	155.80			-1.34	5,193		5,201		0.00		12		19.71		9.72		144		1// 1	SELECT SE_CASH_TYPE, SE_CASH_D...
84nxzpqwn91j5	1.31	157.11			-1.31	322		325		0.04		1		1.29		2.38		2,280		1// 1	Select to_char(TH_DTS, 'mm/dd/...
318ng5h3q5x79	1.23	158.35			-1.23	19,171		22,144		0.00		320		11,654.47		19.44		36		1// 1	Select T_BID_PRICE, T_EXEC_NAM...
15p4z9yvdc8ua	1.21	159.56			-1.21	9,656		9,735		0.00		32		50.21		20.00		70		1// 1	SELECT T_EXEC_NAME, T_BID_PRIC...
g4gkdzc5fb01z	1.01	160.57			-1.01	264		268		0.04		1		1.25		0.97		2,141		1// 1	Select CT_AMT, to_char(CT_DTS,...

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: 33,179,610, Second: 17,774,862
Captured SQL Buffer Gets First: 33,057,700, Second: 13,770,661
Captured SQL % of Total Buffer Gets First: 99.63%, Second: 77.47%
Common SQL % of Total Buffer Gets First: .02%, Second: .06%

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
72vydb3ncbn3s	74.11	74.11			-74.11	332,292.01		74		537,088		9,203		526,827		331,989.09		1.00			DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w	74.11	148.22			-74.11	332,282.86		74		535,567		9,190		526,798		331,989.09		0.00		1// 1	SELECT T_ID FROM E_TRADE WHERE...
bqjghjzaphzb2	18.73	166.95			-18.73	11,446.52		543		13,818		391		12,456		11,494.98		49.36		1// 1	SELECT T_CHRG, T_EXEC_NAME, EX...
95rzx549dbvs5			12.20	12.20	12.20		144,575.00		15		466,584		25,788		443,120		461,439.00		175.00	/ 1/ 1	SELECT NATION, O_YEAR, SUM(AMO...
fps40s3v7nd3r			11.75	23.95	11.75		139,259.00		15		95,447		4,692		93,133		134,596.00		2.00	/ 1/ 1	SELECT O_YEAR, SUM(DECODE(NATI...
1x255a7m968k7			11.43	35.39	11.43		135,480.00		15		268,618		9,483		262,445		237,854.13		4.00	/ 1/ 1	SELECT supp_nation, cust_natio...
48ay2b94rz41x	3.40	170.36			-3.40	2,734.15		413		1,020		109		727		195.33		12.58		1// 1	SELECT DM_DATE, DM_CLOSE, DM_H...
1gkn6r4rbdkmy			3.05	38.43	3.05		135,473.00		4		405,253		9,957		399,255		270,478.25		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
bfk319z4wc782			3.05	41.48	3.05		135,473.00		4		409,879		9,885		403,842		270,200.00		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
2uzp6kw11g1su			2.29	43.77	2.29		135,473.00		3		416,871		10,030		410,881		269,115.00		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
agz7fu32m6qn4			1.53	45.29	1.53		135,573.00		2		390,476		8,333		386,016		161,508.00		36,811.00	/ 1/ 1	SELECT c_custkey, c_name, SUM(...
39pvzrsczv31x			1.52	46.82	1.52		135,473.00		2		415,764		9,889		409,760		269,678.50		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td			1.52	48.34	1.52		135,473.00		2		424,651		9,539		418,723		265,961.50		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
c71khx643vgxb			1.52	49.87	1.52		135,313.00		2		289,804		7,029		285,668		158,850.00		36,762.00	/ 1/ 1	SELECT c_custkey, c_name, SUM(...
318ng5h3q5x79	1.25	171.60			-1.25	11,518.36		36		22,144		320		19,171		11,654.47		19.44		1// 1	Select T_BID_PRICE, T_EXEC_NAM...
8v93w0n1dm76k	0.38	171.98			-0.38	4.00		31,342		6		0		6		0.21		1.00		1// 1	SELECT DM_CLOSE FROM E_DAILY_M...
5pnb5ryzbx5xx	0.29	172.28			-0.29	1,221.20		80		3,142		52		1,422		1,324.93		23.96		1// 1	SELECT TH_DTS, T_QTY, T_S_SYMB...
4j9awnaff2xjr	0.28	172.56			-0.28	3.00		31,342		0		0		0		0.00		1.00		1// 1	SELECT LT_PRICE FROM E_LAST_TR...
7rq305gd2gpzw	0.28	172.84			-0.28	3.00		31,342		0		0		0		0.00		1.00		1// 1	SELECT S_NUM_OUT FROM E_SECURI...
fjpgrrp53dtxj	0.15	173.00			-0.15	359.02		141		71		6		2		0.01		1.83		1// 1	SELECT B_NAME, NVL(SUM(TR_QTY...

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
58h9dvw8qzy7w	77.92	77.92			-77.92	331,989.09		74		535,567		9,190		526,798		0.00		1// 1	SELECT T_ID FROM E_TRADE WHERE...
72vydb3ncbn3s	77.92	155.85			-77.92	331,989.09		74		537,088		9,203		526,827		1.00			DECLARE trades E_TradeList; BE...
95rzx549dbvs5			24.89	24.89	24.89		461,439.00		15		466,584		25,788		443,120		175.00	/ 1/ 1	SELECT NATION, O_YEAR, SUM(AMO...
bqjghjzaphzb2	19.80	175.64			-19.80	11,494.98		543		13,818		391		12,456		49.36		1// 1	SELECT T_CHRG, T_EXEC_NAME, EX...
1x255a7m968k7			12.83	37.72	12.83		237,854.13		15		268,618		9,483		262,445		4.00	/ 1/ 1	SELECT supp_nation, cust_natio...
fps40s3v7nd3r			7.26	44.98	7.26		134,596.00		15		95,447		4,692		93,133		2.00	/ 1/ 1	SELECT O_YEAR, SUM(DECODE(NATI...
1gkn6r4rbdkmy			3.89	48.87	3.89		270,478.25		4		405,253		9,957		399,255		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
bfk319z4wc782			3.89	52.76	3.89		270,200.00		4		409,879		9,885		403,842		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
2uzp6kw11g1su			2.90	55.66	2.90		269,115.00		3		416,871		10,030		410,881		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
39pvzrsczv31x			1.94	57.60	1.94		269,678.50		2		415,764		9,889		409,760		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td			1.91	59.51	1.91		265,961.50		2		424,651		9,539		418,723		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
afy3mzh484trw			1.69	61.20	1.69		235,011.00		2		369,920		9,654		361,348		11,382.00	/ 1/ 1	SELECT l_orderkey, SUM(l_exten...
318ng5h3q5x79	1.33	176.97			-1.33	11,654.47		36		22,144		320		19,171		19.44		1// 1	Select T_BID_PRICE, T_EXEC_NAM...
agz7fu32m6qn4			1.16	62.36	1.16		161,508.00		2		390,476		8,333		386,016		36,811.00	/ 1/ 1	SELECT c_custkey, c_name, SUM(...
5pnb5ryzbx5xx	0.34	177.31			-0.34	1,324.93		80		3,142		52		1,422		23.96		1// 1	SELECT TH_DTS, T_QTY, T_S_SYMB...
48ay2b94rz41x	0.26	177.57			-0.26	195.33		413		1,020		109		727		12.58		1// 1	SELECT DM_DATE, DM_CLOSE, DM_H...
5jctjh9wmayy6	0.11	177.67			-0.11	346.56		98		2,568		19		442		1.00		1// 1	SELECT T_ID FROM E_TRADE WHERE...
83vnfyd1m59nq	0.11	177.78			-0.11	347.42		97		2,390		20		242		1.00			DECLARE tradeid INT; BEGIN SEL...
6h7xku2zvpgsh	0.06	177.84			-0.06	463.53		40		2,406		29		540		20.00		1// 1	Select T_CA_ID, T_EXEC_NAME, D...
7vnf1z0t36s99	0.04	177.88			-0.04	59.39		194		94		5		81		0.00		1// 1	SELECT C_ID FROM E_CUSTOMER WH...

	% 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
72vydb3ncbn3s	70.91	70.91			-70.91	2,600.09		192,407		0.00		74		537,088		9,203		526,827		1.00			DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w	70.91	141.83			-70.91	2,600.01		192,401		0.00		74		535,567		9,190		526,798		0.00		1// 1	SELECT T_ID FROM E_TRADE WHERE...
bqjghjzaphzb2	15.44	157.27			-15.44	77.16		41,899		0.00		543		13,818		391		12,456		49.36		1// 1	SELECT T_CHRG, T_EXEC_NAME, EX...
1x255a7m968k7			14.51	14.51	14.51		16,157.07		242,356		0.00		15		268,618		9,483		262,445		4.00	/ 1/ 1	SELECT supp_nation, cust_natio...
1gkn6r4rbdkmy			4.99	19.50	4.99		20,823.75		83,295		0.00		4		405,253		9,957		399,255		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
bfk319z4wc782			4.98	24.47	4.98		20,784.00		83,136		0.00		4		409,879		9,885		403,842		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
2uzp6kw11g1su			3.71	28.18	3.71		20,629.00		61,887		0.00		3		416,871		10,030		410,881		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
39pvzrsczv31x			2.48	30.66	2.48		20,709.50		41,419		0.00		2		415,764		9,889		409,760		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td			2.42	33.07	2.42		20,178.50		40,357		0.00		2		424,651		9,539		418,723		5.00	/ 1/ 1	SELECT n_name, SUM(l_extendedp...
fps40s3v7nd3r			1.27	34.34	1.27		1,412.00		21,180		0.00		15		95,447		4,692		93,133		2.00	/ 1/ 1	SELECT O_YEAR, SUM(DECODE(NATI...
318ng5h3q5x79	1.13	158.40			-1.13	85.33		3,072		0.00		36		22,144		320		19,171		19.44		1// 1	Select T_BID_PRICE, T_EXEC_NAM...
agz7fu32m6qn4			0.94	35.28	0.94		7,831.00		15,662		0.00		2		390,476		8,333		386,016		36,811.00	/ 1/ 1	SELECT c_custkey, c_name, SUM(...
48ay2b94rz41x	0.66	159.06			-0.66	4.31		1,781		0.00		413		1,020		109		727		12.58		1// 1	SELECT DM_DATE, DM_CLOSE, DM_H...
5pnb5ryzbx5xx	0.52	159.58			-0.52	17.75		1,420		0.00		80		3,142		52		1,422		23.96		1// 1	SELECT TH_DTS, T_QTY, T_S_SYMB...
5jctjh9wmayy6	0.10	159.69			-0.10	2.90		284		0.00		98		2,568		19		442		1.00		1// 1	SELECT T_ID FROM E_TRADE WHERE...
83vnfyd1m59nq	0.10	159.79			-0.10	2.77		269		0.00		97		2,390		20		242		1.00			DECLARE tradeid INT; BEGIN SEL...
7vnf1z0t36s99	0.07	159.86			-0.07	0.99		193		0.00		194		94		5		81		0.00		1// 1	SELECT C_ID FROM E_CUSTOMER WH...
6h7xku2zvpgsh	0.07	159.92			-0.07	4.58		183		0.00		40		2,406		29		540		20.00		1// 1	Select T_CA_ID, T_EXEC_NAME, D...
95rzx549dbvs5			0.00	35.28	0.00		0.00		0				15		466,584		25,788		443,120		175.00	/ 1/ 1	SELECT NATION, O_YEAR, SUM(AMO...
afy3mzh484trw			0.00	35.28	0.00		0.00		0				2		369,920		9,654		361,348		11,382.00	/ 1/ 1	SELECT l_orderkey, SUM(l_exten...

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: 114,253, Second: 4,490
Captured SQL Elapsed Time First: 54,988.66 seconds, Second: 29,390.55 seconds
Captured SQL Elapsed Time as a % of DB time First: 98.36%, Second: 91.08%
Captured SQL Executions as a % of Total Executions First: 83.81%, Second: 57.1%
Common SQL Executions as a % of Total Executions First: 1.57%, Second: 39.19%

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
4j9awnaff2xjr	0.56		-0.56	31,342		0		0		0		0.00		1.00		1// 1	SELECT LT_PRICE FROM E_LAST_TR...
7rq305gd2gpzw	0.56		-0.56	31,342		0		0		0		0.00		1.00		1// 1	SELECT S_NUM_OUT FROM E_SECURI...
8v93w0n1dm76k	0.56		-0.56	31,342		6		0		6		0.21		1.00		1// 1	SELECT DM_CLOSE FROM E_DAILY_M...
cm5vu20fhtnq1	0.02	0.07	0.04	1,274	2,157	1	0	0	0	0	0	0.00	0.00	2.81	2.90	1/ 1/ 1	select /*+ connect_by_filterin...
7yphsb8fr4vus	0.04		-0.04	2,280		235		1		233		0.97		1.00		1// 1	Select SE_AMT, to_char(SE_CASH...
84nxzpqwn91j5	0.04		-0.04	2,280		325		1		322		1.29		2.38		1// 1	Select to_char(TH_DTS, 'mm/dd/...
g4gkdzc5fb01z	0.04		-0.04	2,141		268		1		264		1.25		0.97		1// 1	Select CT_AMT, to_char(CT_DTS,...
3904n1ntv7txj	0.01		-0.01	780		371		1		330		1.24		1.00		1// 1	Select T_BID_PRICE, T_EXEC_NAM...
6dafh4gs0k2jc	0.01		-0.01	780		317		1		268		1.15		1.00			Declare ex_name Varchar2(65); ...
3c1kubcdjnppq	0.01		-0.01	559		1		0		1		0.01		0.64		1// 1	update sys.col_usage$ set equa...
089dbukv1aanh		0.01	0.01		232		0		0		0		0.00		1.00	/ 1/ 1	SELECT SYS_EXTRACT_UTC(SYSTIME...
8vwv6hx92ymmm		0.01	0.01		162		3		0		0		0.02		1.00	/ 1/ 1	UPDATE MGMT_CURRENT_METRICS SE...
6xvp6nxs4a9n4	0.00	0.01	0.00	164	249	2	1	0	0	0	0	0.00	0.00	1.00	1.00	1/ 1/ 1	select nvl(sum(space), 0) from...
csnp95dz2r8ss	0.00	0.01	0.00	164	249	0	0	0	0	0	0	0.00	0.00	0.00	0.00	1/ 1/ 1	select file#, block# from recy...
fsbqktj5vw6n9		0.00	0.00		124		1		1		0		0.00		1.00	/ 1/ 1	select next_run_date, obj#, ru...
18naypzfmabd6		0.00	0.00		81		11		2		1		0.05		1.00		INSERT INTO MGMT_SYSTEM_PERFOR...
08bqjmf8490s2	0.00	0.00	0.00	73	115	1	1	0	0	0	0	0.00	0.00	0.63	0.66	1/ 1/ 1	SELECT PARAMETER_VALUE FROM MG...
350f5yrnnmshs	0.00	0.00	0.00	139	108	0	0	0	0	0	0	0.00	0.00	0.00	0.00		lock table sys.mon_mods$ in ex...
g00cj285jmgsw	0.00	0.00	0.00	139	108	3	1	0	1	2	0	0.01	0.00	0.91	1.00	1/ 1/ 1	update sys.mon_mods$ set inser...

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: 1.32%, Second: .04%
Total Parses First: 20,873, Second: 5,257
Captured SQL Parses First: 10,006, Second: 4,099
Captured SQL Parses % of Total Parses First: 47.94%, Second: 77.97%
Common SQL Parses % of Total Parses First: 10.21%, Second: 58.63%

SQL Id	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	1st/2nd/Both	SQL Text
	% Total Parses					Parses		#Executions		#Plans
cm5vu20fhtnq1	6.10	6.10	41.03	41.03	34.93	1,274	2,157	1,274	2,157	1/ 1/ 1	select /*+ connect_by_filterin...
6xvp6nxs4a9n4	0.79	6.89	4.74	45.77	3.95	164	249	164	249	1/ 1/ 1	select nvl(sum(space), 0) from...
csnp95dz2r8ss	0.79	7.67	4.74	50.50	3.95	164	249	164	249	1/ 1/ 1	select file#, block# from recy...
bqjghjzaphzb2	2.66	10.33			-2.66	555		543		1// 1	SELECT T_CHRG, T_EXEC_NAME, EX...
9ba2vwvw6z4z8	2.60	12.94			-2.60	543		543		1// 1	SELECT C_L_NAME, C_F_NAME, B_N...
fsbqktj5vw6n9			2.36	52.86	2.36		124		124	/ 1/ 1	select next_run_date, obj#, ru...
48ay2b94rz41x	1.99	14.92			-1.99	415		413		1// 1	SELECT DM_DATE, DM_CLOSE, DM_H...
2mw82wp65dyv5	1.98	16.90			-1.98	413		413		1// 1	SELECT S_NAME, CO_ID, CO_NAME,...
37h9f39wxj92r	1.98	18.88			-1.98	413		413		1// 1	SELECT NI_HEADLINE, NI_SUMMARY...
9wfnvt8hnx49f	1.98	20.86			-1.98	413		413		1// 1	SELECT CO_NAME, IN_NAME FROM E...
dbf6bmt9at48f	1.98	22.84			-1.98	413		413		1// 1	SELECT FI_YEAR, FI_QTR, FI_QTR...
gzjm68u0xahd4	1.98	24.82			-1.98	413		413		1// 1	SELECT LT_PRICE, LT_OPEN_PRICE...
08bqjmf8490s2	0.34	25.15	2.19	55.05	1.85	70	115	73	115	1/ 1/ 1	SELECT PARAMETER_VALUE FROM MG...
6w6tz0ppcxb7u	1.54	26.69			-1.54	321		321		1// 1	SELECT WI_S_SYMB FROM E_WATCH_...
089dbukv1aanh			1.45	56.50	1.45		76		232	/ 1/ 1	SELECT SYS_EXTRACT_UTC(SYSTIME...
c8h3jdwaa532q			1.45	57.94	1.45		76		76	/ 1/ 1	SELECT TO_NUMBER(PARAMETER_VAL...
350f5yrnnmshs	0.67	27.36	2.05	60.00	1.39	139	108	139	108		lock table sys.mon_mods$ in ex...
g00cj285jmgsw	0.67	28.02	2.05	62.05	1.39	139	108	139	108	1/ 1/ 1	update sys.mon_mods$ set inser...
0k8522rmdzg4k			1.08	63.13	1.08		57		57	/ 1/ 1	select privilege# from sysauth...

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: 314,572,800, Second: 343,932,928

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
gjm43un5cy843			0.22	0.22	0.22		769,086		769,086		1	SELECT SUM(USED), SUM(TOTAL) F...
d8mayxqw0wnpv			0.10	0.33	0.10		351,762		351,762		4	SELECT OWNER FROM DBA_PROCEDUR...
gcph0kd36arc6	0.10	0.10			-0.10	308,011		308,011		1		SELECT /+ ORDERED PUSH_SUBQ ...
6wm3n4d7bnddg			0.09	0.42	0.09		318,578		318,578		1	SELECT source, (case when tim...
ab3swhv5g138y	0.09	0.19			-0.09	283,194		283,194		1		select OBJOID, CLSOID, RUNTIME...
25fu98m3hw2ts			0.08	0.50	0.08		272,688		272,688		2	SELECT VALUE FROM MGMT_CURRENT...
fdjtrdaz8hpvg	0.07	0.25			-0.07	209,408		209,408		6		INSERT /*+ APPEND LEADING(@"SE...
7ng34ruy5awxq	0.05	0.30			-0.05	152,138		152,138		182		select i.obj#, i.ts#, i.file#,...
bn4b3vjw2mj3u			0.05	0.55	0.05		163,792		163,792		20	SELECT OBJOID, CLSOID, DECODE(...
4jrfrtx4u6zcx			0.04	0.59	0.04		143,744		143,744		39	SELECT TASK_TGT.TARGET_GUID TA...
bqjghjzaphzb2	0.04	0.34			-0.04	116,729		116,729		543		SELECT T_CHRG, T_EXEC_NAME, EX...
8vwv6hx92ymmm			0.04	0.62	0.04		121,448		121,448		162	UPDATE MGMT_CURRENT_METRICS SE...
9tgj4g8y4rwy8	0.03	0.37			-0.03	105,259		105,259		147		select type#, blocks, extents,...
1gu8t96d0bdmu	0.03	0.41			-0.03	104,076		104,076		107		select t.ts#, t.file#, t.block...
1fwcc9b0mbzum			0.03	0.66	0.03		113,568		113,568		1	SELECT l_orderkey, SUM(l_exten...
4ttpsft97zujk			0.03	0.69	0.03		113,568		113,568		1	SELECT l_orderkey, SUM(l_exten...
6uusdb8z8usyu			0.03	0.72	0.03		113,568		113,568		1	SELECT l_orderkey, SUM(l_exten...
fjpgrrp53dtxj	0.03	0.44			-0.03	96,910		96,910		141		SELECT B_NAME, NVL(SUM(TR_QTY...
3ktacv9r56b51	0.03	0.47			-0.03	93,074		93,074		54		select owner#, name, namespace...
6qz82dptj0qr7	0.02	0.49			-0.02	76,440		76,440		22		select l.col#, l.intcol#, l.lo...

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
7ng34ruy5awxq	12		-12	12		182		select i.obj#, i.ts#, i.file#,...
1gu8t96d0bdmu	8		-8	8		107		select t.ts#, t.file#, t.block...
39m4sx9k63ba2	8		-8	8		107		select /*+ index(idl_ub2$ i_id...
c6awqs517jpj0	8		-8	8		107		select /*+ index(idl_char$ i_i...
cvn54b7yz0s8u	8		-8	8		107		select /*+ index(idl_ub1$ i_id...
ga9j9xk5cy9s0	8		-8	8		107		select /*+ index(idl_sb4$ i_id...
25fu98m3hw2ts		6	6		6		2	SELECT VALUE FROM MGMT_CURRENT...
gjm43un5cy843		6	6		6		1	SELECT SUM(USED), SUM(TOTAL) F...
gx4mv66pvj3xz	6		-6	6		192		select con#, type#, condlength...
18naypzfmabd6		4	4		4		81	INSERT INTO MGMT_SYSTEM_PERFOR...
1fwcc9b0mbzum		4	4		4		1	SELECT l_orderkey, SUM(l_exten...
3ktacv9r56b51	4		-4	4		54		select owner#, name, namespace...
45cngnmv709m4	4		-4	4		1		select subscriber_id, name, ad...
4ttpsft97zujk		4	4		4		1	SELECT l_orderkey, SUM(l_exten...
5n1fs4m2n2y0r	4		-4	4		254		select pos#, intcol#, col#, sp...
6ajkhukk78nsr		4	4		4		1	begin prvt_hdm.auto_execute( :...
6uusdb8z8usyu		4	4		4		1	SELECT l_orderkey, SUM(l_exten...
8vwv6hx92ymmm		4	4		4		162	UPDATE MGMT_CURRENT_METRICS SE...
59ahdunmw6xbz		3	3		3		1	SELECT l_orderkey, SUM(l_exten...
08bqjmf8490s2	3	3	0	3	3	73	115	SELECT PARAMETER_VALUE FROM MG...

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: 55,903.45 seconds, Second: 32,268.75 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
07yqdn45g0uwp			0.00	0.00	0.00		0.00		0.00		1	/ 1/ 1	SELECT l_returnflag, l_linesta...
089dbukv1aanh			0.00	0.00	0.00		0.00		0.00		232	/ 1/ 1	SELECT SYS_EXTRACT_UTC(SYSTIME...
08bqjmf8490s2	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	73	115	1/ 1/ 1	SELECT PARAMETER_VALUE FROM MG...
08vznc16ycuag			0.00	0.00	0.00		0.00		0.00		38	/ 1/ 1	SELECT SYS_GUID() FROM SYS.DUA...
09zd7hgsfrdg6			0.00	0.00	0.00		0.00		0.00		1	/ 1/ 1	SELECT l_returnflag, l_linesta...
0k8522rmdzg4k			0.00	0.00	0.00		0.00		0.00		57	/ 1/ 1	select privilege# from sysauth...
0m78skf1mudnb	0.00	0.00			0.00	0.00		0.00		9		1// 1	select audit$, properties from...
0n3h2c1ufzma4	0.00	0.00			0.00	0.00		0.00		1		1// 1	SELECT COLLECTION_TIMESTAMP, R...
0v3dvmc22qnam	0.00	0.00			0.00	0.00		0.00		202			insert into sys.col_usage$ (ob...
111xpqwr0sfjg	0.00	0.00			0.00	0.00		0.00		317			Begin Update E_Trade Set T_COM...
12qmb2vstfhgy			0.00	0.00	0.00		0.00		0.00		2	/ 1/ 1	SELECT c_custkey, c_name, SUM(...
15p4z9yvdc8ua	0.00	0.00			0.00	0.00		0.00		70		1// 1	SELECT T_EXEC_NAME, T_BID_PRIC...
1809cng2r987s			0.00	0.00	0.00		0.00		0.00		1	/ 1/ 1	SELECT c_custkey, c_name, SUM(...
18naypzfmabd6			0.00	0.00	0.00		0.00		0.00		81		INSERT INTO MGMT_SYSTEM_PERFOR...
1ba09vhjx4rxj			0.00	0.00	0.00		0.00		0.00		1	/ 1/ 1	SELECT l_orderkey, SUM(l_exten...
1gu8t96d0bdmu	0.00	0.00			0.00	0.00		0.00		107		2// 2	select t.ts#, t.file#, t.block...
21mdxpk0d7jt7	0.00	0.00			0.00	0.00		0.00		317		1// 1	UPDATE E_BROKER SET B_COMM_TOT...
2mw82wp65dyv5	0.00	0.00			0.00	0.00		0.00		413		1// 1	SELECT S_NAME, CO_ID, CO_NAME,...
2vcn91b1wtmc6	0.00	0.00			0.00	0.00		0.00		144		1// 1	SELECT TH_DTS, TH_ST_ID FROM E...

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	34,188	7,268	-78.74	0.61	0.23	-62.30	25.33	3.17	-87.49	24.63	32.74	32.93
execute count	136,325	7,864	-94.23	2.44	0.24	-90.16	101.02	3.43	-96.60	98.22	35.42	-63.94
logons cumulative	240	148	-38.33	0.00	0.00	0.00	0.18	0.06	-66.67	0.17	0.67	294.12
opened cursors cumulative	21,141	7,236	-65.77	0.38	0.22	-42.11	15.67	3.16	-79.83	15.23	32.59	113.99
parse count (total)	20,873	5,257	-74.81	0.37	0.16	-56.76	15.47	2.29	-85.20	15.04	23.68	57.45
parse time elapsed	59,195	1,035	-98.25	1.06	0.03	-97.17	43.87	0.45	-98.97	42.65	4.66	-89.07
physical reads	31,527,638	27,809,588	-11.79	563.97	861.81	52.81	23,362.89	12,137.94	-48.05	22,714.44	125,268.41	451.49
physical writes	4,805	604,520	12,481.06	0.09	18.73	20,711.11	3.56	263.85	7,311.52	3.46	2,723.06	78,601.16
redo size	9,317,440	3,763,776	-59.61	166.67	116.64	-30.02	6,904.49	1,642.76	-76.21	6,712.85	16,953.95	152.56
session cursor cache hits	16,463	5,006	-69.59	0.29	0.16	-44.83	12.20	2.18	-82.13	11.86	22.55	90.13
session logical reads	33,179,610	17,774,862	-46.43	593.52	550.84	-7.19	24,587.05	7,758.12	-68.45	23,904.62	80,066.95	234.94
user calls	209,267	366,551	75.16	3.74	11.36	203.74	155.07	159.99	3.17	150.77	1,651.13	995.13
user commits	1,330	222	-83.31	0.02	0.01	-50.00	0.99	0.10	-89.90	0.96	1.00	4.17
workarea executions - optimal	9,797	3,070	-68.66	0.18	0.10	-44.44	7.26	1.34	-81.54	7.06	13.83	95.89

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	199	130	-34.67	0.00	0.00	0.00	0.15	0.06	-60.00	0.14	0.59	321.43
Batched IO block miss count	6,438	533	-91.72	0.12	0.02	-83.33	4.77	0.23	-95.18	4.64	2.40	-48.28
Batched IO buffer defrag count	90	3	-96.67	0.00	0.00	0.00	0.07	0.00	-100.00	0.06	0.01	-83.33
Batched IO double miss count	536	14	-97.39	0.01	0.00	-100.00	0.40	0.01	-97.50	0.39	0.06	-84.62
Batched IO same unit count	1,538	327	-78.74	0.03	0.01	-66.67	1.14	0.14	-87.72	1.11	1.47	32.43
Batched IO single block count	36	96	166.67	0.00	0.00	0.00	0.03	0.04	33.33	0.03	0.43	1,333.33
Batched IO slow jump count	6	1	-83.33	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO vector block count	4,812	98	-97.96	0.09	0.00	-100.00	3.57	0.04	-98.88	3.47	0.44	-87.32
Batched IO vector read count	482	35	-92.74	0.01	0.00	-100.00	0.36	0.02	-94.44	0.35	0.16	-54.29
Block Cleanout Optim referenced	7	2	-71.43	0.00	0.00	0.00	0.01	0.00	-100.00	0.01	0.01	0.00
CPU used by this session	107,873	132,180	22.53	1.93	4.10	112.44	79.94	57.69	-27.83	77.72	595.41	666.10
CPU used when call started	101,091	131,368	29.95	1.81	4.07	124.86	74.91	57.34	-23.45	72.83	591.75	712.51
CR blocks created	654	15	-97.71	0.01	0.00	-100.00	0.48	0.01	-97.92	0.47	0.07	-85.11
DBWR checkpoint buffers written	4,466	1,210	-72.91	0.08	0.04	-50.00	3.31	0.53	-83.99	3.22	5.45	69.25
DBWR transaction table writes	171	180	5.26	0.00	0.01	100.00	0.13	0.08	-38.46	0.12	0.81	575.00
DBWR undo block writes	549	340	-38.07	0.01	0.01	0.00	0.41	0.15	-63.41	0.40	1.53	282.50
HSC Heap Segment Block Changes	9,196	1,001	-89.11	0.16	0.03	-81.25	6.81	0.44	-93.54	6.63	4.51	-31.98
Heap Segment Array Inserts	98	107	9.18	0.00	0.00	0.00	0.07	0.05	-28.57	0.07	0.48	585.71
Number of read IOs issued	247,268	139,710	-43.50	4.42	4.33	-2.04	183.23	60.98	-66.72	178.15	629.32	253.25
RowCR attempts	866	157	-81.87	0.02	0.00	-100.00	0.64	0.07	-89.06	0.62	0.71	14.52
RowCR hits	1,139	157	-86.22	0.02	0.00	-100.00	0.84	0.07	-91.67	0.82	0.71	-13.41
SQL*Net roundtrips to/from client	208,400	365,942	75.60	3.73	11.34	204.02	154.43	159.72	3.43	150.14	1,648.39	997.90
active txn count during cleanout	3,123	70	-97.76	0.06	0.00	-100.00	2.31	0.03	-98.70	2.25	0.32	-85.78
background timeouts	6,522	11,212	71.91	0.12	0.35	191.67	4.83	4.89	1.24	4.70	50.50	974.47
buffer is not pinned count	541,668	32,244	-94.05	9.69	1.00	-89.68	401.39	14.07	-96.49	390.25	145.24	-62.78
buffer is pinned count	56,313	104,861	86.21	1.01	3.25	221.78	41.73	45.77	9.68	40.57	472.35	1,064.28
bytes received via SQL*Net from client	8,330,451	4,144,439	-50.25	149.01	128.44	-13.80	6,173.11	1,808.91	-70.70	6,001.77	18,668.64	211.05
bytes sent via SQL*Net to client	32,778,388	124,252,062	279.07	586.34	3,850.54	556.71	24,289.73	54,231.81	123.27	23,615.55	559,693.97	2,270.02
calls to get snapshot scn: kcmgss	133,789	8,806	-93.42	2.39	0.27	-88.70	99.14	3.84	-96.13	96.39	39.67	-58.84
calls to kcmgas	3,209	871	-72.86	0.06	0.03	-50.00	2.38	0.38	-84.03	2.31	3.92	69.70
calls to kcmgcs	72,126	7,666	-89.37	1.29	0.24	-81.40	53.45	3.35	-93.73	51.96	34.53	-33.55
cell physical IO interconnect bytes	258,531,383,296	232,923,072,000	-9.91	4,624,605.56	7,218,224.98	56.08	191,579,231.40	101,663,010.68	-46.93	186,261,803.53	1,049,203,027.03	463.29
change write time	224	89	-60.27	0.00	0.00	0.00	0.17	0.04	-76.47	0.16	0.40	150.00
cleanout - number of ktugct calls	1,839	72	-96.08	0.03	0.00	-100.00	1.36	0.03	-97.79	1.32	0.32	-75.76
cluster key scan block gets	2,389	2,279	-4.60	0.04	0.07	75.00	1.77	0.99	-44.07	1.72	10.27	497.09
cluster key scans	1,243	2,023	62.75	0.02	0.06	200.00	0.92	0.88	-4.35	0.90	9.11	912.22
commit cleanout failures: callback failure	6	4	-33.33	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.02	100.00
commit cleanout failures: cannot pin	15	1	-93.33	0.00	0.00	0.00	0.01	0.00	-100.00	0.01	0.00	-100.00
commit cleanouts	8,711	1,513	-82.63	0.16	0.05	-68.75	6.46	0.66	-89.78	6.28	6.82	8.60
commit cleanouts successfully completed	8,684	1,508	-82.63	0.16	0.05	-68.75	6.44	0.66	-89.75	6.26	6.79	8.47
commit txn count during cleanout	318	41	-87.11	0.01	0.00	-100.00	0.24	0.02	-91.67	0.23	0.18	-21.74
consistent changes	1,538	45	-97.07	0.03	0.00	-100.00	1.14	0.02	-98.25	1.11	0.20	-81.98
consistent gets	33,147,548	17,764,953	-46.41	592.94	550.53	-7.15	24,563.29	7,753.80	-68.43	23,881.52	80,022.31	235.08
consistent gets - examination	490,679	26,338	-94.63	8.78	0.82	-90.66	363.61	11.50	-96.84	353.52	118.64	-66.44
consistent gets direct	31,331,299	17,271,495	-44.87	560.45	535.24	-4.50	23,217.40	7,538.42	-67.53	22,572.98	77,799.53	244.66
consistent gets from cache	1,816,249	493,458	-72.83	32.49	15.29	-52.94	1,345.89	215.38	-84.00	1,308.54	2,222.78	69.87
consistent gets from cache (fastpath)	1,310,977	465,890	-64.46	23.45	14.44	-38.42	971.47	203.35	-79.07	944.51	2,098.60	122.19
cursor authentications	572	16	-97.20	0.01	0.00	-100.00	0.42	0.01	-97.62	0.41	0.07	-82.93
data blocks consistent reads - undo records applied	19,447	34	-99.83	0.35	0.00	-100.00	14.41	0.01	-99.93	14.01	0.15	-98.93
db block gets	32,062	9,909	-69.09	0.57	0.31	-45.61	23.76	4.32	-81.82	23.10	44.64	93.25
db block gets direct	222	130	-41.44	0.00	0.00	0.00	0.16	0.06	-62.50	0.16	0.59	268.75
db block gets from cache	31,840	9,779	-69.29	0.57	0.30	-47.37	23.59	4.27	-81.90	22.94	44.05	92.02
db block gets from cache (fastpath)	7,575	1,958	-74.15	0.14	0.06	-57.14	5.61	0.85	-84.85	5.46	8.82	61.54
deferred (CURRENT) block cleanout applications	4,172	865	-79.27	0.07	0.03	-57.14	3.09	0.38	-87.70	3.01	3.90	29.57
enqueue conversions	3,912	470	-87.99	0.07	0.01	-85.71	2.90	0.21	-92.76	2.82	2.12	-24.82
enqueue releases	37,483	35,587	-5.06	0.67	1.10	64.18	27.78	15.53	-44.10	27.01	160.30	493.48
enqueue requests	37,745	35,587	-5.72	0.68	1.10	61.76	27.97	15.53	-44.48	27.19	160.30	489.55
flashback log write bytes	23,904,256	7,168,000	-70.01	427.60	222.13	-48.05	17,713.74	3,128.59	-82.34	17,222.09	32,288.29	87.48
flashback log writes	460	57	-87.61	0.01	0.00	-100.00	0.34	0.02	-94.12	0.33	0.26	-21.21
free buffer inspected	20,298	365	-98.20	0.36	0.01	-97.22	15.04	0.16	-98.94	14.62	1.64	-88.78
free buffer requested	41,556	393	-99.05	0.74	0.01	-98.65	30.79	0.17	-99.45	29.94	1.77	-94.09
heap block compress	25	23	-8.00	0.00	0.00	0.00	0.02	0.01	-50.00	0.02	0.10	400.00
hot buffers moved to head of LRU	15,694	701	-95.53	0.28	0.02	-92.86	11.63	0.31	-97.33	11.31	3.16	-72.06
immediate (CURRENT) block cleanout applications	247	311	25.91	0.00	0.01	100.00	0.18	0.14	-22.22	0.18	1.40	677.78
index fast full scans (full)	417	7	-98.32	0.01	0.00	-100.00	0.31	0.00	-100.00	0.30	0.03	-90.00
index fetch by key	168,969	8,133	-95.19	3.02	0.25	-91.72	125.21	3.55	-97.16	121.74	36.64	-69.90
index scans kdiixs1	17,867	19,913	11.45	0.32	0.62	93.75	13.24	8.69	-34.37	12.87	89.70	596.97
leaf node 90-10 splits	38	32	-15.79	0.00	0.00	0.00	0.03	0.01	-66.67	0.03	0.14	366.67
leaf node splits	48	40	-16.67	0.00	0.00	0.00	0.04	0.02	-50.00	0.03	0.18	500.00
lob writes	2	5	150.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.02	100.00
lob writes unaligned	2	5	150.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.02	100.00
max cf enq hold time	90	70	-22.22	0.00	0.00	0.00	0.07	0.03	-57.14	0.06	0.32	433.33
messages received	4,819	1,247	-74.12	0.09	0.04	-55.56	3.57	0.54	-84.87	3.47	5.62	61.96
messages sent	4,819	1,247	-74.12	0.09	0.04	-55.56	3.57	0.54	-84.87	3.47	5.62	61.96
no work - consistent read gets	32,570,246	17,730,030	-45.56	582.62	549.45	-5.69	24,135.49	7,738.56	-67.94	23,465.60	79,865.00	240.35
non-idle wait count	563,378	2,131,884	278.41	10.08	66.07	555.46	417.48	930.49	122.88	405.89	9,603.08	2,265.93
parse count (hard)	6,204	31	-99.50	0.11	0.00	-100.00	4.60	0.01	-99.78	4.47	0.14	-96.87
parse time cpu	1,886	97	-94.86	0.03	0.00	-100.00	1.40	0.04	-97.14	1.36	0.44	-67.65
physical read IO requests	271,322	1,670,321	515.62	4.85	51.76	967.22	201.06	729.04	262.60	195.48	7,523.97	3,748.97
physical read bytes	258,274,410,496	227,816,144,896	-11.79	4,620,008.84	7,059,962.65	52.81	191,388,807.13	99,434,010.44	-48.05	186,076,664.62	1,026,198,850.88	451.49
physical read total IO requests	274,471	1,674,382	510.04	4.91	51.89	956.82	203.39	730.81	259.31	197.75	7,542.26	3,714.04
physical read total bytes	258,332,882,944	227,882,796,032	-11.79	4,621,054.79	7,062,028.15	52.82	191,432,136.90	99,463,101.39	-48.04	186,118,791.75	1,026,499,081.23	451.53
physical read total multi block requests	247,905	135,636	-45.29	4.43	4.20	-5.19	183.70	59.20	-67.77	178.61	610.97	242.07
physical reads cache	37,650	336	-99.11	0.67	0.01	-98.51	27.90	0.15	-99.46	27.13	1.51	-94.43
physical reads cache prefetch	18,722	34	-99.82	0.33	0.00	-100.00	13.87	0.01	-99.93	13.49	0.15	-98.89
physical reads direct	31,489,988	27,809,252	-11.69	563.29	861.80	52.99	23,334.99	12,137.79	-47.98	22,687.31	125,266.90	452.15
physical reads for flashback new	384	171	-55.47	0.01	0.01	0.00	0.28	0.07	-75.00	0.28	0.77	175.00
physical write IO requests	2,538	87,160	3,334.20	0.05	2.70	5,300.00	1.88	38.04	1,923.40	1.83	392.61	21,354.10
physical write bytes	39,362,560	4,952,227,840	12,481.06	704.12	153,468.24	21,695.75	29,168.80	2,161,479.27	7,310.24	28,359.19	22,307,332.61	78,559.98
physical write total IO requests	8,862	89,813	913.46	0.16	2.78	1,637.50	6.57	39.20	496.65	6.38	404.56	6,241.07
physical write total bytes	152,539,136	4,997,762,048	3,176.38	2,728.62	154,879.34	5,576.11	113,035.91	2,181,353.41	1,829.79	109,898.51	22,512,441.66	20,384.76
physical write total multi block requests	187	48	-74.33	0.00	0.00	0.00	0.14	0.02	-85.71	0.13	0.22	69.23
physical writes direct	222	603,310	271,661.26	0.00	18.70	100.00	0.16	263.32	164,475.00	0.16	2,717.61	1,698,406.25
physical writes from cache	4,583	1,210	-73.60	0.08	0.04	-50.00	3.40	0.53	-84.41	3.30	5.45	65.15
physical writes non checkpoint	3,494	603,524	17,173.15	0.06	18.70	31,066.67	2.59	263.42	10,070.66	2.52	2,718.58	107,780.16
recursive calls	153,515	53,142	-65.38	2.75	1.65	-40.00	113.76	23.19	-79.61	110.60	239.38	116.44
recursive cpu usage	77,167	817	-98.94	1.38	0.03	-97.83	57.18	0.36	-99.37	55.60	3.68	-93.38
redo blocks checksummed by FG (exclusive)	6,790	4,917	-27.58	0.12	0.15	25.00	5.03	2.15	-57.26	4.89	22.15	352.97
redo blocks written	19,784	7,835	-60.40	0.35	0.24	-31.43	14.66	3.42	-76.67	14.25	35.29	147.65
redo entries	20,064	4,904	-75.56	0.36	0.15	-58.33	14.87	2.14	-85.61	14.46	22.09	52.77
redo ordering marks	444	180	-59.46	0.01	0.01	0.00	0.33	0.08	-75.76	0.32	0.81	153.13
redo size for direct writes	1,836,296	1,075,360	-41.44	32.85	33.33	1.46	1,360.75	469.36	-65.51	1,322.98	4,843.96	266.14
redo subscn max counts	1,987	457	-77.00	0.04	0.01	-75.00	1.47	0.20	-86.39	1.43	2.06	44.06
redo synch time	2,416	451	-81.33	0.04	0.01	-75.00	1.79	0.20	-88.83	1.74	2.03	16.67
redo synch writes	1,295	78	-93.98	0.02	0.00	-100.00	0.96	0.03	-96.88	0.93	0.35	-62.37
redo wastage	555,308	110,300	-80.14	9.93	3.42	-65.56	411.50	48.14	-88.30	400.08	496.85	24.19
redo write time	3,187	931	-70.79	0.06	0.03	-50.00	2.36	0.41	-82.63	2.30	4.19	82.17
redo writes	2,136	446	-79.12	0.04	0.01	-75.00	1.58	0.19	-87.97	1.54	2.01	30.52
rollbacks only - consistent read gets	10,492	15	-99.86	0.19	0.00	-100.00	7.77	0.01	-99.87	7.56	0.07	-99.07
rows fetched via callback	153,816	3,036	-98.03	2.75	0.09	-96.73	113.98	1.33	-98.83	110.82	13.68	-87.66
session pga memory	235,434,640	120,232,392	-48.93	4,211.45	3,725.97	-11.53	174,463.88	52,477.36	-69.92	169,621.50	541,587.35	219.29
session pga memory max	461,100,208	122,001,864	-73.54	8,248.15	3,780.81	-54.16	341,688.59	53,249.67	-84.42	332,204.76	549,557.95	65.43
session uga memory	103,148,550,960	184,691,075,792	79.05	1,845,119.75	5,723,528.05	210.20	76,436,059.18	80,611,382.33	5.46	74,314,517.98	831,941,782.85	1,019.49
session uga memory max	412,375,632	166,179,896	-59.70	7,376.57	5,149.87	-30.19	305,582.27	72,531.88	-76.26	297,100.60	748,558.09	151.95
shared hash latch upgrades - no wait	21,320	1,016	-95.23	0.38	0.03	-92.11	15.80	0.44	-97.22	15.36	4.58	-70.18
sorts (memory)	11,577	6,908	-40.33	0.21	0.21	0.00	8.58	3.02	-64.80	8.34	31.12	273.14
sorts (rows)	124,537	94,764,374	75,993.35	2.23	2,936.72	131,591.48	92.29	41,361.43	44,716.81	89.72	426,866.55	475,676.36
sql area evicted	5,528	4	-99.93	0.10	0.00	-100.00	4.10	0.00	-100.00	3.98	0.02	-99.50
switch current to new buffer	59	17	-71.19	0.00	0.00	0.00	0.04	0.01	-75.00	0.04	0.08	100.00
table fetch by rowid	197,879	53,595	-72.92	3.54	1.66	-53.11	146.63	23.39	-84.05	142.56	241.42	69.35
table scan blocks gotten	32,483,436	17,688,555	-45.55	581.06	548.16	-5.66	24,071.17	7,720.45	-67.93	23,403.05	79,678.18	240.46
table scan rows gotten	1,811,522,529	1,000,452,129	-44.77	32,404.49	31,003.75	-4.32	1,342,390.58	436,663.38	-67.47	1,305,131.51	4,506,541.12	245.29
table scans (direct read)	2,240	255	-88.62	0.04	0.01	-75.00	1.66	0.11	-93.37	1.61	1.15	-28.57
table scans (long tables)	5,681	255	-95.51	0.10	0.01	-90.00	4.21	0.11	-97.39	4.09	1.15	-71.88
table scans (short tables)	1,063	2,019	89.93	0.02	0.06	200.00	0.79	0.88	11.39	0.77	9.09	1,080.52
total cf enq hold time	7,580	3,250	-57.12	0.14	0.10	-28.57	5.62	1.42	-74.73	5.46	14.64	168.13
total number of cf enq holders	138	136	-1.45	0.00	0.00	0.00	0.10	0.06	-40.00	0.10	0.61	510.00
undo change vector size	2,656,212	962,204	-63.78	47.51	29.82	-37.23	1,968.33	419.97	-78.66	1,913.70	4,334.25	126.49

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
182.56	94.86	-48.04	0.22	0.00	-100.00	182.30	91.03	-50.07	0.11	2.08	1,790.91	0.03	0.00	-100.00	0.00	0.73	100.00	0.01	0.00	-100.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
203.45	730.80	259.20	17.27	0.14	-99.19	183.84	724.83	294.27	6.58	39.20	495.74	1.87	0.39	-79.14	0.01	13.45	134,400.00	3.23	0.39	-87.93

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
182.57	94.86	-48.04	182.53	58.90	-67.73	0.00	35.93	100.00	0.11	2.08	1,790.91	0.03	0.00	-100.00	0.00	2.06	100.00	0.01	0.00	-100.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
203.44	730.79	259.22	201.17	61.15	-69.60	0.00	667.91	100.00	6.59	39.20	494.84	1.89	0.39	-79.37	0.00	37.65	100.00	3.24	0.39	-87.96

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
TPCH_BIGTEMP		667.91	100.00		37.64	100.00		1,530,257		0.00		6.89		86,242		0		0.00		705.55
TPCE_TRADE_DATA	184.43	0.00	-100.00	0.74	0.00	-100.00	248,884	0	3.24	0.00	126.11	0.00	994	0	244	0	330.12	0.00	185.17	0.00	-185.17
TPCH_REF_DATA	0.00	61.04	100.00	0.00	0.00	0.00	0	139,842	0.00	0.03	0.00	123.51	0	0	0	47	0.00	50.43	0.00	61.04	61.04
TPCE_TRADE_HISTORY_IDX	1.91	0.00	-100.00	0.01	0.00	-100.00	2,581	0	159.05	0.00	1.25	0.00	11	0	95	0	320.21	0.00	1.92	0.00	-1.92
TPCE_SETTLEMENT_DATA	1.71	0.00	-100.00	0.20	0.00	-100.00	2,313	0	164.38	0.00	1.29	0.00	265	0	25	0	244.40	0.00	1.91	0.00	-1.91
TPCE_DAILY_MARKET_DATA	1.79	0.00	-100.00	0.01	0.00	-100.00	2,417	0	57.19	0.00	35.45	0.00	8	0	1,037	0	126.75	0.00	1.80	0.00	-1.80
TPCE_TRADE_HISTORY_DATA	1.75	0.00	-100.00	0.02	0.00	-100.00	2,368	0	185.03	0.00	1.25	0.00	29	0	14	0	165.71	0.00	1.78	0.00	-1.78
TPCE_CASH_TRANSACTION_DATA	1.65	0.00	-100.00	0.11	0.00	-100.00	2,227	0	373.42	0.00	1.33	0.00	143	0	47	0	231.06	0.00	1.76	0.00	-1.76
TPCE_TRADE_IDX	1.68	0.00	-100.00	0.00	0.00	0.00	2,263	0	236.54	0.00	1.59	0.00	6	0	16	0	157.50	0.00	1.68	0.00	-1.68
TPCE_SETTLEMENT_IDX	1.57	0.00	-100.00	0.00	0.00	0.00	2,112	0	126.27	0.00	1.27	0.00	6	0	20	0	363.00	0.00	1.57	0.00	-1.57
TPCE_CASH_TRANSACTION_IDX	1.51	0.00	-100.00	0.00	0.00	0.00	2,041	0	253.43	0.00	1.27	0.00	3	0	27	0	280.74	0.00	1.51	0.00	-1.51
SYSTEM	0.77	0.00	-100.00	0.03	0.02	-33.33	1,044	0	0.00	0.00	1.01	0.00	42	37	76	0	20.79	0.00	0.80	0.02	-0.79
TPCE_DAILY_MARKET_IDX	0.69	0.00	-100.00	0.00	0.00	0.00	937	0	130.53	0.00	1.82	0.00	0	0	6	0	98.33	0.00	0.69	0.00	-0.69
TPCE_REF_DATA	0.45	0.00	-100.00	0.00	0.00	0.00	610	0	3.49	0.00	4.86	0.00	0	0	60	0	72.83	0.00	0.45	0.00	-0.45
UNDOTBS1	0.22	0.03	-86.36	0.25	0.16	-36.00	292	71	0.00	0.00	1.00	1.00	341	364	9	0	7.78	0.00	0.47	0.19	-0.28
TPCE_WATCH_LIST_DATA	0.24	0.00	-100.00	0.00	0.00	0.00	324	0	1.70	0.00	15.86	0.00	0	0	12	0	167.50	0.00	0.24	0.00	-0.24
SYSAUX	0.11	0.06	-45.45	0.33	0.21	-36.36	155	140	0.00	0.00	3.30	1.86	450	492	0	0	0.00	0.00	0.45	0.28	-0.17
TPCE_CUSTOMER_DATA	0.15	0.00	-100.00	0.00	0.00	0.00	205	0	3.12	0.00	56.46	0.00	0	0	4	0	167.50	0.00	0.15	0.00	-0.15
TPCE_COMPANY_DATA	0.12	0.00	-100.00	0.00	0.00	0.00	165	0	1.21	0.00	57.43	0.00	0	0	4	0	7.50	0.00	0.12	0.00	-0.12
TPCE_HOLDING_HISTORY_DATA	0.01	0.00	-100.00	0.07	0.00	-100.00	16	0	80.63	0.00	1.00	0.00	88	0	68	0	2.65	0.00	0.08	0.00	-0.08
TPCE_WATCH_ITEM_IDX	0.08	0.00	-100.00	0.00	0.00	0.00	104	0	256.35	0.00	3.64	0.00	0	0	7	0	181.43	0.00	0.08	0.00	-0.08

Back to IO Stats
Back to Top

Top File Comparison by IO

No data exists for this section of the report.

Back to IO Stats
Back to Top

		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
SYSAUX	+DATA/orcl/datafile/sysaux.258.716405081	0.00	0.00	0.00	0.00	0.00	155	140	0.11	0.06	3.30	1.86	450	492	0.33	0.21	0	0	0.00	0.00
SYSTEM	+DATA/orcl/datafile/system.259.716405187	0.00	0.00	0.00	0.00	0.00	1,044	0	0.77	0.00	1.01	0.00	42	37	0.03	0.02	76	0	2.08	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
SYSTEM	+DATA/orcl/datafile/system.259.716405187	0.00	0.00	-0.00	76	0	2.08	0.00	1,044	0	0.77	0.00	0.00	0.00	1.01	0.00	42	37	0	0
TPCE_ADDRESS_DATA	/u01/app/oradata/TPCE/tpce_address_data01.dbf	0.00	0.00	-0.00	20	0	7.75	0.00	12	0	0.01	0.00	140.00	0.00	5.25	0.00	0	0	0	0

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	21	369	1,313	2,360	424,602	2,360
E1	0	21	379	2,719	21,163	424,602	21,163

B2	0	21	336	1,133	1,843	424,602	1,843
E2	0	21	336	2,290	5,516	424,602	5,516

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	26.03	-73.97	10,714	88,994	730.63	571	2,739	0	145,986	100.00	0	7,783

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	150	9	202.6	0.0	0.0	0.0	0.0	30,720
E1	150	9	435.9	0.0	0.0	0.0	0.0	30,720

B2	150	9	186.6	0.0	0.0	0.0	0.0	30,720
E2	150	9	188.7	0.0	0.0	0.0	0.0	30,720

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	248.34	2.37	1,653	47	1.50	0.50	-66.67
extent map	0.00	0.00	-0.00	29.20	0.00	60	0	4.87	0.00	-100.00
segment header	0.00	0.00	-0.00	16.57	0.00	138	0	1.20	0.00	-100.00
1st level bmb	0.00	0.00	-0.00	10.17	0.00	67	0	1.52	0.00	-100.00
2nd level bmb	0.00	0.00	-0.00	1.48	0.00	31	0	0.48	0.00	-100.00
undo header	0.00	0.00	-0.00	0.04	0.00	6	0	0.07	0.00	-100.00
undo block	0.00	0.00	-0.00	0.03	0.00	3	0	0.10	0.00	-100.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	1.61	0.00	-1.61	900	0	6,084	0	6,084	0	0	0	666	0	1,351.68	0.00
TX-Transaction (row lock contention)	0.11	0.00	-0.11	63	0	27	0	27	0	0	0	27	0	2,341.48	0.00
PR-Process Startup	0.05	0.00	-0.05	30	0	103	89	103	89	0	0	4	0	7,580.00	0.00
TX-Transaction (index contention)	0.01	0.00	-0.01	6	0	23	0	23	0	0	0	23	0	272.17	0.00
HW-Segment High Water Mark	0.00	0.00	-0.00	2	0	200	128	200	128	0	0	38	0	59.21	0.00
CF-Controlfile Transaction	0.00	0.00	-0.00	1	0	717	1,034	717	1,034	0	0	1	0	1,030.00	0.00

Back to Wait Stats
Back to Top

Undo Segment Summary

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

	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1st	0.54	2,100	752	21	24.1/25.6	0/0	0/0/0/0/0/0
2nd	0.17	448	1,274	3	23.1/33.3	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)
shared pool	81.15	41.89	-39.26	317,474	11,671	3,152	54	1,548	28	1,924	31	271,472,708	850,219	-270,622,489
cache buffers chains	11.64	33.78	22.14	3,358,455	999,904	756	108	499	83	276	25	13,068,358	700,613	-12,367,745
sort extent pool	0.00	14.86	14.86	90	329,808	0	102	0	91	0	11	0	15,739	15,739
process allocation	12.40	0.00	-12.40	3,358	299	31	0	2	0	294	0	4,134,675	0	-4,134,675
cache buffers lru chain	5.15	0.00	-5.15	23,955	1,290	137	0	22	0	122	0	4,880,231	0	-4,880,231
active service list	0.04	4.05	4.01	5,067	7,623	2	3	1	0	1	3	73,928	43,832	-30,096
session idle bit	0.38	4.05	3.67	420,127	733,321	47	48	40	45	9	3	30,458	592	-29,866
simulator hash latch	0.04	2.70	2.66	146,769	636,939	1	18	0	16	1	2	840	15,239	14,399
kks stats	2.66	0.00	-2.66	31,508	55	65	0	2	0	63	0	9,934,065	0	-9,934,065
row cache objects	2.49	0.00	-2.49	299,914	43,142	159	0	100	0	59	0	2,704,611	0	-2,704,611
object queue header operation	0.42	2.70	2.28	101,444	12,497	36	2	26	0	10	2	93,740	8,330	-85,410
FOB s.o list latch	2.28	0.00	-2.28	2,102	978	52	0	0	0	54	0	11,699,506	0	-11,699,506
Real-time plan statistics latch	1.77	0.00	-1.77	13,501	1,439	183	1	143	1	42	0	1,094,839	0	-1,094,839
query server process	1.56	0.00	-1.56	46	0	18	0	0	0	37	0	23,212,382	0	-23,212,382
JS Sh mem access	0.00	1.35	1.35	3	5	0	1	0	0	0	1	0	179	179
ksv class latch	0.00	1.35	1.35	314	178	0	2	0	1	0	1	0	205	205
enqueue hash chains	0.80	0.00	-0.80	80,855	71,629	37	2	18	2	19	0	474,000	0	-474,000
SQL memory manager latch	0.76	0.00	-0.76	1,467	175	20	0	2	0	18	0	196,626	0	-196,626
parallel query alloc buffer	0.76	0.00	-0.76	1,787	305	20	0	7	0	18	0	197,775	0	-197,775
call allocation	0.34	0.00	-0.34	2,310	681	11	0	3	0	8	0	12,903	0	-12,903
SGA IO buffer pool latch	0.30	0.00	-0.30	344	0	7	0	0	0	7	0	931,571	0	-931,571
enqueues	0.30	0.00	-0.30	61,112	68,242	19	5	12	5	7	0	337,575	0	-337,575
redo allocation	0.17	0.00	-0.17	6,752	2,561	4	0	0	0	4	0	110,588	0	-110,588
loader state object freelist	0.13	0.00	-0.13	4,506	2,034	3	0	0	0	3	0	62,731	0	-62,731
shared pool simulator	0.08	0.00	-0.08	51,024	206	3	0	1	0	2	0	32,977	0	-32,977
cache buffer handles	0.04	0.00	-0.04	3,576	226	4	0	3	0	1	0	34	0	-34
dummy allocation	0.04	0.00	-0.04	443	297	1	0	0	0	1	0	8,802	0	-8,802
hash table column usage latch	0.04	0.00	-0.04	362	13	1	0	0	0	1	0	12,056	0	-12,056
process queue reference	0.04	0.00	-0.04	50,266	1	6	0	5	0	1	0	23	0	-23
simulator lru latch	0.04	0.00	-0.04	2,480	728	1	0	0	0	1	0	20	0	-20
space background task latch	0.04	0.00	-0.04	1,003	1,698	1	0	0	0	1	0	27,924	0	-27,924

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
shared pool	271,472,708	850,219	-270,622,489	317,474	11,671	3,152	54	1,548	28	1,924	31	81.15	41.89	-39.26
query server process	23,212,382	0	-23,212,382	46	0	18	0	0	0	37	0	1.56	0.00	-1.56
cache buffers chains	13,068,358	700,613	-12,367,745	3,358,455	999,904	756	108	499	83	276	25	11.64	33.78	22.14
FOB s.o list latch	11,699,506	0	-11,699,506	2,102	978	52	0	0	0	54	0	2.28	0.00	-2.28
kks stats	9,934,065	0	-9,934,065	31,508	55	65	0	2	0	63	0	2.66	0.00	-2.66
cache buffers lru chain	4,880,231	0	-4,880,231	23,955	1,290	137	0	22	0	122	0	5.15	0.00	-5.15
process allocation	4,134,675	0	-4,134,675	3,358	299	31	0	2	0	294	0	12.40	0.00	-12.40
row cache objects	2,704,611	0	-2,704,611	299,914	43,142	159	0	100	0	59	0	2.49	0.00	-2.49
Real-time plan statistics latch	1,094,839	0	-1,094,839	13,501	1,439	183	1	143	1	42	0	1.77	0.00	-1.77
SGA IO buffer pool latch	931,571	0	-931,571	344	0	7	0	0	0	7	0	0.30	0.00	-0.30
enqueue hash chains	474,000	0	-474,000	80,855	71,629	37	2	18	2	19	0	0.80	0.00	-0.80
enqueues	337,575	0	-337,575	61,112	68,242	19	5	12	5	7	0	0.30	0.00	-0.30
parallel query alloc buffer	197,775	0	-197,775	1,787	305	20	0	7	0	18	0	0.76	0.00	-0.76
SQL memory manager latch	196,626	0	-196,626	1,467	175	20	0	2	0	18	0	0.76	0.00	-0.76
redo allocation	110,588	0	-110,588	6,752	2,561	4	0	0	0	4	0	0.17	0.00	-0.17
object queue header operation	93,740	8,330	-85,410	101,444	12,497	36	2	26	0	10	2	0.42	2.70	2.28
loader state object freelist	62,731	0	-62,731	4,506	2,034	3	0	0	0	3	0	0.13	0.00	-0.13
shared pool simulator	32,977	0	-32,977	51,024	206	3	0	1	0	2	0	0.08	0.00	-0.08
active service list	73,928	43,832	-30,096	5,067	7,623	2	3	1	0	1	3	0.04	4.05	4.01
session idle bit	30,458	592	-29,866	420,127	733,321	47	48	40	45	9	3	0.38	4.05	3.67
space background task latch	27,924	0	-27,924	1,003	1,698	1	0	0	0	1	0	0.04	0.00	-0.04
sort extent pool	0	15,739	15,739	90	329,808	0	102	0	91	0	11	0.00	14.86	14.86
simulator hash latch	840	15,239	14,399	146,769	636,939	1	18	0	16	1	2	0.04	2.70	2.66
call allocation	12,903	0	-12,903	2,310	681	11	0	3	0	8	0	0.34	0.00	-0.34
hash table column usage latch	12,056	0	-12,056	362	13	1	0	0	0	1	0	0.04	0.00	-0.04
dummy allocation	8,802	0	-8,802	443	297	1	0	0	0	1	0	0.04	0.00	-0.04
ksv class latch	0	205	205	314	178	0	2	0	1	0	1	0.00	1.35	1.35
JS Sh mem access	0	179	179	3	5	0	1	0	0	0	1	0.00	1.35	1.35
cache buffer handles	34	0	-34	3,576	226	4	0	3	0	1	0	0.04	0.00	-0.04
process queue reference	23	0	-23	50,266	1	6	0	5	0	1	0	0.04	0.00	-0.04
simulator lru latch	20	0	-20	2,480	728	1	0	0	0	1	0	0.04	0.00	-0.04

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
TPCE	TPCE_TRADE_DATA	E_TRADE		TABLE	94.24	94.24			-94.24	31,268,448			94.57		-94.57
TPCH	TPCH_REF_DATA	H_LINEITEM		TABLE			82.67	82.67	82.67		14,693,856			82.74	82.74
TPCH	TPCH_REF_DATA	H_ORDER		TABLE			13.80	96.47	13.80		2,452,768			13.81	13.81
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET		TABLE	3.49	97.73			-3.49	1,157,936			3.50		-3.50
TPCH	TPCH_REF_DATA	H_CUSTOMER		TABLE			1.27	97.74	1.27		225,664			1.27	1.27
TPCH	TPCH_REF_DATA	H_PART		TABLE			0.96	98.69	0.96		170,064			0.96	0.96
TPCH	TPCH_REF_DATA	H_PARTSUPP		TABLE			0.77	99.46	0.77		136,448			0.77	0.77
TPCE	TPCE_DAILY_MARKET_IDX	E_DAILY_MARKET_PK_IDX		INDEX	0.29	98.02			-0.29	96,352			0.29		-0.29
TPCE	TPCE_SECURITY_DATA	E_SECURITY		TABLE	0.25	98.27			-0.25	84,288			0.25		-0.25
TPCE	TPCE_SECURITY_IDX	E_SECURITY_PK_IDX		INDEX	0.22	98.49			-0.22	73,232			0.22		-0.22

					% 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
TPCE	TPCE_TRADE_DATA	E_TRADE		TABLE	99.55	99.55			-99.55	31,385,936			99.56		-99.56
TPCH	TPCH_REF_DATA	H_LINEITEM		TABLE			52.84	52.84	52.84		14,694,075			85.08	85.08
TPCH	TPCH_REF_DATA	H_ORDER		TABLE			8.82	61.66	8.82		2,452,485			14.20	14.20
TPCH	TPCH_REF_DATA	H_PARTSUPP		TABLE			0.45	62.11	0.45		125,049			0.72	0.72
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET		TABLE	0.27	99.82			-0.27	85,675			0.27		-0.27
TPCE	TPCE_CUSTOMER_DATA	E_CUSTOMER		TABLE	0.04	99.86			-0.04	11,574			0.04		-0.04
TPCE	TPCE_COMPANY_DATA	E_COMPANY		TABLE	0.03	99.89			-0.03	9,476			0.03		-0.03
TPCE	TPCE_WATCH_LIST_DATA	E_WATCH_LIST		TABLE	0.02	99.91			-0.02	5,139			0.02		-0.02
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	0.00	99.91	0.00	62.11	-0.00	229	132	-42.36	0.00	0.00	0.00
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	0.00	99.91	0.00	62.11	0.00	30	48	60.00	0.00	0.00	0.00

					% 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
TPCE	TPCE_TRADE_DATA	E_TRADE		TABLE	91.73	91.73			-91.73	248,882			92.25		-92.25
TPCH	TPCH_REF_DATA	H_LINEITEM		TABLE			7.04	7.04	7.04		117,584			84.01	84.01
TPCH	TPCH_REF_DATA	H_ORDER		TABLE			1.25	8.29	1.25		20,894			14.93	14.93
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX		INDEX	0.95	92.68			-0.95	2,581			0.96		-0.96
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET		TABLE	0.89	93.57			-0.89	2,417			0.90		-0.90
TPCE	TPCE_TRADE_HISTORY_DATA	E_TRADE_HISTORY		TABLE	0.87	94.44			-0.87	2,368			0.88		-0.88
TPCE	TPCE_SETTLEMENT_DATA	E_SETTLEMENT		TABLE	0.85	95.30			-0.85	2,313			0.86		-0.86
TPCH	TPCH_REF_DATA	H_PARTSUPP		TABLE			0.08	8.37	0.08		1,344			0.96	0.96
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	0.01	95.31	0.00	8.37	-0.01	30	48	60.00	0.01	0.03	0.02
TPCH	TPCH_REF_DATA	H_PARTSUPP_IDX1		INDEX			0.00	8.37	0.00		18			0.01	0.01

					% 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
TPCE	TPCE_TRADE_DATA	E_TRADE		TABLE	91.73	91.73			-91.73	248,882			92.25		-92.25
TPCH	TPCH_REF_DATA	H_LINEITEM		TABLE			7.04	7.04	7.04		117,584			84.01	84.01
TPCH	TPCH_REF_DATA	H_ORDER		TABLE			1.25	8.29	1.25		20,894			14.93	14.93
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX		INDEX	0.95	92.68			-0.95	2,581			0.96		-0.96
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET		TABLE	0.89	93.57			-0.89	2,417			0.90		-0.90
TPCE	TPCE_TRADE_HISTORY_DATA	E_TRADE_HISTORY		TABLE	0.87	94.44			-0.87	2,368			0.88		-0.88
TPCE	TPCE_SETTLEMENT_DATA	E_SETTLEMENT		TABLE	0.85	95.30			-0.85	2,313			0.86		-0.86
TPCH	TPCH_REF_DATA	H_PARTSUPP		TABLE			0.08	8.37	0.08		1,344			0.96	0.96
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	0.01	95.31	0.00	8.37	-0.01	30	48	60.00	0.01	0.03	0.02
TPCH	TPCH_REF_DATA	H_PARTSUPP_IDX1		INDEX			0.00	8.37	0.00		18			0.01	0.01

					% 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			0.00	0.00
SYS	SYSTEM	I_OBJ#		INDEX			0.00	0.00	0.00		0			0.00	0.00
SYS	SYSTEM	I_SYSAUTH1		INDEX	0.00	0.00	0.00	0.00	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSTEM	SYS_C00641		INDEX	0.00	0.00			0.00	0		100.00	0.00		0.00
SYS	SYSAUX	SYS_LOB0000005938C00038$$		LOB	0.00	0.00			0.00	0		100.00	0.00		0.00
SYS	SYSTEM	TAB$		TABLE			0.00	0.00	0.00		0			0.00	0.00
SYS	SYSTEM	USER$		TABLE			0.00	0.00	0.00		0			0.00	0.00
SYS	SYSAUX	WRH$_BG_EVENT_SUMMARY		TABLE	0.00	0.00			0.00	0		100.00	0.00		0.00
SYS	SYSAUX	WRH$_SQL_BIND_METADATA		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
TPCE	TPCE_TRADE_DATA	E_TRADE		TABLE	99.66	99.66			-99.66	31,382,208			99.66		-99.66
TPCH	TPCH_REF_DATA	H_LINEITEM		TABLE			52.84	52.84	52.84		14,694,075			85.08	85.08
TPCH	TPCH_REF_DATA	H_ORDER		TABLE			8.82	61.66	8.82		2,452,485			14.20	14.20
TPCH	TPCH_REF_DATA	H_PARTSUPP		TABLE			0.45	62.11	0.45		124,935			0.72	0.72
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET		TABLE	0.25	99.90			-0.25	77,568			0.25		-0.25
TPCE	TPCE_CUSTOMER_DATA	E_CUSTOMER		TABLE	0.04	99.94			-0.04	11,520			0.04		-0.04
TPCE	TPCE_COMPANY_DATA	E_COMPANY		TABLE	0.03	99.97			-0.03	9,420			0.03		-0.03
TPCE	TPCE_WATCH_LIST_DATA	E_WATCH_LIST		TABLE	0.02	99.99			-0.02	5,136			0.02		-0.02
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	0.00	99.99	0.00	62.11	-0.00	220	130	-40.91	0.00	0.00	0.00
SYS	SYSTEM	TAB$		TABLE			0.00	62.11	0.00		0			0.00	0.00

Top Segments Comparison by Physical Writes

Ordered by absolute value of 'Diff' column of '% of Total Physical Writes'
Top 5 Segments from each period are compared
Total Physical Writes First: 4,805, Second: 604,520
Captured Physical Writes First: 3,396, Second: 411
Captured Physical Writes as % of Total First: 70.68%, Second: .07%

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
TPCE	TPCE_TRADE_DATA	E_TRADE		TABLE	20.71	20.71			-20.71	995			29.30		-29.30
TPCE	TPCE_HOLDING_HISTORY_DATA	E_HOLDING_HISTORY		TABLE	16.07	36.77			-16.07	772			22.73		-22.73
TPCE	TPCE_SETTLEMENT_DATA	E_SETTLEMENT		TABLE	7.08	43.85			-7.08	340			10.01		-10.01
TPCE	TPCE_CASH_TRANSACTION_DATA	E_CASH_TRANSACTION		TABLE	6.43	50.28			-6.43	309			9.10		-9.10
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	4.93	55.21	0.02	0.02	-4.91	237	141	-40.51	6.98	34.31	27.33
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	0.85	56.07	0.01	0.03	-0.84	41	59	43.90	1.21	14.36	13.15
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	WRH$_EVENT__1200893776_2190	TABLE PARTITION	0.08	56.15	0.00	0.04	-0.08	4	16	300.00	0.12	3.89	3.78
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01		INDEX			0.00	0.04	0.00		22			5.35	5.35
SYS	SYSAUX	SMON_SCN_TIME		TABLE			0.00	0.04	0.00		18			4.38	4.38

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
TPCE	TPCE_TRADE_DATA	E_TRADE		TABLE	39.16	39.16			-39.16	994			56.51		-56.51
TPCE	TPCE_SETTLEMENT_DATA	E_SETTLEMENT		TABLE	10.44	49.61			-10.44	265			15.07		-15.07
TPCE	TPCE_CASH_TRANSACTION_DATA	E_CASH_TRANSACTION		TABLE	5.63	55.24			-5.63	143			8.13		-8.13
TPCE	TPCE_HOLDING_HISTORY_DATA	E_HOLDING_HISTORY		TABLE	3.43	58.67			-3.43	87			4.95		-4.95
TPCE	TPCE_CUSTOMER_ACCOUNT_DATA	E_CUSTOMER_ACCOUNT		TABLE	1.30	59.97			-1.30	33			1.88		-1.88
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	1.18	61.15	0.02	0.02	-1.16	30	17	-43.33	1.71	10.90	9.19
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY		TABLE	0.28	61.43	0.01	0.03	-0.26	7	10	42.86	0.40	6.41	6.01
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	0.24	61.66	0.02	0.05	-0.22	6	14	133.33	0.34	8.97	8.63
SYS	SYSAUX	SMON_SCN_TIME		TABLE			0.02	0.07	0.02		18			11.54	11.54
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01		INDEX			0.02	0.09	0.02		16			10.26	10.26

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: 222, Second: 603,310
Captured Direct Writes First: 222, Second: 130
Captured Direct Writes as % of Total First: 100%, Second: .02%

Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	%Diff	1st	2nd	Diff
					% of Total Direct Writes					Direct Writes			% of Captured Direct Writes
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	99.10	99.10	0.02	0.02	-99.08	220	130	-40.91	99.10	100.00	0.90
SYS	SYSAUX	SYS_LOB0000005938C00038$$		LOB	0.90	100.00			-0.90	2			0.90		-0.90
SYS	SYSTEM	FET$		TABLE			0.00	0.02	0.00		0			0.00	0.00
SYS	SYSTEM	I_OBJ#		INDEX			0.00	0.02	0.00		0			0.00	0.00
SYS	SYSTEM	I_SYSAUTH1		INDEX	0.00	100.00	0.00	0.02	0.00	0	0	0.00	0.00	0.00	0.00
SYS	SYSTEM	SYS_C00641		INDEX	0.00	100.00			0.00	0		100.00	0.00		0.00
SYS	SYSTEM	TAB$		TABLE			0.00	0.02	0.00		0			0.00	0.00
SYS	SYSTEM	USER$		TABLE			0.00	0.02	0.00		0			0.00	0.00
SYS	SYSAUX	WRH$_SQL_BIND_METADATA		TABLE	0.00	100.00	0.00	0.02	0.00	0	0	0.00	0.00	0.00	0.00

Back to Segment Statistics
Back to Top

Top Segments Comparison by Table Scans

Ordered by absolute value of 'Diff' column of '% of Total Table Scans'
Top 5 Segments from each period are compared
Total Table Scans First: 6,098, Second: 262
Captured Table Scans First: 5,681, Second: 261
Captured Table Scans as % of Total First: 93.16%, Second: 99.62%

Owner	Tablespace	Object Name	Type	1st	1st Total	2nd	2nd Total	Diff	1st	2nd	1st	2nd	Diff
				% of Total Table Scans					Table Scans		% of Captured Table Scans
TPCH	TPCH_REF_DATA	H_LINEITEM	TABLE			51.53	51.53	51.53		135		51.72	51.72
TPCH	TPCH_REF_DATA	H_ORDER	TABLE			40.08	91.60	40.08		105		40.23	40.23
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	15.60	15.60			-15.60	951		16.74		-16.74
TPCE	TPCE_SECURITY_DATA	E_SECURITY	TABLE	12.91	28.50			-12.91	787		13.85		-13.85
TPCE	TPCE_REF_DATA	E_TRADE_TYPE	TABLE	11.23	39.73			-11.23	685		12.06		-12.06
TPCE	TPCE_TRADE_REQUEST_DATA	E_TRADE_REQUEST	TABLE	10.66	50.39			-10.66	650		11.44		-11.44
TPCE	TPCE_REF_DATA	E_STATUS_TYPE	TABLE	10.41	60.81			-10.41	635		11.18		-11.18
TPCH	TPCH_REF_DATA	H_PARTSUPP	TABLE			5.73	97.33	5.73		15		5.75	5.75
SYS	SYSTEM	I_OBJ2	INDEX			2.29	99.62	2.29		6		2.30	2.30
SYS	SYSTEM	TAB$	TABLE			0.00	99.62	0.00		0		0.00	0.00

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: 34,188, Second: 7,268
Captured DB Block Changes First: 12,688, Second: 1,616
Captured DB Block Changes as % of Total First: 37.11%, Second: 22.23%

Owner	Tablespace	Object Name	Subobject 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
SYSMAN	SYSAUX	MGMT_CURRENT_METRICS_PK		INDEX			5.94	5.94	5.94		432			26.73	26.73
TPCE	TPCE_HOLDING_HISTORY_DATA	E_HOLDING_HISTORY		TABLE	4.26	4.26			-4.26	1,456			11.48		-11.48
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX		INDEX	4.02	8.28			-4.02	1,376			10.84		-10.84
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01		INDEX			3.30	9.25	3.30		240			14.85	14.85
TPCE	TPCE_HOLDING_SUMMARY_DATA	E_HOLDING_SUMMARY		TABLE	2.90	11.19			-2.90	992			7.82		-7.82
TPCE	TPCE_HOLDING_SUMMARY_IDX	E_HOLDING_SUMMARY_PK_IDX		INDEX	2.76	13.95			-2.76	944			7.44		-7.44
TPCE	TPCE_HOLDING_HISTORY_IDX	E_HOLDING_HISTORY_PK_IDX		INDEX	2.43	16.38			-2.43	832			6.56		-6.56
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	0.98	17.36	3.08	12.33	2.10	336	224	-33.33	2.65	13.86	11.21
SYS	SYSAUX	WRI$_ADV_PARAMETERS		TABLE			1.10	13.43	1.10		80			4.95	4.95
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	WRH$_EVENT__1200893776_2190	INDEX PARTITION	0.09	17.46	1.10	14.53	1.01	32	80	150.00	0.25	4.95	4.70

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: 27, Second: 1
Total TX Row Lock Wait Time First: 63.22 seconds, Second: 0.00 seconds
TX Row Lock Wait Time as % of DB time First: .11%, Second: 0%
Captured Row Lock Waits First: 50, Second: 1

Owner	Tablespace	Object Name	Type	1st	Diff	1st	1st	1st Total	Diff
				% of Total		Row Lock Waits	% of Captured
TPCE	TPCE_BROKER_DATA	E_BROKER	TABLE	96.30	-96.30	26	52.00	52.00	-52.00
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX	INDEX	77.78	-77.78	21	42.00	94.00	-42.00
TPCE	TPCE_HOLDING_SUMMARY_IDX	E_HOLDING_SUMMARY_PK_IDX	INDEX	7.41	-7.41	2	4.00	98.00	-4.00
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	3.70	-3.70	1	2.00	100.00	-2.00

Back to Segment Statistics
Back to Top

Top Segments by ITL Waits

No data exists for this section of the report.

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: 64, Second: 1
Buffer Busy Wait Time First: 3.44 seconds, Second: 0.00 seconds
Buffer Busy Wait Time as % of DB time First: .01%, Second: 0%
Captured Buffer Busy Waits First: 111, Second: 1

Owner	Tablespace	Object Name	Subobject Name	Type	1st	1st Total	Diff	1st	1st	Diff
					% of Total Buffer Busy Waits			Buffer Busy Waits	% of Captured Buffer Busy Waits
TPCE	TPCE_HOLDING_HISTORY_DATA	E_HOLDING_HISTORY		TABLE	106.25	106.25	-106.25	68	61.26	-61.26
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX		INDEX	57.81	164.06	-57.81	37	33.33	-33.33
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	3.13	167.19	-3.13	2	1.80	-1.80
TPCE	TPCE_BROKER_DATA	E_BROKER		TABLE	3.13	170.31	-3.13	2	1.80	-1.80
TPCE	TPCE_TRADE_HISTORY_DATA	E_TRADE_HISTORY		TABLE	1.56	171.88	-1.56	1	0.90	-0.90

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.00	0.00	0.00	0.03	0.02	-33.33	38	49	0.00	0.00	0	0	0.00	0.00	2	2	1	1
dc_files	0.00	0.00	0.00	0.00	0.03	100.00	0	80	0.00	0.00	0	0	0.00	0.00	0	0	80	80
dc_global_oids	0.03	0.01	-66.67	1.35	0.13	-90.37	1,828	306	0.71	0.00	0	0	0.00	0.00	0	0	89	111
dc_histogram_data	0.03	0.00	-100.00	1.19	0.00	-100.00	1,600	7	7.44	0.00	0	0	0.00	0.00	0	0	1,563	1,857
dc_histogram_defs	0.35	0.01	-97.14	14.54	0.13	-99.11	19,624	290	6.64	0.00	0	0	0.00	0.00	0	0	3,380	4,762
dc_object_grants	0.00	0.00	0.00	0.10	0.00	-100.00	138	0	5.07	0.00	0	0	0.00	0.00	0	0	107	110
dc_objects	0.50	0.02	-96.00	20.69	0.31	-98.50	27,925	701	0.91	0.00	0	0	0.00	0.00	4	4	2,720	3,153
dc_profiles	0.00	0.00	0.00	0.06	0.03	-50.00	75	59	0.00	0.00	0	0	0.00	0.00	0	0	2	2
dc_rollback_segments	0.01	0.03	200.00	0.43	0.42	-2.33	584	966	0.00	0.00	0	0	0.00	0.00	0	0	39	39
dc_segments	0.42	0.01	-97.62	17.38	0.14	-99.19	23,449	332	0.55	0.00	0	0	0.00	0.00	49	7	1,011	1,178
dc_sequences	0.00	0.00	0.00	0.00	0.00	0.00	1	0	100.00	0.00	0	0	0.00	0.00	1	0	5	7
dc_tablespaces	0.14	0.09	-35.71	5.88	1.26	-78.57	7,940	2,894	0.00	0.00	0	0	0.00	0.00	0	0	83	84
dc_users	0.30	0.22	-26.67	12.25	3.03	-75.27	16,530	6,948	0.01	0.00	0	0	0.00	0.00	0	0	111	118
global database name	0.02	0.05	150.00	0.76	0.71	-6.58	1,021	1,638	0.00	0.00	0	0	0.00	0.00	0	0	1	1
outstanding_alerts	0.00	0.01	100.00	0.12	0.10	-16.67	161	238	0.62	0.00	0	0	0.00	0.00	2	1	80	79
sch_lj_oids	0.00	0.00	0.00	0.00	0.00	0.00	3	3	0.00	0.00	0	0	0.00	0.00	0	0	6	6

Library Cache Activity

Ordered by Namespace

Namespace	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd	1st	2nd
	Get Requests per Sec (DB Time)			Get Requests per Sec (Elapsed Time)			Get Requests		Pct Miss		Pin Requests		Pct Miss		Reloads		Invalidations
APP CONTEXT	0.00	0.00	0.00	0.01	0.00	-100.00	7	0	14.29		7	0	14.29		0	0	0	0
BODY	0.01	0.02	100.00	0.36	0.32	-11.11	488	744	1.23	0.00	1,085	1,413	4.33	0.00	41	0	0	0
CLUSTER	0.00	0.00	0.00	0.03	0.00	-100.00	39	0	2.56		26	0	3.85		0	0	0	0
DBLINK	0.00	0.00	0.00	0.08	0.01	-87.50	105	33	1.90	0.00	0	0			0	0	0	0
EDITION	0.00	0.00	0.00	0.07	0.03	-57.14	88	67	0.00	0.00	162	125	0.00	0.00	0	0	0	0
INDEX	0.00	0.00	0.00	0.02	0.00	-100.00	25	0	56.00		25	0	56.00		0	0	0	0
QUEUE	0.00	0.00	0.00	0.02	0.02	0.00	24	42	0.00	0.00	76	140	0.00	0.00	0	0	0	0
RULESET	0.00	0.00	0.00	0.00	0.00	0.00	2	1	0.00	0.00	2	1	0.00	0.00	0	0	0	0
SCHEMA	0.01	0.00	-100.00	0.26	0.03	-88.46	352	73	0.00	0.00	0	0			0	0	0	0
SQL AREA	0.45	0.04	-91.11	18.69	0.51	-97.27	25,216	1,168	65.88	4.37	152,708	10,786	11.95	0.73	302	0	28	0
SUBSCRIPTION	0.00	0.00	0.00	0.00	0.00	0.00	5	8	0.00	0.00	5	8	0.00	0.00	0	0	0	0
TABLE/PROCEDURE	0.36	0.03	-91.67	14.91	0.39	-97.38	20,126	900	0.39	0.00	29,736	2,188	2.79	0.00	545	0	0	0
TRIGGER	0.00	0.00	0.00	0.01	0.00	-100.00	12	8	8.33	0.00	25	39	16.00	0.00	3	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)	23,424.00	52,992.00	126.23	8,384.00	8,640.00	3.05	-64.21	-83.70
	Used (KB)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Avg Alloc (KB)	2,928.00	736.00	-74.86	931.56	960.00	3.05	-68.18	30.43
	Std Dev Alloc (KB)	6,422.98	402.48	-93.73	1,155.16	1,155.55	0.03	-82.02	187.10
	Max Alloc (KB)	18,752.00	3,776.00	-93.52	3,776.00	3,776.00	0.00	-79.86	210.53
	Hist Max Alloc (KB)
	Num Procs	8.00	72.00	800.00	9.00	9.00	0.00	12.50	-87.50
	Num Alloc	8.00	72.00	800.00	9.00	9.00	0.00	12.50	-87.50
Other	Alloc (KB)	182,578.98	381,281.95	108.83	181,434.63	183,366.63	1.06	-0.63	-51.91
	Used (KB)
	Avg Alloc (KB)	5,216.54	3,050.26	-41.53	5,183.85	5,239.05	1.06	-0.63	71.76
	Std Dev Alloc (KB)	8,454.44	4,755.29	-43.75	8,468.90	8,452.08	-0.20	0.17	77.74
	Max Alloc (KB)	30,454.10	30,454.10	0.00	30,454.10	30,454.10	0.00	0.00	0.00
	Hist Max Alloc (KB)	31,542.10	31,542.10	0.00	31,542.10	31,542.10	0.00	0.00	0.00
	Num Procs	35.00	125.00	257.14	35.00	35.00	0.00	0.00	-72.00
	Num Alloc	35.00	125.00	257.14	35.00	35.00	0.00	0.00	-72.00
PL/SQL	Alloc (KB)	513.28	5,146.34	902.63	498.82	498.82	0.00	-2.82	-90.31
	Used (KB)	408.52	4,438.30	986.43	424.55	424.57	0.01	3.92	-90.43
	Avg Alloc (KB)	15.55	41.84	169.00	15.12	15.12	0.00	-2.82	-63.87
	Std Dev Alloc (KB)	43.51	48.27	10.95	42.95	42.95	0.00	-1.27	-11.02
	Max Alloc (KB)	233.34	233.34	0.00	233.34	233.34	0.00	0.00	0.00
	Hist Max Alloc (KB)	857.01	235.38	-72.54	1,824.60	1,122.10	-38.50	112.90	376.73
	Num Procs	33.00	123.00	272.73	33.00	33.00	0.00	0.00	-73.17
	Num Alloc	33.00	95.00	187.88	33.00	33.00	0.00	0.00	-65.26
SQL	Alloc (KB)	947.62	7,012.80	640.05	762.43	750.42	-1.57	-19.54	-89.30
	Used (KB)	755.75	3,192.62	322.44	673.54	657.77	-2.34	-10.88	-79.40
	Avg Alloc (KB)	72.89	75.41	3.45	58.65	57.72	-1.57	-19.54	-23.45
	Std Dev Alloc (KB)	201.15	89.86	-55.32	172.03	168.72	-1.92	-14.48	87.75
	Max Alloc (KB)	736.20	614.95	-0.52	626.96	614.95	-1.92	-14.84	-16.03
	Hist Max Alloc (KB)	2,172.59	6,209.00	185.79	2,172.59	2,172.59	0.00	0.00	-65.01
	Num Procs	13.00	93.00	615.38	13.00	13.00	0.00	0.00	-86.02
	Num Alloc	8.00	60.00	650.00	7.00	7.00	0.00	-12.50	-88.33

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	430,080.00	434,176.00	0.95	405,504.00	405,504.00	0.00	-5.71	-6.60
Fixed Size	2,165.73	2,165.73	0.00	2,165.73	2,165.73	0.00	0.00	0.00
Redo Buffers	6,564.00	6,564.00	0.00	6,564.00	6,564.00	0.00	0.00	0.00
Variable Size	352,258.27	348,162.27	-1.16	376,834.27	376,834.27	0.00	6.98	8.24

Back to Memory Statistics
Back to Top

SGA Breakdown Difference

ordered by Pool, Name

Pool	Name	Begin Value	End Value	%Diff	Begin Value	End Value	%Diff	Begin Values	End Values
		1st			2nd			%Diff of
java pool	free memory	4,194,304	4,194,304	0.00	4,194,304	4,194,304	0.00	0.00	0.00
large pool	ASM map operations hashta	393,216	393,216	0.00	393,216	393,216	0.00	0.00	0.00
large pool	PX msg pool	6,881,280	6,881,280	0.00	6,881,280	6,881,280	0.00	0.00	0.00
large pool	free memory	1,114,112	1,114,112	0.00	1,114,112	1,114,112	0.00	0.00	0.00
shared pool	ASH buffers	4,194,304	4,194,304	0.00	4,194,304	4,194,304	0.00	0.00	0.00
shared pool	CCUR	23,652,712	26,161,272	10.61	23,889,488	24,076,152	0.78	1.00	-7.97
shared pool	FileOpenBlock	3,978,648	3,978,648	0.00	3,978,648	3,978,648	0.00	0.00	0.00
shared pool	KCB Table Scan Buffer	3,981,120	3,981,120	0.00	3,981,120	3,981,120	0.00	0.00	0.00
shared pool	KGLH0	10,429,360	5,835,880	-44.04	9,056,416	9,024,032	-0.36	-13.16	54.63
shared pool	KGLHD	9,500,840	10,895,072	14.67	11,862,776	11,891,048	0.24	24.86	9.14
shared pool	KGLS	15,751,472	3,903,048	-75.22	12,473,032	12,241,624	-1.86	-20.81	213.64
shared pool	KGLSG	5,264,904	5,264,904	0.00	5,264,904	5,264,904	0.00	0.00	0.00
shared pool	KKSSP		3,149,648
shared pool	KQR L PO	3,773,496
shared pool	KQR M PO	3,296,824
shared pool	KSFD SGA I/O b	3,977,064	3,977,064	0.00	3,977,064	3,977,064	0.00	0.00	0.00
shared pool	PCUR	11,975,832	27,852,280	132.57	21,596,016	21,681,120	0.39	80.33	-22.16
shared pool	PLDIA	5,420,784			4,073,888	4,004,688	-1.70	-24.85
shared pool	PLMCD	12,391,392	6,414,032	-48.24	12,932,800	12,928,752	-0.03	4.37	101.57
shared pool	SQLA	84,548,288	56,747,872	-32.88	87,844,648	88,202,368	0.41	3.90	55.43
shared pool	SQLP	3,486,216
shared pool	dbwriter coalesce buffer	3,979,264	3,979,264	0.00	3,979,264	3,979,264	0.00	0.00	0.00
shared pool	event statistics per sess		3,182,336
shared pool	flashback generation buff	3,981,120	3,981,120	0.00	3,981,120	3,981,120	0.00	0.00	0.00
shared pool	free memory	32,848,048	60,323,576	83.64	45,807,336	45,494,632	-0.68	39.45	-24.58
shared pool	kglsim hash table bkts	4,194,304	4,194,304	0.00	4,194,304	4,194,304	0.00	0.00	0.00
shared pool	private strands	3,677,184	3,677,184	0.00	3,677,184	3,677,184	0.00	0.00	0.00
shared pool	row cache	7,584,808	7,584,808	0.00	7,584,808	7,584,808	0.00	0.00	0.00
streams pool	KTG hash buckets	1,320,432	1,320,432	0.00	1,320,432	1,320,432	0.00	0.00	0.00
streams pool	free memory	2,862,176	2,862,176	0.00	2,862,632	2,862,632	0.00	0.02	0.02
	buffer_cache	440,401,920	444,596,224	0.95	415,236,096	415,236,096	0.00	-5.71	-6.60
	fixed_sga	2,217,712	2,217,712	0.00	2,217,712	2,217,712	0.00	0.00	0.00
	log_buffer	6,721,536	6,721,536	0.00	6,721,536	6,721,536	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.02	0.01	-75.00	0.00	0.00	0.00	0.00	0.00	0.00
QMON Slaves	0.05	0.02	-50.94	0.67	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.67	0.00	0.67	0.00	0.00	0.00	-100.00	0.05	0.02	-50.94
QMON Coordinator	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.02	0.01	-75.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set by Evaluations

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

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

Back to Streams Statistics
Back to Top

Rule Set by Elapsed Time

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

Ruleset Name	1st	2nd	%Diff	1st	2nd	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Ela(s)			No-SQL Eval%		SQL Execs			CPU(s)			Evals			Eval/Sec			SQL per Eval			Ela(s) per Eval			CPU(s) per Eval			Reloads
SYS.ALERT_QUE_R	0	0.00	0.00	0.00	0.00	0	0	0.00	0	0.00	0.00	2	1	-50.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

Back to Streams Statistics
Back to Top

Persistent Queues

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

Queue Name	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	1st	2nd
	Enq Msgs			Deq Msgs			%Delay Msgs		%Exp Msgs		Enq Time(s)			Deq Time(s)			%Transf Time		%Eval Time
SYSMAN.MGMT_TASK_Q(82156)	21	39	85.71	21	39	85.71	0.00	0.00	0.00	0.00	0.60	0.08	-86.67	2.65	1.09	-58.87	0.00	0.00	0.00	0.00
SYS.ALERT_QUE(11324)	2	1	-50.00	0	0	0.00	100.00	100.00	0.00	0.00	0.02	0.00	-100.00	0.00	0.00	0.00	0.00	0.00	4.65	22.08
SYS.AQ$_ALERT_QT_E(11323)	0	0	0.00	0	0	0.00					0.00	0.00	0.00	0.00	0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(82486)	0	0	0.00	0	0	0.00					0.00	0.00	0.00	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

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

Queue Name	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Enqueue Msgs/sec			Dequeue Msgs/sec			Avg Enqueue sec / msg			Avg Dequeue sec / msg
SYS.ALERT_QUE(11324)	0.00	0.00	0.00	0.00	0.00	0.00	0.01	0.00	-100.00			0.00
SYS.AQ$_ALERT_QT_E(11323)	0.00	0.00	0.00	0.00	0.00	0.00			0.00			0.00
SYSMAN.MGMT_NOTIFY_Q(82486)	0.00	0.00	0.00	0.00	0.00	0.00			0.00			0.00
SYSMAN.MGMT_TASK_Q(82156)	0.02	0.02	0.00	0.02	0.02	0.00	0.03	0.00	-100.00	0.13	0.03	-76.92

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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

Subscriber/Queue Name	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff	1st	2nd	%Diff
	Enqueue Msgs			Dequeue Msgs			Expire Msgs			Enqueue Msgs/sec			Dequeue Msgs/sec			Expire Msgs/sec
B1GR2BASE_3938_ORCL(62)/SYS.ALERT_QUE	2	1	-50.00	0	0	0.00	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
TRAINING_1830_ORCL(41)/SYS.ALERT_QUE	2	1	-50.00	0	0	0.00	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
TRAINING_3872_ORCL(61)/SYS.ALERT_QUE	2	1	-50.00	0	0	0.00	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0.00	0	0	0.00	0	0	0.00			0.00			0.00			0.00

Back to Streams Statistics
Back to Top

Shared Server Statistics

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

Shared Servers Activity

Values represent averages for all samples

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

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

Total Server Time (s)			%Busy			%Idle			Incoming Net %			Outgoing Net %
1st	2nd	%Diff	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	Diff	1st	2nd	Diff
1,358	2,295	69.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

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	440401920	444596224		415236096
__java_pool_size		4194304
__large_pool_size		8388608
__oracle_base		/u01/app/oracle
__pga_aggregate_target		159383552
__sga_target		788529152
__shared_io_pool_size		0
__shared_pool_size	318767104	314572800		343932928
__streams_pool_size		4194304
_enable_automatic_maintenance		0
audit_file_dest		/u01/app/oracle/admin/orcl/adump
audit_trail		DB
compatible		11.2.0.0.0
control_files		+DATA/orcl/controlfile/current.2
db_block_size		8192
db_cache_size		394264576
db_create_file_dest		+DATA
db_create_online_log_dest_1		+DATA
db_domain
db_name		orcl
db_recovery_file_dest		+FRA
db_recovery_file_dest_size		17179869184
diagnostic_dest		/u01/app/oracle
dispatchers		(PROTOCOL=TCP) (SERVICE=orclXDB)
java_pool_size		4194304
job_queue_processes		1000
large_pool_size		4194304
open_cursors		300
pga_aggregate_target		157286400
processes		150
remote_login_passwordfile		EXCLUSIVE
resource_manager_plan
service_names		orcl, OLTP, DSS, ADHOC, BATCH_ST
sga_max_size		813694976
sga_target		788529152
shared_pool_size		134217728
streams_pool_size		4194304
timed_statistics		TRUE
undo_tablespace		UNDOTBS1

Complete List of SQL Text

SQL Id SQL Text

07yqdn45g0uwp SELECT l_returnflag, l_linestatus, sum(l_quantity) AS SUM_QTY, SUM(l_extendedprice) AS SUM_BASE_PRICE, SUM(l_extendedprice * (1 - l_discount)) AS SUM_DISC_PRICE, SUM(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS SUM_CHARGE, AVG(l_quantity) AS AVG_QTY, AVG(l_extendedprice) AS AVG_PRICE, AVG(l_discount) AS AVG_DISC, COUNT(*) AS COUNT_ORDER FROM H_Lineitem WHERE l_shipdate <= to_date ('1998-12-01', 'YYYY-MM-DD') - 114 GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus

089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

08vznc16ycuag SELECT SYS_GUID() FROM SYS.DUAL

09zd7hgsfrdg6 SELECT l_returnflag, l_linestatus, sum(l_quantity) AS SUM_QTY, SUM(l_extendedprice) AS SUM_BASE_PRICE, SUM(l_extendedprice * (1 - l_discount)) AS SUM_DISC_PRICE, SUM(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS SUM_CHARGE, AVG(l_quantity) AS AVG_QTY, AVG(l_extendedprice) AS AVG_PRICE, AVG(l_discount) AS AVG_DISC, COUNT(*) AS COUNT_ORDER FROM H_Lineitem WHERE l_shipdate <= to_date ('1998-12-01', 'YYYY-MM-DD') - 109 GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus

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

0m78skf1mudnb select audit$, properties from type_misc$ where obj#=:1

0n3h2c1ufzma4 SELECT COLLECTION_TIMESTAMP, ROWID FROM MGMT_LAST_VIOLATION WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND KEY_VALUE = :B1

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

111xpqwr0sfjg Begin Update E_Trade Set T_COMM = :comm_amount, T_DTS = To_Date(:trade_dts, 'mm/dd/YYYY'), T_ST_ID = :comp_id, T_TRADE_PRICE = :trade_price Where T_ID = :trade_id; Insert Into E_TRADE_HISTORY(TH_T_ID, TH_DTS, TH_ST_ID) Values( :trade_id, to_date(:trade_dts, 'mm/dd/YYYY'), :comp_id); Update E_BROKER Set B_COMM_TOTAL = B_COMM_TOTAL + :comm_amount, B_NUM_TRADES = B_NUM_TRADES + 1 Where B_ID = :broker_id;End;

12qmb2vstfhgy SELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1993-07-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-07-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC

15p4z9yvdc8ua SELECT T_EXEC_NAME, T_BID_PRICE, T_TRADE_PRICE, T_IS_CASH, TT_IS_MRKT FROM E_TRADE, E_TRADE_TYPE WHERE T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND T_TT_ID = TT_ID AND ROWNUM <= :B1

1809cng2r987s SELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1995-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1995-01-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC

18naypzfmabd6 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))

1ba09vhjx4rxj SELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-10', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-10', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

1fwcc9b0mbzum SELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-20', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-20', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

1gkn6r4rbdkmy SELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1997-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1997-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1x255a7m968k7 SELECT supp_nation, cust_nation, L_YEAR, SUM(VOLUME) AS REVENUE FROM (SELECT N1.n_name supp_nation, N2.n_name cust_nation, to_number(to_char(l_shipdate, 'YYYY')) AS L_YEAR, l_extendedprice * (1 - l_discount) VOLUME FROM H_Supplier, H_Lineitem, H_Order, H_Customer, H_Nation N1, H_Nation N2 WHERE s_suppkey = l_suppkey AND o_orderkey = l_orderkey AND c_custkey = o_custkey AND s_nationkey = N1.n_nationkey AND c_nationkey = N2.n_nationkey AND ((N1.n_name = 'ALGERIA' AND N2.n_name = 'CANADA') OR (N1.n_name = 'CANADA' AND N2.n_name = 'ALGERIA')) AND l_shipdate BETWEEN to_date( '1995-01-01', 'YYYY-MM-DD') AND to_date( '1996-12-31', 'YYYY-MM-DD') ) SHIPPING GROUP BY supp_nation, cust_nation, L_YEAR ORDER BY supp_nation, cust_nation, L_YEAR

21mdxpk0d7jt7 UPDATE E_BROKER SET B_COMM_TOTAL = B_COMM_TOTAL + :B1 , B_NUM_TRADES = B_NUM_TRADES + 1 WHERE B_ID = :B2

25fu98m3hw2ts SELECT VALUE FROM MGMT_CURRENT_METRICS A, MGMT_METRICS B, MGMT_TARGETS C WHERE B.TARGET_TYPE = :B3 AND A.METRIC_GUID = B.METRIC_GUID AND B.METRIC_COLUMN = :B2 AND B.METRIC_NAME = :B1 AND C.TYPE_META_VER = B.TYPE_META_VER AND (B.CATEGORY_PROP_1 = C.CATEGORY_PROP_1 OR B.CATEGORY_PROP_1 = ' ') AND (B.CATEGORY_PROP_2 = C.CATEGORY_PROP_2 OR B.CATEGORY_PROP_2 = ' ') AND (B.CATEGORY_PROP_3 = C.CATEGORY_PROP_3 OR B.CATEGORY_PROP_3 = ' ') AND (B.CATEGORY_PROP_4 = C.CATEGORY_PROP_4 OR B.CATEGORY_PROP_4 = ' ') AND (B.CATEGORY_PROP_5 = C.CATEGORY_PROP_5 OR B.CATEGORY_PROP_5 = ' ')

2mw82wp65dyv5 SELECT S_NAME, CO_ID, CO_NAME, CO_SP_RATE, CO_CEO, CO_DESC, CO_OPEN_DATE, CO_ST_ID, NVL(CA.AD_LINE1, CHR(0)), NVL(CA.AD_LINE2, CHR(0)), ZCA.ZC_TOWN, ZCA.ZC_DIV, CA.AD_ZC_CODE, NVL(CA.AD_CTRY, CHR(0)), S_NUM_OUT, S_START_DATE, S_EXCH_DATE, S_PE, S_52WK_HIGH, S_52WK_HIGH_DATE, S_52WK_LOW, S_52WK_LOW_DATE, S_DIVIDEND, S_YIELD, NVL(EA.AD_LINE1, CHR(0)), NVL(EA.AD_LINE2, CHR(0)), ZEA.ZC_TOWN, ZEA.ZC_DIV, NVL(EA.AD_CTRY, CHR(0)), EA.AD_ZC_CODE, NVL(EX_DESC, CHR(0)), EX_NAME, EX_NUM_SYMB, EX_OPEN, EX_CLOSE FROM E_SECURITY, E_COMPANY, E_ADDRESS CA, E_ADDRESS EA, E_ZIP_CODE ZCA, E_ZIP_CODE ZEA, E_EXCHANGE WHERE S_SYMB = :B1 AND CO_ID = S_CO_ID AND CA.AD_ID = CO_AD_ID AND EA.AD_ID = EX_AD_ID AND EX_ID = S_EX_ID AND CA.AD_ZC_CODE = ZCA.ZC_CODE AND EA.AD_ZC_CODE = ZEA.ZC_CODE

2uzp6kw11g1su SELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1996-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1996-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC

2vcn91b1wtmc6 SELECT TH_DTS, TH_ST_ID FROM E_TRADE_HISTORY WHERE TH_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND ROWNUM <= (3 * :B1 ) ORDER BY TH_DTS

309b84z4mv9jb SELECT SE_CASH_TYPE, SE_CASH_DUE_DATE, SE_AMT FROM E_SETTLEMENT WHERE SE_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND ROWNUM <= :B1

318ng5h3q5x79 Select T_BID_PRICE, T_EXEC_NAME, Decode(T_IS_CASH, 'Y', 1, 'N', 0), T_ID, NVL(T_TRADE_PRICE, 0) From E_TRADE Where T_CA_ID = :acct_id And T_DTS >= to_date(:start_dts, 'mm/dd/YYYY') And T_DTS <= to_date(:end_dts, 'mm/dd/YYYY') And Rownum <= :max_trades order by T_DTS asc

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

37h9f39wxj92r SELECT NI_HEADLINE, NI_SUMMARY, NI_DTS, NI_SOURCE, NVL(NI_AUTHOR, CHR(0)) FROM E_NEWS_XREF, E_NEWS_ITEM WHERE NI_ID = NX_NI_ID AND NX_CO_ID = :B1 AND ROWNUM <= 2

3904n1ntv7txj Select T_BID_PRICE, T_EXEC_NAME, Case When T_IS_CASH = 'Y' Then 1 Else 0 End, TT_IS_MRKT, NVL(T_TRADE_PRICE, 0) From E_TRADE, E_TRADE_TYPE Where T_ID = :trade_id And T_TT_ID = TT_ID

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

39pvzrsczv31x SELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1993-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1993-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC

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

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

45cngnmv709m4 select subscriber_id, name, address, protocol, subscriber_type, rule_name, trans_name, ruleset_name, negative_ruleset_name, creation_time, deletion_time, modification_time, scn_at_remove , scn_at_add from AQ$_SUBSCRIBER_TABLE where queue_name=:1 and schema=:2 and bitand(subscriber_type, 2) = 2

48ay2b94rz41x SELECT DM_DATE, DM_CLOSE, DM_HIGH, DM_LOW, DM_VOL FROM E_DAILY_MARKET WHERE DM_S_SYMB = :B3 AND DM_DATE >= TO_DATE(:B2 , 'mm/dd/YYYY') AND ROWNUM <= :B1 ORDER BY DM_DATE ASC

4j9awnaff2xjr SELECT LT_PRICE FROM E_LAST_TRADE WHERE LT_S_SYMB = :symbol

4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POL ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC

4ttpsft97zujk SELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-24', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-24', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

58h9dvw8qzy7w SELECT T_ID FROM E_TRADE WHERE T_CA_ID = :B4 AND T_DTS BETWEEN TO_DATE(:B3 , 'mm/dd/YYYY') AND TO_DATE(:B2 , 'mm/dd/YYYY') AND ROWNUM <= :B1 ORDER BY T_DTS

59ahdunmw6xbz SELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-22', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-22', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

5jctjh9wmayy6 SELECT T_ID FROM E_TRADE WHERE T_CA_ID = :B2 AND T_DTS >= TO_DATE(:B1 , 'mm/dd/YYYY') AND ROWNUM <= 1 ORDER BY T_DTS ASC

5n1fs4m2n2y0r select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1

5pnb5ryzbx5xx SELECT TH_DTS, T_QTY, T_S_SYMB, T_ID, ST_NAME From (Select T_ID As ID From E_TRADE Where T_CA_ID = :acct_id And Rownum <= 10 Order By T_DTS DESC), E_TRADE, E_TRADE_HISTORY, E_STATUS_TYPE Where T_ID = ID And TH_T_ID = T_ID And ST_ID = TH_ST_ID Order by TH_DTS Desc

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

6dafh4gs0k2jc Declare ex_name Varchar2(65); Begin If :num_update < :max_updates Then Select Trim(T_EXEC_NAME) Into ex_name From E_TRADE Where T_ID = :trade_id; :num_found := :num_found + SQL%ROWCOUNT; If ex_name Like '% X %' Then ex_name := Replace(ex_name, ' X ', ' '); Else ex_name := Replace(ex_name, ' ', ' X '); End If; Update E_TRADE Set T_EXEC_NAME = ex_name Where T_ID = :trade_id; :num_update := :num_update + SQL%ROWCOUNT; End If;End;

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6h7xku2zvpgsh Select T_CA_ID, T_EXEC_NAME, Decode(T_IS_CASH, 'Y', 1, 'N', 0), NVL(T_TRADE_PRICE, 0) TRADE_PRICE, T_QTY, Trim(S_NAME), T_DTS, T_ID, T_TT_ID, TT_NAME From E_TRADE, E_TRADE_TYPE, E_SECURITY Where T_S_SYMB = :symbol And T_DTS >= to_date(:start_dts, 'mm/dd/YYYY') And T_DTS <= to_date(:end_dts, 'mm/dd/YYYY') And TT_ID = T_TT_ID And S_SYMB = T_S_SYMB And Rownum <= :max_trades Order By T_DTS Asc

6qz82dptj0qr7 select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc

6uusdb8z8usyu SELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-15', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-15', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

6w6tz0ppcxb7u SELECT WI_S_SYMB FROM E_WATCH_ITEM, E_WATCH_LIST WHERE WI_WL_ID = WL_ID AND WL_C_ID = :B1

6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC

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

72vydb3ncbn3s DECLARE trades E_TradeList; BEGIN SELECT T_ID BULK COLLECT INTO trades FROM E_TRADE WHERE T_CA_ID = :acct_id AND T_DTS BETWEEN TO_DATE(:start_trade_dts, 'mm/dd/YYYY') AND TO_DATE(:end_trade_dts, 'mm/dd/YYYY') AND ROWNUM <= :maxtrades ORDER BY T_DTS; OPEN :t_cursor for SELECT T_ID, T_EXEC_NAME, T_BID_PRICE, T_TRADE_PRICE, T_IS_CASH, TT_IS_MRKT FROM E_TRADE, E_TRADE_TYPE WHERE T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) and T_TT_ID = TT_ID AND ROWNUM <= :maxtrades; OPEN :se_cursor for SELECT SE_CASH_TYPE, SE_CASH_DUE_DATE, SE_AMT FROM E_SETTLEMENT WHERE SE_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND ROWNUM <= :maxtrades; OPEN :ct_cursor for SELECT T_ID, T_IS_CASH, CT_AMT, CT_NAME, CT_DTS FROM E_CASH_TRANSACTION, E_TRADE WHERE CT_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND T_ID = CT_T_ID AND T_IS_CASH = 'Y' AND ROWNUM <= :maxtrades; OPEN :th_cursor for SELECT TH_DTS, TH_ST_ID FROM E_TRADE_HISTORY WHERE TH_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND ROWNUM <= (3 * :maxtrades) ORDER BY TH_DTS; END;

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

7rq305gd2gpzw SELECT S_NUM_OUT FROM E_SECURITY WHERE S_SYMB = :symbol

7vnf1z0t36s99 SELECT C_ID FROM E_CUSTOMER WHERE C_TAX_ID = :B1

7yphsb8fr4vus Select SE_AMT, to_char(SE_CASH_DUE_DATE, 'mm/dd/YYYY'), SE_CASH_TYPE From E_SETTLEMENT Where SE_T_ID = :trade_id

83vnfyd1m59nq DECLARE tradeid INT; BEGIN SELECT T_ID INTO tradeid FROM E_TRADE WHERE T_CA_ID = :acct_id AND T_DTS >= to_date(:start_trade_dts, 'mm/dd/YYYY') AND ROWNUM <= 1 ORDER BY T_DTS ASC; OPEN :hh_cursor for SELECT HH_H_T_ID, HH_T_ID, HH_BEFORE_QTY, HH_AFTER_QTY FROM E_HOLDING_HISTORY WHERE HH_H_T_ID = tradeid AND ROWNUM <= :maxtrades; END;

84nxzpqwn91j5 Select to_char(TH_DTS, 'mm/dd/YYYY'), TH_ST_ID From E_TRADE_HISTORY Where TH_T_ID = :trade_id order by TH_DTS

8h5jmzqcfpgzb SELECT CT_AMT, CT_NAME, CT_DTS FROM E_CASH_TRANSACTION, E_TRADE WHERE CT_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND T_ID = CT_T_ID AND T_IS_CASH = 'Y' AND ROWNUM <= :B1

8v93w0n1dm76k SELECT DM_CLOSE FROM E_DAILY_MARKET WHERE DM_S_SYMB = :symbol AND DM_DATE = to_date(:dm_date, 'mm/dd/YYYY')

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

95rzx549dbvs5 SELECT NATION, O_YEAR, SUM(AMOUNT) SUM_PROFIT FROM (SELECT n_name NATION, to_number(TO_CHAR (o_orderdate, 'YYYY')) AS O_YEAR , l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity AS AMOUNT FROM H_Part, H_Supplier, H_Lineitem, H_Partsupp, H_Order, H_Nation WHERE s_suppkey = l_suppkey AND ps_suppkey = l_suppkey AND ps_partkey = l_partkey AND p_partkey = l_partkey AND o_orderkey = l_orderkey AND s_nationkey = n_nationkey AND p_name LIKE '%almond%' ) PROFIT GROUP BY NATION, O_YEAR ORDER BY NATION, O_YEAR DESC

9ba2vwvw6z4z8 SELECT C_L_NAME, C_F_NAME, B_NAME FROM E_CUSTOMER_ACCOUNT, E_CUSTOMER, E_BROKER WHERE CA_ID = :B1 AND C_ID = CA_C_ID AND B_ID = CA_B_ID

9tgj4g8y4rwy8 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

9wfnvt8hnx49f SELECT CO_NAME, IN_NAME FROM E_COMPANY_COMPETITOR, E_COMPANY, E_INDUSTRY WHERE CP_CO_ID = :B1 AND CO_ID = CP_COMP_CO_ID AND IN_ID = CP_IN_ID

9xcdxpqrhsvmx SELECT l_returnflag, l_linestatus, sum(l_quantity) AS SUM_QTY, SUM(l_extendedprice) AS SUM_BASE_PRICE, SUM(l_extendedprice * (1 - l_discount)) AS SUM_DISC_PRICE, SUM(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS SUM_CHARGE, AVG(l_quantity) AS AVG_QTY, AVG(l_extendedprice) AS AVG_PRICE, AVG(l_discount) AS AVG_DISC, COUNT(*) AS COUNT_ORDER FROM H_Lineitem WHERE l_shipdate <= to_date ('1998-12-01', 'YYYY-MM-DD') - 119 GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus

ab3swhv5g138y select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID

afy3mzh484trw SELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-06', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-06', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

agz7fu32m6qn4 SELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1994-10-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1994-10-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC

bfk319z4wc782 SELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1995-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1995-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC

bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1

bqjghjzaphzb2 SELECT T_CHRG, T_EXEC_NAME, EX_NAME, S_NAME, ST_NAME, T_S_SYMB, T_DTS, T_ID, T_QTY, TT_NAME FROM E_TRADE, E_STATUS_TYPE, E_TRADE_TYPE, E_SECURITY, E_EXCHANGE WHERE T_CA_ID = :B1 AND ST_ID = T_ST_ID AND TT_ID = T_TT_ID AND S_SYMB = T_S_SYMB AND EX_ID = S_EX_ID AND ROWNUM <= 50 ORDER BY T_DTS DESC

c0chxpnujy8td SELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1994-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1994-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC

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

c71khx643vgxb SELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1993-09-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-09-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC

c8h3jdwaa532q SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

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

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

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

d8mayxqw0wnpv SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'

dbf6bmt9at48f SELECT FI_YEAR, FI_QTR, FI_QTR_START_DATE, FI_REVENUE, FI_NET_EARN, FI_BASIC_EPS, FI_DILUT_EPS, FI_MARGIN, FI_INVENTORY, FI_ASSETS, FI_LIABILITY, FI_OUT_BASIC, FI_OUT_DILUT FROM E_FINANCIAL WHERE FI_CO_ID = :B1 AND ROWNUM <= 20 ORDER BY FI_YEAR ASC, FI_QTR

fdjtrdaz8hpvg INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a. flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')

fjpgrrp53dtxj SELECT B_NAME, NVL(SUM(TR_QTY * TR_BID_PRICE), 0) FROM E_BROKER, E_TRADE_REQUEST, E_SECURITY, E_COMPANY, E_INDUSTRY, E_SECTOR WHERE B_NAME IN (:broker1, :broker2, :broker3, :broker4, :broker5, :broker6, :broker7, :broker8, :broker9, :broker10, :broker11, :broker12, :broker13, :broker14, :broker15, :broker16, :broker17, :broker18, :broker19, :broker20, :broker21, :broker22, :broker23, :broker24, :broker25, :broker26, :broker27, :broker28, :broker29, :broker30, :broker31, :broker32, :broker33, :broker34, :broker35, :broker36, :broker37, :broker38, :broker39, :broker40) AND B_ID = TR_B_ID AND TR_S_SYMB = S_SYMB AND S_CO_ID = CO_ID AND CO_IN_ID = IN_ID AND IN_SC_ID = SC_ID AND SC_NAME = :sector_name GROUP BY B_NAME ORDER BY 2 DESC

fps40s3v7nd3r SELECT O_YEAR, SUM(DECODE(NATION, 'ALGERIA', VOLUME, 0)) / SUM(VOLUME) AS MKT_SHARE FROM (SELECT to_number(TO_CHAR(o_orderdate, 'YYYY')) AS O_YEAR, l_extendedprice * (1 - l_discount) VOLUME, N2.n_name NATION FROM H_Part, H_Supplier, H_Lineitem, H_Order, H_Customer, H_Nation N1, H_Nation N2, H_Region WHERE p_partkey = l_partkey AND s_suppkey = l_suppkey AND l_orderkey = o_orderkey AND o_custkey = c_custkey AND c_nationkey = N1.n_nationkey AND N1.n_regionkey = r_regionkey AND r_name = 'AFRICA' AND s_nationkey = N2.n_nationkey AND o_orderdate BETWEEN to_date ('1995-01-01', 'YYYY-MM-DD') AND to_date ('1996-12-31', 'YYYY-MM-DD') AND p_type = 'STANDARD ANODIZED TIN') ALL_NATIONS GROUP BY O_YEAR ORDER BY O_YEAR

fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

g4gkdzc5fb01z Select CT_AMT, to_char(CT_DTS, 'mm/dd/YYYY') , Nvl(CT_NAME, chr(0)) From E_CASH_TRANSACTION Where CT_T_ID = :trade_id

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

gcph0kd36arc6 SELECT /*+ ORDERED PUSH_SUBQ */ DISTINCT D.PROFILE_NAME, D.DEVICE_NAME, D.TYPE, D.STATUS, D.PROGRAM, CFG.OWNER, CFG.RULE_NAME, DECODE(D.TYPE, :B29 , D.PROFILE_NAME, :B28 , D.PROFILE_NAME, CFG.OWNER) CHECKUSER FROM (SELECT RULE_NAME, OWNER FROM MGMT_NOTIFY_RULE_CONFIGS C WHERE ((:B26 LIKE C.TARGET_TYPE ESCAPE :B21 AND :B25 LIKE C.TARGET_NAME ESCAPE :B21 ) OR (C.TARGET_GUID IS NOT NULL AND EXISTS (SELECT 1 FROM MGMT_FLAT_TARGET_ASSOC A, MGMT_TARGETS T WHERE A.SOURCE_TARGET_GUID = C.TARGET_GUID AND A.IS_MEMBERSHIP = 1 AND A.ASSOC_TARGET_GUID = T.TARGET_GUID AND T.TARGET_TYPE = C.TARGET_TYPE AND T.TARGET_NAME = :B25 ))) AND :B24 LIKE C.METRIC_NAME ESCAPE :B21 AND :B23 LIKE C.METRIC_COLUMN ESCAPE :B21 AND ((:B22 LIKE C.KEY_VALUE ESCAPE :B21 ) OR (C.KEY_VALUE <> ' ' AND EXISTS (SELECT 1 FROM MGMT_METRICS_COMPOSITE_KEYS K WHERE K.COMPOSITE_KEY = :B22 AND NVL(K.KEY_PART1_VALUE, ' ') LIKE C.KEY_PART_1 ESCAPE :B21 AND NVL(K.KEY_PART2_VALUE, ' ') LIKE C.KEY_PART_2 ESCAPE :B21 AND NVL(K.KEY_PART3_VALUE, ' ') LIKE C.KEY_PART_3 ESCAPE :B21 AND NVL(K.KEY_PART4_VALUE, ' ') LIKE C.KEY_PART_4 ESCAPE :B21 AND NVL(K.KEY_PART5_VALUE, ' ') LIKE C.KEY_PART_5 ESCAPE :B21 AND K.TARGET_GUID = :B27 ))) AND ((:B4 = -1 AND ( (:B2 = :B20 AND WANT_TARGET_UNREACHABLE_START = 1) OR (:B2 = :B19 AND WANT_TARGET_UNREACHABLE_END = 1) OR (:B2 = :B18 AND WANT_TARGET_BLACKOUT_START = 1) OR (:B2 = :B17 AND WANT_TARGET_BLACKOUT_END = 1) OR (:B2 = :B16 AND ((WANT_TARGET_METRIC_ERR_START = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_START = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_START = 3))) OR (:B2 = :B15 AND ((WANT_TARGET_METRIC_ERR_END = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_END = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_END = 3))) OR (:B2 = :B1 AND WANT_CLEARS = 1 AND :B14 <> 1) OR (:B2 = :B1 AND WANT_TARGET_UP = 1 AND :B14 = 1) OR (:B2 = :B6 AND WANT_WARNINGS = 1) OR (:B2 = :B5 AND WANT_CRITICAL_ALERTS = 1 AND :B14 <> 1) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 0) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 1 AND :B11 NOT IN (:B10 , :B9 )) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 0 AND :B11 IN (:B10 , :B9 )) OR ((:B2 = :B8 OR :B2 = :B6 OR :B2 = :B5 ) AND WANT_POLICY_VIOLATIONS = 1 ) OR (:B2 = :B1 AND WANT_POLICY_CLEARS = 1 ) ) ) OR (:B4 <> -1 AND ( (:B4 = :B7 AND :B2 = :B6 AND WANT_WARNING_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 = :B5 AND WANT_CRITICAL_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 <> :B1 AND WANT_POLICY_JOB_SUCCEEDED = 1) OR (:B4 = :B3 AND :B2 = :B6 AND WANT_WARNING_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 = :B5 AND WANT_CRITICAL_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 <> :B1 AND WANT_POLICY_JOB_PROBLEMS = 1) ) ) )) CFG, MGMT_NOTIFY_NOTIFYEES N, MGMT_NOTIFY_DEVICES D WHERE N.RULE_NAME = CFG.RULE_NAME AND N.OWNER = CFG.OWNER AND ((D.DEVICE_NAME = N.DEVICE_NAME AND D.PROFILE_NAME = N. PROFILE_NAME) OR (N.DEVICE_NAME = ' ' AND D.PROFILE_NAME = N.PROFILE_NAME AND D.TYPE IN (:B29 , :B28 ) ) ) ORDER BY CHECKUSER

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

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

gzjm68u0xahd4 SELECT LT_PRICE, LT_OPEN_PRICE, LT_VOL FROM E_LAST_TRADE WHERE LT_S_SYMB = :B1

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