WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

CWGKVPD 543330226 CWGKVPD1 1 10.2.0.4.0 YES GKdb1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
CWGKVPD	543330226	CWGKVPD1	1	10.2.0.4.0	YES	GKdb1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 12323 08-Mar-12 03:00:21 68 8.1

End Snap: 12324 08-Mar-12 04:00:21 67 8.0

Elapsed: 60.00 (mins)

DB Time: 120.36 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	12323	08-Mar-12 03:00:21	68	8.1
End Snap:	12324	08-Mar-12 04:00:21	67	8.0
Elapsed:		60.00 (mins)
DB Time:		120.36 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 7,168M 7,168M Std Block Size: 16K

Shared Pool Size: 4,096M 4,096M Log Buffer: 14,324K

	Begin	End
Buffer Cache:	7,168M	7,168M	Std Block Size:	16K
Shared Pool Size:	4,096M	4,096M	Log Buffer:	14,324K

Load Profile

Per Second Per Transaction

Redo size: 4,904.49 2,674.31

Logical reads: 1,159.88 632.45

Block changes: 22.77 12.42

Physical reads: 0.23 0.12

Physical writes: 0.68 0.37

User calls: 38.37 20.92

Parses: 16.47 8.98

Hard parses: 0.92 0.50

Sorts: 1.93 1.05

Logons: 0.03 0.02

Executes: 16.49 8.99

Transactions: 1.83

	Per Second	Per Transaction
Redo size:	4,904.49	2,674.31
Logical reads:	1,159.88	632.45
Block changes:	22.77	12.42
Physical reads:	0.23	0.12
Physical writes:	0.68	0.37
User calls:	38.37	20.92
Parses:	16.47	8.98
Hard parses:	0.92	0.50
Sorts:	1.93	1.05
Logons:	0.03	0.02
Executes:	16.49	8.99
Transactions:	1.83

% Blocks changed per Read: 1.96 Recursive Call %: 43.58

Rollback per transaction %: 60.18 Rows per Sort: 60.69

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 94.17 Soft Parse %: 94.43

Execute to Parse %: 0.09 Latch Hit %: 99.96

Parse CPU to Parse Elapsd %: 62.98 % Non-Parse CPU: 90.57

Shared Pool Statistics

Begin End

Memory Usage %: 79.78 79.32

% SQL with executions>1: 95.01 94.99

% Memory for SQL w/exec>1: 95.56 95.03

	Begin	End
Memory Usage %:	79.78	79.32
% SQL with executions>1:	95.01	94.99
% Memory for SQL w/exec>1:	95.56	95.03

Top 5 Timed Events

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

DFS lock handle 13,548 6,454 476 89.4 Other

reliable message 2,123 1,953 920 27.1 Other

row cache lock 1,102 628 570 8.7 Concurrency

enq: DR - contention 731 356 488 4.9 Other

CPU time 96 1.3

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
DFS lock handle	13,548	6,454	476	89.4	Other
reliable message	2,123	1,953	920	27.1	Other
row cache lock	1,102	628	570	8.7	Concurrency
enq: DR - contention	731	356	488	4.9	Other
CPU time		96		1.3

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: 0.85 0.46

Global Cache blocks served: 0.34 0.19

GCS/GES messages received: 81.35 44.36

GCS/GES messages sent: 5.00 2.73

DBWR Fusion writes: 0.02 0.01

Estd Interconnect traffic (KB) 35.91

	Per Second	Per Transaction
Global Cache blocks received:	0.85	0.46
Global Cache blocks served:	0.34	0.19
GCS/GES messages received:	81.35	44.36
GCS/GES messages sent:	5.00	2.73
DBWR Fusion writes:	0.02	0.01
Estd Interconnect traffic (KB)	35.91

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

Buffer access - local cache %: 99.91

Buffer access - remote cache %: 0.07

Buffer access - disk %: 0.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 86.7

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

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

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 %: 1.8

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

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

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

Global cache log flushes for current blocks served %: 0.0

Avg global cache current block flush time (ms):

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 38.10

% of indirect sent messages: 24.12

