WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ZDCOMORA 996850667 zdcomora1 1 10.2.0.1.0 YES ora01

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ZDCOMORA	996850667	zdcomora1	1	10.2.0.1.0	YES	ora01

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 2499 02-Aug-12 08:00:29 72 4.9

End Snap: 2500 02-Aug-12 09:00:52 53 4.4

Elapsed: 60.39 (mins)

DB Time: 1,901.42 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2499	02-Aug-12 08:00:29	72	4.9
End Snap:	2500	02-Aug-12 09:00:52	53	4.4
Elapsed:		60.39 (mins)
DB Time:		1,901.42 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 6,816M 6,816M Std Block Size: 8K

Shared Pool Size: 2,592M 2,592M Log Buffer: 14,392K

	Begin	End
Buffer Cache:	6,816M	6,816M	Std Block Size:	8K
Shared Pool Size:	2,592M	2,592M	Log Buffer:	14,392K

Load Profile

Per Second Per Transaction

Redo size: 20,111.05 1,358.27

Logical reads: 13,606.17 918.94

Block changes: 102.18 6.90

Physical reads: 14.32 0.97

Physical writes: 5.78 0.39

User calls: 74.50 5.03

Parses: 33.50 2.26

Hard parses: 20.38 1.38

Sorts: 1.60 0.11

Logons: 0.11 0.01

Executes: 24.10 1.63

Transactions: 14.81

	Per Second	Per Transaction
Redo size:	20,111.05	1,358.27
Logical reads:	13,606.17	918.94
Block changes:	102.18	6.90
Physical reads:	14.32	0.97
Physical writes:	5.78	0.39
User calls:	74.50	5.03
Parses:	33.50	2.26
Hard parses:	20.38	1.38
Sorts:	1.60	0.11
Logons:	0.11	0.01
Executes:	24.10	1.63
Transactions:	14.81

% Blocks changed per Read: 0.75 Recursive Call %: 52.80

Rollback per transaction %: 1.11 Rows per Sort: ########

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

Buffer Hit %: 99.89 In-memory Sort %: 100.00

Library Hit %: 74.93 Soft Parse %: 39.16

Execute to Parse %: -39.03 Latch Hit %: 99.73

Parse CPU to Parse Elapsd %: 22.06 % Non-Parse CPU: 89.38

Shared Pool Statistics

Begin End

Memory Usage %: 90.16 91.25

% SQL with executions>1: 59.40 47.68

% Memory for SQL w/exec>1: 50.89 41.83

	Begin	End
Memory Usage %:	90.16	91.25
% SQL with executions>1:	59.40	47.68
% Memory for SQL w/exec>1:	50.89	41.83

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

enq: SQ - contention 24,680 71,997 2,917 63.1 Configuration

gc domain validation 8,007 15,443 1,929 13.5 Cluster

row cache lock 4,932 12,071 2,448 10.6 Concurrency

gc buffer busy 9,922 9,491 957 8.3 Cluster

gc cr failure 2,581 3,147 1,219 2.8 Cluster

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
enq: SQ - contention	24,680	71,997	2,917	63.1	Configuration
gc domain validation	8,007	15,443	1,929	13.5	Cluster
row cache lock	4,932	12,071	2,448	10.6	Concurrency
gc buffer busy	9,922	9,491	957	8.3	Cluster
gc cr failure	2,581	3,147	1,219	2.8	Cluster

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 11.85 0.80

Global Cache blocks served: 23.67 1.60

GCS/GES messages received: 147.89 9.99

GCS/GES messages sent: 210.64 14.23

DBWR Fusion writes: 0.14 0.01

Estd Interconnect traffic (KB) 354.25

	Per Second	Per Transaction
Global Cache blocks received:	11.85	0.80
Global Cache blocks served:	23.67	1.60
GCS/GES messages received:	147.89	9.99
GCS/GES messages sent:	210.64	14.23
DBWR Fusion writes:	0.14	0.01
Estd Interconnect traffic (KB)	354.25

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.81

Buffer access - remote cache %: 0.09

Buffer access - disk %: 0.11

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 2.7

Avg global cache cr block receive time (ms): 7.3

Avg global cache current block receive time (ms): 0.3

Avg global cache cr block build time (ms): 0.0

Avg global cache cr block send time (ms): 0.0

Global cache log flushes for cr blocks served %: 9.4

Avg global cache cr block flush time (ms): 0.7

Avg global cache current block pin time (ms): 0.0

Avg global cache current block send time (ms): 0.0

Global cache log flushes for current blocks served %: 0.1

Avg global cache current block flush time (ms): 0.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.8

Avg message sent queue time on ksxp (ms): 4.4

Avg message received queue time (ms): 4.5

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.1

% of direct sent messages: 8.22

% of indirect sent messages: 77.10

