WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

YXDB 3349992778 yxdb1 1 31-Jan-15 09:01 11.2.0.4.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
YXDB	3349992778	yxdb1	1	31-Jan-15 09:01	11.2.0.4.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

nari62 Linux x86 64-bit 24 12 2 62.89

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
nari62	Linux x86 64-bit	24	12	2	62.89

Snap Id Snap Time Sessions Cursors/Session Instances

Begin Snap: 24 31-Jan-15 12:51:41 122 4.2 2

End Snap: 25 31-Jan-15 13:38:37 174 6.9 2

Elapsed: 46.92 (mins)

DB Time: 1,291.94 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	24	31-Jan-15 12:51:41	122	4.2	2
End Snap:	25	31-Jan-15 13:38:37	174	6.9	2
Elapsed:		46.92 (mins)
DB Time:		1,291.94 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 27.5 2.3 0.00 0.00

DB CPU(s): 9.9 0.8 0.00 0.00

Redo size (bytes): 169,011.2 14,065.9

Logical read (blocks): 1,533,386.3 127,615.1

Block changes: 1,035.6 86.2

Physical read (blocks): 1,326.3 110.4

Physical write (blocks): 71.5 6.0

Read IO requests: 1,326.0 110.4

Write IO requests: 49.0 4.1

Read IO (MB): 10.4 0.9

Write IO (MB): 0.6 0.1

Global Cache blocks received: 122.0 10.2

Global Cache blocks served: 114.3 9.5

User calls: 15,987.0 1,330.5

Parses (SQL): 984.4 81.9

Hard parses (SQL): 0.1 0.0

SQL Work Area (MB): -0.4 -0.0

Logons: 0.2 0.0

Executes (SQL): 8,018.0 667.3

Rollbacks: 0.4 0.0

Transactions: 12.0

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	27.5	2.3	0.00	0.00
DB CPU(s):	9.9	0.8	0.00	0.00
Redo size (bytes):	169,011.2	14,065.9
Logical read (blocks):	1,533,386.3	127,615.1
Block changes:	1,035.6	86.2
Physical read (blocks):	1,326.3	110.4
Physical write (blocks):	71.5	6.0
Read IO requests:	1,326.0	110.4
Write IO requests:	49.0	4.1
Read IO (MB):	10.4	0.9
Write IO (MB):	0.6	0.1
Global Cache blocks received:	122.0	10.2
Global Cache blocks served:	114.3	9.5
User calls:	15,987.0	1,330.5
Parses (SQL):	984.4	81.9
Hard parses (SQL):	0.1	0.0
SQL Work Area (MB):	-0.4	-0.0
Logons:	0.2	0.0
Executes (SQL):	8,018.0	667.3
Rollbacks:	0.4	0.0
Transactions:	12.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 100.02 Soft Parse %: 99.99

Execute to Parse %: 87.72 Latch Hit %: 99.78

Parse CPU to Parse Elapsd %: 61.92 % Non-Parse CPU: 99.85

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
db file sequential read	3,732,212	43.4K	12	56.0	User I/O
DB CPU		27.8K		35.8
log file sync	32,562	3844	118	5.0	Commit
gc current block busy	6,671	961.7	144	1.2	Cluster
gc buffer busy acquire	9,011	488.2	54	.6	Cluster
gc buffer busy release	2,445	486.9	199	.6	Cluster
gc cr block busy	3,580	335.7	94	.4	Cluster
gc current block 2-way	264,055	69.4	0	.1	Cluster
SQL*Net message to client	43,244,308	37.3	0	.0	Network
enq: TX - index contention	1,188	17.5	15	.0	Concurrency

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
User I/O	3,735,751	43,400	12	56.0	15.4
DB CPU		27,787		35.8	9.9
Commit	32,564	3,844	118	5.0	1.4
Cluster	437,022	2,404	6	3.1	0.9
System I/O	272,712	1,198	4	1.5	0.4
Other	178,238	798	4	1.0	0.3
Concurrency	28,409	44	2	.1	0.0
Network	43,258,571	38	0	.0	0.0
Application	239	3	11	.0	0.0
Configuration	216	0	0	.0	0.0

Host CPU

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

24 12 2 2.60 8.57 39.4 6.8 0.0 53.1

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
24	12	2	2.60	8.57	39.4	6.8	0.0	53.1

Instance CPU

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

41.7 88.8 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 1,404.4 1,329.1 75.3

Database Requests: 1,375.0 1,326.0 49.0

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 25.3 0.0 25.3

Total (MB): 11.3 10.4 0.9

Database (MB): 10.9 10.4 0.6

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 0.3 0.0 0.3

Database (blocks): 1,397.9 1,326.3 71.5

Via Buffer Cache (blocks): 1,397.8 1,326.3 71.4

Direct (blocks): 0.1 0.0 0.1

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	1,404.4	1,329.1	75.3
Database Requests:	1,375.0	1,326.0	49.0
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	25.3	0.0	25.3
Total (MB):	11.3	10.4	0.9
Database (MB):	10.9	10.4	0.6
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	0.3	0.0	0.3
Database (blocks):	1,397.9	1,326.3	71.5
Via Buffer Cache (blocks):	1,397.8	1,326.3	71.4
Direct (blocks):	0.1	0.0	0.1

Memory Statistics

Begin End

Host Mem (MB): 64,402.8 64,402.8

SGA use (MB): 23,552.0 23,808.0

PGA use (MB): 489.9 822.7

% Host Mem used for SGA+PGA: 37.33 38.24

	Begin	End
Host Mem (MB):	64,402.8	64,402.8
SGA use (MB):	23,552.0	23,808.0
PGA use (MB):	489.9	822.7
% Host Mem used for SGA+PGA:	37.33	38.24

Cache Sizes

Begin End

Buffer Cache: 17,664M 17,920M Std Block Size: 8K

Shared Pool Size: 3,976M 3,966M Log Buffer: 20,596K

	Begin	End
Buffer Cache:	17,664M	17,920M	Std Block Size:	8K
Shared Pool Size:	3,976M	3,966M	Log Buffer:	20,596K

Shared Pool Statistics

Begin End

Memory Usage %: 42.10 42.22

% SQL with executions>1: 84.99 93.31

% Memory for SQL w/exec>1: 76.69 87.61

	Begin	End
Memory Usage %:	42.10	42.22
% SQL with executions>1:	84.99	93.31
% Memory for SQL w/exec>1:	76.69	87.61

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): 77516.1s
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	71,959.90	92.83
DB CPU	27,786.84	35.85
PL/SQL execution elapsed time	401.14	0.52
parse time elapsed	82.75	0.11
repeated bind elapsed time	35.54	0.05
connection management call elapsed time	1.37	0.00
hard parse elapsed time	0.42	0.00
hard parse (sharing criteria) elapsed time	0.29	0.00
sequence load elapsed time	0.26	0.00
PL/SQL compilation elapsed time	0.18	0.00
failed parse elapsed time	0.06	0.00
DB time	77,516.14
background elapsed time	2,153.67
background cpu time	218.63

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	3,153,231
IDLE_TIME	3,568,568
IOWAIT_TIME	851
NICE_TIME	0
SYS_TIME	454,806
USER_TIME	2,650,180
LOAD	3	9
PHYSICAL_MEMORY_BYTES	67,531,182,080
NUM_CPUS	24
NUM_CPU_CORES	12
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,586
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
31-Jan 12:51:41	2.60
31-Jan 13:38:37	8.57	46.91	39.43	6.77	53.09	0.01

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 100.0% of Total DB time 77,516.14 (s)
Total FG Wait Time: 49,734.15 (s) DB CPU time: 27,786.84 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	3,735,000	0	43,399	12	55.99
DB CPU			27,787		35.85
Commit	32,562	0	3,844	118	4.96
Cluster	434,824	0	2,401	6	3.10
Concurrency	18,710	0	43	2	0.06
Network	43,257,398	0	38	0	0.05
Other	18,224	50	6	0	0.01
Application	238	69	3	11	0.00
System I/O	905	0	1	1	0.00
Configuration	211	59	0	0	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
db file sequential read	3,732,212	0	43,386	12	110.34	55.97
log file sync	32,562	0	3,844	118	0.96	4.96
gc current block busy	6,671	0	962	144	0.20	1.24
gc buffer busy acquire	9,011	0	488	54	0.27	0.63
gc buffer busy release	2,445	0	487	199	0.07	0.63
gc cr block busy	3,580	0	336	94	0.11	0.43
gc current block 2-way	264,055	0	69	0	7.81	0.09
SQL*Net message to client	43,244,308	0	37	0	1,278.47	0.05
enq: TX - index contention	1,188	0	18	15	0.04	0.02
gc cr block 2-way	55,945	0	16	0	1.65	0.02
cursor: pin S	2,402	0	14	6	0.07	0.02
gc current grant busy	14,978	0	14	1	0.44	0.02
gc cr multi block request	1,809	0	12	7	0.05	0.02
read by other session	627	0	11	18	0.02	0.01
gc current grant 2-way	37,277	0	8	0	1.10	0.01
buffer busy waits	1,599	0	8	5	0.05	0.01
gc cr grant 2-way	31,674	0	6	0	0.94	0.01
enq: PS - contention	333	0	3	10	0.01	0.00
library cache: mutex X	6,066	0	3	0	0.18	0.00
enq: TX - row lock contention	201	82	3	13	0.01	0.00
db file scattered read	44	0	2	56	0.00	0.00
gc current block congested	4,274	0	1	0	0.13	0.00
latch: row cache objects	4,396	0	1	0	0.13	0.00
control file sequential read	905	0	1	1	0.03	0.00
latch free	2,512	0	1	0	0.07	0.00
enq: SV - contention	1,736	0	1	0	0.05	0.00
gc current split	62	0	0	5	0.00	0.00
gc cr block congested	977	0	0	0	0.03	0.00
latch: cache buffers chains	2,789	0	0	0	0.08	0.00
gc current multi block request	533	0	0	0	0.02	0.00
reliable message	632	0	0	0	0.02	0.00
gc current grant congested	796	0	0	0	0.02	0.00
enq: FB - contention	536	0	0	0	0.02	0.00
gc cr grant congested	727	0	0	0	0.02	0.00
PX Deq: Slave Session Stats	987	0	0	0	0.03	0.00
SQL*Net more data to client	12,924	0	0	0	0.38	0.00
row cache lock	251	0	0	0	0.01	0.00
enq: HW - contention	186	64	0	0	0.01	0.00
PX Deq: reap credit	8,260	100	0	0	0.24	0.00
PX Deq: Signal ACK RSG	650	0	0	0	0.02	0.00
IPC send completion sync	357	0	0	0	0.01	0.00
buffer deadlock	764	99	0	0	0.02	0.00
latch: ges resource hash list	166	0	0	0	0.00	0.00
undo segment extension	5	100	0	5	0.00	0.00
PX Deq: Signal ACK EXT	650	0	0	0	0.02	0.00
cursor: pin S wait on X	1	0	0	20	0.00	0.00
Disk file operations I/O	2,115	0	0	0	0.06	0.00
ADR block file read	18	0	0	1	0.00	0.00
latch: gc element	187	0	0	0	0.01	0.00
latch: session allocation	42	0	0	0	0.00	0.00
latch: cache buffers lru chain	71	0	0	0	0.00	0.00
enq: TX - allocate ITL entry	20	0	0	0	0.00	0.00
KJC: Wait for msg sends to complete	196	0	0	0	0.01	0.00
db file parallel read	1	0	0	3	0.00	0.00
latch: shared pool	14	0	0	0	0.00	0.00
latch: object queue header operation	25	0	0	0	0.00	0.00
SQL*Net break/reset to client	36	0	0	0	0.00	0.00
gc current retry	10	0	0	0	0.00	0.00
latch: redo allocation	11	0	0	0	0.00	0.00
enq: CF - contention	4	0	0	0	0.00	0.00
latch: gcs resource hash	15	0	0	0	0.00	0.00
global enqueue expand wait	39	0	0	0	0.00	0.00
wait list latch free	1	0	0	1	0.00	0.00
SQL*Net message from client	43,244,261	0	383,703	9	1,278.47
Streams AQ: waiting for messages in the queue	567	98	2,806	4950	0.02
PX Deq: Execute Reply	650	0	1	1	0.02
PX Deq: Execution Msg	1,348	0	1	1	0.04
PX Deq: Join ACK	650	0	0	1	0.02
PX Deq: Parse Reply	650	0	0	0	0.02
PX Deq Credit: send blkd	40	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
log file parallel write	28,948	0	997	34	0.86	46.30
gcs log flush sync	101,830	9	774	8	3.01	35.93
db file parallel write	130,761	0	184	1	3.87	8.55
Streams AQ: qmn coordinator waiting for slave to start	3	100	17	5714	0.00	0.80
db file async I/O submit	102,973	0	11	0	3.04	0.50
control file parallel write	1,368	0	3	2	0.04	0.14
gc cr block busy	32	0	2	73	0.00	0.11
control file sequential read	7,758	0	2	0	0.23	0.11
db file sequential read	508	0	1	2	0.02	0.04
os thread startup	27	0	1	29	0.00	0.04
SGA: allocation forcing component growth	4	50	0	96	0.00	0.02
DFS lock handle	1,328	100	0	0	0.04	0.01
gc cr block 2-way	1,385	0	0	0	0.04	0.01
reliable message	566	0	0	0	0.02	0.01
CGS wait for IPC msg	24,953	100	0	0	0.74	0.01
enq: TM - contention	1	0	0	188	0.00	0.01
gc current block busy	19	0	0	6	0.00	0.01
Parameter File I/O	48	0	0	2	0.00	0.01
row cache lock	201	0	0	0	0.01	0.00
gc current block 2-way	324	0	0	0	0.01	0.00
ksxr poll remote instances	6,505	100	0	0	0.19	0.00
ADR block file read	15	0	0	3	0.00	0.00
gc buffer busy acquire	1	0	0	46	0.00	0.00
gc cr multi block request	52	0	0	1	0.00	0.00
row cache process	11,828	0	0	0	0.35	0.00
enq: CF - contention	88	83	0	0	0.00	0.00
gc current grant busy	144	0	0	0	0.00	0.00
enq: WF - contention	17	0	0	2	0.00	0.00
row cache cleanup	10,221	0	0	0	0.30	0.00
log file sync	2	0	0	12	0.00	0.00
gc buffer busy release	3	0	0	6	0.00	0.00
latch free	31	0	0	1	0.00	0.00
gc current grant 2-way	114	0	0	0	0.00	0.00
ADR block file write	5	0	0	3	0.00	0.00
PX Deq: reap credit	1,890	100	0	0	0.06	0.00
gc cr grant 2-way	100	0	0	0	0.00	0.00
direct path write	4	0	0	3	0.00	0.00
LGWR wait for redo copy	170	0	0	0	0.01	0.00
enq: US - contention	20	0	0	0	0.00	0.00
enq: PS - contention	16	50	0	0	0.00	0.00
libcache interrupt action by LCK	9,358	0	0	0	0.28	0.00
latch: gc element	72	0	0	0	0.00	0.00
CSS initialization	1	0	0	4	0.00	0.00
Disk file operations I/O	191	0	0	0	0.01	0.00
asynch descriptor resize	346	100	0	0	0.01	0.00
latch: cache buffers lru chain	42	0	0	0	0.00	0.00
enq: TA - contention	13	0	0	0	0.00	0.00
gc cr block congested	15	0	0	0	0.00	0.00
latch: object queue header operation	43	0	0	0	0.00	0.00
CSS operation: action	3	0	0	1	0.00	0.00
gc current multi block request	7	0	0	0	0.00	0.00
latch: cache buffers chains	88	0	0	0	0.00	0.00
enq: TD - KTF dump entries	7	0	0	0	0.00	0.00
SQL*Net message to client	1,173	0	0	0	0.03	0.00
latch: redo allocation	8	0	0	0	0.00	0.00
gc current block congested	6	0	0	0	0.00	0.00
buffer busy waits	29	0	0	0	0.00	0.00
enq: FB - contention	3	0	0	0	0.00	0.00
enq: TK - Auto Task Serialization	4	100	0	0	0.00	0.00
rdbms ipc message	147,742	32	51,213	347	4.37
Space Manager: slave idle wait	3,546	86	16,373	4617	0.10
DIAG idle wait	43,445	71	5,604	129	1.28
gcs remote message	799,432	7	4,790	6	23.63
Streams AQ: waiting for time management or cleanup tasks	206	66	4,229	20530	0.01
Streams AQ: qmn slave idle wait	110	3	2,996	27238	0.00
dispatcher timer	47	100	2,820	60010	0.00
pmon timer	938	100	2,816	3003	0.03
GCR sleep	563	100	2,815	5001	0.02
smon timer	110	0	2,815	25587	0.00
wait for unread message on broadcast channel	2,860	79	2,814	984	0.08
ges remote message	37,625	64	2,813	75	1.11
PX Idle Wait	337	0	2,813	8348	0.01
PING	1,068	21	2,809	2630	0.03
Streams AQ: qmn coordinator idle wait	199	49	2,798	14062	0.01
shared server idle wait	93	100	2,791	30008	0.00
class slave wait	30	0	899	29958	0.00
SQL*Net message from client	1,492	0	1	1	0.04
PX Deq: Join ACK	12	0	0	1	0.00
KSV master wait	1,712	100	0	0	0.05
PX Deq: Parse Reply	12	0	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	201	100	0	0	0.01

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	33	75.8		6.1	6.1	12.1
ADR block file write	5	20.0		40.0	40.0
ADR file lock	6	100.0
CGS wait for IPC msg	25K	100.0
CSS initialization	1			100.0
CSS operation: action	3	66.7	33.3
DFS lock handle	1328	99.3	.6	.1
Disk file operations I/O	2306	100.0
IPC send completion sync	365	97.8	1.9	.3
KJC: Wait for msg sends to complete	199	99.5	.5
LGWR wait for redo copy	170	100.0
PX Deq: Signal ACK EXT	662	100.0
PX Deq: Signal ACK RSG	662	98.9	.9	.2
PX Deq: Slave Session Stats	999	98.4	1.5	.1
PX Deq: reap credit	10.1K	100.0	.0
Parameter File I/O	48	64.6	10.4	4.2	12.5	6.3	2.1
SGA: allocation forcing component growth	4							100.0
SQL*Net break/reset to client	36	100.0
SQL*Net message to client	43.2M	100.0	.0	.0	.0
SQL*Net more data from client	166	100.0
SQL*Net more data to client	12.9K	100.0	.0	.0
Streams AQ: qmn coordinator waiting for slave to start	3								100.0
asynch descriptor resize	346	100.0
buffer busy waits	1628	94.1	1.7	.4	.7	.4	.7	2.0
buffer deadlock	763	99.0	.9	.1
control file parallel write	1368	51.4	16.2	16.2	11.3	4.8	.3
control file sequential read	8664	97.7	.9	.4	.5	.2	.2	.2
cursor: pin S	2401	45.9	1.0	.3	.0	52.7	.0
cursor: pin S wait on X	1						100.0
db file async I/O submit	103K	99.9	.1	.0	.0	.0	.0	.0
db file parallel read	1			100.0
db file parallel write	130.8K	74.6	12.2	6.7	4.8	1.3	.3	.2	.0
db file scattered read	44	18.2		9.1	20.5	13.6	31.8	4.5	2.3
db file sequential read	3732.6K	16.0	3.0	7.2	22.7	29.8	15.8	5.5	.0
direct path write	4	25.0	25.0	25.0	25.0
direct path write temp	1	100.0
enq: CF - contention	92	100.0
enq: DR - contention	1	100.0
enq: FB - contention	540	98.3	1.7
enq: HW - contention	190	96.8	2.6	.5
enq: MW - contention	1	100.0
enq: PE - contention	1	100.0
enq: PG - contention	1	100.0
enq: PS - contention	349	88.3	.9	.3		.3	.3	10.0
enq: SV - contention	1736	98.3	1.5	.2
enq: TA - contention	13	100.0
enq: TD - KTF dump entries	7	100.0
enq: TK - Auto Task Serialization	4	100.0
enq: TM - contention	2	50.0						50.0
enq: TX - allocate ITL entry	20	100.0
enq: TX - index contention	1192	61.1	4.3	4.2	5.9	9.5	6.8	8.1	.2
enq: TX - row lock contention	201	78.6	4.5	.5		.5	.5	15.4
enq: US - contention	20	100.0
enq: WF - contention	17	94.1					5.9
gc buffer busy acquire	9012	50.1	3.8	2.9	6.8	8.2	6.0	22.1	.1
gc buffer busy release	2449	5.9	1.9	2.4	3.1	4.6	6.6	75.2	.3
gc cr block 2-way	57.3K	99.4	.5	.1	.0
gc cr block busy	3616	4.2	20.0	14.0	12.1	7.5	5.5	36.1	.6
gc cr block congested	992	99.5	.5
gc cr grant 2-way	31.8K	99.7	.3	.0	.0
gc cr grant congested	728	99.3	.7
gc cr multi block request	1861	85.6	4.5	2.3	2.2	2.0	.6	2.8
gc current block 2-way	264.4K	99.1	.9	.1	.0
gc current block busy	6694	3.6	9.7	9.9	10.4	8.5	6.4	50.6	.9
gc current block congested	4278	99.1	.9	.0
gc current grant 2-way	37.4K	99.4	.5	.0		.0
gc current grant busy	15.1K	99.1	.5	.1	.1	.0	.0	.2	.0
gc current grant congested	798	99.2	.8
gc current multi block request	542	98.7	1.1	.2
gc current retry	10	100.0
gc current split	64	79.7	7.8	3.1	1.6		1.6	6.3
gcs log flush sync	101.8K	36.9	9.4	10.8	11.6	13.0	18.3	.0
global enqueue expand wait	39	100.0
ksxr poll remote instances	6510	100.0
latch free	2543	93.8	4.2	1.7	.3	.0
latch: cache buffers chains	2878	99.3	.2	.1	.4
latch: cache buffers lru chain	113	100.0
latch: call allocation	1	100.0
latch: checkpoint queue latch	4	100.0
latch: enqueue hash chains	12	100.0
latch: gc element	260	99.2	.8
latch: gcs resource hash	33	100.0
latch: ges resource hash list	170	98.2	1.8
latch: messages	1	100.0
latch: object queue header operation	68	100.0
latch: redo allocation	19	100.0
latch: redo writing	3	100.0
latch: row cache objects	4396	96.4	2.7	.8	.1	.0
latch: session allocation	42	97.6	2.4
latch: shared pool	14	100.0
latch: undo global data	1	100.0
libcache interrupt action by LCK	9364	100.0
library cache lock	2	100.0
library cache pin	2	100.0
library cache: mutex X	6059	96.1	.3	.1		3.4	.1
lock deadlock retry	17	100.0
lock escalate retry	1	100.0
log file parallel write	29K	22.3	16.5	17.7	16.4	10.0	3.7	13.2	.2
log file sync	32.5K	13.8	10.3	11.7	11.3	8.1	4.8	39.1	.9
os thread startup	27						77.8	22.2
read by other session	627	30.6	4.8	12.9	16.1	20.3	10.8	4.3	.2
reliable message	1199	96.9	2.8	.3
row cache cleanup	10.2K	100.0
row cache lock	453	97.4	2.4	.2
row cache process	11.8K	100.0
undo segment extension	7	57.1				42.9
wait list latch free	1		100.0
DIAG idle wait	43.4K	27.7	.1	.0	.1	3.1	6.8	62.1
GCR sleep	563								100.0
KSV master wait	1714	100.0
PING	1068	79.5							20.5
PX Deq Credit: send blkd	40	97.5		2.5
PX Deq: Execute Reply	662	89.6	1.8	5.7	.8	.5	.3	1.4
PX Deq: Execution Msg	1348	84.1	13.6	2.0	.1	.1	.1
PX Deq: Join ACK	662	85.5	13.3	1.2
PX Deq: Msg Fragment	40	100.0
PX Deq: Parse Reply	662	98.5	1.4	.2
PX Idle Wait	337	31.2	17.8	12.8	8.0	1.8	1.2	16.3	11.0
SQL*Net message from client	43.2M	84.6	11.0	1.3	.6	.8	.6	1.1	.0
Space Manager: slave idle wait	3547	.3		.1	.1	.2	.3	3.8	95.2
Streams AQ: RAC qmn coordinator idle wait	201	100.0
Streams AQ: qmn coordinator idle wait	199	49.2							50.8
Streams AQ: qmn slave idle wait	110								100.0
Streams AQ: waiting for messages in the queue	568			.2			.2	.5	99.1
Streams AQ: waiting for time management or cleanup tasks	206	33.0						33.0	34.0
class slave wait	30	90.0							10.0
dispatcher timer	47								100.0
gcs remote message	799.5K	42.9	11.5	11.0	10.8	10.5	13.3	.0
ges remote message	37.6K	14.4	1.5	1.7	1.4	1.8	3.3	75.8
pmon timer	937								100.0
rdbms ipc message	147.8K	37.2	2.7	2.6	3.1	3.8	4.1	36.9	9.6
shared server idle wait	93								100.0
smon timer	112					.9		8.0	91.1
wait for unread message on broadcast channel	2862				.0	1.6		98.4

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
SGA: allocation forcing component growth	4			100.0
buffer busy waits	33	98.0	.3	.7	.7	.2	.2
control file sequential read	16	99.8	.1	.1	.0
db file async I/O submit	1	100.0					.0
db file parallel write	221	99.8	.1	.0	.0	.0	.0	.0
db file scattered read	3	93.2	2.3				2.3	2.3
db file sequential read	204.4K	94.5	4.6	.8	.1	.0	.0	.0	.0
enq: PS - contention	35	90.0	2.0	8.0
enq: TM - contention	1	50.0			50.0
enq: TX - index contention	99	91.7	3.6	2.9	1.2	.2	.3	.2
enq: TX - row lock contention	31	84.6	4.0	10.4	1.0
gc buffer busy acquire	2009	77.7	4.5	5.4	5.5	4.7	2.0	.1
gc buffer busy release	1850	24.5	10.2	15.3	22.3	19.1	8.3	.3
gc cr block busy	1326	63.3	6.2	9.0	9.6	7.7	3.6	.6
gc cr multi block request	53	97.2	.9	.3	.8	.8	.1
gc current block busy	3443	48.5	7.5	11.3	13.7	11.7	6.3	.9	.0
gc current grant busy	34	99.8	.0	.0	.1	.1	.0	.0
gc current split	4	93.8	3.1	3.1
gcs log flush sync	16	100.0	.0
log file parallel write	3882	86.6	2.8	3.7	3.4	2.1	1.2	.2	.0
log file sync	13K	60.0	5.6	8.4	10.4	9.3	5.4	.9	.0
os thread startup	6	77.8	22.2
read by other session	28	95.5	2.7		.5	.2	1.0	.2

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
		% of Total Waits
