WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

CYDB 4278731049 cydb1 1 26-Oct-19 04:10 11.2.0.4.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
CYDB	4278731049	cydb1	1	26-Oct-19 04:10	11.2.0.4.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

cydb01.xuwang.online Linux x86 64-bit 80 40 4 252.22

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
cydb01.xuwang.online	Linux x86 64-bit	80	40	4	252.22

Snap Id Snap Time Sessions Cursors/Session Instances

Begin Snap: 37996 16-Dec-19 14:00:26 178 2.4 2

End Snap: 37997 16-Dec-19 15:00:36 184 2.8 2

Elapsed: 60.17 (mins)

DB Time: 553.72 (mins)

通过 Sessions 和 Cursors/Session 可以初步判断并发数和每个会话的SQL数

一般说来，用 DB Time 去除以 Elapsed 时间，然后跟 CPU 数量做比较。可以衡量系统是否繁忙。

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	37996	16-Dec-19 14:00:26	178	2.4	2
End Snap:	37997	16-Dec-19 15:00:36	184	2.8	2
Elapsed:		60.17 (mins)
DB Time:		553.72 (mins)
通过 Sessions 和 Cursors/Session 可以初步判断并发数和每个会话的SQL数
一般说来，用 DB Time 去除以 Elapsed 时间，然后跟 CPU 数量做比较。可以衡量系统是否繁忙。

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 9.2 0.0 0.00 0.00

DB CPU(s): 2.6 0.0 0.00 0.00

Redo size (bytes): 3,593,001.6 2,634.7

Logical read (blocks): 161,875.8 118.7

Block changes: 16,824.0 12.3

Physical read (blocks): 7,723.3 5.7

Physical write (blocks): 380.1 0.3

Read IO requests: 689.6 0.5

Write IO requests: 115.0 0.1

Read IO (MB): 60.3 0.0

Write IO (MB): 3.0 0.0

Global Cache blocks received: 2,058.4 1.5

Global Cache blocks served: 2,031.7 1.5

User calls: 4,677.3 3.4

Parses (SQL): 751.7 0.6

Hard parses (SQL): 231.4 0.2

SQL Work Area (MB): 1.7 0.0

Logons: 1.2 0.0

Executes (SQL): 2,217.5 1.6

Rollbacks: 0.5 0.0

Transactions: 1,363.7

通过这儿的数据，可以分析出该数据库的业务类型是OLTP还是OLAP（例如每秒事务数）。这儿的数据，单独来看，无法判断出性能的好坏，需要一个基线来做对比。另外，这儿的数据也可以用来回答一些被客户经常问到的问题：每秒事务数，事务回滚数，每秒执行了多少SQL语句，一个事务包含了多少SQL语句，每秒产生的日志量，每个事务产生的平均日志量等。

通过这儿的数据，我们进一步可以分析出，在该时间跨度，数据库是在做提交非常频繁且每个事务都非常小的密集提交型操作还是提交不频繁的处理大任务事件的操作，亦或该时段 DML 很少，以查询为主。

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	9.2	0.0	0.00	0.00
DB CPU(s):	2.6	0.0	0.00	0.00
Redo size (bytes):	3,593,001.6	2,634.7
Logical read (blocks):	161,875.8	118.7
Block changes:	16,824.0	12.3
Physical read (blocks):	7,723.3	5.7
Physical write (blocks):	380.1	0.3
Read IO requests:	689.6	0.5
Write IO requests:	115.0	0.1
Read IO (MB):	60.3	0.0
Write IO (MB):	3.0	0.0
Global Cache blocks received:	2,058.4	1.5
Global Cache blocks served:	2,031.7	1.5
User calls:	4,677.3	3.4
Parses (SQL):	751.7	0.6
Hard parses (SQL):	231.4	0.2
SQL Work Area (MB):	1.7	0.0
Logons:	1.2	0.0
Executes (SQL):	2,217.5	1.6
Rollbacks:	0.5	0.0
Transactions:	1,363.7
通过这儿的数据，可以分析出该数据库的业务类型是OLTP还是OLAP（例如每秒事务数）。这儿的数据，单独来看，无法判断出性能的好坏，需要一个基线来做对比。另外，这儿的数据也可以用来回答一些被客户经常问到的问题：每秒事务数，事务回滚数，每秒执行了多少SQL语句，一个事务包含了多少SQL语句，每秒产生的日志量，每个事务产生的平均日志量等。
通过这儿的数据，我们进一步可以分析出，在该时间跨度，数据库是在做提交非常频繁且每个事务都非常小的密集提交型操作还是提交不频繁的处理大任务事件的操作，亦或该时段 DML 很少，以查询为主。

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.28 Redo NoWait %: 100.00

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

Library Hit %: 82.91 Soft Parse %: 69.22

Execute to Parse %: 66.10 Latch Hit %: 99.75

Parse CPU to Parse Elapsd %: 76.01 % Non-Parse CPU: 80.56

OLTP应该关注一下部分内容，OLAP可以忽略。

Execute to Parse 表示执行次数与解析次数的比例。理想的情况是解析一次，执行多次。

对于 OLTP 数据库来说，如果 Soft Parse 低于 95%，应当引起注意，表示存在未使用绑定变量的情况。

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		9198.9		27.7
log file sync	4,919,696	7923	2	23.8	Commit
gc buffer busy release	1,196,480	4974.5	4	15.0	Cluster
gc buffer busy acquire	2,319,056	3872	2	11.7	Cluster
gc current block busy	1,697,213	3556.9	2	10.7	Cluster
enq: TX - index contention	493,048	1198.4	2	3.6	Concurrency
gc current block 2-way	4,547,616	1187.8	0	3.6	Cluster
buffer busy waits	1,082,216	661.6	1	2.0	Concurrency
db file sequential read	795,568	324	0	1.0	User I/O
gc cr block 2-way	1,058,529	292.5	0	.9	Cluster
分析靠前的等待事件，解决之。

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
Cluster	11,958,015	14,324	1	43.1	4.0
DB CPU		9,199		27.7	2.5
Commit	4,919,698	7,923	2	23.8	2.2
System I/O	3,507,801	2,470	1	7.4	0.7
Other	6,390,890	2,261	0	6.8	0.6
Concurrency	1,810,055	1,906	1	5.7	0.5
Administrative	109,075	891	8	2.7	0.2
User I/O	1,362,059	536	0	1.6	0.1
Network	17,470,297	185	0	.6	0.1
Configuration	5,009	13	3	.0	0.0
Application	6,159	2	0	.0	0.0

Host CPU

CPUs Cores Sockets Load Average Begin Load Average End %User %System %WIO %Idle

80 40 4 2.45 4.77 3.6 2.5 0.0 93.6

从主机视角来看，CPU 资源的使用情况。

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
80	40	4	2.45	4.77	3.6	2.5	0.0	93.6
从主机视角来看，CPU 资源的使用情况。

Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

4.4 68.8 0.0

从数据库视角来看， CPU 资源的使用情况。

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
4.4	68.8	0.0
从数据库视角来看， CPU 资源的使用情况。

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 3,039.8 726.2 2,313.6

Database Requests: 804.6 689.6 115.0

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 2,198.5 6.9 2,191.6

Total (MB): 88.1 73.7 14.5

Database (MB): 63.3 60.3 3.0

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 11.4 3.8 7.6

Database (blocks): 8,103.4 7,723.3 380.1

Via Buffer Cache (blocks): 599.5 219.7 379.8

Direct (blocks): 7,503.9 7,503.6 0.3

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	3,039.8	726.2	2,313.6
Database Requests:	804.6	689.6	115.0
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	2,198.5	6.9	2,191.6
Total (MB):	88.1	73.7	14.5
Database (MB):	63.3	60.3	3.0
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	11.4	3.8	7.6
Database (blocks):	8,103.4	7,723.3	380.1
Via Buffer Cache (blocks):	599.5	219.7	379.8
Direct (blocks):	7,503.9	7,503.6	0.3

Memory Statistics

Begin End

Host Mem (MB): 258,277.0 258,277.0

SGA use (MB): 77,568.0 77,568.0

PGA use (MB): 1,662.1 1,624.7

% Host Mem used for SGA+PGA: 30.68 30.66

通过 begin 和 end 值的比较，可以初步判断内存是否抖动

	Begin	End
Host Mem (MB):	258,277.0	258,277.0
SGA use (MB):	77,568.0	77,568.0
PGA use (MB):	1,662.1	1,624.7
% Host Mem used for SGA+PGA:	30.68	30.66
通过 begin 和 end 值的比较，可以初步判断内存是否抖动

Cache Sizes

Begin End

Buffer Cache: 46,848M 46,848M Std Block Size: 8K

Shared Pool Size: 24,802M 24,803M Log Buffer: 167,468K

通过 begin 和 end 值的比较，可以初步判断内存是否抖动

	Begin	End
Buffer Cache:	46,848M	46,848M	Std Block Size:	8K
Shared Pool Size:	24,802M	24,803M	Log Buffer:	167,468K
通过 begin 和 end 值的比较，可以初步判断内存是否抖动

Shared Pool Statistics

Begin End

Memory Usage %: 81.99 81.77

% SQL with executions>1: 67.67 68.07

% Memory for SQL w/exec>1: 74.16 74.29

	Begin	End
