WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ODSDB 3367537179 odsdb1 1 10.2.0.4.0 YES cwgkdb1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ODSDB	3367537179	odsdb1	1	10.2.0.4.0	YES	cwgkdb1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 12746 25-2月 -12 03:00:14 132 19.6

End Snap: 12748 25-2月 -12 05:00:20 131 11.2

Elapsed: 120.10 (mins)

DB Time: 372.16 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	12746	25-2月 -12 03:00:14	132	19.6
End Snap:	12748	25-2月 -12 05:00:20	131	11.2
Elapsed:		120.10 (mins)
DB Time:		372.16 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 8,192M 8,192M Std Block Size: 16K

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

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

Load Profile

Per Second Per Transaction

Redo size: 2,200.62 881.41

Logical reads: 817.45 327.41

Block changes: 10.95 4.39

Physical reads: 0.03 0.01

Physical writes: 0.49 0.20

User calls: 187.58 75.13

Parses: 96.46 38.64

Hard parses: 8.02 3.21

Sorts: 2.46 0.99

Logons: 0.05 0.02

Executes: 75.18 30.11

Transactions: 2.50

	Per Second	Per Transaction
Redo size:	2,200.62	881.41
Logical reads:	817.45	327.41
Block changes:	10.95	4.39
Physical reads:	0.03	0.01
Physical writes:	0.49	0.20
User calls:	187.58	75.13
Parses:	96.46	38.64
Hard parses:	8.02	3.21
Sorts:	2.46	0.99
Logons:	0.05	0.02
Executes:	75.18	30.11
Transactions:	2.50

% Blocks changed per Read: 1.34 Recursive Call %: 15.60

Rollback per transaction %: 44.30 Rows per Sort: 19.87

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 93.16 Soft Parse %: 91.69

Execute to Parse %: -28.30 Latch Hit %: 99.89

Parse CPU to Parse Elapsd %: 0.95 % Non-Parse CPU: 91.34

Shared Pool Statistics

Begin End

Memory Usage %: 87.26 86.57

% SQL with executions>1: 2.14 7.12

% Memory for SQL w/exec>1: 2.01 5.90

	Begin	End
Memory Usage %:	87.26	86.57
% SQL with executions>1:	2.14	7.12
% Memory for SQL w/exec>1:	2.01	5.90

Top 5 Timed Events

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

library cache lock 69,490 20,171 290 90.3 Concurrency

row cache lock 2,712 1,584 584 7.1 Concurrency

DFS lock handle 3,506 1,296 370 5.8 Other

reliable message 1,442 939 651 4.2 Other

enq: DR - contention 1,358 662 487 3.0 Other

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
library cache lock	69,490	20,171	290	90.3	Concurrency
row cache lock	2,712	1,584	584	7.1	Concurrency
DFS lock handle	3,506	1,296	370	5.8	Other
reliable message	1,442	939	651	4.2	Other
enq: DR - contention	1,358	662	487	3.0	Other

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: 1.54 0.62

Global Cache blocks served: 1.16 0.46

GCS/GES messages received: 150.94 60.46

GCS/GES messages sent: 56.12 22.48

DBWR Fusion writes: 0.06 0.02

Estd Interconnect traffic (KB) 83.63

	Per Second	Per Transaction
Global Cache blocks received:	1.54	0.62
Global Cache blocks served:	1.16	0.46
GCS/GES messages received:	150.94	60.46
GCS/GES messages sent:	56.12	22.48
DBWR Fusion writes:	0.06	0.02
Estd Interconnect traffic (KB)	83.63

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

Buffer access - local cache %: 99.81

Buffer access - remote cache %: 0.19

Buffer access - disk %: 0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 49.3

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

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

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

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

Global cache log flushes for cr blocks served %: 0.9

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

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

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

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

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

% of indirect sent messages: 33.00

