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
381251694	AAADB	YES	8192	17060	17061	4	4	4	4	7,616.70	60.20

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	aaadb1	aaadb01.shmcc.com	12-Dec-11 14:33	06-Feb-12 21:59	06-Feb-12 23:00	11.2.0.1.0	60.10	35.15	1,352.45	0.58	Linux x86 64-bit
2	aaadb2	aaadb02.shmcc.com	02-Dec-11 03:37	06-Feb-12 21:59	06-Feb-12 23:00	11.2.0.1.0	60.08	2,543.68	1,603.37	42.34	Linux x86 64-bit
3	aaadb3	aaadb03.shmcc.com	02-Dec-11 03:37	06-Feb-12 22:00	06-Feb-12 23:00	11.2.0.1.0	60.10	2,330.68	1,603.37	38.78	Linux x86 64-bit
4	aaadb4	aaadb04.shmcc.com	02-Dec-11 08:05	06-Feb-12 22:00	06-Feb-12 23:00	11.2.0.1.0	60.08	2,707.19	1,598.90	45.06	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	Begin	Begin	Begin	Begin	Begin	Begin	Log Buffer
	Memory Target	Sga Target	DB Cache	Shared Pool	Large Pool	Java Pool	Streams Pool	PGA Target
1	51,712	23,296	16,384	5,632	256	256	512	28,416	22.22
2	51,712	29,184	22,272	5,888	256	256	256	22,528	22.22
3	51,712	19,200	12,288	5,632	256	256	512	32,512	22.22
4	51,712	30,976	23,296	6,400	256	256	512	20,736	22.22
Avg	51,712	25,664	18,560	5,888	256	256	448	26,048	22.22
Min	51,712	19,200	12,288	5,632	256	256	256	20,736	22.22
Max	51,712	30,976	23,296	6,400	256	256	512	32,512	22.22

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	16	8	2	0.34	0.44	2.80	1.94	0.56	0.01	97.20	1,873.57	65,108.32	66,981.89	72,292.73
2	16	8	2	3.98	4.87	24.12	19.58	2.41	0.01	75.88	16,141.78	50,776.16	66,917.94	72,292.73
3	16	8	2	5.53	5.18	26.31	21.22	2.64	0.01	73.69	17,623.07	49,369.03	66,992.10	72,292.73
4	16	8	2	6.99	6.22	27.14	22.41	2.45	0.14	72.86	18,175.98	48,790.23	66,966.21	72,292.73
Sum											53,814.40	214,043.74	267,858.14

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	2,109.28	561.05	726.47	2.86	0.00	19.63	1,983.20	657.41
2	152,620.87	13,565.18	117,589.02	11.36	1.39	44.96	17,447.03	1,446.05
3	139,840.70	14,824.15	97,412.15	6.99	2.09	18.85	16,200.97	1,601.24
4	162,431.30	15,491.04	124,437.00	5.12	1.37	0.77	15,190.30	1,579.98
Sum	457,002.15	44,441.42	340,164.65	26.33	4.86	84.22	50,821.50	5,284.68
Avg	114,250.54	11,110.35	85,041.16	6.58	1.22	21.05	12,705.38	1,321.17
Std	75,330.80	7,078.06	57,368.41	3.61	0.88	18.16	7,207.46	447.81

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	0.46	26.60	34.44	0.14	3.90	33.15
2	33.40	8.89	77.05	0.01	34.33	8.29
3	30.60	10.60	69.66	0.00	31.88	9.88
4	35.54	9.54	76.61	0.00	29.89	10.40
Avg	25.00	13.91	64.44	0.04	25.00	15.43

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
	10.88	0.00	0.08	11.96	16.87	1.97	0.03	0.04	36.54	9.72

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	71.91	5.95	7.63	0.67	1,185.18	0.71	2.27	1.10	61.91	561.05	2,109.28
2	14,167.49	0.05	136.46	25,298.57	22,972.87	2,570.18	32.40	55.47	55,140.56	13,565.18	152,620.87
3	19,855.15	0.10	90.78	3,003.96	28,655.66	3,703.09	60.54	62.88	52,764.41	14,824.15	139,840.70
4	15,629.07	3.65	140.28	26,375.88	24,284.85	2,743.05	60.02	59.83	59,005.12	15,491.04	162,431.30
Sum	49,723.62	9.75	375.14	54,679.08	77,098.56	9,017.04	155.23	179.28	166,972.01	44,441.42	457,002.15
Avg	12,430.90	2.44	93.79	13,669.77	19,274.64	2,254.26	38.81	44.82	41,743.00	11,110.35	114,250.54
Std	8,585.03	2.88	61.68	14,110.02	12,301.91	1,582.86	27.68	29.31	27,906.16	7,078.06	75,330.80

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	Sys I/O	Other	Applic	Commit	Network	Concurcy	Config	Cluster	DB CPU	% Total DB time
1	3.41	0.28	0.36	0.03	56.19	0.03	0.11	0.05	2.94	26.60	0.46
2	9.28	0.00	0.09	16.58	15.05	1.68	0.02	0.04	36.13	8.89	33.40
3	14.20	0.00	0.06	2.15	20.49	2.65	0.04	0.04	37.73	10.60	30.60
4	9.62	0.00	0.09	16.24	14.95	1.69	0.04	0.04	36.33	9.54	35.54
Avg	9.13	0.07	0.15	8.75	26.67	1.51	0.05	0.04	28.28	13.91

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)
*	Commit	log file sync	2,036,395	0.00	77,100.42	37.86	16.87	33.83	20.40	39.81	9.02	4
	Cluster	gc buffer busy acquire	2,327,633	0.72	65,187.15	28.01	14.26	23.04	8.11	28.60	9.96	4
	Application	enq: TX - row lock contention	259,441	0.00	54,259.18	209.14	11.87	135.22	0.18	237.88	120.21	4
	User I/O	cell single block physical read	13,975,224	0.00	49,672.05	3.55	10.87	3.34	2.73	3.63	0.42	4
	Cluster	gc buffer busy release	799,208	0.04	44,838.21	56.10	9.81	46.78	20.17	60.40	18.73	4
		DB CPU			44,441.42		9.72					4
	Cluster	gc current block busy	857,972	0.00	36,319.92	42.33	7.95	39.74	31.96	42.73	5.22	4
	System I/O	db file parallel write	1,662,069	0.00	15,110.15	9.09	3.31	8.89	6.53	12.37	2.56	4
	Cluster	gc cr block busy	395,936	0.00	13,976.77	35.30	3.06	34.71	32.88	35.64	1.26	4
	Other	gcs log flush sync	26,952,121	0.50	12,155.87	0.45	2.66	0.48	0.44	0.58	0.06	4
1	Commit	log file sync	58,099	0.00	1,185.30	20.40	56.19
	System I/O	log file parallel write	48,953	0.00	627.76	12.82	29.76
		DB CPU			561.05		26.60
	System I/O	db file parallel write	15,413	0.00	116.19	7.54	5.51
	User I/O	cell single block physical read	28,845	0.00	78.68	2.73	3.73
	System I/O	control file parallel write	1,721	0.00	67.82	39.41	3.22
	Cluster	gc cr block busy	1,384	0.00	45.51	32.88	2.16
	System I/O	control file sequential read	25,103	0.00	18.65	0.74	0.88
	Cluster	gc cr block 3-way	23,155	0.00	4.78	0.21	0.23
	Other	DFS lock handle	12,103	29.12	4.43	0.37	0.21
2	Application	enq: TX - row lock contention	107,096	0.00	25,193.43	235.24	16.51
	Commit	log file sync	608,688	0.00	22,973.64	37.74	15.05
	Cluster	gc buffer busy acquire	722,635	0.66	20,210.70	27.97	13.24
	Cluster	gc buffer busy release	277,281	0.01	16,468.74	59.39	10.79
	User I/O	cell single block physical read	4,078,260	0.00	14,149.06	3.47	9.27
		DB CPU			13,565.18		8.89
	Cluster	gc current block busy	278,202	0.00	11,876.40	42.69	7.78
	System I/O	db file parallel write	494,354	0.00	6,117.16	12.37	4.01
	Cluster	gc cr block busy	128,687	0.00	4,562.83	35.46	2.99
	Other	gcs log flush sync	8,740,112	0.39	4,059.44	0.46	2.66
3	Commit	log file sync	719,889	0.00	28,656.54	39.81	20.49
	Cluster	gc buffer busy acquire	819,846	0.89	22,519.71	27.47	16.10
	User I/O	cell single block physical read	5,467,338	0.00	19,837.37	3.63	14.19
		DB CPU			14,824.15		10.60
	Cluster	gc current block busy	287,041	0.00	11,935.61	41.58	8.54
	Cluster	gc buffer busy release	238,223	0.07	11,233.87	47.16	8.03
	System I/O	db file parallel write	520,110	0.00	4,749.66	9.13	3.40
	Cluster	gc cr block busy	134,696	0.00	4,693.63	34.85	3.36
	Other	gcs log flush sync	9,172,694	0.64	4,080.43	0.44	2.92
	System I/O	log file parallel write	212,580	0.00	3,156.57	14.85	2.26
4	Application	enq: TX - row lock contention	110,221	0.00	26,218.85	237.88	16.14
	Commit	log file sync	649,719	0.00	24,284.94	37.38	14.95
	Cluster	gc buffer busy acquire	785,122	0.61	22,456.50	28.60	13.83
	Cluster	gc buffer busy release	283,702	0.03	17,135.56	60.40	10.55
	User I/O	cell single block physical read	4,400,781	0.00	15,606.94	3.55	9.61
		DB CPU			15,491.04		9.54
	Cluster	gc current block busy	292,686	0.00	12,506.53	42.73	7.70
	Cluster	gc cr block busy	131,169	0.00	4,674.81	35.64	2.88
	System I/O	db file parallel write	632,192	0.00	4,127.15	6.53	2.54
	Other	gcs log flush sync	9,036,936	0.47	4,014.63	0.44	2.47

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)
*	Commit	log file sync	2,036,383	0.00	77,098.56	37.86	16.87	33.83	20.40	39.81	9.02	4
	Cluster	gc buffer busy acquire	2,327,630	0.72	65,187.08	28.01	14.26	23.04	8.11	28.60	9.96	4
	Application	enq: TX - row lock contention	259,441	0.00	54,259.18	209.14	11.87	135.22	0.18	237.88	120.21	4
	User I/O	db file scattered read	5,162,883	0.00	51,715.91	10.02	11.32	4.73	1.53	13.60	5.91	4
	User I/O	cell single block physical read	13,963,035	0.00	49,638.96	3.56	10.86	3.32	2.62	3.63	0.47	4
	Cluster	gc buffer busy release	799,208	0.04	44,838.21	56.10	9.81	46.78	20.17	60.40	18.73	4
		DB CPU			44,441.42		9.72					4
	Cluster	gc current block busy	857,948	0.00	36,318.83	42.33	7.95	39.78	32.11	42.73	5.14	4
	User I/O	direct path read temp	3,506,401	0.00	23,743.66	6.77	5.20	2.95	1.31	6.77	2.57	4
	Cluster	gc cr block busy	395,563	0.00	13,965.31	35.30	3.06	34.71	32.88	35.64	1.27	4
1	User I/O	direct path read temp	3,505,337	0.00	23,741.87	6.77	1125.59
	User I/O	cell list of blocks physical read	1,699,641	0.00	7,536.52	4.43	357.30
	Configuration	log buffer space	28,756	0.00	6,523.94	226.87	309.30
	Commit	log file sync	58,097	0.00	1,185.18	20.40	56.19
		DB CPU			561.05		26.60
	Other	enq: TS - contention	421	35.15	265.63	630.96	12.59
	User I/O	local write wait	16,304	0.00	151.54	9.29	7.18
	User I/O	cell single block physical read	27,214	0.00	71.40	2.62	3.38
	Other	name-service call wait	612	0.16	48.04	78.50	2.28
	Cluster	gc cr block busy	1,372	0.00	45.11	32.88	2.14
2	Application	enq: TX - row lock contention	107,096	0.00	25,193.43	235.24	16.51
	Commit	log file sync	608,684	0.00	22,972.87	37.74	15.05
	Cluster	gc buffer busy acquire	722,632	0.66	20,210.63	27.97	13.24
	Cluster	gc buffer busy release	277,281	0.01	16,468.74	59.39	10.79
	User I/O	cell single block physical read	4,075,044	0.00	14,140.83	3.47	9.27
		DB CPU			13,565.18		8.89
	Cluster	gc current block busy	278,198	0.00	11,876.31	42.69	7.78
	Cluster	gc cr block busy	128,410	0.00	4,554.84	35.47	2.98
	Cluster	gc domain validation	1,965	54.61	2,841.49	1446.05	1.86
	User I/O	cell smart table scan	3,626,278	51.56	2,625.42	0.72	1.72
3	User I/O	db file scattered read	3,590,667	0.00	48,838.72	13.60	34.92
	Commit	log file sync	719,885	0.00	28,655.66	39.81	20.49
	Cluster	gc buffer busy acquire	819,846	0.89	22,519.71	27.47	16.10
	User I/O	cell single block physical read	5,463,052	0.00	19,826.02	3.63	14.18
		DB CPU			14,824.15		10.60
	Cluster	gc current block busy	287,028	0.00	11,934.87	41.58	8.53
	Cluster	gc buffer busy release	238,223	0.07	11,233.87	47.16	8.03
	Cluster	gc cr block busy	134,634	0.00	4,691.30	34.84	3.35
	Application	enq: TX - row lock contention	42,121	0.00	2,846.90	67.59	2.04
	Concurrency	enq: TX - index contention	72,976	0.00	2,833.46	38.83	2.03
4	Application	enq: TX - row lock contention	110,221	0.00	26,218.85	237.88	16.14
	Commit	log file sync	649,717	0.00	24,284.85	37.38	14.95
	Cluster	gc buffer busy acquire	785,122	0.61	22,456.50	28.60	13.83
	Cluster	gc buffer busy release	283,702	0.03	17,135.56	60.40	10.55
	User I/O	cell single block physical read	4,397,725	0.00	15,600.71	3.55	9.60
		DB CPU			15,491.04		9.54
	Cluster	gc current block busy	292,680	0.00	12,506.31	42.73	7.70
	Configuration	log buffer space	31,954	0.00	5,508.20	172.38	3.39
	Cluster	gc cr block busy	131,147	0.00	4,674.06	35.64	2.88
	User I/O	cell smart table scan	9,644,983	51.44	3,974.67	0.41	2.45

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	db file parallel write	1,662,042	0.00	15,109.98	9.09	29.73	8.89	6.53	12.37	2.56	4
	Other	gcs log flush sync	26,952,115	0.50	12,155.88	0.45	23.92	0.48	0.44	0.58	0.06	4
	System I/O	log file parallel write	691,727	0.00	10,052.79	14.53	19.78	14.20	12.82	14.85	0.93	4
		background cpu time			5,284.68		10.40					4
	System I/O	log file sequential read	2,607	0.00	438.93	168.37	0.86	144.52	70.61	174.29	49.41	4
	System I/O	control file parallel write	7,601	0.00	300.03	39.47	0.59	39.66	37.45	42.61	2.15	4
	System I/O	Log archive I/O	1,689	0.00	155.24	91.91	0.31	80.78	47.60	96.59	22.39	4
	System I/O	control file sequential read	74,802	0.00	59.32	0.79	0.12	0.79	0.70	0.86	0.07	4
	Other	ASM file metadata operation	4,079	0.00	35.13	8.61	0.07	8.16	1.83	12.63	4.75	4
	User I/O	cell single block physical read	12,183	0.00	32.96	2.71	0.06	2.91	2.05	4.42	1.04	4
1		background cpu time			657.41		33.15
	System I/O	log file parallel write	48,951	0.00	627.64	12.82	31.65
	System I/O	db file parallel write	15,402	0.00	116.10	7.54	5.85
	System I/O	control file parallel write	1,721	0.00	67.82	39.41	3.42
	System I/O	control file sequential read	18,098	0.00	12.70	0.70	0.64
	User I/O	cell single block physical read	1,628	0.00	7.20	4.42	0.36
	Other	DFS lock handle	12,088	29.14	4.42	0.37	0.22
	System I/O	log file sequential read	25	0.00	1.77	70.61	0.09
	Other	ASM file metadata operation	776	0.00	1.42	1.83	0.07
	Other	gcs log flush sync	2,379	0.00	1.37	0.58	0.07
2	System I/O	db file parallel write	494,341	0.00	6,117.16	12.37	35.06
	Other	gcs log flush sync	8,740,402	0.39	4,059.53	0.46	23.27
	System I/O	log file parallel write	213,745	0.00	3,128.94	14.64	17.93
		background cpu time			1,446.05		8.29
	System I/O	log file sequential read	704	0.00	117.90	167.48	0.68
	System I/O	control file parallel write	2,377	0.00	89.02	37.45	0.51
	System I/O	Log archive I/O	478	0.00	42.32	88.53	0.24
	System I/O	control file sequential read	19,676	0.00	16.49	0.84	0.09
	User I/O	cell single block physical read	3,215	0.00	8.22	2.56	0.05
	Other	ASM file metadata operation	1,100	0.00	8.13	7.39	0.05
3	System I/O	db file parallel write	520,101	0.00	4,749.56	9.13	29.32
	Other	gcs log flush sync	9,172,272	0.64	4,080.32	0.44	25.19
	System I/O	log file parallel write	212,586	0.00	3,156.46	14.85	19.48
		background cpu time			1,601.24		9.88
	System I/O	log file sequential read	941	0.00	164.01	174.29	1.01
	System I/O	control file parallel write	1,759	0.00	68.88	39.16	0.43
	System I/O	Log archive I/O	590	0.00	53.33	90.39	0.33
	System I/O	control file sequential read	18,727	0.00	14.31	0.76	0.09
	Other	ASM file metadata operation	1,224	0.00	13.23	10.81	0.08
	User I/O	cell single block physical read	4,284	0.00	11.29	2.63	0.07
