WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

CWGKVPD 543330226 CWGKVPD2 2 10.2.0.4.0 YES GKdb2

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
CWGKVPD	543330226	CWGKVPD2	2	10.2.0.4.0	YES	GKdb2

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 12323 08-Mar-12 03:00:06 36 3.6

End Snap: 12324 08-Mar-12 03:59:47 34 2.1

Elapsed: 59.68 (mins)

DB Time: 840.33 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	12323	08-Mar-12 03:00:06	36	3.6
End Snap:	12324	08-Mar-12 03:59:47	34	2.1
Elapsed:		59.68 (mins)
DB Time:		840.33 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 721.57 662.33

Logical reads: 189.93 174.34

Block changes: 1.92 1.76

Physical reads: 0.00 0.00

Physical writes: 0.18 0.16

User calls: 2.11 1.93

Parses: 2.10 1.92

Hard parses: 0.24 0.22

Sorts: 1.45 1.33

Logons: 0.04 0.04

Executes: 3.82 3.50

Transactions: 1.09

	Per Second	Per Transaction
Redo size:	721.57	662.33
Logical reads:	189.93	174.34
Block changes:	1.92	1.76
Physical reads:	0.00	0.00
Physical writes:	0.18	0.16
User calls:	2.11	1.93
Parses:	2.10	1.92
Hard parses:	0.24	0.22
Sorts:	1.45	1.33
Logons:	0.04	0.04
Executes:	3.82	3.50
Transactions:	1.09

% Blocks changed per Read: 1.01 Recursive Call %: 95.24

Rollback per transaction %: 92.54 Rows per Sort: 184.40

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

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

Library Hit %: 86.40 Soft Parse %: 88.62

Execute to Parse %: 45.11 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 0.18 % Non-Parse CPU: 98.72

Shared Pool Statistics

Begin End

Memory Usage %: 56.23 21.97

% SQL with executions>1: 97.24 74.16

% Memory for SQL w/exec>1: 97.09 73.46

	Begin	End
Memory Usage %:	56.23	21.97
% SQL with executions>1:	97.24	74.16
% Memory for SQL w/exec>1:	97.09	73.46

Top 5 Timed Events

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

cursor: pin S wait on X 2,676,490 26,174 10 51.9 Concurrency

rdbms ipc reply 6,946 13,103 1,886 26.0 Other

row cache lock 7,039 10,578 1,503 21.0 Concurrency

CPU time 4,648 9.2

latch: row cache objects 31,261 2,493 80 4.9 Concurrency

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
cursor: pin S wait on X	2,676,490	26,174	10	51.9	Concurrency
rdbms ipc reply	6,946	13,103	1,886	26.0	Other
row cache lock	7,039	10,578	1,503	21.0	Concurrency
CPU time		4,648		9.2
latch: row cache objects	31,261	2,493	80	4.9	Concurrency

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 0.34 0.32

Global Cache blocks served: 0.87 0.80

GCS/GES messages received: 5.21 4.78

GCS/GES messages sent: 81.88 75.16

DBWR Fusion writes: 0.03 0.03

Estd Interconnect traffic (KB) 36.49

	Per Second	Per Transaction
Global Cache blocks received:	0.34	0.32
Global Cache blocks served:	0.87	0.80
GCS/GES messages received:	5.21	4.78
GCS/GES messages sent:	81.88	75.16
DBWR Fusion writes:	0.03	0.03
Estd Interconnect traffic (KB)	36.49

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

Buffer access - local cache %: 99.82

Buffer access - remote cache %: 0.18

Buffer access - disk %: 0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.2

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

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

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

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

Global cache log flushes for cr blocks served %: 0.1

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

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

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

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

% of indirect sent messages: 91.98

% of flow controlled messages: 6.88

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

