WORKLOAD REPOSITORY REPORT (RAC)

Database Summary

Database				Snapshot Ids		Number of Instances		Number of Hosts		Report Total (minutes)
Id	Name	RAC	Block Size	Begin	End	In Report	Total	In Report	Total	DB time	Elapsed time
3349992778	YXDB	YES	8192	24	25	2	2	2	2	2,642.33	46.99

Database Instances Included In Report

Listed in order of instance number, I#

I#	Instance	Host	Startup	Begin Snap Time	End Snap Time	Release	Elapsed Time(min)	DB time(min)	Up Time(hrs)	Avg Active Sessions	Platform
1	yxdb1	nari62	31-Jan-15 09:08	31-Jan-15 12:51	31-Jan-15 13:38	11.2.0.4.0	46.93	1,291.94	4.50	27.53	Linux x86 64-bit
2	yxdb2	nari65	31-Jan-15 09:08	31-Jan-15 12:51	31-Jan-15 13:38	11.2.0.4.0	46.92	1,350.39	4.50	28.78	Linux x86 64-bit

Report Summary

Cache Sizes

All values are in Megabytes
Listed in order of instance number, I#
End values displayed only if different from Begin values

I#	Begin	Begin	End	Begin	End	Begin	Begin	Begin	Begin	Begin	End	Log Buffer
	Memory Target	Sga Target		DB Cache		Shared Pool	Large Pool	Java Pool	Streams Pool	PGA Target
1	52,352	23,552	23,808	17,664	17,920	4,480	896	128	128	28,800	28,544	19.41
2	52,352	31,744	31,872	25,728	25,856	4,736	896	128		20,608	20,480	19.41
Avg	52,352	27,648	27,840	21,696	21,888	4,608	896	128	128	24,704	24,512	19.41
Min	52,352	23,552	23,808	17,664	17,920	4,480	896	128	128	20,608	20,480	19.41
Max	52,352	31,744	31,872	25,728	25,856	4,736	896	128	128	28,800	28,544	19.41

Main Report

Report Summary
OS Statistics
Time Model Statistics
Wait Events Statistics
Global Activity Load Profile
Global Cache and Enqueue Statistics Summary
Global CR Served Stats
Global CURRENT Served Stats
Global Cache Transfer Stats
Interconnect Stats
SQL Statistics
Global Activity Statistics
I/O Statistics
Library Cache Statistics
Memory Statistics
Supplemental Information

OS Statistics By Instance

Listed in order of instance number, I#
End values are diplayed only if different from begin values

I#	Num CPUs	CPU Cores	CPU Sckts	Load Begin	Load End	% Busy	% Usr	% Sys	% WIO	% Idl	Busy Time (s)	Idle Time (s)	Total Time (s)	Memory (M)
1	24	12	2	2.60	8.57	46.91	39.43	6.77	0.01	53.09	31,532.31	35,685.68	67,217.99	64,402.75
2	24	12	2	1.45	7.86	53.71	49.89	2.97	0.01	46.29	36,105.31	31,118.17	67,223.48	64,402.75
Sum											67,637.62	66,803.85	134,441.47

Time Model

I#	DB time (s)	DB CPU (s)	SQL Exec Ela (s)	Parse Ela (s)	Hard Parse Ela (s)	PL/SQL Ela (s)	bg time (s)	bg CPU (s)
1	77,516.14	27,786.84	71,959.90	82.75	0.42	401.32	2,153.67	218.63
2	81,023.49	35,151.19	74,329.47	102.11	0.49	493.07	2,361.92	226.00
Sum	158,539.63	62,938.03	146,289.37	184.86	0.91	894.40	4,515.59	444.63
Avg	79,269.81	31,469.02	73,144.69	92.43	0.45	447.20	2,257.80	222.32
Std	2,480.07	5,207.38	1,675.53	13.69	0.05	64.88	147.25	5.21

Back to Time Model Statistics
Back to Top

Time Model - % of DB time

% Total [DB time/bg time] - instance [DB time/bg time] as a percentage of the cluster-wide total [DB time/bg time]

I#	% Total DB time	DB CPU %DB time	SQL Exec Ela %DB time	Parse Ela %DB time	% Total bg time	bg CPU %bg time
1	48.89	35.85	92.83	0.11	47.69	10.15
2	51.11	43.38	91.74	0.13	52.31	9.57
Avg	50.00	39.62	92.29	0.12	50.00	9.86

Back to Time Model Statistics
Back to Top

Wait Events Statistics

Foreground Wait Classes - % of Total DB time
Foreground Wait Classes
Foreground Wait Classes - % of DB time
Top Timed Events
Top Timed Foreground Events
Top Timed Background Events

Foreground Wait Classes - % of Total DB time

Cluster-wide totals of wait class foreground wait times as a percentage of the cluster-wide DB time

	User I/O	Sys I/O	Other	Applic	Commit	Network	Concurcy	Config	Cluster	DB CPU
	51.49	0.00	0.01	0.00	5.38	0.06	0.00	0.05	3.21	39.70

Back to Wait Events Statistics
Back to Top

Foreground Wait Classes

I#	User I/O(s)	Sys I/O(s)	Other(s)	Applic (s)	Commit (s)	Network (s)	Concurcy (s)	Config (s)	Cluster (s)	DB CPU (s)	DB time
1	43,399.34	0.81	5.58	2.52	3,843.98	42.86	0.10	37.51	2,401.45	27,786.84	77,516.14
2	38,234.37	0.19	3.58	2.44	4,679.00	57.38	0.12	44.27	2,691.16	35,151.19	81,023.49
Sum	81,633.72	1.00	9.17	4.95	8,522.98	100.24	0.22	81.78	5,092.61	62,938.03	158,539.63
Avg	40,816.86	0.50	4.58	2.48	4,261.49	50.12	0.11	40.89	2,546.31	31,469.02	79,269.81
Std	3,652.18	0.44	1.41	0.06	590.45	10.27	0.01	4.78	204.86	5,207.38	2,480.07

Back to Wait Events Statistics
Back to Top

Foreground Wait Classes - % of DB time

% of Total DB time - instance DB time as a percentage of the cluster-wide total DB time

I#	User I/O	Other	Commit	Network	Config	Cluster	DB CPU	% Total DB time
1	55.99	0.01	4.96	0.06	0.05	3.10	35.85	48.89
2	47.19	0.00	5.77	0.07	0.05	3.32	43.38	51.11
Avg	51.59	0.01	5.37	0.06	0.05	3.21	39.62

Back to Wait Events Statistics
Back to Top

Top Timed Events

Instance '*' - cluster wide summary
'*' Waits, %Timeouts, Wait Time Total(s) : Cluster-wide total for the wait event
'*' 'Wait Time Avg (ms)' : Cluster-wide average computed as (Wait Time Total / Event Waits) in ms
'*' Summary 'Avg Wait Time (ms)' : Per-instance 'Wait Time Avg (ms)' used to compute the following statistics
'*' [Avg/Min/Max/Std Dev] : average/minimum/maximum/standard deviation of per-instance 'Wait Time Avg(ms)'
'*' Cnt : count of instances with wait times for the event

I#	Class	Event	Waits	%Timeouts	Total(s)	Avg(ms)	%DB time	Avg	Min	Max	Std Dev	Cnt
	Wait		Event		Wait Time			Summary Avg Wait Time (ms)
*	User I/O	db file sequential read	7,197,787	0.00	81,595.30	11.34	51.47	11.33	11.03	11.62	0.42	2
*		DB CPU			62,938.03		39.70					2
*	Commit	log file sync	70,583	0.00	8,524.82	120.78	5.38	120.58	118.04	123.12	3.59	2
*	System I/O	log file parallel write	60,001	0.00	2,083.95	34.73	1.31	34.72	34.45	35.00	0.39	2
*	Cluster	gc current block busy	13,349	0.00	1,844.81	138.20	1.16	138.19	132.59	143.78	7.91	2
*	Other	gcs log flush sync	202,360	9.27	1,563.88	7.73	0.99	7.73	7.60	7.86	0.18	2
*	Cluster	gc buffer busy acquire	19,482	0.01	1,143.91	58.72	0.72	58.40	54.17	62.63	5.98	2
*	Cluster	gc buffer busy release	5,507	0.53	1,142.48	207.46	0.72	206.60	198.89	214.32	10.91	2
*	Cluster	gc cr block busy	7,373	0.00	703.75	95.45	0.44	95.41	93.57	97.25	2.60	2
*	System I/O	db file parallel write	303,597	0.00	469.17	1.55	0.30	1.53	1.41	1.65	0.17	2
1	User I/O	db file sequential read	3,732,720	0.00	43,386.50	11.62	55.97
1		DB CPU			27,786.84		35.85
1	Commit	log file sync	32,564	0.00	3,844.00	118.04	4.96
1	System I/O	log file parallel write	28,947	0.00	997.16	34.45	1.29
1	Cluster	gc current block busy	6,690	0.00	961.87	143.78	1.24
1	Other	gcs log flush sync	101,830	8.89	773.75	7.60	1.00
1	Cluster	gc buffer busy acquire	9,012	0.00	488.22	54.17	0.63
1	Cluster	gc buffer busy release	2,448	0.04	486.88	198.89	0.63
1	Cluster	gc cr block busy	3,613	0.00	338.08	93.57	0.44
1	System I/O	db file parallel write	130,761	0.00	184.13	1.41	0.24
2	User I/O	db file sequential read	3,465,067	0.00	38,208.79	11.03	47.16
2		DB CPU			35,151.19		43.38
2	Commit	log file sync	38,019	0.00	4,680.82	123.12	5.78
2	System I/O	log file parallel write	31,054	0.00	1,086.79	35.00	1.34
2	Cluster	gc current block busy	6,659	0.00	882.94	132.59	1.09
2	Other	gcs log flush sync	100,530	9.66	790.13	7.86	0.98
2	Cluster	gc buffer busy acquire	10,470	0.02	655.69	62.63	0.81
2	Cluster	gc buffer busy release	3,059	0.92	655.59	214.32	0.81
2	Cluster	gc cr block busy	3,760	0.00	365.67	97.25	0.45
2	System I/O	db file parallel write	172,836	0.00	285.04	1.65	0.35

Back to Wait Events Statistics
Back to Top

Top Timed Foreground Events

Foreground Activity is captured in release 11g and above
For prior releases, Foreground Activity is computed as difference between Total Activty and Background Activity
Instance '*' - cluster wide summary
'*' Waits, %Timeouts, Wait Time Total(s) : Cluster-wide total for the wait event
'*' 'Wait Time Avg (ms)' : Cluster-wide average computed as (Wait Time Total / Event Waits) in ms
'*' Summary 'Avg Wait Time (ms)' : Per-instance 'Wait Time Avg (ms)' used to compute the following statistics
'*' [Avg/Min/Max/Std Dev] : average/minimum/maximum/standard deviation of per-instance 'Wait Time Avg(ms)'
'*' Cnt : count of instances with wait times for the event

I#	Class	Event	Waits	%Timeouts	Total(s)	Avg(ms)	%DB time	Avg	Min	Max	Std Dev	Cnt
	Wait		Event		Wait Time			Summary Avg Wait Time (ms)
*	User I/O	db file sequential read	7,197,193	0.00	81,592.66	11.34	51.47	11.33	11.03	11.62	0.42	2
*		DB CPU			62,938.03		39.70					2
*	Commit	log file sync	70,577	0.00	8,522.98	120.76	5.38	120.57	118.05	123.08	3.56	2
*	Cluster	gc current block busy	13,330	0.00	1,844.69	138.39	1.16	138.38	132.59	144.17	8.18	2
*	Cluster	gc buffer busy acquire	19,481	0.01	1,143.87	58.72	0.72	58.40	54.18	62.63	5.98	2
*	Cluster	gc buffer busy release	5,504	0.53	1,142.46	207.57	0.72	206.72	199.13	214.32	10.74	2
*	Cluster	gc cr block busy	7,340	0.00	701.41	95.56	0.44	95.52	93.78	97.25	2.46	2
*	Cluster	gc current block 2-way	513,125	0.00	137.99	0.27	0.09	0.27	0.26	0.28	0.01	2
*	Network	SQL*Net message to client	91,968,370	0.00	81.45	0.00	0.05	0.00	0.00	0.00	0.00	2
*	Concurrency	enq: TX - index contention	2,368	0.00	38.77	16.37	0.02	16.38	14.75	18.00	2.30	2
1	User I/O	db file sequential read	3,732,212	0.00	43,385.67	11.62	55.97
1		DB CPU			27,786.84		35.85
1	Commit	log file sync	32,562	0.00	3,843.98	118.05	4.96
1	Cluster	gc current block busy	6,671	0.00	961.75	144.17	1.24
1	Cluster	gc buffer busy acquire	9,011	0.00	488.18	54.18	0.63
1	Cluster	gc buffer busy release	2,445	0.04	486.86	199.13	0.63
1	Cluster	gc cr block busy	3,580	0.00	335.74	93.78	0.43
1	Cluster	gc current block 2-way	264,055	0.00	69.42	0.26	0.09
1	Network	SQL*Net message to client	43,244,308	0.00	37.35	0.00	0.05
1	Concurrency	enq: TX - index contention	1,188	0.00	17.52	14.75	0.02
2	User I/O	db file sequential read	3,464,981	0.00	38,206.99	11.03	47.16
2		DB CPU			35,151.19		43.38
2	Commit	log file sync	38,015	0.00	4,679.00	123.08	5.77
2	Cluster	gc current block busy	6,659	0.00	882.94	132.59	1.09
2	Cluster	gc buffer busy acquire	10,470	0.02	655.69	62.63	0.81
2	Cluster	gc buffer busy release	3,059	0.92	655.59	214.32	0.81
2	Cluster	gc cr block busy	3,760	0.00	365.67	97.25	0.45
2	Cluster	gc current block 2-way	249,070	0.00	68.57	0.28	0.08
2	Network	SQL*Net message to client	48,724,062	0.00	44.10	0.00	0.05
2	User I/O	read by other session	2,353	0.00	26.53	11.27	0.03

Back to Wait Events Statistics
Back to Top

Top Timed Background Events

% of bg time: % of background elapsed time
Instance '*' - cluster wide summary
'*' Waits, %Timeouts, Wait Time Total(s) : Cluster-wide total for the wait event
'*' 'Wait Time Avg (ms)' : Cluster-wide average computed as (Wait Time Total / Event Waits) in ms
'*' Summary 'Avg Wait Time (ms)' : Per-instance 'Wait Time Avg (ms)' used to compute the following statistics
'*' [Avg/Min/Max/Std Dev] : average/minimum/maximum/standard deviation of per-instance 'Wait Time Avg(ms)'
'*' Cnt : count of instances with wait times for the event

