Using the report name /tmp/awrrpt_1_10059_10061.html

AWR Report for DB: MYCAR, Inst: mycar, Snaps: 10059-10061

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:	10059	18-Jul-13 17:00:01	92	4.4
End Snap:	10061	18-Jul-13 17:23:26	94	4.2
Elapsed:		23.42 (mins)
DB Time:		144.25 (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):	6.2	4.9	0.04	0.01
DB CPU(s):	2.3	1.9	0.01	0.00
Redo size:	6,566.9	5,232.2
Logical reads:	2,651.3	2,112.4
Block changes:	27.4	21.8
Physical reads:	0.5	0.4
Physical writes:	2.0	1.6
User calls:	560.0	446.2
Parses:	166.6	132.7
Hard parses:	0.1	0.1
W/A MB processed:	0.8	0.6
Logons:	0.2	0.1
Executes:	168.1	134.0
Rollbacks:	0.0	0.0
Transactions:	1.3

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.90	Soft Parse %:	99.96
Execute to Parse %:	0.93	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	2.55	% Non-Parse CPU:	99.94

Shared Pool Statistics

	Begin	End
Memory Usage %:	73.95	73.97
% SQL with executions>1:	94.48	95.53
% Memory for SQL w/exec>1:	88.58	88.96

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		3,276		37.85
log file sync	2,026	351	173	4.06	Commit
db file sequential read	360	112	312	1.30	User I/O
latch: shared pool	18	10	574	0.12	Concurrency
direct path sync	1	9	9148	0.11	User I/O

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.10	0.66	40.8	17.6	0.1	41.6

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
58.3	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):	436.4	440.2
% Host Mem used for SGA+PGA:	31.50	31.55

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): 8655.1s

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	6,920.77	79.96
PL/SQL execution elapsed time	3,650.73	42.18
DB CPU	3,275.97	37.85
parse time elapsed	89.64	1.04
connection management call elapsed time	65.86	0.76
hard parse elapsed time	49.71	0.57
hard parse (sharing criteria) elapsed time	41.20	0.48
sequence load elapsed time	0.26	0.00
PL/SQL compilation elapsed time	0.01	0.00
repeated bind elapsed time	0.00	0.00
failed parse elapsed time	0.00	0.00
DB time	8,655.13
background elapsed time	422.74
background cpu time	1.04

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	328,163
IDLE_TIME	233,835
IOWAIT_TIME	552
NICE_TIME	0
SYS_TIME	98,837
USER_TIME	229,132
LOAD	0	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
18-Jul 17:00:01	0.10
18-Jul 17:14:34	21.02	58.27	40.67	17.56	41.73	0.12
18-Jul 17:23:26	0.66	58.65	40.98	17.64	41.35	0.06

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 43.7% of Total DB time 8,655.13 (s)

Total FG Wait Time: 508.25 (s) DB CPU time: 3,275.97 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			3,276		37.85
Commit	2,026	0	351	173	4.06
User I/O	992	0	125	126	1.45
Concurrency	105	1	28	267	0.32
Network	579,639	0	3	0	0.03
Configuration	1	100	1	762	0.01
Other	13,209	100	0	0	0.00
System I/O	177	0	0	0	0.00
Application	2	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	2,026	0	351	173	1.15	4.06
db file sequential read	360	0	112	312	0.20	1.30
latch: shared pool	18	0	10	574	0.01	0.12
direct path sync	1	0	9	9148	0.00	0.11
latch: cache buffers chains	59	0	8	131	0.03	0.09
cursor: pin S	4	0	5	1269	0.00	0.06
library cache: mutex X	13	0	4	342	0.01	0.05
Disk file operations I/O	393	0	3	9	0.22	0.04
SQL*Net message to client	561,097	0	2	0	318.08	0.02
undo segment extension	1	100	1	762	0.00	0.01
SQL*Net more data from client	2,360	0	1	0	1.34	0.01
latch: row cache objects	7	0	0	65	0.00	0.01
asynch descriptor resize	13,205	100	0	0	7.49	0.00
read by other session	4	0	0	59	0.00	0.00
SQL*Net more data to client	16,182	0	0	0	9.17	0.00
latch: session allocation	1	0	0	133	0.00	0.00
direct path read	223	0	0	0	0.13	0.00
cursor: mutex S	1	100	0	1	0.00	0.00
control file sequential read	177	0	0	0	0.10	0.00
SQL*Net message from client	561,095	0	203,311	362	318.08
jobq slave wait	2,920	100	1,496	512	1.66

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	4,246	0	220	52	2.41	52.14
control file parallel write	472	0	76	160	0.27	17.91
os thread startup	54	0	55	1016	0.03	12.98
db file async I/O submit	506	0	46	91	0.29	10.84
latch: shared pool	14	0	5	390	0.01	1.29
LGWR wait for redo copy	4	0	5	1274	0.00	1.21
control file sequential read	2,399	0	4	2	1.36	1.04
Disk file operations I/O	37	0	1	38	0.02	0.33
SQL*Net message to client	560	0	1	1	0.32	0.18
latch: call allocation	9	0	1	81	0.01	0.17
reliable message	25	0	0	15	0.01	0.09
enq: CF - contention	1	0	0	267	0.00	0.06
db file sequential read	98	0	0	3	0.06	0.06
rdbms ipc reply	25	0	0	7	0.01	0.04
ADR block file read	13	0	0	3	0.01	0.01
log file sync	1	0	0	8	0.00	0.00
asynch descriptor resize	275	100	0	0	0.16	0.00
buffer busy waits	2	0	0	1	0.00	0.00
ADR block file write	5	0	0	0	0.00	0.00
rdbms ipc message	8,121	71	31,786	3914	4.60
DIAG idle wait	2,772	100	2,810	1014	1.57
smon timer	8	38	1,502	187706	0.00
dispatcher timer	24	100	1,440	60014	0.01
shared server idle wait	47	100	1,411	30019	0.03
Space Manager: slave idle wait	257	98	1,406	5471	0.15
pmon timer	518	85	1,404	2711	0.29
Streams AQ: qmn slave idle wait	97	0	1,402	14456	0.05
Streams AQ: qmn coordinator idle wait	150	33	1,402	9348	0.09
SQL*Net message from client	701	0	27	39	0.40
class slave wait	8	0	1	109	0.00

Back to Wait Events Statistics

Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000

% of Waits: value of .0 indicates value was <.05%; value of null is truly 0

% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms

Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	13	76.9			7.7	15.4
ADR block file write	5	100.0
ADR file lock	6	100.0
Disk file operations I/O	424	98.6	.5	.2				.2	.5
LGWR wait for redo copy	4	75.0							25.0
SQL*Net break/reset to client	2	100.0
SQL*Net message to client	561.7K	100.0				.0		.0
SQL*Net more data from client	2360	99.5	.2	.0				.2
SQL*Net more data to client	16.2K	100.0
asynch descriptor resize	13.5K	100.0				.0		.0
buffer busy waits	5	80.0		20.0
control file parallel write	473	48.6	1.3	1.1		.8	1.7	46.1	.4
control file sequential read	2581	99.9						.0	.0
cursor: mutex S	1		100.0
cursor: pin S	4	50.0							50.0
db file async I/O submit	506	38.7	26.1	11.1	.2	1.0	1.0	20.2	1.8
db file sequential read	446	43.0	1.1	2.2	8.7	14.8	1.6	23.1	5.4
direct path read	223	100.0
direct path sync	1								100.0
direct path write	21	100.0
enq: CF - contention	1							100.0
latch free	2	100.0
latch: cache buffers chains	60	25.0		1.7			3.3	70.0
latch: call allocation	9			11.1			22.2	66.7
latch: enqueue hash chains	1	100.0
latch: row cache objects	7	14.3				14.3	42.9	28.6
latch: session allocation	1							100.0
latch: shared pool	32	18.8					3.1	65.6	12.5
library cache: mutex X	13	23.1	7.7				7.7	53.8	7.7
log file parallel write	4246	79.6	.8	.5	.5	.7	.7	17.0	.1
log file sync	2027	52.7	1.2	.8	.8	.8	1.6	40.0	2.0
os thread startup	54						57.4	20.4	22.2
rdbms ipc reply	25	96.0						4.0
read by other session	4		25.0			25.0		50.0
reliable message	25	92.0						8.0
undo segment extension	1							100.0
DIAG idle wait	2771							86.9	13.1
SQL*Net message from client	561.8K	90.6	2.0	.5	.4	.7	.4	5.2	.2
Space Manager: slave idle wait	257	.4							99.6
Streams AQ: qmn coordinator idle wait	150	58.0				.7	2.0	6.0	33.3
Streams AQ: qmn slave idle wait	97	48.5							51.5
class slave wait	8	87.5						12.5
dispatcher timer	24								100.0
jobq slave wait	2920	.0			.0			99.9
pmon timer	518	2.3		.2	.2	.8	.6	4.8	91.1
rdbms ipc message	8122	5.9	.6	1.8	1.1	9.2	1.2	23.0	57.3
shared server idle wait	47								100.0
smon timer	8								100.0