Memory Usage %:	81.99	81.77
% SQL with executions>1:	67.67	68.07
% Memory for SQL w/exec>1:	74.16	74.29

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

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	21,586.90	64.98
DB CPU	9,198.94	27.69
parse time elapsed	2,375.76	7.15
hard parse elapsed time	1,995.24	6.01
RMAN cpu time (backup/restore)	114.27	0.34
connection management call elapsed time	23.59	0.07
sequence load elapsed time	10.24	0.03
PL/SQL execution elapsed time	4.00	0.01
repeated bind elapsed time	1.15	0.00
hard parse (sharing criteria) elapsed time	0.24	0.00
PL/SQL compilation elapsed time	0.13	0.00
failed parse elapsed time	0.04	0.00
inbound PL/SQL rpc elapsed time	0.01	0.00
hard parse (bind mismatch) elapsed time	0.01	0.00
DB time	33,222.93
background elapsed time	7,689.68
background cpu time	3,470.58

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	1,841,087
IDLE_TIME	26,763,819
IOWAIT_TIME	137
NICE_TIME	3,756
SYS_TIME	722,426
USER_TIME	1,039,503
LOAD	2	5
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	270,823,063,552
NUM_CPUS	80
NUM_CPU_CORES	40
NUM_CPU_SOCKETS	4
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
16-Dec 14:00:26	2.45
16-Dec 15:00:36	4.77	6.44	3.63	2.53	93.56	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 102.8% of Total DB time 33,222.93 (s)
Total FG Wait Time: 24,956.90 (s) DB CPU time: 9,198.94 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Cluster	11,955,132	0	14,323	1	43.11
DB CPU			9,199		27.69
Commit	4,919,696	0	7,923	2	23.85
Concurrency	1,736,544	0	1,903	1	5.73
User I/O	1,360,155	0	535	0	1.61
Other	1,516,906	86	203	0	0.61
System I/O	53,490	0	32	1	0.10
Network	14,650,970	0	23	0	0.07
Configuration	4,881	2	13	3	0.04
Application	6,118	0	2	0	0.01
Administrative	2	0	0	33	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
log file sync	4,919,696	0	7,923	2	1.00	23.85
gc buffer busy release	1,196,480	0	4,974	4	0.24	14.97
gc buffer busy acquire	2,319,056	0	3,872	2	0.47	11.65
gc current block busy	1,697,213	0	3,557	2	0.34	10.71
enq: TX - index contention	493,048	0	1,198	2	0.10	3.61
gc current block 2-way	4,547,616	0	1,188	0	0.92	3.58
buffer busy waits	1,082,216	0	662	1	0.22	1.99
db file sequential read	795,568	0	324	0	0.16	0.98
gc cr block 2-way	1,058,529	0	292	0	0.21	0.88
direct path read	521,347	0	201	0	0.11	0.60
gc current grant busy	306,522	0	143	0	0.06	0.43
gcs enter server mode	190	99	96	507	0.00	0.29
gc cr block busy	44,989	0	79	2	0.01	0.24
gc cr grant 2-way	345,245	0	74	0	0.07	0.22
gc current grant 2-way	277,262	0	55	0	0.06	0.16
gc current split	59,570	0	53	1	0.01	0.16
log switch/archive	4	100	40	10003	0.00	0.12
latch: ges resource hash list	135,569	0	32	0	0.03	0.10
control file sequential read	53,023	0	32	1	0.01	0.10
gc current block congested	65,981	0	21	0	0.01	0.06
library cache: mutex X	18,255	0	19	1	0.00	0.06
SQL*Net message to client	14,203,854	0	16	0	2.88	0.05
ges enter server mode	8	88	14	1750	0.00	0.04
latch: cache buffers chains	115,287	0	13	0	0.02	0.04
buffer deadlock	1,292,649	100	11	0	0.26	0.03
read by other session	20,862	0	10	0	0.00	0.03
log file switch completion	427	0	8	20	0.00	0.03
SQL*Net more data to client	407,906	0	7	0	0.08	0.02
gc cr block congested	14,602	0	5	0	0.00	0.01
gc current multi block request	8,293	0	4	1	0.00	0.01
enq: FB - contention	12,279	0	4	0	0.00	0.01
row cache lock	5,290	0	3	1	0.00	0.01
cursor: pin S wait on X	1,022	0	3	3	0.00	0.01
enq: SQ - contention	2,613	0	3	1	0.00	0.01
cursor: pin S	657	0	2	4	0.00	0.01
gc remaster	1	0	2	2000	0.00	0.01
latch: shared pool	18,179	0	2	0	0.00	0.00
SQL*Net break/reset to client	6,052	0	2	0	0.00	0.00
gc current retry	4,972	0	1	0	0.00	0.00
gc cr grant congested	4,778	0	1	0	0.00	0.00
gc current grant congested	3,835	0	1	0	0.00	0.00
enq: TX - allocate ITL entry	1,667	0	1	0	0.00	0.00
latch: enqueue hash chains	6,260	0	1	0	0.00	0.00
kksfbc child completion	14	100	1	51	0.00	0.00
log file sequential read	326	0	1	2	0.00	0.00
ADR block file read	5,032	0	1	0	0.00	0.00
latch free	5,643	0	1	0	0.00	0.00
latch: gc element	9,196	0	0	0	0.00	0.00
KJC: Wait for msg sends to complete	13,466	0	0	0	0.00	0.00
global enqueue expand wait	12,091	0	0	0	0.00	0.00
SQL*Net more data from client	39,210	0	0	0	0.01	0.00
undo segment extension	80	100	0	5	0.00	0.00
IPC send completion sync	1,520	0	0	0	0.00	0.00
latch: redo allocation	2,487	0	0	0	0.00	0.00
latch: row cache objects	2,236	0	0	0	0.00	0.00
Disk file operations I/O	22,307	0	0	0	0.00	0.00
enq: KO - fast object checkpoint	64	0	0	3	0.00	0.00
enq: PS - contention	460	4	0	0	0.00	0.00
wait list latch free	132	0	0	1	0.00	0.00
library cache lock	183	3	0	1	0.00	0.00
reliable message	183	0	0	1	0.00	0.00
control file parallel write	118	0	0	1	0.00	0.00
PX Deq: Slave Session Stats	600	0	0	0	0.00	0.00
enq: HW - contention	94	15	0	1	0.00	0.00
lock deadlock retry	11,383	100	0	0	0.00	0.00
PX Deq: reap credit	6,174	100	0	0	0.00	0.00
library cache pin	150	0	0	0	0.00	0.00
switch logfile command	2	0	0	33	0.00	0.00
CSS initialization	9	0	0	6	0.00	0.00
direct path write	71	0	0	1	0.00	0.00
gc cr disk read	158	0	0	0	0.00	0.00
latch: gcs resource hash	284	0	0	0	0.00	0.00
Log archive I/O	23	0	0	2	0.00	0.00
latch: messages	220	0	0	0	0.00	0.00
library cache load lock	12	0	0	2	0.00	0.00
latch: cache buffers lru chain	189	0	0	0	0.00	0.00
PX Deq: Signal ACK RSG	157	0	0	0	0.00	0.00
ges inquiry response	40	0	0	0	0.00	0.00
CSS operation: action	9	0	0	1	0.00	0.00
cursor: mutex X	7	0	0	2	0.00	0.00
enq: IV - contention	18	11	0	1	0.00	0.00
enq: TX - contention	7	0	0	1	0.00	0.00
PX Deq: Signal ACK EXT	162	0	0	0	0.00	0.00
gc cr multi block request	16	0	0	1	0.00	0.00
latch: object queue header operation	79	0	0	0	0.00	0.00
lock escalate retry	290	100	0	0	0.00	0.00
latch: undo global data	55	0	0	0	0.00	0.00
DFS lock handle	8	0	0	1	0.00	0.00
gc cr failure	14	0	0	0	0.00	0.00
enq: CF - contention	13	0	0	0	0.00	0.00
enq: TT - contention	12	0	0	0	0.00	0.00
latch: session allocation	7	0	0	0	0.00	0.00
SQL*Net message from client	14,203,850	0	403,705	28	2.88
jobq slave wait	240	100	120	501	0.00
PX Deq: Execution Msg	1,752	0	2	1	0.00
PX Deq: Execute Reply	442	0	1	3	0.00
PX Deq: Join ACK	162	0	0	2	0.00
PX Deq: Parse Reply	162	0	0	1	0.00
PX Deq Credit: send blkd	121	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
gcs log flush sync	4,440,261	0	2,033	0	0.90	26.44
log file parallel write	2,840,498	0	1,920	1	0.58	24.96
Backup: MML write backup piece	108,901	0	697	6	0.02	9.07
db file parallel write	323,537	0	434	1	0.07	5.65
LNS wait on SENDREQ	2,806,507	0	162	0	0.57	2.11
Backup: MML create a backup piece	19	0	139	7294	0.00	1.80
Backup: MML commit backup piece	21	0	52	2487	0.00	0.68
log file sequential read	20,455	0	41	2	0.00	0.53
db file async I/O submit	238,207	0	21	0	0.05	0.28
control file sequential read	24,005	0	15	1	0.00	0.19
Streams AQ: qmn coordinator waiting for slave to start	2	100	11	5564	0.00	0.14
LGWR wait for redo copy	162,434	0	7	0	0.03	0.09
control file parallel write	5,945	0	5	1	0.00	0.07
Backup: MML query backup piece	21	0	2	96	0.00	0.03
reliable message	2,082	0	2	1	0.00	0.02
Disk file operations I/O	1,212	0	1	1	0.00	0.02
Log archive I/O	954	0	1	1	0.00	0.01
row cache process	92,779	0	1	0	0.02	0.01
control file single write	367	0	1	3	0.00	0.01
row cache lock	4,062	0	1	0	0.00	0.01
latch: cache buffers chains	15,836	0	1	0	0.00	0.01
latch: gc element	14,819	0	1	0	0.00	0.01
os thread startup	22	0	1	32	0.00	0.01
enq: CF - contention	396	82	1	2	0.00	0.01
gc cr block 2-way	1,790	0	0	0	0.00	0.01
latch: redo allocation	3,487	0	0	0	0.00	0.01
DFS lock handle	1,218	100	0	0	0.00	0.01
ksxr poll remote instances	44,946	100	0	0	0.01	0.01
Backup: MML initialization	20	0	0	21	0.00	0.01
CGS wait for IPC msg	31,029	100	0	0	0.01	0.01
latch free	1,843	0	0	0	0.00	0.00
latch: ges resource hash list	1,999	0	0	0	0.00	0.00
db file sequential read	667	0	0	0	0.00	0.00
latch: gcs resource hash	1,793	0	0	0	0.00	0.00
row cache cleanup	65,908	0	0	0	0.01	0.00
CSS operation: action	90	0	0	2	0.00	0.00
gc current block 2-way	481	0	0	0	0.00	0.00
gc buffer busy acquire	2	0	0	63	0.00	0.00
enq: TM - contention	1	0	0	113	0.00	0.00
gc cr block busy	66	0	0	2	0.00	0.00
CSS initialization	16	0	0	5	0.00	0.00
library cache lock	241	1	0	0	0.00	0.00
library cache pin	257	0	0	0	0.00	0.00
log file single write	76	0	0	1	0.00	0.00
gc current grant 2-way	270	0	0	0	0.00	0.00
latch: messages	288	0	0	0	0.00	0.00
buffer busy waits	668	0	0	0	0.00	0.00
direct path write	22	0	0	2	0.00	0.00
PX Deq: reap credit	3,832	100	0	0	0.00	0.00
RMAN backup & recovery I/O	135	0	0	0	0.00	0.00
asynch descriptor resize	3,877	100	0	0	0.00	0.00
gc cr grant 2-way	150	0	0	0	0.00	0.00
SQL*Net message to client	12,834	0	0	0	0.00	0.00
libcache interrupt action by LCK	52,205	0	0	0	0.01	0.00
gc current grant busy	78	0	0	0	0.00	0.00
latch: redo writing	125	0	0	0	0.00	0.00
ADR block file read	46	0	0	0	0.00	0.00
latch: object queue header operation	86	0	0	0	0.00	0.00
latch: cache buffers lru chain	64	0	0	0	0.00	0.00
ges inquiry response	40	0	0	0	0.00	0.00
global enqueue expand wait	175	0	0	0	0.00	0.00
library cache: mutex X	203	0	0	0	0.00	0.00
latch: enqueue hash chains	101	0	0	0	0.00	0.00
enq: PS - contention	24	50	0	0	0.00	0.00
wait list latch free	10	0	0	1	0.00	0.00
enq: TT - contention	25	88	0	0	0.00	0.00
enq: KO - fast object checkpoint	39	0	0	0	0.00	0.00
Backup: MML shutdown	20	0	0	0	0.00	0.00
enq: US - contention	25	0	0	0	0.00	0.00
latch: call allocation	162	0	0	0	0.00	0.00
gc cr block congested	19	0	0	0	0.00	0.00
enq: WL - contention	17	100	0	0	0.00	0.00
latch: checkpoint queue latch	28	0	0	0	0.00	0.00
enq: WF - contention	16	0	0	0	0.00	0.00
gc current multi block request	12	0	0	0	0.00	0.00
enq: TA - contention	14	0	0	0	0.00	0.00
enq: IV - contention	15	0	0	0	0.00	0.00
latch: shared pool	48	0	0	0	0.00	0.00
enq: FB - contention	10	0	0	0	0.00	0.00
gc buffer busy release	1	0	0	3	0.00	0.00
enq: RS - prevent file delete	7	100	0	0	0.00	0.00
enq: TD - KTF dump entries	8	0	0	0	0.00	0.00
Backup: MML command to channel	20	0	0	0	0.00	0.00
gc current block congested	10	0	0	0	0.00	0.00
ARCH wait for archivelog lock	26	0	0	0	0.00	0.00
gc current block busy	3	0	0	1	0.00	0.00
ADR block file write	24	0	0	0	0.00	0.00
PX Deq: Signal ACK RSG	18	0	0	0	0.00	0.00
enq: SM - contention	8	0	0	0	0.00	0.00
PX Deq: Signal ACK EXT	18	0	0	0	0.00	0.00
ADR file lock	44	0	0	0	0.00	0.00
gc cr grant congested	5	0	0	0	0.00	0.00
PX Deq: Slave Session Stats	18	0	0	0	0.00	0.00
IPC send completion sync	12	0	0	0	0.00	0.00
rdbms ipc message	2,272,113	3	123,067	54	0.46
Streams AQ: qmn slave idle wait	1,829	0	13,237	7237	0.00
gcs remote message	13,280,339	0	11,301	1	2.70
PX Idle Wait	438	0	7,215	16472	0.00
DIAG idle wait	54,030	73	7,167	133	0.01
Space Manager: slave idle wait	850	99	4,214	4957	0.00
shared server idle wait	121	100	3,631	30010	0.00
smon timer	185	4	3,620	19568	0.00
PING	1,341	21	3,618	2698	0.00
GCR sleep	722	100	3,610	5001	0.00
pmon timer	1,210	99	3,606	2980	0.00
dispatcher timer	60	100	3,601	60010	0.00
Streams AQ: qmn coordinator idle wait	1,074	46	3,597	3349	0.00
ges remote message	675,875	2	3,566	5	0.14
LNS ASYNC end of log	2,823,045	0	3,323	1	0.57
SQL*Net message from client	16,687	0	887	53	0.00
class slave wait	19	0	300	15771	0.00
PX Deq: Join ACK	18	0	0	2	0.00
Streams AQ: RAC qmn coordinator idle wait	1,179	100	0	0	0.00
PX Deq: Parse Reply	18	0	0	1	0.00
KSV master wait	2,182	100	0	0	0.00
PX Deq: Execute Reply	18	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%; value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	5078	99.4	.1	.1	.4	.0	.0
ADR block file write	24	100.0
ADR file lock	44	100.0
ARCH wait for archivelog lock	28	100.0
Backup: MML command to channel	20	100.0
Backup: MML commit backup piece	22							13.6	86.4
Backup: MML create a backup piece	19								100.0
Backup: MML extended initialization	20	100.0
Backup: MML initialization	20	20.0				15.0	55.0	10.0
Backup: MML query backup piece	22							100.0
Backup: MML shutdown	20	100.0
Backup: MML write backup piece	108.5K		1.4	6.9	82.5	9.2	.0
CGS wait for IPC msg	31K	100.0
CSS initialization	25			16.0	84.0
CSS operation: action	99	28.3	61.6	10.1
DFS lock handle	1226	98.0	1.8	.2
Disk file operations I/O	23.5K	99.4	.2	.1	.1	.2	.1	.0
IPC send completion sync	1532	98.8	1.2
KJC: Wait for msg sends to complete	13.5K	100.0	.0	.0
LGWR wait for redo copy	162.4K	99.9	.1	.0
LNS wait on SENDREQ	2806.6K	100.0	.0	.0	.0	.0		.0
Log archive I/O	977	60.3	26.4	9.5	3.1	.7
PX Deq: Signal ACK EXT	180	100.0
PX Deq: Signal ACK RSG	175	98.3	1.7
PX Deq: Slave Session Stats	618	99.5	.5
PX Deq: reap credit	10K	100.0	.0
RMAN backup & recovery I/O	129	94.6	4.7	.8
SQL*Net break/reset to client	6058	95.4	4.1	.4	.0	.0
SQL*Net message to client	14.2M	100.0	.0	.0
SQL*Net more data from client	39.2K	100.0	.0				.0
SQL*Net more data to client	406.8K	100.0	.0
Streams AQ: qmn coordinator waiting for slave to start	2								100.0
asynch descriptor resize	3873	100.0
buffer busy waits	1082.8K	93.0	3.1	1.6	1.1	.8	.2	.1	.0
buffer deadlock	1293.6K	100.0	.0	.0
control file parallel write	6075	81.5	13.0	3.7	1.1	.7	.1
control file sequential read	77.1K	85.7	8.5	4.7	.9	.2	.0
control file single write	367	15.5	6.3	68.1	10.1
cursor: mutex S	2	100.0
cursor: mutex X	7	85.7				14.3
cursor: pin S	657	63.6	1.1			35.3
cursor: pin S wait on X	1022	.3	33.4	50.8	4.8	10.6	.2
db file async I/O submit	238.4K	99.8	.1	.1	.0	.0	.0	.0
db file parallel write	323.8K	46.7	34.9	14.4	3.6	.4	.1	.0
db file scattered read	1	100.0
db file sequential read	796.1K	94.8	3.1	1.8	.3	.0	.0
direct path read	521.3K	92.6	4.0	3.1	.3	.0
direct path write	93	73.1	8.6	12.9	5.4
enq: AE - lock	1	100.0
enq: AF - task serialization	1	100.0
enq: CF - contention	409	97.6	.5	.2			.5	1.2
enq: CR - block range reuse ckpt	2	100.0
enq: FB - contention	12.3K	99.3	.6	.0	.0
enq: HW - contention	97	78.4	7.2	12.4		1.0	1.0
enq: IV - contention	33	100.0
enq: JS - job run lock - synchronize	2	100.0
enq: KO - fast object checkpoint	105	81.0		1.9	10.5	3.8	2.9
enq: MW - contention	2	100.0
enq: PS - contention	484	99.6	.4
enq: PW - flush prewarm buffers	1	100.0
enq: RS - prevent file delete	7	100.0
enq: SM - contention	8	100.0
enq: SQ - contention	2614	52.0	37.0	10.6	.3	.1
enq: SR - contention	1	100.0
enq: TA - contention	14	100.0
enq: TD - KTF dump entries	8	100.0
enq: TM - contention	1							100.0
enq: TT - contention	37	100.0
enq: TX - allocate ITL entry	1666	95.7	1.6	1.6	.8	.2	.1
enq: TX - contention	7	28.6	57.1	14.3
enq: TX - index contention	492.9K	59.3	16.5	13.8	7.5	2.0	.5	.4
enq: TX - row lock contention	2	100.0
enq: US - contention	25	100.0
enq: WF - contention	16	100.0
enq: WL - contention	19	94.7	5.3
gc buffer busy acquire	2317.5K	66.6	16.6	11.8	3.7	.8	.2	.2
gc buffer busy release	1195.1K	32.3	17.6	23.8	18.9	5.4	1.3	.7
gc cr block 2-way	1059.9K	99.5	.5	.0	.0	.0	.0	.0
gc cr block busy	45K	37.3	37.3	19.6	4.6	.8	.3	.0
gc cr block congested	14.6K	99.2	.7	.1	.0
gc cr disk read	160	98.8	1.3
gc cr failure	14	100.0
gc cr grant 2-way	345.3K	99.4	.6	.0	.0	.0
gc cr grant congested	4781	99.1	.8	.0	.0
gc cr multi block request	17	88.2	11.8
gc current block 2-way	4546.3K	99.6	.4	.0	.0	.0	.0	.0
gc current block busy	1697.1K	27.4	36.4	27.2	8.0	.8	.2	.0
gc current block congested	66K	99.2	.7	.1	.0	.0	.0
gc current grant 2-way	277.6K	99.7	.3	.0	.0	.0	.0
gc current grant busy	306.6K	94.4	3.0	1.7	.7	.1	.0	.0
gc current grant congested	3839	99.5	.5	.1	.0
gc current multi block request	8308	98.1	1.9	.0			.0
gc current retry	4975	96.8	1.9	1.0	.2	.0
gc current split	59.6K	81.3	11.2	4.8	1.9	.6	.1	.0
gc remaster	1								100.0
gcs enter server mode	190	1.1						98.9
gcs log flush sync	4440.8K	90.5	6.9	2.4	.2	.0	.0	.0
ges enter server mode	8	12.5							87.5
ges inquiry response	81	100.0
global enqueue expand wait	12.3K	99.9	.1
kksfbc child completion	14							100.0
ksxr poll remote instances	45K	100.0
latch free	7487	99.4	.5		.1
latch: active service list	12	100.0
latch: cache buffers chains	131K	99.5	.5	.0
latch: cache buffers lru chain	253	99.2	.8
latch: call allocation	162	100.0
latch: checkpoint queue latch	28	96.4	3.6
latch: enqueue hash chains	6364	99.4	.6
latch: gc element	24K	99.9	.1		.0
latch: gcs resource hash	2076	99.8	.2
latch: ges resource hash list	137.6K	97.4	2.5	.1
latch: messages	508	99.0	1.0
latch: object queue header operation	165	98.8	1.2
latch: redo allocation	5973	99.6	.4
latch: redo writing	125	100.0
latch: row cache objects	2247	99.5	.4	.0
latch: session allocation	7	100.0
latch: shared pool	18.2K	99.4	.3	.2	.1	.0
latch: undo global data	56	100.0
libcache interrupt action by LCK	52.3K	100.0
library cache load lock	12	83.3			8.3	8.3
library cache lock	423	91.0	5.0	3.5	.2	.2
library cache pin	405	98.3	.7	.5	.2	.2
library cache: mutex X	18.5K	90.5	.1			9.2	.2
lock deadlock retry	11.4K	100.0	.0
lock escalate retry	291	100.0
log file parallel write	2840.6K	85.3	8.8	5.6	.4	.0	.0	.0
log file sequential read	20.8K	22.3	35.7	37.0	4.9	.2	.0
log file single write	76	89.5	9.2	1.3
log file switch completion	426	1.2	3.1	3.3	6.1	23.7	53.8	8.9
log file sync	4913.7K	43.8	31.9	19.3	4.5	.4	.1	.0
log switch/archive	4								100.0
os thread startup	22						36.4	63.6
read by other session	20.9K	90.4	5.2	2.9	1.1	.3	.1	.0
reliable message	2264	87.1	7.9	4.6	.4
row cache cleanup	66K	100.0	.0	.0	.0
row cache lock	9350	93.2	6.7	.1	.0	.0
row cache process	92.8K	100.0	.0
switch logfile command	2						50.0	50.0
undo segment extension	80	61.3				30.0	8.8
wait list latch free	143	6.3	93.7
DIAG idle wait	54K	25.6	.1	.0	.0	3.3	6.9	64.1
GCR sleep	722								100.0
KSV master wait	2184	100.0
LNS ASYNC end of log	2823.1K	63.5	21.5	12.5	2.3	.2	.0	.0
PING	1341	78.9							21.1
PX Deq Credit: need buffer	1	100.0
PX Deq Credit: send blkd	121	100.0
PX Deq: Execute Reply	460	51.1	8.5	15.2	18.9	6.3
PX Deq: Execution Msg	1752	89.6	7.1	1.4	.9	.5	.4	.3
PX Deq: Join ACK	180	41.1	45.0	12.2		.6		1.1
PX Deq: Parse Reply	180	86.7	11.1	1.1		.6	.6
PX Idle Wait	438	15.3	30.1	6.8	2.3	3.4	5.3	15.5	21.2
SQL*Net message from client	14.2M	64.3	15.8	7.9	4.1	2.6	1.9	3.2	.3
Space Manager: slave idle wait	849	.1					.1	.4	99.4
Streams AQ: RAC qmn coordinator idle wait	1179	100.0
Streams AQ: qmn coordinator idle wait	1074	53.3		.1	.1	.2			46.4
Streams AQ: qmn slave idle wait	1816								100.0
class slave wait	19	94.7							5.3
dispatcher timer	60								100.0
gcs remote message	13.3M	73.2	16.3	8.3	2.0	.2	.0	.0
ges remote message	676.1K	59.2	11.0	8.9	6.5	5.2	4.6	4.6
jobq slave wait	240							100.0
pmon timer	1211	.2						.5	99.3
rdbms ipc message	2271.9K	80.6	9.0	5.1	1.0	.3	.2	2.6	1.1
shared server idle wait	120								100.0
smon timer	184						.5	35.3	64.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
Backup: MML commit backup piece	12						13.6	40.9	45.5
Backup: MML initialization	2	90.0	10.0
Backup: MML query backup piece	22			90.9	9.1
Disk file operations I/O	1	100.0	.0
LNS wait on SENDREQ	3	100.0	.0	.0
buffer busy waits	719	99.9	.0	.0	.0	.0	.0	.0
db file async I/O submit	1	100.0	.0
db file parallel write	16	100.0	.0
enq: CF - contention	5	98.8	.5	.5	.2
enq: TM - contention	1			100.0
enq: TX - index contention	1915	99.6	.1	.0	.1	.1
gc buffer busy acquire	4639	99.8	.0	.0	.0	.1	.0
gc buffer busy release	8707	99.3	.4	.1	.1	.2	.0
gc cr block 2-way	4	100.0	.0
gc cr block busy	16	100.0	.0
gc current block 2-way	2	100.0	.0
gc current block busy	668	100.0	.0	.0	.0	.0
gc current grant busy	77	100.0	.0	.0	.0	.0
gc current split	21	100.0	.0	.0	.0	.0
gc remaster	1							100.0
gcs enter server mode	188	1.1				98.9
gcs log flush sync	6	100.0	.0
ges enter server mode	7	12.5						87.5
kksfbc child completion	14		100.0
log file parallel write	26	100.0	.0
log file switch completion	38	91.1	8.9
log file sync	744	100.0	.0	.0
os thread startup	14	36.4	63.6
read by other session	3	100.0	.0			.0
switch logfile command	1	50.0	50.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s
		% of Total Waits
