WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ORCL 1200893776 orcl 1 23-Nov-10 18:11 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORCL	1200893776	orcl	1	23-Nov-10 18:11	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

11gR2Base Linux x86 64-bit 2 1.96

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
11gR2Base	Linux x86 64-bit	2			1.96

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 2207 24-Nov-10 21:18:33 33 1.0

End Snap: 2208 24-Nov-10 21:56:44 33 1.0

Elapsed: 38.19 (mins)

DB Time: 537.81 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2207	24-Nov-10 21:18:33	33	1.0
End Snap:	2208	24-Nov-10 21:56:44	33	1.0
Elapsed:		38.19 (mins)
DB Time:		537.81 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 396M 396M Std Block Size: 8K

Shared Pool Size: 328M 328M Log Buffer: 6,564K

	Begin	End
Buffer Cache:	396M	396M	Std Block Size:	8K
Shared Pool Size:	328M	328M	Log Buffer:	6,564K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 14.1 145.4 4.10 0.09

DB CPU(s): 0.6 6.2 0.17 0.00

Redo size: 1,642.8 16,954.0

Logical reads: 7,758.1 80,067.0

Block changes: 3.2 32.7

Physical reads: 12,137.9 125,268.4

Physical writes: 263.9 2,723.1

User calls: 160.0 1,651.1

Parses: 2.3 23.7

Hard parses: 0.0 0.1

W/A MB processed: 1.2 12.3

Logons: 0.1 0.7

Executes: 3.4 35.4

Rollbacks: 0.0 0.0

Transactions: 0.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	14.1	145.4	4.10	0.09
DB CPU(s):	0.6	6.2	0.17	0.00
Redo size:	1,642.8	16,954.0
Logical reads:	7,758.1	80,067.0
Block changes:	3.2	32.7
Physical reads:	12,137.9	125,268.4
Physical writes:	263.9	2,723.1
User calls:	160.0	1,651.1
Parses:	2.3	23.7
Hard parses:	0.0	0.1
W/A MB processed:	1.2	12.3
Logons:	0.1	0.7
Executes:	3.4	35.4
Rollbacks:	0.0	0.0
Transactions:	0.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

Buffer Hit %: 99.93 In-memory Sort %: 99.70

Library Hit %: 99.46 Soft Parse %: 99.41

Execute to Parse %: 33.15 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 9.37 % Non-Parse CPU: 99.93

Shared Pool Statistics

Begin End

Memory Usage %: 86.68 86.77

% SQL with executions>1: 92.12 91.48

% Memory for SQL w/exec>1: 90.46 90.68

	Begin	End
Memory Usage %:	86.68	86.77
% SQL with executions>1:	92.12	91.48
% Memory for SQL w/exec>1:	90.46	90.68

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
direct path write temp	86,267	17,790	206	55.13	User I/O
direct path read	139,711	6,875	49	21.30	User I/O
direct path read temp	1,530,266	6,208	4	19.24	User I/O
DB CPU		1,367		4.24
log file sync	60	4	72	0.01	Commit

Host CPU (CPUs: 2 Cores: Sockets: )

Load Average Begin Load Average End %User %System %WIO %Idle

0.11 3.55 12.0 19.3 59.5 67.5

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.11	3.55	12.0	19.3	59.5	67.5

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

30.2 93.0 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
30.2	93.0	0.0

Begin End

Host Mem (MB): 2,011.4 2,011.4

SGA use (MB): 752.0 752.0

PGA use (MB): 186.6 188.7

% Host Mem used for SGA+PGA: 46.66 46.77

	Begin	End
Host Mem (MB):	2,011.4	2,011.4
SGA use (MB):	752.0	752.0
PGA use (MB):	186.6	188.7
% Host Mem used for SGA+PGA:	46.66	46.77

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 32268.7s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	32,214.50	99.83
DB CPU	1,366.87	4.24
PL/SQL execution elapsed time	21.08	0.07
parse time elapsed	11.37	0.04
hard parse elapsed time	2.75	0.01
connection management call elapsed time	1.94	0.01
repeated bind elapsed time	0.00	0.00
DB time	32,268.75
background elapsed time	77.36
background cpu time	6.80

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	147,738
IDLE_TIME	306,590
IOWAIT_TIME	270,520
NICE_TIME	69
SYS_TIME	87,501
USER_TIME	54,621
LOAD	0	4
PHYSICAL_MEMORY_BYTES	2,109,128,704
NUM_CPUS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
24-Nov 21:18:33	0.11
24-Nov 21:56:44	3.55	32.52	12.02	19.26	67.48	59.54

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 100.0% of Total DB time 32,268.75 (s)
Total FG Wait Time: 30,890.47 (s) DB CPU time: 1,366.87 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	1,756,800	0	30,882	18	95.70
DB CPU			1,367		4.24
Commit	60	0	4	72	0.01
Concurrency	72	0	2	30	0.01
Network	365,942	0	2	0	0.01
System I/O	506	0	0	1	0.00
Other	766	97	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
direct path write temp	86,267	0	17,790	206	388.59	55.13
direct path read	139,711	0	6,875	49	629.33	21.30
direct path read temp	1,530,266	0	6,208	4	6,893.09	19.24
log file sync	60	0	4	72	0.27	0.01
db file sequential read	282	0	4	15	1.27	0.01
read by other session	45	0	2	52	0.20	0.01
db file parallel read	22	0	2	97	0.10	0.01
SQL*Net message to client	365,942	0	2	0	1,648.39	0.01
latch: shared pool	26	0	1	33	0.12	0.00
latch: cache buffers chains	25	0	1	28	0.11	0.00
library cache: mutex X	20	0	1	29	0.09	0.00
control file sequential read	498	0	0	1	2.24	0.00
Disk file operations I/O	204	0	0	1	0.92	0.00
latch free	16	0	0	2	0.07	0.00
asynch descriptor resize	741	100	0	0	3.34	0.00
direct path write	2	0	0	7	0.01	0.00
flashback log file sync	1	0	0	12	0.00	0.00
latch: object queue header operation	1	0	0	8	0.00	0.00
CSS initialization	1	0	0	8	0.00	0.00
CSS operation: action	1	0	0	2	0.00	0.00
jobq slave wait	4,818	100	2,412	501	21.70
SQL*Net message from client	365,942	0	1,909	5	1,648.39

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
db file parallel write	750	0	17	23	3.38	22.47
os thread startup	89	0	13	146	0.40	16.82
log file parallel write	446	0	9	20	2.01	11.73
ASM file metadata operation	638	0	7	11	2.87	8.77
flashback log file sync	12	42	6	489	0.05	7.59
control file parallel write	840	0	5	6	3.78	6.32
control file sequential read	3,461	0	4	1	15.59	4.78
flashback log file write	64	0	2	24	0.29	1.97
CSS initialization	3	0	0	130	0.01	0.50
db file sequential read	64	0	0	6	0.29	0.47
Disk file operations I/O	298	0	0	1	1.34	0.31
flashback log file read	20	0	0	8	0.09	0.20
log file sync	3	0	0	48	0.01	0.19
direct path read	3	0	0	35	0.01	0.14
direct path write	4	0	0	24	0.02	0.12
latch free	5	0	0	9	0.02	0.06
CSS operation: action	3	0	0	5	0.01	0.02
SQL*Net more data from client	16	0	0	1	0.07	0.01
asynch descriptor resize	107	100	0	0	0.48	0.01
kfk: async disk IO	689	0	0	0	3.10	0.01
CSS operation: query	18	0	0	0	0.08	0.01
SQL*Net more data to client	16	0	0	0	0.07	0.00
rdbms ipc message	11,714	96	40,117	3425	52.77
DIAG idle wait	4,578	100	4,582	1001	20.62
smon timer	8	100	2,400	300006	0.04
dispatcher timer	39	100	2,340	60004	0.18
Streams AQ: qmn coordinator idle wait	164	50	2,296	14002	0.74
Streams AQ: qmn slave idle wait	84	0	2,296	27338	0.38
Space Manager: slave idle wait	459	99	2,292	4995	2.07
ASM background timer	509	0	2,292	4503	2.29
wait for unread message on broadcast channel	2,290	100	2,292	1001	10.32
pmon timer	860	89	2,291	2664	3.87
shared server idle wait	76	100	2,280	30004	0.34
class slave wait	26	0	1,196	45995	0.12
KSV master wait	20	0	6	315	0.09
SQL*Net message from client	64	0	1	13	0.29

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%; value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ASM file metadata operation	639	95.1	1.3	.9	.8	.5	.2	1.1	.2
CSS initialization	4				25.0			75.0
CSS operation: action	4		25.0	25.0	50.0
CSS operation: query	24	91.7	8.3
Disk file operations I/O	502	82.9	12.5	2.4	.2	.6	1.4
LGWR wait for redo copy	2	100.0
SQL*Net message to client	366K	100.0	.0	.0
SQL*Net more data from client	16	93.8		6.3
SQL*Net more data to client	16	100.0
asynch descriptor resize	848	99.5	.1	.4
control file parallel write	841	76.2	9.3	4.8	1.2	3.3	2.6	2.6
control file sequential read	3960	88.7	5.8	2.6	.9	.8	.7	.4
cursor: pin S	1	100.0
db file parallel read	22					13.6	13.6	72.7
db file parallel write	750	3.3	.7	2.8	7.1	28.8	42.8	14.4	.1
db file sequential read	348	37.1	1.7	1.7	8.6	21.3	16.1	13.5
direct path read	139.7K	4.7	35.6	5.8	1.0	2.1	6.8	43.8	.2
direct path read temp	1530.3K	96.1	.6	.4	.7	.9	.3	.9	.1
direct path write	6	33.3				50.0		16.7
direct path write temp	86.3K	.4	.8	1.3	1.4	2.5	4.4	86.8	2.6
flashback log file read	20	50.0	5.0		5.0	15.0	20.0	5.0
flashback log file sync	13	23.1			7.7	7.7	7.7	53.8
flashback log file write	64	18.8			3.1	17.2	32.8	28.1
kfk: async disk IO	697	100.0
latch free	21	76.2	4.8			14.3	4.8
latch: cache buffers chains	25	44.0			4.0		8.0	44.0
latch: object queue header operation	2	50.0				50.0
latch: shared pool	26	7.7	3.8	7.7	7.7	19.2	15.4	38.5
library cache: mutex X	20	20.0		15.0	10.0	45.0		10.0
log file parallel write	447	34.9	7.8	7.4	5.6	17.4	14.1	12.5	.2
log file sync	63	3.2	1.6	6.3	3.2	33.3	41.3	7.9	3.2
os thread startup	89							98.9	1.1
read by other session	45	4.4	4.4	2.2	2.2	13.3	22.2	51.1
ASM background timer	510	5.5	.6	.8	.6	.4	.8	1.4	90.0
DIAG idle wait	4585							100.0
KSV master wait	20	10.0	20.0	20.0	15.0		5.0	20.0	10.0
SQL*Net message from client	366K	5.1	32.4	27.0	35.3	.1	.0	.0	.0
Space Manager: slave idle wait	459	.2							99.8
Streams AQ: qmn coordinator idle wait	164	47.0	2.4		.6				50.0
Streams AQ: qmn slave idle wait	84	2.4							97.6
class slave wait	26	34.6	3.8	15.4	3.8	7.7	15.4	3.8	15.4
dispatcher timer	39								100.0
jobq slave wait	4830							100.0
pmon timer	862	9.5	1.6	.1					88.7
rdbms ipc message	11.7K	.8	.1	.1	.1	.2	.2	21.9	76.5
shared server idle wait	76								100.0
smon timer	8								100.0
wait for unread message on broadcast channel	2292							100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ASM file metadata operation	7	98.7	.2	.2	.3	.3	.2		.2
CSS initialization	3	25.0		50.0	25.0
control file parallel write	22	97.4	1.8	.2		.2	.4
control file sequential read	17	99.6	.3	.1	.0
db file parallel read	16	27.3	4.5	40.9	27.3
db file parallel write	109	85.5	12.4	1.3	.5	.1		.1
db file sequential read	47	86.5	8.0	3.7	1.7
direct path read	61.5K	56.0	20.2	16.3	5.2	1.6	.6	.2	.0
direct path read temp	15.3K	99.0	.1	.2	.2	.2	.2	.1	.0
direct path write	1	83.3		16.7
direct path write temp	77K	10.7	7.6	22.0	43.2	10.0	3.9	2.5	.1
flashback log file read	1	95.0	5.0
flashback log file sync	7	46.2		7.7			46.2
flashback log file write	18	71.9	20.3	6.3	1.6
latch: cache buffers chains	11	56.0	40.0	4.0
latch: shared pool	10	61.5	23.1	11.5	3.8
library cache: mutex X	2	90.0		5.0		5.0
log file parallel write	57	87.2	7.2	4.7	.4		.2	.2
log file sync	7	88.9	4.8	3.2				3.2
os thread startup	89		60.7	18.0	6.7	6.7	6.7	1.1
read by other session	23	48.9	24.4	15.6	11.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s
		% of Total Waits