4	System I/O	db file parallel write	632,198	0.00	4,127.16	6.53	27.17
	Other	gcs log flush sync	9,037,062	0.47	4,014.65	0.44	26.43
	System I/O	log file parallel write	216,445	0.00	3,139.75	14.51	20.67
		background cpu time			1,579.98		10.40
	System I/O	log file sequential read	937	0.00	155.25	165.69	1.02
	System I/O	control file parallel write	1,744	0.00	74.31	42.61	0.49
	System I/O	Log archive I/O	613	0.00	59.21	96.59	0.39
	System I/O	control file sequential read	18,301	0.00	15.81	0.86	0.10
	Other	ASM file metadata operation	979	0.00	12.36	12.63	0.08
	User I/O	cell single block physical read	3,056	0.00	6.25	2.05	0.04

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	64,682,632	2,061,551	28,343	80,078	941,503	643,096	175,499	82,002	1,062	57,832
2	193,895,122	4,104,758	1,054,915	2,940,355	16,804,177	48,499,723	21,960,703	306,630	2,588	604,118
3	214,812,568	5,513,319	1,209,074	3,360,129	19,162,290	55,146,198	25,012,180	44,635	1,023	717,848
4	221,607,800	4,414,839	1,083,768	3,164,807	17,276,310	52,655,992	23,806,104	41,637	887	647,526
Sum	694,998,122	16,094,467	3,376,100	9,545,369	54,184,280	156,945,009	70,954,486	474,904	5,560	2,027,324
Avg	173,749,531	4,023,617	844,025	2,386,342	13,546,070	39,236,252	17,738,622	118,726	1,390	506,831
Std	73,661,433	1,440,897	547,890	1,547,046	8,464,573	25,874,436	11,775,798	126,608	802	302,979

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	17,940.97	571.81	7.86	22.21	261.14	178.38	48.68	22.74	0.29	16.04
2	53,779.36	1,138.51	292.59	815.55	4,660.86	13,452.03	6,091.09	85.05	0.72	167.56
3	59,579.73	1,529.16	335.34	931.95	5,314.79	15,295.17	6,937.30	12.38	0.28	199.10
4	61,465.78	1,224.51	300.60	877.80	4,791.81	14,604.82	6,602.93	11.55	0.25	179.60
Sum	192,765.84	4,463.99	936.40	2,647.51	15,028.60	43,530.40	19,680.00	131.72	1.54	562.30
Avg	48,191.46	1,116.00	234.10	661.88	3,757.15	10,882.60	4,920.00	32.93	0.39	140.58
Std	20,430.51	399.63	151.96	429.09	2,347.73	7,176.54	3,266.14	35.12	0.22	84.03

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	1,118.46	35.65	0.49	1.38	16.28	11.12	3.03	1.42	0.02
2	320.96	6.79	1.75	4.87	27.82	80.28	36.35	0.51	0.00
3	299.25	7.68	1.68	4.68	26.69	76.82	34.84	0.06	0.00
4	342.24	6.82	1.67	4.89	26.68	81.32	36.76	0.06	0.00
Avg	520.22	14.24	1.40	3.96	24.37	62.39	27.75	0.51	0.01

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	30,151	48,171	3,470	2,719	537	0	11,874,263	105,198	4,144,002	94,875	281,825	718,226	0	33
2	2,355,192	1,279,561	2,414,582	1,318,201	1,520	0	13,591,953	158,737	15,456,783	166,005	7,453,259	6,578,748	0	1,101
3	2,558,120	1,393,157	2,511,099	1,381,475	1,730	0	14,242,200	263,802	17,854,506	280,489	8,650,585	7,621,267	0	497
4	2,467,452	1,349,520	2,481,166	1,367,560	1,646	0	13,946,761	180,487	16,222,405	166,848	7,858,103	6,848,073	0	560
Sum	7,410,915	4,070,409	7,410,317	4,069,955	5,433	0	53,655,177	708,224	53,677,696	708,217	24,243,772	21,766,314	0	2,191
Avg	1,852,729	1,017,602	1,852,579	1,017,489	1,358	0	13,413,794	177,056	13,419,424	177,054	6,060,943	5,441,579	0	548
Std	1,217,883	647,979	1,233,399	677,058	554	0	1,060,221	65,919	6,263,943	76,765	3,884,704	3,179,753	0	437

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	8.36	13.36	0.96	0.75	0.15	0.00	3,293.56	29.18	1,149.42	26.32	78.17	199.21	0	0
2	653.24	354.90	669.72	365.62	0.42	0.00	3,769.91	44.03	4,287.14	46.04	2,067.26	1,824.70	0	0
3	709.51	386.40	696.47	383.16	0.48	0.00	3,950.17	73.17	4,952.07	77.80	2,399.30	2,113.81	0	0
4	684.38	374.31	688.18	379.31	0.46	0.00	3,868.31	50.06	4,499.49	46.28	2,179.55	1,899.40	0	0
Sum	2,055.50	1,128.97	2,055.33	1,128.85	1.51	0.00	14,881.95	196.43	14,888.12	196.43	6,724.27	6,037.13	0	1
Avg	513.87	282.24	513.83	282.21	0.38	0.00	3,720.49	49.11	3,722.03	49.11	1,681.07	1,509.28	0	0
Std	337.79	179.72	342.10	187.79	0.15	0.00	294.01	18.28	1,737.35	21.29	1,077.46	881.93	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	0.52	0.83	0.06	0.05	0.01	0.00	205.32	1.82	71.66	1.64	4.87	12.42	0.00	0.00
2	3.90	2.12	4.00	2.18	0.00	0.00	22.50	0.26	25.59	0.27	12.34	10.89	0.00	0.00
3	3.56	1.94	3.50	1.92	0.00	0.00	19.84	0.37	24.87	0.39	12.05	10.62	0.00	0.00
4	3.81	2.08	3.83	2.11	0.00	0.00	21.54	0.28	25.05	0.26	12.14	10.58	0.00	0.00
Avg	2.95	1.74	2.85	1.57	0.00	0.00	67.30	0.68	36.79	0.64	10.35	11.13	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.83	0.13	0.05
2	96.02	1.87	2.11
3	95.60	1.84	2.56
4	96.29	1.72	1.99

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.09	1.14	0.01	0.01	16.56	2.35	0.24	0.01	0.02	18.80	0.72
2	8.69	3.80	0.01	0.02	30.17	10.84	5.42	12.76	0.02	30.47	10.08
3	1.91	3.61	0.01	0.02	31.41	11.46	5.02	15.72	0.02	31.36	9.68
4	10.09	3.70	0.01	0.02	29.89	11.20	5.49	14.17	0.02	30.41	9.55

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.00	0.62	0.01	0.01	0.01	28.16	71.77	0.08
2	0.02	2.63	0.01	0.02	0.02	52.91	46.70	0.38
3	0.02	2.64	0.01	0.02	0.01	53.00	46.69	0.31
4	0.02	2.62	0.01	0.02	0.02	53.23	46.38	0.39

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	2,773	362	2,773	0	296	3,127	1	7	0	0	1,417	296	0	64	0	0	0	11	0
2	1,379,288	156,569	1,379,358	16,907	136,717	1,483,292	14,225	37,738	2	770	567,760	59,880	0	142,958	0	0	0	106,537	0
3	1,420,157	182,071	1,420,217	20,468	149,042	1,541,979	16,562	42,807	0	698	552,542	74,343	0	158,281	0	0	0	119,637	0
4	1,411,686	176,637	1,411,726	19,602	151,369	1,530,711	16,875	40,146	2	533	569,953	62,778	0	153,114	0	0	0	116,159	0
Sum	4,213,904	515,639	4,214,074	56,977	437,424	4,559,109	47,663	120,698	4	2,001	1,691,672	197,297	0	454,417	0	0	0	342,344	0
Avg	1,053,476	128,910	1,053,519	14,244	109,356	1,139,777	11,916	30,175	1	500	422,918	49,324	0	113,604	0	0	0	85,586	0
Std	700,690	86,397	700,718	9,616	72,990	758,193	8,031	20,218	1	348	281,107	33,277	0	75,961	0	0	0	57,318	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	4,201	100.00	0.00	0.00	0.00	0.00	25	0.00	48.00	48.00	4.00	0.00	611	1.64	19.31	75.12	1.47	2.45
2	2,801,871	96.34	3.24	0.40	0.02	0.00	243,391	2.39	20.05	73.41	4.14	0.00	406,145	0.33	8.52	88.25	2.90	0.00
3	2,911,394	96.17	3.37	0.44	0.02	0.00	243,131	2.06	19.14	73.82	4.98	0.00	465,936	0.54	12.84	84.87	1.76	0.00
4	2,875,782	96.19	3.37	0.42	0.02	0.00	236,970	2.15	19.90	73.82	4.13	0.00	436,355	0.81	15.88	81.46	1.86	0.00
Sum	8,593,248						723,517						1,309,047
Avg	2,148,312						180,879						327,262
Std	1,430,135						120,606						219,131

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	4	data block	26,780	98.48	1.42	0.11	13,039	99.74	0.09	0.17	1	0.21	37.21	0.25	0	0.20	22.47	0.23
	3	data block	15,420	96.81	3.12	0.07	11,360	99.77	0.07	0.16	1	0.18	35.49	0.19	0	0.17	42.84	0.25
	2	data block	14,919	96.89	2.98	0.13	11,323	99.59	0.22	0.19	1	0.22	30.22	0.24	0	0.22	29.37	0.25
	3	undo header	1,339	88.13	11.73	0.15	11	100.00	0.00	0.00	3	0.16	27.46	0.11	0	0.17
	4	undo header	1,327	90.43	9.42	0.15	4	100.00	0.00	0.00	3	0.16	29.13	0.21	0	0.15
	2	undo header	1,243	90.51	9.25	0.24	6	100.00	0.00	0.00	4	0.15	37.41	0.30	0	0.15
	3	undo block	998	95.19	4.71	0.10	0				2	0.19	30.88	0.32
	4	undo block	674	96.44	3.41	0.15	0				1	0.16	29.79	0.15
	2	undo block	525	96.19	3.62	0.19	0				1	0.15	18.63	0.14
	2	others	128	99.22	0.00	0.78	80	100.00	0.00	0.00	0	0.45		0.32	0	0.38
	4	others	4	100.00	0.00	0.00	133	100.00	0.00	0.00	0	0.30			0	0.23
	3	others	4	100.00	0.00	0.00	10	100.00	0.00	0.00	0	0.14			0	0.19
2	3	data block	666,013	90.33	9.54	0.13	1,322,795	89.50	10.38	0.12	4	0.26	37.36	0.31	5	0.36	44.47	0.55
	4	data block	641,484	90.32	9.57	0.12	1,290,979	89.11	10.76	0.12	4	0.26	34.87	0.33	5	0.39	43.54	0.40
	3	others	9,259	65.74	34.17	0.09	70,079	60.60	39.32	0.08	13	0.27	38.30	0.31	17	2.32	38.54	2.21
	4	undo header	72,478	90.47	9.44	0.08	1,158	87.91	12.00	0.09	3	0.20	31.66	0.22	5	0.95	31.02	0.64
	3	undo header	71,456	89.72	10.18	0.10	1,140	87.11	12.89	0.00	4	0.20	33.83	0.27	5	0.26	35.96
	4	others	3,351	69.56	30.35	0.09	47,360	66.90	33.01	0.09	12	0.31	37.43	0.44	12	0.71	36.15	0.33
	3	undo block	9,079	73.98	25.96	0.06	0				9	0.22	33.89	0.16
	4	undo block	8,845	74.56	25.30	0.14	0				8	0.21	31.65	0.22
	1	data block	1,609	98.14	1.68	0.19	1,189	87.97	11.86	0.17	0	0.24	14.25	0.21	1	0.35	2.42	0.30
	1	undo header	281	96.80	3.20	0.00	4	100.00	0.00	0.00	1	0.17	17.89		0	0.14
	1	others	42	97.62	2.38	0.00	104	30.77	69.23	0.00	1	0.26	16.59		1	0.34	0.96
3	4	data block	743,219	90.34	9.55	0.12	1,465,493	90.19	9.68	0.13	4	0.26	34.82	0.32	4	0.37	41.81	0.42
	2	data block	705,190	90.84	9.04	0.12	1,371,659	90.21	9.66	0.13	3	0.27	35.47	0.33	4	0.36	43.08	0.38
	4	undo header	77,632	90.65	9.28	0.07	1,336	88.25	11.68	0.07	3	0.20	31.75	0.26	4	0.26	31.61	0.23
	2	undo header	67,953	89.94	9.98	0.08	1,107	88.53	11.47	0.00	3	0.20	32.64	0.28	4	0.36	34.70
	2	others	1,588	84.07	15.87	0.06	65,228	48.39	51.53	0.09	6	0.26	34.66	0.20	19	1.73	35.72	0.48
	4	others	2,231	77.81	22.14	0.04	57,094	64.34	35.59	0.08	9	0.29	37.50	0.77	16	1.05	43.51	1.83
	4	undo block	10,087	75.53	24.40	0.07	0				8	0.21	30.98	0.27
	2	undo block	8,004	74.44	25.51	0.05	0				8	0.21	32.68	0.22
	1	data block	501	97.21	2.79	0.00	1,134	78.75	21.16	0.09	1	0.26	19.46		0	0.28	0.84	0.48
	1	others	9	100.00	0.00	0.00	25	68.00	32.00	0.00	0	0.22			0	0.23	0.36
	1	undo header	7	100.00	0.00	0.00	5	100.00	0.00	0.00	0	0.15			1	1.06
	1	undo block	0				1	100.00	0.00	0.00					0	0.14
4	3	data block	737,559	90.38	9.51	0.12	1,425,524	89.61	10.27	0.12	4	0.26	37.56	0.37	5	0.37	44.19	0.50
	2	data block	658,918	90.70	9.18	0.13	1,299,667	89.65	10.22	0.13	3	0.26	35.08	0.32	5	0.39	43.77	0.49
	3	others	3,017	80.51	19.32	0.17	78,337	54.81	45.14	0.05	7	0.28	37.31	0.49	21	4.36	40.26	0.66
	3	undo header	76,172	89.75	10.15	0.10	1,361	85.16	14.70	0.15	4	0.21	33.96	0.23	5	0.22	35.89	0.23
	2	undo header	67,550	90.09	9.84	0.08	1,055	89.00	10.81	0.19	3	0.20	31.59	0.23	5	0.27	42.09	0.28
	2	others	1,204	85.30	14.70	0.00	52,970	60.54	39.39	0.08	5	0.25	35.93		16	1.37	38.54	2.82
	3	undo block	10,381	74.21	25.70	0.09	0				9	0.22	33.88	0.30
	2	undo block	8,370	73.45	26.48	0.07	0				9	0.21	31.95	0.64
	1	data block	663	98.34	1.51	0.15	1,702	97.94	1.94	0.12	1	0.30	21.37	0.36	0	0.27	0.41	0.83
	1	others	15	100.00	0.00	0.00	32	100.00	0.00	0.00	0	0.26			0	0.24
	1	undo header	7	85.71	14.29	0.00	2	100.00	0.00	0.00	5	0.24	32.61		0	0.14

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	4	data block	0		26,372	41.36	58.64	13,005	67.29	32.71	0.21	0.16	0.24	0.20	0.17	0.26
	3	data block	0		14,928	82.32	17.68	11,334	91.02	8.98	0.18	0.16	0.25	0.17	0.16	0.27
	2	data block	0		14,455	23.83	76.17	11,277	44.30	55.70	0.22	0.16	0.24	0.22	0.17	0.26
	4	undo header	0		1,200	100.00	0.00	4	100.00	0.00	0.16	0.16		0.15	0.15
	3	undo header	0		1,180	100.00	0.00	11	100.00	0.00	0.16	0.16		0.17	0.17
	2	undo header	0		1,125	100.00	0.00	6	100.00	0.00	0.15	0.15		0.15	0.15
	3	undo block	0		950	100.00	0.00	0			0.19	0.19
	4	undo block	0		650	100.00	0.00	0			0.16	0.16
	2	undo block	0		505	100.00	0.00	0			0.15	0.15
	2	others	0		127	0.00	100.00	80	26.25	73.75	0.45		0.45	0.38	0.19	0.45
	4	others	0		4	0.00	100.00	133	49.62	50.38	0.30		0.30	0.23	0.18	0.27
	3	others	0		4	50.00	50.00	10	80.00	20.00	0.14	0.10	0.18	0.19	0.18	0.24
2	3	data block	0		601,612	49.09	50.91	1,183,923	52.14	47.86	0.26	0.22	0.31	0.36	0.35	0.38
	4	data block	0		579,357	52.25	47.75	1,150,410	52.85	47.15	0.26	0.22	0.30	0.39	0.31	0.48
	4	undo header	0		65,573	100.00	0.00	1,018	100.00	0.00	0.20	0.20		0.95	0.95
	3	undo header	0		64,111	100.00	0.00	993	100.00	0.00	0.20	0.20		0.26	0.26
	3	others	0		6,087	85.77	14.23	42,465	72.99	27.01	0.27	0.27	0.30	2.32	3.04	0.37
	4	others	0		2,331	19.61	80.39	31,685	55.71	44.29	0.31	0.20	0.34	0.71	0.30	1.23
	3	undo block	0		6,717	100.00	0.00	0			0.22	0.22
	4	undo block	0		6,595	100.00	0.00	0			0.21	0.21
	1	data block	0		1,579	57.69	42.31	1,046	40.34	59.66	0.24	0.21	0.29	0.35	0.27	0.41
	1	undo header	0		272	100.00	0.00	4	100.00	0.00	0.17	0.17		0.14	0.14
	1	others	0		41	26.83	73.17	32	40.63	59.38	0.26	0.14	0.31	0.34	0.14	0.47
	1	undo block	0		0			0
3	4	data block	0		671,389	55.46	44.54	1,321,775	55.06	44.94	0.26	0.23	0.31	0.37	0.35	0.39
	2	data block	0		640,570	47.90	52.10	1,237,347	52.11	47.89	0.27	0.23	0.31	0.36	0.34	0.39
	4	undo header	0		70,372	100.00	0.00	1,179	100.00	0.00	0.20	0.20		0.26	0.26
	2	undo header	0		61,117	100.00	0.00	980	100.00	0.00	0.20	0.20		0.36	0.36
	4	others	0		1,736	55.99	44.01	36,733	72.54	27.46	0.29	0.27	0.31	1.05	1.31	0.35
	2	others	0		1,335	56.48	43.52	31,561	65.08	34.92	0.26	0.23	0.30	1.73	2.46	0.37
	4	undo block	0		7,619	100.00	0.00	0			0.21	0.21
	2	undo block	0		5,958	100.00	0.00	0			0.21	0.21
	1	data block	0		487	83.57	16.43	893	89.36	10.64	0.26	0.26	0.28	0.28	0.27	0.30
	1	others	0		9	33.33	66.67	17	76.47	23.53	0.22	0.14	0.27	0.23	0.21	0.28
	1	undo header	0		7	100.00	0.00	5	100.00	0.00	0.15	0.15		1.06	1.06
	1	undo block	0		0			1	100.00	0.00				0.14	0.14
