AWR Report for DB: MYCAR, Inst: mycar, Snaps: 9905-9906

body.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}
pre.awr {font:8pt Courier;color:black; background:White;}
h1.awr   {font:bold 20pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;border-bottom:1px solid #cccc99;margin-top:0pt; margin-bottom:0pt;padding:0px 0px 0px 0px;}
h2.awr   {font:bold 18pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}
h3.awr {font:bold 16pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}
li.awr {font: 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;}
th.awrnobg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;padding-left:4px; padding-right:4px;padding-bottom:2px}
th.awrbg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:White; background:#0066CC;padding-left:4px; padding-right:4px;padding-bottom:2px}
td.awrnc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;}
td.awrc    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;}
td.awrnclb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;}
td.awrncbb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;}
td.awrncrb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-right: thin solid black;}
td.awrcrb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-right: thin solid black;}
td.awrclb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;}
td.awrcbb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;border-right: thin solid black;}
a.awr {font:bold 8pt Arial,Helvetica,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;}
td.awrnct {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:White;vertical-align:top;}
td.awrct   {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:#FFFFCC; vertical-align:top;}
td.awrnclbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-left: thin solid black;}
td.awrncbbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;border-top: thin solid black;}
td.awrncrbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-right: thin solid black;}
td.awrcrbt     {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-right: thin solid black;}
td.awrclbt     {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;}
td.awrcbbt   {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;border-right: thin solid black;}
table.tdiff { border_collapse: collapse; }

WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
MYCAR	1652681432	mycar	1	26-Mar-13 18:03	11.2.0.1.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
vm192168000035	Linux x86 64-bit	4	4	4	8.00

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	9905	12-Jul-13 11:00:17	107	4.5
End Snap:	9906	12-Jul-13 11:43:41	110	4.2
Elapsed:		43.40 (mins)
DB Time:		193.14 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	784M	784M	Std Block Size:	8K
Shared Pool Size:	1,264M	1,264M	Log Buffer:	15,596K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	4.5	2.7	0.02	0.01
DB CPU(s):	2.4	1.5	0.01	0.00
Redo size:	6,216.2	3,798.1
Logical reads:	3,249.1	1,985.2
Block changes:	29.8	18.2
Physical reads:	0.5	0.3
Physical writes:	1.9	1.2
User calls:	769.2	470.0
Parses:	226.2	138.2
Hard parses:	0.1	0.1
W/A MB processed:	1.8	1.1
Logons:	0.1	0.1
Executes:	227.5	139.0
Rollbacks:	0.0	0.0
Transactions:	1.6

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.92	Soft Parse %:	99.96
Execute to Parse %:	0.59	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	54.38	% Non-Parse CPU:	99.82

Shared Pool Statistics

	Begin	End
Memory Usage %:	73.15	73.22
% SQL with executions>1:	92.66	95.00
% Memory for SQL w/exec>1:	87.42	93.87

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		6,196		53.47
log file sync	4,514	344	76	2.97	Commit
db file sequential read	824	23	28	0.20	User I/O
latch: shared pool	2	8	4221	0.07	Concurrency
latch: cache buffers chains	44	4	93	0.04	Concurrency

Host CPU (CPUs: 4 Cores: 4 Sockets: 4)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.63	0.87	41.8	17.8	0.1	40.4

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	8,192.0	8,192.0
SGA use (MB):	2,144.0	2,144.0
PGA use (MB):	465.5	470.7
% Host Mem used for SGA+PGA:	31.85	31.92

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

Back to Top

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

Back to Top

Time Model Statistics

Total time in database user-calls (DB Time): 11588.2s

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	11,037.00	95.24
DB CPU	6,196.02	53.47
PL/SQL execution elapsed time	6,066.90	52.35
parse time elapsed	28.11	0.24
hard parse elapsed time	14.45	0.12
connection management call elapsed time	14.23	0.12
sequence load elapsed time	0.29	0.00
hard parse (sharing criteria) elapsed time	0.12	0.00
PL/SQL compilation elapsed time	0.02	0.00
failed parse elapsed time	0.01	0.00
repeated bind elapsed time	0.00	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	11,588.21
background elapsed time	471.36
background cpu time	1.52

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	620,375
IDLE_TIME	421,141
IOWAIT_TIME	1,501
NICE_TIME	0
SYS_TIME	184,942
USER_TIME	434,998
LOAD	1	1
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	8,589,934,592
NUM_CPUS	4
NUM_CPU_CORES	4
NUM_CPU_SOCKETS	4
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
12-Jul 11:00:17	0.63
12-Jul 11:43:41	0.87	59.56	41.77	17.76	40.44	0.14

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 56.8% of Total DB time 11,588.21 (s)

Total FG Wait Time: 389.55 (s) DB CPU time: 6,196.02 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			6,196		53.47
Commit	4,514	0	344	76	2.97
User I/O	1,469	0	25	17	0.22
Concurrency	76	1	16	206	0.13
Network	1,481,457	0	4	0	0.03
Application	36	0	0	7	0.00
Other	46,557	100	0	0	0.00
System I/O	44	0	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
log file sync	4,514	0	344	76	1.06	2.97
db file sequential read	824	0	23	28	0.19	0.20
latch: shared pool	2	0	8	4221	0.00	0.07
latch: cache buffers chains	44	0	4	93	0.01	0.04
SQL*Net message to client	1,429,695	0	3	0	335.45	0.03
library cache: mutex X	5	0	2	406	0.00	0.02
direct path read	372	0	2	4	0.09	0.01
buffer busy waits	9	0	1	82	0.00	0.01
SQL*Net more data to client	48,297	0	1	0	11.33	0.01
db file parallel read	8	0	1	77	0.00	0.01
enq: TX - index contention	10	0	0	34	0.00	0.00
Disk file operations I/O	260	0	0	1	0.06	0.00
SQL*Net break/reset to client	36	0	0	7	0.01	0.00
asynch descriptor resize	46,556	100	0	0	10.92	0.00
SQL*Net more data from client	3,465	0	0	0	0.81	0.00
direct path sync	1	0	0	2	0.00	0.00
SQL*Net message from client	1,429,694	0	93,044	65	335.45
jobq slave wait	5,618	100	2,865	510	1.32

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
log file parallel write	9,648	0	235	24	2.26	49.85
control file parallel write	915	0	100	109	0.21	21.24
db file async I/O submit	1,107	0	81	73	0.26	17.19
os thread startup	98	0	29	297	0.02	6.17
ADR block file read	13	0	10	740	0.00	2.04
ADR block file write	5	0	5	909	0.00	0.96
control file sequential read	4,309	0	1	0	1.01	0.17
LGWR wait for redo copy	2	0	1	375	0.00	0.16
db file sequential read	74	0	0	3	0.02	0.05
Disk file operations I/O	58	0	0	0	0.01	0.00
log file sync	2	0	0	8	0.00	0.00
asynch descriptor resize	287	100	0	0	0.07	0.00
rdbms ipc message	15,924	68	58,729	3688	3.74
DIAG idle wait	5,151	100	5,207	1011	1.21
smon timer	9	100	2,700	300009	0.00
shared server idle wait	87	100	2,612	30021	0.02
Streams AQ: qmn slave idle wait	183	0	2,608	14252	0.04
Streams AQ: qmn coordinator idle wait	279	34	2,608	9348	0.07
Space Manager: slave idle wait	500	99	2,607	5215	0.12
pmon timer	992	86	2,602	2623	0.23
dispatcher timer	43	100	2,581	60018	0.01
SQL*Net message from client	270	0	5	17	0.06
class slave wait	11	0	0	0	0.00

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
ADR block file read	13	69.2						7.7	23.1
ADR block file write	5	80.0							20.0
ADR file lock	6	100.0
Disk file operations I/O	318	98.1	.6	.3	.3	.3		.3
LGWR wait for redo copy	2	50.0						50.0
SQL*Net break/reset to client	36	88.9	2.8					8.3
SQL*Net message to client	1429.9K	100.0						.0
SQL*Net more data from client	3465	99.9		.0		.0
SQL*Net more data to client	48.3K	100.0
asynch descriptor resize	46.8K	100.0
buffer busy waits	9	88.9						11.1
control file parallel write	915	45.1	3.3	.4	1.4	3.9	3.9	41.0	.9
control file sequential read	4353	99.9		.0				.0
cursor: mutex S	1	100.0
cursor: pin S	1	100.0
db file async I/O submit	1107	37.7	19.5	9.1	.9	2.2	4.1	25.5	1.1
db file parallel read	8						25.0	75.0
db file sequential read	896	44.0	1.1	6.8	16.1	15.4	5.1	11.3	.2
direct path read	372	96.0			.3	.5	1.1	2.2
direct path sync	1			100.0
direct path write	28	100.0
enq: TX - index contention	10	10.0			30.0	40.0		20.0
latch free	2	100.0
latch: In memory undo latch	3	100.0
latch: cache buffers chains	44	22.7		2.3		6.8	6.8	61.4
latch: row cache objects	1	100.0
latch: shared pool	2			50.0					50.0
library cache: mutex X	5	20.0					60.0		20.0
log file parallel write	9650	85.3	.8	.5	.6	1.1	1.2	10.2	.2
log file sync	4516	65.7	2.3	1.0	1.6	2.5	2.9	22.6	1.4
os thread startup	98						50.0	39.8	10.2
read by other session	1	100.0
DIAG idle wait	5151							90.9	9.1
SQL*Net message from client	1430K	90.5	2.0	.6	.4	.7	.5	4.9	.3
Space Manager: slave idle wait	500								100.0
Streams AQ: qmn coordinator idle wait	279	61.6		.4			.4	3.9	33.7
Streams AQ: qmn slave idle wait	183	49.2							50.8
class slave wait	11	100.0
dispatcher timer	43								100.0
jobq slave wait	5620	.0				.0	.0	99.9
pmon timer	992	6.8	.3	.2	.6	.5	1.4	3.2	87.0
rdbms ipc message	15.9K	4.3	.6	2.6	1.7	10.6	1.5	24.8	54.0
shared server idle wait	87								100.0
smon timer	9								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
ADR block file read	2	69.2			7.7			7.7	15.4
Disk file operations I/O	1	99.7			.3
LGWR wait for redo copy	1	50.0					50.0
SQL*Net break/reset to client	3	91.7		8.3
SQL*Net message to client	1	100.0				.0
buffer busy waits	1	88.9					11.1
control file parallel write	381	58.1	4.6	10.9	13.7	7.9	3.9	.7	.2
control file sequential read	2	100.0			.0		.0
db file async I/O submit	293	73.4	4.8	7.0	7.2	4.1	2.4	1.0	.1
db file parallel read	6	25.0	25.0	25.0	25.0
db file sequential read	103	88.5	4.1	2.9	1.9	1.8	.6	.2
direct path read	8	97.8	.8	.3	.3	.8
enq: TX - index contention	2	80.0	10.0		10.0
latch: cache buffers chains	27	38.6	6.8	25.0	25.0	4.5
library cache: mutex X	1	80.0						20.0
log file parallel write	1010	89.5	1.7	3.2	2.9	1.7	.7	.2	.0
log file sync	1079	76.0	3.9	5.8	6.4	4.5	2.1	1.3	.2
os thread startup	44	50.0	18.4	8.2	4.1	5.1	4.1	5.1	5.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	<16s
		% of Total Waits