Back to Wait Events Statistics

Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000

Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)

% of Total Waits: total waits for all wait classes, including Idle

% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0

Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
Disk file operations I/O	2	99.3					.2	.2	.2
SQL*Net message to client	5	100.0		.0	.0	.0	.0
SQL*Net more data from client	5	99.8	.0	.1	.0
asynch descriptor resize	1	100.0			.0
control file parallel write	219	53.5	3.4	5.1	11.4	18.6	7.6	.2	.2
control file sequential read	1	99.9		.0					.0
cursor: pin S	1	50.0						25.0	25.0
db file async I/O submit	110	78.1	1.4	3.6	5.9	5.7	3.6	1.6	.2
db file sequential read	112	71.5	2.5	4.9	7.6	3.4	4.7	2.0	3.4
enq: CF - contention	1					100.0
latch: cache buffers chains	42	30.0	8.3	21.7	21.7	16.7	1.7
latch: call allocation	6	33.3	11.1	33.3	22.2
latch: row cache objects	2	71.4			28.6
latch: session allocation	1				100.0
latch: shared pool	21	21.9		12.5	21.9	21.9	9.4		12.5
library cache: mutex X	7	38.5		38.5		7.7	7.7		7.7
log file parallel write	724	82.9	1.4	3.5	4.6	4.9	2.7	.1	.0
log file sync	844	58.1	3.0	6.1	8.7	13.0	9.1	1.7	.3
os thread startup	14	57.4	3.7	3.7	7.4	1.9	3.7	5.6	16.7
rdbms ipc reply	1	96.0			4.0
read by other session	2	50.0		25.0	25.0
reliable message	2	92.0		4.0	4.0
undo segment extension	1						100.0

Back to Wait Events Statistics

Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000

Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)

% of Total Waits: total waits for all wait classes, including Idle

% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0

Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s
		% of Total Waits
Disk file operations I/O	1	99.8	.2
LGWR wait for redo copy	1	75.0		25.0
control file parallel write	1	99.8	.2
control file sequential read	1	100.0		.0
cursor: pin S	1	75.0	25.0
db file async I/O submit	1	99.8	.2
db file sequential read	15	96.6	2.2	.9	.2
direct path sync	1				100.0
latch: shared pool	4	87.5	12.5
library cache: mutex X	1	92.3	7.7
log file parallel write	1	100.0	.0
log file sync	6	99.7	.2	.0
os thread startup	9	83.3	5.6	11.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	8,655	3,276	1	3,711
mycar	0	0	0	3
SYS$BACKGROUND	0	0	0	12
mycarXDB	0	0	0	0

Back to Wait Events Statistics

Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.

Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network

Time Waited (Wt Time) in seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	991	125	105	28	579449	3
mycar	1	0	0	0	190	0
SYS$BACKGROUND	146	2	60	58	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 78.2% of Total DB Time (s): 8,655