4	3	data block	0		666,569	54.69	45.31	1,277,347	55.31	44.69	0.26	0.23	0.31	0.37	0.36	0.39
	2	data block	0		597,618	50.64	49.36	1,165,155	52.50	47.50	0.26	0.22	0.31	0.39	0.31	0.48
	3	undo header	0		68,365	100.00	0.00	1,159	100.00	0.00	0.21	0.21		0.22	0.22
	2	undo header	0		60,853	100.00	0.00	939	100.00	0.00	0.20	0.20		0.27	0.27
	3	others	0		2,429	60.07	39.93	42,934	77.68	22.32	0.28	0.27	0.29	4.36	5.52	0.33
	2	others	0		1,027	45.96	54.04	32,066	52.85	47.15	0.25	0.22	0.28	1.37	0.25	2.62
	3	undo block	0		7,704	100.00	0.00	0			0.22	0.22
	2	undo block	0		6,148	100.00	0.00	0			0.21	0.21
	1	data block	0		652	66.72	33.28	1,667	79.84	20.16	0.30	0.24	0.40	0.27	0.23	0.41
	1	others	0		15	33.33	66.67	32	46.88	53.13	0.26	0.16	0.32	0.24	0.20	0.27
	1	undo header	0		6	100.00	0.00	2	100.00	0.00	0.24	0.24		0.14	0.14
	1	undo block	0		0			0

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	Source	IP Address
		Begin			End (if different from Begin)
1	bond0	172.168.8.10	N	Oracle Cluster Repository
2	bond0	172.168.8.11	N	Oracle Cluster Repository
3	bond0	172.168.8.12	N	Oracle Cluster Repository
4	bond0	172.168.8.13	N	Oracle Cluster Repository

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	334	0.07	0.21	0.07	334	0.07	0.21	0.07
	2	334	0.07	0.21	0.08	334	0.08	0.23	0.09
	3	334	0.07	0.20	0.08	334	0.08	0.23	0.10
	4	334	0.08	0.24	0.10	334	0.09	0.26	0.09
2	1	333	0.07	0.22	0.08	333	0.08	0.24	0.10
	2	333	0.07	0.20	0.07	333	0.06	0.19	0.07
	3	333	0.07	0.20	0.10	333	0.08	0.23	0.10
	4	333	0.06	0.19	0.11	333	0.07	0.22	0.11
3	1	333	0.07	0.21	0.07	333	0.08	0.24	0.08
	2	333	0.07	0.20	0.09	333	0.08	0.23	0.10
	3	333	0.06	0.18	0.06	333	0.06	0.17	0.06
	4	333	0.07	0.20	0.10	333	0.07	0.22	0.11