ASM file metadata operation	1	99.8		.2
direct path read	19	100.0	.0
direct path read temp	6	100.0	.0
direct path write temp	59	99.9	.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
orcl	32,222	1,353	27,809	17,729
SYS$USERS	44	13	0	32
ADHOC	0	0	0	0
BATCH_LOW	0	0	0	0
BATCH_STD	0	0	0	0
DSS	0	0	0	0
OLTP	0	0	0	0
SYS$BACKGROUND	0	0	0	14
orclXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
orcl	1756720	30882	72	2	365942	2
SYS$USERS	79	0	0	0	0	0
SYS$BACKGROUND	381	7	89	13	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 91.1% of Total DB Time (s): 32,269
Captured PL/SQL account for 0.1% of Total DB Time (s): 32,269

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,998.76	15	466.58	21.69	5.53	94.97	95rzx549dbvs5	Agent.exe	SELECT NATION, O_YEAR, SUM(AMO...
4,029.27	15	268.62	12.49	3.53	97.70	1x255a7m968k7	Agent.exe	SELECT supp_nation, cust_natio...
1,639.52	4	409.88	5.08	2.41	98.53	bfk319z4wc782	Agent.exe	SELECT n_name, SUM(l_extendedp...
1,621.01	4	405.25	5.02	2.46	98.52	1gkn6r4rbdkmy	Agent.exe	SELECT n_name, SUM(l_extendedp...
1,431.70	15	95.45	4.44	4.92	97.58	fps40s3v7nd3r	Agent.exe	SELECT O_YEAR, SUM(DECODE(NATI...
1,250.61	3	416.87	3.88	2.41	98.56	2uzp6kw11g1su	Agent.exe	SELECT n_name, SUM(l_extendedp...
849.30	2	424.65	2.63	2.25	98.60	c0chxpnujy8td	Agent.exe	SELECT n_name, SUM(l_extendedp...
831.53	2	415.76	2.58	2.38	98.56	39pvzrsczv31x	Agent.exe	SELECT n_name, SUM(l_extendedp...
780.95	2	390.48	2.42	2.13	98.86	agz7fu32m6qn4	Agent.exe	SELECT c_custkey, c_name, SUM(...
739.84	2	369.92	2.29	2.61	97.68	afy3mzh484trw	Agent.exe	SELECT l_orderkey, SUM(l_exten...
591.44	2	295.72	1.83	2.43	98.59	4d0thwk8bh4zt	Agent.exe	SELECT c_custkey, c_name, SUM(...
579.61	2	289.80	1.80	2.43	98.57	c71khx643vgxb	Agent.exe	SELECT c_custkey, c_name, SUM(...
573.08	2	286.54	1.78	2.44	98.55	12qmb2vstfhgy	Agent.exe	SELECT c_custkey, c_name, SUM(...
542.59	2	271.29	1.68	2.60	98.39	9mhss2f5z0qc8	Agent.exe	SELECT c_custkey, c_name, SUM(...
395.75	1	395.75	1.23	2.53	97.29	1qnaw3d512k2n	Agent.exe	SELECT l_orderkey, SUM(l_exten...
384.29	1	384.29	1.19	2.56	97.55	59ahdunmw6xbz	Agent.exe	SELECT l_orderkey, SUM(l_exten...
377.97	1	377.97	1.17	2.61	97.81	4ttpsft97zujk	Agent.exe	SELECT l_orderkey, SUM(l_exten...
374.83	1	374.83	1.16	2.59	98.27	2jpbyjb76zda2	Agent.exe	SELECT l_orderkey, SUM(l_exten...
365.15	1	365.15	1.13	2.79	97.93	3nk66p120bzrd	Agent.exe	SELECT l_orderkey, SUM(l_exten...
364.96	1	364.96	1.13	2.60	98.15	1fwcc9b0mbzum	Agent.exe	SELECT l_orderkey, SUM(l_exten...
361.29	1	361.29	1.12	2.67	98.10	ct388w8nrts6k	Agent.exe	SELECT l_orderkey, SUM(l_exten...
361.16	1	361.16	1.12	2.58	98.19	8pqynfptn4ff6	Agent.exe	SELECT l_orderkey, SUM(l_exten...
356.27	1	356.27	1.10	2.57	98.31	6uusdb8z8usyu	Agent.exe	SELECT l_orderkey, SUM(l_exten...
355.71	1	355.71	1.10	2.75	98.12	80pntantvvbqy	Agent.exe	SELECT l_orderkey, SUM(l_exten...
355.16	1	355.16	1.10	2.68	98.19	7r9673qwmbsyu	Agent.exe	SELECT l_orderkey, SUM(l_exten...
346.05	1	346.05	1.07	2.53	98.31	1ba09vhjx4rxj	Agent.exe	SELECT l_orderkey, SUM(l_exten...
344.36	1	344.36	1.07	2.27	98.71	8q89qv4cxbg9v	Agent.exe	SELECT c_custkey, c_name, SUM(...
340.80	1	340.80	1.06	2.65	98.32	c6p5t6yk7gvvb	Agent.exe	SELECT l_orderkey, SUM(l_exten...
337.29	1	337.29	1.05	2.25	98.65	bpqbakh1vjzad	Agent.exe	SELECT c_custkey, c_name, SUM(...
330.87	1	330.87	1.03	2.32	98.65	1809cng2r987s	Agent.exe	SELECT c_custkey, c_name, SUM(...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 83.6% of Total CPU Time (s): 1,367
Captured PL/SQL account for 0.3% of Total CPU Time (s): 1,367

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
386.82	15	25.79	28.30	6,998.76	5.53	94.97	95rzx549dbvs5	Agent.exe	SELECT NATION, O_YEAR, SUM(AMO...
142.24	15	9.48	10.41	4,029.27	3.53	97.70	1x255a7m968k7	Agent.exe	SELECT supp_nation, cust_natio...
70.39	15	4.69	5.15	1,431.70	4.92	97.58	fps40s3v7nd3r	Agent.exe	SELECT O_YEAR, SUM(DECODE(NATI...
39.83	4	9.96	2.91	1,621.01	2.46	98.52	1gkn6r4rbdkmy	Agent.exe	SELECT n_name, SUM(l_extendedp...
39.54	4	9.89	2.89	1,639.52	2.41	98.53	bfk319z4wc782	Agent.exe	SELECT n_name, SUM(l_extendedp...
30.09	3	10.03	2.20	1,250.61	2.41	98.56	2uzp6kw11g1su	Agent.exe	SELECT n_name, SUM(l_extendedp...
19.95	2	9.98	1.46	154.28	12.93	66.77	9xcdxpqrhsvmx	Agent.exe	SELECT l_returnflag, l_linesta...
19.78	2	9.89	1.45	831.53	2.38	98.56	39pvzrsczv31x	Agent.exe	SELECT n_name, SUM(l_extendedp...
19.31	2	9.65	1.41	739.84	2.61	97.68	afy3mzh484trw	Agent.exe	SELECT l_orderkey, SUM(l_exten...
19.08	2	9.54	1.40	849.30	2.25	98.60	c0chxpnujy8td	Agent.exe	SELECT n_name, SUM(l_extendedp...
16.67	2	8.33	1.22	780.95	2.13	98.86	agz7fu32m6qn4	Agent.exe	SELECT c_custkey, c_name, SUM(...
14.36	2	7.18	1.05	591.44	2.43	98.59	4d0thwk8bh4zt	Agent.exe	SELECT c_custkey, c_name, SUM(...
14.11	2	7.06	1.03	542.59	2.60	98.39	9mhss2f5z0qc8	Agent.exe	SELECT c_custkey, c_name, SUM(...
14.06	2	7.03	1.03	579.61	2.43	98.57	c71khx643vgxb	Agent.exe	SELECT c_custkey, c_name, SUM(...
14.00	2	7.00	1.02	573.08	2.44	98.55	12qmb2vstfhgy	Agent.exe	SELECT c_custkey, c_name, SUM(...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 91.4% of Total User I/O Wait Time (s): 30,889
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 30,889

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,646.81	15	443.12	21.52	6,998.76	5.53	94.97	95rzx549dbvs5	Agent.exe	SELECT NATION, O_YEAR, SUM(AMO...
3,936.68	15	262.45	12.74	4,029.27	3.53	97.70	1x255a7m968k7	Agent.exe	SELECT supp_nation, cust_natio...
1,615.37	4	403.84	5.23	1,639.52	2.41	98.53	bfk319z4wc782	Agent.exe	SELECT n_name, SUM(l_extendedp...
1,597.02	4	399.26	5.17	1,621.01	2.46	98.52	1gkn6r4rbdkmy	Agent.exe	SELECT n_name, SUM(l_extendedp...
1,396.99	15	93.13	4.52	1,431.70	4.92	97.58	fps40s3v7nd3r	Agent.exe	SELECT O_YEAR, SUM(DECODE(NATI...
1,232.64	3	410.88	3.99	1,250.61	2.41	98.56	2uzp6kw11g1su	Agent.exe	SELECT n_name, SUM(l_extendedp...
837.45	2	418.72	2.71	849.30	2.25	98.60	c0chxpnujy8td	Agent.exe	SELECT n_name, SUM(l_extendedp...
819.52	2	409.76	2.65	831.53	2.38	98.56	39pvzrsczv31x	Agent.exe	SELECT n_name, SUM(l_extendedp...
772.03	2	386.02	2.50	780.95	2.13	98.86	agz7fu32m6qn4	Agent.exe	SELECT c_custkey, c_name, SUM(...
722.70	2	361.35	2.34	739.84	2.61	97.68	afy3mzh484trw	Agent.exe	SELECT l_orderkey, SUM(l_exten...
583.08	2	291.54	1.89	591.44	2.43	98.59	4d0thwk8bh4zt	Agent.exe	SELECT c_custkey, c_name, SUM(...
571.34	2	285.67	1.85	579.61	2.43	98.57	c71khx643vgxb	Agent.exe	SELECT c_custkey, c_name, SUM(...
564.79	2	282.39	1.83	573.08	2.44	98.55	12qmb2vstfhgy	Agent.exe	SELECT c_custkey, c_name, SUM(...
533.83	2	266.91	1.73	542.59	2.60	98.39	9mhss2f5z0qc8	Agent.exe	SELECT c_custkey, c_name, SUM(...
385.02	1	385.02	1.25	395.75	2.53	97.29	1qnaw3d512k2n	Agent.exe	SELECT l_orderkey, SUM(l_exten...
374.86	1	374.86	1.21	384.29	2.56	97.55	59ahdunmw6xbz	Agent.exe	SELECT l_orderkey, SUM(l_exten...
369.69	1	369.69	1.20	377.97	2.61	97.81	4ttpsft97zujk	Agent.exe	SELECT l_orderkey, SUM(l_exten...
368.34	1	368.34	1.19	374.83	2.59	98.27	2jpbyjb76zda2	Agent.exe	SELECT l_orderkey, SUM(l_exten...
358.19	1	358.19	1.16	364.96	2.60	98.15	1fwcc9b0mbzum	Agent.exe	SELECT l_orderkey, SUM(l_exten...
357.59	1	357.59	1.16	365.15	2.79	97.93	3nk66p120bzrd	Agent.exe	SELECT l_orderkey, SUM(l_exten...
354.62	1	354.62	1.15	361.16	2.58	98.19	8pqynfptn4ff6	Agent.exe	SELECT l_orderkey, SUM(l_exten...
354.42	1	354.42	1.15	361.29	2.67	98.10	ct388w8nrts6k	Agent.exe	SELECT l_orderkey, SUM(l_exten...
350.23	1	350.23	1.13	356.27	2.57	98.31	6uusdb8z8usyu	Agent.exe	SELECT l_orderkey, SUM(l_exten...
349.03	1	349.03	1.13	355.71	2.75	98.12	80pntantvvbqy	Agent.exe	SELECT l_orderkey, SUM(l_exten...
348.73	1	348.73	1.13	355.16	2.68	98.19	7r9673qwmbsyu	Agent.exe	SELECT l_orderkey, SUM(l_exten...
340.21	1	340.21	1.10	346.05	2.53	98.31	1ba09vhjx4rxj	Agent.exe	SELECT l_orderkey, SUM(l_exten...
339.92	1	339.92	1.10	344.36	2.27	98.71	8q89qv4cxbg9v	Agent.exe	SELECT c_custkey, c_name, SUM(...
335.08	1	335.08	1.08	340.80	2.65	98.32	c6p5t6yk7gvvb	Agent.exe	SELECT l_orderkey, SUM(l_exten...
332.75	1	332.75	1.08	337.29	2.25	98.65	bpqbakh1vjzad	Agent.exe	SELECT c_custkey, c_name, SUM(...
326.41	1	326.41	1.06	330.87	2.32	98.65	1809cng2r987s	Agent.exe	SELECT c_custkey, c_name, SUM(...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - Buffer Gets as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 17,774,862
Captured SQL account for 77.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,168,625	15	144,575.00	12.20	6,998.76	5.53	94.97	95rzx549dbvs5	Agent.exe	SELECT NATION, O_YEAR, SUM(AMO...
2,088,885	15	139,259.00	11.75	1,431.70	4.92	97.58	fps40s3v7nd3r	Agent.exe	SELECT O_YEAR, SUM(DECODE(NATI...
2,032,200	15	135,480.00	11.43	4,029.27	3.53	97.70	1x255a7m968k7	Agent.exe	SELECT supp_nation, cust_natio...
541,892	4	135,473.00	3.05	1,621.01	2.46	98.52	1gkn6r4rbdkmy	Agent.exe	SELECT n_name, SUM(l_extendedp...
541,892	4	135,473.00	3.05	1,639.52	2.41	98.53	bfk319z4wc782	Agent.exe	SELECT n_name, SUM(l_extendedp...
406,419	3	135,473.00	2.29	1,250.61	2.41	98.56	2uzp6kw11g1su	Agent.exe	SELECT n_name, SUM(l_extendedp...
271,146	2	135,573.00	1.53	780.95	2.13	98.86	agz7fu32m6qn4	Agent.exe	SELECT c_custkey, c_name, SUM(...
270,946	2	135,473.00	1.52	831.53	2.38	98.56	39pvzrsczv31x	Agent.exe	SELECT n_name, SUM(l_extendedp...
270,946	2	135,473.00	1.52	849.30	2.25	98.60	c0chxpnujy8td	Agent.exe	SELECT n_name, SUM(l_extendedp...
270,626	2	135,313.00	1.52	579.61	2.43	98.57	c71khx643vgxb	Agent.exe	SELECT c_custkey, c_name, SUM(...
270,623	2	135,311.50	1.52	573.08	2.44	98.55	12qmb2vstfhgy	Agent.exe	SELECT c_custkey, c_name, SUM(...
270,608	2	135,304.00	1.52	591.44	2.43	98.59	4d0thwk8bh4zt	Agent.exe	SELECT c_custkey, c_name, SUM(...
270,598	2	135,299.00	1.52	542.59	2.60	98.39	9mhss2f5z0qc8	Agent.exe	SELECT c_custkey, c_name, SUM(...
270,442	2	135,221.00	1.52	739.84	2.61	97.68	afy3mzh484trw	Agent.exe	SELECT l_orderkey, SUM(l_exten...
217,702	2	108,851.00	1.22	154.28	12.93	66.77	9xcdxpqrhsvmx	Agent.exe	SELECT l_returnflag, l_linesta...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 27,809,588
Captured SQL account for 85.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,921,585	15	461,439.00	24.89	6,998.76	5.53	94.97	95rzx549dbvs5	Agent.exe	SELECT NATION, O_YEAR, SUM(AMO...
3,567,812	15	237,854.13	12.83	4,029.27	3.53	97.70	1x255a7m968k7	Agent.exe	SELECT supp_nation, cust_natio...
2,018,940	15	134,596.00	7.26	1,431.70	4.92	97.58	fps40s3v7nd3r	Agent.exe	SELECT O_YEAR, SUM(DECODE(NATI...
1,081,913	4	270,478.25	3.89	1,621.01	2.46	98.52	1gkn6r4rbdkmy	Agent.exe	SELECT n_name, SUM(l_extendedp...
1,080,800	4	270,200.00	3.89	1,639.52	2.41	98.53	bfk319z4wc782	Agent.exe	SELECT n_name, SUM(l_extendedp...
807,345	3	269,115.00	2.90	1,250.61	2.41	98.56	2uzp6kw11g1su	Agent.exe	SELECT n_name, SUM(l_extendedp...
539,357	2	269,678.50	1.94	831.53	2.38	98.56	39pvzrsczv31x	Agent.exe	SELECT n_name, SUM(l_extendedp...
531,923	2	265,961.50	1.91	849.30	2.25	98.60	c0chxpnujy8td	Agent.exe	SELECT n_name, SUM(l_extendedp...
470,022	2	235,011.00	1.69	739.84	2.61	97.68	afy3mzh484trw	Agent.exe	SELECT l_orderkey, SUM(l_exten...
323,016	2	161,508.00	1.16	780.95	2.13	98.86	agz7fu32m6qn4	Agent.exe	SELECT c_custkey, c_name, SUM(...
319,269	2	159,634.50	1.15	542.59	2.60	98.39	9mhss2f5z0qc8	Agent.exe	SELECT c_custkey, c_name, SUM(...
319,077	2	159,538.50	1.15	591.44	2.43	98.59	4d0thwk8bh4zt	Agent.exe	SELECT c_custkey, c_name, SUM(...
317,777	2	158,888.50	1.14	573.08	2.44	98.55	12qmb2vstfhgy	Agent.exe	SELECT c_custkey, c_name, SUM(...
317,700	2	158,850.00	1.14	579.61	2.43	98.57	c71khx643vgxb	Agent.exe	SELECT c_custkey, c_name, SUM(...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 1,670,321
Captured SQL account for 39.6% of Total
Total UnOptimized Read Requests: 1,670,321
Captured SQL account for 39.6% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
242,356	242,356	15	16,157.07	14.51	1x255a7m968k7	Agent.exe	SELECT supp_nation, cust_natio...
83,295	83,295	4	20,823.75	4.99	1gkn6r4rbdkmy	Agent.exe	SELECT n_name, SUM(l_extendedp...
83,136	83,136	4	20,784.00	4.98	bfk319z4wc782	Agent.exe	SELECT n_name, SUM(l_extendedp...
61,887	61,887	3	20,629.00	3.71	2uzp6kw11g1su	Agent.exe	SELECT n_name, SUM(l_extendedp...
41,419	41,419	2	20,709.50	2.48	39pvzrsczv31x	Agent.exe	SELECT n_name, SUM(l_extendedp...
40,357	40,357	2	20,178.50	2.42	c0chxpnujy8td	Agent.exe	SELECT n_name, SUM(l_extendedp...
21,180	21,180	15	1,412.00	1.27	fps40s3v7nd3r	Agent.exe	SELECT O_YEAR, SUM(DECODE(NATI...
15,662	15,662	2	7,831.00	0.94	agz7fu32m6qn4	Agent.exe	SELECT c_custkey, c_name, SUM(...
12,401	12,401	2	6,200.50	0.74	4d0thwk8bh4zt	Agent.exe	SELECT c_custkey, c_name, SUM(...
12,401	12,401	2	6,200.50	0.74	9mhss2f5z0qc8	Agent.exe	SELECT c_custkey, c_name, SUM(...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 7,864
Captured SQL account for 57.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,157	6,258	2.90	0.40	75.19	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
249	249	1.00	0.13	30.24	0.00	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
249	0	0.00	0.02	93.89	0.00	csnp95dz2r8ss		select file#, block# from recy...
232	232	1.00	0.04	92.91	0.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
162	162	1.00	0.54	14.06	10.20	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...
124	124	1.00	0.08	103.80	2.32	fsbqktj5vw6n9		select next_run_date, obj#, ru...
115	76	0.66	0.08	37.82	0.00	08bqjmf8490s2	SEVERITY EVALUATION	SELECT PARAMETER_VALUE FROM MG...
108	0	0.00	0.02	78.85	0.00	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
108	108	1.00	0.06	97.82	0.00	g00cj285jmgsw		update sys.mon_mods$ set inser...
81	81	1.00	0.91	20.23	6.63	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 5,257
Captured SQL account for 78.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,157	2,157	41.03	cm5vu20fhtnq1		select /*+ connect_by_filterin...
249	249	4.74	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
249	249	4.74	csnp95dz2r8ss		select file#, block# from recy...
124	124	2.36	fsbqktj5vw6n9		select next_run_date, obj#, ru...
115	115	2.19	08bqjmf8490s2	SEVERITY EVALUATION	SELECT PARAMETER_VALUE FROM MG...
108	108	2.05	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
108	108	2.05	g00cj285jmgsw		update sys.mon_mods$ set inser...
76	232	1.45	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
76	76	1.45	c8h3jdwaa532q	EM_PING	SELECT TO_NUMBER(PARAMETER_VAL...
57	57	1.08	0k8522rmdzg4k		select privilege# from sysauth...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

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

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

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

1qnaw3d512k2n 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-05', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-05', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

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

2jpbyjb76zda2 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-14', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-14', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

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

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

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

3nk66p120bzrd 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-30', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-30', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

4d0thwk8bh4zt 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-03-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-03-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

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

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

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

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

7r9673qwmbsyu 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-26', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-26', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

80pntantvvbqy 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-28', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-28', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

8pqynfptn4ff6 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-18', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-18', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

8q89qv4cxbg9v 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-05-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-05-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

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

9mhss2f5z0qc8 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-10-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-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

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

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

bpqbakh1vjzad 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-11-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1994-11-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

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

c6p5t6yk7gvvb 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-03', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-03', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

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

ct388w8nrts6k 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-07', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-07', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate

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

SQL Id	SQL Text
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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
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
1qnaw3d512k2n	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-05', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-05', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
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
2jpbyjb76zda2	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-14', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-14', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
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
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
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
3nk66p120bzrd	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-30', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-30', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
4d0thwk8bh4zt	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-03-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-03-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
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
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
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
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
7r9673qwmbsyu	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-26', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-26', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
80pntantvvbqy	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-28', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-28', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
8pqynfptn4ff6	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-18', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-18', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
8q89qv4cxbg9v	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-05-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-05-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
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
9mhss2f5z0qc8	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-10-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-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
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
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
bpqbakh1vjzad	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-11-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1994-11-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
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
c6p5t6yk7gvvb	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-03', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-03', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
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
ct388w8nrts6k	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-07', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-07', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	130	0.06	0.59
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	533	0.23	2.40
Batched IO buffer defrag count	3	0.00	0.01
Batched IO double miss count	14	0.01	0.06
Batched IO same unit count	327	0.14	1.47
Batched IO single block count	96	0.04	0.43
Batched IO slow jump count	1	0.00	0.00
Batched IO vector block count	98	0.04	0.44
Batched IO vector read count	35	0.02	0.16
Block Cleanout Optim referenced	2	0.00	0.01
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	132,180	57.69	595.41
CPU used when call started	131,368	57.34	591.75
CR blocks created	15	0.01	0.07
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	3,462,417	1,511.23	15,596.47
DBWR checkpoint buffers written	1,210	0.53	5.45
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	180	0.08	0.81
DBWR undo block writes	340	0.15	1.53
DFO trees parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	1,001	0.44	4.51
Heap Segment Array Inserts	107	0.05	0.48
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	139,710	60.98	629.32
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations downgraded 1 to 25 pct	0	0.00	0.00
Parallel operations downgraded 25 to 50 pct	0	0.00	0.00
Parallel operations downgraded to serial	0	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	157	0.07	0.71
RowCR hits	157	0.07	0.71
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	365,942	159.72	1,648.39
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	70	0.03	0.32
application wait time	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	11,212	4.89	50.50
buffer is not pinned count	32,244	14.07	145.24
buffer is pinned count	104,861	45.77	472.35
bytes received via SQL*Net from client	4,144,439	1,808.91	18,668.64
bytes sent via SQL*Net to client	124,252,062	54,231.81	559,693.97
calls to get snapshot scn: kcmgss	8,806	3.84	39.67
calls to kcmgas	871	0.38	3.92
calls to kcmgcs	7,666	3.35	34.53
cell physical IO interconnect bytes	232,923,072,000	101,663,010.68	1,049,203,027.03
change write time	89	0.04	0.40
cleanout - number of ktugct calls	72	0.03	0.32
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	0	0.00	0.00
cluster key scan block gets	2,279	0.99	10.27
cluster key scans	2,023	0.88	9.11
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	4	0.00	0.02
commit cleanout failures: cannot pin	1	0.00	0.00
commit cleanouts	1,513	0.66	6.82
commit cleanouts successfully completed	1,508	0.66	6.79
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	41	0.02	0.18
concurrency wait time	1,515	0.66	6.82
consistent changes	45	0.02	0.20
consistent gets	17,764,953	7,753.80	80,022.31
consistent gets - examination	26,338	11.50	118.64
consistent gets direct	17,271,495	7,538.42	77,799.53
consistent gets from cache	493,458	215.38	2,222.78
consistent gets from cache (fastpath)	465,890	203.35	2,098.60
cursor authentications	16	0.01	0.07
data blocks consistent reads - undo records applied	34	0.01	0.15
db block changes	7,268	3.17	32.74
db block gets	9,909	4.32	44.64
db block gets direct	130	0.06	0.59
db block gets from cache	9,779	4.27	44.05
db block gets from cache (fastpath)	1,958	0.85	8.82
deferred (CURRENT) block cleanout applications	865	0.38	3.90
dirty buffers inspected	0	0.00	0.00
enqueue conversions	470	0.21	2.12
enqueue releases	35,587	15.53	160.30
enqueue requests	35,587	15.53	160.30
enqueue timeouts	0	0.00	0.00
enqueue waits	0	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	7,864	3.43	35.42
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	76,820,673	33,529.61	346,039.07
flashback log write bytes	7,168,000	3,128.59	32,288.29
flashback log writes	57	0.02	0.26
free buffer inspected	365	0.16	1.64
free buffer requested	393	0.17	1.77
heap block compress	23	0.01	0.10
hot buffers moved to head of LRU	701	0.31	3.16
immediate (CR) block cleanout applications	0	0.00	0.00
immediate (CURRENT) block cleanout applications	311	0.14	1.40
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (full)	7	0.00	0.03
index fetch by key	8,133	3.55	36.64
index scans kdiixs1	19,913	8.69	89.70
leaf node 90-10 splits	32	0.01	0.14
leaf node splits	40	0.02	0.18
lob reads	0	0.00	0.00
lob writes	5	0.00	0.02
lob writes unaligned	5	0.00	0.02
logons cumulative	148	0.06	0.67
max cf enq hold time	70	0.03	0.32
messages received	1,247	0.54	5.62
messages sent	1,247	0.54	5.62
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	17,730,030	7,738.56	79,865.00
non-idle wait count	2,131,884	930.49	9,603.08
non-idle wait time	3,095,451	1,351.06	13,943.47
opened cursors cumulative	7,236	3.16	32.59
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	31	0.01	0.14
parse count (total)	5,257	2.29	23.68
parse time cpu	97	0.04	0.44
parse time elapsed	1,035	0.45	4.66
physical read IO requests	1,670,321	729.04	7,523.97
physical read bytes	227,816,144,896	99,434,010.44	1,026,198,850.88
physical read total IO requests	1,674,382	730.81	7,542.26
physical read total bytes	227,882,796,032	99,463,101.39	1,026,499,081.23
physical read total multi block requests	135,636	59.20	610.97
physical reads	27,809,588	12,137.94	125,268.41
physical reads cache	336	0.15	1.51
physical reads cache prefetch	34	0.01	0.15
physical reads direct	27,809,252	12,137.79	125,266.90
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	10,537,627	4,599.32	47,466.79
physical reads for flashback new	171	0.07	0.77
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	87,160	38.04	392.61
physical write bytes	4,952,227,840	2,161,479.27	22,307,332.61
physical write total IO requests	89,813	39.20	404.56
physical write total bytes	4,997,762,048	2,181,353.41	22,512,441.66
physical write total multi block requests	48	0.02	0.22
physical writes	604,520	263.85	2,723.06
physical writes direct	603,310	263.32	2,717.61
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	603,180	263.27	2,717.03
physical writes from cache	1,210	0.53	5.45
physical writes non checkpoint	603,524	263.42	2,718.58
pinned buffers inspected	0	0.00	0.00
pinned cursors current	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
queries parallelized	0	0.00	0.00
recursive calls	53,142	23.19	239.38
recursive cpu usage	817	0.36	3.68
redo blocks checksummed by FG (exclusive)	4,917	2.15	22.15
redo blocks written	7,835	3.42	35.29
redo buffer allocation retries	0	0.00	0.00
redo entries	4,904	2.14	22.09
redo k-bytes read total	0	0.00	0.00
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	180	0.08	0.81
redo size	3,763,776	1,642.76	16,953.95
redo size for direct writes	1,075,360	469.36	4,843.96
redo subscn max counts	457	0.20	2.06
redo synch time	451	0.20	2.03
redo synch writes	78	0.03	0.35
redo wastage	110,300	48.14	496.85
redo write time	931	0.41	4.19
redo writes	446	0.19	2.01
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	15	0.01	0.07
rows fetched via callback	3,036	1.33	13.68
session cursor cache hits	5,006	2.18	22.55
session logical reads	17,774,862	7,758.12	80,066.95
shared hash latch upgrades - no wait	1,016	0.44	4.58
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	21	0.01	0.09
sorts (memory)	6,908	3.02	31.12
sorts (rows)	94,764,374	41,361.43	426,866.55
sql area evicted	4	0.00	0.02
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	17	0.01	0.08
table fetch by rowid	53,595	23.39	241.42
table fetch continued row	0	0.00	0.00
table scan blocks gotten	17,688,555	7,720.45	79,678.18
table scan rows gotten	1,000,452,129	436,663.38	4,506,541.12
table scans (direct read)	255	0.11	1.15
table scans (long tables)	255	0.11	1.15
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	2,019	0.88	9.09
total cf enq hold time	3,250	1.42	14.64
total number of cf enq holders	136	0.06	0.61
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	962,204	419.97	4,334.25
user I/O wait time	3,088,872	1,348.19	13,913.84
user calls	366,551	159.99	1,651.13
user commits	222	0.10	1.00
user rollbacks	0	0.00	0.00
workarea executions - multipass	205	0.09	0.92
workarea executions - onepass	100	0.04	0.45
workarea executions - optimal	3,070	1.34	13.83
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory	7,705,499,211,304	7,890,190,287,096
opened cursors current	32	32
logons current	33	33
session uga memory max	5,880,982,712	6,047,162,608
session pga memory	5,384,823,832	5,505,056,224
session pga memory max	5,671,412,760	5,793,414,624
session cursor cache count	117,273	119,766

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	203.7G	724.83	91.0267	3G	24.20	1.32423	1670K	7.71
Direct Writes	8.5G	4.06	3.79987	1.6G	13.45	.732390	86.3K	205.70
Others	64M	1.77	.027933	38M	0.77	.016585	4956	2.23
DBWR	0M	0.00	0M	10M	0.39	.004364	0
LGWR	0M	0.00	0M	9M	0.39	.003928	0
Buffer Cache Reads	3M	0.14	.001309	0M	0.00	0M	301	28.97
TOTAL:	212.2G	730.80	94.8558	4.7G	39.20	2.08150	1761.5K	17.39

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	131.8G	61.15	58.8967	11M	0.39	.004801	10.34	49.83
Temp File	80.4G	667.91	35.9320	4.6G	37.65	2.05662	3.95
Control File	61M	1.72	.026624	27M	0.73	.011784	0.75
Flashback Log	1M	0.01	.000436	8M	0.03	.003491	7.76	7.50
Log File	0M	0.00	0M	9M	0.39	.003928
Other	0M	0.00	0M	3M	0.01	.001309
TOTAL:	212.2G	730.79	94.8558	4.7G	39.20	2.08194	3.96	49.83

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	203.7G	724.83	91.0267	3G	24.20	1.32423	0
Direct Reads (Data File)	203.7G	724.83	91.0267	3G	24.20	1.32423	0
Direct Writes	8.5G	4.06	3.79987	1.6G	13.45	.732390	0
Direct Writes (Data File)	8.5G	4.06	3.79987	1.6G	13.45	.732390	0
Others	64M	1.76	.027933	35M	0.76	.015276	4102	1.40
Others (Control File)	62M	1.72	.027060	26M	0.73	.011348	3945	0.75
Others (Flashback Log)	1M	0.01	.000436	8M	0.03	.003491	77	23.48
Others (Data File)	1M	0.03	.000436	1M	0.00	.000436	80	11.85
DBWR	0M	0.00	0M	10M	0.39	.004364	0
DBWR (Data File)	0M	0.00	0M	10M	0.39	.004364	0
LGWR	0M	0.00	0M	9M	0.39	.003928	0
LGWR (Log File)	0M	0.00	0M	9M	0.39	.003928	0
Buffer Cache Reads	3M	0.14	.001309	0M	0.00	0M	257	17.45
Buffer Cache Reads (Data File)	3M	0.14	.001309	0M	0.00	0M	257	17.45
TOTAL:	212.2G	730.79	94.8558	4.7G	39.19	2.08019	4359	2.34

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
TPCH_BIGTEMP	1,530,257	668	0.00	6.89	86,242	38	0	0.00
TPCH_REF_DATA	139,842	61	0.03	123.51	0	0	47	50.43
SYSAUX	140	0	0.00	1.86	492	0	0	0.00
UNDOTBS1	71	0	0.00	1.00	364	0	0	0.00
SYSTEM	0	0	0.00	0.00	37	0	0	0.00
TPCE_BIGTEMP	9	0	0.00	15.00	25	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	+DATA/orcl/datafile/sysaux.258.716405081	140	0	0.00	1.86	492	0	0	0.00
SYSTEM	+DATA/orcl/datafile/system.259.716405187	0	0			37	0	0	0.00
TPCE_BIGTEMP	/u01/app/oradata/TPCE/tpce_bigtemp.tmp	9	0	0.00	15.00	25	0	0
TPCH_BIGTEMP	/u01/app/oradata/TPCH/tpch_bigtemp.tmp	1,530,257	668	0.00	6.89	86,242	38	0
TPCH_REF_DATA	/u01/app/oradata/TPCH/tpch_ref_data01.dbf	139,842	61	0.03	123.51	0	0	47	50.43
UNDOTBS1	+DATA/orcl/datafile/undotbs1.260.716405283	71	0	0.00	1.00	364	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	48,609	100	503,250	339	1,210	0	0	47

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 604,520

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	1,210	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	21	336	1133	1843	424602	1843
E	0	21	336	2290	5516	424602	5516

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	36	0.09	4	5.14	545	1	38300.00
D	72	0.18	9	2.43	258	1	16553.00
D	108	0.27	13	1.49	158	1	9043.00
D	144	0.36	18	1.25	132	1	7084.00
D	180	0.45	22	1.12	119	1	6052.00
D	216	0.55	27	1.08	114	1	5718.00
D	252	0.64	31	1.05	112	1	5507.00
D	288	0.73	35	1.04	111	1	5435.00
D	324	0.82	40	1.03	109	1	5337.00
D	360	0.91	44	1.00	106	1	5099.00
D	396	1.00	49	1.00	106	1	5090.00
D	432	1.09	53	1.00	106	1	5062.00
D	468	1.18	57	0.99	105	1	5039.00
D	504	1.27	62	0.99	105	1	5028.00
D	540	1.36	66	0.99	105	1	5024.00
D	576	1.45	71	0.98	104	1	4894.00
D	612	1.55	75	0.98	103	1	4892.00
D	648	1.64	80	0.98	103	1	4891.00
D	684	1.73	84	0.97	103	1	4872.00
D	720	1.82	88	0.95	101	1	4697.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
26.03	2,739	7,783

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute 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)
B	150	9	186.59	0.00	0.00	0.00	0.00	30,720
E	150	9	188.72	0.00	0.00	0.00	0.00	30,720

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs	M-Pass Execs
2K	4K	2,869	2,869	0	0
64K	128K	12	12	0	0
256K	512K	24	12	12	0
512K	1024K	111	111	0	0
1M	2M	132	66	35	31
2M	4M	45	0	9	36
4M	8M	92	0	13	79
8M	16M	30	0	1	29
16M	32M	45	0	30	15
32M	64M	15	0	0	15

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
19	0.13	9,186.29	21,334.76	30.00	487	45,781
38	0.25	9,186.29	21,334.76	30.00	487	45,781
75	0.50	9,186.29	21,334.76	30.00	487	45,781
113	0.75	9,186.29	21,330.50	30.00	486	45,774
150	1.00	9,186.29	12,654.37	42.00	485	32,760
180	1.20	9,186.29	12,548.44	42.00	404	32,601
210	1.40	9,186.29	12,286.73	43.00	369	32,209
240	1.60	9,186.29	11,356.78	45.00	311	30,814
270	1.80	9,186.29	11,204.31	45.00	302	30,585
300	2.00	9,186.29	9,733.17	49.00	302	28,378
450	3.00	9,186.29	6,948.06	57.00	0	24,201
600	4.00	9,186.29	4,182.00	69.00	0	20,052
900	6.00	9,186.29	1,299.93	88.00	0	15,729
1,200	8.00	9,186.29	484.19	95.00	0	14,505

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
220	0.67	20	1,569	52,379	0.99	1,792	1.32	356
256	0.78	56	3,895	52,526	0.99	1,645	1.21	648
292	0.89	92	5,674	52,720	1.00	1,451	1.07	652
328	1.00	128	7,293	52,815	1.00	1,356	1.00	654
364	1.11	164	9,569	52,860	1.00	1,311	0.97	655
400	1.22	200	12,026	52,882	1.00	1,289	0.95	656
436	1.33	236	14,266	52,904	1.00	1,267	0.93	656
472	1.44	272	16,131	52,930	1.00	1,241	0.92	657
508	1.55	308	17,737	52,944	1.00	1,227	0.90	658
544	1.66	342	19,307	52,946	1.00	1,225	0.90	658
580	1.77	356	19,963	52,947	1.00	1,224	0.90	658
616	1.88	356	19,963	52,947	1.00	1,224	0.90	658
652	1.99	356	19,963	52,947	1.00	1,224	0.90	658
688	2.10	356	19,963	52,947	1.00	1,224	0.90	658

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
376	0.50	324,776	157,972
564	0.75	320,900	111,412
752	1.00	320,355	106,036
940	1.25	320,195	103,311
1,128	1.50	319,939	100,734
1,316	1.75	319,874	100,734
1,504	2.00	319,874	100,734

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
4	1.00	0	0	0	0
8	2.00	0	0	0	0
12	3.00	0	0	0	0
16	4.00	0	0	0	0
20	5.00	0	0	0	0
24	6.00	0	0	0	0
28	7.00	0	0	0	0
32	8.00	0	0	0	0
36	9.00	0	0	0	0
40	10.00	0	0	0	0
44	11.00	0	0	0	0
48	12.00	0	0	0	0
52	13.00	0	0	0	0
56	14.00	0	0	0	0
60	15.00	0	0	0	0
64	16.00	0	0	0	0
68	17.00	0	0	0	0
72	18.00	0	0	0	0
76	19.00	0	0	0	0
80	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	47	2	50

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

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

Undo TS#	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
2	0.17	448	1,274	3	23.1/33.3	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
24-Nov 21:56	22	78	667	2	23	0/0	0/0/0/0/0/0
24-Nov 21:46	22	66	1,270	2	33	0/0	0/0/0/0/0/0
24-Nov 21:36	23	165	670	3	23	0/0	0/0/0/0/0/0
24-Nov 21:26	105	139	1,274	3	33	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0	0
ASM Keyed state latch	85	0.00		0	0
ASM allocation	65	0.00		0	0
ASM db client latch	1,524	0.00		0	0
ASM map headers	54	0.00		0	0
ASM map load waiting list	9	0.00		0	0
ASM map operation freelist	73	0.00		0	0
ASM map operation hash table	40,007	0.00	0.00	0	0
ASM network background latch	1,040	0.00		0	0
ASM network state latch	59	0.00		0	0
AWR Alerted Metric Element list	18,549	0.00		0	0
Change Notification Hash table latch	767	0.00		0	0
Consistent RBA	446	0.00		0	0
DML lock allocation	1,752	0.00		0	0
Event Group Locks	106	0.00		0	0
FAL Queue	59	0.00		0	0
FIB s.o chain latch	22	0.00		0	0
FOB s.o list latch	978	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	1	0.00		0	0
JS Sh mem access	5	20.00	1.00	0	0
JS broadcast autostart latch	42	0.00		0	0
JS mem alloc latch	6	0.00		0	0
JS queue access latch	7	0.00		0	0
JS queue state obj latch	30,322	0.00		0	0
JS slv state obj latch	459	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KFK SGA Libload latch	608	0.00		0	0
KFMD SGA	76	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KMG MMAN ready and startup request latch	764	0.00		0	0
KTF sga latch	12	0.00		0	697	0.00
KWQMN job cache list latch	1	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	10	0.00		0	0
KWQS pqueue ctx latch	55	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	206	0.00		0	0
MQL Tracking Latch	0			0	46	0.00
Memory Management Latch	1	0.00		0	764	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	13	0.00		0	0
Minimum flashback SCN latch	1	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	850	0.00		0	0
OS process allocation	1,330	0.00		0	0
OS process: request allocation	210	0.00		0	0
PL/SQL warning settings	247	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	1,439	0.07	0.00	0	0
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	175	0.00		0	762	0.00
SQL memory manager workarea list latch	64,492	0.00		0	0
Shared B-Tree	226	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	367	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	1,512	0.00		0	0
active service list	7,623	0.04	1.00	0	3,304	0.00
archive control	38	0.00		0	0
archive process latch	177	0.00		0	0
begin backup scn array	9	0.00		0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	226	0.00		0	0
cache buffers chains	999,904	0.01	0.23	1	479	0.00
cache buffers lru chain	1,290	0.00		0	1,616	0.00
call allocation	681	0.00		0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	228	0.00		0	0
channel operations parent latch	14,476	0.00		0	0
checkpoint queue latch	36,640	0.00		0	1,062	0.00
client/application info	1,102	0.00		0	0
compile environment latch	148	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	41	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	41	0.00		0	0
dml lock allocation	41	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	297	0.00		0	0
enqueue hash chains	71,629	0.00	0.00	0	0
enqueues	68,242	0.01	0.00	0	0
fifth spare latch	1	0.00		0	0
file cache latch	862	0.00		0	0
flashback FBA barrier	1	0.00		0	0
flashback SCN barrier	2	0.00		0	0
flashback allocation	1,718	0.00		0	0
flashback copy	1	0.00		0	869	0.00
flashback hint SCN barrier	1	0.00		0	0
flashback mapping	56	0.00		0	0
flashback marker cache	2	0.00		0	0
flashback sync request	51	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	1	0.00		0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs resource freelist	1	0.00		0	0
gcs resource hash	1	0.00		0	0
gcs resource scan list	1	0.00		0	0
gcs shadows freelist	1	0.00		0	0
ges domain table	1	0.00		0	0
ges enqueue table freelist	1	0.00		0	0
ges group table	1	0.00		0	0
ges process hash list	1	0.00		0	0
ges process parent latch	1	0.00		0	0
ges resource hash list	1	0.00		0	0
ges resource scan list	1	0.00		0	0
ges resource table freelist	1	0.00		0	0
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	15	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	13	0.00		0	1,331	0.00
hash table modification latch	74	0.00		0	0
heartbeat check	1	0.00		0	0
hint flashback FBA barrier	1	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	44	0.00		0	43	4.65
job_queue_processes free list latch	88	0.00		0	0
job_queue_processes parameter latch	539	0.00		0	0
k2q lock allocation	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	55	0.00		0	0
kokc descriptor allocation latch	322	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	27	0.00		0	0
ksuosstats global area	156	0.00		0	0
ksv allocation latch	93	0.00		0	0
ksv class latch	178	1.12	0.50	0	0
ksv msg queue latch	19	0.00		0	18	0.00
ksz_so allocation latch	210	0.00		0	0
ktm global data	13	0.00		0	0
kwqbsn:qsga	84	0.00		0	0
lgwr LWN SCN	1,055	0.00		0	0
list of block allocation	164	0.00		0	0
loader state object freelist	2,034	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	9	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	2	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	650	0.00		0	402	0.00
managed standby latch	59	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	85	0.00		0	0
messages	25,609	0.01	0.00	0	0
mostly latch-free SCN	1,056	0.00		0	0
msg queue latch	1	0.00		0	0
multiblock read objects	70	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	41	0.00		0	0
object queue header heap	3,054	0.00		0	23	0.00
object queue header operation	12,497	0.02	1.00	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	305	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	832	0.00		0	0
parameter table management	297	0.00		0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	188	0.00		0	99	0.00
process allocation	299	0.00		0	105	0.00
process group creation	210	0.00		0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	336	0.00		0	0
query server freelists	1	0.00		0	0
queued dump request	7	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	2,561	0.00		0	4,879	0.06
redo copy	5	0.00		0	4,880	0.20
redo writing	4,458	0.00		0	0
resmgr group change latch	255	0.00		0	0
resmgr:active threads	297	0.00		0	0
resmgr:actses change group	73	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	296	0.00		0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	11	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	43,142	0.00		0	9	0.00
rules engine aggregate statistics	1	0.00		0	0
rules engine rule set statistics	102	0.00		0	0
second spare latch	1	0.00		0	0
segmented array pool	18	0.00		0	0
sequence cache	189	0.00		0	0
session allocation	1,099	0.00		0	366	0.00
session idle bit	733,321	0.01	0.06	0	0
session queue latch	1	0.00		0	0
session state list latch	298	0.00		0	0
session switching	567	0.00		0	0
session timer	862	0.00		0	0
shared pool	11,671	0.46	0.57	1	0
shared pool sim alloc	3	0.00		0	0
shared pool simulator	206	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	636,939	0.00	0.11	0	0
simulator lru latch	728	0.00		0	636,199	0.03
sort extent pool	329,808	0.03	0.11	0	0
space background state object latch	2	0.00		0	0
space background task latch	1,698	0.00		0	1,528	0.00
state object free list	2	0.00		0	0
statistics aggregation	2,520	0.00		0	0
tablespace key chain	85	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
third spare latch	1	0.00		0	0
threshold alerts latch	532	0.00		0	0
transaction allocation	525	0.00		0	0
undo global data	2,142	0.00		0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	999,904	108	25	83
sort extent pool	329,808	102	11	91
shared pool	11,671	54	31	28
session idle bit	733,321	48	3	45
simulator hash latch	636,939	18	2	16
active service list	7,623	3	3	0
ksv class latch	178	2	1	1
object queue header operation	12,497	2	2	0
JS Sh mem access	5	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
JS Sh mem access	jsksGetShMemLatch	1	1
active service list	kswslogon: session logout	3	3
cache buffers chains	kcbgtcr: fast path (cr pin)	30	9
cache buffers chains	kcbgcur_2	1	0
ksv class latch	ksvclsl: cldel	1	1
object queue header operation	kcbo_switch_cq	2	1
session idle bit	ksupuc: set busy	6	2
session idle bit	ksupuc: clear busy	1	5
shared pool	kghupr1	14	7
shared pool	kghalo	11	10
shared pool	kghalp	5	13
shared pool	kghfre	1	1
simulator hash latch	kcbs_lookup_setid: lookup dba	1	1
simulator hash latch	kcbsacc: lookup dba	1	1
sort extent pool	ktatobjstats	11	11

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kglhdgn2 106	16	12
Library Cache	kgllkdl1 85	2	-84
Library Cache	kglget2 2	1	-1,373
Library Cache	kglhdgn1 62	1	-7,197
Cursor Pin	kkslce [KKSCHLPIN2]	1	-811

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 17,774,862
Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCH	TPCH_REF_DATA	H_LINEITEM	TABLE	14,693,856	82.67
TPCH	TPCH_REF_DATA	H_ORDER	TABLE	2,452,768	13.80
TPCH	TPCH_REF_DATA	H_CUSTOMER	TABLE	225,664	1.27
TPCH	TPCH_REF_DATA	H_PART	TABLE	170,064	0.96
TPCH	TPCH_REF_DATA	H_PARTSUPP	TABLE	136,448	0.77

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 27,809,588
Captured Segments account for 62.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
TPCH	TPCH_REF_DATA	H_LINEITEM		TABLE	14,694,075	52.84
TPCH	TPCH_REF_DATA	H_ORDER		TABLE	2,452,485	8.82
TPCH	TPCH_REF_DATA	H_PARTSUPP		TABLE	125,049	0.45
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	132	0.00
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	48	0.00

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 1,670,321
Captured Segments account for 8.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
TPCH	TPCH_REF_DATA	H_LINEITEM		TABLE	117,584	7.04
TPCH	TPCH_REF_DATA	H_ORDER		TABLE	20,894	1.25
TPCH	TPCH_REF_DATA	H_PARTSUPP		TABLE	1,344	0.08
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	48	0.00
TPCH	TPCH_REF_DATA	H_PARTSUPP_IDX1		INDEX	18	0.00

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 1,670,321
Captured Segments account for 8.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
TPCH	TPCH_REF_DATA	H_LINEITEM		TABLE	117,584	7.04
TPCH	TPCH_REF_DATA	H_ORDER		TABLE	20,894	1.25
TPCH	TPCH_REF_DATA	H_PARTSUPP		TABLE	1,344	0.08
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	48	0.00
TPCH	TPCH_REF_DATA	H_PARTSUPP_IDX1		INDEX	18	0.00

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 27,809,252
Captured Segments account for 62.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
TPCH	TPCH_REF_DATA	H_LINEITEM		TABLE	14,694,075	52.84
TPCH	TPCH_REF_DATA	H_ORDER		TABLE	2,452,485	8.82
TPCH	TPCH_REF_DATA	H_PARTSUPP		TABLE	124,935	0.45
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	130	0.00

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 604,520
Captured Segments account for 0.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	141	0.02
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	59	0.01
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01		INDEX	22	0.00
SYS	SYSAUX	SMON_SCN_TIME		TABLE	18	0.00
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	WRH$_EVENT__1200893776_2190	TABLE PARTITION	16	0.00

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 87,160
Captured Segments account for 0.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
SYS	SYSAUX	SMON_SCN_TIME		TABLE	18	0.02
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	17	0.02
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01		INDEX	16	0.02
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	14	0.02
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY		TABLE	10	0.01

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 603,310
Captured Segments account for 0.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	130	0.02

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 262
Captured Segments account for 99.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
TPCH	TPCH_REF_DATA	H_LINEITEM	TABLE	135	51.53
TPCH	TPCH_REF_DATA	H_ORDER	TABLE	105	40.08
TPCH	TPCH_REF_DATA	H_PARTSUPP	TABLE	15	5.73
SYS	SYSTEM	I_OBJ2	INDEX	6	2.29

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
SYSMAN	SYSAUX	MGMT_CURRENT_METRICS_PK		INDEX	432	26.73
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01		INDEX	240	14.85
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1200893776_2190	INDEX PARTITION	224	13.86
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	WRH$_EVENT__1200893776_2190	INDEX PARTITION	80	4.95
SYS	SYSAUX	WRI$_ADV_PARAMETERS		TABLE	80	4.95

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Mod Reqs	Final Usage
dc_awr_control	49	2	1
dc_files	80	0	80
dc_global_oids	306	0	111
dc_histogram_data	7	0	1,857
dc_histogram_defs	290	0	4,762
dc_objects	701	4	3,153
dc_profiles	59	0	2
dc_rollback_segments	966	0	39
dc_segments	332	7	1,178
dc_tablespaces	2,894	0	84
dc_users	6,948	0	118
global database name	1,638	0	1
outstanding_alerts	238	1	79
sch_lj_oids	3	0	6

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss
BODY	744	0.00	1,413	0.00
DBLINK	33	0.00	0
EDITION	67	0.00	125	0.00
QUEUE	42	0.00	140	0.00
RULESET	1	0.00	1	0.00
SCHEMA	73	0.00	0
SQL AREA	1,168	4.37	10,786	0.73
SUBSCRIPTION	8	0.00	8	0.00
TABLE/PROCEDURE	900	0.00	2,188	0.00
TRIGGER	8	0.00	39	0.00

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	396.00	396.00	396.00	432.00	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	152.00	152.00	152.00	152.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	752.00	752.00	752.00	752.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	4.00	4.00	4.00	4.00	STA/
large pool	8.00	8.00	8.00	8.00	STA/
shared pool	328.00	328.00	292.00	328.00	GRO/IMM
streams pool	4.00	4.00	4.00	4.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

B: Begin Snap E: End Snap
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 Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	177.18		5.06	8.27	30	31	35	35
	Freeable	8.19	0.00	0.91	1.13	4		9	9
	SQL	0.74	0.66	0.06	0.17	1	2	13	7
	PL/SQL	0.49	0.41	0.01	0.04	0	2	33	33
E	Other	179.07		5.12	8.25	30	31	35	35
	Freeable	8.44	0.00	0.94	1.13	4		9	9
	SQL	0.73	0.64	0.06	0.16	1	2	13	7
	PL/SQL	0.49	0.41	0.01	0.04	0	1	33	33

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	415,236,096
Fixed Size	2,217,712
Redo Buffers	6,721,536
Variable Size	385,878,288

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	4.00	4.00	0.00
large	ASM map operations hashta	0.38	0.38	0.00
large	PX msg pool	6.56	6.56	0.00
large	free memory	1.06	1.06	0.00
shared	ASH buffers	4.00	4.00	0.00
shared	CCUR	22.78	22.96	0.78
shared	FileOpenBlock	3.79	3.79	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGLH0	8.64	8.61	-0.36
shared	KGLHD	11.31	11.34	0.24
shared	KGLS	11.90	11.67	-1.86
shared	KGLSG	5.02	5.02	0.00
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PCUR	20.60	20.68	0.39
shared	PLDIA	3.89	3.82	-1.70
shared	PLMCD	12.33	12.33	-0.03
shared	SQLA	83.78	84.12	0.41
shared	dbwriter coalesce buffer	3.79	3.79	0.00
shared	flashback generation buff	3.80	3.80	0.00
shared	free memory	43.69	43.39	-0.68
shared	kglsim hash table bkts	4.00	4.00	0.00
shared	private strands	3.51	3.51	0.00
shared	row cache	7.23	7.23	0.00
streams	KTG hash buckets	1.26	1.26	0.00
streams	free memory	2.73	2.73	0.00
	buffer_cache	396.00	396.00	0.00
	fixed_sga	2.11	2.11	0.00
	log_buffer	6.41	6.41	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Capture Rate
Streams Apply
Streams Apply Rate
Buffered Queues
Buffered Queue Subscribers
Rule Set
Persistent Queues
Persistent Queues Rate
Persistent Queue Subscribers

Streams CPU/IO Usage

Streams processes ordered by Foreground CPU Time, descending

Session Type	First Logon	Foreground CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	1123 18:57:48	0.03	0.00	0.00
QMON Coordinator	1123 18:57:38	0.01	0.00	0.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 Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations
* indicates Rule Set activity (re)started between Begin/End snaps
SQL per Eval - average # 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

Rule	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	1	0.00	0	0.00	0.00	0.00	0.00	0.00	0.00	0

Back to Streams Statistics
Back to Top

Persistent Queues

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps
%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

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(11324)	1	0	100.00	0.00	0.00	0.00	0.00	22.08
SYS.AQ$_ALERT_QT_E(11323)	0	0			0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(82486)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(82156)	39	39	0.00	0.00	0.08	1.09	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
SYS.ALERT_QUE(11324)	0.00	0.00	0.00
SYS.AQ$_ALERT_QT_E(11323)	0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(82486)	0.00	0.00
SYSMAN.MGMT_TASK_Q(82156)	0.02	0.02	0.00	0.03

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Ordered by Queue Name, Subscriber Name
* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enqueue Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
B1GR2BASE_3938_ORCL(62)/SYS.ALERT_QUE	1	0.00	0.00	0.00
HAE_SUB(1)/SYS.ALERT_QUE	0
TRAINING_1830_ORCL(41)/SYS.ALERT_QUE	1	0.00	0.00	0.00
TRAINING_3872_ORCL(61)/SYS.ALERT_QUE	1	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
processes	36	129	150	150

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 Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

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 %
2,295	0.00	100.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

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	2,295	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

if IP/Public/Source at End snap is different a '*' is displayed

Parameter Name	Begin value	End value (if different)
_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.257.716404861, +FRA/orcl/controlfile/current.256.716404861
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_STD, BATCH_LOW
sga_max_size	813694976
sga_target	788529152
shared_pool_size	134217728
streams_pool_size	4194304
timed_statistics	TRUE
undo_tablespace	UNDOTBS1

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	99.93	In-memory Sort %:	99.70
Library Hit %:	99.46	Soft Parse %:	99.41
Execute to Parse %:	33.15	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	9.37	% Non-Parse CPU:	99.93