AWR Report for DB: MYCAR, Inst: mycar, Snaps: 9225-9226

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:	9225	14-Jun-13 07:00:09	92	3.7
End Snap:	9226	14-Jun-13 08:00:34	94	3.7
Elapsed:		60.43 (mins)
DB Time:		5.77 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	816M	816M	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):	0.1	0.4	0.00	0.00
DB CPU(s):	0.1	0.3	0.00	0.00
Redo size:	1,194.4	4,621.6
Logical reads:	13,461.9	52,088.5
Block changes:	5.7	22.0
Physical reads:	71.7	277.4
Physical writes:	0.5	1.9
User calls:	67.0	259.4
Parses:	20.2	78.0
Hard parses:	0.0	0.1
W/A MB processed:	0.6	2.3
Logons:	0.1	0.2
Executes:	21.3	82.4
Rollbacks:	0.0	0.0
Transactions:	0.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.87	Soft Parse %:	99.93
Execute to Parse %:	5.34	Latch Hit %:	99.93
Parse CPU to Parse Elapsd %:	54.84	% Non-Parse CPU:	99.78

Shared Pool Statistics

	Begin	End
Memory Usage %:	71.35	71.34
% SQL with executions>1:	96.65	96.71
% Memory for SQL w/exec>1:	94.04	94.24

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		309		89.17
log file sync	651	3	5	0.92	Commit
db file sequential read	92	1	8	0.21	User I/O
direct path read	2,277	1	0	0.19	User I/O
SQL*Net message to client	178,246	0	0	0.11	Network

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.00	0.00	1.7	0.4	0.2	97.8

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
2.1	99.0	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):	434.2	437.2
% Host Mem used for SGA+PGA:	31.47	31.51

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

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	331.12	95.62
DB CPU	308.78	89.17
PL/SQL execution elapsed time	84.10	24.28
parse time elapsed	2.29	0.66
hard parse elapsed time	0.16	0.05
sequence load elapsed time	0.04	0.01
repeated bind elapsed time	0.00	0.00
DB time	346.29
background elapsed time	37.32
background cpu time	1.08

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	31,308
IDLE_TIME	1,418,860
IOWAIT_TIME	2,231
NICE_TIME	0
SYS_TIME	6,045
USER_TIME	25,218
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
14-Jun 07:00:09	0.00
14-Jun 08:00:34	0.00	2.16	1.74	0.42	97.84	0.15

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 90.7% of Total DB time 346.29 (s)

Total FG Wait Time: 5.16 (s) DB CPU time: 308.78 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			309		89.17
Commit	651	0	3	5	0.92
User I/O	2,471	0	1	1	0.41
Network	189,603	0	1	0	0.15
Concurrency	30	0	0	1	0.01
Application	4	0	0	1	0.00
Other	1,036	100	0	0	0.00
System I/O	12	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	651	0	3	5	0.69	0.92
db file sequential read	92	0	1	8	0.10	0.21
direct path read	2,277	0	1	0	2.43	0.19
SQL*Net message to client	178,246	0	0	0	190.23	0.11
SQL*Net more data to client	9,431	0	0	0	10.07	0.03
Disk file operations I/O	102	0	0	0	0.11	0.01
latch: cache buffers chains	27	0	0	1	0.03	0.01
SQL*Net more data from client	1,926	0	0	0	2.06	0.01
enq: KO - fast object checkpoint	4	0	0	1	0.00	0.00
asynch descriptor resize	1,036	100	0	0	1.11	0.00
SQL*Net message from client	178,246	0	125,038	701	190.23
jobq slave wait	7,987	100	3,991	500	8.52

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
control file parallel write	1,276	0	15	12	1.36	40.13
log file parallel write	2,376	0	7	3	2.54	18.29
db file async I/O submit	412	0	5	11	0.44	12.47
os thread startup	142	0	4	28	0.15	10.63
db file sequential read	138	0	0	3	0.15	1.28
control file sequential read	5,984	0	0	0	6.39	0.77
ADR block file read	26	0	0	2	0.03	0.17
Disk file operations I/O	82	0	0	0	0.09	0.06
db file scattered read	1	0	0	8	0.00	0.02
ADR block file write	10	0	0	0	0.01	0.01
asynch descriptor resize	216	100	0	0	0.23	0.01
direct path sync	1	0	0	1	0.00	0.00
log file sync	3	0	0	0	0.00	0.00
rdbms ipc message	16,523	93	79,452	4809	17.63
DIAG idle wait	7,250	100	7,248	1000	7.74
pmon timer	1,298	93	3,626	2794	1.39
Space Manager: slave idle wait	726	99	3,621	4987	0.77
Streams AQ: qmn slave idle wait	132	0	3,614	27377	0.14
Streams AQ: qmn coordinator idle wait	258	50	3,614	14007	0.28
shared server idle wait	120	100	3,602	30015	0.13
dispatcher timer	60	100	3,601	60014	0.06
smon timer	12	100	3,600	300006	0.01
class slave wait	20	0	0	0	0.02

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	26	76.9			11.5	7.7	3.8
ADR block file write	10	100.0
ADR file lock	12	100.0
Disk file operations I/O	184	100.0
LGWR wait for redo copy	8	100.0
SQL*Net message to client	178.2K	100.0					.0
SQL*Net more data from client	1926	99.9	.1
SQL*Net more data to client	9431	100.0
asynch descriptor resize	1252	100.0
control file parallel write	1276	92.2	2.5	.7	1.2	1.1	1.1	.8	.4
control file sequential read	5996	100.0						.0
db file async I/O submit	412	60.4	29.4	7.3	.2	.7	.7	.7	.5
db file scattered read	1				100.0
db file sequential read	212	30.2	2.4	7.5	28.8	29.2	1.9
direct path read	2277	99.3	.4	.0	.1	.2
direct path sync	1		100.0
direct path write	2	100.0
enq: KO - fast object checkpoint	4	50.0	25.0	25.0
latch: cache buffers chains	27	77.8	7.4	3.7	11.1
latch: shared pool	3	100.0
log file parallel write	2376	97.6	.2	.4	.5	.7	.1	.4	.0
log file sync	654	96.3	.2	.5	1.4	.6	.2	.9
os thread startup	142						97.9	2.1
DIAG idle wait	7249							100.0	.0
SQL*Net message from client	178.2K	90.4	3.1	.8	1.2	1.6	.2	1.4	1.2
Space Manager: slave idle wait	726	.3							99.7
Streams AQ: qmn coordinator idle wait	258	49.2			.4			.4	50.0
Streams AQ: qmn slave idle wait	132	2.3							97.7
class slave wait	20	95.0	5.0
dispatcher timer	60								100.0
jobq slave wait	7973	.0					.0	99.9
pmon timer	1297	6.7		.1	.1			.1	93.1
rdbms ipc message	16.5K	.4	.4	.8	.4	1.6	.8	24.0	71.7
shared server idle wait	120								100.0
smon timer	12								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
control file parallel write	15	98.8	.2	.2	.1		.4	.4
control file sequential read	1	100.0			.0
db file async I/O submit	4	98.8	.2	.2			.2	.2	.2
log file parallel write	11	99.5	.0	.1		.1	.2	.0
log file sync	6	99.1	.2	.2		.2	.5
os thread startup	3	97.9	2.1

Back to Wait Events Statistics

Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

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

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

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

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

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
db file async I/O submit	1	99.8	.2

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	346	309	260	48,788
SYS$BACKGROUND	0	0	0	19
mycar	0	0	0	0
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	2471	1	30	0	189603	1
SYS$BACKGROUND	225	1	142	4	0	0
mycar	0	0	0	0	0	0

Back to Wait Events Statistics

Back to Top

SQL Statistics

SQL ordered by Elapsed Time

SQL ordered by CPU Time

SQL ordered by User I/O Wait Time

SQL ordered by Gets

SQL ordered by Reads

SQL ordered by Physical Reads (UnOptimized)

SQL ordered by Executions

SQL ordered by Parse Calls

SQL ordered by Sharable Memory

SQL ordered by Version Count

Complete List of SQL Text

Back to Top

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.

% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

%Total - Elapsed Time as a percentage of Total DB time

%CPU - CPU Time as a percentage of Elapsed Time

%IO - User I/O Time as a percentage of Elapsed Time