4	1	333	0.07	0.20	0.07	333	0.07	0.22	0.08
	2	333	0.07	0.21	0.08	333	0.08	0.24	0.09
	3	333	0.07	0.21	0.10	333	0.08	0.23	0.10
	4	333	0.05	0.16	0.06	333	0.05	0.16	0.06

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	1,909.64	46.58	24.41	1,519.11	11.21	308.33	4,956.01	632.17	49.19	3,807.72	11.21	455.72
2	35,594.64	30,091.64	17.37	5,291.41	11.17	183.05	34,135.36	29,258.45	8.92	4,727.25	11.17	129.57
3	37,644.21	31,348.51	17.39	6,090.76	11.17	176.38	36,981.18	31,832.53	9.50	4,999.49	11.17	128.48
4	36,663.87	30,948.50	17.36	5,510.95	11.17	175.89	35,694.45	30,667.07	8.92	4,878.14	11.17	129.15
Sum	111,812.36	92,435.22	76.53	18,412.23	44.73	843.65	111,767.00	92,390.23	76.53	18,412.60	44.73	842.91
Avg	27,953.09	23,108.80	19.13	4,603.06	11.18	210.91	27,941.75	23,097.56	19.13	4,603.15	11.18	210.73
Std	17,382.46	15,383.76	3.52	2,083.43	0.02	65.03	15,367.94	15,013.86	20.04	541.85	0.02	163.33

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.53	0.01	0.01	0.42	0.00	0.09	1.37	0.18	0.01	1.06	0.00	0.13
2	9.87	8.35	0.00	1.47	0.00	0.05	9.47	8.12	0.00	1.31	0.00	0.04
3	10.44	8.69	0.00	1.69	0.00	0.05	10.26	8.83	0.00	1.39	0.00	0.04
4	10.17	8.58	0.00	1.53	0.00	0.05	9.90	8.51	0.00	1.35	0.00	0.04
Sum	31.01	25.64	0.02	5.11	0.01	0.23	31.00	25.63	0.02	5.11	0.01	0.23
Avg	7.75	6.41	0.01	1.28	0.00	0.06	7.75	6.41	0.01	1.28	0.00	0.06
Std	4.82	4.27	0.00	0.58	0.00	0.02	4.26	4.16	0.01	0.15	0.00	0.05

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	lo	127.0.0.1	255.0.0.0	88.52	580,401	0	0	0	0	88.52	580,401	0	0	0	0
2	lo	127.0.0.1	255.0.0.0	462.11	3,119,350	0	0	0	0	462.11	3,119,350	0	0	0	0
3	lo	127.0.0.1	255.0.0.0	500.12	3,367,247	0	0	0	0	500.12	3,367,247	0	0	0	0
4	lo	127.0.0.1	255.0.0.0	500.55	3,373,828	0	0	0	0	500.55	3,373,828	0	0	0	0
Sum				1,551.29	10,440,826	0	0	0	0	1,551.29	10,440,826	0	0	0	0
Avg				387.82	2,610,207	0	0	0	0	387.82	2,610,207	0	0	0	0
Std				200.35	1,358,377	0	0	0	0	200.35	1,358,377	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	lo	127.0.0.1	255.0.0.0	0.02	161	0	0	0	0	0.02	161	0	0	0	0
2	lo	127.0.0.1	255.0.0.0	0.13	865	0	0	0	0	0.13	865	0	0	0	0
3	lo	127.0.0.1	255.0.0.0	0.14	934	0	0	0	0	0.14	934	0	0	0	0
4	lo	127.0.0.1	255.0.0.0	0.14	936	0	0	0	0	0.14	936	0	0	0	0
Sum				0.43	2,896	0	0	0	0	0.43	2,896	0	0	0	0
Avg				0.11	724	0	0	0	0	0.11	724	0	0	0	0
Std				0.06	377	0	0	0	0	0.06	377	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			1	1
2	0			1	1
3	0			1	1
4	0			0	0
Avg	0			1	1
Max				1	1

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 67.2% of Total DB Time (s): 457,002
Captured PL/SQL account for 0.2% of Total DB Time (s): 457,002

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
4636378wmh2bp	82,383.10	86.83	0.02	954,126	12	131,840	29,662.99	131,840	0.62	0.00	0.00	7.24	0.00	1.00	0.22	18.03	0.20	0.00	0.14	0.00	17.76	0.19	update data_t set poid_rev = p...
0v25hwd7t2bus	70,184.08	412.62	1,431.88	14,025,926	151,002	426,464	60,035.35	426,466	0.16	0.00	0.00	32.89	0.35	1.00	0.14	15.36	0.93	0.03	2.02	0.94	35.95	0.60	insert into billlog_t ( poid_D...
g71uftrcn0npd	32,700.57	280.32	779.52	8,484,300	77,199	293,537	30,517.02	293,537	0.11	0.00	0.00	28.90	0.26	1.00	0.10	7.16	0.63	0.02	1.22	0.48	18.27	0.41	insert into event_t ( poid_DB,...
87vd326hc3ar0	16,918.59	107.35	85.36	3,831,035	9,225	154,802	16,416.15	154,803	0.11	0.00	0.00	24.75	0.06	1.00	0.11	3.70	0.24	0.00	0.55	0.06	9.83	0.22	insert into event_t ( poid_DB,...
d36p2zk77mu80	15,882.69	1,374.28	13,045.32	17,916,941	3,279,491	12,237,802	1,552.03	1,556,958	0.01	0.00	0.01	11.51	2.11	7.86	0.00	3.48	3.09	0.26	2.58	20.38	0.93	2.19	select distinct poid_DB, poid_...
1f9918t43pbmq	11,057.89	130.45	3.39	2,493,996	1,441	246,279	10,306.28	246,278	0.04	0.00	0.00	10.13	0.01	1.00	0.04	2.42	0.29	0.00	0.36	0.01	6.17	0.35	insert into using_trafficaccou...
5c0d20xn9qbhm	8,594.74	125.31	1,225.18	2,947,221	122,468	131,843	7,243.77	131,843	0.07	0.00	0.01	22.35	0.93	1.00	0.05	1.88	0.28	0.02	0.42	0.76	4.34	0.19	insert into event_t ( poid_DB,...
61rcbymrd925x	8,503.33	928.91	6,015.17	55,740,145	2,031,954	11,120,201	1,591.65	11,120,403	0.00	0.00	0.00	5.01	0.18	1.00	0.00	1.86	2.09	0.12	8.02	12.63	0.95	15.67	select poid_DB, poid_ID0, poid...
6d5tfynxyu3gr	7,414.31	22.65	175.93	355,929	44,080	36,924	378.84	57,751	0.13	0.00	0.00	6.16	0.76	0.64	0.01	1.62	0.05	0.00	0.05	0.27	0.23	0.08	select poid_DB, poid_ID0, poid...
9f0p23w4gx24d	4,532.35	105.68	4,391.10	1,686,069	479,414	3,030	56.47	9,295	0.49	0.01	0.47	181.40	51.58	0.33	0.01	0.99	0.24	0.09	0.24	2.98	0.03	0.01	select distinct event_t.poid_D...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time (Global)

Captured SQL account for 22.5% of Total CPU Time (s): 44,441
Captured PL/SQL account for 0.5% of Total CPU Time (s): 44,441

SQL Id	CPU (s)	IOWait (s)	Elapsed (s)	Gets	Reads	Rows	Cluster (s)	Execs	CPU (s)	IOWait (s)	Elapsed (s)	Gets	Reads	Rows	Cluster (s)	DB time	DB CPU	IO Wait	Gets	Reads	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
d36p2zk77mu80	1,374.28	15,882.69	13,045.32	17,916,941	3,279,491	12,237,802	1,552.03	1,556,958	0.00	0.01	0.01	11.51	2.11	7.86	0.00	3.09	26.20	3.48	2.58	20.38	0.93	2.19	select distinct poid_DB, poid_...
61rcbymrd925x	928.91	8,503.33	6,015.17	55,740,145	2,031,954	11,120,201	1,591.65	11,120,403	0.00	0.00	0.00	5.01	0.18	1.00	0.00	2.09	12.08	1.86	8.02	12.63	0.95	15.67	select poid_DB, poid_ID0, poid...
56nmjy6g1aky8	858.13	906.80	0.00	96,807,224	0	1,561,360	0.00	1,564,229	0.00	0.00	0.00	61.89	0.00	1.00	0.00	1.93	0.00	0.20	13.93	0.00	0.00	2.20	select distinct poid_DB, poid_...
3q72620j7sw4q	554.31	1,935.79	1,154.39	7,809,016	465,120	1,557,002	215.80	1,556,957	0.00	0.00	0.00	5.02	0.30	1.00	0.00	1.25	2.32	0.42	1.12	2.89	0.13	2.19	select distinct poid_DB, poid_...
0v25hwd7t2bus	412.62	70,184.08	1,431.88	14,025,926	151,002	426,464	60,035.35	426,466	0.00	0.00	0.16	32.89	0.35	1.00	0.14	0.93	2.88	15.36	2.02	0.94	35.95	0.60	insert into billlog_t ( poid_D...
adc95dp9cgt6h	385.60	444.93	0.00	22,918,814	0	11,459,689	0.00	11,459,847	0.00	0.00	0.00	2.00	0.00	1.00	0.00	0.87	0.00	0.10	3.30	0.00	0.00	16.15	select poid_DB, poid_ID0, poid...
6w4q4kh8cprmu	315.43	4,133.74	2,503.91	9,188,971	1,103,638	1,817,449	1,355.24	1,817,450	0.00	0.00	0.00	5.06	0.61	1.00	0.00	0.71	5.03	0.90	1.32	6.86	0.81	2.56	select poid_DB, poid_ID0, poid...
8fadd1k0568gc	296.64	296.91	0.00	59,797,883	0	25,110	0.00	838	0.35	0.00	0.35	71,357.86	0.00	29.96	0.00	0.67	0.00	0.06	8.60	0.00	0.00	0.00	SELECT SQUENCE, BIPCODE, TRANS...
4pxz3dag5j1av	293.36	339.64	0.00	17,729,812	0	8,865,152	0.00	8,865,424	0.00	0.00	0.00	2.00	0.00	1.00	0.00	0.66	0.00	0.07	2.55	0.00	0.00	12.49	select poid_DB, poid_ID0, poid...
607hhqjzab9h6	291.26	3,603.41	2,622.20	9,163,803	1,223,148	1,817,463	733.44	1,817,446	0.00	0.00	0.00	5.04	0.67	1.00	0.00	0.66	5.27	0.79	1.32	7.60	0.44	2.56	select state from account_name...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Time (Global)

Captured SQL account for 98.4% of Total User I/O Wait Time (s): 49,785
Captured PL/SQL account for 1.0% of Total User I/O Wait Time (s): 49,785

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
d36p2zk77mu80	13,045.32	15,882.69	1,374.28	17,916,941	3,279,491	12,237,802	1,552.03	1,556,958	0.01	0.01	0.00	11.51	2.11	7.86	0.00	26.20	3.48	3.09	2.58	20.38	0.93	2.19	select distinct poid_DB, poid_...
61rcbymrd925x	6,015.17	8,503.33	928.91	55,740,145	2,031,954	11,120,201	1,591.65	11,120,403	0.00	0.00	0.00	5.01	0.18	1.00	0.00	12.08	1.86	2.09	8.02	12.63	0.95	15.67	select poid_DB, poid_ID0, poid...
607hhqjzab9h6	2,622.20	3,603.41	291.26	9,163,803	1,223,148	1,817,463	733.44	1,817,446	0.00	0.00	0.00	5.04	0.67	1.00	0.00	5.27	0.79	0.66	1.32	7.60	0.44	2.56	select state from account_name...
6w4q4kh8cprmu	2,503.91	4,133.74	315.43	9,188,971	1,103,638	1,817,449	1,355.24	1,817,450	0.00	0.00	0.00	5.06	0.61	1.00	0.00	5.03	0.90	0.71	1.32	6.86	0.81	2.56	select poid_DB, poid_ID0, poid...
0v25hwd7t2bus	1,431.88	70,184.08	412.62	14,025,926	151,002	426,464	60,035.35	426,466	0.00	0.16	0.00	32.89	0.35	1.00	0.14	2.88	15.36	0.93	2.02	0.94	35.95	0.60	insert into billlog_t ( poid_D...
3q72620j7sw4q	1,154.39	1,935.79	554.31	7,809,016	465,120	1,557,002	215.80	1,556,957	0.00	0.00	0.00	5.02	0.30	1.00	0.00	2.32	0.42	1.25	1.12	2.89	0.13	2.19	select distinct poid_DB, poid_...
4pxz3dag5j1av	0.00	339.64	293.36	17,729,812	0	8,865,152	0.00	8,865,424	0.00	0.00	0.00	2.00	0.00	1.00	0.00	0.00	0.07	0.66	2.55	0.00	0.00	12.49	select poid_DB, poid_ID0, poid...
56nmjy6g1aky8	0.00	906.80	858.13	96,807,224	0	1,561,360	0.00	1,564,229	0.00	0.00	0.00	61.89	0.00	1.00	0.00	0.00	0.20	1.93	13.93	0.00	0.00	2.20	select distinct poid_DB, poid_...
8fadd1k0568gc	0.00	296.91	296.64	59,797,883	0	25,110	0.00	838	0.00	0.35	0.35	71,357.86	0.00	29.96	0.00	0.00	0.06	0.67	8.60	0.00	0.00	0.00	SELECT SQUENCE, BIPCODE, TRANS...
adc95dp9cgt6h	0.00	444.93	385.60	22,918,814	0	11,459,689	0.00	11,459,847	0.00	0.00	0.00	2.00	0.00	1.00	0.00	0.00	0.10	0.87	3.30	0.00	0.00	16.15	select poid_DB, poid_ID0, poid...

Back to SQL Statistics
Back to Top

SQL ordered by Gets (Global)

Total Buffer Gets: 694,998,122
Captured SQL account for 93.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
56nmjy6g1aky8	96,807,224	0	906.80	858.13	0.00	1,561,360	0.00	1,564,229	61.89	0.00	0.00	0.00	0.00	1.00	0.00	13.93	0.00	0.20	1.93	0.00	0.00	2.20	select distinct poid_DB, poid_...
8fadd1k0568gc	59,797,883	0	296.91	296.64	0.00	25,110	0.00	838	71,357.86	0.00	0.35	0.35	0.00	29.96	0.00	8.60	0.00	0.06	0.67	0.00	0.00	0.00	SELECT SQUENCE, BIPCODE, TRANS...
61rcbymrd925x	55,740,145	2,031,954	8,503.33	928.91	6,015.17	11,120,201	1,591.65	11,120,403	5.01	0.18	0.00	0.00	0.00	1.00	0.00	8.02	12.63	1.86	2.09	12.08	0.95	15.67	select poid_DB, poid_ID0, poid...
cbuk77k0pggx7	51,323,862	1,309	221.53	203.19	1.74	1,711	11.56	1,015	50,565.38	1.29	0.22	0.20	0.00	1.69	0.01	7.38	0.01	0.05	0.46	0.00	0.01	0.00	select syncinfo_t.account_obj_...
bmmnh389h4m7p	45,118,578	0	242.56	224.38	0.00	725,034	0.00	727,765	62.00	0.00	0.00	0.00	0.00	1.00	0.00	6.49	0.00	0.05	0.50	0.00	0.00	1.03	select descr, poid_DB, poid_ID...
3ffmts3uvw1z5	44,095,832	110	180.18	171.37	0.19	4,310	5.88	873	50,510.69	0.13	0.21	0.20	0.00	4.94	0.01	6.34	0.00	0.04	0.39	0.00	0.00	0.00	select syncinfo_t.account_obj_...
8562a4usc37q4	34,047,620	145,476	1,470.37	117.81	808.55	182	547.69	11	3,095,238.18	13,225.09	133.67	10.71	73.50	16.55	49.79	4.90	0.90	0.32	0.27	1.62	0.33	0.00	SELECT NVL(A.SESSIONBEGINTIME,...
32n55pzn51541	26,704,571	16,903	1,568.71	141.79	113.34	283,876	1,316.08	286,020	93.37	0.06	0.01	0.00	0.00	0.99	0.00	3.84	0.11	0.34	0.32	0.23	0.79	0.40	select poid_DB, poid_ID0, poid...
5pjdr1a04pvzq	25,087,589	101	183.66	161.87	0.16	4,347	18.49	4,347	5,771.24	0.02	0.04	0.04	0.00	1.00	0.00	3.61	0.00	0.04	0.36	0.00	0.01	0.01	delete from syncinfo_subscript...
adc95dp9cgt6h	22,918,814	0	444.93	385.60	0.00	11,459,689	0.00	11,459,847	2.00	0.00	0.00	0.00	0.00	1.00	0.00	3.30	0.00	0.10	0.87	0.00	0.00	16.15	select poid_DB, poid_ID0, poid...

Back to SQL Statistics
Back to Top

SQL ordered by Reads (Global)

Total Disk Reads: 16,094,467
Captured SQL account for 103.8% 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
d36p2zk77mu80	3,279,491	17,916,941	15,882.69	1,374.28	13,045.32	12,237,802	1,552.03	1,556,958	2.11	11.51	0.01	0.00	0.01	7.86	0.00	20.38	2.58	3.48	3.09	26.20	0.93	2.19	select distinct poid_DB, poid_...
2trtpvb5jtr53	3,047,200	3,047,254	21.88	19.66	0.05	3	0.00	3	1,015,733.33	1,015,751.33	7.29	6.55	0.02	1.00	0.00	18.93	0.44	0.00	0.04	0.00	0.00	0.00	SELECT TO_CHAR(current_timesta...
61rcbymrd925x	2,031,954	55,740,145	8,503.33	928.91	6,015.17	11,120,201	1,591.65	11,120,403	0.18	5.01	0.00	0.00	0.00	1.00	0.00	12.63	8.02	1.86	2.09	12.08	0.95	15.67	select poid_DB, poid_ID0, poid...
607hhqjzab9h6	1,223,148	9,163,803	3,603.41	291.26	2,622.20	1,817,463	733.44	1,817,446	0.67	5.04	0.00	0.00	0.00	1.00	0.00	7.60	1.32	0.79	0.66	5.27	0.44	2.56	select state from account_name...
6w4q4kh8cprmu	1,103,638	9,188,971	4,133.74	315.43	2,503.91	1,817,449	1,355.24	1,817,450	0.61	5.06	0.00	0.00	0.00	1.00	0.00	6.86	1.32	0.90	0.71	5.03	0.81	2.56	select poid_DB, poid_ID0, poid...
cskd6zs6bc7s5	1,006,233	5,754,990	1,954.61	192.87	1,688.44	185	105.38	80,093	12.56	71.85	0.02	0.00	0.02	0.00	0.00	6.25	0.83	0.43	0.43	3.39	0.06	0.11	select serviceid, poid_DB, poi...
55xz19mt7dvy4	727,840	3,563,543	2,120.18	174.36	1,822.58	679,153	150.71	719,137	1.01	4.96	0.00	0.00	0.00	0.94	0.00	4.52	0.51	0.46	0.39	3.66	0.09	1.01	select status, account_obj_DB,...
9f0p23w4gx24d	479,414	1,686,069	4,532.35	105.68	4,391.10	3,030	56.47	9,295	51.58	181.40	0.49	0.01	0.47	0.33	0.01	2.98	0.24	0.99	0.24	8.82	0.03	0.01	select distinct event_t.poid_D...
d85uh8vskn4dq	469,957	4,335,074	1,666.04	103.12	1,522.31	323,235	56.22	45,365	10.36	95.56	0.04	0.00	0.03	7.13	0.00	2.92	0.62	0.36	0.23	3.06	0.03	0.06	select distinct poid_DB, poid_...
3q72620j7sw4q	465,120	7,809,016	1,935.79	554.31	1,154.39	1,557,002	215.80	1,556,957	0.30	5.02	0.00	0.00	0.00	1.00	0.00	2.89	1.12	0.42	1.25	2.32	0.13	2.19	select distinct poid_DB, poid_...

Back to SQL Statistics
Back to Top

SQL ordered by UnOptimized Read Requests (Global)

Total Physical Read Requests: 14,117,858
Captured SQL account for 79.5% of Total
Total UnOptimized Read Requests: 2,682,333
Captured SQL account for 83.1% of Total
Total Optimized Read Requests: 11,435,525
Captured SQL account for 78.6% 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
d36p2zk77mu80	708,028	3,279,421	3,279,491	15,882.69	1,374.28	13,045.32	12,237,802	1,552.03	1,556,958	0.45	2.11	2.11	0.01	0.00	0.01	7.86	0.00	26.40	23.23	20.38	3.48	3.09	26.20	0.93	2.19	select distinct poid_DB, poid_...
61rcbymrd925x	218,330	1,460,659	2,031,954	8,503.33	928.91	6,015.17	11,120,201	1,591.65	11,120,403	0.02	0.13	0.18	0.00	0.00	0.00	1.00	0.00	8.14	10.35	12.63	1.86	2.09	12.08	0.95	15.67	select poid_DB, poid_ID0, poid...
9f0p23w4gx24d	200,895	336,599	479,414	4,532.35	105.68	4,391.10	3,030	56.47	9,295	21.61	36.21	51.58	0.49	0.01	0.47	0.33	0.01	7.49	2.38	2.98	0.99	0.24	8.82	0.03	0.01	select distinct event_t.poid_D...
607hhqjzab9h6	104,079	1,223,152	1,223,148	3,603.41	291.26	2,622.20	1,817,463	733.44	1,817,446	0.06	0.67	0.67	0.00	0.00	0.00	1.00	0.00	3.88	8.66	7.60	0.79	0.66	5.27	0.44	2.56	select state from account_name...
55xz19mt7dvy4	76,150	727,840	727,840	2,120.18	174.36	1,822.58	679,153	150.71	719,137	0.11	1.01	1.01	0.00	0.00	0.00	0.94	0.00	2.84	5.16	4.52	0.46	0.39	3.66	0.09	1.01	select status, account_obj_DB,...
d85uh8vskn4dq	60,067	329,133	469,957	1,666.04	103.12	1,522.31	323,235	56.22	45,365	1.32	7.26	10.36	0.04	0.00	0.03	7.13	0.00	2.24	2.33	2.92	0.36	0.23	3.06	0.03	0.06	select distinct poid_DB, poid_...
3mg8tsjnf7myu	44,595	279,300	279,298	1,285.91	79.97	886.78	287,001	329.96	286,929	0.16	0.97	0.97	0.00	0.00	0.00	1.00	0.00	1.66	1.98	1.74	0.28	0.18	1.78	0.20	0.40	select bal_grp_sub_bals_t.rec_...
6w4q4kh8cprmu	40,297	409,669	1,103,638	4,133.74	315.43	2,503.91	1,817,449	1,355.24	1,817,450	0.02	0.23	0.61	0.00	0.00	0.00	1.00	0.00	1.50	2.90	6.86	0.90	0.71	5.03	0.81	2.56	select poid_DB, poid_ID0, poid...
cskd6zs6bc7s5	40,007	713,479	1,006,233	1,954.61	192.87	1,688.44	185	105.38	80,093	0.50	8.91	12.56	0.02	0.00	0.02	0.00	0.00	1.49	5.05	6.25	0.43	0.43	3.39	0.06	0.11	select serviceid, poid_DB, poi...
499pvd5n5hru4	6,128	434,507	434,509	861.83	135.14	550.72	938,859	189.11	939,026	0.01	0.46	0.46	0.00	0.00	0.00	1.00	0.00	0.23	3.08	2.70	0.19	0.30	1.11	0.11	1.32	select poid_DB, poid_ID0, poid...

Back to SQL Statistics
Back to Top

SQL ordered by Executions (Global)

Total Executions: 70,954,486
Captured SQL account for 71.6% 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
adc95dp9cgt6h	11,459,847	444.93	385.60	0.00	22,918,814	0	11,459,689	0.00	0.00	0.00	0.00	2.00	0.00	1.00	0.00	16.15	0.10	0.87	0.00	3.30	0.00	0.00	select poid_DB, poid_ID0, poid...
61rcbymrd925x	11,120,403	8,503.33	928.91	6,015.17	55,740,145	2,031,954	11,120,201	1,591.65	0.00	0.00	0.00	5.01	0.18	1.00	0.00	15.67	1.86	2.09	12.08	8.02	12.63	0.95	select poid_DB, poid_ID0, poid...
4pxz3dag5j1av	8,865,424	339.64	293.36	0.00	17,729,812	0	8,865,152	0.00	0.00	0.00	0.00	2.00	0.00	1.00	0.00	12.49	0.07	0.66	0.00	2.55	0.00	0.00	select poid_DB, poid_ID0, poid...
6w4q4kh8cprmu	1,817,450	4,133.74	315.43	2,503.91	9,188,971	1,103,638	1,817,449	1,355.24	0.00	0.00	0.00	5.06	0.61	1.00	0.00	2.56	0.90	0.71	5.03	1.32	6.86	0.81	select poid_DB, poid_ID0, poid...
607hhqjzab9h6	1,817,446	3,603.41	291.26	2,622.20	9,163,803	1,223,148	1,817,463	733.44	0.00	0.00	0.00	5.04	0.67	1.00	0.00	2.56	0.79	0.66	5.27	1.32	7.60	0.44	select state from account_name...
56nmjy6g1aky8	1,564,229	906.80	858.13	0.00	96,807,224	0	1,561,360	0.00	0.00	0.00	0.00	61.89	0.00	1.00	0.00	2.20	0.20	1.93	0.00	13.93	0.00	0.00	select distinct poid_DB, poid_...
d36p2zk77mu80	1,556,958	15,882.69	1,374.28	13,045.32	17,916,941	3,279,491	12,237,802	1,552.03	0.01	0.00	0.01	11.51	2.11	7.86	0.00	2.19	3.48	3.09	26.20	2.58	20.38	0.93	select distinct poid_DB, poid_...
3q72620j7sw4q	1,556,957	1,935.79	554.31	1,154.39	7,809,016	465,120	1,557,002	215.80	0.00	0.00	0.00	5.02	0.30	1.00	0.00	2.19	0.42	1.25	2.32	1.12	2.89	0.13	select distinct poid_DB, poid_...
6cqzzxua36gcg	1,556,953	137.68	123.56	0.00	0	0	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	2.19	0.03	0.28	0.00	0.00	0.00	0.00	select distinct poid_DB, poid_...
5c5qmkf7dptb1	1,028,942	535.20	78.04	180.21	5,196,667	103,791	1,028,951	277.03	0.00	0.00	0.00	5.05	0.10	1.00	0.00	1.45	0.12	0.18	0.36	0.75	0.64	0.17	select poid_DB, poid_ID0, poid...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time (Global)

Total Cluster Wait Time (s): 166,988
Captured SQL account for 104.3% 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
0v25hwd7t2bus	60,035.35	70,184.08	412.62	1,431.88	14,025,926	151,002	426,464	426,466	0.14	0.16	0.00	0.00	32.89	0.35	1.00	35.95	15.36	0.93	2.88	2.02	0.94	0.60	insert into billlog_t ( poid_D...
g71uftrcn0npd	30,517.02	32,700.57	280.32	779.52	8,484,300	77,199	293,537	293,537	0.10	0.11	0.00	0.00	28.90	0.26	1.00	18.27	7.16	0.63	1.57	1.22	0.48	0.41	insert into event_t ( poid_DB,...
4636378wmh2bp	29,662.99	82,383.10	86.83	0.02	954,126	12	131,840	131,840	0.22	0.62	0.00	0.00	7.24	0.00	1.00	17.76	18.03	0.20	0.00	0.14	0.00	0.19	update data_t set poid_rev = p...
87vd326hc3ar0	16,416.15	16,918.59	107.35	85.36	3,831,035	9,225	154,802	154,803	0.11	0.11	0.00	0.00	24.75	0.06	1.00	9.83	3.70	0.24	0.17	0.55	0.06	0.22	insert into event_t ( poid_DB,...
1f9918t43pbmq	10,306.28	11,057.89	130.45	3.39	2,493,996	1,441	246,279	246,278	0.04	0.04	0.00	0.00	10.13	0.01	1.00	6.17	2.42	0.29	0.01	0.36	0.01	0.35	insert into using_trafficaccou...
5c0d20xn9qbhm	7,243.77	8,594.74	125.31	1,225.18	2,947,221	122,468	131,843	131,843	0.05	0.07	0.00	0.01	22.35	0.93	1.00	4.34	1.88	0.28	2.46	0.42	0.76	0.19	insert into event_t ( poid_DB,...
5jjcjby7bgz5q	2,860.63	3,155.24	176.20	53.95	7,018,945	6,699	283,495	283,498	0.01	0.01	0.00	0.00	24.76	0.02	1.00	1.71	0.69	0.40	0.11	1.01	0.04	0.40	delete from event_t where poid...
1sw0vhcv41vmh	1,872.24	2,213.14	122.15	1.95	2,567,753	680	229,235	229,302	0.01	0.01	0.00	0.00	11.20	0.00	1.00	1.12	0.48	0.27	0.00	0.37	0.00	0.32	delete from using_trafficaccou...
guvrp5smxrqac	1,639.91	3,402.74	170.66	1,598.02	6,523,719	261,610	302,790	302,790	0.01	0.01	0.00	0.01	21.55	0.86	1.00	0.98	0.74	0.38	3.21	0.94	1.63	0.43	insert into event_t ( poid_DB,...
61rcbymrd925x	1,591.65	8,503.33	928.91	6,015.17	55,740,145	2,031,954	11,120,201	11,120,403	0.00	0.00	0.00	0.00	5.01	0.18	1.00	0.95	1.86	2.09	12.08	8.02	12.63	15.67	select poid_DB, poid_ID0, poid...

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	16	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO block miss count	884	0.25	0.00	0.08	0.03	0.06	0.12
Batched IO buffer defrag count	62	0.02	0.00	0.01	0.00	0.00	0.01
Batched IO double miss count	258	0.07	0.00	0.02	0.01	0.02	0.03
Batched IO same unit count	150	0.04	0.00	0.01	0.02	0.00	0.03
Batched IO single block count	142	0.04	0.00	0.01	0.01	0.01	0.02
Batched IO slow jump count	5	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO vector block count	588	0.16	0.00	0.05	0.02	0.04	0.07
Batched IO vector read count	128	0.04	0.00	0.01	0.00	0.01	0.01
Block Cleanout Optim referenced	413,771	114.76	0.20	28.69	19.23	0.15	41.07
CCursor + sql area evicted	10	0.00	0.00	0.00	0.00	0.00	0.00
CPU used by this session	3,653,869	1,013.44	1.80	253.36	152.47	26.45	351.01
CPU used when call started	3,296,639	914.36	1.63	228.59	145.87	11.49	322.82
CR blocks created	321,248	89.10	0.16	22.28	14.84	0.41	31.76
Cached Commit SCN referenced	232,300	64.43	0.11	16.11	10.30	6.25	30.60
Commit SCN cached	683,926	189.69	0.34	47.42	30.65	1.79	66.32
DB time	40,505,132	11,234.55	19.98	2,808.64	1,784.93	151.67	3,884.31
DBWR checkpoint buffers written	1,304,221	361.74	0.64	90.44	75.74	7.63	179.96
DBWR checkpoints	40	0.01	0.00	0.00	0.00	0.00	0.00
DBWR fusion writes	1,125,324	312.12	0.56	78.03	52.24	0.15	110.95
DBWR object drop buffers written	1,208	0.34	0.00	0.11	0.01	0.10	0.12
DBWR tablespace checkpoint buffers written	5	0.00	0.00	0.00	0.00	0.00	0.00
DBWR thread checkpoint buffers written	15,665	4.34	0.01	4.34		4.34	4.34
DBWR transaction table writes	4,709	1.31	0.00	0.33	0.22	0.04	0.53
DBWR undo block writes	460,647	127.77	0.23	31.94	20.66	1.20	45.27
DFO trees parallelized	828	0.23	0.00	0.06	0.11	0.00	0.22
HSC Heap Segment Block Changes	6,839,256	1,896.94	3.37	474.24	307.38	16.46	658.41
Heap Segment Array Inserts	712	0.20	0.00	0.05	0.01	0.04	0.06
Heap Segment Array Updates	357	0.10	0.00	0.02	0.01	0.01	0.04
Number of read IOs issued	455	0.13	0.00	0.04	0.02	0.03	0.06
PX local messages recv'd	3,264	0.91	0.00	0.23	0.43	0.01	0.87
PX local messages sent	3,264	0.91	0.00	0.23	0.43	0.01	0.87
PX remote messages recv'd	10,080	2.80	0.00	0.70	0.43	0.48	1.34
PX remote messages sent	10,080	2.80	0.00	0.70	0.43	0.48	1.34
Parallel operations not downgraded	828	0.23	0.00	0.06	0.11	0.00	0.22
RowCR - row contention	23,771	6.59	0.01	2.20	0.24	1.96	2.44
RowCR attempts	4,314,315	1,196.62	2.13	398.87	24.03	371.20	414.39
RowCR hits	4,579,718	1,270.23	2.26	423.41	25.58	393.88	438.37
SMON posted for undo segment shrink	476	0.13	0.00	0.03	0.02	0.00	0.05
SQL*Net roundtrips to/from client	157,100,593	43,573.55	77.49	10,893.39	7,171.16	194.90	15,292.61
active txn count during cleanout	1,649,111	457.40	0.81	114.35	77.49	0.13	171.89
application wait time	5,467,530	1,516.49	2.70	379.12	391.33	0.02	731.62
background checkpoints completed	13	0.00	0.00	0.00	0.00	0.00	0.00
background checkpoints started	12	0.00	0.00	0.00	0.00	0.00	0.00
background timeouts	120,934	33.54	0.06	8.39	3.07	6.84	12.99
branch node splits	312	0.09	0.00	0.02	0.01	0.00	0.03
buffer is not pinned count	201,839,268	55,982.35	99.56	13,995.59	8,508.73	1,296.33	18,997.56
buffer is pinned count	85,775,187	23,790.76	42.31	5,947.69	2,532.64	2,175.20	7,626.06
bytes received via SQL*Net from client	16,842,287,769	4,671,382.17	8,307.64	1,167,845.54	844,538.98	18,498.23	2,048,504.08
bytes sent via SQL*Net to client	25,171,313,439	6,981,538.18	12,416.03	1,745,384.54	1,099,291.05	114,565.75	2,483,205.91
calls to get snapshot scn: kcmgss	62,555,344	17,350.41	30.86	4,337.60	2,769.36	212.34	6,151.79
calls to kcmgas	15,276,690	4,237.16	7.54	1,059.29	685.20	34.45	1,467.55
calls to kcmgcs	9,784,601	2,713.87	4.83	678.47	448.15	9.04	940.87
cell IO uncompressed bytes	4,946,526,208	1,372,014.39	2,439.93	1,372,014.39		1,372,014.39	1,372,014.39
cell blocks helped by minscn optimization	622,481	172.66	0.31	172.66		172.66	172.66
cell blocks processed by cache layer	622,493	172.66	0.31	172.66		172.66	172.66
cell blocks processed by data layer	603,824	167.48	0.30	167.48		167.48	167.48
cell blocks processed by txn layer	622,493	172.66	0.31	172.66		172.66	172.66
cell flash cache read hits	11,346,224	3,147.00	5.60	786.75	535.20	6.90	1,222.60
cell physical IO bytes eligible for predicate offload	16,641,392,640	4,615,811.00	8,208.55	4,615,811.00		4,615,811.00	4,615,811.00
cell physical IO bytes saved by storage index	11,697,520,640	3,244,532.81	5,769.93	3,244,532.81		3,244,532.81	3,244,532.81
cell physical IO interconnect bytes	225,631,863,632	62,581,424.14	111,295.41	15,645,356.04	10,215,162.68	629,140.42	23,331,723.20
cell physical IO interconnect bytes returned by smart scan	407,065,936	112,907.58	200.79	112,907.58		112,907.58	112,907.58
cell scans	2	0.00	0.00	0.00		0.00	0.00
cell session smart scan efficiency	80	0.02	0.00	0.02		0.02	0.02
cell simulated session smart scan efficiency	4,946,526,208	1,372,014.39	2,439.93	1,372,014.39		1,372,014.39	1,372,014.39
change write time	23,794	6.60	0.01	1.65	1.07	0.06	2.38
cleanout - number of ktugct calls	1,748,929	485.08	0.86	121.27	81.05	0.74	175.94
cleanouts and rollbacks - consistent read gets	336,022	93.20	0.17	23.30	15.88	0.03	33.92
cleanouts only - consistent read gets	315,956	87.63	0.16	21.91	14.54	0.20	30.79
cluster key scan block gets	9,484	2.63	0.00	0.66	0.30	0.41	1.03
cluster key scans	9,230	2.56	0.00	0.64	0.27	0.41	0.96
cluster wait time	16,698,011	4,631.38	8.24	1,157.84	774.05	1.73	1,636.67
commit batch/immediate performed	13,294	3.69	0.01	0.92	0.62	0.01	1.36
commit batch/immediate requested	13,294	3.69	0.01	0.92	0.62	0.01	1.36
commit cleanout failures: block lost	328,447	91.10	0.16	22.77	15.25	0.01	31.41
commit cleanout failures: buffer being written	2,393	0.66	0.00	0.17	0.11	0.00	0.25
commit cleanout failures: callback failure	708,739	196.58	0.35	49.14	32.82	0.31	70.89
commit cleanout failures: cannot pin	41,196	11.43	0.02	2.86	1.96	0.03	4.53
commit cleanouts	16,816,934	4,664.36	8.30	1,166.09	757.73	39.92	1,676.28
commit cleanouts successfully completed	15,736,159	4,364.59	7.76	1,091.15	707.66	39.57	1,569.24
commit immediate performed	13,294	3.69	0.01	0.92	0.62	0.01	1.36
commit immediate requested	13,294	3.69	0.01	0.92	0.62	0.01	1.36
commit txn count during cleanout	2,225,162	617.17	1.10	154.29	98.95	7.13	212.98
concurrency wait time	901,973	250.17	0.44	62.54	43.90	0.03	102.71
consistent changes	2,359,572	654.46	1.16	163.61	75.93	66.71	236.35
consistent gets	613,710,479	170,219.82	302.72	42,554.95	17,081.48	17,375.31	54,429.51
consistent gets - examination	253,109,387	70,202.64	124.85	17,550.66	11,756.59	68.55	24,879.71
consistent gets direct	2,031,875	563.58	1.00	187.86	325.30	0.04	563.48
consistent gets from cache	611,678,630	169,656.25	301.72	42,414.06	17,358.42	16,811.83	54,429.51
consistent gets from cache (fastpath)	338,341,834	93,843.31	166.89	23,460.83	4,774.26	16,703.16	27,701.30
cursor authentications	41	0.01	0.00	0.00	0.00	0.00	0.00
data blocks consistent reads - undo records applied	570,523	158.24	0.28	39.56	26.83	0.62	57.34
db block changes	54,184,280	15,028.60	26.73	3,757.15	2,347.73	261.14	5,314.79
db block gets	81,287,671	22,546.03	40.10	5,636.51	3,408.52	565.76	7,943.30
db block gets direct	1,601	0.44	0.00	0.11	0.08	0.00	0.17
db block gets from cache	81,286,070	22,545.58	40.10	5,636.40	3,408.45	565.76	7,943.14
db block gets from cache (fastpath)	21,165,139	5,870.38	10.44	1,467.60	970.19	20.51	2,078.67
deferred (CURRENT) block cleanout applications	2,186,598	606.48	1.08	151.62	91.01	16.09	210.90
dirty buffers inspected	1,099,493	304.95	0.54	76.24	100.37	0.00	221.00
enqueue conversions	34,945	9.69	0.02	2.42	2.98	0.48	6.77
enqueue releases	12,240,895	3,395.14	6.04	848.79	551.79	61.10	1,349.37
enqueue requests	12,245,350	3,396.38	6.04	849.09	551.64	61.67	1,349.69
enqueue timeouts	4,547	1.26	0.00	0.32	0.24	0.00	0.57
enqueue waits	470,120	130.39	0.23	32.60	22.13	1.13	48.65
exchange deadlocks	990,476	274.72	0.49	68.68	47.24	0.00	106.63
execute count	70,954,486	19,680.00	35.00	4,920.00	3,266.14	48.68	6,937.30
file io wait time	36,148,861,066	10,026,270.65	17,830.83	2,506,567.66	1,674,732.54	83,823.48	3,939,916.93
free buffer inspected	26,890,458	7,458.36	13.26	1,864.59	1,245.19	30.42	2,801.40
free buffer requested	27,516,347	7,631.96	13.57	1,907.99	1,245.03	68.79	2,822.50
gc CPU used by this session	543,268	150.68	0.27	37.67	15.37	14.89	47.99
gc blocks compressed	3,558,429	986.97	1.76	246.74	164.09	0.74	332.48
gc cr block build time	5,746	1.59	0.00	0.40	0.27	0.00	0.56
gc cr block flush time	1,386,344	384.52	0.68	96.13	64.51	0.03	137.91
gc cr block receive time	1,494,600	414.54	0.74	103.64	68.11	1.52	139.48
gc cr block send time	6,836	1.90	0.00	0.47	0.32	0.00	0.66
gc cr blocks received	4,070,409	1,128.97	2.01	282.24	179.72	13.36	386.40
gc cr blocks served	4,069,955	1,128.85	2.01	282.21	187.79	0.75	383.16
gc current block flush time	2,225,008	617.13	1.10	154.28	102.96	0.01	211.49
gc current block pin time	10,542,189	2,923.99	5.20	731.00	497.11	0.00	1,094.72
gc current block receive time	3,914,523	1,085.74	1.93	271.43	181.08	0.20	375.50
gc current block send time	12,635	3.50	0.01	0.88	0.58	0.00	1.20
gc current blocks received	7,410,915	2,055.50	3.66	513.87	337.79	8.36	709.51
gc current blocks served	7,410,317	2,055.33	3.66	513.83	342.10	0.96	696.47
gc kbytes saved	10,274,508	2,849.75	5.07	712.44	473.55	2.50	961.09
gc kbytes sent	81,567,675	22,623.68	40.23	5,655.92	3,765.53	11.24	7,677.77
gc local grants	4,183,452	1,160.32	2.06	290.08	205.31	2.09	487.55
gc reader bypass grants	261,924	72.65	0.13	18.16	12.16	0.04	26.07
gc remote grants	11,452,935	3,176.59	5.65	794.15	533.25	6.45	1,186.01
gcs messages sent	53,677,696	14,888.12	26.48	3,722.03	1,737.35	1,149.42	4,952.07
ges messages sent	708,217	196.43	0.35	49.11	21.29	26.32	77.80
global enqueue get time	6,178,920	1,713.80	3.05	428.45	405.40	0.53	790.96
global enqueue gets async	61,712	17.12	0.03	4.28	0.49	3.56	4.60
global enqueue gets sync	9,225,451	2,558.78	4.55	639.70	390.69	56.57	868.18
global enqueue releases	9,144,031	2,536.20	4.51	634.05	390.52	51.22	863.01
heap block compress	214,400	59.47	0.11	14.87	9.87	0.22	21.14
hot buffers moved to head of LRU	7,798,811	2,163.08	3.85	540.77	365.56	9.86	840.88
immediate (CR) block cleanout applications	651,993	180.84	0.32	45.21	30.36	0.24	64.71
immediate (CURRENT) block cleanout applications	1,896,660	526.06	0.94	131.51	88.24	2.23	201.20
index crx upgrade (positioned)	17,019	4.72	0.01	1.18	1.32	0.20	3.13
index fast full scans (full)	157	0.04	0.00	0.01	0.01	0.00	0.02
index fetch by key	53,516,551	14,843.40	26.40	3,710.85	2,479.28	32.54	5,220.53
index scans kdiixs1	46,579,492	12,919.33	22.98	3,229.83	2,155.22	23.05	4,593.04
leaf node 90-10 splits	1,403	0.39	0.00	0.10	0.05	0.02	0.15
leaf node splits	64,204	17.81	0.03	4.45	2.88	0.16	6.23
lob reads	673,426	186.78	0.33	62.26	9.22	53.92	72.16
lob writes	513,925	142.54	0.25	35.64	24.23	0.03	53.62
lob writes unaligned	513,925	142.54	0.25	35.64	24.23	0.03	53.62
logons cumulative	5,560	1.54	0.00	0.39	0.22	0.25	0.72
max cf enq hold time	30	0.01	0.00	0.01		0.01	0.01
messages received	2,558,976	709.76	1.26	177.44	107.27	18.45	252.37
messages sent	2,558,978	709.76	1.26	177.44	107.27	18.45	252.37
min active SCN optimization applied on CR	5,689,964	1,578.17	2.81	394.54	264.88	0.07	554.91
no work - consistent read gets	337,839,332	93,703.93	166.64	23,425.98	4,813.91	16,667.85	27,757.80
non-idle wait count	328,720,666	91,174.25	162.15	22,793.56	14,832.66	658.26	31,990.24
non-idle wait time	39,665,370	11,001.63	19.57	2,750.41	1,807.32	60.56	3,881.39
opened cursors cumulative	785,090	217.76	0.39	54.44	59.25	11.94	140.08
parse count (describe)	3	0.00	0.00	0.00		0.00	0.00
parse count (failures)	16	0.00	0.00	0.00		0.00	0.00
parse count (hard)	6,426	1.78	0.00	0.45	0.29	0.01	0.63
parse count (total)	474,904	131.72	0.23	32.93	35.12	11.55	85.05
parse time cpu	1,848	0.51	0.00	0.13	0.06	0.09	0.21
parse time elapsed	1,929	0.54	0.00	0.13	0.08	0.04	0.23
physical read IO requests	14,117,858	3,915.74	6.96	978.93	644.93	43.25	1,517.03
physical read bytes	131,845,849,088	36,568,986.74	65,034.42	9,142,246.68	3,273,799.91	4,684,274.94	12,526,848.43
physical read requests optimized	11,435,525	3,171.76	5.64	792.94	523.19	31.65	1,222.62
physical read total IO requests	14,221,394	3,944.46	7.01	986.11	644.76	50.61	1,523.64
physical read total bytes	144,144,274,944	39,980,093.30	71,100.76	9,995,023.33	3,718,840.99	4,860,132.56	13,674,461.28
physical read total multi block requests	140,394	38.94	0.07	9.74	17.00	0.89	35.22
physical reads	16,094,467	4,463.99	7.94	1,116.00	399.63	571.81	1,529.16
physical reads cache	14,032,955	3,892.19	6.92	973.05	665.08	8.05	1,527.62
physical reads cache prefetch	59,016	16.37	0.03	4.09	4.75	0.41	11.06
physical reads direct	2,061,512	571.80	1.02	142.95	280.54	1.50	563.76
physical reads direct (lob)	455	0.13	0.00	0.04	0.02	0.03	0.06
physical reads direct temporary tablespace	15,975	4.43	0.01	1.48	0.02	1.46	1.50
physical write IO requests	2,609,718	723.83	1.29	180.96	118.56	6.48	265.47
physical write bytes	27,657,011,200	7,670,971.81	13,642.13	1,917,742.95	1,244,877.33	64,401.22	2,747,145.50
physical write total IO requests	3,548,002	984.08	1.75	246.02	151.93	21.10	348.15
physical write total bytes	48,736,463,872	13,517,587.15	24,039.80	3,379,396.79	2,188,004.49	128,134.70	4,820,643.37
physical write total multi block requests	44,082	12.23	0.02	3.06	2.01	0.09	4.43
physical writes	3,376,100	936.40	1.67	234.10	151.96	7.86	335.34
physical writes direct	22,770	6.32	0.01	1.58	1.17	0.11	2.97
physical writes direct temporary tablespace	15,976	4.43	0.01	1.11	0.74	0.00	1.50
physical writes from cache	3,353,330	930.08	1.65	232.52	151.04	7.76	333.72
physical writes non checkpoint	3,086,930	856.19	1.52	214.05	142.56	3.21	318.03
pinned buffers inspected	19,978	5.54	0.01	1.39	0.94	0.01	2.08
pinned cursors current	12	0.00	0.00	0.00	0.00	0.00	0.00
prefetch clients - default	1	0.00	0.00	0.00		0.00	0.00
prefetched blocks aged out before use	56	0.02	0.00	0.01	0.01	0.00	0.01
process last non-idle time	395,487	109.69	0.20	27.42	46.36	1.00	96.60
queries parallelized	552	0.15	0.00	0.04	0.07	0.00	0.14
recursive calls	45,209,355	12,539.31	22.30	3,134.83	2,035.67	90.24	4,354.72
recursive cpu usage	63,688	17.66	0.03	4.42	1.72	1.90	5.65
redo blocks checksummed by FG (exclusive)	4,585,159	1,271.74	2.26	317.94	209.47	6.39	452.31
redo blocks written	20,197,011	5,601.86	9.96	1,400.47	903.29	53.69	1,967.29
redo buffer allocation retries	12,869	3.57	0.01	0.89	0.70	0.00	1.69
redo entries	31,073,959	8,618.70	15.33	2,154.68	1,398.50	67.16	3,019.01
redo k-bytes read total	10,243,378	2,841.11	5.05	710.28	475.77	20.12	1,026.20
redo log space requests	14,116	3.92	0.01	0.98	0.76	0.01	1.82
redo log space wait time	15,102	4.19	0.01	1.05	0.75	0.05	1.63
redo ordering marks	348,755	96.73	0.17	24.18	15.49	1.07	33.88
redo size	9,774,457,684	2,711,052.13	4,821.36	677,763.03	439,386.71	22,744.36	954,321.60
redo size for direct writes	13,164,800	3,651.40	6.49	912.85	624.77	22.82	1,405.80
redo subscn max counts	183,857	50.99	0.09	12.75	8.85	1.19	21.28
redo synch time	7,721,431	2,141.62	3.81	535.41	341.42	32.91	794.26
redo synch writes	2,038,665	565.45	1.01	141.36	84.47	16.12	199.91
redo wastage	228,401,624	63,349.80	112.66	15,837.45	8,025.84	3,818.36	20,297.43
redo write broadcast ack count	4,702	1.30	0.00	0.33	0.21	0.02	0.43
redo write broadcast ack time	8,182,522	2,269.52	4.04	567.38	302.54	118.17	777.29
redo write time	1,017,104	282.11	0.50	70.53	35.31	17.56	88.59
redo writes	691,727	191.86	0.34	47.96	22.93	13.58	60.04
rollback changes - undo records applied	54,979	15.25	0.03	3.81	2.57	0.02	5.66
rollbacks only - consistent read gets	20,441	5.67	0.01	1.42	0.70	0.40	2.00
root node splits	2	0.00	0.00	0.00		0.00	0.00
rows fetched via callback	39,820,962	11,044.77	19.64	2,761.19	1,839.89	22.75	3,927.18
session cursor cache hits	599,763	166.35	0.30	55.45	53.90	6.47	113.20
session logical reads	694,998,122	192,765.84	342.82	48,191.46	20,430.51	17,940.97	61,465.78
shared hash latch upgrades - no wait	14,971,794	4,152.59	7.39	1,038.15	698.06	2.53	1,515.74
shared hash latch upgrades - wait	5,346	1.48	0.00	0.37	0.25	0.00	0.56
sorts (memory)	2,620,235	726.75	1.29	181.69	118.68	7.59	270.72
sorts (rows)	11,237,213	3,116.83	5.54	779.21	854.44	217.13	2,038.04
sql area evicted	39	0.01	0.00	0.00	0.00	0.00	0.01
sql area purged	4,255	1.18	0.00	0.30	0.20	0.00	0.42
summed dirty queue length	40,280,594	11,172.25	19.87	2,793.06	1,950.26	0.01	4,394.09
switch current to new buffer	386,969	107.33	0.19	26.83	16.08	5.30	44.21
table fetch by rowid	94,290,743	26,152.62	46.51	6,538.15	3,215.30	1,723.88	8,292.35
table fetch continued row	21,477	5.96	0.01	1.49	0.98	0.02	2.07
table scan blocks gotten	241,563,439	67,000.73	119.15	16,750.18	1,543.02	15,484.95	18,723.06
table scan rows gotten	6,648,469,321	1,844,045.29	3,279.43	461,011.32	133,496.12	344,443.15	611,634.80
table scans (direct read)	2	0.00	0.00	0.00		0.00	0.00
table scans (long tables)	2	0.00	0.00	0.00		0.00	0.00
table scans (short tables)	2,715,140	753.07	1.34	188.27	126.26	1.49	277.39
total cf enq hold time	129,080	35.80	0.06	8.95	4.37	6.29	15.48
total number of cf enq holders	1,419	0.39	0.00	0.10	0.01	0.09	0.12
total number of times SMON posted	1,639	0.45	0.00	0.11	0.17	0.00	0.36
transaction lock background gets	4	0.00	0.00	0.00		0.00	0.00
transaction lock foreground requests	4	0.00	0.00	0.00		0.00	0.00
transaction lock foreground wait time	27	0.01	0.00	0.01		0.01	0.01
transaction rollbacks	13,294	3.69	0.01	0.92	0.62	0.01	1.36
transaction tables consistent read rollbacks	75	0.02	0.00	0.01	0.01	0.00	0.02
transaction tables consistent reads - undo records applied	1,178	0.33	0.00	0.11	0.19	0.00	0.32
undo change vector size	3,065,108,268	850,141.08	1,511.90	212,535.27	137,396.91	7,870.34	301,335.39
user I/O wait time	4,978,098	1,380.73	2.46	345.18	238.22	2.22	551.18
user calls	156,945,009	43,530.40	77.41	10,882.60	7,176.54	178.38	15,295.17
user commits	2,024,137	561.42	1.00	140.35	83.92	16.01	198.91
user rollbacks	3,187	0.88	0.00	0.22	0.15	0.03	0.39
workarea executions - onepass	84	0.02	0.00	0.01	0.00	0.01	0.01
workarea executions - optimal	3,154,148	874.84	1.56	218.71	141.52	6.98	300.31
write clones created in background	97	0.03	0.00	0.01	0.01	0.00	0.02
write clones created in foreground	3,511	0.97	0.00	0.24	0.16	0.00	0.35

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)	1,675,197	464.64	0.83	116.16	35.40	96.67	169.15
acks for commit broadcast(logical)	1,970,302	546.49	0.97	136.62	26.83	121.79	176.83
broadcast msgs on commit(actual)	1,971,076	546.70	0.97	136.68	65.11	39.02	170.82
broadcast msgs on commit(logical)	2,074,518	575.39	1.02	143.85	68.76	40.73	180.05
broadcast msgs on commit(wasted)	406,340	112.70	0.20	28.18	17.46	2.02	37.80
broadcast on commit wait time(ms)	5,777	1.60	0.00	0.40	0.20	0.09	0.52
broadcast on commit waits	4,762	1.32	0.00	0.33	0.21	0.02	0.44
gcs assume cvt	265,132	73.54	0.13	18.38	17.47	6.63	44.29
gcs assume no cvt	5,183,570	1,437.73	2.56	359.43	34.63	317.18	401.75
gcs ast xid	16,097	4.46	0.01	1.49	0.06	1.42	1.53
gcs blocked converts	7,108,768	1,971.71	3.51	492.93	71.07	402.79	555.15
gcs blocked cr converts	4,021,353	1,115.37	1.98	278.84	43.16	234.17	329.05
gcs compatible basts	55,351	15.35	0.03	3.84	1.18	2.47	5.34
gcs compatible cr basts (global)	738,338	204.79	0.36	51.20	11.19	41.53	63.62
gcs cr basts to PIs	2,271	0.63	0.00	0.16	0.01	0.14	0.17
gcs cr serve without current lock	42	0.01	0.00	0.00	0.00	0.00	0.00
gcs dbwr flush pi msgs	1,213,212	336.50	0.60	84.12	56.34	0.14	119.55
gcs dbwr write request msgs	945,990	262.38	0.47	65.59	56.36	0.11	127.97
gcs error msgs	2	0.00	0.00	0.00		0.00	0.00
gcs forward cr to pinged instance	3,893	1.08	0.00	0.27	0.03	0.23	0.31
gcs immediate (compatible) converts	667,578	185.16	0.33	46.29	6.07	38.88	53.51
gcs immediate (null) converts	1,364,758	378.53	0.67	94.63	14.51	77.34	111.94
gcs immediate cr (compatible) converts	6,029,926	1,672.48	2.97	418.12	59.23	340.60	483.73
gcs immediate cr (null) converts	6,723,195	1,864.76	3.32	466.19	65.20	379.10	536.50
gcs indirect ast	11,086,665	3,075.03	5.47	768.76	50.83	734.49	844.10
gcs indirect bidless ast	180,803	50.15	0.09	12.54	4.68	9.08	19.38
gcs indirect fg ast	11,084,756	3,074.50	5.47	768.63	50.73	734.44	843.82
gcs lms flush pi msgs	624,327	173.17	0.31	43.29	20.50	31.57	73.99
gcs lms write request msgs	612,997	170.02	0.30	42.51	12.44	31.85	59.83
gcs msgs process time(ms)	957,162	265.48	0.47	66.37	20.09	36.53	79.62
gcs msgs received	53,655,177	14,881.95	26.47	3,720.49	294.01	3,293.56	3,950.17
gcs new served by master	181,409	50.32	0.09	12.58	3.60	8.69	16.95
gcs out-of-order msgs	4,068	1.13	0.00	0.28	0.46	0.04	0.96
gcs pings refused	30,088	8.35	0.01	2.09	1.30	1.23	4.03
gcs queued converts	443,691	123.06	0.22	30.77	33.93	10.79	81.56
gcs reader bypass N->Xw ping local	1,696	0.47	0.00	0.12	0.03	0.09	0.15
gcs reader bypass N->Xw ping remote	1,790	0.50	0.00	0.12	0.08	0.03	0.22
gcs reader bypass grant X on assume	2,193	0.61	0.00	0.15	0.07	0.07	0.22
gcs reader bypass grant fg ast	168,502	46.74	0.08	11.68	7.78	0.03	15.75
gcs reader bypass grant immediate	271,083	75.19	0.13	18.80	2.36	15.94	21.68
gcs refuse xid	10,867	3.01	0.01	1.00	0.12	0.91	1.14
gcs regular cr	2,067,530	573.46	1.02	143.37	85.48	89.39	270.95
gcs retry convert request	6	0.00	0.00	0.00		0.00	0.00
gcs side channel msgs actual	259,776	72.05	0.13	18.01	9.06	4.42	22.61
gcs side channel msgs logical	22,754,353	6,311.17	11.22	1,577.79	1,041.60	27.86	2,269.22
gcs stale cr	1	0.00	0.00	0.00		0.00	0.00
gcs undo cr	49,233	13.66	0.02	4.55	0.46	4.05	4.96
gcs write notification msgs	57,864	16.05	0.03	4.01	3.69	0.04	8.23
gcs writes refused	7,626	2.12	0.00	0.53	0.08	0.42	0.59
ges msgs process time(ms)	10,621	2.95	0.01	0.74	0.34	0.26	1.06
ges msgs received	708,224	196.43	0.35	49.11	18.28	29.18	73.17
global posts queue time	265	0.07	0.00	0.04	0.05	0.00	0.07
global posts queued	315	0.09	0.00	0.02	0.04	0.00	0.08
global posts requested	315	0.09	0.00	0.02	0.04	0.00	0.08
global posts sent	315	0.09	0.00	0.02	0.04	0.00	0.08
implicit batch messages received	1,026,566	284.73	0.51	71.18	5.49	65.13	78.26
implicit batch messages sent	1,026,916	284.83	0.51	71.21	46.52	3.17	106.98
lmd msg send time(ms)	176	0.05	0.00	0.05		0.05	0.05
messages flow controlled	163,111	45.24	0.08	11.31	7.44	0.21	15.98
messages queue sent actual	26,752,682	7,420.18	13.20	1,855.04	540.08	1,065.27	2,278.51
messages queue sent logical	2,235,035	619.91	1.10	154.98	101.89	6.53	235.63
messages received actual	51,000,008	14,145.50	25.16	3,536.38	272.34	3,144.92	3,760.47
messages received logical	54,360,905	15,077.69	26.81	3,769.42	310.16	3,322.17	4,023.15
messages sent directly	24,243,772	6,724.27	11.96	1,681.07	1,077.46	78.17	2,399.30
messages sent indirectly	21,766,314	6,037.13	10.74	1,509.28	881.93	199.21	2,113.81
messages sent not implicit batched	839	0.23	0.00	0.08	0.01	0.06	0.09
messages sent pbatched	23,004,244	6,380.51	11.35	1,595.13	371.11	1,069.21	1,941.39
msgs causing lmd to send msgs	216,593	60.07	0.11	15.02	7.42	9.20	25.83
msgs causing lms(s) to send msgs	14,664,819	4,067.45	7.23	1,016.86	769.49	534.67	2,153.76
msgs received queue time (ms)	432,184	119.87	0.21	29.97	5.90	21.19	34.04
msgs received queued	54,357,802	15,076.83	26.81	3,769.21	310.02	3,322.20	4,022.97
msgs sent queue time (ms)	472,134	130.95	0.23	32.74	20.06	2.91	45.48
msgs sent queue time on ksxp (ms)	125,758,875	34,880.60	62.03	8,720.15	5,387.97	705.41	12,326.23
msgs sent queued	27,814,184	7,714.60	13.72	1,928.65	588.90	1,067.83	2,391.11
msgs sent queued on ksxp	50,983,505	14,140.86	25.15	3,535.21	1,613.83	1,145.37	4,674.83
process batch messages received	19,858,388	5,507.97	9.80	1,376.99	310.29	911.70	1,538.88
process batch messages sent	20,737,414	5,751.78	10.23	1,437.94	281.34	1,042.47	1,706.50

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	93	94	140	137	3,777,311	3,780,230
2	245	244	43,190	43,175	90,082,473	90,098,965
3	219	218	43,131	43,064	10,773,772	10,780,887
4	225	224	43,131	43,120	5,563,936	5,565,820
Sum	782	780	129,592	129,496	110,197,492	110,225,902
Avg	196	195	32,398	32,374	27,549,373	27,556,476
Std	69	68	21,505	21,491	41,794,257	41,800,646

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	0.26	0.08	0.00	0.14	0.07	0.00	0.03	18.28	9.68	0.27	24.47	7.46	0.07	15.80
2	11.59	10.44	0.04	4.64	2.62	0.02	0.97	1,346.32	1,334.30	4.15	336.63	242.75	1.09	89.74
3	15.16	13.79	0.01	5.48	3.08	0.01	1.12	1,761.53	1,753.48	0.16	402.53	307.39	0.10	92.67
4	12.19	10.96	0.01	4.79	2.71	0.01	1.05	1,411.25	1,400.48	0.10	378.63	281.31	0.10	95.12
Sum	39.20	35.27	0.07	15.05	8.49	0.04	3.17	4,537.38	4,497.95	4.67	1,142.25	838.90	1.36	293.35
Avg	9.80	8.82	0.02	3.76	2.12	0.01	0.79	1,134.35	1,124.49	1.17	285.56	209.73	0.34	73.34

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	6.85	6.67	0.00	0.14	0.08	0.00	0.03	71.14	63.39	0.00	24.47	7.55	0.00	15.80
2	11.60	10.49	0.01	4.64	2.63	0.01	0.97	1,346.71	1,339.32	0.10	336.63	244.29	0.10	89.71
3	15.15	13.79	0.01	5.48	3.08	0.01	1.12	1,761.67	1,754.26	0.12	402.50	307.40	0.10	92.62
4	12.18	10.96	0.01	4.79	2.72	0.01	1.05	1,411.37	1,401.19	0.10	378.53	281.25	0.10	95.06
Sum	45.78	41.91	0.03	15.05	8.51	0.03	3.17	4,590.89	4,558.16	0.32	1,142.12	840.49	0.30	293.18
Avg	11.45	10.48	0.01	3.76	2.13	0.01	0.79	1,147.72	1,139.54	0.08	285.53	210.12	0.07	73.30

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 87.8% of Total Logical Reads: 694,998,122
Captured Segments account for 78.2% of Total Physical Reads: 16,094,467
Captured Segments account for 75.4% of Total Physical Read Requests: 14,117,858
Captured Segments account for 73.5% of Total UnOptimized Read Requests: 2,682,333
Captured Segments account for 75.8% of Total Optimized Read Requests: 11,435,525
Captured Segments account for 98.5% of Total Direct Physical Reads: 2,061,512
Captured Segments account for 68.6% of Total Physical Writes: 3,376,100
Captured Segments account for 79.6% of Total Physical Write Requests: 2,609,718
Captured Segments account for 4.3% of Total Direct Physical Writes: 22,770
Captured Segments account for 6.9% of Total Table Scans: 159
Captured Segments account for 80.6% of Total CR Blocks Received: 4,070,409
Captured Segments account for 89.0% of Total Current Blocks Received: 7,410,915
Captured Segments account for 80.6% of Total CR Blocks Served: 4,069,955
Captured Segments account for 89.0% of Total Current Blocks Served: 7,410,317

Statistic	Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Value	%Total	%Capture
buffer busy waits	PIN	PINX00	IDX_BILLLOG_TIMESTAMP	P_R_02292012	INDEX PARTITION	196,343		42.38
	PIN	PINX00	BILL_LOG_IDX	P_R_02292012	INDEX PARTITION	144,305		31.15
	PIN	PIN02	DATA_T		TABLE	72,801		15.72
	PIN	PIN00	EVENT_T	P_R_02292012	TABLE PARTITION	25,946		5.60
	PIN	PINX01	I_EVENT_EVENT__NO	P_R_02292012	INDEX PARTITION	23,863		5.15
db block changes	PIN	PINX02	I_EVENT__SERVOBJ_END_T	P_R_02292012	INDEX PARTITION	1,457,024		22.31
	PIN	PINX00	I_EVENT__ACCTOBJ_END_T	P_R_02292012	INDEX PARTITION	1,436,464		22.00
	PIN	PIN00	EVENT_T	P_R_02292012	TABLE PARTITION	1,435,376		21.98
	PIN	PINX02	I_EVENT_ITEM_OBJ__ID	P_R_02292012	INDEX PARTITION	1,293,504		19.81
	PIN	PINX00	I_EVENT__ID	P_R_02292012	INDEX PARTITION	908,288		13.91
gc buffer busy	PIN	PINX00	BILL_LOG_IDX	P_R_02292012	INDEX PARTITION	569,947		27.06
	PIN	PIN00	EVENT_T	P_R_02292012	TABLE PARTITION	554,475		26.32
	PIN	PINX00	IDX_BILLLOG_TIMESTAMP	P_R_02292012	INDEX PARTITION	544,208		25.84
	PIN	PINX01	I_EVENT_EVENT__NO	P_R_02292012	INDEX PARTITION	228,291		10.84
	PIN	PIN02	DATA_T		TABLE	209,496		9.95
gc cr blocks received	PIN	PINX00	I_EVENT__ID	P_R_02292012	INDEX PARTITION	340,814	8.37	25.33
	PIN	PINX00	IDX_USING_MSISDN		INDEX	266,562	6.55	19.82
	PIN	PIN00	USING_TRAFFICACCOUNT_COUNT_T		TABLE	256,885	6.31	19.10
	PIN	PINX00	IDX_USING_POID_ID0		INDEX	243,541	5.98	18.10
	PIN	PIN00	EVENT_T	P_R_02292012	TABLE PARTITION	237,442	5.83	17.65
gc cr blocks served	PIN	PINX00	I_EVENT__ID	P_R_02292012	INDEX PARTITION	340,814	8.37	25.33
	PIN	PINX00	IDX_USING_MSISDN		INDEX	266,562	6.55	19.82
	PIN	PIN00	USING_TRAFFICACCOUNT_COUNT_T		TABLE	256,885	6.31	19.10
	PIN	PINX00	IDX_USING_POID_ID0		INDEX	243,541	5.98	18.10
	PIN	PIN00	EVENT_T	P_R_02292012	TABLE PARTITION	237,442	5.83	17.65
gc cu blocks received	PIN	PIN00	EVENT_T	P_R_02292012	TABLE PARTITION	475,821	6.42	22.25
	PIN	PINX00	I_EVENT__ID	P_R_02292012	INDEX PARTITION	457,055	6.17	21.38
	PIN	PINX02	I_EVENT__SERVOBJ_END_T	P_R_02292012	INDEX PARTITION	434,234	5.86	20.31
	PIN	PINX00	I_EVENT__ACCTOBJ_END_T	P_R_02292012	INDEX PARTITION	395,489	5.34	18.50
	PIN	PINX02	I_EVENT_ITEM_OBJ__ID	P_R_02292012	INDEX PARTITION	375,648	5.07	17.57
gc cu blocks served	PIN	PIN00	EVENT_T	P_R_02292012	TABLE PARTITION	475,821	6.42	22.25
	PIN	PINX00	I_EVENT__ID	P_R_02292012	INDEX PARTITION	457,055	6.17	21.38
	PIN	PINX02	I_EVENT__SERVOBJ_END_T	P_R_02292012	INDEX PARTITION	434,234	5.86	20.31
	PIN	PINX00	I_EVENT__ACCTOBJ_END_T	P_R_02292012	INDEX PARTITION	395,489	5.34	18.50
	PIN	PINX02	I_EVENT_ITEM_OBJ__ID	P_R_02292012	INDEX PARTITION	375,648	5.07	17.57
itl waits	PIN	PINX00	BILL_LOG_IDX	P_R_02292012	INDEX PARTITION	44		31.65
	PIN	PINX00	IDX_USING_MSGID		INDEX	27		19.42
	PIN	PINX00	IDX_SUBSCRIBE_REC_DATE	P_R_02292012	INDEX PARTITION	26		18.71
	PIN	PINX00	IDX_BILLLOG_TIMESTAMP	P_R_02292012	INDEX PARTITION	24		17.27
	PIN	PINX00	IDX_SUBSCRIBERECORD_CREATED	P_R_02292012	INDEX PARTITION	18		12.95
logical reads	PIN	PIN02	DEAL_T		TABLE	137,754,656	19.82	43.81
	PIN	PIN00	BOSS_STMM_T		TABLE	51,404,832	7.40	16.35
	PIN	PINX02	I_ACCOUNT__ID		INDEX	42,563,072	6.12	13.54
	PIN	PINX02	I_PURCHASED_PRODUCT__ID		INDEX	41,615,648	5.99	13.23
	PIN	PIN02	SYNCINFO_SUBSCRIPTION_T		TABLE	41,115,040	5.92	13.08
optimized physical reads	PIN	PIN02	PURCHASED_PRODUCT_T		TABLE	1,936,990	16.94	37.88
	PIN	PINX02	I_PURCHASED_PRODUCT__ID		INDEX	1,563,266	13.67	30.57
	PIN	PINX00	I_SERVICE__LOGIN		INDEX	563,675	4.93	11.02
	PIN	PIN01	ACCOUNT_T		TABLE	527,395	4.61	10.31
	PIN	PIN02	SERVICE_T		TABLE	522,146	4.57	10.21
physical reads	PIN	PIN02	PURCHASED_PRODUCT_T		TABLE	2,510,666	15.60	33.34
	SYS	SYSTEM	AUD$		TABLE	2,031,421	12.62	26.98
	PIN	PINX02	I_PURCHASED_PRODUCT__ID		INDEX	1,818,760	11.30	24.15
	PIN	PINX00	I_SERVICE__LOGIN		INDEX	588,087	3.65	7.81
	PIN	PIN01	ACCOUNT_T		TABLE	581,131	3.61	7.72
physical reads direct	SYS	SYSTEM	AUD$		TABLE	2,031,420		100.00
physical read requests	PIN	PIN02	PURCHASED_PRODUCT_T		TABLE	2,510,549	17.78	41.31
	PIN	PINX02	I_PURCHASED_PRODUCT__ID		INDEX	1,818,757	12.88	29.93
	PIN	PINX00	I_SERVICE__LOGIN		INDEX	588,080	4.17	9.68
	PIN	PIN01	ACCOUNT_T		TABLE	581,130	4.12	9.56
	PIN	PIN02	SERVICE_T		TABLE	578,545	4.10	9.52
physical writes	PIN	PINX02	I_EVENT__SERVOBJ_END_T	P_R_02292012	INDEX PARTITION	198,463		23.07
	PIN	PINX00	I_EVENT__ACCTOBJ_END_T	P_R_02292012	INDEX PARTITION	196,166		22.81
	PIN	PINX01	IDX_BILLLOG_ACCOUNT_OBJ	P_R_02292012	INDEX PARTITION	178,223		20.72
	PIN	PIN02	BAL_GRP_T		TABLE	160,354		18.64
	PIN	PINX02	I_EVENT_ITEM_OBJ__ID	P_R_02292012	INDEX PARTITION	126,927		14.76
physical writes direct	SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_381251694_17004	TABLE PARTITION	984		100.00
physical write requests	PIN	PINX02	I_EVENT__SERVOBJ_END_T	P_R_02292012	INDEX PARTITION	189,683	7.27	22.89
	PIN	PINX00	I_EVENT__ACCTOBJ_END_T	P_R_02292012	INDEX PARTITION	188,490	7.22	22.75
	PIN	PINX01	IDX_BILLLOG_ACCOUNT_OBJ	P_R_02292012	INDEX PARTITION	170,166	6.52	20.54
	PIN	PIN02	BAL_GRP_T		TABLE	157,495	6.03	19.01
	PIN	PINX02	I_EVENT_ITEM_OBJ__ID	P_R_02292012	INDEX PARTITION	122,747	4.70	14.81
row lock waits	PIN	PIN02	DATA_T		TABLE	249,952		63.67
	PIN	PINX00	IDX_BILLLOG_TIMESTAMP	P_R_02292012	INDEX PARTITION	78,232		19.93
	PIN	PINX00	BILL_LOG_IDX	P_R_02292012	INDEX PARTITION	41,217		10.50
	PIN	PINX01	I_EVENT_EVENT__NO	P_R_02292012	INDEX PARTITION	12,645		3.22
	PIN	PIN02	BAL_GRP_T		TABLE	10,543		2.69
table scans	SYS	SYSTEM	I_OBJ2		INDEX	9		81.82
	SYS	SYSTEM	AUD$		TABLE	2		18.18

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
APP CONTEXT	7	0.00	7	0.00	0	0	0	0	0
BODY	11,869	0.00	147,337	0.00	0	0	0	147,255	147,255
DBLINK	3,944	0.00	0		0	0	3,944	0	0
EDITION	2,110	0.00	4,119	0.00	0	0	2,110	2,110	2,110
INDEX	34	0.00	31	0.00	0	0	31	31	31
QUEUE	22,007	0.00	27,600	0.00	0	0	14,446	27,600	27,600
RULESET	6	0.00	6	0.00	0	0	0	6	6
SCHEMA	3,952	0.00	0		0	0	2,009	0	0
SQL AREA	259,957	5.06	71,579,128	0.27	178,080	6,420	0	0	0
SUBSCRIPTION	19	0.00	19	0.00	0	0	0	19	19
TABLE/PROCEDURE	16,942	0.00	403,181	1.06	4,249	0	30,387	399,852	399,852
TRANSFORMATION	7,190	0.00	7,190	0.00	0	0	7,190	7,190	7,190
TRIGGER	31,100	0.00	31,286	0.00	0	0	0	31,286	31,286

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,416.00	28,416.00	25,141.54	25,144.15	858.80	861.93	0.00	0.00	0.00	0.00	1,024.00	1,024.00
2	22,528.00	22,528.00	18,907.69	18,916.17	2,206.31	2,204.02	1.32	2.74	0.00	0.00	1,024.00	1,024.00
3	32,512.00	32,512.00	28,037.15	28,035.01	1,962.29	1,965.04	2.84	4.53	0.00	0.00	1,024.00	1,024.00
4	20,736.00	20,736.00	17,398.67	17,406.04	2,341.93	2,338.97	0.78	2.31	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	640.57	633.90			6.54	6.47	12.13	12.15	81.08	81.08	81.08	81.08	98	98	98	98
	Freeable	210.63	216.88	0.00	0.00	3.05	3.10	10.68	10.61	72.44	72.44			69	70	69	70
	PL/SQL	6.12	6.13	5.72	5.75	0.06	0.06	0.23	0.23	1.66	1.66	1.67	1.67	96	96	95	95
	SQL	1.50	1.52	0.92	0.94	0.02	0.02	0.03	0.03	0.20	0.20	51.51	51.51	66	66	58	58
2	Other	1,649.72	1,654.44			6.60	6.64	5.45	5.48	40.71	40.71	40.71	40.71	250	249	250	249
	Freeable	246.69	238.75	0.00	0.00	1.12	1.09	0.95	0.90	11.94	12.06			221	219	221	219
	SQL	190.06	183.93	129.99	123.94	0.87	0.85	0.64	0.56	4.00	4.02	90.89	90.89	218	217	208	207
	PL/SQL	119.88	119.90	117.32	117.38	0.48	0.49	6.78	6.79	106.75	106.81	106.78	106.85	248	247	247	246
3	Other	1,545.34	1,543.91			6.90	6.92	5.63	5.64	45.27	45.27	45.27	45.27	224	223	224	223
	Freeable	225.19	227.88	0.00	0.00	1.17	1.17	0.98	0.98	11.88	11.88			193	194	193	194
	SQL	178.89	177.40	119.09	117.87	0.94	0.93	0.48	0.47	3.99	4.01	22.58	22.58	191	191	180	181
	PL/SQL	12.90	15.88	10.78	13.67	0.06	0.07	0.18	0.27	1.66	2.95	1.76	2.95	222	221	221	220
4	Other	1,658.98	1,662.28			7.21	7.29	7.53	7.54	66.64	66.64	66.64	66.64	230	228	230	228
	Freeable	488.19	482.56	0.00	0.00	2.43	2.40	9.36	9.36	93.75	93.75			201	201	201	201
	SQL	184.89	178.69	124.32	118.06	0.94	0.91	0.57	0.44	5.03	3.04	25.75	25.75	197	196	188	188
	PL/SQL	9.91	9.83	7.85	7.83	0.04	0.04	0.10	0.10	1.57	1.57	1.64	1.64	228	226	227	225

Back to Memory Statistics
Back to Top

Supplemental Information

init.ora Parameters
Complete List of SQL Text

init.ora Parameters

'*' indicates same value across all instances

Parameter Name	I#	Begin value
_gc_policy_time	*	0
audit_file_dest	*	/u01/app/oracle/admin/aaadb/adump
audit_trail	*	DB
cluster_database	*	TRUE
compatible	*	11.2.0.0.0
control_files	*	+DATA/aaadb/control01.ctl, +DATA/aaadb/control02.ctl
cursor_sharing	*	FORCE
db_block_size	*	8192
db_domain	*
db_file_multiblock_read_count	*	16
db_files	*	5000
db_name	*	aaadb
db_recovery_file_dest	*	+RECO
db_recovery_file_dest_size	*	6291456000000
db_writer_processes	*	2
diagnostic_dest	*	/u01/app/oracle
dispatchers	*	(PROTOCOL=TCP) (SERVICE=aaadbXDB)
instance_number	1	1
	2	2
	3	3
	4	4
local_listener	1	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aaa01-vip.shmcc.com)(PORT=1521))))
	2	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aaa02-vip.shmcc.com)(PORT=1521))))
	3	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aaa03-vip.shmcc.com)(PORT=1521))))
	4	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aaa04-vip.shmcc.com)(PORT=1521))))
