WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ODSDB 3367537179 odsdb2 2 10.2.0.4.0 YES cwgkdb2

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ODSDB	3367537179	odsdb2	2	10.2.0.4.0	YES	cwgkdb2

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 12890 02-3月 -12 03:00:01 59 4.2

End Snap: 12891 02-3月 -12 04:00:54 58 4.4

Elapsed: 60.89 (mins)

DB Time: 2,064.84 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	12890	02-3月 -12 03:00:01	59	4.2
End Snap:	12891	02-3月 -12 04:00:54	58	4.4
Elapsed:		60.89 (mins)
DB Time:		2,064.84 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 4,274.71 4,025.00

Logical reads: 196.25 184.78

Block changes: 23.88 22.49

Physical reads: 0.61 0.57

Physical writes: 0.91 0.86

User calls: 2.87 2.70

Parses: 26.51 24.97

Hard parses: 0.57 0.53

Sorts: 10.83 10.20

Logons: 0.04 0.04

Executes: 31.13 29.31

Transactions: 1.06

	Per Second	Per Transaction
Redo size:	4,274.71	4,025.00
Logical reads:	196.25	184.78
Block changes:	23.88	22.49
Physical reads:	0.61	0.57
Physical writes:	0.91	0.86
User calls:	2.87	2.70
Parses:	26.51	24.97
Hard parses:	0.57	0.53
Sorts:	10.83	10.20
Logons:	0.04	0.04
Executes:	31.13	29.31
Transactions:	1.06

% Blocks changed per Read: 12.17 Recursive Call %: 98.87

Rollback per transaction %: 94.28 Rows per Sort: 21.71

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

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

Library Hit %: 97.45 Soft Parse %: 97.87

Execute to Parse %: 14.83 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 0.15 % Non-Parse CPU: 94.65

Shared Pool Statistics

Begin End

Memory Usage %: 83.46 35.60

% SQL with executions>1: 96.25 81.01

% Memory for SQL w/exec>1: 95.88 75.61

	Begin	End
Memory Usage %:	83.46	35.60
% SQL with executions>1:	96.25	81.01
% Memory for SQL w/exec>1:	95.88	75.61

Top 5 Timed Events

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

cursor: pin S wait on X 9,251,105 90,558 10 73.1 Concurrency

row cache lock 25,956 24,454 942 19.7 Concurrency

library cache load lock 2,041 5,852 2,867 4.7 Concurrency

latch: shared pool 53,086 5,142 97 4.2 Concurrency

CPU time 3,433 2.8

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
cursor: pin S wait on X	9,251,105	90,558	10	73.1	Concurrency
row cache lock	25,956	24,454	942	19.7	Concurrency
library cache load lock	2,041	5,852	2,867	4.7	Concurrency
latch: shared pool	53,086	5,142	97	4.2	Concurrency
CPU time		3,433		2.8

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.86 0.81

Global Cache blocks served: 2.92 2.75

GCS/GES messages received: 32.77 30.86

GCS/GES messages sent: 193.69 182.37

DBWR Fusion writes: 0.05 0.04

Estd Interconnect traffic (KB) 104.69

	Per Second	Per Transaction
Global Cache blocks received:	0.86	0.81
Global Cache blocks served:	2.92	2.75
GCS/GES messages received:	32.77	30.86
GCS/GES messages sent:	193.69	182.37
DBWR Fusion writes:	0.05	0.04
Estd Interconnect traffic (KB)	104.69

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

Buffer access - local cache %: 99.25

Buffer access - remote cache %: 0.44

Buffer access - disk %: 0.31

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 14.3

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

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

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

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

Global cache log flushes for cr blocks served %: 0.5

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

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

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

Global cache log flushes for current blocks served %: 0.3

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.2

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 10.9

% of direct sent messages: 2.91

% of indirect sent messages: 77.74