Captured SQL account for 88.4% of Total DB Time (s): 346

Captured PL/SQL account for 0.6% of Total DB Time (s): 346

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Text
152.14	692	0.22	43.93	96.94	0.01	5spk48gcmhf2g	SELECT * FROM COUNTRY_CODE C J...
23.03	3,217	0.01	6.65	82.44	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
19.54	560	0.03	5.64	89.19	0.00	dx9uj64072dw7	select * from SYS_PRODUCT_BURN...
16.88	6	2.81	4.87	99.52	0.00	5a8j7mudwjb04	SELECT COUNT(*) AS c from ( se...
15.43	1,330	0.01	4.46	77.83	0.00	f6j95rdnz0mmw	select t.* from sys_product t ...
13.09	30	0.44	3.78	98.46	0.51	9kyafghcc1xh6	select distinct temp.SOFT_ID, ...
13.03	1,018	0.01	3.76	89.65	0.00	ch65xaabg3hj1	select * from ( select p.*, pt...
10.57	1,018	0.01	3.05	85.64	0.00	27jr1g1s603q4	SELECT COUNT(*) AS c from SYS_...
5.31	63	0.08	1.53	97.68	0.00	1dv841hap05xc	SELECT COUNT(*) AS c from (sel...
5.29	63	0.08	1.53	96.73	0.00	6zzzr28dtrtpd	select * from ( select us.FREE...
4.96	59	0.08	1.43	98.13	0.00	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
3.82	4,213	0.00	1.10	56.52	0.00	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...

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 90.6% of Total CPU Time (s): 309

Captured PL/SQL account for 0.7% of Total CPU Time (s): 309

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
147.49	692	0.21	47.77	152.14	96.94	0.01	5spk48gcmhf2g	SELECT * FROM COUNTRY_CODE C J...
18.99	3,217	0.01	6.15	23.03	82.44	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
17.43	560	0.03	5.64	19.54	89.19	0.00	dx9uj64072dw7	select * from SYS_PRODUCT_BURN...
16.80	6	2.80	5.44	16.88	99.52	0.00	5a8j7mudwjb04	SELECT COUNT(*) AS c from ( se...
12.89	30	0.43	4.17	13.09	98.46	0.51	9kyafghcc1xh6	select distinct temp.SOFT_ID, ...
12.01	1,330	0.01	3.89	15.43	77.83	0.00	f6j95rdnz0mmw	select t.* from sys_product t ...
11.68	1,018	0.01	3.78	13.03	89.65	0.00	ch65xaabg3hj1	select * from ( select p.*, pt...
9.05	1,018	0.01	2.93	10.57	85.64	0.00	27jr1g1s603q4	SELECT COUNT(*) AS c from SYS_...
5.18	63	0.08	1.68	5.31	97.68	0.00	1dv841hap05xc	SELECT COUNT(*) AS c from (sel...
5.11	63	0.08	1.66	5.29	96.73	0.00	6zzzr28dtrtpd	select * from ( select us.FREE...
4.87	59	0.08	1.58	4.96	98.13	0.00	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
3.13	39	0.08	1.01	3.23	96.88	0.00	6u4dt8af4b0x1	select * from ( select us.FREE...

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

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
0.60	5	0.12	31.01	1.97	97.70	30.71	asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSIO...
0.30	509	0.00	15.35	0.34	4.65	86.85	dnx1ugz1qwd2p	insert into OPERATE_LOG (LOG_I...
0.07	6,872	0.00	3.43	0.54	46.40	12.31	5nggumnh49yzc	select * from SYS_PRODUCT wher...
0.07	30	0.00	3.42	13.09	98.46	0.51	9kyafghcc1xh6	select distinct temp.SOFT_ID, ...
0.05	8	0.01	2.71	0.06	0.00	95.85	dcc8w4dsw3cc8	update SYS_PRODUCT set USER_ID...
0.05	264	0.00	2.36	0.07	11.18	64.12	anz2k7s8r4a62	insert into DIAG_USER_SOFT_CEN...
0.04	467	0.00	2.26	0.11	7.07	38.84	59ygsb7wnbc69	insert into DIAG_DOWNLOAD_RECO...
0.03	61	0.00	1.49	1.93	100.40	1.50	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
0.01	57	0.00	0.53	0.29	59.98	3.52	3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_...
0.01	692	0.00	0.42	152.14	96.94	0.01	5spk48gcmhf2g	SELECT * FROM COUNTRY_CODE C J...

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: 48,806,874

Captured SQL account for 93.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
21,209,578	560	37,874.25	43.46	19.54	89.19	0.00	dx9uj64072dw7	select * from SYS_PRODUCT_BURN...
4,844,397	30	161,479.90	9.93	13.09	98.46	0.51	9kyafghcc1xh6	select distinct temp.SOFT_ID, ...
4,571,357	3,217	1,421.00	9.37	23.03	82.44	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
2,857,528	6	476,254.67	5.85	16.88	99.52	0.00	5a8j7mudwjb04	SELECT COUNT(*) AS c from ( se...
2,492,420	1,330	1,874.00	5.11	15.43	77.83	0.00	f6j95rdnz0mmw	select t.* from sys_product t ...
1,911,248	1,018	1,877.45	3.92	13.03	89.65	0.00	ch65xaabg3hj1	select * from ( select p.*, pt...
1,905,858	1,018	1,872.16	3.90	10.57	85.64	0.00	27jr1g1s603q4	SELECT COUNT(*) AS c from SYS_...
779,074	557	1,398.70	1.60	2.58	41.51	0.00	83trawx9dw96s	select decode(ld.DISPLAY_NAME,...
654,085	63	10,382.30	1.34	5.31	97.68	0.00	1dv841hap05xc	SELECT COUNT(*) AS c from (sel...
654,085	63	10,382.30	1.34	5.29	96.73	0.00	6zzzr28dtrtpd	select * from ( select us.FREE...
614,685	59	10,418.39	1.26	4.96	98.13	0.00	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
565,141	629	898.48	1.16	2.66	37.26	0.00	3jdq13ju0b2z9	select v.* from DIAG_SOFT_VERS...

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: 259,964

Captured SQL account for 99.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
259,585	5	51,917.00	99.85	1.97	97.70	30.71	asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSIO...
32	509	0.06	0.01	0.34	4.65	86.85	dnx1ugz1qwd2p	insert into OPERATE_LOG (LOG_I...
10	467	0.02	0.00	0.11	7.07	38.84	59ygsb7wnbc69	insert into DIAG_DOWNLOAD_RECO...
8	6,872	0.00	0.00	0.54	46.40	12.31	5nggumnh49yzc	select * from SYS_PRODUCT wher...
8	8	1.00	0.00	0.06	0.00	95.85	dcc8w4dsw3cc8	update SYS_PRODUCT set USER_ID...
7	30	0.23	0.00	13.09	98.46	0.51	9kyafghcc1xh6	select distinct temp.SOFT_ID, ...
6	264	0.02	0.00	0.07	11.18	64.12	anz2k7s8r4a62	insert into DIAG_USER_SOFT_CEN...
1	692	0.00	0.00	152.14	96.94	0.01	5spk48gcmhf2g	SELECT * FROM COUNTRY_CODE C J...
1	317	0.00	0.00	0.03	13.31	25.33	c00br6fharcvs	select c.* from diag_user_soft...
0	3,217	0.00	0.00	23.03	82.44	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...

Back to SQL Statistics

Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs

%Opt - Optimized Reads as percentage of SQL Read Requests

%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs

Total Physical Read Requests: 2,490

Captured SQL account for 86.4% of Total

Total UnOptimized Read Requests: 2,490

Captured SQL account for 86.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	%Opt	%Total	SQL Id	SQL Text
2,115	2,115	5	423.00	0.00	84.94	asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSIO...
20	20	2	10.00	0.00	0.80	ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME...
12	12	57	0.21	0.00	0.48	3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_...
12	12	61	0.20	0.00	0.48	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
8	8	6,872	0.00	0.00	0.32	5nggumnh49yzc	select * from SYS_PRODUCT wher...
7	7	30	0.23	0.00	0.28	9kyafghcc1xh6	select distinct temp.SOFT_ID, ...
1	1	692	0.00	0.00	0.04	5spk48gcmhf2g	SELECT * FROM COUNTRY_CODE C J...
1	1	317	0.00	0.00	0.04	c00br6fharcvs	select c.* from diag_user_soft...
0	0	3,217	0.00		0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
0	0	1,330	0.00		0.00	12gmchtj8pp10	select usd.*, s.soft_name as S...

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: 77,210

Captured SQL account for 86.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
24,759	24,760	1.00	1.24	27.33	0.00	520mkxqpf15q8	select 1 from dual
6,872	6,871	1.00	0.54	46.40	12.31	5nggumnh49yzc	select * from SYS_PRODUCT wher...
4,407	4,407	1.00	0.28	44.11	0.00	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
4,213	39,494	9.37	3.82	56.52	0.00	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
3,283	4,824	1.47	0.19	106.00	0.00	cm5vu20fhtnq1	select /*+ connect_by_filterin...
3,217	88,005	27.36	23.03	82.44	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
2,211	615	0.28	0.45	39.35	0.00	5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_...
1,330	0	0.00	0.20	24.17	0.00	12gmchtj8pp10	select usd.*, s.soft_name as S...
1,330	1,077	0.81	15.43	77.83	0.00	f6j95rdnz0mmw	select t.* from sys_product t ...
1,067	1,067	1.00	0.06	6.97	0.00	a6j566u48p8nf	select * from SYS_PDT_TYPE whe...
1,041	0	0.00	0.09	14.10	0.00	drvvh1sx3r1my	select l.LAN_NAME, d.* from SY...
1,018	1,018	1.00	10.57	85.64	0.00	27jr1g1s603q4	SELECT COUNT(*) AS c from SYS_...
1,018	909	0.89	13.03	89.65	0.00	ch65xaabg3hj1	select * from ( select p.*, pt...
919	919	1.00	0.06	108.23	0.00	1qp4my7430ph5	select * from DIAG_SOFT_VERSIO...

Back to SQL Statistics

Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 73,086

Captured SQL account for 89.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
24,759	24,759	33.88	520mkxqpf15q8	select 1 from dual
6,872	6,872	9.40	5nggumnh49yzc	select * from SYS_PRODUCT wher...
4,407	4,407	6.03	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
4,213	4,213	5.76	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
3,283	3,283	4.49	cm5vu20fhtnq1	select /*+ connect_by_filterin...
3,217	3,217	4.40	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
2,210	2,211	3.02	5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_...
1,330	1,330	1.82	12gmchtj8pp10	select usd.*, s.soft_name as S...
1,330	1,330	1.82	f6j95rdnz0mmw	select t.* from sys_product t ...
1,067	1,067	1.46	a6j566u48p8nf	select * from SYS_PDT_TYPE whe...
1,041	1,041	1.42	drvvh1sx3r1my	select l.LAN_NAME, d.* from SY...
1,018	1,018	1.39	27jr1g1s603q4	SELECT COUNT(*) AS c from SYS_...
1,018	1,018	1.39	ch65xaabg3hj1	select * from ( select p.*, pt...
919	919	1.26	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 Text
3,045,266	2	0.23	ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME...
2,144,114	1	0.16	6wm3n4d7bnddg	SELECT source, (case when tim...
1,432,400	10	0.11	bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(...
1,357,966	8	0.10	dcc8w4dsw3cc8	update SYS_PRODUCT set USER_ID...

Back to SQL Statistics

Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
107	1	5s34t44u10q4g		SELECT a.name task_name, nvl(e...
102	1	c8gnrhxma4tas		SELECT owner#, property FROM s...
100	2	69k5bhm12sz98		SELECT dbin.instance_number, d...
91	1	gdn3ysuyssf82		SELECT advisor_id FROM sys.wri...
80	130	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
75	150	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
73	137	fsbqktj5vw6n9		select next_run_date, obj#, ru...
72	160	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
72	2	39ax31acw29z6	Oracle Enterprise Manager.current metric purge	WITH MET AS (SELECT DISTINCT M...
67	1	8p9z2ztb272bm		SELECT sx.instance_number, sx...
67	6	fcb5u7n0r523m		SELECT NVL(AVG((VALUE*1000.0)/...
67	6	fcb5u7n0r523m		SELECT NVL(AVG((VALUE*1000.0)/...
65	248	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...
65	10	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
63	1	6wm3n4d7bnddg		SELECT source, (case when tim...
63	143	davq1msn9b8kd		UPDATE MGMT_POLICY_ASSOC_EVAL_...
57	67	47a50dvdgnxc2		update sys.job$ set failures=0...
57	6	cabqn4dp09qck		SELECT TASK_CLASS, ROUND(NVL(S...
52	1	aktbxfjwnzgmu		update WRM$_DATABASE_INSTANCE ...
51	83	9p5tvdmjymwx7		UPDATE MGMT_POLICY_ASSOC_EVAL_...
51	26	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
45	2	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
41	6	5a8j7mudwjb04		SELECT COUNT(*) AS c from ( se...
41	6	5a8j7mudwjb04		SELECT COUNT(*) AS c from ( se...
41	217	5j0q2df7hm1k2		INSERT INTO MGMT_METRICS_RAW (...
39	2	cpqs5k8jpd9kz	Oracle Enterprise Manager.rollup	SELECT MT.TARGET_GUID, LAST_LO...
34	629	3jdq13ju0b2z9		select v.* from DIAG_SOFT_VERS...
32	1	5ms1dhxbadq64		update wrm$_snapshot set statu...
29	30	9kyafghcc1xh6		select distinct temp.SOFT_ID, ...
29	30	9kyafghcc1xh6		select distinct temp.SOFT_ID, ...
24	8	dcc8w4dsw3cc8		update SYS_PRODUCT set USER_ID...

Back to SQL Statistics

Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0ay7wjuhgzj9k	select d.* from diag_soft_version_detail d left join diag_soft_version v on v.version_id = d.version_id where v.soft_id = :1 order by d.upload_time desc
12gmchtj8pp10	select usd.*, s.soft_name as SOFT_NAME, su.cc as cc, decode(mu.user_name, null, '鏈?煡', mu.user_name) as LAST_UPD_USER_NAME from USER_DOWN_SOFT_LIMITS usd join SYS_USER su on su.user_id = usd.user_id left join sys_manager_user mu on mu.user_id = usd.last_upd_user_id join DIAG_SOFT s on usd.soft_id = s.soft_id where usd.USER_ID = :1 and usd.IS_OPEN_FLAG = :2 and usd.SOFT_TYPE = :3 order by usd.CREATE_TIME desc
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1dv841hap05xc	SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID AND sd.LAN_ID = :1 ) join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID where exists( select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') AND (v.VALID_FLAG = :2) AND (d.CHECK_STATE = :3) ) AND (s.VALID_FLAG = :4) AND (us.SERIAL_NO = :5) AND (s.pdt_type_id = :6) order by upper(s.SOFT_NAME) asc
1qp4my7430ph5	select * from DIAG_SOFT_VERSION where VERSION_ID = :1
27jr1g1s603q4	SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_ID left join sys_vender f on p.filiale_id = f.VENDER_ID where 1=1 AND p.PRODUCT_PART like '%0%' AND p.PDT_STATE like '%1%' AND USER_ID = :1 order by UPDATE_TIME desc
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
39ax31acw29z6	WITH MET AS (SELECT DISTINCT METRIC_GUID METRIC_GUID FROM MGMT_METRICS WHERE KEYS_FROM_MULT_COLLS = 0 ), CM AS (SELECT TARGET_GUID, METRIC_GUID, MAX(COLLECTION_TIMESTAMP) MAX_TIME FROM MGMT_CURRENT_METRICS GROUP BY TARGET_GUID, METRIC_GUID HAVING MAX(COLLECTION_TIMESTAMP) != MIN(COLLECTION_TIMESTAMP)) SELECT CM.TARGET_GUID TARGET_GUID, CM.METRIC_GUID METRIC_GUID, CM. MAX_TIME MAX_TIME FROM MET, CM WHERE CM.METRIC_GUID = MET.METRIC_GUID
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3jdq13ju0b2z9	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=2) 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 = :1 AND to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(:2, 'yyyy-mm-dd') order by v.VERSION_NO desc
47a50dvdgnxc2	update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
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)
5a8j7mudwjb04	SELECT COUNT() AS c from ( select distinct m. from (select s.soft_id, t1.version_no, t1.creater_time, t3.soft_name as soft_desc, t2.remark, t2.version_detail_id, nvl(buy_price, default_bprice) as price, t4.CUR_ID, t4.cur_code from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, diag_soft_desc t3, sys_currency_unit t4 where s.pdt_type_id = p.pdt_type_id and s.soft_id = pr.soft_id and v.cur_id = pr.cur_id and p.vender_id = v.vender_id and s.soft_id = t1.soft_id and t1.version_id = t2.version_id and s.soft_id = t3.soft_id and t3.lan_id = :1 and pr.cur_id = t4.cur_id and upper(s.soft_name) not like '%ZY' and t3.soft_name not like '%涓撶敤_' and upper(t3.soft_name) not like '%CUSTOMIZED_' and s.soft_id not in(select ds.soft_id from diag_soft ds where ds.pdt_type_id in (121, 142, 143 ) and ds.soft_name in ('WLGY', 'LAIYANG''DFG', 'HIGER', 'QIRUIZYDISPLAY', 'KINGLONG', 'UFO', 'DFACLX', 'YUCHAI', 'DFAC_CHAOCHAI', 'RIICH', 'ZZMAZDA', 'HQE', 'DFBF', 'DFAC_SHANGYONG', 'QUANCHAI', 'JMMOTOR', 'DIAS', 'WXDIESEL', 'BJGJ', 'JAC', 'YQHT', 'TJYQZYMID', 'CHDAIHATSU', 'MYXINCHEN', 'DETC', 'ZHONGXINGZHY', 'WABCOABS', 'HANGTIANMIT', 'SPARK', 'DFCNG', 'NJXYT', 'ZHONGHUAO3', 'ZHONGHUAEN', 'CHANGCHENGZY_CN', 'NJYWK', 'GREATWALL', 'QIRUI', 'LIUWEI', 'KARRY', 'RELY')) and upper(s.soft_name) not in ('KARRY', 'ZHONGXINGZHY', 'WLGY', 'LAIYANG', 'DF G' , 'HIGER', 'QIRUIZYDISPLAY', 'KINGLONG') and s.soft_id not in (select soft_id from diag_user_soft_center where user_id = :2 and serial_no = :3) and s.soft_id not in (select uz.soft_id from user_order u, order_detail_info uz where u.order_id = uz.order_id and u.user_id = :4 and u.order_status in (0, 1, 3) and u.serial_no = :5) and p.serial_no = :6 and p.pdt_state = 1 and p.user_id = :7 and t2.lan_id = :8 and s.VALID_FLAG = 1 and t1.VALID_FLAG = 1 and t2.CHECK_STATE = 2 and pr.STATE = 2)m, (select r.soft_id, max(version_no)as version_no, lan_id from diag_soft_version r , diag_soft_version_detail rr, diag_soft s where r.version_id = rr.version_id and lan_id = :9 and s.soft_id = r.soft_id and s.valid_flag = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2 group by r.soft_id, lan_id )n where m.soft_id = n.soft_id and m.version_no = n.version_no order by NLSSORT(m.soft_desc, 'NLS_SORT=SCHINESE_PINYIN_M') )
5j0q2df7hm1k2	INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 )
5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2) and LAN_ID = :3
5ms1dhxbadq64	update wrm$_snapshot set status = 0, flush_elapsed = greatest((cast(SYSDATE as TIMESTAMP) - end_interval_time), interval '00.10' second) where snap_id = :snap_id and dbid = :dbid and instance_number = :instance_number
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
5spk48gcmhf2g	SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1) AND IP.End_Ip1 >= ip_to_number(:2)
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
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;
6u4dt8af4b0x1	select * from ( select us.FREE_END_TIME, vv.version_no MAX_VERSION_No, s.*, decode(sd.SOFT_NAME, null, s.SOFT_NAME, sd.SOFT_NAME) as softDesc, decode(sd.REMARK, null, s.REMARK, sd.REMARK) as remarkDesc from (select max(version_no) version_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID AND sd.LAN_ID = :1 ) join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID where exists( select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') AND (v.VALID_FLAG = :2) AND (d.CHECK_STATE = :3) ) AND (s.VALID_FLAG = :4) AND (us.SERIAL_NO = :5) AND (s.pdt_type_id = :6) order by s.UPDATE_TIME desc ) where rownum <= 10
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
6zzzr28dtrtpd	select * from ( select us.FREE_END_TIME, vv.version_no MAX_VERSION_No, s.*, decode(sd.SOFT_NAME, null, s.SOFT_NAME, sd.SOFT_NAME) as softDesc, decode(sd.REMARK, null, s.REMARK, sd.REMARK) as remarkDesc from (select max(version_no) version_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID AND sd.LAN_ID = :1 ) join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID where exists( select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') AND (v.VALID_FLAG = :2) AND (d.CHECK_STATE = :3) ) AND (s.VALID_FLAG = :4) AND (us.SERIAL_NO = :5) AND (s.pdt_type_id = :6) order by upper(s.SOFT_NAME) asc ) where rownum <= 10000
83trawx9dw96s	select decode(ld.DISPLAY_NAME, null, l.LAN_NAME, ld.DISPLAY_NAME) LAN_NAME, d.* from DIAG_SOFT_VERSION_DETAIL d left join sys_lan l on d.LAN_ID=l.LAN_ID left join SYS_LAN_DISPLAY ld on ld.LAN_ID=l.LAN_ID AND (ld.DISP_LAN_ID = :1) WHERE (d.VERSION_ID = :2) AND (d.CHECK_STATE = :3)
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
9kyafghcc1xh6	select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK, temp.FILE_SIZE, to_char(temp.UPLOAD_TIME, 'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHICLE_TYPE_ID, null, 1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APPLICABLE_AREA_ID, null, 1, temp.SOFT_APPLICABLE_AREA_ID) as SOFT_APPLICABLE_AREA, temp.free_end_time from ( select s.SOFT_ID, s.SOFT_NAME, v.VERSION_NO, d.LAN_ID, decode(sd.SOFT_NAME, null, s.SOFT_NAME, sd.SOFT_NAME) as SOFT_DESC, d.VERSION_DETAIL_ID, d.REMARK, d.FILE_SIZE, d.UPLOAD_TIME, us.free_end_time, s.VEHICLE_TYPE_ID, s.SOFT_APPLICABLE_AREA_ID, ROW_NUMBER() OVER(PARTITION BY v.SOFT_ID ORDER BY v.VERSION_NO DESC) RN from DIAG_USER_SOFT_CENTER us left join sys_user su on us.user_id=su.user_id left join DIAG_SOFT s on s.soft_id=us.soft_id left join DIAG_SOFT_VERSION v on v.soft_id=s.soft_id left join DIAG_SOFT_VERSION_DETAIL d on d.version_id=v.version_id join sys_product sp on (sp.serial_no=us.serial_no and sp.pdt_type_id=s.pdt_type_id) left join DIAG_SOFT_DESC sd on (sd.soft_id=s.soft_id AND sd.LAN_ID = :1 ) where 1=1 AND (( not exists (select 'X' from DIAG_SOFT_ VERSION_DETAIL d2 where d2.LAN_ID=:2 and d2.CHECK_STATE=2 and d2.VERSION_Id=v.VERSION_Id ) and d.LAN_ID=:3 ) or (d.LAN_ID=:4)) and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') and d.CHECK_STATE=2 and v.VALID_FLAG=1 and s.VALID_FLAG=1 AND us.SERIAL_NO=:5 AND su.cc=:6 ) temp where temp.RN=1 order by temp.SOFT_ID desc, temp.VERSION_DETAIL_ID
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
a6j566u48p8nf	select * from SYS_PDT_TYPE where PDT_TYPE_ID = :1
ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
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 )
anz2k7s8r4a62	insert into DIAG_USER_SOFT_CENTER (USER_SOFT_ID, CREATE_TIME, FREE_END_TIME, FREE_START_TIME, SOFT_ID, SOFT_TYPE, UPDATE_TIME, USER_ID, SERIAL_NO, SOFT_CONF_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSION_ID, r.SOFT_ID, r.VERSION_NO, r.VERSION_DETAIL_ID, r.USER_ID, r.LAN_ID, r.DOWNLOAD_PERSON, r.DOWNLOAD_TIME, r.SOFT_TYPE, r.DOWNLOAD_IP, r.SERIAL_NO, l.LAN_NAME as LAN_NAME, (select soft_name from diag_soft where soft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_LAN l on r.serial_no =:1 and r.soft_type = 2 and r.lan_id = l.lan_id order by r.DOWNLOAD_TIME desc
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
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
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
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
cabqn4dp09qck	SELECT TASK_CLASS, ROUND(NVL(SUM(THROUGHPUT), 0), 2), NVL(SUM(TOTAL_VALUE), 0), NVL(SUM(TOTAL_DURATION), 0) FROM (SELECT CLIENT_DATA WORKER_ID, ACTION TASK_CLASS, NVL(AVG(VALUE1000/ DECODE(DURATION, 0, 1000, DURATION)), 0) THROUGHPUT, SUM(VALUE) TOTAL_VALUE, SUM(DURATION)/1000 TOTAL_DURATION, COUNT() RECORDS FROM MGMT_SYSTEM_PERFORMANCE_LOG LOG WHERE LOG.JOB_NAME = :B3 AND LOG.MODULE = :B2 AND LOG.TIME > (SYSDATE-:B1 /1440) AND LOG.IS_TOTAL = 'Y' GROUP BY CLIENT_DATA, ACTION ) GROUP BY TASK_CLASS
ch65xaabg3hj1	select * from ( select p.*, pt.PDT_TYPE, sc.name, v.VENDER_NAME, f.VENDER_NAME as FILIAL_ENAME from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_ID left join sys_vender f on p.filiale_id = f.VENDER_ID where 1=1 AND p.PRODUCT_PART like '%0%' AND p.PDT_STATE like '%1%' AND USER_ID = :1 order by UPDATE_TIME desc ) where rownum <= 2147483647
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cpqs5k8jpd9kz	SELECT MT.TARGET_GUID, LAST_LOAD_TIME FROM MGMT_TARGETS MT, MGMT_TARGET_ROLLUP_TIMES MTRT WHERE MTRT.ROLLUP_TABLE_NAME = :B1 AND MT.TARGET_GUID = MTRT.TARGET_GUID AND (TRUNC(MT.LAST_LOAD_TIME, 'HH24') > MTRT.ROLLUP_TIMESTAMP)
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
dcc8w4dsw3cc8	update SYS_PRODUCT set USER_ID = :1, REG_TIME = :2, UPGRADEFLAG = :3, PDT_STATE = :4, SOFT_CONF_ID = :5, ORIGIN_CONF_ID = :6, FILIALE_ID = :7, SERIAL_NO = :8, PDT_TYPE_ID = :9, COUNTRY_ID = :10, DOWNLOAD_FLAG = :11, DOWNLOAD_AREA_ID = :12, BLUETOOLTH_NAME = :13, PRODUCT_USE_PWD = :14, BOOKER_ID = :15, PRODUCT_NO = :16, REMARK = :17, IS_INNER_PRODUCT = :18 , IS_PASSWORD_FLAG = :19 , PASSWORD = :20 , vender_id = :21, PRODUCT_PART = :22, ORDER_NO = :23, LONGITUDE = :24, LATITUDE = :25, CREATE_TIME = :26, UPDATE_TIME = :27, SALE_TIME = :28 , CUSTOMER_NUMBER = :29, IS_DBSCAR_PRO=:30 where PRODUCT_ID = :31
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
dx9uj64072dw7	select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
f6j95rdnz0mmw	select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
fcb5u7n0r523m	SELECT NVL(AVG((VALUE1000.0)/DURATION), 0), NVL((((SUM(DURATION)/(601000))/60)*100), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 = B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.IS_TOTAL='Y' AND A.DURATION > 0
fsbqktj5vw6n9	select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1

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	2	0.00	0.00
CCursor + sql area evicted	3	0.00	0.00
CPU used by this session	30,291	8.35	32.33
CPU used when call started	30,019	8.28	32.04
CR blocks created	99	0.03	0.11
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	429,671	118.51	458.56
DBWR checkpoint buffers written	1,788	0.49	1.91
DBWR checkpoints	4	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	18	0.00	0.02
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	103	0.03	0.11
DBWR undo block writes	312	0.09	0.33
HSC Heap Segment Block Changes	3,485	0.96	3.72
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	113	0.03	0.12
Heap Segment Array Updates	89	0.02	0.09
IMU CR rollbacks	120	0.03	0.13
IMU Flushes	246	0.07	0.26
IMU Redo allocation size	831,404	229.32	887.30
IMU commits	751	0.21	0.80
IMU contention	1	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	3,154,824	870.16	3,366.94
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	2,277	0.63	2.43
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	119	0.03	0.13
RowCR hits	119	0.03	0.13
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	178,246	49.16	190.23
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	143	0.04	0.15
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	15,349	4.23	16.38
branch node splits	0	0.00	0.00
buffer is not pinned count	21,715,338	5,989.51	23,175.39
buffer is pinned count	70,145,343	19,347.44	74,861.63
bytes received via SQL*Net from client	22,155,658	6,110.96	23,645.31
bytes sent via SQL*Net to client	74,170,313	20,457.60	79,157.22
calls to get snapshot scn: kcmgss	82,111	22.65	87.63
calls to kcmgas	1,921	0.53	2.05
calls to kcmgcs	211,004	58.20	225.19
cell physical IO interconnect bytes	2,289,666,560	631,534.24	2,443,614.26
change write time	13	0.00	0.01
cleanout - number of ktugct calls	81	0.02	0.09
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	2	0.00	0.00
cluster key scan block gets	2,227	0.61	2.38
cluster key scans	1,980	0.55	2.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	3	0.00	0.00
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	4,223	1.16	4.51
commit cleanouts successfully completed	4,220	1.16	4.50
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	150	0.04	0.16
concurrency wait time	399	0.11	0.43
consistent changes	221	0.06	0.24
consistent gets	48,783,542	13,455.44	52,063.55
consistent gets - examination	379,835	104.77	405.37
consistent gets direct	259,748	71.64	277.21
consistent gets from cache	48,523,794	13,383.80	51,786.33
consistent gets from cache (fastpath)	48,117,213	13,271.66	51,352.42
cursor authentications	37	0.01	0.04
data blocks consistent reads - undo records applied	210	0.06	0.22
db block changes	20,648	5.70	22.04
db block gets	23,332	6.44	24.90
db block gets direct	2	0.00	0.00
db block gets from cache	23,330	6.43	24.90
db block gets from cache (fastpath)	7,965	2.20	8.50
deferred (CURRENT) block cleanout applications	2,370	0.65	2.53
dirty buffers inspected	0	0.00	0.00
enqueue conversions	750	0.21	0.80
enqueue deadlocks	0	0.00	0.00
enqueue releases	35,201	9.71	37.57
enqueue requests	35,201	9.71	37.57
enqueue timeouts	0	0.00	0.00
enqueue waits	4	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	77,210	21.30	82.40
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	5,854,543	1,614.80	6,248.18
free buffer inspected	993	0.27	1.06
free buffer requested	917	0.25	0.98
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	41	0.01	0.04
hot buffers moved to head of LRU	282	0.08	0.30
immediate (CR) block cleanout applications	2	0.00	0.00
immediate (CURRENT) block cleanout applications	734	0.20	0.78
index crx upgrade (positioned)	3	0.00	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	32	0.01	0.03
index fetch by key	700,342	193.17	747.43
index scans kdiixs1	14,274	3.94	15.23
leaf node 90-10 splits	27	0.01	0.03
leaf node splits	34	0.01	0.04
lob reads	198	0.05	0.21
lob writes	8	0.00	0.01
lob writes unaligned	8	0.00	0.01
logons cumulative	211	0.06	0.23
max cf enq hold time	0	0.00	0.00
messages received	1,610	0.44	1.72
messages sent	1,610	0.44	1.72
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	20	0.01	0.02
no work - consistent read gets	48,186,032	13,290.64	51,425.86
non-idle wait count	205,191	56.60	218.99
non-idle wait time	3,643	1.00	3.89
opened cursors cumulative	75,919	20.94	81.02
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	48	0.01	0.05
parse count (total)	73,086	20.16	78.00
parse time cpu	68	0.02	0.07
parse time elapsed	124	0.03	0.13
physical read IO requests	2,490	0.69	2.66
physical read bytes	2,129,625,088	587,391.72	2,272,812.26
physical read total IO requests	8,494	2.34	9.07
physical read total bytes	2,228,256,768	614,596.24	2,378,075.53
physical read total multi block requests	2,035	0.56	2.17
physical reads	259,964	71.70	277.44
physical reads cache	216	0.06	0.23
physical reads cache prefetch	4	0.00	0.00
physical reads direct	259,748	71.64	277.21
physical reads direct (lob)	162	0.04	0.17
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	1,170	0.32	1.25
physical write bytes	14,663,680	4,044.53	15,649.61
physical write total IO requests	4,911	1.35	5.24
physical write total bytes	61,409,792	16,938.01	65,538.73
physical write total multi block requests	18	0.00	0.02
physical writes	1,790	0.49	1.91
physical writes direct	2	0.00	0.00
physical writes direct (lob)	2	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	1,788	0.49	1.91
physical writes non checkpoint	527	0.15	0.56
pinned buffers inspected	0	0.00	0.00
pinned cursors current	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
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	0	0.00	0.00
recursive calls	99,372	27.41	106.05
recursive cpu usage	323	0.09	0.34
redo blocks checksummed by FG (exclusive)	5,141	1.42	5.49
redo blocks written	9,637	2.66	10.28
redo buffer allocation retries	0	0.00	0.00
redo entries	6,612	1.82	7.06
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	171	0.05	0.18
redo size	4,330,404	1,194.41	4,621.56
redo size for direct writes	16,456	4.54	17.56
redo subscn max counts	707	0.20	0.75
redo synch time	313	0.09	0.33
redo synch writes	654	0.18	0.70
redo wastage	366,144	100.99	390.76
redo write time	684	0.19	0.73
redo writes	1,188	0.33	1.27
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	99	0.03	0.11
root node splits	0	0.00	0.00
rows fetched via callback	134,672	37.15	143.73
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	3,104	0.86	3.31
session logical reads	48,806,874	13,461.88	52,088.45
shared hash latch upgrades - no wait	7,089	1.96	7.57
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	18,382	5.07	19.62
sorts (rows)	268,014	73.92	286.03
sql area evicted	46	0.01	0.05
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	250	0.07	0.27
table fetch by rowid	45,531,164	12,558.37	48,592.49
table fetch continued row	4,088	1.13	4.36
table scan blocks gotten	26,626,701	7,344.16	28,416.97
table scan rows gotten	1,500,973,142	413,997.37	1,601,892.36
table scans (direct read)	5	0.00	0.01
table scans (long tables)	5	0.00	0.01
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	51,302	14.15	54.75
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	10	0.00	0.01
total number of cf enq holders	256	0.07	0.27
total number of times SMON posted	0	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	1,426,780	393.53	1,522.71
user I/O wait time	192	0.05	0.20
user calls	243,019	67.03	259.36
user commits	937	0.26	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	15,801	4.36	16.86
write clones created in foreground	2	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,011,653,514,016	1,011,848,500,392
session pga memory	318,041,061,720	318,215,534,784
session pga memory max	356,905,174,648	357,101,274,592
session cursor cache count	9,353,101	9,357,505
session uga memory	561,251,604,026,608	561,547,967,409,120
opened cursors current	342	345
workarea memory allocated	1,724	1,724
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)
Direct Reads	2G	0.63	.559637	0M	0.00	0M	2277	0.03
Others	94M	1.66	.025927	40M	0.70	.011032	8557	3.30
DBWR	0M	0.00	0M	14M	0.32	.003861	412	10.81
LGWR	0M	0.00	0M	5M	0.33	.001379	1188	5.40
Buffer Cache Reads	1M	0.06	.000275	0M	0.00	0M	204	5.43
Direct Writes	0M	0.00	0M	0M	0.00	0M	2	0.00
TOTAL:	2.1G	2.34	.585840	59M	1.35	.016273	12.6K	3.19

Back to IO Stats

Back to Top

IOStat by Filetype summary

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

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

Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	2G	0.69	.560189	16M	0.32	.004413	2.54	0.01
Control File	94M	1.65	.025927	40M	0.70	.011032	0.04
Log File	0M	0.00	0M	5M	0.33	.001379
TOTAL:	2.1G	2.34	.586116	61M	1.35	.016824	0.21	0.01

Back to IO Stats

Back to Top

IOStat by Function/Filetype summary

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

Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	2G	0.63	.559637	0M	0.00	0M	0
Direct Reads (Data File)	2G	0.63	.559637	0M	0.00	0M	0
Others	94M	1.66	.025927	40M	0.70	.011032	6005	0.04
Others (Control File)	94M	1.65	.025927	40M	0.70	.011032	5996	0.04
Others (Data File)	0M	0.00	0M	0M	0.00	0M	9	0.11
DBWR	0M	0.00	0M	14M	0.32	.003861	0
DBWR (Data File)	0M	0.00	0M	14M	0.32	.003861	0
LGWR	0M	0.00	0M	5M	0.33	.001379	0
LGWR (Log File)	0M	0.00	0M	5M	0.33	.001379	0
Buffer Cache Reads	1M	0.06	.000275	0M	0.00	0M	204	5.43
Buffer Cache Reads (Data File)	1M	0.06	.000275	0M	0.00	0M	204	5.43
Direct Writes	0M	0.00	0M	0M	0.00	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.00	0M	0
TOTAL:	2.1G	2.34	.585840	59M	1.35	.016273	6209	0.21

Back to IO Stats

Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes
MYCAR	2,356	1	0.26	110.28	260
SYSAUX	127	0	3.86	1.03	585
UNDOTBS1	0	0	0.00	0.00	215
SYSTEM	6	0	6.67	1.00	67
PASSPORT	11	0	8.18	1.00	43

Back to IO Stats

Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes
MYCAR	/oracle/oradata/mycar/mycar.dbf	2,356	1	0.26	110.28	260
PASSPORT	/oracle/oradata/mycar/passport.dbf	11	0	8.18	1.00	43
SYSAUX	/oracle/oradata/mycar/sysaux01.dbf	127	0	3.86	1.03	585
SYSTEM	/oracle/oradata/mycar/system01.dbf	6	0	6.67	1.00	67
UNDOTBS1	/oracle/oradata/mycar/undotbs01.dbf	0	0			215

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	100,470	100	48,538,500	221	1,788	0	0	0

Back to Buffer Pool Statistics

Back to Top

Checkpoint Activity

Total Physical Writes: 1,790

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	1,770	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	335	1439	3064	663552	3064
E	0	14	370	1766	3508	663552	3508

Back to Advisory Statistics

Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics

Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed

ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	80	0.10	10	1.70	2,628,095	1	674347.00
D	160	0.20	20	1.01	1,570,868	1	27940.00
D	240	0.29	30	1.00	1,552,454	1	16681.00
D	320	0.39	39	1.00	1,551,065	1	15832.00
D	400	0.49	49	1.00	1,550,643	1	15574.00
D	480	0.59	59	1.00	1,550,331	1	15383.00
D	560	0.69	69	1.00	1,550,094	1	15239.00
D	640	0.78	79	1.00	1,549,846	1	15087.00
D	720	0.88	89	1.00	1,549,638	1	14960.00
D	800	0.98	99	1.00	1,549,469	1	14857.00
D	816	1.00	100	1.00	1,549,440	1	14839.00
D	880	1.08	108	1.00	1,549,331	1	14772.00
D	960	1.18	118	1.00	1,549,182	1	14681.00
D	1,040	1.27	128	1.00	1,549,090	1	14625.00
D	1,120	1.37	138	1.00	1,549,029	1	14587.00
D	1,200	1.47	148	1.00	1,548,980	1	14558.00
D	1,280	1.57	158	1.00	1,548,924	1	14523.00
D	1,360	1.67	167	1.00	1,548,164	1	14059.00
D	1,440	1.76	177	0.96	1,488,191	1	6542.00
D	1,520	1.86	187	0.95	1,474,634	1	6541.00
D	1,600	1.96	197	0.91	1,406,397	1	6537.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	2,168	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	12,879	12,879
64K	128K	544	544
128K	256K	100	100
256K	512K	2	2
512K	1024K	1,370	1,370
1M	2M	898	898
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	20,116,539.83	44,130,888.94	31.00	257,173	74,284,496,579
284	0.25	20,116,539.83	43,969,147.88	31.00	253,036	74,097,487,487
568	0.50	20,116,539.83	11,236,544.65	64.00	9	36,251,226,570
852	0.75	20,116,539.83	10,984,070.09	65.00	0	35,959,309,122
1,136	1.00	20,116,539.83	10,308,832.85	66.00	0	35,178,582,800
1,363	1.20	20,116,539.83	10,162,686.66	66.00	0	35,009,604,885
1,590	1.40	20,116,539.83	10,162,536.83	66.00	0	35,009,431,656
1,818	1.60	20,116,539.83	10,162,425.91	66.00	0	35,009,303,403
2,045	1.80	20,116,539.83	10,162,425.91	66.00	0	35,009,303,403
2,272	2.00	20,116,539.83	10,162,425.91	66.00	0	35,009,303,403
3,408	3.00	20,116,539.83	10,162,425.91	66.00	0	35,009,303,403
4,544	4.00	20,116,539.83	10,162,266.32	66.00	0	35,009,118,881
6,816	6.00	20,116,539.83	10,162,266.32	66.00	0	35,009,118,881
9,088	8.00	20,116,539.83	10,162,266.32	66.00	0	35,009,118,881

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	30	1,974	5,617,984	1.00	176,909	1.08	61,538
880	0.70	158	9,191	5,620,177	1.00	174,716	1.06	257,280
1,008	0.80	286	13,069	5,627,579	1.00	167,314	1.02	257,802
1,136	0.90	414	16,982	5,629,285	1.00	165,608	1.01	258,035
1,264	1.00	542	21,515	5,630,612	1.00	164,281	1.00	258,225
1,392	1.10	670	25,470	5,631,728	1.00	163,165	0.99	258,395
1,520	1.20	798	29,250	5,632,374	1.00	162,519	0.99	258,497
1,648	1.30	926	33,186	5,632,639	1.00	162,254	0.99	258,539
1,776	1.41	1,054	36,536	5,632,899	1.00	161,994	0.99	258,568
1,904	1.51	1,181	39,307	5,633,047	1.00	161,846	0.99	258,582
2,032	1.61	1,309	42,213	5,633,164	1.00	161,729	0.98	258,592
2,160	1.71	1,437	46,885	5,633,248	1.00	161,645	0.98	258,599
2,288	1.81	1,565	51,124	5,633,328	1.00	161,565	0.98	258,605
2,416	1.91	1,693	54,890	5,633,407	1.00	161,486	0.98	258,610
2,544	2.01	1,821	58,266	5,633,460	1.00	161,433	0.98	258,615

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	4,082,440	1,551,763,705
1,608	0.75	4,069,833	1,551,763,705
2,144	1.00	4,066,580	1,549,439,546
2,680	1.25	4,060,887	1,473,981,840
3,216	1.50	4,057,227	1,487,616,908
3,752	1.75	4,056,820	1,487,616,908
4,288	2.00	4,056,820	1,405,806,500

Back to Advisory Statistics

Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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

No data exists for this section of the report.

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)
KO-Multiple Object Checkpoint (fast object checkpoint)	36	36	0	4	0	2.50

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.09	1,176	833	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
14-Jun 08:00	13	184	833	2	240	0/0	0/0/0/0/0/0
14-Jun 07:50	12	144	707	3	240	0/0	0/0/0/0/0/0
14-Jun 07:40	19	226	826	4	240	0/0	0/0/0/0/0/0
14-Jun 07:30	19	112	223	4	240	0/0	0/0/0/0/0/0
14-Jun 07:20	12	251	821	2	240	0/0	0/0/0/0/0/0
14-Jun 07:10	12	259	216	2	240	0/0	0/0/0/0/0/0

Back to Undo Statistics

Back to Top

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Back to Top

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests

"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests

"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
ASM db client latch	2,400	0.00		0
ASM map operation hash table	1	0.00		0
ASM network state latch	61	0.00		0
AWR Alerted Metric Element list	30,291	0.00		0
Change Notification Hash table latch	1,202	0.00		0
Consistent RBA	1,188	0.00		0
DML lock allocation	6,190	0.00		0
Event Group Locks	143	0.00		0
FAL Queue	168	0.00		0
FOB s.o list latch	365	0.00		0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	1	0.00		0
In memory undo latch	10,193	0.00		1,798	0.00
JS Sh mem access	7	0.00		0
JS mem alloc latch	6	0.00		0
JS queue access latch	7	0.00		0
JS queue state obj latch	26,278	0.00		0
JS slv state obj latch	1,085,580	0.36	0.00	0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1	0.00		0
KJCT flow control latch	1	0.00		0
KMG MMAN ready and startup request latch	1,207	0.00		0
KTF sga latch	19	0.00		944	0.00
KWQS pqueue ctx latch	63	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	1	0.00		1,207	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	20	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	1,273	0.00		0
OS process allocation	2,056	0.00		0
OS process: request allocation	282	0.00		0
PL/SQL warning settings	390	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	4,020	0.00		0
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	121	0.00		1,196	0.00
SQL memory manager workarea list latch	99,798	0.00		0
Shared B-Tree	319	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	2,313	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	1,643	0.00		0
active service list	8,092	0.00		3,730	0.00
archive control	60	0.00		0
archive process latch	504	0.00		0
begin backup scn array	2	0.00		0
buffer pool	1	0.00		0
business card	1	0.00		0
cache buffer handles	714	0.00		0
cache buffers chains	96,778,564	0.07	0.00	833	0.00
cache buffers lru chain	2,314	0.00		2,677	0.00
cache table scan latch	1	0.00		1	0.00
call allocation	992	0.00		0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	334	0.00		0
channel operations parent latch	17,632	0.00		0
checkpoint queue latch	104,497	0.00		1,769	0.00
client/application info	1,700	0.00		0
compile environment latch	211	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	61	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	61	0.00		0
dml lock allocation	61	0.00		0
done queue latch	1	0.00		0
dummy allocation	421	0.00		0
enqueue hash chains	71,278	0.00		0
enqueues	60,974	0.02	0.00	0
fifth spare latch	1	0.00		0
file cache latch	198	0.00		0
flashback copy	1	0.00		0
gc element	1	0.00		0
gcs commit scn state	1	0.00		0
gcs partitioned table hash	1	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs resource freelist	1	0.00		0
gcs resource hash	1	0.00		0
gcs resource scan list	1	0.00		0
gcs shadows freelist	1	0.00		0
ges domain table	1	0.00		0
ges enqueue table freelist	1	0.00		0
ges group table	1	0.00		0
ges process hash list	1	0.00		0
ges process parent latch	1	0.00		0
ges resource hash list	1	0.00		0
ges resource scan list	1	0.00		0
ges resource table freelist	1	0.00		0
ges value block free list	1	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	34	0.00		3,086	0.00
hash table modification latch	92	0.00		0
heartbeat check	1	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	70	0.00		69	2.90
job_queue_processes free list latch	142	0.00		0
job_queue_processes parameter latch	856	0.00		0
k2q lock allocation	1	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kks stats	228	0.00		0
kokc descriptor allocation latch	518	0.00		0
ksfv messages	1	0.00		0
kss move lock	41	0.00		0
ksuosstats global area	244	0.00		0
ksv allocation latch	141	0.00		0
ksv class latch	81	0.00		0
ksv msg queue latch	1	0.00		0
ksz_so allocation latch	282	0.00		0
ktm global data	19	0.00		0
kwqbsn:qsga	129	0.00		0
lgwr LWN SCN	1,914	0.00		0
list of block allocation	237	0.00		0
loader state object freelist	326	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	13	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
managed standby latch	168	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	13	0.00		0
messages	35,254	0.12	0.00	0
mostly latch-free SCN	1,915	0.00		0
msg queue latch	1	0.00		0
multiblock read objects	2	0.00		0
name-service namespace bucket	1	0.00		0
ncodef allocation latch	61	0.00		0
object queue header heap	65	0.00		4	0.00
object queue header operation	7,192	0.00		0
object stats modification	1	0.00		0
parallel query alloc buffer	469	0.00		0
parallel query stats	1	0.00		0
parameter list	180	0.00		0
parameter table management	422	0.00		0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	1,024	0.00		684	0.00
process allocation	424	0.00		142	0.00
process group creation	282	0.00		0
process queue	1	0.00		0
process queue reference	1	0.00		0
qmn task queue latch	528	0.00		0
query server freelists	1	0.00		0
queued dump request	12	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	8,565	0.00		6,680	0.00
redo copy	1	0.00		6,680	0.19
redo writing	7,697	0.00		0
resmgr group change latch	406	0.00		0
resmgr:active threads	421	0.00		0
resmgr:actses change group	90	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	420	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	81	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	108,484	0.00		74	0.00
second spare latch	1	0.00		0
sequence cache	4,340	0.00		0
session allocation	71,862	0.00	0.00	23,955	0.00
session idle bit	509,781	0.00	0.00	0
session queue latch	1	0.00		0
session state list latch	478	0.00		0
session switching	762	0.00		0
session timer	1,298	0.00		0
shared pool	19,002	0.12	0.23	0
shared pool sim alloc	1	0.00		0
shared pool simulator	561	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	2,984,464	0.00	0.00	0
simulator lru latch	798	0.00		2,983,592	0.11
sort extent pool	97	0.00		0
space background state object latch	4	0.00		0
space background task latch	2,681	0.00		2,414	0.00
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	2	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	168	0.00		0
transaction allocation	801	0.00		0
undo global data	6,674	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		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	96,778,564	69,829	28	69,802
JS slv state obj latch	1,085,580	3,946	4	0
shared pool	19,002	22	5	19

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
cache buffers chains	kcbgtcr: fast path (cr pin)	17	6
cache buffers chains	kcbrls_1	11	23
cache buffers chains	kcbgtcr: fast path	2	1
shared pool	kghalo	5	5

Back to Latch Statistics

Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

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: 48,806,874

Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
MYCAR	MYCAR	SYS_PRODUCT_BURN_INFOR	TABLE	21,124,928	43.28
MYCAR	MYCAR	DIAG_SOFT_VERSION_DETAIL	TABLE	10,965,648	22.47
MYCAR	MYCAR	SYS_PRODUCT	TABLE	9,469,888	19.40
MYCAR	MYCAR	ORDER_DETAIL_INFO	TABLE	2,573,440	5.27
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	2,491,440	5.10

Back to Segment Statistics

Back to Top

Segments by Physical Reads

Total Physical Reads: 259,964

Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	259,591	99.86
MYCAR	MYCAR	OPERATE_LOG	TABLE	32	0.01
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	23	0.01
MYCAR	MYCAR	SOFTIDUSERIDSERIALNO_UNIQUE	INDEX	13	0.01
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	11	0.00

Back to Segment Statistics

Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 2,490

Captured Segments account for 90.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	2,121	85.18
MYCAR	MYCAR	OPERATE_LOG	TABLE	32	1.29
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	23	0.92
MYCAR	MYCAR	SOFTIDUSERIDSERIALNO_UNIQUE	INDEX	13	0.52
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	11	0.44

Back to Segment Statistics

Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 2,490

Captured Segments account for 90.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	2,121	85.18
MYCAR	MYCAR	OPERATE_LOG	TABLE	32	1.29
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	23	0.92
MYCAR	MYCAR	SOFTIDUSERIDSERIALNO_UNIQUE	INDEX	13	0.52
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	11	0.44

Back to Segment Statistics

Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 259,748

Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD		TABLE	259,585	99.94

Back to Segment Statistics

Back to Top

Segments by Physical Writes

Total Physical Writes: 1,790

Captured Segments account for 30.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
MYCAR	MYCAR	OPERATE_LOG		TABLE	213	11.90
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD		TABLE	58	3.24
MYCAR	MYCAR	SYS_USER		TABLE	23	1.28
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER		TABLE	18	1.01
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	WRH$_EVENT__1652681432_9205	INDEX PARTITION	17	0.95

Back to Segment Statistics

Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 1,170

Captured Segments account for 28.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
MYCAR	MYCAR	OPERATE_LOG	TABLE	89	7.61
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	53	4.53
MYCAR	MYCAR	SYS_USER	TABLE	23	1.97
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	17	1.45
MYCAR	MYCAR	SOFTIDUSERIDSERIALNO_UNIQUE	INDEX	14	1.20

Back to Segment Statistics

Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 2

Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	SYS_LOB0000006213C00038$$		LOB	2	100.00

Back to Segment Statistics

Back to Top

Segments by Table Scans

Total Table Scans: 37

Captured Segments account for 13.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD		TABLE	5	13.51

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	352	21.57
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	208	12.75
MYCAR	MYCAR	PK_DIAG_USER_SOFT_CENTER	INDEX	192	11.76
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX	INDEX	128	7.84
MYCAR	MYCAR	SOFTIDUSERIDSERIALNO_UNIQUE	INDEX	112	6.86

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
SYS	SYSAUX	WRH$_SEG_STAT_PK	WRH$_SEG_ST_1652681432_9205	INDEX PARTITION	4	28.57
MYCAR	MYCAR	PK_DIAG_USER_SOFT_CENTER		INDEX	2	14.29
MYCAR	MYCAR	SOFTIDUSERIDSERIALNO_UNIQUE		INDEX	2	14.29
SYS	SYSAUX	WRH$_ENQUEUE_STAT_PK		INDEX	2	14.29
SYS	SYSAUX	WRH$_ROWCACHE_SUMMARY_PK	WRH$_ROWCAC_1652681432_9205	INDEX PARTITION	2	14.29

Back to Segment Statistics

Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

Dictionary Cache Stats

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

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	65	0.00	2	1
dc_files	8	0.00	0	8
dc_global_oids	596	0.00	0	132
dc_histogram_data	742	0.00	0	6,836
dc_histogram_defs	1,168	0.09	0	6,607
dc_objects	1,548	0.06	5	3,775
dc_profiles	71	0.00	0	2
dc_rollback_segments	857	0.00	0	22
dc_segments	855	0.00	5	1,718
dc_sequences	130	0.00	130	47
dc_tablespaces	10,145	0.00	0	10
dc_users	17,778	0.00	0	189
global database name	2,494	0.00	0	2
outstanding_alerts	42	0.00	0	7
sch_lj_oids	5	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
BODY	1,485	0.00	1,873	0.00	0
DBLINK	2	0.00	0		0
EDITION	87	0.00	156	0.00	0
QUEUE	62	0.00	219	0.00	0
SCHEMA	69	0.00	0		0
SQL AREA	5,148	1.69	82,431	0.14	20
SUBSCRIPTION	26	0.00	26	0.00	0
TABLE/PROCEDURE	1,883	0.00	6,477	0.06	2
TRIGGER	26	0.00	63	0.00	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	816.00	816.00	816.00	816.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	1,136.00	1,136.00	1,136.00	1,136.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	2,144.00	2,144.00	2,144.00	2,144.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	16.00	16.00	16.00	16.00	STA/
large pool	16.00	16.00	16.00	16.00	STA/
shared pool	1,264.00	1,264.00	1,264.00	1,264.00	STA/
streams pool	0.00	0.00	0.00	0.00	STA/

Back to Memory Statistics

Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics

Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics

Back to Top

Process Memory Summary

B: Begin Snap E: End Snap

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

Max Alloc is Maximum PGA Allocation size at snapshot time

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

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	377.91		4.02	8.16	28	28	94	94
	Freeable	54.06	0.00	1.23	0.96	4		44	44
	SQL	1.29	0.84	0.02	0.01	0	118	72	66
	PL/SQL	0.92	0.71	0.01	0.03	0	0	92	92
E	Other	379.68		3.96	8.09	28	28	96	96
	Freeable	55.31	0.00	1.23	0.95	4		45	45
	SQL	1.29	0.84	0.02	0.01	0	118	73	66
	PL/SQL	0.94	0.73	0.01	0.03	0	2	94	94

Back to Memory Statistics

Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	855,638,016
Fixed Size	2,218,152
Redo Buffers	15,970,304
Variable Size	2,550,138,712

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	85.42	85.61	0.21
shared	FileOpenBlock	15.20	15.20	0.00
shared	KGLHD	30.24	30.20	-0.15
shared	KGLS	14.96	14.81	-1.01
shared	PCUR	74.27	74.24	-0.04
shared	SQLA	458.35	458.81	0.10
shared	free memory	362.12	362.31	0.05
	buffer_cache	816.00	816.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

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

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

ITPub博客

awrrpt_1_9225_9226.html

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