% of flow controlled messages: 34.94

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): 22329.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	19,861.84	88.95
PL/SQL execution elapsed time	17,577.86	78.72
parse time elapsed	2,143.14	9.60
connection management call elapsed time	2,071.12	9.28
DB CPU	241.69	1.08
sequence load elapsed time	182.18	0.82
hard parse elapsed time	62.21	0.28
PL/SQL compilation elapsed time	11.71	0.05
repeated bind elapsed time	0.05	0.00
hard parse (sharing criteria) elapsed time	0.03	0.00
failed parse elapsed time	0.00	0.00
DB time	22,329.78
background elapsed time	3,220.60
background cpu time	95.85

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
Concurrency	73,124	57.06	21,757	298	4.06
Other	919,900	97.96	3,470	4	51.13
System I/O	47,786	0.00	23	0	2.66
Commit	10,479	0.01	10	1	0.58
Application	11,258	0.00	6	1	0.63
Cluster	11,613	0.01	5	0	0.65
User I/O	442	0.00	3	6	0.02
Network	1,042,080	0.00	1	0	57.92
Configuration	10	100.00	0	0	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
library cache lock	69,490	59.27	20,171	290	3.86
row cache lock	2,712	19.62	1,584	584	0.15
DFS lock handle	3,506	75.30	1,296	370	0.19
reliable message	1,442	66.37	939	651	0.08
enq: DR - contention	1,358	99.78	662	487	0.08
enq: CF - contention	1,391	74.34	506	364	0.08
enq: PS - contention	227	31.72	36	158	0.01
enq: TD - KTF dump entries	229	10.04	13	56	0.01
log file sync	10,479	0.01	10	1	0.58
control file sequential read	31,628	0.00	9	0	1.76
log file parallel write	11,713	0.00	9	1	0.65
rdbms ipc reply	411	0.49	8	19	0.02
CGS wait for IPC msg	874,233	100.00	6	0	48.59
enq: TX - row lock contention	479	0.00	3	7	0.03
control file parallel write	2,363	0.00	3	1	0.13
db file sequential read	432	0.00	3	6	0.02
ges inquiry response	8,473	0.00	2	0	0.47
db file parallel write	2,082	0.00	2	1	0.12
enq: RO - fast object reuse	8,470	0.00	2	0	0.47
gc cr block 2-way	4,593	0.00	2	0	0.26
gc current block busy	56	0.00	2	30	0.00
latch: ges resource hash list	1,940	0.00	1	0	0.11
enq: WF - contention	39	2.56	1	23	0.00
latch: library cache	138	0.00	1	6	0.01
SQL*Net message to client	1,037,623	0.00	1	0	57.67
gc cr multi block request	5,067	0.00	1	0	0.28
latch: shared pool	532	0.00	1	1	0.03
gc current block 2-way	1,419	0.00	1	0	0.08
name-service call wait	6	0.00	0	70	0.00
os thread startup	11	0.00	0	36	0.00
gc buffer busy	59	0.00	0	5	0.00
SQL*Net break/reset to client	1,990	0.00	0	0	0.11
gc current grant busy	219	0.46	0	1	0.01
global enqueue expand wait	20	100.00	0	10	0.00
ksxr poll remote instances	19,407	81.60	0	0	1.08
enq: TM - contention	319	0.00	0	0	0.02
IPC send completion sync	364	99.18	0	0	0.02
cursor: pin S wait on X	9	100.00	0	10	0.00
latch free	1,468	0.00	0	0	0.08
library cache pin	97	0.00	0	1	0.01
wait for scn ack	51	0.00	0	1	0.00
enq: TT - contention	155	0.00	0	0	0.01
PX Deq: reap credit	4,639	97.72	0	0	0.26
SQL*Net more data to client	2,322	0.00	0	0	0.13
gc current grant 2-way	118	0.00	0	0	0.01
KJC: Wait for msg sends to complete	179	0.00	0	0	0.01
LGWR wait for redo copy	191	0.00	0	0	0.01
enq: TX - index contention	4	0.00	0	4	0.00
buffer busy waits	100	0.00	0	0	0.01
PX Deq Credit: send blkd	49	55.10	0	0	0.00
SQL*Net more data from client	2,135	0.00	0	0	0.12
gc cr grant 2-way	61	0.00	0	0	0.00
gcs log flush sync	72	9.72	0	0	0.00
direct path write	10	0.00	0	1	0.00
gc cr block busy	7	0.00	0	1	0.00
PX Deq: Signal ACK	27	37.04	0	0	0.00
latch: row cache objects	4	0.00	0	0	0.00
enq: MW - contention	4	0.00	0	0	0.00
gc current multi block request	14	0.00	0	0	0.00
kkdlgon	1	0.00	0	1	0.00
latch: library cache lock	3	0.00	0	0	0.00
latch: cache buffers chains	22	0.00	0	0	0.00
enq: PI - contention	2	0.00	0	0	0.00
enq: TA - contention	4	0.00	0	0	0.00
enq: FB - contention	2	0.00	0	0	0.00
enq: AF - task serialization	1	0.00	0	0	0.00
enq: US - contention	1	0.00	0	0	0.00
latch: messages	3	0.00	0	0	0.00
latch: library cache pin	2	0.00	0	0	0.00
undo segment extension	10	100.00	0	0	0.00
cursor: pin S	5	0.00	0	0	0.00
SQL*Net message from client	1,037,623	0.00	707,601	682	57.67
gcs remote message	557,687	97.82	14,066	25	31.00
jobq slave wait	3,971	100.00	11,624	2927	0.22
DIAG idle wait	36,029	0.00	7,036	195	2.00
Streams AQ: qmn slave idle wait	254	0.00	6,996	27543	0.01
Streams AQ: qmn coordinator idle wait	557	47.04	6,996	12560	0.03
ges remote message	446,141	86.04	6,996	16	24.80
Streams AQ: waiting for messages in the queue	715	100.00	6,753	9445	0.04
PX Idle Wait	2,722	94.38	6,460	2373	0.15
Streams AQ: waiting for time management or cleanup tasks	2	100.00	2,145	1072437	0.00
PX Deq: Execution Msg	772	31.99	13	16	0.04
PX Deq: Join ACK	54	42.59	5	90	0.00
PX Deq: Parse Reply	55	40.00	2	33	0.00
PX Deq: Msg Fragment	145	17.93	0	0	0.01
Streams AQ: RAC qmn coordinator idle wait	557	100.00	0	0	0.03
PX Deq: Execute Reply	35	37.14	0	0	0.00
class slave wait	3	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	911,782	98.07	2,042	2	50.68
library cache lock	2,012	28.68	283	141	0.11
row cache lock	629	2.38	37	58	0.03
log file parallel write	11,713	0.00	9	1	0.65
control file sequential read	19,244	0.00	7	0	1.07
control file parallel write	2,331	0.00	3	1	0.13
db file parallel write	2,082	0.00	2	1	0.12
enq: RO - fast object reuse	8,471	0.00	2	0	0.47
gc cr block 2-way	2,567	0.00	1	0	0.14
gc cr multi block request	4,955	0.00	1	0	0.28
os thread startup	11	0.00	0	36	0.00
gc current block 2-way	593	0.00	0	0	0.03
db file sequential read	1	0.00	0	28	0.00
enq: TM - contention	294	0.00	0	0	0.02
gc current grant busy	13	0.00	0	0	0.00
gc cr block busy	1	0.00	0	2	0.00
direct path write	2	0.00	0	1	0.00
library cache pin	1	0.00	0	1	0.00
gc current multi block request	7	0.00	0	0	0.00
latch: shared pool	4	0.00	0	0	0.00
latch: row cache objects	1	0.00	0	0	0.00
undo segment extension	10	100.00	0	0	0.00
rdbms ipc message	238,245	43.13	95,806	402	13.24
gcs remote message	557,689	97.82	14,066	25	31.00
DIAG idle wait	36,028	0.00	7,036	195	2.00
pmon timer	2,435	100.00	7,030	2887	0.14
Streams AQ: qmn slave idle wait	254	0.00	6,996	27543	0.01
Streams AQ: qmn coordinator idle wait	557	47.04	6,996	12560	0.03
ges remote message	446,147	86.04	6,996	16	24.80
smon timer	8,835	0.27	6,866	777	0.49
Streams AQ: waiting for time management or cleanup tasks	2	100.00	2,145	1072437	0.00
PX Deq: Join ACK	54	42.59	5	90	0.00
PX Deq: Parse Reply	55	40.00	2	33	0.00
Streams AQ: RAC qmn coordinator idle wait	557	100.00	0	0	0.03
PX Deq: Execute Reply	35	37.14	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,341
AVG_IDLE_TIME	711,659
AVG_IOWAIT_TIME	331
AVG_SYS_TIME	4,785
AVG_USER_TIME	5,349
BUSY_TIME	84,389
IDLE_TIME	5,694,997
IOWAIT_TIME	4,143
SYS_TIME	39,935
USER_TIME	44,454
LOAD	0
OS_CPU_WAIT_TIME	113,400
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,353,105,408
NUM_CPUS	8
NUM_CPU_CORES	4

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	22,127.60	226.30	24	4,895,792
odsdb	202.10	15.30	7	889,025
SYS$BACKGROUND	0.00	0.00	155	106,341
ods	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
SYS$USERS	24	20	68834	2134406	1025673	82
odsdb	7	14	191	3220	15715	5
SYS$BACKGROUND	411	239	4103	38093	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
16,908	43	195,292	0.09	75.72	a16hu5wzwq421		BEGIN vPD_PKG.SET_CONTEXT_COMP...
2,062	1	175	11.78	9.23	bvskgnk4p3x2w	racgimon@cwgkdb1 (TNS V1-V3)	DECLARE V_PROGRAM VARCHA...
2,001	0	14	142.95	8.96	dqmvgn5svxvcm		BEGIN PA_FMIS_BASE.NEWENTITY(:...
226	0	200	1.13	1.01	f67hktj85gdrc		BEGIN vPD_PKG.SET_CONTEXT_COMP...
213	0	5	42.53	0.95	akjps9g3srbtk		BEGIN vPD_PKG.SET_CONTEXT_COMP...
182	0	545	0.33	0.82	3mmcwuyvjx2d9		select hibernate_sequence.next...
122	0	5	24.32	0.54	ff7w7fz1rzcnj		BEGIN vPD_PKG.SET_CONTEXT_COMP...
92	0	5	18.35	0.41	018q25c6zgh44		BEGIN vPD_PKG.SET_CONTEXT_COMP...
25	0	5	5.05	0.11	ab30f54tvnvg7		BEGIN vPD_PKG.SET_CONTEXT_COMP...
10	0	6	1.68	0.05	1dubbbfqnqvh9		SELECT ORA_TQ_BASE$.NEXTVAL FR...

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
43	16,908	195,292	0.00	75.72	a16hu5wzwq421		BEGIN vPD_PKG.SET_CONTEXT_COMP...
6	9	401	0.02	0.04	0jn5hzudm8han		select * from ( select logeven...
4	4	1,664	0.00	0.02	4wfs884q6datz		Select A.MSG_ID, A.MSG_TOPIC,...
4	4	92	0.04	0.02	f6ynnf6u0cmv4		UPDATE XTYHXX SET XSMC = :1, ...
3	4	46	0.07	0.02	5p6jc91q68nj0		UPDATE XTYHXX SET STOPED = 1 W...
3	3	1,450	0.00	0.01	bk4zdy7ksxag7		SELECT MSG_ID, MSG_CONSUME FRO...
3	5	191	0.02	0.02	0jbc3ny0twdry		select * from ( select logeven...
3	3	94,353	0.00	0.01	6pgaqa2kcx6vs		SELECT SYS_CONTEXT('VPD_CONTEX...
3	3	1	2.83	0.01	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
2	3	70	0.03	0.01	a9hdzvx8ht4am		INSERT INTO FMIS0400.HZBB_DXLI...
1	2,062	175	0.00	9.23	bvskgnk4p3x2w	racgimon@cwgkdb1 (TNS V1-V3)	DECLARE V_PROGRAM VARCHA...
0	2,001	14	0.02	8.96	dqmvgn5svxvcm		BEGIN PA_FMIS_BASE.NEWENTITY(:...
0	226	200	0.00	1.01	f67hktj85gdrc		BEGIN vPD_PKG.SET_CONTEXT_COMP...

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: 5,890,490
Captured SQL account for 41.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
399,360	1,664	240.00	6.78	4.10	4.10	4wfs884q6datz		Select A.MSG_ID, A.MSG_TOPIC,...
373,052	1	373,052.00	6.33	2.83	3.19	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
348,000	1,450	240.00	5.91	3.30	3.30	bk4zdy7ksxag7		SELECT MSG_ID, MSG_CONSUME FRO...
299,384	70	4,276.91	5.08	2.29	2.77	a9hdzvx8ht4am		INSERT INTO FMIS0400.HZBB_DXLI...
252,642	401	630.03	4.29	6.28	8.92	0jn5hzudm8han		select * from ( select logeven...
164,319	46	3,572.15	2.79	3.39	3.85	5p6jc91q68nj0		UPDATE XTYHXX SET STOPED = 1 W...
121,482	1	121,482.00	2.06	1.76	1.79	91k4w10zgrg4m	plsqldev.exe	select object_name, object_ty...
120,342	191	630.06	2.04	3.20	4.60	0jbc3ny0twdry		select * from ( select logeven...
87,360	92	949.57	1.48	3.86	4.00	f6ynnf6u0cmv4		UPDATE XTYHXX SET XSMC = :1, ...
46,830	70	669.00	0.80	0.47	0.89	fnh94j9kuk8gf		SELECT BILLID FROM XTBILL2012 ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 198
Captured SQL account for 13.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
18	175	0.10	9.09	0.14	0.25	1rd8um1taq1fn		update sys.aud$ set action#=:2...
18	1	18.00	9.09	0.71	1.05	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
3	1	3.00	1.52	2.83	3.19	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
2	2	1.00	1.01	0.54	2.74	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
1	1	1.00	0.51	0.01	1.11	350myuyx0t1d6		insert into wrh$_tablespace_st...
1	11	0.09	0.51	0.00	0.06	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
1	32	0.03	0.51	0.00	0.02	8swypbbr0m372		select order#, columns, types ...
1	11	0.09	0.51	0.01	0.02	c6awqs517jpj0		select /*+ index(idl_char$ i_i...
0	5	0.00	0.00	0.01	91.77	018q25c6zgh44		BEGIN vPD_PKG.SET_CONTEXT_COMP...
0	120	0.00	0.00	0.01	0.01	0411hbafqj4t7		select interfaces0_.GROUP_ID_ ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 541,771
Captured SQL account for 62.9% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
195,292	195,257	1.00	0.09	a16hu5wzwq421		BEGIN vPD_PKG.SET_CONTEXT_COMP...
94,353	94,353	1.00	0.00	6pgaqa2kcx6vs		SELECT SYS_CONTEXT('VPD_CONTEX...
11,659	11,660	1.00	0.00	bunvx480ynf57		SELECT 1 FROM DUAL
5,922	0	0.00	0.00	4hc8pzq5901r9		SELECT TRIGGER_NAME, TRIGGER_...
3,696	2,006	0.54	0.00	fudsnu0u8fuhj		select * from xtclusterlock wh...
3,367	0	0.00	0.00	dtgu0gb2u9y64		select username from xtcluster...
3,240	3,240	1.00	0.00	b70fnskn0kam7		SELECT * FROM QRTZ_TRIGGERS WH...
1,995	1,995	1.00	0.00	fhdxrqd4stwqk		SELECT * FROM QRTZ_LOCKS WHERE...
1,776	1,776	1.00	0.00	42ddyag628kjx	PL/SQL Developer	begin :con := VPD_PKG.FILTER_C...
1,699	22	0.01	0.00	29tgxad9bpwfd		select * from xtclusterlock wh...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 695,090
Captured SQL account for 44.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
195,196	195,292	28.08	a16hu5wzwq421		BEGIN vPD_PKG.SET_CONTEXT_COMP...
94,353	94,353	13.57	6pgaqa2kcx6vs		SELECT SYS_CONTEXT('VPD_CONTEX...
3,696	3,696	0.53	fudsnu0u8fuhj		select * from xtclusterlock wh...
3,367	3,367	0.48	dtgu0gb2u9y64		select username from xtcluster...
1,776	1,776	0.26	42ddyag628kjx	PL/SQL Developer	begin :con := VPD_PKG.FILTER_C...
1,699	1,699	0.24	29tgxad9bpwfd		select * from xtclusterlock wh...
800	800	0.12	c6j034dcffqaq		select nbitask0_.ID_ as ID1_16...
545	545	0.08	3mmcwuyvjx2d9		select hibernate_sequence.next...
499	502	0.07	0h6b2sajwb74n		select privilege#, level from ...
437	437	0.06	c4nhd1ntptxq7		select message_level, sequenc...

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

No data exists for this section of the report.

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.74	52.52	1.40	0.91	2	cfz686a6qp0kg		select o.obj#, u.name, o.nam...
0.42	58.22	0.72	0.72	1,379	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
0.42	13.01	3.19	2.83	1	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
0.37	69.16	0.54	0.54	1,379	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
0.30	66.42	0.45	0.24	1	8p23kcbgfqnk4		select file#, block#, ts# fr...
0.18	9.90	1.79	1.76	1	91k4w10zgrg4m	plsqldev.exe	select object_name, object_ty...
0.09	69.87	0.13	0.13	237	2skwhauh2cwky		select o.name, u.name from ob...
0.05	28.72	0.18	0.16	1,699	29tgxad9bpwfd		select * from xtclusterlock wh...
0.05	0.52	8.92	6.28	401	0jn5hzudm8han		select * from ( select logeven...
0.04	1.00	4.07	0.98	1,995	fhdxrqd4stwqk		SELECT * FROM QRTZ_LOCKS WHERE...
0.04	59.73	0.07	0.04	156	ftf0qy4kwpk62		insert into NBI_LOG_EVENT (TIM...
0.04	0.00	2,001.34	0.30	14	dqmvgn5svxvcm		BEGIN PA_FMIS_BASE.NEWENTITY(:...
0.03	2.47	1.05	0.71	1	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0.02	0.47	4.60	3.20	191	0jbc3ny0twdry		select * from ( select logeven...
0.02	3.94	0.51	0.36	16	51g0by2z0h0vy		BEGIN PA_FMIS_BASE.NEWENTITYBY...
0.02	7.60	0.20	0.20	680	3c1kubcdjnppq		update sys.col_usage$ set eq...
0.01	38.07	0.03	0.03	334	2ym6hhaq30r73		select type#, blocks, extents,...
0.01	5.09	0.25	0.14	175	1rd8um1taq1fn		update sys.aud$ set action#=:2...
0.01	26.01	0.04	0.04	30	64wq3fa5a77sm		insert into seg$ (file#, block...
0.01	4.44	0.21	0.20	193	15zytu14qzw6p		insert into sys.aud$( sessioni...
0.01	0.01	182.20	0.08	545	3mmcwuyvjx2d9		select hibernate_sequence.next...
0.01	15.96	0.06	0.03	30	60uw2vh6q9vn2		insert into col$(obj#, name, i...
0.01	0.85	0.95	0.95	2	84qubbrsr0kfn		insert into wrh$_latch (snap...
0.01	30.64	0.02	0.02	46	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
0.01	6.48	0.10	0.10	327	g00cj285jmgsw		update sys.mon_mods$ set inser...
0.01	24.95	0.03	0.03	437	c4nhd1ntptxq7		select message_level, sequenc...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

018q25c6zgh44 BEGIN vPD_PKG.SET_CONTEXT_COMPID('0410'); END;

0411hbafqj4t7 select interfaces0_.GROUP_ID_ as GROUP8_1_, interfaces0_.ID_ as ID1_1_, interfaces0_.ID_ as ID1_7_0_, interfaces0_.NAME_ as NAME3_7_0_, interfaces0_.METHOD_NAME_ as METHOD4_7_0_, interfaces0_.UID_ as UID5_7_0_, interfaces0_.CREATED_TIME_ as CREATED6_7_0_, interfaces0_.NOTES_ as NOTES7_7_0_, interfaces0_.GROUP_ID_ as GROUP8_7_0_, interfaces0_.HAS_ATTACHMENT_ as HAS9_7_0_, interfaces0_.JAR_ as JAR10_7_0_, interfaces0_.DATA_SOURCE_ID_ as DATA11_7_0_, interfaces0_.READONLY_ as READONLY12_7_0_, interfaces0_.END_POINT_ as END13_7_0_, interfaces0_.NAMESPACE_ as NAMESPACE14_7_0_, interfaces0_.CLASS_ as CLASS2_7_0_ from NBI_INTERFACE interfaces0_ where interfaces0_.GROUP_ID_=:1 order by interfaces0_.NAME_

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

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

15zytu14qzw6p insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :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, :30, :31, :32, :33, :34)

1dubbbfqnqvh9 SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL

1rd8um1taq1fn update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(systimestamp as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100

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

2skwhauh2cwky select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#

2ym6hhaq30r73 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

350myuyx0t1d6 insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#

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

3mmcwuyvjx2d9 select hibernate_sequence.nextval from dual

42ddyag628kjx begin :con := VPD_PKG.FILTER_COMPID(:sn, :on); 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

4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1

4wfs884q6datz Select A.MSG_ID, A.MSG_TOPIC, A.MSG_RECV, A.MSG_SEND, A.MSG_SENDCOUNT, A.MSG_CONSUME, A.MSG_SUCCEED, A.MSG_KEY, A.MSG_GENERATECONTENT From MSG_QUEUE A Where A.MSG_KEY Is Not Null AND ROWNUM <= 50 order by A.MSG_RECV DESC

51g0by2z0h0vy BEGIN PA_FMIS_BASE.NEWENTITYBYQUERY(:1, :2); END;

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)

60uw2vh6q9vn2 insert into col$(obj#, name, intcol#, segcol#, type#, length, precision#, scale, null$, offset, fixedstorage, segcollength, deflength, default$, col#, property, charsetid, charsetform, spare1, spare2, spare3)values(:1, :2, :3, :4, :5, :6, decode(:5, 182/*DTYIYM*/, :7, 183/*DTYIDS*/, :7, decode(:7, 0, null, :7)), decode(:5, 2, decode(:8, -127/*MAXSB1MINAL*/, null, :8), 178, :8, 179, :8, 180, :8, 181, :8, 182, :8, 183, :8, 231, :8, null), :9, 0, :10, :11, decode(:12, 0, null, :12), :13, :14, :15, :16, :17, :18, :19, :20)

64wq3fa5a77sm insert into seg$ (file#, block#, type#, ts#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, lists, groups, cachehint, bitmapranges, hwmincr, spare1, scanhint) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, 0, :16, DECODE(:17, 0, NULL, :17), :18)

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

6ssrk2dqj7jbx select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job

7vgmvmy8vvb9s insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)

84qubbrsr0kfn insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash

8p23kcbgfqnk4 select file#, block#, ts# from seg$ where type# = 3

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

91k4w10zgrg4m select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

a16hu5wzwq421 BEGIN vPD_PKG.SET_CONTEXT_COMPID('0400'); END;

a9hdzvx8ht4am INSERT INTO FMIS0400.HZBB_DXLIST (DXID) SELECT B.BILLID FROM XTBILL2012 B, FMIS0400.XTSENDBILL C , FMIS0400.XTTRANSBILL D WHERE B.COMPID=:1 AND TO_CHAR(B.TTIME, 'MM')=:2 AND B.BILLID>0 AND B.BZWC=1 AND C.BILLID(+)=B.BILLID AND C.TBDW(+)=:3 AND C.TYEAR(+)=:4 AND NVL(C.SENDSYS(+), 0)=0 AND C.BILLID IS NULL AND D.BILLID(+)=B.BILLID AND D.DWDH(+)=:5 AND D.TYEAR(+)=:6 AND NVL(D.TRANSSYS(+), 0)=0 AND D.BILLID IS NULL

ab30f54tvnvg7 BEGIN vPD_PKG.SET_CONTEXT_COMPID('0401'); END;

akjps9g3srbtk BEGIN vPD_PKG.SET_CONTEXT_COMPID('0406'); END;

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

bd502nbh9abbs select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

bk4zdy7ksxag7 SELECT MSG_ID, MSG_CONSUME FROM MSG_QUEUE WHERE MSG_SUCCEED=0 AND MSG_KEY IS NULL AND ROWNUM <= 100 ORDER BY MSG_RECV

bunvx480ynf57 SELECT 1 FROM DUAL

bvskgnk4p3x2w DECLARE V_PROGRAM VARCHAR2(100); V_SESSIONID NUMBER(10); V_CONTEXT VARCHAR2(32); BEGIN SELECT MAX(TRIM(UPPER(PROGRAM))), MAX(TRIM(UPPER(USERNAME))) INTO V_PROGRAM, V_CONTEXT FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'); IF SUBSTR(V_PROGRAM, 1, 3) IN ('EXP', 'IMP') THEN VPD_PKG.SET_CONTEXT_COMPID('-1'); VPD_PKG.SET_CONTEXT_VPD_YEAR('-1'); VPD_PKG.SET_CONTEXT_ACCBOOKID('-1'); ELSE VPD_PKG.SET_CONTEXT_COMPID(REPLACE(SUBSTR(V_CONTEXT, 5), '_TOP', '9999')); VPD_PKG.SET_CONTEXT_VPD_YEAR(TO_CHAR(SYSDATE, 'YYYYMMDD')); VPD_PKG.SET_CONTEXT_ACCBOOKID('0'); END IF; END;

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

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

c6j034dcffqaq select nbitask0_.ID_ as ID1_16_, nbitask0_.OBJ_VERSION_ as OBJ2_16_, nbitask0_.TYPE_ as TYPE3_16_, nbitask0_.CONTENT_ as CONTENT4_16_, nbitask0_.MAPPING_TYPE_ as MAPPING5_16_, nbitask0_.OBJECT_ as OBJECT6_16_, nbitask0_.INT_RULE_ID_ as INT7_16_, nbitask0_.LAST_ACCESS_TIME_ as LAST8_16_, nbitask0_.CREATED_TIME_ as CREATED9_16_, nbitask0_.EXCUTED_ as EXCUTED10_16_ from NBI_TASK nbitask0_, NBI_INTEGRATION_RULE integratio1_ where nbitask0_.INT_RULE_ID_=integratio1_.ID_ and integratio1_.STOP_=0 and nbitask0_.EXCUTED_=0

cfz686a6qp0kg select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#

d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

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

dtgu0gb2u9y64 select username from xtclusteruser where userid=-9999

f67hktj85gdrc BEGIN vPD_PKG.SET_CONTEXT_COMPID('-1'); END;

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

ff7w7fz1rzcnj BEGIN vPD_PKG.SET_CONTEXT_COMPID('0409'); END;

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

fnh94j9kuk8gf SELECT BILLID FROM XTBILL2012 WHERE MONTH(TTIME) = :1 AND ZWHZBZ = 1 AND CODE2 IS NULL

ftf0qy4kwpk62 insert into NBI_LOG_EVENT (TIME_, TYPE_, MSG_, STATUS_, INTRULE_ID_, INTRULE_NAME_, DATA_, HANDLED_, ID_) values (:1, :2, :3, :4, :5, :6, :7, :8, :9)

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

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

g2wr3u7s1gtf3 select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))

SQL Id	SQL Text
018q25c6zgh44	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0410'); END;
0411hbafqj4t7	select interfaces0_.GROUP_ID_ as GROUP8_1_, interfaces0_.ID_ as ID1_1_, interfaces0_.ID_ as ID1_7_0_, interfaces0_.NAME_ as NAME3_7_0_, interfaces0_.METHOD_NAME_ as METHOD4_7_0_, interfaces0_.UID_ as UID5_7_0_, interfaces0_.CREATED_TIME_ as CREATED6_7_0_, interfaces0_.NOTES_ as NOTES7_7_0_, interfaces0_.GROUP_ID_ as GROUP8_7_0_, interfaces0_.HAS_ATTACHMENT_ as HAS9_7_0_, interfaces0_.JAR_ as JAR10_7_0_, interfaces0_.DATA_SOURCE_ID_ as DATA11_7_0_, interfaces0_.READONLY_ as READONLY12_7_0_, interfaces0_.END_POINT_ as END13_7_0_, interfaces0_.NAMESPACE_ as NAMESPACE14_7_0_, interfaces0_.CLASS_ as CLASS2_7_0_ from NBI_INTERFACE interfaces0_ where interfaces0_.GROUP_ID_=:1 order by interfaces0_.NAME_
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
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
15zytu14qzw6p	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :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, :30, :31, :32, :33, :34)
1dubbbfqnqvh9	SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL
1rd8um1taq1fn	update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(systimestamp as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
29tgxad9bpwfd	select * from xtclusterlock where clustername='GRIS_CLUSTER' and objkind='MessagePlatformNew'
2skwhauh2cwky	select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
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
3mmcwuyvjx2d9	select hibernate_sequence.nextval from dual
42ddyag628kjx	begin :con := VPD_PKG.FILTER_COMPID(:sn, :on); 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
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4wfs884q6datz	Select A.MSG_ID, A.MSG_TOPIC, A.MSG_RECV, A.MSG_SEND, A.MSG_SENDCOUNT, A.MSG_CONSUME, A.MSG_SUCCEED, A.MSG_KEY, A.MSG_GENERATECONTENT From MSG_QUEUE A Where A.MSG_KEY Is Not Null AND ROWNUM <= 50 order by A.MSG_RECV DESC
51g0by2z0h0vy	BEGIN PA_FMIS_BASE.NEWENTITYBYQUERY(:1, :2); END;
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)
60uw2vh6q9vn2	insert into col$(obj#, name, intcol#, segcol#, type#, length, precision#, scale, null$, offset, fixedstorage, segcollength, deflength, default$, col#, property, charsetid, charsetform, spare1, spare2, spare3)values(:1, :2, :3, :4, :5, :6, decode(:5, 182/DTYIYM/, :7, 183/DTYIDS/, :7, decode(:7, 0, null, :7)), decode(:5, 2, decode(:8, -127/MAXSB1MINAL/, null, :8), 178, :8, 179, :8, 180, :8, 181, :8, 182, :8, 183, :8, 231, :8, null), :9, 0, :10, :11, decode(:12, 0, null, :12), :13, :14, :15, :16, :17, :18, :19, :20)
64wq3fa5a77sm	insert into seg$ (file#, block#, type#, ts#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, lists, groups, cachehint, bitmapranges, hwmincr, spare1, scanhint) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, 0, :16, DECODE(:17, 0, NULL, :17), :18)
6pgaqa2kcx6vs	SELECT SYS_CONTEXT('VPD_CONTEXT', 'COMPID') AS VPD_CONTEXT FROM DUAL
6ssrk2dqj7jbx	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
7vgmvmy8vvb9s	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
84qubbrsr0kfn	insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
8p23kcbgfqnk4	select file#, block#, ts# from seg$ where type# = 3
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
91k4w10zgrg4m	select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
a16hu5wzwq421	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0400'); END;
a9hdzvx8ht4am	INSERT INTO FMIS0400.HZBB_DXLIST (DXID) SELECT B.BILLID FROM XTBILL2012 B, FMIS0400.XTSENDBILL C , FMIS0400.XTTRANSBILL D WHERE B.COMPID=:1 AND TO_CHAR(B.TTIME, 'MM')=:2 AND B.BILLID>0 AND B.BZWC=1 AND C.BILLID(+)=B.BILLID AND C.TBDW(+)=:3 AND C.TYEAR(+)=:4 AND NVL(C.SENDSYS(+), 0)=0 AND C.BILLID IS NULL AND D.BILLID(+)=B.BILLID AND D.DWDH(+)=:5 AND D.TYEAR(+)=:6 AND NVL(D.TRANSSYS(+), 0)=0 AND D.BILLID IS NULL
ab30f54tvnvg7	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0401'); END;
akjps9g3srbtk	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0406'); END;
b70fnskn0kam7	SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
bk4zdy7ksxag7	SELECT MSG_ID, MSG_CONSUME FROM MSG_QUEUE WHERE MSG_SUCCEED=0 AND MSG_KEY IS NULL AND ROWNUM <= 100 ORDER BY MSG_RECV
bunvx480ynf57	SELECT 1 FROM DUAL
bvskgnk4p3x2w	DECLARE V_PROGRAM VARCHAR2(100); V_SESSIONID NUMBER(10); V_CONTEXT VARCHAR2(32); BEGIN SELECT MAX(TRIM(UPPER(PROGRAM))), MAX(TRIM(UPPER(USERNAME))) INTO V_PROGRAM, V_CONTEXT FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'); IF SUBSTR(V_PROGRAM, 1, 3) IN ('EXP', 'IMP') THEN VPD_PKG.SET_CONTEXT_COMPID('-1'); VPD_PKG.SET_CONTEXT_VPD_YEAR('-1'); VPD_PKG.SET_CONTEXT_ACCBOOKID('-1'); ELSE VPD_PKG.SET_CONTEXT_COMPID(REPLACE(SUBSTR(V_CONTEXT, 5), '_TOP', '9999')); VPD_PKG.SET_CONTEXT_VPD_YEAR(TO_CHAR(SYSDATE, 'YYYYMMDD')); VPD_PKG.SET_CONTEXT_ACCBOOKID('0'); END IF; END;
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
c6awqs517jpj0	select /+ index(idl_char$ i_idl_char1) +/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
c6j034dcffqaq	select nbitask0_.ID_ as ID1_16_, nbitask0_.OBJ_VERSION_ as OBJ2_16_, nbitask0_.TYPE_ as TYPE3_16_, nbitask0_.CONTENT_ as CONTENT4_16_, nbitask0_.MAPPING_TYPE_ as MAPPING5_16_, nbitask0_.OBJECT_ as OBJECT6_16_, nbitask0_.INT_RULE_ID_ as INT7_16_, nbitask0_.LAST_ACCESS_TIME_ as LAST8_16_, nbitask0_.CREATED_TIME_ as CREATED9_16_, nbitask0_.EXCUTED_ as EXCUTED10_16_ from NBI_TASK nbitask0_, NBI_INTEGRATION_RULE integratio1_ where nbitask0_.INT_RULE_ID_=integratio1_.ID_ and integratio1_.STOP_=0 and nbitask0_.EXCUTED_=0
cfz686a6qp0kg	select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dqmvgn5svxvcm	BEGIN PA_FMIS_BASE.NEWENTITY(:1, :2); END;
dtgu0gb2u9y64	select username from xtclusteruser where userid=-9999
f67hktj85gdrc	BEGIN vPD_PKG.SET_CONTEXT_COMPID('-1'); END;
f6ynnf6u0cmv4	UPDATE XTYHXX SET XSMC = :1, EMAIL = :2, STOPED = :3 WHERE UPPER(YHMC) = UPPER(:4)
ff7w7fz1rzcnj	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0409'); END;
fhdxrqd4stwqk	SELECT * FROM QRTZ_LOCKS WHERE LOCK_NAME = :1 FOR UPDATE
fnh94j9kuk8gf	SELECT BILLID FROM XTBILL2012 WHERE MONTH(TTIME) = :1 AND ZWHZBZ = 1 AND CODE2 IS NULL
ftf0qy4kwpk62	insert into NBI_LOG_EVENT (TIME_, TYPE_, MSG_, STATUS_, INTRULE_ID_, INTRULE_NAME_, DATA_, HANDLED_, ID_) values (:1, :2, :3, :4, :5, :6, :7, :8, :9)
fudsnu0u8fuhj	select * from xtclusterlock where clustername='GRIS_CLUSTER' and objkind='MessagePlatform'
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g2wr3u7s1gtf3	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))

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,939	1.10	0.44
CPU used when call started	7,111	0.99	0.40
CR blocks created	360	0.05	0.02
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	8,787,509	1,219.48	488.44
DBWR checkpoint buffers written	3,172	0.44	0.18
DBWR checkpoints	8,452	1.17	0.47
DBWR fusion writes	401	0.06	0.02
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	547	0.08	0.03
DBWR undo block writes	1,121	0.16	0.06
DFO trees parallelized	22	0.00	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	55	0.01	0.00
PX local messages sent	55	0.01	0.00
PX remote messages recv'd	443	0.06	0.02
PX remote messages sent	343	0.05	0.02
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	22	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	65	0.01	0.00
RowCR hits	65	0.01	0.00
SMON posted for undo segment shrink	4	0.00	0.00
SQL*Net roundtrips to/from client	1,036,935	143.90	57.64
active txn count during cleanout	904	0.13	0.05
application wait time	565	0.08	0.03
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	27,571	3.83	1.53
branch node splits	0	0.00	0.00
buffer is not pinned count	2,801,441	388.77	155.71
buffer is pinned count	1,106,188	153.51	61.49
bytes received via SQL*Net from client	81,995,918	11,378.95	4,557.61
bytes sent via SQL*Net to client	195,482,540	27,128.01	10,865.57
calls to get snapshot scn: kcmgss	413,816	57.43	23.00
calls to kcmgas	27,162	3.77	1.51
calls to kcmgcs	341	0.05	0.02
change write time	103	0.01	0.01
cleanout - number of ktugct calls	728	0.10	0.04
cleanouts and rollbacks - consistent read gets	187	0.03	0.01
cleanouts only - consistent read gets	46	0.01	0.00
cluster key scan block gets	8,258	1.15	0.46
cluster key scans	1,820	0.25	0.10
cluster wait time	531	0.07	0.03
commit batch/immediate performed	302	0.04	0.02
commit batch/immediate requested	302	0.04	0.02
commit cleanout failures: block lost	1	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	19	0.00	0.00
commit cleanout failures: cannot pin	35	0.00	0.00
commit cleanouts	19,505	2.71	1.08
commit cleanouts successfully completed	19,450	2.70	1.08
commit immediate performed	302	0.04	0.02
commit immediate requested	302	0.04	0.02
commit txn count during cleanout	167	0.02	0.01
concurrency wait time	2,175,715	301.93	120.93
consistent changes	838	0.12	0.05
consistent gets	5,822,332	807.99	323.62
consistent gets - examination	322,968	44.82	17.95
consistent gets direct	8	0.00	0.00
consistent gets from cache	5,822,322	807.99	323.62
current blocks converted for CR	0	0.00	0.00
cursor authentications	33,343	4.63	1.85
data blocks consistent reads - undo records applied	668	0.09	0.04
db block changes	78,926	10.95	4.39
db block gets	68,158	9.46	3.79
db block gets direct	33	0.00	0.00
db block gets from cache	68,128	9.45	3.79
deferred (CURRENT) block cleanout applications	7,065	0.98	0.39
dirty buffers inspected	0	0.00	0.00
enqueue conversions	18,386	2.55	1.02
enqueue deadlocks	0	0.00	0.00
enqueue releases	187,248	25.99	10.41
enqueue requests	186,593	25.89	10.37
enqueue timeouts	10	0.00	0.00
enqueue waits	9,991	1.39	0.56
exchange deadlocks	0	0.00	0.00
execute count	541,771	75.18	30.11
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	1	0.00	0.00
free buffer requested	17,076	2.37	0.95
gc CPU used by this session	2,430	0.34	0.14
gc blocks lost	0	0.00	0.00
gc cr block build time	7	0.00	0.00
gc cr block flush time	1	0.00	0.00
gc cr block receive time	745	0.10	0.04
gc cr block send time	35	0.00	0.00
gc cr blocks received	9,168	1.27	0.51
gc cr blocks served	6,279	0.87	0.35
gc current block flush time	0	0.00	0.00
gc current block pin time	35	0.00	0.00
gc current block receive time	295	0.04	0.02
gc current block send time	11	0.00	0.00
gc current blocks received	1,942	0.27	0.11
gc current blocks served	2,061	0.29	0.11
gc local grants	367	0.05	0.02
gc remote grants	282	0.04	0.02
gcs messages sent	97,754	13.57	5.43
ges messages sent	306,639	42.55	17.04
global enqueue get time	2,388,052	331.40	132.74
global enqueue gets async	36,360	5.05	2.02
global enqueue gets sync	448,224	62.20	24.91
global enqueue releases	452,350	62.77	25.14
heap block compress	163	0.02	0.01
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	233	0.03	0.01
immediate (CURRENT) block cleanout applications	4,976	0.69	0.28
index crx upgrade (found)	557	0.08	0.03
index crx upgrade (positioned)	87,838	12.19	4.88
index fast full scans (full)	94	0.01	0.01
index fetch by key	102,594	14.24	5.70
index scans kdiixs1	1,898,855	263.51	105.54
leaf node 90-10 splits	8	0.00	0.00
leaf node splits	45	0.01	0.00
lob reads	222	0.03	0.01
lob writes	438	0.06	0.02
lob writes unaligned	438	0.06	0.02
logons cumulative	335	0.05	0.02
messages received	75,146	10.43	4.18
messages sent	75,146	10.43	4.18
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	5,337,767	740.75	296.69
opened cursors cumulative	516,454	71.67	28.71
parse count (failures)	3	0.00	0.00
parse count (hard)	57,767	8.02	3.21
parse count (total)	695,090	96.46	38.64
parse time cpu	2,094	0.29	0.12
parse time elapsed	220,290	30.57	12.24
physical read IO requests	198	0.03	0.01
physical read bytes	3,244,032	450.19	180.31
physical read total IO requests	32,071	4.45	1.78
physical read total bytes	525,451,264	72,919.29	29,206.34
physical read total multi block requests	0	0.00	0.00
physical reads	198	0.03	0.01
physical reads cache	190	0.03	0.01
physical reads cache prefetch	0	0.00	0.00
physical reads direct	8	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	2,839	0.39	0.16
physical write bytes	57,737,216	8,012.46	3,209.23
physical write total IO requests	33,375	4.63	1.86
physical write total bytes	214,126,592	29,715.33	11,901.87
physical write total multi block requests	22,684	3.15	1.26
physical writes	3,524	0.49	0.20
physical writes direct	33	0.00	0.00
physical writes direct (lob)	8	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	3,491	0.48	0.19
physical writes non checkpoint	1,002	0.14	0.06
pinned buffers inspected	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	30,377	4.22	1.69
queries parallelized	22	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	249,769	34.66	13.88
recursive cpu usage	2,727	0.38	0.15
redo blocks written	39,348	5.46	2.19
redo buffer allocation retries	0	0.00	0.00
redo entries	46,388	6.44	2.58
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	611	0.08	0.03
redo size	15,857,492	2,200.62	881.41
redo subscn max counts	757	0.11	0.04
redo synch time	986	0.14	0.05
redo synch writes	10,636	1.48	0.59
redo wastage	3,535,296	490.61	196.50
redo write time	1,004	0.14	0.06
redo writer latching time	3	0.00	0.00
redo writes	11,713	1.63	0.65
rollback changes - undo records applied	308	0.04	0.02
rollbacks only - consistent read gets	148	0.02	0.01
rows fetched via callback	64,411	8.94	3.58
session connect time	0	0.00	0.00
session cursor cache hits	507,660	70.45	28.22
session logical reads	5,890,490	817.45	327.41
session pga memory	22,113,472	3,068.79	1,229.14
session uga memory max	143,083,456	19,856.35	7,953.06
shared hash latch upgrades - no wait	87,056	12.08	4.84
shared hash latch upgrades - wait	557	0.08	0.03
sorts (disk)	0	0.00	0.00
sorts (memory)	17,743	2.46	0.99
sorts (rows)	352,641	48.94	19.60
sql area evicted	54,768	7.60	3.04
sql area purged	17	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	4,910	0.68	0.27
table fetch by rowid	818,354	113.57	45.49
table fetch continued row	219	0.03	0.01
table scan blocks gotten	1,670,178	231.78	92.83
table scan rows gotten	299,320,601	41,538.09	16,637.24
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	26,370	3.66	1.47
total number of times SMON posted	8,812	1.22	0.49
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	302	0.04	0.02
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	5,203,308	722.09	289.22
user I/O wait time	287	0.04	0.02
user calls	1,351,701	187.58	75.13
user commits	10,021	1.39	0.56
user rollbacks	7,970	1.11	0.44
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	6,615	0.92	0.37
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	131,699	133,522
opened cursors current	2,582	1,462
logons current	132	131

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)
UNDOTBS1	0	0.00	0.00	1,142	7	0.00
SYSAUX	153	8.43	1.00	796	0	0.00
FMIS0400	1	10.00	1.00	334	81	1.48
SYSTEM	25	10.40	1.00	310	44	0.45
CWGK_IMS	1	10.00	1.00	128	20	0.00
FMIS_LARGE	0	0.00	0.00	79	0	0.00
FMISINDEX	1	10.00	1.00	50	7	24.29
TEMP	4	12.50	1.00	0	0	0.00
FMIS_LOB	0	0.00	0.00	1	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
CWGK_IMS	/dev/rlv_vpd_CWGK_IMS	1	10.00	1.00	128	20	0.00
FMIS0400	/dev/rlv_VPD0400_21	0			8	0	0.00
FMIS0400	/dev/rlv_VPD0400_22	0			10	0	0.00
FMIS0400	/dev/rlv_vpd0400_01	0			120	22	0.00
FMIS0400	/dev/rlv_vpd0400_02	0			69	59	2.03
FMIS0400	/dev/rlv_vpd0400_03	0			2	0	0.00
FMIS0400	/dev/rlv_vpd0400_04	0			1	0	0.00
FMIS0400	/dev/rlv_vpd0400_05	0			10	0	0.00
FMIS0400	/dev/rlv_vpd0400_06	0			13	0	0.00
FMIS0400	/dev/rlv_vpd0400_07	0			1	0	0.00
FMIS0400	/dev/rlv_vpd0400_08	1	10.00	1.00	3	0	0.00
FMIS0400	/dev/rlv_vpd0400_09	0			13	0	0.00
FMIS0400	/dev/rlv_vpd0400_11	0			14	0	0.00
FMIS0400	/dev/rlv_vpd0400_12	0			4	0	0.00
FMIS0400	/dev/rlv_vpd0400_13	0			10	0	0.00
FMIS0400	/dev/rlv_vpd0400_14	0			1	0	0.00
FMIS0400	/dev/rlv_vpd0400_15	0			3	0	0.00
FMIS0400	/dev/rlv_vpd0400_16	0			4	0	0.00
FMIS0400	/dev/rlv_vpd0400_17	0			8	0	0.00
FMIS0400	/dev/rlv_vpd0400_18	0			33	0	0.00
FMIS0400	/dev/rlv_vpd0400_19	0			7	0	0.00
FMISINDEX	/dev/rlv_vpdindex1	0			39	7	24.29
FMISINDEX	/dev/rlv_vpdindex2	0			1	0	0.00
FMISINDEX	/dev/rlv_vpdindex3	0			2	0	0.00
FMISINDEX	/dev/rlv_vpdindex5	0			6	0	0.00
FMISINDEX	/dev/rlv_vpdindex7	0			1	0	0.00
FMISINDEX	/dev/rlv_vpdindex8	1	10.00	1.00	1	0	0.00
FMIS_LARGE	/dev/rlv_vpd_large3	0			79	0	0.00
FMIS_LOB	/dev/rlv_vpd_lob1	0			1	0	0.00
SYSAUX	/dev/rlv_vpdsysaux01	153	8.43	1.00	796	0	0.00
SYSTEM	/dev/rlv_vpdsystem01	20	10.50	1.00	194	39	0.51
SYSTEM	/dev/rlv_vpdsystem02	5	10.00	1.00	116	5	0.00
TEMP	/dev/rlv_vpdtemp3	4	12.50	1.00	0	0
UNDOTBS1	/dev/rlv_vpdundo1_1	0			387	1	0.00
UNDOTBS1	/dev/rlv_vpdundo1_2	0			349	1	0.00
UNDOTBS1	/dev/rlv_vpdundo1_3	0			232	3	0.00
UNDOTBS1	/dev/rlv_vpdundo1_4	0			174	2	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	506,880	100	5,890,885	183	3,491	163
K	24,750		0	0	0	0
R	24,750	100	7	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	439	2546	10475	2764800	10475
E	0	0	376	3090	8390	2764800	8390

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	816	0.10	50,490	1.91	586,856,141
D	1,632	0.20	100,980	1.22	373,899,752
D	2,448	0.30	151,470	1.09	335,676,746
D	3,264	0.40	201,960	1.05	322,171,451
D	4,080	0.50	252,450	1.03	315,505,584
D	4,896	0.60	302,940	1.01	311,835,272
D	5,712	0.70	353,430	1.01	309,896,224
D	6,528	0.80	403,920	1.00	308,781,049
D	7,344	0.90	454,410	1.00	308,057,483
D	8,160	1.00	504,900	1.00	307,567,635
D	8,192	1.00	506,880	1.00	307,550,243
D	8,976	1.10	555,390	1.00	307,221,032
D	9,792	1.20	605,880	1.00	306,962,360
D	10,608	1.29	656,370	1.00	306,589,430
D	11,424	1.39	706,860	1.00	306,338,593
D	12,240	1.49	757,350	1.00	306,133,558
D	13,056	1.59	807,840	0.99	305,975,523
D	13,872	1.69	858,330	0.99	305,848,110
D	14,688	1.79	908,820	0.99	305,748,209
D	15,504	1.89	959,310	0.99	305,646,501
D	16,320	1.99	1,009,800	0.94	290,359,354

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	320	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	1,958	1,419	778.70	0.00	0.00	0.00	0.00	200,490
E	1,958	1,495	671.89	0.00	0.00	0.00	0.00	200,490

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	6,236	6,236
64K	128K	10	10
128K	256K	2	2
256K	512K	48	48
512K	1024K	324	324
1M	2M	1	1
2M	4M	2	2
4M	8M	3	3

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
245	0.13	4,010,130.70	198,904.63	95.00	36,746
490	0.25	4,010,130.70	5,794.47	100.00	201
979	0.50	4,010,130.70	3,226.65	100.00	0
1,469	0.75	4,010,130.70	3,226.65	100.00	0
1,958	1.00	4,010,130.70	2,195.68	100.00	0
2,350	1.20	4,010,130.70	633.62	100.00	0
2,741	1.40	4,010,130.70	633.62	100.00	0
3,133	1.60	4,010,130.70	633.62	100.00	0
3,524	1.80	4,010,130.70	633.62	100.00	0
3,916	2.00	4,010,130.70	633.62	100.00	0
5,874	3.00	4,010,130.70	633.62	100.00	0
7,832	4.00	4,010,130.70	633.62	100.00	0
11,748	6.00	4,010,130.70	633.62	100.00	0
15,664	8.00	4,010,130.70	633.62	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
1,600	0.39	440	26,004	3,134,041	0.91	362,392	5.29	617,084,250
2,016	0.49	855	40,482	3,178,784	0.93	317,649	4.63	619,436,579
2,432	0.59	1,270	54,484	3,205,634	0.94	290,799	4.24	620,669,726
2,848	0.70	1,684	87,426	3,275,472	0.96	220,961	3.22	621,891,576
3,264	0.80	2,099	119,146	3,317,158	0.97	179,275	2.62	622,369,678
3,680	0.90	2,514	159,298	3,377,572	0.99	118,861	1.73	622,843,236
4,096	1.00	2,929	200,847	3,427,888	1.00	68,545	1.00	623,173,907
4,512	1.10	3,344	234,790	3,466,708	1.01	29,725	0.43	623,421,749
4,928	1.20	3,759	275,517	3,489,640	1.02	6,793	0.10	623,704,241
5,344	1.30	4,174	306,726	3,536,499	1.03	1	0.00	623,950,523
5,760	1.41	4,589	328,924	3,585,783	1.05	1	0.00	624,364,435
6,176	1.51	5,004	355,446	3,622,390	1.06	1	0.00	624,565,835
6,592	1.61	5,419	382,672	3,667,898	1.07	1	0.00	624,934,416
7,008	1.71	5,834	413,384	3,705,187	1.08	1	0.00	625,152,058
7,424	1.81	6,249	444,876	3,737,765	1.09	1	0.00	625,417,156
7,840	1.91	6,664	472,707	3,789,510	1.11	1	0.00	625,641,800
8,256	2.02	7,079	500,328	3,797,120	1.11	1	0.00	625,868,047

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	152	2
undo header	4	0
undo block	3	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	3	3	0	3	677	225,827.33
CF-Controlfile Transaction	17,015	17,010	5	355	518	1,459.92
PS-PX Process Reservation	234	234	0	155	37	237.30
TD-KTF map table enqueue (KTF dump entries)	23	20	3	23	13	568.26
TX-Transaction (row lock contention)	505	493	0	479	4	7.39
RO-Multiple Object Reuse (fast object reuse)	33,808	33,808	0	8,452	2	0.28
WF-AWR Flush	58	57	1	37	1	24.51
TM-DML	18,058	18,058	0	316	0	0.55
TT-Tablespace	393	393	0	153	0	0.48
TX-Transaction (index contention)	5	5	0	4	0	4.25
MW-MWIN Schedule	4	4	0	4	0	0.75
FB-Format Block	12	12	0	2	0	0.50
PI-Remote PX Process Spawn Status	4	4	0	2	0	0.50
AF-Advisor Framework (task serialization)	14	14	0	1	0	1.00
US-Undo Segment	3	3	0	1	0	1.00
TA-Instance Undo	43	43	0	4	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

Error encountered in Undo Segment Summary While executing SQL statement: Len = 834 select undotsn , sum(undoblks)/1000 undob , sum(txncount) txcnt , max(maxquerylen) maxq , max(maxconcurrency) maxc , min(tuned_undoretention)/60 ||'/'|| max(tuned_undor etention)/60 mintun , sum(ssolderrcnt) ||'/'|| sum(nospaceerrcnt) snolno , sum (unxpstealcnt) ||'/'|| sum(unxpblkrelcnt) ||'/'| | sum(unxpblkreucnt) ||'/'|| sum(expstealcnt) || '/'|| sum(expblkrelcnt) ||'/'|| sum(expblkreucnt) blkst from dba_hist_undostat where dbid = :dbid a nd instance_number = :inst_num and end_time > :b_eitvtim e and begin_time < :e_eitvtime group by undotsn Encountered error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small Continuing to Next Section...

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

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

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
25-2月 05:01	135	1,022	0	3	59	0/0	0/0/0/0/0/0
25-2月 04:51	48	873	0	2	49	0/0	0/0/0/0/0/0
25-2月 04:41	39	804	0	2	39	0/0	0/0/0/0/0/0
25-2月 04:31	57	911	0	3	29	0/0	0/0/0/0/0/0
25-2月 04:21	56	937	0	3	19	0/0	0/0/0/0/0/0
25-2月 04:11	79	909	515	30	24	0/0	0/0/0/0/0/0
25-2月 04:01	39	1,014	0	25	19	0/0	0/0/0/0/0/0
25-2月 03:51	26	937	0	3	69	0/0	0/0/0/0/0/0
25-2月 03:41	19	968	0	1	59	0/0	0/0/0/0/0/0
25-2月 03:31	23	1,024	0	1	49	0/0	0/0/0/0/0/0
25-2月 03:21	21	941	0	3	39	0/0	0/0/0/0/0/0
25-2月 03:11	28	1,289	0	3	29	0/0	0/0/0/0/0/0
25-2月 03:01	90	1,173	0	3	19	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 db client latch	63,942	0.00		0	0
AWR Alerted Metric Element list	59,922	0.00		0	0
Consistent RBA	11,712	0.00		0	0
FAL request queue	140	0.00		0	0
FAL subheap alocation	140	0.00		0	0
FOB s.o list latch	3,090	0.00		0	0
JS broadcast add buf latch	1,582	0.00		0	0
JS broadcast drop buf latch	1,582	0.00		0	0
JS broadcast load blnc latch	1,383	0.00		0	0
JS queue state obj latch	49,788	0.00		0	0
JS slv state obj latch	17	0.00		0	0
KCL gc element parent latch	81,680	0.01	0.00	0	287	0.00
KJC message pool free list	83,520	0.02	0.13	0	4,237	0.02
KJCT flow control latch	741,956	0.01	0.00	0	0
KMG MMAN ready and startup request latch	2,402	0.00		0	0
KSXR large replies	448	0.00		0	0
KTF sga latch	42	0.00		0	1,952	0.00
KWQMN job cache list latch	607	0.00		0	0
KWQP Prop Status	4	0.00		0	0
MQL Tracking Latch	0			0	144	0.00
Memory Management Latch	0			0	2,402	0.00
OS process	681	0.00		0	0
OS process allocation	2,855	0.00		0	0
OS process: request allocation	409	0.00		0	0
PL/SQL warning settings	206,749	0.00		0	0
SGA IO buffer pool latch	22	0.00		0	22	0.00
SQL memory manager latch	2	0.00		0	2,326	0.00
SQL memory manager workarea list latch	159,630	0.00		0	0
Shared B-Tree	260	0.00		0	0
active checkpoint queue latch	119,904	1.92	0.00	0	0
active service list	15,776	0.00		0	2,435	0.00
archive control	116	0.00		0	0
archive process latch	2,606	0.00		0	0
begin backup scn array	10	0.00		0	0
business card	44	0.00		0	0
cache buffer handles	777	0.13	0.00	0	0
cache buffers chains	11,749,377	0.08	0.00	0	35,817	0.00
cache buffers lru chain	24,295	0.03	0.00	0	60,666	0.00
channel handle pool latch	553	0.00		0	0
channel operations parent latch	1,465,519	0.01	0.01	0	0
checkpoint queue latch	1,720,878	0.00	0.00	0	3,810	0.00
client/application info	1,597	0.00		0	0
commit callback allocation	128	0.00		0	0
compile environment latch	337	0.00		0	0
dictionary lookup	74	0.00		0	0
dml lock allocation	36,248	0.01	0.00	0	0
dummy allocation	675	0.00		0	0
enqueue hash chains	488,151	0.00	0.00	0	1,300	0.00
enqueues	367,608	0.01	0.00	0	0
error message lists	88	0.00		0	0
event group latch	204	0.00		0	0
file cache latch	3,274	0.00		0	0
gcs opaque info freelist	6,670	0.00		0	0
gcs partitioned table hash	120,771	0.00		0	0
gcs remastering latch	23	0.00		0	0
gcs resource freelist	8,816	0.00		0	4,386	0.00
gcs resource hash	69,398	0.26	0.00	0	0
gcs shadows freelist	4,617	0.00		0	5,365	0.00
ges caches resource lists	1,811,184	0.20	0.00	0	1,461,392	0.21
ges deadlock list	57,310	0.00		0	975	0.00
ges domain table	860,499	0.00		0	0
ges enqueue table freelist	1,605,832	0.02	0.00	0	0
ges group table	1,304,384	0.00	0.00	0	0
ges process hash list	981,307	0.15	0.96	0	0
ges process parent latch	2,621,316	0.00	0.00	0	0
ges process table freelist	409	0.00		0	0
ges resource hash list	3,902,885	0.18	0.27	1	694,373	0.01
ges resource scan list	998	0.00		0	0
ges resource table freelist	815,561	0.00	0.00	0	0
ges timeout list	2,990	0.00		0	34,374	0.00
global KZLD latch for mem in SGA	193	0.00		0	0
global ctx hash table latch	386	0.00		0	0
hash table column usage latch	559	0.18	1.00	0	126,325	0.00
hash table modification latch	164	0.00		0	0
job_queue_processes parameter latch	115	0.00		0	0
kks stats	363,701	0.01	0.31	0	0
kokc descriptor allocation latch	952	0.00		0	0
ksuosstats global area	484	0.00		0	0
ktm global data	8,840	0.00		0	0
kwqbsn:qsga	258	0.00		0	0
lgwr LWN SCN	12,088	0.10	0.00	0	0
library cache	8,453,347	0.28	0.01	1	163,692	0.08
library cache load lock	1,144	0.00		0	0
library cache lock	3,468,451	0.04	0.00	0	0
library cache lock allocation	3,916	0.00		0	0
library cache pin	3,704,482	0.10	0.00	0	0
library cache pin allocation	212,633	0.00		0	0
list of block allocation	577	0.00		0	0
loader state object freelist	50	0.00		0	0
logminer context allocation	2	0.00		0	0
message pool operations parent latch	45,575	0.02	0.00	0	0
messages	593,830	0.82	0.00	0	0
mostly latch-free SCN	12,066	0.07	0.00	0	0
multiblock read objects	2,912	0.00		0	0
name-service memory objects	11,120	0.00		0	0
name-service namespace bucket	75,761	0.00		0	0
name-service namespace objects	4	0.00		0	0
name-service pending queue	5,380	0.00		0	0
name-service request	12	0.00		0	0
name-service request queue	76,593	0.00		0	0
ncodef allocation latch	116	0.00		0	0
object queue header heap	391,771	0.00		0	6,011	0.00
object queue header operation	671,815	0.00	0.00	0	0
object stats modification	9,169	0.00		0	0
parallel query alloc buffer	2,148	0.00		0	0
parallel query stats	199	0.00		0	0
parallel txn reco latch	9,761	0.00		0	0
parameter list	54	0.00		0	0
parameter table allocation management	341	0.00		0	0
post/wait queue	15,831	0.00		0	10,556	0.02
process allocation	69,902	0.00		0	204	0.00
process group creation	409	0.00		0	0
process queue	524	0.00		0	0
process queue reference	9,452	0.00		0	896	0.00
qmn task queue latch	1,016	0.00		0	0
query server freelists	402	0.00		0	0
query server process	2	0.00		0	2	0.00
queued dump request	36,029	0.00		0	0
redo allocation	35,857	0.03	0.00	0	46,339	0.07
redo copy	0			0	46,353	0.46
redo writing	105,265	0.69	0.00	0	0
resmgr group change latch	427	0.00		0	0
resmgr:active threads	669	0.00		0	0
resmgr:actses change group	326	0.00		0	0
resmgr:free threads list	667	0.00		0	0
resmgr:schema config	2	0.00		0	0
row cache objects	5,948,732	0.15	0.00	0	16,886	0.01
rules engine aggregate statistics	34	0.00		0	0
rules engine rule set statistics	268	0.00		0	0
sequence cache	2,612	0.11	0.00	0	0
session allocation	214,205	0.07	0.00	0	0
session idle bit	2,756,943	0.01	0.00	0	0
session state list latch	751	0.00		0	0
session switching	116	0.00		0	0
session timer	2,435	0.00		0	0
shared pool	2,566,149	0.16	0.13	1	0
shared pool simulator	4,235,229	0.00	0.03	0	0
simulator hash latch	501,668	0.00	0.00	0	0
simulator lru latch	0			0	501,590	0.18
slave class	4	0.00		0	0
slave class create	16	6.25	1.00	0	0
sort extent pool	10,570	0.12	0.00	0	0
state object free list	4	0.00		0	0
statistics aggregation	1,120	0.00		0	0
temp lob duration state obj allocation	48	0.00		0	0
temporary table state object allocation	56	0.00		0	0
threshold alerts latch	1,187	0.00		0	0
transaction allocation	581	0.00		0	0
transaction branch allocation	2,435	0.00		0	0
undo global data	47,744	0.01	0.00	0	0
user lock	877	0.80	0.00	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
library cache	8,453,347	23,430	138	23,297
cache buffers chains	11,749,377	8,866	22	8,845
row cache objects	5,948,732	8,716	4	8,712
ges resource hash list	3,902,885	7,147	1,940	5,207
messages	593,830	4,852	3	4,849
shared pool	2,566,149	4,088	532	3,590
ges caches resource lists	1,811,184	3,707	8	3,699
library cache pin	3,704,482	3,556	2	3,554
library cache lock	3,468,451	1,550	3	1,547
ges process hash list	981,307	1,495	1,433	62
session idle bit	2,756,943	395	1	394
channel operations parent latch	1,465,519	193	1	192
shared pool simulator	4,235,229	185	6	179
kks stats	363,701	49	15	36
KJC message pool free list	83,520	16	2	14
hash table column usage latch	559	1	1	0
slave class create	16	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
KJC message pool free list	kjcspfmbq: free vector of msg buffers	2	0
cache buffers chains	kcbgtcr: kslbegin excl	32	24
cache buffers chains	kcbgcur: kslbegin	8	4
cache buffers chains	kcbchg: kslbegin: bufs not pinned	5	6
cache buffers chains	kcbrls: kslbegin	3	12
cache buffers chains	kcbzwb	3	3
cache buffers chains	kcbbxsv	2	3
cache buffers chains	kcbgtcr: fast path	2	0
cache buffers chains	kcbget: pin buffer	1	0
cache buffers chains	kclwrt	1	0
channel operations parent latch	ksrwait()	2	1
ges process hash list	kjakiqa: set inquiry response	1,433	0
ges resource hash list	kjakcai: search for resp by resname	1,710	1
ges resource hash list	kjrmas1: lookup master node	100	2
ges resource hash list	kjucvl: lock convert request	37	1,660
ges resource hash list	kjcvscn: remove from scan queue	36	0
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	33	1
ges resource hash list	kjlrlr: remove lock from resource queue	11	158
ges resource hash list	kjrref: find matched resource	11	118
ges resource hash list	kjtscn: try lock res with nowait	2	0
ges resource table freelist	kjruch: cached obj cleanup	7	0
ges resource table freelist	kjrchc: cached obj cleanup	1	0
hash table column usage latch	KSXMMON_GETCELEM	1	0
kks stats	kks stats alloc/free	15	15
library cache	kglpndl: child: after processing	35	0
library cache	kglobpn: child:	22	55
library cache	kglpin	9	10
library cache	kgldte: child 0	7	4
library cache	kgldti: 2child	6	2
library cache	kglScanDependency	5	0
library cache	kglrtl	5	4
library cache	kglukp: child	5	8
library cache	kglLockCursor	3	1
library cache	kglati	3	0
library cache	kglhdgn: child:	3	11
library cache	kglpndl: child: before processing	3	18
library cache	kglhdgc: child:	1	0
library cache lock	kgllkdl: child: no lock handle	15	7
library cache lock	kgllkdl: child: cleanup	2	2
library cache lock	kgllkal: child: multiinstance	1	1
library cache pin	kglpnal: child: alloc space	1	2
library cache pin	kglpndl	1	0
messages	ksarcv	2	1
messages	ksarcv: after wait	1	1
object queue header operation	kcbo_switch_q_bg	2	0
row cache objects	kqreqd: reget	3	0
row cache objects	ksucallcbksafely: kqrhngc	1	0
session idle bit	ksupuc: set busy	1	0
shared pool	kghalo	374	209
shared pool	kghupr1	73	198
shared pool	kghalp	39	91
shared pool	kghfrunp: alloc: wait	28	2
shared pool	kghfre	17	22
shared pool	kghfrunp: clatch: nowait	12	0
shared pool	kghfrunp: clatch: wait	4	14
shared pool	kghasp	1	10
shared pool simulator	kglsim_unpin_simhp	6	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: 5,890,490
Captured Segments account for 90.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
FMIS0400	FMIS0400	MSG_QUEUE		TABLE	750,784	12.75
CWGK_IMS	CWGK_IMS	NBI_LOG_EVENT		TABLE	378,768	6.43
SYS	SYSTEM	OBJ$		TABLE	221,696	3.76
FMIS0400	FMISINDEX	IND_XTTRANSBILL_BILLID	IND_PA_014	INDEX PARTITION	194,928	3.31
FMIS0400	FMISINDEX	IND_XTTRANSBILL_BILLID	IND_PA_008	INDEX PARTITION	185,152	3.14

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 198
Captured Segments account for 37.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	AUD$	TABLE	13	6.57
SYS	SYSAUX	WRH$_SQLTEXT	TABLE	13	6.57
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	12	6.06
SYS	SYSTEM	I_AUD1	INDEX	5	2.53
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY	TABLE	5	2.53

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
FMIS0400	FMIS0400	QRTZ_LOCKS		TABLE	896	94.92
FMIS0400	FMISINDEX	IDU060712193340934		INDEX	43	4.56
SYS	SYSTEM	I_AUD1		INDEX	2	0.21
SYS	SYSTEM	I_COL2		INDEX	2	0.21
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	7179_12735	INDEX PARTITION	1	0.11

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
FMIS0400	FMIS0400	XTCLUSTERLOCK	TABLE	54	58.06
FMIS0400	FMIS0400	QRTZ_LOCKS	TABLE	22	23.66
SYS	SYSTEM	AUD$	TABLE	9	9.68
SYS	SYSTEM	I_AUD1	INDEX	4	4.30
SYS	SYSTEM	I_COL2	INDEX	2	2.15

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
SYS	SYSTEM	USER$	TABLE	27	45.76
CWGK_IMS	CWGK_IMS	NBI_LOG_EVENT	TABLE	20	33.90
FMIS0400	FMISINDEX	IDU060712193340934	INDEX	7	11.86
FMIS0400	FMIS0400	XTCLUSTERLOCK	TABLE	5	8.47

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 9,168
Captured Segments account for 99.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	TAB$	TABLE	3,848	41.97
SYS	SYSTEM	SEG$	TABLE	1,372	14.97
SYS	SYSTEM	JOB$	TABLE	922	10.06
SYS	SYSTEM	I_JOB_NEXT	INDEX	811	8.85
SYS	SYSTEM	I_OBJ2	INDEX	797	8.69

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 1,942
Captured Segments account for 91.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSTEM	TAB$	TABLE	516	26.57
SYS	SYSTEM	I_JOB_NEXT	INDEX	199	10.25
SYS	SYSTEM	JOB$	TABLE	171	8.81
FMIS0400	FMIS0400	QRTZ_LOCKS	TABLE	101	5.20
FMIS0400	FMISINDEX	IDU060712193340934	INDEX	100	5.15

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	120	1.67	2	1
dc_database_links	389	0.00	0	1
dc_global_oids	633	0.00	0	23
dc_histogram_data	1,545,326	0.02	0	3,216
dc_histogram_defs	674,365	0.07	0	1,660
dc_object_grants	8	100.00	0	16
dc_object_ids	280,969	0.09	60	519
dc_objects	60,008	0.59	96	466
dc_profiles	193	0.00	0	1
dc_rollback_segments	14,358	0.00	0	229
dc_segments	80,200	0.52	72	378
dc_sequences	52	32.69	52	2
dc_tablespace_quotas	31	29.03	31	0
dc_tablespaces	10,039	0.00	0	23
dc_usernames	200,673	0.00	0	43
dc_users	145,963	0.00	0	61
outstanding_alerts	554	79.06	34	4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	11	2	0
dc_histogram_defs	454	0	1,773
dc_object_ids	309	2	685
dc_objects	488	1	632
dc_segments	525	0	721
dc_sequences	108	17	4
dc_tablespace_quotas	42	9	1
dc_usernames	2	0	2
outstanding_alerts	1,077	463	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	213	0.47	593,249	0.00	4	0
CLUSTER	12	16.67	24	8.33	0	0
INDEX	13,399	0.01	20,838	0.07	12	0
SQL AREA	197,135	12.31	861,493	20.09	41,689	15
TABLE/PROCEDURE	16,163	0.59	1,064,358	0.06	269	0
TRIGGER	76	0.00	313	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	24	2	1	2
INDEX	20,838	2	30	2
TABLE/PROCEDURE	126,337	151	505	194

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	579.40		4.36	12.93	111	111	133	133
	Freeable	190.00	0.00	1.78	5.03	45		107	107
	SQL	4.84	1.81	0.04	0.02	0	226	117	115
	PL/SQL	4.48	2.84	0.03	0.02	0	0	133	132
E	Other	507.46		3.84	13.07	111	111	132	132
	Freeable	156.25	0.00	2.26	6.22	45		69	69
	PL/SQL	4.38	2.75	0.03	0.02	0	0	132	131
	SQL	3.82	1.75	0.03	0.02	0	92	116	114

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	9,428,795,392
Fixed Size	2,108,080
Redo Buffers	14,667,776
Variable Size	4,513,072,464

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	160.00	160.00	0.00
large	free memory	32.00	32.00	0.00
shared	CCursor	392.09	397.02	1.26
shared	Cursor Stats	47.24	47.24	0.00
shared	PCursor	258.17	259.82	0.64
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	521.69	550.19	5.46
shared	gcs resources	97.41	97.41	0.00
shared	gcs shadows	58.33	58.33	0.00
shared	ges enqueues	266.53	268.92	0.89
shared	ges resource	384.51	329.15	-14.40
shared	kglsim heap	59.98	59.98	0.00
shared	kglsim object batch	99.90	99.90	0.00
shared	library cache	158.47	155.73	-1.73
shared	obj stat memo	71.16	71.16	0.00
shared	sql area	1,368.99	1,376.62	0.56
shared	sql area:PLSQL	55.56	72.58	30.62
streams	free memory	16.00	16.00	0.00
	buffer_cache	8,992.00	8,992.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	43,442	0	0
QMON Slaves	16,345	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	34	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	349,220	608,477	630378	630378
gcs_shadows	436,221	610,221	630378	630378
ges_procs	132	360	401	401
processes	133	362	400	400
sessions	142	371	445	445

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/opt/app/oracle/admin/odsdb/adump
audit_sys_operations	TRUE
audit_trail	DB_EXTENDED
background_dump_dest	/opt/app/oracle/admin/odsdb/bdump
bitmap_merge_area_size	65536
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	/opt/app/oracle/admin/odsdb/cdump
create_bitmap_area_size	65536
db_block_size	16384
db_cache_size	8589934592
db_domain
db_file_multiblock_read_count	16
db_files	2000
db_keep_cache_size	419430400
db_name	odsdb
db_recycle_cache_size	419430400
db_writer_processes	2
hash_area_size	1048576
instance_number	1
java_pool_size	167772160
job_queue_processes	5
large_pool_size	33554432
local_listener	(address=(protocol=tcp)(host=10.122.7.192)(port=1521))
log_archive_dest_1	LOCATION=/oraarch
open_cursors	500
optimizer_mode	CHOOSE
pga_aggregate_target	2053111808
processes	400
recyclebin	OFF
remote_listener	LISTENERS_ODSDB
remote_login_passwordfile	EXCLUSIVE
service_names	ods
sessions	445
sga_max_size	13958643712
sga_target	0
shared_pool_reserved_size	419430400
shared_pool_size	4294967296
sort_area_size	1048576
spfile	/dev/rlv_vpdspfile
sql92_security	TRUE
streams_pool_size	16777216
thread	1
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/opt/app/oracle/admin/odsdb/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	59,142	8.21	3.29
acks for commit broadcast(logical)	67,441	9.36	3.75
broadcast msgs on commit(actual)	11,707	1.62	0.65
broadcast msgs on commit(logical)	11,713	1.63	0.65
broadcast msgs on commit(wasted)	99	0.01	0.01
broadcast on commit wait time(ms)	54	0.01	0.00
broadcast on commit waits	50	0.01	0.00
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	29	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	1,232	0.17	0.07
gcs ast xid	0	0.00	0.00
gcs blocked converts	2,281	0.32	0.13
gcs blocked cr converts	9,002	1.25	0.50
gcs compatible basts	1	0.00	0.00
gcs compatible cr basts (global)	454	0.06	0.03
gcs compatible cr basts (local)	739	0.10	0.04
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	301	0.04	0.02
gcs dbwr write request msgs	100	0.01	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	2,366	0.33	0.13
gcs immediate (null) converts	2,067	0.29	0.11
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	2,476	0.34	0.14
gcs indirect ast	7,467	1.04	0.42
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	103	0.01	0.01
gcs msgs process time(ms)	1,054	0.15	0.06
gcs msgs received	105,433	14.63	5.86
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	1,711	0.24	0.10
gcs side channel msgs logical	11,354	1.58	0.63
gcs stale cr	588	0.08	0.03
gcs undo cr	0	0.00	0.00
gcs write notification msgs	60	0.01	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	31,386	4.36	1.74
ges msgs received	982,243	136.31	54.60
global posts dropped	0	0.00	0.00
global posts queue time	4	0.00	0.00
global posts queued	34	0.00	0.00
global posts requested	34	0.00	0.00
global posts sent	34	0.00	0.00
implicit batch messages received	38,896	5.40	2.16
implicit batch messages sent	14,052	1.95	0.78
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	57,329	7.96	3.19
messages queue sent actual	253,676	35.20	14.10
messages queue sent logical	271,967	37.74	15.12
messages received actual	448,405	62.23	24.92
messages received logical	1,087,675	150.94	60.46
messages sent directly	52,602	7.30	2.92
messages sent indirectly	54,153	7.52	3.01
messages sent not implicit batched	239,624	33.25	13.32
messages sent pbatched	283,983	39.41	15.78
msgs causing lmd to send msgs	172,113	23.88	9.57
msgs causing lms(s) to send msgs	5,282	0.73	0.29
msgs received queue time (ms)	18,329	2.54	1.02
msgs received queued	1,087,674	150.94	60.46
msgs sent queue time (ms)	5,997	0.83	0.33
msgs sent queue time on ksxp (ms)	187,638	26.04	10.43
msgs sent queued	268,923	37.32	14.95
msgs sent queued on ksxp	366,676	50.89	20.38
process batch messages received	110,587	15.35	6.15
process batch messages sent	261,488	36.29	14.53

Global CR Served Stats

Statistic	Total
CR Block Requests	2,200
CURRENT Block Requests	4,079
Data Block Requests	2,200
Undo Block Requests	0
TX Block Requests	7
Current Results	6,244
Private results	5
Zero Results	28
Disk Read Results	0
Fail Results	0
Fairness Down Converts	757
Fairness Clears	0
Free GC Elements	0
Flushes	57
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	5
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	2,061	99.47	0.00	0.53	0.00
Flushes	0	0.00	0.00	0.00	0.00
Writes	401	58.85	39.15	1.50	0.50

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	9,091	99.57	0.08	0.35	1,875	97.01	2.99	0.00
2	Others	77	100.00	0.00	0.00	84	100.00	0.00	0.00
2	undo header	15	100.00	0.00	0.00	2	100.00	0.00	0.00
2	undo block	1	100.00	0.00	0.00	0

End of Report

% Blocks changed per Read:	1.34	Recursive Call %:	15.60
Rollback per transaction %:	44.30	Rows per Sort:	19.87

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	93.16	Soft Parse %:	91.69
Execute to Parse %:	-28.30	Latch Hit %:	99.89
Parse CPU to Parse Elapsd %:	0.95	% Non-Parse CPU:	91.34

Buffer access - local cache %:	99.81
Buffer access - remote cache %:	0.19
Buffer access - disk %:	0.00

Avg global enqueue get time (ms):	49.3
Avg global cache cr block receive time (ms):	0.8
Avg global cache current block receive time (ms):	1.5
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.1
Global cache log flushes for cr blocks served %:	0.9
Avg global cache cr block flush time (ms):	0.2
Avg global cache current block pin time (ms):	0.2
Avg global cache current block send time (ms):	0.1
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.5
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:	32.06
% of indirect sent messages:	33.00
% of flow controlled messages:	34.94