% of flow controlled messages: 19.34

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): 123890.3s
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
parse time elapsed	113,645.44	91.73
hard parse elapsed time	41,933.76	33.85
connection management call elapsed time	39,711.25	32.05
sql execute elapsed time	27,561.48	22.25
DB CPU	3,433.43	2.77
failed parse elapsed time	2,973.46	2.40
sequence load elapsed time	113.63	0.09
PL/SQL execution elapsed time	16.10	0.01
PL/SQL compilation elapsed time	0.40	0.00
hard parse (sharing criteria) elapsed time	0.18	0.00
repeated bind elapsed time	0.12	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	123,890.26
background elapsed time	17,775.72
background cpu time	54.12

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	9,389,014	98.64	126,559	13	2,419.85
Other	339,081	81.83	3,955	12	87.39
Cluster	5,234	0.34	585	112	1.35
System I/O	33,860	0.00	14	0	8.73
User I/O	2,358	0.00	10	4	0.61
Application	3,070	0.00	1	0	0.79
Configuration	1,192	0.00	1	1	0.31
Commit	191	0.00	0	2	0.05
Network	9,240	0.00	0	0	2.38

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	9,251,105	99.99	90,558	10	2,384.31
row cache lock	25,956	33.56	24,454	942	6.69
library cache load lock	2,041	97.84	5,852	2867	0.53
latch: shared pool	53,086	0.00	5,142	97	13.68
latch free	7,680	0.00	2,121	276	1.98
enq: CF - contention	3,775	97.09	1,790	474	0.97
gc current grant 2-way	795	0.00	436	548	0.20
latch: row cache objects	4,315	0.00	266	62	1.11
latch: library cache	41,143	0.00	196	5	10.60
os thread startup	101	88.12	89	880	0.03
gc cr disk read	72	0.00	77	1074	0.02
gc current grant busy	359	0.00	68	189	0.09
Streams AQ: qmn coordinator waiting for slave to start	6	100.00	33	5497	0.00
db file sequential read	2,355	0.00	10	4	0.61
log file parallel write	8,884	0.00	6	1	2.29
control file sequential read	21,225	0.00	5	0	5.47
DFS lock handle	8,019	0.00	5	1	2.07
gc buffer busy	98	18.37	2	19	0.03
CGS wait for IPC msg	246,409	100.00	2	0	63.51
db file parallel write	2,592	0.00	2	1	0.67
library cache lock	3,907	0.00	2	0	1.01
control file parallel write	1,159	0.00	1	1	0.30
library cache pin	4,854	0.00	1	0	1.25
reliable message	1,143	0.00	1	1	0.29
rdbms ipc reply	3,211	0.00	1	0	0.83
log buffer space	1,084	0.00	1	1	0.28
enq: RO - fast object reuse	2,160	0.00	1	0	0.56
gc cr block 2-way	1,738	0.00	1	0	0.45
ksxr poll remote instances	61,566	43.04	1	0	15.87
enq: TS - contention	1,209	0.00	1	0	0.31
gc cr block busy	319	0.00	0	1	0.08
kksfbc child completion	8	100.00	0	49	0.00
enq: TM - contention	869	0.00	0	0	0.22
enq: IR - contention	1,033	0.00	0	0	0.27
gc current block 2-way	730	0.00	0	0	0.19
log file sync	191	0.00	0	2	0.05
enq: MD - contention	548	0.00	0	0	0.14
name-service call wait	3	0.00	0	72	0.00
latch: ges resource hash list	3,222	0.00	0	0	0.83
enq: SQ - contention	1	0.00	0	124	0.00
gc cr grant 2-way	588	0.00	0	0	0.15
gc current block busy	4	0.00	0	24	0.00
gc cr multi block request	502	0.00	0	0	0.13
enq: HW - contention	107	0.00	0	1	0.03
enq: PR - contention	2	0.00	0	26	0.00
wait for scn ack	49	0.00	0	1	0.01
enq: TT - contention	20	0.00	0	1	0.01
enq: PS - contention	36	0.00	0	1	0.01
LGWR wait for redo copy	63	0.00	0	0	0.02
PX Deq: reap credit	896	92.63	0	0	0.23
SQL*Net message to client	9,210	0.00	0	0	2.37
gcs log flush sync	67	11.94	0	0	0.02
PX Deq Credit: send blkd	25	32.00	0	0	0.01
db file scattered read	1	0.00	0	11	0.00
IPC send completion sync	15	100.00	0	0	0.00
buffer busy waits	10	0.00	0	1	0.00
SQL*Net break/reset to client	41	0.00	0	0	0.01
enq: WF - contention	10	0.00	0	1	0.00
cursor: mutex X	2,481	0.00	0	0	0.64
enq: FB - contention	8	0.00	0	0	0.00
gc current multi block request	29	0.00	0	0	0.01
enq: TA - contention	5	0.00	0	0	0.00
latch: cache buffers chains	4	0.00	0	0	0.00
direct path write	2	0.00	0	1	0.00
PX Deq: Signal ACK	30	46.67	0	0	0.01
latch: session allocation	8	0.00	0	0	0.00
enq: AF - task serialization	1	0.00	0	1	0.00
enq: JQ - contention	1	0.00	0	1	0.00
enq: PI - contention	1	0.00	0	0	0.00
KJC: Wait for msg sends to complete	12	0.00	0	0	0.00
SQL*Net more data from client	30	0.00	0	0	0.01
latch: library cache lock	1	0.00	0	0	0.00
cursor: mutex S	10	0.00	0	0	0.00
SQL*Net message from client	9,212	0.00	43,150	4684	2.37
gcs remote message	268,497	96.59	7,129	27	69.20
Streams AQ: qmn slave idle wait	138	3.62	3,701	26822	0.04
Streams AQ: waiting for time management or cleanup tasks	13	100.00	3,574	274902	0.00
DIAG idle wait	18,150	0.00	3,545	195	4.68
Streams AQ: qmn coordinator idle wait	258	44.19	3,218	12472	0.07
ges remote message	176,411	49.99	2,564	15	45.47
jobq slave wait	515	86.41	1,479	2872	0.13
PX Idle Wait	408	93.38	965	2365	0.11
Streams AQ: waiting for messages in the queue	18	100.00	59	3257	0.00
class slave wait	20	55.00	58	2887	0.01
PX Deq: Execution Msg	88	11.36	1	13	0.02
PX Deq: Parse Reply	44	40.91	0	2	0.01
PX Deq: Join ACK	48	35.42	0	1	0.01
PX Deq: Msg Fragment	21	4.76	0	0	0.01
PX Deq: Execute Reply	31	19.35	0	0	0.01
Streams AQ: RAC qmn coordinator idle wait	260	100.00	0	0	0.07

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
row cache lock	4,071	60.97	6,823	1676	1.05
events in waitclass Other	323,715	85.47	3,812	12	83.43
latch: shared pool	47,003	0.00	3,770	80	12.11
cursor: pin S wait on X	304,506	99.79	2,974	10	78.48
os thread startup	101	88.12	89	880	0.03
latch: row cache objects	575	0.00	55	95	0.15
latch: library cache	31,981	0.00	22	1	8.24
log file parallel write	8,884	0.00	6	1	2.29
control file sequential read	7,425	0.00	2	0	1.91
db file parallel write	2,592	0.00	2	1	0.67
control file parallel write	1,151	0.00	1	1	0.30
log buffer space	1,084	0.00	1	1	0.28
db file sequential read	16	0.00	0	6	0.00
enq: TM - contention	118	0.00	0	1	0.03
gc current block 2-way	104	0.00	0	1	0.03
library cache pin	103	0.00	0	1	0.03
enq: HW - contention	85	0.00	0	1	0.02
library cache lock	101	0.00	0	0	0.03
gc cr block 2-way	103	0.00	0	0	0.03
gc current grant busy	9	0.00	0	0	0.00
gc cr multi block request	15	0.00	0	0	0.00
cursor: mutex X	669	0.00	0	0	0.17
gc cr grant 2-way	10	0.00	0	0	0.00
gc current grant 2-way	1	0.00	0	0	0.00
gc buffer busy	1	0.00	0	0	0.00
rdbms ipc message	115,309	32.24	36,228	314	29.72
gcs remote message	268,500	96.59	7,129	27	69.20
Streams AQ: waiting for time management or cleanup tasks	13	100.00	3,574	274902	0.00
pmon timer	1,240	100.00	3,563	2874	0.32
DIAG idle wait	18,150	0.00	3,545	195	4.68
Streams AQ: qmn coordinator idle wait	258	44.19	3,218	12472	0.07
ges remote message	176,446	49.99	2,564	15	45.48
smon timer	1,087	0.46	954	877	0.28
class slave wait	2	0.00	0	15	0.00
PX Deq: Join ACK	15	40.00	0	1	0.00
PX Deq: Parse Reply	13	46.15	0	1	0.00
PX Deq: Execute Reply	8	37.50	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	260	100.00	0	0	0.07

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	43,371
AVG_IDLE_TIME	322,614
AVG_IOWAIT_TIME	350
AVG_SYS_TIME	2,928
AVG_USER_TIME	40,377
BUSY_TIME	347,529
IDLE_TIME	2,581,533
IOWAIT_TIME	3,309
SYS_TIME	23,952
USER_TIME	323,577
LOAD	0
OS_CPU_WAIT_TIME	852,400
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,285,996,544
NUM_CPUS	8
NUM_CPU_CORES	4

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	107,374.30	3,406.40	2,178	623,224
odsdb	16,040.60	25.60	0	29,732
SYS$BACKGROUND	0.00	0.00	50	63,593
ods	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	2174	986	7518063	9556407	7908	1
odsdb	0	0	1431023	1601818	1174	0
SYS$BACKGROUND	184	39	437869	1441858	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
36,023	63	38	947.96	29.08	15zytu14qzw6p		insert into sys.aud$( sessioni...
22,885	39	26	880.18	18.47	82rgxmjf8nq0w		select nbitask0_.ID_ as ID1_16...
19,386	30	304	63.77	15.65	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
8,351	15	10	835.07	6.74	c6j034dcffqaq		select nbitask0_.ID_ as ID1_16...
5,689	7	6	948.16	4.59	b8t4pnddvjst3		select * from ( select nbitask...
5,238	8	24	218.24	4.23	2as5hqq1zdtkw		select baseinterf0_.ID_ as ID1...
4,674	7	49	95.40	3.77	7nuw4xwrnuwxq		select col#, intcol#, toid, ve...
3,569	2,953	1	3568.52	2.88	dct34c6626znm		DECLARE job BINARY_INTEGER := ...
3,346	3	3	1115.46	2.70	5jxwda6s8nvc7		select tablespace_id, rfno, ...
2,988	2	52	57.46	2.41	1dubbbfqnqvh9		SELECT ORA_TQ_BASE$.NEXTVAL FR...
2,870	0	152	18.88	2.32	0r5x6sbm1qrnr	JDBC Thin Client	select serviceass0_.ID_ as ID1...
2,867	5	28	102.38	2.31	8buwz935md4tm	JDBC Thin Client	select jobid, ts, transacted...
2,863	5	5	572.51	2.31	4hc8pzq5901r9		SELECT TRIGGER_NAME, TRIGGER_...
2,618	3	2	1308.83	2.11	40sy7a9rbz5md		SELECT AA.COMPID COMPID, AA.MC...
2,597	3	4	649.14	2.10	c7sn076yz7030		select smontabv.cnt, smontab....
2,573	3	12	214.39	2.08	axmdf8vq7k1rh		select increment$, minvalue, m...
2,412	2	40	60.29	1.95	1rd8um1taq1fn		update sys.aud$ set action#=:2...
2,044	0	25	81.75	1.65	fudsnu0u8fuhj		select * from xtclusterlock wh...
2,044	0	1	2043.81	1.65	29tgxad9bpwfd		select * from xtclusterlock wh...
1,562	1	33	47.34	1.26	0k8522rmdzg4k		select privilege# from sysauth...

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
2,953	3,569	1	2952.70	2.88	dct34c6626znm		DECLARE job BINARY_INTEGER := ...
63	36,023	38	1.67	29.08	15zytu14qzw6p		insert into sys.aud$( sessioni...
39	22,885	26	1.49	18.47	82rgxmjf8nq0w		select nbitask0_.ID_ as ID1_16...
30	19,386	304	0.10	15.65	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
15	8,351	10	1.46	6.74	c6j034dcffqaq		select nbitask0_.ID_ as ID1_16...
9	9	1	8.71	0.01	5zdk0raqna76z		INSERT INTO FMIS_STATUS (LOG_N...
9	9	1	8.56	0.01	0ty41xnrhd894		INSERT INTO FMIS_STATUS (LOG_N...
8	8	1	7.99	0.01	6sjthdk7c46tg		SELECT COUNT(*), TRUNC(SUM(KSM...
8	5,238	24	0.33	4.23	2as5hqq1zdtkw		select baseinterf0_.ID_ as ID1...
7	4,674	49	0.14	3.77	7nuw4xwrnuwxq		select col#, intcol#, toid, ve...
7	5,689	6	1.08	4.59	b8t4pnddvjst3		select * from ( select nbitask...
5	2,867	28	0.18	2.31	8buwz935md4tm	JDBC Thin Client	select jobid, ts, transacted...
5	2,863	5	0.97	2.31	4hc8pzq5901r9		SELECT TRIGGER_NAME, TRIGGER_...
3	2,618	2	1.67	2.11	40sy7a9rbz5md		SELECT AA.COMPID COMPID, AA.MC...
3	2,597	4	0.83	2.10	c7sn076yz7030		select smontabv.cnt, smontab....
3	2,573	12	0.26	2.08	axmdf8vq7k1rh		select increment$, minvalue, m...
3	3,346	3	0.97	2.70	5jxwda6s8nvc7		select tablespace_id, rfno, ...
2	2,412	40	0.05	1.95	1rd8um1taq1fn		update sys.aud$ set action#=:2...
2	2,988	52	0.03	2.41	1dubbbfqnqvh9		SELECT ORA_TQ_BASE$.NEXTVAL FR...
1	1,562	33	0.04	1.26	0k8522rmdzg4k		select privilege# from sysauth...
0	2,870	152	0.00	2.32	0r5x6sbm1qrnr	JDBC Thin Client	select serviceass0_.ID_ as ID1...
0	2,044	25	0.00	1.65	fudsnu0u8fuhj		select * from xtclusterlock wh...
0	2,044	1	0.05	1.65	29tgxad9bpwfd		select * from xtclusterlock wh...

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: 716,951
Captured SQL account for 35.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
554,045	1	554,045.00	77.28	2952.70	3568.52	dct34c6626znm	DECLARE job BINARY_INTEGER := ...
70,679	2,146	32.94	9.86	4.11	4.36	33cmj01uf5zfb	delete from col$ where obj#=:1
31,363	1,073	29.23	4.37	0.47	0.47	7ayfw9g455pn3	select u2.name, o2.name from ...
19,965	23	868.04	2.78	0.74	8.77	0070chz1yu5uf	DECLARE job BINARY_INTEGER := ...
12,154	3,268	3.72	1.70	0.23	0.36	96g93hntrzjtr	select /+ rule / bucket_cnt,...
11,847	69	171.70	1.65	0.46	16.12	8jtnr6cma1t3y	SELECT TRIM(NVL(MAX(A.CSZ), 0)...
10,902	1,082	10.08	1.52	0.79	0.79	59vjj34vugaav	delete from obj$ where obj# = ...
8,462	46	183.96	1.18	0.35	8.23	27vgn5r380y20	DECLARE job BINARY_INTEGER := ...
7,600	1,082	7.02	1.06	0.51	0.51	7zx0nu1u7qccz	delete from seg$ where ts#=:1 ...
7,231	3,597	2.01	1.01	0.38	0.38	9y7s2afnkqs9d	delete from idl_ub2$ where obj...
7,231	3,597	2.01	1.01	0.39	0.39	d5jd9b2xct7xz	delete from idl_char$ where ob...
7,231	3,597	2.01	1.01	0.38	0.38	dvpfc386d6dmm	delete from idl_sb4$ where obj...
7,231	3,597	2.01	1.01	0.40	0.40	gsqxm6zz3w2by	delete from idl_ub1$ where obj...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 2,222
Captured SQL account for 0.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
2,157	1	2,157.00	97.07	2952.70	3568.52	dct34c6626znm	DECLARE job BINARY_INTEGER := ...
10	2,146	0.00	0.45	4.11	4.36	33cmj01uf5zfb	delete from col$ where obj#=:1
2	131	0.02	0.09	0.06	0.06	8swypbbr0m372	select order#, columns, types ...
1	23	0.04	0.05	0.74	8.77	0070chz1yu5uf	DECLARE job BINARY_INTEGER := ...
1	2	0.50	0.05	3.34	2617.66	40sy7a9rbz5md	SELECT AA.COMPID COMPID, AA.MC...
1	80	0.01	0.05	0.02	8.90	42ddyag628kjx	begin :con := VPD_PKG.FILTER_C...
1	69	0.01	0.05	0.46	16.12	8jtnr6cma1t3y	SELECT TRIM(NVL(MAX(A.CSZ), 0)...
0	1,191	0.00	0.00	0.15	0.15	03tuga43v3xkg	BEGIN aw_drop_proc(ora_dict_...
0	531	0.00	0.00	0.11	0.59	04xtrk7uyhknh	select obj#, type#, ctime, mti...
0	99	0.00	0.00	0.21	0.26	0a0pcbdzfybs2	DECLARE V_OBJ_NAME VARCHA...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 113,725
Captured SQL account for 36.4% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Text
3,597	0	0.00	9y7s2afnkqs9d	delete from idl_ub2$ where obj...
3,597	0	0.00	d5jd9b2xct7xz	delete from idl_char$ where ob...
3,597	0	0.00	dvpfc386d6dmm	delete from idl_sb4$ where obj...
3,597	0	0.00	gsqxm6zz3w2by	delete from idl_ub1$ where obj...
3,268	2,204	0.67	96g93hntrzjtr	select /+ rule / bucket_cnt,...
2,146	0	0.00	1ts05g359wku8	select 1 from sys.streams$_pre...
2,146	61	0.03	2wdrw5tqputaq	delete from cdef$ where obj#=:...
2,146	5,406	2.52	33cmj01uf5zfb	delete from col$ where obj#=:1
1,199	0	0.00	av0kjjbhc642q	delete from objauth$ where obj...
1,191	1,191	1.00	03tuga43v3xkg	BEGIN aw_drop_proc(ora_dict_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 96,865
Captured SQL account for 37.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
3,597	3,597	3.71	9y7s2afnkqs9d	delete from idl_ub2$ where obj...
3,597	3,597	3.71	d5jd9b2xct7xz	delete from idl_char$ where ob...
3,597	3,597	3.71	dvpfc386d6dmm	delete from idl_sb4$ where obj...
3,597	3,597	3.71	gsqxm6zz3w2by	delete from idl_ub1$ where obj...
2,146	2,146	2.22	1ts05g359wku8	select 1 from sys.streams$_pre...
2,146	2,146	2.22	2wdrw5tqputaq	delete from cdef$ where obj#=:...
2,146	2,146	2.22	33cmj01uf5zfb	delete from col$ where obj#=:1
1,199	1,199	1.24	av0kjjbhc642q	delete from objauth$ where obj...
1,191	1,191	1.23	03tuga43v3xkg	BEGIN aw_drop_proc(ora_dict_...
1,086	13	1.12	1gfaj4z5hn1kf	delete from dependency$ where ...
1,083	1,083	1.12	aq4js2gkfjru8	update tsq$ set blocks=:3, max...
1,082	1,082	1.12	1mvbtvbqt4z4p	delete from sys.cache_stats_1$...
1,082	1,082	1.12	59vjj34vugaav	delete from obj$ where obj# = ...
1,082	1,082	1.12	7zx0nu1u7qccz	delete from seg$ where ts#=:1 ...
1,073	1,073	1.11	7ayfw9g455pn3	select u2.name, o2.name from ...
1,073	1,073	1.11	a37gqn1h2uah8	select nvl(spare3, 0), proper...
1,073	1,073	1.11	as3uq6ggb3gx6	delete from hist_head$ where o...

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 Text
42	29	ftf0qy4kwpk62	insert into NBI_LOG_EVENT (TIM...
40	4	99wvrgpaqvtrk	INSERT INTO HZ_LOG (LOG_NO, US...
26	267	6aq34nj2zb2n7	select col#, grantee#, privi...
23	80	42ddyag628kjx	begin :con := VPD_PKG.FILTER_C...
21	49	7nuw4xwrnuwxq	select col#, intcol#, toid, ve...
21	49	f3g84j69n0tjh	select col#, intcol#, ntab# fr...

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 Text
587.29	16.46	3,568.52	2,952.70	1	dct34c6626znm	DECLARE job BINARY_INTEGER := ...
0.51	0.00	36,022.65	63.29	38	15zytu14qzw6p	insert into sys.aud$( sessioni...
0.16	18.30	0.87	0.82	1,083	aq4js2gkfjru8	update tsq$ set blocks=:3, max...
0.05	4.28	1.17	1.16	1	3map0rqcjzx4h	SELECT OWNER, OBJECT_NAME FROM...
0.05	10.27	0.47	0.47	1,073	7ayfw9g455pn3	select u2.name, o2.name from ...
0.04	0.82	4.36	4.11	2,146	33cmj01uf5zfb	delete from col$ where obj#=:1
0.02	3.14	0.79	0.79	1,082	59vjj34vugaav	delete from obj$ where obj# = ...
0.02	0.27	8.77	0.74	23	0070chz1yu5uf	DECLARE job BINARY_INTEGER := ...
0.02	0.26	7.75	0.11	174	9qgtwh66xg6nz	update seg$ set type#=:4, bloc...
0.02	6.03	0.32	0.09	788	2ym6hhaq30r73	select type#, blocks, extents,...
0.02	0.11	16.12	0.46	69	8jtnr6cma1t3y	SELECT TRIM(NVL(MAX(A.CSZ), 0)...
0.01	0.11	8.23	0.35	46	27vgn5r380y20	DECLARE job BINARY_INTEGER := ...
0.01	1.49	0.59	0.11	531	04xtrk7uyhknh	select obj#, type#, ctime, mti...
0.01	3.53	0.19	0.07	632	5ngzsfstg8tmy	select o.owner#, o.name, o.nam...

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;

03tuga43v3xkg BEGIN aw_drop_proc(ora_dict_obj_type, ora_dict_obj_name, ora_dict_obj_owner); 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

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;

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

0r5x6sbm1qrnr select serviceass0_.ID_ as ID1_1_, serviceass0_.OBJ_VERSION_ as OBJ3_1_, serviceass0_.STATE_ as STATE4_1_, serviceass0_.NAME_ as NAME5_1_, serviceass0_.DESCRIPTION_ as DESCRIPT6_1_, serviceass0_.BUNDLE_VERSION_ as BUNDLE7_1_, serviceass0_.CREATE_DATE_ as CREATE8_1_, serviceass0_.LAST_MODIFIED_DATE_ as LAST9_1_, serviceass0_.SINGLETON_ as SINGLETON11_1_ from MG_BUNDLE_INFO serviceass0_ where serviceass0_.CLASS_='S' and serviceass0_.SINGLETON_=1

0ty41xnrhd894 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, 'ODSDB2_2' AS INST_INFO FROM V$KSMSP GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '空闲块', 'RECR', '可重建块', 'FREEABL', '可释放块', 'PERM', '永久块(不可释放)', KSMCHCLS))

15zytu14qzw6p insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34)

1dubbbfqnqvh9 SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL

1gfaj4z5hn1kf delete from dependency$ where d_obj#=:1

1mvbtvbqt4z4p delete from sys.cache_stats_1$ where dataobj# = :1

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

1ts05g359wku8 select 1 from sys.streams$_prepare_object where obj#= :1 and rownum= 1

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

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

2as5hqq1zdtkw select baseinterf0_.ID_ as ID1_7_, baseinterf0_.NAME_ as NAME3_7_, baseinterf0_.METHOD_NAME_ as METHOD4_7_, baseinterf0_.UID_ as UID5_7_, baseinterf0_.CREATED_TIME_ as CREATED6_7_, baseinterf0_.NOTES_ as NOTES7_7_, baseinterf0_.GROUP_ID_ as GROUP8_7_, baseinterf0_.HAS_ATTACHMENT_ as HAS9_7_, baseinterf0_.JAR_ as JAR10_7_, baseinterf0_.DATA_SOURCE_ID_ as DATA11_7_, baseinterf0_.READONLY_ as READONLY12_7_, baseinterf0_.END_POINT_ as END13_7_, baseinterf0_.NAMESPACE_ as NAMESPACE14_7_, baseinterf0_.CLASS_ as CLASS2_7_ from NBI_INTERFACE baseinterf0_ where baseinterf0_.UID_=:1

2wdrw5tqputaq delete from cdef$ where obj#=:1

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

33cmj01uf5zfb delete from col$ where obj#=:1

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

40sy7a9rbz5md SELECT AA.COMPID COMPID, AA.MC COMPANYNAME, COUNT(*) VALUE FROM (SELECT DISTINCT A.YHDM YHDM, C.YHMC USERID, C.XSMC NAME, C.COMPID compid, D.MC MC, C.XTDXID XTDXID FROM XTYWCSCONTROL A, (select * from XTYHXX ) C, (SELECT DECODE(TRIM(DH), 'MAIN', :1, DH) DH, MC FROM XTDW) D WHERE TRIM(D.DH(+)) = TRIM(C.COMPID) 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')) AA GROUP BY AA.COMPID, AA.MC ORDER BY AA.COMPID

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

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

59vjj34vugaav delete from obj$ where obj# = :1

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

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

5zdk0raqna76z 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, 'ODSDB2_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)

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

7ayfw9g455pn3 select u2.name, o2.name from ind$ i, obj$ o1, obj$ o2, user$ u1, user$ u2 where i.bo# = o1.obj# and o1.owner#=u1.user# and i.obj#=o2.obj# and o2.owner#=u2.user# and u1.name=:1 and o1.name=:2 and i.type#=9 union select u4.name, o4.name from ind$ i1, ntab$ n, obj$ o3, obj$ o4, user$ u3, user$ u4 where i1.bo#=n.ntab# and n.ntab# in (select n1.ntab# from ntab$ n1 start with n1.obj#=o3.obj# connect by prior n1.ntab# = n1.obj#) and o3.owner#=u3.user# and i1.obj#=o4.obj# and o4.owner#=u4.user# and u3.name=:1 and o3.name=:2 and i1.type#=9

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#

7nuw4xwrnuwxq select col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc

7zx0nu1u7qccz delete from seg$ where ts#=:1 and file#=:2 and block#=:3

82rgxmjf8nq0w select nbitask0_.ID_ as ID1_16_, nbitask0_.OBJ_VERSION_ as OBJ2_16_, nbitask0_.TYPE_ as TYPE3_16_, nbitask0_.EXCUTE_TIMES_ as EXCUTE4_16_, nbitask0_.CONTENT_ as CONTENT5_16_, nbitask0_.MAPPING_TYPE_ as MAPPING6_16_, nbitask0_.OBJECT_ as OBJECT7_16_, nbitask0_.INT_RULE_ID_ as INT8_16_, nbitask0_.LAST_ACCESS_TIME_ as LAST9_16_, nbitask0_.CREATED_TIME_ as CREATED10_16_, nbitask0_.EXCUTED_ as EXCUTED11_16_, nbitask0_.EXCUTED_WITH_FAULT_ as EXCUTED12_16_ from NBI_TASK nbitask0_, NBI_INTEGRATION_RULE integratio1_ where nbitask0_.INT_RULE_ID_=integratio1_.ID_ and integratio1_.STOP_=0 and nbitask0_.EXCUTED_=0 and nbitask0_.EXCUTED_WITH_FAULT_=0

8buwz935md4tm select jobid, ts, transacted, scheduled, details from ODE_JOB where nodeid = :1 and ts < :2 order by ts

8jtnr6cma1t3y SELECT TRIM(NVL(MAX(A.CSZ), 0)) FROM XTCS A WHERE UPPER(TRIM(A.CSMC))=:CSMC

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

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 )

9qgtwh66xg6nz update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3

9y7s2afnkqs9d delete from idl_ub2$ where obj#=:1 and part=:2

a37gqn1h2uah8 select nvl(spare3, 0), property, flags, nvl(spare5, 'N') from tab$ where obj# = :1

aq4js2gkfjru8 update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2

as3uq6ggb3gx6 delete from hist_head$ where obj# = :1

av0kjjbhc642q delete from objauth$ where obj#=:1

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

b8t4pnddvjst3 select * from ( select nbitask0_.ID_ as ID1_16_, nbitask0_.OBJ_VERSION_ as OBJ2_16_, nbitask0_.TYPE_ as TYPE3_16_, nbitask0_.EXCUTE_TIMES_ as EXCUTE4_16_, nbitask0_.CONTENT_ as CONTENT5_16_, nbitask0_.MAPPING_TYPE_ as MAPPING6_16_, nbitask0_.OBJECT_ as OBJECT7_16_, nbitask0_.INT_RULE_ID_ as INT8_16_, nbitask0_.LAST_ACCESS_TIME_ as LAST9_16_, nbitask0_.CREATED_TIME_ as CREATED10_16_, nbitask0_.EXCUTED_ as EXCUTED11_16_, nbitask0_.EXCUTED_WITH_FAULT_ as EXCUTED12_16_ from NBI_TASK nbitask0_ where nbitask0_.EXCUTED_=1 or nbitask0_.EXCUTED_WITH_FAULT_=1 and nbitask0_.CREATED_TIME_<=:1 ) where rownum <= :2

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

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

d5jd9b2xct7xz delete from idl_char$ where obj#=:1 and part=:2

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;

dvpfc386d6dmm delete from idl_sb4$ where obj#=:1 and part=:2

f3g84j69n0tjh select col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc

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

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

gsqxm6zz3w2by delete from idl_ub1$ where obj#=:1 and part=:2

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;
03tuga43v3xkg	BEGIN aw_drop_proc(ora_dict_obj_type, ora_dict_obj_name, ora_dict_obj_owner); 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
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;
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0r5x6sbm1qrnr	select serviceass0_.ID_ as ID1_1_, serviceass0_.OBJ_VERSION_ as OBJ3_1_, serviceass0_.STATE_ as STATE4_1_, serviceass0_.NAME_ as NAME5_1_, serviceass0_.DESCRIPTION_ as DESCRIPT6_1_, serviceass0_.BUNDLE_VERSION_ as BUNDLE7_1_, serviceass0_.CREATE_DATE_ as CREATE8_1_, serviceass0_.LAST_MODIFIED_DATE_ as LAST9_1_, serviceass0_.SINGLETON_ as SINGLETON11_1_ from MG_BUNDLE_INFO serviceass0_ where serviceass0_.CLASS_='S' and serviceass0_.SINGLETON_=1
0ty41xnrhd894	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, 'ODSDB2_2' AS INST_INFO FROM V$KSMSP GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '空闲块', 'RECR', '可重建块', 'FREEABL', '可释放块', 'PERM', '永久块(不可释放)', KSMCHCLS))
15zytu14qzw6p	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34)
1dubbbfqnqvh9	SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
1mvbtvbqt4z4p	delete from sys.cache_stats_1$ where dataobj# = :1
1rd8um1taq1fn	update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(systimestamp as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
1ts05g359wku8	select 1 from sys.streams$_prepare_object where obj#= :1 and rownum= 1
27vgn5r380y20	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN RUN_JOB_1; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
29tgxad9bpwfd	select * from xtclusterlock where clustername='GRIS_CLUSTER' and objkind='MessagePlatformNew'
2as5hqq1zdtkw	select baseinterf0_.ID_ as ID1_7_, baseinterf0_.NAME_ as NAME3_7_, baseinterf0_.METHOD_NAME_ as METHOD4_7_, baseinterf0_.UID_ as UID5_7_, baseinterf0_.CREATED_TIME_ as CREATED6_7_, baseinterf0_.NOTES_ as NOTES7_7_, baseinterf0_.GROUP_ID_ as GROUP8_7_, baseinterf0_.HAS_ATTACHMENT_ as HAS9_7_, baseinterf0_.JAR_ as JAR10_7_, baseinterf0_.DATA_SOURCE_ID_ as DATA11_7_, baseinterf0_.READONLY_ as READONLY12_7_, baseinterf0_.END_POINT_ as END13_7_, baseinterf0_.NAMESPACE_ as NAMESPACE14_7_, baseinterf0_.CLASS_ as CLASS2_7_ from NBI_INTERFACE baseinterf0_ where baseinterf0_.UID_=:1
2wdrw5tqputaq	delete from cdef$ where obj#=:1
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
33cmj01uf5zfb	delete from col$ where obj#=:1
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
40sy7a9rbz5md	SELECT AA.COMPID COMPID, AA.MC COMPANYNAME, COUNT() VALUE FROM (SELECT DISTINCT A.YHDM YHDM, C.YHMC USERID, C.XSMC NAME, C.COMPID compid, D.MC MC, C.XTDXID XTDXID FROM XTYWCSCONTROL A, (select from XTYHXX ) C, (SELECT DECODE(TRIM(DH), 'MAIN', :1, DH) DH, MC FROM XTDW) D WHERE TRIM(D.DH(+)) = TRIM(C.COMPID) 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')) AA GROUP BY AA.COMPID, AA.MC ORDER BY AA.COMPID
42ddyag628kjx	begin :con := VPD_PKG.FILTER_COMPID(:sn, :on); end;
4hc8pzq5901r9	SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = :1 AND NEXT_FIRE_TIME < :2 AND (NEXT_FIRE_TIME >= :3) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
59vjj34vugaav	delete from obj$ where obj# = :1
5jxwda6s8nvc7	select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))
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
5zdk0raqna76z	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, 'ODSDB2_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)
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
7ayfw9g455pn3	select u2.name, o2.name from ind$ i, obj$ o1, obj$ o2, user$ u1, user$ u2 where i.bo# = o1.obj# and o1.owner#=u1.user# and i.obj#=o2.obj# and o2.owner#=u2.user# and u1.name=:1 and o1.name=:2 and i.type#=9 union select u4.name, o4.name from ind$ i1, ntab$ n, obj$ o3, obj$ o4, user$ u3, user$ u4 where i1.bo#=n.ntab# and n.ntab# in (select n1.ntab# from ntab$ n1 start with n1.obj#=o3.obj# connect by prior n1.ntab# = n1.obj#) and o3.owner#=u3.user# and i1.obj#=o4.obj# and o4.owner#=u4.user# and u3.name=:1 and o3.name=:2 and i1.type#=9
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#
7nuw4xwrnuwxq	select col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc
7zx0nu1u7qccz	delete from seg$ where ts#=:1 and file#=:2 and block#=:3
82rgxmjf8nq0w	select nbitask0_.ID_ as ID1_16_, nbitask0_.OBJ_VERSION_ as OBJ2_16_, nbitask0_.TYPE_ as TYPE3_16_, nbitask0_.EXCUTE_TIMES_ as EXCUTE4_16_, nbitask0_.CONTENT_ as CONTENT5_16_, nbitask0_.MAPPING_TYPE_ as MAPPING6_16_, nbitask0_.OBJECT_ as OBJECT7_16_, nbitask0_.INT_RULE_ID_ as INT8_16_, nbitask0_.LAST_ACCESS_TIME_ as LAST9_16_, nbitask0_.CREATED_TIME_ as CREATED10_16_, nbitask0_.EXCUTED_ as EXCUTED11_16_, nbitask0_.EXCUTED_WITH_FAULT_ as EXCUTED12_16_ from NBI_TASK nbitask0_, NBI_INTEGRATION_RULE integratio1_ where nbitask0_.INT_RULE_ID_=integratio1_.ID_ and integratio1_.STOP_=0 and nbitask0_.EXCUTED_=0 and nbitask0_.EXCUTED_WITH_FAULT_=0
8buwz935md4tm	select jobid, ts, transacted, scheduled, details from ODE_JOB where nodeid = :1 and ts < :2 order by ts
8jtnr6cma1t3y	SELECT TRIM(NVL(MAX(A.CSZ), 0)) FROM XTCS A WHERE UPPER(TRIM(A.CSMC))=:CSMC
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
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 )
9qgtwh66xg6nz	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9y7s2afnkqs9d	delete from idl_ub2$ where obj#=:1 and part=:2
a37gqn1h2uah8	select nvl(spare3, 0), property, flags, nvl(spare5, 'N') from tab$ where obj# = :1
aq4js2gkfjru8	update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2
as3uq6ggb3gx6	delete from hist_head$ where obj# = :1
av0kjjbhc642q	delete from objauth$ where obj#=:1
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b8t4pnddvjst3	select * from ( select nbitask0_.ID_ as ID1_16_, nbitask0_.OBJ_VERSION_ as OBJ2_16_, nbitask0_.TYPE_ as TYPE3_16_, nbitask0_.EXCUTE_TIMES_ as EXCUTE4_16_, nbitask0_.CONTENT_ as CONTENT5_16_, nbitask0_.MAPPING_TYPE_ as MAPPING6_16_, nbitask0_.OBJECT_ as OBJECT7_16_, nbitask0_.INT_RULE_ID_ as INT8_16_, nbitask0_.LAST_ACCESS_TIME_ as LAST9_16_, nbitask0_.CREATED_TIME_ as CREATED10_16_, nbitask0_.EXCUTED_ as EXCUTED11_16_, nbitask0_.EXCUTED_WITH_FAULT_ as EXCUTED12_16_ from NBI_TASK nbitask0_ where nbitask0_.EXCUTED_=1 or nbitask0_.EXCUTED_WITH_FAULT_=1 and nbitask0_.CREATED_TIME_<=:1 ) where rownum <= :2
c6j034dcffqaq	select nbitask0_.ID_ as ID1_16_, nbitask0_.OBJ_VERSION_ as OBJ2_16_, nbitask0_.TYPE_ as TYPE3_16_, nbitask0_.CONTENT_ as CONTENT4_16_, nbitask0_.MAPPING_TYPE_ as MAPPING5_16_, nbitask0_.OBJECT_ as OBJECT6_16_, nbitask0_.INT_RULE_ID_ as INT7_16_, nbitask0_.LAST_ACCESS_TIME_ as LAST8_16_, nbitask0_.CREATED_TIME_ as CREATED9_16_, nbitask0_.EXCUTED_ as EXCUTED10_16_ from NBI_TASK nbitask0_, NBI_INTEGRATION_RULE integratio1_ where nbitask0_.INT_RULE_ID_=integratio1_.ID_ and integratio1_.STOP_=0 and nbitask0_.EXCUTED_=0
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
d5jd9b2xct7xz	delete from idl_char$ where obj#=:1 and part=:2
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;
dvpfc386d6dmm	delete from idl_sb4$ where obj#=:1 and part=:2
f3g84j69n0tjh	select col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc
ftf0qy4kwpk62	insert into NBI_LOG_EVENT (TIME_, TYPE_, MSG_, STATUS_, INTRULE_ID_, INTRULE_NAME_, DATA_, HANDLED_, ID_) values (:1, :2, :3, :4, :5, :6, :7, :8, :9)
fudsnu0u8fuhj	select * from xtclusterlock where clustername='GRIS_CLUSTER' and objkind='MessagePlatform'
gsqxm6zz3w2by	delete from idl_ub1$ where obj#=:1 and part=:2

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	316,185	86.55	81.49
CPU used when call started	15,541	4.25	4.01
CR blocks created	6,968	1.91	1.80
Cached Commit SCN referenced	52	0.01	0.01
Commit SCN cached	1	0.00	0.00
DB time	11,632,562	3,184.09	2,998.08
DBWR checkpoint buffers written	2,015	0.55	0.52
DBWR checkpoints	1,080	0.30	0.28
DBWR fusion writes	168	0.05	0.04
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	39	0.01	0.01
DBWR undo block writes	513	0.14	0.13
DFO trees parallelized	18	0.00	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	75	0.02	0.02
PX local messages sent	75	0.02	0.02
PX remote messages recv'd	63	0.02	0.02
PX remote messages sent	75	0.02	0.02
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	18	0.00	0.00
RowCR - row contention	66	0.02	0.02
RowCR attempts	975	0.27	0.25
RowCR hits	909	0.25	0.23
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	8,340	2.28	2.15
active txn count during cleanout	621	0.17	0.16
application wait time	103	0.03	0.03
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	10,343	2.83	2.67
branch node splits	0	0.00	0.00
buffer is not pinned count	260,575	71.33	67.16
buffer is pinned count	226,375	61.96	58.34
bytes received via SQL*Net from client	1,168,257	319.78	301.10
bytes sent via SQL*Net to client	929,974	254.55	239.68
calls to get snapshot scn: kcmgss	121,408	33.23	31.29
calls to kcmgas	25,352	6.94	6.53
calls to kcmgcs	1,172	0.32	0.30
change write time	529	0.14	0.14
cleanout - number of ktugct calls	665	0.18	0.17
cleanouts and rollbacks - consistent read gets	536	0.15	0.14
cleanouts only - consistent read gets	39	0.01	0.01
cluster key scan block gets	54,596	14.94	14.07
cluster key scans	33,057	9.05	8.52
cluster wait time	58,478	16.01	15.07
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	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	6	0.00	0.00
commit cleanout failures: cannot pin	7	0.00	0.00
commit cleanouts	14,209	3.89	3.66
commit cleanouts successfully completed	14,196	3.89	3.66
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	108	0.03	0.03
concurrency wait time	12,600,127	3,448.93	3,247.46
consistent changes	7,612	2.08	1.96
consistent gets	626,293	171.43	161.42
consistent gets - examination	287,401	78.67	74.07
consistent gets direct	0	0.00	0.00
consistent gets from cache	626,295	171.43	161.42
current blocks converted for CR	0	0.00	0.00
cursor authentications	1,416	0.39	0.36
data blocks consistent reads - undo records applied	7,589	2.08	1.96
db block changes	87,253	23.88	22.49
db block gets	90,658	24.82	23.37
db block gets direct	83	0.02	0.02
db block gets from cache	90,572	24.79	23.34
deferred (CURRENT) block cleanout applications	4,421	1.21	1.14
dirty buffers inspected	0	0.00	0.00
enqueue conversions	5,645	1.55	1.45
enqueue deadlocks	0	0.00	0.00
enqueue releases	68,807	18.83	17.73
enqueue requests	68,842	18.84	17.74
enqueue timeouts	35	0.01	0.01
enqueue waits	5,970	1.63	1.54
exchange deadlocks	5	0.00	0.00
execute count	113,725	31.13	29.31
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	12,753	3.49	3.29
gc CPU used by this session	1,111	0.30	0.29
gc blocks lost	0	0.00	0.00
gc cr block build time	7	0.00	0.00
gc cr block flush time	1	0.00	0.00
gc cr block receive time	152	0.04	0.04
gc cr block send time	38	0.01	0.01
gc cr blocks received	2,421	0.66	0.62
gc cr blocks served	7,372	2.02	1.90
gc current block flush time	1	0.00	0.00
gc current block pin time	28	0.01	0.01
gc current block receive time	38	0.01	0.01
gc current block send time	17	0.00	0.00
gc current blocks received	731	0.20	0.19
gc current blocks served	3,282	0.90	0.85
gc local grants	996	0.27	0.26
gc remote grants	1,545	0.42	0.40
gcs messages sent	22,377	6.13	5.77
ges messages sent	685,226	187.56	176.60
global enqueue get time	182,288	49.90	46.98
global enqueue gets async	30,042	8.22	7.74
global enqueue gets sync	97,222	26.61	25.06
global enqueue releases	1,097,087	300.30	282.75
heap block compress	34	0.01	0.01
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	575	0.16	0.15
immediate (CURRENT) block cleanout applications	269	0.07	0.07
index crx upgrade (found)	4	0.00	0.00
index crx upgrade (positioned)	22,568	6.18	5.82
index fast full scans (full)	0	0.00	0.00
index fetch by key	112,272	30.73	28.94
index scans kdiixs1	95,094	26.03	24.51
leaf node 90-10 splits	22	0.01	0.01
leaf node splits	26	0.01	0.01
lob reads	263	0.07	0.07
lob writes	125	0.03	0.03
lob writes unaligned	125	0.03	0.03
logons cumulative	142	0.04	0.04
messages received	61,693	16.89	15.90
messages sent	61,693	16.89	15.90
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	299,473	81.97	77.18
opened cursors cumulative	90,003	24.64	23.20
parse count (failures)	15	0.00	0.00
parse count (hard)	2,065	0.57	0.53
parse count (total)	96,865	26.51	24.97
parse time cpu	18,353	5.02	4.73
parse time elapsed	11,959,248	3,273.51	3,082.28
physical read IO requests	2,218	0.61	0.57
physical read bytes	36,405,248	9,964.92	9,382.80
physical read total IO requests	23,577	6.45	6.08
physical read total bytes	386,351,104	105,752.79	99,575.03
physical read total multi block requests	1	0.00	0.00
physical reads	2,222	0.61	0.57
physical reads cache	2,222	0.61	0.57
physical reads cache prefetch	4	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	2,675	0.73	0.69
physical write bytes	54,362,112	14,880.10	14,010.85
physical write total IO requests	23,931	6.55	6.17
physical write total bytes	149,657,600	40,964.57	38,571.55
physical write total multi block requests	10,311	2.82	2.66
physical writes	3,318	0.91	0.86
physical writes direct	83	0.02	0.02
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	3,235	0.89	0.83
physical writes non checkpoint	1,708	0.47	0.44
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	3,598	0.98	0.93
queries parallelized	18	0.00	0.00
recursive calls	911,995	249.63	235.05
recursive cpu usage	42,174	11.54	10.87
redo blocks written	37,430	10.25	9.65
redo buffer allocation retries	0	0.00	0.00
redo entries	53,024	14.51	13.67
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	424	0.12	0.11
redo size	15,616,992	4,274.71	4,025.00
redo subscn max counts	536	0.15	0.14
redo synch time	23	0.01	0.01
redo synch writes	227	0.06	0.06
redo wastage	2,646,756	724.48	682.15
redo write time	727	0.20	0.19
redo writer latching time	1	0.00	0.00
redo writes	8,883	2.43	2.29
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	6,415	1.76	1.65
rows fetched via callback	30,584	8.37	7.88
session connect time	0	0.00	0.00
session cursor cache hits	28,874	7.90	7.44
session logical reads	716,951	196.25	184.78
session pga memory	105,863,984	28,977.30	27,284.53
session pga memory max	9,903,005,808	2,710,670.34	2,552,321.08
session uga memory	###############	82,294,504.83	77,487,105.89
session uga memory max	127,469,384	34,891.17	32,852.93
shared hash latch upgrades - no wait	23,793	6.51	6.13
shared hash latch upgrades - wait	4	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	39,566	10.83	10.20
sorts (rows)	858,912	235.10	221.37
sql area evicted	19,007	5.20	4.90
sql area purged	16	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	240	0.07	0.06
table fetch by rowid	91,015	24.91	23.46
table fetch continued row	116	0.03	0.03
table scan blocks gotten	109,693	30.03	28.27
table scan rows gotten	9,969,367	2,728.83	2,569.42
table scans (long tables)	0	0.00	0.00
table scans (short tables)	2,683	0.73	0.69
total number of times SMON posted	1,082	0.30	0.28
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	6,376,864	1,745.49	1,643.52
user I/O wait time	1,020	0.28	0.26
user calls	10,467	2.87	2.70
user commits	222	0.06	0.06
user rollbacks	3,658	1.00	0.94
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	4,192	1.15	1.08
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	3,028,582	3,027,696
opened cursors current	245	255
workarea memory allocated	12,098	10,365
logons current	59	58

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
FMIS0400	2,136	1	4.39	1.00	1,161	10	2.00
SYSTEM	57	0	7.54	1.00	1,101	23	2.17
SYSAUX	32	0	7.81	1.13	277	0	0.00
UNDOTBS2	0	0	0.00	0.00	115	0	0.00
CWGK_IMS	0	0	0.00	0.00	21	6	1.67
NBI	0	0	0.00	0.00	6	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
CWGK_IMS	/dev/rlv_vpd_CWGK_IMS	0			21	6	1.67
FMIS0400	/dev/rlv_VPD0400_20	0			3	0	0.00
FMIS0400	/dev/rlv_VPD0400_21	1	10.00	1.00	3	0	0.00
FMIS0400	/dev/rlv_VPD0400_22	4	2.50	1.00	6	0	0.00
FMIS0400	/dev/rlv_VPD0400_23	146	4.59	1.00	74	0	0.00
FMIS0400	/dev/rlv_VPD0400_24	19	6.84	1.00	21	0	0.00
FMIS0400	/dev/rlv_VPD0400_25	1	0.00	1.00	5	0	0.00
FMIS0400	/dev/rlv_VPD0400_26	13	4.62	1.00	9	0	0.00
FMIS0400	/dev/rlv_VPD0400_27	3	6.67	1.00	6	0	0.00
FMIS0400	/dev/rlv_VPD0400_28	0			2	0	0.00
FMIS0400	/dev/rlv_vpd0400_01	21	7.14	1.00	22	6	1.67
FMIS0400	/dev/rlv_vpd0400_02	3	6.67	1.00	4	4	2.50
FMIS0400	/dev/rlv_vpd0400_03	3	3.33	1.00	3	0	0.00
FMIS0400	/dev/rlv_vpd0400_04	28	7.86	1.00	31	0	0.00
FMIS0400	/dev/rlv_vpd0400_05	7	7.14	1.00	6	0	0.00
FMIS0400	/dev/rlv_vpd0400_06	10	5.00	1.00	9	0	0.00
FMIS0400	/dev/rlv_vpd0400_07	12	9.17	1.00	10	0	0.00
FMIS0400	/dev/rlv_vpd0400_08	21	5.24	1.00	13	0	0.00
FMIS0400	/dev/rlv_vpd0400_09	22	4.09	1.00	15	0	0.00
FMIS0400	/dev/rlv_vpd0400_10	5	6.00	1.00	5	0	0.00
FMIS0400	/dev/rlv_vpd0400_11	29	4.83	1.00	18	0	0.00
FMIS0400	/dev/rlv_vpd0400_12	35	4.57	1.00	24	0	0.00
FMIS0400	/dev/rlv_vpd0400_13	74	4.46	1.00	39	0	0.00
FMIS0400	/dev/rlv_vpd0400_14	6	1.67	1.00	3	0	0.00
FMIS0400	/dev/rlv_vpd0400_15	5	2.00	1.00	3	0	0.00
FMIS0400	/dev/rlv_vpd0400_16	336	4.26	1.00	171	0	0.00
FMIS0400	/dev/rlv_vpd0400_17	22	4.55	1.00	16	0	0.00
FMIS0400	/dev/rlv_vpd0400_18	284	4.33	1.00	140	0	0.00
FMIS0400	/dev/rlv_vpd0400_19	1,026	4.11	1.00	500	0	0.00
NBI	/dev/rlv_vpd_nbi	0			5	0	0.00
NBI	/dev/rlv_vpd_nbi02	0			1	0	0.00
SYSAUX	/dev/rlv_vpdsysaux01	32	7.81	1.13	277	0	0.00
SYSTEM	/dev/rlv_vpdsystem01	29	7.59	1.00	585	17	2.94
SYSTEM	/dev/rlv_vpdsystem02	28	7.50	1.00	516	6	0.00
UNDOTBS2	/dev/rlv_vpdundo2_1	0			49	0	0.00
UNDOTBS2	/dev/rlv_vpdundo2_2	0			11	0	0.00
UNDOTBS2	/dev/rlv_vpdundo2_3	0			34	0	0.00
UNDOTBS2	/dev/rlv_vpdundo2_4	0			21	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	506,880	100	714,361	2,222	3,235	54
K	24,750		0	0	0	0
R	24,750	100	2	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	10	1009	18450	90872	2764800	90872
E	0	2	540	6188	6028	2764800	6028

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	816	0.10	50,490	1.28	64,069,390
D	1,632	0.20	100,980	1.11	55,861,038
D	2,448	0.30	151,470	1.07	53,699,612
D	3,264	0.40	201,960	1.05	52,621,505
D	4,080	0.50	252,450	1.03	51,776,141
D	4,896	0.60	302,940	1.02	51,339,987
D	5,712	0.70	353,430	1.01	50,888,106
D	6,528	0.80	403,920	1.01	50,585,265
D	7,344	0.90	454,410	1.00	50,309,676
D	8,160	1.00	504,900	1.00	50,150,546
D	8,192	1.00	506,880	1.00	50,145,787
D	8,976	1.10	555,390	1.00	50,058,732
D	9,792	1.20	605,880	0.99	49,633,926
D	10,608	1.29	656,370	0.98	49,335,113
D	11,424	1.39	706,860	0.98	49,125,126
D	12,240	1.49	757,350	0.98	48,956,888
D	13,056	1.59	807,840	0.97	48,812,973
D	13,872	1.69	858,330	0.97	48,559,027
D	14,688	1.79	908,820	0.97	48,403,235
D	15,504	1.89	959,310	0.96	48,257,153
D	16,320	1.99	1,009,800	0.94	47,049,774

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	1,958	1,542	812.41	11.81	1.45	100.00	0.00	200,490
E	1,958	1,542	668.10	10.12	1.52	100.00	0.00	200,490

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	4,057	4,057
64K	128K	13	13
512K	1024K	71	71
1M	2M	17	17
2M	4M	6	6
4M	8M	3	3

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
245	0.13	492,290.38	54,833.50	90.00	1,567
490	0.25	492,290.38	5,462.31	99.00	2
979	0.50	492,290.38	4,563.47	99.00	0
1,469	0.75	492,290.38	4,563.47	99.00	0
1,958	1.00	492,290.38	4,563.47	99.00	0
2,350	1.20	492,290.38	2,818.42	99.00	0
2,741	1.40	492,290.38	2,818.42	99.00	0
3,133	1.60	492,290.38	2,818.42	99.00	0
3,524	1.80	492,290.38	2,818.42	99.00	0
3,916	2.00	492,290.38	2,818.42	99.00	0
5,874	3.00	492,290.38	2,818.42	99.00	0
7,832	4.00	492,290.38	2,818.42	99.00	0
11,748	6.00	492,290.38	2,818.42	99.00	0
15,664	8.00	492,290.38	2,818.42	99.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
1,600	0.39	14	3,260	304,573,993	1.00	854,805	2.29	417,514,181
2,016	0.49	14	3,260	304,881,469	1.00	547,329	1.47	417,607,684
2,432	0.59	14	3,261	304,960,694	1.00	468,104	1.25	417,642,929
2,848	0.70	14	3,261	305,003,364	1.00	425,434	1.14	417,659,359
3,264	0.80	14	3,265	305,024,354	1.00	404,444	1.08	417,664,482
3,680	0.90	14	3,265	305,039,755	1.00	389,043	1.04	417,667,875
4,096	1.00	14	3,268	305,055,454	1.00	373,344	1.00	417,671,085
4,512	1.10	14	3,268	305,061,540	1.00	367,258	0.98	417,673,218
4,928	1.20	14	3,268	305,064,961	1.00	363,837	0.97	417,675,168
5,344	1.30	14	3,268	305,069,672	1.00	359,126	0.96	417,683,915
5,760	1.41	14	3,268	305,071,510	1.00	357,288	0.96	417,688,712
6,176	1.51	14	3,269	305,079,677	1.00	349,121	0.94	417,690,460
6,592	1.61	14	3,290	305,079,728	1.00	349,070	0.94	417,691,604
7,008	1.71	14	3,312	305,081,394	1.00	347,404	0.93	417,693,102
7,424	1.81	14	3,312	305,082,228	1.00	346,570	0.93	417,694,092
7,840	1.91	14	3,312	305,083,685	1.00	345,113	0.92	417,695,158
8,256	2.02	14	3,312	305,083,769	1.00	345,029	0.92	417,697,819

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	Total Wait Time (s)	Avg Time (ms)
data block	54	0	3

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
CF-Controlfile Transaction	6,547	6,524	23	110	1,833	16,659.65
RO-Multiple Object Reuse (fast object reuse)	9,720	9,720	0	2,160	1	0.43
TS-Temporary Segment	1,081	1,081	0	1,081	1	0.80
IR-Instance Recovery	2,161	2,161	0	1,033	1	0.62
TM-DML	38,472	38,472	0	863	1	0.66
MD-Materialized View Log DDL	1,072	1,072	0	549	0	0.81
SQ-Sequence Cache	29	29	0	1	0	128.00
HW-Segment High Water Mark	207	207	0	104	0	1.15
PR-Process Startup	12	12	0	1	0	54.00
TT-Tablespace	1,175	1,175	0	20	0	1.65
PS-PX Process Reservation	121	121	0	35	0	0.77
WF-AWR Flush	22	22	0	10	0	0.90
FB-Format Block	7	7	0	6	0	1.00
TA-Instance Undo	5	5	0	5	0	1.00
AF-Advisor Framework (task serialization)	7	7	0	1	0	1.00
JQ-Job Queue	82	72	10	1	0	1.00
PI-Remote PX Process Spawn Status	3	3	0	1	0	1.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.72	6,638	2,480	7	0/56.3333333333333333333333333333333333333	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
02-3月 04:08	337	2,922	275	5	20	0/0	0/0/0/0/0/0
02-3月 03:58	1	25	0	7	18	0/0	0/0/0/0/0/0
02-3月 03:48	0	2	0	0	24	0/0	0/0/0/0/0/0
02-3月 03:38	0	0	0	0	15	0/0	0/0/0/0/0/0
02-3月 03:28	0	0	0	0	0	0/0	0/0/0/0/0/0
02-3月 03:18	16	196	0	2	16	0/0	0/0/0/0/0/0
02-3月 03:08	364	3,493	2,480	3	56	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	8,861	0.00		0	0
ASM network background latch	2	0.00		0	0
AWR Alerted Metric Element list	14,616	0.00		0	0
Consistent RBA	8,884	0.00		0	0
FAL request queue	55	0.00		0	0
FAL subheap alocation	55	0.00		0	0
FOB s.o list latch	379	0.00		0	0
JS broadcast add buf latch	194	0.00		0	0
JS broadcast drop buf latch	194	0.00		0	0
JS broadcast load blnc latch	169	0.00		0	0
JS queue state obj latch	6,084	0.00		0	0
JS slv state obj latch	6	0.00		0	0
KCL gc element parent latch	42,318	0.11	0.00	0	669	0.00
KJC message pool free list	151,874	0.20	0.00	0	5,724	0.44
KJCT flow control latch	354,703	0.28	0.00	0	0
KMG MMAN ready and startup request latch	1,217	0.00		0	0
KTF sga latch	8	0.00		0	1,194	0.00
KWQMN job cache list latch	291	0.00		0	0
KWQP Prop Status	2	0.00		0	0
MQL Tracking Latch	0			0	52	0.00
Memory Management Latch	0			0	1,217	0.00
OS process	231	0.00		0	0
OS process allocation	1,370	0.00		0	0
OS process: request allocation	105	0.00		0	0
PL/SQL warning settings	4,708	0.00		0	0
SGA IO buffer pool latch	1	0.00		0	1	0.00
SQL memory manager latch	1	0.00		0	1,119	0.00
SQL memory manager workarea list latch	90,896	0.00		0	0
Shared B-Tree	123	0.00		0	0
active checkpoint queue latch	22,499	3.08	0.00	0	0
active service list	2,925	0.07	0.00	0	1,240	0.00
archive control	58	0.00		0	0
archive process latch	1,229	0.00		0	0
begin backup scn array	7	0.00		0	0
business card	36	0.00		0	0
cache buffer handles	136	0.00		0	0
cache buffers chains	1,394,204	0.08	0.00	0	20,327	0.00
cache buffers lru chain	48,251	0.00		0	29,913	0.00
cache table scan latch	0			0	1	0.00
channel handle pool latch	2,248	0.00		0	0
channel operations parent latch	1,720,505	0.04	0.00	0	0
checkpoint queue latch	389,234	0.00	0.00	0	3,048	0.00
client/application info	646	0.00		0	0
commit callback allocation	2,152	0.00		0	0
compile environment latch	143	0.00		0	0
dictionary lookup	4	0.00		0	0
dml lock allocation	76,967	0.00	0.00	0	0
dummy allocation	287	0.00		0	0
enqueue hash chains	246,888	0.00	0.00	0	1,563	0.00
enqueues	57,352	0.03	0.00	0	0
error message lists	84	0.00		0	0
event group latch	52	0.00		0	0
file cache latch	2,031	0.00		0	0
gcs opaque info freelist	3,882	0.00		0	0
gcs partitioned table hash	54,933	0.00		0	0
gcs remaster request queue	3,240	0.00		0	0
gcs remastering latch	2,691	0.00		0	0
gcs resource freelist	1,692	0.00		0	241	0.00
gcs resource hash	31,703	0.04	0.00	0	0
gcs shadows freelist	1,243	0.00		0	1,730	0.00
ges caches resource lists	1,305,499	0.14	2.56	1306	1,271,997	0.11
ges deadlock list	7,306	0.00		0	4	0.00
ges domain table	133,460	0.00		0	0
ges enqueue table freelist	204,633	0.00	0.00	0	0
ges group table	202,255	0.00		0	0
ges process hash list	24,328	0.00		0	0
ges process parent latch	1,486,292	0.00	0.02	0	355,631	0.03
ges process table freelist	105	0.00		0	0
ges resource hash list	1,493,895	0.23	0.94	0	1,423,237	0.00
ges resource scan list	4,316	0.00		0	0
ges resource table freelist	1,090,964	0.01	17.82	682	220	29.09
ges timeout list	19,900	0.01	0.00	0	19,343	0.00
global KZLD latch for mem in SGA	38	0.00		0	0
global ctx hash table latch	216	0.00		0	0
hash table column usage latch	105	0.95	0.00	0	62,992	0.00
hash table modification latch	78	0.00		0	0
job workq parent latch	0			0	144	2.08
job_queue_processes parameter latch	64	0.00		0	0
kks stats	37,447	2.99	0.11	0	0
kokc descriptor allocation latch	10	0.00		0	0
ksuosstats global area	165	0.00		0	0
ktm global data	1,087	0.00		0	0
kwqbsn:qsga	122	0.00		0	0
lgwr LWN SCN	9,419	0.00		0	0
library cache	2,469,187	2.92	0.57	196	716,345,437	0.00
library cache load lock	8,449	0.02	0.00	0	3,840	0.00
library cache lock	566,485	0.02	0.01	0	0
library cache lock allocation	1,153	0.00		0	0
library cache pin	144,214	0.03	0.00	0	4	0.00
library cache pin allocation	965	0.00		0	0
list of block allocation	251	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	8,554	0.00		0	0
messages	316,183	0.31	0.00	0	0
mostly latch-free SCN	9,426	0.08	0.00	0	0
multiblock read objects	668	0.00		0	0
name-service memory objects	2,507	0.00		0	0
name-service namespace bucket	27,823	0.00		0	0
name-service namespace objects	2	0.00		0	0
name-service pending queue	478	0.00		0	0
name-service request	6	0.00		0	0
name-service request queue	26,907	0.00		0	0
ncodef allocation latch	59	0.00		0	0
object queue header heap	2,408	0.00		0	2,235	0.00
object queue header operation	62,221	0.00	0.00	0	0
object stats modification	3	0.00		0	0
parallel query alloc buffer	806	0.00		0	0
parallel query stats	75	0.00		0	0
parallel txn reco latch	1,362	0.00		0	0
parameter list	21	0.00		0	0
parameter table allocation management	190	0.00		0	0
post/wait queue	2,105	0.14	0.00	0	1,350	0.00
process allocation	26,379	0.00		0	52	0.00
process group creation	105	0.00		0	0
process queue	194	0.00		0	0
process queue reference	2,930	0.00		0	300	0.00
qmn state object latch	11	0.00		0	0
qmn task queue latch	516	0.78	0.00	0	0
query server freelists	164	0.00		0	0
query server process	1	0.00		0	1	0.00
queued dump request	15,155	0.00		0	0
redo allocation	27,719	0.00		0	53,061	0.01
redo copy	0			0	53,064	0.14
redo writing	43,615	0.56	0.00	0	0
resmgr group change latch	141	0.00		0	0
resmgr:active threads	271	0.00		0	0
resmgr:actses change group	129	0.00		0	0
resmgr:free threads list	270	0.74	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	1,058,552	3.25	0.13	266	2,873,704	0.97
rules engine aggregate statistics	4	0.00		0	0
rules engine rule set statistics	108	0.00		0	0
sequence cache	1,699	0.06	0.00	0	0
session allocation	1,681,712	0.74	0.00	0	0
session idle bit	26,545	0.00	0.00	0	0
session state list latch	301	1.33	0.00	0	0
session switching	59	0.00		0	0
session timer	1,240	0.00		0	0
shared pool	1,366,131	5.08	0.76	5142	0
shared pool sim alloc	46	0.00		0	0
shared pool simulator	6,799,930,869	0.00	0.00	0	0
simulator hash latch	44,828	0.00		0	0
simulator lru latch	0			0	44,694	0.11
slave class	8	0.00		0	0
slave class create	33	9.09	154.00	133	0
sort extent pool	1,164	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
threshold alerts latch	303	0.00		0	0
transaction allocation	11,885	0.00		0	0
transaction branch allocation	1,240	0.00		0	0
undo global data	23,088	0.00		0	2	0.00
user lock	396	1.26	0.80	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
library cache	2,469,187	72,174	41,143	51,901
shared pool	1,366,131	69,419	53,086	28,944
row cache objects	1,058,552	34,446	4,315	32,173
session allocation	1,681,712	12,494	8	12,486
ges resource hash list	1,493,895	3,443	3,223	222
ges caches resource lists	1,305,499	1,805	4,627	1,702
kks stats	37,447	1,120	127	1,005
cache buffers chains	1,394,204	1,050	4	1,046
ges resource table freelist	1,090,964	138	2,459	68
library cache lock	566,485	112	1	111
ges process parent latch	1,486,292	59	1	58
user lock	396	5	4	1
slave class create	33	3	462	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	kcbo_write_process	16	16
cache buffers chains	kcbgtcr: kslbegin excl	6	4
cache buffers chains	kcbgtcr: fast path	1	0
cache buffers chains	kcbrls: kslbegin	1	2
cache buffers chains	kcbzwb	1	0
cost function	kzulgt: find user res	3	3
cost function	kzulrl	1	1
ges process parent latch	kjpdmc	1	0
ges resource hash list	kjakcai: search for resp by resname	1,464	1
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	1,400	0
ges resource hash list	kjrmas1: lookup master node	312	0
ges resource hash list	kjrref: find matched resource	26	71
ges resource hash list	kjucvl: lock convert request	13	366
ges resource hash list	kjcvscn: remove from scan queue	7	0
ges resource table freelist	kjruch: cached obj cleanup	4,571	0
ges resource table freelist	kjrfr: remove from resource table	2,457	1
ges resource table freelist	kjrchc: cached obj cleanup	30	0
ges resource table freelist	kjrm2c: move resource to cache	26	4,627
ges resource table freelist	kjralc: resource allocation	2	2,381
kks stats	kks stats alloc/free	127	127
library cache	kqlmbfre: child: in loop	4,765	2,947
library cache	kqlmbfre: child: no obj to free	3,812	29,012
library cache	kglpndl: child: before processing	262	30
library cache	kgldti: 2child	55	13
library cache	kglukp: child	48	38
library cache	kglpndl: child: after processing	18	0
library cache	kglLockCursor	11	0
library cache	kgldte: child 0	10	322
library cache	kglobpn: child:	10	227
library cache	kglati	4	0
library cache	kglhdgn: child:	3	194
library cache	kglScanDependency	2	0
library cache	kglpin	2	3
library cache	kglhdunp: parent: flush	1	0
library cache lock	kgllkdl: child: no lock handle	146	44
library cache lock	kgllkal: child: multiinstance	1	0
row cache objects	kqrbip	3,882	153
row cache objects	kqreqd	56	2
row cache objects	kqrpre: find obj	34	111
row cache objects	kqrigt	29	2,817
row cache objects	kqreqd: reget	15	4
row cache objects	kqrso	10	9
row cache objects	ksucallcbksafely: kqrhngc	7	0
row cache objects	kqrbtm: pop parent	6	24
row cache objects	kqrbgl	4	3
row cache objects	kqrbfr	1	6
session allocation	ksudlc	4	3
session allocation	ksuprc	4	5
shared pool	kghfrunp: alloc: wait	50,891	1
shared pool	kghfrunp: clatch: nowait	31,627	0
shared pool	kghfre	1,097	41,192
shared pool	kghfrunp: clatch: wait	638	9,523
shared pool	kghdmp	631	0
shared pool	kghupr1	311	6,850
shared pool	kghalo	128	4,919
shared pool	kghalp	12	105
shared pool	kghasp	7	19
shared pool	kghfrh	6	0
shared pool	kghfsh	3	0
slave class create	ksvcreate	462	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: 716,951
Captured Segments account for 83.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_OBJ2	INDEX	60,240	8.40
SYS	SYSTEM	TAB$	TABLE	39,904	5.57
SYS	SYSTEM	I_OBJ#	INDEX	37,248	5.20
SYS	SYSTEM	IND$	TABLE	36,784	5.13
SYS	SYSTEM	I_IND1	INDEX	34,688	4.84

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 2,222
Captured Segments account for 2.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	HISTGRM$		TABLE	19	0.86
SYS	SYSTEM	IDL_UB1$		TABLE	6	0.27
SYS	SYSAUX	WRH$_LOG_PK		INDEX	6	0.27
SYS	SYSTEM	I_COL1		INDEX	5	0.23
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	7179_12879	TABLE PARTITION	5	0.23

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	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	I_AUD1	INDEX	6	60.00
SYS	SYSTEM	AUD$	TABLE	3	30.00
SYS	SYSTEM	JOB$	TABLE	1	10.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

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

Owner	Tablespace Name	Object Name	Obj. Type	GC Buffer Busy	% of Capture
FMIS0400	FMISINDEX	IDU060712193340934	INDEX	11	26.19
CWGK_IMS	CWGK_IMS	NBI_LOG_EVENT	TABLE	6	14.29
SYS	SYSTEM	OBJ$	TABLE	5	11.90
FMIS0400	FMIS0400	XTCLUSTERLOCK	TABLE	4	9.52
FMIS0400	FMIS0400	XTCLUSTERUSER	TABLE	4	9.52

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 2,421
Captured Segments account for 70.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	OBJ$	TABLE	693	28.62
SYS	SYSTEM	I_OBJ2	INDEX	170	7.02
SYS	SYSTEM	USER$	TABLE	157	6.48
SYS	SYSTEM	SEG$	TABLE	117	4.83
SYS	SYSTEM	TAB$	TABLE	83	3.43

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 731
Captured Segments account for 66.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSTEM	SEG$	TABLE	58	7.93
SYS	SYSTEM	TSQ$	TABLE	54	7.39
SYS	SYSTEM	HISTGRM$	TABLE	43	5.88
SYS	SYSTEM	OBJ$	TABLE	42	5.75
SYS	SYSTEM	I_OBJ2	INDEX	32	4.38

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	19	10.53	1	1
dc_constraints	61	100.00	61	0
dc_database_links	80	1.25	0	1
dc_files	132	0.00	0	0
dc_global_oids	49	34.69	0	16
dc_histogram_data	8,116	19.26	0	1,223
dc_histogram_defs	10,518	71.79	6	1,856
dc_object_grants	52	30.77	0	16
dc_object_ids	9,149	18.24	2	530
dc_objects	12,695	12.79	1,202	499
dc_profiles	108	1.85	0	1
dc_rollback_segments	3,562	0.00	0	230
dc_segments	6,446	23.91	3,246	457
dc_sequences	49	18.37	48	6
dc_table_scns	1,071	100.00	0	0
dc_tablespace_quotas	1,081	0.65	1,081	1
dc_tablespaces	15,484	0.16	0	23
dc_usernames	6,884	0.20	0	13
dc_users	31,717	0.07	0	31
outstanding_alerts	147	65.31	4	6

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	4	1	1
dc_constraints	61	0	0
dc_database_links	1	0	1
dc_global_oids	17	0	19
dc_histogram_defs	7,557	0	465,350
dc_object_ids	2,750	3,810	5,704
dc_objects	2,944	3,810	39,102
dc_profiles	2	0	2
dc_segments	5,988	4	2,305
dc_sequences	96	3	4
dc_table_scns	1,071	0	0
dc_tablespace_quotas	2,162	7	4
dc_tablespaces	25	0	25
dc_usernames	14	0	41
dc_users	13	0	37
outstanding_alerts	284	88	4

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	17	17.65	5,069	0.06	0	0
CLUSTER	83	3.61	249	1.20	0	0
INDEX	18	94.44	29	58.62	0	0
SQL AREA	77,542	2.17	261,120	1.84	1,120	747
TABLE/PROCEDURE	2,545	57.37	41,968	7.59	185	0
TRIGGER	4,764	0.08	6,058	0.12	2	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	249	3	3	3
INDEX	29	25	58	25
TABLE/PROCEDURE	15,050	8,086	281,886	3,605

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	459.56		7.66	31.67	243	243	60	60
	Freeable	334.88	0.00	8.59	28.52	171		39	39
	SQL	16.52	15.06	0.37	1.80	12	190	45	41
	PL/SQL	1.46	0.93	0.02	0.02	0	0	60	59
E	Other	464.74		7.88	32.06	243	243	59	59
	Freeable	186.56	0.00	4.44	10.01	41		42	42
	SQL	15.46	13.64	0.36	1.59	10	190	43	40
	PL/SQL	1.34	0.88	0.02	0.02	0	0	59	58

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	160.00	160.00	0.00
large	free memory	32.00	32.00	0.00
shared	CCursor	203.86		-100.00
shared	Heap0: KGL	98.95		-100.00
shared	KGLS heap	73.54		-100.00
shared	KQR L PO	507.94		-100.00
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	677.53	2,637.76	289.32
shared	gcs resources	97.41	97.41	0.00
shared	gcs shadows	58.33	58.33	0.00
shared	ges enqueues	238.96	238.96	0.00
shared	ges resource	847.37	626.69	-26.04
shared	kglsim heap	111.37	111.54	0.16
shared	library cache	464.74		-100.00
shared	rm request queue link	86.17	86.21	0.05
shared	sql area	315.31		-100.00
shared	sql area:PLSQL	82.45		-100.00
streams	free memory	16.00	16.00	0.00
	buffer_cache	8,992.00	8,992.00	0.00
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.99	13.99	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

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

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Coordinator	99,255	0	0
QMON Slaves	3,119	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	4	0	0	7	23

Back to Streams Statistics
Back to Top

Resource Limit Stats

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

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	378,316	608,646	630378	630378
gcs_shadows	459,748	615,743	630378	630378

init.ora Parameters

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

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	5,698	1.56	1.47
acks for commit broadcast(logical)	5,762	1.58	1.49
broadcast msgs on commit(actual)	8,883	2.43	2.29
broadcast msgs on commit(logical)	8,888	2.43	2.29
broadcast msgs on commit(wasted)	518	0.14	0.13
broadcast on commit wait time(ms)	40	0.01	0.01
broadcast on commit waits	49	0.01	0.01
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	20	0.01	0.01
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	1,518	0.42	0.39
gcs ast xid	0	0.00	0.00
gcs blocked converts	809	0.22	0.21
gcs blocked cr converts	4,223	1.16	1.09
gcs compatible basts	0	0.00	0.00
gcs compatible cr basts (global)	16	0.00	0.00
gcs compatible cr basts (local)	1,223	0.33	0.32
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	157	0.04	0.04
gcs dbwr write request msgs	107	0.03	0.03
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	297	0.08	0.08
gcs immediate (null) converts	312	0.09	0.08
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	528	0.14	0.14
gcs indirect ast	346	0.09	0.09
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	14	0.00	0.00
gcs msgs process time(ms)	816	0.22	0.21
gcs msgs received	28,108	7.69	7.24
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	58	0.02	0.01
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	797	0.22	0.21
gcs side channel msgs logical	4,259	1.17	1.10
gcs stale cr	28	0.01	0.01
gcs undo cr	0	0.00	0.00
gcs write notification msgs	6	0.00	0.00
gcs writes refused	1	0.00	0.00
ges msgs process time(ms)	998,218	273.23	257.27
ges msgs received	91,624	25.08	23.61
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	4	0.00	0.00
global posts requested	4	0.00	0.00
global posts sent	4	0.00	0.00
implicit batch messages received	2,214	0.61	0.57
implicit batch messages sent	32,395	8.87	8.35
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	129,392	35.42	33.35
messages queue sent actual	121,434	33.24	31.30
messages queue sent logical	266,043	72.82	68.57
messages received actual	95,082	26.03	24.51
messages received logical	119,732	32.77	30.86
messages sent directly	19,495	5.34	5.02
messages sent indirectly	520,005	142.34	134.02
messages sent not implicit batched	89,039	24.37	22.95
messages sent pbatched	557,092	152.49	143.58
msgs causing lmd to send msgs	31,266	8.56	8.06
msgs causing lms(s) to send msgs	922	0.25	0.24
msgs received queue time (ms)	499	0.14	0.13
msgs received queued	119,732	32.77	30.86
msgs sent queue time (ms)	41,988	11.49	10.82
msgs sent queue time on ksxp (ms)	29,452	8.06	7.59
msgs sent queued	186,975	51.18	48.19
msgs sent queued on ksxp	146,729	40.16	37.82
process batch messages received	38,667	10.58	9.97
process batch messages sent	61,625	16.87	15.88

Global CR Served Stats

Statistic	Total
CR Block Requests	7,339
CURRENT Block Requests	83
Data Block Requests	7,339
Undo Block Requests	0
TX Block Requests	15
Current Results	7,408
Private results	0
Zero Results	13
Disk Read Results	0
Fail Results	0
Fairness Down Converts	1,896
Fairness Clears	0
Free GC Elements	0
Flushes	34
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	19
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	3,389	99.76	0.00	0.24
Flushes	10	70.00	30.00	0.00
Writes	168	53.57	45.83	0.60

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	1,724	83.70	16.30	0.00	631	99.37	0.63	0.00
1	undo header	494	97.17	2.83	0.00	1	100.00	0.00	0.00
1	Others	186	100.00	0.00	0.00	117	100.00	0.00	0.00
1	undo block	29	96.55	3.45	0.00	0

End of Report

% Blocks changed per Read:	12.17	Recursive Call %:	98.87
Rollback per transaction %:	94.28	Rows per Sort:	21.71

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	99.69	In-memory Sort %:	100.00
Library Hit %:	97.45	Soft Parse %:	97.87
Execute to Parse %:	14.83	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	0.15	% Non-Parse CPU:	94.65

Buffer access - local cache %:	99.25
Buffer access - remote cache %:	0.44
Buffer access - disk %:	0.31

Avg global enqueue get time (ms):	14.3
Avg global cache cr block receive time (ms):	0.6
Avg global cache current block receive time (ms):	0.5
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.1
Global cache log flushes for cr blocks served %:	0.5
Avg global cache cr block flush time (ms):	0.3
Avg global cache current block pin time (ms):	0.1
Avg global cache current block send time (ms):	0.1
Global cache log flushes for current blocks served %:	0.3
Avg global cache current block flush time (ms):	1.0

Avg message sent queue time (ms):	0.2
Avg message sent queue time on ksxp (ms):	0.2
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	10.9
% of direct sent messages:	2.91
% of indirect sent messages:	77.74
% of flow controlled messages:	19.34