memory_max_target	*	54223962112
memory_target	*	54223962112
open_cursors	*	6000
processes	*	1500
recyclebin	*	OFF
remote_listener	*	aaa-scan:1521
remote_login_passwordfile	*	EXCLUSIVE
sec_case_sensitive_logon	*	FALSE
service_names	1	BRM1_SRV, BRM_SERVICE, BRM4_SRV
	2	BRM2_SRV, MAINTENANCE_SERVICE, BRM_SERVICE
	3	BRM_SERVICE, BRM3_SRV
	4	BRM4_SRV, BRM1_SRV, BRM_SERVICE, BRM3_SRV
session_cached_cursors	*	400
sessions	*	2272
spfile	*	+DATA/aaadb/spfileaaadb.ora
thread	1	1
	2	2
	3	3
	4	4
undo_tablespace	1	UNDOTBS1
	2	UNDOTBS2
	3	UNDOTBS3
	4	UNDOTBS4

Back to Supplemental Information
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0v25hwd7t2bus insert into billlog_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, msgid, streamno, timestamp, billtimpid, chargenodeid, ordernum, oa, oaoperateid, cdrtype, chargepartytype, msisdn, spid, pserviceid, serviceid, servicetype, chargemode, sessionbegintime, sessionendtime, times, fee, chargeresult, srcdevicetype, srcdeviceid, destdevicetype, destdeviceid, paytype, spbenifitrate, duration, amount, prediscountfee, spbenifitfee, bearertype, bearerprotocoltype, uplinkvolume, unlinkvolume, contenttype, bsspcardtype, bsspaccounttype, aapnodeno, provinceid, operatetype, servicestatus, currency, pkgspid, pkgserviceid, pkgproductid, spname, channelid, programid, parentnodeid, created_t, mod_t, read_access, write_access, apn, chargingid, bsspcardnumber, bsspsignedinfobytp, bsspservicename, bsspuserid, da, daoperateid, fa, faoperateid, qos, RoamingOperatorID, servicename, imsi, sessionsign, transactionid ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :account_obj_DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :msgid, :streamno, :timestamp, :billtimpid, :chargenodeid, :ordernum, :oa, :oaoperateid, :cdrtype, :chargepartytype, :msisdn, :spid, :pserviceid, :serviceid, :servicetype, :chargemode, :sessionbegintime, :sessionendtime, :times, :fee, :chargeresult, :srcdevicetype, :srcdeviceid, :destdevicetype, :destdeviceid, :paytype, :spbenifitrate, :duration, :amount, :prediscountfee, :spbenifitfee, :bearertype, :bearerprotocoltype, :uplinkvolume, :unlinkvolume, :contenttype, :bsspcardtype, :bsspaccounttype, :aapnodeno, :provinceid, :operatetype, :servicestatus, :currency, :pkgspid, :pkgserviceid, :pkgproductid, :spname, :channelid, :programid, :parentnodeid, :created_t, :mod_t, :read_access, :write_access, :apn, :chargingid, :bsspcardnumber, :bsspsignedinfobytp, :bsspservicename, :bsspuserid, :da, :daoperateid, :fa, :faoperateid, :qos, :RoamingOperatorID, :servicename, :imsi, :sessionsign, :transactionid )