I#	Class	Event	Waits	%Timeouts	Total(s)	Avg(ms)	%DB time	Avg	Min	Max	Std Dev	Cnt
	Wait		Event		Wait Time			Summary Avg Wait Time (ms)
*	System I/O	log file parallel write	60,002	0.00	2,083.94	34.73	46.15	34.72	34.45	35.00	0.39	2
*	Other	gcs log flush sync	202,361	9.27	1,563.89	7.73	34.63	7.73	7.60	7.86	0.18	2
*	System I/O	db file parallel write	303,597	0.00	469.17	1.55	10.39	1.53	1.41	1.65	0.17	2
*		background cpu time			444.63		9.85					2
*	Other	Streams AQ: qmn coordinator waiting for slave to start	5	100.00	29.71	5941.47	0.66	5998.43	5713.65	6283.20	402.73	2
*	System I/O	db file async I/O submit	244,731	0.00	23.64	0.10	0.52	0.10	0.09	0.10	0.01	2
*	System I/O	control file parallel write	2,676	0.00	6.19	2.31	0.14	2.31	2.24	2.38	0.10	2
*	System I/O	control file sequential read	14,968	0.00	5.05	0.34	0.11	0.34	0.30	0.38	0.05	2
*	User I/O	db file sequential read	594	0.00	2.65	4.46	0.06	11.33	1.66	20.99	13.67	2
*	Cluster	gc cr block busy	32	0.00	2.34	73.05	0.05	73.05	73.05	73.05		2
1	System I/O	log file parallel write	28,948	0.00	997.16	34.45	46.30
1	Other	gcs log flush sync	101,830	8.89	773.76	7.60	35.93
1		background cpu time			218.63		10.15
1	System I/O	db file parallel write	130,761	0.00	184.13	1.41	8.55
1	Other	Streams AQ: qmn coordinator waiting for slave to start	3	100.00	17.14	5713.65	0.80
1	System I/O	db file async I/O submit	102,973	0.00	10.78	0.10	0.50
1	System I/O	control file parallel write	1,368	0.00	3.07	2.24	0.14
1	Cluster	gc cr block busy	32	0.00	2.34	73.05	0.11
1	System I/O	control file sequential read	7,758	0.00	2.34	0.30	0.11
1	User I/O	db file sequential read	508	0.00	0.84	1.66	0.04
2	System I/O	log file parallel write	31,054	0.00	1,086.78	35.00	46.01
2	Other	gcs log flush sync	100,531	9.66	790.13	7.86	33.45
2	System I/O	db file parallel write	172,836	0.00	285.04	1.65	12.07
2		background cpu time			226.00		9.57
2	System I/O	db file async I/O submit	141,758	0.00	12.87	0.09	0.54
2	Other	Streams AQ: qmn coordinator waiting for slave to start	2	100.00	12.57	6283.20	0.53
2	System I/O	control file parallel write	1,308	0.00	3.12	2.38	0.13
2	System I/O	control file sequential read	7,210	0.00	2.71	0.38	0.11
2	Commit	log file sync	4	0.00	1.82	454.16	0.08
2	User I/O	db file sequential read	86	0.00	1.81	20.99	0.08

Back to Wait Events Statistics
Back to Top

Global Activity Load Profile

System Statistics
System Statistics - Per Second
System Statistics - Per Transaction
SysStat and Global Messaging - RAC
SysStat and Global Messaging (per Sec)- RAC
SysStat and Global Messaging (per Tx)- RAC

System Statistics

I#	Logical Reads	Physical Reads	Physical Writes	Redo Size (k)	Block Changes	User Calls	Execs	Parses	Logons	Txns
1	4,316,580,454	3,733,672	201,403	464,626	2,915,246	45,004,293	22,571,255	2,771,057	683	33,825
2	5,139,590,195	3,465,644	248,612	526,857	3,368,266	50,797,615	26,092,461	3,261,339	634	39,506
Sum	9,456,170,649	7,199,316	450,015	991,483	6,283,512	95,801,908	48,663,716	6,032,396	1,317	73,331
Avg	4,728,085,325	3,599,658	225,008	495,742	3,141,756	47,900,954	24,331,858	3,016,198	659	36,666
Std	581,955,769	189,524	33,382	44,004	320,334	4,096,497	2,489,869	346,682	35	4,017

Back to Global Activity Load Profile
Back to Top

System Statistics - Per Second

I#	Logical Reads/s	Physical Reads/s	Physical Writes/s	Redo Size (k)/s	Block Changes/s	User Calls/s	Execs/s	Parses/s	Logons/s	Txns/s
1	1,533,386.26	1,326.32	71.54	165.05	1,035.59	15,986.95	8,018.03	984.37	0.24	12.02
2	1,825,703.91	1,231.08	88.31	187.15	1,196.49	18,044.51	9,268.66	1,158.50	0.23	14.03
Sum	3,359,090.17	2,557.40	159.86	352.20	2,232.08	34,031.47	17,286.68	2,142.87	0.47	26.05
Avg	1,679,545.08	1,278.70	79.93	176.10	1,116.04	17,015.73	8,643.34	1,071.44	0.23	13.02
Std	206,699.79	67.34	11.86	15.63	113.77	1,454.92	884.33	123.13	0.01	1.43

Back to Global Activity Load Profile
Back to Top

System Statistics - Per Transaction

I#	Logical Reads/tx	Physical Reads/tx	Physical Writes/tx	Redo Size (k)/tx	Block Changes/tx	User Calls/tx	Execs/tx	Parses/tx	Logons/tx
1	127,615.09	110.38	5.95	13.74	86.19	1,330.50	667.30	81.92	0.02
2	130,096.45	87.72	6.29	13.34	85.26	1,285.82	660.47	82.55	0.02
Avg	128,855.77	99.05	6.12	13.54	85.72	1,308.16	663.88	82.24	0.02

Back to Global Activity Load Profile
Back to Top

SysStat and Global Messaging - RAC

I#	GC Current	GC CR	GC Current	GC CR	GC	IPC	GCS Received	GES Received	GCS Sent	GES Sent	Sent Direct	Sent Indir	Lost	Failure
	Blocks Received		Blocks Served		CPU (seconds)		Messages						GC Blks	GC CR
1	278,822	64,662	261,833	59,805	0	0	748,170	13,081	744,240	13,094	393,366	310,587	0	0
2	261,833	59,805	278,824	64,662	0	0	744,243	13,100	748,159	13,077	400,679	310,270	0	1
Sum	540,655	124,467	540,657	124,467	0	0	1,492,413	26,181	1,492,399	26,171	794,045	620,857	0	1
Avg	270,328	62,234	270,329	62,234	0	0	746,207	13,091	746,200	13,086	397,023	310,429	0	1
Std	12,013	3,434	12,014	3,434	0	0	2,777	13	2,771	12	5,171	224	0	1

Back to Global Activity Load Profile
Back to Top

SysStat and Global Messaging (per Sec)- RAC

I#	GC Current	GC CR	GC Current	GC CR	GC	IPC	GCS Received	GES Received	GCS Sent	GES Sent	Sent Direct	Sent Indir	Lost/s	Fail/s
	Blocks Received Per Second		Blocks Served per Second		CPU seconds per Second		Messages Per Second						GC Blks	GC CR
1	99.05	22.97	93.01	21.24	0.00	0.00	265.77	4.65	264.38	4.65	139.74	110.33	0	0
2	93.01	21.24	99.04	22.97	0.00	0.00	264.37	4.65	265.76	4.65	142.33	110.22	0	0
Sum	192.06	44.21	192.06	44.21	0.00	0.00	530.15	9.30	530.14	9.30	282.07	220.55	0	0
Avg	96.03	22.11	96.03	22.11	0.00	0.00	265.07	4.65	265.07	4.65	141.03	110.27	0	0
Std	4.27	1.22	4.27	1.22	0.00	0.00	0.99	0.00	0.98	0.00	1.83	0.08	0	0

Back to Global Activity Load Profile
Back to Top

SysStat and Global Messaging (per Tx)- RAC

I#	GC Current	GC CR	GC Current	GC CR	GC	IPC	GCS Received	GES Received	GCS Sent	GES Sent	Sent Direct	Sent Indir	Lost/Tx	Fail/Tx
	Blocks Received per Tx		Blocks Served		CPU (seconds) per Tx		Messages per Transaction						GC Blks	GC CR
1	8.24	1.91	7.74	1.77	0.00	0.00	22.12	0.39	22.00	0.39	11.63	9.18	0.00	0.00
2	6.63	1.51	7.06	1.64	0.00	0.00	18.84	0.33	18.94	0.33	10.14	7.85	0.00	0.00
Avg	7.44	1.71	7.40	1.70	0.00	0.00	20.48	0.36	20.47	0.36	10.89	8.52	0.00	0.00

Back to Global Activity Load Profile
Back to Top

Global Cache and Enqueue Statistics Summary

Global Cache Efficiency Percentages
Global Cache and Enqueue Workload Characteristics
Global Cache and Enqueue Messaging Statistics

Global Cache Efficiency Percentages

I#	Local %	Remote %	Disk %
	Buffer Access
1	99.91	0.01	0.09
2	99.93	0.01	0.07

Back to Global Cache and Enqueue Statistics Summary
Back to Top

Global Cache and Enqueue Workload Characteristics

I#	GE Get Time (ms)	Receive Time (ms)	Build Time (ms)	Send Time (ms)	Flush Time (ms)	Log Flush CR Srvd %	Receive Time (ms)	Pin Time (ms)	Send Time (ms)	Flush Time (ms)	Log Flush CU Srvd %
		CR Blocks					CU Blocks
1	0.02	5.74	0.00	0.00	93.57	6.74	3.72	0.01	0.00	137.76	2.42
2	0.02	6.59	0.00	0.00	90.86	6.00	4.62	0.03	0.00	145.96	2.33

Back to Global Cache and Enqueue Statistics Summary
Back to Top

Global Cache and Enqueue Messaging Statistics

I#	Sent	on ksxp	Received	GCS msgs	GES msgs	Direct	Indirect	Flow Ctrl
	Queue Time (ms)			Process Time		% Messages Sent
1	0.04	1.55	0.01	0.04	0.03	55.20	43.58	1.22
2	0.05	1.72	0.01	0.04	0.02	55.81	43.22	0.97

Back to Global Cache and Enqueue Statistics Summary
Back to Top

CR Blocks Served Statistics

I#	CR	CU	Data	Undo	TX	Current	Private	Zero	Dsk Rd	Fail	Down Conv	Clears	Elems	Total	Queued	QFull	MaxTm	Works	Errors
	Block Requests					Results					Fairness		FreeGC	Flushes				Light	Total
1	49,490	10,316	49,490	1,171	7,490	57,522	1,767	516	0	0	12,701	944	0	4,033	0	0	0	1,131	0
2	52,790	11,873	52,790	1,148	8,463	62,495	1,614	554	0	0	15,195	1,163	0	3,882	0	0	0	1,768	0
Sum	102,280	22,189	102,280	2,319	15,953	120,017	3,381	1,070	0	0	27,896	2,107	0	7,915	0	0	0	2,899	0
Avg	51,140	11,095	51,140	1,160	7,977	60,009	1,691	535	0	0	13,948	1,054	0	3,958	0	0	0	1,450	0
Std	2,333	1,101	2,333	16	688	3,516	108	27	0	0	1,764	155	0	107	0	0	0	450	0

Current Blocks Served Statistics

I#	Pins	% <1ms	% <10ms	% <100ms	% <1s	% <10s	Flushes	% <1ms	% <10ms	% <100ms	% <1s	% <10s	Writes	% <1ms	% <10ms	% <100ms	% <1s	% <10s
1	407	85.75	9.09	1.97	3.19	0.00	6,344	5.94	32.36	25.22	35.58	0.90	43,138	37.30	55.54	5.13	1.41	0.61
2	409	81.17	11.74	3.67	3.42	0.00	6,508	5.67	30.38	25.72	37.17	1.06	61,526	33.56	58.37	5.35	1.91	0.81
Sum	816						12,852						104,664
Avg	408						6,426						52,332
Std	1						116						13,002

Global Cache Transfer Stats

Global Cache Transfer Stats
Global Cache Transfer (Immediate)

Global Cache Transfer Stats

Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
Busy (Busy) - Block Transfer impacted by Remote Contention
Congested (Cngst) - Block Transfer impacted by Remote System Load
All - average time of All blocks (Immed,Busy,Cngst) in ms
Ordered by instance_number, CR + Current Blocks Received desc

Instance#		Block	CR Blocks				Current Blocks				CR Avg Time (ms)				Current Avg Time (ms)
Dest	Src	Class	Received	%Immed	%Busy	%Cngst	Received	%Immed	%Busy	%Cngst	All	Immed	Busy	Cngst	All	Immed	Busy	Cngst
1	2	data block	52,789	92.16	6.07	1.78	275,179	95.72	2.51	1.78	6	0.31	96.62	0.34	4	0.27	137.81	0.42
1	2	undo header	8,463	95.42	3.45	1.13	231	95.67	3.46	0.87	3	0.21	92.85	0.23	7	0.24	190.66	0.19
1	2	others	2,262	98.28	0.44	1.28	3,398	98.18	0.88	0.94	1	0.20	213.34	0.24	0	0.21	3.35	0.22
1	2	undo block	1,148	66.11	33.01	0.87	0				14	0.22	41.06	0.23
2	1	data block	49,488	91.37	6.81	1.81	259,098	95.54	2.86	1.60	7	0.30	98.15	0.34	5	0.28	153.07	0.31
2	1	undo header	7,489	94.63	4.03	1.34	211	93.36	4.74	1.90	5	0.22	107.04	0.25	14	0.24	282.81	0.91
2	1	others	1,649	99.03	0.06	0.91	2,484	97.95	1.13	0.93	0	0.20	7.06	0.20	0	0.20	7.22	0.22
2	1	undo block	1,171	68.32	30.57	1.11	0				13	0.24	43.52	0.21

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

Ordered by instance_number, CR + Current Blocks Received desc