Streams AQ: qmn coordinator waiting for slave to start	3			100.0
db file sequential read	24	100.0	.0
gc current block busy	2	100.0	.0
log file parallel write	2	100.0	.0
log file sync	4	100.0	.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)
yxdb	77,495	27,779	3,733	4,316,451
SYS$USERS	22	8	0	18
SYS$BACKGROUND	0	0	1	111
yxdbXDB	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	Network Total Wts	Network Wt Time
yxdb	3734726	43397	18708	43	43254957	38
SYS$USERS	274	3	2	0	2443	0
SYS$BACKGROUND	750	1	9699	1	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by 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 90.5% of Total DB Time (s): 77,516
Captured PL/SQL account for 60.1% of Total DB Time (s): 77,516

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Text
40,379.52	177,486	0.23	52.09	2.87	97.65	9t6habqtx6vzg	begin pkg_ca_counter.p_ca_coun...
21,876.12	1,774,976	0.01	28.22	1.78	99.12	86g6708pvuqtu	SELECT PL_AMT_ID FROM P_E_PL_A...
20,560.42	3,887,786	0.01	26.52	87.99	0.00	83p6uchsnm6n2	SELECT a.sys_user_name, a.org_...
17,943.59	1,775,010	0.01	23.15	2.41	98.94	c98tw7kbymbru	SELECT PL_AMT_ID FROM P_E_PL_A...
3,057.19	25,381	0.12	3.94	8.24	37.56	07ttw6rma134k	begin pkg_ca_counter.p_ca_arra...
2,460.39	29,254	0.08	3.17	98.08	0.00	ctpdw3pywk3k9	begin pkg_ca_lookup.p_get_owec...
1,260.15	24,982	0.05	1.63	2.52	0.76	fb7paxp4m9wcg	INSERT INTO A_PREPAY_FLOW (PRE...
1,158.76	107,861	0.01	1.49	98.46	0.00	3d3k6bzs4nk3f	SELECT RCVBL_YM, ORG_NO, SUM(R...
1,115.56	107,865	0.01	1.44	98.73	0.00	42pxs62tawj10	SELECT RCVBL_YM, ORG_NO, SUM(R...
856.33	25,279	0.03	1.10	3.24	96.67	4bf7r12w7dg25	SELECT pkg_sp_seq.f_a_defid se...
839.79	50,660	0.02	1.08	1.98	99.12	7q8fzfa8p6gk8	SELECT PL_AMT_ID FROM P_E_PL_A...
837.03	50,659	0.02	1.08	2.89	99.13	bxctd2r3kgjyb	SELECT PL_AMT_ID FROM P_E_PL_A...

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 79.9% of Total CPU Time (s): 27,787
Captured PL/SQL account for 14.4% of Total CPU Time (s): 27,787

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
18,091.62	3,887,786	0.00	65.11	20,560.42	87.99	0.00	83p6uchsnm6n2	SELECT a.sys_user_name, a.org_...
2,413.11	29,254	0.08	8.68	2,460.39	98.08	0.00	ctpdw3pywk3k9	begin pkg_ca_lookup.p_get_owec...
1,158.47	177,486	0.01	4.17	40,379.52	2.87	97.65	9t6habqtx6vzg	begin pkg_ca_counter.p_ca_coun...
1,140.85	107,861	0.01	4.11	1,158.76	98.46	0.00	3d3k6bzs4nk3f	SELECT RCVBL_YM, ORG_NO, SUM(R...
1,101.39	107,865	0.01	3.96	1,115.56	98.73	0.00	42pxs62tawj10	SELECT RCVBL_YM, ORG_NO, SUM(R...
433.33	1,775,010	0.00	1.56	17,943.59	2.41	98.94	c98tw7kbymbru	SELECT PL_AMT_ID FROM P_E_PL_A...
390.27	1,774,976	0.00	1.40	21,876.12	1.78	99.12	86g6708pvuqtu	SELECT PL_AMT_ID FROM P_E_PL_A...
251.95	25,381	0.01	0.91	3,057.19	8.24	37.56	07ttw6rma134k	begin pkg_ca_counter.p_ca_arra...
99.54	622,279	0.00	0.36	266.95	37.29	0.00	f3pwz8c7b36m5	select * from indy_user_profil...
93.90	87,969	0.00	0.34	135.76	69.17	0.00	0zy85nnkqxrx6	select dept_no deptno from v_m...

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 99.8% of Total User I/O Wait Time (s): 43,400
Captured PL/SQL account for 94.0% of Total User I/O Wait Time (s): 43,400

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
39,430.22	177,486	0.22	90.85	40,379.52	2.87	97.65	9t6habqtx6vzg	begin pkg_ca_counter.p_ca_coun...
21,684.55	1,774,976	0.01	49.96	21,876.12	1.78	99.12	86g6708pvuqtu	SELECT PL_AMT_ID FROM P_E_PL_A...
17,753.17	1,775,010	0.01	40.91	17,943.59	2.41	98.94	c98tw7kbymbru	SELECT PL_AMT_ID FROM P_E_PL_A...
1,148.20	25,381	0.05	2.65	3,057.19	8.24	37.56	07ttw6rma134k	begin pkg_ca_counter.p_ca_arra...
832.39	50,660	0.02	1.92	839.79	1.98	99.12	7q8fzfa8p6gk8	SELECT PL_AMT_ID FROM P_E_PL_A...
829.73	50,659	0.02	1.91	837.03	2.89	99.13	bxctd2r3kgjyb	SELECT PL_AMT_ID FROM P_E_PL_A...
827.77	25,279	0.03	1.91	856.33	3.24	96.67	4bf7r12w7dg25	SELECT pkg_sp_seq.f_a_defid se...
301.99	24,985	0.01	0.70	521.65	5.08	57.89	33j84p5q021j3	INSERT INTO A_PAY_FLOW (CHARGE...
294.49	3,586	0.08	0.68	304.95	2.04	96.57	g4ncbpmxhsh2b	SELECT a.org_no, a.cons_id, a....
275.56	10,796	0.03	0.63	282.94	1.86	97.39	b76zzq2h9gm66	SELECT count(*) record_num FRO...

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: 4,316,580,454
Captured SQL account for 5.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
100,504,153	29,254	3,435.57	2.33	2,460.39	98.1	0	ctpdw3pywk3k9	begin pkg_ca_lookup.p_get_owec...
59,634,702	107,861	552.88	1.38	1,158.76	98.5	0	3d3k6bzs4nk3f	SELECT RCVBL_YM, ORG_NO, SUM(R...
40,314,350	107,865	373.75	0.93	1,115.56	98.7	0	42pxs62tawj10	SELECT RCVBL_YM, ORG_NO, SUM(R...
39,822,736	622,279	63.99	0.92	266.95	37.3	0	f3pwz8c7b36m5	select * from indy_user_profil...
25,547,140	177,486	143.94	0.59	40,379.52	2.9	97.6	9t6habqtx6vzg	begin pkg_ca_counter.p_ca_coun...
14,341,899	3,641	3,939.00	0.33	73.42	90.9	0	4nxjprfhqt4jr	select DISTINCT a.sys_user_nam...
12,761,842	101,503	125.73	0.30	170.13	51.5	0	cr61tqvuq0fzd	select pkg_ca_counter.f_getnew...
12,076,716	101,329	119.18	0.28	115.69	52.9	0	942n22j17wfux	SELECT CUR_NOTE_NO, INV_OPER_I...
11,697,753	3,899,753	3.00	0.27	175.56	14.9	0	4fuvxgt352tdg	SELECT role_id FROM p_role WHE...
9,335,300	3,340	2,795.00	0.22	67.10	94.9	0	71c03qpak3wm6	SELECT time_limit_id, bgn_act,...

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: 3,733,672
Captured SQL account for 100.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
3,477,338	177,486	19.59	93.13	40,379.52	2.87	97.65	9t6habqtx6vzg	begin pkg_ca_counter.p_ca_coun...
1,740,727	1,774,976	0.98	46.62	21,876.12	1.78	99.12	86g6708pvuqtu	SELECT PL_AMT_ID FROM P_E_PL_A...
1,740,724	1,775,010	0.98	46.62	17,943.59	2.41	98.94	c98tw7kbymbru	SELECT PL_AMT_ID FROM P_E_PL_A...
80,138	25,381	3.16	2.15	3,057.19	8.24	37.56	07ttw6rma134k	begin pkg_ca_counter.p_ca_arra...
59,241	50,659	1.17	1.59	837.03	2.89	99.13	bxctd2r3kgjyb	SELECT PL_AMT_ID FROM P_E_PL_A...
59,225	50,660	1.17	1.59	839.79	1.98	99.12	7q8fzfa8p6gk8	SELECT PL_AMT_ID FROM P_E_PL_A...
59,044	25,279	2.34	1.58	856.33	3.24	96.67	4bf7r12w7dg25	SELECT pkg_sp_seq.f_a_defid se...
19,928	24,985	0.80	0.53	521.65	5.08	57.89	33j84p5q021j3	INSERT INTO A_PAY_FLOW (CHARGE...
15,586	3,586	4.35	0.42	304.95	2.04	96.57	g4ncbpmxhsh2b	SELECT a.org_no, a.cons_id, a....
13,963	10,796	1.29	0.37	282.94	1.86	97.39	b76zzq2h9gm66	SELECT count(*) record_num FRO...

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: 3,732,770
Captured SQL account for 99.9% of Total
Total UnOptimized Read Requests: 3,732,770
Captured SQL account for 99.9% 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 Text
3,481,589	3,481,589	177,486	19.62	93.27	9t6habqtx6vzg	begin pkg_ca_counter.p_ca_coun...
1,740,790	1,740,790	1,774,976	0.98	46.64	86g6708pvuqtu	SELECT PL_AMT_ID FROM P_E_PL_A...
1,740,670	1,740,670	1,775,010	0.98	46.63	c98tw7kbymbru	SELECT PL_AMT_ID FROM P_E_PL_A...
80,117	80,117	25,381	3.16	2.15	07ttw6rma134k	begin pkg_ca_counter.p_ca_arra...
59,241	59,241	50,659	1.17	1.59	bxctd2r3kgjyb	SELECT PL_AMT_ID FROM P_E_PL_A...
59,225	59,225	50,660	1.17	1.59	7q8fzfa8p6gk8	SELECT PL_AMT_ID FROM P_E_PL_A...
59,044	59,044	25,279	2.34	1.58	4bf7r12w7dg25	SELECT pkg_sp_seq.f_a_defid se...
19,928	19,928	24,985	0.80	0.53	33j84p5q021j3	INSERT INTO A_PAY_FLOW (CHARGE...
15,586	15,586	3,586	4.35	0.42	g4ncbpmxhsh2b	SELECT a.org_no, a.cons_id, a....
13,963	13,963	10,796	1.29	0.37	b76zzq2h9gm66	SELECT count(*) record_num FRO...

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: 22,571,255
Captured SQL account for 68.7% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
3,899,753	3,899,587	1.00	175.56	14.9	0	4fuvxgt352tdg	SELECT role_id FROM p_role WHE...
3,887,786	57,524,873	14.80	20,560.42	88	0	83p6uchsnm6n2	SELECT a.sys_user_name, a.org_...
1,775,010	1,774,952	1.00	17,943.59	2.4	98.9	c98tw7kbymbru	SELECT PL_AMT_ID FROM P_E_PL_A...
1,774,976	1,774,922	1.00	21,876.12	1.8	99.1	86g6708pvuqtu	SELECT PL_AMT_ID FROM P_E_PL_A...
622,304	622,292	1.00	43.24	40.6	0	f64k97dx2b3ng	select * from indy_user where ...
622,279	42,934,041	68.99	266.95	37.3	0	f3pwz8c7b36m5	select * from indy_user_profil...
228,164	228,161	1.00	39.34	51.8	0	g03fat3zm461h	SELECT CAST(DBMS_RANDOM.VALUE(...
228,163	228,161	1.00	5.91	61.2	0	g29djn2028jrv	SELECT MOD(:B1 , 12) FROM DUAL
177,500	532,509	3.00	16.18	49.3	0	f0zvt5m556g1h	SELECT '' NAME, '' VALUE, 0 DI...
177,495	2,307,535	13.00	19.14	46.9	0	d84sbdxtx6154	SELECT PARA_NAME NAME, PARA_VA...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 2,771,057
Captured SQL account for 78.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
177,435	177,481	6.40	7b264xcn53h3m	SELECT :B21 LOCATION, :B20 RCV...
177,430	177,494	6.40	43nabnvjnxcxs	SELECT PARA_NAME NAME, PARA_VA...
177,422	177,495	6.40	d84sbdxtx6154	SELECT PARA_NAME NAME, PARA_VA...
177,413	177,495	6.40	g2rwb6n6qd4sy	SELECT NAME, VALUE, VALUE \|\| '...
177,372	177,500	6.40	f0zvt5m556g1h	SELECT '' NAME, '' VALUE, 0 DI...
162,564	1,774,976	5.87	86g6708pvuqtu	SELECT PL_AMT_ID FROM P_E_PL_A...
162,558	1,775,010	5.87	c98tw7kbymbru	SELECT PL_AMT_ID FROM P_E_PL_A...
100,669	228,164	3.63	g03fat3zm461h	SELECT CAST(DBMS_RANDOM.VALUE(...
100,669	228,163	3.63	g29djn2028jrv	SELECT MOD(:B1 , 12) FROM DUAL
54,794	56,641	1.98	bunvx480ynf57	SELECT 1 FROM DUAL
50,953	50,953	1.84	ct1sv0zp5u7bz	SELECT * FROM TABLE(:B1 )
46,438	50,660	1.68	7q8fzfa8p6gk8	SELECT PL_AMT_ID FROM P_E_PL_A...
46,434	50,659	1.68	bxctd2r3kgjyb	SELECT PL_AMT_ID FROM P_E_PL_A...
35,661	51,056	1.29	bp3yfmnrn6u37	SELECT NVL(PARA_VALUE, '?') FR...
35,433	50,660	1.28	85x2nh0ncy4rn	SELECT PARA_VALUE FROM A_PAY_C...
29,255	29,255	1.06	3pfdq4w46wcgt	SELECT * FROM (SELECT T.*, ROW...
29,117	87,924	1.05	24sywb47s816k	SELECT PARA_NAME NAME, PARA_VA...
28,711	91,612	1.04	9b5xuf6ffcgq3	SELECT t.org_no org_no, null p...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

%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): 2,404
Captured SQL account for 83.3% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Text
1,634.66	25,381	67.99	3,057.19	53.47	8.24	37.56	07ttw6rma134k	begin pkg_ca_counter.p_ca_arra...
1,217.83	24,982	50.65	1,260.15	96.64	2.52	0.76	fb7paxp4m9wcg	INSERT INTO A_PREPAY_FLOW (PRE...
232.75	3,366	9.68	289.67	80.35	5.02	14.90	09g7gn0zqnu2s	begin pkg_be_common.p_initapp(...
216.33	25,377	9.00	229.44	94.29	7.00	1.01	g5tva0zp1yz4v	SELECT NVL(PREPAY_BAL, 0) - NV...
213.90	3,366	8.90	221.17	96.71	1.41	2.18	512pkdrfucyax	INSERT INTO S_APP_CERT (ACT_ID...
192.06	24,985	7.99	521.65	36.82	5.08	57.89	33j84p5q021j3	INSERT INTO A_PAY_FLOW (CHARGE...
55.43	30,060	2.31	139.54	39.72	17.83	39.61	dfcmxs132fy4g	begin pkg_be_common.p_updatere...
43.26	3,339	1.80	80.69	53.61	33.61	9.72	5xwhyp8wvvjwk	BEGIN OWF_MGR.WF_ENGINE.STARTP...
41.76	101,503	1.74	170.13	24.55	51.52	0.00	cr61tqvuq0fzd	select pkg_ca_counter.f_getnew...
40.29	101,329	1.68	115.69	34.82	52.91	0.00	942n22j17wfux	SELECT CUR_NOTE_NO, INV_OPER_I...
24.66	3,616	1.03	170.97	14.42	3.16	82.73	c49c86qkjp1hf	INSERT INTO C_CONS(CONS_ID, VA...
24.24	18,080	1.01	167.95	14.43	5.56	80.07	9j429cnhv8w62	INSERT INTO p_special_maint_lo...
11.19	29	0.47	42.09	26.59	43.85	26.25	awvtdy3vc6fum	SELECT codeId, codeSortId, par...
5.63	3,586	0.23	304.95	1.85	2.04	96.57	g4ncbpmxhsh2b	SELECT a.org_no, a.cons_id, a....
4.06	25,279	0.17	109.97	3.69	85.04	1.02	7xn7z2p30awww	begin pkg_ca_counter.p_ca_coun...
3.78	107,865	0.16	1,115.56	0.34	98.73	0.00	42pxs62tawj10	SELECT RCVBL_YM, ORG_NO, SUM(R...
3.78	29,254	0.16	2,460.39	0.15	98.08	0.00	ctpdw3pywk3k9	begin pkg_ca_lookup.p_get_owec...
3.67	3,616	0.15	100.98	3.64	6.21	89.27	41xb9h8r0cfba	INSERT INTO C_CUST(ORG_NO, LEG...
2.81	10,796	0.12	282.94	0.99	1.86	97.39	b76zzq2h9gm66	SELECT count(*) record_num FRO...
2.77	3,616	0.12	125.20	2.21	2.78	95.48	gf7t338wcvvkh	INSERT INTO C_PAYMENT_RELA(PR_...
2.57	3,616	0.11	106.55	2.42	6.12	91.57	4jpp33nxykts6	begin pkg_ca_paymode.p_update_...
0.84	177,486	0.03	40,379.52	0.00	2.87	97.65	9t6habqtx6vzg	begin pkg_ca_counter.p_ca_coun...
0.43	1,774,976	0.02	21,876.12	0.00	1.78	99.12	86g6708pvuqtu	SELECT PL_AMT_ID FROM P_E_PL_A...
0.41	1,775,010	0.02	17,943.59	0.00	2.41	98.94	c98tw7kbymbru	SELECT PL_AMT_ID FROM P_E_PL_A...
0.38	25,279	0.02	6.89	5.47	41.87	10.45	5ka8uwtu53fcd	SELECT A.TMP_PAY_RELA_NO, A.CO...
0.02	50,660	0.00	839.79	0.00	1.98	99.12	7q8fzfa8p6gk8	SELECT PL_AMT_ID FROM P_E_PL_A...
0.02	50,659	0.00	837.03	0.00	2.89	99.13	bxctd2r3kgjyb	SELECT PL_AMT_ID FROM P_E_PL_A...
0.01	25,279	0.00	856.33	0.00	3.24	96.67	4bf7r12w7dg25	SELECT pkg_sp_seq.f_a_defid se...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

07ttw6rma134k begin pkg_ca_counter.p_ca_array_write_off(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18); end;

09g7gn0zqnu2s begin pkg_be_common.p_initapp(:1, :2, :3, :4, :5, :6, :7, :8, :9); end;

0zy85nnkqxrx6 select dept_no deptno from v_mr_dep_no where org_no = :1 order by prio_code

24sywb47s816k SELECT PARA_NAME NAME, PARA_VALUE VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '??????????'

33j84p5q021j3 INSERT INTO A_PAY_FLOW (CHARGE_ID, CASHCHK_ID, ACCT_ID, CONS_NO, ORG_NO, CHARGE_YM, CHARGE_DATE, ACCT_YM, TYPE_CODE, RCV_AMT, THIS_CHG, LAST_CHG, CHARGE_EMP_NO, PAY_MODE, SETTLE_MODE, SETTLE_NOTE_NO, SETTLE_BANK_CODE, ACCT_NO, CHARGE_REMARK, RCV_ORG_NO, DEPT_NO, STATUS_CODE, RELATE_ID, RCVED_DATE, BANK_DATE, CONS_BANK_ACCT, BRANCH_ID, PREPAY_CODE) VALUES (:B1 , :B31 , :B2 , :B3 , :B4 , TO_CHAR(:B15 , 'YYYYMM'), :B15 , :B30 , :B29 , :B5 , :B6 , :B7 , :B28 , :B27 , :B26 , :B25 , :B24 , :B8 , 'THIS:' || TO_CHAR(:B23 , :B22 ) || '|LAST:' || TO_CHAR(:B23 - DECODE(:B17 , '????', 0, NVL(:B9 , 0)), :B22 ) || '|' || DECODE(NVL(:B10 , '0'), '0', '', 'TRAN:' || :B10 ) || '|' || DECODE(:B17 , '????', 'XGYS:' || :B11 ) || '|' || DECODE(:B17 , '????', 'XGSJ:' || :B21 ) || '|' || DECODE(:B20 , -999999, '', 0, '', 'YZJE:' || :B20 || '|'), :B19 , :B18 , DECODE(:B17 , '????', '02', '01'), NULL, TO_CHAR(:B15 , 'YYYYMMDD'), NVL(:B1 6 , TO_CHAR(:B15 , 'yyyymmdd')), NVL(:B14 , '0'), :B13 , :B12 )

3d3k6bzs4nk3f SELECT RCVBL_YM, ORG_NO, SUM(RCVBL_AMT) RCVBL_AMT, OPERATOR_NO FROM (SELECT RCVBL_YM, ORG_NO, RCVBL_AMT, B.OPERATOR_NO FROM P_MID_RCVBL_YSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND AMT_TYPE NOT IN (SELECT T.PARA_VALUE FROM A_PAY_CFG T WHERE PARA_TYPE = '??????????') AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B2 OR :B2 IS NULL) AND A.RELEASE_YM < SUBSTR(:B1 , 1, 6) UNION ALL SELECT RCVBL_YM, ORG_NO, RCVBL_AMT, B.OPERATOR_NO FROM P_MID_RCVBLSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND AMT_TYPE NOT IN (SELECT T.PARA_VALUE FROM A_PAY_CFG T WHERE PARA_TYPE = '??????????') AND RELEASE_DATE <> TO_CHAR(SYSDATE, 'yyyymmdd') AND RELEASE_DATE <= :B1 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RELEASE_YM = SUBSTR(:B1 , 1, 6) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B2 OR :B2 IS NULL) UNION ALL SELECT RCVBL_YM, ORG_NO, RCVBL_AMT, B.OPERATOR_ NO FROM A_RCVBL_FLOW A, R_OPER_ACTIVITY B WHERE AMT_TYPE NOT IN (SELECT T.PARA_VALUE FROM A_PAY_CFG T WHERE PARA_TYPE = '??????????') AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RELEASE_DATE = TO_CHAR(SYSDATE, 'yyyymmdd') AND :B1 = TO_CHAR(SYSDATE, 'yyyymmdd') AND ORG_NO = :B5 AND (B.OPERATOR_NO = :B2 OR :B2 IS NULL) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03') GROUP BY RCVBL_YM, ORG_NO, OPERATOR_NO

3pfdq4w46wcgt SELECT * FROM (SELECT T.*, ROWNUM RN FROM (SELECT RCVBL_YM, ORG_NO, MR_SECT_EMPNO, SUM(RCVBL_AMT) RCVBL_AMT, SUM(RCVED_AMT) RCVED_AMT, SUM(RCVBL_AMT) - SUM(RCVED_AMT) OWE_AMT, (CASE SIGN(SUM(RCVBL_AMT)) WHEN 1 THEN TO_CHAR(SUM(RCVED_AMT) / SUM(RCVBL_AMT) * 100, '9999990.09') || '%' WHEN -1 THEN TO_CHAR(SUM(RCVED_AMT) / SUM(RCVBL_AMT) * 100, '9999990.09') || '%' ELSE '100%' END) RCVED_RAT, '??' DETAIL FROM TABLE(:B1 ) GROUP BY RCVBL_YM, ORG_NO, MR_SECT_EMPNO ORDER BY ORG_NO, RCVBL_YM DESC, MR_SECT_EMPNO) T) WHERE RN BETWEEN :B3 AND :B2

41xb9h8r0cfba INSERT INTO C_CUST(ORG_NO, LEGAL_PERSON, CUST_ID, CUST_NO, NAME) VALUES(:1, :2, :3, :4, :5)

42pxs62tawj10 SELECT RCVBL_YM, ORG_NO, SUM(RCVED_AMT) RCVED_AMT, OPERATOR_NO FROM (SELECT RCVBL_YM, ORG_NO, RCVED_AMT, B.OPERATOR_NO FROM P_MID_RCVED_YSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RCVED_YM <> TO_CHAR(SYSDATE, 'YYYYMM') AND RCVED_YM < SUBSTR(:B2 , 1, 6) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B1 OR :B1 IS NULL) UNION ALL SELECT RCVBL_YM, ORG_NO, RCVED_AMT, B.OPERATOR_NO FROM P_MID_RCVEDSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RCVED_DATE <> TO_CHAR(SYSDATE, 'YYYYMMDD') AND RCVED_DATE <= :B2 AND RCVED_YM = SUBSTR(:B2 , 1, 6) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B1 OR :B1 IS NULL) UNION ALL SELECT RCVBL_YM, ORG_NO, THIS_RCVED_AMT RCVED_AMT, B.OPERATOR_NO FROM A_RCVED_FLOW T, R_OPER_ACTIVITY B WHERE EXISTS (SELECT 1 FROM A_PAY_FLOW WHERE STATUS_CODE = '01' AND CHARGE_YM = T. RCVED_YM AND CHARGE_ID = T.CHARGE_ID) AND ORG_NO = :B5 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RCVED_YM = TO_CHAR(SYSDATE, 'YYYYMM') AND :B2 = TO_CHAR(SYSDATE, 'YYYYMMDD') AND RCVED_DATE = TO_CHAR(SYSDATE, 'YYYYMMDD') AND T.MR_SECT_NO = B.MR_SECT_NO AND (B.OPERATOR_NO = :B1 OR :B1 IS NULL) AND B.ACT_CODE = '03') GROUP BY RCVBL_YM, ORG_NO, OPERATOR_NO

43nabnvjnxcxs SELECT PARA_NAME NAME, PARA_VALUE VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '????????' ORDER BY FILE_ID ASC

4bf7r12w7dg25 SELECT pkg_sp_seq.f_a_defid seq FROM DUAL

4fuvxgt352tdg SELECT role_id FROM p_role WHERE role_desc = :1 AND role_grant_flag = :2 AND range_code = :3

4jpp33nxykts6 begin pkg_ca_paymode.p_update_cons_extend(:1, :2, :3); end;

4nxjprfhqt4jr select DISTINCT a.sys_user_name, a.org_no, a.dept_no, a.user_name from v_sp_user a where exists (select 1 from p_user_role_rela b where a.sys_user_name = b.sys_user_name and b.role_id = :1) AND a.org_no in (select org_no from o_org start with org_no = :2 connect by PRIOR org_no = p_org_no) AND a.cur_status_code IN ('04', '01') ORDER BY nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M')

512pkdrfucyax INSERT INTO S_APP_CERT (ACT_ID, APPN_ID, APP_ID, CERT_EFFECT_DATE, CERT_EXPIRE_DATE, CERT_ID, CERT_NAME, CERT_NO, CERT_TYPE_CODE, DIRECTORY) SELECT PKG_SP_SEQ.F_C_DEFID, :B3 , :B2 , CERT_EFFECT_DATE, CERT_EXPIRE_DATE, CERT_ID, CERT_NAME, CERT_NO, CERT_TYPE_CODE, DIRECTORY FROM C_CERT WHERE CUST_ID = :B1

5ka8uwtu53fcd SELECT A.TMP_PAY_RELA_NO, A.CONS_NAME, (SELECT ORG_NAME FROM O_ORG WHERE ORG_NO = A.ORG_NO) ORG_NAME, A.ORG_NO, A.ELEC_ADDR, (SELECT NAME FROM P_CODE WHERE VALUE = C.PAY_MODE AND CODE_TYPE = 'payMode') PAYMODE, D.VAT_NO VATNO, A.CUST_ID, STATUS_CODE, VOLT_CODE, A.CONS_NO FROM C_CONS A, C_PAYMENT_RELA B, C_ACCT C, C_VAT D WHERE C.ACCT_ID(+) = B.ACCT_ID AND B.CONS_ID(+) = A.CONS_ID AND D.VAT_ID(+) = A.VAT_ID AND A.CONS_NO = :B1

5xwhyp8wvvjwk BEGIN OWF_MGR.WF_ENGINE.STARTPROCESS(:1, :2);END;

71c03qpak3wm6 SELECT time_limit_id, bgn_act, end_act_no, time_limit, alarm_time_limit, unit FROM sgpm.P_PROC_TL a WHERE type_code = :1 AND handle_status_code = :2 AND EXISTS (select 1 from (select org_no from sgpm.o_org b start with b.org_no = :3 connect by prior b.p_org_no = b.org_no) temp where temp.org_no = a.org_no) AND a.bgn_act= :4 AND a.end_act_no= :5 AND rownum =1 ORDER BY org_no DESC

7b264xcn53h3m SELECT :B21 LOCATION, :B20 RCV_ORG_NO, :B19 ACCT_ORG_NO, TO_CHAR(:B18 ) PAGE_LINE, :B17 SFQX, :B16 TWFS, :B15 CHG, UPPER(:B14 ) POSCS, UPPER(:B13 ) VOICECS, :B12 APP_MODEL, :B11 PRT_VALUE, :B10 PREVIEW_FLAG, :B9 ANALYSIS_FLAG, :B8 MULTI_CONS, :B7 CHG_KZ, :B6 MAXMONEY, :B5 ISPRTTOGETHER, :B4 LIMITMONEY, :B3 PRECHG_KZ, :B2 PRECHK_FLAG, :B1 JM_BFSFZ FROM DUAL

7q8fzfa8p6gk8 SELECT PL_AMT_ID FROM P_E_PL_ATMTM WHERE ID = :B2 + :B1 *400

7xn7z2p30awww begin pkg_ca_counter.p_ca_counter_attr_query(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21); end;

83p6uchsnm6n2 SELECT a.sys_user_name, a.org_no, a.dept_no, a.user_name FROM v_sp_user a, p_user_role_rela b WHERE a.sys_user_name = b.sys_user_name AND b.role_id = :1 AND a.dept_no = :2 AND a.cur_status_code IN (:3, :4) ORDER BY nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M')

85x2nh0ncy4rn SELECT PARA_VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '????' AND PARA_NAME = '???????????'

86g6708pvuqtu SELECT PL_AMT_ID FROM P_E_PL_ATMTM WHERE ID = :B2 + :B1 *200

942n22j17wfux SELECT CUR_NOTE_NO, INV_OPER_ID, REMAIN_T_NUM FROM A_INV_IO WHERE OPER_STATUS = '02' AND NOTE_TYPE_CODE = :B2 AND INITIATOR_NO = :B1 AND VER_ID IS NOT NULL AND REMAIN_T_NUM > 0 AND BGN_NO = (SELECT MIN(BGN_NO) FROM A_INV_IO WHERE OPER_STATUS = '02' AND NOTE_TYPE_CODE = :B2 AND INITIATOR_NO = :B1 AND VER_ID IS NOT NULL AND REMAIN_T_NUM > 0)

9b5xuf6ffcgq3 SELECT t.org_no org_no, null p_org_no, t.sort_no disp_sn, t.org_name name, t.org_type org_type_code, (select count(a.org_no) FROM o_org a WHERE a.p_org_no = t.org_no) subs FROM o_org t WHERE t.org_no = :1 ORDER BY t.sort_no

9j429cnhv8w62 INSERT INTO p_special_maint_log (log_id, chg_type_code, table_name, primary_key, log_time, end_time, content, user_name, login_ip, qry_name, qry_value) VALUES (:1, :2, upper(:3), :4, SYSDATE, SYSDATE, :5, :6, :7, :8, :9)

9t6habqtx6vzg begin pkg_ca_counter.p_ca_counter_para(:1, :2, :3, :4, :5, :6, :7, :8); end;

awvtdy3vc6fum SELECT codeId, codeSortId, parentCodeId, codeType, orgNo, value, name, dispSn, content1, content2, content3, content4, content5 FROM (SELECT '' codeId, '' codeSortId, p_code parentCodeId, code_type codeType, org_no orgNo, value, name, disp_sn dispSn, content1, content2, content3, content4, content5 FROM v_sp_cache_code) WHERE codeType=:1

b76zzq2h9gm66 SELECT count(*) record_num FROM c_cons a WHERE a.org_no = :1 AND a.cons_no = :2 AND nvl(a.status_code, 'x') <> '9'

bp3yfmnrn6u37 SELECT NVL(PARA_VALUE, '?') FROM A_PAY_CFG WHERE PARA_TYPE = '????' AND PARA_NAME = '????????'

bunvx480ynf57 SELECT 1 FROM DUAL

bxctd2r3kgjyb SELECT PL_AMT_ID FROM P_E_PL_ATMTE WHERE ID = :B2 + :B1 *400

c49c86qkjp1hf INSERT INTO C_CONS(CONS_ID, VAT_ID, CUST_ID, CONS_NO, CONS_NAME, CUST_QUERY_NO, TMP_PAY_RELA_NO, ORGN_CONS_NO, VOLT_CODE, ELEC_ADDR, TRADE_CODE, ELEC_TYPE_CODE, CONTRACT_CAP, RUN_CAP, SHIFT_NO, LODE_ATTR_CODE, HEC_INDUSTRY_CODE, HOLIDAY, BUILD_DATE, PS_DATE, CANCEL_DATE, DUE_DATE, NOTIFY_MODE, SETTLE_MODE, STATUS_CODE, ORG_NO, RRIO_CODE, CHK_CYCLE, LAST_CHK_DATE, CHECKER_NO, POWEROFF_CODE, TRANSFER_CODE, MR_SECT_NO, NOTE_TYPE_CODE, TMP_FLAG, TMP_DATE, CONS_SORT_CODE, RURAL_CONS_CODE) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38)

c98tw7kbymbru SELECT PL_AMT_ID FROM P_E_PL_ATMTE WHERE ID = :B2 + :B1 *200

cr61tqvuq0fzd select pkg_ca_counter.f_getnewnoteno(:1, :2) inv_no from dual

ct1sv0zp5u7bz SELECT * FROM TABLE(:B1 )

ctpdw3pywk3k9 begin pkg_ca_lookup.p_get_owecount_group_empno(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13); end;

d84sbdxtx6154 SELECT PARA_NAME NAME, PARA_VALUE VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '????????' ORDER BY FILE_ID ASC

dfcmxs132fy4g begin pkg_be_common.p_updaterecord(:1, :2, :3, :4, :5); end;

f0zvt5m556g1h SELECT '' NAME, '' VALUE, 0 DISP_SN FROM DUAL UNION ALL SELECT NAME, VALUE, DISP_SN FROM P_CODE WHERE CODE_TYPE = 'bankCode' AND NVL(CONTENT1, 1) = '1'

f3pwz8c7b36m5 select * from indy_user_profile where user_id in ( select user_id from indy_user where user_name=:1 )

f64k97dx2b3ng select * from indy_user where user_name=:1

fb7paxp4m9wcg INSERT INTO A_PREPAY_FLOW (PREPAY_ID, CHARGE_ID, PREPAY_AMT, CONS_NO, ORG_NO, PREPAY_DATE, PREPAY_YM, ACCT_NO, NOTE_ID, RCVBL_AMT_ID, PREPAY_TYPE, PREPAY_CODE, AMT_TYPE) SELECT PKG_SP_SEQ.F_A_PRE_FLO_PREID, :B7 , :B6 - :B8 , :B5 , :B4 , TO_CHAR(:B9 , 'YYYYMMDD'), TO_CHAR(:B9 , 'YYYYMM'), :B3 , '0', :B2 , '01', :B1 , '01' FROM DUAL WHERE :B6 - :B8 <> 0

g03fat3zm461h SELECT CAST(DBMS_RANDOM.VALUE(1, 257199038) AS NUMBER(9)) FROM DUAL

g29djn2028jrv SELECT MOD(:B1 , 12) FROM DUAL

g2rwb6n6qd4sy SELECT NAME, VALUE, VALUE || '|' || DECODE(NVL(CONTENT2, '?'), '?', 'YES', '?', 'NO') ISINV FROM V_SP_CODE WHERE VALUE NOT IN ('06', '09', '04', '07') AND CODE_TYPE = 'settleMode' ORDER BY VALUE ASC

g4ncbpmxhsh2b SELECT a.org_no, a.cons_id, a.cust_id, a.rrio_code, a.run_cap orgn_run_cap, a.run_cap t_run_cap, a.cust_id, a.cons_id, a.cons_no, a.cons_name, a.cust_query_no, a.tmp_pay_rela_no, a.orgn_cons_no, a.cons_sort_code, a.elec_addr, a.trade_code, (SELECT name FROM v_sp_code WHERE code_type = 'tradeCode' AND value = a.trade_code) trade, a.elec_type_code, a.shift_no, (SELECT o.org_name FROM o_org o WHERE o.org_no= a.org_no) org_name, a.lode_attr_code, a.volt_code, a.hec_industry_code, a.holiday, a.notify_mode, a.settle_mode, a.org_no ps_org_no, a.transfer_code, a.mr_sect_no, a.note_type_code, a.tmp_flag, a.tmp_date, a.build_date, a.contract_cap orgn_contract_cap, a.contract_cap t_contract_cap, a.rrio_code prio_code, b.pr_id, b.pay_agreement_no, c.pay_mode, d.vat_id, d.vat_name, d.vat_no, d.vat_acct, d.bank_code vat_bank_code, d.reg_addr, d.tel_no vat_tel_no, d.bgn_date vat_bgn_date, d.end_date vat_end_date, e.csa_id elec_addr_id, e.province_code, e.cit y_code, e.county_code, e.street_code, e.village_code, e.road_code, e.community_code, e.plate_no, f.cust_no, f.name cust_name, f.credit_level_code, f.value_level_code, f.risk_level_code, f.org_no cust_org_no FROM c_cons a, c_payment_rela b, c_acct c, c_vat d, c_elec_addr e, c_cust f WHERE a.cons_id = b.cons_id(+) AND b.acct_id = c.acct_id(+) AND a.vat_id = d.vat_id(+) AND a.cons_id = e.cons_id(+) AND a.cust_id = f.cust_id(+) AND a.cons_no = :1

g5tva0zp1yz4v SELECT NVL(PREPAY_BAL, 0) - NVL(FREEZE_AMT, 0) - NVL(TRANSIT_NOTE_BAL, 0) - NVL(CHECK_AMT, 0), NVL(FREEZE_AMT, 0) FROM A_ACCT_BAL WHERE CONS_NO = :B2 AND PREPAY_CODE = :B1 FOR UPDATE NOWAIT

gf7t338wcvvkh INSERT INTO C_PAYMENT_RELA(PR_ID, ACCT_ID, CONS_ID, PAY_AGREEMENT_NO, ORG_NO) VALUES(:1, :2, :3, :4, :5)

SQL Id	SQL Text
07ttw6rma134k	begin pkg_ca_counter.p_ca_array_write_off(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18); end;
09g7gn0zqnu2s	begin pkg_be_common.p_initapp(:1, :2, :3, :4, :5, :6, :7, :8, :9); end;
0zy85nnkqxrx6	select dept_no deptno from v_mr_dep_no where org_no = :1 order by prio_code
24sywb47s816k	SELECT PARA_NAME NAME, PARA_VALUE VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '??????????'
33j84p5q021j3	INSERT INTO A_PAY_FLOW (CHARGE_ID, CASHCHK_ID, ACCT_ID, CONS_NO, ORG_NO, CHARGE_YM, CHARGE_DATE, ACCT_YM, TYPE_CODE, RCV_AMT, THIS_CHG, LAST_CHG, CHARGE_EMP_NO, PAY_MODE, SETTLE_MODE, SETTLE_NOTE_NO, SETTLE_BANK_CODE, ACCT_NO, CHARGE_REMARK, RCV_ORG_NO, DEPT_NO, STATUS_CODE, RELATE_ID, RCVED_DATE, BANK_DATE, CONS_BANK_ACCT, BRANCH_ID, PREPAY_CODE) VALUES (:B1 , :B31 , :B2 , :B3 , :B4 , TO_CHAR(:B15 , 'YYYYMM'), :B15 , :B30 , :B29 , :B5 , :B6 , :B7 , :B28 , :B27 , :B26 , :B25 , :B24 , :B8 , 'THIS:' \|\| TO_CHAR(:B23 , :B22 ) \|\| '\|LAST:' \|\| TO_CHAR(:B23 - DECODE(:B17 , '????', 0, NVL(:B9 , 0)), :B22 ) \|\| '\|' \|\| DECODE(NVL(:B10 , '0'), '0', '', 'TRAN:' \|\| :B10 ) \|\| '\|' \|\| DECODE(:B17 , '????', 'XGYS:' \|\| :B11 ) \|\| '\|' \|\| DECODE(:B17 , '????', 'XGSJ:' \|\| :B21 ) \|\| '\|' \|\| DECODE(:B20 , -999999, '', 0, '', 'YZJE:' \|\| :B20 \|\| '\|'), :B19 , :B18 , DECODE(:B17 , '????', '02', '01'), NULL, TO_CHAR(:B15 , 'YYYYMMDD'), NVL(:B1 6 , TO_CHAR(:B15 , 'yyyymmdd')), NVL(:B14 , '0'), :B13 , :B12 )
3d3k6bzs4nk3f	SELECT RCVBL_YM, ORG_NO, SUM(RCVBL_AMT) RCVBL_AMT, OPERATOR_NO FROM (SELECT RCVBL_YM, ORG_NO, RCVBL_AMT, B.OPERATOR_NO FROM P_MID_RCVBL_YSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND AMT_TYPE NOT IN (SELECT T.PARA_VALUE FROM A_PAY_CFG T WHERE PARA_TYPE = '??????????') AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B2 OR :B2 IS NULL) AND A.RELEASE_YM < SUBSTR(:B1 , 1, 6) UNION ALL SELECT RCVBL_YM, ORG_NO, RCVBL_AMT, B.OPERATOR_NO FROM P_MID_RCVBLSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND AMT_TYPE NOT IN (SELECT T.PARA_VALUE FROM A_PAY_CFG T WHERE PARA_TYPE = '??????????') AND RELEASE_DATE <> TO_CHAR(SYSDATE, 'yyyymmdd') AND RELEASE_DATE <= :B1 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RELEASE_YM = SUBSTR(:B1 , 1, 6) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B2 OR :B2 IS NULL) UNION ALL SELECT RCVBL_YM, ORG_NO, RCVBL_AMT, B.OPERATOR_ NO FROM A_RCVBL_FLOW A, R_OPER_ACTIVITY B WHERE AMT_TYPE NOT IN (SELECT T.PARA_VALUE FROM A_PAY_CFG T WHERE PARA_TYPE = '??????????') AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RELEASE_DATE = TO_CHAR(SYSDATE, 'yyyymmdd') AND :B1 = TO_CHAR(SYSDATE, 'yyyymmdd') AND ORG_NO = :B5 AND (B.OPERATOR_NO = :B2 OR :B2 IS NULL) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03') GROUP BY RCVBL_YM, ORG_NO, OPERATOR_NO
3pfdq4w46wcgt	SELECT * FROM (SELECT T., ROWNUM RN FROM (SELECT RCVBL_YM, ORG_NO, MR_SECT_EMPNO, SUM(RCVBL_AMT) RCVBL_AMT, SUM(RCVED_AMT) RCVED_AMT, SUM(RCVBL_AMT) - SUM(RCVED_AMT) OWE_AMT, (CASE SIGN(SUM(RCVBL_AMT)) WHEN 1 THEN TO_CHAR(SUM(RCVED_AMT) / SUM(RCVBL_AMT) 100, '9999990.09') \|\| '%' WHEN -1 THEN TO_CHAR(SUM(RCVED_AMT) / SUM(RCVBL_AMT) * 100, '9999990.09') \|\| '%' ELSE '100%' END) RCVED_RAT, '??' DETAIL FROM TABLE(:B1 ) GROUP BY RCVBL_YM, ORG_NO, MR_SECT_EMPNO ORDER BY ORG_NO, RCVBL_YM DESC, MR_SECT_EMPNO) T) WHERE RN BETWEEN :B3 AND :B2
41xb9h8r0cfba	INSERT INTO C_CUST(ORG_NO, LEGAL_PERSON, CUST_ID, CUST_NO, NAME) VALUES(:1, :2, :3, :4, :5)
42pxs62tawj10	SELECT RCVBL_YM, ORG_NO, SUM(RCVED_AMT) RCVED_AMT, OPERATOR_NO FROM (SELECT RCVBL_YM, ORG_NO, RCVED_AMT, B.OPERATOR_NO FROM P_MID_RCVED_YSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RCVED_YM <> TO_CHAR(SYSDATE, 'YYYYMM') AND RCVED_YM < SUBSTR(:B2 , 1, 6) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B1 OR :B1 IS NULL) UNION ALL SELECT RCVBL_YM, ORG_NO, RCVED_AMT, B.OPERATOR_NO FROM P_MID_RCVEDSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RCVED_DATE <> TO_CHAR(SYSDATE, 'YYYYMMDD') AND RCVED_DATE <= :B2 AND RCVED_YM = SUBSTR(:B2 , 1, 6) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B1 OR :B1 IS NULL) UNION ALL SELECT RCVBL_YM, ORG_NO, THIS_RCVED_AMT RCVED_AMT, B.OPERATOR_NO FROM A_RCVED_FLOW T, R_OPER_ACTIVITY B WHERE EXISTS (SELECT 1 FROM A_PAY_FLOW WHERE STATUS_CODE = '01' AND CHARGE_YM = T. RCVED_YM AND CHARGE_ID = T.CHARGE_ID) AND ORG_NO = :B5 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RCVED_YM = TO_CHAR(SYSDATE, 'YYYYMM') AND :B2 = TO_CHAR(SYSDATE, 'YYYYMMDD') AND RCVED_DATE = TO_CHAR(SYSDATE, 'YYYYMMDD') AND T.MR_SECT_NO = B.MR_SECT_NO AND (B.OPERATOR_NO = :B1 OR :B1 IS NULL) AND B.ACT_CODE = '03') GROUP BY RCVBL_YM, ORG_NO, OPERATOR_NO
43nabnvjnxcxs	SELECT PARA_NAME NAME, PARA_VALUE VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '????????' ORDER BY FILE_ID ASC
4bf7r12w7dg25	SELECT pkg_sp_seq.f_a_defid seq FROM DUAL
4fuvxgt352tdg	SELECT role_id FROM p_role WHERE role_desc = :1 AND role_grant_flag = :2 AND range_code = :3
4jpp33nxykts6	begin pkg_ca_paymode.p_update_cons_extend(:1, :2, :3); end;
4nxjprfhqt4jr	select DISTINCT a.sys_user_name, a.org_no, a.dept_no, a.user_name from v_sp_user a where exists (select 1 from p_user_role_rela b where a.sys_user_name = b.sys_user_name and b.role_id = :1) AND a.org_no in (select org_no from o_org start with org_no = :2 connect by PRIOR org_no = p_org_no) AND a.cur_status_code IN ('04', '01') ORDER BY nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M')
512pkdrfucyax	INSERT INTO S_APP_CERT (ACT_ID, APPN_ID, APP_ID, CERT_EFFECT_DATE, CERT_EXPIRE_DATE, CERT_ID, CERT_NAME, CERT_NO, CERT_TYPE_CODE, DIRECTORY) SELECT PKG_SP_SEQ.F_C_DEFID, :B3 , :B2 , CERT_EFFECT_DATE, CERT_EXPIRE_DATE, CERT_ID, CERT_NAME, CERT_NO, CERT_TYPE_CODE, DIRECTORY FROM C_CERT WHERE CUST_ID = :B1
5ka8uwtu53fcd	SELECT A.TMP_PAY_RELA_NO, A.CONS_NAME, (SELECT ORG_NAME FROM O_ORG WHERE ORG_NO = A.ORG_NO) ORG_NAME, A.ORG_NO, A.ELEC_ADDR, (SELECT NAME FROM P_CODE WHERE VALUE = C.PAY_MODE AND CODE_TYPE = 'payMode') PAYMODE, D.VAT_NO VATNO, A.CUST_ID, STATUS_CODE, VOLT_CODE, A.CONS_NO FROM C_CONS A, C_PAYMENT_RELA B, C_ACCT C, C_VAT D WHERE C.ACCT_ID(+) = B.ACCT_ID AND B.CONS_ID(+) = A.CONS_ID AND D.VAT_ID(+) = A.VAT_ID AND A.CONS_NO = :B1
5xwhyp8wvvjwk	BEGIN OWF_MGR.WF_ENGINE.STARTPROCESS(:1, :2);END;
71c03qpak3wm6	SELECT time_limit_id, bgn_act, end_act_no, time_limit, alarm_time_limit, unit FROM sgpm.P_PROC_TL a WHERE type_code = :1 AND handle_status_code = :2 AND EXISTS (select 1 from (select org_no from sgpm.o_org b start with b.org_no = :3 connect by prior b.p_org_no = b.org_no) temp where temp.org_no = a.org_no) AND a.bgn_act= :4 AND a.end_act_no= :5 AND rownum =1 ORDER BY org_no DESC
7b264xcn53h3m	SELECT :B21 LOCATION, :B20 RCV_ORG_NO, :B19 ACCT_ORG_NO, TO_CHAR(:B18 ) PAGE_LINE, :B17 SFQX, :B16 TWFS, :B15 CHG, UPPER(:B14 ) POSCS, UPPER(:B13 ) VOICECS, :B12 APP_MODEL, :B11 PRT_VALUE, :B10 PREVIEW_FLAG, :B9 ANALYSIS_FLAG, :B8 MULTI_CONS, :B7 CHG_KZ, :B6 MAXMONEY, :B5 ISPRTTOGETHER, :B4 LIMITMONEY, :B3 PRECHG_KZ, :B2 PRECHK_FLAG, :B1 JM_BFSFZ FROM DUAL
7q8fzfa8p6gk8	SELECT PL_AMT_ID FROM P_E_PL_ATMTM WHERE ID = :B2 + :B1 *400
7xn7z2p30awww	begin pkg_ca_counter.p_ca_counter_attr_query(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21); end;
83p6uchsnm6n2	SELECT a.sys_user_name, a.org_no, a.dept_no, a.user_name FROM v_sp_user a, p_user_role_rela b WHERE a.sys_user_name = b.sys_user_name AND b.role_id = :1 AND a.dept_no = :2 AND a.cur_status_code IN (:3, :4) ORDER BY nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M')
85x2nh0ncy4rn	SELECT PARA_VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '????' AND PARA_NAME = '???????????'
86g6708pvuqtu	SELECT PL_AMT_ID FROM P_E_PL_ATMTM WHERE ID = :B2 + :B1 *200
942n22j17wfux	SELECT CUR_NOTE_NO, INV_OPER_ID, REMAIN_T_NUM FROM A_INV_IO WHERE OPER_STATUS = '02' AND NOTE_TYPE_CODE = :B2 AND INITIATOR_NO = :B1 AND VER_ID IS NOT NULL AND REMAIN_T_NUM > 0 AND BGN_NO = (SELECT MIN(BGN_NO) FROM A_INV_IO WHERE OPER_STATUS = '02' AND NOTE_TYPE_CODE = :B2 AND INITIATOR_NO = :B1 AND VER_ID IS NOT NULL AND REMAIN_T_NUM > 0)
9b5xuf6ffcgq3	SELECT t.org_no org_no, null p_org_no, t.sort_no disp_sn, t.org_name name, t.org_type org_type_code, (select count(a.org_no) FROM o_org a WHERE a.p_org_no = t.org_no) subs FROM o_org t WHERE t.org_no = :1 ORDER BY t.sort_no
9j429cnhv8w62	INSERT INTO p_special_maint_log (log_id, chg_type_code, table_name, primary_key, log_time, end_time, content, user_name, login_ip, qry_name, qry_value) VALUES (:1, :2, upper(:3), :4, SYSDATE, SYSDATE, :5, :6, :7, :8, :9)
9t6habqtx6vzg	begin pkg_ca_counter.p_ca_counter_para(:1, :2, :3, :4, :5, :6, :7, :8); end;
awvtdy3vc6fum	SELECT codeId, codeSortId, parentCodeId, codeType, orgNo, value, name, dispSn, content1, content2, content3, content4, content5 FROM (SELECT '' codeId, '' codeSortId, p_code parentCodeId, code_type codeType, org_no orgNo, value, name, disp_sn dispSn, content1, content2, content3, content4, content5 FROM v_sp_cache_code) WHERE codeType=:1
b76zzq2h9gm66	SELECT count(*) record_num FROM c_cons a WHERE a.org_no = :1 AND a.cons_no = :2 AND nvl(a.status_code, 'x') <> '9'
bp3yfmnrn6u37	SELECT NVL(PARA_VALUE, '?') FROM A_PAY_CFG WHERE PARA_TYPE = '????' AND PARA_NAME = '????????'
bunvx480ynf57	SELECT 1 FROM DUAL
bxctd2r3kgjyb	SELECT PL_AMT_ID FROM P_E_PL_ATMTE WHERE ID = :B2 + :B1 *400
c49c86qkjp1hf	INSERT INTO C_CONS(CONS_ID, VAT_ID, CUST_ID, CONS_NO, CONS_NAME, CUST_QUERY_NO, TMP_PAY_RELA_NO, ORGN_CONS_NO, VOLT_CODE, ELEC_ADDR, TRADE_CODE, ELEC_TYPE_CODE, CONTRACT_CAP, RUN_CAP, SHIFT_NO, LODE_ATTR_CODE, HEC_INDUSTRY_CODE, HOLIDAY, BUILD_DATE, PS_DATE, CANCEL_DATE, DUE_DATE, NOTIFY_MODE, SETTLE_MODE, STATUS_CODE, ORG_NO, RRIO_CODE, CHK_CYCLE, LAST_CHK_DATE, CHECKER_NO, POWEROFF_CODE, TRANSFER_CODE, MR_SECT_NO, NOTE_TYPE_CODE, TMP_FLAG, TMP_DATE, CONS_SORT_CODE, RURAL_CONS_CODE) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38)
c98tw7kbymbru	SELECT PL_AMT_ID FROM P_E_PL_ATMTE WHERE ID = :B2 + :B1 *200
cr61tqvuq0fzd	select pkg_ca_counter.f_getnewnoteno(:1, :2) inv_no from dual
ct1sv0zp5u7bz	SELECT * FROM TABLE(:B1 )
ctpdw3pywk3k9	begin pkg_ca_lookup.p_get_owecount_group_empno(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13); end;
d84sbdxtx6154	SELECT PARA_NAME NAME, PARA_VALUE VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '????????' ORDER BY FILE_ID ASC
dfcmxs132fy4g	begin pkg_be_common.p_updaterecord(:1, :2, :3, :4, :5); end;
f0zvt5m556g1h	SELECT '' NAME, '' VALUE, 0 DISP_SN FROM DUAL UNION ALL SELECT NAME, VALUE, DISP_SN FROM P_CODE WHERE CODE_TYPE = 'bankCode' AND NVL(CONTENT1, 1) = '1'
f3pwz8c7b36m5	select * from indy_user_profile where user_id in ( select user_id from indy_user where user_name=:1 )
f64k97dx2b3ng	select * from indy_user where user_name=:1
fb7paxp4m9wcg	INSERT INTO A_PREPAY_FLOW (PREPAY_ID, CHARGE_ID, PREPAY_AMT, CONS_NO, ORG_NO, PREPAY_DATE, PREPAY_YM, ACCT_NO, NOTE_ID, RCVBL_AMT_ID, PREPAY_TYPE, PREPAY_CODE, AMT_TYPE) SELECT PKG_SP_SEQ.F_A_PRE_FLO_PREID, :B7 , :B6 - :B8 , :B5 , :B4 , TO_CHAR(:B9 , 'YYYYMMDD'), TO_CHAR(:B9 , 'YYYYMM'), :B3 , '0', :B2 , '01', :B1 , '01' FROM DUAL WHERE :B6 - :B8 <> 0
g03fat3zm461h	SELECT CAST(DBMS_RANDOM.VALUE(1, 257199038) AS NUMBER(9)) FROM DUAL
g29djn2028jrv	SELECT MOD(:B1 , 12) FROM DUAL
g2rwb6n6qd4sy	SELECT NAME, VALUE, VALUE \|\| '\|' \|\| DECODE(NVL(CONTENT2, '?'), '?', 'YES', '?', 'NO') ISINV FROM V_SP_CODE WHERE VALUE NOT IN ('06', '09', '04', '07') AND CODE_TYPE = 'settleMode' ORDER BY VALUE ASC
g4ncbpmxhsh2b	SELECT a.org_no, a.cons_id, a.cust_id, a.rrio_code, a.run_cap orgn_run_cap, a.run_cap t_run_cap, a.cust_id, a.cons_id, a.cons_no, a.cons_name, a.cust_query_no, a.tmp_pay_rela_no, a.orgn_cons_no, a.cons_sort_code, a.elec_addr, a.trade_code, (SELECT name FROM v_sp_code WHERE code_type = 'tradeCode' AND value = a.trade_code) trade, a.elec_type_code, a.shift_no, (SELECT o.org_name FROM o_org o WHERE o.org_no= a.org_no) org_name, a.lode_attr_code, a.volt_code, a.hec_industry_code, a.holiday, a.notify_mode, a.settle_mode, a.org_no ps_org_no, a.transfer_code, a.mr_sect_no, a.note_type_code, a.tmp_flag, a.tmp_date, a.build_date, a.contract_cap orgn_contract_cap, a.contract_cap t_contract_cap, a.rrio_code prio_code, b.pr_id, b.pay_agreement_no, c.pay_mode, d.vat_id, d.vat_name, d.vat_no, d.vat_acct, d.bank_code vat_bank_code, d.reg_addr, d.tel_no vat_tel_no, d.bgn_date vat_bgn_date, d.end_date vat_end_date, e.csa_id elec_addr_id, e.province_code, e.cit y_code, e.county_code, e.street_code, e.village_code, e.road_code, e.community_code, e.plate_no, f.cust_no, f.name cust_name, f.credit_level_code, f.value_level_code, f.risk_level_code, f.org_no cust_org_no FROM c_cons a, c_payment_rela b, c_acct c, c_vat d, c_elec_addr e, c_cust f WHERE a.cons_id = b.cons_id(+) AND b.acct_id = c.acct_id(+) AND a.vat_id = d.vat_id(+) AND a.cons_id = e.cons_id(+) AND a.cust_id = f.cust_id(+) AND a.cons_no = :1
g5tva0zp1yz4v	SELECT NVL(PREPAY_BAL, 0) - NVL(FREEZE_AMT, 0) - NVL(TRANSIT_NOTE_BAL, 0) - NVL(CHECK_AMT, 0), NVL(FREEZE_AMT, 0) FROM A_ACCT_BAL WHERE CONS_NO = :B2 AND PREPAY_CODE = :B1 FOR UPDATE NOWAIT
gf7t338wcvvkh	INSERT INTO C_PAYMENT_RELA(PR_ID, ACCT_ID, CONS_ID, PAY_AGREEMENT_NO, ORG_NO) VALUES(:1, :2, :3, :4, :5)

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	2,915,246	1,035.59	86.19
execute count	22,571,255	8,018.03	667.30
gc cr block receive time	37,098	13.18	1.10
gc cr blocks received	64,662	22.97	1.91
gc current block receive time	103,763	36.86	3.07
gc current blocks received	278,822	99.05	8.24
logons cumulative	683	0.24	0.02
opened cursors cumulative	12,277,169	4,361.24	362.96
parse count (total)	2,771,057	984.37	81.92
parse time elapsed	6,917	2.46	0.20
physical reads	3,733,672	1,326.32	110.38
physical writes	201,403	71.54	5.95
redo size	475,777,416	169,011.23	14,065.85
session cursor cache hits	2,543,554	903.55	75.20
session logical reads	4,316,580,454	1,533,386.26	127,615.09
user calls	45,004,293	15,986.95	1,330.50
user commits	32,759	11.64	0.97
user rollbacks	1,066	0.38	0.03
workarea executions - optimal	6,599,836	2,344.47	195.12

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	3	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	13	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	8	0.00	0.00
Batched IO single block count	2	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	3	0.00	0.00
Batched IO vector read count	1	0.00	0.00
Block Cleanout Optim referenced	18,091	6.43	0.53
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	2,341,583	831.80	69.23
CPU used when call started	2,328,397	827.12	68.84
CR blocks created	27,282	9.69	0.81
Cached Commit SCN referenced	2,286,573	812.26	67.60
Commit SCN cached	7,596	2.70	0.22
DBWR checkpoint buffers written	141,431	50.24	4.18
DBWR checkpoints	0	0.00	0.00
DBWR fusion writes	43,137	15.32	1.28
DBWR object drop buffers written	0	0.00	0.00
DBWR transaction table writes	771	0.27	0.02
DBWR undo block writes	23,936	8.50	0.71
DFO trees parallelized	333	0.12	0.01
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	406,619	144.44	12.02
Heap Segment Array Inserts	58,643	20.83	1.73
Heap Segment Array Updates	259	0.09	0.01
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	1,356	0.48	0.04
PX local messages sent	1,356	0.48	0.04
PX remote messages recv'd	682	0.24	0.02
PX remote messages sent	722	0.26	0.02
Parallel operations not downgraded	333	0.12	0.01
Requests to/from client	43,244,269	15,361.74	1,278.47
RowCR - row contention	14	0.00	0.00
RowCR attempts	4,645,111	1,650.09	137.33
RowCR hits	4,660,376	1,655.51	137.78
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	71	0.03	0.00
SQL*Net roundtrips to/from client	43,244,314	15,361.75	1,278.47
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	4	0.00	0.00
TBS Extension: tasks executed	4	0.00	0.00
active txn count during cleanout	68,093	24.19	2.01
background timeouts	19,579	6.96	0.58
branch node splits	217	0.08	0.01
buffer is not pinned count	4,081,497,774	1,449,877.44	120,665.12
buffer is pinned count	56,147,121,623	19,945,238.06	1,659,929.69
bytes received via SQL*Net from client	1,683,578,396	598,060.43	49,773.20
bytes sent via SQL*Net to client	10,864,719,688	3,859,492.96	321,203.83
calls to get snapshot scn: kcmgss	22,655,576	8,047.98	669.79
calls to kcmgas	179,667	63.82	5.31
calls to kcmgcs	1,656,853	588.57	48.98
cell physical IO interconnect bytes	33,426,034,688	11,873,987.48	988,205.02
change write time	1,472	0.52	0.04
cleanout - number of ktugct calls	45,720	16.24	1.35
cleanouts and rollbacks - consistent read gets	26,690	9.48	0.79
cleanouts only - consistent read gets	5,869	2.08	0.17
cluster key scan block gets	155,748	55.33	4.60
cluster key scans	87,041	30.92	2.57
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	297	0.11	0.01
commit batch/immediate requested	297	0.11	0.01
commit cleanout failures: block lost	33,109	11.76	0.98
commit cleanout failures: buffer being written	51	0.02	0.00
commit cleanout failures: callback failure	357	0.13	0.01
commit cleanout failures: cannot pin	134	0.05	0.00
commit cleanouts	983,557	349.39	29.08
commit cleanouts successfully completed	949,906	337.44	28.08
commit immediate performed	297	0.11	0.01
commit immediate requested	297	0.11	0.01
commit txn count during cleanout	111,728	39.69	3.30
consistent changes	267,788	95.13	7.92
consistent gets	4,313,109,806	1,532,153.37	127,512.49
consistent gets - examination	60,254,142	21,404.18	1,781.35
consistent gets direct	0	0.00	0.00
consistent gets from cache	4,313,109,806	1,532,153.37	127,512.49
consistent gets from cache (fastpath)	4,246,814,634	1,508,603.23	125,552.54
cursor authentications	5	0.00	0.00
data blocks consistent reads - undo records applied	41,784	14.84	1.24
db block gets	3,470,648	1,232.88	102.61
db block gets direct	301	0.11	0.01
db block gets from cache	3,470,347	1,232.78	102.60
db block gets from cache (fastpath)	994,268	353.20	29.39
deferred (CURRENT) block cleanout applications	261,687	92.96	7.74
dirty buffers inspected	19,021	6.76	0.56
enqueue conversions	28,247	10.03	0.84
enqueue releases	575,784	204.54	17.02
enqueue requests	576,224	204.69	17.04
enqueue timeouts	393	0.14	0.01
enqueue waits	2,647	0.94	0.08
exchange deadlocks	852	0.30	0.03
failed probes on index block reclamation	0	0.00	0.00
file io service time	1,821,117	646.92	53.84
free buffer inspected	4,125,565	1,465.53	121.97
free buffer requested	4,238,456	1,505.63	125.31
gc blocks compressed	193,868	68.87	5.73
gc cr block flush time	37,735	13.40	1.12
gc cr blocks served	59,805	21.24	1.77
gc current block flush time	87,398	31.05	2.58
gc current block pin time	366	0.13	0.01
gc current blocks served	261,833	93.01	7.74
gc force cr disk read	3	0.00	0.00
gc kbytes saved	555,689	197.40	16.43
gc kbytes sent	2,017,413	716.65	59.64
gc local grants	3,700,146	1,314.41	109.39
gc read wait timeouts	1	0.00	0.00
gc read waits	1,069	0.38	0.03
gc remote grants	94,382	33.53	2.79
gcs messages sent	744,240	264.38	22.00
ges messages sent	13,094	4.65	0.39
global enqueue get time	8,913	3.17	0.26
global enqueue gets async	465	0.17	0.01
global enqueue gets sync	4,452,716	1,581.75	131.64
global enqueue releases	4,422,534	1,571.02	130.75
heap block compress	1,236	0.44	0.04
hot buffers moved to head of LRU	1,083,436	384.87	32.03
immediate (CR) block cleanout applications	32,561	11.57	0.96
immediate (CURRENT) block cleanout applications	15,933	5.66	0.47
index crx upgrade (positioned)	1,882	0.67	0.06
index fast full scans (full)	38	0.01	0.00
index fetch by key	15,565,116	5,529.22	460.17
index scans kdiixs1	29,354,396	10,427.61	867.83
leaf node 90-10 splits	183	0.07	0.01
leaf node splits	4,956	1.76	0.15
lob reads	0	0.00	0.00
lob writes	68	0.02	0.00
lob writes unaligned	68	0.02	0.00
logical read bytes from cache	35,361,418,190,848	12,561,497,071.06	1,045,422,562.92
max cf enq hold time	120	0.04	0.00
messages received	187,826	66.72	5.55
messages sent	187,826	66.72	5.55
min active SCN optimization applied on CR	2,821,523	1,002.29	83.42
no buffer to keep pinned count	282	0.10	0.01
no work - consistent read gets	4,245,427,024	1,508,110.30	125,511.52
non-idle wait count	48,629,114	17,274.60	1,437.67
parse count (describe)	0	0.00	0.00
parse count (failures)	304	0.11	0.01
parse count (hard)	309	0.11	0.01
parse time cpu	4,283	1.52	0.13
physical read IO requests	3,732,770	1,326.00	110.36
physical read bytes	30,586,241,024	10,865,202.72	904,249.55
physical read total IO requests	3,741,452	1,329.08	110.61
physical read total bytes	30,728,213,504	10,915,635.84	908,446.81
physical read total multi block requests	8	0.00	0.00
physical reads cache	3,733,672	1,326.32	110.38
physical reads cache prefetch	907	0.32	0.03
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	137,846	48.97	4.08
physical write bytes	1,649,893,376	586,094.45	48,777.34
physical write total IO requests	211,890	75.27	6.26
physical write total bytes	2,697,821,184	958,351.63	79,758.20
physical write total multi block requests	2,280	0.81	0.07
physical writes direct	301	0.11	0.01
physical writes direct (lob)	4	0.00	0.00
physical writes direct temporary tablespace	1	0.00	0.00
physical writes from cache	201,102	71.44	5.95
physical writes non checkpoint	157,518	55.96	4.66
pinned buffers inspected	2,841	1.01	0.08
pinned cursors current	100	0.04	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	2	0.00	0.00
process last non-idle time	3,416	1.21	0.10
queries parallelized	333	0.12	0.01
recursive calls	43,294,308	15,379.51	1,279.95
recursive cpu usage	387,326	137.59	11.45
redo blocks checksummed by FG (exclusive)	183,068	65.03	5.41
redo blocks written	979,558	347.97	28.96
redo entries	1,637,744	581.78	48.42
redo ordering marks	20,169	7.16	0.60
redo size for direct writes	728	0.26	0.02
redo subscn max counts	6,119	2.17	0.18
redo synch long waits	175	0.06	0.01
redo synch time	384,453	136.57	11.37
redo synch time (usec)	3,844,509,452	1,365,691.67	113,658.82
redo synch time overhead (usec)	2,794,622	992.74	82.62
redo synch time overhead count (<128 msec)	0	0.00	0.00
redo synch time overhead count (<2 msec)	32,736	11.63	0.97
redo synch time overhead count (<32 msec)	3	0.00	0.00
redo synch time overhead count (<8 msec)	4	0.00	0.00
redo synch time overhead count (>=128 msec)	3	0.00	0.00
redo synch writes	32,768	11.64	0.97
redo wastage	9,356,296	3,323.65	276.61
redo write broadcast ack count	21	0.01	0.00
redo write broadcast ack time	929	0.33	0.03
redo write info find	32,752	11.63	0.97
redo write info find fail	6	0.00	0.00
redo write time	100,386	35.66	2.97
redo writes	28,956	10.29	0.86
rollback changes - undo records applied	1,769	0.63	0.05
rollbacks only - consistent read gets	795	0.28	0.02
root node splits	7	0.00	0.00
rows fetched via callback	11,243,212	3,993.95	332.39
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	6,597,680	2,343.71	195.05
shared hash latch upgrades - wait	3,437	1.22	0.10
sorts (memory)	5,470,905	1,943.44	161.74
sorts (rows)	111,734,368	39,691.59	3,303.31
sql area evicted	304	0.11	0.01
sql area purged	304	0.11	0.01
summed dirty queue length	344,293	122.30	10.18
switch current to new buffer	40,375	14.34	1.19
table fetch by rowid	30,095,755,650	10,690,966.76	889,748.87
table fetch continued row	29	0.01	0.00
table scan blocks gotten	43,226,680	15,355.49	1,277.95
table scan rows gotten	3,167,658,294	1,125,252.67	93,648.43
table scans (short tables)	990,385	351.82	29.28
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	1,550	0.55	0.05
total number of cf enq holders	143	0.05	0.00
total number of times SMON posted	111	0.04	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	282	0.10	0.01
undo change vector size	166,888,172	59,283.97	4,933.87
user logons cumulative	319	0.11	0.01
user logouts cumulative	272	0.10	0.01
write clones created in background	0	0.00	0.00
write clones created in foreground	42	0.01	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	122	174
opened cursors current	507	1,199
session cursor cache count	164,932	199,744
session pga memory	419,196,032	708,548,128
session pga memory max	810,713,472	1,582,011,008
session uga memory	752,492,304	994,073,864
session uga memory max	15,629,066,376	18,400,708,920

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

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)
Buffer Cache Reads	28.5G	1325.89	10.361M	0M	0.00	0M	3732.1K	11.16
DBWR	0M	0.00	0M	1.5G	48.96	.558M	0
LGWR	0M	0.00	0M	957M	25.32	.34M	0
Others	136M	3.09	.048M	44M	0.99	.016M	8721	0.23
Direct Writes	0M	0.00	0M	2M	0.00	.001M	0
TOTAL:	28.6G	1328.97	10.409M	2.5G	75.27	.914M	3740.8K	11.14

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	28.5G	1325.93	10.361M	1.5G	48.97	.559M	11.16	256.00
Log File	0M	0.00	0M	956M	25.32	.34M
Control File	136M	3.08	.048M	43M	0.98	.015M	0.22
Other	0M	0.01	0M	0M	0.01	0M	2.11
Temp File	0M	0.00	0M	0M	0.00	0M	0.00
TOTAL:	28.6G	1329.02	10.409M	2.5G	75.27	.914M	11.13	256.00

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)
Buffer Cache Reads	28.5G	1325.89	10.361M	0M	0.00	0M	3732.1K	11.16
Buffer Cache Reads (Data File)	28.5G	1325.89	10.361M	0M	0.00	0M	3732.1K	11.16
DBWR	0M	0.00	0M	1.5G	48.96	.558M	0
DBWR (Data File)	0M	0.00	0M	1.5G	48.96	.558M	0
LGWR	0M	0.00	0M	956M	25.32	.34M	0
LGWR (Log File)	0M	0.00	0M	956M	25.32	.34M	0
Others	136M	3.08	.048M	44M	0.98	.016M	8673	0.22
Others (Control File)	136M	3.08	.048M	43M	0.98	.015M	8673	0.22
Others (Data File)	0M	0.00	0M	1M	0.00	0M	0
Direct Writes	0M	0.00	0M	2M	0.00	.001M	0
Direct Writes (Data File)	0M	0.00	0M	2M	0.00	.001M	0
TOTAL:	28.6G	1328.97	10.409M	2.5G	75.26	.914M	3740.8K	11.14

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)
DATA_MAN	3,620,455	1,286	11.44	1.00	20,940	1286.11	11	7	885	28.38
IDX_C	61,427	22	16.77	1.00	35,455	21.82	17	13	12	122.50
IDX_S	5,183	2	16.86	1.00	29,371	1.84	17	10	659	134.28
DATA_C	20,290	7	22.16	1.00	6,103	7.21	22	2	3	263.33
IDX_P	9,097	3	15.41	1.00	12,825	3.23	15	5	1,136	13.35
USERS	2,721	1	18.07	1.30	7,115	0.95	17	3	1,755	19.12
DATA_A	2,501	1	16.50	1.00	5,330	0.89	16	2	707	48.02
IDX_A	1,082	0	17.10	1.00	6,615	0.38	17	2	3,050	133.30
IDX_OUT	2,769	1	20.23	1.00	2,895	0.98	20	1	4	32.50
DATA_D	4,324	2	17.12	1.00	441	1.54	17	0	0	0.00
DATA_S	702	0	17.31	1.00	3,552	0.25	17	1	18	0.00
UNDOTBS1	19	0	5.79	1.00	2,757	0.01	6	1	161	0.06
DATA_P	885	0	13.67	1.11	1,359	0.31	14	0	4,686	4.19
SYSAUX	785	0	5.30	1.01	1,439	0.28	5	1	5	102.00
DATA_E	103	0	22.43	1.00	891	0.04	22	0	478	68.03
DATA_OUT	23	0	16.09	1.00	687	0.01	17	0	1	0.00
SYSTEM	55	0	17.09	1.00	62	0.02	17	0	0	0.00
DATA_G	76	0	23.55	1.00	0	0.03	23	0	0	0.00
DATA_R	14	0	21.43	1.00	0	0.00	21	0	0	0.00
TEMP	1	0	0.00	1.00	6	0.00	0	0	0	0.00
IDX_G	5	0	24.00	1.00	0	0.00	24	0	0	0.00
IDX_R	4	0	15.00	1.00	0	0.00	13	0	0	0.00
DATA_O	1	0	20.00	1.00	0	0.00	10	0	4	10.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)
DATA_A	/ora/yxdb/DATA_A.DBF	2,501	1	16.50	1.00	1	16.50	5,330	2	707	48.02
DATA_C	/ora/yxdb/DATA_C.DBF	20,290	7	22.16	1.00	7	22.16	6,103	2	3	263.33
DATA_D	/ora/yxdb/DATA_D.DBF	4,324	2	17.12	1.00	2	17.12	441	0	0	0.00
DATA_E	/ora/yxdb/DATA_E.DBF	103	0	22.43	1.00	0	22.43	891	0	478	68.03
DATA_G	/ora/yxdb/DATA_G.DBF	76	0	23.55	1.00	0	23.42	0	0	0	0.00
DATA_MAN	/ora/yxdb/DATA_MAN.DBF	3,620,455	1,286	11.44	1.00	1,286	11.44	20,940	7	885	28.38
DATA_O	/ora/yxdb/DATA_O.DBF	1	0	20.00	1.00	0	10.00	0	0	4	10.00
DATA_OUT	/ora/yxdb/DATA_OUT.DBF	23	0	16.09	1.00	0	16.52	687	0	1	0.00
DATA_P	/ora/yxdb/DATA_P.DBF	885	0	13.67	1.11	0	13.74	1,359	0	4,686	4.19
DATA_R	/ora/yxdb/DATA_R.DBF	14	0	21.43	1.00	0	21.43	0	0	0	0.00
DATA_S	/ora/yxdb/DATA_S.DBF	702	0	17.31	1.00	0	17.31	3,552	1	18	0.00
IDX_A	/ora/yxdb/IDX_A.DBF	1,082	0	17.10	1.00	0	17.10	6,615	2	3,050	133.30
IDX_C	/ora/yxdb/IDX_C.DBF	61,427	22	16.77	1.00	22	16.77	35,455	13	12	122.50
IDX_G	/ora/yxdb/IDX_G.DBF	5	0	24.00	1.00	0	24.00	0	0	0	0.00
IDX_OUT	/ora/yxdb/IDX_OUT.DBF	2,769	1	20.23	1.00	1	20.23	2,895	1	4	32.50
IDX_P	/ora/yxdb/IDX_P.DBF	9,097	3	15.41	1.00	3	15.41	12,825	5	1,136	13.35
IDX_R	/ora/yxdb/IDX_R.DBF	4	0	15.00	1.00	0	12.50	0	0	0	0.00
IDX_S	/ora/yxdb/IDX_S.DBF	5,183	2	16.86	1.00	2	16.86	29,371	10	659	134.28
SYSAUX	/ora/yxdb/sysaux01.dbf	785	0	5.30	1.01	0	5.28	1,439	1	5	102.00
SYSTEM	/ora/yxdb/system01.dbf	55	0	17.09	1.00	0	17.09	62	0	0	0.00
TEMP	/ora/yxdb/temp01.dbf	1	0	0.00	1.00	0	0.00	6	0	0
UNDOTBS1	/ora/yxdb/undotbs01.dbf	19	0	5.79	1.00	0	5.79	2,757	1	161	0.06
USERS	/ora/yxdb/users01.dbf	2,721	1	18.07	1.30	1	17.40	7,115	3	1,755	19.12

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	2,099,440	100	4,292,768,320	3,733,670	201,102	0	0	13,820

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 201,403

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	141,429	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	0	760	5298	6225	67947660	6225			0
E	0	18	21785	95628	628863	67947660	628863			6

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	1,792	0.10	210	1.42	19,267	1	327783.00
D	3,584	0.20	420	1.36	18,381	1	311795.00
D	5,376	0.30	630	1.31	17,704	1	299593.00
D	7,168	0.40	840	1.26	17,025	1	287344.00
D	8,960	0.50	1,050	1.21	16,354	1	275255.00
D	10,752	0.60	1,260	1.16	15,755	1	264454.00
D	12,544	0.70	1,470	1.12	15,205	1	254541.00
D	14,336	0.80	1,680	1.08	14,653	1	244587.00
D	16,128	0.90	1,889	1.04	14,083	1	234299.00
D	17,920	1.00	2,099	1.00	13,542	1	224549.00
D	19,712	1.10	2,309	0.96	13,043	1	215552.00
D	21,504	1.20	2,519	0.92	12,526	1	206223.00
D	23,296	1.30	2,729	0.89	12,057	1	197776.00
D	25,088	1.40	2,939	0.86	11,612	1	189749.00
D	26,880	1.50	3,149	0.83	11,177	1	181901.00
D	28,672	1.60	3,359	0.80	10,767	1	174516.00
D	30,464	1.70	3,569	0.77	10,368	1	167315.00
D	32,256	1.80	3,779	0.74	9,989	1	160489.00
D	34,048	1.90	3,989	0.71	9,615	1	153734.00
D	35,840	2.00	4,199	0.68	9,240	1	146982.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	877,536	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

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	5,760,400	5,760,400
64K	128K	9,016	9,016
128K	256K	59,856	59,856
256K	512K	400	400
512K	1024K	286,047	286,047
1M	2M	470,970	470,970
2M	4M	1,566	1,566
4M	8M	4,592	4,592
8M	16M	2,990	2,990

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 PGA Cache Hit %	Estd Time
3,568	0.13	10.26	100.00	997
7,136	0.25	10.26	100.00	997
14,272	0.50	10.26	100.00	997
21,408	0.75	10.26	100.00	997
28,544	1.00	10.26	100.00	997
34,253	1.20	10.26	100.00	997
39,962	1.40	10.26	100.00	997
45,670	1.60	10.26	100.00	997
51,379	1.80	10.26	100.00	997
57,088	2.00	10.26	100.00	997
85,632	3.00	10.26	100.00	997
114,176	4.00	10.26	100.00	997
171,264	6.00	10.26	100.00	997
228,352	8.00	10.26	100.00	997

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)
4,352	1.00	226	11,118	2,521,496	1.00	405	1.00	29,514
4,480	1.03	226	11,118	2,521,497	1.00	404	1.00	29,514
4,608	1.06	226	11,118	2,521,497	1.00	404	1.00	29,514
4,736	1.09	226	11,118	2,521,497	1.00	404	1.00	29,514
4,864	1.12	226	11,118	2,521,497	1.00	404	1.00	29,514
4,992	1.15	226	11,118	2,521,497	1.00	404	1.00	29,514
5,120	1.18	226	11,118	2,521,497	1.00	404	1.00	29,514
5,248	1.21	226	11,118	2,521,497	1.00	404	1.00	29,514
5,376	1.24	226	11,118	2,521,497	1.00	404	1.00	29,514
5,504	1.26	226	11,118	2,521,497	1.00	404	1.00	29,514
5,888	1.35	226	11,118	2,521,497	1.00	404	1.00	29,514
6,400	1.47	226	11,118	2,521,497	1.00	404	1.00	29,514
6,912	1.59	226	11,118	2,521,497	1.00	404	1.00	29,514
7,424	1.71	226	11,118	2,521,497	1.00	404	1.00	29,514
7,936	1.82	226	11,118	2,521,497	1.00	404	1.00	29,514
8,448	1.94	226	11,118	2,521,497	1.00	404	1.00	29,514
8,960	2.06	226	11,118	2,521,497	1.00	404	1.00	29,514

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
8,928	0.38	483,551	19,267,425
11,904	0.50	455,333	17,703,335
14,880	0.63	430,994	16,354,561
17,856	0.75	410,306	15,204,853
20,832	0.88	400,342	14,653,698
23,808	1.00	380,300	13,541,907
26,784	1.13	361,970	12,524,910
29,760	1.25	345,503	11,612,185
32,736	1.38	337,668	11,176,136
35,712	1.50	323,065	10,367,684
38,688	1.63	309,488	9,614,754
41,664	1.75	302,719	9,239,643
44,640	1.88	302,719	9,239,643
47,616	2.00	302,719	9,239,643

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)
128	1.00	0	0	0	0
256	2.00	0	0	0	0
384	3.00	0	0	0	0
512	4.00	0	0	0	0
640	5.00	0	0	0	0
768	6.00	0	0	0	0
896	7.00	0	0	0	0
1,024	8.00	0	0	0	0
1,152	9.00	0	0	0	0
1,280	10.00	0	0	0	0
1,408	11.00	0	0	0	0
1,536	12.00	0	0	0	0
1,664	13.00	0	0	0	0
1,792	14.00	0	0	0	0
1,920	15.00	0	0	0	0
2,048	16.00	0	0	0	0
2,176	17.00	0	0	0	0
2,304	18.00	0	0	0	0
2,432	19.00	0	0	0	0
2,560	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	13,297	658	49
undo header	210	2	10
undo block	192	2	11
segment header	47	0	5
2nd level bmb	4	0	23
1st level bmb	51	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)	1,200	1,200	0	1,188	18	14.95
PS-PX Process Reservation	2,323	2,323	0	349	3	9.63
TX-Transaction (row lock contention)	429	36	393	201	3	12.84
FB-Format Block	1,118	1,118	0	539	0	0.50
TM-DML	444,646	444,621	0	2	0	95.00
HW-Segment High Water Mark	26,567	26,563	0	188	0	0.53
CF-Controlfile Transaction	6,339	6,339	0	92	0	0.33
WF-AWR Flush	25	25	0	17	0	1.76
TX-Transaction (allocate ITL entry)	20	20	0	20	0	0.50
TD-KTF map table enqueue (KTF dump entries)	8	8	0	7	0	1.43
US-Undo Segment	99	99	0	20	0	0.00
TA-Instance Undo	16	16	0	13	0	0.00
TK-Auto Task Serialization (Auto Task Serialization)	4	4	0	4	0	0.00
PE-Parameter	24	24	0	1	0	0.00
PG-Global Parameter	6	6	0	1	0	0.00
DR-Distributed Recovery	1	1	0	1	0	0.00
MW-MWIN Schedule	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	19.91	31,007	921	22	15/28.4	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
31-Jan 13:28	5,529	8,717	921	22	28	0/0	0/0/0/0/0/0
31-Jan 13:18	5,192	8,079	318	16	18	0/0	0/0/0/0/0/0
31-Jan 13:08	5,426	8,630	20	21	15	0/0	0/0/0/0/0/0
31-Jan 12:58	3,767	5,581	326	16	18	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 deq log cmt cbk chunk latch	36	0.00		0	0
AQ deq log statistics latch	13	0.00		0	0
AQ dequeue txn counter latch	2,276	0.00		0	0
AQ ht cmt cbk chunk latch	26	0.00		0	0
ASM db client latch	2,600	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	45	0.00		0	0
AWR Alerted Metric Element list	29,482	0.00		0	0
Change Notification Hash table latch	939	0.00		0	0
Consistent RBA	28,954	0.00		0	0
DML lock allocation	6,624,994	0.00	0.00	0	0
Event Group Locks	1,030	0.00		0	0
FIB s.o chain latch	12	0.00		0	0
FOB s.o list latch	4,052	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	23	0.00		0	0
IPC stats buffer allocation latch	1,659	0.00		0	1,886	0.00
In memory undo latch	1	0.00		0	0
JS Sh mem access	1	0.00		0	0
JS queue access latch	1	0.00		0	0
JS slv state obj latch	1	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	149,196	0.10	0.03	0	6,936	0.14
KJCT flow control latch	1,287,558	0.05	0.01	0	0
KMG MMAN ready and startup request latch	938	0.00		0	0
KMG resize request state object freelist	4	0.00		0	0
KSXR large replies	188	0.00		0	0
KTF sga latch	24	0.00		0	937	0.00
KWQMN job cache list latch	591	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	35	0.00		0	0
KWQS pqueue ctx latch	1,426	0.00		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	55	0.00
Memory Management Latch	61	0.00		0	938	0.00
Memory Queue	1	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	1,935	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	1,364	0.00		0	0
OS process allocation	6,350	0.00		0	0
OS process: request allocation	640	0.00		0	0
PL/SQL warning settings	290,055	0.03	0.00	0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	9,965	0.00		0	0
SGA IO buffer pool latch	108	0.00		0	108	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	94	0.00		0	936	0.00
SQL memory manager workarea list latch	9,572,308	0.02	0.02	0	0
Shared B-Tree	2,498	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	1	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	159,990	0.10	0.01	0	0
active service list	15,064	0.00		0	1,594	0.00
begin backup scn array	14	0.00		0	0
buffer pool	5	0.00		0	0
business card	667	0.00		0	0
cache buffer handles	105,639	0.01	0.00	0	0
cache buffers chains	8,584,242,314	0.23	0.00	0	5,680,290	0.01
cache buffers lru chain	896,167	0.09	0.15	0	5,714,209	0.10
cache table scan latch	44	0.00		0	44	0.00
call allocation	101,982	0.50	0.00	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	707	0.00		0	0
channel operations parent latch	618,175	0.01	0.00	0	0
checkpoint queue latch	4,400,801	0.00	0.02	0	415,128	0.00
client/application info	4,983	0.00		0	0
compile environment latch	685	0.00		0	0
corrupted undo seg latch	5,589	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	45	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	45	0.00		0	0
dml lock allocation	45	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	1,315	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	233,251	0.01
enqueue hash chains	2,271,650	0.15	0.00	0	37	0.00
enqueues	153	0.00		0	0
error message lists	1,657	0.00		0	0
fifteenth spare latch - children	1	0.00		0	0
file cache latch	1,405	0.00		0	0
first Audit Vault latch	319	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	4,416,147	0.07	0.08	0	473,890	0.04
gcs commit scn state	1	0.00		0	0
gcs opaque info freelist	595,951	0.06	0.01	0	0
gcs partitioned table hash	10,476,699	0.00	0.00	0	3,622,748	0.00
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs remaster request queue	25,003	0.96	0.00	0	0
gcs resource freelist	265,123	0.02	0.04	0	0
gcs resource hash	6,306,256	0.02	0.02	0	312	0.00
gcs resource scan list	724	0.14	0.00	0	0
gcs resource validate list	1	0.00		0	0
gcs shadows freelist	163,988	0.02	0.00	0	0
ges caches resource lists	1,321,828	0.01	0.00	0	37,629	0.01
ges deadlock list	2,466	0.00		0	4	0.00
ges domain table	8,840,549	0.00	0.00	0	0
ges enqueue table freelist	8,851,755	0.02	0.01	0	0
ges group table	8,895,669	0.01	0.00	0	0
ges process hash list	3,365	0.00		0	0
ges process parent latch	17,741,586	0.00	0.78	0	0
ges process table freelist	640	0.00		0	0
ges resource hash list	17,329,507	0.11	0.01	0	385	1.04
ges resource scan list	139	0.00		0	0
ges resource table freelist	5,413	0.00		0	0
ges timeout list	1,512	0.00		0	313	0.00
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	319	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	77	0.00		0	787	0.00
hash table modification latch	170	0.00		0	0
heartbeat check	1	0.00		0	799	0.00
heartbeat structure management	0			0	563	0.00
interrupt manipulation	3,029	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	1	0.00		0	0
k2q global data latch	1,876	0.00		0	0
k2q lock allocation	1	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	14	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	951	0.00		0	0
ksim membership request latch	0			0	1,600	0.00
kss move lock	55	0.00		0	0
ksuosstats global area	393	0.00		0	0
ksv allocation latch	148	0.00		0	0
ksv class latch	5,241	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksxp shared latch	640	0.00		0	0
ksxp so latch	640	0.00		0	0
ksz_so allocation latch	640	0.00		0	0
ktm global data	456	0.00		0	0
kwqbsn:qsga	612	0.00		0	0
lgwr LWN SCN	29,016	0.02	0.00	0	0
list of block allocation	34,953	0.00		0	0
loader state object freelist	8	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	9	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	1	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	7,859	0.00		0	0
messages	620,804	0.11	0.00	0	0
mostly latch-free SCN	30,090	1.91	0.01	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	17,926	0.01	0.00	0	0
name-service memory objects	28,998	0.00		0	0
name-service namespace bucket	30,806	0.00		0	0
name-service pending queue	14,400	0.00		0	0
name-service request queue	49,223	0.00		0	0
ncodef allocation latch	45	0.00		0	0
nineth spare latch - X parent	1	0.00		0	0
object queue header heap	1,347,164	0.00	0.00	0	65,415	0.00
object queue header operation	16,914,004	0.15	0.00	0	0
object stats modification	548	0.00		0	0
parallel query alloc buffer	7,233	0.00		0	0
parallel query stats	1,337	0.00		0	0
parallel txn reco latch	2,832	0.00		0	0
parameter list	2,813	0.04	0.00	0	0
parameter table management	2,022	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	230,936	0.08	0.01	0	209,748	0.06
process allocation	14,316	0.01	1.00	0	346	0.00
process group creation	640	0.00		0	0
process queue	3,664	0.00		0	0
process queue reference	59,646	0.00	0.00	0	5,737	0.00
qmn state object latch	6	0.00		0	0
qmn task context latch	3	0.00		0	0
qmn task queue latch	422	0.24	0.00	0	0
query server freelists	2,998	0.00		0	0
query server process	329	0.00		0	0
queued dump request	10	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	95,034	0.84	0.02	0	1,636,226	0.27
redo copy	1	0.00		0	1,637,664	0.02
redo writing	255,715	0.05	0.02	0	0
resmgr group change latch	656	0.00		0	0
resmgr:active threads	1,351	0.00		0	0
resmgr:actses change group	684	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	1,314	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	37	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	30,904,688	0.86	0.02	1	0
rules engine aggregate statistics	7	0.00		0	0
rules engine rule set statistics	114	0.00		0	0
second Audit Vault latch	1	0.00		0	0
sequence cache	734,190	0.06	0.01	0	0
session allocation	20,357,985	0.03	0.01	0	20,356,450	0.03
session idle bit	110,363,920	0.02	0.03	0	0
session queue latch	1	0.00		0	0
session state list latch	1,661	0.00		0	0
session switching	340	0.00		0	0
session timer	938	0.00		0	0
seventh spare latch - X parent	1	0.00		0	0
shared pool	337,648	0.11	0.04	0	0
shared pool sim alloc	2	0.00		0	0
shared pool simulator	13	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	266,706,958	0.03	0.02	1	0
simulator lru latch	435	0.23	0.00	0	266,415,761	3.14
sixth spare latch - X parent	1	0.00		0	0
sort extent pool	150,101	0.47	0.00	0	0
space background state object latch	19	0.00		0	0
space background task latch	9,112	3.49	0.05	0	1,909	0.16
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
temporary table state object allocation	177	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	359	0.00		0	0
transaction allocation	1,607,852	0.00	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	357,507	0.03	0.01	0	0
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	29,036	0.08

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	8,584,242,314	20,117,208	3,011	20,122,818
row cache objects	30,904,688	265,105	4,453	260,712
simulator hash latch	266,706,958	89,625	1,791	87,850
object queue header operation	16,914,004	24,872	70	24,804
session idle bit	110,363,920	24,466	683	23,787
ges resource hash list	17,329,507	19,672	172	19,502
session allocation	20,357,985	6,344	43	6,302
enqueue hash chains	2,271,650	3,496	12	3,484
gc element	4,416,147	3,152	262	2,893
ges enqueue table freelist	8,851,755	1,943	10	1,933
SQL memory manager workarea list latch	9,572,308	1,928	29	1,900
gcs resource hash	6,306,256	1,372	33	1,339
ges group table	8,895,669	1,169	3	1,166
redo allocation	95,034	795	19	776
cache buffers lru chain	896,167	771	116	658
KJCT flow control latch	1,287,558	684	6	678
messages	620,804	659	2	658
mostly latch-free SCN	30,090	576	3	573
call allocation	101,982	513	1	512
sequence cache	734,190	417	3	414
gcs opaque info freelist	595,951	387	2	385
shared pool	337,648	386	14	372
space background task latch	9,112	318	17	301
post/wait queue	230,936	183	1	182
checkpoint queue latch	4,400,801	170	4	166
active checkpoint queue latch	159,990	152	1	151
KJC message pool free list	149,196	150	4	146
redo writing	255,715	126	3	123
undo global data	357,507	110	1	109
gcs resource freelist	265,123	51	2	49
ges process parent latch	17,741,586	9	7	2
process allocation	14,316	2	2	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
KJC message pool free list	kjcsmpav: allocate a msg buffer	3	4
KJC message pool free list	kjcspfmbq: free vector of msg buffers	1	0
KJCT flow control latch	kjcts_sqenq: queue a message	5	0
KJCT flow control latch	kjctcsnd: send normal message	1	1
SQL memory manager workarea list latch	qesmmIRegisterWorkArea:2	23	14
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	6	15
active checkpoint queue latch	kcbbacq: scan active checkpoints	1	1
cache buffers chains	kcbzwb	784	647
cache buffers chains	kcbgtcr: kslbegin shared	527	261
cache buffers chains	kcbgtcr: fast path	485	376
cache buffers chains	kcbchg1: mod cr pin	362	137
cache buffers chains	kcbgtcr: fast path (cr pin)	269	725
cache buffers chains	kcbgtcr_2	184	198
cache buffers chains	kcbget: fast exchange	178	143
cache buffers chains	kclcls_3	142	2
cache buffers chains	kcbchg1: clear MS bit	81	62
cache buffers chains	kcbzgb: scan from tail. nowait	73	0
cache buffers chains	kcbgcur_2	68	23
cache buffers chains	kcbgtcr: kslbegin excl	54	66
cache buffers chains	kcbget: pin buffer	35	34
cache buffers chains	kcbgtcr_1	35	42
cache buffers chains	kclwlr	34	20
cache buffers chains	kcbgcur: fast path (shr)	32	24
cache buffers chains	kcbrls_2	21	138
cache buffers chains	kclrqchk	15	6
cache buffers chains	kcbesc: escalate	14	4
cache buffers chains	kcbgcur_4	11	10
cache buffers chains	kcbget: exchange	11	38
cache buffers chains	kclbla	11	4
cache buffers chains	kcbget: fast path	10	20
cache buffers chains	kcbrls: fast release	6	204
cache buffers chains	kcbzib: finish processing buffer	5	9
cache buffers chains	kcbsod1	4	7
cache buffers chains	kclgrantlk	3	0
cache buffers chains	kcbbic1	2	0
cache buffers chains	kcbnlc	2	11
cache buffers chains	kcbso1: set no access	2	17
cache buffers chains	kcbzibmlt: multi-block read: nowait	2	0
cache buffers chains	kclcqchk	2	0
cache buffers chains	kcllkopesc	2	0
cache buffers chains	kcb_trim_hash_chain	1	0
cache buffers chains	kcbbxsv	1	0
cache buffers chains	kcbcge	1	79
cache buffers chains	kcbchg1: aux pin	1	0
cache buffers chains	kcbgkcbcr	1	15
cache buffers chains	kcbrls_1	1	1
cache buffers chains	kclcqchk_1	1	67
cache buffers chains	kclrlstp	1	8
cache buffers lru chain	kcbzgws	97	0
cache buffers lru chain	kcbzgb	11	51
cache buffers lru chain	kcbzgb_2	5	14
cache buffers lru chain	kcbo_link_q	2	0
cache buffers lru chain	kcbo_ivd_proc	1	5
call allocation	ksudlc : rec call	1	0
checkpoint queue latch	kcbkubc_4	2	2
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	1	30
checkpoint queue latch	kcbklbc_cql	1	0
enqueue hash chains	ksqgtl3	6	5
enqueue hash chains	ksqrcl	4	2
enqueue hash chains	ksqcmi: if lk mode requested	2	1
gc element	kclnfndnewm	261	22
gc element	kclbla	45	7
gc element	kclchkping	44	0
gc element	kclnfndx	6	23
gc element	kclfwrite1	4	8
gc element	kclulb	4	10
gc element	kclhngcbk1	2	0
gc element	KCLUNLNK	1	28
gc element	kclcqchk	1	40
gc element	kclrwrite	1	5
gcs opaque info freelist	kjbrinfofree free opaque info	2	0
gcs resource freelist	kjbralc add resource	2	1
gcs resource hash	kjbassume	8	3
gcs resource hash	kjbconvert	5	3
gcs resource hash	kjbcropen	5	2
gcs resource hash	kjblocalobj_nolock	4	5
gcs resource hash	kjbcrcomplete	3	0
gcs resource hash	kjbopen	3	0
gcs resource hash	kclfwrite1	2	0
gcs resource hash	kjbopen:affinity	2	2
gcs resource hash	kjbmpconvert	1	29
ges enqueue table freelist	kjlalc: lock allocation	5	5
ges enqueue table freelist	kjlfr: remove lock from parent object	5	5
ges group table	kjgdgll: move a lock from group lock list to process lock list	3	2
ges process parent latch	kjata_fg	7	0
ges resource hash list	kjlrlr: remove lock from resource queue	81	78
ges resource hash list	kjrmas1: lookup master node	63	6
ges resource hash list	kjakoca: search for resp by resname	21	29
ges resource hash list	kjrref: find matched resource	5	55
ges resource hash list	kjakcai: search for resp by resname	1	2
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	1	2
lgwr LWN SCN	kcs023	1	0
messages	ksaamb: after wakeup	2	0
mostly latch-free SCN	kcslcu3	2	3
object queue header operation	kcbo_unlink_q	70	4
object queue header operation	kcbo_ivbo	19	26
object queue header operation	kcbo_link_q	14	2
object queue header operation	kcbo_switch_q_bg	4	1
object queue header operation	kcbo_switch_cq	1	2
object queue header operation	kcbo_switch_mq_bg	1	5
post/wait queue	ksliwat:add:nowait	1	0
process allocation	ksucrp:1	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	19	0
redo writing	kcrfwcr	3	2
row cache objects	kqreqd: reget	3,108	29
row cache objects	kqreqd	819	205
row cache objects	kqrpre: find obj	524	4,219
row cache objects	kqrso	2	0
sequence cache	kdnnxt: cached seq	1	0
sequence cache	kdnss	1	3
sequence cache	kdnssd	1	0
session allocation	ksucri_int : SSO	20	13
session allocation	kspallmod	13	0
session allocation	ksuxds	10	30
session idle bit	ksupuc: set busy	474	211
session idle bit	ksupuc: clear busy	161	285
session idle bit	ksuxds	82	221
shared pool	kghalp	13	13
shared pool	kghalo	1	1
simulator hash latch	kcbsacc: lookup dba	1,790	1,789
simulator hash latch	kcbs_lookup_setid: lookup dba	1	1
space background task latch	ktsj_grab_task	16	17
space background task latch	ktsjCreateTask	1	0
undo global data	kturax	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Cursor Pin	kksfbc [KKSCHLFSP2]	3,684
Library Cache	kglpndl1 95	3,277
Library Cache	kglpnal2 91	2,017
Cursor Pin	kksLockDelete [KKSCHLPIN6]	1,345
Library Cache	kglpin1 4	747
Library Cache	kglpnal1 90	358
Library Cache	kglget1 1	114
Library Cache	kgllkdl1 85	50
Cursor Pin	kksfbc [KKSCHLPIN1]	49
Library Cache	kgllkal1 80	44
Cursor Pin	kkslce [KKSCHLPIN2]	20
Library Cache	kglhdgn2 106	15
Library Cache	kglobpn1 71	14
Library Cache	kgllkc1 57	4
Cursor Pin	kksxsccmp [KKSCHLPIN5]	2

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: 4,316,580,454
Captured Segments account for 99.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SGPM	DATA_P	P_USER_ROLE_RELA	TABLE	3,864,491,504	89.53
SGPM	IDX_P	FK_SP_ROLE_USER_ROLE	INDEX	129,695,456	3.00
SGPM	DATA_MAN	IDX_2013010303	INDEX	44,038,496	1.02
AMBER	DATA_P	INDY_USER_PROFILE	TABLE	41,095,904	0.95
AMBER	DATA_P	INDY_USER	TABLE	40,333,840	0.93

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.91	In-memory Sort %:	100.00
Library Hit %:	100.02	Soft Parse %:	99.99
Execute to Parse %:	87.72	Latch Hit %:	99.78
Parse CPU to Parse Elapsd %:	61.92	% Non-Parse CPU:	99.85

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SGPM	DATA_MAN	P_E_PL_ATMTE	TABLE	1,422,858	38.11
SGPM	DATA_MAN	P_E_PL_ATMTM	TABLE	1,422,724	38.11
SGPM	DATA_MAN	P_E_PL_ATMTM_IDX	INDEX	377,350	10.11
SGPM	DATA_MAN	P_E_PL_ATMTE_IDX	INDEX	377,200	10.10
SGPM	DATA_MAN	PK_A_PAY_FLOW_R01_RED	INDEX	16,467	0.44

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
SGPM	DATA_E	A_ACCT_BAL	P1240201	TABLE PARTITION	55,968	6.17
SGPM	DATA_A	A_PAY_FLOW	PMAX	TABLE PARTITION	35,120	3.87
SGPM	DATA_MAN	LOC_A_PAY_FLOW_LONG2		INDEX	31,120	3.43
SGPM	IDX_A	IDX_A_PREPAY_FLOW_R01_ACCT_NO1		INDEX	29,424	3.24
SGPM	IDX_A	IDX_A_PREPAY_FLOW_R0_CHARGE_I1		INDEX	28,336	3.12

Owner	Tablespace Name	Object Name	Obj. Type	ITL Waits	% of Capture
OWF_MGR	USERS	WF_ITEMS_N2	INDEX	8	44.44
SGPM	IDX_A	IDX_A_PREPAY_FLOW_R0_CHARGE_I1	INDEX	2	11.11
WF_AMBER	IDX_P	IDX_INSTANCES_BEGIN_DATE	INDEX	2	11.11
SGPM	IDX_S	IDX_S_APP_HANDLE_TIME	INDEX	2	11.11
WF_AMBER	IDX_P	IDX_USER_CUR_TASKID	INDEX	1	5.56

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SGPM	IDX_A	LOC_A_PAY_FLOW_ACNO	PMAX	INDEX PARTITION	383	26.90
SGPM	DATA_MAN	LOC_A_PAY_FLOW_LONG2		INDEX	221	15.52
SGPM	IDX_A	IDX_A_PREPAY_FLOW_CONS_NO1		INDEX	161	11.31
SGPM	DATA_MAN	PK_A_PREPAY_FLOW_R01_RED1		INDEX	97	6.81
SGPM	DATA_E	A_ACCT_BAL	P1240201	TABLE PARTITION	83	5.83

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	GC Buffer Busy	% of Capture
AMBER	DATA_P	NDX_INDY_USER_PROFILE		INDEX	1,694	20.10
SGPM	IDX_A	IDX_A_PREPAY_FLOW_CONS_NO1		INDEX	1,014	12.03
WF_AMBER	DATA_P	INDYWF_WORKLIST_CUR		TABLE	842	9.99
SGPM	IDX_A	LOC_A_PAY_FLOW_ACNO	PMAX	INDEX PARTITION	696	8.26
SGPM	DATA_A	A_INV_IO		TABLE	680	8.07

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	52	3.85	0	1
dc_global_oids	220,968	0.00	0	139
dc_histogram_data	235	0.00	0	3,435
dc_histogram_defs	162	0.00	0	8,379
dc_objects	220,652	0.00	0	4,671
dc_profiles	750	0.00	0	2
dc_rollback_segments	45,607	0.00	0	179
dc_segments	748	7.49	70	7,066
dc_sequences	181	55.80	181	16
dc_tablespaces	4,823,611	0.00	0	40
dc_users	4,986,437	0.00	0	95
global database name	3,762	0.00	0	1
outstanding_alerts	153	97.39	7	39

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	957	0.00	0		0	0
BODY	5,269	0.00	1,736,277	-0.00	0	0
CONTEXT POLICY	3,616	0.00	3,616	0.00	0	0
DBLINK	958	0.00	0		0	0
EDITION	331	0.00	650	0.00	0	0
QUEUE	424	0.00	1,569	0.00	0	0
RULESET	0		7	0.00	0	0
SCHEMA	320	0.00	0		0	0
SQL AREA	23,703	0.01	22,850,453	-0.02	306	304
SQL AREA BUILD	310	0.97	0		0	0
SQL AREA STATS	309	1.29	309	1.29	0	0
TABLE/PROCEDURE	80,452	0.00	2,111,362	0.00	1	0
TRIGGER	94	0.00	10,105	0.00	0	0

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
ACCOUNT_STATUS	957	0	0
BODY	0	1,682,474	1,682,474
CONTEXT POLICY	3,616	3,616	3,616
DBLINK	958	0	0
EDITION	331	331	331
QUEUE	220	1,569	1,569
RULESET	0	7	7
SCHEMA	319	0	0
TABLE/PROCEDURE	128,824	2,057,338	2,057,338
TRIGGER	0	10,094	10,094

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	17,664.00	17,920.00	16,256.00	17,920.00	0	GRO/MAN
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	28,800.00	28,544.00	28,544.00	29,440.00	2	SHR/MAN
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	23,552.00	23,808.00	22,912.00	23,808.00	2	GRO/DEF
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	128.00	128.00	128.00	768.00	0	SHR/DEF
large pool	896.00	896.00	896.00	1,280.00	0	SHR/DEF
shared pool	4,480.00	4,480.00	2,432.00	4,480.00	0	GRO/IMM
streams pool	128.00	128.00	128.00	256.00	0	SHR/DEF

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	17,792.00	17,920.00	17,856.00	2	2	0
PGA Target	28,544.00	28,672.00	28,608.00	2	0	2
SGA Target	23,680.00	23,808.00	23,744.00	2	2	0

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
01/31 13:37:35	0	pga	SHR/MAN	28,672	-128	28,544	COM
01/31 13:37:35	0	sga	GRO/DEF	23,680	128	23,808	COM
01/31 13:08:23	0	pga	SHR/MAN	28,800	-128	28,672	COM
01/31 13:08:22	1	sga	GRO/DEF	23,552	128	23,680	COM
01/31 09:58:53	11370	bufcache	GRO/MAN	17,024	768	17,792	COM
01/31 09:58:53	13122	bufcache	GRO/MAN	17,024	896	17,920	COM

	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	391.07		3.13	4.13	27	30	125	125
B	PL/SQL	51.06	20.89	0.42	1.05	5	13	123	123
B	Freeable	46.00	0.00	1.07	0.80	4		43	43
B	SQL	1.81	0.08	0.02	0.04	0	22	100	93
E	Other	581.95		3.29	3.65	26	29	177	177
E	PL/SQL	131.69	66.93	0.75	1.34	5	13	175	175
E	Freeable	85.38	0.00	0.97	0.69	4		88	88
E	SQL	23.76	0.18	0.16	0.24	1	22	152	145

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	18,522,046,464	18,790,481,920
Fixed Size	2,266,224
Redo Buffers	21,090,304
Variable Size	36,104,571,792	35,836,136,336

Pool	Name	Begin MB	End MB	% Diff
java	free memory	128.00	128.00	0.00
large	free memory	888.19	888.19	0.00
shared	ASH buffers	48.00	48.00	0.00
shared	KGLH0	74.53	74.61	0.10
shared	SQLA	150.44	150.79	0.23
shared	db_block_hash_buckets	178.00	178.00	0.00
shared	dbktb: trace buffer	46.88	46.88	0.00
shared	event statistics per sess	56.89	56.89	0.00
shared	free memory	2,301.96	2,291.90	-0.44
shared	gc name table	96.00	96.00	0.00
shared	gcs resources	503.91	503.91	0.00
shared	gcs shadows	348.86	348.86	0.00
shared	ges big msg buffers	54.17	54.17	0.00
shared	ges enqueues	61.99	62.15	0.26
shared	ksunfy : SSO free list	54.13	54.13	0.00
streams	free memory	128.00	128.00	0.00
	buffer_cache	17,664.00	17,920.00	1.45
	fixed_sga	2.16	2.16	0.00
	log_buffer	20.11	20.11	0.00

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0131 09:08:51	0.22	0.00	0.00
QMON Coordinator	0131 09:08:40	0.10	0.00	0.00

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(13069)	7	18	100.00	0.00	0.01	43.49	0.00	11.14
SYSMAN.MGMT_NOTIFY_Q(80815)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(80485)	0	0			0.00	0.00

Subscriber/Queue	Enqueue Msgs	Dequeue Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE	0	0
NARI62_3938_YXDB1(41)/SYS.ALERT_QUE	7	18	0.00	0.01	0.00
NARI65_3938_YXDB2(61)/SYS.ALERT_QUE	7	0	0.00	0.00	0.00

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/yxdb/adump
audit_trail	NONE
cluster_database	TRUE
compatible	11.2.0.4.0
control_files	/ora/yxdb/control01.ctl, /ora/fast_recovery_area/yxdb/control02.ctl
db_block_size	8192
db_domain
db_name	yxdb
db_recovery_file_dest	/ora/fast_recovery_area
db_recovery_file_dest_size	4621074432
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=yxdbXDB)
instance_number	1
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.52)(PORT=1521))
memory_target	54895050752
open_cursors	3000
plsql_warnings	DISABLE:ALL
processes	3000
remote_listener	nari-cluster-scan:1521
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan
session_cached_cursors	800
sessions	4536
spfile	/ora/yxdb/spfileyxdb.ora
thread	1
undo_tablespace	UNDOTBS1

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

Parameter Name	Begin value	End value (if different)
control_files	/ora/fast_recovery_area/yxdb/control02.ctl
control_files	/ora/yxdb/control01.ctl

	Per Second	Per Transaction
Global Cache blocks received:	122.02	10.15
Global Cache blocks served:	114.26	9.51
GCS/GES messages received:	270.42	22.51
GCS/GES messages sent:	269.03	22.39
DBWR Fusion writes:	15.32	1.28
Estd Interconnect traffic (KB)	1,995.54

Buffer access - local cache %:	99.91
Buffer access - remote cache %:	0.01
Buffer access - disk %:	0.09

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	5.7
Avg global cache current block receive time (ms):	3.7
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	6.7
Avg global cache cr block flush time (ms):	93.6
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 %:	2.4
Avg global cache current block flush time (ms):	137.8

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	1.6
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:	55.20
% of indirect sent messages:	43.58
% of flow controlled messages:	1.22

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	24,502	8.70	0.72
acks for commit broadcast(logical)	25,377	9.01	0.75
broadcast msgs on commit(actual)	23,648	8.40	0.70
broadcast msgs on commit(logical)	28,951	10.28	0.86
broadcast msgs on commit(wasted)	1,668	0.59	0.05
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	140,762	50.00	4.16
gcs ast xid	63	0.02	0.00
gcs blocked converts	270,184	95.98	7.99
gcs blocked cr converts	69,936	24.84	2.07
gcs compatible basts	1,216	0.43	0.04
gcs compatible cr basts (global)	7,530	2.67	0.22
gcs compatible cr basts (local)	27,595	9.80	0.82
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	41,677	14.80	1.23
gcs dbwr write request msgs	37,458	13.31	1.11
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	0	0.00	0.00
gcs force cr grant	0	0.00	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,293	3.66	0.30
gcs immediate (null) converts	91,507	32.51	2.71
gcs immediate cr (compatible) converts	12	0.00	0.00
gcs immediate cr (null) converts	70,190	24.93	2.08
gcs indirect ast	88,954	31.60	2.63
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	88,954	31.60	2.63
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	10,522	3.74	0.31
gcs msgs process time(ms)	32,509	11.55	0.96
gcs msgs received	748,170	265.77	22.12
gcs new served by master	16,620	5.90	0.49
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	171	0.06	0.01
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	110	0.04	0.00
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	49	0.02	0.00
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	18,526	6.58	0.55
gcs side channel msgs logical	418,239	148.57	12.36
gcs stale cr	0	0.00	0.00
gcs undo cr	1,789	0.64	0.05
gcs write notification msgs	1,904	0.68	0.06
gcs writes refused	258	0.09	0.01
ges msgs process time(ms)	340	0.12	0.01
ges msgs received	13,081	4.65	0.39
global posts dropped	0	0.00	0.00
global posts queue time	5	0.00	0.00
global posts queued	5	0.00	0.00
global posts requested	7	0.00	0.00
global posts sent	5	0.00	0.00
implicit batch messages received	43,324	15.39	1.28
implicit batch messages sent	44,908	15.95	1.33
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	8,715	3.10	0.26
messages queue sent actual	270,906	96.23	8.01
messages queue sent logical	103,833	36.88	3.07
messages received actual	696,020	247.25	20.58
messages received logical	761,251	270.42	22.51
messages sent directly	393,366	139.74	11.63
messages sent indirectly	310,587	110.33	9.18
messages sent not implicit batched	1	0.00	0.00
messages sent pbatched	75,460	26.81	2.23
msgs causing lmd to send msgs	6,559	2.33	0.19
msgs causing lms(s) to send msgs	23,829	8.46	0.70
msgs received queue time (ms)	8,469	3.01	0.25
msgs received queued	761,251	270.42	22.51
msgs sent queue time (ms)	13,343	4.74	0.39
msgs sent queue time on ksxp (ms)	1,067,434	379.19	31.56
msgs sent queued	329,412	117.02	9.74
msgs sent queued on ksxp	688,567	244.60	20.36
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	45,699	16.23	1.35
process batch messages sent	65,213	23.17	1.93

Statistic	Total
CR Block Requests	49,490
CURRENT Block Requests	10,316
Data Block Requests	49,490
Undo Block Requests	1,171
TX Block Requests	7,490
Current Results	57,522
Private results	1,767
Zero Results	516
Disk Read Results	0
Fail Results	0
Fairness Down Converts	12,701
Fairness Clears	944
Free GC Elements	0
Flushes	4,033
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	1,131
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	407	85.75	9.09	1.97	3.19	0.00
Flushes	6,344	5.94	32.36	25.22	35.58	0.90
Writes	43,138	37.30	55.54	5.13	1.41	0.61

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	52,789	92.16	6.07	1.78	275,179	95.72	2.51	1.78
2	undo header	8,463	95.42	3.45	1.13	231	95.67	3.46	0.87
2	Others	2,262	98.28	0.44	1.28	3,398	98.18	0.88	0.94
2	undo block	1,148	66.11	33.01	0.87	0

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	6.15	0.31	96.62	0.34	3.72	0.27	137.81	0.42
2	undo header	3.40	0.21	92.85	0.23	6.84	0.24	190.66	0.19
2	others	1.14	0.20	213.34	0.24	0.23	0.21	3.35	0.22
2	undo block	13.70	0.22	41.06	0.23