1f9918t43pbmq insert into using_trafficaccount_count_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, msisdn, serviceID, productID, srcdeviceid, channelID, msgid, msgtype, opertiontime, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, created_t, mod_t, read_access, write_access, srcdevicetype ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :msisdn, :serviceID, :productID, :srcdeviceid, :channelID, :msgid, :msgtype, :opertiontime, :account_obj_DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :created_t, :mod_t, :read_access, :write_access, :srcdevicetype )

1sw0vhcv41vmh delete from using_trafficaccount_count_t where poid_id0 = :1

2trtpvb5jtr53 SELECT TO_CHAR(current_timestamp AT TIME ZONE :"SYS_B_0", :"SYS_B_1") AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != :"SYS_B_2" AND TO_CHAR(timestamp, :"SYS_B_3") >= TO_CHAR(current_timestamp - TO_DSINTERVAL(:"SYS_B_4"), :"SYS_B_5")

32n55pzn51541 select poid_DB, poid_ID0, poid_TYPE, poid_REV, name, descr from event_t where event_t.event_no = :1

3ffmts3uvw1z5 select syncinfo_t.account_obj_DB, syncinfo_t.account_obj_ID0, syncinfo_t.account_obj_TYPE, syncinfo_t.account_obj_REV, syncinfo_t.protocol, syncinfo_t.subprotocol, syncinfo_t.datatype, syncinfo_t.poid_DB, syncinfo_t.poid_ID0, syncinfo_t.poid_TYPE, syncinfo_t.poid_REV from syncinfo_t , syncinfo_subscription_t , account_t , account_nameinfo_t where syncinfo_t.poid_TYPE = :1 and syncinfo_t.account_obj_ID0 = account_t.poid_ID0 and syncinfo_t.priority >= :2 and syncinfo_t.priority <= :3 and syncinfo_t.operatenum < :4 and syncinfo_t.flag = :5 and account_nameinfo_t.state != :6 and syncinfo_t.poid_id0 = syncinfo_subscription_t.obj_id0 and account_t.poid_id0 = account_nameinfo_t.obj_id0 order by syncinfo_subscription_t.subscriptionvalidtime asc

