rere

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)
  

		% of Waits
Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
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)
  

		% of Total Waits
Event	Waits 64ms  to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
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)
  

		% of Total Waits
Event	Waits 4s     to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
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	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	1469	25	76	16	0	0	1481263	4
mycar	0	0	0	0	0	0	194	0
SYS$BACKGROUND	157	0	98	29	0	0	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 Module	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 Module	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 Module	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 Module	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 Module	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(VALUE*1000/ 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	Large 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    Reads/s	Av   Rd(ms)	Av     Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
MYCAR	1,281	0	17.10	1.00	1,801	1	8	0.00
UNDOTBS1	0	0	0.00	0.00	772	0	1	0.00
SYSAUX	77	0	4.29	1.00	653	0	0	0.00
SYSTEM	1	0	50.00	1.00	78	0	1	740.00
PASSPORT	11	0	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      Reads/s	Av   Rd(ms)	Av    Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
MYCAR	/oracle/oradata/mycar/mycar.dbf	1,105	0	14.13	1.00	1,189	0	0	0.00
MYCAR	/oracle/oradata/mycar/mycar01.dbf	176	0	35.74	1.00	612	0	8	0.00
PASSPORT	/oracle/oradata/mycar/passport.dbf	11	0	78.18	1.00	53	0	0	0.00
SYSAUX	/oracle/oradata/mycar/sysaux01.dbf	77	0	4.29	1.00	653	0	0	0.00
SYSTEM	/oracle/oradata/mycar/system01.dbf	1	0	50.00	1.00	78	0	1	740.00
UNDOTBS1	/oracle/oradata/mycar/undotbs01.dbf	0	0			772	0	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	1-Pass Execs	M-Pass Execs
2K	4K	68,759	68,759	0	0
64K	128K	3,448	3,448	0	0
128K	256K	1,890	1,890	0	0
256K	512K	70	70	0	0
512K	1024K	4,323	4,323	0	0
1M	2M	502	502	0	0
2M	4M	1	1	0	0
4M	8M	22	22	0	0

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	NoWait Misses	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	0	1	2
In memory undo latch	ktiFlushMe	0	1	0
In memory undo latch	kticmt: child	0	1	0
archive process latch	kcrrgpll	0	1	0
cache buffers chains	kcbgtcr: fast path (cr pin)	0	27	20
cache buffers chains	kcbgtcr: fast path	0	11	2
cache buffers chains	kcbrls_2	0	5	13
cache buffers chains	kcbgtcr_2	0	4	4
cache buffers chains	kcbrls_1	0	4	12
cache buffers chains	kcbgcur_2	0	2	0
row cache objects	kqreqd: reget	0	1	0
session idle bit	ksupuc: clear busy	0	1	0
shared pool	kghalo	0	1	0
shared pool	kghupr1	0	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	Subobject   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	Subobject   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	Subobject   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	Subobject   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	Subobject   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	Subobject   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	Subobject   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	Subobject   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	Scan Reqs	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	47	0.00	0		2	1
dc_global_oids	787	0.00	0		0	58
dc_histogram_data	6,169	0.00	0		0	8,442
dc_histogram_defs	9,524	0.00	0		0	6,247
dc_objects	17,193	0.00	0		5	3,004
dc_profiles	105	0.00	0		0	1
dc_rollback_segments	1,498	0.00	0		0	52
dc_segments	3,714	0.00	0		11	1,583
dc_sequences	887	0.11	0		887	41
dc_tablespaces	175,102	0.00	0		0	10
dc_users	184,718	0.00	0		0	188
global database name	1,840	0.00	0		0	2
outstanding_alerts	28	0.00	0		0	7
sch_lj_oids	4	0.00	0		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)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	784.00	784.00	784.00	816.00	0	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	1,136.00	1,136.00	1,136.00	1,136.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	2,144.00	2,144.00	2,144.00	2,144.00	0	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	16.00	16.00	16.00	16.00	0	STA/
large pool	16.00	16.00	16.00	16.00	0	STA/
shared pool	1,264.00	1,264.00	1,264.00	1,264.00	0	STA/
streams pool	32.00	32.00	0.00	32.00	0	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

Back to Top

Dynamic Remastering Stats

          No data exists for this section of the report.

Back to Top

End of Report

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22126868/viewspace-766164/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22126868/viewspace-766164/