AWR Report for DB: MYCAR, Inst: mycar, Snaps: 9716-9717

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:	9716	04-Jul-13 14:00:18	102	3.6
End Snap:	9717	04-Jul-13 14:57:50	117	3.5
Elapsed:		57.53 (mins)
DB Time:		624.29 (mins)

Report Summary

Cache Sizes

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

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	10.9	9.6	0.03	0.01
DB CPU(s):	2.2	1.9	0.01	0.00
Redo size:	4,232.5	3,755.4
Logical reads:	6,564.1	5,824.2
Block changes:	18.4	16.3
Physical reads:	593.7	526.8
Physical writes:	1.1	1.0
User calls:	1,250.7	1,109.7
Parses:	355.0	314.9
Hard parses:	0.1	0.1
W/A MB processed:	3.2	2.8
Logons:	0.1	0.1
Executes:	356.2	316.1
Rollbacks:	0.0	0.0
Transactions:	1.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	99.82	In-memory Sort %:	100.00
Library Hit %:	99.95	Soft Parse %:	99.98
Execute to Parse %:	0.36	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	12.06	% Non-Parse CPU:	99.87

Shared Pool Statistics

	Begin	End
Memory Usage %:	73.46	73.55
% SQL with executions>1:	95.96	94.95
% Memory for SQL w/exec>1:	94.48	93.06

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		7,552		20.16
db file sequential read	24,594	1,272	52	3.40	User I/O
log file sync	4,133	1,053	255	2.81	Commit
read by other session	4,133	223	54	0.60	User I/O
enq: KO - fast object checkpoint	22	51	2313	0.14	Application

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.00	8.31	38.1	16.4	0.3	45.4

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	8,192.0	8,192.0
SGA use (MB):	2,144.0	2,144.0
PGA use (MB):	451.7	486.3
% Host Mem used for SGA+PGA:	31.69	32.11

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

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	34,272.82	91.50
PL/SQL execution elapsed time	17,487.72	46.69
DB CPU	7,552.39	20.16
parse time elapsed	95.45	0.25
connection management call elapsed time	64.35	0.17
hard parse elapsed time	30.67	0.08
sequence load elapsed time	0.29	0.00
PL/SQL compilation elapsed time	0.29	0.00
hard parse (sharing criteria) elapsed time	0.28	0.00
failed parse elapsed time	0.09	0.00
repeated bind elapsed time	0.00	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	37,457.57
background elapsed time	1,669.46
background cpu time	1.75

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	756,139
IDLE_TIME	628,563
IOWAIT_TIME	3,903
NICE_TIME	0
SYS_TIME	226,510
USER_TIME	528,138
LOAD	0	8
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
04-Jul 14:00:18	0.00
04-Jul 14:57:50	8.31	54.61	38.14	16.36	45.39	0.28

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 27.5% of Total DB time 37,457.57 (s)

Total FG Wait Time: 2,745.45 (s) DB CPU time: 7,552.39 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			7,552		20.16
User I/O	49,998	0	1,530	31	4.08
Commit	4,133	0	1,053	255	2.81
Concurrency	222	1	96	431	0.26
Application	48	0	52	1091	0.14
Network	3,160,044	0	8	0	0.02
Other	187,690	100	6	0	0.02
Configuration	10	0	0	0	0.00
System I/O	82	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
db file sequential read	24,594	0	1,272	52	6.32	3.40
log file sync	4,133	0	1,053	255	1.06	2.81
read by other session	4,133	0	223	54	1.06	0.60
enq: KO - fast object checkpoint	22	0	51	2313	0.01	0.14
library cache: mutex X	10	0	48	4773	0.00	0.13
direct path read	17,669	0	31	2	4.54	0.08
latch: cache buffers chains	150	0	29	194	0.04	0.08
cursor: pin S	9	0	9	997	0.00	0.02
SQL*Net message to client	3,107,453	0	7	0	798.83	0.02
reliable message	22	5	4	193	0.01	0.01
direct path sync	1	0	3	3280	0.00	0.01
enq: TX - index contention	10	0	3	309	0.00	0.01
latch: shared pool	11	0	3	253	0.00	0.01
cursor: mutex S	3	100	2	760	0.00	0.01
enq: TX - row lock contention	13	0	1	113	0.00	0.00
SQL*Net more data to client	47,481	0	1	0	12.21	0.00
buffer busy waits	13	0	1	80	0.00	0.00
asynch descriptor resize	187,661	100	1	0	48.24	0.00
latch: row cache objects	8	0	1	101	0.00	0.00
db file parallel read	9	0	1	62	0.00	0.00
latch: object queue header operation	1	0	0	454	0.00	0.00
latch: cache buffers lru chain	1	0	0	443	0.00	0.00
Disk file operations I/O	397	0	0	0	0.10	0.00
SQL*Net more data from client	5,110	0	0	0	1.31	0.00
db file scattered read	3,191	0	0	0	0.82	0.00
enq: SQ - contention	10	0	0	0	0.00	0.00
SQL*Net break/reset to client	13	0	0	0	0.00	0.00
latch: In memory undo latch	8	0	0	0	0.00	0.00
SQL*Net message from client	3,107,442	0	127,532	41	798.83
jobq slave wait	6,983	100	3,540	507	1.80

Back to Wait Events Statistics

Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Only events with Total Wait Time (s) >= .001 are shown

%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	8,910	0	661	74	2.29	39.61
control file parallel write	1,098	0	378	344	0.28	22.62
db file async I/O submit	885	0	330	373	0.23	19.78
os thread startup	128	0	235	1835	0.03	14.07
direct path sync	2	0	16	7952	0.00	0.95
log file sync	3	0	5	1804	0.00	0.32
latch: shared pool	3	0	5	1761	0.00	0.32
control file sequential read	5,445	0	5	1	1.40	0.27
enq: CF - contention	2	0	3	1611	0.00	0.19
db file sequential read	57	0	1	14	0.01	0.05
latch: call allocation	2	0	0	126	0.00	0.02
latch: cache buffers chains	1	0	0	240	0.00	0.01
ADR block file read	13	0	0	3	0.00	0.00
Disk file operations I/O	85	0	0	0	0.02	0.00
db file parallel read	32	0	0	1	0.01	0.00
ADR file lock	6	0	0	1	0.00	0.00
LGWR wait for redo copy	8	0	0	1	0.00	0.00
asynch descriptor resize	303	100	0	0	0.08	0.00
direct path write	9	0	0	0	0.00	0.00
ADR block file write	5	0	0	0	0.00	0.00
rdbms ipc message	18,844	75	73,235	3886	4.84
DIAG idle wait	6,869	100	6,921	1008	1.77
shared server idle wait	116	100	3,482	30016	0.03
Streams AQ: qmn slave idle wait	246	0	3,475	14124	0.06
Streams AQ: qmn coordinator idle wait	373	33	3,475	9315	0.10
pmon timer	1,257	90	3,461	2753	0.32
Space Manager: slave idle wait	543	100	3,443	6340	0.14
dispatcher timer	57	100	3,421	60014	0.01
smon timer	12	92	3,300	275009	0.00
SQL*Net message from client	492	0	78	159	0.13
class slave wait	17	0	3	179	0.00

Back to Wait Events Statistics

Back to Top

Wait Event Histogram

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

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

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

Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	13	76.9				23.1
ADR block file write	5	100.0
ADR file lock	6	83.3			16.7
Disk file operations I/O	482	99.6	.4
LGWR wait for redo copy	8	87.5			12.5
SQL*Net break/reset to client	13	100.0
SQL*Net message to client	3108.3K	100.0	.0	.0	.0			.0
SQL*Net more data from client	5112	99.9	.0		.0		.0
SQL*Net more data to client	47.5K	100.0	.0					.0
asynch descriptor resize	188K	100.0	.0	.0				.0
buffer busy waits	13	61.5						38.5
control file parallel write	1098	49.7	2.5	.3	.8	.9	.9	34.9	10.0
control file sequential read	5527	99.9						.0	.0
cursor: mutex S	3	66.7							33.3
cursor: pin S	9	66.7		11.1					22.2
db file async I/O submit	885	35.6	13.7	5.3	.9	1.2	.7	30.4	12.2
db file parallel read	41	39.0	39.0			7.3		14.6
db file scattered read	3191	100.0
db file sequential read	24.7K	77.1	1.5	1.1	2.0	2.5	.5	15.1	.3
direct path read	17.7K	98.6	1.1	.0	.0	.0		.2	.0
direct path sync	3				33.3				66.7
direct path write	13	100.0
enq: CF - contention	2							50.0	50.0
enq: KO - fast object checkpoint	22	13.6		9.1				22.7	54.5
enq: SQ - contention	10	100.0
enq: TX - index contention	10	10.0		10.0	50.0	10.0		10.0	10.0
enq: TX - row lock contention	13		15.4	38.5		7.7		38.5
latch free	7	100.0
latch: In memory undo latch	8	100.0
latch: cache buffers chains	151	43.0	2.0	.7		1.3		51.0	2.0
latch: cache buffers lru chain	1							100.0
latch: call allocation	2	50.0						50.0
latch: object queue header operation	1							100.0
latch: redo allocation	1	100.0
latch: row cache objects	8	12.5		25.0		25.0		37.5
latch: shared pool	14	57.1						21.4	21.4
library cache: mutex X	10	10.0						30.0	60.0
log file parallel write	8912	82.7	.7	.4	.5	.6	.3	13.6	1.2
log file sync	4137	59.4	2.7	1.3	1.0	1.3	.9	26.3	7.2
os thread startup	128						53.1	25.0	21.9
read by other session	4133	73.4	1.9	1.5	2.9	2.4	.6	17.1	.2
reliable message	23	65.2						30.4	4.3
DIAG idle wait	6869							93.3	6.7
SQL*Net message from client	3108.3K	94.4	2.3	.5	.2	.3	.2	1.9	.2
Space Manager: slave idle wait	543	.2							99.8
Streams AQ: qmn coordinator idle wait	373	62.7	.3			.3		3.5	33.2
Streams AQ: qmn slave idle wait	246	49.6							50.4
class slave wait	17	88.2							11.8
dispatcher timer	57								100.0
jobq slave wait	6984	.0	.0		.0	.0	.0	99.9	.0
pmon timer	1257	5.4	.1	.1		.3	.2	1.8	92.0
rdbms ipc message	18.8K	5.9	.9	2.3	2.1	5.0	1.0	24.3	58.5
shared server idle wait	116								100.0
smon timer	12	8.3							91.7

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
SQL*Net message to client	5	100.0	.0	.0	.0	.0
SQL*Net more data to client	1	100.0					.0
asynch descriptor resize	1	100.0				.0
buffer busy waits	5	61.5		7.7	23.1	7.7
control file parallel write	484	55.1	1.1	2.1	3.7	9.2	18.8	9.2	.8
control file sequential read	3	99.9					.0	.0
cursor: pin S	1	77.8						11.1	11.1
db file async I/O submit	335	57.4	1.2	3.2	6.2	10.6	9.2	7.5	4.7
db file parallel read	6	85.4	7.3	4.9	2.4
db file sequential read	3794	84.6	.4	3.2	4.0	5.4	2.1	.3	.0
direct path read	33	99.8	.0	.0	.0	.1	.1		.0
enq: CF - contention	1					50.0			50.0
enq: KO - fast object checkpoint	5	22.7			4.5	4.5	13.6		54.5
enq: TX - index contention	1	80.0					10.0		10.0
enq: TX - row lock contention	5	61.5	7.7		7.7	23.1
latch: cache buffers chains	80	47.0	1.3	4.6	11.9	27.8	5.3	2.0
latch: cache buffers lru chain	1					100.0
latch: call allocation	1	50.0			50.0
latch: object queue header operation	1					100.0
latch: row cache objects	3	62.5		12.5	12.5	12.5
latch: shared pool	5	57.1				14.3	7.1	14.3	7.1
library cache: mutex X	3	10.0	10.0			10.0	10.0		60.0
log file parallel write	1315	85.2	.5	1.4	2.8	4.6	4.2	1.2	.0
log file sync	1338	66.5	1.1	2.2	4.4	8.1	10.4	6.1	1.1
os thread startup	33	53.1	14.1	5.5	1.6	.8	3.1	.8	21.1
read by other session	715	82.7	.6	3.6	4.5	6.5	1.8	.2	.0
reliable message	8	65.2		8.7		13.0	8.7	4.3

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
		% of Total Waits