3mg8tsjnf7myu select bal_grp_sub_bals_t.rec_id, bal_grp_sub_bals_t.rec_id2, bal_grp_sub_bals_t.contributor, bal_grp_sub_bals_t.valid_to, bal_grp_sub_bals_t.valid_to_details, bal_grp_sub_bals_t.valid_from, bal_grp_sub_bals_t.valid_from_details, bal_grp_sub_bals_t.current_bal, bal_grp_sub_bals_t.next_bal, bal_grp_sub_bals_t.delayed_bal, bal_grp_sub_bals_t.rollover_data, bal_grp_sub_bals_t.grantor_obj_DB, bal_grp_sub_bals_t.grantor_obj_ID0, bal_grp_sub_bals_t.grantor_obj_TYPE, bal_grp_sub_bals_t.grantor_obj_REV from bal_grp_sub_bals_t where bal_grp_sub_bals_t.obj_id0 = :1 and ( bal_grp_sub_bals_t.valid_to = :2 or bal_grp_sub_bals_t.valid_to >= :3 or bal_grp_sub_bals_t.valid_to IS NULL ) order by bal_grp_sub_bals_t.rec_id

3q72620j7sw4q select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, name, login, status, created_t from service_t where service_t.account_obj_ID0 = :1

4636378wmh2bp update data_t set poid_rev = poid_rev + :"SYS_B_0", header_num=header_num+:header_num where poid_id0 = :poid_id0

499pvd5n5hru4 select poid_DB, poid_ID0, poid_TYPE, poid_REV, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV from service_t where service_t.login = :1

4pxz3dag5j1av select poid_DB, poid_ID0, poid_TYPE, poid_REV, name from deal_t where deal_t.poid_id0 = :1

55xz19mt7dvy4 select status, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, poid_DB, poid_ID0, poid_TYPE, poid_REV from service_t where service_t.login = :1

56nmjy6g1aky8 select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, descr, end_t, flags, name, permitted, start_t from deal_t where deal_t.name = :1

5c0d20xn9qbhm insert into event_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, name, userid_DB, userid_ID0, userid_TYPE, userid_REV, session_obj_DB, session_obj_ID0, session_obj_TYPE, session_obj_REV, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, program_name, start_t, end_t, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, sys_descr, rum_name, unit, tod_mode, net_quantity, min_quantity, incr_quantity, min_unit, incr_unit, rounding_mode, timezone_mode, rated_timezone_id, unrated_quantity, currency, item_obj_DB, item_obj_ID0, item_obj_TYPE, item_obj_REV, invoice_data, earned_start_t, earned_end_t, earned_type, effective_t, created_t, mod_t, read_access, write_access, archive_status, batch_id, descr, event_no, flags, group_obj_DB, group_obj_ID0, group_obj_TYPE, group_obj_REV, loader_batch_obj_DB, loader_batch_obj_ID0, loader_batch_obj_TYPE, loader_batch_obj_REV, cli_ipaddr, original_batch_id, profile_label_list, provider_descr, provider_id_DB, provider_id_ID0, provider_id_TYPE, provider_id_REV, provider_ipaddr, rerate_obj_DB, rerate_obj_ID0, rerate_obj_TYPE, rerate_obj_REV, tax_locales, tax_supplier, timezone_adj_end_t, timezone_adj_start_t, timezone_id, usage_type ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :name, :userid_DB, :userid_ID0, :userid_TYPE, :userid_REV, :session_obj_DB, :session_obj_ID0, :session_obj_TYPE, :session_obj_REV, :account_obj_ DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :program_name, :start_t, :end_t, :service_obj_DB, :service_obj_ID0, :service_obj_TYPE, :service_obj_REV, :sys_descr, :rum_name, :unit, :tod_mode, :net_quantity, :min_quantity, :incr_quantity, :min_unit, :incr_unit, :rounding_mode, :timezone_mode, :rated_timezone_id, :unrated_quantity, :currency, :item_obj_DB, :item_obj_ID0, :item_obj_TYPE, :item_obj_REV, :invoice_data, :earned_start_t, :earned_end_t, :earned_type, :effective_t, :created_t, :mod_t, :read_access, :write_access, :archive_status, :batch_id, :descr, :event_no, :flags, :group_obj_DB, :group_obj_ID0, :group_obj_TYPE, :group_obj_REV, :loader_batch_obj_DB, :loader_batch_obj_ID0, :loader_batch_obj_TYPE, :loader_batch_obj_REV, :cli_ipaddr, :original_batch_id, :profile_label_list, :provider_descr, :provider_id_DB, :provider_id_ID0, :provider_id_TYPE, :provider_id_REV, :provider_ipaddr, :rerate_obj_DB, :rerate_obj_ID0, :rerate_obj_TYPE, :rerate_obj_REV, :tax_locales, :tax_supplier, :timezone_adj_end_t, :timezone_adj_start_t, :timezone_id, :usage_type )

5c5qmkf7dptb1 select poid_DB, poid_ID0, poid_TYPE, poid_REV, account_type from account_t where account_t.poid_id0 = :1

5jjcjby7bgz5q delete from event_t where poid_id0 = :1

5pjdr1a04pvzq delete from syncinfo_subscription_t where obj_id0 = :1

607hhqjzab9h6 select state from account_nameinfo_t where obj_id0 = :1 and rec_id = :2

61rcbymrd925x select poid_DB, poid_ID0, poid_TYPE, poid_REV, package_id, deal_obj_DB, deal_obj_ID0, deal_obj_TYPE, deal_obj_REV from purchased_product_t where purchased_product_t.poid_id0 = :1