Instance#		Block	Lost Blocks		Immediate CR Blocks			Immediate Current Blocks			Immed CR Avg Time (ms)			Immed Current Avg Time (ms)
Dest	Src	Class	Count	Time(ms)	Received	%2-hop	%3-hop	Received	%2-hop	%3-hop	Total	2-hop	3-hop	Total	2-hop	3-hop
1	2	data block	0		48,648	100.00	0.00	263,388	100.00	0.00	0.31	0.31		0.27	0.27
1	2	undo header	0		8,075	100.00	0.00	221	100.00	0.00	0.21	0.21		0.24	0.24
1	2	others	0		2,223	100.00	0.00	3,336	100.00	0.00	0.20	0.20		0.21	0.21
1	2	undo block	0		759	100.00	0.00	0			0.22	0.22
2	1	data block	0		45,219	100.00	0.00	247,532	100.00	0.00	0.30	0.30		0.28	0.28
2	1	undo header	0		7,087	100.00	0.00	197	100.00	0.00	0.22	0.22		0.24	0.24
2	1	others	0		1,633	100.00	0.00	2,433	100.00	0.00	0.20	0.20		0.20	0.20
2	1	undo block	0		800	100.00	0.00	0			0.24	0.24

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Cluster Interconnect
Ping Statistics
Interconnect Client Statistics
Interconnect Client Statistics (per Second)
Interconnect Device Statistics
Interconnect Device Statistics (per Second)
Dynamic Remastering Statistics - per Remaster Ops

Cluster Interconnect

I#	NAME	IP Address	Pub	IP Address
		Begin		End (if different from Begin)
1	eth2:1	169.254.146.197	N
2	eth2:1	169.254.222.45	N

Back to Interconnect Stats
Back to Top

Ping Statistics

Latency of the roundtrip of a message from Src Instance to the Target instances

Instance#		500 bytes				8 Kbytes
Src	Target	Ping Count	Ping Time(s)	Avg Time(ms)	Std Dev	Ping Count	Ping Time(s)	Avg Time(ms)	Std Dev
1	1	219	0.04	0.17	0.05	219	0.03	0.16	0.05
1	2	219	0.04	0.19	0.05	219	0.05	0.24	0.09
2	1	219	0.04	0.20	0.07	219	0.06	0.25	0.10
2	2	219	0.03	0.15	0.05	219	0.03	0.14	0.04

Back to Interconnect Stats
Back to Top

Interconnect Client Statistics

I#	Total	Cache	IPQ	DLM	PNG	Misc	Total	Cache	IPQ	DLM	PNG	Misc
	Sent (MB)						Received (MB)
1	2,253.13	1,970.00	3.55	212.18	3.67	63.72	2,464.69	2,112.71	5.88	211.76	3.67	130.66
2	2,464.71	2,112.75	5.88	211.74	3.67	130.66	2,252.99	1,969.90	3.55	212.14	3.67	63.72
Sum	4,717.84	4,082.76	9.43	423.92	7.35	194.38	4,717.68	4,082.61	9.43	423.90	7.35	194.38
Avg	2,358.92	2,041.38	4.72	211.96	3.67	97.19	2,358.84	2,041.31	4.72	211.95	3.67	97.19
Std	149.61	100.94	1.65	0.31	0.00	47.33	149.70	100.98	1.65	0.27	0.00	47.34

Back to Interconnect Stats
Back to Top

Interconnect Client Statistics (per Second)

I#	Total	Cache	IPQ	DLM	PNG	Misc	Total	Cache	IPQ	DLM	PNG	Misc
	Sent (MB/s)						Received (MB/s)
1	0.80	0.70	0.00	0.08	0.00	0.02	0.88	0.75	0.00	0.08	0.00	0.05
2	0.88	0.75	0.00	0.08	0.00	0.05	0.80	0.70	0.00	0.08	0.00	0.02
Sum	1.68	1.45	0.00	0.15	0.00	0.07	1.68	1.45	0.00	0.15	0.00	0.07
Avg	0.84	0.73	0.00	0.08	0.00	0.03	0.84	0.73	0.00	0.08	0.00	0.03
Std	0.05	0.04	0.00	0.00	0.00	0.02	0.05	0.04	0.00	0.00	0.00	0.02

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

Data is retrieved from underlying Operating system and may overflow on some 32-bit OSs
null means begin value > end value

I#	NAME	IP Address	IP Mask	MBytes	Packets	Errors	Packets Dropped	Buffer Ovrrun	Carrier Lost	MBytes	Packets	Errors	Packets Dropped	Buffer Ovrrun	Frame Errors
	Interface			Sent						Received
1	eth0	192.168.200.62	255.255.255.0	13,500.47	47,099,999	0	0	0	0	4,964.27	47,461,910	0	0	0	0
1	eth0:1	192.168.200.53	255.255.255.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
1	eth0:2	192.168.200.52	255.255.255.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
1	eth2	10.10.10.62	255.255.255.0	2,590.07	3,082,436	0	0	0	0	2,792.76	3,219,993	0	0	0	0
1	eth2:1	169.254.146.197	255.255.0.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
1	ib1	10.10.1.62	255.255.255.0	31.51	54,791	0	0	0	0	37.01	57,603	0	0	0	0
1	ib2	10.10.2.62	255.255.255.0	31.59	54,808	0	0	0	0	37.13	57,596	0	0	0	0
1	lo	127.0.0.1	255.0.0.0	48.18	190,552	0	0	0	0	48.18	190,552	0	0	0	0
2	eth0	192.168.200.65	255.255.255.0	13,469.48	51,895,757	0	0	0	0	5,542.41	52,164,953	0	0	0	0
2	eth0:1	192.168.200.55	255.255.255.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
2	eth2	10.10.10.65	255.255.255.0	2,791.94	3,219,677	0	0	0	0	2,589.73	3,081,966	0	0	0	0
2	eth2:1	169.254.222.45	255.255.0.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
2	ib1	10.10.1.65	255.255.255.0	37.23	58,140	0	0	0	0	31.30	54,791	0	0	0	0
2	ib2	10.10.2.65	255.255.255.0	37.36	58,140	0	0	0	0	31.38	54,801	0	0	0	0
2	lo	127.0.0.1	255.0.0.0	39.06	174,590	0	0	0	0	39.06	174,590	0	0	0	0
Sum				32,576.89	105,888,890	0	0	0	0	16,113.21	106,518,755	0	0	0	0
Avg				2,171.79	7,059,259	0	0	0	0	1,074.21	7,101,250	0	0	0	0
Std				4,686.24	17,287,546	0	0	0	0	1,937.75	17,397,342	0	0	0	0

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics (per Second)

Data is retrieved from underlying Operating system and may overflow on some 32-bit OSs
Blank means begin value > end value

I#	NAME	IP Address	IP Mask	MBytes	Packets	Errors	Packets Dropped	Buffer Ovrrun	Carrier Lost	MBytes	Packets	Errors	Packets Dropped	Buffer Ovrrun	Frame Errors
	Interface			Sent						Received
1	eth0	192.168.200.62	255.255.255.0	4.80	16,731	0	0	0	0	1.76	16,860	0	0	0	0
1	eth0:1	192.168.200.53	255.255.255.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
1	eth0:2	192.168.200.52	255.255.255.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
1	eth2	10.10.10.62	255.255.255.0	0.92	1,095	0	0	0	0	0.99	1,144	0	0	0	0
1	eth2:1	169.254.146.197	255.255.0.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
1	ib1	10.10.1.62	255.255.255.0	0.01	19	0	0	0	0	0.01	20	0	0	0	0
1	ib2	10.10.2.62	255.255.255.0	0.01	19	0	0	0	0	0.01	20	0	0	0	0
1	lo	127.0.0.1	255.0.0.0	0.02	68	0	0	0	0	0.02	68	0	0	0	0
2	eth0	192.168.200.65	255.255.255.0	4.78	18,435	0	0	0	0	1.97	18,530	0	0	0	0
2	eth0:1	192.168.200.55	255.255.255.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
2	eth2	10.10.10.65	255.255.255.0	0.99	1,144	0	0	0	0	0.92	1,095	0	0	0	0
2	eth2:1	169.254.222.45	255.255.0.0	0.00	0	0	0	0	0	0.00	0	0	0	0	0
2	ib1	10.10.1.65	255.255.255.0	0.01	21	0	0	0	0	0.01	19	0	0	0	0
2	ib2	10.10.2.65	255.255.255.0	0.01	21	0	0	0	0	0.01	19	0	0	0	0
2	lo	127.0.0.1	255.0.0.0	0.01	62	0	0	0	0	0.01	62	0	0	0	0
Sum				11.57	37,615	0	0	0	0	5.72	37,838	0	0	0	0
Avg				0.77	2,508	0	0	0	0	0.38	2,523	0	0	0	0
Std				1.66	6,141	0	0	0	0	0.69	6,180	0	0	0	0

Back to Interconnect Stats
Back to Top

Dynamic Remastering Statistics - per Remaster Ops

Affinity Obj - objects remastered due to affinity at begin/end snap

I#	Remaster Ops	Remastered Objects	Remaster	Begin	End
		Counts per Ops	Time per Ops (seconds)	Affinity Objects
1	0			32	32
2	0			1	1
Avg	0			17	17
Max				32	32

Back to Interconnect Stats
Back to Top

SQL Statistics

SQL ordered by Elapsed Time (Global)
SQL ordered by CPU Time (Global)
SQL ordered by User I/O Time (Global)
SQL ordered by Gets (Global)
SQL ordered by Reads (Global)
SQL ordered by UnOptimized Read Requests (Global)
SQL ordered by Executions (Global)
SQL ordered by Cluster Wait Time (Global)

SQL ordered by Elapsed Time (Global)

Captured SQL account for 89.7% of Total DB Time (s): 158,540
Captured PL/SQL account for 56.3% of Total DB Time (s): 158,540