ADR block file read	2	84.6	15.4
ADR block file write	1	80.0		20.0
control file parallel write	2	99.8	.2
db file async I/O submit	1	99.9	.1
latch: shared pool	1	50.0			50.0
log file parallel write	1	100.0	.0
log file sync	7	99.8	.1		.0
os thread startup	5	94.9	5.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)
SYS$USERS	11,575	6,188	1	8,430
mycar	13	8	0	14
SYS$BACKGROUND	0	0	0	17
mycarXDB	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
SYS$USERS	1469	25	76	16	1481263	4
mycar	0	0	0	0	194	0
SYS$BACKGROUND	157	0	98	29	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

Back to Top

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 94.6% of Total DB Time (s): 11,588

Captured PL/SQL account for 0.2% of Total DB Time (s): 11,588

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
10,854.11	16,629	0.65	93.67	56.00	0.00	9y8z91h8pk7d7		SELECT C.* FROM COUNTRY_CODE C...
28.36	43	0.66	0.24	5.13	0.11	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
8.80	3,754	0.00	0.08	5.41	85.79	59ygsb7wnbc69		insert into DIAG_DOWNLOAD_RECO...
8.72	15,884	0.00	0.08	30.97	0.00	87hfb2vvgt6tp		select 1 from sys_area_country...
7.06	25,878	0.00	0.06	37.62	0.00	0ay7wjuhgzj9k		select d.* from diag_soft_vers...
6.31	151,349	0.00	0.05	38.59	0.00	520mkxqpf15q8		select 1 from dual
5.11	19	0.27	0.04	79.66	0.00	7c9aurkrt70vn		select * from ( select p.*, pt...
4.65	67,011	0.00	0.04	37.47	0.00	5nggumnh49yzc		select * from SYS_PRODUCT wher...
4.34	3,498	0.00	0.04	53.98	0.00	83trawx9dw96s		select decode(ld.DISPLAY_NAME,...
3.76	2	1.88	0.03	31.64	0.00	7v67qgf92mxfb	PL/SQL Developer	-- --select * from user_carbas...

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 98.8% of Total CPU Time (s): 6,196

Captured PL/SQL account for 0.0% of Total CPU Time (s): 6,196

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,078.26	16,629	0.37	98.10	10,854.11	56.00	0.00	9y8z91h8pk7d7		SELECT C.* FROM COUNTRY_CODE C...
4.07	19	0.21	0.07	5.11	79.66	0.00	7c9aurkrt70vn		select * from ( select p.*, pt...
2.70	15,884	0.00	0.04	8.72	30.97	0.00	87hfb2vvgt6tp		select 1 from sys_area_country...
2.66	25,878	0.00	0.04	7.06	37.62	0.00	0ay7wjuhgzj9k		select d.* from diag_soft_vers...
2.44	151,349	0.00	0.04	6.31	38.59	0.00	520mkxqpf15q8		select 1 from dual
2.34	3,498	0.00	0.04	4.34	53.98	0.00	83trawx9dw96s		select decode(ld.DISPLAY_NAME,...
2.25	233	0.01	0.04	2.71	82.92	0.00	9nkj1gjfq5k91		select * from CC_USER where Lo...
1.74	67,011	0.00	0.03	4.65	37.47	0.00	5nggumnh49yzc		select * from SYS_PRODUCT wher...
1.72	3	0.57	0.03	3.16	54.29	0.00	4hyzzmwyq9k00	PL/SQL Developer	-- --select * from user_carbas...
1.46	43	0.03	0.02	28.36	5.13	0.11	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...

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 54.6% of Total User I/O Wait Time (s): 26

Captured PL/SQL account for 0.1% of Total User I/O Wait Time (s): 26

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
7.55	3,754	0.00	29.53	8.80	5.41	85.79	59ygsb7wnbc69	insert into DIAG_DOWNLOAD_RECO...
2.68	30	0.09	10.49	2.71	0.59	98.86	asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSIO...
1.36	27	0.05	5.32	1.84	10.89	74.00	9kyafghcc1xh6	select distinct temp.SOFT_ID, ...
1.01	5,064	0.00	3.95	1.48	15.97	68.37	dx9uj64072dw7	select * from SYS_PRODUCT_BURN...
0.79	74	0.01	3.09	1.36	0.29	58.25	2gyywxdrf81zu	select distinct s.SOFT_ID, s.S...
0.49	188	0.00	1.94	2.13	57.23	23.22	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
0.03	43	0.00	0.12	28.36	5.13	0.11	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
0.02	16,629	0.00	0.08	10,854.11	56.00	0.00	9y8z91h8pk7d7	SELECT C.* FROM COUNTRY_CODE C...
0.02	35,959	0.00	0.07	1.84	44.43	1.00	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
0.01	6,212	0.00	0.05	0.80	27.51	1.44	12gmchtj8pp10	select usd.*, s.soft_name as S...

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: 8,460,857

Captured SQL account for 86.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
2,764,007	16,629	166.22	32.67	10,854.11	56.00	0.00	9y8z91h8pk7d7	SELECT C.* FROM COUNTRY_CODE C...
640,031	15,884	40.29	7.56	8.72	30.97	0.00	87hfb2vvgt6tp	select 1 from sys_area_country...
461,247	25,878	17.82	5.45	7.06	37.62	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
434,540	25,878	16.79	5.14	3.09	46.29	0.00	5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERS...
342,578	189	1,812.58	4.05	1.29	69.68	0.00	1dv841hap05xc	SELECT COUNT(*) AS c from (sel...
342,578	189	1,812.58	4.05	1.38	66.59	0.00	6zzzr28dtrtpd	select * from ( select us.FREE...
339,773	188	1,807.30	4.02	2.13	57.23	23.22	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
292,868	67,011	4.37	3.46	4.65	37.47	0.00	5nggumnh49yzc	select * from SYS_PRODUCT wher...
262,385	16,399	16.00	3.10	2.48	28.72	0.00	9arur6gysf1z0	select t.*, '' as name from sy...
183,135	36,625	5.00	2.16	2.75	37.67	0.00	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
145,858	233	626.00	1.72	2.71	82.92	0.00	9nkj1gjfq5k91	select * from CC_USER where Lo...
105,240	5,595	18.81	1.24	1.10	45.77	0.00	0nrknqc0j9kgr	select * from ( select p.*, pt...
90,108	30,036	3.00	1.06	1.56	39.97	0.11	1fnv7qu1a8qsc	select * from product_down_set...

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: 1,369

Captured SQL account for 23.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
115	3,754	0.03	8.40	8.80	5.41	85.79	59ygsb7wnbc69	insert into DIAG_DOWNLOAD_RECO...
86	188	0.46	6.28	2.13	57.23	23.22	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
52	30	1.73	3.80	2.71	0.59	98.86	asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSIO...
23	27	0.85	1.68	1.84	10.89	74.00	9kyafghcc1xh6	select distinct temp.SOFT_ID, ...
21	74	0.28	1.53	1.36	0.29	58.25	2gyywxdrf81zu	select distinct s.SOFT_ID, s.S...
19	5,064	0.00	1.39	1.48	15.97	68.37	dx9uj64072dw7	select * from SYS_PRODUCT_BURN...
3	35,959	0.00	0.22	1.84	44.43	1.00	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
3	16,629	0.00	0.22	10,854.11	56.00	0.00	9y8z91h8pk7d7	SELECT C.* FROM COUNTRY_CODE C...
2	4,880	0.00	0.15	0.39	37.86	2.39	c00br6fharcvs	select c.* from diag_user_soft...
0	25,878	0.00	0.00	7.06	37.62	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...

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,369

Captured SQL account for 2.2% of Total

Total UnOptimized Read Requests: 1,369

Captured SQL account for 2.2% 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	%Opt	%Total	SQL Id	SQL Module	SQL Text
21	21	74	0.28	0.00	1.53	2gyywxdrf81zu		select distinct s.SOFT_ID, s.S...
3	3	35,959	0.00	0.00	0.22	4xbg42tpyp0gm		select * from SYS_PRODUCT_LANG...
3	3	16,629	0.00	0.00	0.22	9y8z91h8pk7d7		SELECT C.* FROM COUNTRY_CODE C...
2	2	4,880	0.00	0.00	0.15	c00br6fharcvs		select c.* from diag_user_soft...
1	1	3,754	0.00	0.00	0.07	59ygsb7wnbc69		insert into DIAG_DOWNLOAD_RECO...
0	0	25,878	0.00		0.00	0ay7wjuhgzj9k		select d.* from diag_soft_vers...
0	0	147	0.00		0.00	0bw79rck3c9j6	sqlplus@vm192168000035 (TNS V1-V3)	select 'username : ' \|\| s.user...
0	0	2	0.00		0.00	0fvkywuhw4whr	PL/SQL Developer	select m.* from (select s.sof...
0	0	5,595	0.00		0.00	0nrknqc0j9kgr		select * from ( select p.*, pt...
0	0	1	0.00		0.00	11p815z8hkfms	Oracle Enterprise Manager.purge system performan	DELETE MGMT_SYSTEM_PERFORMANCE...

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: 592,421

Captured SQL account for 95.9% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
151,349	151,350	1.00	6.31	38.59	0.00	520mkxqpf15q8	select 1 from dual
67,011	66,950	1.00	4.65	37.47	0.00	5nggumnh49yzc	select * from SYS_PRODUCT wher...
36,625	36,625	1.00	2.75	37.67	0.00	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
35,959	51,981	1.45	1.84	44.43	1.00	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
33,296	11,979	0.36	1.87	52.09	0.00	5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_...
30,036	0	0.00	1.56	39.97	0.11	1fnv7qu1a8qsc	select * from product_down_set...
25,878	648,875	25.07	7.06	37.62	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
25,878	82,143	3.17	3.09	46.29	0.00	5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERS...
16,629	15,591	0.94	10,854.11	56.00	0.00	9y8z91h8pk7d7	SELECT C.* FROM COUNTRY_CODE C...
16,399	515	0.03	2.48	28.72	0.00	9arur6gysf1z0	select t.*, '' as name from sy...
16,175	16,176	1.00	1.63	28.03	0.00	b43g51pg3hyza	select * from COUNTRY_CODE whe...
15,884	15,882	1.00	8.72	30.97	0.00	87hfb2vvgt6tp	select 1 from sys_area_country...
8,938	8,938	1.00	0.49	38.68	0.00	a6j566u48p8nf	select * from SYS_PDT_TYPE whe...
8,802	0	0.00	0.82	31.39	0.94	drvvh1sx3r1my	select l.LAN_NAME, d.* from SY...
8,387	8,387	1.00	0.52	43.10	0.00	1qp4my7430ph5	select * from DIAG_SOFT_VERSIO...
6,214	11,456	1.84	0.50	43.99	0.00	f6j95rdnz0mmw	select t.* from sys_product t ...
6,212	0	0.00	0.80	27.51	1.44	12gmchtj8pp10	select usd.*, s.soft_name as S...

Back to SQL Statistics

Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 588,926

Captured SQL account for 96.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
151,350	151,349	25.70	520mkxqpf15q8	select 1 from dual
67,011	67,011	11.38	5nggumnh49yzc	select * from SYS_PRODUCT wher...
36,625	36,625	6.22	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
35,959	35,959	6.11	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
33,296	33,296	5.65	5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_...
30,036	30,036	5.10	1fnv7qu1a8qsc	select * from product_down_set...
25,878	25,878	4.39	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
25,878	25,878	4.39	5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERS...
16,629	16,629	2.82	9y8z91h8pk7d7	SELECT C.* FROM COUNTRY_CODE C...
16,399	16,399	2.78	9arur6gysf1z0	select t.*, '' as name from sy...
16,176	16,175	2.75	b43g51pg3hyza	select * from COUNTRY_CODE whe...
15,884	15,884	2.70	87hfb2vvgt6tp	select 1 from sys_area_country...
8,938	8,938	1.52	a6j566u48p8nf	select * from SYS_PDT_TYPE whe...
8,802	8,802	1.49	drvvh1sx3r1my	select l.LAN_NAME, d.* from SY...
8,387	8,387	1.42	1qp4my7430ph5	select * from DIAG_SOFT_VERSIO...
6,214	6,214	1.06	f6j95rdnz0mmw	select t.* from sys_product t ...
6,212	6,212	1.05	12gmchtj8pp10	select usd.*, s.soft_name as S...

Back to SQL Statistics

Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,051,549	9	0.08	6uj36dxzapkn6		select count(*) from ((select ...

Back to SQL Statistics

Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
107	1	5s34t44u10q4g		SELECT a.name task_name, nvl(e...
72	106	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
69	1	9yt4ka3n2svmc	DBMS_SCHEDULER	update sys.scheduler$_job set ...
57	4	cabqn4dp09qck		SELECT TASK_CLASS, ROUND(NVL(S...
53	1	11p815z8hkfms	Oracle Enterprise Manager.purge system performan	DELETE MGMT_SYSTEM_PERFORMANCE...
51	70	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
51	156	g00cj285jmgsw		update sys.mon_mods$ set inser...
40	5	7gzxf61vj6wq4		SELECT ID FROM SYS.WRI$_ADV_TA...
37	3,754	59ygsb7wnbc69		insert into DIAG_DOWNLOAD_RECO...
35	1	7zsc0j9jsfm0h		select last_sample_date_num, l...
33	1	9rfkm1bf915a0		UPDATE WRH$_SEG_STAT_OBJ SET s...
29	27	9kyafghcc1xh6		select distinct temp.SOFT_ID, ...

Back to SQL Statistics

Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0ay7wjuhgzj9k	select d.* from diag_soft_version_detail d left join diag_soft_version v on v.version_id = d.version_id where v.soft_id = :1 order by d.upload_time desc
0bw79rck3c9j6	select 'username : ' \|\| s.username \|\| chr(10) \|\| 'schema : ' \|\| s.schemaname \|\| chr(10) \|\| 'osuser : ' \|\| s.osuser \|\| chr(10) \|\| 'program : ' \|\| s.program \|\| chr(10) \|\| 'spid : ' \|\| p.spid \|\| chr(10) \|\| 'sid : ' \|\| s.sid \|\| chr(10) \|\| 'serial# : ' \|\| s.serial# \|\| chr(10) \|\| 'kill string : ' \|\| '''' \|\| s.sid \|\| ', ' \|\| s.serial# \|\| '''' \|\| chr(10) \|\| 'machine : ' \|\| s.machine \|\| chr(10) \|\| 'terminal : ' \|\| s.terminal \|\| chr(10) \|\| 'sql_id : ' \|\| q.sql_id \|\| chr(10) \|\| 'sql_text : ' \|\| q.sql_text from v$session s, v$process p, v$sql q where s.paddr = p.addr and p.spid = 774 and s.sql_id = q.sql_id(+)
0fvkywuhw4whr	select m.* from (select s.soft_id, t1.version_no, t1.creater_time, t3.soft_name as soft_desc, t2.remark, t2.version_detail_id, nvl(buy_price, default_bprice) as price, v.CUR_ID, t4.cur_code from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, diag_soft_desc t3, sys_currency_unit t4 where s.pdt_type_id = p.pdt_type_id and s.soft_id = pr.soft_id and --v.cur_id = pr.cur_id ( (s.pdt_type_id not in (121, 215, 243) and v.cur_id = pr.cur_id) or (s.pdt_type_id in (121, 215, 243) --and p.filiale_id = 23550 and pr.cur_id in (select cu.cur_id from sys_currency_unit cu where upper(cu.cur_code)='JPY') ) ) and p.vender_id = v.vender_id and s.soft_id = t1.soft_id and t1.version_id = t2.version_id and s.soft_id = t3.soft_id and t3.lan_id = 1002 and pr.cur_id = t4.cur_id and s.soft_id not in (select soft_id from diag_user_soft_center where user_id = 25673 and serial_no = '982490041761') and s.soft_id not in (select uz.soft_id from user_order u, order_detail_info uz where u.order_id = uz.order_id and u.user_id = 25673 and u.order_status in (0, 1, 3) and u.serial_no = '982490041761') and p.serial_no = '982490041761' and p.pdt_state = 1 and p.user_id = 25673 and t2.lan_id = 1002 and s.VALID_FLAG = 1 and t1.VALID_FLAG = 1 and t2.CHECK_STATE = 2 and pr.STATE = 2)m, (select r.soft_id, max(version_no)as vers ion_no, lan_id from diag_soft_version r , diag_soft_version_detail rr, diag_soft s where r.version_id = rr.version_id and lan_id = 1002 and s.soft_id = r.soft_id and s.valid_flag = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2 group by r.soft_id, lan_id )n where m.soft_id = n.soft_id and m.version_no = n.version_no
0nrknqc0j9kgr	select * from ( select p.*, pt.PDT_TYPE, sc.name, v.VENDER_NAME, f.VENDER_NAME as FILIAL_ENAME, c.customer_name from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_ID left join sys_vender f on p.filiale_id = f.VENDER_ID left join customer c on c.customer_number_id = p.customer_number where 1=1 AND p.PRODUCT_PART = :1 AND p.PDT_STATE = :2 AND USER_ID = :3 order by UPDATE_TIME desc ) where rownum <= 2147483647
11p815z8hkfms	DELETE MGMT_SYSTEM_PERFORMANCE_LOG WHERE TIME < :B2 AND ROWNUM <= :B1
12gmchtj8pp10	select usd.*, s.soft_name as SOFT_NAME, su.cc as cc, decode(mu.user_name, null, '鏈?煡', mu.user_name) as LAST_UPD_USER_NAME from USER_DOWN_SOFT_LIMITS usd join SYS_USER su on su.user_id = usd.user_id left join sys_manager_user mu on mu.user_id = usd.last_upd_user_id join DIAG_SOFT s on usd.soft_id = s.soft_id where usd.USER_ID = :1 and usd.IS_OPEN_FLAG = :2 and usd.SOFT_TYPE = :3 order by usd.CREATE_TIME 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))
1dv841hap05xc	SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID AND sd.LAN_ID = :1 ) join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID where exists( select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') AND (v.VALID_FLAG = :2) AND (d.CHECK_STATE = :3) ) AND (s.VALID_FLAG = :4) AND (us.SERIAL_NO = :5) AND (s.pdt_type_id = :6) order by upper(s.SOFT_NAME) asc
1fnv7qu1a8qsc	select * from product_down_setting p where p.serial_no=:1
1qp4my7430ph5	select * from DIAG_SOFT_VERSION where VERSION_ID = :1
2gyywxdrf81zu	select distinct s.SOFT_ID, s.SOFT_NAME, v.VERSION_NO, d.LAN_ID, decode(sd.SOFT_NAME, null, s.SOFT_NAME, sd.SOFT_NAME) as SOFT_DESC, d.VERSION_DETAIL_ID, d.REMARK, d.FILE_SIZE, to_char(d.UPLOAD_TIME, 'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(s.VEHICLE_TYPE_ID, null, 1, s.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(s.SOFT_APPLICABLE_AREA_ID, null, 1, s.SOFT_APPLICABLE_AREA_ID) as SOFT_APPLICABLE_AREA, us.free_end_time from DIAG_USER_SOFT_CENTER us, DIAG_SOFT_VERSION_DETAIL d, DIAG_SOFT_VERSION v, DIAG_SOFT s , DIAG_SOFT_DESC sd where us.SOFT_ID=s.SOFT_ID and d.VERSION_ID=v.VERSION_ID and v.SOFT_ID=s.SOFT_ID and (sd.SOFT_ID=s.SOFT_ID AND sd.LAN_ID = :1 ) AND ((not exists (select 'X' from DIAG_SOFT_VERSION_DETAIL d2 where d2.LAN_ID=:2 and d2.CHECK_STATE=2 and d2.VERSION_Id=v.VERSION_Id ) and d.LAN_ID=:3 ) or (d.LAN_ID=:4)) and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') and d.CHECK_STATE=2 and v.VALID_FLAG=1 and s.VALID_FLAG=1 AND s.SOFT_ID=:5 AND us.SERIAL_NO=:6 order by s.SOFT_ID desc, v.VERSION_NO desc, d.VERSI ON_DETAIL_ID desc
4hyzzmwyq9k00	-- --select * from user_carbaseinfo uc where uc.serial_no like '965190000051' --select * from diag_soft ds where ds.soft_id=2089 select m.* from (select s.soft_id, t1.version_no, t1.creater_time, t3.soft_name as soft_desc, t2.remark, t2.version_detail_id, nvl(buy_price, default_bprice) as price, v.CUR_ID, t4.cur_code from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, diag_soft_desc t3, sys_currency_unit t4 where s.pdt_type_id = p.pdt_type_id and s.soft_id = pr.soft_id and --v.cur_id = pr.cur_id ( (s.pdt_type_id not in (121, 215, 243) and v.cur_id = pr.cur_id) or (s.pdt_type_id in (121, 215, 243) and p.filiale_id = 23550 and pr.cur_id in (select cu.cur_id from sys_currency_unit cu where upper(cu.cur_code)='JPY') ) or (s.pdt_type_id in (121, 215, 243) and p.filiale_id <> 23550 and v.cur_id = pr.cur_id ) ) and p.vender_id = v.vender_id and s.soft_id = t1.soft_id and t1.version_id = t2.version_id and s.soft_id = t3.soft_id and t3.lan_id = 1002 and pr.cur_id = t4.cur_id and s.soft_id not in (select soft_id from diag_user_soft_center where user_id = 25673 and serial_no = '982490041761') and s.soft_id not in (select uz.soft_id from user_order u, order_detail_info uz where u.order_id = uz.order_id and u.user_id = 25673 and u.order_status in (0, 1, 3) and u .serial_no = '982490041761') and p.serial_no = '982490041761' and p.pdt_state = 1 and p.user_id = 25673 and t2.lan_id = 1002 and s.VALID_FLAG = 1 and t1.VALID_FLAG = 1 and t2.CHECK_STATE = 2 and pr.STATE = 2)m, (select r.soft_id, max(version_no)as version_no, lan_id from diag_soft_version r , diag_soft_version_detail rr, diag_soft s where r.version_id = rr.version_id and lan_id = 1002 and s.soft_id = r.soft_id and s.valid_flag = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2 group by r.soft_id, lan_id )n where m.soft_id = n.soft_id and m.version_no = n.version_no -- select * from sys_product sp where sp.serial_no='982490041761'
4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
520mkxqpf15q8	select 1 from dual
59ygsb7wnbc69	insert into DIAG_DOWNLOAD_RECORD (DOWNLOAD_ID, DOWNLOAD_IP, DOWNLOAD_PERSON, DOWNLOAD_TIME, LAN_Id, SOFT_ID, SOFT_NAME, SOFT_TYPE, USER_ID, VERSION_DETAIL_ID, VERSION_ID, VERSION_NO, SERIAL_NO) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERSION v where exists (select 'X' from DIAG_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID AND d.CHECK_STATE=:1 ) and exists(select 'X' from DIAG_SOFT s where s.SOFT_ID=v.SOFT_ID and s.VALID_FLAG=1) and v.VALID_FLAG=1 and v.SOFT_ID = :2 AND to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(:3, 'yyyy-mm-dd') order by v.VERSION_NO desc
5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2) and LAN_ID = :3
5nggumnh49yzc	select * from SYS_PRODUCT where SERIAL_NO = :1
5s34t44u10q4g	SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6uj36dxzapkn6	select count() from ((select distinct m. from CNT_MESSAGE_DESC m, sys_user u where u.cc=:1 and m.MESSAGE_TYPE = 0 and (m.read_user is null or m.read_user not like '%46849%')) UNION (select distinct m.* from CNT_MESSAGE_DESC m, sys_user u, sys_product sp, sys_vender sv where (m.MESSAGE_TYPE = 3 and sp.USER_ID = u.USER_ID and m.send_user_id = sp.VENDER_ID and sv.VENDER_ID = sp.VENDER_ID) and u.cc = :2 and (m.read_user is null or m.read_user not like '%46849%'))UNION ( select distinct m.* from CNT_MESSAGE_DESC m where m.MESSAGE_TYPE = 2 and m.receive_user_id= :3 and m.read_flag = 0 ) )where RECEIVE_VALID_FLAG = 1
6zzzr28dtrtpd	select * from ( select us.FREE_END_TIME, vv.version_no MAX_VERSION_No, s.*, decode(sd.SOFT_NAME, null, s.SOFT_NAME, sd.SOFT_NAME) as softDesc, decode(sd.REMARK, null, s.REMARK, sd.REMARK) as remarkDesc from (select max(version_no) version_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID AND sd.LAN_ID = :1 ) join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID where exists( select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') AND (v.VALID_FLAG = :2) AND (d.CHECK_STATE = :3) ) AND (s.VALID_FLAG = :4) AND (us.SERIAL_NO = :5) AND (s.pdt_type_id = :6) order by upper(s.SOFT_NAME) asc ) where rownum <= 10000
7c9aurkrt70vn	select * from ( select p.*, pt.PDT_TYPE, sc.name, v.VENDER_NAME, f.VENDER_NAME as FILIAL_ENAME, c.customer_name from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_ID left join sys_vender f on p.filiale_id = f.VENDER_ID left join customer c on c.customer_number_id = p.customer_number where 1=1 AND p.PRODUCT_PART = :1 order by UPDATE_TIME desc ) where rownum <= 10
7gzxf61vj6wq4	SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1
7v67qgf92mxfb	-- --select * from user_carbaseinfo uc where uc.serial_no like '965190000051' --select * from diag_soft ds where ds.soft_id=2089 select m.* from (select s.soft_id, t1.version_no, t1.creater_time, t3.soft_name as soft_desc, t2.remark, t2.version_detail_id, nvl(buy_price, default_bprice) as price, v.CUR_ID, t4.cur_code from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, diag_soft_desc t3, sys_currency_unit t4 where s.pdt_type_id = p.pdt_type_id and s.soft_id = pr.soft_id and --v.cur_id = pr.cur_id ( (s.pdt_type_id not in (121, 215, 243) and v.cur_id = pr.cur_id) or (s.pdt_type_id in (121, 215, 243) and p.filiale_id = 23550 and pr.cur_id in (select cu.cur_id from sys_currency_unit cu where upper(cu.cur_code)='JPY') ) or (s.pdt_type_id in (121, 215, 243) and p.filiale_id != 23550 and v.cur_id = pr.cur_id ) ) and p.vender_id = v.vender_id and s.soft_id = t1.soft_id and t1.version_id = t2.version_id and s.soft_id = t3.soft_id and t3.lan_id = 1002 and pr.cur_id = t4.cur_id and s.soft_id not in (select soft_id from diag_user_soft_center where user_id = 25673 and serial_no = '982490041761') and s.soft_id not in (select uz.soft_id from user_order u, order_detail_info uz where u.order_id = uz.order_id and u.user_id = 25673 and u.order_status in (0, 1, 3) and u.seria l_no = '982490041761') and p.serial_no = '982490041761' and p.pdt_state = 1 and p.user_id = 25673 and t2.lan_id = 1002 and s.VALID_FLAG = 1 and t1.VALID_FLAG = 1 and t2.CHECK_STATE = 2 and pr.STATE = 2)m, (select r.soft_id, max(version_no)as version_no, lan_id from diag_soft_version r , diag_soft_version_detail rr, diag_soft s where r.version_id = rr.version_id and lan_id = 1002 and s.soft_id = r.soft_id and s.valid_flag = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2 group by r.soft_id, lan_id )n where m.soft_id = n.soft_id and m.version_no = n.version_no -- select * from sys_product sp where sp.serial_no='982490041761'
7zsc0j9jsfm0h	select last_sample_date_num, last_sample_date, total_samples from WRI$_DBU_CPU_USAGE_SAMPLE where dbid = :dbid and version = :version
83trawx9dw96s	select decode(ld.DISPLAY_NAME, null, l.LAN_NAME, ld.DISPLAY_NAME) LAN_NAME, d.* from DIAG_SOFT_VERSION_DETAIL d left join sys_lan l on d.LAN_ID=l.LAN_ID left join SYS_LAN_DISPLAY ld on ld.LAN_ID=l.LAN_ID AND (ld.DISP_LAN_ID = :1) WHERE (d.VERSION_ID = :2) AND (d.CHECK_STATE = :3)
87hfb2vvgt6tp	select 1 from sys_area_country where 1=1 AND DOWNLOAD_AREA_ID = (select distinct t1.download_area_id from sys_vender t1 join sys_vender t2 ON (t2.user_type=2 and t1.vender_id = t2.filiale_id) or(t2.user_type=3 and t1.vender_id =t2.vender_id) join sys_product tp ON (t2.vender_id = tp.vender_id )or (tp.vender_id is null and t2.vender_id = tp.filiale_id) where t1.user_type = 3 and tp.serial_no = :1) and country_id = :2
89nfp8fv1y8vw	SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID AND sd.LAN_ID = :1 ) join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID where exists( select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') AND (v.VALID_FLAG = :2) AND (d.CHECK_STATE = :3) ) AND (s.VALID_FLAG = :4) AND (us.SERIAL_NO = :5) AND (s.pdt_type_id = :6) order by s.UPDATE_TIME desc
9arur6gysf1z0	select t.*, '' as name from sys_product_ip_rule t where t.product_id = :1 and (t.start_time is null or t.start_time<= sysdate) and (t.end_time is null or t.end_time>sysdate )
9kyafghcc1xh6	select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK, temp.FILE_SIZE, to_char(temp.UPLOAD_TIME, 'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHICLE_TYPE_ID, null, 1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APPLICABLE_AREA_ID, null, 1, temp.SOFT_APPLICABLE_AREA_ID) as SOFT_APPLICABLE_AREA, temp.free_end_time from ( select s.SOFT_ID, s.SOFT_NAME, v.VERSION_NO, d.LAN_ID, decode(sd.SOFT_NAME, null, s.SOFT_NAME, sd.SOFT_NAME) as SOFT_DESC, d.VERSION_DETAIL_ID, d.REMARK, d.FILE_SIZE, d.UPLOAD_TIME, us.free_end_time, s.VEHICLE_TYPE_ID, s.SOFT_APPLICABLE_AREA_ID, ROW_NUMBER() OVER(PARTITION BY v.SOFT_ID ORDER BY v.VERSION_NO DESC) RN from DIAG_USER_SOFT_CENTER us left join sys_user su on us.user_id=su.user_id left join DIAG_SOFT s on s.soft_id=us.soft_id left join DIAG_SOFT_VERSION v on v.soft_id=s.soft_id left join DIAG_SOFT_VERSION_DETAIL d on d.version_id=v.version_id join sys_product sp on (sp.serial_no=us.serial_no and sp.pdt_type_id=s.pdt_type_id) left join DIAG_SOFT_DESC sd on (sd.soft_id=s.soft_id AND sd.LAN_ID = :1 ) where 1=1 AND (( not exists (select 'X' from DIAG_SOFT_ VERSION_DETAIL d2 where d2.LAN_ID=:2 and d2.CHECK_STATE=2 and d2.VERSION_Id=v.VERSION_Id ) and d.LAN_ID=:3 ) or (d.LAN_ID=:4)) and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') and d.CHECK_STATE=2 and v.VALID_FLAG=1 and s.VALID_FLAG=1 AND us.SERIAL_NO=:5 AND su.cc=:6 ) temp where temp.RN=1 order by temp.SOFT_ID desc, temp.VERSION_DETAIL_ID
9nkj1gjfq5k91	select * from CC_USER where Lower(USER_NAME) = :1
9rfkm1bf915a0	UPDATE WRH$_SEG_STAT_OBJ SET snap_id = :lah_snap_id WHERE dbid = :dbid AND (OBJ#, DATAOBJ#) IN (SELECT NUM1_KEWRATTR, NUM2_KEWRATTR FROM X$KEWRATTRSTALE)
9y8z91h8pk7d7	SELECT C.* FROM COUNTRY_CODE C JOIN (select country_code from COUNTRY_IP_RANGE IP WHERE IP.Start_Ip1 <= ip_to_number(:1) AND IP.End_Ip1 >= ip_to_number(:2) and rownum=1) IP ON C.COUNTRY_CODE = ip.country_code
9yt4ka3n2svmc	update sys.scheduler$_job set last_enabled_time = :1, next_run_date = :2, job_status = :3 where obj# = :4
a6j566u48p8nf	select * from SYS_PDT_TYPE where PDT_TYPE_ID = :1
asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSION_ID, r.SOFT_ID, r.VERSION_NO, r.VERSION_DETAIL_ID, r.USER_ID, r.LAN_ID, r.DOWNLOAD_PERSON, r.DOWNLOAD_TIME, r.SOFT_TYPE, r.DOWNLOAD_IP, r.SERIAL_NO, l.LAN_NAME as LAN_NAME, (select soft_name from diag_soft where soft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_LAN l on r.serial_no =:1 and r.soft_type = 2 and r.lan_id = l.lan_id order by r.DOWNLOAD_TIME desc
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
b43g51pg3hyza	select * from COUNTRY_CODE where COUNTRY_CODE = :1
bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DIAG_SOFT_VERSION_DETAIL d left join sys_lan l on d.LAN_ID=l.LAN_ID where VERSION_DETAIL_ID = :1
c00br6fharcvs	select c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_id join diag_soft_version v on v.soft_id = s.soft_id join diag_soft_version_detail d on d.version_id = v.version_id join sys_product p on p.serial_no = c.serial_no where d.version_detail_id = :1 and c.serial_no = :2 and c.user_id = :3
cabqn4dp09qck	SELECT TASK_CLASS, ROUND(NVL(SUM(THROUGHPUT), 0), 2), NVL(SUM(TOTAL_VALUE), 0), NVL(SUM(TOTAL_DURATION), 0) FROM (SELECT CLIENT_DATA WORKER_ID, ACTION TASK_CLASS, NVL(AVG(VALUE1000/ DECODE(DURATION, 0, 1000, DURATION)), 0) THROUGHPUT, SUM(VALUE) TOTAL_VALUE, SUM(DURATION)/1000 TOTAL_DURATION, COUNT() RECORDS FROM MGMT_SYSTEM_PERFORMANCE_LOG LOG WHERE LOG.JOB_NAME = :B3 AND LOG.MODULE = :B2 AND LOG.TIME > (SYSDATE-:B1 /1440) AND LOG.IS_TOTAL = 'Y' GROUP BY CLIENT_DATA, ACTION ) GROUP BY TASK_CLASS
drvvh1sx3r1my	select l.LAN_NAME, d.* from SYS_PDT_TYPE_DESC d, sys_lan l where d.LAN_ID=l.LAN_ID AND d.PDT_TYPE_ID = :1
dx9uj64072dw7	select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
f6j95rdnz0mmw	select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 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

Back to Top

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	78	0.03	0.02
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	309	0.12	0.07
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	3	0.00	0.00
Batched IO same unit count	161	0.06	0.04
Batched IO single block count	78	0.03	0.02
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	70	0.03	0.02
Batched IO vector read count	3	0.00	0.00
Block Cleanout Optim referenced	10	0.00	0.00
CCursor + sql area evicted	20	0.01	0.00
CPU used by this session	616,465	236.73	144.64
CPU used when call started	616,300	236.67	144.60
CR blocks created	81	0.03	0.02
Cached Commit SCN referenced	136	0.05	0.03
Commit SCN cached	95	0.04	0.02
DB time	1,423,146	546.51	333.92
DBWR checkpoint buffers written	4,872	1.87	1.14
DBWR checkpoints	0	0.00	0.00
DBWR object drop 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	377	0.14	0.09
DBWR undo block writes	1,025	0.39	0.24
DFO trees parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	12,661	4.86	2.97
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	124	0.05	0.03
Heap Segment Array Updates	70	0.03	0.02
IMU CR rollbacks	81	0.03	0.02
IMU Flushes	1,606	0.62	0.38
IMU Redo allocation size	4,513,048	1,733.07	1,058.90
IMU commits	2,695	1.03	0.63
IMU contention	126	0.05	0.03
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	2	0.00	0.00
IMU undo allocation size	10,867,376	4,173.22	2,549.83
IMU- failed to get a private strand	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	372	0.14	0.09
OS Involuntary context switches	0	0.00	0.00
OS Page faults	0	0.00	0.00
OS Page reclaims	0	0.00	0.00
OS System time used	0	0.00	0.00
OS User time used	0	0.00	0.00
OS Voluntary context switches	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
RowCR - row contention	1	0.00	0.00
RowCR attempts	63	0.02	0.01
RowCR hits	62	0.02	0.01
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	1,429,714	549.03	335.46
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	223	0.09	0.05
application wait time	26	0.01	0.01
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	10,926	4.20	2.56
branch node splits	0	0.00	0.00
buffer is not pinned count	3,029,905	1,163.52	710.91
buffer is pinned count	3,468,567	1,331.98	813.84
bytes received via SQL*Net from client	151,004,878	57,987.94	35,430.52
bytes sent via SQL*Net to client	534,853,575	205,391.08	125,493.57
calls to get snapshot scn: kcmgss	598,738	229.92	140.48
calls to kcmgas	6,548	2.51	1.54
calls to kcmgcs	303,787	116.66	71.28
cell physical IO interconnect bytes	171,533,312	65,871.14	40,247.14
change write time	152	0.06	0.04
cleanout - number of ktugct calls	319	0.12	0.07
cleanouts and rollbacks - consistent read gets	1	0.00	0.00
cleanouts only - consistent read gets	12	0.00	0.00
cluster key scan block gets	41	0.02	0.01
cluster key scans	37	0.01	0.01
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	4	0.00	0.00
commit batch/immediate requested	4	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	9	0.00	0.00
commit cleanout failures: cannot pin	111	0.04	0.03
commit cleanouts	23,759	9.12	5.57
commit cleanouts successfully completed	23,639	9.08	5.55
commit immediate performed	4	0.00	0.00
commit immediate requested	4	0.00	0.00
commit txn count during cleanout	2,125	0.82	0.50
concurrency wait time	4,474	1.72	1.05
consistent changes	176	0.07	0.04
consistent gets	8,347,941	3,205.72	1,958.69
consistent gets - examination	1,247,932	479.22	292.80
consistent gets direct	386	0.15	0.09
consistent gets from cache	8,347,555	3,205.58	1,958.60
consistent gets from cache (fastpath)	6,932,015	2,661.99	1,626.47
cursor authentications	96	0.04	0.02
data blocks consistent reads - undo records applied	164	0.06	0.04
db block changes	77,711	29.84	18.23
db block gets	112,916	43.36	26.49
db block gets direct	65	0.02	0.02
db block gets from cache	112,851	43.34	26.48
db block gets from cache (fastpath)	41,012	15.75	9.62
deferred (CURRENT) block cleanout applications	13,247	5.09	3.11
dirty buffers inspected	0	0.00	0.00
enqueue conversions	520	0.20	0.12
enqueue deadlocks	0	0.00	0.00
enqueue releases	43,022	16.52	10.09
enqueue requests	43,023	16.52	10.09
enqueue timeouts	0	0.00	0.00
enqueue waits	10	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	592,421	227.50	139.00
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	104,217,776	40,021.05	24,452.79
free buffer inspected	2,244	0.86	0.53
free buffer requested	2,365	0.91	0.55
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	73	0.03	0.02
hot buffers moved to head of LRU	847	0.33	0.20
immediate (CR) block cleanout applications	13	0.00	0.00
immediate (CURRENT) block cleanout applications	765	0.29	0.18
index crx upgrade (positioned)	32	0.01	0.01
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	703	0.27	0.16
index fetch by key	339,710	130.45	79.71
index scans kdiixs1	927,356	356.12	217.59
leaf node 90-10 splits	61	0.02	0.01
leaf node splits	106	0.04	0.02
lob reads	410	0.16	0.10
lob writes	34	0.01	0.01
lob writes unaligned	34	0.01	0.01
logons cumulative	203	0.08	0.05
max cf enq hold time	0	0.00	0.00
messages received	6,364	2.44	1.49
messages sent	6,364	2.44	1.49
min active SCN optimization applied on CR	636	0.24	0.15
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	6,681,746	2,565.88	1,567.75
non-idle wait count	1,557,312	598.03	365.39
non-idle wait time	85,082	32.67	19.96
opened cursors cumulative	590,992	226.95	138.67
parse count (describe)	0	0.00	0.00
parse count (failures)	18	0.01	0.00
parse count (hard)	214	0.08	0.05
parse count (total)	588,926	226.16	138.18
parse time cpu	1,105	0.42	0.26
parse time elapsed	2,032	0.78	0.48
physical read IO requests	1,369	0.53	0.32
physical read bytes	11,214,848	4,306.65	2,631.36
physical read total IO requests	5,731	2.20	1.34
physical read total bytes	82,853,888	31,817.03	19,440.14
physical read total multi block requests	0	0.00	0.00
physical reads	1,369	0.53	0.32
physical reads cache	983	0.38	0.23
physical reads cache prefetch	101	0.04	0.02
physical reads direct	386	0.15	0.09
physical reads direct (lob)	372	0.14	0.09
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	3,357	1.29	0.79
physical write bytes	40,443,904	15,531.01	9,489.42
physical write total IO requests	10,013	3.85	2.35
physical write total bytes	88,679,424	34,054.11	20,807.00
physical write total multi block requests	45	0.02	0.01
physical writes	4,937	1.90	1.16
physical writes direct	65	0.02	0.02
physical writes direct (lob)	27	0.01	0.01
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	4,872	1.87	1.14
physical writes non checkpoint	1,557	0.60	0.37
pinned buffers inspected	0	0.00	0.00
pinned cursors current	1	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,059	1.17	0.72
queries parallelized	0	0.00	0.00
recursive calls	228,709	87.83	53.66
recursive cpu usage	1,309	0.50	0.31
redo blocks checksummed by FG (exclusive)	18,026	6.92	4.23
redo blocks written	35,650	13.69	8.36
redo buffer allocation retries	0	0.00	0.00
redo entries	23,623	9.07	5.54
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	530	0.20	0.12
redo size	16,187,436	6,216.20	3,798.08
redo size for direct writes	534,820	205.38	125.49
redo subscn max counts	1,535	0.59	0.36
redo synch time	34,558	13.27	8.11
redo synch writes	4,537	1.74	1.06
redo wastage	1,413,080	542.64	331.55
redo write time	23,534	9.04	5.52
redo writes	4,824	1.85	1.13
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	16	0.01	0.00
rollbacks only - consistent read gets	80	0.03	0.02
root node splits	0	0.00	0.00
rows fetched via callback	267,760	102.82	62.82
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	447,066	171.68	104.90
session logical reads	8,460,857	3,249.08	1,985.18
shared hash latch upgrades - no wait	114,777	44.08	26.93
shared hash latch upgrades - wait	12	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	82,221	31.57	19.29
sorts (rows)	3,220,585	1,236.75	755.65
sql area evicted	251	0.10	0.06
sql area purged	18	0.01	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	227	0.09	0.05
table fetch by rowid	2,641,308	1,014.30	619.73
table fetch continued row	50,985	19.58	11.96
table scan blocks gotten	1,813,528	696.42	425.51
table scan rows gotten	129,374,836	49,681.70	30,355.43
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	108,112	41.52	25.37
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	2,790	1.07	0.65
total number of cf enq holders	196	0.08	0.05
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	4	0.00	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	4,373,168	1,679.36	1,026.08
user I/O wait time	2,563	0.98	0.60
user calls	2,003,149	769.24	470.00
user commits	4,259	1.64	1.00
user rollbacks	3	0.00	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	79,015	30.34	18.54
write clones created in background	0	0.00	0.00
write clones created in foreground	1	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 max	1,306,673,622,824	1,307,131,297,120
session pga memory	431,149,092,752	431,276,601,816
session pga memory max	485,362,064,560	485,454,070,168
session cursor cache count	12,568,307	12,573,971
session uga memory	759,867,355,465,408	760,082,114,068,376
opened cursors current	477	460
workarea memory allocated	1,724	1,724
logons current	107	110

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

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

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)
Others	68M	1.68	.026112	29M	0.70	.011136	6206	32.20
DBWR	0M	0.00	0M	38M	1.28	.014592	1107	72.68
LGWR	0M	0.00	0M	18M	1.85	.006912	4825	48.23
Buffer Cache Reads	7M	0.38	.002688	0M	0.00	0M	890	27.36
Direct Reads	2M	0.14	.000768	0M	0.00	0M	372	4.04
Direct Writes	0M	0.00	0M	1M	0.01	.000384	28	0.00
TOTAL:	77M	2.20	.029569	86M	3.85	.033025	13.4K	40.13

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
Control File	69M	1.67	.026496	29M	0.70	.011136	0.17
Data File	10M	0.53	.003840	38M	1.29	.014592	18.72
Log File	0M	0.00	0M	18M	1.85	.006912
TOTAL:	79M	2.20	.030337	85M	3.85	.032641	4.64

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)
Others	69M	1.68	.026496	29M	0.70	.011136	4376	0.18
Others (Control File)	69M	1.67	.026496	29M	0.70	.011136	4353	0.17
Others (Data File)	0M	0.01	0M	0M	0.00	0M	23	1.35
DBWR	0M	0.00	0M	38M	1.28	.014592	0
DBWR (Data File)	0M	0.00	0M	38M	1.28	.014592	0
LGWR	0M	0.00	0M	18M	1.85	.006912	0
LGWR (Log File)	0M	0.00	0M	18M	1.85	.006912	0
Buffer Cache Reads	7M	0.38	.002688	0M	0.00	0M	874	26.46
Buffer Cache Reads (Data File)	7M	0.38	.002688	0M	0.00	0M	874	26.46
Direct Reads	2M	0.14	.000768	0M	0.00	0M	0
Direct Reads (Data File)	2M	0.14	.000768	0M	0.00	0M	0
Direct Writes	0M	0.00	0M	1M	0.01	.000384	0
Direct Writes (Data File)	0M	0.00	0M	1M	0.01	.000384	0
TOTAL:	78M	2.20	.029953	86M	3.85	.033025	5250	4.56

Back to IO Stats

Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
MYCAR	1,281	17.10	1.00	1,801	1	8	0.00
UNDOTBS1	0	0.00	0.00	772	0	1	0.00
SYSAUX	77	4.29	1.00	653	0	0	0.00
SYSTEM	1	50.00	1.00	78	0	1	740.00
PASSPORT	11	78.18	1.00	53	0	0	0.00

Back to IO Stats

Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
MYCAR	/oracle/oradata/mycar/mycar.dbf	1,105	14.13	1.00	1,189	0	0.00
MYCAR	/oracle/oradata/mycar/mycar01.dbf	176	35.74	1.00	612	8	0.00
PASSPORT	/oracle/oradata/mycar/passport.dbf	11	78.18	1.00	53	0	0.00
SYSAUX	/oracle/oradata/mycar/sysaux01.dbf	77	4.29	1.00	653	0	0.00
SYSTEM	/oracle/oradata/mycar/system01.dbf	1	50.00	1.00	78	1	740.00
UNDOTBS1	/oracle/oradata/mycar/undotbs01.dbf	0			772	1	0.00

Back to IO Stats

Back to Top

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

Back to Top

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	96,530	100	8,460,227	984	4,872	0	0	10

Back to Buffer Pool Statistics

Back to Top

Checkpoint Activity

Total Physical Writes: 4,937

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	4,872	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

Back to Top

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	14	626	5847	17258	995328	17258
E	0	14	577	5634	25642	995328	25642

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	80	0.10	10	1.65	2,597,592	1	1391801.00
D	160	0.20	20	1.02	1,596,555	1	66649.00
D	240	0.30	30	1.00	1,576,621	1	40261.00
D	320	0.40	39	1.00	1,572,644	1	34997.00
D	400	0.50	49	1.00	1,571,988	1	34128.00
D	480	0.60	59	1.00	1,571,533	1	33526.00
D	560	0.70	69	1.00	1,571,196	1	33080.00
D	640	0.80	79	1.00	1,570,895	1	32681.00
D	720	0.90	89	1.00	1,570,651	1	32359.00
D	800	1.00	99	1.00	1,570,465	1	32112.00
D	880	1.10	108	1.00	1,570,256	1	31835.00
D	960	1.20	118	1.00	1,570,045	1	31556.00
D	1,040	1.30	128	1.00	1,569,902	1	31366.00
D	1,120	1.40	138	1.00	1,569,808	1	31243.00
D	1,200	1.50	148	1.00	1,569,730	1	31139.00
D	1,280	1.60	158	1.00	1,569,630	1	31006.00
D	1,360	1.70	167	1.00	1,568,964	1	30125.00
D	1,440	1.80	177	0.97	1,520,739	1	8970.00
D	1,520	1.90	187	0.96	1,509,788	1	8967.00
D	1,600	2.00	197	0.92	1,448,213	1	8949.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
100.00	4,603	0

Back to Advisory Statistics

Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

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
2K	4K	68,759	68,759
64K	128K	3,448	3,448
128K	256K	1,890	1,890
256K	512K	70	70
512K	1024K	4,323	4,323
1M	2M	502	502
2M	4M	1	1
4M	8M	22	22

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
142	0.13	26,344,827.56	52,811,682.47	33.00	399,899	93,319,024,643
284	0.25	26,344,827.56	52,649,941.41	33.00	395,762	93,128,345,214
568	0.50	26,344,827.56	13,327,939.90	66.00	9	46,770,934,725
852	0.75	26,344,827.56	12,964,308.28	67.00	0	46,342,242,911
1,136	1.00	26,344,827.56	12,107,330.22	69.00	0	45,331,936,157
1,363	1.20	26,344,827.56	11,946,154.45	69.00	0	45,141,923,156
1,590	1.40	26,344,827.56	11,946,004.62	69.00	0	45,141,746,527
1,818	1.60	26,344,827.56	11,945,893.70	69.00	0	45,141,615,757
2,045	1.80	26,344,827.56	11,945,893.70	69.00	0	45,141,615,757
2,272	2.00	26,344,827.56	11,945,893.70	69.00	0	45,141,615,757
3,408	3.00	26,344,827.56	11,945,893.70	69.00	0	45,141,615,757
4,544	4.00	26,344,827.56	11,945,734.11	69.00	0	45,141,427,613
6,816	6.00	26,344,827.56	11,945,734.11	69.00	0	45,141,427,613
9,088	8.00	26,344,827.56	11,945,734.11	69.00	0	45,141,427,613

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)
752	0.59	41	2,042	7,232,804	1.00	257,212	1.08	114,631
880	0.70	169	7,563	7,237,618	1.00	252,398	1.06	360,371
1,008	0.80	297	11,430	7,248,687	1.00	241,329	1.02	361,081
1,136	0.90	425	15,753	7,250,907	1.00	239,109	1.01	361,362
1,264	1.00	553	19,648	7,252,713	1.00	237,303	1.00	361,596
1,392	1.10	681	23,139	7,254,242	1.00	235,774	0.99	361,801
1,520	1.20	809	26,574	7,255,091	1.00	234,925	0.99	361,923
1,648	1.30	936	29,888	7,255,473	1.00	234,543	0.99	361,975
1,776	1.41	1,064	33,683	7,255,858	1.00	234,158	0.99	362,012
1,904	1.51	1,192	37,461	7,256,126	1.00	233,890	0.99	362,032
2,032	1.61	1,320	41,004	7,256,355	1.00	233,661	0.98	362,049
2,160	1.71	1,448	44,416	7,256,522	1.00	233,494	0.98	362,061
2,288	1.81	1,576	48,677	7,256,684	1.00	233,332	0.98	362,072
2,416	1.91	1,704	52,684	7,256,827	1.00	233,189	0.98	362,082
2,544	2.01	1,832	57,022	7,256,912	1.00	233,104	0.98	362,091

Back to Advisory Statistics

Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,072	0.50	6,380,268	1,575,961,957
1,608	0.75	6,356,134	1,571,250,561
2,144	1.00	6,351,053	1,570,465,328
2,680	1.25	6,331,365	1,509,060,134
3,216	1.50	6,326,284	1,520,053,391
3,752	1.75	6,325,649	1,520,053,391
4,288	2.00	6,325,014	1,447,497,893

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)
16	0.50	0	0	0	0
32	1.00	0	0	0	0
48	1.50	0	0	0	0
64	2.00	0	0	0	0
80	2.50	0	0	0	0
96	3.00	0	0	0	0
112	3.50	0	0	0	0
128	4.00	0	0	0	0
144	4.50	0	0	0	0
160	5.00	0	0	0	0
176	5.50	0	0	0	0
192	6.00	0	0	0	0
208	6.50	0	0	0	0
224	7.00	0	0	0	0
240	7.50	0	0	0	0
256	8.00	0	0	0	0
272	8.50	0	0	0	0
288	9.00	0	0	0	0
304	9.50	0	0	0	0
320	10.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

Back to Top

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	9	1	82
undo header	1	0	0

Back to Wait Statistics

Back to Top

Enqueue Activity

only enqueues with waits are shown

Enqueue stats gathered prior to 10g should not be compared with 10g data

ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (index contention)	13	13	0	10	0	34.00

Back to Wait Statistics

Back to Top

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Back to Top

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)

STO - Snapshot Too Old count, OOS - Out of Space count

Undo segment block stats:

uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed

eS - expired Stolen, eR - expired Released, eU - expired reUsed

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.45	4,955	1,058	5	240/240	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
12-Jul 11:40	102	1,201	1,058	3	240	0/0	0/0/0/0/0/0
12-Jul 11:30	200	2,217	453	5	240	0/0	0/0/0/0/0/0
12-Jul 11:20	82	1,091	1,053	2	240	0/0	0/0/0/0/0/0
12-Jul 11:10	70	446	449	2	240	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

Back to Top

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 db client latch	1,662	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	47	0.00		0	0
AWR Alerted Metric Element list	22,757	0.00		0	0
Change Notification Hash table latch	862	0.00		0	0
Consistent RBA	4,824	0.00		0	0
DML lock allocation	27,922	0.00		0	0
Event Group Locks	154	0.00		0	0
FAL Queue	125	0.00		0	0
FOB s.o list latch	631	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	35,354	0.01	1.00	0	4,884	0.00
JS Sh mem access	5	0.00		0	0
JS mem alloc latch	4	0.00		0	0
JS queue access latch	5	0.00		0	0
JS queue state obj latch	18,682	0.00		0	0
JS slv state obj latch	1,468,304	0.35	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
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	863	0.00		0	0
KTF sga latch	14	0.00		0	661	0.00
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	5	0.00		0	0
KWQS pqueue ctx latch	57	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	52	0.00
Memory Management Latch	1	0.00		0	863	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	15	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	1,039	0.00		0	0
OS process allocation	1,558	0.00		0	0
OS process: request allocation	303	0.00		0	0
PL/SQL warning settings	406	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	2,924	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	88	0.00		0	831	0.00
SQL memory manager workarea list latch	127,331	0.00		0	0
Shared B-Tree	240	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	2,333	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,950	0.00		0	0
active service list	6,124	0.00		0	2,878	0.00
archive control	44	0.00		0	0
archive process latch	375	0.27	1.00	0	0
begin backup scn array	28	0.00		0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	111,248	0.01	0.00	0	0
cache buffers chains	15,931,689	0.00	0.17	4	2,800	0.00
cache buffers lru chain	5,340	0.00		0	7,649	0.00
call allocation	903	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	338	0.00		0	0
channel operations parent latch	12,531	0.00		0	0
checkpoint queue latch	89,491	0.00		0	4,618	0.00
client/application info	1,517	0.00		0	0
compile environment latch	203	0.00		0	0
corrupted undo seg latch	52	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	47	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	47	0.00		0	0
dml lock allocation	47	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	404	0.00		0	0
enqueue hash chains	86,572	0.00		0	0
enqueues	44,603	0.01	0.00	0	0
fifth spare latch	1	0.00		0	0
file cache latch	145	0.00		0	0
flashback copy	1	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	53	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	100	0.00		0	896,664	0.00
hash table modification latch	88	0.00		0	0
heartbeat check	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	51	0.00		0	50	4.00
job_queue_processes free list latch	104	0.00		0	0
job_queue_processes parameter latch	609	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	1,575	0.00		0	0
kokc descriptor allocation latch	528	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	23	0.00		0	0
ksuosstats global area	177	0.00		0	0
ksv allocation latch	92	0.00		0	0
ksv class latch	47	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	303	0.00		0	0
ktm global data	14	0.00		0	0
kwqbsn:qsga	95	0.00		0	0
lgwr LWN SCN	5,328	0.00		0	0
list of block allocation	429	0.00		0	0
loader state object freelist	830	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	1	0.00		0	0
managed standby latch	125	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	1	0.00		0	0
messages	40,232	0.02	0.00	0	0
mostly latch-free SCN	5,324	0.00		0	0
msg queue latch	1	0.00		0	0
multiblock read objects	180	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	47	0.00		0	0
object queue header heap	42	0.00		0	47	0.00
object queue header operation	19,013	0.00		0	0
object stats modification	8	0.00		0	0
parallel query alloc buffer	337	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	278	0.00		0	0
parameter table management	405	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	8,847	0.00		0	6,570	0.00
process allocation	401	0.00		0	153	0.00
process group creation	303	0.00		0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	654	0.00		0	0
query server freelists	1	0.00		0	0
queued dump request	8	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	25,213	0.00	0.00	0	23,649	0.00
redo copy	1	0.00		0	23,649	0.16
redo writing	18,170	0.01	0.00	0	0
resmgr group change latch	341	0.00		0	0
resmgr:active threads	404	0.00		0	0
resmgr:actses change group	117	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	403	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	81	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	1,192,569	0.00	0.04	0	93	0.00
rules engine rule set statistics	100	0.00		0	0
second spare latch	1	0.00		0	0
sequence cache	28,714	0.00		0	0
session allocation	455,314	0.00	0.00	0	151,773	0.00
session idle bit	4,157,867	0.00	0.01	0	0
session queue latch	1	0.00		0	0
session state list latch	461	0.00		0	0
session switching	798	0.00		0	0
session timer	992	0.00		0	0
shared pool	32,135	0.08	0.08	8	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	2,268	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	562,198	0.00	0.00	0	0
simulator lru latch	2,629	0.00		0	559,381	0.01
sort extent pool	74	0.00		0	0
space background task latch	1,876	0.00		0	1,728	0.00
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	1	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	116	0.00		0	0
transaction allocation	750	0.00		0	0
undo global data	29,123	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
JS slv state obj latch	1,468,304	5,144	4	0
cache buffers chains	15,931,689	254	44	210
session idle bit	4,157,867	188	1	187
row cache objects	1,192,569	26	1	25
shared pool	32,135	25	2	23
In memory undo latch	35,354	3	3	0
archive process latch	375	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
In memory undo latch	ktiFlush: child	1	2
In memory undo latch	ktiFlushMe	1	0
In memory undo latch	kticmt: child	1	0
archive process latch	kcrrgpll	1	0
cache buffers chains	kcbgtcr: fast path (cr pin)	27	20
cache buffers chains	kcbgtcr: fast path	11	2
cache buffers chains	kcbrls_2	5	13
cache buffers chains	kcbgtcr_2	4	4
cache buffers chains	kcbrls_1	4	12
cache buffers chains	kcbgcur_2	2	0
row cache objects	kqreqd: reget	1	0
session idle bit	ksupuc: clear busy	1	0
shared pool	kghalo	1	0
shared pool	kghupr1	1	2

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	kglIsOwnerVersionable 121	3	-0
Library Cache	kgllkdl1 85	1	29
Library Cache	kglpndl1 95	1	33
Cursor Stat	kkocsStoreBindAwareStats [KKSSTALOC8]	1	0
Cursor Pin	kksfbc [KKSCHLPIN1]	1	0

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

Back to Top

Segments by Logical Reads

Total Logical Reads: 8,460,857

Captured Segments account for 95.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
MYCAR	MYCAR	UNI_IP_RANGE	INDEX	2,719,120	32.14
MYCAR	MYCAR	DIAG_SOFT_VERSION	TABLE	648,448	7.66
MYCAR	MYCAR	SYS_VENDER	TABLE	534,960	6.32
MYCAR	MYCAR	DIAG_SOFT_VERSION_DETAIL	TABLE	471,440	5.57
MYCAR	MYCAR	IND_VERSION_ID_DSD	INDEX	420,032	4.96

Back to Segment Statistics

Back to Top

Segments by Physical Reads

Total Physical Reads: 1,369

Captured Segments account for 35.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
MYCAR	MYCAR	OPERATE_LOG	TABLE	122	8.91
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	121	8.84
MYCAR	MYCAR	COM_IND_DUSC	INDEX	90	6.57
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	43	3.14
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD	INDEX	28	2.05

Back to Segment Statistics

Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 1,369

Captured Segments account for 35.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
MYCAR	MYCAR	OPERATE_LOG	TABLE	122	8.91
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	121	8.84
MYCAR	MYCAR	COM_IND_DUSC	INDEX	90	6.57
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	43	3.14
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD	INDEX	28	2.05

Back to Segment Statistics

Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 1,369

Captured Segments account for 35.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
MYCAR	MYCAR	OPERATE_LOG	TABLE	122	8.91
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	121	8.84
MYCAR	MYCAR	COM_IND_DUSC	INDEX	90	6.57
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	43	3.14
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD	INDEX	28	2.05

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

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

Segments by Physical Writes

Total Physical Writes: 4,937

Captured Segments account for 52.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
MYCAR	MYCAR	OPERATE_LOG	TABLE	852	17.26
MYCAR	MYCAR	COM_IND_DUSC	INDEX	744	15.07
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD	INDEX	188	3.81
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	173	3.50
MYCAR	MYCAR	PK_OPERATE_LOG	INDEX	58	1.17

Back to Segment Statistics

Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 3,357

Captured Segments account for 54.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
MYCAR	MYCAR	COM_IND_DUSC	INDEX	664	19.78
MYCAR	MYCAR	OPERATE_LOG	TABLE	402	11.97
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD	INDEX	159	4.74
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	152	4.53
MYCAR	MYCAR	SYS_PRODUCT	TABLE	40	1.19

Back to Segment Statistics

Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 65

Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1652681432_9895	TABLE PARTITION	38	58.46
SYS	SYSAUX	SYS_LOB0000006213C00038$$		LOB	18	27.69
SYS	SYSAUX	SYS_LOB0000006207C00004$$		LOB	9	13.85

Back to Segment Statistics

Back to Top

Segments by Table Scans

Total Table Scans: 703

Captured Segments account for 46.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
MYCAR	MYCAR	PK_SYS_LAN		INDEX	325	46.23
MYCAR	MYCAR	IND_VERSION_ID_DSD		INDEX	1	0.14

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	Obj. Type	DB Block Changes	% of Capture
MYCAR	MYCAR	OPERATE_LOG	TABLE	2,976	24.80
MYCAR	MYCAR	PK_OPERATE_LOG	INDEX	1,600	13.33
MYCAR	MYCAR	COM_IND_DUSC	INDEX	1,184	9.87
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	1,008	8.40
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD	INDEX	944	7.87

Back to Segment Statistics

Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared

with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
MYCAR	MYCAR	PK_DIAG_DOWNLOAD_RECORD	INDEX	10	76.92
SYS	SYSAUX	WRI$_ADV_MESSAGE_GROUPS_PK	INDEX	2	15.38
MYCAR	MYCAR	PK_DIAG_USER_SOFT_CENTER	INDEX	1	7.69

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

% of Capture shows % of Buffer Busy Waits for each top segment compared

with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
MYCAR	MYCAR	PK_DIAG_DOWNLOAD_RECORD		INDEX	7	87.50
SYS	SYSTEM	AUD$		TABLE	1	12.50

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	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	47	0.00	2	1
dc_global_oids	787	0.00	0	58
dc_histogram_data	6,169	0.00	0	8,442
dc_histogram_defs	9,524	0.00	0	6,247
dc_objects	17,193	0.00	5	3,004
dc_profiles	105	0.00	0	1
dc_rollback_segments	1,498	0.00	0	52
dc_segments	3,714	0.00	11	1,583
dc_sequences	887	0.11	887	41
dc_tablespaces	175,102	0.00	0	10
dc_users	184,718	0.00	0	188
global database name	1,840	0.00	0	2
outstanding_alerts	28	0.00	0	7
sch_lj_oids	4	0.00	0	16

Back to Top

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,036	0.00	1,407	0.00	0	0
CLUSTER	3	0.00	2	0.00	0	0
DBLINK	110	0.00	0		0	0
EDITION	116	0.00	219	0.00	0	0
INDEX	9	0.00	9	0.00	0	0
QUEUE	48	0.00	154	0.00	0	0
SCHEMA	162	0.00	0		0	0
SQL AREA	11,679	3.16	605,883	0.09	92	18
SUBSCRIPTION	17	0.00	17	0.00	0	0
TABLE/PROCEDURE	4,930	0.00	55,424	0.02	11	0
TRIGGER	35	0.00	60	0.00	0	0

Back to Top

Memory Statistics

Memory Dynamic Components

Memory Resize Operations Summary

Memory Resize Ops

Process Memory Summary

SGA Memory Summary

SGA breakdown difference

Back to Top

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	784.00	784.00	784.00	816.00	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	1,136.00	1,136.00	1,136.00	1,136.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	2,144.00	2,144.00	2,144.00	2,144.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	16.00	16.00	16.00	16.00	STA/
large pool	16.00	16.00	16.00	16.00	STA/
shared pool	1,264.00	1,264.00	1,264.00	1,264.00	STA/
streams pool	32.00	32.00	0.00	32.00	GRO/IMM

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	398.90		3.66	7.63	28	32	109	109
	Freeable	63.56	0.00	0.99	0.63	4		64	64
	SQL	1.77	1.10	0.02	0.02	0	12	87	81
	PL/SQL	1.29	1.02	0.01	0.03	0	0	107	107
E	Other	401.08		3.58	7.54	28	32	112	112
	Freeable	65.94	0.00	1.01	0.63	4		65	65
	SQL	2.33	1.66	0.03	0.06	1	12	89	82
	PL/SQL	1.41	1.10	0.01	0.03	0	1	110	110

Back to Memory Statistics

Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	822,083,584
Fixed Size	2,218,152
Redo Buffers	15,970,304
Variable Size	2,583,693,144

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	16.00	16.00	0.00
large	PX msg pool	7.50	7.50	0.00
large	free memory	8.50	8.50	0.00
shared	CCUR	86.89	86.83	-0.06
shared	FileOpenBlock	15.20	15.20	0.00
shared	KGLHD	26.47	26.46	-0.04
shared	KGLS	16.57	16.56	-0.05
shared	PCUR	76.35	76.62	0.35
shared	PLMCD	13.63	13.63	0.00
shared	SQLA	481.93	482.99	0.22
shared	free memory	339.35	338.44	-0.27
streams	KTG hash buckets	1.26	1.26	0.00
streams	free memory	30.72	30.72	0.00
	buffer_cache	784.00	784.00	0.00
	fixed_sga	2.12	2.12	0.00
	log_buffer	15.23	15.23	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

Back to Top

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 Coordinator	0326 18:10:23	0.00	0.00	0.00
QMON Slaves	0326 18:10:33	0.00	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

No data exists for this section of the report.

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(12343)	0	0			0.00	0.00
SYS.AQ$_ALERT_QT_E(12342)	0	0			0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(66903)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(66573)	42	42	0.00	0.00	0.02	0.10	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(12343)	0.00	0.00
SYS.AQ$_ALERT_QT_E(12342)	0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(66903)	0.00	0.00
SYSMAN.MGMT_TASK_Q(66573)	0.02	0.02	0.00	0.00

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	Dequeue Msgs	Expire Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0
VM19216800003_3938_MYCAR(22)/SYS.ALERT_QUE	0	0	0	0.00	0.00	0.00

Back to Streams Statistics

Back to Top

Resource Limit Stats

No data exists for this section of the report.

Back to Top

Shared Server Statistics

Shared Servers Activity

Shared Servers Rates

Shared Servers Utilization

Shared Servers Common Queue

Shared Servers Dispatchers

Back to Top

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,604	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,604	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)
audit_file_dest	/oracle/admin/mycar/adump
audit_trail	DB
compatible	11.2.0.0.0
control_files	/oracle/oradata/mycar/control01.ctl, /oracle/flash_recovery_area/mycar/control02.ctl
cursor_sharing	EXACT
db_block_size	8192
db_domain
db_name	mycar
db_recovery_file_dest	/oracle/flash_recovery_area
db_recovery_file_dest_size	4070572032
deferred_segment_creation	FALSE
diagnostic_dest	/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=mycarXDB)
log_archive_dest_1	location=/oracle/oradata/archivelog
log_archive_format	archive_%t_%s_%r.log
log_archive_max_processes	10
memory_target	3439329280
open_cursors	300
processes	500
remote_login_passwordfile	EXCLUSIVE
sec_case_sensitive_logon	FALSE
sql_trace	FALSE
undo_retention	14400
undo_tablespace	UNDOTBS1
workarea_size_policy	AUTO

ITPub博客

rere

WORKLOAD REPOSITORY report for

Report Summary

Main Report

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

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

Instance Activity Statistics

Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

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

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

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