6cqzzxua36gcg select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, cycle_end_details, cycle_end_t, cycle_start_details, cycle_start_t, deal_obj_DB, deal_obj_ID0, deal_obj_TYPE, deal_obj_REV, descr, discount_obj_DB, discount_obj_ID0, discount_obj_TYPE, discount_obj_REV, effective_t, flags, instantiated_t, node_location, object_cache_type, package_id, plan_obj_DB, plan_obj_ID0, plan_obj_TYPE, plan_obj_REV, purchase_end_details, purchase_end_t, purchase_start_details, purchase_start_t, quantity, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, status, status_flags, usage_end_details, usage_end_t, usage_start_details, usage_start_t from purchased_discount_t where ( purchased_discount_t.status = :1 OR purchased_discount_t.status = :2 ) AND purchased_discount_t.account_obj_ID0 = :3

6d5tfynxyu3gr select poid_DB, poid_ID0, poid_TYPE, poid_REV from bal_grp_t where bal_grp_t.account_obj_ID0 = :1 order by bal_grp_t.poid_id0 for update of bal_grp_t.poid_id0

6w4q4kh8cprmu select poid_DB, poid_ID0, poid_TYPE, poid_REV from account_t where account_t.poid_ID0 = :1

8562a4usc37q4 SELECT NVL(A.SESSIONBEGINTIME, A.TIMESTAMP) SESSIONBEGINTIME, NVL(A.SESSIONENDTIME, A.TIMESTAMP) SESSIONENDTIME, A.TIMESTAMP, A.CHARGEMODE, A.FEE, A.DURATION, NVL(A.SERVICEID, A.PKGPRODUCTID) PRODUCTID, NVL(A.PSERVICEID, A.PKGSERVICEID) CONTENTID, NVL(B.PRODUCTNAME, A.SERVICENAME) PRODUCTNAME FROM (SELECT T.*, ROW_NUMBER() OVER (PARTITION BY T.MSISDN, T.SERVICEID, T.PSERVICEID, T.TIMESTAMP, T.FEE ORDER BY 1) AS RN FROM BILLLOG_T T WHERE T.ACCOUNT_OBJ_ID0 = :B3 AND T.TIMESTAMP >= :B2 AND T.TIMESTAMP <= :B1 AND (CHARGEMODE NOT IN (0, 13, 15) OR (CHARGEMODE IN (0, 13, 15) AND FEE = 0)) ) A , V_MCC_PRODUCTINFO B WHERE A.SERVICEID = B.PRODUCTID(+) AND A.RN = 1 UNION SELECT NVL(A.SESSIONBEGINTIME, A.TIMESTAMP) SESSIONBEGINTIME, NVL(A.SESSIONENDTIME, A.TIMESTAMP) SESSIONENDTIME, A.TIMESTAMP, A.CHARGEMODE, A.FEE, A.DURATION, NVL(A.SERVICEID, A.PKGPRODUCTID) PRODUCTID, NVL(A.PSERVICEID, A.PKGSERVICEID) CONTENTID, NVL(B.PRODUCTNAME, A.SERVICENAME) PRODUCTNAME FROM V_WWW_BOSS_BILLINFO A , V_MCC_PRODUCTINFO B WHERE A.SERVICEID = B.PRODUCTID(+) AND A.MSISDN = :B4 AND A.TIMESTAMP >= :B2 AND A.TIMESTAMP <= :B1

87vd326hc3ar0 insert into event_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, name, userid_DB, userid_ID0, userid_TYPE, userid_REV, session_obj_DB, session_obj_ID0, session_obj_TYPE, session_obj_REV, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, program_name, start_t, end_t, sys_descr, earned_start_t, earned_end_t, earned_type, effective_t, created_t, mod_t, read_access, write_access, archive_status, batch_id, currency, descr, event_no, flags, group_obj_DB, group_obj_ID0, group_obj_TYPE, group_obj_REV, incr_quantity, incr_unit, invoice_data, item_obj_DB, item_obj_ID0, item_obj_TYPE, item_obj_REV, loader_batch_obj_DB, loader_batch_obj_ID0, loader_batch_obj_TYPE, loader_batch_obj_REV, min_quantity, min_unit, cli_ipaddr, net_quantity, original_batch_id, profile_label_list, provider_descr, provider_id_DB, provider_id_ID0, provider_id_TYPE, provider_id_REV, provider_ipaddr, rated_timezone_id, rerate_obj_DB, rerate_obj_ID0, rerate_obj_TYPE, rerate_obj_REV, rounding_mode, rum_name, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, tax_locales, tax_supplier, timezone_adj_end_t, timezone_adj_start_t, timezone_id, timezone_mode, tod_mode, unit, unrated_quantity, usage_type ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :name, :userid_DB, :userid_ID0, :userid_TYPE, :userid_REV, :session_obj_DB, :session_obj_ID0, :session_obj_TYPE, :session_obj_REV, :account_obj_ DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :program_name, :start_t, :end_t, :sys_descr, :earned_start_t, :earned_end_t, :earned_type, :effective_t, :created_t, :mod_t, :read_access, :write_access, :archive_status, :batch_id, :currency, :descr, :event_no, :flags, :group_obj_DB, :group_obj_ID0, :group_obj_TYPE, :group_obj_REV, :incr_quantity, :incr_unit, :invoice_data, :item_obj_DB, :item_obj_ID0, :item_obj_TYPE, :item_obj_REV, :loader_batch_obj_DB, :loader_batch_obj_ID0, :loader_batch_obj_TYPE, :loader_batch_obj_REV, :min_quantity, :min_unit, :cli_ipaddr, :net_quantity, :original_batch_id, :profile_label_list, :provider_descr, :provider_id_DB, :provider_id_ID0, :provider_id_TYPE, :provider_id_REV, :provider_ipaddr, :rated_timezone_id, :rerate_obj_DB, :rerate_obj_ID0, :rerate_obj_TYPE, :rerate_obj_REV, :rounding_mode, :rum_name, :service_obj_DB, :service_obj_ID0, :service_obj_TYPE, :service_obj_REV, :tax_locales, :tax_supplier, :timezone_adj_end_t, :timezone_adj_start_t, :timezone_id, :timezone_mode, :tod_mode, :unit, :unrated_quantity, :usage_type )

8fadd1k0568gc SELECT SQUENCE, BIPCODE, TRANSIDO, PKGSEQ, IDVAL, OPRCODE, SPID, SPBIZCODE, CREDATE, FLAG, ACTIONCODE, ACTIVITYCODE, PROCID, TRANSIDH, PROCESSTIME, TRANSIDC, CUTOFFDAY FROM (SELECT * FROM BOSS_STMM_T B ORDER BY B.CREDATE) WHERE FLAG='0' AND ROWNUM<=:B1

9f0p23w4gx24d select distinct event_t.poid_DB, event_t.poid_ID0, event_t.poid_TYPE, event_t.poid_REV, event_t.created_t, event_t.mod_t, event_t.read_access, event_t.write_access, event_t.account_obj_DB, event_t.account_obj_ID0, event_t.account_obj_TYPE, event_t.account_obj_REV, event_t.archive_status, event_t.batch_id, event_t.currency, event_t.descr, event_t.earned_end_t, event_t.earned_start_t, event_t.earned_type, event_t.effective_t, event_t.end_t, event_t.event_no, event_t.flags, event_t.group_obj_DB, event_t.group_obj_ID0, event_t.group_obj_TYPE, event_t.group_obj_REV, event_t.incr_quantity, event_t.incr_unit, event_t.invoice_data, event_t.item_obj_DB, event_t.item_obj_ID0, event_t.item_obj_TYPE, event_t.item_obj_REV, event_t.loader_batch_obj_DB, event_t.loader_batch_obj_ID0, event_t.loader_batch_obj_TYPE, event_t.loader_batch_obj_REV, event_t.min_quantity, event_t.min_unit, event_t.name, event_t.cli_ipaddr, event_t.net_quantity, event_t.original_batch_id, event_t.profile_label_list, event_t.program_name, event_t.provider_descr, event_t.provider_id_DB, event_t.provider_id_ID0, event_t.provider_id_TYPE, event_t.provider_id_REV, event_t.provider_ipaddr, event_t.rated_timezone_id, event_t.rerate_obj_DB, event_t.rerate_obj_ID0, event_t.rerate_obj_TYPE, event_t.rerate_obj_REV, event_t.rounding_mode, event_t.rum_name, event_t.service_obj_DB, event_t.service_obj_ID0, event_t.service_obj_TYPE, event_t.service_obj_REV, event_t.s ession_obj_DB, event_t.session_obj_ID0, event_t.session_obj_TYPE, event_t.session_obj_REV, event_t.start_t, event_t.sys_descr, event_t.tax_locales, event_t.tax_supplier, event_t.timezone_adj_end_t, event_t.timezone_adj_start_t, event_t.timezone_id, event_t.timezone_mode, event_t.tod_mode, event_t.unit, event_t.unrated_quantity, event_t.usage_type, event_t.userid_DB, event_t.userid_ID0, event_t.userid_TYPE, event_t.userid_REV from event_t , event_product_fee_cycle_t , event_billing_product_t where event_t.account_obj_ID0 = :1 and event_product_fee_cycle_t.cycle_end_t > :2 and event_product_fee_cycle_t.flags in ( :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21", :"SYS_B_22", :"SYS_B_23") and event_t.poid_TYPE = :3 and ( event_billing_product_t.offering_obj_ID0 = :4 ) and event_t.rerate_obj_ID0 = :5 and event_t.poid_id0 = event_product_fee_cycle_t.obj_id0 and event_t.poid_id0 = event_billing_product_t.obj_id0 and ((event_t.poid_ID0 >= :6 and event_t.poid_I D0 < :7))

adc95dp9cgt6h select poid_DB, poid_ID0, poid_TYPE, poid_REV, name from product_t where product_t.poid_id0 = :1

bmmnh389h4m7p select descr, poid_DB, poid_ID0, poid_TYPE, poid_REV from deal_t where deal_t.name = :1

cbuk77k0pggx7 select syncinfo_t.account_obj_DB, syncinfo_t.account_obj_ID0, syncinfo_t.account_obj_TYPE, syncinfo_t.account_obj_REV, syncinfo_t.protocol, syncinfo_t.subprotocol, syncinfo_t.datatype, syncinfo_t.poid_DB, syncinfo_t.poid_ID0, syncinfo_t.poid_TYPE, syncinfo_t.poid_REV from syncinfo_t , syncinfo_subscription_t , account_t , account_nameinfo_t where syncinfo_t.poid_TYPE = :1 and syncinfo_t.account_obj_ID0 = account_t.poid_ID0 and syncinfo_t.priority >= :2 and syncinfo_t.priority <= :3 and syncinfo_t.operatenum < :4 and syncinfo_t.flag = :5 and account_nameinfo_t.state is not null and syncinfo_t.poid_id0 = syncinfo_subscription_t.obj_id0 and account_t.poid_id0 = account_nameinfo_t.obj_id0 order by syncinfo_subscription_t.subscriptionvalidtime asc

cskd6zs6bc7s5 select serviceid, poid_DB, poid_ID0, poid_TYPE, poid_REV from subscriberecord_t where subscriberecord_t.msisdn = :1 and subscriberecord_t.operator = :2 and subscriberecord_t.subtype = :3 and subscriberecord_t.rec_date >= :4

d36p2zk77mu80 select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, cycle_discount, cycle_disc_amt, cycle_end_details, cycle_end_t, cycle_fee_amt, cycle_fee_flags, cycle_start_details, cycle_start_t, deal_obj_DB, deal_obj_ID0, deal_obj_TYPE, deal_obj_REV, descr, effective_t, flags, instantiated_t, mmc_type, node_location, object_cache_type, overridden_obj_DB, overridden_obj_ID0, overridden_obj_TYPE, overridden_obj_REV, package_id, plan_obj_DB, plan_obj_ID0, plan_obj_TYPE, plan_obj_REV, product_obj_DB, product_obj_ID0, product_obj_TYPE, product_obj_REV, purchase_discount, purchase_disc_amt, purchase_end_details, purchase_end_t, purchase_fee_amt, purchase_start_details, purchase_start_t, quantity, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, sponsor_obj_DB, sponsor_obj_ID0, sponsor_obj_TYPE, sponsor_obj_REV, status, status_flags, usage_discount, usage_end_details, usage_end_t, usage_start_details, usage_start_t from purchased_product_t where ( purchased_product_t.status = :1 OR purchased_product_t.status = :2 ) AND purchased_product_t.account_obj_ID0 = :3

d85uh8vskn4dq select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, channelid, effectivetime, chargemode, cpid, rec_date, msisdn, operator, spname, opertype, operstr, productname, reason, serviceid, subtype, endtime from subscriberecord_t where subscriberecord_t.account_obj_ID0 = :1 and subscriberecord_t.serviceid = :2 and ((subscriberecord_t.poid_ID0 >= :3 and subscriberecord_t.poid_ID0 <= :4)) order by subscriberecord_t.created_t desc

g71uftrcn0npd insert into event_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, program_name, name, event_no, start_t, end_t, earned_start_t, earned_end_t, earned_type, effective_t, created_t, mod_t, read_access, write_access, archive_status, batch_id, currency, descr, flags, group_obj_DB, group_obj_ID0, group_obj_TYPE, group_obj_REV, incr_quantity, incr_unit, invoice_data, item_obj_DB, item_obj_ID0, item_obj_TYPE, item_obj_REV, loader_batch_obj_DB, loader_batch_obj_ID0, loader_batch_obj_TYPE, loader_batch_obj_REV, min_quantity, min_unit, cli_ipaddr, net_quantity, original_batch_id, profile_label_list, provider_descr, provider_id_DB, provider_id_ID0, provider_id_TYPE, provider_id_REV, provider_ipaddr, rated_timezone_id, rerate_obj_DB, rerate_obj_ID0, rerate_obj_TYPE, rerate_obj_REV, rounding_mode, rum_name, session_obj_DB, session_obj_ID0, session_obj_TYPE, session_obj_REV, sys_descr, tax_locales, tax_supplier, timezone_adj_end_t, timezone_adj_start_t, timezone_id, timezone_mode, tod_mode, unit, unrated_quantity, usage_type, userid_DB, userid_ID0, userid_TYPE, userid_REV ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :account_obj_DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :service_obj_DB, :service_obj_ID0, :service_obj_TYPE, :service_obj_REV, : program_name, :name, :event_no, :start_t, :end_t, :earned_start_t, :earned_end_t, :earned_type, :effective_t, :created_t, :mod_t, :read_access, :write_access, :archive_status, :batch_id, :currency, :descr, :flags, :group_obj_DB, :group_obj_ID0, :group_obj_TYPE, :group_obj_REV, :incr_quantity, :incr_unit, :invoice_data, :item_obj_DB, :item_obj_ID0, :item_obj_TYPE, :item_obj_REV, :loader_batch_obj_DB, :loader_batch_obj_ID0, :loader_batch_obj_TYPE, :loader_batch_obj_REV, :min_quantity, :min_unit, :cli_ipaddr, :net_quantity, :original_batch_id, :profile_label_list, :provider_descr, :provider_id_DB, :provider_id_ID0, :provider_id_TYPE, :provider_id_REV, :provider_ipaddr, :rated_timezone_id, :rerate_obj_DB, :rerate_obj_ID0, :rerate_obj_TYPE, :rerate_obj_REV, :rounding_mode, :rum_name, :session_obj_DB, :session_obj_ID0, :session_obj_TYPE, :session_obj_REV, :sys_descr, :tax_locales, :tax_supplier, :timezone_adj_end_t, :timezone_adj_start_t, :timezone_id, :timezone_mode, :tod_mode, :unit, :unrated_quantity, :usage_type, :userid_DB, :userid_ID0, :userid_TYPE, :userid_REV )

guvrp5smxrqac insert into event_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, name, userid_DB, userid_ID0, userid_TYPE, userid_REV, session_obj_DB, session_obj_ID0, session_obj_TYPE, session_obj_REV, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, program_name, start_t, end_t, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, sys_descr, earned_start_t, earned_end_t, earned_type, effective_t, created_t, mod_t, read_access, write_access, archive_status, batch_id, currency, descr, event_no, flags, group_obj_DB, group_obj_ID0, group_obj_TYPE, group_obj_REV, incr_quantity, incr_unit, invoice_data, item_obj_DB, item_obj_ID0, item_obj_TYPE, item_obj_REV, loader_batch_obj_DB, loader_batch_obj_ID0, loader_batch_obj_TYPE, loader_batch_obj_REV, min_quantity, min_unit, cli_ipaddr, net_quantity, original_batch_id, profile_label_list, provider_descr, provider_id_DB, provider_id_ID0, provider_id_TYPE, provider_id_REV, provider_ipaddr, rated_timezone_id, rerate_obj_DB, rerate_obj_ID0, rerate_obj_TYPE, rerate_obj_REV, rounding_mode, rum_name, tax_locales, tax_supplier, timezone_adj_end_t, timezone_adj_start_t, timezone_id, timezone_mode, tod_mode, unit, unrated_quantity, usage_type ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :name, :userid_DB, :userid_ID0, :userid_TYPE, :userid_REV, :session_obj_DB, :session_obj_ID0, :session_obj_TYPE, :session_obj_REV, :account_obj_ DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :program_name, :start_t, :end_t, :service_obj_DB, :service_obj_ID0, :service_obj_TYPE, :service_obj_REV, :sys_descr, :earned_start_t, :earned_end_t, :earned_type, :effective_t, :created_t, :mod_t, :read_access, :write_access, :archive_status, :batch_id, :currency, :descr, :event_no, :flags, :group_obj_DB, :group_obj_ID0, :group_obj_TYPE, :group_obj_REV, :incr_quantity, :incr_unit, :invoice_data, :item_obj_DB, :item_obj_ID0, :item_obj_TYPE, :item_obj_REV, :loader_batch_obj_DB, :loader_batch_obj_ID0, :loader_batch_obj_TYPE, :loader_batch_obj_REV, :min_quantity, :min_unit, :cli_ipaddr, :net_quantity, :original_batch_id, :profile_label_list, :provider_descr, :provider_id_DB, :provider_id_ID0, :provider_id_TYPE, :provider_id_REV, :provider_ipaddr, :rated_timezone_id, :rerate_obj_DB, :rerate_obj_ID0, :rerate_obj_TYPE, :rerate_obj_REV, :rounding_mode, :rum_name, :tax_locales, :tax_supplier, :timezone_adj_end_t, :timezone_adj_start_t, :timezone_id, :timezone_mode, :tod_mode, :unit, :unrated_quantity, :usage_type )

Back to Supplemental Information
Back to Top

End of Report