SQL Id	Elapsed (s)	CPU (s)	IOWait (s)	Gets	Reads	Rows	Cluster (s)	Execs	Elapsed (s)	CPU (s)	IOWait (s)	Gets	Reads	Rows	Cluster (s)	DB time	DB CPU	IO Wait	Gets	Reads	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
9t6habqtx6vzg	75,773.50	2,468.04	73,690.44	55,703,118	6,680,888	386,966	0.99	386,962	0.20	0.01	0.19	143.95	17.26	1.00	0.00	47.79	3.92	0.90	0.59	92.80	0.02	0.80	begin pkg_ca_counter.p_ca_coun...
83p6uchsnm6n2	47,117.98	41,548.16	0.00	525,546,477	0	126,428,947	0.00	8,530,809	0.01	0.00	0.00	61.61	0.00	14.82	0.00	29.72	66.01	0.00	5.56	0.00	0.00	17.53	SELECT a.sys_user_name, a.org_...
86g6708pvuqtu	41,089.86	812.84	40,681.48	19,349,395	3,342,882	3,869,925	0.51	3,869,991	0.01	0.00	0.01	5.00	0.86	1.00	0.00	25.92	1.29	0.50	0.20	46.43	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
c98tw7kbymbru	33,450.62	896.76	33,046.36	19,349,658	3,342,163	3,869,983	0.49	3,870,056	0.01	0.00	0.01	5.00	0.86	1.00	0.00	21.10	1.42	0.40	0.20	46.42	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
07ttw6rma134k	6,286.59	554.97	2,234.57	13,680,890	157,883	55,267	3,445.36	55,264	0.11	0.01	0.04	247.56	2.86	1.00	0.06	3.97	0.88	0.03	0.14	2.19	67.61	0.11	begin pkg_ca_counter.p_ca_arra...
ctpdw3pywk3k9	5,633.98	5,527.21	0.00	222,396,865	0	63,990	6.60	63,990	0.09	0.09	0.00	3,475.49	0.00	1.00	0.00	3.55	8.78	0.00	2.35	0.00	0.13	0.13	begin pkg_ca_lookup.p_get_owec...
fb7paxp4m9wcg	2,668.91	67.89	17.27	784,710	1,252	54,424	2,573.97	54,425	0.05	0.00	0.00	14.42	0.02	1.00	0.05	1.68	0.11	0.00	0.01	0.02	50.51	0.11	INSERT INTO A_PREPAY_FLOW (PRE...
3d3k6bzs4nk3f	2,652.76	2,611.15	0.00	131,836,355	0	7,261,226	0.00	237,223	0.01	0.01	0.00	555.75	0.00	30.61	0.00	1.67	4.15	0.00	1.39	0.00	0.00	0.49	SELECT RCVBL_YM, ORG_NO, SUM(R...
42pxs62tawj10	2,556.95	2,526.13	0.00	89,343,341	0	7,667,739	6.60	237,225	0.01	0.01	0.00	376.62	0.00	32.32	0.00	1.61	4.01	0.00	0.94	0.00	0.13	0.49	SELECT RCVBL_YM, ORG_NO, SUM(R...
4bf7r12w7dg25	1,574.36	58.92	1,511.47	552,908	110,897	55,290	0.02	55,290	0.03	0.00	0.03	10.00	2.01	1.00	0.00	0.99	0.09	0.02	0.01	1.54	0.00	0.11	SELECT pkg_sp_seq.f_a_defid se...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time (Global)

Captured SQL account for 80.5% of Total CPU Time (s): 62,938
Captured PL/SQL account for 14.2% of Total CPU Time (s): 62,938

SQL Id	CPU (s)	Elapsed (s)	IOWait (s)	Gets	Reads	Rows	Cluster (s)	Execs	CPU (s)	Elapsed (s)	IOWait (s)	Gets	Reads	Rows	Cluster (s)	DB CPU	DB time	IO Wait	Gets	Reads	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
83p6uchsnm6n2	41,548.16	47,117.98	0.00	525,546,477	0	126,428,947	0.00	8,530,809	0.00	0.01	0.00	61.61	0.00	14.82	0.00	66.01	29.72	0.00	5.56	0.00	0.00	17.53	SELECT a.sys_user_name, a.org_...
ctpdw3pywk3k9	5,527.21	5,633.98	0.00	222,396,865	0	63,990	6.60	63,990	0.09	0.09	0.00	3,475.49	0.00	1.00	0.00	8.78	3.55	0.00	2.35	0.00	0.13	0.13	begin pkg_ca_lookup.p_get_owec...
3d3k6bzs4nk3f	2,611.15	2,652.76	0.00	131,836,355	0	7,261,226	0.00	237,223	0.01	0.01	0.00	555.75	0.00	30.61	0.00	4.15	1.67	0.00	1.39	0.00	0.00	0.49	SELECT RCVBL_YM, ORG_NO, SUM(R...
42pxs62tawj10	2,526.13	2,556.95	0.00	89,343,341	0	7,667,739	6.60	237,225	0.01	0.01	0.00	376.62	0.00	32.32	0.00	4.01	1.61	0.00	0.94	0.00	0.13	0.49	SELECT RCVBL_YM, ORG_NO, SUM(R...
9t6habqtx6vzg	2,468.04	75,773.50	73,690.44	55,703,118	6,680,888	386,966	0.99	386,962	0.01	0.20	0.19	143.95	17.26	1.00	0.00	3.92	47.79	90.27	0.59	92.80	0.02	0.80	begin pkg_ca_counter.p_ca_coun...
c98tw7kbymbru	896.76	33,450.62	33,046.36	19,349,658	3,342,163	3,869,983	0.49	3,870,056	0.00	0.01	0.01	5.00	0.86	1.00	0.00	1.42	21.10	40.48	0.20	46.42	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
86g6708pvuqtu	812.84	41,089.86	40,681.48	19,349,395	3,342,882	3,869,925	0.51	3,869,991	0.00	0.01	0.01	5.00	0.86	1.00	0.00	1.29	25.92	49.83	0.20	46.43	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
07ttw6rma134k	554.97	6,286.59	2,234.57	13,680,890	157,883	55,267	3,445.36	55,264	0.01	0.11	0.04	247.56	2.86	1.00	0.06	0.88	3.97	2.74	0.14	2.19	67.61	0.11	begin pkg_ca_counter.p_ca_arra...
0zy85nnkqxrx6	212.33	304.22	0.00	5,443,805	0	4,265,904	0.00	192,016	0.00	0.00	0.00	28.35	0.00	22.22	0.00	0.34	0.19	0.00	0.06	0.00	0.00	0.39	select dept_no deptno from v_m...
7xn7z2p30awww	211.63	249.93	5.08	5,489,442	315	55,289	7.08	55,289	0.00	0.00	0.00	99.29	0.01	1.00	0.00	0.34	0.16	0.01	0.06	0.00	0.14	0.11	begin pkg_ca_counter.p_ca_coun...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Time (Global)

Captured SQL account for 99.5% of Total User I/O Wait Time (s): 81,637
Captured PL/SQL account for 93.5% of Total User I/O Wait Time (s): 81,637

SQL Id	IOWait (s)	Elapsed (s)	CPU (s)	Gets	Reads	Rows	Cluster (s)	Execs	IOWait (s)	Elapsed (s)	CPU (s)	Gets	Reads	Rows	Cluster (s)	IO Wait	DB time	DB CPU	Gets	Reads	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
9t6habqtx6vzg	73,690.44	75,773.50	2,468.04	55,703,118	6,680,888	386,966	0.99	386,962	0.19	0.20	0.01	143.95	17.26	1.00	0.00	90.27	47.79	3.92	0.59	92.80	0.02	0.80	begin pkg_ca_counter.p_ca_coun...
86g6708pvuqtu	40,681.48	41,089.86	812.84	19,349,395	3,342,882	3,869,925	0.51	3,869,991	0.01	0.01	0.00	5.00	0.86	1.00	0.00	49.83	25.92	1.29	0.20	46.43	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
c98tw7kbymbru	33,046.36	33,450.62	896.76	19,349,658	3,342,163	3,869,983	0.49	3,870,056	0.01	0.01	0.00	5.00	0.86	1.00	0.00	40.48	21.10	1.42	0.20	46.42	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
07ttw6rma134k	2,234.57	6,286.59	554.97	13,680,890	157,883	55,267	3,445.36	55,264	0.04	0.11	0.01	247.56	2.86	1.00	0.06	2.74	3.97	0.88	0.14	2.19	67.61	0.11	begin pkg_ca_counter.p_ca_arra...
7xn7z2p30awww	5.08	249.93	211.63	5,489,442	315	55,289	7.08	55,289	0.00	0.00	0.00	99.29	0.01	1.00	0.00	0.01	0.16	0.34	0.06	0.00	0.14	0.11	begin pkg_ca_counter.p_ca_coun...
42pxs62tawj10	0.00	2,556.95	2,526.13	89,343,341	0	7,667,739	6.60	237,225	0.00	0.01	0.01	376.62	0.00	32.32	0.00	0.00	1.61	4.01	0.94	0.00	0.13	0.49	SELECT RCVBL_YM, ORG_NO, SUM(R...
ctpdw3pywk3k9	0.00	5,633.98	5,527.21	222,396,865	0	63,990	6.60	63,990	0.00	0.09	0.09	3,475.49	0.00	1.00	0.00	0.00	3.55	8.78	2.35	0.00	0.13	0.13	begin pkg_ca_lookup.p_get_owec...
0zy85nnkqxrx6	0.00	304.22	212.33	5,443,805	0	4,265,904	0.00	192,016	0.00	0.00	0.00	28.35	0.00	22.22	0.00	0.00	0.19	0.34	0.06	0.00	0.00	0.39	select dept_no deptno from v_m...
3d3k6bzs4nk3f	0.00	2,652.76	2,611.15	131,836,355	0	7,261,226	0.00	237,223	0.00	0.01	0.01	555.75	0.00	30.61	0.00	0.00	1.67	4.15	1.39	0.00	0.00	0.49	SELECT RCVBL_YM, ORG_NO, SUM(R...
83p6uchsnm6n2	0.00	47,117.98	41,548.16	525,546,477	0	126,428,947	0.00	8,530,809	0.00	0.01	0.00	61.61	0.00	14.82	0.00	0.00	29.72	66.01	5.56	0.00	0.00	17.53	SELECT a.sys_user_name, a.org_...

Back to SQL Statistics
Back to Top

SQL ordered by Gets (Global)

Total Buffer Gets: 9,456,170,649
Captured SQL account for 11.3% of Total

SQL Id	Gets	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Execs	Gets	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Gets	Reads	DB time	DB CPU	IO Wait	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
83p6uchsnm6n2	525,546,477	0	47,117.98	41,548.16	0.00	126,428,947	0.00	8,530,809	61.61	0.00	0.01	0.00	0.00	14.82	0.00	5.56	0.00	29.72	66.01	0.00	0.00	17.53	SELECT a.sys_user_name, a.org_...
ctpdw3pywk3k9	222,396,865	0	5,633.98	5,527.21	0.00	63,990	6.60	63,990	3,475.49	0.00	0.09	0.09	0.00	1.00	0.00	2.35	0.00	3.55	8.78	0.00	0.13	0.13	begin pkg_ca_lookup.p_get_owec...
3d3k6bzs4nk3f	131,836,355	0	2,652.76	2,611.15	0.00	7,261,226	0.00	237,223	555.75	0.00	0.01	0.01	0.00	30.61	0.00	1.39	0.00	1.67	4.15	0.00	0.00	0.49	SELECT RCVBL_YM, ORG_NO, SUM(R...
42pxs62tawj10	89,343,341	0	2,556.95	2,526.13	0.00	7,667,739	6.60	237,225	376.62	0.00	0.01	0.01	0.00	32.32	0.00	0.94	0.00	1.61	4.01	0.00	0.13	0.49	SELECT RCVBL_YM, ORG_NO, SUM(R...
f3pwz8c7b36m5	73,313,531	0	509.03	192.13	0.00	79,042,382	0.00	1,145,603	64.00	0.00	0.00	0.00	0.00	69.00	0.00	0.78	0.00	0.32	0.31	0.00	0.00	2.35	select * from indy_user_profil...
9t6habqtx6vzg	55,703,118	6,680,888	75,773.50	2,468.04	73,690.44	386,966	0.99	386,962	143.95	17.26	0.20	0.01	0.19	1.00	0.00	0.59	92.80	47.79	3.92	90.27	0.02	0.80	begin pkg_ca_counter.p_ca_coun...
4nxjprfhqt4jr	31,649,865	0	167.08	151.86	0.00	3,430,935	0.00	8,035	3,939.00	0.00	0.02	0.02	0.00	427.00	0.00	0.33	0.00	0.11	0.24	0.00	0.00	0.02	select DISTINCT a.sys_user_nam...
cr61tqvuq0fzd	27,794,231	0	453.59	200.57	0.00	221,136	161.87	221,141	125.69	0.00	0.00	0.00	0.00	1.00	0.00	0.29	0.00	0.29	0.32	0.00	3.18	0.45	select pkg_ca_counter.f_getnew...
942n22j17wfux	26,302,451	0	330.51	140.09	0.00	0	158.81	220,797	119.13	0.00	0.00	0.00	0.00	0.00	0.00	0.28	0.00	0.21	0.22	0.00	3.12	0.45	SELECT CUR_NOTE_NO, INV_OPER_I...
4fuvxgt352tdg	25,661,106	0	396.34	58.56	0.00	8,554,678	0.00	8,555,004	3.00	0.00	0.00	0.00	0.00	1.00	0.00	0.27	0.00	0.25	0.09	0.00	0.00	17.58	SELECT role_id FROM p_role WHE...

Back to SQL Statistics
Back to Top

SQL ordered by Reads (Global)

Total Disk Reads: 7,199,316
Captured SQL account for 99.9% of Total

SQL Id	Reads	Gets	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Execs	Reads	Gets	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Reads	Gets	DB time	DB CPU	IO Wait	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
9t6habqtx6vzg	6,680,888	55,703,118	75,773.50	2,468.04	73,690.44	386,966	0.99	386,962	17.26	143.95	0.20	0.01	0.19	1.00	0.00	92.80	0.59	47.79	3.92	90.27	0.02	0.80	begin pkg_ca_counter.p_ca_coun...
86g6708pvuqtu	3,342,882	19,349,395	41,089.86	812.84	40,681.48	3,869,925	0.51	3,869,991	0.86	5.00	0.01	0.00	0.01	1.00	0.00	46.43	0.20	25.92	1.29	49.83	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
c98tw7kbymbru	3,342,163	19,349,658	33,450.62	896.76	33,046.36	3,869,983	0.49	3,870,056	0.86	5.00	0.01	0.00	0.01	1.00	0.00	46.42	0.20	21.10	1.42	40.48	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
07ttw6rma134k	157,883	13,680,890	6,286.59	554.97	2,234.57	55,267	3,445.36	55,264	2.86	247.56	0.11	0.01	0.04	1.00	0.06	2.19	0.14	3.97	0.88	2.74	67.61	0.11	begin pkg_ca_counter.p_ca_arra...
bxctd2r3kgjyb	111,378	552,859	1,536.32	49.16	1,520.84	110,572	0.02	110,572	1.01	5.00	0.01	0.00	0.01	1.00	0.00	1.55	0.01	0.97	0.08	1.86	0.00	0.23	SELECT PL_AMT_ID FROM P_E_PL_A...
7q8fzfa8p6gk8	111,175	552,860	1,531.65	34.58	1,516.03	110,572	0.02	110,572	1.01	5.00	0.01	0.00	0.01	1.00	0.00	1.54	0.01	0.97	0.05	1.86	0.00	0.23	SELECT PL_AMT_ID FROM P_E_PL_A...
4bf7r12w7dg25	110,897	552,908	1,574.36	58.92	1,511.47	55,290	0.02	55,290	2.01	10.00	0.03	0.00	0.03	1.00	0.00	1.54	0.01	0.99	0.09	1.85	0.00	0.11	SELECT pkg_sp_seq.f_a_defid se...
33j84p5q021j3	44,589	2,047,969	1,142.88	57.71	684.61	54,427	403.46	54,427	0.82	37.63	0.02	0.00	0.01	1.00	0.01	0.62	0.02	0.72	0.09	0.84	7.92	0.11	INSERT INTO A_PAY_FLOW (CHARGE...
g4ncbpmxhsh2b	33,932	272,835	630.84	13.30	609.55	7,732	10.86	7,781	4.36	35.06	0.08	0.00	0.08	0.99	0.00	0.47	0.00	0.40	0.02	0.75	0.21	0.02	SELECT a.org_no, a.cons_id, a....
b76zzq2h9gm66	30,546	95,407	592.61	11.57	576.99	23,699	5.51	23,699	1.29	4.03	0.03	0.00	0.02	1.00	0.00	0.42	0.00	0.37	0.02	0.71	0.11	0.05	SELECT count(*) record_num FRO...

Back to SQL Statistics
Back to Top

SQL ordered by UnOptimized Read Requests (Global)

Total Physical Read Requests: 7,197,965
Captured SQL account for 99.7% of Total
Total UnOptimized Read Requests: 7,197,965
Captured SQL account for 99.7% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

SQL Id	UnOptimized	Requests	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Execs	UnOptimized	Requests	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	UnOptimized	Requests	Reads	DB time	DB CPU	IO Wait	Cluster	Execs	SQL Text
	Total									Per Execution								Percentage of Total
9t6habqtx6vzg	6,685,073	6,685,073	6,680,888	75,773.50	2,468.04	73,690.44	386,966	0.99	386,962	17.28	17.28	17.26	0.20	0.01	0.19	1.00	0.00	92.87	92.87	92.80	47.79	3.92	90.27	0.02	0.80	begin pkg_ca_counter.p_ca_coun...
86g6708pvuqtu	3,342,919	3,342,919	3,342,882	41,089.86	812.84	40,681.48	3,869,925	0.51	3,869,991	0.86	0.86	0.86	0.01	0.00	0.01	1.00	0.00	46.44	46.44	46.43	25.92	1.29	49.83	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
c98tw7kbymbru	3,342,083	3,342,083	3,342,163	33,450.62	896.76	33,046.36	3,869,983	0.49	3,870,056	0.86	0.86	0.86	0.01	0.00	0.01	1.00	0.00	46.43	46.43	46.42	21.10	1.42	40.48	0.01	7.95	SELECT PL_AMT_ID FROM P_E_PL_A...
07ttw6rma134k	157,892	157,892	157,883	6,286.59	554.97	2,234.57	55,267	3,445.36	55,264	2.86	2.86	2.86	0.11	0.01	0.04	1.00	0.06	2.19	2.19	2.19	3.97	0.88	2.74	67.61	0.11	begin pkg_ca_counter.p_ca_arra...
bxctd2r3kgjyb	111,378	111,378	111,378	1,536.32	49.16	1,520.84	110,572	0.02	110,572	1.01	1.01	1.01	0.01	0.00	0.01	1.00	0.00	1.55	1.55	1.55	0.97	0.08	1.86	0.00	0.23	SELECT PL_AMT_ID FROM P_E_PL_A...
7q8fzfa8p6gk8	111,175	111,175	111,175	1,531.65	34.58	1,516.03	110,572	0.02	110,572	1.01	1.01	1.01	0.01	0.00	0.01	1.00	0.00	1.54	1.54	1.54	0.97	0.05	1.86	0.00	0.23	SELECT PL_AMT_ID FROM P_E_PL_A...
4bf7r12w7dg25	110,897	110,897	110,897	1,574.36	58.92	1,511.47	55,290	0.02	55,290	2.01	2.01	2.01	0.03	0.00	0.03	1.00	0.00	1.54	1.54	1.54	0.99	0.09	1.85	0.00	0.11	SELECT pkg_sp_seq.f_a_defid se...
33j84p5q021j3	44,589	44,589	44,589	1,142.88	57.71	684.61	54,427	403.46	54,427	0.82	0.82	0.82	0.02	0.00	0.01	1.00	0.01	0.62	0.62	0.62	0.72	0.09	0.84	7.92	0.11	INSERT INTO A_PAY_FLOW (CHARGE...
g4ncbpmxhsh2b	33,932	33,932	33,932	630.84	13.30	609.55	7,732	10.86	7,781	4.36	4.36	4.36	0.08	0.00	0.08	0.99	0.00	0.47	0.47	0.47	0.40	0.02	0.75	0.21	0.02	SELECT a.org_no, a.cons_id, a....
b76zzq2h9gm66	30,546	30,546	30,546	592.61	11.57	576.99	23,699	5.51	23,699	1.29	1.29	1.29	0.03	0.00	0.02	1.00	0.00	0.42	0.42	0.42	0.37	0.02	0.71	0.11	0.05	SELECT count(*) record_num FRO...

Back to SQL Statistics
Back to Top

SQL ordered by Executions (Global)

Total Executions: 48,663,716
Captured SQL account for 67.8% of Total

SQL Id	Execs	Elapsed (s)	CPU (s)	IOWait (s)	Gets	Reads	Rows	Cluster (s)	Elapsed (s)	CPU (s)	IOWait (s)	Gets	Reads	Rows	Cluster (s)	Execs	DB time	DB CPU	IO Wait	Gets	Reads	Cluster	SQL Text
	Total								Per Execution							Percentage of Total
4fuvxgt352tdg	8,555,004	396.34	58.56	0.00	25,661,106	0	8,554,678	0.00	0.00	0.00	0.00	3.00	0.00	1.00	0.00	17.58	0.25	0.09	0.00	0.27	0.00	0.00	SELECT role_id FROM p_role WHE...
83p6uchsnm6n2	8,530,809	47,117.98	41,548.16	0.00	525,546,477	0	126,428,947	0.00	0.01	0.00	0.00	61.61	0.00	14.82	0.00	17.53	29.72	66.01	0.00	5.56	0.00	0.00	SELECT a.sys_user_name, a.org_...
c98tw7kbymbru	3,870,056	33,450.62	896.76	33,046.36	19,349,658	3,342,163	3,869,983	0.49	0.01	0.00	0.01	5.00	0.86	1.00	0.00	7.95	21.10	1.42	40.48	0.20	46.42	0.01	SELECT PL_AMT_ID FROM P_E_PL_A...
86g6708pvuqtu	3,869,991	41,089.86	812.84	40,681.48	19,349,395	3,342,882	3,869,925	0.51	0.01	0.00	0.01	5.00	0.86	1.00	0.00	7.95	25.92	1.29	49.83	0.20	46.43	0.01	SELECT PL_AMT_ID FROM P_E_PL_A...
f3pwz8c7b36m5	1,145,603	509.03	192.13	0.00	73,313,531	0	79,042,382	0.00	0.00	0.00	0.00	64.00	0.00	69.00	0.00	2.35	0.32	0.31	0.00	0.78	0.00	0.00	select * from indy_user_profil...
f64k97dx2b3ng	622,304	43.24	17.56	0.00	1,866,897	0	622,292	0.00	0.00	0.00	0.00	3.00	0.00	1.00	0.00	1.28	0.03	0.03	0.00	0.02	0.00	0.00	select * from indy_user where ...
g03fat3zm461h	497,591	88.73	46.57	0.00	0	0	497,583	0.00	0.00	0.00	0.00	0.00	0.00	1.00	0.00	1.02	0.06	0.07	0.00	0.00	0.00	0.00	SELECT CAST(DBMS_RANDOM.VALUE(...
g29djn2028jrv	497,578	13.18	8.39	0.00	0	0	497,580	0.00	0.00	0.00	0.00	0.00	0.00	1.00	0.00	1.02	0.01	0.01	0.00	0.00	0.00	0.00	SELECT MOD(:B1 , 12) FROM DUAL
f0zvt5m556g1h	386,993	36.25	17.72	0.00	3,096,526	0	1,161,048	0.00	0.00	0.00	0.00	8.00	0.00	3.00	0.00	0.80	0.02	0.03	0.00	0.03	0.00	0.00	SELECT '' NAME, '' VALUE, 0 DI...
43nabnvjnxcxs	386,987	34.56	18.80	0.00	1,935,111	0	1,548,064	0.00	0.00	0.00	0.00	5.00	0.00	4.00	0.00	0.80	0.02	0.03	0.00	0.02	0.00	0.00	SELECT PARA_NAME NAME, PARA_VA...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time (Global)

Total Cluster Wait Time (s): 5,096
Captured SQL account for 84.5% of Total

SQL Id	Cluster (s)	Elapsed (s)	CPU (s)	IOWait (s)	Gets	Reads	Rows	Execs	Cluster (s)	Elapsed (s)	CPU (s)	IOWait (s)	Gets	Reads	Rows	Cluster	DB time	DB CPU	Gets	IO Wait	Reads	Execs	SQL Text
	Total								Per Execution							Percentage of Total
07ttw6rma134k	3,445.36	6,286.59	554.97	2,234.57	13,680,890	157,883	55,267	55,264	0.06	0.11	0.01	0.04	247.56	2.86	1.00	67.61	3.97	0.88	2.74	0.14	2.19	0.11	begin pkg_ca_counter.p_ca_arra...
fb7paxp4m9wcg	2,573.97	2,668.91	67.89	17.27	784,710	1,252	54,424	54,425	0.05	0.05	0.00	0.00	14.42	0.02	1.00	50.51	1.68	0.11	0.02	0.01	0.02	0.11	INSERT INTO A_PREPAY_FLOW (PRE...
09g7gn0zqnu2s	454.90	574.24	30.91	89.16	563,299	5,212	7,214	7,214	0.06	0.08	0.00	0.01	78.08	0.72	1.00	8.93	0.36	0.05	0.11	0.01	0.07	0.01	begin pkg_be_common.p_initapp(...
g5tva0zp1yz4v	448.72	479.29	33.88	7.38	342,797	392	54,426	55,277	0.01	0.01	0.00	0.00	6.20	0.01	0.98	8.81	0.30	0.05	0.01	0.00	0.01	0.11	SELECT NVL(PREPAY_BAL, 0) - NV...
512pkdrfucyax	423.47	438.32	6.55	9.64	125,684	665	7,214	7,214	0.06	0.06	0.00	0.00	17.42	0.09	1.00	8.31	0.28	0.01	0.01	0.00	0.01	0.01	INSERT INTO S_APP_CERT (ACT_ID...
33j84p5q021j3	403.46	1,142.88	57.71	684.61	2,047,969	44,589	54,427	54,427	0.01	0.02	0.00	0.01	37.63	0.82	1.00	7.92	0.72	0.09	0.84	0.02	0.62	0.11	INSERT INTO A_PAY_FLOW (CHARGE...
cr61tqvuq0fzd	161.87	453.59	200.57	0.00	27,794,231	0	221,136	221,141	0.00	0.00	0.00	0.00	125.69	0.00	1.00	3.18	0.29	0.32	0.00	0.29	0.00	0.45	select pkg_ca_counter.f_getnew...
942n22j17wfux	158.81	330.51	140.09	0.00	26,302,451	0	0	220,797	0.00	0.00	0.00	0.00	119.13	0.00	0.00	3.12	0.21	0.22	0.00	0.28	0.00	0.45	SELECT CUR_NOTE_NO, INV_OPER_I...
dfcmxs132fy4g	109.85	291.94	52.83	119.55	2,050,688	7,301	64,485	64,485	0.00	0.00	0.00	0.00	31.80	0.11	1.00	2.16	0.18	0.08	0.15	0.02	0.10	0.13	begin pkg_be_common.p_updatere...
5xwhyp8wvvjwk	95.50	176.05	59.06	16.27	1,842,530	973	7,161	7,163	0.01	0.02	0.01	0.00	257.23	0.14	1.00	1.87	0.11	0.09	0.02	0.02	0.01	0.01	BEGIN OWF_MGR.WF_ENGINE.STARTP...

Back to SQL Statistics
Back to Top

Global Activity Statistics

System Statistics (Global)
Global Messaging Statistics (Global)
System Statistics (Absolute Values)

System Statistics (Global)

per Second Average - average of per-instance per Second rates
per Second Std Dev - standard deviation of per-instance per Second rates
per Second Min - minium of per-instance per Second rates
per Second Max - maximum of per-instance per Second rates

Statistic	Total	per Second	per Trans	Average	Std Dev	Min	Max
				per Second
Batched IO (bound) vector count	5	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO block miss count	23	0.01	0.00	0.00	0.00	0.00	0.00
Batched IO same unit count	14	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO single block count	3	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO vector block count	6	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO vector read count	2	0.00	0.00	0.00	0.00	0.00	0.00
Block Cleanout Optim referenced	35,934	12.76	0.49	6.38	0.06	6.34	6.43
CPU used by this session	5,332,919	1,894.40	72.72	947.20	163.19	831.80	1,062.59
CPU used when call started	5,306,462	1,885.00	72.36	942.50	163.17	827.12	1,057.88
CR blocks created	61,041	21.68	0.83	10.84	1.63	9.69	11.99
Cached Commit SCN referenced	5,191,561	1,844.18	70.80	922.09	155.32	812.26	1,031.92
Commit SCN cached	16,329	5.80	0.22	2.90	0.29	2.70	3.10
DB time	16,400,396	5,825.87	223.65	2,912.94	158.20	2,801.07	3,024.80
DBWR checkpoint buffers written	323,212	114.81	4.41	57.41	10.13	50.24	64.57
DBWR fusion writes	104,665	37.18	1.43	18.59	4.62	15.32	21.86
DBWR transaction table writes	1,580	0.56	0.02	0.28	0.01	0.27	0.29
DBWR undo block writes	49,880	17.72	0.68	8.86	0.50	8.50	9.22
DFO trees parallelized	341	0.12	0.00	0.06	0.08	0.00	0.12
HSC Heap Segment Block Changes	881,048	312.97	12.01	156.49	17.03	144.44	168.53
Heap Segment Array Inserts	126,592	44.97	1.73	22.48	2.34	20.83	24.14
Heap Segment Array Updates	444	0.16	0.01	0.08	0.02	0.07	0.09
PX local messages recv'd	1,372	0.49	0.02	0.24	0.34	0.01	0.48
PX local messages sent	1,372	0.49	0.02	0.24	0.34	0.01	0.48
PX remote messages recv'd	1,404	0.50	0.02	0.25	0.01	0.24	0.26
PX remote messages sent	1,404	0.50	0.02	0.25	0.01	0.24	0.26
Parallel operations not downgraded	341	0.12	0.00	0.06	0.08	0.00	0.12
Requests to/from client	91,968,291	32,669.66	1,254.15	16,334.83	1,376.16	15,361.74	17,307.92
RowCR - row contention	32	0.01	0.00	0.01	0.00	0.00	0.01
RowCR attempts	10,087,323	3,583.29	137.56	1,791.65	200.19	1,650.09	1,933.20
RowCR hits	10,120,064	3,594.92	138.01	1,797.46	200.75	1,655.51	1,939.41
SMON posted for undo segment shrink	136	0.05	0.00	0.02	0.00	0.02	0.03
SQL*Net roundtrips to/from client	91,968,373	32,669.69	1,254.15	16,334.84	1,376.16	15,361.75	17,307.94
TBS Extension: tasks created	8	0.00	0.00	0.00	0.00	0.00	0.00
TBS Extension: tasks executed	8	0.00	0.00	0.00	0.00	0.00	0.00
active txn count during cleanout	152,599	54.21	2.08	27.10	4.12	24.19	30.02
application wait time	514	0.18	0.01	0.09	0.01	0.09	0.10
background timeouts	39,156	13.91	0.53	6.95	0.00	6.95	6.96
branch node splits	231	0.08	0.00	0.04	0.05	0.00	0.08
buffer is not pinned count	8,943,901,683	3,177,118.23	121,966.18	1,588,559.11	196,125.51	1,449,877.44	1,727,240.79
buffer is pinned count	123,359,861,320	43,820,791.74	1,682,233.45	21,910,395.87	2,779,152.83	19,945,238.06	23,875,553.69
bytes received via SQL*Net from client	3,613,014,319	1,283,441.67	49,269.94	641,720.84	61,745.14	598,060.43	685,381.24
bytes sent via SQL*Net to client	21,296,217,290	7,565,007.45	290,412.20	3,782,503.73	108,879.22	3,705,514.49	3,859,492.96
calls to get snapshot scn: kcmgss	48,856,950	17,355.33	666.25	8,677.66	890.51	8,047.98	9,307.35
calls to kcmgas	386,911	137.44	5.28	68.72	6.93	63.82	73.62
calls to kcmgcs	3,528,357	1,253.37	48.12	626.68	53.91	588.57	664.80
cell physical IO interconnect bytes	65,157,044,224	23,145,592.02	888,533.42	11,572,796.01	425,949.06	11,271,604.54	11,873,987.48
change write time	3,201	1.14	0.04	0.57	0.06	0.52	0.61
cleanout - number of ktugct calls	101,628	36.10	1.39	18.05	2.56	16.24	19.86
cleanouts and rollbacks - consistent read gets	59,940	21.29	0.82	10.65	1.65	9.48	11.81
cleanouts only - consistent read gets	12,600	4.48	0.17	2.24	0.22	2.08	2.39
cluster key scan block gets	345,925	122.88	4.72	61.44	8.65	55.33	67.56
cluster key scans	193,257	68.65	2.64	34.33	4.82	30.92	37.73
cluster wait time	509,571	181.01	6.95	90.51	7.20	85.42	95.60
commit batch/immediate performed	564	0.20	0.01	0.10	0.01	0.09	0.11
commit batch/immediate requested	564	0.20	0.01	0.10	0.01	0.09	0.11
commit cleanout failures: block lost	70,405	25.01	0.96	12.50	1.05	11.76	13.25
commit cleanout failures: buffer being written	130	0.05	0.00	0.02	0.01	0.02	0.03
commit cleanout failures: callback failure	748	0.27	0.01	0.13	0.01	0.13	0.14
commit cleanout failures: cannot pin	295	0.10	0.00	0.05	0.01	0.05	0.06
commit cleanouts	2,134,053	758.07	29.10	379.04	41.93	349.39	408.68
commit cleanouts successfully completed	2,062,475	732.65	28.13	366.32	40.85	337.44	395.21
commit immediate performed	564	0.20	0.01	0.10	0.01	0.09	0.11
commit immediate requested	564	0.20	0.01	0.10	0.01	0.09	0.11
commit txn count during cleanout	246,960	87.73	3.37	43.86	5.90	39.69	48.04
concurrency wait time	10,186	3.62	0.14	1.81	0.36	1.55	2.06
consistent changes	585,870	208.12	7.99	104.06	12.63	95.13	112.99
consistent gets	9,448,649,632	3,356,418.50	128,849.32	1,678,209.25	206,554.20	1,532,153.37	1,824,265.12
consistent gets - examination	129,335,341	45,943.46	1,763.72	22,971.73	2,216.85	21,404.18	24,539.27
consistent gets from cache	9,448,649,632	3,356,418.50	128,849.32	1,678,209.25	206,554.20	1,532,153.37	1,824,265.12
consistent gets from cache (fastpath)	9,306,203,255	3,305,817.64	126,906.81	1,652,908.82	204,078.93	1,508,603.23	1,797,214.41
cursor authentications	101	0.04	0.00	0.02	0.02	0.00	0.03
data blocks consistent reads - undo records applied	93,772	33.31	1.28	16.66	2.56	14.84	18.47
db block changes	6,283,512	2,232.08	85.69	1,116.04	113.77	1,035.59	1,196.49
db block gets	7,521,017	2,671.67	102.56	1,335.84	145.60	1,232.88	1,438.79
db block gets direct	605	0.21	0.01	0.11	0.00	0.11	0.11
db block gets from cache	7,520,412	2,671.46	102.55	1,335.73	145.59	1,232.78	1,438.68
db block gets from cache (fastpath)	2,131,749	757.26	29.07	378.63	35.97	353.20	404.06
deferred (CURRENT) block cleanout applications	565,954	201.04	7.72	100.52	10.69	92.96	108.08
dirty buffers inspected	24,667	8.76	0.34	4.38	3.36	2.01	6.76
enqueue conversions	58,878	20.92	0.80	10.46	0.60	10.03	10.88
enqueue releases	1,244,513	442.09	16.97	221.04	23.34	204.54	237.55
enqueue requests	1,246,384	442.75	17.00	221.37	23.59	204.69	238.06
enqueue timeouts	1,787	0.63	0.02	0.32	0.25	0.14	0.50
enqueue waits	6,074	2.16	0.08	1.08	0.20	0.94	1.22
exchange deadlocks	2,060	0.73	0.03	0.37	0.09	0.30	0.43
execute count	48,663,716	17,286.68	663.62	8,643.34	884.33	8,018.03	9,268.66
file io service time	1,821,117	646.92	24.83	646.92		646.92	646.92
file io wait time	82,258,470,660	29,220,505.50	1,121,742.11	14,610,252.75	1,270,250.57	13,712,049.96	15,508,455.54
free buffer inspected	8,010,379	2,845.51	109.24	1,422.75	60.50	1,379.98	1,465.53
free buffer requested	8,207,346	2,915.48	111.92	1,457.74	67.73	1,409.84	1,505.63
gc blocks compressed	396,920	141.00	5.41	70.50	2.31	68.87	72.13
gc cr block flush time	73,008	25.93	1.00	12.97	0.62	12.53	13.40
gc cr block receive time	76,518	27.18	1.04	13.59	0.58	13.18	14.00
gc cr blocks received	124,467	44.21	1.70	22.11	1.22	21.24	22.97
gc cr blocks served	124,467	44.21	1.70	22.11	1.22	21.24	22.97
gc current block flush time	182,386	64.79	2.49	32.39	1.91	31.05	33.74
gc current block pin time	1,166	0.41	0.02	0.21	0.11	0.13	0.28
gc current block receive time	224,805	79.86	3.07	39.93	4.34	36.86	43.00
gc current blocks received	540,655	192.06	7.37	96.03	4.27	93.01	99.05
gc current blocks served	540,657	192.06	7.37	96.03	4.27	93.01	99.04
gc force cr disk read	5	0.00	0.00	0.00	0.00	0.00	0.00
gc kbytes saved	1,139,975	404.95	15.55	202.48	7.18	197.40	207.55
gc kbytes sent	4,181,016	1,485.21	57.02	742.61	36.71	716.65	768.56
gc local grants	7,117,775	2,528.43	97.06	1,264.22	70.98	1,214.02	1,314.41
gc read wait time	26,274	9.33	0.36	4.67	6.37	0.16	9.17
gc read wait timeouts	1	0.00	0.00	0.00		0.00	0.00
gc read waits	1,468	0.52	0.02	0.26	0.17	0.14	0.38
gc remote grants	202,276	71.85	2.76	35.93	3.39	33.53	38.33
gcs messages sent	1,492,399	530.14	20.35	265.07	0.98	264.38	265.76
ges messages sent	26,171	9.30	0.36	4.65	0.00	4.65	4.65
global enqueue get time	19,484	6.92	0.27	3.46	0.42	3.17	3.76
global enqueue gets async	922	0.33	0.01	0.16	0.00	0.16	0.17
global enqueue gets sync	9,683,771	3,439.94	132.06	1,719.97	195.48	1,581.75	1,858.19
global enqueue releases	9,620,052	3,417.31	131.19	1,708.65	194.64	1,571.02	1,846.28
heap block compress	2,750	0.98	0.04	0.49	0.07	0.44	0.54
hot buffers moved to head of LRU	2,692,388	956.41	36.72	478.20	131.99	384.87	571.54
immediate (CR) block cleanout applications	72,542	25.77	0.99	12.88	1.86	11.57	14.20
immediate (CURRENT) block cleanout applications	34,039	12.09	0.46	6.05	0.55	5.66	6.43
in call idle wait time	20,924,268	7,432.88	285.34	3,716.44	200.05	3,574.98	3,857.90
index crx upgrade (positioned)	5,172	1.84	0.07	0.92	0.35	0.67	1.17
index fast full scans (full)	66	0.02	0.00	0.01	0.00	0.01	0.01
index fetch by key	33,371,235	11,854.38	455.08	5,927.19	562.81	5,529.22	6,325.15
index scans kdiixs1	64,053,878	22,753.69	873.49	11,376.84	1,342.42	10,427.61	12,326.08
leaf node 90-10 splits	463	0.16	0.01	0.08	0.02	0.07	0.10
leaf node splits	10,386	3.69	0.14	1.84	0.12	1.76	1.93
lob writes	200	0.07	0.00	0.04	0.02	0.02	0.05
lob writes unaligned	200	0.07	0.00	0.04	0.02	0.02	0.05
logical read bytes from cache	77,464,929,263,616	27,517,659,303.39	1,056,373,556.39	13,758,829,651.69	1,693,283,974.20	12,561,497,071.06	14,956,162,232.33
logons cumulative	1,317	0.47	0.02	0.23	0.01	0.23	0.24
max cf enq hold time	120	0.04	0.00	0.04		0.04	0.04
messages received	423,864	150.57	5.78	75.28	12.11	66.72	83.85
messages sent	423,864	150.57	5.78	75.28	12.11	66.72	83.85
min active SCN optimization applied on CR	6,140,550	2,181.29	83.74	1,090.65	124.95	1,002.29	1,179.00
no buffer to keep pinned count	494	0.18	0.01	0.09	0.02	0.08	0.10
no work - consistent read gets	9,303,231,421	3,304,761.96	126,866.28	1,652,380.98	204,029.55	1,508,110.30	1,796,651.66
non-idle wait count	102,560,067	36,432.15	1,398.59	18,216.08	1,331.44	17,274.60	19,157.55
non-idle wait time	9,964,126	3,539.53	135.88	1,769.77	95.91	1,701.95	1,837.59
opened cursors cumulative	26,743,768	9,500.12	364.70	4,750.06	549.87	4,361.24	5,138.88
parse count (failures)	456	0.16	0.01	0.08	0.04	0.05	0.11
parse count (hard)	479	0.17	0.01	0.09	0.03	0.06	0.11
parse count (total)	6,032,396	2,142.87	82.26	1,071.44	123.13	984.37	1,158.50
parse time cpu	9,500	3.37	0.13	1.69	0.23	1.52	1.85
parse time elapsed	15,874	5.64	0.22	2.82	0.51	2.46	3.18
physical read IO requests	7,197,965	2,556.92	98.16	1,278.46	67.23	1,230.92	1,326.00
physical read bytes	58,976,796,672	20,950,199.08	804,254.64	10,475,099.54	551,689.20	10,084,996.37	10,865,202.72
physical read total IO requests	7,214,282	2,562.71	98.38	1,281.36	67.49	1,233.63	1,329.08
physical read total bytes	59,243,412,992	21,044,908.65	807,890.43	10,522,454.32	556,042.64	10,129,272.80	10,915,635.84
physical read total multi block requests	9	0.00	0.00	0.00	0.00	0.00	0.00
physical reads	7,199,316	2,557.40	98.18	1,278.70	67.34	1,231.08	1,326.32
physical reads cache	7,199,316	2,557.40	98.18	1,278.70	67.34	1,231.08	1,326.32
physical reads cache prefetch	1,356	0.48	0.02	0.24	0.12	0.16	0.32
physical write IO requests	316,053	112.27	4.31	56.14	10.14	48.97	63.30
physical write bytes	3,686,522,880	1,309,553.38	50,272.37	654,776.69	97,131.36	586,094.45	723,458.93
physical write total IO requests	470,558	167.16	6.42	83.58	11.75	75.27	91.88
physical write total bytes	5,913,631,232	2,100,683.37	80,642.99	1,050,341.68	130,093.58	958,351.63	1,142,331.73
physical write total multi block requests	4,673	1.66	0.06	0.83	0.03	0.81	0.85
physical writes	450,015	159.86	6.14	79.93	11.86	71.54	88.31
physical writes direct	605	0.21	0.01	0.11	0.00	0.11	0.11
physical writes direct (lob)	8	0.00	0.00	0.00	0.00	0.00	0.00
physical writes direct temporary tablespace	1	0.00	0.00	0.00		0.00	0.00
physical writes from cache	449,410	159.64	6.13	79.82	11.86	71.44	88.20
physical writes non checkpoint	340,908	121.10	4.65	60.55	6.50	55.96	65.14
pinned buffers inspected	3,156	1.12	0.04	0.56	0.63	0.11	1.01
pinned cursors current	158	0.06	0.00	0.03	0.01	0.02	0.04
prefetched blocks aged out before use	2	0.00	0.00	0.00		0.00	0.00
process last non-idle time	6,304	2.24	0.09	1.12	0.13	1.03	1.21
queries parallelized	341	0.12	0.00	0.06	0.08	0.00	0.12
recursive calls	94,092,640	33,424.28	1,283.12	16,712.14	1,884.62	15,379.51	18,044.77
recursive cpu usage	864,450	307.08	11.79	153.54	22.55	137.59	169.49
redo blocks checksummed by FG (exclusive)	376,147	133.62	5.13	66.81	2.51	65.03	68.59
redo blocks written	2,089,235	742.15	28.49	371.08	32.68	347.97	394.18
redo entries	3,519,560	1,250.24	48.00	625.12	61.30	581.78	668.47
redo ordering marks	39,777	14.13	0.54	7.06	0.14	6.97	7.16
redo size	1,015,278,724	360,654.84	13,845.15	180,327.42	16,003.52	169,011.23	191,643.62
redo size for direct writes	1,508	0.54	0.02	0.27	0.01	0.26	0.28
redo subscn max counts	13,367	4.75	0.18	2.37	0.28	2.17	2.57
redo synch long waits	426	0.15	0.01	0.08	0.02	0.06	0.09
redo synch time	852,592	302.86	11.63	151.43	21.02	136.57	166.29
redo synch time (usec)	8,525,952,200	3,028,650.78	116,266.68	1,514,325.39	210,199.82	1,365,691.67	1,662,959.11
redo synch time overhead (usec)	7,070,700	2,511.70	96.42	1,255.85	372.10	992.74	1,518.96
redo synch time overhead count (<128 msec)	4	0.00	0.00	0.00		0.00	0.00
redo synch time overhead count (<2 msec)	70,984	25.22	0.97	12.61	1.38	11.63	13.59
redo synch time overhead count (<32 msec)	7	0.00	0.00	0.00	0.00	0.00	0.00
redo synch time overhead count (<8 msec)	17	0.01	0.00	0.00	0.00	0.00	0.00
redo synch time overhead count (>=128 msec)	6	0.00	0.00	0.00	0.00	0.00	0.00
redo synch writes	71,094	25.25	0.97	12.63	1.40	11.64	13.61
redo wastage	19,411,448	6,895.48	264.71	3,447.74	175.49	3,323.65	3,571.83
redo write broadcast ack count	56	0.02	0.00	0.01	0.00	0.01	0.01
redo write broadcast ack time	4,073	1.45	0.06	0.72	0.56	0.33	1.12
redo write info find	71,026	25.23	0.97	12.62	1.39	11.63	13.60
redo write info find fail	8	0.00	0.00	0.00	0.00	0.00	0.00
redo write time	209,787	74.52	2.86	37.26	2.26	35.66	38.86
redo writes	60,021	21.32	0.82	10.66	0.53	10.29	11.04
rollback changes - undo records applied	3,171	1.13	0.04	0.56	0.09	0.50	0.63
rollbacks only - consistent read gets	1,466	0.52	0.02	0.26	0.03	0.24	0.28
root node splits	9	0.00	0.00	0.00	0.00	0.00	0.00
rows fetched via callback	24,027,395	8,535.19	327.66	4,267.59	387.00	3,993.95	4,541.24
session cursor cache hits	5,326,420	1,892.09	72.64	946.05	60.10	903.55	988.54
session logical reads	9,456,170,649	3,359,090.17	128,951.88	1,679,545.08	206,699.79	1,533,386.26	1,825,703.91
shared hash latch upgrades - no wait	13,969,613	4,962.39	190.50	2,481.19	194.44	2,343.71	2,618.68
shared hash latch upgrades - wait	7,361	2.61	0.10	1.31	0.12	1.22	1.39
sorts (memory)	11,976,178	4,254.27	163.32	2,127.13	259.78	1,943.44	2,310.83
sorts (rows)	241,787,067	85,889.38	3,297.20	42,944.69	4,600.58	39,691.59	46,197.79
sql area evicted	456	0.16	0.01	0.08	0.04	0.05	0.11
sql area purged	456	0.16	0.01	0.08	0.04	0.05	0.11
summed dirty queue length	525,482	186.67	7.17	93.33	40.97	64.36	122.30
switch current to new buffer	90,109	32.01	1.23	16.00	2.35	14.34	17.67
table fetch by rowid	66,112,940,474	23,485,122.06	901,568.78	11,742,561.03	1,487,178.88	10,690,966.76	12,794,155.30
table fetch continued row	35	0.01	0.00	0.01	0.01	0.00	0.01
table scan blocks gotten	90,561,418	32,169.91	1,234.97	16,084.95	1,031.62	15,355.49	16,814.42
table scan rows gotten	6,791,351,900	2,412,474.29	92,612.29	1,206,237.14	114,529.34	1,125,252.67	1,287,221.61
table scans (short tables)	2,076,208	737.53	28.31	368.76	23.97	351.82	385.71
total cf enq hold time	2,490	0.88	0.03	0.44	0.15	0.33	0.55
total number of cf enq holders	236	0.08	0.00	0.04	0.01	0.03	0.05
total number of times SMON posted	201	0.07	0.00	0.04	0.01	0.03	0.04
transaction rollbacks	546	0.19	0.01	0.10	0.00	0.09	0.10
undo change vector size	354,901,832	126,070.87	4,839.72	63,035.43	5,305.37	59,283.97	66,786.90
user I/O wait time	8,163,679	2,899.97	111.33	1,449.98	129.73	1,358.25	1,541.72
user calls	95,801,908	34,031.47	1,306.43	17,015.73	1,454.92	15,986.95	18,044.51
user commits	71,077	25.25	0.97	12.62	1.40	11.64	13.61
user logons cumulative	595	0.21	0.01	0.11	0.01	0.10	0.11
user logouts cumulative	511	0.18	0.01	0.09	0.01	0.08	0.10
user rollbacks	2,254	0.80	0.03	0.40	0.03	0.38	0.42
workarea executions - optimal	14,466,841	5,139.02	197.28	2,569.51	318.25	2,344.47	2,794.55
write clones created in background	1	0.00	0.00	0.00		0.00	0.00
write clones created in foreground	110	0.04	0.00	0.02	0.01	0.01	0.02

Back to Global Activity Statistics
Back to Top

Global Messaging Statistics (Global)

per Second Average - average of per-instance per Second rates
per Second Std Dev - standard deviation of per-instance per Second rates
per Second Min - minium of per-instance per Second rates
per Second Max - maximum of per-instance per Second rates

Statistic	Total	per Second	per Trans	Average	Std Dev	Min	Max
				per Second
acks for commit broadcast(actual)	47,326	16.81	0.65	8.41	0.42	8.11	8.70
acks for commit broadcast(logical)	49,024	17.41	0.67	8.71	0.43	8.40	9.01
broadcast msgs on commit(actual)	49,025	17.42	0.67	8.71	0.43	8.40	9.01
broadcast msgs on commit(logical)	60,016	21.32	0.82	10.66	0.53	10.28	11.04
broadcast msgs on commit(wasted)	3,502	1.24	0.05	0.62	0.04	0.59	0.65
gcs assume no cvt	270,117	95.95	3.68	47.98	2.87	45.95	50.00
gcs ast xid	112	0.04	0.00	0.02	0.00	0.02	0.02
gcs blocked converts	504,290	179.14	6.88	89.57	9.06	83.16	95.98
gcs blocked cr converts	121,337	43.10	1.65	21.55	4.66	18.26	24.84
gcs compatible basts	2,492	0.89	0.03	0.44	0.02	0.43	0.45
gcs compatible cr basts (global)	11,575	4.11	0.16	2.06	0.88	1.44	2.67
gcs compatible cr basts (local)	53,561	19.03	0.73	9.51	0.41	9.22	9.80
gcs dbwr flush pi msgs	101,723	36.13	1.39	18.07	4.61	14.80	21.33
gcs dbwr write request msgs	73,781	26.21	1.01	13.10	0.29	12.90	13.31
gcs force cr block only	5	0.00	0.00	0.00		0.00	0.00
gcs immediate (compatible) converts	20,302	7.21	0.28	3.61	0.07	3.56	3.66
gcs immediate (null) converts	179,473	63.75	2.45	31.88	0.89	31.25	32.51
gcs immediate cr (compatible) converts	44	0.02	0.00	0.01	0.01	0.00	0.01
gcs immediate cr (null) converts	141,827	50.38	1.93	25.19	0.36	24.93	25.45
gcs indirect ast	163,715	58.16	2.23	29.08	3.57	26.56	31.60
gcs indirect fg ast	163,715	58.16	2.23	29.08	3.57	26.56	31.60
gcs lms write request msgs	15,893	5.65	0.22	2.82	1.29	1.91	3.74
gcs msgs process time(ms)	65,652	23.32	0.90	11.66	0.16	11.55	11.77
gcs msgs received	1,492,413	530.15	20.35	265.07	0.99	264.37	265.77
gcs new served by master	29,950	10.64	0.41	5.32	0.83	4.74	5.90
gcs out-of-order msgs	1	0.00	0.00	0.00		0.00	0.00
gcs pings refused	349	0.12	0.00	0.06	0.00	0.06	0.06
gcs queued converts	212	0.08	0.00	0.04	0.00	0.04	0.04
gcs refuse xid	112	0.04	0.00	0.02	0.00	0.02	0.02
gcs side channel msgs actual	37,202	13.22	0.51	6.61	0.04	6.58	6.63
gcs side channel msgs logical	828,776	294.40	11.30	147.20	1.94	145.83	148.57
gcs undo cr	3,130	1.11	0.04	0.56	0.11	0.48	0.64
gcs write notification msgs	4,281	1.52	0.06	0.76	0.12	0.68	0.84
gcs writes refused	478	0.17	0.01	0.08	0.01	0.08	0.09
ges msgs process time(ms)	648	0.23	0.01	0.12	0.01	0.11	0.12
ges msgs received	26,181	9.30	0.36	4.65	0.00	4.65	4.65
global posts queue time	10	0.00	0.00	0.00	0.00	0.00	0.00
global posts queued	16	0.01	0.00	0.00	0.00	0.00	0.00
global posts requested	18	0.01	0.00	0.00	0.00	0.00	0.00
global posts sent	16	0.01	0.00	0.00	0.00	0.00	0.00
implicit batch messages received	88,232	31.34	1.20	15.67	0.40	15.39	15.95
implicit batch messages sent	88,232	31.34	1.20	15.67	0.40	15.39	15.95
messages flow controlled	15,699	5.58	0.21	2.79	0.43	2.48	3.10
messages queue sent actual	543,603	193.10	7.41	96.55	0.45	96.23	96.87
messages queue sent logical	201,604	71.62	2.75	35.81	1.52	34.73	36.88
messages received actual	1,384,610	491.85	18.88	245.93	1.87	244.60	247.25
messages received logical	1,518,594	539.45	20.71	269.72	0.99	269.03	270.42
messages sent directly	794,045	282.07	10.83	141.03	1.83	139.74	142.33
messages sent indirectly	620,857	220.55	8.47	110.27	0.08	110.22	110.33
messages sent not implicit batched	1	0.00	0.00	0.00		0.00	0.00
messages sent pbatched	143,028	50.81	1.95	25.40	1.98	24.00	26.81
msgs causing lmd to send msgs	12,364	4.39	0.17	2.20	0.19	2.06	2.33
msgs causing lms(s) to send msgs	42,208	14.99	0.58	7.50	1.37	6.53	8.46
msgs received queue time (ms)	16,634	5.91	0.23	2.95	0.08	2.90	3.01
msgs received queued	1,518,594	539.45	20.71	269.72	0.99	269.03	270.42
msgs sent queue time (ms)	30,345	10.78	0.41	5.39	0.92	4.74	6.04
msgs sent queue time on ksxp (ms)	2,267,975	805.65	30.93	402.82	33.43	379.19	426.46
msgs sent queued	655,915	233.00	8.94	116.50	0.73	115.98	117.02
msgs sent queued on ksxp	1,384,537	491.83	18.88	245.91	1.86	244.60	247.22
process batch messages received	95,817	34.04	1.31	17.02	1.11	16.23	17.80
process batch messages sent	121,356	43.11	1.65	21.55	2.28	19.94	23.17

Back to Global Activity Statistics
Back to Top

System Statistics (Absolute Values)

I#	Begin	End	Begin	End	Begin	End
	Sessions		Open Cursors		Session Cached Cursors
1	122	174	507	1,199	164,932	199,744
2	120	161	463	972	177,824	210,819
Sum	242	335	970	2,171	342,756	410,563
Avg	121	168	485	1,086	171,378	205,282
Std	1	9	31	161	9,116	7,831

Back to Global Activity Statistics
Back to Top

I/O Statistics

IOStat by Function (per Second)
IOStat by File Type (per Second)
Segment Statistics (Global)

IOStat by Function (per Second)

Total Reads includes all Functions: Buffer Cache, Direct Reads, ARCH, Data Pump, Others, RMAN, Recovry, Streams/AQ and XDB
Total Writes includes all Functions: DBWR, Direct Writes, LGWR, ARCH, Data Pump, Others, RMAN, Recovry, Streams/AQ and XDB

I#	Total	Buffer Cache	Direct Reads	Total	DBWR	Direct Writes	LGWR	Total	Buffer Cache	Direct Reads	Total	DBWR	Direct Writes	LGWR
	Reads MB/sec			Writes MB/sec				Reads requests/sec			Writes requests/sec
1	10.39	10.35	0.00	0.91	0.56	0.00	0.34	1,326.94	1,323.85	0.00	75.16	48.89	0.00	25.28
2	9.65	9.60	0.00	1.09	0.69	0.00	0.38	1,231.66	1,228.95	0.00	91.74	63.20	0.00	27.61
Sum	20.04	19.95	0.00	2.00	1.25	0.00	0.72	2,558.59	2,552.80	0.00	166.90	112.08	0.01	52.89
Avg	10.02	9.97	0.00	1.00	0.62	0.00	0.36	1,279.30	1,276.40	0.00	83.45	56.04	0.00	26.44

Back to I/O Statistics
Back to Top

IOStat by File Type (per Second)

Total Reads includes all Filetypes: Data File, Temp File, Archive Log, Backups, Control File, Data Pump Dump File, Flashback Log, Log File, Other, etc
Total Writes includes all Filetypes: Data File, Temp File, Log File, Archive Log, Backup, Control File, Data Pump Dump File, Flasbachk Log, Log File, Other, etc

I#	Total	Data File	Temp File	Total	Data File	Temp File	Log File	Total	Data File	Temp File	Total	Data File	Temp File	Log File
	Reads MB/sec			Writes MB/sec				Reads requests/sec			Writes requests/sec
1	10.39	10.35	0.00	0.91	0.56	0.00	0.34	1,326.98	1,323.90	0.00	75.16	48.89	0.00	25.28
2	9.65	9.60	0.00	1.09	0.69	0.00	0.38	1,231.72	1,229.02	0.00	91.75	63.21	0.00	27.61
Sum	20.04	19.95	0.00	2.00	1.25	0.00	0.72	2,558.70	2,552.92	0.00	166.90	112.10	0.00	52.89
Avg	10.02	9.97	0.00	1.00	0.62	0.00	0.36	1,279.35	1,276.46	0.00	83.45	56.05	0.00	26.44

Back to I/O Statistics
Back to Top

Segment Statistics (Global)

% Total shows % of statistic for each segment compared to the global cluster-wide total (logical reads, physical reads, gc [cr/cu] blocks [recv/serv])
% Capture shows % of statistic for each segment compared to the total captured by AWR for all segments during the snapshot interval
Captured Segments account for 99.3% of Total Logical Reads: 9,456,170,649
Captured Segments account for 98.0% of Total Physical Reads: 7,199,316
Captured Segments account for 98.0% of Total Physical Read Requests: 7,197,965
Captured Segments account for 98.0% of Total UnOptimized Read Requests: 7,197,965
Captured Segments account for 0.0% of Total Optimized Read Requests: 1
Captured Segments account for 0.0% of Total Direct Physical Reads: 1
Captured Segments account for 46.8% of Total Physical Writes: 450,015
Captured Segments account for 51.3% of Total Physical Write Requests: 316,053
Captured Segments account for 98.5% of Total Direct Physical Writes: 605
Captured Segments account for 0.0% of Total Table Scans: 66
Captured Segments account for 76.4% of Total CR Blocks Received: 124,467
Captured Segments account for 76.7% of Total Current Blocks Received: 540,655
Captured Segments account for 76.4% of Total CR Blocks Served: 124,467
Captured Segments account for 76.7% of Total Current Blocks Served: 540,657

Statistic	Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Value	%Total	%Capture
buffer busy waits	SGPM	IDX_A	LOC_A_PAY_FLOW_ACNO	PMAX	INDEX PARTITION	999		42.28
buffer busy waits	SGPM	DATA_MAN	LOC_A_PAY_FLOW_LONG2		INDEX	633		26.79
buffer busy waits	SGPM	IDX_A	IDX_A_PREPAY_FLOW_CONS_NO1		INDEX	375		15.87
buffer busy waits	SGPM	DATA_E	A_ACCT_BAL	P1240201	TABLE PARTITION	180		7.62
buffer busy waits	SGPM	DATA_MAN	PK_A_PREPAY_FLOW_R01_RED1		INDEX	176		7.45
db block changes	SGPM	DATA_E	A_ACCT_BAL	P1240201	TABLE PARTITION	123,008		31.74
db block changes	SGPM	DATA_A	A_PAY_FLOW	PMAX	TABLE PARTITION	75,792		19.56
db block changes	SGPM	IDX_A	LOC_A_PAY_FLOW_ACNO	PMAX	INDEX PARTITION	63,248		16.32
db block changes	SGPM	IDX_A	IDX_A_PREPAY_FLOW_R01_ACCT_NO1		INDEX	63,104		16.28
db block changes	SGPM	IDX_A	IDX_A_PREPAY_FLOW_R0_CHARGE_I1		INDEX	62,368		16.09
gc buffer busy	AMBER	DATA_P	NDX_INDY_USER_PROFILE		INDEX	4,004		36.17
gc buffer busy	SGPM	IDX_A	IDX_A_PREPAY_FLOW_CONS_NO1		INDEX	2,245		20.28
gc buffer busy	SGPM	DATA_A	A_INV_IO		TABLE	1,703		15.38
gc buffer busy	WF_AMBER	DATA_P	INDYWF_WORKLIST_CUR		TABLE	1,679		15.17
gc buffer busy	SGPM	IDX_A	LOC_A_PAY_FLOW_ACNO	PMAX	INDEX PARTITION	1,440		13.01
gc cr blocks received	SGPM	DATA_E	A_ACCT_BAL	P1240201	TABLE PARTITION	27,365	21.99	47.78
gc cr blocks received	OWF_MGR	USERS	WF_TASK		TABLE	15,936	12.80	27.82
gc cr blocks received	SGPM	IDX_S	PK_S_APP_CONS_NO		INDEX	7,143	5.74	12.47
gc cr blocks received	SGPM	IDX_S	IDX_S_APP_PAYMENT_INS_ID		INDEX	3,421	2.75	5.97
gc cr blocks received	SGPM	IDX_S	IDX_S_APP_NATURAL_INS_ID		INDEX	3,410	2.74	5.95
gc cr blocks served	SGPM	DATA_E	A_ACCT_BAL	P1240201	TABLE PARTITION	27,365	21.99	47.78
gc cr blocks served	OWF_MGR	USERS	WF_TASK		TABLE	15,936	12.80	27.82
gc cr blocks served	SGPM	IDX_S	PK_S_APP_CONS_NO		INDEX	7,143	5.74	12.47
gc cr blocks served	SGPM	IDX_S	IDX_S_APP_PAYMENT_INS_ID		INDEX	3,421	2.75	5.97
gc cr blocks served	SGPM	IDX_S	IDX_S_APP_NATURAL_INS_ID		INDEX	3,410	2.74	5.95
gc cu blocks received	SGPM	IDX_A	IDX_A_PREPAY_FLOW_R0_CHARGE_I1		INDEX	37,509	6.94	23.51
gc cu blocks received	SGPM	DATA_MAN	PK_A_PREPAY_FLOW_R01_RED1		INDEX	36,633	6.78	22.96
gc cu blocks received	SGPM	IDX_A	IDX_A_PREPAY_FLOW_R01_ACCT_NO1		INDEX	31,379	5.80	19.67
gc cu blocks received	SGPM	IDX_A	IDX_A_PREPAY_FLOW_CONS_NO1		INDEX	27,221	5.03	17.06
gc cu blocks received	SGPM	DATA_E	A_ACCT_BAL	P1240201	TABLE PARTITION	26,797	4.96	16.80
gc cu blocks served	SGPM	IDX_A	IDX_A_PREPAY_FLOW_R0_CHARGE_I1		INDEX	37,509	6.94	23.51
gc cu blocks served	SGPM	DATA_MAN	PK_A_PREPAY_FLOW_R01_RED1		INDEX	36,633	6.78	22.96
gc cu blocks served	SGPM	IDX_A	IDX_A_PREPAY_FLOW_R01_ACCT_NO1		INDEX	31,379	5.80	19.67
gc cu blocks served	SGPM	IDX_A	IDX_A_PREPAY_FLOW_CONS_NO1		INDEX	27,221	5.03	17.06
gc cu blocks served	SGPM	DATA_E	A_ACCT_BAL	P1240201	TABLE PARTITION	26,797	4.96	16.80
itl waits	OWF_MGR	USERS	WF_ITEMS_N2		INDEX	8		24.24
itl waits	SGPM	IDX_S	IDX_S_APP_HANDLE_TIME		INDEX	6		18.18
itl waits	SGPM	IDX_A	IDX_A_PREPAY_FLOW_R0_CHARGE_I1		INDEX	5		15.15
itl waits	SGPM	DATA_MAN	PK_A_PREPAY_FLOW_R01_RED1		INDEX	2		6.06
itl waits	SGPM	IDX_A	IDX_A_PREPAY_FLOW_CONS_NO1		INDEX	2		6.06
itl waits	WF_AMBER	IDX_P	IDX_INSTANCES_BEGIN_DATE		INDEX	2		6.06
itl waits	AMBER	DATA_P	IDX_LOG_USER_ID		INDEX	1		3.03
itl waits	OWF_MGR	USERS	WF_ITEM_ACTIVITY_STATUSES_N2		INDEX	1		3.03
itl waits	SGPM	IDX_A	IDX_A_PREPAY_FLOW_R01_ACCT_NO1		INDEX	1		3.03
itl waits	SGPM	IDX_S	FK_S_APP_ACCT_S_APP_PAYMENT_RE		INDEX	1		3.03
itl waits	SGPM	IDX_S	FK_S_APP_NATURAL_INFO_S_APP_AC		INDEX	1		3.03
itl waits	SGPM	IDX_S	PK_S_APP_NATURAL_INFO		INDEX	1		3.03
itl waits	WF_AMBER	IDX_P	IDX_USER_CUR_TASKID		INDEX	1		3.03
itl waits	WF_AMBER	IDX_P	IDX_WORKLIST_CUR_BEGIN_DATE		INDEX	1		3.03
logical reads	SGPM	DATA_P	P_USER_ROLE_RELA		TABLE	8,480,953,840	89.69	93.91
logical reads	SGPM	IDX_P	FK_SP_ROLE_USER_ROLE		INDEX	284,205,792	3.01	3.15
logical reads	SGPM	DATA_MAN	IDX_2013010303		INDEX	96,673,856	1.02	1.07
logical reads	AMBER	DATA_P	INDY_USER		TABLE	88,137,360	0.93	0.98
logical reads	SGPM_OUT	DATA_OUT	P_MID_RCVBL_YSTAT		TABLE	80,540,544	0.85	0.89
physical reads	SGPM	DATA_MAN	P_E_PL_ATMTM		TABLE	2,820,686	39.18	40.64
physical reads	SGPM	DATA_MAN	P_E_PL_ATMTE		TABLE	2,820,237	39.17	40.63
physical reads	SGPM	DATA_MAN	P_E_PL_ATMTM_IDX		INDEX	633,601	8.80	9.13
physical reads	SGPM	DATA_MAN	P_E_PL_ATMTE_IDX		INDEX	633,481	8.80	9.13
physical reads	SGPM	DATA_MAN	PK_A_PAY_FLOW_R01_RED		INDEX	33,114	0.46	0.48
physical read requests	SGPM	DATA_MAN	P_E_PL_ATMTM		TABLE	2,820,713	39.19	40.64
physical read requests	SGPM	DATA_MAN	P_E_PL_ATMTE		TABLE	2,820,242	39.18	40.63
physical read requests	SGPM	DATA_MAN	P_E_PL_ATMTM_IDX		INDEX	633,604	8.80	9.13
physical read requests	SGPM	DATA_MAN	P_E_PL_ATMTE_IDX		INDEX	633,483	8.80	9.13
physical read requests	SGPM	DATA_MAN	PK_A_PAY_FLOW_R01_RED		INDEX	33,114	0.46	0.48
physical writes	SGPM	DATA_MAN	PK_A_PAY_FLOW_R01_RED		INDEX	35,484		36.09
physical writes	SGPM	IDX_P	IDX_P_SPECIAL_PRIMARY_KEY		INDEX	29,885		30.40
physical writes	SGPM	IDX_P	PK_P_SPECIAL_MAINT_LOG		INDEX	17,753		18.06
physical writes	SGPM	DATA_C	C_CONS	P1240201	TABLE PARTITION	8,058		8.20
physical writes	SGPM	IDX_C	IDX_C_CONS_CONS_NO		INDEX	7,133		7.26
physical writes direct	SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_3349992778_0	TABLE PARTITION	596		100.00
physical write requests	SGPM	DATA_MAN	PK_A_PAY_FLOW_R01_RED		INDEX	35,485	11.23	44.43
physical write requests	SGPM	IDX_P	IDX_P_SPECIAL_PRIMARY_KEY		INDEX	23,136	7.32	28.97
physical write requests	SGPM	DATA_C	C_CONS	P1240201	TABLE PARTITION	7,237	2.29	9.06
physical write requests	SGPM	IDX_C	IDX_C_CONS_CONS_NO		INDEX	7,131	2.26	8.93
physical write requests	SGPM	IDX_P	PK_P_SPECIAL_MAINT_LOG		INDEX	6,872	2.17	8.60
row lock waits	SGPM	DATA_E	A_ACCT_BAL	P1240201	TABLE PARTITION	851		40.89
row lock waits	SGPM	IDX_A	LOC_A_PAY_FLOW_ACNO	PMAX	INDEX PARTITION	495		23.79
row lock waits	SGPM	IDX_A	IDX_A_PREPAY_FLOW_CONS_NO1		INDEX	376		18.07
row lock waits	SGPM	IDX_A	IDX_A_PREPAY_FLOW_R01_ACCT_NO1		INDEX	181		8.70
row lock waits	SGPM	DATA_MAN	LOC_A_PAY_FLOW_LONG2		INDEX	178		8.55

Back to I/O Statistics
Back to Top

Library Cache Activity

Summarized for all instances in the report
"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations	GES Lock Requests	GES Pin Requests	GES Pin Releases
ACCOUNT_STATUS	1,785	0.00	0		0	0	1,785	0	0
APP CONTEXT	2	0.00	14	0.00	0	0	0	0	0
BODY	10,324	0.00	3,776,273	-0.00	0	0	0	3,659,158	3,659,158
CONTEXT POLICY	8,035	0.00	8,035	0.00	0	0	8,035	8,035	8,035
DBLINK	1,787	0.00	0		0	0	1,787	0	0
EDITION	618	0.00	1,213	0.00	0	0	618	618	618
INDEX	12	0.00	12	0.00	0	0	12	12	12
QUEUE	988	0.00	6,318	0.00	0	0	3,442	6,318	6,318
RULESET	0		18	0.00	0	0	0	18	18
SCHEMA	597	0.00	0		0	0	595	0	0
SQL AREA	46,728	0.04	49,268,618	-0.02	459	456	0	0	0
SQL AREA BUILD	480	3.75	0		0	0	0	0	0
SQL AREA STATS	479	4.38	479	4.38	0	0	0	0	0
TABLE/PROCEDURE	173,580	0.00	4,592,798	-0.00	1	0	280,494	4,474,951	4,474,951
TRANSFORMATION	282	0.00	282	0.00	0	0	282	282	282
TRIGGER	188	0.00	21,624	0.00	0	0	0	21,608	21,608

Memory Statistics

PGA Aggregate Target Statistics
Process Memory Summary

PGA Aggregate Target Statistics

all stats are reported in MegaBytes

I#	Begin	End	Begin	End	Begin	End	Begin	End	Begin	End	Begin	End
	PGA Aggr Target		Auto PGA Target		PGA Mem Alloc		Auto Workareas		Manual Workarea		Global Mem Bound
1	28,800.00	28,544.00	25,558.57	25,085.71	489.91	822.73	0.00	0.00	0.00	0.00	1,024.00	1,024.00
2	20,608.00	20,480.00	18,200.00	17,928.90	470.77	688.26	0.00	0.00	0.00	0.00	1,024.00	1,024.00

Back to Memory Statistics
Back to Top

Process Memory Summary

Max Alloc is Maximum PGA allocation size at snapshot time
Hist Alloc is the Historical Maximum Allocation for still-connected processes
Num Procs or Allocs: For Begin/End snapshot lines, it is the number of processes For Category lines, it is the number of allocations
Allocation sizes are displayed in MegaBytes
ordered by instance, Allocated Total (End) desc

I#	Category	Begin	End	Begin	End	Begin	End	Begin	End	Begin	End	Begin	End	Begin	End	Begin	End
		Allocated		Used		Avg Alloc		Std Dev		Max Alloc		Hist Max		Num Procs		Num Allocs
1	Other	391.07	581.95			3.13	3.29	4.13	3.65	26.70	26.45	29.50	28.88	125	177	125	177
1	PL/SQL	51.06	131.69	20.89	66.93	0.42	0.75	1.05	1.34	4.74	4.74	13.41	13.42	123	175	123	175
1	Freeable	46.00	85.38	0.00	0.00	1.07	0.97	0.80	0.69	4.19	4.19			43	88	43	88
1	SQL	1.81	23.76	0.08	0.18	0.02	0.16	0.04	0.24	0.24	0.61	22.30	21.60	100	152	93	145
2	Other	377.85	504.55			3.07	3.08	3.91	3.54	24.83	24.83	24.83	24.83	123	164	123	164
2	PL/SQL	47.86	94.96	29.43	44.23	0.40	0.59	1.00	1.19	3.24	3.24	13.39	13.42	121	162	121	162
2	Freeable	42.88	70.31	0.00	0.00	1.00	0.93	0.65	0.70	3.94	3.94			43	76	43	76
2	SQL	2.21	18.48	0.75	0.90	0.02	0.13	0.07	0.23	0.64	0.64	20.03	20.20	98	139	93	134

Back to Memory Statistics
Back to Top

Supplemental Information

init.ora Parameters
init.ora Multi-valued Parameters
Complete List of SQL Text

init.ora Parameters

'*' indicates same value across all instances

Parameter Name	I#	Begin value
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	1
instance_number	2	2
local_listener	1	(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.52)(PORT=1521))
local_listener	2	(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.55)(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	1
thread	2	2
undo_tablespace	1	UNDOTBS1
undo_tablespace	2	UNDOTBS2

Back to Supplemental Information
Back to Top

init.ora Multi-valued Parameters

This section only displays parameters that have more one value
'*' indicates same value across all instances
'(NULL)' indicates that the parameter value was not set
A blank value in the End Snapshot indicates the value is the same as the Begin Snapshot

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

Back to Supplemental Information
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

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

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

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

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

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')

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)

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

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'

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

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

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

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

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

Back to Supplemental Information
Back to Top

End of Report

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
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
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
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
5xwhyp8wvvjwk	BEGIN OWF_MGR.WF_ENGINE.STARTPROCESS(:1, :2);END;
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')
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)
9t6habqtx6vzg	begin pkg_ca_counter.p_ca_counter_para(:1, :2, :3, :4, :5, :6, :7, :8); end;
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'
bxctd2r3kgjyb	SELECT PL_AMT_ID FROM P_E_PL_ATMTE WHERE ID = :B2 + :B1 *400
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
ctpdw3pywk3k9	begin pkg_ca_lookup.p_get_owecount_group_empno(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13); end;
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
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