% of flow controlled messages: 14.69

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
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Wait Class
Wait Events
Background Wait Events
Operating System Statistics
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 114085.1s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
connection management call elapsed time	73,168.89	64.14
sequence load elapsed time	73,168.25	64.13
sql execute elapsed time	39,681.51	34.78
PL/SQL execution elapsed time	1,116.33	0.98
DB CPU	603.51	0.53
parse time elapsed	295.87	0.26
hard parse elapsed time	75.65	0.07
failed parse elapsed time	49.83	0.04
PL/SQL compilation elapsed time	5.99	0.01
hard parse (sharing criteria) elapsed time	0.29	0.00
hard parse (bind mismatch) elapsed time	0.01	0.00
repeated bind elapsed time	0.00	0.00
DB time	114,085.08
background elapsed time	4,591.48
background cpu time	145.21

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Configuration	32,892	99.60	71,998	2189	0.61
Cluster	60,425	36.57	30,367	503	1.13
Concurrency	12,964	33.23	12,274	947	0.24
Other	273,829	89.86	1,777	6	5.10
System I/O	68,523	0.00	56	1	1.28
Commit	52,422	0.00	56	1	0.98
User I/O	10,060	0.00	28	3	0.19
Application	51,554	0.01	6	0	0.96
Network	192,692	0.00	3	0	3.59

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
enq: SQ - contention	24,680	99.70	71,997	2917	0.46
gc domain validation	8,007	99.65	15,443	1929	0.15
row cache lock	4,932	83.50	12,071	2448	0.09
gc buffer busy	9,922	97.81	9,491	957	0.18
gc cr failure	2,581	99.46	3,147	1219	0.05
gc current retry	1,695	99.35	2,065	1218	0.03
reliable message	1,644	91.42	1,464	890	0.03
gc cr block busy	8,526	1.94	211	25	0.16
latch free	996	0.00	194	194	0.02
os thread startup	208	66.83	139	669	0.00
log file sync	52,422	0.00	56	1	0.98
Streams AQ: qmn coordinator waiting for slave to start	8	75.00	41	5176	0.00
buffer busy waits	59	69.49	41	689	0.00
log file parallel write	57,396	0.00	28	0	1.07
kst: async disk IO	888	0.00	24	27	0.02
gcs enter server mode	14	42.86	17	1213	0.00
enq: CF - contention	799	4.13	17	21	0.01
Data file init write	5,996	0.00	16	3	0.11
latch: shared pool	3,288	0.00	15	5	0.06
wait for scn ack	18,619	0.04	10	1	0.35
DFS lock handle	920	1.96	9	10	0.02
db file sequential read	3,895	0.00	9	2	0.07
ges enter server mode	10	0.00	6	649	0.00
library cache lock	2,896	0.35	6	2	0.05
SQL*Net break/reset to client	51,394	0.00	4	0	0.96
db file parallel read	72	0.00	3	41	0.00
gc current block 2-way	10,374	0.00	3	0	0.19
ges2 LMON to wake up LMD - mrcvr	164	87.80	3	18	0.00
wait for votes	94	100.00	3	29	0.00
SQL*Net more data from client	1,328	0.00	3	2	0.02
gc cr block 2-way	8,794	0.00	3	0	0.16
gcs resource directory to be unfrozen	21	0.00	3	127	0.00
ges lmd/lmses to freeze in rcfg - mrcvr	270	87.41	3	9	0.01
gc cr multi block request	8,095	0.00	2	0	0.15
enq: TM - contention	123	2.44	2	16	0.00
latch: library cache	1,200	0.00	2	2	0.02
control file sequential read	5,463	0.00	2	0	0.10
kjbdrmcvtq lmon drm quiesce: ping completion	24	37.50	2	72	0.00
CGS wait for IPC msg	146,169	99.95	1	0	2.72
db file parallel write	3,208	0.00	1	0	0.06
checkpoint completed	3	33.33	1	381	0.00
enq: US - contention	2,374	0.00	1	0	0.04
control file parallel write	1,520	0.00	1	1	0.03
name-service call wait	9	0.00	1	81	0.00
ges2 LMON to wake up lms - mrcvr 2	36	94.44	1	19	0.00
gcs log flush sync	1,176	7.65	1	1	0.02
recovery read	14	0.00	1	43	0.00
ges LMON to get to FTDONE	39	82.05	1	15	0.00
gc current grant busy	783	0.00	0	1	0.01
gc current block busy	63	0.00	0	6	0.00
IPC send completion sync	85,869	99.82	0	0	1.60
lms flush message acks	32	0.00	0	11	0.00
library cache pin	225	0.00	0	1	0.00
ges global resource directory to be frozen	27	100.00	0	11	0.00
latch: row cache objects	3	0.00	0	82	0.00
read by other session	64	0.00	0	3	0.00
SQL*Net message to client	187,518	0.00	0	0	3.50
db file scattered read	22	0.00	0	8	0.00
ges LMON for send queues	6	66.67	0	25	0.00
gc cr grant 2-way	597	0.00	0	0	0.01
library cache load lock	26	0.00	0	4	0.00
latch: object queue header operation	110	0.00	0	1	0.00
ges LMD to inherit communication channels	1	100.00	0	98	0.00
gc current grant 2-way	358	0.00	0	0	0.01
rdbms ipc reply	268	0.00	0	0	0.00
enq: JS - job run lock - synchronize	1	0.00	0	71	0.00
log file sequential read	29	0.00	0	2	0.00
kksfbc child completion	1	100.00	0	49	0.00
ksxr poll remote instances	4,750	70.99	0	0	0.09
gc current multi block request	629	0.00	0	0	0.01
cr request retry	4	100.00	0	10	0.00
enq: TX - row lock contention	3	0.00	0	11	0.00
kjctssqmg: quick message send wait	68	98.53	0	0	0.00
lock deadlock retry	3	100.00	0	10	0.00
latch: cache buffers chains	123	0.00	0	0	0.00
PX Deq: reap credit	2,928	99.35	0	0	0.05
LGWR wait for redo copy	195	0.00	0	0	0.00
enq: PS - contention	100	0.00	0	0	0.00
ges reconfiguration to start	1	100.00	0	20	0.00
enq: FB - contention	142	0.00	0	0	0.00
enq: TT - contention	97	0.00	0	0	0.00
SQL*Net more data to client	864	0.00	0	0	0.02
undo segment extension	8,152	100.00	0	0	0.15
enq: HW - contention	57	0.00	0	0	0.00
ksdxexeotherwait	4,848	99.65	0	0	0.09
enq: TX - contention	38	0.00	0	0	0.00
enq: TA - contention	26	0.00	0	0	0.00
PX Deq: Signal ACK	38	26.32	0	0	0.00
PX Deq Credit: send blkd	39	46.15	0	0	0.00
enq: TQ - TM contention	24	0.00	0	0	0.00
log file single write	3	0.00	0	1	0.00
buffer deadlock	795	100.00	0	0	0.01
SQL*Net message to dblink	2,896	0.00	0	0	0.05
enq: UL - contention	8	0.00	0	0	0.00
enq: WF - contention	7	0.00	0	0	0.00
latch: KCL gc element parent latch	5	0.00	0	0	0.00
latch: ges resource hash list	13	0.00	0	0	0.00
SQL*Net more data from dblink	86	0.00	0	0	0.00
control file single write	1	0.00	0	0	0.00
gc current split	1	0.00	0	0	0.00
enq: PI - contention	3	0.00	0	0	0.00
enq: PW - flush prewarm buffers	4	0.00	0	0	0.00
db file single write	1	0.00	0	0	0.00
enq: TX - index contention	2	0.00	0	0	0.00
enq: CT - state	2	0.00	0	0	0.00
SQL*Net break/reset to dblink	22	0.00	0	0	0.00
ges lmd/lmses to unfreeze in rcfg - mrcvr	2	0.00	0	0	0.00
direct path write	10	0.00	0	0	0.00
cursor: mutex S	2	0.00	0	0	0.00
Log archive I/O	1	0.00	0	0	0.00
SQL*Net message from client	187,536	0.00	97,339	519	3.50
gcs remote message	917,268	93.68	14,104	15	17.10
PX Idle Wait	2,011	96.97	4,824	2399	0.04
Streams AQ: waiting for messages in the queue	562	96.98	4,377	7789	0.01
ges remote message	58,823	96.51	3,535	60	1.10
ASM background timer	778	0.00	3,533	4541	0.01
virtual circuit status	121	100.00	3,533	29199	0.00
DIAG idle wait	17,911	0.00	3,497	195	0.33
Streams AQ: qmn slave idle wait	134	2.99	3,414	25474	0.00
Streams AQ: qmn coordinator idle wait	247	47.37	3,147	12740	0.00
class slave wait	52	65.38	2,842	54661	0.00
Streams AQ: waiting for time management or cleanup tasks	61	72.13	2,766	45342	0.00
jobq slave wait	755	97.75	2,088	2765	0.01
SQL*Net message from dblink	2,896	0.00	838	289	0.05
KSV master wait	8,022	1.71	664	83	0.15
Streams AQ: RAC qmn coordinator idle wait	21,155,244	100.00	143	0	394.35
PX Deq: Execute Reply	44	38.64	12	265	0.00
PX Deq: Execution Msg	233	26.61	1	2	0.00
PX Deq: Parse Reply	44	38.64	0	6	0.00
single-task message	5	0.00	0	41	0.00
PX Deq: Join ACK	45	35.56	0	1	0.00
PX Deq: Msg Fragment	163	41.10	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
row cache lock	327	101.53	974	2978	0.01
gc buffer busy	799	99.50	774	968	0.01
gc domain validation	410	99.51	666	1624	0.01
gc current retry	502	99.40	612	1219	0.01
events in waitclass Other	268,209	90.23	428	2	5.00
os thread startup	207	67.15	139	672	0.00
gc cr block busy	36	94.44	42	1168	0.00
buffer busy waits	51	80.39	41	797	0.00
log file parallel write	57,397	0.00	28	0	1.07
kst: async disk IO	888	0.00	24	27	0.02
control file sequential read	4,659	0.00	2	0	0.09
db file parallel write	3,208	0.00	1	0	0.06
checkpoint completed	3	33.33	1	381	0.00
control file parallel write	1,517	0.00	1	1	0.03
recovery read	14	0.00	1	43	0.00
db file sequential read	141	0.00	0	2	0.00
gc current block busy	2	0.00	0	89	0.00
gc cr block 2-way	389	0.00	0	0	0.01
log file sequential read	29	0.00	0	2	0.00
library cache lock	280	0.00	0	0	0.01
gc current block 2-way	147	0.00	0	0	0.00
latch: library cache	7	0.00	0	4	0.00
latch: cache buffers chains	5	0.00	0	4	0.00
gc current grant 2-way	75	0.00	0	0	0.00
gc current grant busy	33	0.00	0	0	0.00
enq: TM - contention	27	0.00	0	0	0.00
library cache pin	14	0.00	0	0	0.00
gc cr grant 2-way	26	0.00	0	0	0.00
db file scattered read	1	0.00	0	3	0.00
log file single write	3	0.00	0	1	0.00
read by other session	1	0.00	0	2	0.00
enq: HW - contention	2	0.00	0	0	0.00
control file single write	1	0.00	0	0	0.00
gc current multi block request	2	0.00	0	0	0.00
Log archive I/O	1	0.00	0	0	0.00
rdbms ipc message	120,625	48.58	43,779	363	2.25
gcs remote message	917,230	93.68	14,104	15	17.10
pmon timer	1,388	99.57	3,536	2548	0.03
ges remote message	58,825	96.51	3,535	60	1.10
ASM background timer	778	0.00	3,533	4541	0.01
DIAG idle wait	17,910	0.00	3,497	195	0.33
Streams AQ: qmn coordinator idle wait	247	47.37	3,147	12740	0.00
class slave wait	40	55.00	2,784	69594	0.00
Streams AQ: waiting for time management or cleanup tasks	61	72.13	2,766	45342	0.00
smon timer	402	71.89	2,258	5617	0.01
KSV master wait	8,012	1.67	652	81	0.15
Streams AQ: RAC qmn coordinator idle wait	21,155,244	100.00	143	0	394.35
PX Deq: Parse Reply	20	40.00	0	1	0.00
PX Deq: Join ACK	20	40.00	0	1	0.00
PX Deq: Execute Reply	15	33.33	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	10,317
AVG_IDLE_TIME	351,702
AVG_IOWAIT_TIME	258
AVG_SYS_TIME	3,483
AVG_USER_TIME	6,716
BUSY_TIME	166,889
IDLE_TIME	5,629,062
IOWAIT_TIME	5,478
SYS_TIME	57,597
USER_TIME	109,292
LOAD	0
OS_CPU_WAIT_TIME	334,600
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,151,778,816
NUM_CPUS	16
NUM_CPU_CORES	8

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
zdcomora	106,485.90	594.50	5,147	48,492,268
SYS$USERS	7,598.70	8.80	476	725,989
SYS$BACKGROUND	0.00	0.00	46,218	82,273
zdcomoraXDB	0.00	0.00	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 centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
zdcomora	9489	2655	9744	1099610	187516	19
SYS$USERS	302	85	1050	12366	4069	1
SYS$BACKGROUND	269	68	2161	115439	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 Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
SQL ordered by Cluster Wait Time
Complete List of SQL Text

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
1,391	0	38	36.59	1.22	5ansr7r9htpq3		update undo$ set name=:2, file...
1,346	2	36	37.39	1.18	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
1,114	0	0		0.98	8qcqkskshyyqq	emagent@ora01 (TNS V1-V3)	/* OracleOEM */ BEGIN ...
667	0	11	60.67	0.58	axmdf8vq7k1rh		select increment$, minvalue, m...
234	0	5	46.88	0.21	34zgdrkuufg1h	racgimon@ora01 (TNS V1-V3)	begin dbms_lock.allocate_uniqu...
234	0	5	46.88	0.21	19x1189chq3xd	racgimon@ora01 (TNS V1-V3)	SELECT LOCKID FROM DBMS_LOCK_A...
79	50	387	0.20	0.07	4mkxat916hu62	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(o_pbrq) fro...
61	39	117	0.53	0.05	axwrprcw9dqb3	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(O_YXSJBRQ),...
59	0	30	1.98	0.05	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
50	0	8	6.22	0.04	f20qqtsxtbnc8		SELECT DISTINCT HOST_URL FROM ...

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 DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
50	79	387	0.13	0.07	4mkxat916hu62	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(o_pbrq) fro...
39	61	117	0.33	0.05	axwrprcw9dqb3	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(O_YXSJBRQ),...
4	8	270	0.02	0.01	3sy8gb2v0g7xu	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(O_YXSJBRQ),...
2	1,346	36	0.07	1.18	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
2	21	5	0.48	0.02	1gc7umngbqyc1		SELECT /+ ORDERED / A.READY ...
1	6	8	0.16	0.01	fca1gqzj52va2		select sum(SYSDATE - cast(NVL(...
1	3	9	0.09	0.00	fnzzh9uay06sb		select count (*), state from ...
1	1	1	0.72	0.00	cghf05c6r758h		INSERT /+ APPEND / INTO WRH$...
1	1	3,779	0.00	0.00	7gtztzv329wg0		select c.name, u.name from co...
1	1	9	0.07	0.00	cmjf0y5s3t51t	OEM.BoundedPool	INSERT INTO MGMT_SEVERITY(COLL...
0	1,391	38	0.01	1.22	5ansr7r9htpq3		update undo$ set name=:2, file...

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: 49,297,357
Captured SQL account for 8.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,536,042	387	3,969.10	3.12	49.57	78.54	4mkxat916hu62	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(o_pbrq) fro...
914,434	117	7,815.68	1.85	39.17	61.49	axwrprcw9dqb3	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(O_YXSJBRQ),...
553,612	36	15,378.11	1.12	2.44	1345.92	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
456,630	30	15,221.00	0.93	0.12	59.26	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
454,002	5	90,800.40	0.92	2.40	20.85	1gc7umngbqyc1		SELECT /+ ORDERED / A.READY ...
400,424	8	50,053.00	0.81	1.24	6.41	fca1gqzj52va2		select sum(SYSDATE - cast(NVL(...
234,630	270	869.00	0.48	4.20	7.72	3sy8gb2v0g7xu	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(O_YXSJBRQ),...
67,070	12	5,589.17	0.14	0.19	0.42	2zwjrv2186835	Oracle Enterprise Manager.rollup	DELETE FROM MGMT_METRICS_RAW W...
38,432	9	4,270.22	0.08	0.78	3.10	fnzzh9uay06sb		select count (*), state from ...
31,255	4	7,813.75	0.06	0.19	0.27	2260jajub9ct3	httpd@localhost.localdomain (TNS V1-V3)	DELETE T_DM_YXSJBJBA WHERE O_X...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 51,873
Captured SQL account for 10.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,449	1	2,449.00	4.72	0.16	4.59	gry0huksd6h9g	httpd@localhost.localdomain (TNS V1-V3)	select O_DATE, O_TIME, O_LINE...
1,836	1	1,836.00	3.54	0.08	3.19	a85s0d7wxwuqk	httpd@localhost.localdomain (TNS V1-V3)	select O_DATE, O_TIME, O_LINE...
292	36	8.11	0.56	2.44	1345.92	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
203	30	6.77	0.39	0.12	59.26	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
189	5	37.80	0.36	2.40	20.85	1gc7umngbqyc1		SELECT /+ ORDERED / A.READY ...
163	9	18.11	0.31	0.78	3.10	fnzzh9uay06sb		select count (*), state from ...
125	97	1.29	0.24	0.17	0.18	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
58	3	19.33	0.11	0.41	1.12	f787fyhjmkp61	OEM.BoundedPool	INSERT INTO MGMT_SEVERITY(ACTI...
46	9	5.11	0.09	0.62	1.45	cmjf0y5s3t51t	OEM.BoundedPool	INSERT INTO MGMT_SEVERITY(COLL...
43	2	21.50	0.08	0.24	0.54	863r0p51yahqf	httpd@localhost.localdomain (TNS V1-V3)	select distinct o_busno_jh, o_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 87,305
Captured SQL account for 16.2% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
3,779	3,779	1.00	0.00	0.00	7gtztzv329wg0		select c.name, u.name from co...
2,305	0	0.00	0.00	0.00	5zuzmh83csg6t	httpd@localhost.localdomain (TNS V1-V3)	ALTER SESSION SET NLS_DATE_FOR...
1,053	1,052	1.00	0.00	0.00	grwydz59pu6mc		select text from view$ where r...
905	879	0.97	0.00	0.00	3c1kubcdjnppq		update sys.col_usage$ set eq...
473	1,106	2.34	0.00	0.00	0h6b2sajwb74n		select privilege#, level from ...
387	91,709	236.97	0.13	0.20	4mkxat916hu62	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(o_pbrq) fro...
336	0	0.00	0.00	0.00	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
284	712	2.51	0.00	0.00	6769wyy3yf66f		select pos#, intcol#, col#, sp...
270	16,200	60.00	0.02	0.03	3sy8gb2v0g7xu	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(O_YXSJBRQ),...
251	3,346	13.33	0.00	0.00	83taa7kaw59c1		select name, intcol#, segcol#,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 121,379
Captured SQL account for 10.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
3,779	3,779	3.11	7gtztzv329wg0		select c.name, u.name from co...
2,305	2,305	1.90	5zuzmh83csg6t	httpd@localhost.localdomain (TNS V1-V3)	ALTER SESSION SET NLS_DATE_FOR...
1,053	1,053	0.87	grwydz59pu6mc		select text from view$ where r...
473	473	0.39	0h6b2sajwb74n		select privilege#, level from ...
387	387	0.32	4mkxat916hu62	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(o_pbrq) fro...
336	905	0.28	3c1kubcdjnppq		update sys.col_usage$ set eq...
336	26	0.28	53btfq0dt9bs9		insert into sys.col_usage$ val...
336	336	0.28	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
270	270	0.22	3sy8gb2v0g7xu	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(O_YXSJBRQ),...
214	214	0.18	0k8522rmdzg4k		select privilege# from sysauth...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

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
34	8	19rkm1wsf9axx		insert into WRI$_ALERT_HISTORY...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)	CWT % of Elapsd Time	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
1,388.23	99.84	1,390.51	0.21	38	5ansr7r9htpq3		update undo$ set name=:2, file...
1,337.67	99.39	1,345.92	2.44	36	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
666.88	99.93	667.36	0.04	11	axmdf8vq7k1rh		select increment$, minvalue, m...
117.19	49.99	234.40	0.03	5	19x1189chq3xd	racgimon@ora01 (TNS V1-V3)	SELECT LOCKID FROM DBMS_LOCK_A...
117.19	49.99	234.40	0.03	5	34zgdrkuufg1h	racgimon@ora01 (TNS V1-V3)	begin dbms_lock.allocate_uniqu...
58.50	98.71	59.26	0.12	30	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
49.78	99.98	49.79	0.02	8	f20qqtsxtbnc8		SELECT DISTINCT HOST_URL FROM ...
8.73	41.86	20.85	2.40	5	1gc7umngbqyc1		SELECT /+ ORDERED / A.READY ...
4.92	99.95	4.92	0.00	38	c4nhd1ntptxq7		select message_level, sequenc...
4.71	73.49	6.41	1.24	8	fca1gqzj52va2		select sum(SYSDATE - cast(NVL(...
2.31	74.41	3.10	0.78	9	fnzzh9uay06sb		select count (*), state from ...
1.07	83.26	1.28	0.20	8	6bzv9ph7d1hvj		select count(*) from "SYS"....
0.64	81.27	0.79	0.16	8	0078dhy7zav20		select sum(SYSDATE - cast(qt.e...
0.15	21.29	0.70	0.70	3,779	7gtztzv329wg0		select c.name, u.name from co...
0.15	35.22	0.42	0.19	12	2zwjrv2186835	Oracle Enterprise Manager.rollup	DELETE FROM MGMT_METRICS_RAW W...
0.06	0.10	61.49	39.17	117	axwrprcw9dqb3	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(O_YXSJBRQ),...
0.05	0.06	78.54	49.57	387	4mkxat916hu62	httpd@localhost.localdomain (TNS V1-V3)	select o_xlmc, max(o_pbrq) fro...
0.01	6.30	0.18	0.17	97	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
0.01	0.64	1.12	0.41	3	f787fyhjmkp61	OEM.BoundedPool	INSERT INTO MGMT_SEVERITY(ACTI...
0.01	0.46	1.45	0.62	9	cmjf0y5s3t51t	OEM.BoundedPool	INSERT INTO MGMT_SEVERITY(COLL...
0.01	10.22	0.06	0.06	163	8swypbbr0m372		select order#, columns, types ...
0.01	8.04	0.07	0.03	97	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
0.01	4.82	0.11	0.08	163	cqgv56fmuj63x		select owner#, name, namespace...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0078dhy7zav20 select sum(SYSDATE - cast(qt.enq_time as date)) from "SYS"."ALERT_QT" qt, "SYS"."AQ$_ALERT_QT_I" iot where iot.subscriber# != 0 and (iot.subscriber# in (select subscriber_id from "SYS"."AQ$_ALERT_QT_S" where queue_name = :1 and (bitand(subscriber_type, 8) = 8))) and qt.msgid = iot.msgid

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

19rkm1wsf9axx insert into WRI$_ALERT_HISTORY (sequence_id, reason_id, owner, object_name, subobject_name, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, resolution, metric_value) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)

19x1189chq3xd SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE

1gc7umngbqyc1 SELECT /*+ ORDERED */ A.READY FROM USER_QUEUES B, GV$AQ A WHERE B.NAME = 'MGMT_NOTIFY_Q' AND A.QID = B.QID

2260jajub9ct3 DELETE T_DM_YXSJBJBA WHERE O_XLMC='549' AND O_YXSJBRQ='2012-08-02' AND O_YXSJBBS=0 AND O_BC=24 AND O_BB='M' AND O_LOOPNUM=2 AND O_YXFX=1

2zwjrv2186835 DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1

34zgdrkuufg1h begin dbms_lock.allocate_unique(:a1, :a2); end;

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln

3sy8gb2v0g7xu select o_xlmc, max(O_YXSJBRQ), O_YXSJBBS from T_DM_YXSJ group by o_xlmc, O_YXSJBBS having max(O_YXSJBRQ)>'1991-01-01' order by o_xlmc, O_YXSJBBS

4mkxat916hu62 select o_xlmc, max(o_pbrq) from T_DM_PAIBAN group by o_xlmc having max(o_pbrq)>'1991-01-01'

53btfq0dt9bs9 insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)

5ansr7r9htpq3 update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1

5zuzmh83csg6t ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'

6769wyy3yf66f select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1

6bzv9ph7d1hvj select count(*) from "SYS"."AQ$_ALERT_QT_I" where (subscriber# != 0 and subscriber# in (select subscriber_id from "SYS"."AQ$_ALERT_QT_S" where queue_name = :1)) or (subscriber# = 0 and queue# = :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;

7gtztzv329wg0 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

863r0p51yahqf select distinct o_busno_jh, o_jhfcsjc, o_jhfcsjc_dd, o_sjfcsjc, o_jhddsjc_dd, o_sjddsjc, o_gh_jh, o_cwy_q_id_jh, o_cwy_z_id_jh , o_cwy_h_id_jh, o_runtype_jh, o_record_state, o_glgs, o_busno, o_tjrq, o_is_changeline, o_lineno_tj, o_lineno_src, o_bc , o_bb, o_bcbs, o_tc, o_gh, o_cwy_q_id, o_cwy_z_id, o_cwy_h_id, o_fczd, o_ddzd, o_scddsjc, o_runtype, o_runtimescoef , o_isempty, o_yxgl, o_downline, O_MAKEUP, o_sjyxgl, o_manualtag, o_scmdkind, o_ecmdkind, O_MANUALTAG_REASION, O_ISCROSS, O_CROSSSTATION, O_JHBC, O_YSJHTC, O_JHTC, o_index, 0 o_changid, o_yxfx, o_busno, o_record_state, length(o_gh) from t_dm_ddb201207 where o_xlmc = '1003' and o_rq='2012-07-31' and o_record_state in(1, 21) and o_sjfcsj is not null

8qcqkskshyyqq /* OracleOEM */ BEGIN dbms_server_alert.set_threshold(:metrics_id, :warning_operator, :warning_value, :critical_operator, :critical_value, 1, :consecutive_occurrences, :instance_name, :object_type, :object_name); END;

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

a85s0d7wxwuqk select O_DATE, O_TIME, O_LINENAME, O_BUSNAME, O_UP, O_RUN, O_SPEED, O_NEXTSTATIONNO, O_MOTORTEMP, O_INDOORTEMP, O_LONGITUDE, O_LATITUDE, O_MIDDOOR, O_REARDOOR, O_FRONTDOOR, O_DISTANCE, O_DIRECTION, O_HEIGHT from T_JK_FULLGPSDATA20120801 Where O_DATE='2012-08-01' and O_TIME between '10:22:54' and '10:45:54' and O_BUSNAME in ('21116') and O_HISTORYDATA=0 order by O_TIME

abtp0uqvdb1d3 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)

axmdf8vq7k1rh select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1

axwrprcw9dqb3 select o_xlmc, max(O_YXSJBRQ), O_YXSJBBS from T_DM_YXSJBJBA group by o_xlmc, O_YXSJBBS having max(O_YXSJBRQ)>'1991-01-01' order by o_xlmc, O_YXSJBBS

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

c4nhd1ntptxq7 select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4

cghf05c6r758h INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, sql_opcode, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, a.sql_opcode, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id 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 (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)

cmjf0y5s3t51t INSERT INTO MGMT_SEVERITY(COLLECTION_TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, METRIC_GUID, SEVERITY_CODE, TARGET_GUID) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6, :7, :8)

cqgv56fmuj63x select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

f20qqtsxtbnc8 SELECT DISTINCT HOST_URL FROM MGMT_OMS_PARAMETERS

f787fyhjmkp61 INSERT INTO MGMT_SEVERITY(ACTION_MESSAGE, ACTION_NLSID, ADVISORY_ID, COLLECTION_TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, METRIC_GUID, SEVERITY_CODE, TARGET_GUID) VALUES ( :1, :2, :3, :4, NVL(:5, ' '), :6, :7, :8, :9, :10, :11)

fca1gqzj52va2 select sum(SYSDATE - cast(NVL(qt.delay, qt.enq_time) as date)) from "SYS"."ALERT_QT" qt, "SYS"."AQ$_ALERT_QT_I" iot where ((iot.subscriber# != 0 and iot.subscriber# in (select subscriber_id from "SYS"."AQ$_ALERT_QT_S" where queue_name = :1 and (bitand(subscriber_type, 1) = 1))) or (iot.subscriber# = 0 and iot.queue# = :2)) and qt.msgid = iot.msgid

fnzzh9uay06sb select count (*), state from "SYS"."ALERT_QT" where q_name = :1 group by state

grwydz59pu6mc select text from view$ where rowid=:1

gry0huksd6h9g select O_DATE, O_TIME, O_LINENAME, O_BUSNAME, O_UP, O_RUN, O_SPEED, O_NEXTSTATIONNO, O_MOTORTEMP, O_INDOORTEMP, O_LONGITUDE, O_LATITUDE, O_MIDDOOR, O_REARDOOR, O_FRONTDOOR, O_DISTANCE, O_DIRECTION, O_HEIGHT from T_JK_FULLGPSDATA20120801 Where O_DATE='2012-08-01' and O_TIME between '06:45:26' and '18:45:26' and O_BUSNAME in ('2007') and O_HISTORYDATA=0 order by O_TIME

SQL Id	SQL Text
0078dhy7zav20	select sum(SYSDATE - cast(qt.enq_time as date)) from "SYS"."ALERT_QT" qt, "SYS"."AQ$_ALERT_QT_I" iot where iot.subscriber# != 0 and (iot.subscriber# in (select subscriber_id from "SYS"."AQ$_ALERT_QT_S" where queue_name = :1 and (bitand(subscriber_type, 8) = 8))) and qt.msgid = iot.msgid
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
19rkm1wsf9axx	insert into WRI$_ALERT_HISTORY (sequence_id, reason_id, owner, object_name, subobject_name, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, resolution, metric_value) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)
19x1189chq3xd	SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE
1gc7umngbqyc1	SELECT /+ ORDERED / A.READY FROM USER_QUEUES B, GV$AQ A WHERE B.NAME = 'MGMT_NOTIFY_Q' AND A.QID = B.QID
2260jajub9ct3	DELETE T_DM_YXSJBJBA WHERE O_XLMC='549' AND O_YXSJBRQ='2012-08-02' AND O_YXSJBBS=0 AND O_BC=24 AND O_BB='M' AND O_LOOPNUM=2 AND O_YXFX=1
2zwjrv2186835	DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1
34zgdrkuufg1h	begin dbms_lock.allocate_unique(:a1, :a2); end;
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3sy8gb2v0g7xu	select o_xlmc, max(O_YXSJBRQ), O_YXSJBBS from T_DM_YXSJ group by o_xlmc, O_YXSJBBS having max(O_YXSJBRQ)>'1991-01-01' order by o_xlmc, O_YXSJBBS
4mkxat916hu62	select o_xlmc, max(o_pbrq) from T_DM_PAIBAN group by o_xlmc having max(o_pbrq)>'1991-01-01'
53btfq0dt9bs9	insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
5ansr7r9htpq3	update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1
5zuzmh83csg6t	ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6bzv9ph7d1hvj	select count(*) from "SYS"."AQ$_ALERT_QT_I" where (subscriber# != 0 and subscriber# in (select subscriber_id from "SYS"."AQ$_ALERT_QT_S" where queue_name = :1)) or (subscriber# = 0 and queue# = :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;
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
863r0p51yahqf	select distinct o_busno_jh, o_jhfcsjc, o_jhfcsjc_dd, o_sjfcsjc, o_jhddsjc_dd, o_sjddsjc, o_gh_jh, o_cwy_q_id_jh, o_cwy_z_id_jh , o_cwy_h_id_jh, o_runtype_jh, o_record_state, o_glgs, o_busno, o_tjrq, o_is_changeline, o_lineno_tj, o_lineno_src, o_bc , o_bb, o_bcbs, o_tc, o_gh, o_cwy_q_id, o_cwy_z_id, o_cwy_h_id, o_fczd, o_ddzd, o_scddsjc, o_runtype, o_runtimescoef , o_isempty, o_yxgl, o_downline, O_MAKEUP, o_sjyxgl, o_manualtag, o_scmdkind, o_ecmdkind, O_MANUALTAG_REASION, O_ISCROSS, O_CROSSSTATION, O_JHBC, O_YSJHTC, O_JHTC, o_index, 0 o_changid, o_yxfx, o_busno, o_record_state, length(o_gh) from t_dm_ddb201207 where o_xlmc = '1003' and o_rq='2012-07-31' and o_record_state in(1, 21) and o_sjfcsj is not null
8qcqkskshyyqq	/* OracleOEM */ BEGIN dbms_server_alert.set_threshold(:metrics_id, :warning_operator, :warning_value, :critical_operator, :critical_value, 1, :consecutive_occurrences, :instance_name, :object_type, :object_name); END;
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
a85s0d7wxwuqk	select O_DATE, O_TIME, O_LINENAME, O_BUSNAME, O_UP, O_RUN, O_SPEED, O_NEXTSTATIONNO, O_MOTORTEMP, O_INDOORTEMP, O_LONGITUDE, O_LATITUDE, O_MIDDOOR, O_REARDOOR, O_FRONTDOOR, O_DISTANCE, O_DIRECTION, O_HEIGHT from T_JK_FULLGPSDATA20120801 Where O_DATE='2012-08-01' and O_TIME between '10:22:54' and '10:45:54' and O_BUSNAME in ('21116') and O_HISTORYDATA=0 order by O_TIME
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
axwrprcw9dqb3	select o_xlmc, max(O_YXSJBRQ), O_YXSJBBS from T_DM_YXSJBJBA group by o_xlmc, O_YXSJBBS having max(O_YXSJBRQ)>'1991-01-01' order by o_xlmc, O_YXSJBBS
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
c4nhd1ntptxq7	select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
cghf05c6r758h	INSERT /+ APPEND / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, sql_opcode, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, a.sql_opcode, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id 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 (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
cmjf0y5s3t51t	INSERT INTO MGMT_SEVERITY(COLLECTION_TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, METRIC_GUID, SEVERITY_CODE, TARGET_GUID) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6, :7, :8)
cqgv56fmuj63x	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
f20qqtsxtbnc8	SELECT DISTINCT HOST_URL FROM MGMT_OMS_PARAMETERS
f787fyhjmkp61	INSERT INTO MGMT_SEVERITY(ACTION_MESSAGE, ACTION_NLSID, ADVISORY_ID, COLLECTION_TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, METRIC_GUID, SEVERITY_CODE, TARGET_GUID) VALUES ( :1, :2, :3, :4, NVL(:5, ' '), :6, :7, :8, :9, :10, :11)
fca1gqzj52va2	select sum(SYSDATE - cast(NVL(qt.delay, qt.enq_time) as date)) from "SYS"."ALERT_QT" qt, "SYS"."AQ$_ALERT_QT_I" iot where ((iot.subscriber# != 0 and iot.subscriber# in (select subscriber_id from "SYS"."AQ$_ALERT_QT_S" where queue_name = :1 and (bitand(subscriber_type, 1) = 1))) or (iot.subscriber# = 0 and iot.queue# = :2)) and qt.msgid = iot.msgid
fnzzh9uay06sb	select count (*), state from "SYS"."ALERT_QT" where q_name = :1 group by state
grwydz59pu6mc	select text from view$ where rowid=:1
gry0huksd6h9g	select O_DATE, O_TIME, O_LINENAME, O_BUSNAME, O_UP, O_RUN, O_SPEED, O_NEXTSTATIONNO, O_MOTORTEMP, O_INDOORTEMP, O_LONGITUDE, O_LATITUDE, O_MIDDOOR, O_REARDOOR, O_FRONTDOOR, O_DISTANCE, O_DIRECTION, O_HEIGHT from T_JK_FULLGPSDATA20120801 Where O_DATE='2012-08-01' and O_TIME between '06:45:26' and '18:45:26' and O_BUSNAME in ('2007') and O_HISTORYDATA=0 order by O_TIME

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	41,515	11.46	0.77
CPU used when call started	46,638	12.87	0.87
CR blocks created	1,971	0.54	0.04
Cached Commit SCN referenced	50	0.01	0.00
Commit SCN cached	1	0.00	0.00
DB time	12,179,740	3,361.63	227.04
DBWR checkpoint buffers written	20,110	5.55	0.37
DBWR checkpoints	1	0.00	0.00
DBWR fusion writes	512	0.14	0.01
DBWR object drop buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	123	0.03	0.00
DBWR undo block writes	5,441	1.50	0.10
DFO trees parallelized	17	0.00	0.00
IPC CPU used by this session	12,991	3.59	0.24
PX local messages recv'd	69	0.02	0.00
PX local messages sent	69	0.02	0.00
PX remote messages recv'd	185	0.05	0.00
PX remote messages sent	118	0.03	0.00
Parallel operations downgraded to serial	1	0.00	0.00
Parallel operations not downgraded	17	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	909	0.25	0.02
RowCR hits	914	0.25	0.02
SMON posted for instance recovery	1	0.00	0.00
SMON posted for undo segment recovery	2	0.00	0.00
SMON posted for undo segment shrink	8	0.00	0.00
SQL*Net roundtrips to/from client	186,906	51.59	3.48
SQL*Net roundtrips to/from dblink	2,896	0.80	0.05
active txn count during cleanout	3,573	0.99	0.07
application wait time	628	0.17	0.01
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	20,315	5.61	0.38
branch node splits	1	0.00	0.00
buffer is not pinned count	792,728	218.79	14.78
buffer is pinned count	3,160,290	872.25	58.91
bytes received via SQL*Net from client	51,239,459	14,142.19	955.14
bytes received via SQL*Net from dblink	1,969,367	543.55	36.71
bytes sent via SQL*Net to client	31,655,071	8,736.86	590.07
bytes sent via SQL*Net to dblink	537,157	148.26	10.01
calls to get snapshot scn: kcmgss	223,861	61.79	4.17
calls to kcmgas	83,347	23.00	1.55
calls to kcmgcs	4,544	1.25	0.08
change write time	529	0.15	0.01
cleanout - number of ktugct calls	3,814	1.05	0.07
cleanouts and rollbacks - consistent read gets	26	0.01	0.00
cleanouts only - consistent read gets	46	0.01	0.00
cluster key scan block gets	14,090	3.89	0.26
cluster key scans	5,570	1.54	0.10
cluster wait time	3,036,672	838.13	56.61
commit batch performed	1	0.00	0.00
commit batch requested	1	0.00	0.00
commit batch/immediate performed	3,806	1.05	0.07
commit batch/immediate requested	3,806	1.05	0.07
commit cleanout failures: block lost	46	0.01	0.00
commit cleanout failures: buffer being written	2	0.00	0.00
commit cleanout failures: callback failure	7	0.00	0.00
commit cleanout failures: cannot pin	3	0.00	0.00
commit cleanouts	93,103	25.70	1.74
commit cleanouts successfully completed	93,045	25.68	1.73
commit immediate performed	3,805	1.05	0.07
commit immediate requested	3,805	1.05	0.07
commit txn count during cleanout	360	0.10	0.01
concurrency wait time	1,227,428	338.77	22.88
consistent changes	2,833	0.78	0.05
consistent gets	48,785,369	13,464.86	909.39
consistent gets - examination	474,539	130.97	8.85
consistent gets direct	0	0.00	0.00
consistent gets from cache	48,784,815	13,464.71	909.38
current blocks converted for CR	2	0.00	0.00
cursor authentications	6,641	1.83	0.12
data blocks consistent reads - undo records applied	2,800	0.77	0.05
db block changes	370,224	102.18	6.90
db block gets	511,988	141.31	9.54
db block gets direct	239	0.07	0.00
db block gets from cache	512,003	141.31	9.54
deferred (CURRENT) block cleanout applications	78,956	21.79	1.47
dirty buffers inspected	0	0.00	0.00
enqueue conversions	15,443	4.26	0.29
enqueue releases	452,923	125.01	8.44
enqueue requests	453,249	125.10	8.45
enqueue timeouts	336	0.09	0.01
enqueue waits	2,016	0.56	0.04
exchange deadlocks	795	0.22	0.01
execute count	87,305	24.10	1.63
free buffer inspected	124,035	34.23	2.31
free buffer requested	114,859	31.70	2.14
gc CPU used by this session	5,006	1.38	0.09
gc cr block build time	14	0.00	0.00
gc cr block flush time	64	0.02	0.00
gc cr block receive time	23,544	6.50	0.44
gc cr block send time	45	0.01	0.00
gc cr blocks received	32,439	8.95	0.60
gc cr blocks served	10,292	2.84	0.19
gc current block flush time	4	0.00	0.00
gc current block pin time	41	0.01	0.00
gc current block receive time	366	0.10	0.01
gc current block send time	290	0.08	0.01
gc current blocks received	10,508	2.90	0.20
gc current blocks served	75,483	20.83	1.41
gcs messages sent	744,655	205.53	13.88
ges messages sent	18,537	5.12	0.35
global enqueue CPU used by this session	580	0.16	0.01
global enqueue get time	55,559	15.33	1.04
global enqueue gets async	1,435	0.40	0.03
global enqueue gets sync	207,028	57.14	3.86
global enqueue releases	209,936	57.94	3.91
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	3,986	1.10	0.07
hot buffers moved to head of LRU	5,129	1.42	0.10
immediate (CR) block cleanout applications	72	0.02	0.00
immediate (CURRENT) block cleanout applications	4,482	1.24	0.08
index fast full scans (full)	3	0.00	0.00
index fetch by key	227,490	62.79	4.24
index scans kdiixs1	16,092	4.44	0.30
leaf node 90-10 splits	55	0.02	0.00
leaf node splits	242	0.07	0.00
lob reads	415	0.11	0.01
lob writes	64	0.02	0.00
lob writes unaligned	64	0.02	0.00
logons cumulative	381	0.11	0.01
messages received	63,209	17.45	1.18
messages sent	63,138	17.43	1.18
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	48,173,306	13,295.93	897.99
opened cursors cumulative	98,068	27.07	1.83
parse count (failures)	21,549	5.95	0.40
parse count (hard)	73,850	20.38	1.38
parse count (total)	121,379	33.50	2.26
parse time cpu	6,411	1.77	0.12
parse time elapsed	29,062	8.02	0.54
physical read IO requests	51,790	14.29	0.97
physical read bytes	424,910,848	117,276.25	7,920.64
physical read total IO requests	29,846	8.24	0.56
physical read total bytes	1,204,062,720	332,323.73	22,444.59
physical read total multi block requests	3,902	1.08	0.07
physical reads	51,873	14.32	0.97
physical reads cache	51,868	14.32	0.97
physical reads cache prefetch	1,894	0.52	0.04
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	8,035	2.22	0.15
physical write bytes	171,524,096	47,341.00	3,197.33
physical write total IO requests	125,827	34.73	2.35
physical write total bytes	2,497,945,600	689,438.01	46,563.50
physical write total multi block requests	61,872	17.08	1.15
physical writes	20,938	5.78	0.39
physical writes direct	239	0.07	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	20,699	5.71	0.39
physical writes non checkpoint	5,963	1.65	0.11
pinned buffers inspected	14	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	9,582	2.64	0.18
process last non-idle time	9,412	2.60	0.18
queries parallelized	17	0.00	0.00
recovery blocks read	45,982	12.69	0.86
recursive calls	301,987	83.35	5.63
recursive cpu usage	5,899	1.63	0.11
redo blocks read for recovery	1,242,974	343.06	23.17
redo blocks written	171,569	47.35	3.20
redo buffer allocation retries	0	0.00	0.00
redo entries	200,647	55.38	3.74
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	2,944	0.81	0.05
redo size	72,865,608	20,111.05	1,358.27
redo synch time	5,732	1.58	0.11
redo synch writes	70,032	19.33	1.31
redo wastage	12,179,664	3,361.61	227.04
redo write time	3,493	0.96	0.07
redo writer latching time	3	0.00	0.00
redo writes	57,413	15.85	1.07
rollback changes - undo records applied	4,000	1.10	0.07
rollbacks only - consistent read gets	1,921	0.53	0.04
rows fetched via callback	208,029	57.42	3.88
session connect time	582,302	160.72	10.85
session cursor cache hits	11,646	3.21	0.22
session logical reads	49,297,357	13,606.17	918.94
session pga memory	256,002,192	70,657.12	4,772.06
session uga memory	###############	45,047,385.76	3,042,425.83
session uga memory max	464,227,504	128,127.72	8,653.53
shared hash latch upgrades - no wait	23,364	6.45	0.44
shared hash latch upgrades - wait	12	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	5,804	1.60	0.11
sorts (rows)	125,517,451	34,643.07	2,339.74
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	4,607	1.27	0.09
table fetch by rowid	1,851,110	510.91	34.51
table fetch continued row	3,974	1.10	0.07
table scan blocks gotten	47,611,752	13,140.94	887.52
table scan rows gotten	5,518,444,890	1,523,101.89	102,867.78
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (short tables)	13,909	3.84	0.26
total number of times SMON posted	12	0.00	0.00
transaction lock background gets	22	0.01	0.00
transaction lock foreground requests	22	0.01	0.00
transaction lock foreground wait time	3	0.00	0.00
transaction rollbacks	3,806	1.05	0.07
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	18,538,100	5,116.55	345.56
user I/O wait time	2,818	0.78	0.05
user calls	269,926	74.50	5.03
user commits	53,052	14.64	0.99
user rollbacks	594	0.16	0.01
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	5,467	1.51	0.10
write clones created in background	11	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	1,233,714	1,236,110
opened cursors current	350	231
logons current	72	53

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

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
TSTEST	35,259	10	10.89	1.00	6,551	2	9,215	972.51
UNDOTBS2	15,392	4	0.36	1.00	7	0	0	0.00
SYSAUX	771	0	8.34	1.10	817	0	812	981.77
UNDOTBS1	15	0	6.67	1.00	561	0	12	0.00
SYSTEM	322	0	2.67	1.01	98	0	1	20.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	+DATA/zdcomora/datafile/sysaux.257.780884719	771	0	8.34	1.10	817	0	812	981.77
SYSTEM	+DATA/zdcomora/datafile/system.256.780884719	322	0	2.67	1.01	98	0	1	20.00
TSTEST	+DATA/zdcomora/datafile/tstest_01.dbf	8	0	23.75	1.00	140	0	1	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_02.dbf	84	0	19.05	1.00	10	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_03.dbf	1	0	0.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_04.dbf	1	0	10.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_05.dbf	1	0	10.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_06.dbf	1	0	0.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_07.dbf	5	0	22.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_08.dbf	1	0	10.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_09.dbf	1	0	0.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_10.dbf	1	0	10.00	1.00	45	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_11.dbf	2	0	5.00	1.00	8	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_12.dbf	1	0	10.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_13.dbf	2	0	5.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_14.dbf	2	0	10.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_15.dbf	2	0	5.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_16.dbf	5	0	2.00	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_17.dbf	9	0	3.33	1.00	0	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_18.dbf	3	0	13.33	1.00	4	0	16	1.88
TSTEST	+DATA/zdcomora/datafile/tstest_19.dbf	3,637	1	11.66	1.00	1,311	0	0	0.00
TSTEST	+DATA/zdcomora/datafile/tstest_20.dbf	26,642	7	10.93	1.00	2,214	1	500	988.68
TSTEST	+DATA/zdcomora/datafile/tstest_21.dbf	1,722	0	14.58	1.00	1,395	0	8,665	977.18
TSTEST	+DATA/zdcomora/datafile/tstest_22.dbf	3,128	1	7.48	1.00	1,424	0	33	0.30
UNDOTBS1	+DATA/zdcomora/datafile/undotbs1.258.780884719	15	0	6.67	1.00	561	0	12	0.00
UNDOTBS2	+DATA/zdcomora/datafile/undotbs2.264.780884797	15,392	4	0.36	1.00	7	0	0	0.00

Back to IO Stats
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	820,033	100	49,259,944	5,874	20,699	0	0	10,041

Advisory Statistics

Instance Recovery Stats
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

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	30	2876	22548	108131	921600	108131
E	0	41	3144	23776	127229	921600	127229

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 for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	672	0.10	80,850	2.99	189,649,576
D	1,344	0.20	161,700	2.45	154,885,924
D	2,016	0.30	242,550	2.04	129,060,263
D	2,688	0.39	323,400	1.73	109,684,288
D	3,360	0.49	404,250	1.50	95,162,088
D	4,032	0.59	485,100	1.33	84,375,883
D	4,704	0.69	565,950	1.21	76,472,815
D	5,376	0.79	646,800	1.12	70,736,577
D	6,048	0.89	727,650	1.05	66,609,325
D	6,720	0.99	808,500	1.01	63,718,227
D	6,816	1.00	820,050	1.00	63,342,198
D	7,392	1.08	889,350	0.97	61,643,294
D	8,064	1.18	970,200	0.95	60,061,145
D	8,736	1.28	1,051,050	0.93	58,776,888
D	9,408	1.38	1,131,900	0.91	57,682,694
D	10,080	1.48	1,212,750	0.90	56,695,790
D	10,752	1.58	1,293,600	0.88	55,742,053
D	11,424	1.68	1,374,450	0.86	54,769,130
D	12,096	1.77	1,455,300	0.85	53,742,828
D	12,768	1.87	1,536,150	0.83	52,631,115
D	13,440	1.97	1,617,000	0.81	51,451,638

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	2,031	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	3,151	2,376	718.99	0.00	0.00	0.00	0.00	322,660
E	3,151	2,377	848.09	0.00	0.00	0.00	0.00	322,660

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	3,681	3,681
64K	128K	59	59
128K	256K	38	38
256K	512K	64	64
512K	1024K	1,408	1,408
1M	2M	85	85
2M	4M	8	8
4M	8M	127	127

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
394	0.13	753,384.29	15,288.30	98.00	814
788	0.25	753,384.29	8,545.17	99.00	0
1,576	0.50	753,384.29	8,545.17	99.00	0
2,363	0.75	753,384.29	8,545.17	99.00	0
3,151	1.00	753,384.29	778.52	100.00	0
3,781	1.20	753,384.29	0.00	100.00	0
4,411	1.40	753,384.29	0.00	100.00	0
5,042	1.60	753,384.29	0.00	100.00	0
5,672	1.80	753,384.29	0.00	100.00	0
6,302	2.00	753,384.29	0.00	100.00	0
9,453	3.00	753,384.29	0.00	100.00	0
12,604	4.00	753,384.29	0.00	100.00	0
18,906	6.00	753,384.29	0.00	100.00	0
25,208	8.00	753,384.29	0.00	100.00	0

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
2,320	0.90	321	35,924	566,150	1.00	62,457	1.01	102,242,562
2,592	1.00	589	65,752	566,984	1.00	61,623	1.00	102,594,361
2,864	1.10	860	96,402	567,617	1.00	60,990	0.99	102,876,117
3,136	1.21	1,131	127,901	568,065	1.00	60,542	0.98	103,101,466
3,408	1.31	1,402	158,803	568,391	1.00	60,216	0.98	103,283,325
3,680	1.42	1,673	188,976	568,631	1.00	59,976	0.97	103,428,499
3,952	1.52	1,944	220,074	568,874	1.00	59,733	0.97	103,542,056
4,224	1.63	2,215	256,002	569,199	1.00	59,408	0.96	103,629,703
4,496	1.73	2,486	286,872	569,392	1.00	59,215	0.96	103,697,701
4,768	1.84	2,757	320,362	569,480	1.00	59,127	0.96	103,751,080
5,040	1.94	3,028	350,831	569,553	1.00	59,054	0.96	103,793,728
5,312	2.05	3,299	382,623	569,615	1.00	58,992	0.96	103,828,893

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
4,728	0.50	749,227	132,619,399
7,092	0.75	682,430	78,582,235
9,456	1.00	663,326	63,342,121
11,820	1.25	657,422	60,396,712
14,184	1.50	652,315	55,221,661
16,548	1.75	647,738	52,871,668
18,912	2.00	646,743	52,871,668

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	9,985	9,716	973
file header block	43	43	991
undo header	10	0	0
undo block	2	0	0
2nd level bmb	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
SQ-Sequence Cache	90	90	0	73	73,725	1,009,935.45
CF-Controlfile Transaction	5,987	5,671	316	385	17	45.03
TM-DML	65,174	65,168	0	65	2	32.08
US-Undo Segment	2,150	2,150	0	1,209	1	0.72
JS-Job Scheduler (job run lock - synchronize)	2	2	0	1	0	74.00
TX-Transaction (row lock contention)	3	3	0	3	0	11.00
FB-Format Block	139	139	0	72	0	0.38
PS-PX Process Reservation	143	142	1	66	0	0.32
TT-Tablespace	187	187	0	51	0	0.37
HW-Segment High Water Mark	442	442	0	36	0	0.33
TX-Transaction	57,825	57,838	0	20	0	0.45
TA-Instance Undo	13	13	0	13	0	0.38
TQ-Queue table enqueue (TM contention)	37	37	0	12	0	0.33
UL-User-defined	5	5	0	4	0	0.00
WF-AWR Flush	21	21	0	4	0	0.00
PW-Buffer Cache PreWarm (flush prewarm buffers)	2	1	1	2	0	0.00
CT-Block Change Tracking (state)	1	1	0	1	0	0.00
PI-Remote PX Process Spawn Status	3	3	0	1	0	0.00
TX-Transaction (index contention)	1	1	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

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
1	6.62	70,346	1,373	17	15/34.2	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
02-Aug 09:05	1,362	12,155	0	4	15	0/0	0/0/0/0/0/0
02-Aug 08:55	1,127	12,479	189	3	15	0/0	0/0/0/0/0/0
02-Aug 08:45	1,650	25,472	0	17	34	0/0	0/0/0/0/0/0
02-Aug 08:35	0	0	1,373	15	34	0/0	0/0/0/0/0/0
02-Aug 08:25	6	242	773	15	24	0/0	0/0/0/0/0/0
02-Aug 08:15	1,065	8,897	173	15	17	0/0	0/0/0/0/0/0
02-Aug 08:05	1,406	11,101	0	15	15	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
Parent Latch Statistics
Child Latch Statistics

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
ASM allocation	79	0.00		0	0
ASM map headers	87	0.00		0	0
ASM map load waiting list	34	0.00		0	0
ASM map operation freelist	2,694	0.00		0	0
ASM map operation hash table	281,632	0.00		0	0
ASM network background latch	1,558	0.00		0	0
AWR Alerted Metric Element list	24,783	0.00		0	0
Consistent RBA	57,401	0.00		0	0
FIB s.o chain latch	14	0.00		0	0
FOB s.o list latch	1,034	0.00		0	0
JS broadcast add buf latch	6,662	0.00		0	0
JS broadcast drop buf latch	6,663	0.00		0	0
JS broadcast load blnc latch	6,480	0.00		0	0
JS mem alloc latch	12	0.00		0	0
JS queue access latch	12	0.00		0	0
JS queue state obj latch	236,108	0.00		0	0
JS slv state obj latch	118	0.00		0	0
KCL gc element parent latch	10,976,808	0.00	0.02	0	5,950	0.00
KFK SGA context latch	703	0.00		0	0
KFMD SGA	103	0.00		0	0
KJC destination ctx free list	15	0.00		0	0
KJC message pool free list	65,814	0.02	0.00	0	3,433	0.00
KJCT flow control latch	724,786	0.00	0.00	0	0
KMG MMAN ready and startup request latch	1,207	0.00		0	0
KSXR large replies	107	0.00		0	0
KTF sga latch	14	0.00		0	1,206	0.00
KWQMN job cache list latch	555	0.00		0	0
KWQMN to-be-Stopped Buffer list Latch	1	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	0			0	1,207	0.00
OS process	1,432	0.00		0	0
OS process allocation	2,184	0.00		0	0
OS process: request allocation	643	0.00		0	0
PL/SQL warning settings	802	0.00		0	0
SGA IO buffer pool latch	1,096	0.00		0	4,122	0.00
SQL memory manager latch	1	0.00		0	1,205	0.00
SQL memory manager workarea list latch	88,952	0.00	0.00	0	0
Shared B-Tree	119	0.00		0	0
active checkpoint queue latch	5,858	0.00		0	0
active service list	56,086	0.01	0.00	0	1,388	0.00
archive control	23	0.00		0	0
begin backup scn array	11	0.00		0	0
business card	42	0.00		0	0
cache buffer handles	3,149	0.00		0	0
cache buffers chains	99,348,656	0.26	0.00	0	8,663,281	0.00
cache buffers lru chain	88,473	0.01	0.00	0	340,613	0.02
cache table scan latch	0			0	34	0.00
channel handle pool latch	664	0.00		0	0
channel operations parent latch	228,416	0.00	0.00	0	0
checkpoint queue latch	360,830	0.01	0.00	0	21,820	0.00
client/application info	2,212	0.00		0	0
commit callback allocation	349	0.00		0	0
compile environment latch	66,699	0.00		0	0
database property service latch	4	0.00		0	0
dml lock allocation	130,433	0.05	0.00	0	0
dummy allocation	787	0.00		0	0
enqueue hash chains	1,105,444	0.00	0.00	0	78,223	0.00
enqueues	726,632	0.03	0.00	0	0
error message lists	76	0.00		0	0
event group latch	312	0.00		0	0
file cache latch	400	0.00		0	0
gcs domain validate latch	4	0.00		0	0
gcs drop object freelist	662	0.45	0.00	0	0
gcs opaque info freelist	83,210	0.05	0.00	0	0
gcs partitioned table hash	8,464,479	0.00		0	0
gcs remaster request queue	32	0.00		0	0
gcs remastering latch	870,070	0.00	3.50	0	0
gcs resource freelist	1,122,249	0.03	0.81	1	0
gcs resource hash	4,709,596	0.00	0.00	0	19	0.00
gcs resource scan list	38	0.00		0	0
gcs resource validate list	746,034	15.03	0.00	0	0
gcs shadows freelist	746,114	0.00		0	0
generalized trace enabling latch	1	0.00		0	0
ges caches resource lists	215,950	0.03	0.00	0	75,622	0.05
ges deadlock list	3,130	0.00		0	4	0.00
ges domain table	412,304	0.00		0	0
ges enqueue table freelist	454,694	0.00	0.00	0	0
ges group table	616,227	0.00	0.00	0	0
ges process hash list	12,233	0.00		0	0
ges process parent latch	850,682	0.00		0	5	0.00
ges process table freelist	645	0.00		0	0
ges resource hash list	1,516,204	0.00	0.21	0	40,897	0.00
ges resource scan list	192	0.00		0	0
ges resource table freelist	43,018	0.00	0.00	0	0
ges synchronous data	74	0.00		0	24,258	0.00
ges timeout list	3,045	0.00		0	9,073	0.00
global KZLD latch for mem in SGA	173	0.00		0	0
global tx hash mapping	2,458	0.00		0	3	0.00
hash table column usage latch	506	0.00		0	114,384	0.00
hash table modification latch	80	0.00		0	0
job workq parent latch	0			0	76	0.00
job_queue_processes parameter latch	97	0.00		0	0
kks stats	211,682	0.09	0.16	1	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
ksuosstats global area	246	0.00		0	0
ksv instance	2	0.00		0	0
ktm global data	435	0.00		0	0
kwqbsn:qsga	119	0.00		0	0
lgwr LWN SCN	58,639	0.01	0.00	0	0
library cache	2,318,990	0.19	0.28	2	212,899	0.77
library cache load lock	2,976	0.00		0	0
library cache lock	788,584	0.00	0.00	0	0
library cache lock allocation	4,331	0.00		0	0
library cache pin	721,911	0.00	0.00	0	0
library cache pin allocation	1,561	0.00		0	0
list of block allocation	400	0.00		0	0
loader state object freelist	4	0.00		0	0
longop free list parent	2	0.00		0	2	0.00
message pool operations parent latch	1,005	0.00		0	0
messages	310,424	0.02	0.00	0	0
mostly latch-free SCN	58,681	0.06	0.00	0	0
msg queue	18	0.00		0	18	0.00
multiblock read objects	18,386	0.03	0.00	0	0
name-service memory objects	18,602	0.00		0	0
name-service namespace bucket	128,238	0.00		0	0
name-service namespace objects	10	0.00		0	0
name-service pending queue	8,222	0.00		0	0
name-service request	18	0.00		0	0
name-service request queue	47,699	0.00		0	0
ncodef allocation latch	69	0.00		0	0
object queue header heap	1,633	0.00		0	1,300	0.00
object queue header operation	323,334	0.05	0.70	0	0
object stats modification	19	0.00		0	2	0.00
parallel query alloc buffer	980	0.00		0	0
parallel query stats	96	0.00		0	0
parallel txn reco latch	1,956	0.00		0	0
parameter list	1,831	0.00		0	0
parameter table allocation management	407	1.72	0.29	0	0
post/wait queue	82,006	0.01	0.00	0	53,675	0.03
process allocation	32,806	0.00		0	312	0.00
process group creation	643	0.00		0	0
process queue	256	0.00		0	0
process queue reference	4,917	0.00		0	447	0.00
qmn state object latch	16	0.00		0	0
qmn task queue latch	503	0.00		0	0
query server freelists	212	0.00		0	0
query server process	5	0.00		0	3	0.00
queued dump request	17,899	0.00		0	0
redo allocation	174,885	0.01	0.00	0	200,668	0.09
redo copy	0			0	200,758	0.10
redo writing	180,728	0.00		0	0
resmgr group change latch	447	0.00		0	0
resmgr:actses active list	767	0.00		0	0
resmgr:actses change group	262	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	763	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	2	0.00		0	0
row cache objects	1,878,423	0.17	0.00	0	14,343	0.01
rules engine aggregate statistics	16	0.00		0	0
rules engine rule set statistics	32	0.00		0	0
segmented array pool	14	0.00		0	0
sequence cache	1,143	0.17	0.00	0	0
session allocation	252,783	0.08	0.00	0	0
session idle bit	606,042	0.00	0.00	0	0
session state list latch	376	0.00		0	0
session switching	69	0.00		0	0
session timer	1,388	0.00		0	0
shared pool	2,170,157	0.25	0.62	15	0
simulator hash latch	3,036,575	0.00	0.00	0	0
simulator lru latch	3,031,323	0.48	0.00	0	3,380	0.00
slave class	66	0.00		0	0
slave class create	103	5.83	39.50	192	0
sort extent pool	388	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	143	0.00		0	0
temporary table state object allocation	10	0.00		0	0
threshold alerts latch	199	0.00		0	0
transaction allocation	43,049	0.00		0	0
transaction branch allocation	2,506	0.00		0	0
undo global data	208,649	0.01	0.00	0	85	0.00
user lock	982	1.93	0.63	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	99,348,656	261,713	123	261,591
gcs resource validate list	746,034	112,107	4	112,103
simulator lru latch	3,031,323	14,658	8	14,650
shared pool	2,170,157	5,332	3,297	2,422
library cache	2,318,990	4,327	1,200	3,221
row cache objects	1,878,423	3,178	3	3,175
gcs resource freelist	1,122,249	361	292	72
KCL gc element parent latch	10,976,808	290	5	285
kks stats	211,682	194	32	162
object queue header operation	323,334	158	110	54
ges resource hash list	1,516,204	63	13	50
user lock	982	19	12	7
parameter table allocation management	407	7	2	5
slave class create	103	6	237	0
gcs remastering latch	870,070	2	7	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
KCL gc element parent latch	kclnfndnew	4	0
KCL gc element parent latch	kclzcl	2	2
KCL gc element parent latch	kcldle	1	0
KCL gc element parent latch	kclnfndt	1	0
KCL gc element parent latch	kclplz	1	2
cache buffers chains	kcbgtcr: kslbegin excl	161	138
cache buffers chains	kcbrls: kslbegin	18	55
cache buffers chains	kcbzwb	14	6
cache buffers chains	kcbgcur: kslbegin	13	1
cache buffers chains	kcbgtcr	11	7
cache buffers chains	kcbchg: kslbegin: bufs not pinned	3	2
cache buffers chains	kcbnew: new latch again	3	0
cache buffers chains	kcbzgb: scan from tail. nowait	3	0
cache buffers chains	kclbla	3	0
cache buffers chains	kcbgtcr: fast path	2	1
cache buffers chains	kcbzpnd: dump buffers	2	0
cache buffers chains	kcbget: pin buffer	1	1
cache buffers chains	kcbso1: set no access	1	11
cost function	kzulrl	11	9
cost function	kzulgt: find user res	1	3
gcs remastering latch	59	5	0
gcs remastering latch	43	1	1
gcs remastering latch	66	1	186
gcs resource freelist	kjbralc: extend	291	0
gcs resource freelist	kjbralc add resource	1	289
gcs resource validate list	enq res to validate list	4	4
ges resource hash list	kjakcai: search for resp by resname	11	0
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	2	0
kks stats	kks stats alloc/free	32	32
library cache	kglukp: child	121	485
library cache	kglobpn: child:	69	149
library cache	kglrtl	59	15
library cache	kglhdgc: child:	48	4
library cache	kglpndl: child: before processing	21	103
library cache	kglpndl: child: after processing	14	27
library cache	kgldti: 2child	13	18
library cache	kglpin	6	21
library cache	kgldte: child 0	4	47
library cache	kglobld	4	29
library cache	kglati	3	0
library cache	kglpnc: child	2	12
library cache	kglhdgn: child:	1	96
library cache	kglpin: child: heap processing	1	4
library cache	kglpnp: child	1	61
library cache lock	kgllkdl: child: no lock handle	71	115
object queue header operation	kclobj_3	83	0
object queue header operation	kclobj_2	26	0
object queue header operation	kcbo_switch_cq	1	74
parameter table allocation management	ksp_param_table_free	2	2
row cache objects	kqreqd: reget	2	0
row cache objects	kqreqd	1	0
shared pool	kghfrunp: alloc: cursor dur	1,518	0
shared pool	kghalo	1,306	853
shared pool	kghfrunp: clatch: wait	387	62
shared pool	kghfrunp: clatch: nowait	375	0
shared pool	kghupr1	213	1,900
shared pool	kghfre	151	390
shared pool	kghalp	107	147
shared pool	kghfrunp: alloc: session dur	2	0
shared pool	kghfen: not perm alloc class	1	1
simulator lru latch	kcbssck	8	0
slave class create	ksvcreate	642	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 49,297,357
Captured Segments account for 99.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
ZDCOM	TSTEST	T_DM_YXSJBJBA	TABLE	36,098,848	73.23
ZDCOM	TSTEST	T_DM_PAIBAN	TABLE	9,878,048	20.04
ZDCOM	TSTEST	T_CORE_USERINFO	TABLE	948,080	1.92
ZDCOM	TSTEST	T_SSO_LOG	TABLE	278,480	0.56
SYS	SYSAUX	ALERT_QT	TABLE	241,024	0.49

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 51,873
Captured Segments account for 9.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
ZDCOM	TSTEST	T_JK_FULLGPSDATA20120801	TABLE	4,252	8.20
ZDCOM	TSTEST	T_DM_DDB201208	TABLE	304	0.59
SYS	SYSAUX	ALERT_QT	TABLE	163	0.31
ZDCOM	TSTEST	T_DM_DDB_LINENAME201208	INDEX	43	0.08
ZDCOM	TSTEST	T_LOG_UPDATELOG	TABLE	29	0.06

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
SYSMAN	SYSAUX	MGMT_OMS_PARAMETERS		TABLE	6	100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSAUX	SYS_IOT_TOP_8802	INDEX	2	40.00
SYSMAN	SYSAUX	MGMT_OMS_PARAMETERS	TABLE	1	20.00
SYSMAN	SYSAUX	MGMT_SEVERITY_IDX_05	INDEX	1	20.00
ZDCOM	TSTEST	T_DM_YXSJBJBA	TABLE	1	20.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

% of Capture shows % of GC Buffer Busy for each top segment compared
with GC Buffer Busy for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	GC Buffer Busy	% of Capture
ZDCOM	TSTEST	T_SSO_LOG	TABLE	8,603	86.83
SYS	SYSAUX	SYS_IOT_TOP_8802	INDEX	799	8.06
ZDCOM	TSTEST	T_JK_OVERSPEED201208	TABLE	494	4.99
ZDCOM	TSTEST	T_DM_YXSJBJBA	TABLE	10	0.10
SYS	SYSAUX	SYS_C002066	INDEX	2	0.02

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 32,439
Captured Segments account for 99.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	ALERT_QT	TABLE	20,327	62.66
SYS	SYSAUX	SYS_IOT_TOP_8802	INDEX	3,833	11.82
ZDCOM	TSTEST	T_DM_YXSJBJBA	TABLE	2,517	7.76
ZDCOM	TSTEST	T_DM_DDB201208	TABLE	1,156	3.56
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	929	2.86

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 10,508
Captured Segments account for 98.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
ZDCOM	TSTEST	T_JK_OVERSPEED201206	TABLE	5,600	53.29
ZDCOM	TSTEST	I_JK_OVERSPEED_DATE201206	INDEX	2,323	22.11
SYS	SYSAUX	SYS_IOT_TOP_8802	INDEX	541	5.15
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	299	2.85
ZDCOM	TSTEST	T_DM_DDB201208	TABLE	275	2.62

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats
Dictionary Cache Stats (RAC)

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	45	2.22	1	1
dc_database_links	7,906	0.00	0	4
dc_global_oids	739	0.41	0	131
dc_histogram_data	234,216	0.08	0	5,492
dc_histogram_defs	79,545	0.29	0	8,637
dc_object_grants	178	0.00	0	414
dc_object_ids	135,140	0.04	0	2,599
dc_objects	128,128	0.10	5	10,375
dc_profiles	225	0.00	0	2
dc_rollback_segments	6,163	0.44	38	142
dc_segments	141,477	0.04	12	7,588
dc_sequences	76	14.47	76	5
dc_tablespace_quotas	4	75.00	4	0
dc_tablespaces	19,633	0.00	0	8
dc_usernames	975	0.00	0	16
dc_users	25,019	0.00	0	73
outstanding_alerts	70	54.29	15	13

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	3	1	0
dc_global_oids	3	0	0
dc_histogram_defs	228	0	607
dc_object_ids	57	0	1,488
dc_objects	133	0	164
dc_rollback_segments	101	27	0
dc_segments	97	8	0
dc_sequences	169	11	0
dc_tablespace_quotas	8	4	0
outstanding_alerts	131	20	0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Library Cache Activity
Library Cache Activity (RAC)

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	636	0.31	1,374	2.26	27	0
CLUSTER	34	0.00	49	2.04	1	0
INDEX	36	8.33	92	22.83	18	0
SQL AREA	68,603	99.11	190,315	75.05	5,979	6
TABLE/PROCEDURE	3,056	5.60	383,479	0.36	623	0
TRIGGER	26	7.69	162	3.70	3	0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases	GES Inval Requests
CLUSTER	49	0	1	0
INDEX	92	12	7	3
TABLE/PROCEDURE	128,337	166	1,302	76

Back to Library Cache Statistics
Back to Top

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

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	664.59		8.74	24.10	160	160	76	76
	Freeable	50.94	0.00	1.00	0.41	3		51	51
	SQL	2.48	0.96	0.04	0.04	0	206	56	50
	PL/SQL	1.01	0.65	0.01	0.02	0	0	74	72
E	Other	814.50		14.29	33.37	159	159	57	57
	Freeable	32.00	0.00	1.03	0.49	3		31	31
	SQL	1.25	0.57	0.03	0.04	0	12	37	30
	PL/SQL	0.36	0.16	0.01	0.02	0	0	55	55

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	7,147,094,016
Fixed Size	2,037,128
Redo Buffers	14,737,408
Variable Size	2,751,466,104

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	ASM map operations hashta	0.38	0.38	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.60	14.60	0.00
shared	ASH buffers	29.00	29.00	0.00
shared	CCursor	168.07	168.02	-0.03
shared	KQR L PO	30.58	28.89	-5.53
shared	PCursor	103.69	105.75	1.99
shared	db_block_hash_buckets	33.63	33.63	0.00
shared	free memory	254.97	226.78	-11.06
shared	gcs resources	139.01	156.91	12.87
shared	gcs shadows	82.55	82.55	0.00
shared	kglsim heap	44.04	44.30	0.58
shared	kglsim object batch	113.29	114.31	0.90
shared	library cache	770.30	772.49	0.28
shared	sql area	401.10	408.17	1.76
	buffer_cache	6,816.00	6,816.00	0.00
	fixed_sga	1.94	1.94	0.00
	log_buffer	14.05	14.05	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

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

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	276,125	892,038	892038	892038
processes	58	150	150	150
sessions	65	170	170	170

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/admin/zdcomora/adump
background_dump_dest	/oracle/admin/zdcomora/bdump
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.1.0
control_files	+DATA/zdcomora/controlfile/current.260.780884779
core_dump_dest	/oracle/admin/zdcomora/cdump
db_block_size	8192
db_create_file_dest	+DATA
db_domain
db_file_multiblock_read_count	16
db_name	zdcomora
dispatchers	(PROTOCOL=TCP) (SERVICE=zdcomoraXDB)
instance_number	1
job_queue_processes	10
log_archive_dest_1	LOCATION=+DATA/zdcomora/
log_archive_format	%t_%s_%r.dbf
open_cursors	300
pga_aggregate_target	3304062976
processes	150
remote_listener
remote_login_passwordfile	EXCLUSIVE
sga_target	9915334656
shadow_core_dump	partial	PARTIAL
spfile	+DATA/zdcomora/spfilezdcomora.ora
thread	1
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/zdcomora/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	244,396	67.45	4.56
acks for commit broadcast(logical)	248,792	68.67	4.64
broadcast msgs on commit(actual)	56,973	15.72	1.06
broadcast msgs on commit(logical)	57,363	15.83	1.07
broadcast msgs on commit(wasted)	982	0.27	0.02
dynamically allocated gcs resources	121,856	33.63	2.27
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	1	0.00	0.00
flow control messages received	17	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	38,447	10.61	0.72
gcs ast xid	1	0.00	0.00
gcs blocked converts	3,790	1.05	0.07
gcs blocked cr converts	24,023	6.63	0.45
gcs compatible basts	33	0.01	0.00
gcs compatible cr basts (global)	401	0.11	0.01
gcs compatible cr basts (local)	37,593	10.38	0.70
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	371	0.10	0.01
gcs dbwr write request msgs	371	0.10	0.01
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	1,389	0.38	0.03
gcs immediate (null) converts	51,465	14.20	0.96
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	29,312	8.09	0.55
gcs indirect ast	36,323	10.03	0.68
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	132	0.04	0.00
gcs msgs process time(ms)	10,715	2.96	0.20
gcs msgs received	518,207	143.03	9.66
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	4	0.00	0.00
gcs queued converts	1	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	1	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	30,477	8.41	0.57
gcs side channel msgs actual	959	0.26	0.02
gcs side channel msgs logical	45,558	12.57	0.85
gcs undo cr	9	0.00	0.00
gcs write notification msgs	21	0.01	0.00
gcs writes refused	7	0.00	0.00
ges msgs process time(ms)	1,478	0.41	0.03
ges msgs received	17,629	4.87	0.33
global posts dropped	0	0.00	0.00
global posts queue time	7	0.00	0.00
global posts queued	15	0.00	0.00
global posts requested	15	0.00	0.00
global posts sent	15	0.00	0.00
implicit batch messages received	3,426	0.95	0.06
implicit batch messages sent	3,352	0.93	0.06
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	58,418	16.12	1.09
messages queue sent actual	80,467	22.21	1.50
messages queue sent logical	97,560	26.93	1.82
messages received actual	417,111	115.12	7.78
messages received logical	535,837	147.89	9.99
messages sent directly	32,684	9.02	0.61
messages sent indirectly	306,682	84.64	5.72
messages sent not implicit batched	77,115	21.28	1.44
messages sent pbatched	647,122	178.61	12.06
msgs causing lmd to send msgs	7,979	2.20	0.15
msgs causing lms(s) to send msgs	269,045	74.26	5.02
msgs received queue time (ms)	2,400,426	662.52	44.75
msgs received queued	535,840	147.89	9.99
msgs sent queue time (ms)	73,061	20.16	1.36
msgs sent queue time on ksxp (ms)	1,684,151	464.83	31.39
msgs sent queued	96,603	26.66	1.80
msgs sent queued on ksxp	381,017	105.16	7.10
process batch messages received	97,776	26.99	1.82
process batch messages sent	282,644	78.01	5.27

Global CR Served Stats

Statistic	Total
CR Block Requests	10,130
CURRENT Block Requests	162
Data Block Requests	10,130
Undo Block Requests	9
TX Block Requests	153
Current Results	9,374
Private results	3
Zero Results	915
Disk Read Results	0
Fail Results	0
Fairness Down Converts	703
Fairness Clears	0
Free GC Elements	0
Flushes	963
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	1
Errors	0

Global CURRENT Served Stats

Pins = CURRENT Block Pin Operations
Flushes = Redo Flush before CURRENT Block Served Operations
Writes = CURRENT Block Fusion Write Operations

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	75,482	100.00	0.00	0.00	0.00	0.00
Flushes	90	96.67	3.33	0.00	0.00	0.00
Writes	519	71.68	24.66	2.12	0.77	0.77

Global Cache Transfer Stats

Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
Busy (Busy) - Block Transfer impacted by Remote Contention
Congested (Congst) - Block Transfer impacted by Remote System Load
ordered by CR + Current Blocks Received desc

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	32,088	59.87	39.96	0.17	10,358	99.39	0.61	0.00
2	Others	195	99.49	0.51	0.00	105	100.00	0.00	0.00
2	undo block	121	100.00	0.00	0.00	0
2	undo header	17	94.12	5.88	0.00	3	100.00	0.00	0.00

End of Report

% Blocks changed per Read:	0.75	Recursive Call %:	52.80
Rollback per transaction %:	1.11	Rows per Sort:	########

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	99.89	In-memory Sort %:	100.00
Library Hit %:	74.93	Soft Parse %:	39.16
Execute to Parse %:	-39.03	Latch Hit %:	99.73
Parse CPU to Parse Elapsd %:	22.06	% Non-Parse CPU:	89.38

Buffer access - local cache %:	99.81
Buffer access - remote cache %:	0.09
Buffer access - disk %:	0.11

Avg global enqueue get time (ms):	2.7
Avg global cache cr block receive time (ms):	7.3
Avg global cache current block receive time (ms):	0.3
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	9.4
Avg global cache cr block flush time (ms):	0.7
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.1
Avg global cache current block flush time (ms):	0.4

Avg message sent queue time (ms):	0.8
Avg message sent queue time on ksxp (ms):	4.4
Avg message received queue time (ms):	4.5
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.1
% of direct sent messages:	8.22
% of indirect sent messages:	77.10
% of flow controlled messages:	14.69