Captured PL/SQL account for 2.8% of Total DB Time (s): 8,655

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,528.28	9,642	0.68	75.43	49.07	0.00	9y8z91h8pk7d7		SELECT C.* FROM COUNTRY_CODE C...
202.77	1	202.77	2.34	0.39	50.69	1uk5m5qbzj1vt	sqlplus@vm192168000035 (TNS V1-V3)	BEGIN dbms_workload_repository...
24.28	1	24.28	0.28	0.33	60.85	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
20.71	8,989	0.00	0.24	9.52	0.00	87hfb2vvgt6tp		select 1 from sys_area_country...
18.62	1	18.62	0.22	0.11	49.14	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
16.78	2	8.39	0.19	1.00	98.98	bunssq950snhf		insert into wrh$_sga_target_ad...
11.12	23	0.48	0.13	7.77	8.04	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
10.60	1,554	0.01	0.12	0.79	97.95	dnx1ugz1qwd2p		insert into OPERATE_LOG (LOG_I...
10.43	8	1.30	0.12	0.00	99.88	3sqgkcng6vx8r		INSERT INTO sys.wri$_adv_ratio...
9.56	1	9.56	0.11	0.00	45.64	692wcvj50ytxz		insert into wrh$_resource_limi...

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.3% of Total CPU Time (s): 3,276

Captured PL/SQL account for 0.1% of Total CPU Time (s): 3,276

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,203.51	9,642	0.33	97.79	6,528.28	49.07	0.00	9y8z91h8pk7d7		SELECT C.* FROM COUNTRY_CODE C...
1.97	8,989	0.00	0.06	20.71	9.52	0.00	87hfb2vvgt6tp		select 1 from sys_area_country...
1.42	7,423	0.00	0.04	2.18	65.09	0.00	0ay7wjuhgzj9k		select d.* from diag_soft_vers...
1.18	56,354	0.00	0.04	2.47	47.86	0.00	520mkxqpf15q8		select 1 from dual
1.08	31,372	0.00	0.03	9.21	11.72	0.00	5nggumnh49yzc		select * from SYS_PRODUCT wher...
0.86	84	0.01	0.03	1.13	76.28	0.00	9nkj1gjfq5k91		select * from CC_USER where Lo...
0.86	23	0.04	0.03	11.12	7.77	8.04	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0.80	9,591	0.00	0.02	8.44	9.44	0.01	9arur6gysf1z0		select t.*, '' as name from sy...
0.79	1	0.79	0.02	202.77	0.39	50.69	1uk5m5qbzj1vt	sqlplus@vm192168000035 (TNS V1-V3)	BEGIN dbms_workload_repository...
0.64	17,092	0.00	0.02	2.70	23.54	15.41	4xbg42tpyp0gm		select * from SYS_PRODUCT_LANG...

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

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
102.78	1	102.78	80.98	202.77	0.39	50.69	1uk5m5qbzj1vt	sqlplus@vm192168000035 (TNS V1-V3)	BEGIN dbms_workload_repository...
16.61	2	8.30	13.09	16.78	1.00	98.98	bunssq950snhf		insert into wrh$_sga_target_ad...
14.78	1	14.78	11.64	24.28	0.33	60.85	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
10.42	8	1.30	8.21	10.43	0.00	99.88	3sqgkcng6vx8r		INSERT INTO sys.wri$_adv_ratio...
10.39	1,554	0.01	8.18	10.60	0.79	97.95	dnx1ugz1qwd2p		insert into OPERATE_LOG (LOG_I...
9.15	1	9.15	7.21	18.62	0.11	49.14	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
5.83	1	5.83	4.60	5.86	0.34	99.58	84k66tf2s7y1c		insert into wrh$_bg_event_summ...
4.70	1	4.70	3.70	4.70	0.26	99.91	gj6uc50hpnr1p		insert into WRH$_MUTEX_SLEEP (...
4.69	1,485	0.00	3.69	5.01	4.47	93.55	59ygsb7wnbc69		insert into DIAG_DOWNLOAD_RECO...
4.36	1	4.36	3.44	9.56	0.00	45.64	692wcvj50ytxz		insert into wrh$_resource_limi...
4.12	4	1.03	3.24	4.12	0.00	99.98	2gxbvynrd71dr		INSERT INTO sys.wri$_adv_rec_a...
3.78	2	1.89	2.98	7.22	2.16	52.33	dayq182sk41ks		insert into wrh$_memory_target...
3.72	1	3.72	2.93	3.99	0.00	93.34	f318xdxdn0pdc		insert into wrh$_log (snap_id,...
3.71	1	3.71	2.92	3.72	0.00	99.83	6hwjmjgrpsuaa		insert into wrh$_enqueue_stat ...
3.00	1	3.00	2.36	3.00	0.00	99.97	fp6ajqcjfqf2j		insert into wrh$_streams_pool_...
2.89	1	2.89	2.28	2.90	0.41	99.67	dnwpm0gdccrph		insert into wrh$_process_memor...
2.55	1	2.55	2.01	2.55	0.47	99.81	350myuyx0t1d6		insert into wrh$_tablespace_st...

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: 3,726,244

Captured SQL account for 87.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
1,446,538	9,642	150.02	38.82	6,528.28	49.07	0.00	9y8z91h8pk7d7	SELECT C.* FROM COUNTRY_CODE C...
368,272	8,989	40.97	9.88	20.71	9.52	0.00	87hfb2vvgt6tp	select 1 from sys_area_country...
153,456	9,591	16.00	4.12	8.44	9.44	0.01	9arur6gysf1z0	select t.*, '' as name from sy...
152,924	7,423	20.60	4.10	2.18	65.09	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
152,605	31,372	4.86	4.10	9.21	11.72	0.00	5nggumnh49yzc	select * from SYS_PRODUCT wher...
136,066	7,451	18.26	3.65	0.93	65.78	0.00	5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERS...
86,547	17,307	5.00	2.32	3.93	16.00	0.00	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
71,584	59	1,213.29	1.92	0.96	42.08	27.63	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
61,768	8,824	7.00	1.66	0.59	78.01	0.49	1fnv7qu1a8qsc	select * from product_down_set...
61,746	82	753.00	1.66	0.30	83.48	0.00	15u508g96b995	select count(*) from appstore_...
58,681	49	1,197.57	1.57	0.20	82.32	0.00	1dv841hap05xc	SELECT COUNT(*) AS c from (sel...
52,584	84	626.00	1.41	1.13	76.28	0.00	9nkj1gjfq5k91	select * from CC_USER where Lo...
52,259	17,092	3.06	1.40	2.70	23.54	15.41	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
43,400	14	3,100.00	1.16	0.23	64.94	0.00	faup55dtz1ufw	SELECT COUNT(*) AS c from sys_...

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: 654

Captured SQL account for 35.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
122	1	122.00	18.65	202.77	0.39	50.69	1uk5m5qbzj1vt	sqlplus@vm192168000035 (TNS V1-V3)	BEGIN dbms_workload_repository...
100	1,554	0.06	15.29	10.60	0.79	97.95	dnx1ugz1qwd2p		insert into OPERATE_LOG (LOG_I...
65	1,485	0.04	9.94	5.01	4.47	93.55	59ygsb7wnbc69		insert into DIAG_DOWNLOAD_RECO...
34	1	34.00	5.20	24.28	0.33	60.85	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
14	1	14.00	2.14	2.29	0.00	0.02	47mm81hm9sggy		SELECT sum(case when a.sessio...
11	4	2.75	1.68	0.23	22.87	75.60	gkuh6srmynubb		select distinct temp.SOFT_ID, ...
10	8	1.25	1.53	10.43	0.00	99.88	3sqgkcng6vx8r		INSERT INTO sys.wri$_adv_ratio...
5	1	5.00	0.76	9.56	0.00	45.64	692wcvj50ytxz		insert into wrh$_resource_limi...
4	1	4.00	0.61	5.86	0.34	99.58	84k66tf2s7y1c		insert into wrh$_bg_event_summ...
3	59	0.05	0.46	0.96	42.08	27.63	89nfp8fv1y8vw		SELECT COUNT(*) AS c from (sel...

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: 654

Captured SQL account for 19.4% of Total

Total UnOptimized Read Requests: 654

Captured SQL account for 19.4% of Total

Total Optimized Read Requests: 1

Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
264	264	1	264.00	40.37	1uk5m5qbzj1vt	sqlplus@vm192168000035 (TNS V1-V3)	BEGIN dbms_workload_repository...
104	104	2	52.00	15.90	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
34	34	1	34.00	5.20	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
10	10	8	1.25	1.53	3sqgkcng6vx8r		INSERT INTO sys.wri$_adv_ratio...
3	3	59	0.05	0.46	89nfp8fv1y8vw		SELECT COUNT(*) AS c from (sel...
3	3	1,444	0.00	0.46	c00br6fharcvs		select c.* from diag_user_soft...
2	2	17,092	0.00	0.31	4xbg42tpyp0gm		select * from SYS_PRODUCT_LANG...
2	2	9,642	0.00	0.31	9y8z91h8pk7d7		SELECT C.* FROM COUNTRY_CODE C...
1	1	4	0.25	0.15	2gxbvynrd71dr		INSERT INTO sys.wri$_adv_rec_a...
1	1	23	0.04	0.15	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...

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: 236,290

Captured SQL account for 95.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
56,354	56,354	1.00	2.47	47.86	0.00	520mkxqpf15q8	select 1 from dual
31,372	31,371	1.00	9.21	11.72	0.00	5nggumnh49yzc	select * from SYS_PRODUCT wher...
17,307	17,307	1.00	3.93	16.00	0.00	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
17,092	79,705	4.66	2.70	23.54	15.41	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
13,044	2,761	0.21	1.14	30.96	0.00	5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_...
9,642	8,561	0.89	6,528.28	49.07	0.00	9y8z91h8pk7d7	SELECT C.* FROM COUNTRY_CODE C...
9,591	602	0.06	8.44	9.44	0.01	9arur6gysf1z0	select t.*, '' as name from sy...
8,989	8,989	1.00	20.71	9.52	0.00	87hfb2vvgt6tp	select 1 from sys_area_country...
8,824	0	0.00	0.59	78.01	0.49	1fnv7qu1a8qsc	select * from product_down_set...
7,451	26,110	3.50	0.93	65.78	0.00	5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERS...
7,423	246,098	33.15	2.18	65.09	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
3,057	3,057	1.00	0.18	43.29	0.00	a6j566u48p8nf	select * from SYS_PDT_TYPE whe...
3,023	0	0.00	0.26	33.39	0.11	drvvh1sx3r1my	select l.LAN_NAME, d.* from SY...
2,919	2,919	1.00	0.21	22.99	0.00	1qp4my7430ph5	select * from DIAG_SOFT_VERSIO...

Back to SQL Statistics

Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 234,085

Captured SQL account for 95.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
56,354	56,354	24.07	520mkxqpf15q8	select 1 from dual
31,372	31,372	13.40	5nggumnh49yzc	select * from SYS_PRODUCT wher...
17,307	17,307	7.39	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
17,092	17,092	7.30	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
13,044	13,044	5.57	5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_...
9,642	9,642	4.12	9y8z91h8pk7d7	SELECT C.* FROM COUNTRY_CODE C...
9,591	9,591	4.10	9arur6gysf1z0	select t.*, '' as name from sy...
8,989	8,989	3.84	87hfb2vvgt6tp	select 1 from sys_area_country...
8,824	8,824	3.77	1fnv7qu1a8qsc	select * from product_down_set...
7,451	7,451	3.18	5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERS...
7,423	7,423	3.17	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
3,057	3,057	1.31	a6j566u48p8nf	select * from SYS_PDT_TYPE whe...
3,023	3,023	1.29	drvvh1sx3r1my	select l.LAN_NAME, d.* from SY...
2,919	2,919	1.25	1qp4my7430ph5	select * from DIAG_SOFT_VERSIO...

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,989,522	2	0.15	6wm3n4d7bnddg		SELECT source, (case when tim...
1,050,287	4	0.08	69k5bhm12sz98		SELECT dbin.instance_number, d...

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	2	5s34t44u10q4g		SELECT a.name task_name, nvl(e...
102	2	c8gnrhxma4tas		SELECT owner#, property FROM s...
100	4	69k5bhm12sz98		SELECT dbin.instance_number, d...
91	2	gdn3ysuyssf82		SELECT advisor_id FROM sys.wri...
72	59	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
67	2	8p9z2ztb272bm		SELECT sx.instance_number, sx...
65	113	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...
63	2	6wm3n4d7bnddg		SELECT source, (case when tim...
63	47	davq1msn9b8kd		UPDATE MGMT_POLICY_ASSOC_EVAL_...
56	2	5uw1u291s3m0k		SELECT case when cnt = 0 then ...
52	2	aktbxfjwnzgmu		update WRM$_DATABASE_INSTANCE ...
51	27	9p5tvdmjymwx7		UPDATE MGMT_POLICY_ASSOC_EVAL_...
51	4	f0wj261bm8snd		update wrm$_wr_control set sna...
50	2	0ut2yw7mxf0aq		insert into WRM$_SNAPSHOT (sna...
37	1,485	59ygsb7wnbc69		insert into DIAG_DOWNLOAD_RECO...
35	1	7zsc0j9jsfm0h		select last_sample_date_num, l...
30	2	bunssq950snhf		insert into wrh$_sga_target_ad...
29	6	cumjq42201t37		select u1.user#, u2.user#, u3....
26	2	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
26	2	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
26	2	dayq182sk41ks		insert into wrh$_memory_target...

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
0ut2yw7mxf0aq	insert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, begin_interval_time, end_interval_time, snap_level, status, error_count, bl_moved, snap_flag) values (:snap_id, :dbid, :instance_number, :startup_time, :begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1)
15u508g96b995	select count(*) from appstore_push_history t where t.auto_push=0 and t.message_type = :1 and t.serial_no = :2 and t.fault_deal_flag = :3
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))
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
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
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
2gxbvynrd71dr	INSERT INTO sys.wri$_adv_rec_actions (task_id, rec_id, act_id) VALUES (:1, :2, :3)
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
3sqgkcng6vx8r	INSERT INTO sys.wri$_adv_rationale (id, task_id, rec_id, obj_id, impact_msg_id, impact_val, msg_id, type, attr1, attr2, attr3, attr4, attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, ' ', :13) RETURNING rowid INTO :14
47mm81hm9sggy	SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid
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
5uw1u291s3m0k	SELECT case when cnt = 0 then 0 else (1000000 * total) / cnt end FROM ( SELECT SUM(m.num_interval) AS cnt, SUM(m.num_interval * m.average) AS total FROM WRH$_SYSMETRIC_SUMMARY m , WRH$_METRIC_NAME n WHERE m.dbid = :dbid and m.instance_number = :inst_num and m.snap_id > :begin_snap_id and m.snap_id <= :end_snap_id and m.metric_id = n.metric_id and n.dbid = :dbid and n.metric_name = 'Current OS Load' )
692wcvj50ytxz	insert into wrh$_resource_limit (snap_id, dbid, instance_number, resource_name, current_utilization, max_utilization, initial_allocation, limit_value) select :snap_id, :dbid, :instance_number, resource_name, current_utilization, max_utilization, initial_allocation, limit_value from v$resource_limit where limit_value != ' UNLIMITED' and max_utilization > 0
69k5bhm12sz98	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6hwjmjgrpsuaa	insert into wrh$_enqueue_stat (snap_id, dbid, instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#, cum_wait_time, event#) select :snap_id, :dbid, :instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#, cum_wait_time, event# from v$enqueue_statistics where total_req# != 0 order by eq_type, req_reason
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
7zsc0j9jsfm0h	select last_sample_date_num, last_sample_date, total_samples from WRI$_DBU_CPU_USAGE_SAMPLE where dbid = :dbid and version = :version
84k66tf2s7y1c	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
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
8p9z2ztb272bm	SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number
8vwv6hx92ymmm	UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
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 )
9nkj1gjfq5k91	select * from CC_USER where Lower(USER_NAME) = :1
9p5tvdmjymwx7	UPDATE MGMT_POLICY_ASSOC_EVAL_SUMM SET LAST_EVALUATION_DATE = NVL(:B12 , SYSDATE), ROWS_EVALUATED = NVL(:B11 , 0), TOTAL_VIOLATIONS_LOGGED = NVL(:B10 , TOTAL_VIOLATIONS_LOGGED), NON_EXEMPT_VIOLATIONS_LOGGED = NVL(:B9 , :B8 ), MAX_VIOLATION_LEVEL = NVL(:B7 , :B6 ), COMPLIANCE_SCORE = NVL(:B5 , :B4 ) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1
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
a6j566u48p8nf	select * from SYS_PDT_TYPE where PDT_TYPE_ID = :1
aktbxfjwnzgmu	update WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 )
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
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
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
c8gnrhxma4tas	SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
cumjq42201t37	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
davq1msn9b8kd	UPDATE MGMT_POLICY_ASSOC_EVAL_DETAILS SET CRIT_COUNTER = NVL(:B9 , CRIT_COUNTER), WARN_COUNTER = NVL(:B8 , WARN_COUNTER), INFO_COUNTER = NVL(:B7 , INFO_COUNTER), LAST_ERROR_MESSAGE = :B6 , LAST_EVALUATION_DATE = :B5 WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND COLL_NAME = :B2 AND RESULT_KEY_VALUE = :B1
dayq182sk41ks	insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice
dnwpm0gdccrph	insert into wrh$_process_memory_summary (snap_id, dbid, instance_number, category, num_processes, non_zero_allocs, used_total, allocated_total, allocated_stddev, allocated_max, max_allocated_max) select :snap_id, :dbid, :instance_number, category, COUNT(*) num_processes, SUM(DECODE(allocated, 0, 0, 1)) non_zero_allocs, SUM(used) used_total, SUM(allocated) allocated_total, STDDEV(allocated) allocated_stddev, MAX(allocated) allocated_max, MAX(max_allocated) max_allocated_max from v$process_memory group by category
dnx1ugz1qwd2p	insert into OPERATE_LOG (LOG_ID, LOG_TYPE, OPERATE_DATE, OPERATE_DESC, OPERATE_RESULT, REMOTE_ADDRESS, USER_ID, USER_NAME, CLASS_NAME, METHOD_NAME) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
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
f0wj261bm8snd	update wrm$_wr_control set snap_interval = :bind1, snapint_num = :bind2, retention = :bind3, retention_num = :bind4, most_recent_snap_id = :bind5, most_recent_snap_time = :bind6, mrct_snap_time_num = :bind7, status_flag = :bind8, most_recent_purge_time = :bind9, mrct_purge_time_num = :bind10, most_recent_split_id = :bind11, most_recent_split_time = :bind12, swrf_version = :bind13, registration_status = :bind14, mrct_baseline_id = :bind15, topnsql = :bind16, mrct_bltmpl_id = :bind17 where dbid = :dbid
f318xdxdn0pdc	insert into wrh$_log (snap_id, dbid, instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time) select :snap_id, :dbid, :instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time from v$log
faup55dtz1ufw	SELECT COUNT(*) AS c from sys_product sp left join sys_vender sv on sv.vender_id = sp.filiale_id left join sys_pdt_type spt on spt.pdt_type_id = sp.pdt_type_id left join sys_user su on sp.user_id =su.user_id join appstore_token ap on ap.cc = su.cc where sp.pdt_state = 1 AND sp.filiale_id = :1 AND sp.pdt_type_id = :2
fdjtrdaz8hpvg	INSERT /+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a. flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
fp6ajqcjfqf2j	insert into wrh$_streams_pool_advice (snap_id, dbid, instance_number, size_for_estimate, size_factor, estd_spill_count, estd_spill_time, estd_unspill_count, estd_unspill_time) select :snap_id, :dbid, :instance_number, streams_pool_size_for_estimate, streams_pool_size_factor, estd_spill_count, estd_spill_time, estd_unspill_count, estd_unspill_time from v$streams_pool_advice where streams_pool_size_for_estimate > 0
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gj6uc50hpnr1p	insert into WRH$_MUTEX_SLEEP (snap_id, dbid, instance_number, mutex_type, location, sleeps, wait_time) select :snap_id, :dbid, :instance_number, mutex_type, location, sleeps, wait_time from v$mutex_sleep where sleeps > 0 order by mutex_type, location
gkuh6srmynubb	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 v.VALID_FLAG=1 and s.VALID_FLAG=1 AND d.CHECK_STATE=:5 AND us.SERIAL_NO=:6 AND su.cc=:7 ) temp where temp.RN=1 order by temp.SOFT_ID desc, temp.VERSION_DETAIL_ID

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	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	8	0.01	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	325,797	231.81	184.69
CPU used when call started	325,682	231.73	184.63
CR blocks created	61	0.04	0.03
Cached Commit SCN referenced	352	0.25	0.20
Commit SCN cached	60	0.04	0.03
DB time	882,166	627.67	500.09
DBWR checkpoint buffers written	2,706	1.93	1.53
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	40	0.03	0.02
DBWR undo block writes	461	0.33	0.26
DFO trees parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	6,105	4.34	3.46
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	214	0.15	0.12
Heap Segment Array Updates	71	0.05	0.04
IMU CR rollbacks	88	0.06	0.05
IMU Flushes	614	0.44	0.35
IMU Redo allocation size	1,774,480	1,262.56	1,005.94
IMU commits	1,174	0.84	0.67
IMU contention	18	0.01	0.01
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	4,765,344	3,390.59	2,701.44
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	223	0.16	0.13
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	0	0.00	0.00
RowCR attempts	287	0.20	0.16
RowCR hits	312	0.22	0.18
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	5	0.00	0.00
SQL*Net roundtrips to/from client	561,097	399.23	318.08
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	249	0.18	0.14
application wait time	0	0.00	0.00
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	5,867	4.17	3.33
branch node splits	1	0.00	0.00
buffer is not pinned count	1,051,305	748.01	595.98
buffer is pinned count	2,636,642	1,876.00	1,494.70
bytes received via SQL*Net from client	65,207,168	46,395.57	36,965.51
bytes sent via SQL*Net to client	208,877,770	148,618.69	118,411.43
calls to get snapshot scn: kcmgss	242,363	172.44	137.39
calls to kcmgas	3,320	2.36	1.88
calls to kcmgcs	116,746	83.07	66.18
cell physical IO interconnect bytes	96,099,840	68,376.03	54,478.37
change write time	785	0.56	0.45
cleanout - number of ktugct calls	213	0.15	0.12
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	5	0.00	0.00
cluster key scan block gets	320	0.23	0.18
cluster key scans	187	0.13	0.11
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: 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.01	0.01
commit cleanout failures: cannot pin	10	0.01	0.01
commit cleanouts	10,500	7.47	5.95
commit cleanouts successfully completed	10,481	7.46	5.94
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	873	0.62	0.49
concurrency wait time	8,581	6.11	4.86
consistent changes	145	0.10	0.08
consistent gets	3,674,686	2,614.58	2,083.16
consistent gets - examination	514,179	365.84	291.48
consistent gets direct	240	0.17	0.14
consistent gets from cache	3,674,446	2,614.41	2,083.02
consistent gets from cache (fastpath)	2,876,141	2,046.40	1,630.47
cursor authentications	45	0.03	0.03
data blocks consistent reads - undo records applied	123	0.09	0.07
db block changes	38,479	27.38	21.81
db block gets	51,558	36.68	29.23
db block gets direct	45	0.03	0.03
db block gets from cache	51,513	36.65	29.20
db block gets from cache (fastpath)	17,588	12.51	9.97
deferred (CURRENT) block cleanout applications	5,922	4.21	3.36
dirty buffers inspected	0	0.00	0.00
enqueue conversions	357	0.25	0.20
enqueue deadlocks	0	0.00	0.00
enqueue releases	21,656	15.41	12.28
enqueue requests	21,658	15.41	12.28
enqueue timeouts	0	0.00	0.00
enqueue waits	1	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	236,290	168.12	133.95
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	158,464,394	112,749.05	89,832.42
free buffer inspected	763	0.54	0.43
free buffer requested	1,306	0.93	0.74
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	59	0.04	0.03
hot buffers moved to head of LRU	141	0.10	0.08
immediate (CR) block cleanout applications	5	0.00	0.00
immediate (CURRENT) block cleanout applications	645	0.46	0.37
index crx upgrade (positioned)	31	0.02	0.02
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	161	0.11	0.09
index fetch by key	149,806	106.59	84.92
index scans kdiixs1	329,361	234.34	186.71
leaf node 90-10 splits	58	0.04	0.03
leaf node splits	83	0.06	0.05
lob reads	247	0.18	0.14
lob writes	68	0.05	0.04
lob writes unaligned	68	0.05	0.04
logons cumulative	220	0.16	0.12
max cf enq hold time	0	0.00	0.00
messages received	3,011	2.14	1.71
messages sent	3,011	2.14	1.71
min active SCN optimization applied on CR	209	0.15	0.12
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	2,971,729	2,114.42	1,684.65
non-idle wait count	608,820	433.18	345.14
non-idle wait time	91,999	65.46	52.15
opened cursors cumulative	235,708	167.71	133.62
parse count (describe)	0	0.00	0.00
parse count (failures)	1	0.00	0.00
parse count (hard)	93	0.07	0.05
parse count (total)	234,085	166.55	132.70
parse time cpu	194	0.14	0.11
parse time elapsed	7,596	5.40	4.31
physical read IO requests	654	0.47	0.37
physical read bytes	5,357,568	3,811.96	3,037.17
physical read total IO requests	3,253	2.31	1.84
physical read total bytes	47,923,200	34,097.85	27,167.35
physical read total multi block requests	0	0.00	0.00
physical reads	654	0.47	0.37
physical reads cache	414	0.29	0.23
physical reads cache prefetch	0	0.00	0.00
physical reads direct	240	0.17	0.14
physical reads direct (lob)	223	0.16	0.13
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	1,576	1.12	0.89
physical write bytes	22,536,192	16,034.73	12,775.62
physical write total IO requests	4,646	3.31	2.63
physical write total bytes	48,176,640	34,278.18	27,311.02
physical write total multi block requests	41	0.03	0.02
physical writes	2,751	1.96	1.56
physical writes direct	45	0.03	0.03
physical writes direct (lob)	17	0.01	0.01
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	2,706	1.93	1.53
physical writes non checkpoint	1,061	0.75	0.60
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,479	2.48	1.97
queries parallelized	0	0.00	0.00
recursive calls	121,456	86.42	68.85
recursive cpu usage	406	0.29	0.23
redo blocks checksummed by FG (exclusive)	10,920	7.77	6.19
redo blocks written	19,807	14.09	11.23
redo buffer allocation retries	0	0.00	0.00
redo entries	12,807	9.11	7.26
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	365	0.26	0.21
redo size	9,229,584	6,566.94	5,232.19
redo size for direct writes	370,304	263.48	209.92
redo subscn max counts	1,195	0.85	0.68
redo synch time	35,208	25.05	19.96
redo synch writes	2,040	1.45	1.16
redo wastage	579,652	412.43	328.60
redo write time	22,045	15.69	12.50
redo writes	2,123	1.51	1.20
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	61	0.04	0.03
root node splits	0	0.00	0.00
rows fetched via callback	97,881	69.64	55.49
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	160,731	114.36	91.12
session logical reads	3,726,244	2,651.26	2,112.38
shared hash latch upgrades - no wait	72,309	51.45	40.99
shared hash latch upgrades - wait	3	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	28,484	20.27	16.15
sorts (rows)	601,258	427.80	340.85
sql area evicted	81	0.06	0.05
sql area purged	1	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	177	0.13	0.10
table fetch by rowid	1,599,118	1,137.79	906.53
table fetch continued row	41,529	29.55	23.54
table scan blocks gotten	863,519	614.40	489.52
table scan rows gotten	42,805,023	30,456.22	24,265.89
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)	43,496	30.95	24.66
temp space allocated (bytes)	1,048,576	746.07	594.43
total cf enq hold time	3,870	2.75	2.19
total number of cf enq holders	105	0.07	0.06
total number of times SMON posted	5	0.00	0.00
transaction rollbacks	0	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	2,603,240	1,852.23	1,475.76
user I/O wait time	12,686	9.03	7.19
user calls	787,040	559.99	446.17
user commits	1,764	1.26	1.00
user rollbacks	0	0.00	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	24,565	17.48	13.93
write clones created in background	0	0.00	0.00
write clones created in foreground	3	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,345,829,936,664	1,346,147,590,760
session pga memory	457,724,402,552	457,789,413,424
session pga memory max	515,429,559,768	515,378,438,160
session cursor cache count	13,296,015	13,302,709
session uga memory	803,995,508,435,512	804,102,893,795,936
opened cursors current	406	391
workarea memory allocated	7,409	7,409
logons current	92	94

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	40M	1.86	.028460	15M	0.67	.010672	3562	44.33
DBWR	0M	0.00	0M	21M	1.11	.014941	506	90.07
LGWR	0M	0.00	0M	10M	1.51	.007115	2123	103.36
Buffer Cache Reads	4M	0.29	.002846	0M	0.00	0M	410	268.73
Direct Reads	2M	0.16	.001423	0M	0.00	0M	223	0.00
Direct Writes	0M	0.00	0M	0M	0.01	0M	21	0.00
TOTAL:	46M	2.31	.032729	46M	3.31	.032729	6845	77.88

Back to IO Stats

Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000

Small Read and Large Read are average service times, in milliseconds

Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read
Control File	41M	1.84	.029171	15M	0.67	.010672	1.69
Data File	5M	0.48	.003557	21M	1.12	.014941	168.99
Log File	0M	0.00	0M	10M	1.51	.007115
TOTAL:	46M	2.31	.032729	46M	3.31	.032729	36.09

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	41M	1.86	.029171	15M	0.67	.010672	2616	2.70
Others (Control File)	41M	1.84	.029171	15M	0.67	.010672	2581	1.69
Others (Data File)	0M	0.02	0M	0M	0.00	0M	35	77.40
DBWR	0M	0.00	0M	21M	1.11	.014941	0
DBWR (Data File)	0M	0.00	0M	21M	1.11	.014941	0
LGWR	0M	0.00	0M	10M	1.51	.007115	0
LGWR (Log File)	0M	0.00	0M	10M	1.51	.007115	0
Buffer Cache Reads	4M	0.29	.002846	0M	0.00	0M	409	269.38
Buffer Cache Reads (Data File)	4M	0.29	.002846	0M	0.00	0M	409	269.38
Direct Reads	2M	0.16	.001423	0M	0.00	0M	0
Direct Reads (Data File)	2M	0.16	.001423	0M	0.00	0M	0
Direct Writes	0M	0.00	0M	0M	0.01	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.01	0M	0
TOTAL:	47M	2.31	.033440	46M	3.31	.032729	3025	38.76

Back to IO Stats

Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	209	396.89	1.00	841	1	0	0.00
MYCAR	429	39.93	1.00	544	0	4	55.00
UNDOTBS1	0	0.00	0.00	99	0	3	0.00
SYSTEM	21	575.24	1.00	50	0	3	0.00
PASSPORT	6	86.67	1.00	42	0	0	0.00

Back to IO Stats

Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
MYCAR	/oracle/oradata/mycar/mycar.dbf	246	4.39	1.00	178	0	0	0.00
MYCAR	/oracle/oradata/mycar/mycar01.dbf	183	87.70	1.00	366	0	4	55.00
PASSPORT	/oracle/oradata/mycar/passport.dbf	6	86.67	1.00	42	0	0	0.00
SYSAUX	/oracle/oradata/mycar/sysaux01.dbf	209	396.89	1.00	841	1	0	0.00
SYSTEM	/oracle/oradata/mycar/system01.dbf	21	575.24	1.00	50	0	3	0.00
UNDOTBS1	/oracle/oradata/mycar/undotbs01.dbf	0			99	0	3	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	3,725,875	426	2,706	0	0	10

Back to Buffer Pool Statistics

Back to Top

Checkpoint Activity

Total Physical Writes: 2,751

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	2,706	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	457	2682	11993	995328	11993
E	0	14	463	3651	22237	995328	22237

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	64	0.08	8	1.85	2,905,152	1	1892882.00
D	128	0.16	16	1.29	2,035,486	1	680289.00
D	192	0.24	24	1.01	1,592,240	1	62263.00
D	256	0.33	32	1.00	1,578,303	1	42829.00
D	320	0.41	39	1.00	1,574,793	1	37935.00
D	384	0.49	47	1.00	1,574,186	1	37089.00
D	448	0.57	55	1.00	1,573,713	1	36429.00
D	512	0.65	63	1.00	1,573,349	1	35922.00
D	576	0.73	71	1.00	1,573,049	1	35503.00
D	640	0.82	79	1.00	1,572,766	1	35109.00
D	704	0.90	87	1.00	1,572,536	1	34788.00
D	768	0.98	95	1.00	1,572,338	1	34513.00
D	784	1.00	97	1.00	1,572,292	1	34448.00
D	832	1.06	102	1.00	1,572,152	1	34253.00
D	896	1.14	110	1.00	1,571,971	1	34001.00
D	960	1.22	118	1.00	1,571,780	1	33734.00
D	1,024	1.31	126	1.00	1,571,650	1	33553.00
D	1,088	1.39	134	1.00	1,571,549	1	33412.00
D	1,152	1.47	142	1.00	1,571,462	1	33291.00
D	1,216	1.55	150	1.00	1,571,382	1	33180.00
D	1,280	1.63	158	1.00	1,571,281	1	33038.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	1,068	0

Back to Advisory Statistics

Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics

Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	21,612	21,612
64K	128K	1,240	1,240
128K	256K	686	686
256K	512K	8	8
512K	1024K	911	911
1M	2M	103	103
2M	4M	1	1
4M	8M	4	4

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	28,120,921.79	52,829,686.26	35.00	405,271	95,433,405,200
284	0.25	28,120,921.79	52,667,945.20	35.00	401,134	95,242,727,197
568	0.50	28,120,921.79	13,327,939.90	68.00	9	48,864,438,550
852	0.75	28,120,921.79	12,964,308.28	68.00	0	48,435,749,942
1,136	1.00	28,120,921.79	12,107,330.22	70.00	0	47,425,450,743
1,363	1.20	28,120,921.79	11,946,154.45	70.00	0	47,235,439,164
1,590	1.40	28,120,921.79	11,946,004.62	70.00	0	47,235,262,536
1,818	1.60	28,120,921.79	11,945,893.70	70.00	0	47,235,131,767
2,045	1.80	28,120,921.79	11,945,893.70	70.00	0	47,235,131,767
2,272	2.00	28,120,921.79	11,945,893.70	70.00	0	47,235,131,767
3,408	3.00	28,120,921.79	11,945,893.70	70.00	0	47,235,131,767
4,544	4.00	28,120,921.79	11,945,734.11	70.00	0	47,234,943,625
6,816	6.00	28,120,921.79	11,945,734.11	70.00	0	47,234,943,625
9,088	8.00	28,120,921.79	11,945,734.11	70.00	0	47,234,943,625

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	39	2,136	7,464,467	1.00	305,051	1.08	118,443
880	0.70	167	8,073	7,469,677	1.00	299,841	1.06	382,307
1,008	0.80	295	11,913	7,482,058	1.00	287,460	1.02	383,071
1,136	0.90	423	16,096	7,484,428	1.00	285,090	1.01	383,363
1,264	1.00	551	20,504	7,486,402	1.00	283,116	1.00	383,610
1,392	1.10	679	23,963	7,488,064	1.00	281,454	0.99	383,828
1,520	1.20	807	27,881	7,488,944	1.00	280,574	0.99	383,952
1,648	1.30	935	31,964	7,489,361	1.00	280,157	0.99	384,007
1,776	1.41	1,063	35,242	7,489,783	1.00	279,735	0.99	384,046
1,904	1.51	1,191	38,821	7,490,077	1.00	279,441	0.99	384,067
2,032	1.61	1,319	42,521	7,490,335	1.00	279,183	0.99	384,084
2,160	1.71	1,447	46,182	7,490,521	1.00	278,997	0.99	384,098
2,288	1.81	1,575	50,014	7,490,696	1.00	278,822	0.98	384,110
2,416	1.91	1,703	53,296	7,490,847	1.00	278,671	0.98	384,120
2,544	2.01	1,831	56,319	7,490,938	1.00	278,580	0.98	384,130

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,726,939	1,591,945,921
1,608	0.75	6,681,545	1,573,864,560
2,144	1.00	6,675,537	1,572,292,268
2,680	1.25	6,672,867	1,571,506,122
3,216	1.50	6,671,532	1,571,191,663
3,752	1.75	6,670,864	1,571,034,434
4,288	2.00	6,670,864	1,571,034,434

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	7	0	31
undo header	3	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)
CF-Controlfile Transaction	650	650	0	1	0	260.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.44	2,769	904	4	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
18-Jul 17:20	184	1,370	304	4	240	0/0	0/0/0/0/0/0
18-Jul 17:10	93	929	904	2	240	0/0	0/0/0/0/0/0
18-Jul 17:00	161	470	299	3	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	2	0.00		0	0
ASM db client latch	940	0.00		0	0
ASM map operation hash table	2	0.00		0	0
ASM network state latch	25	0.00		0	0
AWR Alerted Metric Element list	12,022	0.00		0	0
Change Notification Hash table latch	462	0.00		0	0
Consistent RBA	2,123	0.00		0	0
DML lock allocation	12,222	0.00		0	0
Event Group Locks	197	0.00		0	0
FAL Queue	69	0.00		0	0
FOB s.o list latch	858	0.00		0	0
File State Object Pool Parent Latch	2	0.00		0	0
IPC stats buffer allocation latch	2	0.00		0	0
In memory undo latch	15,231	0.00		0	2,104	0.00
JS Sh mem access	6	0.00		0	0
JS mem alloc latch	2	0.00		0	0
JS queue access latch	4	0.00		0	0
JS queue state obj latch	9,828	0.00		0	0
JS slv state obj latch	94	0.00		0	0
KFC FX Hash Latch	2	0.00		0	0
KFC Hash Latch	2	0.00		0	0
KFCL LE Freelist	2	0.00		0	0
KGNFS-NFS:SHM structure	2	0.00		0	0
KGNFS-NFS:SVR LIST	2	0.00		0	0
KJC message pool free list	2	0.00		0	0
KJCT flow control latch	2	0.00		0	0
KMG MMAN ready and startup request latch	467	0.00		0	0
KTF sga latch	8	0.00		0	370	0.00
KWQP Prop Status	4	0.00		0	0
KWQS pqsubs latch	10	0.00		0	0
KWQS pqueue ctx latch	64	0.00		0	0
Locator state objects pool parent latch	2	0.00		0	0
Lsod array latch	2	0.00		0	0
MQL Tracking Latch	0			0	27	0.00
Memory Management Latch	2	0.00		0	467	0.00
Memory Queue	2	0.00		0	0
Memory Queue Message Subscriber #1	2	0.00		0	0
Memory Queue Message Subscriber #2	2	0.00		0	0
Memory Queue Message Subscriber #3	2	0.00		0	0
Memory Queue Message Subscriber #4	2	0.00		0	0
Memory Queue Subscriber	2	0.00		0	0
MinActiveScn Latch	8	0.00		0	0
Mutex	2	0.00		0	0
Mutex Stats	2	0.00		0	0
OS process	905	0.00		0	0
OS process allocation	1,069	0.00		0	0
OS process: request allocation	388	0.00		0	0
PL/SQL warning settings	324	0.00		0	0
PX hash array latch	2	0.00		0	0
QMT	2	0.00		0	0
Real-time plan statistics latch	1,633	0.00		0	0
SGA blob parent	2	0.00		0	0
SGA bucket locks	2	0.00		0	0
SGA heap locks	2	0.00		0	0
SGA pool locks	2	0.00		0	0
SQL memory manager latch	48	0.00		0	440	0.00
SQL memory manager workarea list latch	59,810	0.00		0	0
Shared B-Tree	194	0.00		0	0
Streams Generic	2	0.00		0	0
Testing	2	0.00		0	0
Token Manager	2	0.00		0	0
WCR: sync	2	0.00		0	0
Write State Object Pool Parent Latch	2	0.00		0	0
X$KSFQP	4,670	0.00		0	0
XDB NFS Security Latch	2	0.00		0	0
XDB unused session pool	2	0.00		0	0
XDB used session pool	2	0.00		0	0
active checkpoint queue latch	961	0.00		0	0
active service list	3,948	0.05	0.00	0	5,933	0.00
archive control	24	0.00		0	0
archive process latch	207	0.00		0	0
begin backup scn array	21	0.00		0	0
buffer pool	2	0.00		0	0
business card	2	0.00		0	0
cache buffer handles	10,292	0.00		0	0
cache buffers chains	7,064,688	0.00	0.35	8	1,242	0.00
cache buffers lru chain	3,077	0.00		0	6,654	0.00
call allocation	1,016	0.89	1.11	1	0
cas latch	2	0.00		0	0
change notification client cache latch	2	0.00		0	0
channel handle pool latch	408	0.00		0	0
channel operations parent latch	7,386	0.00		0	0
checkpoint queue latch	46,491	0.00		0	2,592	0.00
client/application info	1,498	0.00		0	0
compile environment latch	220	0.00		0	0
cp cmon/server latch	2	0.00		0	0
cp pool latch	2	0.00		0	0
cp server hash latch	2	0.00		0	0
cp sga latch	25	0.00		0	0
cvmap freelist lock	2	0.00		0	0
deferred cleanup latch	25	0.00		0	0
dml lock allocation	25	0.00		0	0
done queue latch	2	0.00		0	0
dummy allocation	440	0.00		0	0
enqueue hash chains	43,646	0.00	0.50	0	0
enqueues	24,592	0.01	0.00	0	0
fifth spare latch	2	0.00		0	0
file cache latch	124	0.00		0	0
flashback copy	2	0.00		0	0
gc element	2	0.00		0	0
gcs commit scn state	2	0.00		0	0
gcs partitioned table hash	2	0.00		0	0
gcs pcm hashed value bucket hash	2	0.00		0	0
gcs resource freelist	2	0.00		0	0
gcs resource hash	2	0.00		0	0
gcs resource scan list	2	0.00		0	0
gcs shadows freelist	2	0.00		0	0
ges domain table	2	0.00		0	0
ges enqueue table freelist	2	0.00		0	0
ges group table	2	0.00		0	0
ges process hash list	2	0.00		0	0
ges process parent latch	2	0.00		0	0
ges resource hash list	2	0.00		0	0
ges resource scan list	2	0.00		0	0
ges resource table freelist	2	0.00		0	0
ges value block free list	2	0.00		0	0
global KZLD latch for mem in SGA	140	0.00		0	0
global tx hash mapping	2	0.00		0	0
granule operation	2	0.00		0	0
hash table column usage latch	33	0.00		0	21,479	0.00
hash table modification latch	65	0.00		0	0
heartbeat check	2	0.00		0	0
intra txn parallel recovery	2	0.00		0	0
io pool granule metadata list	2	0.00		0	0
job workq parent latch	27	0.00		0	25	0.00
job_queue_processes free list latch	50	0.00		0	0
job_queue_processes parameter latch	320	0.00		0	0
k2q lock allocation	2	0.00		0	0
kdlx hb parent latch	2	0.00		0	0
kgb parent	2	0.00		0	0
kks stats	479	0.00		0	0
kokc descriptor allocation latch	238	0.00		0	0
ksfv messages	2	0.00		0	0
kss move lock	18	0.00		0	0
ksuosstats global area	100	0.00		0	0
ksv allocation latch	58	0.00		0	0
ksv class latch	36	0.00		0	0
ksv msg queue latch	2	0.00		0	0
ksz_so allocation latch	388	0.00		0	0
ktm global data	19	0.00		0	0
kwqbsn:qsga	54	0.00		0	0
lgwr LWN SCN	2,554	0.00		0	0
list of block allocation	523	0.00		0	0
loader state object freelist	536	0.00		0	0
lob segment dispenser latch	2	0.00		0	0
lob segment hash table latch	6	0.00		0	0
lob segment query latch	2	0.00		0	0
lock DBA buffer during media recovery	2	0.00		0	0
logical standby cache	2	0.00		0	0
logminer context allocation	4	0.00		0	0
logminer work area	2	0.00		0	0
longop free list parent	2	0.00		0	0
managed standby latch	69	0.00		0	0
mapped buffers lru chain	2	0.00		0	0
message pool operations parent latch	77	0.00		0	0
messages	20,650	0.03	0.00	0	0
mostly latch-free SCN	2,554	0.00		0	0
msg queue latch	2	0.00		0	0
name-service namespace bucket	2	0.00		0	0
ncodef allocation latch	25	0.00		0	0
object queue header heap	31	0.00		0	13	0.00
object queue header operation	13,285	0.00		0	0
object stats modification	8	0.00		0	0
parallel query alloc buffer	182	0.00		0	0
parallel query stats	2	0.00		0	0
parameter list	230	0.00		0	0
parameter table management	438	0.00		0	0
peshm	2	0.00		0	0
pesom_free_list	2	0.00		0	0
pesom_hash_node	2	0.00		0	0
post/wait queue	5,187	0.02	0.00	0	4,253	0.07
process allocation	442	0.00		0	195	0.00
process group creation	388	0.00		0	0
process queue	2	0.00		0	0
process queue reference	2	0.00		0	0
qmn task queue latch	350	0.00		0	0
query server freelists	2	0.00		0	0
queued dump request	4	0.00		0	0
queuing load statistics	2	0.00		0	0
recovery domain hash list	2	0.00		0	0
redo allocation	11,387	0.00		0	12,745	0.00
redo copy	2	0.00		0	12,745	1.29
redo writing	8,259	0.00		0	0
resmgr group change latch	297	0.00		0	0
resmgr:active threads	440	0.00		0	0
resmgr:actses change group	176	0.00		0	0
resmgr:actses change state	2	0.00		0	0
resmgr:free threads list	438	0.00		0	0
resmgr:plan CPU method	2	0.00		0	0
resmgr:resource group CPU method	2	0.00		0	0
resmgr:schema config	162	0.00		0	0
resmgr:session queuing	2	0.00		0	0
rm cas latch	2	0.00		0	0
row cache objects	169,410	0.02	0.20	0	42	0.00
rules engine rule set statistics	200	0.00		0	0
second spare latch	2	0.00		0	0
sequence cache	11,544	0.00		0	0
session allocation	172,054	0.00	0.25	0	57,352	0.00
session idle bit	1,631,214	0.00	0.07	0	0
session queue latch	2	0.00		0	0
session state list latch	465	0.00		0	0
session switching	992	0.00		0	0
session timer	518	0.00		0	0
shared pool	21,070	0.79	0.20	16	0
shared pool sim alloc	2	0.00		0	0
shared pool simulator	1,041	0.00		0	0
sim partition latch	2	0.00		0	0
simulator hash latch	269,970	0.00		0	0
simulator lru latch	1,302	0.08	0.00	0	268,554	0.04
sort extent pool	49	0.00		0	0
space background task latch	990	0.00		0	932	0.00
state object free list	4	0.00		0	0
statistics aggregation	1,120	0.00		0	0
tablespace key chain	2	0.00		0	0
temp lob duration state obj allocation	3	0.00		0	0
test excl. parent l0	2	0.00		0	0
test excl. parent2 l0	2	0.00		0	0
third spare latch	2	0.00		0	0
threshold alerts latch	60	0.00		0	0
transaction allocation	840	0.00		0	0
undo global data	12,786	0.00		0	0
virtual circuit buffers	2	0.00		0	0
virtual circuit holder	2	0.00		0	0
virtual circuit queues	2	0.00		0	0

Back to Latch Statistics

Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	7,064,688	170	60	110
shared pool	21,070	167	34	136
row cache objects	169,410	35	7	28
session idle bit	1,631,214	28	2	26
call allocation	1,016	9	10	0
session allocation	172,054	4	1	3
enqueue hash chains	43,646	2	1	1

Back to Latch Statistics

Back to Top

Latch Miss Sources

only latches with sleeps are shown

ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
active service list	kswslogon: session logout	1	1
cache buffers chains	kcbgtcr: fast path (cr pin)	34	34
cache buffers chains	kcbrls_1	15	15
cache buffers chains	kcbgtcr: fast path	7	3
cache buffers chains	kcbrls_2	3	5
cache buffers chains	kcbgcur_2	1	0
cache buffers chains	kcbgtcr_2	1	3
call allocation	ksudlp: top call	7	0
call allocation	ksuxds	3	10
enqueue hash chains	ksqgtl3	1	0
row cache objects	kqrpre: find obj	4	7
row cache objects	kqreqd: reget	3	0
session allocation	ksuxds	1	1
session idle bit	ksupuc: clear busy	1	1
session idle bit	ksupuc: set busy	1	1
shared pool	kghalo	22	26
shared pool	kghupr1	8	6
shared pool	kghfre	3	2
shared pool	kghalp	1	0

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	kglpin1 4	88	1,794
Library Cache	kgllkdl1 85	9	76
Cursor Pin	kksLockDelete [KKSCHLPIN6]	2	0
Cursor Pin	kksfbc [KKSCHLPIN1]	2	0
Library Cache	kglIsOwnerVersionable 121	1	109
Library Cache	kglhdgn2 106	1	517
Library Cache	kglpndl1 95	1	-56
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	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: 3,726,244

Captured Segments account for 93.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
MYCAR	MYCAR	UNI_IP_RANGE	INDEX	1,420,032	38.11
MYCAR	MYCAR	SYS_VENDER	TABLE	294,784	7.91
MYCAR	MYCAR	SYS_PRODUCT	TABLE	174,352	4.68
MYCAR	MYCAR	SYS_PRODUCT_IP_RULE	TABLE	154,992	4.16
MYCAR	MYCAR	DIAG_SOFT_VERSION	TABLE	150,160	4.03

Back to Segment Statistics

Back to Top

Segments by Physical Reads

Total Physical Reads: 654

Captured Segments account for 42.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
MYCAR	MYCAR	OPERATE_LOG		TABLE	100	15.29
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD		TABLE	38	5.81
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	24	3.67
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD		INDEX	22	3.36
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1652681432_10051	TABLE PARTITION	20	3.06

Back to Segment Statistics

Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 654

Captured Segments account for 42.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
MYCAR	MYCAR	OPERATE_LOG		TABLE	100	15.29
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD		TABLE	38	5.81
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	24	3.67
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD		INDEX	22	3.36
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1652681432_10051	TABLE PARTITION	20	3.06

Back to Segment Statistics

Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 654

Captured Segments account for 42.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
MYCAR	MYCAR	OPERATE_LOG		TABLE	100	15.29
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD		TABLE	38	5.81
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	24	3.67
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD		INDEX	22	3.36
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1652681432_10051	TABLE PARTITION	20	3.06

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: 2,751

Captured Segments account for 47.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
MYCAR	MYCAR	OPERATE_LOG	TABLE	401	14.58
MYCAR	MYCAR	COM_IND_DUSC	INDEX	224	8.14
MYCAR	MYCAR	PK_OPERATE_LOG	INDEX	57	2.07
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	55	2.00
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD	INDEX	55	2.00

Back to Segment Statistics

Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 1,576

Captured Segments account for 46.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
MYCAR	MYCAR	OPERATE_LOG	TABLE	156	9.90
MYCAR	MYCAR	COM_IND_DUSC	INDEX	141	8.95
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	49	3.11
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD	INDEX	48	3.05
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	41	2.60

Back to Segment Statistics

Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 45

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_10051	TABLE PARTITION	28	62.22
SYS	SYSAUX	SYS_LOB0000006213C00038$$		LOB	17	37.78

Back to Segment Statistics

Back to Top

Segments by Table Scans

Total Table Scans: 161

Captured Segments account for 30.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
MYCAR	MYCAR	PK_SYS_LAN		INDEX	49	30.43

Back to Segment Statistics

Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared

with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
MYCAR	MYCAR	OPERATE_LOG	TABLE	1,744	28.99
MYCAR	MYCAR	PK_OPERATE_LOG	INDEX	768	12.77
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	720	11.97
MYCAR	MYCAR	IND2_DIAG_DOWNLOAD_RECORD	INDEX	624	10.37
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	272	4.52

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	IND2_DIAG_DOWNLOAD_RECORD		INDEX	3	60.00
MYCAR	MYCAR	PK_DIAG_DOWNLOAD_RECORD		INDEX	2	40.00

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
SYS	SYSTEM	AUD$		TABLE	3	100.00

Back to Segment Statistics

Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)

"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	30	0.00	4	1
dc_global_oids	267	0.00	0	48
dc_histogram_data	1,249	0.08	0	4,778
dc_histogram_defs	1,726	6.89	0	5,453
dc_objects	2,033	0.20	0	2,702
dc_profiles	165	0.00	0	1
dc_rollback_segments	909	0.00	0	52
dc_segments	911	0.00	15	1,390
dc_sequences	345	0.00	345	56
dc_tablespaces	19,267	0.00	0	10
dc_users	31,467	0.00	0	165
global database name	1,096	0.00	0	2
outstanding_alerts	14	0.00	0	7
sch_lj_oids	2	0.00	0	16

Back to Top

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	563	0.00	739	0.00	0	0
CLUSTER	3	0.00	2	0.00	0	0
DBLINK	282	0.00	0		0	0
EDITION	174	0.00	339	0.00	0	0
QUEUE	32	0.00	112	0.00	0	0
SCHEMA	305	0.00	0		0	0
SQL AREA	8,707	1.75	244,130	0.09	50	1
SUBSCRIPTION	9	0.00	9	0.00	0	0
TABLE/PROCEDURE	1,742	0.00	28,613	0.19	55	0
TRIGGER	10	0.00	25	0.00	0	0

Back to Top

Memory Statistics

Memory Dynamic Components

Memory Resize Operations Summary

Memory Resize Ops

Process Memory Summary

SGA Memory Summary

SGA breakdown difference

Back to Top

Memory Dynamic Components

Min/Max sizes since instance startup

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred

ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	784.00	784.00	752.00	816.00	GRO/MAN
KEEP buffer cache	0.00	0.00	0.00	32.00	SHR/MAN
PGA Target	1,136.00	1,136.00	1,136.00	1,136.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	2,144.00	2,144.00	2,144.00	2,144.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	16.00	16.00	16.00	16.00	STA/
large pool	16.00	16.00	16.00	16.00	STA/
shared pool	1,264.00	1,264.00	1,264.00	1,264.00	STA/
streams pool	32.00	32.00	0.00	32.00	GRO/IMM

Back to Memory Statistics

Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics

Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics

Back to Top

Process Memory Summary

B: Begin Snap E: End Snap

All rows below contain absolute values (i.e. not diffed over the interval)

Max Alloc is Maximum PGA Allocation size at snapshot time

Hist Max Alloc is the Historical Max Allocation for still-connected processes

ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	379.76		4.04	8.16	28	32	94	94
	Freeable	53.94	0.00	1.08	0.68	4		50	50
	SQL	1.55	0.95	0.02	0.02	0	25	72	66
	PL/SQL	1.18	0.95	0.01	0.03	0	0	92	92
E	Other	379.98		3.96	8.09	28	32	96	96
	Freeable	56.94	0.00	1.09	0.67	4		52	52
	SQL	2.13	1.53	0.03	0.07	1	25	74	68
	PL/SQL	1.22	0.99	0.01	0.03	0	0	94	94

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	87.22	87.25	0.03
shared	FileOpenBlock	15.20	15.20	0.00
shared	KGLHD	25.82	25.86	0.16
shared	KGLS	14.00	14.00	-0.03
shared	PCUR	76.72	76.79	0.09
shared	PLMCD	13.25	12.99	-1.98
shared	SQLA	498.86	499.20	0.07
shared	free memory	329.32	329.08	-0.07
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)	34	34	0.00	0.00	1.07	2.39	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.03	0.07

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 %
1,405	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	1,405	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_keep_cache_size	0
db_name	mycar
db_recovery_file_dest	/oracle/flash_recovery_area
db_recovery_file_dest_size	4070572032
deferred_segment_creation	FALSE
diagnostic_dest	/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=mycarXDB)
log_archive_dest_1	location=/oracle/oradata/archivelog
log_archive_format	archive_%t_%s_%r.log
log_archive_max_processes	10
memory_target	3439329280
open_cursors	300
processes	500
remote_login_passwordfile	EXCLUSIVE
sec_case_sensitive_logon	FALSE
sql_trace	FALSE
undo_retention	14400
undo_tablespace	UNDOTBS1
workarea_size_policy	AUTO

ITPub博客

werdgdsds

WORKLOAD REPOSITORY report for

Report Summary

Main Report

Wait Events Statistics

Time Model Statistics

Operating System Statistics

Operating System Statistics - Detail

Foreground Wait Class

Foreground Wait Events

Background Wait Events

Wait Event Histogram

Wait Event Histogram Detail (64 msec to 2 sec)

Wait Event Histogram Detail (4 sec to 2 min)

Wait Event Histogram Detail (4 min to 1 hr)

Service Statistics

Service Wait Class Stats

SQL Statistics

SQL ordered by Elapsed Time

SQL ordered by CPU Time

SQL ordered by User I/O Wait Time

SQL ordered by Gets

SQL ordered by Reads

SQL ordered by Physical Reads (UnOptimized)

SQL ordered by Executions

SQL ordered by Parse Calls

SQL ordered by Sharable Memory

SQL ordered by Version Count

Complete List of SQL Text

Instance Activity Statistics

Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

Advisory Statistics

Instance Recovery Stats

MTTR Advisory

Buffer Pool Advisory

PGA Aggr Summary

PGA Aggr Target Stats

PGA Aggr Target Histogram

PGA Memory Advisory

Shared Pool Advisory

SGA Target Advisory

Streams Pool Advisory

Java Pool Advisory

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Segment Statistics

Segments by Logical Reads

Segments by Physical Reads

Segments by Physical Read Requests

Segments by UnOptimized Reads

Segments by Optimized Reads

Segments by Direct Physical Reads

Segments by Physical Writes

Segments by Physical Write Requests

Segments by Direct Physical Writes

Segments by Table Scans

Segments by DB Blocks Changes