% of flow controlled messages: 37.78

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): 7221.8s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	7,201.48	99.72
DB CPU	96.01	1.33
parse time elapsed	20.03	0.28
hard parse elapsed time	18.43	0.26
hard parse (sharing criteria) elapsed time	2.84	0.04
PL/SQL compilation elapsed time	2.82	0.04
hard parse (bind mismatch) elapsed time	2.76	0.04
PL/SQL execution elapsed time	2.44	0.03
connection management call elapsed time	0.33	0.00
sequence load elapsed time	0.03	0.00
repeated bind elapsed time	0.00	0.00
DB time	7,221.78
background elapsed time	2,363.60
background cpu time	23.59

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
Other	467,037	99.01	8,790	19	70.74
Concurrency	2,861	7.41	629	220	0.43
Application	1,475	3.05	24	16	0.22
System I/O	54,284	0.00	18	0	8.22
Commit	2,643	0.00	2	1	0.40
Cluster	3,383	0.00	2	1	0.51
User I/O	506	0.00	2	3	0.08
Network	99,713	0.00	0	0	15.10
Configuration	11	0.00	0	1	0.00

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
DFS lock handle	13,548	97.39	6,454	476	2.05
reliable message	2,123	93.88	1,953	920	0.32
row cache lock	1,102	19.15	628	570	0.17
enq: DR - contention	731	99.86	356	488	0.11
enq: TX - row lock contention	61	73.77	23	384	0.01
enq: TD - KTF dump entries	36	88.89	17	475	0.01
control file sequential read	48,551	0.00	13	0	7.35
Streams AQ: qmn coordinator waiting for slave to start	1	100.00	5	4883	0.00
CGS wait for IPC msg	442,166	100.00	3	0	66.97
log file sync	2,643	0.00	2	1	0.40
log file parallel write	3,559	0.00	2	1	0.54
control file parallel write	1,204	0.00	1	1	0.18
db file sequential read	364	0.00	1	3	0.06
gc cr block 2-way	1,870	0.00	1	0	0.28
db file parallel write	970	0.00	1	1	0.15
os thread startup	25	0.00	1	25	0.00
db file scattered read	140	0.00	1	4	0.02
library cache lock	1,576	0.00	1	0	0.24
gc current block 2-way	724	0.00	0	0	0.11
wait for scn ack	2,247	0.00	0	0	0.34
enq: TM - contention	140	0.00	0	2	0.02
gc current block busy	6	0.00	0	38	0.00
name-service call wait	3	0.00	0	52	0.00
gc cr multi block request	438	0.00	0	0	0.07
SQL*Net break/reset to client	1,272	0.00	0	0	0.19
SQL*Net message to client	97,835	0.00	0	0	14.82
enq: CF - contention	120	0.00	0	1	0.02
gc current grant busy	128	0.00	0	0	0.02
rdbms ipc reply	142	0.00	0	0	0.02
ksxr poll remote instances	4,429	69.65	0	0	0.67
gc cr grant 2-way	132	0.00	0	0	0.02
library cache pin	81	0.00	0	0	0.01
IPC send completion sync	81	100.00	0	0	0.01
gc current grant 2-way	71	0.00	0	0	0.01
latch free	10	0.00	0	2	0.00
enq: TT - contention	47	0.00	0	0	0.01
latch: shared pool	49	0.00	0	0	0.01
enq: PS - contention	44	0.00	0	0	0.01
gc buffer busy	12	0.00	0	1	0.00
SQL*Net more data to client	594	0.00	0	0	0.09
PX Deq: Signal ACK	11	27.27	0	1	0.00
PX Deq: reap credit	1,157	98.70	0	0	0.18
cursor: pin S wait on X	1	100.00	0	10	0.00
SQL*Net more data from client	1,284	0.00	0	0	0.19
enq: HW - contention	11	0.00	0	1	0.00
enq: TA - contention	12	0.00	0	0	0.00
enq: TS - contention	6	0.00	0	1	0.00
enq: WF - contention	10	0.00	0	0	0.00
PX Deq Credit: send blkd	16	12.50	0	0	0.00
latch: library cache	11	0.00	0	0	0.00
gcs log flush sync	17	11.76	0	0	0.00
gc cr block busy	2	0.00	0	1	0.00
enq: FB - contention	4	0.00	0	0	0.00
latch: ges resource hash list	25	0.00	0	0	0.00
KJC: Wait for msg sends to complete	36	0.00	0	0	0.01
enq: RO - fast object reuse	2	0.00	0	0	0.00
LGWR wait for redo copy	11	0.00	0	0	0.00
buffer busy waits	12	0.00	0	0	0.00
direct path write	2	0.00	0	0	0.00
ges inquiry response	1	0.00	0	0	0.00
latch: cache buffers chains	4	0.00	0	0	0.00
latch: session allocation	1	0.00	0	0	0.00
PX qref latch	1	100.00	0	0	0.00
buffer deadlock	1	100.00	0	0	0.00
SQL*Net message from client	97,835	0.00	129,713	1326	14.82
gcs remote message	487,104	99.21	14,058	29	73.78
Streams AQ: qmn slave idle wait	133	3.01	3,587	26967	0.02
DIAG idle wait	17,990	0.00	3,513	195	2.72
ges remote message	63,155	96.19	3,512	56	9.57
Streams AQ: waiting for messages in the queue	372	100.00	3,509	9434	0.06
Streams AQ: qmn coordinator idle wait	273	53.85	3,485	12764	0.04
Streams AQ: waiting for time management or cleanup tasks	12	100.00	3,244	270350	0.00
PX Idle Wait	659	94.39	1,558	2364	0.10
jobq slave wait	428	100.00	1,254	2930	0.06
PX Deq: Execution Msg	186	31.72	31	168	0.03
PX Deq: Parse Reply	30	60.00	27	890	0.00
PX Deq: Join ACK	19	36.84	5	280	0.00
PX Deq: Execute Reply	17	35.29	0	1	0.00
PX Deq: Msg Fragment	39	33.33	0	0	0.01
Streams AQ: RAC qmn coordinator idle wait	273	100.00	0	0	0.04
class slave wait	2	0.00	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
events in waitclass Other	452,343	99.07	2,317	5	68.52
control file sequential read	9,760	0.00	4	0	1.48
log file parallel write	3,559	0.00	2	1	0.54
control file parallel write	1,204	0.00	1	1	0.18
db file parallel write	970	0.00	1	1	0.15
os thread startup	25	0.00	1	25	0.00
gc cr block 2-way	418	0.00	0	0	0.06
gc current block 2-way	170	0.00	0	0	0.03
enq: TM - contention	132	0.00	0	0	0.02
row cache lock	167	0.00	0	0	0.03
library cache lock	24	0.00	0	0	0.00
gc current grant busy	15	0.00	0	0	0.00
enq: HW - contention	5	0.00	0	0	0.00
enq: RO - fast object reuse	2	0.00	0	0	0.00
direct path write	2	0.00	0	0	0.00
buffer busy waits	3	0.00	0	0	0.00
rdbms ipc message	56,339	89.94	46,586	827	8.53
gcs remote message	487,100	99.21	14,058	29	73.78
pmon timer	1,211	100.00	3,515	2902	0.18
DIAG idle wait	17,990	0.00	3,513	195	2.72
ges remote message	63,151	96.21	3,511	56	9.57
Streams AQ: qmn coordinator idle wait	273	53.85	3,485	12764	0.04
smon timer	13	92.31	3,287	252847	0.00
Streams AQ: waiting for time management or cleanup tasks	12	100.00	3,244	270350	0.00
PX Deq: Parse Reply	30	60.00	27	890	0.00
PX Deq: Join ACK	19	36.84	5	280	0.00
PX Deq: Execute Reply	17	35.29	0	1	0.00
Streams AQ: RAC qmn coordinator idle wait	273	100.00	0	0	0.04

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	2,978
AVG_IDLE_TIME	357,836
AVG_IOWAIT_TIME	108
AVG_SYS_TIME	1,381
AVG_USER_TIME	1,489
BUSY_TIME	49,425
IDLE_TIME	5,727,118
IOWAIT_TIME	3,187
SYS_TIME	23,849
USER_TIME	25,576
LOAD	0
OS_CPU_WAIT_TIME	68,400
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	49,392,123,904
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
SYS$USERS	7,221.80	96.00	813	4,148,064
CWGK	0.00	0.00	0	0
CWGKVPD	0.00	0.00	0	0
SYS$BACKGROUND	0.00	0.00	0	27,496

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
SYS$USERS	419	160	2374	62854	99534	10
CWGKVPD	0	0	0	0	0	0
SYS$BACKGROUND	87	2	483	79	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
7,083	0	6	1180.49	98.08	dqmvgn5svxvcm	JDBC Thin Client	BEGIN PA_FMIS_BASE.NEWENTITY(:...
23	0	360	0.06	0.32	fhdxrqd4stwqk	JDBC Thin Client	SELECT * FROM QRTZ_LOCKS WHERE...
16	16	21	0.79	0.23	a8gqd7rwbm8yv		select f.tablespace_name as na...
10	7	260	0.04	0.13	1unfxrq5p4p7y	JDBC Thin Client	SELECT '5069.'\|\|DXID DXID FROM...
8	2	21	0.38	0.11	80yr9qa4w5gts		select df.tablespace_name as t...
6	6	32	0.19	0.09	c4rtfbah05hfd		SELECT NULL AS pktable_cat, ...
2	2	311	0.01	0.03	7hgpugh2xm0a7		delete from NBI_BYTEARRAY_FOR_...
2	2	311	0.01	0.03	3gmcbfvsz816n		select /+ all_rows / count(...
2	0	21	0.09	0.03	a28cyw6c6p2nm		select tablespace_name as name...
2	2	7,364	0.00	0.03	3my81td8y2rm3	JDBC Thin Client	BEGIN vPD_PKG.SET_CONTEXT_COMP...

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
16	16	21	0.78	0.23	a8gqd7rwbm8yv		select f.tablespace_name as na...
7	10	260	0.03	0.13	1unfxrq5p4p7y	JDBC Thin Client	SELECT '5069.'\|\|DXID DXID FROM...
6	6	32	0.19	0.09	c4rtfbah05hfd		SELECT NULL AS pktable_cat, ...
2	2	311	0.01	0.03	7hgpugh2xm0a7		delete from NBI_BYTEARRAY_FOR_...
2	8	21	0.10	0.11	80yr9qa4w5gts		select df.tablespace_name as t...
2	2	311	0.01	0.03	3gmcbfvsz816n		select /+ all_rows / count(...
2	2	7,364	0.00	0.03	3my81td8y2rm3	JDBC Thin Client	BEGIN vPD_PKG.SET_CONTEXT_COMP...
1	2	6	0.20	0.03	5p6jc91q68nj0	JDBC Thin Client	UPDATE XTYHXX SET STOPED = 1 W...
1	1	36	0.02	0.02	0jn5hzudm8han		select * from ( select logeven...
1	1	6	0.09	0.01	f6ynnf6u0cmv4	JDBC Thin Client	UPDATE XTYHXX SET XSMC = :1, ...
0	7,083	6	0.06	98.08	dqmvgn5svxvcm	JDBC Thin Client	BEGIN PA_FMIS_BASE.NEWENTITY(:...

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: 4,175,464
Captured SQL account for 48.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
769,851	21	36,659.57	18.44	16.37	16.49	a8gqd7rwbm8yv		select f.tablespace_name as na...
588,120	260	2,262.00	14.09	7.50	9.57	1unfxrq5p4p7y	JDBC Thin Client	SELECT '5069.'\|\|DXID DXID FROM...
219,263	311	705.03	5.25	2.03	2.12	7hgpugh2xm0a7		delete from NBI_BYTEARRAY_FOR_...
215,834	311	694.00	5.17	1.95	2.03	3gmcbfvsz816n		select /+ all_rows / count(...
74,934	32	2,341.69	1.79	6.01	6.19	c4rtfbah05hfd		SELECT NULL AS pktable_cat, ...
26,569	6	4,428.17	0.64	1.17	1.91	5p6jc91q68nj0	JDBC Thin Client	UPDATE XTYHXX SET STOPED = 1 W...
23,304	36	647.33	0.56	0.69	1.09	0jn5hzudm8han		select * from ( select logeven...
12,495	21	595.00	0.30	2.01	7.90	80yr9qa4w5gts		select df.tablespace_name as t...
12,492	18	694.00	0.30	0.55	0.71	0jbc3ny0twdry		select * from ( select logeven...
11,770	6	1,961.67	0.28	0.55	0.78	f6ynnf6u0cmv4	JDBC Thin Client	UPDATE XTYHXX SET XSMC = :1, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 813
Captured SQL account for 0.1% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1	32	0.03	0.12	6.01	6.19	c4rtfbah05hfd		SELECT NULL AS pktable_cat, ...
0	18	0.00	0.00	0.55	0.71	0jbc3ny0twdry		select * from ( select logeven...
0	36	0.00	0.00	0.69	1.09	0jn5hzudm8han		select * from ( select logeven...
0	1	0.00	0.00	0.26	0.26	123aya340ss4a		select null as table_cat, ...
0	2,520	0.00	0.00	0.09	0.09	15dyr87r4w2a1	JDBC Thin Client	SELECT * FROM QRTZ_CRON_TRIGGE...
0	544	0.00	0.00	0.05	0.05	181pph9d2w4bq	JDBC Thin Client	begin :con := VPD_PKG.FILTER_D...
0	260	0.00	0.00	0.25	0.25	1gtksdg355a1b	JDBC Thin Client	SELECT SYDW FROM XTGLDX5029 A,...
0	33	0.00	0.00	0.00	0.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
0	44	0.00	0.00	0.01	0.01	1ug9us08315bc	JDBC Thin Client	SELECT COUNT(*) FROM DBA_TRIGG...
0	260	0.00	0.00	7.50	9.57	1unfxrq5p4p7y	JDBC Thin Client	SELECT '5069.'\|\|DXID DXID FROM...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 59,357
Captured SQL account for 49.4% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
7,364	7,364	1.00	3my81td8y2rm3	JDBC Thin Client	BEGIN vPD_PKG.SET_CONTEXT_COMP...
4,508	4,508	1.00	6pgaqa2kcx6vs	JDBC Thin Client	SELECT SYS_CONTEXT('VPD_CONTEX...
2,520	0	0.00	15dyr87r4w2a1	JDBC Thin Client	SELECT * FROM QRTZ_CRON_TRIGGE...
2,520	2,520	1.00	b70fnskn0kam7	JDBC Thin Client	SELECT * FROM QRTZ_TRIGGERS WH...
1,560	1,560	1.00	1x2t90bpshx95	JDBC Thin Client	begin :con := VPD_PKG.FILTER_D...
1,080	0	0.00	4hc8pzq5901r9	JDBC Thin Client	SELECT TRIGGER_NAME, TRIGGER_...
804	804	1.00	3mmcwuyvjx2d9		select hibernate_sequence.next...
720	359	0.50	fudsnu0u8fuhj	JDBC Thin Client	select * from xtclusterlock wh...
704	0	0.00	dtgu0gb2u9y64	JDBC Thin Client	select username from xtcluster...
544	544	1.00	181pph9d2w4bq	JDBC Thin Client	begin :con := VPD_PKG.FILTER_D...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 59,304
Captured SQL account for 49.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
7,364	7,364	12.42	3my81td8y2rm3	JDBC Thin Client	BEGIN vPD_PKG.SET_CONTEXT_COMP...
4,508	4,508	7.60	6pgaqa2kcx6vs	JDBC Thin Client	SELECT SYS_CONTEXT('VPD_CONTEX...
2,520	2,520	4.25	15dyr87r4w2a1	JDBC Thin Client	SELECT * FROM QRTZ_CRON_TRIGGE...
2,520	2,520	4.25	b70fnskn0kam7	JDBC Thin Client	SELECT * FROM QRTZ_TRIGGERS WH...
1,560	1,560	2.63	1x2t90bpshx95	JDBC Thin Client	begin :con := VPD_PKG.FILTER_D...
1,080	1,080	1.82	4hc8pzq5901r9	JDBC Thin Client	SELECT TRIGGER_NAME, TRIGGER_...
804	804	1.36	3mmcwuyvjx2d9		select hibernate_sequence.next...
720	720	1.21	fudsnu0u8fuhj	JDBC Thin Client	select * from xtclusterlock wh...
704	704	1.19	dtgu0gb2u9y64	JDBC Thin Client	select username from xtcluster...
544	544	0.92	181pph9d2w4bq	JDBC Thin Client	begin :con := VPD_PKG.FILTER_D...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,501,807	4	0.03	5jxwda6s8nvc7		select tablespace_id, rfno, ...

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
60	4	5jxwda6s8nvc7		select tablespace_id, rfno, ...
25	2,520	15dyr87r4w2a1	JDBC Thin Client	SELECT * FROM QRTZ_CRON_TRIGGE...
25	4	a1xgxtssv5rrp		select sum(used_blocks), ts.t...
25	2,520	b70fnskn0kam7	JDBC Thin Client	SELECT * FROM QRTZ_TRIGGERS WH...

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
0.42	2.55	16.49	16.37	21	a8gqd7rwbm8yv		select f.tablespace_name as na...
0.41	21.21	1.91	1.17	6	5p6jc91q68nj0	JDBC Thin Client	UPDATE XTYHXX SET STOPED = 1 W...
0.05	2.82	1.93	0.44	21	a28cyw6c6p2nm		select tablespace_name as name...
0.02	0.00	7,082.91	0.34	6	dqmvgn5svxvcm	JDBC Thin Client	BEGIN PA_FMIS_BASE.NEWENTITY(:...
0.02	15.20	0.15	0.15	704	dtgu0gb2u9y64	JDBC Thin Client	select username from xtcluster...
0.02	41.77	0.04	0.04	345	29tgxad9bpwfd	JDBC Thin Client	select * from xtclusterlock wh...
0.01	0.06	22.95	0.13	360	fhdxrqd4stwqk	JDBC Thin Client	SELECT * FROM QRTZ_LOCKS WHERE...
0.01	3.35	0.30	0.16	1	c2aw4fq306q4k		INSERT /+ APPEND / INTO WRH$...
0.01	1.17	0.78	0.55	6	f6ynnf6u0cmv4	JDBC Thin Client	UPDATE XTYHXX SET XSMC = :1, ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0jbc3ny0twdry select * from ( select logevent0_.ID_ as ID1_31_, logevent0_.TIME_ as TIME2_31_, logevent0_.TYPE_ as TYPE3_31_, logevent0_.MSG_ as MSG4_31_, logevent0_.STATUS_ as STATUS5_31_, logevent0_.INTRULE_ID_ as INTRULE6_31_, logevent0_.INTRULE_NAME_ as INTRULE7_31_, logevent0_.DATA_ as DATA8_31_, logevent0_.HANDLED_ as HANDLED9_31_ from NBI_LOG_EVENT logevent0_ where logevent0_.TIME_<:1 and logevent0_.HANDLED_=0 and logevent0_.STATUS_='INFO' ) where rownum <= :2

0jn5hzudm8han select * from ( select logevent0_.ID_ as ID1_31_, logevent0_.TIME_ as TIME2_31_, logevent0_.TYPE_ as TYPE3_31_, logevent0_.MSG_ as MSG4_31_, logevent0_.STATUS_ as STATUS5_31_, logevent0_.INTRULE_ID_ as INTRULE6_31_, logevent0_.INTRULE_NAME_ as INTRULE7_31_, logevent0_.DATA_ as DATA8_31_, logevent0_.HANDLED_ as HANDLED9_31_ from NBI_LOG_EVENT logevent0_ where logevent0_.HANDLED_=1 ) where rownum <= :1

123aya340ss4a select null as table_cat, owner as table_schem, table_name, 0 as NON_UNIQUE, null as index_qualifier, null as index_name, 0 as type, 0 as ordinal_position, null as column_name, null as asc_or_desc, num_rows as cardinality, blocks as pages, null as filter_condition from all_tables where table_name = 'NBI_BYTEBLOCK_FOR_DATACACHE' and owner = 'NBI' union select null as table_cat, i.owner as table_schem, i.table_name, decode (i.uniqueness, 'UNIQUE', 0, 1), null as index_qualifier, i.index_name, 1 as type, c.column_position as ordinal_position, c.column_name, null as asc_or_desc, i.distinct_keys as cardinality, i.leaf_blocks as pages, null as filter_condition from all_indexes i, all_ind_columns c where i.table_name = 'NBI_BYTEBLOCK_FOR_DATACACHE' and i.owner = 'NBI' and i.index_name = c.index_name and i.table_owner = c.table_owner and i.table_name = c.table_name and i.owner = c.index_owner order by non_unique, type, index_name, ordinal_position

15dyr87r4w2a1 SELECT * FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2

181pph9d2w4bq begin :con := VPD_PKG.FILTER_DXCOMPID2(:sn, :on); end;

1gtksdg355a1b SELECT SYDW FROM XTGLDX5029 A, XTGLDX5001 B WHERE A.CID = B.DXID AND trim(A.DXDM) = :1

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1ug9us08315bc SELECT COUNT(*) FROM DBA_TRIGGERS WHERE TRIGGER_NAME='TR_DDL_TRACE' AND OWNER='SYSTEM'

1unfxrq5p4p7y SELECT '5069.'||DXID DXID FROM XTGLDX5069 WHERE TRIM(DXMC)=TRIM(:1)

1x2t90bpshx95 begin :con := VPD_PKG.FILTER_DXCOMPID3(:sn, :on); end;

29tgxad9bpwfd select * from xtclusterlock where clustername='GRIS_CLUSTER' and objkind='MessagePlatformNew'

3gmcbfvsz816n select /*+ all_rows */ count(1) from "NBI"."NBI_LOG_EVENT" where "DATA_" = :1

3mmcwuyvjx2d9 select hibernate_sequence.nextval from dual

3my81td8y2rm3 BEGIN vPD_PKG.SET_CONTEXT_COMPID('0300'); END;

4hc8pzq5901r9 SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = :1 AND NEXT_FIRE_TIME < :2 AND (NEXT_FIRE_TIME >= :3) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC

5jxwda6s8nvc7 select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))

5p6jc91q68nj0 UPDATE XTYHXX SET STOPED = 1 WHERE YHMC IN (SELECT B.YHMC FROM USERPOSTEXCHANGE A , XTYHXX B WHERE UPPER(B.YHMC) = UPPER(A.YHMC(+)) AND B.USERTYPE = 1 AND A.YHMC IS NULL)

6pgaqa2kcx6vs SELECT SYS_CONTEXT('VPD_CONTEXT', 'COMPID') AS VPD_CONTEXT FROM DUAL

7hgpugh2xm0a7 delete from NBI_BYTEARRAY_FOR_LOGEVENT where ID_=:1

80yr9qa4w5gts select df.tablespace_name as tn, df.file_name as fn, f.phyrds as pyr, f.phyblkrd as pbr, f.phywrts as pyw, f.phyblkwrt as pbw from sys.v_$filestat f, sys.dba_data_files df where f.file# = df.file_id order by df.tablespace_name

a1xgxtssv5rrp select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#

a28cyw6c6p2nm select tablespace_name as name, to_char(sum(bytes)) as bytes from sys.dba_data_files group by tablespace_name order by name

a8gqd7rwbm8yv select f.tablespace_name as name, sum(f.bytes) as used from SYS.Dba_Segments f group by f.tablespace_name

b70fnskn0kam7 SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2

c2aw4fq306q4k 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, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, 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, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, 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)

c4rtfbah05hfd SELECT NULL AS pktable_cat, p.owner as pktable_schem, p.table_name as pktable_name, pc.column_name as pkcolumn_name, NULL as fktable_cat, f.owner as fktable_schem, f.table_name as fktable_name, fc.column_name as fkcolumn_name, fc.position as key_seq, NULL as update_rule, decode (f.delete_rule, 'CASCADE', 0, 'SET NULL', 2, 1) as delete_rule, f.constraint_name as fk_name, p.constraint_name as pk_name, decode(f.deferrable, 'DEFERRABLE', 5 , 'NOT DEFERRABLE', 7 , 'DEFERRED', 6 ) deferrability FROM all_cons_columns pc, all_constraints p, all_cons_columns fc, all_constraints f WHERE 1 = 1 AND f.table_name = :2 AND f.owner = :4 AND f.constraint_type = 'R' AND p.owner = f.r_owner AND p.constraint_name = f.r_constraint_name AND p.constraint_type = 'P' AND pc.owner = p.owner AND pc.constraint_name = p.constraint_name AND pc.table_name = p.table_name AND fc.owner = f.owner AND fc.constraint_name = f.constraint_name AND fc.table_name = f.table_name AND fc.position = pc.position ORDER BY pktable_schem, pktable_name, key_seq

dqmvgn5svxvcm BEGIN PA_FMIS_BASE.NEWENTITY(:1, :2); END;

dtgu0gb2u9y64 select username from xtclusteruser where userid=-9999

f6ynnf6u0cmv4 UPDATE XTYHXX SET XSMC = :1, EMAIL = :2, STOPED = :3 WHERE UPPER(YHMC) = UPPER(:4)

fhdxrqd4stwqk SELECT * FROM QRTZ_LOCKS WHERE LOCK_NAME = :1 FOR UPDATE

fudsnu0u8fuhj select * from xtclusterlock where clustername='GRIS_CLUSTER' and objkind='MessagePlatform'

SQL Id	SQL Text
0jbc3ny0twdry	select * from ( select logevent0_.ID_ as ID1_31_, logevent0_.TIME_ as TIME2_31_, logevent0_.TYPE_ as TYPE3_31_, logevent0_.MSG_ as MSG4_31_, logevent0_.STATUS_ as STATUS5_31_, logevent0_.INTRULE_ID_ as INTRULE6_31_, logevent0_.INTRULE_NAME_ as INTRULE7_31_, logevent0_.DATA_ as DATA8_31_, logevent0_.HANDLED_ as HANDLED9_31_ from NBI_LOG_EVENT logevent0_ where logevent0_.TIME_<:1 and logevent0_.HANDLED_=0 and logevent0_.STATUS_='INFO' ) where rownum <= :2
0jn5hzudm8han	select * from ( select logevent0_.ID_ as ID1_31_, logevent0_.TIME_ as TIME2_31_, logevent0_.TYPE_ as TYPE3_31_, logevent0_.MSG_ as MSG4_31_, logevent0_.STATUS_ as STATUS5_31_, logevent0_.INTRULE_ID_ as INTRULE6_31_, logevent0_.INTRULE_NAME_ as INTRULE7_31_, logevent0_.DATA_ as DATA8_31_, logevent0_.HANDLED_ as HANDLED9_31_ from NBI_LOG_EVENT logevent0_ where logevent0_.HANDLED_=1 ) where rownum <= :1
123aya340ss4a	select null as table_cat, owner as table_schem, table_name, 0 as NON_UNIQUE, null as index_qualifier, null as index_name, 0 as type, 0 as ordinal_position, null as column_name, null as asc_or_desc, num_rows as cardinality, blocks as pages, null as filter_condition from all_tables where table_name = 'NBI_BYTEBLOCK_FOR_DATACACHE' and owner = 'NBI' union select null as table_cat, i.owner as table_schem, i.table_name, decode (i.uniqueness, 'UNIQUE', 0, 1), null as index_qualifier, i.index_name, 1 as type, c.column_position as ordinal_position, c.column_name, null as asc_or_desc, i.distinct_keys as cardinality, i.leaf_blocks as pages, null as filter_condition from all_indexes i, all_ind_columns c where i.table_name = 'NBI_BYTEBLOCK_FOR_DATACACHE' and i.owner = 'NBI' and i.index_name = c.index_name and i.table_owner = c.table_owner and i.table_name = c.table_name and i.owner = c.index_owner order by non_unique, type, index_name, ordinal_position
15dyr87r4w2a1	SELECT * FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
181pph9d2w4bq	begin :con := VPD_PKG.FILTER_DXCOMPID2(:sn, :on); end;
1gtksdg355a1b	SELECT SYDW FROM XTGLDX5029 A, XTGLDX5001 B WHERE A.CID = B.DXID AND trim(A.DXDM) = :1
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1ug9us08315bc	SELECT COUNT(*) FROM DBA_TRIGGERS WHERE TRIGGER_NAME='TR_DDL_TRACE' AND OWNER='SYSTEM'
1unfxrq5p4p7y	SELECT '5069.'\|\|DXID DXID FROM XTGLDX5069 WHERE TRIM(DXMC)=TRIM(:1)
1x2t90bpshx95	begin :con := VPD_PKG.FILTER_DXCOMPID3(:sn, :on); end;
29tgxad9bpwfd	select * from xtclusterlock where clustername='GRIS_CLUSTER' and objkind='MessagePlatformNew'
3gmcbfvsz816n	select /+ all_rows / count(1) from "NBI"."NBI_LOG_EVENT" where "DATA_" = :1
3mmcwuyvjx2d9	select hibernate_sequence.nextval from dual
3my81td8y2rm3	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0300'); END;
4hc8pzq5901r9	SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = :1 AND NEXT_FIRE_TIME < :2 AND (NEXT_FIRE_TIME >= :3) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
5jxwda6s8nvc7	select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))
5p6jc91q68nj0	UPDATE XTYHXX SET STOPED = 1 WHERE YHMC IN (SELECT B.YHMC FROM USERPOSTEXCHANGE A , XTYHXX B WHERE UPPER(B.YHMC) = UPPER(A.YHMC(+)) AND B.USERTYPE = 1 AND A.YHMC IS NULL)
6pgaqa2kcx6vs	SELECT SYS_CONTEXT('VPD_CONTEXT', 'COMPID') AS VPD_CONTEXT FROM DUAL
7hgpugh2xm0a7	delete from NBI_BYTEARRAY_FOR_LOGEVENT where ID_=:1
80yr9qa4w5gts	select df.tablespace_name as tn, df.file_name as fn, f.phyrds as pyr, f.phyblkrd as pbr, f.phywrts as pyw, f.phyblkwrt as pbw from sys.v_$filestat f, sys.dba_data_files df where f.file# = df.file_id order by df.tablespace_name
a1xgxtssv5rrp	select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
a28cyw6c6p2nm	select tablespace_name as name, to_char(sum(bytes)) as bytes from sys.dba_data_files group by tablespace_name order by name
a8gqd7rwbm8yv	select f.tablespace_name as name, sum(f.bytes) as used from SYS.Dba_Segments f group by f.tablespace_name
b70fnskn0kam7	SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
c2aw4fq306q4k	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, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, 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, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, 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)
c4rtfbah05hfd	SELECT NULL AS pktable_cat, p.owner as pktable_schem, p.table_name as pktable_name, pc.column_name as pkcolumn_name, NULL as fktable_cat, f.owner as fktable_schem, f.table_name as fktable_name, fc.column_name as fkcolumn_name, fc.position as key_seq, NULL as update_rule, decode (f.delete_rule, 'CASCADE', 0, 'SET NULL', 2, 1) as delete_rule, f.constraint_name as fk_name, p.constraint_name as pk_name, decode(f.deferrable, 'DEFERRABLE', 5 , 'NOT DEFERRABLE', 7 , 'DEFERRED', 6 ) deferrability FROM all_cons_columns pc, all_constraints p, all_cons_columns fc, all_constraints f WHERE 1 = 1 AND f.table_name = :2 AND f.owner = :4 AND f.constraint_type = 'R' AND p.owner = f.r_owner AND p.constraint_name = f.r_constraint_name AND p.constraint_type = 'P' AND pc.owner = p.owner AND pc.constraint_name = p.constraint_name AND pc.table_name = p.table_name AND fc.owner = f.owner AND fc.constraint_name = f.constraint_name AND fc.table_name = f.table_name AND fc.position = pc.position ORDER BY pktable_schem, pktable_name, key_seq
dqmvgn5svxvcm	BEGIN PA_FMIS_BASE.NEWENTITY(:1, :2); END;
dtgu0gb2u9y64	select username from xtclusteruser where userid=-9999
f6ynnf6u0cmv4	UPDATE XTYHXX SET XSMC = :1, EMAIL = :2, STOPED = :3 WHERE UPPER(YHMC) = UPPER(:4)
fhdxrqd4stwqk	SELECT * FROM QRTZ_LOCKS WHERE LOCK_NAME = :1 FOR UPDATE
fudsnu0u8fuhj	select * from xtclusterlock where clustername='GRIS_CLUSTER' and objkind='MessagePlatform'

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	7,288	2.02	1.10
CPU used when call started	6,971	1.94	1.06
CR blocks created	1,154	0.32	0.17
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	1,227,188	340.89	185.88
DBWR checkpoint buffers written	2,399	0.67	0.36
DBWR checkpoints	1	0.00	0.00
DBWR fusion writes	69	0.02	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	104	0.03	0.02
DBWR undo block writes	910	0.25	0.14
DFO trees parallelized	8	0.00	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	20	0.01	0.00
PX local messages sent	20	0.01	0.00
PX remote messages recv'd	108	0.03	0.02
PX remote messages sent	86	0.02	0.01
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	8	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	5,402	1.50	0.82
RowCR hits	5,402	1.50	0.82
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	97,656	27.13	14.79
active txn count during cleanout	371	0.10	0.06
application wait time	2,382	0.66	0.36
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	13,219	3.67	2.00
branch node splits	0	0.00	0.00
buffer is not pinned count	454,857	126.35	68.90
buffer is pinned count	2,029,006	563.63	307.33
bytes received via SQL*Net from client	14,815,097	4,115.40	2,244.03
bytes sent via SQL*Net to client	16,286,967	4,524.26	2,466.97
calls to get snapshot scn: kcmgss	105,312	29.25	15.95
calls to kcmgas	11,438	3.18	1.73
calls to kcmgcs	92	0.03	0.01
change write time	48	0.01	0.01
cleanout - number of ktugct calls	351	0.10	0.05
cleanouts and rollbacks - consistent read gets	247	0.07	0.04
cleanouts only - consistent read gets	15	0.00	0.00
cluster key scan block gets	33,169	9.21	5.02
cluster key scans	18,729	5.20	2.84
cluster wait time	176	0.05	0.03
commit batch/immediate performed	276	0.08	0.04
commit batch/immediate requested	276	0.08	0.04
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	12	0.00	0.00
commit cleanout failures: cannot pin	8	0.00	0.00
commit cleanouts	9,087	2.52	1.38
commit cleanouts successfully completed	9,067	2.52	1.37
commit immediate performed	276	0.08	0.04
commit immediate requested	276	0.08	0.04
commit txn count during cleanout	69	0.02	0.01
concurrency wait time	62,934	17.48	9.53
consistent changes	3,503	0.97	0.53
consistent gets	4,089,098	1,135.89	619.37
consistent gets - examination	111,056	30.85	16.82
consistent gets direct	0	0.00	0.00
consistent gets from cache	4,089,083	1,135.88	619.37
cursor authentications	84	0.02	0.01
data blocks consistent reads - undo records applied	3,491	0.97	0.53
db block changes	81,964	22.77	12.42
db block gets	86,366	23.99	13.08
db block gets direct	12	0.00	0.00
db block gets from cache	86,354	23.99	13.08
deferred (CURRENT) block cleanout applications	4,519	1.26	0.68
dirty buffers inspected	0	0.00	0.00
enqueue conversions	13,458	3.74	2.04
enqueue releases	51,094	14.19	7.74
enqueue requests	51,099	14.19	7.74
enqueue timeouts	5	0.00	0.00
enqueue waits	415	0.12	0.06
exchange deadlocks	1	0.00	0.00
execute count	59,357	16.49	8.99
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	3,426	0.95	0.52
free buffer requested	10,444	2.90	1.58
gc CPU used by this session	1,365	0.38	0.21
gc blocks lost	0	0.00	0.00
gc cr block build time	0	0.00	0.00
gc cr block flush time	0	0.00	0.00
gc cr block receive time	119	0.03	0.02
gc cr block send time	3	0.00	0.00
gc cr blocks received	2,269	0.63	0.34
gc cr blocks served	834	0.23	0.13
gc current block flush time	0	0.00	0.00
gc current block pin time	15	0.00	0.00
gc current block receive time	57	0.02	0.01
gc current block send time	0	0.00	0.00
gc current blocks received	779	0.22	0.12
gc current blocks served	402	0.11	0.06
gc local grants	1,273	0.35	0.19
gc remote grants	495	0.14	0.07
gcs messages sent	9,098	2.53	1.38
ges messages sent	8,907	2.47	1.35
global enqueue get time	417,736	116.04	63.27
global enqueue gets async	1,103	0.31	0.17
global enqueue gets sync	47,103	13.08	7.13
global enqueue releases	35,079	9.74	5.31
heap block compress	72	0.02	0.01
hot buffers moved to head of LRU	477	0.13	0.07
immediate (CR) block cleanout applications	263	0.07	0.04
immediate (CURRENT) block cleanout applications	1,408	0.39	0.21
index crx upgrade (found)	3	0.00	0.00
index crx upgrade (positioned)	3,899	1.08	0.59
index fast full scans (full)	18	0.01	0.00
index fetch by key	1,128,788	313.56	170.98
index scans kdiixs1	11,634	3.23	1.76
leaf node 90-10 splits	8	0.00	0.00
leaf node splits	9	0.00	0.00
lob reads	0	0.00	0.00
lob writes	426	0.12	0.06
lob writes unaligned	426	0.12	0.06
logons cumulative	102	0.03	0.02
messages received	5,715	1.59	0.87
messages sent	5,715	1.59	0.87
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	3,922,382	1,089.58	594.12
opened cursors cumulative	55,234	15.34	8.37
parse count (failures)	0	0.00	0.00
parse count (hard)	3,304	0.92	0.50
parse count (total)	59,304	16.47	8.98
parse time cpu	905	0.25	0.14
parse time elapsed	1,437	0.40	0.22
physical read IO requests	419	0.12	0.06
physical read bytes	13,320,192	3,700.14	2,017.60
physical read total IO requests	49,054	13.63	7.43
physical read total bytes	810,156,032	225,048.41	122,713.73
physical read total multi block requests	140	0.04	0.02
physical reads	813	0.23	0.12
physical reads cache	813	0.23	0.12
physical reads cache prefetch	394	0.11	0.06
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	1,390	0.39	0.21
physical write bytes	40,353,792	11,209.64	6,112.36
physical write total IO requests	12,153	3.38	1.84
physical write total bytes	138,313,728	38,421.34	20,950.28
physical write total multi block requests	6,717	1.87	1.02
physical writes	2,463	0.68	0.37
physical writes direct	12	0.00	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	2,451	0.68	0.37
physical writes non checkpoint	1,465	0.41	0.22
pinned buffers inspected	1	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	89,396	24.83	13.54
queries parallelized	8	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	106,700	29.64	16.16
recursive cpu usage	2,681	0.74	0.41
redo blocks written	37,920	10.53	5.74
redo buffer allocation retries	0	0.00	0.00
redo entries	43,916	12.20	6.65
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	824	0.23	0.12
redo size	17,655,764	4,904.49	2,674.31
redo subscn max counts	131	0.04	0.02
redo synch time	277	0.08	0.04
redo synch writes	2,927	0.81	0.44
redo wastage	1,099,020	305.29	166.47
redo write time	292	0.08	0.04
redo writer latching time	0	0.00	0.00
redo writes	3,559	0.99	0.54
rollback changes - undo records applied	276	0.08	0.04
rollbacks only - consistent read gets	896	0.25	0.14
rows fetched via callback	36,713	10.20	5.56
session connect time	0	0.00	0.00
session cursor cache hits	51,720	14.37	7.83
session logical reads	4,175,464	1,159.88	632.45
session pga memory	16,925,432	4,701.61	2,563.68
session pga memory max	67,011,992	18,614.86	10,150.26
session uga memory	3,131,088	869.77	474.26
session uga memory max	288,479,472	80,134.99	43,695.77
shared hash latch upgrades - no wait	9,312	2.59	1.41
shared hash latch upgrades - wait	3	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	6,959	1.93	1.05
sorts (rows)	422,315	117.31	63.97
sql area evicted	1,947	0.54	0.29
sql area purged	38	0.01	0.01
summed dirty queue length	0	0.00	0.00
switch current to new buffer	4,575	1.27	0.69
table fetch by rowid	45,019	12.51	6.82
table fetch continued row	41	0.01	0.01
table scan blocks gotten	3,861,286	1,072.60	584.87
table scan rows gotten	178,468,096	49,575.59	27,032.43
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	11,751	3.26	1.78
total number of times SMON posted	1	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction lock foreground wait time	0	0.00	0.00
transaction rollbacks	276	0.08	0.04
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	9,486,204	2,635.12	1,436.87
user I/O wait time	161	0.04	0.02
user calls	138,140	38.37	20.92
user commits	2,629	0.73	0.40
user rollbacks	3,973	1.10	0.60
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	4,577	1.27	0.69
write clones created in background	0	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	7,319,162	7,320,028
opened cursors current	548	533
logons current	68	67

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 Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
YGNBI	418	3.88	1.94	267	0	0.00
FMIS_LARGE	0	0.00	0.00	452	1	0.00
UNDOTBS1	0	0.00	0.00	277	4	0.00
SYSAUX	0	0.00	0.00	199	0	0.00
FMIS0300	0	0.00	0.00	97	7	0.00
SYSTEM	1	10.00	1.00	76	11	0.00
FMISINDEX	0	0.00	0.00	22	1	10.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
FMIS0300	/dev/rlv_free_2	0			5	0	0.00
FMIS0300	/dev/rlv_free_24	0			4	0	0.00
FMIS0300	/dev/rlv_free_3	0			14	0	0.00
FMIS0300	/dev/rlv_free_44	0			1	0	0.00
FMIS0300	/dev/rlv_free_45	0			4	0	0.00
FMIS0300	/dev/rlv_free_51	0			4	0	0.00
FMIS0300	/dev/rlv_free_53	0			4	0	0.00
FMIS0300	/dev/rlv_free_55	0			4	0	0.00
FMIS0300	/dev/rlv_vpd0300_01	0			23	5	0.00
FMIS0300	/dev/rlv_vpd0300_02	0			16	2	0.00
FMIS0300	/dev/rlv_vpd0300_03	0			6	0	0.00
FMIS0300	/dev/rlv_vpd0300_04	0			12	0	0.00
FMISINDEX	/dev/rlv_vpdindex2	0			22	1	10.00
FMIS_LARGE	/dev/rlv_vpd_large1	0			452	1	0.00
SYSAUX	/dev/rlv_vpdsysaux01	0			199	0	0.00
SYSTEM	/dev/rlv_vpdsystem01	1	10.00	1.00	23	2	0.00
SYSTEM	/dev/rlv_vpdsystem02	0			53	9	0.00
UNDOTBS1	/dev/rlv_vpdundo1_1	0			33	0	0.00
UNDOTBS1	/dev/rlv_vpdundo1_2	0			60	0	0.00
UNDOTBS1	/dev/rlv_vpdundo1_3	0			184	4	0.00
YGNBI	/dev/rlv_vpd_nbi	418	3.88	1.94	267	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	Buffer Busy Waits
D	443,520	100	4,175,352	813	2,451	24
K	15,840		0	0	0	0
R	15,840		0	0	0	0

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	0	263	3028	15821	1843200	15821
E	0	0	289	3103	18387	1843200	18387

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	704	0.10	43,560	2.95	381,269,087
D	1,408	0.20	87,120	1.74	225,018,500
D	2,112	0.29	130,680	1.37	176,726,481
D	2,816	0.39	174,240	1.21	155,964,107
D	3,520	0.49	217,800	1.13	145,663,964
D	4,224	0.59	261,360	1.08	139,620,307
D	4,928	0.69	304,920	1.05	135,703,385
D	5,632	0.79	348,480	1.03	132,919,771
D	6,336	0.88	392,040	1.01	130,780,831
D	7,040	0.98	435,600	1.00	129,379,126
D	7,168	1.00	443,520	1.00	129,191,268
D	7,744	1.08	479,160	0.99	128,378,249
D	8,448	1.18	522,720	0.99	127,364,088
D	9,152	1.28	566,280	0.98	126,512,406
D	9,856	1.38	609,840	0.97	125,700,145
D	10,560	1.47	653,400	0.97	124,986,225
D	11,264	1.57	696,960	0.96	124,416,450
D	11,968	1.67	740,520	0.96	123,990,974
D	12,672	1.77	784,080	0.96	123,557,964
D	13,376	1.87	827,640	0.95	122,885,976
D	14,080	1.96	871,200	0.93	119,987,621

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	407	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	2,000	1,585	547.39	0.00	0.00	0.00	0.00	204,800
E	2,000	1,587	545.80	0.00	0.00	0.00	0.00	204,800

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	4,238	4,238
64K	128K	47	47
128K	256K	1	1
512K	1024K	212	212
1M	2M	19	19
2M	4M	21	21
4M	8M	29	29

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
250	0.13	4,649,941.75	97,667.46	98.00	4,226
500	0.25	4,649,941.75	32,003.08	99.00	3
1,000	0.50	4,649,941.75	21,476.12	100.00	0
1,500	0.75	4,649,941.75	21,476.12	100.00	0
2,000	1.00	4,649,941.75	21,254.31	100.00	0
2,400	1.20	4,649,941.75	12,838.88	100.00	0
2,800	1.40	4,649,941.75	12,838.88	100.00	0
3,200	1.60	4,649,941.75	12,838.88	100.00	0
3,600	1.80	4,649,941.75	12,838.88	100.00	0
4,000	2.00	4,649,941.75	12,838.88	100.00	0
6,000	3.00	4,649,941.75	12,838.88	100.00	0
8,000	4.00	4,649,941.75	12,838.88	100.00	0
12,000	6.00	4,649,941.75	12,838.88	100.00	0
16,000	8.00	4,649,941.75	12,838.88	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,016	0.49	466	66,866	20,696,167	0.91	2,212,586	28.14	1,043,075,443
2,432	0.59	881	93,316	21,529,044	0.94	1,379,709	17.55	1,044,531,884
2,848	0.70	1,296	117,244	22,032,937	0.97	875,816	11.14	1,044,864,893
3,264	0.80	1,711	139,727	22,402,162	0.98	506,591	6.44	1,045,069,396
3,680	0.90	2,126	178,822	22,638,312	0.99	270,441	3.44	1,045,213,213
4,096	1.00	2,541	212,683	22,830,139	1.00	78,614	1.00	1,045,325,685
4,512	1.10	2,956	241,563	22,973,933	1.01	1	0.00	1,045,411,656
4,928	1.20	3,371	269,594	23,072,846	1.01	1	0.00	1,045,479,821
5,344	1.30	3,786	297,992	23,151,578	1.01	1	0.00	1,045,539,663
5,760	1.41	4,201	326,755	23,206,060	1.02	1	0.00	1,045,590,455
6,176	1.51	4,616	354,893	23,280,373	1.02	1	0.00	1,045,641,211
6,592	1.61	5,031	383,121	23,313,589	1.02	1	0.00	1,045,684,449
7,008	1.71	5,446	412,002	23,372,543	1.02	1	0.00	1,045,724,865
7,424	1.81	5,861	440,116	23,406,042	1.03	1	0.00	1,045,762,043
7,840	1.91	6,276	468,136	23,447,691	1.03	1	0.00	1,045,800,828
8,256	2.02	6,691	495,859	23,479,829	1.03	1	0.00	1,045,834,053

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Avg Time (ms)
data block	20	1
undo block	3	0
undo header	1	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)
DR-Distributed Recovery	2	2	0	1	365	365,119.00
TX-Transaction (row lock contention)	16	16	0	16	24	1,499.19
TD-KTF map table enqueue (KTF dump entries)	8	4	4	4	18	4,375.25
TM-DML	20,194	20,194	0	140	0	2.11
CF-Controlfile Transaction	8,570	8,570	0	120	0	0.78
TT-Tablespace	113	113	0	47	0	0.70
PS-PX Process Reservation	69	69	0	44	0	0.50
TA-Instance Undo	12	12	0	12	0	0.58
HW-Segment High Water Mark	439	439	0	10	0	0.70
WF-AWR Flush	26	26	0	10	0	0.70
TS-Temporary Segment	6	6	0	6	0	0.83
FB-Format Block	3	3	0	3	0	0.33
RO-Multiple Object Reuse (fast object reuse)	4	4	0	2	0	0.50

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	0.97	3,821	604	14	5760/5760	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
08-Mar 04:04	147	615	0	3	5,760	0/0	0/0/0/0/0/0
08-Mar 03:54	109	573	0	14	5,760	0/0	0/0/0/0/0/0
08-Mar 03:44	110	483	0	13	5,760	0/0	0/0/0/0/0/0
08-Mar 03:34	160	524	0	4	5,760	0/0	0/0/0/0/0/0
08-Mar 03:24	223	512	0	4	5,760	0/0	0/0/0/0/0/0
08-Mar 03:14	91	580	0	3	5,760	0/0	0/0/0/0/0/0
08-Mar 03:04	129	534	604	3	5,760	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	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,428	0.00		0
ASM network background latch	1	0.00		0
AWR Alerted Metric Element list	25,169	0.00		0
Consistent RBA	3,559	0.00		0
FAL request queue	72	0.00		0
FAL subheap alocation	72	0.00		0
FOB s.o list latch	543	0.00		0
JS broadcast add buf latch	823	0.00		0
JS broadcast drop buf latch	823	0.00		0
JS broadcast load blnc latch	720	0.00		0
JS mem alloc latch	8	0.00		0
JS queue access latch	8	0.00		0
JS queue state obj latch	25,920	0.00		0
JS slv state obj latch	63	0.00		0
KCL gc element parent latch	21,599	0.00		39	0.00
KJC message pool free list	6,567	0.05	0.00	413	0.00
KJCT flow control latch	28,685	0.03	0.00	0
KMG MMAN ready and startup request latch	1,200	0.00		0
KSXR large replies	118	0.00		0
KTF sga latch	12	0.00		849	0.00
KWQMN job cache list latch	300	0.00		0
KWQP Prop Status	2	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	0			1,200	0.00
OS process	366	0.00		0
OS process allocation	1,443	0.00		0
OS process: request allocation	143	0.00		0
PL/SQL warning settings	11,624	0.00		0
SGA IO buffer pool latch	10	0.00		10	0.00
SQL memory manager latch	1	0.00		1,199	0.00
SQL memory manager workarea list latch	81,612	0.00		0
Shared B-Tree	128	0.00		0
active checkpoint queue latch	3,457	0.00		0
active service list	7,734	0.01	0.00	1,211	0.00
archive control	60	0.00		0
archive process latch	1,343	0.00		0
begin backup scn array	3	0.00		0
business card	16	0.00		0
cache buffer handles	1,900	0.00		0
cache buffers chains	8,416,175	0.03	0.00	18,182	0.00
cache buffers lru chain	15,313	0.01	0.00	27,390	0.05
cache table scan latch	0			140	0.00
channel handle pool latch	145	0.00		0
channel operations parent latch	151,574	0.00	0.00	0
checkpoint queue latch	322,146	0.00		2,668	0.00
client/application info	370	0.00		0
commit callback allocation	36	0.00		0
compile environment latch	103	0.00		0
dictionary lookup	14	0.00		0
dml lock allocation	15,042	0.01	0.00	0
dummy allocation	207	0.00		0
enqueue hash chains	145,999	0.00	0.00	596	0.00
enqueues	95,785	0.00	0.00	0
error message lists	32	0.00		0
event group latch	71	0.00		0
file cache latch	821	0.00		0
gcs opaque info freelist	1,134	0.00		0
gcs partitioned table hash	19,990	0.00		0
gcs remastering latch	214	0.00		0
gcs resource freelist	519	0.00		42	0.00
gcs resource hash	14,739	0.01	0.00	0
gcs shadows freelist	157	0.00		209	0.00
ges caches resource lists	682,284	0.13	0.01	661,839	0.11
ges deadlock list	3,262	0.00		3	0.00
ges domain table	67,370	0.00		0
ges enqueue table freelist	332,856	0.00		0
ges group table	125,316	0.00	0.00	0
ges process hash list	3,628	0.00		0
ges process parent latch	420,286	0.00		7	0.00
ges process table freelist	143	0.00		0
ges resource hash list	927,638	0.01	0.23	309,164	0.00
ges resource scan list	174	0.00		0
ges resource table freelist	266,315	0.00	0.00	0
ges timeout list	1,134	0.00		46,238	0.00
global KZLD latch for mem in SGA	46	0.00		0
global ctx hash table latch	92	0.00		0
hash table column usage latch	101	0.99	0.00	383,932	0.00
hash table modification latch	98	0.00		0
job_queue_processes parameter latch	60	0.00		0
kks stats	16,210	0.06	0.20	0
kokc descriptor allocation latch	482	0.00		0
ksuosstats global area	242	0.00		0
ktm global data	13	0.00		0
kwqbsn:qsga	127	0.00		0
lgwr LWN SCN	3,768	0.00		0
library cache	443,607	0.04	0.06	14,353	0.14
library cache load lock	414	0.24	0.00	0
library cache lock	170,309	0.01	0.00	0
library cache lock allocation	1,015	0.00		0
library cache pin	200,333	0.00	0.00	0
library cache pin allocation	2,320	0.00		0
list of block allocation	224	0.00		0
loader state object freelist	2	0.00		0
logminer context allocation	1	0.00		0
message pool operations parent latch	479	0.00		0
messages	120,018	0.00	0.00	0
mostly latch-free SCN	3,772	0.05	0.00	0
multiblock read objects	1,608	0.00		0
name-service memory objects	2,620	0.00		0
name-service namespace bucket	36,253	0.00		0
name-service namespace objects	2	0.00		0
name-service pending queue	2,292	0.00		0
name-service request	6	0.00		0
name-service request queue	38,220	0.00		0
ncodef allocation latch	58	0.00		0
object queue header heap	597	0.00		213	0.00
object queue header operation	29,963	0.00	0.00	0
object stats modification	8	0.00		0
parallel query alloc buffer	784	0.00		0
parallel query stats	56	0.00		0
parallel txn reco latch	1,872	0.00		0
parameter list	12	0.00		0
parameter table allocation management	104	1.92	0.00	0
post/wait queue	4,084	0.00		2,665	0.04
process allocation	34,752	0.00		71	0.00
process group creation	143	0.00		0
process queue	142	0.00		0
process queue reference	2,560	0.04	0.00	235	0.43
qmn state object latch	3	0.00		0
qmn task queue latch	512	0.00		0
query server freelists	114	0.00		0
query server process	1	0.00		1	0.00
queued dump request	16,492	0.00		0
redo allocation	11,116	0.02	0.00	43,922	0.03
redo copy	0			43,927	0.03
redo writing	16,665	0.00		0
resmgr group change latch	100	0.00		0
resmgr:active threads	201	0.00		0
resmgr:actses change group	78	0.00		0
resmgr:free threads list	200	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	443,274	0.37	0.00	795	0.00
rules engine aggregate statistics	12	0.00		0
rules engine rule set statistics	124	0.00		0
sequence cache	2,704	0.00		0
session allocation	48,631	0.09	0.02	0
session idle bit	291,515	0.00	0.00	0
session state list latch	294	0.00		0
session switching	58	0.00		0
session timer	1,211	0.00		0
shared pool	183,171	0.10	0.26	0
shared pool simulator	330,503	0.00	0.00	0
simulator hash latch	255,040	0.00		0
simulator lru latch	0			254,904	0.03
slave class	4	0.00		0
slave class create	15	6.67	1.00	0
sort extent pool	120	0.00		0
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
threshold alerts latch	322	0.00		0
transaction allocation	57	0.00		0
transaction branch allocation	1,211	0.00		0
undo global data	43,268	0.00		0
user lock	207	0.48	0.00	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	8,416,175	2,235	4	2,231
ges caches resource lists	682,284	912	7	905
library cache	443,607	191	11	186
shared pool	183,171	187	49	147
ges resource hash list	927,638	110	25	85
session allocation	48,631	45	1	44
kks stats	16,210	10	2	8
slave class create	15	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
cache buffers chains	kcbchg: kslbegin: bufs not pinned	3	2
cache buffers chains	kcbgcur: kslbegin	2	1
cache buffers chains	kcbgtcr: kslbegin excl	2	3
ges resource hash list	kjrmas1: lookup master node	17	0
ges resource hash list	kjrref: find matched resource	7	16
ges resource hash list	kjakcai: search for resp by resname	1	0
ges resource table freelist	kjrchc: cached obj cleanup	4	0
ges resource table freelist	kjruch: cached obj cleanup	3	0
kks stats	kks stats alloc/free	2	2
library cache	kglScanDependency	9	0
library cache	kgldti: 2child	1	0
session allocation	ksuxds: KSUSFCLC not set	1	1
shared pool	kghalo	39	29
shared pool	kghalp	6	10
shared pool	kghfrunp: alloc: wait	4	0
shared pool	kghfrunp: clatch: wait	1	1
slave class create	ksvcreate	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by 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: 4,175,464
Captured Segments account for 97.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
NBI	YGNBI	NBI_LOG_EVENT	TABLE	2,469,904	59.15
FMIS0300	FMIS0300	XTGLDX5069	TABLE	588,400	14.09
SYS	SYSTEM	TAB$	TABLE	171,776	4.11
SYS	SYSTEM	IND$	TABLE	164,384	3.94
SYS	SYSTEM	CLU$	TABLE	163,776	3.92

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 813
Captured Segments account for 4.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
NBI	YGNBI	NBI_BYTEBLOCK_FOR_LOGEVENT		TABLE	36	4.43
SYS	SYSTEM	I_CON1		INDEX	1	0.12

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
FMIS0300	FMIS_LARGE	XTYHXX	YHXX_PA_01	TABLE PARTITION	14	43.75
FMIS0300	FMIS0300	QRTZ_LOCKS		TABLE	12	37.50
FMIS0300	FMISINDEX	IDU060712193340934		INDEX	3	9.38
NBI	YGNBI	SYS_C00614301		INDEX	3	9.38

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
FMIS0300	FMIS0300	XTCLUSTERLOCK		TABLE	4	50.00
SYS	SYSTEM	I_DEPENDENCY1		INDEX	1	12.50
SYS	SYSTEM	OBJ$		TABLE	1	12.50
SYS	SYSTEM	SEG$		TABLE	1	12.50
FMIS0300	FMIS_LARGE	XTYHXX	YHXX_PA_01	TABLE PARTITION	1	12.50

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	Subobject Name	Obj. Type	GC Buffer Busy	% of Capture
SYS	SYSTEM	I_DEPENDENCY1		INDEX	4	80.00
FMIS0300	FMISINDEX	IDU060712193340934		INDEX	1	20.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 2,269
Captured Segments account for 59.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	I_JOB_NEXT		INDEX	178	7.84
SYS	SYSTEM	JOB$		TABLE	177	7.80
FMIS0300	FMIS_LARGE	XTYHXX	YHXX_PA_05	TABLE PARTITION	76	3.35
FMIS0300	FMIS_LARGE	XTYHXX	YHXX_PA_06	TABLE PARTITION	75	3.31
FMIS0300	FMIS_LARGE	XTYHXX	YHXX_PA_01	TABLE PARTITION	73	3.22

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 779
Captured Segments account for 78.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSTEM	I_JOB_NEXT		INDEX	44	5.65
SYS	SYSTEM	JOB$		TABLE	42	5.39
FMIS0300	FMIS_LARGE	XTYHXX	YHXX_PA_12	TABLE PARTITION	31	3.98
FMIS0300	FMIS_LARGE	XTYHXX	YHXX_PA_14	TABLE PARTITION	30	3.85
FMIS0300	FMIS_LARGE	XTYHXX	YHXX_PA_08	TABLE PARTITION	26	3.34

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	36	0.00	2	1
dc_database_links	94	0.00	0	1
dc_files	3,570	0.00	0	85
dc_global_oids	306	0.00	0	38
dc_histogram_data	11,890	1.37	13	11,635
dc_histogram_defs	13,059	2.86	165	22,145
dc_object_ids	18,825	0.53	12	1,339
dc_objects	5,840	1.30	19	5,029
dc_profiles	46	0.00	0	1
dc_rollback_segments	3,074	0.00	0	158
dc_segments	3,665	2.46	16	5,816
dc_sequences	44	2.27	44	9
dc_tablespace_quotas	6	16.67	6	1
dc_tablespaces	31,998	0.00	0	18
dc_usernames	12,102	0.00	0	59
dc_users	54,626	0.02	0	78
outstanding_alerts	151	45.03	12	2

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	4	0	0
dc_histogram_defs	550	1	0
dc_object_ids	111	0	0
dc_objects	102	2	75
dc_segments	116	25	31
dc_sequences	88	4	0
dc_tablespace_quotas	70	1	0
dc_users	1	0	0
outstanding_alerts	292	90	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	39	0.00	27,854	0.00	0	0
CLUSTER	110	0.00	160	0.00	0	0
INDEX	1	0.00	12	0.00	0	0
SQL AREA	9,692	50.60	82,136	12.00	54	84
TABLE/PROCEDURE	1,149	4.26	62,638	0.36	46	0
TRIGGER	44	0.00	102	0.00	0	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	160	0	0	0
INDEX	12	0	0	0
TABLE/PROCEDURE	14,203	125	10	75

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	378.68		5.49	9.14	58	58	69	69
	Freeable	157.94	0.00	3.16	8.95	51		50	50
	PL/SQL	9.77	4.13	0.14	0.18	1	2	69	68
	SQL	1.02	0.51	0.02	0.04	0	140	51	42
E	Other	379.25		5.58	9.19	58	58	68	68
	Freeable	155.88	0.00	3.32	9.21	51		47	47
	PL/SQL	9.69	4.10	0.14	0.18	1	2	68	67
	SQL	1.01	0.50	0.02	0.04	0	140	50	44

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	8,053,063,680
Fixed Size	2,107,464
Redo Buffers	14,667,776
Variable Size	5,570,037,688

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	256.00	256.00	0.00
large	free memory	256.00	256.00	0.00
shared	CCursor	373.60	373.63	0.01
shared	Cursor Stats	48.00	48.00	0.00
shared	PCursor	300.01	299.88	-0.04
shared	free memory	828.23	847.08	2.28
shared	gcs resources	83.20	83.20	0.00
shared	gcs shadows	49.83	49.83	0.00
shared	ges enqueues	266.64	266.64	0.00
shared	ges resource	329.66	292.10	-11.39
shared	kglsim heap	59.62	59.62	0.00
shared	kglsim object batch	101.44	101.44	0.00
shared	library cache	342.03	340.93	-0.32
shared	sql area	757.20	767.24	1.32
shared	sql area:PLSQL	247.66	256.73	3.66
streams	free memory	16.00	16.00	0.00
	buffer_cache	7,680.00	7,680.00	0.00
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.99	13.99	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

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Coordinator	20,336	0	0
QMON Slaves	-6,286	0	0

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

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	12	0	0	0	0

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	328,690	526,501	538401	538401
gcs_shadows	416,158	529,230	538401	538401

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/app/admin/CWGKVPD/adump
background_dump_dest	/oracle/app/admin/CWGKVPD/bdump
bitmap_merge_area_size	131072
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.3.0
control_files	/dev/rlv_vpdctrl01, /dev/rlv_vpdctrl02, /dev/rlv_vpdctrl03
core_dump_dest	/oracle/app/admin/CWGKVPD/cdump
create_bitmap_area_size	131072
db_block_size	16384
db_cache_size	7516192768
db_domain
db_file_multiblock_read_count	16
db_keep_cache_size	268435456
db_name	CWGKVPD
db_recycle_cache_size	268435456
hash_area_size	2097152
instance_number	1
java_pool_size	268435456
job_queue_processes	4
large_pool_size	268435456
log_archive_dest_1	location=/cwgkvpd1_archive
open_cursors	300
optimizer_mode	CHOOSE
pga_aggregate_target	2097152000
processes	500
recyclebin	OFF
remote_listener	LISTENERS_CWGKVPD
remote_login_passwordfile	EXCLUSIVE
service_names	CWGK
sessions	555
sga_max_size	13639876608
sga_target	0
shared_pool_size	4294967296
sort_area_size	1048576
streams_pool_size	16777216
thread	1
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/app/admin/CWGKVPD/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	1,109	0.31	0.17
acks for commit broadcast(logical)	1,129	0.31	0.17
broadcast msgs on commit(actual)	3,559	0.99	0.54
broadcast msgs on commit(logical)	3,559	0.99	0.54
broadcast msgs on commit(wasted)	130	0.04	0.02
broadcast on commit wait time(ms)	179	0.05	0.03
broadcast on commit waits	2,246	0.62	0.34
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	10	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	229	0.06	0.03
gcs ast xid	0	0.00	0.00
gcs blocked converts	661	0.18	0.10
gcs blocked cr converts	677	0.19	0.10
gcs compatible basts	0	0.00	0.00
gcs compatible cr basts (global)	2	0.00	0.00
gcs compatible cr basts (local)	496	0.14	0.08
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	63	0.02	0.01
gcs dbwr write request msgs	115	0.03	0.02
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	68	0.02	0.01
gcs immediate (null) converts	93	0.03	0.01
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	408	0.11	0.06
gcs indirect ast	198	0.06	0.03
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	6	0.00	0.00
gcs msgs process time(ms)	117	0.03	0.02
gcs msgs received	7,354	2.04	1.11
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs side channel msgs actual	602	0.17	0.09
gcs side channel msgs logical	3,220	0.89	0.49
gcs stale cr	0	0.00	0.00
gcs undo cr	1	0.00	0.00
gcs write notification msgs	13	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	3,293	0.91	0.50
ges msgs received	285,497	79.31	43.24
global posts dropped	0	0.00	0.00
global posts queue time	1	0.00	0.00
global posts queued	12	0.00	0.00
global posts requested	12	0.00	0.00
global posts sent	12	0.00	0.00
implicit batch messages received	5,348	1.49	0.81
implicit batch messages sent	308	0.09	0.05
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	5,114	1.42	0.77
messages queue sent actual	9,238	2.57	1.40
messages queue sent logical	9,999	2.78	1.51
messages received actual	34,157	9.49	5.17
messages received logical	292,851	81.35	44.36
messages sent directly	5,157	1.43	0.78
messages sent indirectly	3,265	0.91	0.49
messages sent not implicit batched	8,930	2.48	1.35
messages sent pbatched	7,086	1.97	1.07
msgs causing lmd to send msgs	2,671	0.74	0.40
msgs causing lms(s) to send msgs	184	0.05	0.03
msgs received queue time (ms)	1,341	0.37	0.20
msgs received queued	292,851	81.35	44.36
msgs sent queue time (ms)	367	0.10	0.06
msgs sent queue time on ksxp (ms)	3,801	1.06	0.58
msgs sent queued	9,752	2.71	1.48
msgs sent queued on ksxp	15,728	4.37	2.38
process batch messages received	20,417	5.67	3.09
process batch messages sent	5,246	1.46	0.79

Global CR Served Stats

Statistic	Total
CR Block Requests	468
CURRENT Block Requests	406
Data Block Requests	468
Undo Block Requests	1
TX Block Requests	282
Current Results	873
Private results	0
Zero Results	1
Disk Read Results	0
Fail Results	0
Fairness Down Converts	83
Fairness Clears	0
Free GC Elements	0
Flushes	15
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	2
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
Pins	429	98.83	0.00	1.17	0.00
Flushes	0	0.00	0.00	0.00	0.00
Writes	69	79.71	18.84	0.00	1.45

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	1,390	100.00	0.00	0.00	733	99.32	0.68	0.00
2	undo header	820	99.76	0.24	0.00	1	100.00	0.00	0.00
2	Others	83	100.00	0.00	0.00	80	98.75	1.25	0.00

End of Report

% Blocks changed per Read:	1.96	Recursive Call %:	43.58
Rollback per transaction %:	60.18	Rows per Sort:	60.69

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	94.17	Soft Parse %:	94.43
Execute to Parse %:	0.09	Latch Hit %:	99.96
Parse CPU to Parse Elapsd %:	62.98	% Non-Parse CPU:	90.57

Buffer access - local cache %:	99.91
Buffer access - remote cache %:	0.07
Buffer access - disk %:	0.02

Avg global enqueue get time (ms):	86.7
Avg global cache cr block receive time (ms):	0.5
Avg global cache current block receive time (ms):	0.7
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 %:	1.8
Avg global cache cr block flush time (ms):	0.0
Avg global cache current block pin time (ms):	0.4
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.2
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	38.10
% of indirect sent messages:	24.12
% of flow controlled messages:	37.78