Statistic Name	Time (s)	% of DB Time
connection management call elapsed time	34,852.46	69.12
parse time elapsed	30,557.60	60.61
sql execute elapsed time	15,501.43	30.74
hard parse elapsed time	10,949.72	21.72
DB CPU	4,647.59	9.22
failed parse elapsed time	117.19	0.23
PL/SQL execution elapsed time	3.26	0.01
PL/SQL compilation elapsed time	0.37	0.00
sequence load elapsed time	0.04	0.00
hard parse (sharing criteria) elapsed time	0.04	0.00
repeated bind elapsed time	0.02	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	50,419.73
background elapsed time	9,235.46
background cpu time	37.17

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	2,951,601	90.81	39,600	13	756.63
Other	429,971	98.73	13,185	31	110.22
System I/O	33,084	0.00	11	0	8.48
Cluster	1,550	0.26	1	1	0.40
Commit	181	0.00	0	2	0.05
Application	150	0.00	0	1	0.04
User I/O	93	0.00	0	1	0.02
Network	6,542	0.00	0	0	1.68
Configuration	1	0.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
cursor: pin S wait on X	2,676,490	100.00	26,174	10	686.10
rdbms ipc reply	6,946	96.53	13,103	1886	1.78
row cache lock	7,039	55.70	10,578	1503	1.80
latch: row cache objects	31,261	0.00	2,493	80	8.01
latch: shared pool	6,133	0.00	313	51	1.57
latch free	608	0.00	78	128	0.16
library cache load lock	62	1.61	28	453	0.02
latch: library cache	1,153	0.00	13	12	0.30
control file sequential read	30,301	0.00	9	0	7.77
CGS wait for IPC msg	413,585	100.00	3	0	106.02
control file parallel write	1,197	0.00	1	1	0.31
log file parallel write	1,120	0.00	1	1	0.29
library cache lock	1,262	0.00	1	0	0.32
log file sync	181	0.00	0	2	0.05
gc buffer busy	85	4.71	0	5	0.02
os thread startup	16	0.00	0	24	0.00
gc cr block 2-way	786	0.00	0	0	0.20
db file parallel write	466	0.00	0	0	0.12
enq: TM - contention	133	0.00	0	2	0.03
gc current block 2-way	383	0.00	0	0	0.10
cursor: mutex X	227,914	0.00	0	0	58.42
gc current block busy	5	0.00	0	30	0.00
wait for scn ack	756	0.00	0	0	0.19
name-service call wait	3	0.00	0	42	0.00
library cache pin	258	0.00	0	0	0.07
enq: CF - contention	134	0.00	0	1	0.03
gc current grant busy	241	0.00	0	0	0.06
db file sequential read	91	0.00	0	1	0.02
DFS lock handle	147	0.00	0	0	0.04
ksxr poll remote instances	5,222	39.24	0	0	1.34
kksfbc child completion	1	100.00	0	49	0.00
enq: PS - contention	56	0.00	0	0	0.01
reliable message	101	0.00	0	0	0.03
PX Deq: reap credit	2,145	98.60	0	0	0.55
enq: TT - contention	51	0.00	0	0	0.01
enq: JQ - contention	42	0.00	0	0	0.01
gc cr block busy	16	0.00	0	1	0.00
PX Deq Credit: send blkd	39	10.26	0	0	0.01
SQL*Net message to client	6,524	0.00	0	0	1.67
IPC send completion sync	21	100.00	0	0	0.01
enq: WF - contention	12	0.00	0	0	0.00
PX Deq: Signal ACK	54	44.44	0	0	0.01
gc current multi block request	10	0.00	0	0	0.00
gc cr multi block request	15	0.00	0	0	0.00
gc current grant 2-way	9	0.00	0	0	0.00
latch: ges resource hash list	17	0.00	0	0	0.00
direct path write	2	0.00	0	1	0.00
enq: TD - KTF dump entries	4	0.00	0	0	0.00
gcs log flush sync	2	0.00	0	1	0.00
enq: RO - fast object reuse	3	0.00	0	0	0.00
ges inquiry response	2	0.00	0	0	0.00
enq: DR - contention	2	0.00	0	0	0.00
enq: MW - contention	2	0.00	0	0	0.00
enq: IR - contention	2	0.00	0	0	0.00
SQL*Net break/reset to client	14	0.00	0	0	0.00
enq: CU - contention	1	0.00	0	1	0.00
log buffer space	1	0.00	0	0	0.00
KJC: Wait for msg sends to complete	9	0.00	0	0	0.00
enq: PI - contention	1	0.00	0	0	0.00
latch: cache buffers chains	12	0.00	0	0	0.00
LGWR wait for redo copy	6	0.00	0	0	0.00
buffer busy waits	1	0.00	0	0	0.00
SQL*Net more data from client	18	0.00	0	0	0.00
SQL*Net message from client	6,525	0.00	17,334	2657	1.67
gcs remote message	483,322	99.73	13,986	29	123.90
Streams AQ: waiting for time management or cleanup tasks	12	100.00	3,516	292969	0.00
Streams AQ: qmn slave idle wait	127	0.00	3,509	27629	0.03
Streams AQ: qmn coordinator idle wait	283	46.64	3,509	12399	0.07
ges remote message	67,660	65.78	3,496	52	17.34
virtual circuit status	119	100.00	3,486	29297	0.03
DIAG idle wait	17,813	0.00	3,479	195	4.57
jobq slave wait	784	92.98	2,265	2890	0.20
PX Deq: Execution Msg	873	85.11	1,791	2052	0.22
PX Idle Wait	664	94.43	1,549	2333	0.17
Streams AQ: waiting for messages in the queue	18	100.00	59	3257	0.00
PX Deq: Join ACK	77	35.06	0	1	0.02
PX Deq: Parse Reply	78	34.62	0	1	0.02
PX Deq: Execute Reply	70	28.57	0	0	0.02
PX Deq: Msg Fragment	35	8.57	0	0	0.01
Streams AQ: RAC qmn coordinator idle wait	283	100.00	0	0	0.07
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
cursor: pin S wait on X	481,474	100.00	4,708	10	123.42
row cache lock	2,429	37.51	2,216	912	0.62
latch: row cache objects	27,976	0.00	2,145	77	7.17
latch: shared pool	4,470	0.00	94	21	1.15
events in waitclass Other	420,317	98.91	12	0	107.75
latch: library cache	958	0.00	5	5	0.25
control file sequential read	9,694	0.00	4	0	2.49
control file parallel write	1,197	0.00	1	1	0.31
log file parallel write	1,120	0.00	1	1	0.29
os thread startup	16	0.00	0	24	0.00
library cache lock	670	0.00	0	0	0.17
db file parallel write	466	0.00	0	0	0.12
enq: TM - contention	132	0.00	0	2	0.03
gc cr block 2-way	96	0.00	0	0	0.02
library cache pin	102	0.00	0	0	0.03
gc current block 2-way	80	0.00	0	0	0.02
db file sequential read	2	0.00	0	8	0.00
gc cr block busy	4	0.00	0	2	0.00
gc current grant busy	6	0.00	0	0	0.00
direct path write	2	0.00	0	1	0.00
gc buffer busy	2	0.00	0	1	0.00
gc current multi block request	2	0.00	0	0	0.00
gc current grant 2-way	3	0.00	0	0	0.00
log buffer space	1	0.00	0	0	0.00
enq: RO - fast object reuse	1	0.00	0	0	0.00
rdbms ipc message	53,333	91.14	41,556	779	13.67
gcs remote message	483,327	99.73	13,986	29	123.90
Streams AQ: waiting for time management or cleanup tasks	12	100.00	3,516	292969	0.00
Streams AQ: qmn slave idle wait	127	0.00	3,509	27629	0.03
Streams AQ: qmn coordinator idle wait	283	46.64	3,509	12399	0.07
pmon timer	1,209	100.00	3,498	2893	0.31
ges remote message	67,677	65.78	3,496	52	17.35
DIAG idle wait	17,814	0.00	3,479	195	4.57
smon timer	8	87.50	1,755	219333	0.00
PX Deq: Parse Reply	15	40.00	0	1	0.00
PX Deq: Join ACK	14	42.86	0	1	0.00
Streams AQ: RAC qmn coordinator idle wait	283	100.00	0	0	0.07
PX Deq: Execute Reply	13	30.77	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	17,961
AVG_IDLE_TIME	340,524
AVG_IOWAIT_TIME	61
AVG_SYS_TIME	1,534
AVG_USER_TIME	16,316
BUSY_TIME	289,176
IDLE_TIME	5,450,068
IOWAIT_TIME	2,610
SYS_TIME	26,286
USER_TIME	262,890
LOAD	0
OS_CPU_WAIT_TIME	315,100
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	49,392,123,904
NUM_CPUS	16
NUM_CPU_CORES	8

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	50,393.00	4,647.50	2	634,935
CWGK	0.00	0.00	0	0
CWGKVPD	0.00	0.00	0	0
CWGKVPD2XDB	0.00	0.00	0	0
SYS$BACKGROUND	0.00	0.00	4	39,818

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	2	2	2432443	3037940	6415	1
CWGKVPD	0	0	0	0	0	0
SYS$BACKGROUND	91	5	519066	922011	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
19,609	33	24	817.06	38.89	5ur69atw3vfhj		select decode(failover_method,...
8,828	13	227	38.89	17.51	83taa7kaw59c1		select name, intcol#, segcol#,...
2,154	0	67	32.16	4.27	a1mbfp580hw3k		select u1.user#, u2.user#, u...
2,002	4	1	2001.80	3.97	2ctzxkhd3zmpp	JDBC Thin Client	SELECT DISTINCT A.YHDM YHDM, ...
1,988	4	2	993.85	3.94	8vkjh60z1g287		select OBJOID, CLSOID, RUNT...
1,753	3	2	876.49	3.48	c7sn076yz7030		select smontabv.cnt, smontab....
44	0	9	4.84	0.09	91yym373k8wgt	JDBC Thin Client	select csz from xtcs where csm...
43	0	20	2.17	0.09	aq8yqxyyb40nn		update sys.job$ set this_date=...
17	0	15	1.11	0.03	459f3z9u4fb3u		select value$ from props$ wher...
16	0	1	16.05	0.03	a1xgxtssv5rrp		select sum(used_blocks), ts.t...

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
33	19,609	24	1.38	38.89	5ur69atw3vfhj		select decode(failover_method,...
13	8,828	227	0.06	17.51	83taa7kaw59c1		select name, intcol#, segcol#,...
5	5	1	4.70	0.01	0jaz0harg375c		INSERT INTO FMIS_STATUS (LOG_N...
5	5	1	4.69	0.01	52jg66k9sq6wh		INSERT INTO FMIS_STATUS (LOG_N...
4	4	1	4.31	0.01	6sjthdk7c46tg		SELECT COUNT(*), TRUNC(SUM(KSM...
4	4	7	0.57	0.01	dct34c6626znm		DECLARE job BINARY_INTEGER := ...
4	1,988	2	2.01	3.94	8vkjh60z1g287		select OBJOID, CLSOID, RUNT...
4	2,002	1	3.96	3.97	2ctzxkhd3zmpp	JDBC Thin Client	SELECT DISTINCT A.YHDM YHDM, ...
3	3	8	0.43	0.01	3map0rqcjzx4h		SELECT OWNER, OBJECT_NAME FROM...
3	1,753	2	1.66	3.48	c7sn076yz7030		select smontabv.cnt, smontab....
0	2,154	67	0.00	4.27	a1mbfp580hw3k		select u1.user#, u2.user#, u...

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: 680,096
Captured SQL account for 50.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
148,082	4	37,020.50	21.77	3.31	14.59	a8gqd7rwbm8yv	select f.tablespace_name as na...
140,624	7	20,089.14	20.68	4.02	4.02	dct34c6626znm	DECLARE job BINARY_INTEGER := ...
123,710	1	123,710.00	18.19	0.76	0.76	83mp1thdpyjc3	SELECT A.SYNONYM_NAME FROM DBA...
10,332	2,740	3.77	1.52	0.15	9.42	96g93hntrzjtr	select /+ rule / bucket_cnt,...
9,637	44	219.02	1.42	0.44	6.18	0070chz1yu5uf	DECLARE job BINARY_INTEGER := ...
7,674	8	959.25	1.13	3.46	3.46	3map0rqcjzx4h	SELECT OWNER, OBJECT_NAME FROM...
6,024	10	602.40	0.89	1.03	3.57	80yr9qa4w5gts	select df.tablespace_name as t...
4,428	1,476	3.00	0.65	0.32	1.46	db78fxqxwxt7r	select /+ rule / bucket, en...
4,166	2	2,083.00	0.61	4.02	1987.70	8vkjh60z1g287	select OBJOID, CLSOID, RUNT...
3,770	10	377.00	0.55	0.26	1.02	a28cyw6c6p2nm	select tablespace_name as name...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 6
Captured SQL account for 0.0% of Total

Executions	Reads per Exec	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
44	0.00	0.44	6.18	0070chz1yu5uf	DECLARE job BINARY_INTEGER := ...
396	0.00	0.08	3.10	04xtrk7uyhknh	select obj#, type#, ctime, mti...
0		0.02	0.02	06a7wq8prjng7	select DBID, NAME, CREATED,...
2	0.00	0.06	0.08	0a0pcbdzfybs2	DECLARE V_OBJ_NAME VARCHA...
43	0.00	0.03	0.03	0fr8zhn4ymu3v	select intcol#, type, flags, l...
60	0.00	0.01	0.01	0h6b2sajwb74n	select privilege#, level from ...
1	0.00	4.70	4.70	0jaz0harg375c	INSERT INTO FMIS_STATUS (LOG_N...
23	0.00	0.01	0.01	0k8522rmdzg4k	select privilege# from sysauth...
1	0.00	0.00	0.00	0v3dvmc22qnam	insert into sys.col_usage$ (ob...
21	0.00	0.16	0.17	130dvvr5s8bgn	select obj#, dataobj#, part#...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 13,672
Captured SQL account for 75.1% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
2,740	1,925	0.70	0.00	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...
1,476	23,461	15.89	0.00	0.00	db78fxqxwxt7r		select /+ rule / bucket, en...
717	949	1.32	0.00	0.01	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
630	630	1.00	0.00	0.00	2ym6hhaq30r73		select type#, blocks, extents,...
440	440	1.00	0.00	0.00	5ngzsfstg8tmy		select o.owner#, o.name, o.nam...
416	416	1.00	0.00	0.00	42ddyag628kjx		begin :con := VPD_PKG.FILTER_C...
396	392	0.99	0.00	0.01	04xtrk7uyhknh		select obj#, type#, ctime, mti...
232	551	2.38	0.00	0.03	6769wyy3yf66f		select pos#, intcol#, col#, sp...
227	2,743	12.08	0.06	38.89	83taa7kaw59c1		select name, intcol#, segcol#,...
209	101	0.48	0.00	0.01	asvzxj61dc5vs		select timestamp, flags from ...
189	228	1.21	0.00	0.04	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
185	185	1.00	0.00	0.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
180	179	0.99	0.00	0.00	3c1kubcdjnppq		update sys.col_usage$ set eq...
166	35	0.21	0.00	0.05	2q93zsrvbdw48		select grantee#, privilege#, n...
166	0	0.00	0.00	0.04	6aq34nj2zb2n7		select col#, grantee#, privi...
147	147	1.00	0.00	0.06	3my81td8y2rm3	JDBC Thin Client	BEGIN vPD_PKG.SET_CONTEXT_COMP...
143	712	4.98	0.00	0.02	a73wbv1yu8x5c		select con#, type#, condlength...
141	1	0.01	0.00	0.00	f8pavn1bvsj7t		select con#, obj#, rcon#, enab...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 7,505
Captured SQL account for 46.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
630	630	8.39	2ym6hhaq30r73		select type#, blocks, extents,...
416	416	5.54	42ddyag628kjx		begin :con := VPD_PKG.FILTER_C...
209	209	2.78	asvzxj61dc5vs		select timestamp, flags from ...
147	147	1.96	3my81td8y2rm3	JDBC Thin Client	BEGIN vPD_PKG.SET_CONTEXT_COMP...
120	120	1.60	8swypbbr0m372		select order#, columns, types ...
119	119	1.59	cqgv56fmuj63x		select owner#, name, namespace...
85	85	1.13	19g6x6d7nh669		select blocks, NVL(ts#, -1), s...
79	1	1.05	0v3dvmc22qnam		insert into sys.col_usage$ (ob...
79	180	1.05	3c1kubcdjnppq		update sys.col_usage$ set eq...
79	79	1.05	b2gnxm5z6r51n		lock table sys.col_usage$ in e...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
73	5	99wvrgpaqvtrk		INSERT INTO HZ_LOG (LOG_NO, US...
39	7	dct34c6626znm		DECLARE job BINARY_INTEGER := ...
32	56	15dyr87r4w2a1	JDBC Thin Client	SELECT * FROM QRTZ_CRON_TRIGGE...
32	55	b70fnskn0kam7	JDBC Thin Client	SELECT * FROM QRTZ_TRIGGERS WH...
24	60	0h6b2sajwb74n		select privilege#, level from ...
24	23	0k8522rmdzg4k		select privilege# from sysauth...

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.12	8.02	1.46	0.32	1,476	db78fxqxwxt7r		select /+ rule / bucket, en...
0.08	0.54	14.59	3.31	4	a8gqd7rwbm8yv		select f.tablespace_name as na...
0.03	0.00	2,001.80	3.96	1	2ctzxkhd3zmpp	JDBC Thin Client	SELECT DISTINCT A.YHDM YHDM, ...
0.02	0.61	4.02	4.02	7	dct34c6626znm		DECLARE job BINARY_INTEGER := ...
0.02	3.13	0.53	0.24	1	c2aw4fq306q4k		INSERT /+ APPEND / INTO WRH$...
0.01	0.63	1.77	0.06	120	8swypbbr0m372		select order#, columns, types ...
0.01	0.00	8,828.09	12.78	227	83taa7kaw59c1		select name, intcol#, segcol#,...
0.01	0.02	43.49	0.08	20	aq8yqxyyb40nn		update sys.job$ set this_date=...
0.01	0.74	1.02	0.26	10	a28cyw6c6p2nm		select tablespace_name as name...
0.01	0.10	7.12	0.13	189	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.01	0.22	3.10	0.08	396	04xtrk7uyhknh		select obj#, type#, ctime, mti...
0.01	12.50	0.05	0.05	630	2ym6hhaq30r73		select type#, blocks, extents,...
0.01	0.07	8.36	0.06	17	cjk1ffy5kmm5s		select obj# from oid$ where us...
0.01	6.43	0.09	0.05	55	b70fnskn0kam7	JDBC Thin Client	SELECT * FROM QRTZ_TRIGGERS WH...
0.01	8.95	0.06	0.06	180	3c1kubcdjnppq		update sys.col_usage$ set eq...
0.01	0.31	1.64	0.02	7	fhdxrqd4stwqk	JDBC Thin Client	SELECT * FROM QRTZ_LOCKS WHERE...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0070chz1yu5uf DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN RUN_JOB; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

04xtrk7uyhknh select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

06a7wq8prjng7 select DBID, NAME, CREATED, RESETLOGS_CHANGE#, RESETLOGS_TIME, PRIOR_RESETLOGS_CHANGE#, PRIOR_RESETLOGS_TIME, LOG_MODE, CHECKPOINT_CHANGE#, ARCHIVE_CHANGE#, CONTROLFILE_TYPE, CONTROLFILE_CREATED, CONTROLFILE_SEQUENCE#, CONTROLFILE_CHANGE#, CONTROLFILE_TIME, OPEN_RESETLOGS, VERSION_TIME, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, REMOTE_ARCHIVE, ACTIVATION#, SWITCHOVER#, DATABASE_ROLE, ARCHIVELOG_CHANGE#, ARCHIVELOG_COMPRESSION, SWITCHOVER_STATUS, DATAGUARD_BROKER, GUARD_STATUS, SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI, FORCE_LOGGING, PLATFORM_ID, PLATFORM_NAME, RECOVERY_TARGET_INCARNATION#, LAST_OPEN_INCARNATION#, CURRENT_SCN, FLASHBACK_ON, SUPPLEMENTAL_LOG_DATA_FK, SUPPLEMENTAL_LOG_DATA_ALL, DB_UNIQUE_NAME, STANDBY_BECAME_PRIMARY_SCN, FS_FAILOVER_STATUS, FS_FAILOVER_CURRENT_TARGET, FS_FAILOVER_THRESHOLD, FS_FAILOVER_OBSERVER_PRESENT, FS_FAILOVER_OBSERVER_HOST from GV$DATABASE where inst_id = USERENV('Instance')

0a0pcbdzfybs2 DECLARE V_OBJ_NAME VARCHAR2(32); --Ŀ�� V_OWNER VARCHAR2(32); --Ŀ��ӵ�� V_TYPE VARCHAR2(32); --Ŀ��(��, ��, ��, ��ͼ��) V_USER VARCHAR2(32); --��ݿ��û�� V_EVENTS VARCHAR2(32); --��¼��(CREATE, ALTER, DROP, TRUNCATE֮һ) V_IPADDRESS VARCHAR2(32); --��Ŀͻ��IP��ַ V_MACHINE VARCHAR2(64); --��Ŀͻ��˻�� V_PROGRAM VARCHAR2(64); --��Ŀͻ��˳�� V_SESSION_ID NUMBER(10); V_SQL_FULL VARCHAR2(32000); V_SQL_FULL1 VARCHAR2(5000); V_SQL_FULL2 VARCHAR2(5000); V_COUNT NUMBER(10); V_I NUMBER(10); V_EXIST NUMBER(10); V_SQL ORA_NAME_LIST_T; FUNCTION SUBSTR_CHINESE(I_STR IN VARCHAR2, I_POS IN OUT NUMBER) RETURN VARCHAR2 IS --Ϊ�˱��substrb��ֹظ��ֵ��substr��޷��洢��, �Զ��屾��, ��ȡ��i_pos��ַ�, �Ҳ��ְ��ֵ�� --��oracle�д洢SQL��ʹ��˶��¼��δ��ֵ��ж�, ��, ��ȡ��Կ��а��ֵ��, �ر��ڴ洢�� V_I1 NUMBER(10); V_RESULT VARCHAR2(32000); BEGIN V_I1:=I_POS; WHILE LENGTHB(SUBSTR(I_STR, 1, V_I1))>I_POS LOOP V_I1:=V_I1-1; END LOOP; V_RESULT:=SUBSTR(I_STR, 1, V_I1); I_POS:=V_I1; RETURN V_RESULT; END; BEGIN SELECT COUNT(*) INTO V_EXIST FROM DBA_TRIGGERS WHERE TRIGGER_NAME='TR_DDL_TRACE' AND OWNER='SYSTEM'; --�ж�ϵͳ�û��Ƿ��ͬ�Ĺ��̣��ҵ�ǰ�û��system�û��Ҫ��κ��飬��ֹ�ظ�� IF V_EXIST=0 OR SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')='SYSTEM' THEN V_OBJ_NAME:=NVL(TRIM(UPPER(ORA_DICT_OBJ_NAME)), 'OTHERS'); V_TYPE:=NVL(TRIM(UPPER( ORA_DICT_OBJ_TYPE)), 'OTHERS'); V_OWNER:=NVL(TRIM(UPPER(ORA_DICT_OBJ_OWNER)), 'OTHERS'); IF (V_TYPE NOT IN ('TABLE', 'SYNONYM') OR (SUBSTR(V_OBJ_NAME, 1, 4)<>'TMP_' AND SUBSTR(V_OBJ_NAME, 1, 5)<>'TEMP_' AND SUBSTR(V_OBJ_NAME, 1, 4)<>'BIN$')) AND V_OWNER NOT IN ('SYS', 'SYSTEM') THEN --��tmp��temp��ͷ��ʱ��bin$��ͷ�Ļ��վ�е��ݱ��, Ҳ��ϵͳ�û�sys��system�û��Ľṹ�䶯 V_USER:=TRIM(UPPER(ORA_LOGIN_USER)); V_EVENTS:=TRIM(UPPER(ORA_SYSEVENT)); SELECT SYS_CONTEXT('USERENV', 'IP_ADDRESS') INTO V_IPADDRESS FROM DUAL; SELECT USERENV('SESSIONID') INTO V_SESSION_ID FROM DUAL; SELECT MAX(MACHINE), MAX(PROGRAM) INTO V_MACHINE, V_PROGRAM FROM V$SESSION WHERE AUDSID=V_SESSION_ID; V_COUNT:=ORA_SQL_TXT(V_SQL); V_SQL_FULL:=''; V_I:=1; WHILE V_I<=V_COUNT AND NVL(LENGTHB(V_SQL_FULL), 0)<20000 LOOP V_SQL_FULL:=V_SQL_FULL||V_SQL(V_I); V_I:=V_I+1; END LOOP; V_I:=4000; V_SQL_FULL1:=SUBSTR_CHINESE(V_SQL_FULL, V_I); --ȡ��ǰ4000��ַ� V_SQL_FULL:=SUBSTR(V_SQL_FULL, V_I+1); V_I:=4000; V_SQL_FULL2:=SUBSTR_CHINESE(V_SQL_FULL, V_I); V_SQL_FULL:=SUBSTR(V_SQL_FULL, V_I+1); V_I:=4000; V_SQL_FULL:=SUBSTR_CHINESE(V_SQL_FULL, V_I); INSERT INTO T_OBJ_TRACE(TIMES, OWNER, OBJECT_NAME, OBJECT_TYPE, USER_NAME, EVENTS, IP_ADDRESS, MACHINE, PROGRAM, SQL_TEXT, SQL_TEXT1, SQL_TEXT2) VALUES (SYSDATE, V_OWNER, V_OBJ_NAME, V_TYPE, V_USER, V_EVENTS, V_IPADDRESS, V_MACHINE, V_PROGRAM, V_SQL_FULL1, V_SQL_FULL2, V_SQL_FULL); END IF; END IF; EXCEPTION WHEN OTHERS THEN NULL; --��ִ��, ��κδ��, ��Ӱ��ԭ��ִ�� END;

0fr8zhn4ymu3v select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc

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

0jaz0harg375c INSERT INTO FMIS_STATUS (LOG_NO, TIMES, NAME, SUB_NAME, STATUS, INST_INFO) SELECT HZ_SEQ.NEXTVAL, SYSDATE, '��ؿ��п�ֲ��', KSMCHCLS||'('||SIZE_MOD||')', '��'||LPAD(BLOCKS, 8)||';�ܴ�С(�ֽ�):'||LPAD(ALL_SIZE, 14)||';��(�ֽ�):'|| LPAD(MAX_SIZE, 10)||';��С��(�ֽ�):'||LPAD(MIN_SIZE, 10)||';��ƽ��С(�ֽ�):'||LPAD(AVG_SIZE, 12) AS STATUS, INST_INFO FROM (SELECT DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS) AS KSMCHCLS, KSMCHCOM, DECODE(TRUNC(KSMCHSIZ/1024), 0, '0:<1K', 1, '1:1K-2K', DECODE(TRUNC(KSMCHSIZ/2048), 1, '2:2K-4K', 2, '3:4K-6K', 3, '4:6K-8K', 4, '5:8K-10K', '6:>10K')) AS SIZE_MOD, TRIM(TO_CHAR(COUNT(*), '9, 999, 999, 999')) AS BLOCKS, TRIM(TO_CHAR(SUM(KSMCHSIZ), '9, 999, 999, 999')) AS ALL_SIZE, TRIM(TO_CHAR(MAX(KSMCHSIZ), '9, 999, 999, 999')) AS MAX_SIZE, TRIM(TO_CHAR(MIN(KSMCHSIZ), '9, 999, 999, 999')) AS MIN_SIZE, TRIM(TO_CHAR(ROUND(AVG(KSMCHSIZ), 2), '9, 999, 999, 999.99')) AS AVG_SIZE, 'CWGKVPD2_2' AS INST_INFO FROM V$KSMSP WHERE TRIM(UPPER(KSMCHCOM))='FREE MEMORY' GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS), KSMCHCOM, DECODE(TRUNC(KSMCHSIZ/1024), 0, '0:<1K', 1, '1:1K-2K', DECODE(TRUNC(KSMCHSIZ/2048), 1, '2:2K-4K', 2, '3:4K-6K', 3, '4:6K-8K', 4, '5:8K-10K', '6:>10K')) ORDER BY KSMCHCLS, SIZE_MOD)

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

0v3dvmc22qnam insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)

130dvvr5s8bgn select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#

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

19g6x6d7nh669 select blocks, NVL(ts#, -1), status$, NVL(relfile#, 0), maxextend, inc, crscnwrp, crscnbas, NVL(spare1, 0) from file$ where file#=:1

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

2ctzxkhd3zmpp SELECT DISTINCT A.YHDM YHDM, C.YHMC USERID, C.XSMC NAME, C.COMPID DH, D.MC MC, C.XTDXID XTDXID, E.DXMC DEPARTMENT FROM XTYWCSCONTROL A, (SELECT YHDM, YHMC, XSMC, XTDXID, STOPED, COMPID FROM XTYHXX WHERE 1 = 1 AND VPD_COMPID=:1) C, (SELECT DECODE(TRIM(DH), 'MAIN', :2, DH) DH, MC FROM XTDW) D, (SELECT A.DXMC AS DXMC, B.DXID AS XTDXID FROM VIEW_XTGLDX5001 A , VIEW_XTGLDX5113 B WHERE A.DXID = B.ZD5033 ORDER BY B.DXID) E WHERE TRIM(D.DH(+)) = TRIM(C.COMPID) AND E.XTDXID(+) = C.XTDXID AND C.YHDM = A.YHDM AND NVL(C.STOPED, 0)<>1 AND TO_CHAR(A.SJ, 'YYYY-MM-DD') = TO_CHAR(SYSDATE, 'YYYY-MM-DD')

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

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

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

3map0rqcjzx4h SELECT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE='TABLE' AND OWNER LIKE 'FMIS%' AND (SUBSTR(OBJECT_NAME, 1, 4)='TEMP' OR SUBSTR(OBJECT_NAME, 1, 3)='TMP' OR (SUBSTR(OBJECT_NAME, 1, 5)='BBHBG' AND LENGTH(OBJECT_NAME)>5) OR (SUBSTR(OBJECT_NAME, 1, 10)='ZWCX_PZTMP' AND LENGTH(OBJECT_NAME)>10) OR (SUBSTR(OBJECT_NAME, 1, 7)='PZCX_20' AND LENGTH(OBJECT_NAME)>7) OR (SUBSTR(OBJECT_NAME, 1, 9)='LJZTABLE_' AND LENGTH(OBJECT_NAME)>9)) AND (SYSDATE-LAST_DDL_TIME)*24>2 AND ROWNUM<5000

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

42ddyag628kjx begin :con := VPD_PKG.FILTER_COMPID(:sn, :on); end;

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

52jg66k9sq6wh INSERT INTO FMIS_STATUS (LOG_NO, TIMES, NAME, SUB_NAME, STATUS, INST_INFO) SELECT HZ_SEQ.NEXTVAL, SYSDATE, '��ϸ��', NAME, STATUS, INST_INFO FROM (SELECT DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS) AS NAME, '�ܿ��:'||LPAD(TRIM(TO_CHAR(COUNT(*), '99, 999, 999, 999')), 15)|| ', �ܴ�С:'||LPAD(TRIM(TO_CHAR(SUM(KSMCHSIZ), '99, 999, 999, 999')), 15)||'BYTES'|| ', ��С:'||LPAD(TRIM(TO_CHAR(MAX(KSMCHSIZ), '99, 999, 999, 999')), 15)||'BYTES'|| ', ��С��С:'||LPAD(TRIM(TO_CHAR(MIN(KSMCHSIZ), '999, 999, 999')), 12)||'BYTES'|| ', ƽ��С:'||LPAD(TRIM(TO_CHAR(TRUNC(AVG(KSMCHSIZ)), '999, 999, 999')), 12)||'BYTES' AS STATUS, 'CWGKVPD2_2' AS INST_INFO FROM V$KSMSP GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS))

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

5ngzsfstg8tmy select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

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

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6sjthdk7c46tg SELECT COUNT(*), TRUNC(SUM(KSMCHSIZ)/1024), TRUNC(AVG(KSMCHSIZ)) FROM V$KSMSP

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

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

83mp1thdpyjc3 SELECT A.SYNONYM_NAME FROM DBA_SYNONYMS A, USER_TABLES B WHERE A.OWNER='PUBLIC' AND (A.SYNONYM_NAME LIKE 'TEMP%' OR A.SYNONYM_NAME LIKE 'TMP%') AND A.TABLE_OWNER=SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') AND A.TABLE_NAME=B.TABLE_NAME(+) AND B.TABLE_NAME IS NULL

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

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

8vkjh60z1g287 select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID

91yym373k8wgt select csz from xtcs where csmc = 'COMPID_TOP'

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

99wvrgpaqvtrk INSERT INTO HZ_LOG (LOG_NO, USER_NAME, BEGIN_TIME, END_TIME, SQL_TEXT, SQL_TEXT1, SQL_TEXT2, ROW_COUNT, LOG_TYPE, LOG_LEVEL, LOG_DETAIL, IP_ADDRESS, TIMES) VALUES (HZ_SEQ.NEXTVAL, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA'), :B8 , SYSDATE, :B7 , :B6 , :B5 , :B4 , :B3 , 'INFO', TO_CHAR(:B2 ), SYS_CONTEXT('USERENV', 'IP_ADDRESS'), :B1 )

a1mbfp580hw3k select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name

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

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

a73wbv1yu8x5c select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1

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

aq8yqxyyb40nn update sys.job$ set this_date=:1 where job=:2

asvzxj61dc5vs select timestamp, flags from fixed_obj$ where obj#=:1

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

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

c2aw4fq306q4k INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)

c7sn076yz7030 select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map, smontab.orig_thread from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.scn = smontabv.scnmax and thread=0

cjk1ffy5kmm5s select obj# from oid$ where user#=:1 and oid$=:2

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

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

dct34c6626znm DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN RUN_STICK_JOB; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

f8pavn1bvsj7t select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1

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

SQL Id	SQL Text
0070chz1yu5uf	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN RUN_JOB; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
06a7wq8prjng7	select DBID, NAME, CREATED, RESETLOGS_CHANGE#, RESETLOGS_TIME, PRIOR_RESETLOGS_CHANGE#, PRIOR_RESETLOGS_TIME, LOG_MODE, CHECKPOINT_CHANGE#, ARCHIVE_CHANGE#, CONTROLFILE_TYPE, CONTROLFILE_CREATED, CONTROLFILE_SEQUENCE#, CONTROLFILE_CHANGE#, CONTROLFILE_TIME, OPEN_RESETLOGS, VERSION_TIME, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, REMOTE_ARCHIVE, ACTIVATION#, SWITCHOVER#, DATABASE_ROLE, ARCHIVELOG_CHANGE#, ARCHIVELOG_COMPRESSION, SWITCHOVER_STATUS, DATAGUARD_BROKER, GUARD_STATUS, SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI, FORCE_LOGGING, PLATFORM_ID, PLATFORM_NAME, RECOVERY_TARGET_INCARNATION#, LAST_OPEN_INCARNATION#, CURRENT_SCN, FLASHBACK_ON, SUPPLEMENTAL_LOG_DATA_FK, SUPPLEMENTAL_LOG_DATA_ALL, DB_UNIQUE_NAME, STANDBY_BECAME_PRIMARY_SCN, FS_FAILOVER_STATUS, FS_FAILOVER_CURRENT_TARGET, FS_FAILOVER_THRESHOLD, FS_FAILOVER_OBSERVER_PRESENT, FS_FAILOVER_OBSERVER_HOST from GV$DATABASE where inst_id = USERENV('Instance')
0a0pcbdzfybs2	DECLARE V_OBJ_NAME VARCHAR2(32); --Ŀ�� V_OWNER VARCHAR2(32); --Ŀ��ӵ�� V_TYPE VARCHAR2(32); --Ŀ��(��, ��, ��, ��ͼ��) V_USER VARCHAR2(32); --��ݿ��û�� V_EVENTS VARCHAR2(32); --��¼��(CREATE, ALTER, DROP, TRUNCATE֮һ) V_IPADDRESS VARCHAR2(32); --��Ŀͻ��IP��ַ V_MACHINE VARCHAR2(64); --��Ŀͻ��˻�� V_PROGRAM VARCHAR2(64); --��Ŀͻ��˳�� V_SESSION_ID NUMBER(10); V_SQL_FULL VARCHAR2(32000); V_SQL_FULL1 VARCHAR2(5000); V_SQL_FULL2 VARCHAR2(5000); V_COUNT NUMBER(10); V_I NUMBER(10); V_EXIST NUMBER(10); V_SQL ORA_NAME_LIST_T; FUNCTION SUBSTR_CHINESE(I_STR IN VARCHAR2, I_POS IN OUT NUMBER) RETURN VARCHAR2 IS --Ϊ�˱��substrb��ֹظ��ֵ��substr��޷��洢��, �Զ��屾��, ��ȡ��i_pos��ַ�, �Ҳ��ְ��ֵ�� --��oracle�д洢SQL��ʹ��˶��¼��δ��ֵ��ж�, ��, ��ȡ��Կ��а��ֵ��, �ر��ڴ洢�� V_I1 NUMBER(10); V_RESULT VARCHAR2(32000); BEGIN V_I1:=I_POS; WHILE LENGTHB(SUBSTR(I_STR, 1, V_I1))>I_POS LOOP V_I1:=V_I1-1; END LOOP; V_RESULT:=SUBSTR(I_STR, 1, V_I1); I_POS:=V_I1; RETURN V_RESULT; END; BEGIN SELECT COUNT(*) INTO V_EXIST FROM DBA_TRIGGERS WHERE TRIGGER_NAME='TR_DDL_TRACE' AND OWNER='SYSTEM'; --�ж�ϵͳ�û��Ƿ��ͬ�Ĺ��̣��ҵ�ǰ�û��system�û��Ҫ��κ��飬��ֹ�ظ�� IF V_EXIST=0 OR SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')='SYSTEM' THEN V_OBJ_NAME:=NVL(TRIM(UPPER(ORA_DICT_OBJ_NAME)), 'OTHERS'); V_TYPE:=NVL(TRIM(UPPER( ORA_DICT_OBJ_TYPE)), 'OTHERS'); V_OWNER:=NVL(TRIM(UPPER(ORA_DICT_OBJ_OWNER)), 'OTHERS'); IF (V_TYPE NOT IN ('TABLE', 'SYNONYM') OR (SUBSTR(V_OBJ_NAME, 1, 4)<>'TMP_' AND SUBSTR(V_OBJ_NAME, 1, 5)<>'TEMP_' AND SUBSTR(V_OBJ_NAME, 1, 4)<>'BIN$')) AND V_OWNER NOT IN ('SYS', 'SYSTEM') THEN --��tmp��temp��ͷ��ʱ��bin$��ͷ�Ļ��վ�е��ݱ��, Ҳ��ϵͳ�û�sys��system�û��Ľṹ�䶯 V_USER:=TRIM(UPPER(ORA_LOGIN_USER)); V_EVENTS:=TRIM(UPPER(ORA_SYSEVENT)); SELECT SYS_CONTEXT('USERENV', 'IP_ADDRESS') INTO V_IPADDRESS FROM DUAL; SELECT USERENV('SESSIONID') INTO V_SESSION_ID FROM DUAL; SELECT MAX(MACHINE), MAX(PROGRAM) INTO V_MACHINE, V_PROGRAM FROM V$SESSION WHERE AUDSID=V_SESSION_ID; V_COUNT:=ORA_SQL_TXT(V_SQL); V_SQL_FULL:=''; V_I:=1; WHILE V_I<=V_COUNT AND NVL(LENGTHB(V_SQL_FULL), 0)<20000 LOOP V_SQL_FULL:=V_SQL_FULL\|\|V_SQL(V_I); V_I:=V_I+1; END LOOP; V_I:=4000; V_SQL_FULL1:=SUBSTR_CHINESE(V_SQL_FULL, V_I); --ȡ��ǰ4000��ַ� V_SQL_FULL:=SUBSTR(V_SQL_FULL, V_I+1); V_I:=4000; V_SQL_FULL2:=SUBSTR_CHINESE(V_SQL_FULL, V_I); V_SQL_FULL:=SUBSTR(V_SQL_FULL, V_I+1); V_I:=4000; V_SQL_FULL:=SUBSTR_CHINESE(V_SQL_FULL, V_I); INSERT INTO T_OBJ_TRACE(TIMES, OWNER, OBJECT_NAME, OBJECT_TYPE, USER_NAME, EVENTS, IP_ADDRESS, MACHINE, PROGRAM, SQL_TEXT, SQL_TEXT1, SQL_TEXT2) VALUES (SYSDATE, V_OWNER, V_OBJ_NAME, V_TYPE, V_USER, V_EVENTS, V_IPADDRESS, V_MACHINE, V_PROGRAM, V_SQL_FULL1, V_SQL_FULL2, V_SQL_FULL); END IF; END IF; EXCEPTION WHEN OTHERS THEN NULL; --��ִ��, ��κδ��, ��Ӱ��ԭ��ִ�� END;
0fr8zhn4ymu3v	select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0jaz0harg375c	INSERT INTO FMIS_STATUS (LOG_NO, TIMES, NAME, SUB_NAME, STATUS, INST_INFO) SELECT HZ_SEQ.NEXTVAL, SYSDATE, '��ؿ��п�ֲ��', KSMCHCLS\|\|'('\|\|SIZE_MOD\|\|')', '��'\|\|LPAD(BLOCKS, 8)\|\|';�ܴ�С(�ֽ�):'\|\|LPAD(ALL_SIZE, 14)\|\|';��(�ֽ�):'\|\| LPAD(MAX_SIZE, 10)\|\|';��С��(�ֽ�):'\|\|LPAD(MIN_SIZE, 10)\|\|';��ƽ��С(�ֽ�):'\|\|LPAD(AVG_SIZE, 12) AS STATUS, INST_INFO FROM (SELECT DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS) AS KSMCHCLS, KSMCHCOM, DECODE(TRUNC(KSMCHSIZ/1024), 0, '0:<1K', 1, '1:1K-2K', DECODE(TRUNC(KSMCHSIZ/2048), 1, '2:2K-4K', 2, '3:4K-6K', 3, '4:6K-8K', 4, '5:8K-10K', '6:>10K')) AS SIZE_MOD, TRIM(TO_CHAR(COUNT(*), '9, 999, 999, 999')) AS BLOCKS, TRIM(TO_CHAR(SUM(KSMCHSIZ), '9, 999, 999, 999')) AS ALL_SIZE, TRIM(TO_CHAR(MAX(KSMCHSIZ), '9, 999, 999, 999')) AS MAX_SIZE, TRIM(TO_CHAR(MIN(KSMCHSIZ), '9, 999, 999, 999')) AS MIN_SIZE, TRIM(TO_CHAR(ROUND(AVG(KSMCHSIZ), 2), '9, 999, 999, 999.99')) AS AVG_SIZE, 'CWGKVPD2_2' AS INST_INFO FROM V$KSMSP WHERE TRIM(UPPER(KSMCHCOM))='FREE MEMORY' GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS), KSMCHCOM, DECODE(TRUNC(KSMCHSIZ/1024), 0, '0:<1K', 1, '1:1K-2K', DECODE(TRUNC(KSMCHSIZ/2048), 1, '2:2K-4K', 2, '3:4K-6K', 3, '4:6K-8K', 4, '5:8K-10K', '6:>10K')) ORDER BY KSMCHCLS, SIZE_MOD)
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
130dvvr5s8bgn	select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#
15dyr87r4w2a1	SELECT * FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
19g6x6d7nh669	select blocks, NVL(ts#, -1), status$, NVL(relfile#, 0), maxextend, inc, crscnwrp, crscnbas, NVL(spare1, 0) from file$ where file#=:1
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
2ctzxkhd3zmpp	SELECT DISTINCT A.YHDM YHDM, C.YHMC USERID, C.XSMC NAME, C.COMPID DH, D.MC MC, C.XTDXID XTDXID, E.DXMC DEPARTMENT FROM XTYWCSCONTROL A, (SELECT YHDM, YHMC, XSMC, XTDXID, STOPED, COMPID FROM XTYHXX WHERE 1 = 1 AND VPD_COMPID=:1) C, (SELECT DECODE(TRIM(DH), 'MAIN', :2, DH) DH, MC FROM XTDW) D, (SELECT A.DXMC AS DXMC, B.DXID AS XTDXID FROM VIEW_XTGLDX5001 A , VIEW_XTGLDX5113 B WHERE A.DXID = B.ZD5033 ORDER BY B.DXID) E WHERE TRIM(D.DH(+)) = TRIM(C.COMPID) AND E.XTDXID(+) = C.XTDXID AND C.YHDM = A.YHDM AND NVL(C.STOPED, 0)<>1 AND TO_CHAR(A.SJ, 'YYYY-MM-DD') = TO_CHAR(SYSDATE, 'YYYY-MM-DD')
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
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
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
3map0rqcjzx4h	SELECT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE='TABLE' AND OWNER LIKE 'FMIS%' AND (SUBSTR(OBJECT_NAME, 1, 4)='TEMP' OR SUBSTR(OBJECT_NAME, 1, 3)='TMP' OR (SUBSTR(OBJECT_NAME, 1, 5)='BBHBG' AND LENGTH(OBJECT_NAME)>5) OR (SUBSTR(OBJECT_NAME, 1, 10)='ZWCX_PZTMP' AND LENGTH(OBJECT_NAME)>10) OR (SUBSTR(OBJECT_NAME, 1, 7)='PZCX_20' AND LENGTH(OBJECT_NAME)>7) OR (SUBSTR(OBJECT_NAME, 1, 9)='LJZTABLE_' AND LENGTH(OBJECT_NAME)>9)) AND (SYSDATE-LAST_DDL_TIME)*24>2 AND ROWNUM<5000
3my81td8y2rm3	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0300'); END;
42ddyag628kjx	begin :con := VPD_PKG.FILTER_COMPID(:sn, :on); end;
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
52jg66k9sq6wh	INSERT INTO FMIS_STATUS (LOG_NO, TIMES, NAME, SUB_NAME, STATUS, INST_INFO) SELECT HZ_SEQ.NEXTVAL, SYSDATE, '��ϸ��', NAME, STATUS, INST_INFO FROM (SELECT DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS) AS NAME, '�ܿ��:'\|\|LPAD(TRIM(TO_CHAR(COUNT(*), '99, 999, 999, 999')), 15)\|\| ', �ܴ�С:'\|\|LPAD(TRIM(TO_CHAR(SUM(KSMCHSIZ), '99, 999, 999, 999')), 15)\|\|'BYTES'\|\| ', ��С:'\|\|LPAD(TRIM(TO_CHAR(MAX(KSMCHSIZ), '99, 999, 999, 999')), 15)\|\|'BYTES'\|\| ', ��С��С:'\|\|LPAD(TRIM(TO_CHAR(MIN(KSMCHSIZ), '999, 999, 999')), 12)\|\|'BYTES'\|\| ', ƽ��С:'\|\|LPAD(TRIM(TO_CHAR(TRUNC(AVG(KSMCHSIZ)), '999, 999, 999')), 12)\|\|'BYTES' AS STATUS, 'CWGKVPD2_2' AS INST_INFO FROM V$KSMSP GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS))
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5ngzsfstg8tmy	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6sjthdk7c46tg	SELECT COUNT(*), TRUNC(SUM(KSMCHSIZ)/1024), TRUNC(AVG(KSMCHSIZ)) FROM V$KSMSP
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
80yr9qa4w5gts	select df.tablespace_name as tn, df.file_name as fn, f.phyrds as pyr, f.phyblkrd as pbr, f.phywrts as pyw, f.phyblkwrt as pbw from sys.v_$filestat f, sys.dba_data_files df where f.file# = df.file_id order by df.tablespace_name
83mp1thdpyjc3	SELECT A.SYNONYM_NAME FROM DBA_SYNONYMS A, USER_TABLES B WHERE A.OWNER='PUBLIC' AND (A.SYNONYM_NAME LIKE 'TEMP%' OR A.SYNONYM_NAME LIKE 'TMP%') AND A.TABLE_OWNER=SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') AND A.TABLE_NAME=B.TABLE_NAME(+) AND B.TABLE_NAME IS NULL
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
8vkjh60z1g287	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
91yym373k8wgt	select csz from xtcs where csmc = 'COMPID_TOP'
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
99wvrgpaqvtrk	INSERT INTO HZ_LOG (LOG_NO, USER_NAME, BEGIN_TIME, END_TIME, SQL_TEXT, SQL_TEXT1, SQL_TEXT2, ROW_COUNT, LOG_TYPE, LOG_LEVEL, LOG_DETAIL, IP_ADDRESS, TIMES) VALUES (HZ_SEQ.NEXTVAL, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA'), :B8 , SYSDATE, :B7 , :B6 , :B5 , :B4 , :B3 , 'INFO', TO_CHAR(:B2 ), SYS_CONTEXT('USERENV', 'IP_ADDRESS'), :B1 )
a1mbfp580hw3k	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
a1xgxtssv5rrp	select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
a28cyw6c6p2nm	select tablespace_name as name, to_char(sum(bytes)) as bytes from sys.dba_data_files group by tablespace_name order by name
a73wbv1yu8x5c	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
a8gqd7rwbm8yv	select f.tablespace_name as name, sum(f.bytes) as used from SYS.Dba_Segments f group by f.tablespace_name
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
b70fnskn0kam7	SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
c2aw4fq306q4k	INSERT /+ APPEND / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
c7sn076yz7030	select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map, smontab.orig_thread from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.scn = smontabv.scnmax and thread=0
cjk1ffy5kmm5s	select obj# from oid$ where user#=:1 and oid$=:2
cqgv56fmuj63x	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dct34c6626znm	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN RUN_STICK_JOB; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
f8pavn1bvsj7t	select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
fhdxrqd4stwqk	SELECT * FROM QRTZ_LOCKS WHERE LOCK_NAME = :1 FOR UPDATE

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	239,524	66.89	61.40
CPU used when call started	5,604	1.57	1.44
CR blocks created	47	0.01	0.01
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	4,946,072	1,381.31	1,267.90
DBWR checkpoint buffers written	446	0.12	0.11
DBWR checkpoints	1	0.00	0.00
DBWR fusion writes	123	0.03	0.03
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	43	0.01	0.01
DBWR undo block writes	88	0.02	0.02
DFO trees parallelized	27	0.01	0.01
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	120	0.03	0.03
PX local messages sent	120	0.03	0.03
PX remote messages recv'd	84	0.02	0.02
PX remote messages sent	105	0.03	0.03
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	27	0.01	0.01
RowCR - row contention	0	0.00	0.00
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	6,397	1.79	1.64
active txn count during cleanout	44	0.01	0.01
application wait time	21	0.01	0.01
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	11,962	3.34	3.07
branch node splits	0	0.00	0.00
buffer is not pinned count	115,999	32.40	29.74
buffer is pinned count	1,088,164	303.90	278.94
bytes received via SQL*Net from client	545,324	152.29	139.79
bytes sent via SQL*Net to client	366,964	102.48	94.07
calls to get snapshot scn: kcmgss	19,700	5.50	5.05
calls to kcmgas	4,240	1.18	1.09
calls to kcmgcs	31	0.01	0.01
change write time	15	0.00	0.00
cleanout - number of ktugct calls	50	0.01	0.01
cleanouts and rollbacks - consistent read gets	5	0.00	0.00
cleanouts only - consistent read gets	4	0.00	0.00
cluster key scan block gets	46,442	12.97	11.91
cluster key scans	29,714	8.30	7.62
cluster wait time	126	0.04	0.03
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	1	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	1	0.00	0.00
commit cleanout failures: cannot pin	1	0.00	0.00
commit cleanouts	1,158	0.32	0.30
commit cleanouts successfully completed	1,155	0.32	0.30
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	45	0.01	0.01
concurrency wait time	3,959,978	1,105.92	1,015.12
consistent changes	65	0.02	0.02
consistent gets	671,350	187.49	172.10
consistent gets - examination	138,476	38.67	35.50
consistent gets direct	0	0.00	0.00
consistent gets from cache	671,365	187.49	172.10
current blocks converted for CR	0	0.00	0.00
cursor authentications	318	0.09	0.08
data blocks consistent reads - undo records applied	63	0.02	0.02
db block changes	6,876	1.92	1.76
db block gets	8,746	2.44	2.24
db block gets direct	58	0.02	0.01
db block gets from cache	8,688	2.43	2.23
deferred (CURRENT) block cleanout applications	523	0.15	0.13
dirty buffers inspected	0	0.00	0.00
enqueue conversions	415	0.12	0.11
enqueue releases	25,856	7.22	6.63
enqueue requests	25,857	7.22	6.63
enqueue timeouts	5	0.00	0.00
enqueue waits	445	0.12	0.11
exchange deadlocks	0	0.00	0.00
execute count	13,672	3.82	3.50
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	1,509	0.42	0.39
gc CPU used by this session	1,475	0.41	0.38
gc cr block build time	2	0.00	0.00
gc cr block flush time	0	0.00	0.00
gc cr block receive time	33	0.01	0.01
gc cr block send time	10	0.00	0.00
gc cr blocks received	845	0.24	0.22
gc cr blocks served	2,244	0.63	0.58
gc current block flush time	0	0.00	0.00
gc current block pin time	24	0.01	0.01
gc current block receive time	29	0.01	0.01
gc current block send time	5	0.00	0.00
gc current blocks received	384	0.11	0.10
gc current blocks served	887	0.25	0.23
gc local grants	83	0.02	0.02
gc remote grants	143	0.04	0.04
gcs messages sent	7,292	2.04	1.87
ges messages sent	285,891	79.84	73.29
global enqueue get time	264	0.07	0.07
global enqueue gets async	4,051	1.13	1.04
global enqueue gets sync	7,328	2.05	1.88
global enqueue releases	530,664	148.20	136.03
heap block compress	18	0.01	0.00
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	9	0.00	0.00
immediate (CURRENT) block cleanout applications	194	0.05	0.05
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	918	0.26	0.24
index fast full scans (full)	0	0.00	0.00
index fetch by key	588,204	164.27	150.78
index scans kdiixs1	6,141	1.72	1.57
leaf node 90-10 splits	17	0.00	0.00
leaf node splits	19	0.01	0.00
lob reads	269	0.08	0.07
lob writes	66	0.02	0.02
lob writes unaligned	66	0.02	0.02
logons cumulative	148	0.04	0.04
messages received	5,327	1.49	1.37
messages sent	5,327	1.49	1.37
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	525,116	146.65	134.61
opened cursors cumulative	12,293	3.43	3.15
parse count (failures)	2	0.00	0.00
parse count (hard)	854	0.24	0.22
parse count (total)	7,505	2.10	1.92
parse time cpu	5,944	1.66	1.52
parse time elapsed	3,226,331	901.03	827.05
physical read IO requests	6	0.00	0.00
physical read bytes	98,304	27.45	25.20
physical read total IO requests	30,393	8.49	7.79
physical read total bytes	497,958,912	139,066.58	127,649.04
physical read total multi block requests	0	0.00	0.00
physical reads	6	0.00	0.00
physical reads cache	6	0.00	0.00
physical reads cache prefetch	0	0.00	0.00
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	490	0.14	0.13
physical write bytes	10,305,536	2,878.06	2,641.77
physical write total IO requests	6,323	1.77	1.62
physical write total bytes	75,297,792	21,028.66	19,302.18
physical write total multi block requests	1,141	0.32	0.29
physical writes	629	0.18	0.16
physical writes direct	58	0.02	0.01
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	571	0.16	0.15
physical writes non checkpoint	318	0.09	0.08
pinned buffers inspected	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	1,509	0.42	0.39
queries parallelized	27	0.01	0.01
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	151,034	42.18	38.72
recursive cpu usage	242,704	67.78	62.22
redo blocks written	6,013	1.68	1.54
redo buffer allocation retries	0	0.00	0.00
redo entries	4,959	1.38	1.27
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	83	0.02	0.02
redo size	2,583,760	721.57	662.33
redo subscn max counts	146	0.04	0.04
redo synch time	45	0.01	0.01
redo synch writes	189	0.05	0.05
redo wastage	353,616	98.76	90.65
redo write time	103	0.03	0.03
redo writer latching time	0	0.00	0.00
redo writes	1,121	0.31	0.29
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	40	0.01	0.01
rows fetched via callback	7,177	2.00	1.84
session connect time	2,836	0.79	0.73
session cursor cache hits	8,900	2.49	2.28
session logical reads	680,096	189.93	174.34
session pga memory max	6,881,940,112	1,921,941.49	1,764,147.68
session uga memory	###############	81,532,717.66	74,838,779.13
session uga memory max	249,196,408	69,593.88	63,880.14
shared hash latch upgrades - no wait	1,032	0.29	0.26
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	5,205	1.45	1.33
sorts (rows)	959,780	268.04	246.03
sql area evicted	23,621	6.60	6.06
sql area purged	1	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	44	0.01	0.01
table fetch by rowid	34,937	9.76	8.96
table fetch continued row	112	0.03	0.03
table scan blocks gotten	439,324	122.69	112.62
table scan rows gotten	13,864,172	3,871.89	3,554.00
table scans (long tables)	0	0.00	0.00
table scans (short tables)	1,422	0.40	0.36
total number of times SMON posted	1	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	0	0.00	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	899,016	251.07	230.46
user I/O wait time	7	0.00	0.00
user calls	7,546	2.11	1.93
user commits	291	0.08	0.07
user rollbacks	3,610	1.01	0.93
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	3,352	0.94	0.86
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	4,314,820	4,312,619
opened cursors current	129	70
logons current	36	34

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)
SYSAUX	4	5.00	1.00	322	0	0.00
UNDOTBS2	0	0.00	0.00	89	0	0.00
SYSTEM	1	10.00	1.00	58	6	1.67
FMIS0300	1	10.00	1.00	15	6	1.67
FMISINDEX	0	0.00	0.00	3	5	0.00
FMIS_LARGE	0	0.00	0.00	3	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)
FMIS0300	/dev/rlv_free_55	1	10.00	1.00	3	2	0.00
FMIS0300	/dev/rlv_vpd0300_01	0			6	4	2.50
FMIS0300	/dev/rlv_vpd0300_02	0			1	0	0.00
FMIS0300	/dev/rlv_vpd0300_03	0			4	0	0.00
FMIS0300	/dev/rlv_vpd0300_04	0			1	0	0.00
FMISINDEX	/dev/rlv_vpdindex2	0			3	5	0.00
FMIS_LARGE	/dev/rlv_vpd_large2	0			3	0	0.00
SYSAUX	/dev/rlv_vpdsysaux01	4	5.00	1.00	322	0	0.00
SYSTEM	/dev/rlv_vpdsystem01	0			12	3	3.33
SYSTEM	/dev/rlv_vpdsystem02	1	10.00	1.00	46	3	0.00
UNDOTBS2	/dev/rlv_vpdundo2_1	0			23	0	0.00
UNDOTBS2	/dev/rlv_vpdundo2_2	0			4	0	0.00
UNDOTBS2	/dev/rlv_vpdundo2_3	0			62	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Buffer Busy Waits
D	443,520	100	677,663	6	571	82
K	15,840		0	0	0	0
R	15,840	100	5	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	234	806	4520	1843200	4520
E	0	0	238	2288	3240	1843200	3240

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	704	0.10	43,560	1.18	122,810,122
D	1,408	0.20	87,120	1.10	113,966,088
D	2,112	0.29	130,680	1.06	110,354,857
D	2,816	0.39	174,240	1.04	108,210,066
D	3,520	0.49	217,800	1.03	106,535,771
D	4,224	0.59	261,360	1.02	105,621,146
D	4,928	0.69	304,920	1.01	104,725,646
D	5,632	0.79	348,480	1.01	104,401,656
D	6,336	0.88	392,040	1.00	103,921,552
D	7,040	0.98	435,600	1.00	103,821,577
D	7,168	1.00	443,520	1.00	103,812,376
D	7,744	1.08	479,160	1.00	103,644,516
D	8,448	1.18	522,720	1.00	103,496,699
D	9,152	1.28	566,280	1.00	103,340,103
D	9,856	1.38	609,840	0.99	103,231,167
D	10,560	1.47	653,400	0.99	103,181,172
D	11,264	1.57	696,960	0.99	103,122,428
D	11,968	1.67	740,520	0.99	103,073,065
D	12,672	1.77	784,080	0.99	102,831,764
D	13,376	1.87	827,640	0.99	102,771,483
D	14,080	1.96	871,200	0.99	102,387,123

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	2,000	1,551	523.39	0.00	0.00	0.00	0.00	204,800
E	2,000	1,647	410.96	0.00	0.00	0.00	0.00	204,800

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	3,217	3,217
64K	128K	29	29
512K	1024K	40	40
1M	2M	3	3
2M	4M	12	12
4M	8M	26	26

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
250	0.13	849,015.70	292,005.88	74.00	490
500	0.25	849,015.70	100,951.24	89.00	0
1,000	0.50	849,015.70	100,951.24	89.00	0
1,500	0.75	849,015.70	100,951.24	89.00	0
2,000	1.00	849,015.70	100,951.24	89.00	0
2,400	1.20	849,015.70	89,869.78	90.00	0
2,800	1.40	849,015.70	89,869.78	90.00	0
3,200	1.60	849,015.70	89,869.78	90.00	0
3,600	1.80	849,015.70	89,869.78	90.00	0
4,000	2.00	849,015.70	89,869.78	90.00	0
6,000	3.00	849,015.70	89,869.78	90.00	0
8,000	4.00	849,015.70	89,869.78	90.00	0
12,000	6.00	849,015.70	89,869.78	90.00	0
16,000	8.00	849,015.70	89,869.78	90.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,184	0.29	13	2,394	175,647,081	1.00	616,155	3.27	202,795,061
1,600	0.39	13	2,394	176,012,408	1.00	250,828	1.33	202,848,178
2,016	0.49	13	2,405	176,041,078	1.00	222,158	1.18	202,855,345
2,432	0.59	13	2,429	176,057,938	1.00	205,298	1.09	202,859,497
2,848	0.70	13	2,429	176,062,686	1.00	200,550	1.07	202,861,445
3,264	0.80	13	2,429	176,062,700	1.00	200,536	1.07	202,862,714
3,680	0.90	13	2,434	176,067,843	1.00	195,393	1.04	202,863,594
4,096	1.00	13	2,434	176,075,052	1.00	188,184	1.00	202,864,031
4,512	1.10	13	2,440	176,075,056	1.00	188,180	1.00	202,864,112
4,928	1.20	13	2,440	176,075,056	1.00	188,180	1.00	202,864,136
5,344	1.30	13	2,440	176,075,056	1.00	188,180	1.00	202,864,136
5,760	1.41	13	2,440	176,075,056	1.00	188,180	1.00	202,864,136
6,176	1.51	13	2,440	176,075,056	1.00	188,180	1.00	202,864,136
6,592	1.61	13	2,440	176,075,056	1.00	188,180	1.00	202,864,136
7,008	1.71	13	2,440	176,075,056	1.00	188,180	1.00	202,864,136
7,424	1.81	13	2,440	176,075,056	1.00	188,180	1.00	202,864,136
7,840	1.91	13	2,440	176,075,056	1.00	188,180	1.00	202,864,136
8,256	2.02	13	2,440	176,075,056	1.00	188,180	1.00	202,864,136

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	33	1
undo header	38	0
file header block	11	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	Av Wt Time(ms)
TM-DML	878	878	0	133	1.72
CF-Controlfile Transaction	8,504	8,504	0	134	0.79
PS-PX Process Reservation	186	186	0	55	0.60
TT-Tablespace	108	108	0	51	0.61
JQ-Job Queue	71	67	4	42	0.67
WF-AWR Flush	22	22	0	12	0.67
TD-KTF map table enqueue (KTF dump entries)	4	4	0	4	0.75
RO-Multiple Object Reuse (fast object reuse)	9	9	0	3	0.33
DR-Distributed Recovery	2	2	0	2	0.50
IR-Instance Recovery	3	3	0	2	0.50
MW-MWIN Schedule	2	2	0	2	0.50
CU-Cursor	1,120	1,120	0	1	0.00
PI-Remote PX Process Spawn Status	1	1	0	1	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
4	0.11	931	0	4	5760/5760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
08-Mar 04:08	70	304	3	5,760	0/0	0/0/0/0/0/0
08-Mar 03:58	11	200	4	5,760	0/0	0/0/0/0/0/0
08-Mar 03:48	0	0	0	5,760	0/0	0/0/0/0/0/0
08-Mar 03:38	0	0	0	5,760	0/0	0/0/0/0/0/0
08-Mar 03:28	0	0	0	5,760	0/0	0/0/0/0/0/0
08-Mar 03:18	4	85	2	5,760	0/0	0/0/0/0/0/0
08-Mar 03:08	27	342	4	5,760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,416	0.00		0	0
ASM network background latch	1	0.00		0	0
AWR Alerted Metric Element list	18,036	0.00		0	0
Consistent RBA	1,120	0.00		0	0
FAL request queue	72	0.00		0	0
FAL subheap alocation	72	0.00		0	0
FOB s.o list latch	418	0.24	0.00	0	0
JS broadcast add buf latch	349	0.00		0	0
JS broadcast drop buf latch	349	0.00		0	0
JS broadcast load blnc latch	305	0.00		0	0
JS mem alloc latch	8	0.00		0	0
JS queue access latch	8	0.00		0	0
JS queue state obj latch	12,810	0.00		0	0
JS slv state obj latch	38	0.00		0	0
KCL gc element parent latch	9,538	0.01	0.00	0	26	0.00
KJC message pool free list	33,785	0.18	0.00	0	1,370	0.58
KJCT flow control latch	76,158	0.26	0.00	0	0
KMG MMAN ready and startup request latch	1,194	0.00		0	0
KTF sga latch	8	0.00		0	1,125	0.00
KWQMN job cache list latch	306	0.00		0	0
KWQP Prop Status	2	0.00		0	0
MQL Tracking Latch	0			0	71	0.00
Memory Management Latch	0			0	1,194	0.00
OS process	243	0.00		0	0
OS process allocation	1,354	0.00		0	0
OS process: request allocation	100	0.00		0	0
PL/SQL warning settings	1,373	0.00		0	0
SQL memory manager latch	1	0.00		0	1,193	0.00
SQL memory manager workarea list latch	81,146	0.00		0	0
Shared B-Tree	130	0.00		0	0
active checkpoint queue latch	2,983	0.03	0.00	0	0
active service list	4,810	0.00		0	1,209	0.00
archive control	82	0.00		0	0
archive process latch	1,337	0.00		0	0
begin backup scn array	11	0.00		0	0
business card	54	0.00		0	0
cache buffer handles	55	0.00		0	0
cache buffers chains	1,238,156	0.13	0.01	0	1,950	0.00
cache buffers lru chain	2,220	0.00		0	4,258	0.02
channel handle pool latch	102	0.00		0	0
channel operations parent latch	169,279	0.00	0.00	0	0
checkpoint queue latch	262,143	0.00		0	793	0.00
client/application info	610	0.00		0	0
commit callback allocation	16	0.00		0	0
compile environment latch	149	0.00		0	0
dml lock allocation	1,818	0.00		0	0
dummy allocation	300	0.00		0	0
enqueue hash chains	55,617	0.00		0	17	0.00
enqueues	52,802	0.01	0.00	0	0
error message lists	129	0.00		0	0
event group latch	49	0.00		0	0
file cache latch	731	0.82	0.00	0	0
gcs opaque info freelist	1,496	0.00		0	0
gcs partitioned table hash	16,321	0.00		0	0
gcs remaster request queue	3	0.00		0	0
gcs remastering latch	287	0.00		0	0
gcs resource freelist	104	0.00		0	391	0.00
gcs resource hash	9,027	0.02	0.00	0	0
gcs shadows freelist	335	0.00		0	864	0.00
ges caches resource lists	893,627	0.05	0.00	0	889,566	0.04
ges deadlock list	2,512	0.00		0	0
ges domain table	13,771	0.00		0	0
ges enqueue table freelist	18,619	0.00		0	0
ges group table	19,479	0.01	0.00	0	0
ges process hash list	3,781	0.00		0	0
ges process parent latch	566,586	0.01	0.03	0	377,716	0.01
ges process table freelist	100	0.00		0	0
ges resource hash list	571,464	0.02	0.16	0	889,291	0.00
ges resource scan list	24	0.00		0	0
ges resource table freelist	513,637	0.00	0.00	0	2	0.00
ges timeout list	1,928	0.00		0	2,136	0.00
global KZLD latch for mem in SGA	24	0.00		0	0
global ctx hash table latch	182	0.00		0	0
hash table column usage latch	177	1.13	0.00	0	108,780	0.00
hash table modification latch	73	0.00		0	0
job workq parent latch	0			0	134	0.00
job_queue_processes parameter latch	76	0.00		0	0
kks stats	47,144	6.51	0.17	54	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
kokc descriptor allocation latch	24	0.00		0	0
ksuosstats global area	241	0.00		0	0
ktm global data	8	0.00		0	0
kwqbsn:qsga	129	0.00		0	0
lgwr LWN SCN	1,653	0.06	0.00	0	0
library cache	804,807	1.58	0.09	13	6,816,712	0.08
library cache load lock	1,887	0.26	0.00	0	30	0.00
library cache lock	67,206	0.09	0.00	0	0
library cache lock allocation	1,145	0.00		0	0
library cache pin	25,103	0.10	0.00	0	7	0.00
library cache pin allocation	1,283	0.00		0	0
list of block allocation	179	0.00		0	0
loader state object freelist	2	0.00		0	0
logminer context allocation	1	0.00		0	0
message pool operations parent latch	485	0.00		0	0
messages	120,531	0.02	0.00	0	0
mostly latch-free SCN	1,653	0.06	0.00	0	0
multiblock read objects	80	0.00		0	0
name-service memory objects	2,598	0.00		0	0
name-service namespace bucket	37,805	0.00		0	0
name-service namespace objects	2	0.00		0	0
name-service pending queue	322	0.00		0	0
name-service request	6	0.00		0	0
name-service request queue	36,477	0.00		0	0
ncodef allocation latch	58	0.00		0	0
object queue header heap	394	0.00		0	90	0.00
object queue header operation	5,031	0.00		0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	1,016	0.00		0	0
parallel query stats	113	0.00		0	0
parallel txn reco latch	1,092	0.00		0	0
parameter list	24	0.00		0	0
parameter table allocation management	239	1.26	6.67	6	0
post/wait queue	300	0.00		0	184	0.00
process allocation	36,197	0.00		0	49	0.00
process group creation	100	0.00		0	0
process queue	299	0.00		0	0
process queue reference	6,897	0.00		0	449	0.00
qmn task queue latch	508	0.00		0	0
query server freelists	249	0.00		0	0
query server process	1	0.00		0	1	0.00
queued dump request	16,316	0.00		0	0
redo allocation	4,427	0.00		0	4,982	0.02
redo copy	0			0	4,982	0.12
redo writing	8,842	0.00		0	0
resmgr group change latch	144	0.00		0	0
resmgr:active threads	297	0.00		0	0
resmgr:actses change group	123	0.00		0	0
resmgr:free threads list	296	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	722,155	13.48	0.32	2493	175,299	24.61
rules engine aggregate statistics	7	0.00		0	0
rules engine rule set statistics	114	0.00		0	0
sequence cache	1,107	0.09	0.00	0	0
session allocation	200,837	5.68	0.00	0	0
session idle bit	19,676	0.00		0	0
session state list latch	435	0.00		0	0
session switching	58	0.00		0	0
session timer	1,209	0.00		0	0
shared pool	892,127	4.98	0.14	313	0
shared pool simulator	2,880,465,195	0.00	0.00	0	0
simulator hash latch	36,945	0.00		0	0
simulator lru latch	0			0	36,927	0.10
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	115	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	840	0.00		0	0
threshold alerts latch	243	0.00		0	0
transaction allocation	28,926	0.00		0	0
transaction branch allocation	1,209	0.00		0	0
undo global data	18,695	0.00		0	0
user lock	258	3.10	7.88	18	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	722,155	97,370	31,261	78,607
shared pool	892,127	44,385	6,133	39,114
library cache	804,807	12,753	1,153	11,651
kks stats	47,144	3,068	522	2,763
cache buffers chains	1,238,156	1,583	12	1,571
ges caches resource lists	893,627	455	1	454
ges resource hash list	571,464	106	17	89
ges process parent latch	566,586	36	1	35
user lock	258	8	63	0
parameter table allocation management	239	3	20	1
slave class create	8	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
cache buffers chains	kcbgtcr: kslbegin excl	25	20
cache buffers chains	kcbgcur: kslbegin	5	5
cache buffers chains	kcbgtcr: fast path	1	0
cost function	kzulrl	60	60
cost function	kzulgt: find user res	3	3
ges process parent latch	kjpdmc	1	0
ges resource hash list	kjrref: find matched resource	8	14
ges resource hash list	kjrmas1: lookup master node	6	0
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	3	1
ges resource table freelist	kjruch: cached obj cleanup	1	0
kks stats	kks stats alloc/free	522	522
library cache	kqlmbfre: child: in loop	101	543
library cache	kglukp: child	29	17
library cache	kglobpn: child:	23	17
library cache	kqlmbfre: child: no obj to free	19	388
library cache	kglpndl: child: after processing	9	0
library cache	kglpndl: child: before processing	9	4
library cache	kgldte: child 0	4	9
library cache	kglhdunp: parent: flush	2	0
library cache	kglLockCursor	1	0
library cache	kglini: child	1	8
library cache	kglpin	1	2
library cache	kglsca: parent	1	0
library cache lock	kgllkdl: child: no lock handle	13	14
parameter table allocation management	ksp_param_table_free	20	20
row cache objects	kqrbip	1,010	27,928
row cache objects	kqrpre: find obj	70	263
row cache objects	kqrigt	47	2,753
row cache objects	kqreqd: reget	18	2
row cache objects	kqreqd	11	6
row cache objects	ksucallcbksafely: kqrhngc	5	0
row cache objects	kqrso	1	13
shared pool	kghfrunp: clatch: nowait	27,993	0
shared pool	kghfrunp: alloc: wait	4,863	0
shared pool	kghfrunp: clatch: wait	3,046	428
shared pool	kghfre	931	5,099
shared pool	kghdmp	184	0
shared pool	kghupr1	104	596
shared pool	kghalo	39	343
shared pool	kghalp	7	82
shared pool	kghasp	2	12
shared pool	kghfrh	2	1
shared pool	kghfsh	1	0
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: 680,096
Captured Segments account for 95.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	TAB$	TABLE	116,816	17.18
SYS	SYSTEM	IND$	TABLE	98,224	14.44
SYS	SYSTEM	I_OBJ#	INDEX	90,768	13.35
SYS	SYSTEM	CLU$	TABLE	78,064	11.48
SYS	SYSTEM	LOB$	TABLE	78,000	11.47

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 6
Captured Segments account for 66.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	SYS_IOT_TOP_8872		INDEX	2	33.33
SYS	SYSAUX	WRI$_ADV_MESSAGE_GROUPS_PK		INDEX	2	33.33

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	JOB$		TABLE	1	100.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	GC Buffer Busy	% of Capture
FMIS0300	FMIS_LARGE	XTYHXX	YHXX_PA_10	TABLE PARTITION	18	56.25
FMIS0300	FMISINDEX	IDU060712193340934		INDEX	4	12.50
SYS	SYSTEM	HISTGRM$		TABLE	3	9.38
SYS	SYSTEM	OBJ$		TABLE	2	6.25
FMIS0300	FMIS0300	XTCLUSTERLOCK		TABLE	2	6.25

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 845
Captured Segments account for 51.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	HISTGRM$	TABLE	110	13.02
FMIS0300	FMIS0300	XTCLUSTERUSER	TABLE	65	7.69
FMIS0300	FMISINDEX	IDU060712193340934	INDEX	25	2.96
FMIS0300	FMIS0300	XTCLUSTERLOCK	TABLE	22	2.60
SYS	SYSTEM	SEG$	TABLE	20	2.37

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 384
Captured Segments account for 74.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSTEM	HISTGRM$	TABLE	40	10.42
FMIS0300	FMISINDEX	IDX060712193341043	INDEX	23	5.99
FMIS0300	FMIS0300	QRTZ_LOCKS	TABLE	23	5.99
FMIS0300	FMIS0300	XTCLUSTERLOCK	TABLE	23	5.99
FMIS0300	FMIS0300	XTCLUSTERUSER	TABLE	23	5.99

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	25	12.00	0	1
dc_database_links	60	1.67	0	1
dc_files	1,785	4.76	0	85
dc_global_oids	64	26.56	0	17
dc_histogram_data	5,810	20.12	0	1,195
dc_histogram_defs	5,325	36.08	0	1,722
dc_object_grants	52	30.77	0	16
dc_object_ids	5,939	6.42	0	442
dc_objects	2,536	15.34	2	448
dc_profiles	91	1.10	0	1
dc_rollback_segments	1,864	0.00	0	158
dc_segments	958	40.08	36	381
dc_sequences	41	17.07	41	4
dc_table_scns	1	100.00	0	0
dc_tablespace_quotas	1	100.00	1	1
dc_tablespaces	24,583	0.08	0	17
dc_usernames	1,494	0.80	0	10
dc_users	26,474	0.07	0	30
outstanding_alerts	112	83.93	7	30

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	3	2	1
dc_database_links	1	0	1
dc_files	85	0	85
dc_global_oids	17	0	26
dc_histogram_defs	1,921	0	409,727
dc_object_ids	382	0	8,056
dc_objects	392	0	8,069
dc_profiles	1	0	1
dc_segments	453	1	15,187
dc_sequences	82	3	3
dc_table_scns	1	0	0
dc_tablespace_quotas	2	1	1
dc_tablespaces	20	0	20
dc_usernames	12	0	15
dc_users	11	0	13
outstanding_alerts	215	61	2

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	44	6.82	2,321	0.17	0	0
CLUSTER	86	2.33	241	1.66	2	0
INDEX	9	100.00	20	45.00	0	0
SQL AREA	3,834	14.29	20,724	16.71	650	315
TABLE/PROCEDURE	1,115	23.05	8,670	9.97	149	0
TRIGGER	10	50.00	101	17.82	1	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	241	2	2	2
INDEX	20	9	57	9
TABLE/PROCEDURE	2,953	252	41,169	164

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	360.32		9.24	22.33	135	135	39	39
	SQL	105.95	103.79	5.30	23.04	103	104	20	18
	Freeable	56.63	0.00	2.98	3.38	11		19	19
	PL/SQL	0.52	0.36	0.01	0.03	0	0	37	36
E	Other	353.09		9.54	22.88	135	135	37	37
	Freeable	56.00	0.00	2.80	3.36	11		20	20
	SQL	1.62	0.95	0.09	0.18	1	104	18	16
	PL/SQL	0.34	0.21	0.01	0.01	0	0	35	34

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	256.00	256.00	0.00
large	free memory	256.00	256.00	0.00
shared	CCursor	123.67		-100.00
shared	KGLS heap	137.92		-100.00
shared	KQR L PO	430.87		-100.00
shared	PCursor	55.17		-100.00
shared	free memory	1,793.02	3,195.91	78.24
shared	gcs resources	83.36	83.36	0.00
shared	gcs shadows	49.83	49.83	0.00
shared	ges enqueues	165.27	165.27	0.00
shared	ges resource	437.91	332.79	-24.00
shared	library cache	105.66		-100.00
shared	sql area	372.42		-100.00
shared	sql area:PLSQL	84.87		-100.00
streams	free memory	16.00	16.00	0.00
	buffer_cache	7,680.00	7,680.00	0.00
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.99	13.99	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

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

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Coordinator	25,039	0	0
QMON Slaves	13,367	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	7	0	0	5	12

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_shadows	368,571	463,207	538401	538401

init.ora Parameters

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

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	3,539	0.99	0.91
acks for commit broadcast(logical)	3,557	0.99	0.91
broadcast msgs on commit(actual)	1,119	0.31	0.29
broadcast msgs on commit(logical)	1,121	0.31	0.29
broadcast msgs on commit(wasted)	72	0.02	0.02
broadcast on commit wait time(ms)	60	0.02	0.02
broadcast on commit waits	755	0.21	0.19
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	10	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	577	0.16	0.15
gcs ast xid	0	0.00	0.00
gcs blocked converts	769	0.21	0.20
gcs blocked cr converts	1,648	0.46	0.42
gcs compatible basts	0	0.00	0.00
gcs compatible cr basts (global)	103	0.03	0.03
gcs compatible cr basts (local)	392	0.11	0.10
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	108	0.03	0.03
gcs dbwr write request msgs	25	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	55	0.02	0.01
gcs immediate (null) converts	32	0.01	0.01
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	369	0.10	0.09
gcs indirect ast	289	0.08	0.07
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	16	0.00	0.00
gcs msgs process time(ms)	257	0.07	0.07
gcs msgs received	9,288	2.59	2.38
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	250	0.07	0.06
gcs side channel msgs logical	1,457	0.41	0.37
gcs stale cr	1	0.00	0.00
gcs undo cr	0	0.00	0.00
gcs write notification msgs	1	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	355	0.10	0.09
ges msgs received	9,356	2.61	2.40
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	7	0.00	0.00
global posts requested	7	0.00	0.00
global posts sent	7	0.00	0.00
implicit batch messages received	324	0.09	0.08
implicit batch messages sent	5,346	1.49	1.37
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	19,735	5.51	5.06
messages queue sent actual	27,691	7.73	7.10
messages queue sent logical	38,175	10.66	9.79
messages received actual	16,287	4.55	4.18
messages received logical	18,644	5.21	4.78
messages sent directly	3,264	0.91	0.84
messages sent indirectly	263,787	73.67	67.62
messages sent not implicit batched	22,345	6.24	5.73
messages sent pbatched	269,448	75.25	69.07
msgs causing lmd to send msgs	2,661	0.74	0.68
msgs causing lms(s) to send msgs	223	0.06	0.06
msgs received queue time (ms)	208	0.06	0.05
msgs received queued	18,644	5.21	4.78
msgs sent queue time (ms)	1,859	0.52	0.48
msgs sent queue time on ksxp (ms)	9,848	2.75	2.52
msgs sent queued	37,460	10.46	9.60
msgs sent queued on ksxp	34,544	9.65	8.86
process batch messages received	5,604	1.57	1.44
process batch messages sent	20,489	5.72	5.25

Global CR Served Stats

Statistic	Total
CR Block Requests	1,365
CURRENT Block Requests	879
Data Block Requests	1,365
Undo Block Requests	0
TX Block Requests	782
Current Results	2,244
Private results	0
Zero Results	0
Disk Read Results	0
Fail Results	0
Fairness Down Converts	139
Fairness Clears	0
Free GC Elements	0
Flushes	3
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	0
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
Pins	887	99.32	0.00	0.68
Flushes	0	0.00	0.00	0.00
Writes	123	94.31	5.69	0.00

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
1	data block	487	97.13	2.87	0.00	316	98.42	1.58	0.00
1	undo header	281	100.00	0.00	0.00	1	100.00	0.00	0.00
1	Others	95	100.00	0.00	0.00	68	100.00	0.00	0.00
1	undo block	1	0.00	100.00	0.00	0

End of Report

% Blocks changed per Read:	1.01	Recursive Call %:	95.24
Rollback per transaction %:	92.54	Rows per Sort:	184.40

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	86.40	Soft Parse %:	88.62
Execute to Parse %:	45.11	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	0.18	% Non-Parse CPU:	98.72

Buffer access - local cache %:	99.82
Buffer access - remote cache %:	0.18
Buffer access - disk %:	0.00

Avg global enqueue get time (ms):	0.2
Avg global cache cr block receive time (ms):	0.4
Avg global cache current block receive time (ms):	0.8
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	0.1
Avg global cache cr block flush time (ms):	0.0
Avg global cache current block pin time (ms):	0.3
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.3
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:	1.14
% of indirect sent messages:	91.98
% of flow controlled messages:	6.88