Backup: MML commit backup piece	10	54.5	40.9	4.5
Backup: MML create a backup piece	19			89.5	10.5
Streams AQ: qmn coordinator waiting for slave to start	2			100.0
log switch/archive	4				100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
cydb	33,030	9,033	27,882	582,767
SYS$USERS	190	166	1	555
SYS$BACKGROUND	0	0	1	1,107
SYS.SCHEDULER$_EVENT_QUEUE	0	0	0	0
cydbXDB	0	0	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 seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
cydb	1352256	533	1735250	1903	0	0	14609686	23
SYS$USERS	8348	2	1269	0	109093	891	42328	0
SYS$BACKGROUND	1472	1	73439	3	0	0	2806486	162

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
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
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 59.2% of Total DB Time (s): 33,223
Captured PL/SQL account for 0.0% of Total DB Time (s): 33,223

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
5,009.63	1,097,430	0.00	15.08	13.58	0.04	60rsjr56rbk28	JDBC Thin Client	insert into rcvreq( ID, SVCSRL...
4,888.27	1,098,245	0.00	14.71	13.38	0.05	1vc7mynra0qbv	JDBC Thin Client	insert into reqres( ID, SVCSRL...
4,463.57	968,780	0.00	13.44	13.08	0.09	g5pqwnf9nf816	JDBC Thin Client	insert into sndreq( ID, REQSRL...
3,766.42	967,760	0.00	11.34	14.75	0.10	abz06usyb2a0c	JDBC Thin Client	insert into rcvres( ID, SVCSRL...
207.29	212,335	0.00	0.62	44.09	4.31	16ckptc2haxr7		insert into ECC_SERVICE_LOG (C...
136.42	23,120	0.01	0.41	32.60	49.45	amuwuh29bcc65		select * from (select ebo.orde...
130.74	397,282	0.00	0.39	37.41	0.00	7c4wzfz6aks1b	JDBC Thin Client	update PRV_MONITOR_INFO set co...
127.18	2,869	0.04	0.38	31.94	55.35	9z2jvwsdhu99w		select * from ( select ebo.ord...
100.84	1,607	0.06	0.30	31.28	48.85	9g4z954b99aqy		select * from ( select * from ...
98.07	397,284	0.00	0.30	36.15	0.00	gq9sd8ffqp655	JDBC Thin Client	SELECT * from PRV_MONITOR_INFO...

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 - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 34.0% of Total CPU Time (s): 9,199
Captured PL/SQL account for 0.0% of Total CPU Time (s): 9,199

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
680.47	1,097,430	0.00	7.40	5,009.63	13.58	0.04	60rsjr56rbk28	JDBC Thin Client	insert into rcvreq( ID, SVCSRL...
654.01	1,098,245	0.00	7.11	4,888.27	13.38	0.05	1vc7mynra0qbv	JDBC Thin Client	insert into reqres( ID, SVCSRL...
583.64	968,780	0.00	6.34	4,463.57	13.08	0.09	g5pqwnf9nf816	JDBC Thin Client	insert into sndreq( ID, REQSRL...
555.73	967,760	0.00	6.04	3,766.42	14.75	0.10	abz06usyb2a0c	JDBC Thin Client	insert into rcvres( ID, SVCSRL...
91.40	212,335	0.00	0.99	207.29	44.09	4.31	16ckptc2haxr7		insert into ECC_SERVICE_LOG (C...
60.24	25,139	0.00	0.65	75.80	79.48	0.00	06f1k4f08asrm		select eccaccount0_.ACCT_AUTH_...
48.90	397,282	0.00	0.53	130.74	37.41	0.00	7c4wzfz6aks1b	JDBC Thin Client	update PRV_MONITOR_INFO set co...
44.48	23,120	0.00	0.48	136.42	32.60	49.45	amuwuh29bcc65		select * from (select ebo.orde...
40.62	2,869	0.01	0.44	127.18	31.94	55.35	9z2jvwsdhu99w		select * from ( select ebo.ord...
35.45	397,284	0.00	0.39	98.07	36.15	0.00	gq9sd8ffqp655	JDBC Thin Client	SELECT * from PRV_MONITOR_INFO...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 55.8% of Total User I/O Wait Time (s): 536
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 536

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
70.40	2,869	0.02	13.13	127.18	31.94	55.35	9z2jvwsdhu99w	select * from ( select ebo.ord...
67.46	23,120	0.00	12.58	136.42	32.60	49.45	amuwuh29bcc65	select * from (select ebo.orde...
49.26	1,607	0.03	9.19	100.84	31.28	48.85	9g4z954b99aqy	select * from ( select * from ...
26.38	4,020	0.01	4.92	63.98	33.06	41.22	4q3s3g437rkys	select * from (select ebo.orde...
21.43	15,295	0.00	3.99	68.77	32.79	31.16	41q0v4dhrxvkg	select eccauthseq0_.CHAN_AUTH_...
14.51	2,590	0.01	2.71	41.28	44.89	35.16	7gjvwutsv9ddn	select * from ( select ebo.ord...
10.08	15,430	0.00	1.88	45.07	51.82	22.37	4wu3ay3j3wbdv	insert into ECC_BASE_ORDER (BA...
8.93	212,335	0.00	1.66	207.29	44.09	4.31	16ckptc2haxr7	insert into ECC_SERVICE_LOG (C...
5.96	10,922	0.00	1.11	13.45	35.52	44.30	csqpy9yyx11fy	select eccpayeeli0_.PAYEE_SEQ ...
5.07	43,636	0.00	0.95	38.32	53.97	13.24	g7gffa5dqdgpv	insert into ECC_ORDER_LOG (NEW...

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 as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 584,427,784
Captured SQL account for 22.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
25,949,454	1,097,430	23.65	4.44	5,009.63	13.6	0	60rsjr56rbk28	JDBC Thin Client	insert into rcvreq( ID, SVCSRL...
25,461,427	1,098,245	23.18	4.36	4,888.27	13.4	0	1vc7mynra0qbv	JDBC Thin Client	insert into reqres( ID, SVCSRL...
22,610,863	968,780	23.34	3.87	4,463.57	13.1	.1	g5pqwnf9nf816	JDBC Thin Client	insert into sndreq( ID, REQSRL...
21,978,162	967,760	22.71	3.76	3,766.42	14.8	.1	abz06usyb2a0c	JDBC Thin Client	insert into rcvres( ID, SVCSRL...
9,375,729	25,139	372.96	1.60	75.80	79.5	0	06f1k4f08asrm		select eccaccount0_.ACCT_AUTH_...
3,786,147	212,335	17.83	0.65	207.29	44.1	4.3	16ckptc2haxr7		insert into ECC_SERVICE_LOG (C...
2,175,887	15,295	142.26	0.37	68.77	32.8	31.2	41q0v4dhrxvkg		select eccauthseq0_.CHAN_AUTH_...
2,007,307	397,282	5.05	0.34	130.74	37.4	0	7c4wzfz6aks1b	JDBC Thin Client	update PRV_MONITOR_INFO set co...
1,598,093	397,284	4.02	0.27	98.07	36.2	0	gq9sd8ffqp655	JDBC Thin Client	SELECT * from PRV_MONITOR_INFO...
1,530,730	12,459	122.86	0.26	20.56	53	0	avwynfhqzsxwv		select eccauthseq0_.CHAN_AUTH_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 27,883,809
Captured SQL account for 2.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
174,214	2,869	60.72	0.62	127.18	31.94	55.35	9z2jvwsdhu99w	select * from ( select ebo.ord...
170,276	23,120	7.36	0.61	136.42	32.60	49.45	amuwuh29bcc65	select * from (select ebo.orde...
128,242	1,607	79.80	0.46	100.84	31.28	48.85	9g4z954b99aqy	select * from ( select * from ...
71,397	4,020	17.76	0.26	63.98	33.06	41.22	4q3s3g437rkys	select * from (select ebo.orde...
48,428	15,295	3.17	0.17	68.77	32.79	31.16	41q0v4dhrxvkg	select eccauthseq0_.CHAN_AUTH_...
38,403	2,590	14.83	0.14	41.28	44.89	35.16	7gjvwutsv9ddn	select * from ( select ebo.ord...
22,124	15,430	1.43	0.08	45.07	51.82	22.37	4wu3ay3j3wbdv	insert into ECC_BASE_ORDER (BA...
17,462	212,335	0.08	0.06	207.29	44.09	4.31	16ckptc2haxr7	insert into ECC_SERVICE_LOG (C...
12,416	10,922	1.14	0.04	13.45	35.52	44.30	csqpy9yyx11fy	select eccpayeeli0_.PAYEE_SEQ ...
9,664	43,636	0.22	0.03	38.32	53.97	13.24	g7gffa5dqdgpv	insert into ECC_ORDER_LOG (NEW...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 2,489,662
Captured SQL account for 29.4% of Total
Total UnOptimized Read Requests: 2,489,662
Captured SQL account for 29.4% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
174,214	174,214	2,869	60.72	7.00	9z2jvwsdhu99w		select * from ( select ebo.ord...
170,276	170,276	23,120	7.36	6.84	amuwuh29bcc65		select * from (select ebo.orde...
128,242	128,242	1,607	79.80	5.15	9g4z954b99aqy		select * from ( select * from ...
71,397	71,397	4,020	17.76	2.87	4q3s3g437rkys		select * from (select ebo.orde...
48,428	48,428	15,295	3.17	1.95	41q0v4dhrxvkg		select eccauthseq0_.CHAN_AUTH_...
38,403	38,403	2,590	14.83	1.54	7gjvwutsv9ddn		select * from ( select ebo.ord...
22,091	22,091	15,430	1.43	0.89	4wu3ay3j3wbdv		insert into ECC_BASE_ORDER (BA...
17,463	17,463	212,335	0.08	0.70	16ckptc2haxr7		insert into ECC_SERVICE_LOG (C...
12,660	12,660	60	211.00	0.51	4njydwxfq93k0	SQL*Plus	select to_char((active_undo/to...
12,416	12,416	10,922	1.14	0.50	csqpy9yyx11fy		select eccpayeeli0_.PAYEE_SEQ ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 8,006,060
Captured SQL account for 77.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,098,245	1,098,265	1.00	4,888.27	13.4	0	1vc7mynra0qbv	JDBC Thin Client	insert into reqres( ID, SVCSRL...
1,097,430	1,094,831	1.00	5,009.63	13.6	0	60rsjr56rbk28	JDBC Thin Client	insert into rcvreq( ID, SVCSRL...
968,780	968,778	1.00	4,463.57	13.1	.1	g5pqwnf9nf816	JDBC Thin Client	insert into sndreq( ID, REQSRL...
967,760	967,773	1.00	3,766.42	14.8	.1	abz06usyb2a0c	JDBC Thin Client	insert into rcvres( ID, SVCSRL...
397,284	397,277	1.00	98.07	36.2	0	gq9sd8ffqp655	JDBC Thin Client	SELECT * from PRV_MONITOR_INFO...
397,282	397,281	1.00	130.74	37.4	0	7c4wzfz6aks1b	JDBC Thin Client	update PRV_MONITOR_INFO set co...
212,335	212,332	1.00	207.29	44.1	4.3	16ckptc2haxr7		insert into ECC_SERVICE_LOG (C...
212,334	0	0.00	49.46	20.5	0	9yt2rgdf155nr		select eccservice0_.ECC_SERVIC...
120,651	120,651	1.00	40.51	37.8	0	3z40sf3yhppjr	JDBC Thin Client	update CSM_MONITOR_INFO set co...
120,651	120,651	1.00	28.65	40.5	0	atqyrxmf2swga	JDBC Thin Client	SELECT * from CSM_MONITOR_INFO...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 2,713,877
Captured SQL account for 37.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
212,328	212,334	7.82	9yt2rgdf155nr	select eccservice0_.ECC_SERVIC...
212,327	212,335	7.82	16ckptc2haxr7	insert into ECC_SERVICE_LOG (C...
60,244	60,246	2.22	68zrg4s7s50c2	select eccorderex0_.SEQ_NO as ...
44,095	44,096	1.62	5arz42cptu84j	select eccbaseord0_.ORDER_NO a...
43,636	43,636	1.61	g7gffa5dqdgpv	insert into ECC_ORDER_LOG (NEW...
43,635	43,636	1.61	2xyvzr7zj6y4c	select eccorderlo0_.SEQ_NO as ...
36,139	36,140	1.33	bgzkv85h3m3p7	select eccbizepar0_.SUB_CLASS_...
33,403	33,403	1.23	gry4ujjkpvdyh	select eccauthseq0_.CHAN_AUTH_...
29,178	29,179	1.08	5667w6yswxatv	select Order_No, Create_Time, ...
28,336	28,337	1.04	9jw679r0aghnx	select eccbaseord0_.ORDER_NO a...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
64	15,430	4wu3ay3j3wbdv		insert into ECC_BASE_ORDER (BA...
25	24,778	au9a3fwsp67wm		update ECC_BASE_ORDER set BASE...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

%Total - Cluster Time as a percentage of Total Cluster Wait Time
%Clu - Cluster Time as a percentage of Elapsed Time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Only SQL with Cluster Wait Time > .005 seconds is reported
Total Cluster Wait Time (s): 14,324
Captured SQL account for 99.5% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,788.66	1,097,430	26.45	5,009.63	75.63	13.58	0.04	60rsjr56rbk28	JDBC Thin Client	insert into rcvreq( ID, SVCSRL...
3,712.78	1,098,245	25.92	4,888.27	75.95	13.38	0.05	1vc7mynra0qbv	JDBC Thin Client	insert into reqres( ID, SVCSRL...
3,424.40	968,780	23.91	4,463.57	76.72	13.08	0.09	g5pqwnf9nf816	JDBC Thin Client	insert into sndreq( ID, REQSRL...
2,823.23	967,760	19.71	3,766.42	74.96	14.75	0.10	abz06usyb2a0c	JDBC Thin Client	insert into rcvres( ID, SVCSRL...
100.05	212,335	0.70	207.29	48.27	44.09	4.31	16ckptc2haxr7		insert into ECC_SERVICE_LOG (C...
52.52	397,284	0.37	98.07	53.55	36.15	0.00	gq9sd8ffqp655	JDBC Thin Client	SELECT * from PRV_MONITOR_INFO...
49.55	397,282	0.35	130.74	37.90	37.41	0.00	7c4wzfz6aks1b	JDBC Thin Client	update PRV_MONITOR_INFO set co...
38.40	23,120	0.27	136.42	28.15	32.60	49.45	amuwuh29bcc65		select * from (select ebo.orde...
32.35	1,607	0.23	100.84	32.08	31.28	48.85	9g4z954b99aqy		select * from ( select * from ...
31.45	2,869	0.22	127.18	24.73	31.94	55.35	9z2jvwsdhu99w		select * from ( select ebo.ord...
26.90	212,334	0.19	49.46	54.38	20.53	0.01	9yt2rgdf155nr		select eccservice0_.ECC_SERVIC...
22.56	4,020	0.16	63.98	35.26	33.06	41.22	4q3s3g437rkys		select * from (select ebo.orde...
17.82	15,295	0.12	68.77	25.91	32.79	31.16	41q0v4dhrxvkg		select eccauthseq0_.CHAN_AUTH_...
16.41	24,778	0.11	45.46	36.09	60.15	8.69	au9a3fwsp67wm		update ECC_BASE_ORDER set BASE...
15.35	15,430	0.11	45.07	34.05	51.82	22.37	4wu3ay3j3wbdv		insert into ECC_BASE_ORDER (BA...
15.24	120,651	0.11	40.51	37.63	37.75	0.00	3z40sf3yhppjr	JDBC Thin Client	update CSM_MONITOR_INFO set co...
14.75	120,651	0.10	28.65	51.47	40.49	0.00	atqyrxmf2swga	JDBC Thin Client	SELECT * from CSM_MONITOR_INFO...
11.69	43,636	0.08	38.32	30.51	53.97	13.24	g7gffa5dqdgpv		insert into ECC_ORDER_LOG (NEW...
11.03	2,590	0.08	41.28	26.72	44.89	35.16	7gjvwutsv9ddn		select * from ( select ebo.ord...
8.93	12,459	0.06	20.56	43.45	53.03	0.00	avwynfhqzsxwv		select eccauthseq0_.CHAN_AUTH_...
6.54	434	0.05	12.02	54.39	45.72	9.01	aucdbzprkg07d		select * from ( select count(*...
5.49	20,858	0.04	16.65	32.99	59.52	7.01	gx62tugc66qh5		insert into ECC_AUTH_SEQ_INFO ...
4.51	44,096	0.03	12.15	37.08	30.50	0.78	5arz42cptu84j		select eccbaseord0_.ORDER_NO a...
4.43	28,337	0.03	11.35	39.03	33.69	5.82	9jw679r0aghnx		select eccbaseord0_.ORDER_NO a...
4.24	43,636	0.03	9.19	46.19	26.05	0.00	2xyvzr7zj6y4c		select eccorderlo0_.SEQ_NO as ...
3.52	33,403	0.02	8.71	40.47	35.06	0.00	gry4ujjkpvdyh		select eccauthseq0_.CHAN_AUTH_...
3.15	10,922	0.02	13.45	23.46	35.52	44.30	csqpy9yyx11fy		select eccpayeeli0_.PAYEE_SEQ ...
2.71	13,485	0.02	9.31	29.13	59.50	4.41	cpcsjn6cp83mg		insert into ECC_PAY_LOG (CHARG...
2.10	12,528	0.01	6.49	32.32	53.14	0.00	4tdp7p21v3105		update ECC_AUTH_SEQ_INFO set A...
1.94	11,571	0.01	4.38	44.44	33.27	0.05	1z084h3gy67v3		select eccbaseord0_.ORDER_NO a...
1.39	13,485	0.01	3.27	42.48	28.70	0.00	5wu6w9mzvbwz0		select eccpaylog0_.PAY_SEQ as ...
1.19	60,246	0.01	5.25	22.74	21.39	0.00	68zrg4s7s50c2		select eccorderex0_.SEQ_NO as ...
0.96	5,456	0.01	4.74	20.29	53.58	11.04	agh662drb6szz		insert into ECC_ORDER_EXTDATA ...
0.04	60	0.00	15.91	0.23	73.41	0.01	4njydwxfq93k0	SQL*Plus	select to_char((active_undo/to...
0.01	22	0.00	5.27	0.13	97.88	0.21	6qdm91ks29sjv		select * from ( select bb.*, n...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

07f1y4f08axrm 这儿会打印出整个SQL语句，略……

SQL Id	SQL Text
07f1y4f08axrm	这儿会打印出整个SQL语句，略……

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats
Other Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	60,740,329	16,823.95	12.34
execute count	8,006,060	2,217.53	1.63
gc cr block receive time	37,206	10.31	0.01
gc cr blocks received	1,119,997	310.22	0.23
gc current block receive time	476,026	131.85	0.10
gc current blocks received	6,311,637	1,748.21	1.28
logons cumulative	4,317	1.20	0.00
opened cursors cumulative	2,772,500	767.93	0.56
parse count (total)	2,713,877	751.69	0.55
parse time elapsed	235,216	65.15	0.05
physical reads	27,883,809	7,723.30	5.66
physical writes	1,372,311	380.10	0.28
redo size	12,971,986,036	3,593,001.57	2,634.73
session cursor cache hits	384,376	106.47	0.08
session logical reads	584,427,784	161,875.75	118.70
user calls	16,886,805	4,677.33	3.43
user commits	4,921,775	1,363.24	1.00
user rollbacks	1,678	0.46	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	1,618,415	448.27	0.33

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
ADG parselock X get attempts	0	0.00	0.00
ADG parselock X get successes	0	0.00	0.00
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	631	0.17	0.00
Batched IO buffer defrag count	1	0.00	0.00
Batched IO double miss count	9	0.00	0.00
Batched IO same unit count	15	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	183	0.05	0.00
Batched IO vector read count	9	0.00	0.00
Block Cleanout Optim referenced	7,353	2.04	0.00
CCursor + sql area evicted	318	0.09	0.00
CPU used by this session	904,995	250.67	0.18
CPU used when call started	693,699	192.14	0.14
CR blocks created	10,963	3.04	0.00
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	67,392	18.67	0.01
DBWR checkpoint buffers written	1,045,604	289.61	0.21
DBWR checkpoints	64	0.02	0.00
DBWR fusion writes	242,192	67.08	0.05
DBWR object drop buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	1,651	0.46	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	5,819	1.61	0.00
DBWR undo block writes	724,735	200.74	0.15
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	98	0.03	0.00
Effective IO time	200,634,707	55,572.12	40.75
HSC Heap Segment Block Changes	5,014,709	1,388.98	1.02
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	6,207	1.72	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	1,695,595	469.65	0.34
PX local messages recv'd	508	0.14	0.00
PX local messages sent	508	0.14	0.00
PX remote messages recv'd	1,008	0.28	0.00
PX remote messages sent	1,028	0.28	0.00
Parallel operations not downgraded	98	0.03	0.00
Requests to/from client	14,203,735	3,934.17	2.88
RowCR - row contention	29	0.01	0.00
RowCR attempts	1,237	0.34	0.00
RowCR hits	30,284	8.39	0.01
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	173	0.05	0.00
SQL*Net roundtrips to/from client	14,204,477	3,934.38	2.89
active txn count during cleanout	3,366,636	932.50	0.68
background checkpoints completed	19	0.01	0.00
background checkpoints started	19	0.01	0.00
background timeouts	36,894	10.22	0.01
branch node splits	831	0.23	0.00
buffer is not pinned count	418,638,778	115,955.24	85.03
buffer is pinned count	512,365,831	141,915.91	104.07
bytes received via SQL*Net from client	3,862,569,095	1,069,860.60	784.52
bytes sent via SQL*Net to client	4,875,382,979	1,350,391.42	990.24
bytes via SQL*Net vector from client	0	0.00	0.00
calls to get snapshot scn: kcmgss	13,291,029	3,681.37	2.70
calls to kcmgas	5,707,927	1,580.99	1.16
calls to kcmgcs	1,719,706	476.33	0.35
cell physical IO interconnect bytes	333,670,270,464	92,420,528.57	67,771.60
change write time	39,535	10.95	0.01
cleanout - number of ktugct calls	1,180,896	327.09	0.24
cleanouts and rollbacks - consistent read gets	3,276	0.91	0.00
cleanouts only - consistent read gets	16,098	4.46	0.00
cluster key scan block gets	54,028	14.96	0.01
cluster key scans	53,394	14.79	0.01
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	47,007	13.02	0.01
commit batch/immediate requested	47,007	13.02	0.01
commit cleanout failures: block lost	452,492	125.33	0.09
commit cleanout failures: buffer being written	61	0.02	0.00
commit cleanout failures: callback failure	20,518	5.68	0.00
commit cleanout failures: cannot pin	408,342	113.10	0.08
commit cleanouts	22,974,583	6,363.54	4.67
commit cleanouts successfully completed	22,093,170	6,119.40	4.49
commit immediate performed	47,007	13.02	0.01
commit immediate requested	47,007	13.02	0.01
commit txn count during cleanout	7,251,156	2,008.44	1.47
consistent changes	178,102	49.33	0.04
consistent gets	486,247,075	134,681.50	98.76
consistent gets - examination	25,140,616	6,963.49	5.11
consistent gets direct	27,088,391	7,502.99	5.50
consistent gets from cache	459,158,684	127,178.51	93.26
consistent gets from cache (fastpath)	431,761,846	119,590.09	87.69
cursor authentications	179,215	49.64	0.04
data blocks consistent reads - undo records applied	66,466	18.41	0.01
db block gets	98,180,668	27,194.24	19.94
db block gets direct	246	0.07	0.00
db block gets from cache	98,180,422	27,194.17	19.94
db block gets from cache (fastpath)	19,700,246	5,456.61	4.00
deferred (CURRENT) block cleanout applications	2,888,386	800.03	0.59
dirty buffers inspected	220,468	61.07	0.04
enqueue conversions	9,370	2.60	0.00
enqueue deadlocks	0	0.00	0.00
enqueue releases	20,169,453	5,586.57	4.10
enqueue requests	20,169,472	5,586.57	4.10
enqueue timeouts	21	0.01	0.00
enqueue waits	510,892	141.51	0.10
exchange deadlocks	1,455,792	403.23	0.30
failed probes on index block reclamation	1	0.00	0.00
file io service time	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	8,497,546	2,353.66	1.73
free buffer requested	9,262,616	2,565.57	1.88
gc blocks compressed	3,944,192	1,092.47	0.80
gc blocks lost	0	0.00	0.00
gc cr block flush time	5,746	1.59	0.00
gc cr blocks served	1,015,656	281.32	0.21
gc current block flush time	271,473	75.19	0.06
gc current block pin time	19,470	5.39	0.00
gc current blocks served	6,319,401	1,750.36	1.28
gc force cr disk read	772	0.21	0.00
gc kbytes saved	9,739,115	2,697.56	1.98
gc kbytes sent	48,941,330	13,555.85	9.94
gc local grants	773,370	214.21	0.16
gc read wait timeouts	0	0.00	0.00
gc read waits	52	0.01	0.00
gc remote grants	1,071,218	296.71	0.22
gcs messages sent	14,499,561	4,016.11	2.94
ges messages sent	540,392	149.68	0.11
global enqueue get time	144,784	40.10	0.03
global enqueue gets async	9,515	2.64	0.00
global enqueue gets sync	12,031,977	3,332.64	2.44
global enqueue releases	12,026,837	3,331.21	2.44
heap block compress	12,781	3.54	0.00
hot buffers moved to head of LRU	1,543,555	427.54	0.31
immediate (CR) block cleanout applications	19,377	5.37	0.00
immediate (CURRENT) block cleanout applications	711,735	197.14	0.14
index crx upgrade (positioned)	542	0.15	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	2,221	0.62	0.00
index fetch by key	2,217,796	614.29	0.45
index scans kdiixs1	4,390,151	1,215.99	0.89
leaf node 90-10 splits	33,525	9.29	0.01
leaf node splits	159,971	44.31	0.03
lob reads	164	0.05	0.00
lob writes	40,497	11.22	0.01
lob writes unaligned	40,386	11.19	0.01
logical read bytes from cache	4,554,371,760,128	1,261,477,220.51	925,036.10
max cf enq hold time	720	0.20	0.00
messages received	3,244,936	898.79	0.66
messages sent	3,244,937	898.79	0.66
min active SCN optimization applied on CR	959	0.27	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	459,473,774	127,265.79	93.32
non-idle wait count	72,855,815	20,179.72	14.80
parse count (describe)	0	0.00	0.00
parse count (failures)	4	0.00	0.00
parse count (hard)	835,357	231.38	0.17
parse time cpu	178,796	49.52	0.04
physical read IO requests	2,489,662	689.59	0.51
physical read bytes	228,424,163,328	63,269,292.41	46,395.11
physical read total IO requests	2,621,812	726.19	0.53
physical read total bytes	278,924,170,752	77,256,865.75	56,652.14
physical read total multi block requests	1,735,652	480.74	0.35
physical reads cache	793,170	219.69	0.16
physical reads cache prefetch	7	0.00	0.00
physical reads direct	27,090,639	7,503.61	5.50
physical reads direct (lob)	305	0.08	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical write IO requests	415,099	114.97	0.08
physical write bytes	11,241,971,712	3,113,819.42	2,283.35
physical write total IO requests	8,352,749	2,313.56	1.70
physical write total bytes	54,746,099,712	15,163,662.81	11,119.45
physical write total multi block requests	66,723	18.48	0.01
physical writes direct	966	0.27	0.00
physical writes direct (lob)	89	0.02	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	1,371,345	379.84	0.28
physical writes non checkpoint	1,002,478	277.67	0.20
pinned buffers inspected	26,723	7.40	0.01
prefetch clients - default	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,615	1.00	0.00
queries parallelized	98	0.03	0.00
recovery block gets from cache	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	8,043,287	2,227.84	1.63
recursive cpu usage	181,305	50.22	0.04
redo KB read	27,275,462	7,554.80	5.54
redo KB read (memory)	13,261,613	3,673.22	2.69
redo KB read (memory) for transport	13,261,613	3,673.22	2.69
redo KB read for transport	13,369,025	3,702.97	2.72
redo blocks checksummed by FG (exclusive)	8,340,357	2,310.13	1.69
redo blocks read for recovery	0	0.00	0.00
redo blocks written	28,067,424	7,774.16	5.70
redo buffer allocation retries	536	0.15	0.00
redo entries	31,781,712	8,802.95	6.46
redo k-bytes read for recovery	0	0.00	0.00
redo log space requests	586	0.16	0.00
redo ordering marks	324,871	89.98	0.07
redo size for direct writes	2,031,744	562.76	0.41
redo subscn max counts	22,910	6.35	0.00
redo synch long waits	1,468	0.41	0.00
redo synch time	796,057	220.49	0.16
redo synch time (usec)	7,960,542,245	2,204,923.80	1,616.86
redo synch time overhead (usec)	223,699,255	61,960.58	45.44
redo synch time overhead count (<128 msec)	0	0.00	0.00
redo synch time overhead count (<2 msec)	4,921,179	1,363.08	1.00
redo synch time overhead count (<32 msec)	7	0.00	0.00
redo synch time overhead count (<8 msec)	172	0.05	0.00
redo synch time overhead count (>=128 msec)	3	0.00	0.00
redo synch writes	4,922,094	1,363.33	1.00
redo wastage	937,651,920	259,712.34	190.45
redo write broadcast ack count	15,959	4.42	0.00
redo write broadcast ack time	869,668	240.88	0.18
redo write broadcast lgwr post count	3	0.00	0.00
redo write info find	4,921,568	1,363.18	1.00
redo write info find fail	207	0.06	0.00
redo write time	221,266	61.29	0.04
redo writes	2,841,567	787.06	0.58
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	199,695	55.31	0.04
rollbacks only - consistent read gets	6,977	1.93	0.00
root node splits	0	0.00	0.00
rows fetched via callback	144,109	39.92	0.03
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	161,327	44.68	0.03
shared hash latch upgrades - wait	311	0.09	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	1,721,757	476.90	0.35
sorts (rows)	9,643,161	2,670.98	1.96
sql area evicted	836,802	231.78	0.17
sql area purged	4	0.00	0.00
summed dirty queue length	3,122,128	864.77	0.63
switch current to new buffer	6,127	1.70	0.00
table fetch by rowid	461,764,487	127,900.27	93.79
table fetch continued row	191,117	52.94	0.04
table scan blocks gotten	40,887,174	11,325.00	8.30
table scan rows gotten	1,527,433,147	423,070.89	310.24
table scans (direct read)	20	0.01	0.00
table scans (long tables)	20	0.01	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	96,707	26.79	0.02
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	6,480	1.79	0.00
total number of cf enq holders	741	0.21	0.00
total number of times SMON posted	177	0.05	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	47,005	13.02	0.01
transaction tables consistent read rollbacks	2,709	0.75	0.00
transaction tables consistent reads - undo records applied	102,730	28.45	0.02
undo change vector size	4,211,137,228	1,166,407.57	855.32
user logons cumulative	3,855	1.07	0.00
user logouts cumulative	3,850	1.07	0.00
write clones created for recovery	0	0.00	0.00
write clones created in background	4	0.00	0.00
write clones created in foreground	384	0.11	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
logons current	178	184
opened cursors current	433	514
session cursor cache count	79,923,081	79,972,377
session pga memory	4,454,975,184	4,415,702,672
session pga memory max	11,065,787,184	11,047,679,184
session uga memory	403,185,654,360	403,413,217,824
session uga memory max	9,733,531,071,584	9,737,884,773,752

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)	19	18.95

Back to Instance Activity Statistics
Back to Top

IO Stats

IOStat by Function summary
IOStat by Filetype summary
IOStat by Function/Filetype summary
Tablespace IO Stats
File IO Stats

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	206.7G	469.87	58.622M	0M	0.02	0M	0
Others	20G	28.13	5.659M	13.4G	6.87	3.81M	77K	0.26
RMAN	27.1G	8.40	7.68M	320M	0.28	.089M	3534	0.54
LGWR	5M	0.12	.001M	26.8G	2191.72	7.595M	494	0.16
DBWR	0M	0.00	0M	10.5G	114.77	2.968M	0
Buffer Cache Reads	6.1G	219.68	1.716M	0M	0.00	0M	793.1K	0.09
Direct Writes	0M	0.00	0M	7M	0.18	.002M	0
TOTAL:	259.8G	726.20	73.678M	51G	2313.84	14.463M	874.1K	0.11

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	212.8G	690.41	60.344M	10.5G	115.06	2.971M	0.09	0.67
Log File	13.4G	6.90	3.792M	26.8G	2191.62	7.593M	1.56	5.19
Archive Log	26.2G	7.45	7.428M	13.3G	3.76	3.761M	0.06	0.75
Control File	7.5G	21.44	2.114M	499M	3.47	.138M	0.15	1.50
TOTAL:	259.8G	726.20	73.678M	51G	2313.91	14.463M	0.12	0.71

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	206.7G	469.87	58.622M	0M	0.02	0M	0
Direct Reads (Data File)	206.7G	469.87	58.622M	0M	0.02	0M	0
Others	20G	28.13	5.659M	13.4G	6.87	3.81M	77K	0.26
Others (Log File)	13.4G	6.88	3.791M	0M	0.00	0M	265	0.95
Others (Archive Log)	0M	0.00	0M	13.3G	3.76	3.761M	0
Others (Control File)	6.6G	20.40	1.861M	174M	3.08	.048M	73.7K	0.26
Others (Data File)	24M	0.85	.007M	0M	0.02	0M	3056	0.06
RMAN	27.1G	8.40	7.68M	320M	0.28	.089M	3534	0.54
RMAN (Archive Log)	26.2G	7.45	7.428M	0M	0.00	0M	78	0.06
RMAN (Control File)	910M	0.94	.252M	320M	0.28	.089M	3456	0.55
LGWR	5M	0.12	.001M	26.8G	2191.77	7.595M	494	0.16
LGWR (Log File)	0M	0.02	0M	26.8G	2191.66	7.593M	152	0.13
LGWR (Control File)	5M	0.09	.001M	6M	0.11	.002M	342	0.18
DBWR	0M	0.00	0M	10.5G	114.69	2.966M	0
DBWR (Data File)	0M	0.00	0M	10.5G	114.69	2.966M	0
Buffer Cache Reads	6.1G	219.76	1.717M	0M	0.00	0M	793.4K	0.09
Buffer Cache Reads (Data File)	6.1G	219.76	1.717M	0M	0.00	0M	793.4K	0.09
Direct Writes	0M	0.00	0M	7M	0.18	.002M	0
Direct Writes (Data File)	0M	0.00	0M	7M	0.18	.002M	0
TOTAL:	259.8G	726.27	73.679M	51G	2313.81	14.461M	874.4K	0.11

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
TS_EBCC	2,394,138	663	0.12	11.61	29,908	193.54	0	8	21,619	0.71
TS_CYDB	4,952	1	0.51	1.00	231,709	1.37	1	64	3,984,923	2.03
IDX_EBCC	89,096	25	0.48	1.00	98,404	24.68	0	27	2,731	1.07
UNDOTBS1	15	0	0.00	1.00	54,548	0.00	0	15	16,082	0.04
SYSAUX	954	0	0.38	1.00	553	0.26	0	0	0	0.00
SYSTEM	417	0	0.29	1.02	67	0.12	0	0	9	1.11
SOE	35	0	0.29	1.00	15	0.01	0	0	0	0.00
CKS	15	0	0.00	1.00	15	0.00	0	0	0	0.00
IDX_CYDB	15	0	0.00	1.00	15	0.00	0	0	0	0.00
LOB_CYDB	15	0	0.00	1.00	15	0.00	0	0	0	0.00
TS_QMON_DATA	15	0	0.00	1.00	15	0.00	0	0	0	0.00
UNDOTBS2	15	0	0.00	1.00	15	0.00	0	0	8,455	18.18
USERS	15	0	0.00	1.00	15	0.00	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
CKS	/oradata/cydb/cjk1.dbf	15	0	0.00	1.00	0	0.00	15	0	0	0.00
IDX_EBCC	/oradata/cydb/idx_ebcc_01.dbf	16,589	5	0.48	1.00	5	0.48	19,834	5	2,177	1.23
IDX_EBCC	/oradata/cydb/idx_ebcc_02.dbf	16,414	5	0.48	1.00	5	0.48	16,301	5	18	0.00
IDX_EBCC	/oradata/cydb/idx_ebcc_03.dbf	13,369	4	0.47	1.00	4	0.47	12,800	4	122	0.41
IDX_EBCC	/oradata/cydb/idx_ebcc_04.dbf	16,198	4	0.49	1.00	4	0.49	19,285	5	180	0.56
IDX_EBCC	/oradata/cydb/idx_ebcc_05.dbf	16,522	5	0.49	1.00	5	0.49	19,487	5	161	0.50
IDX_EBCC	/oradata/cydb/idx_ebcc_06.dbf	10,004	3	0.49	1.00	3	0.49	10,697	3	73	0.27
IDX_CYDB	/oradata/cydb/idx_cydb_01.dbf	15	0	0.00	1.00	0	0.00	15	0	0	0.00
LOB_CYDB	/oradata/cydb/lob_cydb_01.dbf	15	0	0.00	1.00	0	0.00	15	0	0	0.00
SOE	/oradata/cydb/soe.dbf	35	0	0.29	1.00	0	0.29	15	0	0	0.00
SYSAUX	/oradata/cydb/sysaux01.dbf	626	0	0.40	1.00	0	0.38	282	0	0	0.00
SYSAUX	/oradata/cydb/sysaux02.dbf	328	0	0.34	1.00	0	0.34	271	0	0	0.00
SYSTEM	/oradata/cydb/system01.dbf	396	0	0.28	1.02	0	0.30	52	0	9	1.11
SYSTEM	/oradata/cydb/system02.dbf	21	0	0.48	1.00	0	0.00	15	0	0	0.00
TS_EBCC	/oradata/cydb/ts_ebcc_03.dbf	191,137	53	0.12	11.54	16	0.40	1,419	0	1,365	0.30
TS_EBCC	/oradata/cydb/ts_ebcc_04.dbf	193,703	54	0.12	11.64	16	0.40	2,020	1	4,768	1.35
TS_EBCC	/oradata/cydb/ts_ebcc_05.dbf	220,282	61	0.11	11.95	16	0.40	1,780	0	1,403	0.31
TS_EBCC	/oradata/cydb/ts_ebcc_06.dbf	211,767	59	0.11	11.75	17	0.39	1,795	0	1,526	0.33
TS_EBCC	/oradata/cydb/ts_ebcc_07.dbf	198,995	55	0.12	11.61	16	0.40	1,621	0	1,266	0.30
TS_EBCC	/oradata/cydb/ts_ebcc_08.dbf	214,966	60	0.10	12.07	16	0.40	1,825	1	1,403	0.38
TS_EBCC	/oradata/cydb/ts_ebcc_09.dbf	199,518	55	0.12	11.63	16	0.40	2,362	1	2,410	1.05
TS_EBCC	/oradata/cydb/ts_ebcc_10.dbf	206,264	57	0.10	12.04	15	0.39	1,848	1	1,965	0.99
TS_EBCC	/oradata/cydb/ts_ebcc_11.dbf	183,176	51	0.11	11.61	15	0.39	4,238	1	2,014	0.52
TS_EBCC	/oradata/cydb/ts_ebcc_12.dbf	169,719	47	0.14	10.83	16	0.39	1,789	0	1,288	0.26
TS_EBCC	/oradata/cydb/ts_ebcc_13.dbf	14,500	4	0.21	8.28	2	0.42	894	0	4	2.50
TS_EBCC	/oradata/cydb/ts_ebcc_14.dbf	17,245	5	0.18	9.45	2	0.42	1,299	0	12	0.00
TS_EBCC	/oradata/cydb/ts_ebcc_15.dbf	10,127	3	0.13	11.61	1	0.44	451	0	0	0.00
TS_EBCC	/oradata/cydb/ts_cydb_01.dbf	156,547	43	0.13	10.85	15	0.39	2,758	1	1,133	0.29
TS_EBCC	/oradata/cydb/ts_cydb_03.dbf	206,192	57	0.11	11.83	16	0.39	3,809	1	1,062	0.39
TS_CYDB	/oradata/cydb/ts_cydb_02.dbf	23	0	0.00	1.00	0	0.43	15,015	4	114,537	1.57
TS_CYDB	/oradata/cydb/ts_cydb_04.dbf	17	0	0.59	1.00	0	0.00	15,144	4	166,413	2.28
TS_CYDB	/oradata/cydb/ts_cydb_05.dbf	741	0	0.46	1.00	0	0.46	20,737	6	344,204	2.14
TS_CYDB	/oradata/cydb/ts_cydb_06.dbf	16	0	0.00	1.00	0	0.00	11,210	3	192,965	2.40
TS_CYDB	/oradata/cydb/ts_cydb_07.dbf	255	0	0.43	1.00	0	0.43	5,874	2	23,257	2.19
TS_CYDB	/oradata/cydb/ts_cydb_08.dbf	215	0	0.42	1.00	0	0.42	6,966	2	105,350	2.07
TS_CYDB	/oradata/cydb/ts_cydb_09.dbf	439	0	0.55	1.00	0	0.52	14,738	4	415,826	1.81
TS_CYDB	/oradata/cydb/ts_cydb_10.dbf	15	0	0.00	1.00	0	0.00	21,320	6	665,457	2.08
TS_CYDB	/oradata/cydb/ts_cydb_11.dbf	1,047	0	0.53	1.00	0	0.53	30,920	9	675,997	2.46
TS_CYDB	/oradata/cydb/ts_cydb_12.dbf	1,049	0	0.54	1.00	0	0.54	15,612	4	267,024	2.38
TS_CYDB	/oradata/cydb/ts_cydb_13.dbf	15	0	0.00	1.00	0	0.00	11,432	3	107,198	1.96
TS_CYDB	/oradata/cydb/ts_cydb_14.dbf	1,028	0	0.57	1.00	0	0.56	18,309	5	277,720	1.56
TS_CYDB	/oradata/cydb/ts_cydb_15.dbf	52	0	0.38	1.00	0	0.38	18,135	5	249,720	1.44
TS_CYDB	/oradata/cydb/ts_cydb_16.dbf	15	0	0.00	1.00	0	0.00	11,117	3	198,893	1.64
TS_CYDB	/oradata/cydb/ts_cydb_17.dbf	25	0	0.00	1.00	0	0.00	15,180	4	180,362	1.62
TS_QMON_DATA	/oradata/cydb/ts_qmon_data_01.dbf	15	0	0.00	1.00	0	0.00	15	0	0	0.00
UNDOTBS1	/oradata/cydb/undotbs01.dbf	15	0	0.00	1.00	0	0.00	54,548	15	16,082	0.04
UNDOTBS2	/oradata/cydb/undotbs02.dbf	15	0	0.00	1.00	0	0.00	15	0	8,455	18.18
USERS	/oradata/cydb/users01.dbf	15	0	0.00	1.00	0	0.00	15	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	5,488,902	100	555,879,873	793,199	1,371,345	0	0	4,038,624

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 1,372,311

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	1,043,787	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
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 RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	14	86320	2055081	12158481	15288183	12158481			5
E	0	18	118565	2717202	14977199	15288183	14977199			7

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

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 (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	4,608	0.10	540	1.35	2,440,381	1	577864.00
D	9,216	0.20	1,080	1.22	2,207,014	1	481800.00
D	13,824	0.29	1,620	1.17	2,114,952	1	443903.00
D	18,432	0.39	2,160	1.14	2,048,269	1	416453.00
D	23,040	0.49	2,699	1.11	1,998,160	1	395826.00
D	27,648	0.59	3,239	1.08	1,956,102	1	378512.00
D	32,256	0.68	3,779	1.04	1,878,578	1	346600.00
D	36,864	0.78	4,319	1.03	1,849,817	1	334761.00
D	41,472	0.88	4,859	1.01	1,824,889	1	324499.00
D	46,080	0.98	5,399	1.00	1,806,541	1	316946.00
D	47,104	1.00	5,519	1.00	1,803,345	1	315631.00
D	50,688	1.08	5,939	0.99	1,790,955	1	310530.00
D	55,296	1.17	6,479	0.99	1,777,227	1	304879.00
D	59,904	1.27	7,019	0.98	1,764,970	1	299834.00
D	64,512	1.37	7,558	0.97	1,754,093	1	295356.00
D	69,120	1.47	8,098	0.97	1,744,252	1	291305.00
D	73,728	1.57	8,638	0.96	1,735,509	1	287706.00
D	78,336	1.66	9,178	0.96	1,727,717	1	284499.00
D	82,944	1.76	9,718	0.95	1,721,055	1	281756.00
D	87,552	1.86	10,258	0.95	1,715,044	1	279282.00
D	92,160	1.96	10,798	0.94	1,700,067	1	273117.00

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	5,990	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	25,827	22,124	1,662.12	0.00	0.00	0.00	0.00	1,048,576
E	25,827	22,148	1,624.69	0.00	0.00	0.00	0.00	1,048,576

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	1,614,429	1,614,429
64K	128K	1,177	1,177
128K	256K	597	597
256K	512K	238	238
512K	1024K	308	308
1M	2M	1,010	1,010
2M	4M	64	64
4M	8M	2	2
8M	16M	72	72

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 Time
3,228	0.13	3,324,294.23	105,408.98	97.00	191,643,233
6,457	0.25	3,324,294.23	54,940.54	98.00	188,823,183
12,914	0.50	3,324,294.23	2,252.92	100.00	185,879,131
19,370	0.75	3,324,294.23	2,252.92	100.00	185,879,131
25,827	1.00	3,324,294.23	2,252.92	100.00	185,879,131
30,992	1.20	3,324,294.23	2,129.57	100.00	185,872,238
36,158	1.40	3,324,294.23	2,129.57	100.00	185,872,238
41,323	1.60	3,324,294.23	2,129.57	100.00	185,872,238
46,489	1.80	3,324,294.23	2,129.57	100.00	185,872,238
51,654	2.00	3,324,294.23	2,129.57	100.00	185,872,238
77,481	3.00	3,324,294.23	2,129.57	100.00	185,872,238
103,308	4.00	3,324,294.23	2,129.57	100.00	185,872,238
154,962	6.00	3,324,294.23	2,129.57	100.00	185,872,238
206,616	8.00	3,324,294.23	2,129.57	100.00	185,872,238

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 (K)
15,104	0.57	2,073	202,709	40,415,075	0.43	54,555,946	38.57	1,144,778
17,920	0.68	4,888	314,127	53,775,398	0.57	41,195,623	29.12	2,061,162
20,736	0.79	7,703	424,096	67,068,370	0.72	27,902,651	19.73	2,952,411
23,552	0.89	10,518	536,657	80,357,050	0.86	14,613,971	10.33	3,841,218
23,808	0.90	10,774	547,068	81,564,592	0.87	13,406,429	9.48	3,921,965
24,064	0.91	11,030	556,428	82,772,555	0.88	12,198,466	8.62	4,002,707
24,320	0.92	11,286	566,434	83,980,069	0.90	10,990,952	7.77	4,083,439
24,576	0.93	11,542	576,838	85,187,978	0.91	9,783,043	6.92	4,164,169
24,832	0.94	11,798	587,159	86,395,818	0.92	8,575,203	6.06	4,244,901
25,088	0.95	12,054	596,996	87,603,484	0.94	7,367,537	5.21	30,651
25,344	0.96	12,309	606,630	88,811,224	0.95	6,159,797	4.35	111,360
25,600	0.97	12,565	616,739	90,019,102	0.96	4,951,919	3.50	192,072
25,856	0.98	12,821	627,892	91,226,870	0.98	3,744,151	2.65	272,782
26,112	0.99	13,077	638,034	92,435,282	0.99	2,535,739	1.79	353,695
26,368	1.00	13,333	648,137	93,556,481	1.00	1,414,540	1.00	430,175
26,624	1.01	13,589	657,724	93,576,647	1.00	1,394,374	0.99	438,905
26,880	1.02	13,845	667,671	93,576,967	1.00	1,394,054	0.99	439,057
27,136	1.03	14,101	678,462	93,577,295	1.00	1,393,726	0.99	439,213
27,392	1.04	14,357	688,395	93,577,603	1.00	1,393,418	0.99	439,360
27,648	1.05	14,613	699,011	93,577,934	1.00	1,393,087	0.98	439,517
27,904	1.06	14,868	709,617	93,578,233	1.00	1,392,788	0.98	439,663
28,160	1.07	15,124	720,304	93,578,531	1.00	1,392,490	0.98	439,808
28,416	1.08	15,380	730,418	93,578,825	1.00	1,392,196	0.98	439,954
28,672	1.09	15,635	740,036	93,579,115	1.00	1,391,906	0.98	440,097
29,184	1.11	16,147	760,922	93,579,689	1.00	1,391,332	0.98	440,378
32,000	1.21	18,963	871,713	93,582,677	1.00	1,388,344	0.98	441,846
34,816	1.32	21,779	982,920	93,585,538	1.00	1,385,483	0.98	443,234
37,632	1.43	24,594	1,093,561	93,589,466	1.00	1,381,555	0.98	444,998
40,448	1.53	27,409	1,203,871	93,594,122	1.00	1,376,899	0.97	447,018
43,264	1.64	30,222	1,315,041	93,598,429	1.00	1,372,592	0.97	448,890
46,080	1.75	33,037	1,427,734	93,602,166	1.00	1,368,855	0.97	450,559
48,896	1.85	35,853	1,540,299	93,605,606	1.00	1,365,415	0.97	452,109
51,712	1.96	38,668	1,650,952	93,608,894	1.00	1,362,127	0.96	453,579
54,528	2.07	41,483	1,762,145	93,612,035	1.00	1,358,986	0.96	454,978

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
24,240	0.31	70,280,230	2,457,232,752
29,088	0.38	43,616,524	2,457,232,752
33,936	0.44	17,097,556	2,457,232,752
38,784	0.50	17,001,626	2,222,257,390
43,632	0.56	16,962,917	2,129,565,651
48,480	0.63	16,934,306	2,062,481,358
53,328	0.69	16,914,110	2,011,987,804
58,176	0.75	16,895,597	1,969,609,285
63,024	0.81	16,863,620	1,891,524,610
67,872	0.88	16,845,107	1,837,424,373
72,720	0.94	16,836,692	1,819,030,293
77,568	1.00	16,829,959	1,803,341,224
82,416	1.06	16,823,229	1,789,455,497
87,264	1.13	16,818,180	1,777,192,776
92,112	1.19	16,811,448	1,819,030,293
96,960	1.25	16,806,399	1,803,341,224
101,808	1.31	16,797,984	1,777,192,776
106,656	1.38	16,792,936	1,789,455,497
111,504	1.44	16,787,887	1,777,192,776
116,352	1.50	16,782,838	1,756,274,018
121,200	1.56	16,779,472	1,747,437,646
126,048	1.63	16,772,740	1,747,437,646
130,896	1.69	16,769,375	1,739,683,279
135,744	1.75	16,767,692	1,733,010,916
140,592	1.81	16,760,960	1,711,911,824
145,440	1.88	16,757,594	1,711,911,824
150,288	1.94	16,757,594	1,711,911,824
155,136	2.00	16,757,594	1,711,911,824

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)
256	0.50	0	0	0	0
512	1.00	0	0	0	0
768	1.50	0	0	0	0
1,024	2.00	0	0	0	0
1,280	2.50	0	0	0	0
1,536	3.00	0	0	0	0
1,792	3.50	0	0	0	0
2,048	4.00	0	0	0	0
2,304	4.50	0	0	0	0
2,560	5.00	0	0	0	0
2,816	5.50	0	0	0	0
3,072	6.00	0	0	0	0
3,328	6.50	0	0	0	0
3,584	7.00	0	0	0	0
3,840	7.50	0	0	0	0
4,096	8.00	0	0	0	0
4,352	8.50	0	0	0	0
4,608	9.00	0	0	0	0
4,864	9.50	0	0	0	0
5,120	10.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	4,009,524	8,099	2
undo header	24,443	154	6
1st level bmb	296	0	0
2nd level bmb	59	0	1
undo block	92	0	0
file header block	8	0	0
segment header	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (index contention)	509,965	509,950	0	493,044	1,266	2.57
FB-Format Block	15,675	15,675	0	12,289	5	0.42
SQ-Sequence Cache	6,737	6,737	0	2,613	2	0.89
CF-Controlfile Transaction	11,716	11,715	1	409	1	1.98
TX-Transaction (allocate ITL entry)	1,875	1,875	0	1,667	1	0.45
KO-Multiple Object Checkpoint (fast object checkpoint)	296	296	0	103	0	1.84
PS-PX Process Reservation	978	978	0	484	0	0.35
TM-DML	4,983,491	4,983,290	0	1	0	120.00
HW-Segment High Water Mark	7,649	7,637	12	97	0	0.93
TT-Tablespace	94,796	94,796	0	37	0	0.27
US-Undo Segment	291	291	0	25	0	0.40
WF-AWR Flush	20	20	0	16	0	0.63
TX-Transaction	5,137,940	5,136,338	0	7	0	1.43
SR-Synchronized Replication	414	414	0	1	0	10.00
WL-Being Written Redo Log	28	20	8	19	0	0.00
TA-Instance Undo	14	14	0	14	0	0.00
TD-KTF map table enqueue (KTF dump entries)	9	9	0	8	0	0.00
RS-Reclaimable Space (prevent file delete)	78	78	0	7	0	0.00
CR-Reuse Block Range (block range reuse ckpt)	11,628	11,628	0	2	0	0.00
JS-Job Scheduler (job run lock - synchronize)	2	2	0	2	0	0.00
MW-MWIN Schedule	2	2	0	2	0	0.00
TX-Transaction (row lock contention)	2	2	0	2	0	0.00
AE-Edition Lock (lock)	3,868	3,868	0	1	0	0.00
AF-Advisor Framework (task serialization)	6	6	0	1	0	0.00
PW-Buffer Cache PreWarm (flush prewarm buffers)	1	1	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	714.00	4,976,513	1,740	60	31.7/42	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
16-Dec 14:50	136,650	938,600	535	60	32	0/0	0/0/0/0/0/0
16-Dec 14:40	124,885	862,182	1,140	57	32	0/0	0/0/0/0/0/0
16-Dec 14:30	121,312	835,809	1,740	59	42	0/0	0/0/0/0/0/0
16-Dec 14:20	114,630	800,975	1,137	56	32	0/0	0/0/0/0/0/0
16-Dec 14:10	108,852	773,180	1,737	56	42	0/0	0/0/0/0/0/0
16-Dec 14:00	107,667	765,767	1,134	54	32	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
Mutex Sleep Summary
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
AQ deq hash table latch	1	0.00		0	0
AQ dequeue txn counter latch	842	0.00		0	0
ASM db client latch	11,716	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	67	0.00		0	0
AWR Alerted Metric Element list	35,626	0.00		0	0
Change Notification Hash table latch	1,201	0.00		0	0
Consistent RBA	2,847,999	0.07	0.04	0	0
DML lock allocation	9,971,113	0.01	0.02	0	0
Event Group Locks	8,195	0.06	0.00	0	0
FAL Queue	294	0.00		0	0
FIB s.o chain latch	846	0.00		0	0
FOB s.o list latch	45,821	3.93	0.00	0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC other latch	30	0.00		0	0
IPC stats buffer allocation latch	14,432	0.00		0	14,450	0.04
In memory undo latch	1	0.00		0	0
JS Sh mem access	9	0.00		0	0
JS broadcast add buf latch	833	0.00		0	0
JS broadcast drop buf latch	833	0.00		0	0
JS broadcast load blnc latch	723	0.00		0	0
JS mem alloc latch	4	0.00		0	0
JS queue access latch	5	0.00		0	0
JS queue state obj latch	30,696	0.00		0	0
JS slv state obj latch	9	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1,713,863	1.18	0.01	0	167,156	0.44
KJCT flow control latch	22,567,305	0.08	0.01	0	0
KMG MMAN ready and startup request latch	1,203	0.00		0	0
KSXR large replies	242	0.00		0	0
KTF sga latch	30	0.00		0	1,213	0.00
KWQMN job cache list latch	1,180	0.00		0	0
KWQP Prop Status	416	0.00		0	0
KWQS pqueue ctx latch	2	0.00		0	0
LGWR NS Write	5,613,295	0.00	0.28	0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	71	0.00
Memory Management Latch	1	0.00		0	1,203	0.00
Memory Queue	417	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	2,480	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	15,601	0.00		0	0
OS process allocation	15,022	0.55	0.00	0	0
OS process: request allocation	7,748	0.28	0.00	0	0
PL/SQL warning settings	11,622	0.01	0.00	0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	79,787	0.00		0	0
SGA IO buffer pool latch	112	0.00		0	112	0.00
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	1	0.00		0	3,595	0.00
SQL memory manager workarea list latch	318,979	0.00		0	0
Shared B-Tree	2,588	0.35	0.00	0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	213,069	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	379,307	1.11	0.02	0	0
active service list	37,465	0.47	0.07	0	2,788	0.00
alert log latch	95	0.00		0	0
archive control	556	0.00		0	0
archive process latch	731	0.00		0	0
begin backup scn array	95	0.00		0	0
bq:time manger info latch	127	0.00		0	0
buffer pool	1	0.00		0	0
bufq statistics	416	0.00		0	0
business card	197	0.00		0	0
cache buffer handles	250,162	0.01	0.00	0	0
cache buffers chains	1,246,129,240	0.19	0.06	14	25,040,931	0.32
cache buffers lru chain	10,689,157	0.04	0.06	0	13,421,060	0.03
cache table scan latch	0			0	1	0.00
call allocation	18,002	1.94	0.54	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	7,791	0.82	0.02	0	0
channel operations parent latch	3,178,506	0.00	0.01	0	0
checkpoint queue latch	21,022,013	0.01	0.01	0	7,067,467	0.00
client/application info	33,145	0.00		0	0
compile environment latch	4,317	0.00		0	0
corrupted undo seg latch	646,029	0.00	0.00	0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	67	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	67	0.00		0	0
dml lock allocation	67	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	8,629	0.54	0.00	0	0
eighth spare latch - X parent	1	0.00		0	0
eleventh spare latch - children	1	0.00		0	0
enqueue freelist latch	1	0.00		0	20,071,142	0.00
enqueue hash chains	52,351,377	1.11	0.01	1	1,684	0.42
enqueue sob latch	3	0.00		0	0
enqueues	20	0.00		0	0
error message lists	458	0.00		0	0
fifteenth spare latch - children	1	0.00		0	0
file cache latch	4,884	0.00		0	0
first Audit Vault latch	1,185	0.25	0.00	0	0
flashback copy	1	0.00		0	0
fourteenth spare latch - children	1	0.00		0	0
fourth Audit Vault latch	1	0.00		0	0
gc element	59,815,057	0.48	0.08	1	484,622	0.18
gcs commit scn state	1	0.00		0	0
gcs opaque info freelist	14,314,684	0.31	0.02	0	0
gcs partitioned table hash	39,319,217	0.02	0.00	0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs remaster request queue	1	0.00		0	0
gcs resource freelist	2,123,358	0.01	0.03	0	0
gcs resource hash	40,262,883	0.07	0.08	0	166,934	0.12
gcs resource scan list	394,681	0.00	0.18	0	0
gcs resource validate list	1	0.00		0	0
gcs shadows freelist	1,028,858	0.00	0.00	0	0
ges caches resource lists	4,419,802	0.12	0.04	0	701,163	0.04
ges deadlock list	988,566	0.03	0.02	0	162	0.62
ges domain table	24,035,627	0.00	0.02	0	0
ges enqueue table freelist	24,312,348	0.01	0.07	0	0
ges group table	24,052,671	0.00	0.00	0	0
ges process hash list	214,135	0.00	0.00	0	0
ges process parent latch	48,920,486	0.03	0.19	0	0
ges process table freelist	7,748	1.14	0.00	0	0
ges resource hash list	44,245,034	1.27	0.25	32	69,796	3.92
ges resource scan list	85,675	0.01	0.00	0	0
ges resource table freelist	692,125	0.00	0.00	0	0
ges timeout list	15,850	0.02	0.00	0	3,072	0.00
ges value block free list	9	0.00		0	0
global KZLD latch for mem in SGA	3,683	0.03	0.00	0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	681	0.00		0	2,703,079	0.02
hash table modification latch	81	0.00		0	0
heartbeat check	1	0.00		0	1,382	0.00
heartbeat structure management	0			0	722	0.00
interrupt manipulation	3,607	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	3	0.00		0	2	0.00
job_queue_processes free list latch	4	0.00		0	0
job_queue_processes parameter latch	790	0.00		0	0
k2q global data latch	2,406	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	19	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kokc descriptor allocation latch	54	0.00		0	0
krbmrosl	491	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	164	0.00		0	0
ksim membership request latch	0			0	3,471	0.00
kss move lock	37	0.00		0	0
ksuosstats global area	364	0.00		0	0
ksv allocation latch	138	0.00		0	0
ksv class latch	6,619	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksxp shared latch	7,748	0.40	0.00	0	0
ksxp so latch	7,748	0.05	0.00	0	0
ksz_so allocation latch	7,748	1.03	0.00	0	0
ktm global data	753	0.00		0	0
kwqbsn:qsga	2,060	0.29	0.00	0	0
lgwr LWN SCN	2,894,772	0.34	0.00	0	0
list of block allocation	7,880	0.38	0.00	0	0
loader state object freelist	902	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	13	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	2	0.00		0	0
logminer local	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	162	0.00		0	75	0.00
managed standby latch	219	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	20,706	0.00		0	0
messages	9,942,560	0.36	0.01	0	0
mostly latch-free SCN	3,225,818	9.22	0.01	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	1,072	0.00		0	0
name-service memory objects	62,751	0.00		0	0
name-service namespace bucket	50,453	0.00		0	0
name-service pending queue	31,276	0.00		0	0
name-service request queue	81,733	0.00		0	0
ncodef allocation latch	67	0.00		0	0
nineth spare latch - X parent	1	0.00		0	0
object queue header heap	579,385	0.00		0	578,569	0.00
object queue header operation	29,030,079	0.02	0.03	0	0
object stats modification	3	0.00		0	0
parallel query alloc buffer	6,965	0.00		0	0
parallel query stats	733	0.00		0	0
parallel txn reco latch	28,672	0.00		0	0
parameter list	11,755	0.02	0.00	0	0
parameter table management	11,078	0.09	0.00	0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	10,757,626	0.29	0.01	0	10,846,194	0.40
process allocation	25,270	0.29	0.07	0	3,864	0.34
process group creation	7,748	0.31	0.00	0	0
process queue	2,041	0.00		0	0
process queue reference	39,010	0.00	0.00	0	3,670	0.00
qmn state object latch	3	0.00		0	0
qmn task queue latch	4,524	5.00	0.00	0	0
query server freelists	1,531	0.00		0	0
query server process	82	0.00		0	0
queued dump request	12	0.00		0	0
queuing load statistics	1	0.00		0	0
readredo stats and histogram	2,817,424	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	18,557,481	0.84	0.04	1	31,599,633	2.22
redo copy	1	0.00		0	31,789,350	0.60
redo writing	10,024,085	0.04	0.03	0	0
resmgr group change latch	4,845	0.02	0.00	0	0
resmgr:active threads	8,629	0.00		0	0
resmgr:actses change group	4,312	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	8,628	1.18	0.00	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	81	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	123,046,120	0.47	0.00	0	989	0.30
rules engine rule set statistics	100	0.00		0	0
second Audit Vault latch	1	0.00		0	0
sequence cache	12,375,904	0.87	0.01	0	0
session allocation	6,885,830	0.00	0.03	0	6,877,243	0.00
session idle bit	40,675,044	0.00	0.02	0	0
session queue latch	1	0.00		0	0
session state list latch	3,782	0.45	0.00	0	0
session switching	3,939	2.51	0.01	0	0
session timer	1,211	0.00		0	0
seventh spare latch - X parent	1	0.00		0	0
shared pool	47,042,095	0.22	0.18	2	1,556	0.13
shared pool sim alloc	1	0.00		0	0
shared pool simulator	2,838,274	0.01	0.05	0	0
sim partition latch	1	0.00		0	0
simulator hash latch	36,427,814	0.00	0.06	0	0
simulator lru latch	1	0.00		0	36,290,719	0.11
sixth spare latch - X parent	1	0.00		0	0
sort extent pool	294	0.00		0	0
space background state object latch	10	0.00		0	0
space background task latch	4,133	0.24	0.10	0	2,411	0.00
state object free list	2	0.00		0	0
statistics aggregation	700	0.00		0	0
tablespace key chain	40,604	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
tenth spare latch - X parent	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
thirteenth spare latch - children	1	0.00		0	0
threshold alerts latch	224	0.00		0	0
transaction allocation	9,617	0.03	0.00	0	0
twelfth spare latch - children	1	0.00		0	0
twenty-fifth spare latch - S par	1	0.00		0	0
twenty-first spare latch - S par	1	0.00		0	0
twenty-fourth spare latch - S par	1	0.00		0	0
twenty-second spare latch - S par	1	0.00		0	0
twenty-third spare latch - S par	1	0.00		0	0
undo global data	25,907,823	0.01	0.01	0	204	0.00
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0
write info latch	0			0	2,892,221	0.63

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	1,246,129,240	2,405,457	135,166	2,275,320
row cache objects	123,046,120	583,790	2,300	581,555
enqueue hash chains	52,351,377	582,312	6,445	575,956
ges resource hash list	44,245,034	560,830	141,676	424,548
mostly latch-free SCN	3,225,818	297,419	1,647	295,796
gc element	59,815,057	287,058	24,331	263,043
redo allocation	18,557,481	155,109	6,015	149,135
sequence cache	12,375,904	107,440	710	106,734
shared pool	47,042,095	102,335	18,532	84,117
gcs opaque info freelist	14,314,684	43,851	944	42,911
messages	9,942,560	36,224	513	35,716
post/wait queue	10,757,626	31,033	201	30,833
gcs resource hash	40,262,883	27,972	2,104	25,895
KJC message pool free list	1,713,863	20,175	302	19,875
KJCT flow control latch	22,567,305	18,548	237	18,313
ges process parent latch	48,920,486	15,135	2,860	12,275
lgwr LWN SCN	2,894,772	9,712	41	9,671
object queue header operation	29,030,079	5,420	165	5,255
ges caches resource lists	4,419,802	5,234	186	5,048
redo writing	10,024,085	4,331	125	4,206
active checkpoint queue latch	379,307	4,216	88	4,128
cache buffers lru chain	10,689,157	3,897	253	3,644
undo global data	25,907,823	3,738	56	3,682
checkpoint queue latch	21,022,013	2,116	29	2,088
Consistent RBA	2,847,999	1,945	87	1,858
session idle bit	40,675,044	1,897	36	1,861
FOB s.o list latch	45,821	1,803	5	1,799
ges enqueue table freelist	24,312,348	1,527	114	1,414
DML lock allocation	9,971,113	898	14	884
ges domain table	24,035,627	711	12	700
call allocation	18,002	349	189	191
session allocation	6,885,830	278	7	271
ges deadlock list	988,566	265	4	261
shared pool simulator	2,838,274	255	12	244
active service list	37,465	176	12	164
channel operations parent latch	3,178,506	154	1	153
gcs resource freelist	2,123,358	147	4	143
simulator hash latch	36,427,814	104	6	98
session switching	3,939	99	1	98
process allocation	25,270	73	5	68
channel handle pool latch	7,791	64	1	63
LGWR NS Write	5,613,295	18	5	13
gcs resource scan list	394,681	11	2	9
space background task latch	4,133	10	1	9

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
DML lock allocation	ktaiam	11	8
DML lock allocation	ktaidm	3	6
FOB s.o list latch	ksfd_allfob	3	4
FOB s.o list latch	ksfd_fobd	2	1
KJC message pool free list	kjcsmpav: allocate a msg buffer	235	302
KJC message pool free list	kjcspfmbq: free vector of msg buffers	67	0
KJCT flow control latch	kjctcsnd: send normal message	156	117
KJCT flow control latch	kjcts_sqenq: queue a message	60	45
KJCT flow control latch	kjcts_sedeqv2: dequeue a vector of msgs	10	23
KJCT flow control latch	kjctr_updatetkt: update ticket info	8	47
KJCT flow control latch	kjcts_sqenq2: queue a message	2	5
KJCT flow control latch	kjctssqmg: adjuest send tickets	1	0
LGWR NS Write	kcrrnsltwa	4	0
LGWR NS Write	kcrrnsltwb	1	0
PC and Classifier lists for WLM	No latch	1	0
active checkpoint queue latch	kcbbacq: scan active checkpoints	88	88
active service list	kswslogon: session logout	14	14
cache buffers chains	kcbchg1: clear MS bit	61,109	1,752
cache buffers chains	kcbget: fast exchange	16,626	42,003
cache buffers chains	kcllkopesc	16,158	37
cache buffers chains	kcbzwb	10,336	14,334
cache buffers chains	kcbget: pin buffer	6,550	12,851
cache buffers chains	kcbget: fast path	4,489	10,639
cache buffers chains	kcbrls_2	3,459	180
cache buffers chains	kclbla	3,145	2,736
cache buffers chains	kcbgcur_2	3,041	10,390
cache buffers chains	kcbnlc	2,594	13,469
cache buffers chains	kcbsod1	2,049	4,995
cache buffers chains	kcbgcur_4	1,579	5,567
cache buffers chains	kcbso1: set no access	1,543	2,032
cache buffers chains	kcbesc: escalate	1,459	398
cache buffers chains	kclwlr	1,165	680
cache buffers chains	kcbget: upgrade latch	989	893
cache buffers chains	kcbgcur: fast path (shr)	739	691
cache buffers chains	kcbget: release excl	733	435
cache buffers chains	kcbzib: finish processing buffer	706	46
cache buffers chains	kcbgtcr: fast path	663	509
cache buffers chains	kcbgtcr: fast path (cr pin)	582	398
cache buffers chains	kcbchg1: mod cur pin	528	1,440
cache buffers chains	kcbget: exchange	478	680
cache buffers chains	kclcqchk	426	0
cache buffers chains	kcbzib: exchange rls	423	449
cache buffers chains	kcllkopb_1	242	328
cache buffers chains	kcbgtcr_2	212	122
cache buffers chains	kcbget: release shr	183	862
cache buffers chains	kclcqchk_1	96	12,962
cache buffers chains	kclrlstp	40	184
cache buffers chains	kcbbxsv	15	11
cache buffers chains	kcbchg1: mod cr pin	12	6
cache buffers chains	kcbgtcr_1	11	0
cache buffers chains	kclpdcl_1	11	113
cache buffers chains	kcb_is_private	8	148
cache buffers chains	kclwcrs	8	9
cache buffers chains	kcbzgb: scan from tail. nowait	7	0
cache buffers chains	kcbgtcr: kslbegin excl	6	12
cache buffers chains	kclpdcl	6	0
cache buffers chains	kclchkblkdma	4	23
cache buffers chains	kcbbic1	2	2
cache buffers chains	kcbchg1: aux pin	2	2
cache buffers chains	kcbrls: fast release	2	17
cache buffers chains	kclwrt	2	6
cache buffers chains	kcbbic2	1	1
cache buffers chains	kcbget: release upgrade	1	0
cache buffers chains	kcbgtcr: kslbegin shared	1	1
cache buffers chains	kcl_fairness	1	0
cache buffers chains	kclgcbbrcbk_1	1	0
cache buffers lru chain	kcbzgws	113	0
cache buffers lru chain	kcbzgb	80	177
cache buffers lru chain	kcbzgb_2	38	8
cache buffers lru chain	kcbbic2	6	40
cache buffers lru chain	kcbbxsv: move to being written	6	0
cache buffers lru chain	kcbo_link_q	5	0
cache buffers lru chain	kclmvreqbg	2	11
cache buffers lru chain	kcbbwlru	1	13
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP_2	1	0
cache buffers lru chain	kclwcrs	1	0
call allocation	ksuxds	186	176
call allocation	ksudlp: top call	3	13
channel handle pool latch	ksrchdelete()	1	1
channel operations parent latch	ksrpubwait():1	1	0
checkpoint queue latch	kcbklbc_cql	13	0
checkpoint queue latch	kcbkubc_4	12	12
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	3	10
checkpoint queue latch	kcbbwdl: thread checkpoint queue	1	2
enqueue hash chains	ksqrcl	2,446	2,184
enqueue hash chains	ksqcmi: if lk mode not requested	1,718	1,161
enqueue hash chains	ksqgtl3	1,215	1,427
enqueue hash chains	ksqcmi: if lk mode requested	534	1,309
enqueue hash chains	ksqexpandwait	315	272
enqueue hash chains	ksqexpandres	166	6
enqueue hash chains	ksqinq	26	61
enqueue hash chains	ksqexpandlmd	25	25
gc element	kclchkping	19,674	111
gc element	kclnfndnewm	4,095	5,841
gc element	kclbla	746	421
gc element	kclcqchk	271	13,887
gc element	KCLUNLNK	195	997
gc element	kclulb	152	385
gc element	kclrwrite	151	276
gc element	kclfwrite1	144	220
gc element	kclrlstp	75	144
gc element	kclcqchk_1	58	11
gc element	kclwrt	58	52
gc element	kclebs	42	53
gc element	kclnfnds	39	3,030
gc element	kclnfnd	25	86
gc element	kclfwrite2	21	3
gc element	kclrwrite_10	12	0
gc element	kclplz_1	9	23
gc element	kcllwr	7	1
gc element	kclplz	7	205
gc element	kclpdc_14	5	5
gc element	kclpdcl	5	28
gc element	kcl_fairness	3	0
gc element	kcllkopesc	2	5
gc element	kclshrsplit	2	11
gc element	kclhngcbk1	1	0
gcs opaque info freelist	kjbrinfofree free opaque info	538	401
gcs opaque info freelist	kjbrcvt save opaque info	406	543
gcs resource freelist	kjbralc add resource	4	1
gcs resource hash	kjbassume	1,712	139
gcs resource hash	kjbconvert	152	94
gcs resource hash	kjbcropen	76	27
gcs resource hash	kclfwrite1	37	23
gcs resource hash	kclrwrite	28	24
gcs resource hash	kjbmpconvert	24	1,411
gcs resource hash	kjbopen:affinity	19	10
gcs resource hash	kjbopen	14	4
gcs resource hash	kjbrwrdone reget	14	5
gcs resource hash	kclpdc	9	38
gcs resource hash	kjbcrconvert	6	6
gcs resource hash	kjblpbast	4	184
gcs resource hash	kjbcrcomplete	1	7
gcs resource hash	kjblpflushpi	1	7
gcs resource hash	kjblpwreq	1	3
gcs resource hash	kjblpwreq reget	1	1
gcs resource hash	kjbmpclose	1	36
gcs resource hash	kjbmpcreatepi	1	2
gcs resource hash	kjbmpopen	1	15
gcs resource hash	kjbmpwrite	1	11
gcs resource hash	kjbrwreq reget	1	0
gcs resource scan list	kjbrgscn deq res from scan q	1	1
gcs resource scan list	kjbrpcvt enq res to scan q	1	1
ges caches resource lists	kjchc: clean resource cache	108	0
ges caches resource lists	kjruref: directly free resource	44	81
ges caches resource lists	kjrm2c: move resource to cache	30	105
ges caches resource lists	kjruch: cached obj cleanup	3	0
ges caches resource lists	kjrchc2: cached obj cleanup	1	0
ges deadlock list	kjcv_move_cg_fg: remove from dd timer_q	2	0
ges deadlock list	kjcvdld: remove from dd timer_q	1	1
ges deadlock list	kjcvdte: insert into dd timer_q	1	3
ges domain table	kjdmlrm: remove a lock from its xid-hashed lock list	9	7
ges domain table	kjdmlad: add a lock to an xid-hashed lock list	3	5
ges enqueue table freelist	kjlfr: remove lock from parent object	90	99
ges enqueue table freelist	kjlalc: lock allocation	24	15
ges process parent latch	kjata_fg	2,860	0
ges resource hash list	kjlrlr: remove lock from resource queue	70,675	1,938
ges resource hash list	kjakoca: search for resp by resname	43,431	115,460
ges resource hash list	kjrmas1: lookup master node	19,305	3,593
ges resource hash list	kjcvscn: remove from scan queue	2,969	0
ges resource hash list	kjakcai: search for resp by resname	2,707	1,278
ges resource hash list	kjrref: find matched resource	1,934	18,573
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	605	825
ges resource hash list	kjrmas3: resource mastering	50	9
lgwr LWN SCN	kcs023	371	0
messages	ksaamb: after wakeup	404	353
messages	ksarcv	86	138
messages	ksarcv: after wait	23	22
mostly latch-free SCN	kcslcu3	1,278	1,688
mostly latch-free SCN	kcs01	44	87
mostly latch-free SCN	kcsnew_scn_rba	43	0
mostly latch-free SCN	kcs024	39	0
object queue header operation	kcbo_link_q	59	17
object queue header operation	kcbo_switch_cq	42	44
object queue header operation	kcbo_switch_q_bg	28	25
object queue header operation	kcbo_unlink_q	19	18
object queue header operation	kcbo_switch_mq_bg	13	26
object queue header operation	kcbo_link_q:reget	5	0
post/wait queue	ksliwat:add:nowait	102	0
post/wait queue	kslpstevent:get	56	76
post/wait queue	kslpstevent:reget	38	48
post/wait queue	ksliwat:remove	5	75
process allocation	ksucrp:1	3	0
process allocation	ksufap: active procs	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	5,191	0
redo allocation	kcrfw_redo_gen: redo allocation 3	371	2,546
redo allocation	kcrfw_post: more space	182	1,532
redo allocation	kcrfw_redo_write: before write	179	1,937
redo allocation	kcrfw_redo_gen: redo allocation 2	92	0
redo writing	kcrfwcr	77	114
redo writing	kcrfw_post: rba scn pair	35	0
redo writing	kcrfw_cal_target_rba	7	6
redo writing	kcrfw_post: after write	5	4
redo writing	kcrfsr: rba scn pair	1	1
row cache objects	kqrpre: find obj	977	1,771
row cache objects	kqreqd: reget	850	38
row cache objects	kqreqd	304	352
row cache objects	kqrso	164	131
row cache objects	kqrbgl	3	1
sequence cache	kdnnxt: cached seq	377	20
sequence cache	kdnssd	246	22
sequence cache	kdnss	87	668
session allocation	ksucri_int : SSO	4	0
session allocation	ksuxds	3	7
session idle bit	ksupuc: set busy	17	10
session idle bit	ksuxds	13	10
session idle bit	ksupuc: clear busy	7	17
session switching	kskexeall	1	1
shared pool	kghalo	15,869	7,436
shared pool	kghalp	2,232	6,591
shared pool	kghupr1	288	3,438
shared pool	kghasp	66	82
shared pool	kgh_heap_sizes	65	921
shared pool	kghfre	11	63
shared pool simulator	kglsim_upd_newhp	12	6
simulator hash latch	kcbsacc: lookup dba	6	4
undo global data	ktudba: KSLBEGIN	18	17
undo global data	ktudnx:child	16	8
undo global data	ktusmupst: KSLBEGIN	15	17
undo global data	ktufrbs_2	4	12
undo global data	kturax	2	0
undo global data	ktucof: at start	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglpnal2 91	6,008
Library Cache	kglpin1 4	3,988
Library Cache	kglpndl1 95	2,515
Cursor Pin	kkslce [KKSCHLPIN2]	2,110
Library Cache	kglpnal1 90	1,985
Library Cache	kgllkdl1 85	1,443
Library Cache	kglget1 1	1,297
Library Cache	kglhdgn2 106	1,197
Library Cache	kglhdgh1 64	1,157
Cursor Pin	kksLockDelete [KKSCHLPIN6]	814
Library Cache	kglobpn1 71	704
Library Cache	kgllkal1 80	692
Library Cache	kglget2 2	625
Library Cache	kgldtin1 42	474
Cursor Pin	kksfbc [KKSCHLFSP2]	331
Library Cache	kglhdgn1 62	272
Library Cache	kgllkc1 57	54
Library Cache	kglrfcl1 79	42
Cursor Pin	kksfbc [KKSCHLPIN1]	17
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	8
Library Cache	kglhdgc1 102	7
Library Cache	kglUpgradeLock 119	5
Library Cache	kglrdtin1 44	3
Cursor Parent	kkscsPruneChild [KKSPRTLOC35]	2
Library Cache	kglati1 45	1
Library Cache	kgllldl2 112	1

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 Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
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: 584,427,784
Captured Segments account for 95.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
EBCC_X	TS_EBCC	ECC_PAYEE_LIST	TABLE	391,620,192	67.01
EBCC_X	TS_EBCC	ECC_PAY_LOG	TABLE	27,152,416	4.65
EBCC_X	TS_EBCC	ECC_ACCOUNT_AUTH	TABLE	10,869,936	1.86
EBCC_X	TS_EBCC	ECC_BASE_ORDER	TABLE	9,326,032	1.60
EBCC_X	IDX_EBCC	ECC_PAYEE_LIST_1	INDEX	7,997,248	1.37

Buffer Nowait %:	99.28	Redo NoWait %:	100.00
Buffer Hit %:	99.86	In-memory Sort %:	100.00
Library Hit %:	82.91	Soft Parse %:	69.22
Execute to Parse %:	66.10	Latch Hit %:	99.75
Parse CPU to Parse Elapsd %:	76.01	% Non-Parse CPU:	80.56
OLTP应该关注一下部分内容，OLAP可以忽略。
Execute to Parse 表示执行次数与解析次数的比例。理想的情况是解析一次，执行多次。
对于 OLTP 数据库来说，如果 Soft Parse 低于 95%，应当引起注意，表示存在未使用绑定变量的情况。

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
CYDB_X	TS_CYDB	RCVREQ	TABLE	55,454	4.04
CYDB_X	TS_CYDB	REQRES_SVCSRLNO_INDEX	INDEX	37,184	2.71
CYDB_X	TS_CYDB	IDX_RCVREQ_4	INDEX	35,504	2.59
CYDB_X	TS_CYDB	SNDREQ	TABLE	34,862	2.54
CYDB_X	TS_CYDB	SNDREQ_REQSRLNO_INDEX	INDEX	28,527	2.08

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
EBCC_X	IDX_EBCC	ECC_SERVICE_LOG_1	INDEX	27,471	6.62
CYDB_X	TS_CYDB	REQRES_SVCSRLNO_INDEX	INDEX	22,658	5.46
CYDB_X	TS_CYDB	SNDREQ_REQSRLNO_INDEX	INDEX	20,004	4.82
CYDB_X	TS_CYDB	IDX_RCVREQ_4	INDEX	19,123	4.61
CYDB_X	TS_CYDB	IDX_RCVREQ_5	INDEX	16,971	4.09

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_4278731049_37985	TABLE PARTITION	157	16.25
EBCC_X	TS_EBCC	SYS_LOB0000108971C00030$$		LOB	89	9.21

Owner	Tablespace Name	Object Name	Obj. Type	GC Buffer Busy	% of Capture
CYDB_X	TS_CYDB	REQRES_RESTIME_INDEX	INDEX	411,550	14.29
CYDB_X	TS_CYDB	IDX_RCVREQ_5	INDEX	410,746	14.27
CYDB_X	TS_CYDB	SNDREQ_REQTIME_INDEX	INDEX	399,710	13.88
CYDB_X	TS_CYDB	INDEX1	INDEX	315,008	10.94
CYDB_X	TS_CYDB	IDX_RCVREQ_6	INDEX	215,902	7.50

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
CYDB_X	TS_CYDB	PRV_MONITOR_INFO	TABLE	181,447	16.20
CYDB_X	TS_CYDB	CSM_MONITOR_INFO	TABLE	55,067	4.92
CYDB_X	TS_CYDB	SNDREQ	TABLE	44,253	3.95
EBCC_X	IDX_EBCC	PK_ECC_SERVICE_LOG	INDEX	43,197	3.86
CYDB_X	TS_CYDB	RCVRES	TABLE	34,497	3.08

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	63	3.17	0	1
dc_files	4,272	0.00	0	48
dc_global_oids	85	25.88	0	9
dc_histogram_data	12,728,713	0.01	0	878
dc_histogram_defs	15,006,146	0.03	0	1,470
dc_objects	9,180,814	0.01	0	499
dc_profiles	7,366	0.00	0	1
dc_rollback_segments	4,558,065	0.00	0	2,051
dc_segments	5,042,509	0.02	7	454
dc_sequences	4,119	88.49	4,119	2
dc_tablespaces	293,627	0.00	0	14
dc_users	2,664,046	0.00	0	40
global database name	8,236	0.00	0	1
outstanding_alerts	68	97.06	0	11
sch_lj_oids	4	75.00	0	0

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	11,049	0.02	0		0	0
BODY	7,588	0.25	11,540	0.19	1	0
CLUSTER	120	2.50	120	2.50	0	0
DBLINK	11,393	0.00	0		0	0
EDITION	3,866	0.00	7,549	0.00	0	0
INDEX	23	100.00	23	100.00	0	0
QUEUE	1,689	0.00	1,749	0.00	0	0
SCHEMA	4,542	0.07	0		0	0
SQL AREA	1,802,212	27.22	9,672,833	22.39	50,732	4
SQL AREA BUILD	834,946	64.08	0		0	0
SQL AREA STATS	834,595	96.73	834,579	96.73	0	0
TABLE/PROCEDURE	860,633	0.06	6,875,872	0.01	752	0
TRANSFORMATION	361	0.00	361	0.00	0	0

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	46,848.00	46,848.00	46,848.00	47,104.00	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	25,856.00	25,856.00	25,856.00	25,856.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	77,568.00	77,568.00	77,568.00	77,568.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	1,792.00	1,792.00	1,792.00	1,792.00	STA/
large pool	1,536.00	1,536.00	1,536.00	1,536.00	STA/
shared pool	26,368.00	26,368.00	26,112.00	26,368.00	GRO/IMM
streams pool	512.00	512.00	512.00	512.00	STA/

	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	1,433.19		7.87	15.15	70	70	182	182
B	Freeable	225.69	0.00	1.57	5.20	46		144	144
B	SQL	1.72	0.35	0.01	0.02	0	6	137	101
B	PL/SQL	1.61	0.84	0.01	0.04	0	0	180	179
E	Other	1,397.52		7.43	14.80	70	70	188	188
E	Freeable	223.75	0.00	1.51	5.14	46		148	148
E	SQL	1.88	0.18	0.01	0.02	0	6	143	111
E	PL/SQL	1.63	0.79	0.01	0.04	0	0	186	185

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	49,123,688,448
Fixed Size	2,261,968
Redo Buffers	171,487,232
Variable Size	31,675,386,928

Pool	Name	Begin MB	End MB	% Diff
java	free memory	1,792.00	1,792.00	0.00
large	free memory	1,528.19	1,528.19	0.00
shared	KGLDA	268.18	267.41	-0.29
shared	KGLH0	5,047.50	5,047.60	0.00
shared	KGLHD	967.05	955.95	-1.15
shared	SQLA	11,454.73	11,412.48	-0.37
shared	db_block_hash_buckets	356.00	356.00	0.00
shared	free memory	4,466.35	4,521.67	1.24
shared	gcs resources	1,324.66	1,324.66	0.00
shared	gcs shadows	917.07	917.07	0.00
streams	free memory	511.99	511.99	0.00
	buffer_cache	46,848.00	46,848.00	0.00
	fixed_sga	2.16	2.16	0.00
	log_buffer	163.54	163.54	0.00

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	1026 04:19:06	0.26	0.00	0.00
QMON Slaves	1026 04:19:16	-0.32	-0.00	0.00

Name	Total Disp Time (s)	%Busy	%Idle
D000	3,610	0.00	100.00
D000	3,610	0.00	100.00
D000	3,610	0.00	100.00
D000	3,610	0.00	100.00
Sum
Avg		0.00	100.00
Std		0.00	0.00

Parameter Name	Begin value	End value (if different)
_gc_policy_time	0
_gc_undo_affinity	FALSE
_use_adaptive_log_file_sync	FALSE
audit_file_dest	/oracle/app/db/admin/cydb/adump
audit_trail	NONE
cluster_database	TRUE
compatible	11.2.0.4.0
control_file_record_keep_time	14
control_files	/oradata/cydb/control01.ctl, /oradata/cydb/control02.ctl
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_file_name_convert	/oradata/drebcc/, /oradata/cydb/
db_name	cydb
db_recovery_file_dest
db_recovery_file_dest_size	214748364800
diagnostic_dest	/oracle/app/db
dispatchers	(PROTOCOL=TCP) (SERVICE=cydbXDB)
enable_goldengate_replication	TRUE
event	28401 TRACE NAME CONTEXT FOREVER, LEVEL 1
fal_server	ebccdpc
instance_number	1
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.13.11.117)(PORT=1521))
log_archive_config	DG_CONFIG=(cydb, ebccdpc)
log_archive_dest_1	LOCATION=/oradata/arch VALID_FOR=(ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=cydb
log_archive_dest_3	SERVICE=ebccdpc LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=ebccdpc
log_archive_dest_state_2	enable
log_archive_dest_state_3	ENABLE
log_archive_format	%t_%s_%r.arc
log_archive_max_processes	8
log_file_name_convert	/oradata/drebcc/, /oradata/cydb/
max_dump_file_size	50M
open_cursors	1000
parallel_force_local	TRUE
parallel_max_servers	160
pga_aggregate_target	27081572352
plsql_warnings	DISABLE:ALL
processes	3000
recyclebin	OFF
remote_listener	cydb-scan.xuwang.online:1521
remote_login_passwordfile	EXCLUSIVE
service_names	SYS$SYS.SCHEDULER$_EVENT_QUEUE.CYDB
sessions	4560
sga_target	81335943168
spfile	/oradata/cydb/spfilecydb.ora
standby_file_management	AUTO
thread	1
undo_tablespace	UNDOTBS1

Parameter Name	Begin value	End value (if different)
control_files	/oradata/cydb/control01.ctl
control_files	/oradata/cydb/control02.ctl
db_file_name_convert	/oradata/drebcc/
db_file_name_convert	/oradata/cydb/
log_file_name_convert	/oradata/drebcc/
log_file_name_convert	/oradata/cydb/

	Per Second	Per Transaction
Global Cache blocks received:	2,058.43	1.51
Global Cache blocks served:	2,031.68	1.49
GCS/GES messages received:	4,059.86	2.98
GCS/GES messages sent:	4,165.79	3.05
DBWR Fusion writes:	67.08	0.05
Estd Interconnect traffic (KB)	34,327.39

Buffer access - local cache %:	98.52
Buffer access - remote cache %:	1.33
Buffer access - disk %:	0.14

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.3
Avg global cache current block receive time (ms):	0.8
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	4.0
Avg global cache cr block flush time (ms):	1.4
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	25.4
Avg global cache current block flush time (ms):	1.7

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	0.4
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	69.99
% of indirect sent messages:	28.93
% of flow controlled messages:	1.08

WORKLOAD REPOSITORY report for

Report Summary

Main Report

RAC Statistics

Wait Events Statistics

Time Model Statistics

Operating System Statistics

Operating System Statistics - Detail

Foreground Wait Class

Foreground Wait Events

Background Wait Events

Wait Event Histogram

Wait Event Histogram Detail (64 msec to 2 sec)

Wait Event Histogram Detail (4 sec to 2 min)

Wait Event Histogram Detail (4 min to 1 hr)

Service Statistics

Service Wait Class Stats

SQL Statistics

SQL ordered by Elapsed Time

SQL ordered by CPU Time

SQL ordered by User I/O Wait Time

SQL ordered by Gets

SQL ordered by Reads

SQL ordered by Physical Reads (UnOptimized)

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

Instance Activity Statistics

Key Instance Activity Stats

Other Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

Advisory Statistics

Instance Recovery Stats

MTTR Advisory

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

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Segment Statistics

Segments by Logical Reads

Segments by Physical Reads

Segments by Physical Read Requests

Segments by UnOptimized Reads

Segments by Optimized Reads

Segments by Direct Physical Reads

Segments by Physical Writes

Segments by Physical Write Requests

Segments by Direct Physical Writes

Segments by Table Scans

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	1,110,874	307.69	0.23
acks for commit broadcast(logical)	2,717,145	752.60	0.55
broadcast msgs on commit(actual)	2,818,921	780.79	0.57
broadcast msgs on commit(logical)	2,818,921	780.79	0.57
broadcast msgs on commit(wasted)	1,259,435	348.84	0.26
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	3,464,056	959.48	0.70
gcs ast xid	59,606	16.51	0.01
gcs blocked converts	6,818,965	1,888.73	1.38
gcs blocked cr converts	1,439,033	398.59	0.29
gcs compatible basts	1,128	0.31	0.00
gcs compatible cr basts (global)	22,301	6.18	0.00
gcs compatible cr basts (local)	441,950	122.41	0.09
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	235,199	65.15	0.05
gcs dbwr write request msgs	161,551	44.75	0.03
gcs delta msgs sent	0	0.00	0.00
gcs delta push aborted by cancel	0	0.00	0.00
gcs delta push aborted by remastering	0	0.00	0.00
gcs delta push cancelled	0	0.00	0.00
gcs delta push cancelled at master	0	0.00	0.00
gcs delta push cancelled by close	0	0.00	0.00
gcs delta push cancelled by consign	0	0.00	0.00
gcs delta push cancelled by cvt ping	0	0.00	0.00
gcs delta push cancelled by dwncvt	0	0.00	0.00
gcs delta push create pi	0	0.00	0.00
gcs delta update master msgs sent	0	0.00	0.00
gcs delta wait aborted by remastering	0	0.00	0.00
gcs delta wait cancelled	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs force cr block only	284	0.08	0.00
gcs force cr grant	53	0.01	0.00
gcs force cr no current	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	10,570	2.93	0.00
gcs immediate (null) converts	750,340	207.83	0.15
gcs immediate cr (compatible) converts	42	0.01	0.00
gcs immediate cr (null) converts	593,099	164.28	0.12
gcs indirect ast	617,424	171.02	0.13
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	617,424	171.02	0.13
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	58,110	16.10	0.01
gcs msgs process time(ms)	511,377	141.64	0.10
gcs msgs received	14,129,910	3,913.73	2.87
gcs new served by master	250,343	69.34	0.05
gcs out-of-order msgs	328	0.09	0.00
gcs pings refused	97,530	27.01	0.02
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	54,585	15.12	0.01
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	0	0.00	0.00
gcs reader bypass grant X on assume	0	0.00	0.00
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	0	0.00	0.00
gcs reader bypass grant immediate	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	55,318	15.32	0.01
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	55,721	15.43	0.01
gcs side channel msgs logical	8,188,743	2,268.13	1.66
gcs stale cr	920	0.25	0.00
gcs undo cr	0	0.00	0.00
gcs write notification msgs	50,456	13.98	0.01
gcs writes refused	34,096	9.44	0.01
ges msgs process time(ms)	12,974	3.59	0.00
ges msgs received	527,588	146.13	0.11
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	0	0.00	0.00
global posts requested	0	0.00	0.00
global posts sent	0	0.00	0.00
implicit batch messages received	329,041	91.14	0.07
implicit batch messages sent	402,198	111.40	0.08
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	144,816	40.11	0.03
messages queue sent actual	3,589,025	994.09	0.73
messages queue sent logical	1,076,035	298.04	0.22
messages received actual	13,808,019	3,824.57	2.80
messages received logical	14,657,498	4,059.86	2.98
messages sent directly	9,363,633	2,593.55	1.90
messages sent indirectly	3,870,856	1,072.16	0.79
messages sent not implicit batched	2,440	0.68	0.00
messages sent pbatched	1,926,549	533.62	0.39
msgs causing lmd to send msgs	144,147	39.93	0.03
msgs causing lms(s) to send msgs	237,060	65.66	0.05
msgs received queue time (ms)	173,115	47.95	0.04
msgs received queued	14,657,498	4,059.86	2.98
msgs sent queue time (ms)	429,275	118.90	0.09
msgs sent queue time on ksxp (ms)	5,414,015	1,499.58	1.10
msgs sent queued	4,252,289	1,177.81	0.86
msgs sent queued on ksxp	14,108,552	3,907.81	2.87
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	1,723,886	477.48	0.35
process batch messages sent	1,662,497	460.48	0.34

Statistic	Total
CR Block Requests	403,425
CURRENT Block Requests	612,683
Data Block Requests	403,425
Undo Block Requests	8,757
TX Block Requests	600,936
Current Results	1,010,973
Private results	218
Zero Results	4,457
Disk Read Results	460
Fail Results	13
Fairness Down Converts	43,144
Fairness Clears	15,455
Free GC Elements	0
Flushes	40,558
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	3,563
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	139,786	84.78	13.16	1.94	0.12	0.00
Flushes	1,607,554	39.24	60.40	0.36	0.00	0.00
Writes	242,108	6.07	72.22	21.55	0.01	0.15

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	486,498	96.27	2.39	1.34	6,273,100	71.94	27.02	1.04
2	undo header	618,219	93.32	5.40	1.28	31,508	92.36	6.29	1.35
2	undo block	13,228	98.37	0.38	1.25	0
2	Others	1,976	98.58	0.30	1.11	5,927	97.96	0.67	1.37

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	0.33	0.29	2.03	0.33	0.76	0.26	2.10	0.31
2	undo header	0.34	0.27	1.67	0.31	0.33	0.25	1.62	0.29
2	undo block	0.30	0.29	2.38	0.37
2	others	0.27	0.26	3.52	0.26	0.24	0.23	1.72	0.30

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	468,347	100.00	0.00	4,512,648	100.00	0.00
2	undo header	0	576,945	100.00	0.00	29,102	100.00	0.00
2	undo block	0	13,013	100.00	0.00	0
2	others	0	1,948	100.00	0.00	5,806	100.00	0.00

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	13.24	13.41
Parallel Query	0.00	0.00
DB Locks	1.09	1.06
DB Streams	0.00	0.00
Other	0.00	0.01