control file parallel write	9	99.2	.7		.1
cursor: mutex S	1	66.7	33.3
cursor: pin S	1	88.9		11.1
db file async I/O submit	42	95.3	4.2	.6
db file sequential read	4	100.0	.0		.0
direct path read	2	100.0	.0		.0
direct path sync	2	33.3	33.3		33.3
enq: CF - contention	1	50.0	50.0
enq: KO - fast object checkpoint	12	45.5	36.4	18.2
enq: TX - index contention	1	90.0	10.0
latch: shared pool	1	92.9	7.1
library cache: mutex X	6	40.0	20.0	10.0	30.0
log file parallel write	4	100.0	.0	.0	.0
log file sync	47	98.9	.7	.3	.1
os thread startup	27	78.9	1.6	10.2	8.6	.8
read by other session	1	100.0	.0

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	37,339	7,547	2,046	22,579
mycar	118	5	0	51
SYS$BACKGROUND	0	0	3	24
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	49994	1530	221	96	3159821	8
mycar	4	0	0	0	223	0
SYS$BACKGROUND	185	17	130	236	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 91.3% of Total DB Time (s): 37,458

Captured PL/SQL account for 0.0% of Total DB Time (s): 37,458

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
32,074.50	9,225	3.48	85.63	22.28	0.00	5spk48gcmhf2g		SELECT * FROM COUNTRY_CODE C J...
1,455.99	456	3.19	3.89	0.18	99.34	7m9w85hj1ukqg		select t.* from df_data_stream...
93.60	21	4.46	0.25	11.54	16.47	asdsn1yqzjk0r		select r.DOWNLOAD_ID, r.VERSIO...
83.21	1	83.21	0.22	5.85	0.00	fqmpmkfr6pqyk	PLSQLDev.exe	select s.synonym_name object_n...
61.06	23	2.65	0.16	30.40	0.00	4040jw7rmjbqj		select cbi.* FROM diag_soft ds...
49.32	165	0.30	0.13	35.54	0.89	89nfp8fv1y8vw		SELECT COUNT(*) AS c from (sel...
42.16	39,714	0.00	0.11	74.81	0.00	c2t5v51gankkv		select ds.unified_id as unifie...
29.93	516,410	0.00	0.08	47.17	0.00	520mkxqpf15q8		select 1 from dual
24.35	52,550	0.00	0.07	7.75	10.59	5nggumnh49yzc		select * from SYS_PRODUCT wher...
23.41	7,783	0.00	0.06	6.48	0.00	87hfb2vvgt6tp		select 1 from sys_area_country...

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 97.1% of Total CPU Time (s): 7,552

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
7,146.26	9,225	0.77	94.62	32,074.50	22.28	0.00	5spk48gcmhf2g	SELECT * FROM COUNTRY_CODE C J...
31.54	39,714	0.00	0.42	42.16	74.81	0.00	c2t5v51gankkv	select ds.unified_id as unifie...
18.57	23	0.81	0.25	61.06	30.40	0.00	4040jw7rmjbqj	select cbi.* FROM diag_soft ds...
17.53	165	0.11	0.23	49.32	35.54	0.89	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
14.12	516,410	0.00	0.19	29.93	47.17	0.00	520mkxqpf15q8	select 1 from dual
13.71	165	0.08	0.18	16.00	85.72	3.31	6zzzr28dtrtpd	select * from ( select us.FREE...
13.67	165	0.08	0.18	14.75	92.65	2.76	1dv841hap05xc	SELECT COUNT(*) AS c from (sel...
12.48	340,546	0.00	0.17	22.00	56.72	0.00	5d80ww4xabj00	select t.* from df_unit_conver...
10.80	21	0.51	0.14	93.60	11.54	16.47	asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSIO...
8.06	4,871	0.00	0.11	11.89	67.81	0.00	2asdyf7j381tv	select s.*, l.LAN_NAME from DI...

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 97.7% of Total User I/O Wait Time (s): 1,547

Captured PL/SQL account for 0.2% of Total User I/O Wait Time (s): 1,547

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,446.45	456	3.17	93.51	1,455.99	0.18	99.34	7m9w85hj1ukqg		select t.* from df_data_stream...
19.19	2	9.59	1.24	22.71	0.42	84.48	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
15.42	21	0.73	1.00	93.60	11.54	16.47	asdsn1yqzjk0r		select r.DOWNLOAD_ID, r.VERSIO...
9.92	5,036	0.00	0.64	10.40	2.69	95.41	dx9uj64072dw7		select * from SYS_PRODUCT_BURN...
8.65	28,339	0.00	0.56	10.75	10.27	80.53	4xbg42tpyp0gm		select * from SYS_PRODUCT_LANG...
4.39	80	0.05	0.28	5.60	14.87	78.49	9kyafghcc1xh6		select distinct temp.SOFT_ID, ...
3.79	0		0.25	10.86	0.77	34.92	1uk5m5qbzj1vt	sqlplus@vm192168000035 (TNS V1-V3)	BEGIN dbms_workload_repository...
2.58	52,550	0.00	0.17	24.35	7.75	10.59	5nggumnh49yzc		select * from SYS_PRODUCT wher...
1.93	4,026	0.00	0.12	2.24	3.75	85.89	c00br6fharcvs		select c.* from diag_user_soft...
0.53	165	0.00	0.03	16.00	85.72	3.31	6zzzr28dtrtpd		select * from ( select us.FREE...

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: 22,656,056

Captured SQL account for 88.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
3,346,867	9,225	362.80	14.77	32,074.50	22.28	0.00	5spk48gcmhf2g	SELECT * FROM COUNTRY_CODE C J...
1,918,540	165	11,627.52	8.47	16.00	85.72	3.31	6zzzr28dtrtpd	select * from ( select us.FREE...
1,918,518	165	11,627.38	8.47	14.75	92.65	2.76	1dv841hap05xc	SELECT COUNT(*) AS c from (sel...
1,916,581	165	11,615.64	8.46	49.32	35.54	0.89	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
1,362,804	4,871	279.78	6.02	11.89	67.81	0.00	2asdyf7j381tv	select s.*, l.LAN_NAME from DI...
1,349,124	21	64,244.00	5.95	93.60	11.54	16.47	asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSIO...
1,077,708	39,714	27.14	4.76	42.16	74.81	0.00	c2t5v51gankkv	select ds.unified_id as unifie...
1,069,796	17	62,929.18	4.72	17.73	29.91	0.00	7c9aurkrt70vn	select * from ( select p.*, pt...
868,754	75	11,583.39	3.83	9.34	66.74	3.10	6u4dt8af4b0x1	select * from ( select us.FREE...
855,583	340,546	2.51	3.78	22.00	56.72	0.00	5d80ww4xabj00	select t.* from df_unit_conver...
532,037	19	28,001.95	2.35	1.10	87.98	0.00	aygjw8hmzpntb	select * from ( select s.SOFT_...
453,476	20	22,673.80	2.00	1.47	70.32	27.07	1dgz6vdqx9dy0	SELECT COUNT(*) AS c from DIAG...
391,884	18,959	20.67	1.73	5.34	57.83	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
351,112	18,959	18.52	1.55	2.40	65.95	0.00	5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERS...
326,637	456	716.31	1.44	1,455.99	0.18	99.34	7m9w85hj1ukqg	select t.* from df_data_stream...
318,771	7,783	40.96	1.41	23.41	6.48	0.00	87hfb2vvgt6tp	select 1 from sys_area_country...
281,136	17,571	16.00	1.24	4.15	54.40	0.00	5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_...
252,808	52,550	4.81	1.12	24.35	7.75	10.59	5nggumnh49yzc	select * from SYS_PRODUCT wher...

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: 2,049,244

Captured SQL account for 94.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
1,347,297	21	64,157.00	65.75	93.60	11.54	16.47	asdsn1yqzjk0r	select r.DOWNLOAD_ID, r.VERSIO...
154,119	165	934.05	7.52	49.32	35.54	0.89	89nfp8fv1y8vw	SELECT COUNT(*) AS c from (sel...
152,892	165	926.62	7.46	14.75	92.65	2.76	1dv841hap05xc	SELECT COUNT(*) AS c from (sel...
152,771	165	925.88	7.45	16.00	85.72	3.31	6zzzr28dtrtpd	select * from ( select us.FREE...
97,557	75	1,300.76	4.76	9.34	66.74	3.10	6u4dt8af4b0x1	select * from ( select us.FREE...
20,353	456	44.63	0.99	1,455.99	0.18	99.34	7m9w85hj1ukqg	select t.* from df_data_stream...
10,733	14	766.64	0.52	1.31	91.10	2.53	5g35vsgdmpdds	select * from ( select row_.*,...
27	80	0.34	0.00	5.60	14.87	78.49	9kyafghcc1xh6	select distinct temp.SOFT_ID, ...
23	5,036	0.00	0.00	10.40	2.69	95.41	dx9uj64072dw7	select * from SYS_PRODUCT_BURN...
17	20	0.85	0.00	1.47	70.32	27.07	1dgz6vdqx9dy0	SELECT COUNT(*) AS c from DIAG...

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: 48,494

Captured SQL account for 64.8% of Total

Total UnOptimized Read Requests: 48,494

Captured SQL account for 64.8% of Total

Total Optimized Read Requests: 1

Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
20,353	20,353	456	44.63	41.97	7m9w85hj1ukqg		select t.* from df_data_stream...
3,419	3,419	165	20.72	7.05	89nfp8fv1y8vw		SELECT COUNT(*) AS c from (sel...
2,863	2,863	165	17.35	5.90	6zzzr28dtrtpd		select * from ( select us.FREE...
2,842	2,842	165	17.22	5.86	1dv841hap05xc		SELECT COUNT(*) AS c from (sel...
1,600	1,600	75	21.33	3.30	6u4dt8af4b0x1		select * from ( select us.FREE...
150	150	15	10.00	0.31	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
128	128	14	9.14	0.26	5g35vsgdmpdds		select * from ( select row_.*,...
17	17	20	0.85	0.04	1dgz6vdqx9dy0		SELECT COUNT(*) AS c from DIAG...
12	12	56	0.21	0.02	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
11	11	0		0.02	1uk5m5qbzj1vt	sqlplus@vm192168000035 (TNS V1-V3)	BEGIN dbms_workload_repository...

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: 1,229,498

Captured SQL account for 97.4% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
516,410	516,403	1.00	29.93	47.17	0.00	520mkxqpf15q8	select 1 from dual
340,546	174,480	0.51	22.00	56.72	0.00	5d80ww4xabj00	select t.* from df_unit_conver...
52,550	52,449	1.00	24.35	7.75	10.59	5nggumnh49yzc	select * from SYS_PRODUCT wher...
39,714	39,712	1.00	42.16	74.81	0.00	c2t5v51gankkv	select ds.unified_id as unifie...
30,063	30,063	1.00	4.93	24.61	0.00	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
28,339	170,393	6.01	10.75	10.27	80.53	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
21,927	0	0.00	1.15	65.16	0.05	1fnv7qu1a8qsc	select * from product_down_set...
18,959	628,792	33.17	5.34	57.83	0.00	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
18,959	66,770	3.52	2.40	65.95	0.00	5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERS...
17,571	7,798	0.44	4.15	54.40	0.00	5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_...

Back to SQL Statistics

Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,225,129

Captured SQL account for 97.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
516,411	516,410	42.15	520mkxqpf15q8	select 1 from dual
340,547	340,546	27.80	5d80ww4xabj00	select t.* from df_unit_conver...
52,550	52,550	4.29	5nggumnh49yzc	select * from SYS_PRODUCT wher...
39,714	39,714	3.24	c2t5v51gankkv	select ds.unified_id as unifie...
30,063	30,063	2.45	bm7qdt1qj4cg0	select l.LAN_NAME, d.* from DI...
28,339	28,339	2.31	4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG...
21,927	21,927	1.79	1fnv7qu1a8qsc	select * from product_down_set...
18,959	18,959	1.55	0ay7wjuhgzj9k	select d.* from diag_soft_vers...
18,959	18,959	1.55	5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERS...
17,571	17,571	1.43	5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_...

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
4,317,483	1	0.33	gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) F...
2,265,370	3	0.17	ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME...
1,732,252	17	0.13	3hpxs5dvc897x	select * from ( select mm.*, n...
1,298,216	15	0.10	bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(...

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
90	2	5rygsj4dbw6jt		insert into sys.mon_mods$ (obj...
73	122	fsbqktj5vw6n9		select next_run_date, obj#, ru...
72	121	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
71	72	ctsfqq07f876g		SELECT NVL(CRIT_COUNTER, 0), N...
69	1	9yt4ka3n2svmc	DBMS_SCHEDULER	update sys.scheduler$_job set ...
67	5	fcb5u7n0r523m		SELECT NVL(AVG((VALUE*1000.0)/...
67	5	fcb5u7n0r523m		SELECT NVL(AVG((VALUE*1000.0)/...
65	203	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...
65	15	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
57	5	cabqn4dp09qck		SELECT TASK_CLASS, ROUND(NVL(S...
53	203	gfdn12rn0fg3m		SELECT TARGET_GUID FROM MGMT_T...
51	46	9vt6njn4h1wf1		SELECT TRIM(B.METRIC_NAME) FRO...
51	119	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
51	188	g00cj285jmgsw		update sys.mon_mods$ set inser...
50	51	3x0kdm7z3yasw		SELECT TARGET_TYPE, TYPE_META_...
50	5	869avkb73kf5g		SELECT NVL((((SUM(DURATION)/(6...
47	62	aq8yqxyyb40nn		update sys.job$ set this_date=...
45	3	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
40	5	7gzxf61vj6wq4		SELECT ID FROM SYS.WRI$_ADV_TA...
39	2	g4gp07gt2z920		update sys.scheduler$_job set ...
39	1	gjm43un5cy843		SELECT SUM(USED), SUM(TOTAL) F...
39	1	gjm43un5cy843		SELECT SUM(USED), SUM(TOTAL) F...
35	34	cw5gh4duww26p		SELECT COUNT(*) AS c from ( se...
35	34	cw5gh4duww26p		SELECT COUNT(*) AS c from ( se...
35	34	cw5gh4duww26p		SELECT COUNT(*) AS c from ( se...
35	34	cw5gh4duww26p		SELECT COUNT(*) AS c from ( se...
35	34	cw5gh4duww26p		SELECT COUNT(*) AS c from ( se...
35	34	cw5gh4duww26p		SELECT COUNT(*) AS c from ( se...
35	34	cw5gh4duww26p		SELECT COUNT(*) AS c from ( se...
29	80	9kyafghcc1xh6		select distinct temp.SOFT_ID, ...
28	17	77jfd5z2qky8p		select * from ( select mm.*, n...
28	17	77jfd5z2qky8p		select * from ( select mm.*, n...
28	17	77jfd5z2qky8p		select * from ( select mm.*, n...
28	17	77jfd5z2qky8p		select * from ( select mm.*, n...
28	17	77jfd5z2qky8p		select * from ( select mm.*, n...
28	17	77jfd5z2qky8p		select * from ( select mm.*, n...
28	17	77jfd5z2qky8p		select * from ( select mm.*, n...
26	17	3hpxs5dvc897x		select * from ( select mm.*, n...
26	17	3hpxs5dvc897x		select * from ( select mm.*, n...
26	17	3hpxs5dvc897x		select * from ( select mm.*, n...
26	17	3hpxs5dvc897x		select * from ( select mm.*, n...
26	17	3hpxs5dvc897x		select * from ( select mm.*, n...
26	17	3hpxs5dvc897x		select * from ( select mm.*, n...
24	7	g4kcn01rx9d0m		SELECT COUNT(*) AS c from ( se...
24	7	g4kcn01rx9d0m		SELECT COUNT(*) AS c from ( se...
24	7	g4kcn01rx9d0m		SELECT COUNT(*) AS c from ( se...
24	7	g4kcn01rx9d0m		SELECT COUNT(*) AS c from ( se...
23	7	1r00pg8rfnkpa		select * from ( select m.* fro...
23	7	1r00pg8rfnkpa		select * from ( select m.* fro...
23	7	1r00pg8rfnkpa		select * from ( select m.* fro...
23	7	1r00pg8rfnkpa		select * from ( select m.* fro...

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
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))
1dgz6vdqx9dy0	SELECT COUNT(*) AS c from DIAG_SOFT_VERSION v join DIAG_SOFT s on s.SOFT_ID = v.SOFT_ID join SYS_PDT_TYPE pdt on pdt.PDT_TYPE_ID=s.PDT_TYPE_ID WHERE exists(select 'X' from DIAG_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID and d.CHECK_STATE=:1) order by v.UPDATE_TIME desc
1dv841hap05xc	SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID AND sd.LAN_ID = :1 ) join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID where exists( select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') AND (v.VALID_FLAG = :2) AND (d.CHECK_STATE = :3) ) AND (s.VALID_FLAG = :4) AND (us.SERIAL_NO = :5) AND (s.pdt_type_id = :6) order by upper(s.SOFT_NAME) asc
1fnv7qu1a8qsc	select * from product_down_setting p where p.serial_no=:1
1r00pg8rfnkpa	select * from ( select m.* from (select s.soft_id, t1.version_no, t1.creater_time, t4.soft_name as soft_desc, t2.remark, t2.version_detail_id, nvl(UPGRADE_PRICE, DEFAULT_BPRICE) as price, v.CUR_ID, t5.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_user_soft_center t3, diag_soft_desc t4, sys_currency_unit t5 where s.pdt_type_id = p.pdt_type_id and s.soft_id = pr.soft_id and v.cur_id = pr.cur_id and upper(s.soft_name) not like '%ZY' and t4.soft_id = s.soft_id and t4.lan_id = :1 and pr.cur_id = t5.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.user_id = :2 and t3.free_end_time < sysdate and p.serial_no = :3 and p.serial_no = t3.serial_no and p.pdt_state = 1 and p.user_id = :4 and t2.lan_id = :5 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 = :6 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 and not exists ( select 1 from ( 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 = :7 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 ) tr, ( select soft_id, info.version from user_order uo, order_detail_info info where uo.order_id = info.order_id and uo.order_status in (0, 1, 3) and uo.serial_no = :8 and uo.buy_origin = 1 and uo.user_id = :9 ) rt where tr.soft_id = rt.soft_id and tr.version_no = rt.version ) ) where rownum <= 10
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
2asdyf7j381tv	select s.*, l.LAN_NAME from DIAG_SOFT_DESC s left join sys_lan l on s.LAN_ID=l.LAN_ID where s.SOFT_ID=:1
3hpxs5dvc897x	select * from ( select mm., nvl2(t3.soft_name, t3.soft_name, mm.soft_name) as soft_desc from (select distinct m. from (select s.soft_id, t1.version_no, t1.creater_time, t2.remark, t2.version_detail_id, nvl(buy_price, default_bprice) as price, t4.CUR_ID, t4.cur_code, s.soft_name from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, 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 pr.cur_id = t4.cur_id and upper(s.soft_name) not like '%ZY' and upper(s.soft_name) not in ('KARRY', 'ZHONGXINGZHY') 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 s.soft_id not in (select soft_id from diag_user_soft_center where user_id = :1 and serial_no = :2) 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 = :3 and u.order_status in (0, 1, 3) and u.serial_no = :4) and p.serial_no = :5 and p.pdt_state = 1 and p.user_id = :6 and t2.lan_id = :7 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 = :8 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 )mm left join diag_soft_desc t3 on mm.soft_id = t3.soft_id and t3.lan_id = :9 order by NLSSORT(soft_desc, 'NLS_SORT=SCHINESE_PINYIN_M') ) where rownum <= 10
3x0kdm7z3yasw	SELECT TARGET_TYPE, TYPE_META_VER, NVL(CATEGORY_PROP_1, ' '), NVL(CATEGORY_PROP_2, ' '), NVL(CATEGORY_PROP_3, ' '), NVL(CATEGORY_PROP_4, ' '), NVL(CATEGORY_PROP_5, ' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
4040jw7rmjbqj	select cbi.* FROM diag_soft ds, car_base_info cbi where ds.soft_name in (select dsxn.auto_code from user_carbaseinfo uc, diag_soft_x431_name dsxn where uc.serial_no=:1 and uc.auto_id=cbi.car_brand_id and uc.diag_entrance_id = cbi.diag_entrance_id and dsxn.auto_id=cbi.car_brand_id) AND DS.PDT_TYPE_ID=:2
4xbg42tpyp0gm	select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
520mkxqpf15q8	select 1 from dual
5ck2pk4pxbq6y	select v.* from DIAG_SOFT_VERSION v where exists (select 'X' from DIAG_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID AND d.CHECK_STATE=:1 ) and exists(select 'X' from DIAG_SOFT s where s.SOFT_ID=v.SOFT_ID and s.VALID_FLAG=1) and v.VALID_FLAG=1 and v.SOFT_ID = :2 AND to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(:3, 'yyyy-mm-dd') order by v.VERSION_NO desc
5d80ww4xabj00	select t.* from df_unit_conversion t where t.private_unit_id = :1 and t.unified_unit_id=:2
5g35vsgdmpdds	select * from ( select row_., rownum rownum_ 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 ) row_ where rownum <= 20) where ro wnum_ > 10
5ky6k3fa3cu3y	select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2) and LAN_ID = :3
5nggumnh49yzc	select * from SYS_PRODUCT where SERIAL_NO = :1
5rygsj4dbw6jt	insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7)
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)
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
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
77jfd5z2qky8p	select * from ( select mm., nvl2(t3.soft_name, t3.soft_name, mm.soft_name) as soft_desc from (select distinct m. from (select s.soft_id, t1.version_no, t1.creater_time, t2.remark, t2.version_detail_id, nvl(buy_price, default_bprice) as price, t4.CUR_ID, t4.cur_code, s.soft_name from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, 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 pr.cur_id = t4.cur_id and upper(s.soft_name) not like '%ZY' and upper(s.soft_name) not in ('KARRY', 'ZHONGXINGZHY') 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 s.soft_id not in (select soft_id from diag_user_soft_center where user_id = :1 and serial_no = :2) 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 = :3 and u.order_status in (0, 1, 3) and u.serial_no = :4) and p.serial_no = :5 and p.pdt_state = 1 and p.user_id = :6 and t2.lan_id = :7 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 = :8 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 )mm left join diag_soft_desc t3 on mm.soft_id = t3.soft_id and t3.lan_id = :9 order by NLSSORT(soft_desc, 'NLS_SORT=SCHINESE_PINYIN_M') ) where rownum <= 2147483647
7c9aurkrt70vn	select * from ( select p.*, pt.PDT_TYPE, sc.name, v.VENDER_NAME, f.VENDER_NAME as FILIAL_ENAME, c.customer_name from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_ID left join sys_vender f on p.filiale_id = f.VENDER_ID left join customer c on c.customer_number_id = p.customer_number where 1=1 AND p.PRODUCT_PART = :1 order by UPDATE_TIME desc ) where rownum <= 10
7gzxf61vj6wq4	SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1
7m9w85hj1ukqg	select t.* from df_data_stream_desc t where t.version_detail_id = :1 and t.unified_id is not null
869avkb73kf5g	SELECT NVL((((SUM(DURATION)/(601000))/60)100), 0), NVL(AVG((VALUE*1000.0)/DURATION), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE IS_TOTAL='Y' AND DURATION > 0 AND TIME > (SYSDATE-(1/24)) AND JOB_NAME = 'JOB_DISPATCHER' AND HOST_URL = :B1
87hfb2vvgt6tp	select 1 from sys_area_country where 1=1 AND DOWNLOAD_AREA_ID = (select distinct t1.download_area_id from sys_vender t1 join sys_vender t2 ON (t2.user_type=2 and t1.vender_id = t2.filiale_id) or(t2.user_type=3 and t1.vender_id =t2.vender_id) join sys_product tp ON (t2.vender_id = tp.vender_id )or (tp.vender_id is null and t2.vender_id = tp.filiale_id) where t1.user_type = 3 and tp.serial_no = :1) and country_id = :2
89nfp8fv1y8vw	SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID AND sd.LAN_ID = :1 ) join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID where exists( select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id and to_char(v.CREATER_TIME, 'yyyy-mm-dd') <= to_char(us.FREE_END_TIME, 'yyyy-mm-dd') AND (v.VALID_FLAG = :2) AND (d.CHECK_STATE = :3) ) AND (s.VALID_FLAG = :4) AND (us.SERIAL_NO = :5) AND (s.pdt_type_id = :6) order by s.UPDATE_TIME desc
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
9vt6njn4h1wf1	SELECT TRIM(B.METRIC_NAME) FROM MGMT_TARGETS A, MGMT_METRICS B WHERE B.METRIC_GUID = :B2 AND A.TARGET_TYPE = B.TARGET_TYPE AND A.TYPE_META_VER = B.TYPE_META_VER AND (B.CATEGORY_PROP_1 = A.CATEGORY_PROP_1 OR B.CATEGORY_PROP_1 = ' ') AND (B.CATEGORY_PROP_2 = A.CATEGORY_PROP_2 OR B.CATEGORY_PROP_2 = ' ') AND (B.CATEGORY_PROP_3 = A.CATEGORY_PROP_3 OR B.CATEGORY_PROP_3 = ' ') AND (B.CATEGORY_PROP_4 = A.CATEGORY_PROP_4 OR B.CATEGORY_PROP_4 = ' ') AND (B.CATEGORY_PROP_5 = A.CATEGORY_PROP_5 OR B.CATEGORY_PROP_5 = ' ') AND A.TARGET_GUID=:B1
9yt4ka3n2svmc	update sys.scheduler$_job set last_enabled_time = :1, next_run_date = :2, job_status = :3 where obj# = :4
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
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
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
aygjw8hmzpntb	select * from ( select s.SOFT_NAME, pdt.PDT_TYPE, v.* from DIAG_SOFT_VERSION v join DIAG_SOFT s on s.SOFT_ID = v.SOFT_ID join SYS_PDT_TYPE pdt on pdt.PDT_TYPE_ID=s.PDT_TYPE_ID WHERE exists(select 'X' from DIAG_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID and d.CHECK_STATE=:1) order by v.UPDATE_TIME desc ) where rownum <= 10
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
c2t5v51gankkv	select ds.unified_id as unified_data_id, du.stream_display_name as unified_data_name, ddsu.unit_name as unified_data_unit_name, ddsu.unit_id as unified_data_unit_id from df_data_stream_desc ds left join df_unified_data_desc dud on dud.data_stream_id = ds.unified_id left join df_unified_data_name_desc du on (du.data_stream_id =ds.unified_id and du.lan_id = :1) left join df_data_stream_unit ddsu on ddsu.unit_id =dud.data_stream_unit_id where ds.version_detail_id = :2 and ds.data_stream_id = :3
cabqn4dp09qck	SELECT TASK_CLASS, ROUND(NVL(SUM(THROUGHPUT), 0), 2), NVL(SUM(TOTAL_VALUE), 0), NVL(SUM(TOTAL_DURATION), 0) FROM (SELECT CLIENT_DATA WORKER_ID, ACTION TASK_CLASS, NVL(AVG(VALUE1000/ DECODE(DURATION, 0, 1000, DURATION)), 0) THROUGHPUT, SUM(VALUE) TOTAL_VALUE, SUM(DURATION)/1000 TOTAL_DURATION, COUNT() RECORDS FROM MGMT_SYSTEM_PERFORMANCE_LOG LOG WHERE LOG.JOB_NAME = :B3 AND LOG.MODULE = :B2 AND LOG.TIME > (SYSDATE-:B1 /1440) AND LOG.IS_TOTAL = 'Y' GROUP BY CLIENT_DATA, ACTION ) GROUP BY TASK_CLASS
ctsfqq07f876g	SELECT NVL(CRIT_COUNTER, 0), NVL(WARN_COUNTER, 0), NVL(INFO_COUNTER, 0) FROM MGMT_POLICY_ASSOC_EVAL_DETAILS WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND RESULT_KEY_VALUE = :B2 AND COLL_NAME = :B1
cw5gh4duww26p	SELECT COUNT() AS c from ( select mm., nvl2(t3.soft_name, t3.soft_name, mm.soft_name) as soft_desc from (select distinct m.* from (select s.soft_id, t1.version_no, t1.creater_time, t2.remark, t2.version_detail_id, nvl(buy_price, default_bprice) as price, t4.CUR_ID, t4.cur_code, s.soft_name from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, 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 pr.cur_id = t4.cur_id and upper(s.soft_name) not like '%ZY' and upper(s.soft_name) not in ('KARRY', 'ZHONGXINGZHY') 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 s.soft_id not in (select soft_id from diag_user_soft_center where user_id = :1 and serial_no = :2) 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 = :3 and u.order_status in (0, 1, 3) and u.serial_no = :4) and p.serial_no = :5 and p.pdt_state = 1 and p.user_id = :6 and t2.lan_id = :7 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 = :8 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 )mm left join diag_soft_desc t3 on mm.soft_id = t3.soft_id and t3.lan_id = :9 )
dx9uj64072dw7	select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
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
fdjtrdaz8hpvg	INSERT /+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a. flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
fqmpmkfr6pqyk	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
fsbqktj5vw6n9	select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g4gp07gt2z920	update sys.scheduler$_job set last_start_date = :1, running_instance = :2, running_slave = :3, job_status = :4 where obj# = :5
g4kcn01rx9d0m	SELECT COUNT() AS c from ( select m. from (select s.soft_id, t1.version_no, t1.creater_time, t4.soft_name as soft_desc, t2.remark, t2.version_detail_id, nvl(UPGRADE_PRICE, DEFAULT_BPRICE) as price, v.CUR_ID, t5.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_user_soft_center t3, diag_soft_desc t4, sys_currency_unit t5 where s.pdt_type_id = p.pdt_type_id and s.soft_id = pr.soft_id and v.cur_id = pr.cur_id and upper(s.soft_name) not like '%ZY' and t4.soft_id = s.soft_id and t4.lan_id = :1 and pr.cur_id = t5.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.user_id = :2 and t3.free_end_time < sysdate and p.serial_no = :3 and p.serial_no = t3.serial_no and p.pdt_state = 1 and p.user_id = :4 and t2.lan_id = :5 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 = :6 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 and not exists ( select 1 from ( 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 = :7 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 ) tr, ( select soft_id, info.version from user_order uo, order_detail_info info where uo.order_id = info.order_id and uo.order_status in (0, 1, 3) and uo.serial_no = :8 and uo.buy_origin = 1 and uo.user_id = :9 ) rt where tr.soft_id = rt.soft_id and tr.version_no = rt.version ) )
gfdn12rn0fg3m	SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :B1
gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /+ ORDERED / SUM(D.BYTES)/(10241024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(10241024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(10241024) BYTES FROM (SELECT /+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)

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	18	0.01	0.00
Batched IO (full) vector count	18	0.01	0.00
Batched IO block miss count	3,013	0.87	0.77
Batched IO buffer defrag count	13	0.00	0.00
Batched IO double miss count	1	0.00	0.00
Batched IO same unit count	201	0.06	0.05
Batched IO single block count	5	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	2,825	0.82	0.73
Batched IO vector read count	32	0.01	0.01
Block Cleanout Optim referenced	18	0.01	0.00
CCursor + sql area evicted	23	0.01	0.01
CPU used by this session	745,503	215.99	191.65
CPU used when call started	744,593	215.73	191.41
CR blocks created	89	0.03	0.02
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	49	0.01	0.01
DB time	3,905,021	1,131.39	1,003.86
DBWR checkpoint buffers written	3,820	1.11	0.98
DBWR checkpoints	22	0.01	0.01
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	248	0.07	0.06
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	152	0.04	0.04
DBWR undo block writes	618	0.18	0.16
DFO trees parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	11,250	3.26	2.89
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	127	0.04	0.03
Heap Segment Array Updates	86	0.02	0.02
IMU CR rollbacks	104	0.03	0.03
IMU Flushes	1,561	0.45	0.40
IMU Redo allocation size	4,224,060	1,223.82	1,085.88
IMU commits	2,385	0.69	0.61
IMU contention	282	0.08	0.07
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	3	0.00	0.00
IMU undo allocation size	8,752,584	2,535.85	2,250.02
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	17,669	5.12	4.54
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
RowCR - row contention	4	0.00	0.00
RowCR attempts	67	0.02	0.02
RowCR hits	63	0.02	0.02
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	3,107,787	900.41	798.92
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	283	0.08	0.07
application wait time	5,235	1.52	1.35
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	14,298	4.14	3.68
branch node splits	0	0.00	0.00
buffer is not pinned count	7,697,451	2,230.15	1,978.78
buffer is pinned count	17,059,675	4,942.64	4,385.52
bytes received via SQL*Net from client	252,797,478	73,242.09	64,986.50
bytes sent via SQL*Net to client	721,096,370	208,920.61	185,371.82
calls to get snapshot scn: kcmgss	1,240,331	359.36	318.85
calls to kcmgas	6,153	1.78	1.58
calls to kcmgcs	504,271	146.10	129.63
cell physical IO interconnect bytes	16,962,907,136	4,914,600.88	4,360,644.51
change write time	59	0.02	0.02
cleanout - number of ktugct calls	289	0.08	0.07
cleanouts and rollbacks - consistent read gets	7	0.00	0.00
cleanouts only - consistent read gets	10	0.00	0.00
cluster key scan block gets	2,278	0.66	0.59
cluster key scans	2,034	0.59	0.52
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	12	0.00	0.00
commit batch/immediate requested	12	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	7	0.00	0.00
commit cleanout failures: cannot pin	259	0.08	0.07
commit cleanouts	17,938	5.20	4.61
commit cleanouts successfully completed	17,672	5.12	4.54
commit immediate performed	12	0.00	0.00
commit immediate requested	12	0.00	0.00
commit txn count during cleanout	907	0.26	0.23
concurrency wait time	33,153	9.61	8.52
consistent changes	373	0.11	0.10
consistent gets	22,563,467	6,537.23	5,800.38
consistent gets - examination	3,422,629	991.63	879.85
consistent gets direct	2,011,474	582.78	517.09
consistent gets from cache	20,551,993	5,954.45	5,283.29
consistent gets from cache (fastpath)	16,904,631	4,897.72	4,345.66
cursor authentications	99	0.03	0.03
data blocks consistent reads - undo records applied	377	0.11	0.10
db block changes	63,375	18.36	16.29
db block gets	92,589	26.83	23.80
db block gets direct	126	0.04	0.03
db block gets from cache	92,463	26.79	23.77
db block gets from cache (fastpath)	26,617	7.71	6.84
deferred (CURRENT) block cleanout applications	12,060	3.49	3.10
dirty buffers inspected	0	0.00	0.00
enqueue conversions	902	0.26	0.23
enqueue deadlocks	0	0.00	0.00
enqueue releases	47,911	13.88	12.32
enqueue requests	47,924	13.88	12.32
enqueue timeouts	0	0.00	0.00
enqueue waits	57	0.02	0.01
exchange deadlocks	0	0.00	0.00
execute count	1,229,498	356.22	316.07
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	1,603,093,548	464,458.42	412,106.31
free buffer inspected	44,227	12.81	11.37
free buffer requested	38,897	11.27	10.00
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	181	0.05	0.05
hot buffers moved to head of LRU	16,576	4.80	4.26
immediate (CR) block cleanout applications	17	0.00	0.00
immediate (CURRENT) block cleanout applications	829	0.24	0.21
index crx upgrade (positioned)	6	0.00	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	93	0.03	0.02
index fetch by key	2,742,019	794.44	704.89
index scans kdiixs1	1,225,069	354.93	314.93
leaf node 90-10 splits	55	0.02	0.01
leaf node splits	78	0.02	0.02
lob reads	605	0.18	0.16
lob writes	12	0.00	0.00
lob writes unaligned	12	0.00	0.00
logons cumulative	294	0.09	0.08
max cf enq hold time	0	0.00	0.00
messages received	28,653	8.30	7.37
messages sent	28,653	8.30	7.37
min active SCN optimization applied on CR	7	0.00	0.00
no buffer to keep pinned count	64	0.02	0.02
no work - consistent read gets	18,528,820	5,368.29	4,763.19
non-idle wait count	3,436,817	995.74	883.50
non-idle wait time	438,036	126.91	112.61
opened cursors cumulative	1,227,949	355.77	315.67
parse count (describe)	0	0.00	0.00
parse count (failures)	2	0.00	0.00
parse count (hard)	223	0.06	0.06
parse count (total)	1,225,129	354.95	314.94
parse time cpu	991	0.29	0.25
parse time elapsed	8,215	2.38	2.11
physical read IO requests	48,494	14.05	12.47
physical read bytes	16,787,406,848	4,863,753.83	4,315,528.75
physical read total IO requests	54,030	15.65	13.89
physical read total bytes	16,878,313,472	4,890,091.87	4,338,898.06
physical read total multi block requests	15,936	4.62	4.10
physical reads	2,049,244	593.72	526.80
physical reads cache	37,770	10.94	9.71
physical reads cache prefetch	9,896	2.87	2.54
physical reads direct	2,011,474	582.78	517.09
physical reads direct (lob)	539	0.16	0.14
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	2,496	0.72	0.64
physical write bytes	32,325,632	9,365.59	8,309.93
physical write total IO requests	9,161	2.65	2.36
physical write total bytes	84,593,664	24,509.01	21,746.44
physical write total multi block requests	44	0.01	0.01
physical writes	3,946	1.14	1.01
physical writes direct	126	0.04	0.03
physical writes direct (lob)	1	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	3,820	1.11	0.98
physical writes non checkpoint	1,439	0.42	0.37
pinned buffers inspected	0	0.00	0.00
pinned cursors current	2	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	4,641	1.34	1.19
queries parallelized	0	0.00	0.00
recursive calls	618,117	179.08	158.90
recursive cpu usage	730	0.21	0.19
redo blocks checksummed by FG (exclusive)	16,431	4.76	4.22
redo blocks written	31,814	9.22	8.18
redo buffer allocation retries	0	0.00	0.00
redo entries	20,461	5.93	5.26
redo k-bytes read total	0	0.00	0.00
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	444	0.13	0.11
redo size	14,608,672	4,232.52	3,755.44
redo size for direct writes	1,036,728	300.37	266.51
redo subscn max counts	1,421	0.41	0.37
redo synch time	106,031	30.72	27.26
redo synch writes	4,156	1.20	1.07
redo wastage	1,054,016	305.38	270.96
redo write time	66,150	19.17	17.01
redo writes	4,456	1.29	1.15
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	34	0.01	0.01
rollbacks only - consistent read gets	92	0.03	0.02
root node splits	0	0.00	0.00
rows fetched via callback	2,131,687	617.61	547.99
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	1,014,966	294.06	260.92
session logical reads	22,656,056	6,564.06	5,824.18
shared hash latch upgrades - no wait	108,215	31.35	27.82
shared hash latch upgrades - wait	7	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	67,826	19.65	17.44
sorts (rows)	3,403,989	986.23	875.06
sql area evicted	242	0.07	0.06
sql area purged	2	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	180	0.05	0.05
table fetch by rowid	10,520,741	3,048.14	2,704.56
table fetch continued row	90,552	26.24	23.28
table scan blocks gotten	12,190,327	3,531.86	3,133.76
table scan rows gotten	1,248,918,757	361,844.65	321,058.81
table scans (direct read)	78	0.02	0.02
table scans (long tables)	689	0.20	0.18
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	185,543	53.76	47.70
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	18,650	5.40	4.79
total number of cf enq holders	240	0.07	0.06
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	12	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	3,789,600	1,097.95	974.19
user I/O wait time	154,685	44.82	39.76
user calls	4,316,889	1,250.72	1,109.74
user commits	3,886	1.13	1.00
user rollbacks	4	0.00	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	71,907	20.83	18.49
write clones created in background	0	0.00	0.00
write clones created in foreground	33	0.01	0.01

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,262,814,757,048	1,263,365,716,816
session pga memory	400,626,849,424	400,791,229,416
session pga memory max	451,109,873,904	451,258,867,304
session cursor cache count	11,764,838	11,772,490
session uga memory	704,301,310,874,448	704,576,210,686,704
opened cursors current	368	414
workarea memory allocated	1,724	2,980
logons current	102	117

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	15.3G	5.12	4.55275	0M	0.00	0M	17.7K	1.45
Buffer Cache Reads	295M	8.93	.085469	0M	0.00	0M	27.9K	45.34
Others	86M	1.60	.024916	34M	0.64	.009850	7733	98.07
DBWR	0M	0.00	0M	30M	0.72	.008691	885	372.66
LGWR	0M	0.00	0M	15M	1.29	.004345	4456	147.91
Direct Writes	0M	0.00	0M	1M	0.00	.000289	13	0.00
TOTAL:	15.7G	15.66	4.66314	80M	2.65	.023178	58.7K	51.79

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	15.6G	14.05	4.63880	28M	0.72	.008112	39.28	0.75
Control File	87M	1.60	.025206	34M	0.64	.009850	0.81
Log File	0M	0.00	0M	16M	1.30	.004635
TOTAL:	15.7G	15.65	4.66401	78M	2.65	.022598	33.70	0.75

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	15.3G	5.12	4.55275	0M	0.00	0M	0
Direct Reads (Data File)	15.3G	5.12	4.55275	0M	0.00	0M	0
Buffer Cache Reads	295M	8.93	.085469	0M	0.00	0M	27.8K	45.44
Buffer Cache Reads (Data File)	295M	8.93	.085469	0M	0.00	0M	27.8K	45.44
Others	86M	1.60	.024916	34M	0.64	.009850	5537	0.81
Others (Control File)	86M	1.60	.024916	34M	0.64	.009850	5527	0.81
Others (Data File)	0M	0.00	0M	0M	0.00	0M	10	0.20
DBWR	0M	0.00	0M	30M	0.72	.008691	0
DBWR (Data File)	0M	0.00	0M	30M	0.72	.008691	0
LGWR	0M	0.00	0M	16M	1.30	.004635	0
LGWR (Log File)	0M	0.00	0M	16M	1.30	.004635	0
Direct Writes	0M	0.00	0M	1M	0.00	.000289	0
Direct Writes (Data File)	0M	0.00	0M	1M	0.00	.000289	0
TOTAL:	15.7G	15.66	4.66314	81M	2.65	.023467	33.4K	38.04

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	Buffer Waits	Av Buf Wt(ms)
MYCAR	45,567	13	27.82	44.91	1,469	4,824	46.60
SYSTEM	2,839	1	0.48	1.00	78	0	0.00
SYSAUX	72	0	11.11	1.04	559	0	0.00
UNDOTBS1	0	0	0.00	0.00	323	1	0.00
PASSPORT	14	0	220.00	1.00	67	0	0.00

Back to IO Stats

Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
MYCAR	/oracle/oradata/mycar/mycar.dbf	42,725	12	29.34	42.58	511	4,716	47.03
MYCAR	/oracle/oradata/mycar/mycar01.dbf	2,842	1	4.96	79.97	958	108	27.69
PASSPORT	/oracle/oradata/mycar/passport.dbf	14	0	220.00	1.00	67	0	0.00
SYSAUX	/oracle/oradata/mycar/sysaux01.dbf	72	0	11.11	1.04	559	0	0.00
SYSTEM	/oracle/oradata/mycar/system01.dbf	2,839	1	0.48	1.00	78	0	0.00
UNDOTBS1	/oracle/oradata/mycar/undotbs01.dbf	0	0			323	1	0.00

Back to IO Stats

Back to Top

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle

Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	96,530	100	20,643,530	37,775	3,820	0	0	4,825

Back to Buffer Pool Statistics

Back to Top

Checkpoint Activity

Total Physical Writes: 3,946

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	3,572	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	366	1665	5351	995328	5351
E	0	14	761	12218	23062	995328	23062

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.67	2,619,325	1	1332310.00
D	160	0.20	20	1.02	1,591,052	1	61015.00
D	240	0.30	30	1.00	1,570,724	1	35883.00
D	320	0.40	39	1.00	1,566,725	1	30938.00
D	400	0.50	49	1.00	1,566,098	1	30164.00
D	480	0.60	59	1.00	1,565,670	1	29634.00
D	560	0.70	69	1.00	1,565,378	1	29273.00
D	640	0.80	79	1.00	1,565,097	1	28926.00
D	720	0.90	89	1.00	1,564,862	1	28636.00
D	800	1.00	99	1.00	1,564,683	1	28414.00
D	880	1.10	108	1.00	1,564,500	1	28188.00
D	960	1.20	118	1.00	1,564,338	1	27987.00
D	1,040	1.30	128	1.00	1,564,223	1	27845.00
D	1,120	1.40	138	1.00	1,564,138	1	27741.00
D	1,200	1.50	148	1.00	1,564,068	1	27653.00
D	1,280	1.60	158	1.00	1,563,993	1	27561.00
D	1,360	1.70	167	1.00	1,563,333	1	26745.00
D	1,440	1.80	177	0.97	1,513,773	1	8334.00
D	1,520	1.90	187	0.96	1,502,537	1	8331.00
D	1,600	2.00	197	0.92	1,439,839	1	8314.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	10,878	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	54,357	54,357
64K	128K	3,446	3,446
128K	256K	1,958	1,958
256K	512K	58	58
512K	1024K	11,475	11,475
1M	2M	550	550
2M	4M	51	51
4M	8M	12	12

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	24,946,143.07	52,492,447.74	32.00	364,978	91,329,156,593
284	0.25	24,946,143.07	52,330,706.68	32.00	360,841	91,138,403,190
568	0.50	24,946,143.07	13,323,513.83	65.00	9	45,134,285,775
852	0.75	24,946,143.07	12,959,882.21	66.00	0	44,705,427,649
1,136	1.00	24,946,143.07	12,103,143.67	67.00	0	43,695,011,420
1,363	1.20	24,946,143.07	11,942,180.47	68.00	0	43,505,175,417
1,590	1.40	24,946,143.07	11,942,030.65	68.00	0	43,504,998,719
1,818	1.60	24,946,143.07	11,941,919.73	68.00	0	43,504,867,898
2,045	1.80	24,946,143.07	11,941,919.73	68.00	0	43,504,867,898
2,272	2.00	24,946,143.07	11,941,919.73	68.00	0	43,504,867,898
3,408	3.00	24,946,143.07	11,941,919.73	68.00	0	43,504,867,898
4,544	4.00	24,946,143.07	11,941,760.14	68.00	0	43,504,679,682
6,816	6.00	24,946,143.07	11,941,760.14	68.00	0	43,504,679,682
9,088	8.00	24,946,143.07	11,941,760.14	68.00	0	43,504,679,682

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	48	2,738	6,992,799	1.00	231,909	1.08	126,062
880	0.70	176	8,949	6,997,655	1.00	227,053	1.06	337,899
1,008	0.80	304	13,397	7,006,626	1.00	218,082	1.02	338,518
1,136	0.90	432	17,862	7,008,614	1.00	216,094	1.01	338,780
1,264	1.00	560	21,564	7,010,210	1.00	214,498	338,998
1,392	1.10	688	24,829	7,011,558	1.00	213,150	0.99	339,187
1,520	1.20	815	28,212	7,012,311	1.00	212,397	0.99	339,298
1,648	1.30	943	31,207	7,012,663	1.00	212,045	0.99	339,347
1,776	1.41	1,071	34,727	7,013,001	1.00	211,707	0.99	339,380
1,904	1.51	1,199	37,796	7,013,233	1.00	211,475	0.99	339,398
2,032	1.61	1,327	40,939	7,013,418	1.00	211,290	0.99	339,413
2,160	1.71	1,455	45,104	7,013,557	1.00	211,151	0.98	339,423
2,288	1.81	1,583	49,129	7,013,700	1.00	211,008	0.98	339,433
2,416	1.91	1,711	52,551	7,013,825	1.00	210,883	0.98	339,442
2,544	2.01	1,839	55,839	7,013,896	1.00	210,812	0.98	339,449

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	5,975,001	1,570,002,873
1,608	0.75	5,953,585	1,565,465,292
2,144	1.00	5,948,826	1,564,682,951
2,680	1.25	5,931,574	1,501,939,165
3,216	1.50	5,927,410	1,513,048,414
3,752	1.75	5,926,220	1,513,048,414
4,288	2.00	5,926,220	1,439,195,378

Back to Advisory Statistics

Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	0.50	0	0	0	0
32	1.00	0	0	0	0
48	1.50	0	0	0	0
64	2.00	0	0	0	0
80	2.50	0	0	0	0
96	3.00	0	0	0	0
112	3.50	0	0	0	0
128	4.00	0	0	0	0
144	4.50	0	0	0	0
160	5.00	0	0	0	0
176	5.50	0	0	0	0
192	6.00	0	0	0	0
208	6.50	0	0	0	0
224	7.00	0	0	0	0
240	7.50	0	0	0	0
256	8.00	0	0	0	0
272	8.50	0	0	0	0
288	9.00	0	0	0	0
304	9.50	0	0	0	0
320	10.00	0	0	0	0

Back to Advisory Statistics

Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics

Back to Top

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Back to Top

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	4,824	225	47
undo header	1	0	0

Back to Wait Statistics

Back to Top

Enqueue Activity

only enqueues with waits are shown

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

ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Wt Time (s)	Av Wt Time(ms)
KO-Multiple Object Checkpoint (fast object checkpoint)	198	198	22	51	2,311.82
CF-Controlfile Transaction	1,510	1,510	2	3	1,615.00
TX-Transaction (index contention)	13	13	10	3	309.00
TX-Transaction (row lock contention)	15	15	13	1	114.62
SQ-Sequence Cache	790	790	10	0	0.00

Back to Wait Statistics

Back to Top

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Back to Top

Undo Segment Summary

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

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

Undo segment block stats:

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

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	0.27	2,833	795	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
04-Jul 14:50	89	732	795	3	240	0/0	0/0/0/0/0/0
04-Jul 14:40	46	618	125	2	240	0/0	0/0/0/0/0/0
04-Jul 14:30	51	454	788	4	240	0/0	0/0/0/0/0/0
04-Jul 14:20	64	841	185	2	240	0/0	0/0/0/0/0/0
04-Jul 14:10	18	188	781	3	240	0/0	0/0/0/0/0/0

Back to Undo Statistics

Back to Top

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Back to Top

Latch Activity

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

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

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	3	0.00		0	0
ASM db client latch	2,178	0.00		0	0
ASM map operation hash table	3	0.00		0	0
ASM network state latch	60	0.00		0	0
AWR Alerted Metric Element list	29,995	0.00		0	0
Change Notification Hash table latch	1,136	0.00		0	0
Consistent RBA	4,456	0.00		0	0
DML lock allocation	108,362	0.00		0	0
Event Group Locks	233	0.00		0	0
FAL Queue	157	0.00		0	0
FOB s.o list latch	923	0.00		0	0
File State Object Pool Parent Latch	3	0.00		0	0
IPC stats buffer allocation latch	3	0.00		0	0
In memory undo latch	37,018	0.02	0.89	0	4,679	0.00
JS Sh mem access	11	0.00		0	0
JS mem alloc latch	6	0.00		0	0
JS queue access latch	9	0.00		0	0
JS queue state obj latch	23,722	0.00		0	0
JS slv state obj latch	1,360,862	0.35	0.00	0	0
KFC FX Hash Latch	3	0.00		0	0
KFC Hash Latch	3	0.00		0	0
KFCL LE Freelist	3	0.00		0	0
KGNFS-NFS:SHM structure	3	0.00		0	0
KGNFS-NFS:SVR LIST	3	0.00		0	0
KJC message pool free list	3	0.00		0	0
KJCT flow control latch	3	0.00		0	0
KMG MMAN ready and startup request latch	1,150	0.00		0	0
KTF sga latch	18	0.00		0	898	0.00
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	5	0.00		0	0
KWQS pqueue ctx latch	66	0.00		0	0
Locator state objects pool parent latch	3	0.00		0	0
Lsod array latch	3	0.00		0	0
MQL Tracking Latch	0			0	68	0.00
Memory Management Latch	3	0.00		0	1,150	0.00
Memory Queue	3	0.00		0	0
Memory Queue Message Subscriber #1	3	0.00		0	0
Memory Queue Message Subscriber #2	3	0.00		0	0
Memory Queue Message Subscriber #3	3	0.00		0	0
Memory Queue Message Subscriber #4	3	0.00		0	0
Memory Queue Subscriber	3	0.00		0	0
MinActiveScn Latch	17	0.00		0	0
Mutex	3	0.00		0	0
Mutex Stats	3	0.00		0	0
OS process	1,416	0.00		0	0
OS process allocation	2,081	0.00		0	0
OS process: request allocation	445	0.00		0	0
PL/SQL warning settings	490	0.00		0	0
PX hash array latch	3	0.00		0	0
QMT	3	0.00		0	0
Real-time plan statistics latch	3,857	0.00		0	0
SGA IO buffer pool latch	1	0.00		0	1	0.00
SGA blob parent	3	0.00		0	0
SGA bucket locks	3	0.00		0	0
SGA heap locks	3	0.00		0	0
SGA pool locks	3	0.00		0	0
SQL memory manager latch	115	0.00		0	1,030	0.00
SQL memory manager workarea list latch	338,794	0.00		0	0
Shared B-Tree	300	0.00		0	0
Streams Generic	3	0.00		0	0
Testing	3	0.00		0	0
Token Manager	3	0.00		0	0
WCR: sync	3	0.00		0	0
Write State Object Pool Parent Latch	3	0.00		0	0
X$KSFQP	2,332	0.00		0	0
XDB NFS Security Latch	3	0.00		0	0
XDB unused session pool	3	0.00		0	0
XDB used session pool	3	0.00		0	0
active checkpoint queue latch	24,700	0.00		0	0
active service list	7,968	0.01	0.00	0	3,481	0.00
archive control	58	0.00		0	0
archive process latch	471	0.42	1.00	0	0
begin backup scn array	13	0.00		0	0
buffer pool	3	0.00		0	0
business card	3	0.00		0	0
cache buffer handles	18,148	0.00		0	0
cache buffers chains	38,203,809	0.02	0.02	29	881,259	0.00
cache buffers lru chain	4,250	0.02	1.00	0	7,162,120	0.01
cache table scan latch	3,191	0.00		0	3,191	0.00
call allocation	1,259	0.32	0.50	0	0
cas latch	3	0.00		0	0
change notification client cache latch	3	0.00		0	0
channel handle pool latch	501	0.00		0	0
channel operations parent latch	16,830	0.00		0	0
checkpoint queue latch	463,114	0.00		0	4,083	0.00
client/application info	2,144	0.00		0	0
compile environment latch	294	0.00		0	0
corrupted undo seg latch	114	0.00		0	0
cp cmon/server latch	3	0.00		0	0
cp pool latch	3	0.00		0	0
cp server hash latch	3	0.00		0	0
cp sga latch	60	0.00		0	0
cvmap freelist lock	3	0.00		0	0
deferred cleanup latch	60	0.00		0	0
dml lock allocation	60	0.00		0	0
done queue latch	3	0.00		0	0
dummy allocation	576	0.00		0	0
enqueue hash chains	96,848	0.00	0.00	0	17	0.00
enqueues	57,027	0.01	0.00	0	0
fifth spare latch	3	0.00		0	0
file cache latch	259	0.00		0	0
flashback copy	3	0.00		0	0
gc element	3	0.00		0	0
gcs commit scn state	3	0.00		0	0
gcs partitioned table hash	3	0.00		0	0
gcs pcm hashed value bucket hash	3	0.00		0	0
gcs resource freelist	3	0.00		0	0
gcs resource hash	3	0.00		0	0
gcs resource scan list	3	0.00		0	0
gcs shadows freelist	3	0.00		0	0
ges domain table	3	0.00		0	0
ges enqueue table freelist	3	0.00		0	0
ges group table	3	0.00		0	0
ges process hash list	3	0.00		0	0
ges process parent latch	3	0.00		0	0
ges resource hash list	3	0.00		0	0
ges resource scan list	3	0.00		0	0
ges resource table freelist	3	0.00		0	0
ges value block free list	3	0.00		0	0
global KZLD latch for mem in SGA	100	0.00		0	0
global tx hash mapping	3	0.00		0	0
granule operation	3	0.00		0	0
hash table column usage latch	195	0.00		0	161,080	0.00
hash table modification latch	97	0.00		0	0
heartbeat check	3	0.00		0	0
intra txn parallel recovery	3	0.00		0	0
io pool granule metadata list	3	0.00		0	0
job workq parent latch	67	0.00		0	64	0.00
job_queue_processes free list latch	132	0.00		0	0
job_queue_processes parameter latch	775	0.00		0	0
k2q lock allocation	3	0.00		0	0
kdlx hb parent latch	3	0.00		0	0
kgb parent	3	0.00		0	0
kks stats	1,642	0.00		0	0
kokc descriptor allocation latch	498	0.00		0	0
ksfv messages	3	0.00		0	0
kss move lock	37	0.00		0	0
ksuosstats global area	234	0.00		0	0
ksv allocation latch	129	0.00		0	0
ksv class latch	73	0.00		0	0
ksv msg queue latch	3	0.00		0	0
ksz_so allocation latch	445	0.00		0	0
ktm global data	17	0.00		0	0
kwqbsn:qsga	126	0.00		0	0
lgwr LWN SCN	5,282	0.00		0	0
list of block allocation	543	0.00		0	0
loader state object freelist	1,210	0.00		0	0
lob segment dispenser latch	3	0.00		0	0
lob segment hash table latch	13	0.00		0	0
lob segment query latch	3	0.00		0	0
lock DBA buffer during media recovery	3	0.00		0	0
logical standby cache	3	0.00		0	0
logminer context allocation	4	0.00		0	0
logminer work area	3	0.00		0	0
longop free list parent	4	0.00		0	1	0.00
managed standby latch	157	0.00		0	0
mapped buffers lru chain	3	0.00		0	0
message pool operations parent latch	183	0.00		0	0
messages	91,465	0.00	0.00	0	0
mostly latch-free SCN	5,281	0.02	0.00	0	0
msg queue latch	3	0.00		0	0
multiblock read objects	13,444	0.00		0	0
name-service namespace bucket	3	0.00		0	0
ncodef allocation latch	60	0.00		0	0
object queue header heap	76	0.00		0	5	0.00
object queue header operation	283,355	0.00	1.00	0	0
object stats modification	12	0.00		0	0
parallel query alloc buffer	443	0.00		0	0
parallel query stats	3	0.00		0	0
parameter list	353	0.00		0	0
parameter table management	576	0.00		0	0
peshm	3	0.00		0	0
pesom_free_list	3	0.00		0	0
pesom_hash_node	3	0.00		0	0
post/wait queue	14,229	0.01	0.00	0	12,210	0.01
process allocation	573	0.00		0	230	0.00
process group creation	445	0.00		0	0
process queue	3	0.00		0	0
process queue reference	3	0.00		0	0
qmn task queue latch	875	0.00		0	0
query server freelists	3	0.00		0	0
queued dump request	11	0.00		0	0
queuing load statistics	3	0.00		0	0
recovery domain hash list	3	0.00		0	0
redo allocation	24,350	0.02	0.20	0	20,543	0.04
redo copy	3	0.00		0	20,547	0.06
redo writing	40,120	0.00		0	0
resmgr group change latch	469	0.00		0	0
resmgr:active threads	574	0.00		0	0
resmgr:actses change group	186	0.00		0	0
resmgr:actses change state	3	0.00		0	0
resmgr:free threads list	573	0.00		0	0
resmgr:plan CPU method	3	0.00		0	0
resmgr:resource group CPU method	3	0.00		0	0
resmgr:schema config	81	0.00		0	0
resmgr:session queuing	3	0.00		0	0
rm cas latch	3	0.00		0	0
row cache objects	1,130,553	0.01	0.12	1	152	0.00
rules engine rule set statistics	100	0.00		0	0
second spare latch	3	0.00		0	0
sequence cache	25,560	0.00		0	0
session allocation	1,549,458	0.00	0.00	0	516,495	0.00
session idle bit	9,149,773	0.00	0.01	0	0
session queue latch	3	0.00		0	0
session state list latch	651	0.00		0	0
session switching	1,138	0.00		0	0
session timer	1,257	0.00		0	0
shared pool	38,973	0.28	0.15	8	0
shared pool sim alloc	3	0.00		0	0
shared pool simulator	2,338	0.00		0	0
sim partition latch	3	0.00		0	0
simulator hash latch	2,291,952	0.00	0.00	0	0
simulator lru latch	1,729	0.00		0	1,510,529	0.06
sort extent pool	96	0.00		0	0
space background state object latch	4	0.00		0	0
space background task latch	2,248	0.00		0	2,294	0.00
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	3	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
test excl. parent l0	3	0.00		0	0
test excl. parent2 l0	3	0.00		0	0
third spare latch	3	0.00		0	0
threshold alerts latch	164	0.00		0	0
transaction allocation	21,361	0.00		0	0
undo global data	25,765	0.00		0	0
virtual circuit buffers	3	0.00		0	0
virtual circuit holder	3	0.00		0	0
virtual circuit queues	3	0.00		0	0

Back to Latch Statistics

Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	38,203,809	8,943	155	8,792
JS slv state obj latch	1,360,862	4,772	4	0
session idle bit	9,149,773	395	5	390
shared pool	38,973	109	16	95
row cache objects	1,130,553	67	8	59
In memory undo latch	37,018	9	8	1
redo allocation	24,350	5	1	4
call allocation	1,259	4	2	2
archive process latch	471	2	2	0
cache buffers lru chain	4,250	1	1	0
object queue header operation	283,355	1	1	0

Back to Latch Statistics

Back to Top

Latch Miss Sources

only latches with sleeps are shown

ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	7	3
In memory undo latch	kticmt: child	1	2
archive process latch	kcrrgpll	2	1
cache buffers chains	kcbgtcr: fast path (cr pin)	73	83
cache buffers chains	kcbgtcr_2	38	25
cache buffers chains	kcbrls_1	33	42
cache buffers chains	kcbgtcr: fast path	13	10
cache buffers chains	kcbzwb	4	0
cache buffers chains	kcbrls_2	3	3
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	1	0
cache buffers chains	kcbgcur_2	1	0
cache buffers lru chain	kcbzgws	1	0
call allocation	ksudlp: top call	1	0
call allocation	ksuxds	1	1
object queue header operation	kcbo_service_ockpt	1	7
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
row cache objects	kqreqd: reget	6	0
row cache objects	kqrpre: find obj	2	8
session idle bit	ksupuc: clear busy	4	4
session idle bit	ksupuc: set busy	3	2
shared pool	kghalo	12	6
shared pool	kghupr1	2	1
shared pool	kghalp	1	0
shared pool	kghfre	1	9

Back to Latch Statistics

Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Cursor Pin	kksfbc [KKSCHLPIN1]	7	0
Library Cache	kgllkdl1 85	4	480
Cursor Stat	kkocsStoreBindAwareStats [KKSSTALOC8]	3	0
Library Cache	kglIsOwnerVersionable 121	2	850
Library Cache	kglpin1 4	2	0
Cursor Pin	kksLockDelete [KKSCHLPIN6]	2	0
Library Cache	kglhdgn2 106	1	4,141
Library Cache	kgllkc1 57	1	44

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: 22,656,056

Captured Segments account for 95.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	7,116,848	31.41
MYCAR	MYCAR	IDX_LIN	INDEX	3,300,752	14.57
MYCAR	MYCAR	DIAG_SOFT_DESC	TABLE	1,507,008	6.65
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	1,424,784	6.29
MYCAR	MYCAR	SYS_SOFT_CONF	TABLE	1,112,320	4.91

Back to Segment Statistics

Back to Top

Segments by Physical Reads

Total Physical Reads: 2,049,244

Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	1,411,454	68.88
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	613,148	29.92
MYCAR	MYCAR	DF_DATA_STREAM_DESC	TABLE	13,307	0.65
MYCAR	MYCAR	I_STREAM_VERSION_DETAIL_ID	INDEX	7,060	0.34
MYCAR	MYCAR	OPERATE_LOG	TABLE	269	0.01

Back to Segment Statistics

Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 48,494

Captured Segments account for 92.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
MYCAR	MYCAR	DF_DATA_STREAM_DESC	TABLE	13,307	27.44
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	12,437	25.65
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	11,418	23.55
MYCAR	MYCAR	I_STREAM_VERSION_DETAIL_ID	INDEX	7,060	14.56
MYCAR	MYCAR	OPERATE_LOG	TABLE	269	0.55

Back to Segment Statistics

Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 48,494

Captured Segments account for 92.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
MYCAR	MYCAR	DF_DATA_STREAM_DESC	TABLE	13,307	27.44
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	12,437	25.65
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	11,418	23.55
MYCAR	MYCAR	I_STREAM_VERSION_DETAIL_ID	INDEX	7,060	14.56
MYCAR	MYCAR	OPERATE_LOG	TABLE	269	0.55

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: 2,011,474

Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD		TABLE	1,411,454	70.17
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER		TABLE	599,480	29.80

Back to Segment Statistics

Back to Top

Segments by Physical Writes

Total Physical Writes: 3,946

Captured Segments account for 41.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
MYCAR	MYCAR	OPERATE_LOG		TABLE	521	13.20
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD		TABLE	161	4.08
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER		TABLE	155	3.93
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1652681432_9713	TABLE PARTITION	139	3.52
MYCAR	MYCAR	IND_DIAG_DOWNLOAD_RECORD		INDEX	125	3.17

Back to Segment Statistics

Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 2,496

Captured Segments account for 36.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
MYCAR	MYCAR	OPERATE_LOG	TABLE	238	9.54
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	143	5.73
MYCAR	MYCAR	SYS_PRODUCT	TABLE	84	3.37
MYCAR	MYCAR	IND_DIAG_DOWNLOAD_RECORD	INDEX	82	3.29
MYCAR	MYCAR	SYS_USER	TABLE	37	1.48

Back to Segment Statistics

Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 126

Captured Segments account for 99.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1652681432_9713	TABLE PARTITION	125	99.21

Back to Segment Statistics

Back to Top

Segments by Table Scans

Total Table Scans: 782

Captured Segments account for 90.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	667	85.29
MYCAR	MYCAR	DIAG_DOWNLOAD_RECORD	TABLE	22	2.81
MYCAR	MYCAR	PK_SYS_LAN	INDEX	10	1.28
MYCAR	MYCAR	PK_DIAG_SOFT_VERSION_DETAIL	INDEX	5	0.64
MYCAR	MYCAR	CO_PRIVATE_UNIFIED_ID	INDEX	4	0.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	3,024	33.81
MYCAR	MYCAR	DIAG_USER_SOFT_CENTER	TABLE	1,360	15.21
MYCAR	MYCAR	SOFTIDUSERIDSERIALNO_UNIQUE	INDEX	1,248	13.95
MYCAR	MYCAR	PK_DIAG_USER_SOFT_CENTER	INDEX	944	10.55
MYCAR	MYCAR	PK_DIAG_DOWNLOAD_RECORD	INDEX	592	6.62

Back to Segment Statistics

Back to Top

Segments by Row Lock Waits

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

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
MYCAR	MYCAR	SYS_USER		TABLE	14	51.85
MYCAR	MYCAR	PK_DIAG_DOWNLOAD_RECORD		INDEX	13	48.15

Back to Segment Statistics

Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

Segments by Buffer Busy Waits

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

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
MYCAR	MYCAR	PK_DIAG_DOWNLOAD_RECORD		INDEX	7	58.33
MYCAR	MYCAR	SYS_USER		TABLE	5	41.67

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	64	0.00	2	1
dc_files	9	0.00	0	9
dc_global_oids	536	0.00	0	61
dc_histogram_data	6,447	0.00	0	4,864
dc_histogram_defs	7,117	1.46	0	6,340
dc_objects	6,817	0.06	5	3,141
dc_profiles	166	0.00	0	1
dc_rollback_segments	825	0.00	0	22
dc_segments	3,176	0.00	17	1,596
dc_sequences	781	0.00	781	43
dc_tablespaces	169,521	0.00	0	10
dc_users	184,488	0.00	0	173
global database name	2,451	0.00	0	2
outstanding_alerts	42	0.00	0	7
sch_lj_oids	6	33.33	0	16

Back to Top

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,105	0.00	1,574	0.00	0	0
CLUSTER	69	0.00	20	0.00	0	0
DBLINK	204	0.00	0		0	0
EDITION	181	0.00	345	0.00	0	0
INDEX	9	0.00	9	0.00	0	0
QUEUE	60	0.00	190	0.00	0	0
SCHEMA	312	0.00	0		0	0
SQL AREA	15,085	2.56	1,247,097	0.04	78	2
SUBSCRIPTION	11	0.00	11	0.00	0	0
TABLE/PROCEDURE	5,117	0.12	30,311	0.18	22	0
TRIGGER	18	0.00	58	0.00	0	0

Back to Top

Memory Statistics

Memory Dynamic Components

Memory Resize Operations Summary

Memory Resize Ops

Process Memory Summary

SGA Memory Summary

SGA breakdown difference

Back to Top

Memory Dynamic Components

Min/Max sizes since instance startup

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

ordered by Component

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

Back to Memory Statistics

Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics

Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics

Back to Top

Process Memory Summary

B: Begin Snap E: End Snap

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

Max Alloc is Maximum PGA Allocation size at snapshot time

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

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	391.81		3.77	7.80	28	32	104	104
	Freeable	57.06	0.00	1.04	0.68	4		55	55
	SQL	1.63	1.03	0.02	0.02	0	41	82	76
	PL/SQL	1.23	0.98	0.01	0.03	0	0	102	102
E	Other	407.75		3.43	7.34	28	32	119	119
	Freeable	73.25	0.00	1.11	0.63	4		66	66
	SQL	3.70	3.01	0.04	0.14	1	41	96	89
	PL/SQL	1.60	1.26	0.01	0.02	0	1	117	117

Back to Memory Statistics

Back to Top

SGA Memory Summary

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

Back to Memory Statistics

Back to Top

SGA breakdown difference

ordered by Pool, Name

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	7.50	7.50	0.00
large	free memory	8.50	8.50	0.00
shared	CCUR	87.09	87.33	0.27
shared	FileOpenBlock	15.20	15.20	0.00
shared	KGLHD	26.63	26.47	-0.62
shared	KGLS	17.26	17.15	-0.65
shared	PCUR	76.12	76.06	-0.08
shared	PLMCD	13.22	12.93	-2.20
shared	SQLA	486.56	488.47	0.39
shared	free memory	335.52	334.37	-0.34
streams	KTG hash buckets	1.26	1.26	0.00
streams	free memory	30.72	30.72	0.00
	buffer_cache	784.00	784.00	0.00
	fixed_sga	2.12	2.12	0.00
	log_buffer	15.23	15.23	0.00

Back to Memory Statistics

Back to Top

Streams Statistics

Streams CPU/IO Usage

Streams Capture

Streams Capture Rate

Streams Apply

Streams Apply Rate

Buffered Queues

Buffered Queue Subscribers

Rule Set

Persistent Queues

Persistent Queues Rate

Persistent Queue Subscribers

Back to Top

Streams CPU/IO Usage

Streams processes ordered by Foreground CPU Time, descending

Session Type	First Logon	Foreground CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	0326 18:10:23	0.00	0.00	0.00
QMON Slaves	0326 18:10:33	0.00	0.00	0.00

Back to Streams Statistics

Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

Persistent Queues

Ordered by Queue Name

* indicates queue (re)started between Begin/End snaps

%Exp Msgs - % of msgs enqueued with expiry

%Delay Msgs - % of msgs enqueued with delay

%Trasf Time - % of Enqueue time spent in transformation

%Eval Time - % of Enqueue time spent in rule evaluation

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(12343)	0	0			0.00	0.00
SYS.AQ$_ALERT_QT_E(12342)	0	0			0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(66903)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(66573)	51	51	0.00	0.00	0.02	0.08	0.00	0.00

Back to Streams Statistics

Back to Top

Persistent Queues Rate

Ordered by Queue Name

* indicates queue (re)started between Begin/End snaps

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
SYS.ALERT_QUE(12343)	0.00	0.00
SYS.AQ$_ALERT_QT_E(12342)	0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(66903)	0.00	0.00
SYSMAN.MGMT_TASK_Q(66573)	0.01	0.01	0.00	0.00

Back to Streams Statistics

Back to Top

Persistent Queue Subscribers

Ordered by Queue Name, Subscriber Name

* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enqueue Msgs	Dequeue Msgs	Expire Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0
VM19216800003_3938_MYCAR(22)/SYS.ALERT_QUE	0	0	0	0.00	0.00	0.00

Back to Streams Statistics

Back to Top

Resource Limit Stats

No data exists for this section of the report.

Back to Top

Shared Server Statistics

Shared Servers Activity

Shared Servers Rates

Shared Servers Utilization

Shared Servers Common Queue

Shared Servers Dispatchers

Back to Top

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics

Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics

Back to Top

Shared Servers Utilization

Statistics are combined for all servers

Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
3,462	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,462	0.00	100.00	0	0

Back to Shared Server Statistics

Back to Top

init.ora Parameters

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

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

ITPub博客

awrrpt_1_9716_9717.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