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
3275181459	ZHBDB	YES	8192	49263	49264	4	4	4	4	203.10	60.19

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	zhbdb1	ora1a	07-Mar-13 05:20	20-Mar-13 10:00	20-Mar-13 11:00	11.2.0.1.0	60.20	66.90	317.66	1.11	AIX-Based Systems (64-bit)
2	zhbdb2	ora2a	07-Mar-13 05:23	20-Mar-13 10:00	20-Mar-13 11:00	11.2.0.1.0	60.20	42.44	317.63	0.70	AIX-Based Systems (64-bit)
3	zhbdb3	ora3a	07-Mar-13 05:24	20-Mar-13 10:00	20-Mar-13 11:00	11.2.0.1.0	60.20	56.50	317.61	0.94	AIX-Based Systems (64-bit)
4	zhbdb4	ora4a	07-Mar-13 05:34	20-Mar-13 10:00	20-Mar-13 11:00	11.2.0.1.0	60.20	37.26	317.43	0.62	AIX-Based Systems (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	76,800	61,440	50,048	9,984	640	128	256	15,360	104.23
2	76,800	61,440	51,712	8,448	640	128	128	15,360	104.23
3	76,800	61,440	51,712	8,448	640	128	128	15,360	104.23
4	76,800	61,440	51,456	8,704	640	128	128	15,360	104.23
Avg	76,800	61,440	51,232	8,896	640	128	160	15,360	104.23
Min	76,800	61,440	50,048	8,448	640	128	128	15,360	104.23
Max	76,800	61,440	51,712	9,984	640	128	256	15,360	104.23

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	Load Begin	Load End	% Busy	% Usr	% Sys	% WIO	% Idl	Busy Time (s)	Idle Time (s)	Total Time (s)	Memory (M)
1	32	16	7.22	5.87	4.37	2.63	1.75	0.39	95.63	5,097.64	111,421.86	116,519.50	131,072.00
2	32	16	3.81	8.79	3.15	1.56	1.58	0.32	96.85	3,670.86	112,947.95	116,618.81	131,072.00
3	32	16	5.60	4.54	3.93	2.16	1.78	0.44	96.07	4,586.44	111,972.25	116,558.69	131,072.00
4	32	16	5.37	4.91	3.07	1.43	1.64	0.29	96.93	3,577.24	113,095.33	116,672.57	131,072.00
Sum										16,932.18	449,437.39	466,369.57

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	4,014.21	2,054.40	2,889.46	708.94	651.52	139.25	1,059.22	323.55
2	2,546.11	1,197.25	1,717.26	576.34	532.20	11.78	872.86	311.79
3	3,389.92	1,952.31	2,686.16	471.86	431.89	34.35	784.62	292.83
4	2,235.86	1,041.40	1,432.37	548.46	502.71	13.36	891.16	292.10
Sum	12,186.10	6,245.36	8,725.25	2,305.60	2,118.33	198.74	3,607.87	1,220.27
Avg	3,046.53	1,561.34	2,181.31	576.40	529.58	49.69	901.97	305.07
Std	808.69	516.03	714.75	98.79	91.55	60.59	114.69	15.33

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	Hard Parse %DB time	% Total bg time	bg CPU %bg time
1	32.94	51.18	71.98	17.66	16.23	29.36	30.55
2	20.89	47.02	67.45	22.64	20.90	24.19	35.72
3	27.82	57.59	79.24	13.92	12.74	21.75	37.32
4	18.35	46.58	64.06	24.53	22.48	24.70	32.78
Avg	25.00	50.59	70.68	19.69	18.09	25.00	34.09

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
	8.30	0.09	2.76	0.01	2.77	3.08	0.06	0.07	18.35	51.25

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	215.30	3.06	88.89	1.04	113.29	223.66	0.52	2.26	622.60	2,054.40	4,014.21
2	204.18	2.59	72.17	0.02	88.29	116.03	6.28	2.93	567.10	1,197.25	2,546.11
3	453.83	2.58	80.90	0.11	57.26	15.02	0.00	1.40	499.38	1,952.31	3,389.92
4	138.53	2.97	93.84	0.06	78.93	20.25	0.23	1.71	546.94	1,041.40	2,235.86
Sum	1,011.84	11.21	335.80	1.23	337.77	374.97	7.03	8.30	2,236.02	6,245.36	12,186.10
Avg	252.96	2.80	83.95	0.31	84.44	93.74	1.76	2.08	559.01	1,561.34	3,046.53
Std	138.13	0.25	9.49	0.49	23.21	98.28	3.02	0.67	51.02	516.03	808.69

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	5.36	0.08	2.21	0.03	2.82	5.57	0.01	0.06	15.51	51.18	32.94
2	8.02	0.10	2.83	0.00	3.47	4.56	0.25	0.11	22.27	47.02	20.89
3	13.39	0.08	2.39	0.00	1.69	0.44	0.00	0.04	14.73	57.59	27.82
4	6.20	0.13	4.20	0.00	3.53	0.91	0.01	0.08	24.46	46.58	18.35
Avg	8.24	0.10	2.91	0.01	2.88	2.87	0.07	0.07	19.24	50.59

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)
*		DB CPU			6,245.36		51.25					4
	System I/O	db file parallel write	457,319	0.00	1,455.64	3.18	11.95	3.17	2.98	3.43	0.19	4
	Cluster	gc current block busy	85,080	0.00	605.06	7.11	4.97	7.12	6.90	7.39	0.20	4
	User I/O	db file sequential read	103,110	0.00	562.73	5.46	4.62	5.81	4.26	6.66	1.07	4
	System I/O	log file parallel write	253,205	0.00	464.06	1.83	3.81	1.83	1.82	1.85	0.02	4
	Cluster	gc current block 3-way	443,951	0.00	369.85	0.83	3.03	0.83	0.82	0.85	0.01	4
	Cluster	gc current block 2-way	634,627	0.00	361.04	0.57	2.96	0.57	0.56	0.58	0.01	4
	Commit	log file sync	143,194	0.00	337.83	2.36	2.77	2.36	2.27	2.44	0.08	4
	Cluster	gc buffer busy acquire	63,391	0.47	280.89	4.43	2.31	5.47	2.82	7.80	2.25	4
	User I/O	direct path write temp	27,381	0.00	262.24	9.58	2.15	9.58	9.58	9.58		4
1		DB CPU			2,054.40		51.18
	System I/O	db file parallel write	131,744	0.00	451.48	3.43	11.25
	Cluster	gc current block busy	22,327	0.00	157.60	7.06	3.93
	User I/O	db file sequential read	26,006	0.00	154.57	5.94	3.85
	Concurrency	library cache pin	137,062	0.00	137.50	1.00	3.43
	System I/O	log file parallel write	74,254	0.00	135.07	1.82	3.36
	Commit	log file sync	46,878	0.00	113.30	2.42	2.82
	Cluster	gc current block 3-way	120,833	0.00	100.15	0.83	2.49
	Cluster	gc current block 2-way	157,948	0.00	92.00	0.58	2.29
	Cluster	gc buffer busy acquire	19,483	0.45	87.03	4.47	2.17
2		DB CPU			1,197.25		47.02
	System I/O	db file parallel write	110,097	0.00	327.55	2.98	12.86
	User I/O	db file sequential read	42,020	0.00	178.95	4.26	7.03
	Cluster	gc current block busy	20,055	0.00	142.85	7.12	5.61
	System I/O	log file parallel write	66,000	0.00	122.04	1.85	4.79
	Cluster	gc current block 3-way	119,538	0.00	98.31	0.82	3.86
	Cluster	gc current block 2-way	169,935	0.00	96.00	0.56	3.77
	Commit	log file sync	38,910	0.00	88.30	2.27	3.47
	Cluster	gc buffer busy acquire	27,853	0.26	78.59	2.82	3.09
	Other	gcs log flush sync	93,139	0.07	62.40	0.67	2.45
3		DB CPU			1,952.31		57.59
	System I/O	db file parallel write	100,017	0.00	313.89	3.14	9.26
	User I/O	direct path write temp	27,381	0.00	262.24	9.58	7.74
	Cluster	gc current block busy	20,354	0.00	150.37	7.39	4.44
	User I/O	db file sequential read	14,868	0.00	94.64	6.37	2.79
	System I/O	log file parallel write	49,991	0.00	92.43	1.85	2.73
	Cluster	gc current block 2-way	155,662	0.00	87.52	0.56	2.58
	Cluster	gc current block 3-way	100,478	0.00	83.85	0.83	2.47
	Other	DFS lock handle	52,699	50.22	63.27	1.20	1.87
	User I/O	direct path read temp	76,006	0.00	61.13	0.80	1.80
4		DB CPU			1,041.40		46.58
	System I/O	db file parallel write	115,461	0.00	362.72	3.14	16.22
	Cluster	gc current block busy	22,344	0.00	154.24	6.90	6.90
	User I/O	db file sequential read	20,216	0.00	134.56	6.66	6.02
	System I/O	log file parallel write	62,960	0.00	114.53	1.82	5.12
	Cluster	gc current block 3-way	103,102	0.00	87.54	0.85	3.92
	Cluster	gc current block 2-way	151,082	0.00	85.52	0.57	3.82
	Commit	log file sync	33,944	0.00	78.95	2.33	3.53
	Other	DFS lock handle	61,708	50.36	76.62	1.24	3.43
	Cluster	gc buffer busy acquire	9,978	0.74	67.87	6.80	3.04

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)
*		DB CPU			6,245.36		51.25					4
	Other	Data Pump slave startup	218	38.53	1,638.30	7515.15	24.97	3995.97	0.23	7991.71	5650.83	2
	User I/O	direct path write temp	222,460	0.00	1,321.03	5.94	10.84	6.59	3.36	9.58	2.93	4
	Cluster	gc current block busy	85,009	0.00	604.95	7.12	4.96	7.12	6.91	7.39	0.20	4
	User I/O	db file sequential read	102,399	0.00	559.07	5.46	4.59	5.82	4.25	6.67	1.09	4
	Other	log switch/archive	51	100.00	442.05	8667.58	11.01	8667.58	8667.58	8667.58		1
	User I/O	direct path read temp	362,043	0.00	415.81	1.15	3.41	0.87	0.49	1.45	0.41	4
	Cluster	gc current block 3-way	442,614	0.00	368.46	0.83	3.02	0.83	0.82	0.85	0.01	4
	Cluster	gc current block 2-way	632,815	0.00	360.01	0.57	2.95	0.57	0.56	0.58	0.01	4
	Commit	log file sync	143,184	0.00	337.77	2.36	2.77	2.36	2.27	2.44	0.08	4
1		DB CPU			2,054.40		51.18
	Other	log switch/archive	51	100.00	442.05	8667.58	11.01
	User I/O	direct path write temp	37,387	0.00	317.79	8.50	7.92
	Cluster	gc current block busy	22,312	0.00	157.58	7.06	3.93
	User I/O	db file sequential read	25,848	0.00	153.94	5.96	3.83
	Concurrency	library cache pin	135,543	0.00	135.99	1.00	3.39
	Commit	log file sync	46,876	0.00	113.29	2.42	2.82
	Network	SQL*Net message from dblink	2,438	0.00	107.90	44.26	2.69
	Cluster	gc current block 3-way	120,548	0.00	99.93	0.83	2.49
	Cluster	gc current block 2-way	157,634	0.00	91.86	0.58	2.29
2	Other	Data Pump slave startup	205	40.98	1,638.30	7991.71	64.35
		DB CPU			1,197.25		47.02
	User I/O	db file sequential read	41,818	0.00	177.58	4.25	6.97
	Cluster	gc current block busy	20,037	0.00	142.82	7.13	5.61
	Other	PX Nsq: PQ load info query	1,231	52.64	126.41	102.69	4.96
	Cluster	gc current block 3-way	119,181	0.00	97.67	0.82	3.84
	Cluster	gc current block 2-way	169,405	0.00	95.61	0.56	3.76
	Commit	log file sync	38,906	0.00	88.29	2.27	3.47
	Cluster	gc remaster	196	3.57	82.08	418.77	3.22
	User I/O	direct path write temp	24,107	0.00	80.98	3.36	3.18
3		DB CPU			1,952.31		57.59
	User I/O	direct path write temp	27,381	0.00	262.24	9.58	7.74
	Cluster	gc current block busy	20,340	0.00	150.35	7.39	4.44
	User I/O	db file sequential read	14,722	0.00	94.05	6.39	2.77
	Cluster	gc current block 2-way	155,154	0.00	87.27	0.56	2.57
	Cluster	gc current block 3-way	100,178	0.00	83.61	0.83	2.47
	User I/O	direct path read temp	76,006	0.00	61.13	0.80	1.80
	Commit	log file sync	23,460	0.00	57.26	2.44	1.69
	Other	rdbms ipc reply	99,831	0.00	47.65	0.48	1.41
	Cluster	gc buffer busy acquire	6,077	1.09	47.40	7.80	1.40
4		DB CPU			1,041.40		46.58
	User I/O	direct path write temp	133,585	0.00	660.03	4.94	29.52
	User I/O	direct path read temp	210,413	0.00	305.55	1.45	13.67
	Cluster	gc current block busy	22,320	0.00	154.20	6.91	6.90
	User I/O	db file sequential read	20,011	0.00	133.50	6.67	5.97
	Cluster	gc current block 3-way	102,707	0.00	87.26	0.85	3.90
	Cluster	gc current block 2-way	150,622	0.00	85.27	0.57	3.81
	Commit	log file sync	33,942	0.00	78.93	2.33	3.53
	Cluster	gc buffer busy acquire	9,978	0.74	67.87	6.80	3.04
	Cluster	gc remaster	192	3.13	56.74	295.53	2.54

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	457,325	0.00	1,455.65	3.18	40.35	3.17	2.98	3.43	0.19	4
		background cpu time			1,220.27		33.82					4
	System I/O	log file parallel write	253,196	0.00	464.02	1.83	12.86	1.83	1.82	1.85	0.02	4
	Other	gcs log flush sync	376,885	0.11	249.86	0.66	6.93	0.66	0.66	0.67	0.01	4
	Other	DFS lock handle	111,196	98.90	143.88	1.29	3.99	1.29	1.24	1.35	0.05	4
	Concurrency	os thread startup	488	0.00	68.85	141.09	1.91	141.43	130.81	148.69	7.58	4
	System I/O	control file sequential read	50,644	0.00	45.36	0.90	1.26	0.90	0.86	0.96	0.05	4
	System I/O	Log archive I/O	2,192	0.00	37.31	17.02	1.03	17.00	16.46	18.01	0.87	4
	Other	enq: WF - contention	64	1.56	26.09	407.67	0.72	405.57	0.53	743.51	332.34	4
	System I/O	control file parallel write	6,881	0.00	20.31	2.95	0.56	2.95	2.50	3.59	0.51	4
1	System I/O	db file parallel write	131,744	0.00	451.48	3.43	42.62
		background cpu time			323.55		30.55
	System I/O	log file parallel write	74,250	0.00	135.06	1.82	12.75
	Other	gcs log flush sync	96,806	0.12	64.74	0.67	6.11
	Other	DFS lock handle	27,971	98.67	34.73	1.24	3.28
	Concurrency	os thread startup	128	0.00	16.74	130.81	1.58
	System I/O	Log archive I/O	758	0.00	13.65	18.01	1.29
	System I/O	control file sequential read	12,743	0.00	12.28	0.96	1.16
	Other	Streams AQ: qmn coordinator waiting for slave to start	2	100.00	10.24	5119.91	0.97
	System I/O	control file parallel write	1,779	0.00	5.56	3.13	0.53
2	System I/O	db file parallel write	110,103	0.00	327.56	2.98	37.53
		background cpu time			311.79		35.72
	System I/O	log file parallel write	65,996	0.00	122.02	1.85	13.98
	Other	gcs log flush sync	93,139	0.07	62.40	0.67	7.15
	Other	DFS lock handle	25,145	98.77	31.58	1.26	3.62
	Concurrency	os thread startup	105	0.00	15.61	148.69	1.79
	Other	reliable message	127	10.24	14.90	117.31	1.71
	System I/O	Log archive I/O	758	0.00	12.47	16.46	1.43
	System I/O	control file sequential read	12,665	0.00	10.93	0.86	1.25
	System I/O	control file parallel write	1,711	0.00	6.15	3.59	0.70
3	System I/O	db file parallel write	100,017	0.00	313.89	3.14	40.01
		background cpu time			292.83		37.32
	System I/O	log file parallel write	49,993	0.00	92.44	1.85	11.78
	Other	gcs log flush sync	88,155	0.11	57.85	0.66	7.37
	Other	DFS lock handle	26,662	99.26	34.99	1.31	4.46
	Concurrency	os thread startup	126	0.00	17.93	142.33	2.29
	System I/O	control file sequential read	12,585	0.00	10.98	0.87	1.40
	Other	enq: WF - contention	17	0.00	10.18	598.56	1.30
	System I/O	control file parallel write	1,680	0.00	4.33	2.57	0.55
	Other	ges lms sync during dynamic remastering and reconfig	69	78.26	3.31	47.96	0.42
4	System I/O	db file parallel write	115,461	0.00	362.72	3.14	40.70
		background cpu time			292.10		32.78
	System I/O	log file parallel write	62,957	0.00	114.51	1.82	12.85
	Other	gcs log flush sync	98,785	0.13	64.87	0.66	7.28
	Other	DFS lock handle	31,418	98.90	42.57	1.35	4.78
	Concurrency	os thread startup	129	0.00	18.56	143.87	2.08
	System I/O	Log archive I/O	676	0.00	11.19	16.55	1.26
	System I/O	control file sequential read	12,651	0.00	11.17	0.88	1.25
	Other	enq: WF - contention	15	0.00	11.15	743.51	1.25
	System I/O	control file parallel write	1,711	0.00	4.27	2.50	0.48

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	205,991,296	271,150	160,179	340,743	2,032,590	1,593,589	750,109	472,986	867	72,831
2	74,640,771	96,852	146,526	405,939	1,978,553	722,701	392,812	170,595	188	21,537
3	87,600,360	3,163,624	3,108,188	261,663	1,589,246	590,826	323,838	155,616	223	21,345
4	40,165,396	25,818	138,182	296,534	1,792,122	721,012	403,355	169,413	221	22,815
Sum	408,397,823	3,557,444	3,553,075	1,304,878	7,392,511	3,628,128	1,870,114	968,610	1,499	138,528
Avg	102,099,456	889,361	888,269	326,220	1,848,128	907,032	467,529	242,153	375	34,632
Std	72,096,106	1,519,675	1,479,974	62,222	200,992	461,854	191,659	154,039	329	25,474

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	57,040.98	75.08	44.36	94.35	562.84	441.28	207.71	130.97	0.24	20.17
2	20,668.53	26.82	40.57	112.41	547.87	200.12	108.77	47.24	0.05	5.96
3	24,257.35	876.04	860.69	72.46	440.08	163.61	89.67	43.09	0.06	5.91
4	11,122.17	7.15	38.26	82.11	496.26	199.65	111.69	46.91	0.06	6.32
Sum	113,089.04	985.09	983.88	361.33	2,047.05	1,004.66	517.85	268.22	0.42	38.36
Avg	28,272.26	246.27	245.97	90.33	511.76	251.17	129.46	67.05	0.10	9.59
Std	19,964.14	420.81	409.82	17.23	55.66	127.89	53.07	42.66	0.09	7.05

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	2,828.35	3.72	2.20	4.68	27.91	21.88	10.30	6.49	0.01
2	3,465.70	4.50	6.80	18.85	91.87	33.56	18.24	7.92	0.01
3	4,104.02	148.21	145.62	12.26	74.46	27.68	15.17	7.29	0.01
4	1,760.48	1.13	6.06	13.00	78.55	31.60	17.68	7.43	0.01
Avg	3,039.64	39.39	40.17	12.20	68.20	28.68	15.35	7.28	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	467,389	133,682	404,494	122,263	293	0	2,053,329	734,624	2,249,946	999,665	1,294,985	1,042,259	2	299
2	381,120	123,934	425,859	115,921	284	0	2,052,630	733,064	1,960,937	788,795	1,114,505	857,981	0	262
3	298,248	102,861	415,241	104,065	266	0	1,962,779	649,411	1,827,647	453,434	766,748	711,084	0	303
4	474,483	108,271	375,752	126,713	266	0	1,794,756	577,755	1,785,563	493,318	833,471	737,856	0	276
Sum	1,621,240	468,748	1,621,346	468,962	1,110	0	7,863,494	2,694,854	7,824,093	2,735,212	4,009,709	3,349,180	2	1,140
Avg	405,310	117,187	405,337	117,241	277	0	1,965,874	673,714	1,956,023	683,803	1,002,427	837,295	1	285
Std	83,038	14,170	21,566	9,837	13	0	121,746	75,346	209,724	258,293	246,470	150,837	1	19

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	129.42	37.02	112.01	33.86	0.08	0.00	568.59	203.42	623.03	276.82	358.59	288.61	0	0
2	105.53	34.32	117.92	32.10	0.08	0.00	568.39	202.99	543.00	218.42	308.61	237.58	0	0
3	82.59	28.48	114.98	28.82	0.07	0.00	543.51	179.83	506.09	125.56	212.32	196.91	0	0
4	131.39	29.98	104.05	35.09	0.07	0.00	496.98	159.99	494.44	136.60	230.80	204.32	0	0
Sum	448.94	129.80	448.96	129.86	0.31	0.00	2,177.47	746.23	2,166.56	757.40	1,110.32	927.42	0	0
Avg	112.23	32.45	112.24	32.46	0.08	0.00	544.37	186.56	541.64	189.35	277.58	231.85	0	0
Std	22.99	3.92	5.97	2.72	0.00	0.00	33.71	20.86	58.07	71.52	68.25	41.77	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	6.42	1.84	5.55	1.68	0.00	0.00	28.19	10.09	30.89	13.73	17.78	14.31	0.00	0.00
2	17.70	5.75	19.77	5.38	0.01	0.00	95.31	34.04	91.05	36.63	51.75	39.84	0.00	0.01
3	13.97	4.82	19.45	4.88	0.01	0.00	91.95	30.42	85.62	21.24	35.92	33.31	0.00	0.01
4	20.80	4.75	16.47	5.55	0.01	0.00	78.67	25.32	78.26	21.62	36.53	32.34	0.00	0.01
Avg	14.72	4.29	15.31	4.37	0.01	0.00	73.53	24.97	71.46	23.30	35.50	29.95	0.00	0.01

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.58	0.29	0.13
2	99.21	0.68	0.11
3	99.34	0.46	0.20
4	98.50	1.45	0.05

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.14	0.98	0.01	0.03	2.79	8.22	1.63	0.06	0.03	2.57	4.49
2	0.14	0.88	0.01	0.03	2.81	8.46	1.38	0.05	0.03	2.56	4.01
3	0.07	0.96	0.01	0.03	2.62	7.71	1.27	0.04	0.03	2.49	4.25
4	0.08	0.93	0.01	0.03	2.66	8.09	1.75	0.06	0.03	2.50	4.96

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.08	0.62	0.02	0.01	0.03	54.04	43.49	2.47
2	0.03	0.60	0.04	0.01	0.02	54.66	42.08	3.26
3	0.03	0.58	0.06	0.01	0.01	50.43	46.77	2.79
4	0.04	0.61	0.04	0.01	0.01	51.55	45.63	2.82

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	78,569	44,084	78,569	2,678	25,097	120,257	699	1,305	85	142	53,052	2,151	0	10,054	0	0	0	3,414	0
2	72,915	43,206	72,915	3,225	27,055	113,778	742	1,389	0	113	43,530	2,020	0	9,804	0	0	0	3,775	0
3	63,322	41,045	63,322	2,449	29,468	101,881	744	1,441	19	137	39,123	1,777	0	8,024	0	0	0	3,796	0
4	81,245	45,803	81,245	4,531	28,180	124,357	820	1,514	18	167	54,577	2,243	0	10,257	0	0	0	4,307	0
Sum	296,051	174,138	296,051	12,883	109,800	460,273	3,005	5,649	122	559	190,282	8,191	0	38,139	0	0	0	15,292	0
Avg	74,013	43,535	74,013	3,221	27,450	115,068	751	1,412	31	140	47,571	2,048	0	9,535	0	0	0	3,823	0
Std	7,928	1,979	7,928	932	1,853	9,811	50	88	37	22	7,457	202	0	1,024	0	0	0	367	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	404,489	99.04	0.88	0.08	0.00	0.00	18,181	18.88	76.51	4.60	0.00	0.00	60,773	1.59	84.73	13.08	0.38	0.21
2	425,808	99.15	0.79	0.06	0.00	0.00	17,089	18.80	76.58	4.62	0.00	0.00	48,593	2.11	87.21	10.08	0.38	0.22
3	415,246	99.25	0.69	0.05	0.00	0.00	17,641	17.72	78.09	4.19	0.00	0.00	46,776	1.75	86.89	10.83	0.31	0.22
4	375,655	98.82	1.11	0.08	0.00	0.00	18,652	18.29	77.51	4.20	0.01	0.00	50,780	1.80	86.92	10.74	0.30	0.25
Sum	1,621,198						71,563						206,922
Avg	405,300						17,891						51,731
Std	21,595						676						6,247

Global Cache Transfer Stats

Global Cache Transfer Stats
Global Cache Transfer (Immediate)

Global Cache Transfer Stats

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

Instance#		Block	CR Blocks				Current Blocks				CR Avg Time (ms)				Current Avg Time (ms)
Dest	Src	Class	Received	%Immed	%Busy	%Cngst	Received	%Immed	%Busy	%Cngst	All	Immed	Busy	Cngst	All	Immed	Busy	Cngst
1	2	data block	29,031	93.57	6.38	0.05	224,421	96.05	3.08	0.88	1	0.84	3.80	1.17	2	1.65	7.14	2.99
	4	data block	35,435	93.90	6.02	0.07	122,479	93.46	5.97	0.57	1	0.80	3.52	1.69	2	1.22	6.94	3.61
	3	data block	25,267	92.76	7.20	0.04	97,560	93.03	6.84	0.13	1	0.81	3.70	1.06	1	0.87	7.33	1.62
	2	others	4,357	70.03	29.93	0.05	8,644	93.68	6.30	0.01	2	0.70	3.66	0.59	1	0.69	7.96	0.59
	4	others	4,364	71.08	28.87	0.05	7,888	94.46	5.50	0.04	2	0.87	3.78	1.00	1	0.79	9.15	0.70
	3	undo header	10,021	97.87	2.07	0.06	23	95.65	4.35	0.00	1	0.51	5.62	1.24	1	0.45	3.05
	4	undo header	9,892	97.26	2.72	0.02	21	85.71	14.29	0.00	1	0.50	3.38	1.16	4	2.81	8.23
	3	others	3,160	72.47	27.50	0.03	6,343	93.73	6.20	0.08	2	0.78	4.28	0.46	1	0.83	6.39	1.72
	2	undo header	9,256	96.65	3.32	0.03	19	94.74	5.26	0.00	1	0.48	4.61	0.50	1	0.58	1.67
	4	undo block	1,132	67.58	32.33	0.09	0				1	0.63	2.97	0.41
	2	undo block	930	69.57	30.32	0.11	0				1	0.59	3.00	0.39
	3	undo block	838	64.20	35.80	0.00	0				2	0.61	3.28
2	4	data block	27,351	94.93	5.01	0.06	142,337	94.86	4.79	0.35	1	0.75	3.45	1.84	1	1.15	7.37	3.61
	1	data block	33,241	96.49	3.47	0.04	130,154	94.75	4.68	0.57	1	0.76	3.85	0.97	1	1.17	7.15	2.87
	3	data block	20,299	94.47	5.48	0.05	87,498	93.27	6.68	0.06	1	0.73	3.29	0.54	1	0.77	7.27	1.07
	1	others	5,035	67.75	32.19	0.06	9,005	94.35	5.57	0.08	2	0.67	3.46	0.55	1	0.69	6.42	0.60
	4	others	4,146	72.60	27.40	0.00	6,545	94.51	5.38	0.11	2	0.80	3.80		1	0.76	7.53	0.64
	4	undo header	10,108	97.27	2.70	0.03	18	83.33	16.67	0.00	1	0.48	3.27	0.65	1	0.46	2.42
	3	undo header	9,667	97.93	2.02	0.05	16	93.75	6.25	0.00	1	0.45	3.15	0.42	1	0.45	2.30
	1	undo header	8,648	97.50	2.47	0.02	19	73.68	26.32	0.00	1	0.50	3.71	0.94	1	0.60	3.43
	3	others	2,701	72.05	27.95	0.00	5,498	93.45	6.51	0.04	2	0.78	3.84		1	0.73	6.80	0.45
	4	undo block	1,263	63.02	36.98	0.00	0				1	0.58	2.99
	3	undo block	780	62.95	37.05	0.00	0				1	0.55	2.79
	1	undo block	694	62.82	37.18	0.00	0				1	0.61	2.65
3	1	data block	22,306	94.67	5.29	0.04	95,397	93.11	6.80	0.09	1	0.80	3.80	0.97	1	0.82	7.61	2.02
	2	data block	21,063	94.64	5.33	0.03	91,940	93.61	6.32	0.07	1	0.73	3.59	0.53	1	0.77	7.86	1.43
	4	data block	18,462	93.55	6.40	0.05	90,911	92.34	7.57	0.09	1	0.82	3.64	2.07	1	0.86	7.34	2.71
	1	others	5,241	69.20	30.78	0.02	7,625	94.03	5.88	0.09	2	0.79	3.79	4.73	1	0.73	6.46	0.74
	2	others	4,007	69.63	30.32	0.05	6,573	94.25	5.71	0.05	2	0.79	3.68	0.63	1	0.74	4.75	0.67
	4	others	4,243	71.29	28.56	0.14	5,759	94.50	5.47	0.03	2	0.82	3.69	0.69	1	0.85	6.97	0.51
	4	undo header	8,221	96.96	3.00	0.04	11	81.82	18.18	0.00	1	0.47	2.87	0.41	2	0.55	8.08
	2	undo header	7,713	97.29	2.68	0.03	8	87.50	12.50	0.00	1	0.51	4.10	0.40	1	0.41	1.81
	1	undo header	7,427	97.23	2.73	0.04	14	92.86	7.14	0.00	1	0.49	3.47	0.80	1	0.89	1.32
	4	undo block	2,145	83.08	16.92	0.00	0				1	0.50	2.71
	1	undo block	1,026	73.59	26.32	0.10	0				1	0.57	2.86	0.76
	2	undo block	1,005	67.56	32.44	0.00	0				1	0.59	3.18
4	3	data block	17,751	93.84	6.10	0.06	213,633	95.92	3.15	0.93	1	0.77	3.29	1.16	2	1.64	7.16	3.95
	1	data block	22,828	94.80	5.19	0.02	152,479	94.48	4.73	0.79	1	0.79	3.75	1.52	2	1.69	7.18	3.44
	2	data block	22,678	94.78	5.19	0.04	86,386	91.68	8.26	0.06	1	0.74	3.75	1.12	1	0.82	6.98	2.23
	1	others	5,619	69.73	30.20	0.07	9,395	94.71	5.20	0.09	2	0.79	3.60	1.32	1	0.79	5.60	0.62
	2	others	4,320	70.32	29.65	0.02	7,067	94.65	5.28	0.07	2	0.80	3.98	0.69	1	0.73	5.23	0.80
	2	undo header	10,017	97.34	2.60	0.06	14	78.57	21.43	0.00	1	0.49	3.63	0.53	1	0.52	2.70
	3	undo header	9,832	97.95	2.04	0.01	15	100.00	0.00	0.00	1	0.50	3.34	0.44	1	0.56
	1	undo header	9,013	96.82	3.13	0.06	19	78.95	21.05	0.00	1	0.52	3.47	0.71	1	0.47	2.75
	3	others	3,146	71.33	28.64	0.03	5,389	94.10	5.88	0.02	2	0.86	3.83	1.58	1	0.86	5.73	1.10
	2	undo block	1,279	66.30	33.70	0.00	0				1	0.61	2.89
	1	undo block	949	62.80	37.20	0.00	0				1	0.61	2.83
	3	undo block	832	61.30	38.70	0.00	0				1	0.61	2.44

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

Ordered by instance_number, CR + Current Blocks Received desc

Instance#		Block	Lost Blocks		Immediate CR Blocks			Immediate Current Blocks			Immed CR Avg Time (ms)			Immed Current Avg Time (ms)
Dest	Src	Class	Count	Time(ms)	Received	%2-hop	%3-hop	Received	%2-hop	%3-hop	Total	2-hop	3-hop	Total	2-hop	3-hop
1	2	data block	0		27,163	41.90	58.10	215,547	60.72	39.28	0.84	0.76	0.90	1.65	1.66	1.64
	4	data block	0		33,275	49.14	50.86	114,468	45.02	54.98	0.80	0.68	0.91	1.22	0.65	1.69
	3	data block	0		23,437	47.72	52.28	90,762	66.37	33.63	0.81	0.68	0.93	0.87	0.82	0.97
	2	others	0		3,051	86.69	13.31	8,098	78.65	21.35	0.70	0.68	0.83	0.69	0.65	0.83
	4	others	0		3,102	36.98	63.02	7,451	43.55	56.45	0.87	0.71	0.96	0.79	0.66	0.89
	3	undo header	0		9,808	100.00	0.00	22	100.00	0.00	0.51	0.51		0.45	0.45
	4	undo header	0		9,621	100.00	0.00	18	100.00	0.00	0.50	0.50		2.81	2.81
	2	undo header	0		8,946	100.00	0.00	18	100.00	0.00	0.48	0.48		0.58	0.58
	3	others	0		2,290	44.67	55.33	5,945	52.13	47.87	0.78	0.60	0.92	0.83	0.63	1.05
	4	undo block	0		765	100.00	0.00	0			0.63	0.63
	2	undo block	0		647	100.00	0.00	0			0.59	0.59
	3	undo block	0		538	100.00	0.00	0			0.61	0.61
2	4	data block	0		25,964	53.84	46.16	135,015	54.12	45.88	0.75	0.64	0.87	1.15	0.73	1.65
	1	data block	0		32,074	45.61	54.39	123,320	67.94	32.06	0.76	0.66	0.84	1.17	1.27	0.95
	3	data block	0		19,176	53.12	46.88	81,608	62.25	37.75	0.73	0.62	0.87	0.77	0.65	0.98
	1	others	0		3,411	86.05	13.95	8,496	78.51	21.49	0.67	0.65	0.82	0.69	0.63	0.88
	4	undo header	0		9,832	100.00	0.00	15	100.00	0.00	0.48	0.48		0.46	0.46
	3	undo header	0		9,467	100.00	0.00	15	100.00	0.00	0.45	0.45		0.45	0.45
	4	others	0		3,010	48.97	51.03	6,186	54.91	45.09	0.80	0.70	0.89	0.76	0.62	0.92
	1	undo header	0		8,432	100.00	0.00	14	100.00	0.00	0.50	0.50		0.60	0.60
	3	others	0		1,946	59.56	40.44	5,138	58.04	41.96	0.78	0.63	1.00	0.73	0.59	0.92
	4	undo block	0		796	100.00	0.00	0			0.58	0.58
	3	undo block	0		491	100.00	0.00	0			0.55	0.55
	1	undo block	0		436	100.00	0.00	0			0.61	0.61
3	1	data block	0		21,116	46.08	53.92	88,824	62.17	37.83	0.80	0.67	0.91	0.82	0.72	0.98
	2	data block	0		19,934	52.55	47.45	86,069	65.07	34.93	0.73	0.60	0.87	0.77	0.65	0.98
	4	data block	0		17,271	57.30	42.70	83,950	61.30	38.70	0.82	0.70	0.98	0.86	0.70	1.10
	1	others	0		3,627	53.57	46.43	7,170	55.59	44.41	0.79	0.63	0.97	0.73	0.60	0.90
	2	others	0		2,790	59.61	40.39	6,195	60.82	39.18	0.79	0.66	0.98	0.74	0.62	0.93
	4	others	0		3,025	20.26	79.74	5,442	32.43	67.57	0.82	0.66	0.86	0.85	0.58	0.98
	4	undo header	0		7,971	100.00	0.00	9	100.00	0.00	0.47	0.47		0.55	0.55
	2	undo header	0		7,504	100.00	0.00	7	100.00	0.00	0.51	0.51		0.41	0.41
	1	undo header	0		7,221	100.00	0.00	13	92.31	7.69	0.49	0.49		0.89	0.82	1.76
	4	undo block	0		1,782	100.00	0.00	0			0.50	0.50
	1	undo block	0		755	100.00	0.00	0			0.57	0.57
	2	undo block	0		679	100.00	0.00	0			0.59	0.59
4	3	data block	0		16,658	54.61	45.39	204,923	63.30	36.70	0.77	0.65	0.92	1.64	1.04	2.68
	1	data block	0		21,640	50.21	49.79	144,066	59.37	40.63	0.79	0.67	0.90	1.69	1.52	1.93
	2	data block	0		21,494	56.77	43.23	79,203	63.04	36.96	0.74	0.63	0.88	0.82	0.73	0.97
	1	others	0		3,918	45.74	54.26	8,898	50.51	49.49	0.79	0.72	0.84	0.79	0.65	0.94
	2	undo header	0		9,751	100.00	0.00	11	100.00	0.00	0.49	0.49		0.52	0.52
	2	others	0		3,038	42.76	57.24	6,689	56.87	43.13	0.80	0.68	0.90	0.73	0.60	0.89
	3	undo header	0		9,630	100.00	0.00	15	100.00	0.00	0.50	0.50		0.56	0.56
	1	undo header	0		8,726	100.00	0.00	15	100.00	0.00	0.52	0.52		0.47	0.47
	3	others	0		2,244	12.43	87.57	5,071	34.35	65.65	0.86	0.55	0.91	0.86	0.60	0.99
	2	undo block	0		848	100.00	0.00	0			0.61	0.61
	1	undo block	0		596	100.00	0.00	0			0.61	0.61
	3	undo block	0		510	100.00	0.00	0			0.61	0.61

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	en10	192.168.10.1	N	Oracle Cluster Repository
2	en10	192.168.10.2	N	Oracle Cluster Repository
3	en10	192.168.10.3	N	Oracle Cluster Repository
4	en10	192.168.10.4	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	288	0.10	0.35	0.10	288	0.10	0.34	0.10
	2	288	0.15	0.53	0.90	288	0.22	0.76	1.28
	3	288	0.21	0.72	3.15	288	0.25	0.85	3.19
	4	288	0.21	0.72	1.15	288	0.24	0.83	1.23
2	1	288	0.24	0.84	1.49	288	0.29	1.02	1.64
	2	288	0.08	0.28	0.07	288	0.08	0.26	0.07
	3	288	0.23	0.81	3.30	288	0.27	0.92	3.32
	4	288	0.24	0.84	1.52	288	0.26	0.91	1.50
3	1	287	0.24	0.82	1.18	287	0.26	0.92	1.20
	2	287	0.18	0.64	1.10	287	0.22	0.75	1.09
	3	287	0.07	0.26	0.09	287	0.07	0.25	0.09
	4	287	0.18	0.64	0.89	287	0.21	0.74	0.89
4	1	288	0.23	0.80	1.21	288	0.27	0.94	1.21
	2	288	0.21	0.71	1.36	288	0.24	0.84	1.35
	3	288	0.19	0.67	3.15	288	0.23	0.80	3.14
	4	288	0.06	0.23	0.08	288	0.06	0.21	0.08

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	4,492.42	3,541.43	1.05	687.65	9.66	252.63	5,171.40	4,111.14	1.18	634.69	9.66	414.73
2	4,452.43	3,678.18	1.04	614.77	9.66	148.78	4,167.54	3,437.92	0.91	624.93	9.66	94.11
3	4,319.63	3,622.67	1.05	539.07	9.63	147.21	3,361.47	2,670.74	1.09	585.74	9.63	94.27
4	4,107.14	3,411.44	1.04	536.25	9.66	148.75	4,668.65	4,031.31	1.00	532.44	9.66	94.22
Sum	17,371.62	14,253.72	4.18	2,377.74	38.62	697.36	17,369.06	14,251.11	4.18	2,377.81	38.62	697.33
Avg	4,342.91	3,563.43	1.05	594.44	9.66	174.34	4,342.26	3,562.78	1.05	594.45	9.66	174.33
Std	173.66	115.85	0.00	72.00	0.02	52.20	771.68	666.22	0.12	46.44	0.02	160.26

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	1.24	0.98	0.00	0.19	0.00	0.07	1.43	1.14	0.00	0.18	0.00	0.11
2	1.23	1.02	0.00	0.17	0.00	0.04	1.15	0.95	0.00	0.17	0.00	0.03
3	1.20	1.00	0.00	0.15	0.00	0.04	0.93	0.74	0.00	0.16	0.00	0.03
4	1.14	0.94	0.00	0.15	0.00	0.04	1.29	1.12	0.00	0.15	0.00	0.03
Sum	4.81	3.95	0.00	0.66	0.01	0.19	4.81	3.95	0.00	0.66	0.01	0.19
Avg	1.20	0.99	0.00	0.16	0.00	0.05	1.20	0.99	0.00	0.16	0.00	0.05
Std	0.05	0.03	0.00	0.02	0.00	0.01	0.21	0.18	0.00	0.01	0.00	0.04

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	en0	10.6.135.223	255.255.255.0	383.34	1,289,323	0	0	0	0		1,555,260	0	0	0	0
2	en0	10.6.135.231	255.255.255.0	178.81	705,616	0	0	0	0	198.76	770,565	0	0	0	0
3	en0	10.6.135.239	255.255.255.0	173.58	577,803	0	0	0	0	136.54	626,743	0	0	0	0
4	en0	10.6.135.247	255.255.255.0	241.73	743,924	0	0	0	0	162.27	788,950	0	0	0	0
Sum				977.45	3,316,666	0	0	0	0	497.57	3,741,518	0	0	0	0
Avg				244.36	829,167	0	0	0	0	165.86	935,380	0	0	0	0
Std				97.69	314,885	0	0	0	0	31.26	419,569	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	en0	10.6.135.223	255.255.255.0	0.11	357	0	0	0	0		431	0	0	0	0
2	en0	10.6.135.231	255.255.255.0	0.05	195	0	0	0	0	0.06	213	0	0	0	0
3	en0	10.6.135.239	255.255.255.0	0.05	160	0	0	0	0	0.04	174	0	0	0	0
4	en0	10.6.135.247	255.255.255.0	0.07	206	0	0	0	0	0.04	218	0	0	0	0
Sum				0.27	918	0	0	0	0	0.14	1,036	0	0	0	0
Avg				0.07	230	0	0	0	0	0.05	259	0	0	0	0
Std				0.03	87	0	0	0	0	0.01	116	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	Replay Locks Received	Replay Locks Sent	Resources Cleaned	Remaster	Quiesce	Freeze	Cleanup	Replay	Fixwrite	Sync	Begin	End
		Counts per Ops				Time per Ops (seconds)							Affinity Objects
1	3	1.00	5,807.00	279.67	0.00	3.85	0.95	0.16	0.57	0.09	1.16	0.89	239	238
2	3	1.00	7,482.00	9.33	0.00	3.85	0.88	0.11	0.44	0.26	0.90	1.23	21	21
3	3	1.00	28.33	140.67	0.00	3.84	0.75	0.12	0.42	0.18	0.77	1.57	6	7
4	3	1.00	0.00	12,883.67	0.00	3.85	0.99	0.12	0.57	0.17	1.00	0.96	13	13
Avg	3	1.00	3,329.33	3,328.33	0.00	3.85	0.89	0.13	0.50	0.17	0.96	1.16	70	70
Max			7,482.00	12,883.67	0.00	3.85	0.99	0.16	0.57	0.26	1.16	1.57	239	238

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 27.0% of Total DB Time (s): 12,186
Captured PL/SQL account for 0.9% of Total DB Time (s): 12,186

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
8g4p2van6nvnd	374.73	337.19	0.00	0	0	13,070	0.00	49	7.65	6.88	0.00	0.00	0.00	266.73	0.00	3.08	5.40	0.00	0.00	0.00	0.00	0.00	SELECT /+RULE / v1.sid SID, ...
c60h9paz2fkp6	262.48	27.88	85.44	795,139	13,035	43,303	137.32	43,345	0.01	0.00	0.00	18.34	0.30	1.00	0.00	2.15	0.45	0.08	0.19	0.37	6.13	2.32	DELETE FROM CJCL.CJ_SJTB_JL WH...
1d4x5y7rhzyxg	172.44	137.50	1.50	30,679,807	213	9	24.98	9	19.16	15.28	0.17	3,408,867.44	23.67	1.00	2.78	1.42	2.20	0.00	7.51	0.01	1.12	0.00	select count(distinct tbjd.dwx...
84p0m46r1y8zq	158.17	67.85	50.40	22,742,999	8,021	16,684	11.90	1,617	0.10	0.04	0.03	14,064.93	4.96	10.32	0.01	1.30	1.09	0.05	5.57	0.23	0.53	0.09	SELECT ZZID FROM CJCL.CJ_CJ_TB...
85t04831hywhk	124.15	10.52	46.26	1,331,019	5,962	92,145	59.95	40,200	0.00	0.00	0.00	33.11	0.15	2.29	0.00	1.02	0.17	0.05	0.33	0.17	2.68	2.15	DELETE FROM CJCL.CJ_CW_CWDW WH...
6zpwu3y1x9psp	111.38	79.75	0.00	6,409,168	0	790	0.00	793	0.14	0.10	0.00	8,082.18	0.00	1.00	0.00	0.91	1.28	0.00	1.57	0.00	0.00	0.04	SELECT DWXTM, ZZJGDM, DWMC, DH...
95uzxsm5j9r4j	106.51	10.39	0.00	0	0	193,441	0.00	193,513	0.00	0.00	0.00	0.00	0.00	1.00	0.00	0.87	0.17	0.00	0.00	0.00	0.00	10.35	BEGIN "TISETUSETRIGER"('FALSE'...
dryt5ugs0j5hf	102.35	81.04	0.00	18,219,527	0	6	8.84	6	17.06	13.51	0.00	3,036,587.83	0.00	1.00	1.47	0.84	1.30	0.00	4.46	0.00	0.39	0.00	select count(distinct tbjd.dwx...
5u06x1z3hrmnv	86.01	59.14	0.00	15,611,808	0	3	21.03	3	28.67	19.71	0.00	5,203,936.00	0.00	1.00	7.01	0.71	0.95	0.00	3.82	0.00	0.94	0.00	select count(distinct tbjd.dwx...
a09y5t50r2z8c	77.61	32.26	21.78	5,616,394	11,139	30	18.55	6	12.93	5.38	3.63	936,065.67	1,856.50	5.00	3.09	0.64	0.52	0.02	1.38	0.31	0.83	0.00	select dwxtm, zzjgdm, dwmc, cl...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time (Global)

Captured SQL account for 29.9% of Total CPU Time (s): 6,245
Captured PL/SQL account for 0.2% of Total CPU Time (s): 6,245

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
8g4p2van6nvnd	337.19	374.73	0.00	0	0	13,070	0.00	49	6.88	0.00	7.65	0.00	0.00	266.73	0.00	5.40	0.00	3.08	0.00	0.00	0.00	0.00	SELECT /+RULE / v1.sid SID, ...
1d4x5y7rhzyxg	137.50	172.44	1.50	30,679,807	213	9	24.98	9	15.28	0.17	19.16	3,408,867.44	23.67	1.00	2.78	2.20	0.15	1.42	7.51	0.01	1.12	0.00	select count(distinct tbjd.dwx...
dryt5ugs0j5hf	81.04	102.35	0.00	18,219,527	0	6	8.84	6	13.51	0.00	17.06	3,036,587.83	0.00	1.00	1.47	1.30	0.00	0.84	4.46	0.00	0.39	0.00	select count(distinct tbjd.dwx...
6zpwu3y1x9psp	79.75	111.38	0.00	6,409,168	0	790	0.00	793	0.10	0.00	0.14	8,082.18	0.00	1.00	0.00	1.28	0.00	0.91	1.57	0.00	0.00	0.04	SELECT DWXTM, ZZJGDM, DWMC, DH...
84p0m46r1y8zq	67.85	158.17	50.40	22,742,999	8,021	16,684	11.90	1,617	0.04	0.03	0.10	14,064.93	4.96	10.32	0.01	1.09	4.96	1.30	5.57	0.23	0.53	0.09	SELECT ZZID FROM CJCL.CJ_CJ_TB...
5u06x1z3hrmnv	59.14	86.01	0.00	15,611,808	0	3	21.03	3	19.71	0.00	28.67	5,203,936.00	0.00	1.00	7.01	0.95	0.00	0.71	3.82	0.00	0.94	0.00	select count(distinct tbjd.dwx...
5brubmy7nj4kf	42.49	57.20	0.15	6,815,452	27	162	10.42	9	4.72	0.02	6.36	757,272.44	3.00	18.00	1.16	0.68	0.01	0.47	1.67	0.00	0.46	0.00	select dwxtm, zzjgdm, dwmc, cl...
5vvyt2upfvnw0	34.92	57.43	0.00	5,222,197	0	1,110	2.54	666	0.05	0.00	0.09	7,841.14	0.00	1.67	0.00	0.56	0.00	0.47	1.28	0.00	0.11	0.04	select "BGQ", "DCDXXTM", "ZZJG...
cy4j4q092hxqr	34.18	53.76	0.00	1,627,042	1	352	0.41	429	0.08	0.00	0.13	3,792.64	0.00	0.82	0.00	0.55	0.00	0.44	0.40	0.00	0.02	0.02	SELECT "ZZID" FROM "CJ_CJ_TBJD...
a09y5t50r2z8c	32.26	77.61	21.78	5,616,394	11,139	30	18.55	6	5.38	3.63	12.93	936,065.67	1,856.50	5.00	3.09	0.52	2.14	0.64	1.38	0.31	0.83	0.00	select dwxtm, zzjgdm, dwmc, cl...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Time (Global)

Captured SQL account for 32.7% of Total User I/O Wait Time (s): 1,017
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 1,017

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
84p0m46r1y8zq	50.40	158.17	67.85	22,742,999	8,021	16,684	11.90	1,617	0.03	0.10	0.04	14,064.93	4.96	10.32	0.01	4.96	1.30	1.09	5.57	0.23	0.53	0.09	SELECT ZZID FROM CJCL.CJ_CJ_TB...
a09y5t50r2z8c	21.78	77.61	32.26	5,616,394	11,139	30	18.55	6	3.63	12.93	5.38	936,065.67	1,856.50	5.00	3.09	2.14	0.64	0.52	1.38	0.31	0.83	0.00	select dwxtm, zzjgdm, dwmc, cl...
1d4x5y7rhzyxg	1.50	172.44	137.50	30,679,807	213	9	24.98	9	0.17	19.16	15.28	3,408,867.44	23.67	1.00	2.78	0.15	1.42	2.20	7.51	0.01	1.12	0.00	select count(distinct tbjd.dwx...
5brubmy7nj4kf	0.15	57.20	42.49	6,815,452	27	162	10.42	9	0.02	6.36	4.72	757,272.44	3.00	18.00	1.16	0.01	0.47	0.68	1.67	0.00	0.46	0.00	select dwxtm, zzjgdm, dwmc, cl...
cy4j4q092hxqr	0.00	53.76	34.18	1,627,042	1	352	0.41	429	0.00	0.13	0.08	3,792.64	0.00	0.82	0.00	0.00	0.44	0.55	0.40	0.00	0.02	0.02	SELECT "ZZID" FROM "CJ_CJ_TBJD...
5u06x1z3hrmnv	0.00	86.01	59.14	15,611,808	0	3	21.03	3	0.00	28.67	19.71	5,203,936.00	0.00	1.00	7.01	0.00	0.71	0.95	3.82	0.00	0.94	0.00	select count(distinct tbjd.dwx...
5vvyt2upfvnw0	0.00	57.43	34.92	5,222,197	0	1,110	2.54	666	0.00	0.09	0.05	7,841.14	0.00	1.67	0.00	0.00	0.47	0.56	1.28	0.00	0.11	0.04	select "BGQ", "DCDXXTM", "ZZJG...
6zpwu3y1x9psp	0.00	111.38	79.75	6,409,168	0	790	0.00	793	0.00	0.14	0.10	8,082.18	0.00	1.00	0.00	0.00	0.91	1.28	1.57	0.00	0.00	0.04	SELECT DWXTM, ZZJGDM, DWMC, DH...
8g4p2van6nvnd	0.00	374.73	337.19	0	0	13,070	0.00	49	0.00	7.65	6.88	0.00	0.00	266.73	0.00	0.00	3.08	5.40	0.00	0.00	0.00	0.00	SELECT /+RULE / v1.sid SID, ...
dryt5ugs0j5hf	0.00	102.35	81.04	18,219,527	0	6	8.84	6	0.00	17.06	13.51	3,036,587.83	0.00	1.00	1.47	0.00	0.84	1.30	4.46	0.00	0.39	0.00	select count(distinct tbjd.dwx...

Back to SQL Statistics
Back to Top

SQL ordered by Gets (Global)

Total Buffer Gets: 408,397,823
Captured SQL account for 61.8% 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
1d4x5y7rhzyxg	30,679,807	213	172.44	137.50	1.50	9	24.98	9	3,408,867.44	23.67	19.16	15.28	0.17	1.00	2.78	7.51	0.01	1.42	2.20	0.15	1.12	0.00	select count(distinct tbjd.dwx...
84p0m46r1y8zq	22,742,999	8,021	158.17	67.85	50.40	16,684	11.90	1,617	14,064.93	4.96	0.10	0.04	0.03	10.32	0.01	5.57	0.23	1.30	1.09	4.96	0.53	0.09	SELECT ZZID FROM CJCL.CJ_CJ_TB...
dryt5ugs0j5hf	18,219,527	0	102.35	81.04	0.00	6	8.84	6	3,036,587.83	0.00	17.06	13.51	0.00	1.00	1.47	4.46	0.00	0.84	1.30	0.00	0.39	0.00	select count(distinct tbjd.dwx...
5u06x1z3hrmnv	15,611,808	0	86.01	59.14	0.00	3	21.03	3	5,203,936.00	0.00	28.67	19.71	0.00	1.00	7.01	3.82	0.00	0.71	0.95	0.00	0.94	0.00	select count(distinct tbjd.dwx...
5brubmy7nj4kf	6,815,452	27	57.20	42.49	0.15	162	10.42	9	757,272.44	3.00	6.36	4.72	0.02	18.00	1.16	1.67	0.00	0.47	0.68	0.01	0.46	0.00	select dwxtm, zzjgdm, dwmc, cl...
6zpwu3y1x9psp	6,409,168	0	111.38	79.75	0.00	790	0.00	793	8,082.18	0.00	0.14	0.10	0.00	1.00	0.00	1.57	0.00	0.91	1.28	0.00	0.00	0.04	SELECT DWXTM, ZZJGDM, DWMC, DH...
a09y5t50r2z8c	5,616,394	11,139	77.61	32.26	21.78	30	18.55	6	936,065.67	1,856.50	12.93	5.38	3.63	5.00	3.09	1.38	0.31	0.64	0.52	2.14	0.83	0.00	select dwxtm, zzjgdm, dwmc, cl...
3j4mhbda5xjqb	5,381,706	2	37.77	21.47	0.03	1	13.87	1	5,381,706.00	2.00	37.77	21.47	0.03	1.00	13.87	1.32	0.00	0.31	0.34	0.00	0.62	0.00	select count(distinct tbjd.dwx...
5vvyt2upfvnw0	5,222,197	0	57.43	34.92	0.00	1,110	2.54	666	7,841.14	0.00	0.09	0.05	0.00	1.67	0.00	1.28	0.00	0.47	0.56	0.00	0.11	0.04	select "BGQ", "DCDXXTM", "ZZJG...
56pft0402x99d	3,911,631	0	23.61	13.98	0.00	31	0.26	676	5,786.44	0.00	0.03	0.02	0.00	0.05	0.00	0.96	0.00	0.19	0.22	0.00	0.01	0.04	select "C101_1", "C101_2", "C2...

Back to SQL Statistics
Back to Top

SQL ordered by Reads (Global)

Total Disk Reads: 3,557,444
Captured SQL account for 7.4% 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
6kcjx3mypknuh	88,329	278,638	28.11	10.87	14.48	4	1.13	1	88,329.00	278,638.00	28.11	10.87	14.48	4.00	1.13	2.48	0.07	0.23	0.17	1.42	0.05	0.00	SELECT /��λ��ģ/ T12.MLMC as ML...
30jx64uuk7xk8	50,757	198,616	26.40	5.14	16.52	78	3.44	3	16,919.00	66,205.33	8.80	1.71	5.51	26.00	1.15	1.43	0.05	0.22	0.08	1.62	0.15	0.00	select sbjd_wb, sbjd_yb, sbjd_...
8kz5d4zkmhqpz	46,568	170,821	23.78	13.43	5.21	4	4.39	1	46,568.00	170,821.00	23.78	13.43	5.21	4.00	4.39	1.31	0.04	0.20	0.22	0.51	0.20	0.00	SELECT /��λ��ģ/ T12.MLMC as ML...
b0mjdyk04c7hs	20,178	57,970	15.21	8.39	6.07	1	0.08	1	20,178.00	57,970.00	15.21	8.39	6.07	1.00	0.08	0.57	0.01	0.12	0.13	0.60	0.00	0.00	SELECT 0 AS DM, T12.TG1202 AS ...
c60h9paz2fkp6	13,035	795,139	262.48	27.88	85.44	43,303	137.32	43,345	0.30	18.34	0.01	0.00	0.00	1.00	0.00	0.37	0.19	2.15	0.45	8.40	6.13	2.32	DELETE FROM CJCL.CJ_SJTB_JL WH...
a09y5t50r2z8c	11,139	5,616,394	77.61	32.26	21.78	30	18.55	6	1,856.50	936,065.67	12.93	5.38	3.63	5.00	3.09	0.31	1.38	0.64	0.52	2.14	0.83	0.00	select dwxtm, zzjgdm, dwmc, cl...
84p0m46r1y8zq	8,021	22,742,999	158.17	67.85	50.40	16,684	11.90	1,617	4.96	14,064.93	0.10	0.04	0.03	10.32	0.01	0.23	5.57	1.30	1.09	4.96	0.53	0.09	SELECT ZZID FROM CJCL.CJ_CJ_TB...
4xr8bc73u004f	6,640	246,274	25.22	3.89	15.42	7	0.11	7	948.57	35,182.00	3.60	0.56	2.20	1.00	0.02	0.19	0.06	0.21	0.06	1.52	0.00	0.00	UPDATE CJCL.GH_BB_BBZC set ZBS...
85t04831hywhk	5,962	1,331,019	124.15	10.52	46.26	92,145	59.95	40,200	0.15	33.11	0.00	0.00	0.00	2.29	0.00	0.17	0.33	1.02	0.17	4.55	2.68	2.15	DELETE FROM CJCL.CJ_CW_CWDW WH...
8qpwtrm143jkp	4,170	108,716	64.09	6.51	30.36	15,051	27.28	1	4,170.00	108,716.00	64.09	6.51	30.36	15,051.00	27.28	0.12	0.03	0.53	0.10	2.99	1.22	0.00	SELECT /+ USE_HASH(TBJD, GZ)...

Back to SQL Statistics
Back to Top

SQL ordered by UnOptimized Read Requests (Global)

Total Physical Read Requests: 365,772
Captured SQL account for 10.9% of Total
Total UnOptimized Read Requests: 365,772
Captured SQL account for 10.9% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

SQL Id	UnOptimized	Requests	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Execs	UnOptimized	Requests	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	UnOptimized	Requests	Reads	DB time	DB CPU	IO Wait	Cluster	Execs	SQL Text
	Total									Per Execution								Percentage of Total
a09y5t50r2z8c	10,714	10,714	11,139	77.61	32.26	21.78	30	18.55	6	1,785.67	1,785.67	1,856.50	12.93	5.38	3.63	5.00	3.09	2.93	2.93	0.31	0.64	0.52	2.14	0.83	0.00	select dwxtm, zzjgdm, dwmc, cl...
30jx64uuk7xk8	8,850	8,850	50,757	26.40	5.14	16.52	78	3.44	3	2,950.00	2,950.00	16,919.00	8.80	1.71	5.51	26.00	1.15	2.42	2.42	1.43	0.22	0.08	1.62	0.15	0.00	select sbjd_wb, sbjd_yb, sbjd_...
85t04831hywhk	5,962	5,962	5,962	124.15	10.52	46.26	92,145	59.95	40,200	0.15	0.15	0.15	0.00	0.00	0.00	2.29	0.00	1.63	1.63	0.17	1.02	0.17	4.55	2.68	2.15	DELETE FROM CJCL.CJ_CW_CWDW WH...
b0mjdyk04c7hs	4,690	4,690	20,178	15.21	8.39	6.07	1	0.08	1	4,690.00	4,690.00	20,178.00	15.21	8.39	6.07	1.00	0.08	1.28	1.28	0.57	0.12	0.13	0.60	0.00	0.00	SELECT 0 AS DM, T12.TG1202 AS ...
8qpwtrm143jkp	4,170	4,170	4,170	64.09	6.51	30.36	15,051	27.28	1	4,170.00	4,170.00	4,170.00	64.09	6.51	30.36	15,051.00	27.28	1.14	1.14	0.12	0.53	0.10	2.99	1.22	0.00	SELECT /+ USE_HASH(TBJD, GZ)...
298n8b3tuwbka	1,294	1,294	1,294	7.97	1.18	5.70	2	1.13	1	1,294.00	1,294.00	1,294.00	7.97	1.18	5.70	2.00	1.13	0.35	0.35	0.04	0.07	0.02	0.56	0.05	0.00	SELECT TBJD.ZZJGDM, TBJD.DWMC,...
6kcjx3mypknuh	931	931	88,329	28.11	10.87	14.48	4	1.13	1	931.00	931.00	88,329.00	28.11	10.87	14.48	4.00	1.13	0.25	0.25	2.48	0.23	0.17	1.42	0.05	0.00	SELECT /��λ��ģ/ T12.MLMC as ML...
4bjjzk10c88v8	755	755	755	6.19	0.25	4.79	1	0.92	1	755.00	755.00	755.00	6.19	0.25	4.79	1.00	0.92	0.21	0.21	0.02	0.05	0.00	0.47	0.04	0.00	select decode(sbjd_wb, '', '0'...
3qkb569jsvads	677	677	677	7.72	0.68	4.70	3,648	1.99	1	677.00	677.00	677.00	7.72	0.68	4.70	3,648.00	1.99	0.19	0.19	0.02	0.06	0.01	0.46	0.09	0.00	INSERT INTO CJCL.CJ_CJ_YSCLJL ...
7ys1f51rrpxrg	553	553	1,607	39.65	4.02	10.32	28,363	22.81	31,687	0.02	0.02	0.05	0.00	0.00	0.00	0.90	0.00	0.15	0.15	0.05	0.33	0.06	1.01	1.02	1.69	SELECT CWID FROM CJCL.CJ_CW_CW...

Back to SQL Statistics
Back to Top

SQL ordered by Executions (Global)

Total Executions: 1,870,114
Captured SQL account for 20.1% 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
95uzxsm5j9r4j	193,513	106.51	10.39	0.00	0	0	193,441	0.00	0.00	0.00	0.00	0.00	0.00	1.00	0.00	10.35	0.87	0.17	0.00	0.00	0.00	0.00	BEGIN "TISETUSETRIGER"('FALSE'...
c60h9paz2fkp6	43,345	262.48	27.88	85.44	795,139	13,035	43,303	137.32	0.01	0.00	0.00	18.34	0.30	1.00	0.00	2.32	2.15	0.45	8.40	0.19	0.37	6.13	DELETE FROM CJCL.CJ_SJTB_JL WH...
85t04831hywhk	40,200	124.15	10.52	46.26	1,331,019	5,962	92,145	59.95	0.00	0.00	0.00	33.11	0.15	2.29	0.00	2.15	1.02	0.17	4.55	0.33	0.17	2.68	DELETE FROM CJCL.CJ_CW_CWDW WH...
g895wjrhjfun3	35,711	5.60	0.19	1.02	489,381	134	45	0.34	0.00	0.00	0.00	13.70	0.00	0.00	0.00	1.91	0.05	0.00	0.10	0.12	0.00	0.02	UPDATE "CJ_CJ_TBJD" SET "SJZTB...
4vs91dcv7u1p6	32,864	10.84	2.50	2.85	73,349	457	32,862	0.70	0.00	0.00	0.00	2.23	0.01	1.00	0.00	1.76	0.09	0.04	0.28	0.02	0.01	0.03	insert into sys.aud$( sessioni...
d9w357uw5y7wp	31,702	19.81	1.23	0.28	490,228	49	31,700	11.90	0.00	0.00	0.00	15.46	0.00	1.00	0.00	1.70	0.16	0.02	0.03	0.12	0.00	0.53	INSERT INTO CJCL.CJ_SJTB_JL (Z...
7ys1f51rrpxrg	31,687	39.65	4.02	10.32	149,886	1,607	28,363	22.81	0.00	0.00	0.00	4.73	0.05	0.90	0.00	1.69	0.33	0.06	1.01	0.04	0.05	1.02	SELECT CWID FROM CJCL.CJ_CW_CW...
bs6ja4ccvvjmk	25,796	73.06	30.25	0.01	495,394	1	635,343	0.01	0.00	0.00	0.00	19.20	0.00	24.63	0.00	1.38	0.60	0.48	0.00	0.12	0.00	0.00	SELECT DISTINCT AQDB.ZK_JL_GNQ...
9tgj4g8y4rwy8	24,946	1.25	0.08	0.00	74,714	0	24,816	0.01	0.00	0.00	0.00	3.00	0.00	0.99	0.00	1.33	0.01	0.00	0.00	0.02	0.00	0.00	select type#, blocks, extents,...
bunvx480ynf57	20,679	1.78	0.26	0.00	0	0	20,679	0.00	0.00	0.00	0.00	0.00	0.00	1.00	0.00	1.11	0.01	0.00	0.00	0.00	0.00	0.00	SELECT 1 FROM DUAL

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time (Global)

Total Cluster Wait Time (s): 2,241
Captured SQL account for 22.6% 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
c60h9paz2fkp6	137.32	262.48	27.88	85.44	795,139	13,035	43,303	43,345	0.00	0.01	0.00	0.00	18.34	0.30	1.00	6.13	2.15	0.45	8.40	0.19	0.37	2.32	DELETE FROM CJCL.CJ_SJTB_JL WH...
85t04831hywhk	59.95	124.15	10.52	46.26	1,331,019	5,962	92,145	40,200	0.00	0.00	0.00	0.00	33.11	0.15	2.29	2.68	1.02	0.17	4.55	0.33	0.17	2.15	DELETE FROM CJCL.CJ_CW_CWDW WH...
8qpwtrm143jkp	27.28	64.09	6.51	30.36	108,716	4,170	15,051	1	27.28	64.09	6.51	30.36	108,716.00	4,170.00	15,051.00	1.22	0.53	0.10	2.99	0.03	0.12	0.00	SELECT /+ USE_HASH(TBJD, GZ)...
1d4x5y7rhzyxg	24.98	172.44	137.50	1.50	30,679,807	213	9	9	2.78	19.16	15.28	0.17	3,408,867.44	23.67	1.00	1.12	1.42	2.20	0.15	7.51	0.01	0.00	select count(distinct tbjd.dwx...
7ys1f51rrpxrg	22.81	39.65	4.02	10.32	149,886	1,607	28,363	31,687	0.00	0.00	0.00	0.00	4.73	0.05	0.90	1.02	0.33	0.06	1.01	0.04	0.05	1.69	SELECT CWID FROM CJCL.CJ_CW_CW...
5u06x1z3hrmnv	21.03	86.01	59.14	0.00	15,611,808	0	3	3	7.01	28.67	19.71	0.00	5,203,936.00	0.00	1.00	0.94	0.71	0.95	0.00	3.82	0.00	0.00	select count(distinct tbjd.dwx...
aamqzv0c9n63a	19.92	43.38	20.36	0.03	2,095,358	8	1,380	16	1.25	2.71	1.27	0.00	130,959.88	0.50	86.25	0.89	0.36	0.33	0.00	0.51	0.00	0.00	SELECT TS.NAME UTSNAME, TS.BLO...
bp13rxpdavu5g	19.63	37.76	20.03	0.00	1,053,035	0	7	1	19.63	37.76	20.03	0.00	1,053,035.00	0.00	7.00	0.88	0.31	0.32	0.00	0.26	0.00	0.00	SELECT ml.FZ0043DM as CODE, ml...
a09y5t50r2z8c	18.55	77.61	32.26	21.78	5,616,394	11,139	30	6	3.09	12.93	5.38	3.63	936,065.67	1,856.50	5.00	0.83	0.64	0.52	2.14	1.38	0.31	0.00	select dwxtm, zzjgdm, dwmc, cl...
3j4mhbda5xjqb	13.87	37.77	21.47	0.03	5,381,706	2	1	1	13.87	37.77	21.47	0.03	5,381,706.00	2.00	1.00	0.62	0.31	0.34	0.00	1.32	0.00	0.00	select count(distinct tbjd.dwx...

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	2,287	0.63	0.02	0.16	0.05	0.11	0.21
Batched IO (full) vector count	180	0.05	0.00	0.02	0.03	0.00	0.05
Batched IO block miss count	42,582	11.79	0.31	2.95	1.59	1.56	4.72
Batched IO buffer defrag count	18	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO double miss count	229	0.06	0.00	0.02	0.01	0.00	0.03
Batched IO same unit count	19,071	5.28	0.14	1.32	0.65	0.73	1.94
Batched IO single block count	532	0.15	0.00	0.04	0.04	0.01	0.09
Batched IO slow jump count	16	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO vector block count	22,242	6.16	0.16	1.54	0.94	0.79	2.75
Batched IO vector read count	2,013	0.56	0.01	0.14	0.04	0.10	0.18
Block Cleanout Optim referenced	18,052	5.00	0.13	1.25	0.10	1.14	1.35
CCursor + sql area evicted	167	0.05	0.00	0.01	0.01	0.00	0.02
CPU used by this session	643,742	178.26	4.65	44.56	12.91	31.08	56.76
CPU used when call started	555,708	153.88	4.01	38.47	12.83	25.28	50.75
CR blocks created	20,193	5.59	0.15	1.40	0.20	1.13	1.59
Cached Commit SCN referenced	5,164,462	1,430.08	37.28	357.52	281.77	100.82	732.51
Clusterwide global transactions	144,091	39.90	1.04	9.98	0.95	9.01	11.27
Clusterwide global transactions spanning RAC nodes	6	0.00	0.00	0.00	0.00	0.00	0.00
Commit SCN cached	13,997	3.88	0.10	0.97	0.08	0.87	1.03
DB time	3,233,629,984	895,422.16	23,342.79	223,855.54	447,319.86	137.99	894,835.32
DBWR checkpoint buffers written	357,081	98.88	2.58	24.72	3.03	20.94	28.35
DBWR checkpoints	7	0.00	0.00	0.00	0.00	0.00	0.00
DBWR fusion writes	206,942	57.30	1.49	14.33	1.73	12.95	16.83
DBWR object drop buffers written	3	0.00	0.00	0.00		0.00	0.00
DBWR transaction table writes	704	0.19	0.01	0.05	0.00	0.05	0.05
DBWR undo block writes	75,212	20.83	0.54	5.21	0.70	4.32	6.00
DFO trees parallelized	60	0.02	0.00	0.00	0.00	0.00	0.00
DX/BB enqueue lock background get time	14,992	4.15	0.11	1.04	0.14	0.89	1.22
DX/BB enqueue lock background gets	288,183	79.80	2.08	19.95	1.90	18.02	22.54
DX/BB enqueue lock foreground requests	2,129,653	589.72	15.37	147.43	19.51	129.36	175.03
DX/BB enqueue lock foreground wait time	34,658	9.60	0.25	2.40	0.29	2.07	2.78
GTX processes spawned by autotune	2	0.00	0.00	0.00	0.00	0.00	0.00
GTX processes stopped by autotune	20	0.01	0.00	0.00	0.00	0.00	0.00
HSC Heap Segment Block Changes	929,235	257.31	6.71	64.33	8.37	54.23	74.37
Heap Segment Array Inserts	2,060	0.57	0.01	0.14	0.08	0.08	0.25
Heap Segment Array Updates	149	0.04	0.00	0.01	0.00	0.01	0.01
Number of read IOs issued	10,440	2.89	0.08	0.72	0.18	0.48	0.89
PX local messages recv'd	144	0.04	0.00	0.01	0.00	0.01	0.01
PX local messages sent	144	0.04	0.00	0.01	0.00	0.01	0.01
PX remote messages recv'd	720	0.20	0.01	0.05	0.00	0.05	0.05
PX remote messages sent	720	0.20	0.01	0.05	0.00	0.05	0.05
Parallel operations not downgraded	60	0.02	0.00	0.00	0.00	0.00	0.00
RowCR - row contention	19	0.01	0.00	0.00	0.00	0.00	0.00
RowCR attempts	12,538	3.47	0.09	0.87	0.04	0.82	0.92
RowCR hits	12,439	3.44	0.09	0.86	0.04	0.81	0.91
SMON posted for undo segment recovery	1	0.00	0.00	0.00		0.00	0.00
SMON posted for undo segment shrink	78	0.02	0.00	0.01	0.00	0.00	0.01
SQL*Net roundtrips to/from client	3,216,337	890.63	23.22	222.66	88.69	155.00	353.21
active txn count during cleanout	343,742	95.19	2.48	23.80	30.03	6.52	68.77
application wait time	215	0.06	0.00	0.01	0.01	0.00	0.03
background checkpoints completed	3	0.00	0.00	0.00	0.00	0.00	0.00
background checkpoints started	3	0.00	0.00	0.00	0.00	0.00	0.00
background timeouts	165,743	45.90	1.20	11.47	0.68	10.93	12.45
branch node splits	11	0.00	0.00	0.00	0.00	0.00	0.00
buffer is not pinned count	143,406,634	39,710.50	1,035.22	9,927.63	4,025.57	5,090.93	14,942.67
buffer is pinned count	196,497,446	54,411.82	1,418.47	13,602.96	4,251.13	7,752.78	17,437.70
bytes received via SQL*Net from client	635,995,305	176,112.65	4,591.10	44,028.16	14,848.38	30,344.07	63,475.37
bytes sent via SQL*Net to client	796,814,720	220,645.13	5,752.01	55,161.28	23,326.27	38,993.81	89,002.20
calls to get snapshot scn: kcmgss	1,486,105	411.52	10.73	102.88	26.92	73.91	138.41
calls to kcmgas	1,831,670	507.21	13.22	126.80	11.67	110.73	138.44
calls to kcmgcs	1,269,691	351.59	9.17	87.90	62.47	50.49	181.37
cell physical IO interconnect bytes	66,180,758,016	18,326,056.88	477,742.82	4,581,514.22	6,553,438.02	1,028,892.17	14,404,034.79
change write time	5,629	1.56	0.04	0.39	0.07	0.29	0.45
cleanout - number of ktugct calls	349,566	96.80	2.52	24.20	30.83	6.95	70.39
cleanouts only - consistent read gets	47,420	13.13	0.34	3.28	0.79	2.45	4.24
cluster key scan block gets	2,745,728	760.32	19.82	190.08	16.85	164.84	199.62
cluster key scans	2,650,484	733.94	19.13	183.49	16.23	159.14	192.14
cluster wait time	224,041	62.04	1.62	15.51	1.42	13.85	17.27
commit batch/immediate performed	30	0.01	0.00	0.00	0.00	0.00	0.00
commit batch/immediate requested	30	0.01	0.00	0.00	0.00	0.00	0.00
commit cleanout failures: block lost	63,044	17.46	0.46	4.36	0.18	4.23	4.62
commit cleanout failures: buffer being written	11	0.00	0.00	0.00	0.00	0.00	0.00
commit cleanout failures: callback failure	921	0.26	0.01	0.06	0.01	0.05	0.07
commit cleanout failures: cannot pin	400	0.11	0.00	0.03	0.01	0.02	0.04
commit cleanouts	1,151,926	318.98	8.32	79.74	7.63	70.05	88.57
commit cleanouts successfully completed	1,087,550	301.15	7.85	75.29	7.57	65.75	84.10
commit immediate performed	30	0.01	0.00	0.00	0.00	0.00	0.00
commit immediate requested	30	0.01	0.00	0.00	0.00	0.00	0.00
commit txn count during cleanout	113,201	31.35	0.82	7.84	1.98	5.63	10.27
concurrency wait time	45,012	12.46	0.32	3.12	2.72	0.93	6.71
consistent changes	261,429	72.39	1.89	18.10	9.57	9.20	29.35
consistent gets	394,422,382	109,219.11	2,847.24	27,304.78	19,884.91	10,193.54	55,939.99
consistent gets - examination	15,495,067	4,290.72	111.86	1,072.68	230.13	902.79	1,407.84
consistent gets direct	23,621	6.54	0.17	1.64	1.43	0.54	3.74
consistent gets from cache	394,398,761	109,212.57	2,847.07	27,303.14	19,885.23	10,192.38	55,938.89
consistent gets from cache (fastpath)	370,563,810	102,612.47	2,675.01	25,653.12	19,644.95	8,653.71	53,897.05
cursor authentications	13,060	3.62	0.09	0.90	0.19	0.80	1.20
data blocks consistent reads - undo records applied	242,400	67.12	1.75	16.78	9.51	7.55	27.92
db block changes	7,392,511	2,047.05	53.36	511.76	55.66	440.08	562.84
db block gets	13,975,426	3,869.92	100.89	967.48	112.51	835.99	1,100.99
db block gets direct	10,974	3.04	0.08	0.76	1.49	0.01	3.00
db block gets from cache	13,964,452	3,866.88	100.81	966.72	112.20	835.98	1,100.97
db block gets from cache (fastpath)	3,139,723	869.42	22.66	217.35	21.49	190.42	241.51
deferred (CURRENT) block cleanout applications	273,111	75.63	1.97	18.91	2.79	15.17	21.77
dirty buffers inspected	6,658	1.84	0.05	0.46	0.09	0.37	0.58
enqueue conversions	4,482	1.24	0.03	0.31	0.03	0.28	0.34
enqueue releases	1,313,326	363.67	9.48	90.92	10.84	80.99	105.57
enqueue requests	1,317,001	364.69	9.51	91.17	10.70	81.33	105.57
enqueue timeouts	3,686	1.02	0.03	0.26	0.17	0.00	0.34
enqueue waits	17,691	4.90	0.13	1.22	1.48	0.28	3.44
exchange deadlocks	2,389	0.66	0.02	0.17	0.04	0.13	0.22
execute count	1,870,114	517.85	13.50	129.46	53.07	89.67	207.71
failed probes on index block reclamation	3	0.00	0.00	0.00		0.00	0.00
file io wait time	6,638,671,986	1,838,308.39	47,922.96	459,577.10	587,368.59	146,741.34	1,340,002.73
frame signature mismatch	6	0.00	0.00	0.00	0.00	0.00	0.00
free buffer inspected	2,711,008	750.70	19.57	187.68	39.98	163.85	247.47
free buffer requested	2,840,418	786.54	20.50	196.63	40.41	169.93	256.83
gc CPU used by this session	110,987	30.73	0.80	7.68	0.37	7.37	8.11
gc blocks compressed	637,142	176.43	4.60	44.11	4.55	37.43	47.13
gc blocks lost	2	0.00	0.00	0.00		0.00	0.00
gc cr block build time	538	0.15	0.00	0.04	0.00	0.03	0.04
gc cr block flush time	10,395	2.88	0.08	0.72	0.09	0.58	0.78
gc cr block read wait time	15	0.00	0.00	0.00	0.00	0.00	0.00
gc cr block receive time	44,018	12.19	0.32	3.05	0.41	2.74	3.63
gc cr block send time	1,358	0.38	0.01	0.09	0.01	0.08	0.10
gc cr blocks received	468,748	129.80	3.38	32.45	3.92	28.48	37.02
gc cr blocks served	468,962	129.86	3.39	32.46	2.72	28.82	35.09
gc current block flush time	18,103	5.01	0.13	1.25	0.05	1.21	1.29
gc current block pin time	8,734	2.42	0.06	0.60	0.08	0.52	0.68
gc current block receive time	249,247	69.02	1.80	17.25	5.79	10.46	22.97
gc current block send time	4,903	1.36	0.04	0.34	0.01	0.32	0.35
gc current blocks received	1,621,240	448.94	11.70	112.23	22.99	82.59	131.39
gc current blocks served	1,621,346	448.96	11.70	112.24	5.97	104.05	117.92
gc kbytes saved	2,098,356	581.05	15.15	145.26	15.86	123.30	159.31
gc kbytes sent	14,624,108	4,049.54	105.57	1,012.39	33.23	968.54	1,046.29
gc local grants	252,547	69.93	1.82	17.48	21.56	4.56	49.64
gc reader bypass grants	52,501	14.54	0.38	3.63	0.67	3.00	4.52
gc remote grants	438,600	121.45	3.17	30.36	14.97	11.03	46.34
gcs messages sent	7,824,093	2,166.56	56.48	541.64	58.07	494.44	623.03
ges messages sent	2,735,212	757.40	19.74	189.35	71.52	125.56	276.82
global enqueue get time	76,647	21.22	0.55	5.31	2.68	3.01	8.89
global enqueue gets async	44,229	12.25	0.32	3.06	0.96	2.36	4.44
global enqueue gets sync	6,832,157	1,891.88	49.32	472.97	108.91	399.76	632.56
global enqueue releases	6,431,033	1,780.81	46.42	445.20	109.46	373.05	607.54
heap block compress	34,496	9.55	0.25	2.39	0.53	1.69	2.88
hot buffers moved to head of LRU	911,366	252.37	6.58	63.09	107.66	5.61	224.48
immediate (CR) block cleanout applications	47,426	13.13	0.34	3.28	0.79	2.45	4.24
immediate (CURRENT) block cleanout applications	199,465	55.23	1.44	13.81	1.64	12.01	15.75
index crx upgrade (positioned)	40,299	11.16	0.29	2.79	2.86	0.43	6.72
index crx upgrade (prefetch)	1,211	0.34	0.01	0.08	0.13	0.01	0.28
index fast full scans (full)	37,307	10.33	0.27	2.58	0.83	1.88	3.78
index fetch by key	42,309,137	11,715.76	305.42	2,928.94	904.13	2,093.93	3,883.69
index scans kdiixs1	21,792,716	6,034.59	157.32	1,508.65	290.17	1,269.50	1,930.95
leaf node 90-10 splits	93	0.03	0.00	0.01	0.00	0.00	0.01
leaf node splits	2,294	0.64	0.02	0.16	0.04	0.12	0.19
lob reads	2,740	0.76	0.02	0.19	0.03	0.16	0.23
lob writes	806	0.22	0.01	0.06	0.05	0.01	0.12
lob writes unaligned	352	0.10	0.00	0.02	0.01	0.01	0.04
logons cumulative	1,499	0.42	0.01	0.10	0.09	0.05	0.24
messages received	1,603,138	443.92	11.57	110.98	8.97	99.75	119.51
messages sent	1,603,137	443.92	11.57	110.98	8.97	99.75	119.51
min active SCN optimization applied on CR	2,314	0.64	0.02	0.16	0.04	0.10	0.19
no buffer to keep pinned count	18,780	5.20	0.14	1.30	0.10	1.20	1.43
no work - consistent read gets	377,254,930	104,465.30	2,723.31	26,116.32	19,635.00	9,159.57	54,359.03
non-idle wait count	21,018,704	5,820.26	151.73	1,455.07	429.82	1,024.64	1,967.15
non-idle wait time	692,479	191.75	5.00	47.94	5.91	42.64	56.41
opened cursors cumulative	602,062	166.72	4.35	41.68	41.15	19.39	103.37
parse count (describe)	102	0.03	0.00	0.01	0.00	0.00	0.01
parse count (failures)	133	0.04	0.00	0.01	0.01	0.00	0.03
parse count (hard)	535,899	148.40	3.87	37.10	2.93	33.67	40.81
parse count (total)	968,610	268.22	6.99	67.05	42.66	43.09	130.97
parse time cpu	110,539	30.61	0.80	7.65	0.67	7.03	8.49
parse time elapsed	217,654	60.27	1.57	15.07	2.72	12.21	18.68
physical read IO requests	365,772	101.29	2.64	25.32	28.83	6.74	68.26
physical read bytes	29,142,581,248	8,069,850.09	210,373.22	2,017,462.52	3,447,292.51	58,566.59	7,176,493.89
physical read total IO requests	440,332	121.93	3.18	30.48	28.69	11.93	73.21
physical read total bytes	32,860,686,336	9,099,425.37	237,213.32	2,274,856.34	3,329,958.50	374,106.77	7,257,393.30
physical read total multi block requests	6,304	1.75	0.05	0.44	0.26	0.22	0.81
physical reads	3,557,444	985.09	25.68	246.27	420.81	7.15	876.04
physical reads cache	544,955	150.90	3.93	37.73	29.67	5.97	73.99
physical reads cache prefetch	443,104	122.70	3.20	30.67	29.24	0.36	65.32
physical reads direct	3,012,489	834.19	21.75	208.55	413.07	1.10	828.15
physical reads direct (lob)	12,959	3.59	0.09	0.90	0.28	0.54	1.15
physical reads direct temporary tablespace	2,988,720	827.60	21.57	827.60		827.60	827.60
physical write IO requests	666,450	184.55	4.81	46.14	24.92	31.48	83.33
physical write bytes	29,106,790,400	8,059,937.83	210,114.85	2,014,984.46	3,357,233.77	313,457.61	7,050,740.61
physical write total IO requests	951,443	263.46	6.87	65.87	22.47	51.91	99.06
physical write total bytes	33,320,071,680	9,226,631.51	240,529.51	2,306,657.88	3,226,775.09	654,785.41	7,146,641.50
physical write total multi block requests	7,447	2.06	0.05	0.52	0.17	0.27	0.67
physical writes	3,553,075	983.88	25.65	245.97	409.82	38.26	860.69
physical writes direct	2,999,463	830.58	21.65	207.64	413.25	0.01	827.52
physical writes direct (lob)	10,914	3.02	0.08	0.76	1.49	0.00	3.00
physical writes direct temporary tablespace	2,988,375	827.51	21.57	827.51		827.51	827.51
physical writes from cache	553,612	153.30	4.00	38.33	4.60	33.17	44.34
physical writes non checkpoint	3,454,461	956.57	24.94	239.14	410.70	31.12	855.18
pinned buffers inspected	783	0.22	0.01	0.05	0.01	0.05	0.07
prefetched blocks aged out before use	6,896	1.91	0.05	0.48	0.93	0.00	1.87
process last non-idle time	14,449	4.00	0.10	1.00	0.00	1.00	1.00
queries parallelized	60	0.02	0.00	0.00	0.00	0.00	0.00
recursive calls	3,885,639	1,075.97	28.05	268.99	70.76	177.16	335.79
recursive cpu usage	123,205	34.12	0.89	8.53	0.80	7.85	9.53
redo blocks checksummed by FG (exclusive)	373,576	103.45	2.70	25.86	23.78	11.68	61.36
redo blocks written	2,831,990	784.20	20.44	196.05	36.35	157.53	241.83
redo buffer allocation retries	10	0.00	0.00	0.00		0.00	0.00
redo entries	4,571,622	1,265.92	33.00	316.48	32.36	274.32	348.36
redo k-bytes read total	2,478,284	686.26	17.89	228.75	0.20	228.63	228.98
redo log space requests	10	0.00	0.00	0.00		0.00	0.00
redo log space wait time	16	0.00	0.00	0.00		0.00	0.00
redo ordering marks	50,510	13.99	0.36	3.50	0.41	3.00	3.96
redo size	1,336,195,220	370,003.92	9,645.67	92,500.98	17,643.06	74,195.89	115,105.01
redo size for direct writes	90,295,876	25,003.54	651.82	6,250.89	12,283.09	70.63	24,675.45
redo subscn max counts	57,810	16.01	0.42	4.00	0.37	3.54	4.43
redo synch time	34,081	9.44	0.25	2.36	0.64	1.61	3.15
redo synch writes	152,443	42.21	1.10	10.55	2.73	7.12	13.65
redo wastage	67,169,876	18,599.92	484.88	4,649.98	696.12	3,731.14	5,419.91
redo write broadcast ack count	9,789	2.71	0.07	0.68	0.12	0.52	0.78
redo write broadcast ack time	10,228,341	2,832.32	73.84	708.08	106.95	579.09	824.97
redo write time	51,043	14.13	0.37	3.53	0.56	2.81	4.15
redo writes	253,148	70.10	1.83	17.52	2.79	13.84	20.56
rollback changes - undo records applied	95	0.03	0.00	0.01	0.00	0.00	0.01
rows fetched via callback	2,632,937	729.08	19.01	182.27	23.01	158.28	213.47
session cursor cache hits	173,263	47.98	1.25	15.99	3.92	12.89	20.40
session logical reads	408,397,823	113,089.04	2,948.12	28,272.26	19,964.14	11,122.17	57,040.98
shared hash latch upgrades - no wait	442,160	122.44	3.19	30.61	14.63	17.48	45.85
shared hash latch upgrades - wait	5,560	1.54	0.04	0.38	0.74	0.01	1.50
sorts (memory)	1,124,832	311.48	8.12	77.87	35.93	52.73	131.15
sorts (rows)	270,389,588	74,872.87	1,951.88	18,718.22	25,735.60	4,691.81	57,293.17
sql area evicted	537,854	148.94	3.88	37.23	3.10	33.54	41.05
sql area purged	133	0.04	0.00	0.01	0.01	0.00	0.03
summed dirty queue length	38,972	10.79	0.28	2.70	0.99	1.42	3.84
switch current to new buffer	129,085	35.74	0.93	8.94	1.62	7.01	10.46
table fetch by rowid	151,934,893	42,072.05	1,096.78	10,518.01	4,325.07	5,005.33	15,424.25
table fetch continued row	1,244,350	344.57	8.98	86.14	67.33	42.24	185.53
table scan blocks gotten	223,800,229	61,972.39	1,615.56	15,493.10	19,159.84	2,765.18	43,566.70
table scan rows gotten	15,327,904,278	4,244,441.01	110,648.42	1,061,110.25	1,407,404.40	248,144.17	3,161,259.46
table scans (short tables)	78,893	21.85	0.57	5.46	4.92	2.32	12.80
total cf enq hold time	7,402	2.05	0.05	0.51	0.09	0.43	0.63
total number of cf enq holders	1,148	0.32	0.01	0.08	0.00	0.08	0.08
total number of times SMON posted	79	0.02	0.00	0.01	0.00	0.00	0.01
transaction rollbacks	30	0.01	0.00	0.00	0.00	0.00	0.00
transaction tables consistent read rollbacks	45	0.01	0.00	0.00	0.00	0.00	0.01
transaction tables consistent reads - undo records applied	3,993	1.11	0.03	0.28	0.45	0.02	0.95
undo change vector size	485,887,644	134,546.52	3,507.50	33,636.63	3,493.96	29,354.62	37,638.65
user I/O wait time	101,725	28.17	0.73	7.04	3.82	3.88	12.59
user calls	3,628,128	1,004.66	26.19	251.17	127.89	163.61	441.28
user commits	93,007	25.75	0.67	6.44	0.77	5.91	7.56
user rollbacks	45,521	12.61	0.33	12.61		12.61	12.61
workarea executions - onepass	24	0.01	0.00	0.01		0.01	0.01
workarea executions - optimal	964,104	266.97	6.96	66.74	8.42	56.85	76.02
write clones created in background	1	0.00	0.00	0.00		0.00	0.00
write clones created in foreground	17	0.00	0.00	0.00	0.00	0.00	0.00

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)	687,730	190.44	4.96	47.61	2.66	44.77	51.20
acks for commit broadcast(logical)	746,610	206.74	5.39	51.69	2.53	48.90	55.04
broadcast msgs on commit(actual)	747,652	207.03	5.40	51.76	8.31	40.80	60.82
broadcast msgs on commit(logical)	757,236	209.69	5.47	52.42	8.36	41.40	61.54
broadcast msgs on commit(wasted)	44,776	12.40	0.32	3.10	0.52	2.65	3.85
broadcast on commit wait time(ms)	7,703	2.13	0.06	0.53	0.08	0.46	0.63
broadcast on commit waits	9,817	2.72	0.07	0.68	0.12	0.52	0.78
flow control messages received	443	0.12	0.00	0.03	0.03	0.00	0.07
flow control messages sent	443	0.12	0.00	0.03	0.03	0.00	0.08
gcs assume cvt	14,272	3.95	0.10	0.99	0.21	0.74	1.23
gcs assume no cvt	1,081,996	299.61	7.81	74.90	15.18	63.25	95.96
gcs ast xid	224	0.06	0.00	0.02	0.00	0.01	0.02
gcs blocked converts	808,833	223.97	5.84	55.99	6.28	51.45	65.27
gcs blocked cr converts	384,936	106.59	2.78	26.65	2.14	24.31	29.49
gcs compatible basts	2,997	0.83	0.02	0.21	0.02	0.19	0.22
gcs compatible cr basts (global)	79,820	22.10	0.58	5.53	1.30	3.75	6.60
gcs compatible cr basts (local)	822,710	227.82	5.94	56.95	8.71	49.16	65.37
gcs cr basts to PIs	214	0.06	0.00	0.01	0.01	0.01	0.02
gcs cr serve without current lock	148	0.04	0.00	0.01	0.01	0.00	0.02
gcs dbwr flush pi msgs	223,266	61.82	1.61	15.46	1.83	13.98	18.14
gcs dbwr write request msgs	182,298	50.48	1.32	12.62	1.16	11.73	14.25
gcs error msgs	1	0.00	0.00	0.00		0.00	0.00
gcs forward cr to pinged instance	1,004	0.28	0.01	0.07	0.04	0.02	0.10
gcs immediate (compatible) converts	26,078	7.22	0.19	1.81	0.31	1.53	2.22
gcs immediate (null) converts	31,706	8.78	0.23	2.19	0.08	2.10	2.30
gcs immediate cr (compatible) converts	84,018	23.27	0.61	5.82	6.48	0.54	14.17
gcs immediate cr (null) converts	267,620	74.11	1.93	18.53	23.46	5.16	53.55
gcs indirect ast	130,404	36.11	0.94	9.03	0.72	8.14	9.90
gcs indirect bidless ast	40,326	11.17	0.29	2.79	0.22	2.57	3.06
gcs indirect fg ast	128,987	35.72	0.93	8.93	0.74	8.05	9.87
gcs lms flush pi msgs	128,312	35.53	0.93	8.88	1.25	7.46	10.44
gcs lms write request msgs	117,790	32.62	0.85	8.15	1.06	6.67	9.12
gcs msgs process time(ms)	72,128	19.97	0.52	4.99	1.02	4.13	6.44
gcs msgs received	7,863,494	2,177.47	56.76	544.37	33.71	496.98	568.59
gcs new served by master	3,325	0.92	0.02	0.23	0.05	0.19	0.30
gcs out-of-order msgs	4	0.00	0.00	0.00	0.00	0.00	0.00
gcs pings refused	1,810	0.50	0.01	0.13	0.02	0.10	0.15
gcs queued converts	18,774	5.20	0.14	1.30	0.28	0.96	1.62
gcs reader bypass N->Xw ping local	1,360	0.38	0.01	0.09	0.11	0.03	0.25
gcs reader bypass N->Xw ping remote	1,066	0.30	0.01	0.07	0.05	0.03	0.14
gcs reader bypass grant X on assume	1,833	0.51	0.01	0.13	0.09	0.05	0.25
gcs reader bypass grant fg ast	38,307	10.61	0.28	2.65	0.54	2.12	3.39
gcs reader bypass grant immediate	52,507	14.54	0.38	3.63	0.19	3.43	3.88
gcs refuse xid	170	0.05	0.00	0.01	0.00	0.01	0.02
gcs regular cr	468,103	129.62	3.38	32.41	10.19	23.16	45.68
gcs retry convert request	172	0.05	0.00	0.01	0.01	0.01	0.02
gcs side channel msgs actual	146,070	40.45	1.05	10.11	1.30	9.16	11.93
gcs side channel msgs logical	2,259,123	625.57	16.31	156.39	26.69	120.11	180.02
gcs stale cr	168	0.05	0.00	0.02	0.02	0.01	0.03
gcs undo cr	84,806	23.48	0.61	5.87	0.48	5.33	6.34
gcs write notification msgs	7,961	2.20	0.06	0.55	0.10	0.46	0.69
gcs writes refused	564	0.16	0.00	0.04	0.01	0.03	0.05
ges msgs process time(ms)	46,906	12.99	0.34	3.25	1.52	2.01	5.22
ges msgs received	2,694,854	746.23	19.45	186.56	20.86	159.99	203.42
global posts queue time	722	0.20	0.01	0.07	0.06	0.03	0.14
global posts queued	188	0.05	0.00	0.02	0.01	0.01	0.03
global posts requested	189	0.05	0.00	0.02	0.01	0.01	0.03
global posts sent	188	0.05	0.00	0.02	0.01	0.01	0.03
implicit batch messages received	176,260	48.81	1.27	12.20	1.59	10.72	14.42
implicit batch messages sent	176,345	48.83	1.27	12.21	3.12	9.08	16.47
lmd msg send time(ms)	7,004	1.94	0.05	0.48	0.05	0.44	0.55
messages flow controlled	213,760	59.19	1.54	14.80	3.14	11.76	18.39
messages queue sent actual	4,572,728	1,266.23	33.01	316.56	16.27	296.64	335.02
messages queue sent logical	613,168	169.79	4.43	42.45	15.53	26.72	61.62
messages received actual	8,680,325	2,403.66	62.66	600.91	30.15	567.41	634.69
messages received logical	10,558,306	2,923.69	76.22	730.92	54.32	656.97	772.00
messages sent directly	4,009,709	1,110.32	28.95	277.58	68.25	212.32	358.59
messages sent indirectly	3,349,180	927.42	24.18	231.85	41.77	196.91	288.61
messages sent not implicit batched	348	0.10	0.00	0.02	0.02	0.01	0.05
messages sent pbatched	4,802,012	1,329.72	34.66	332.43	55.54	271.35	405.07
msgs causing lmd to send msgs	815,969	225.95	5.89	56.49	4.40	52.03	62.29
msgs causing lms(s) to send msgs	1,349,719	373.75	9.74	93.44	6.11	87.47	99.15
msgs received queue time (ms)	429,852	119.03	3.10	29.76	9.59	17.68	40.86
msgs received queued	10,558,240	2,923.67	76.22	730.92	54.32	656.96	772.00
msgs sent queue time (ms)	212,820	58.93	1.54	14.73	8.54	8.35	27.23
msgs sent queue time on ksxp (ms)	5,269,983	1,459.30	38.04	364.83	57.94	309.06	437.91
msgs sent queued	4,863,833	1,346.84	35.11	336.71	19.89	315.77	361.69
msgs sent queued on ksxp	8,681,625	2,404.02	62.67	601.00	82.60	529.30	701.31
process batch messages received	3,094,093	856.78	22.34	214.20	34.01	179.44	256.10
process batch messages sent	3,216,041	890.55	23.22	222.64	17.15	197.00	233.23

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	360	361	51,349	52,078	2,612,715	2,619,901
2	246	243	51,959	52,763	707,688	707,839
3	242	240	47,506	48,350	803,443	804,819
4	245	242	48,316	49,147	821,654	822,649
Sum	1,093	1,086	199,130	202,338	4,945,500	4,955,208
Avg	273	272	49,783	50,585	1,236,375	1,238,802
Std	58	60	2,200	2,163	918,921	922,114

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.89	0.58	0.01	0.68	0.35	0.00	0.10	16.45	10.26	0.89	60.04	37.21	0.00	21.62
2	0.51	0.18	0.01	0.67	0.29	0.02	0.12	20.26	11.31	0.80	51.61	30.83	0.46	19.07
3	6.92	0.37	6.47	6.81	0.26	6.46	0.08	73.20	12.60	55.65	98.98	28.09	55.16	14.80
4	0.36	0.05	0.01	0.62	0.30	0.00	0.09	11.92	5.95	0.76	52.17	32.45	0.01	18.52
Sum	8.68	1.18	6.49	8.80	1.20	6.49	0.38	121.81	40.12	58.10	262.80	128.57	55.63	74.01
Avg	2.17	0.29	1.62	2.20	0.30	1.62	0.10	30.45	10.03	14.53	65.70	32.14	13.91	18.50

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	0.89	0.59	0.00	0.68	0.35	0.00	0.10	16.45	11.17	0.01	60.03	37.21	0.00	21.61
2	0.51	0.21	0.00	0.67	0.32	0.00	0.12	20.26	15.07	0.01	51.61	31.38	0.00	19.06
3	6.92	0.38	6.47	6.81	0.26	6.46	0.08	73.20	13.09	55.19	98.98	28.09	55.16	14.80
4	0.36	0.06	0.00	0.62	0.30	0.00	0.09	11.91	6.73	0.01	52.16	32.48	0.00	18.51
Sum	8.68	1.23	6.47	8.80	1.22	6.46	0.38	121.81	46.07	55.23	262.79	129.16	55.16	73.98
Avg	2.17	0.31	1.62	2.20	0.30	1.62	0.10	30.45	11.52	13.81	65.70	32.29	13.79	18.50

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 90.1% of Total Logical Reads: 408,397,823
Captured Segments account for 8.1% of Total Physical Reads: 3,557,444
Captured Segments account for 26.8% of Total Physical Read Requests: 365,772
Captured Segments account for 26.8% of Total UnOptimized Read Requests: 365,772
Captured Segments account for 0.0% of Total Optimized Read Requests: 1
Captured Segments account for 0.1% of Total Direct Physical Reads: 3,012,489
Captured Segments account for 12.4% of Total Physical Writes: 3,553,075
Captured Segments account for 62.4% of Total Physical Write Requests: 666,450
Captured Segments account for 0.4% of Total Direct Physical Writes: 2,999,463
Captured Segments account for 0.0% of Total Table Scans: 37,307
Captured Segments account for 69.9% of Total CR Blocks Received: 468,748
Captured Segments account for 91.6% of Total Current Blocks Received: 1,621,240
Captured Segments account for 69.9% of Total CR Blocks Served: 468,962
Captured Segments account for 91.6% of Total Current Blocks Served: 1,621,346

Statistic	Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Value	%Total	%Capture
buffer busy waits	CJCL	INDEX_DATA	IDX_CJ_CJ_YSCLJL	PART_201201YY	INDEX PARTITION	726		50.45
	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	285		19.81
	CJCL	INDEX_DATA	PK_CJ_CW_CWDW		INDEX	155		10.77
	CJCL	NEWCJCL_DATA	IND_SJZT	RWID_601_BGQ_201302MM	INDEX SUBPARTITION	153		10.63
	CJCL	INDEX_DATA	IND_CWDW		INDEX	120		8.34
db block changes	CJCL	INDEX_DATA	PK_CJ_CW_CWDW		INDEX	243,728		23.47
	CJCL	INDEX_DATA	IND_CWDW		INDEX	211,072		20.33
	CJCL	NEWCJCL_DATA	CJ_CW_CWDW		TABLE	204,672		19.71
	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	199,632		19.23
	CJCL	INDEX_DATA	IDX_CJ_CJ_YSCLJL	PART_201302MM	INDEX PARTITION	179,280		17.27
gc buffer busy	CJCL	NEWCJCL_DATA	IND_CJ_CJ_TBJD	RWID_600_BGQ_201201YY	INDEX SUBPARTITION	13,536		36.61
	CJCL	NEWCJCL_DATA	IND_JGCX_TBJD	RWID_600_BGQ_201201YY	INDEX SUBPARTITION	10,283		27.81
	CJCL	NEWCJCL_DATA	IND_RWID_BH	RWID_601_BGQ_201302MM	INDEX SUBPARTITION	5,790		15.66
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_601_BGQ_201302MM	TABLE SUBPARTITION	4,363		11.80
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_600_BGQ_201201YY	TABLE SUBPARTITION	3,002		8.12
gc cr blocks received	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_600_BGQ_201201YY	TABLE SUBPARTITION	51,717	11.03	30.79
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_601_BGQ_201302MM	TABLE SUBPARTITION	43,507	9.28	25.90
	CJCL	CJCL_DATA	IND_SBCX_SJTB		INDEX	27,008	5.76	16.08
	CJCL	NEWCJCL_DATA	CJ_CW_CWSJ		TABLE	24,265	5.18	14.44
	CJCL	NEWCJCL_DATA	IND_JGCX_TBJD	RWID_600_BGQ_201201YY	INDEX SUBPARTITION	21,494	4.59	12.79
gc cr blocks served	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_600_BGQ_201201YY	TABLE SUBPARTITION	51,717	11.03	30.79
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_601_BGQ_201302MM	TABLE SUBPARTITION	43,507	9.28	25.90
	CJCL	CJCL_DATA	IND_SBCX_SJTB		INDEX	27,008	5.76	16.08
	CJCL	NEWCJCL_DATA	CJ_CW_CWSJ		TABLE	24,265	5.17	14.44
	CJCL	NEWCJCL_DATA	IND_JGCX_TBJD	RWID_600_BGQ_201201YY	INDEX SUBPARTITION	21,494	4.58	12.79
gc cu blocks received	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_600_BGQ_201201YY	TABLE SUBPARTITION	108,088	6.67	30.01
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_601_BGQ_201302MM	TABLE SUBPARTITION	70,808	4.37	19.66
	CJCL	CJCL_DATA	C2012_000000_205_1_1		TABLE	66,578	4.11	18.49
	CJCL	NEWCJCL_DATA	CJ_CW_CWSJ		TABLE	62,570	3.86	17.37
	CJCL	NEWCJCL_DATA	IND_JGCX_TBJD	RWID_600_BGQ_201201YY	INDEX SUBPARTITION	52,112	3.21	14.47
gc cu blocks served	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_600_BGQ_201201YY	TABLE SUBPARTITION	108,088	6.67	30.01
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_601_BGQ_201302MM	TABLE SUBPARTITION	70,808	4.37	19.66
	CJCL	CJCL_DATA	C2012_000000_205_1_1		TABLE	66,578	4.11	18.49
	CJCL	NEWCJCL_DATA	CJ_CW_CWSJ		TABLE	62,570	3.86	17.37
	CJCL	NEWCJCL_DATA	IND_JGCX_TBJD	RWID_600_BGQ_201201YY	INDEX SUBPARTITION	52,112	3.21	14.47
logical reads	CJCL	CJCL_DATA	BCG_MSG		TABLE	137,928,464	33.77	46.15
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_601_BGQ_201302MM	TABLE SUBPARTITION	91,826,880	22.48	30.73
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_600_BGQ_201201YY	TABLE SUBPARTITION	41,494,304	10.16	13.89
	CJCL	CJCL_DATA	CJ_BB_DWTB		TABLE	17,163,216	4.20	5.74
	CJCL	CJCL_DATA	GH_BB_BBGZZ		TABLE	10,424,912	2.55	3.49
physical reads	CJCL	CJCL_DATA	C2013_000000_101_1_1	BGQ1101YY	TABLE PARTITION	93,109	2.62	42.42
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_580_BGQ_201201SS	TABLE SUBPARTITION	55,583	1.56	25.32
	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	41,590	1.17	18.95
	CJCL	CJCL_DATA	C2013_000000_205_1_1	BGQ1302MM	TABLE PARTITION	17,740	0.50	8.08
	CJCL	NEWCJCL_DATA	CJ_CW_CWSJ		TABLE	11,473	0.32	5.23
physical reads direct	CJCL	CJCL_DATA	SYS_LOB0000232440C00051$$		LOB	2,107		84.99
	CJCL	CJCL_DATA	SYS_LOB0000232484C00005$$		LOB	189		7.62
	CJCL	CJCL_DATA	SYS_LOB0000232440C00050$$		LOB	103		4.15
	CJCL	CJCL_DATA	SYS_LOB0000232440C00054$$		LOB	49		1.98
	CJCL	CJCL_DATA	SYS_LOB0000232440C00080$$		LOB	31		1.25
physical read requests	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_580_BGQ_201201SS	TABLE SUBPARTITION	13,676	3.74	28.34
	CJCL	NEWCJCL_DATA	CJ_CW_CWSJ		TABLE	11,473	3.14	23.78
	CJCL	NEWCJCL_DATA	IND_RWID_BH	RWID_601_BGQ_201302MM	INDEX SUBPARTITION	11,324	3.10	23.47
	CJCL	CJCL_DATA	PK_SJTB_JL		INDEX	7,590	2.08	15.73
	CJCL	CJCL_DATA	IND_CWSJ_RWID		INDEX	4,192	1.15	8.69
physical writes	CJCL	CJCL_DATA	PK_SJTB_JL		INDEX	33,419		23.37
	CJCL	CJCL_DATA	IND_SBCX_SJTB		INDEX	33,087		23.14
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_600_BGQ_201201YY	TABLE SUBPARTITION	27,580		19.29
	CJCL	CJCL_DATA	IDX_GZID		INDEX	25,538		17.86
	CJCL	CJCL_DATA	CJ_SJTB_JL		TABLE	23,380		16.35
physical writes direct	CJCL	CJCL_DATA	SYS_LOB0000232440C00051$$		LOB	7,914		76.58
	CJCL	CJCL_DATA	SYS_LOB0000232440C00078$$		LOB	1,278		12.37
	CJCL	CJCL_DATA	SYS_LOB0000232440C00081$$		LOB	435		4.21
	CJCL	CJCL_DATA	SYS_LOB0000232440C00050$$		LOB	367		3.55
	CJCL	CJCL_DATA	SYS_LOB0000232440C00080$$		LOB	340		3.29
physical write requests	CJCL	CJCL_DATA	PK_SJTB_JL		INDEX	32,663	4.90	23.55
	CJCL	CJCL_DATA	IND_SBCX_SJTB		INDEX	32,365	4.86	23.34
	CJCL	NEWCJCL_DATA	CJ_CJ_TBJD	RWID_600_BGQ_201201YY	TABLE SUBPARTITION	27,209	4.08	19.62
	CJCL	CJCL_DATA	IDX_GZID		INDEX	23,738	3.56	17.12
	CJCL	CJCL_DATA	CJ_SJTB_JL		TABLE	22,713	3.41	16.38
row lock waits	CJCL	INDEX_DATA	IDX_CJ_CJ_YSCLJL	PART_201201YY	INDEX PARTITION	99		26.54
	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	85		22.79
	CJCL	INDEX_DATA	IDX_CJ_CJ_YSCLJL	PART_201302MM	INDEX PARTITION	78		20.91
	CJCL	INDEX_DATA	CJ_YSCLJL_BH	PART_201201YY	INDEX PARTITION	60		16.09
	CJCL	NEWCJCL_DATA	IND_PK_PLTB	RWID_600_BGQ_201201YY	INDEX SUBPARTITION	51		13.67
table scans	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	1		25.00
	CJCL	INDEX_DATA	IDX_GH_DX_DCDXRW	RWID_601	INDEX PARTITION	1		25.00
	CJCL	INDEX_DATA	IND_SJXGJL	PART_201201YY	INDEX PARTITION	1		25.00
	CJCL	INDEX_DATA	IND_SJXGJL	PART_201212MM	INDEX PARTITION	1		25.00

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	193,510	0.00	193,510	0.00	0	0	0	0	0
BODY	1,747	0.17	209,251	0.01	12	0	0	209,236	209,236
CLUSTER	941	0.74	426	1.64	0	0	426	426	426
DBLINK	1,357	0.52	0		0	0	1,357	0	0
DIRECTORY	12	33.33	24	33.33	0	0	0	12	12
EDITION	790	0.13	1,512	0.46	4	0	790	790	790
INDEX	1,084,442	0.05	1,077,974	0.05	0	0	1,077,977	1,077,972	1,077,972
OBJECT ID	2	100.00	0		0	0	0	0	0
QUEUE	14,560	0.04	17,596	0.07	0	0	7,255	17,596	17,596
SCHEMA	1,872	0.00	0		0	0	722	0	0
SQL AREA	1,658,663	95.41	3,203,878	50.08	11,501	182	0	0	0
SUBSCRIPTION	7	57.14	7	57.14	0	0	0	7	7
TABLE/PROCEDURE	1,907,353	0.00	3,229,994	0.10	2,931	0	610,210	1,025,794	1,025,794
TRANSFORMATION	7,181	0.00	7,181	0.00	0	0	7,181	7,181	7,181
TRIGGER	37,698	0.02	40,448	0.59	231	0	0	40,448	40,448

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	15,360.00	15,360.00	12,817.17	12,810.81	1,606.68	1,620.62	2.39	2.39	0.00	0.00	1,024.00	1,024.00
2	15,360.00	15,360.00	12,900.67	12,897.96	1,419.97	1,423.68	0.00	0.00	0.00	0.00	1,024.00	1,024.00
3	15,360.00	15,360.00	13,009.35	13,004.01	1,233.61	1,241.30	0.00	0.00	0.00	0.00	1,024.00	1,024.00
4	15,360.00	15,360.00	12,979.11	12,975.00	1,275.69	1,281.56	2.45	2.45	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	1,155.05	1,165.28			3.06	3.08	3.81	3.82	44.54	45.17	238.92	238.92	377	378	377	378
	Freeable	231.56	233.19	0.00	0.00	0.88	0.88	1.08	1.07	9.81	9.81			262	266	262	266
	SQL	187.00	189.79	3.18	3.31	0.56	0.56	0.64	0.64	2.42	2.42	879.71	879.71	333	340	240	245
	PL/SQL	33.10	32.40	23.77	23.96	0.09	0.09	0.19	0.14	3.35	2.25	4.35	4.35	377	378	376	377
2	Other	967.65	969.95			3.68	3.73	4.43	4.44	38.68	38.68	594.25	594.25	263	260	263	260
	Freeable	234.25	233.69	0.00	0.00	1.06	1.07	2.05	2.06	21.63	21.63			220	219	220	219
	SQL	192.25	194.00	0.29	0.25	0.88	0.89	0.60	0.60	1.63	1.63	819.05	819.05	219	219	186	187
	PL/SQL	25.84	26.07	20.90	21.06	0.10	0.10	0.09	0.09	0.27	0.26	0.28	0.28	263	260	256	253
3	Other	860.92	865.67			3.32	3.37	3.40	3.39	22.24	22.24	593.88	593.88	259	257	259	257
	SQL	176.66	179.91	0.05	0.05	0.83	0.83	0.61	0.62	1.66	1.67	818.99	1,237.43	214	216	174	176
	Freeable	172.69	172.06	0.00	0.00	0.85	0.85	0.91	0.92	10.00	10.00			202	203	202	203
	PL/SQL	23.36	23.69	19.40	19.43	0.09	0.09	0.09	0.09	0.27	0.27	0.30	0.30	259	257	242	240
4	Other	893.31	893.15			3.41	3.45	3.37	3.38	22.24	22.24	225.15	225.15	262	259	262	259
	SQL	179.55	182.20	2.69	2.70	0.84	0.84	0.61	0.61	2.69	2.69	1,237.11	1,237.11	215	216	179	180
	Freeable	177.75	181.44	0.00	0.00	0.89	0.90	0.95	0.94	10.06	10.06			200	202	200	202
	PL/SQL	24.72	24.80	19.95	19.93	0.09	0.10	0.09	0.09	0.28	0.28	0.28	0.28	262	259	245	242

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
audit_file_dest	*	/u01/app/oracle/admin/zhbdb/adump
audit_trail	*	DB
cluster_database	*	TRUE
compatible	*	11.2.0.0.0
control_files	*	/oradata/zhbdb/zhbdb/control01.ctl, /oradata/zhbdb/zhbdb/control02.ctl
db_block_size	*	8192
db_domain	*
db_name	*	zhbdb
db_writer_processes	*	12
diagnostic_dest	*	/u01/app/oracle
instance_number	1	1
	2	2
	3	3
	4	4
job_queue_processes	*	1000
local_listener	*	LISTENER_DB
log_archive_dest_1	*	LOCATION=/archivelog/zhbdb
log_archive_format	*	%t_%s_%r.dbf
memory_max_target	*	80530636800
memory_target	*	80530636800
open_cursors	*	2000
optimizer_dynamic_sampling	*	0
parallel_min_servers	*	16
processes	*	2000
remote_listener	*	LISTENER_SCAN
remote_login_passwordfile	*	EXCLUSIVE
resource_limit	*	TRUE
service_names	*	zhbdbapp
sessions	*	3040
sga_max_size	*	64424509440
sga_target	*	64424509440
spfile	*	/oradata/zhbdb/zhbdb/spfilezhbdb.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

1d4x5y7rhzyxg select count(distinct tbjd.dwxtm) ROWCOUNTS from cjcl.CJ_CJ_TBJD tbjd, cjcl.GH_DX_DCDXRW dcdxrw where tbjd.dwxtm = dcdxrw.dwxtm and tbjd.rwid=dcdxrw.rwid and tbjd.rwid =:1 and tbjd.bh = 'B203' and tbjd.bgq = '201302MM' and dcdxrw.ZGTJJG like '120114002%'

298n8b3tuwbka SELECT TBJD.ZZJGDM, TBJD.DWMC, TBJD.XMID, TBJD.XMMC, CWSJ.GZCWXX, CWSJ.CWSM, SUBSTR(CWSJ.GZID, LENGTH(CWSJ.GZID)-6+1) AS SUBSORT, QZX.SHCWFLFH, (CASE WHEN( GZ.GZQXDM = '0' ) THEN '��' ELSE '˽��' END ) GZQXMC, (CASE WHEN( CWSJ.SHRLX = '1' ) THEN 'ͳ��' ELSE '��ҵ' END ) SHRMC, ZT.HSZTFH, RW.GLJB FROM CJCL.CJ_CJ_TBJD TBJD, CJCL.CJ_CW_CWSJ CWSJ, CJCL.GH_BB_GZZYH GZZYH, CJCL.GH_BB_GZZZC GZZZC, CJCL.CJ_ML_SHCWFL QZX, CJCL.GH_GZ_GZ GZ, CJCL.GH_DX_DCDXRW RW, CJCL.CJ_ML_HSZT ZT WHERE 1 = 1 AND TBJD.RWID = '000000000000_600' AND TBJD.BGQ = '201201YY' AND TBJD.BH = '101-1' AND cwsj.BH=tbjd.BH AND cwsj.RWID='000000000000_600' AND TBJD.RWID = CWSJ.RWID and tbjd.bgq = cwsj.bgq and tbjd.dwxtm = cwsj.dwxtm and tbjd.xmid = cwsj.xmid and cwsj.qzxdm = qzx.shcwfldm and cwsj.gzid=gz.gzid AND GZ.REPORTID = 'DA3AC4FC0' and cwsj.HSZTDM = zt.HSZTDM and tbjd.dwxtm = rw.dwxtm and rw.rwid = '000000000000_600' and gz.gzqxdm = '0' and gz.ghztdm='4' AND TBJD.SJZTBM = '4' AND TBJD.CJZGGZZID = GZZYH.GROUPID AND GZZYH.YHID = 'gy120105' AND GZZYH.GROUPID = GZZZC.GROUPID AND GZZZC.RWID = '000000000000_600' AND GZZZC.GZZLX = '1' AND GZZZC.GZZSSJG ='120105000000' AND TBJD.SB_TJJGJBDM <= '04' AND TBJD.TJZYDM IN (SELECT TJZY.TJZYDM FROM AQDB.ZK_JL_YH_TJZY TJZY WHERE TJZY.YHID='gy120105') AND CWSJ.QZXDM IN ('3') AND GZ.ZYY IN('1', '2') AND GZ.GLJG IN('000000000000', '120000000000', '120105000000') ORDER BY SUBSORT, TBJD.ZZJGDM

30jx64uuk7xk8 select sbjd_wb, sbjd_yb, sbjd_sbzs, tbjd_sbl, ys_wys, ys_wtg, ys_tg, ys_ysl, jgys_wys, jgys_wtg, jgys_tg, tjjgdm, tjjgjbdm, tjjgmc, zbip_num, zbip_zbl, iszg, case when sbjd_yb = 0 then '0%' else fixLostZero(round(decode((jgys_tg + jgys_wtg) / sbjd_yb * 100, '', '0', (jgys_tg + jgys_wtg) / sbjd_yb *100), 2))||'%' end jgys_ysl, case when sbjd_yb = 0 then '0%' else fixLostZero(round(decode(jgys_tg / sbjd_yb * 100, '', '0', jgys_tg / sbjd_yb *100), 2))||'%' end jgys_ystgl, case when sbjd_yb = 0 then '0%' else fixLostZero(round(decode(jgys_wtg / sbjd_yb * 100, '', '0', jgys_wtg / sbjd_yb *100), 2))||'%' end jgys_yswtgl from ( select decode(sbjd_wb, '', '0', sbjd_wb) sbjd_wb, decode(sbjd_yb, '', '0', sbjd_yb) sbjd_yb, decode(sbjd_yb + sbjd_wb, '', '0', sbjd_yb + sbjd_wb) sbjd_sbzs, fixLostZero(round(decode(((sbjd_yb / (sbjd_yb + sbjd_wb)) * 100), '', '0', ((sbjd_yb / (sbjd_yb + sbjd_wb)) *100)), 2))||'%' tbjd_sbl, decode(ys_wys, '', '0', ys_wys) ys_wys, decode(ys_wtg, '', '0', ys_wtg) ys_wtg, decode(ys_tg, '', '0', ys_tg) ys_tg, case when sbjd_yb = 0 then '0%' else fixLostZero(round(decode(ys_tg / sbjd_yb * 100, '', '0', ys_tg / sbjd_yb *100), 2))||'%' end ys_ysl, case when b.iszg = '1' then decode(jgys_wys_bj, '', '0', jgys_wys_bj) else decode(jgys_wys_xj, '', '0', jgys_wys_xj) end jgys_wys, case when b.iszg = '1' then decode(jgys_wtg_bj, '', '0', jgys_wtg_bj) else decode(jgys_wtg_xj, '', '0', jgys_wtg_xj) end jgys_wtg, case when b.iszg = '1' then decode(jgys_tg_bj, '', '0', jgys_tg_bj) else decode(jgys_tg_xj, '', '0', jgys_tg_xj) end jgys_tg, b.tjjgdm, b.tjjggbdm tjjgjbdm, b.tjjgmc, decode(zbip_num, '', '0', zbip_num) zbip_num, fixLostZero(round(decode(((zbip_num /(sbjd_yb + sbjd_wb)) * 100), '', '0', ((zbip_num /(sbjd_yb + sbjd_wb)) * 100)), 2))||'%' zbip_zbl, b.iszg from ( select sum(case when tbjd.sjztbm IN ('2', '3') then 1 else 0 end) sbjd_wb, sum(case when tbjd.sjztbm IN ('4', '-1') then 1 else 0 end) sbjd_yb, sum(decode (tbjd.zgyszt, '0', 1, 0)) ys_wys, sum(decode (tbjd.zgyszt, '1', 1, 0)) ys_wtg, sum(decode (tbjd.zgyszt, '2', 1, 0)) ys_tg, sum(decode (tbjd.jgyszt_tjjb04, '2', 1, 0)) jgys_tg_bj, sum(decode (tbjd.jgyszt_tjjb04, '1', 1, 0)) jgys_wtg_bj, sum(decode (tbjd.jgyszt_tjjb04, '0', 1, 0)) jgys_wys_bj, sum(decode (tbjd.jgyszt_tjjb05, '2', 1, 0)) jgys_tg_xj, sum(decode (tbjd.jgyszt_tjjb05, '1', 1, 0)) jgys_wtg_xj, sum(decode (tbjd.jgyszt_tjjb05, '0', 1, 0)) jgys_wys_xj, sum(case when tbjd.sjztbm IN ('4', '-1') and tbjd.sjddfsdm = '1' and substr(tbjd.clientip, 0, length('10.')) <> '10.' then 1 else 0 end) zbip_num, substr(tbjd.gljg, 0, 9)||'000' gljg from cjcl.cj_cj_tbjd tbjd where tbjd.bh = 'E204-2' and tbjd.bgq = '201201SS' and tbjd.rwid = '000000000000_580' and tbjd.sb_tjjgjbdm <= '04' and tbjd.sb_tjjgjbdm <= '04' group by substr(tbjd.gljg, 0, 9) ) a right join ( select t_tjjg.tjjgdm, t_tjjg.tjjgmc||'ֱ��' tjjgmc, t_t jj g.tjjggbdm, '1' iszg from cjcl.gy_ml_tjjg t_tjjg where t_tjjg.tjjgdm = '120223000000' union select t_tjjg.tjjgdm, t_tjjg.tjjgmc, t_tjjg.tjjggbdm, '0' iszg from cjcl.gy_ml_tjjg t_tjjg where t_tjjg.sjtjjgdm = '120223000000' and t_tjjg.bjtjjgdm <> '120223000000' ) b on a.gljg = b.tjjgdm ) order by tjjgjbdm, tjjgdm

3j4mhbda5xjqb select count(distinct tbjd.dwxtm) ROWCOUNTS from cjcl.CJ_CJ_TBJD tbjd, cjcl.GH_DX_DCDXRW dcdxrw where tbjd.dwxtm = dcdxrw.dwxtm and tbjd.rwid=dcdxrw.rwid and tbjd.rwid =:1 and tbjd.bh = '101-1' and tbjd.bgq = '201201YY' AND TBJD.TJZYDM IN (SELECT TJZY.TJZYDM FROM AQDB.ZK_JL_YH_TJZY TJZY WHERE TJZY.YHID='fwy126061') and dcdxrw.ZGTJJG like '126061%'

3qkb569jsvads INSERT INTO CJCL.CJ_CJ_YSCLJL (REPORTID, BGQ, XMID, DWXTM, YSSJ, YSZTMC, YSYJ, YSR, YSJBMC, TJJGDM, TJJGJBDM, YSZTDM, YSRID, BH, RWID)SELECT 'DA3AC4FC0', '201201YY', TBJD.XMID, TBJD.DWXTM, SYSDATE, '��ͨ��', :1, '��һ��', '�ؼ��', '126000000000', '03', '2', 'gly126000', TBJD.BH, '000000000000_600' FROM CJCL.CJ_CJ_TBJD TBJD WHERE 1 = 1 AND TBJD.RWID = '000000000000_600' AND TBJD.BH = '101-1' AND TBJD.BGQ = '201201YY' AND TBJD.SJZTBM = '4' AND TBJD.RWID = '000000000000_600' AND TBJD.GLJG LIKE '1260%'AND TBJD.DQSHZT = '5' AND TBJD.SB_TJJGJBDM <= '03' AND TBJD.TJZYDM IN (SELECT TJZY.TJZYDM FROM AQDB.ZK_JL_YH_TJZY TJZY WHERE TJZY.YHID='gly126000') AND TBJD.JGYSZT_TJJB03 <> '2' AND ( TBJD.TJJGJBDM <> '03' AND TBJD.JGYSZT_TJJB04 = '2' OR TBJD.TJJGJBDM = '03' ) AND TBJD.JGYSZT_TJJB01 <> '2' AND TBJD.JGYSZT_TJJB02 <> '2'

4bjjzk10c88v8 select decode(sbjd_wb, '', '0', sbjd_wb) sbjd_wb, decode(sbjd_yb, '', '0', sbjd_yb) sbjd_yb, decode(sbjd_yb + sbjd_wb, '', '0', sbjd_yb + sbjd_wb) sbjd_sbzs, fixLostZero(round(decode(((sbjd_yb / (sbjd_yb + sbjd_wb)) * 100), '', '0', ((sbjd_yb / (sbjd_yb + sbjd_wb)) *100)), 2))||'%' tbjd_sbl, decode(ys_wys, '', '0', ys_wys) ys_wys, decode(ys_wtg, '', '0', ys_wtg) ys_wtg, decode(ys_tg, '', '0', ys_tg) ys_tg, case when sbjd_yb = 0 then '0%' else fixLostZero(round(decode(ys_tg / sbjd_yb * 100, '', '0', ys_tg / sbjd_yb *100), 2))||'%' end ys_ysl, decode(jgys_wys, '', '0', jgys_wys) jgys_wys, decode(jgys_wtg, '', '0', jgys_wtg) jgys_wtg, decode(jgys_tg, '', '0', jgys_tg) jgys_tg, case when sbjd_yb = 0 then '0%' else fixLostZero(round(decode((jgys_tg + jgys_wtg) / sbjd_yb * 100, '', '0', (jgys_tg + jgys_wtg) / sbjd_yb *100), 2))||'%' end jgys_ysl, case when sbjd_yb = 0 then '0%' else fixLostZero(round(decode(jgys_tg / sbjd_yb * 100, '', '0', jgys_tg / sbjd_yb *100), 2))||'%' end jgys_ystgl, case when sbjd_yb = 0 then '0%' else fixLostZero(round(decode(jgys_wtg / sbjd_yb * 100, '', '0', jgys_wtg / sbjd_yb *100), 2))||'%' end jgys_yswtgl, decode(zbip_num, '', '0', zbip_num) zbip_num, fixLostZero(round(decode(((zbip_num /(sbjd_yb + sbjd_wb)) * 100), '', '0', ((zbip_num /(sbjd_yb + sbjd_wb)) * 100)), 2))||'%' zbip_zbl from ( select sum(case when tbjd.sjztbm IN ('2', '3') then 1 else 0 end) sbjd_wb, sum(case wh en tbjd.sjztbm IN ('4', '-1') then 1 else 0 end) sbjd_yb, sum(decode (tbjd.zgyszt, '0', 1, 0)) ys_wys, sum(decode (tbjd.zgyszt, '1', 1, 0)) ys_wtg, sum(decode (tbjd.zgyszt, '2', 1, 0)) ys_tg, sum(decode (tbjd.jgyszt_tjjb04, '2', 1, 0)) jgys_tg, sum(decode (tbjd.jgyszt_tjjb04, '1', 1, 0)) jgys_wtg, sum(decode (tbjd.jgyszt_tjjb04, '0', 1, 0)) jgys_wys, sum(case when tbjd.sjztbm IN ('4', '-1') and tbjd.sjddfsdm = '1' and substr(tbjd.clientip, 0, length('10.')) <> '10.' then 1 else 0 end) zbip_num from cjcl.cj_cj_tbjd tbjd where tbjd.bh = 'E204-2' and tbjd.bgq = '201201SS' and tbjd.rwid = '000000000000_580' and tbjd.sb_tjjgjbdm <= '04' and tbjd.sb_tjjgjbdm <= '04' and tbjd.gljg like '120223%' )

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

4xr8bc73u004f UPDATE CJCL.GH_BB_BBZC set ZBS=:1, BH=:2, BBZWQC=:3, BBYWQC=:4, BB=:5, BBLX=:6, ZYFLDM=:7, WH=:8, DCFFFLDM=:9, DCPDDM=:10, CJSJ=:11, YXQZ=:12, BBZTDM=:13, BYWJ=:14, BDCML=:15, CJR=:16, QSFS=:17, BBZWJC=:18, BBJB=:19, DCNR=:20, PZHJG=:21, BAJG=:22, BAWH=:23, ZBJG=:24, GLJGFZR=:25, BZH=:26, BZ=:27, SFYXJZLSSJ=:28, HZBSJYS=:29, SSRW=:30, XGSJ=:31, XGR=:32, BYDX=:33, HTMLBY=:34 , EXCELBY=:35, NBBS=:36, HZBLX=:37, SFGLB=:38 where REPORTID=:39

56pft0402x99d select "C101_1", "C101_2", "C209_1", "C209_2", "C211_1", "C211_2", "C213_1", "C213_2", "C217_1", "C217_2", "C218_1", "C218_2", "C301_1", "C301_2", "C302_1", "C302_2", "C307_1", "C307_2", "C308_1", "C308_2", "C309_1", "C309_2", "C310_1", "C310_2", "C312_1", "C312_2", "C313_1", "C313_2", "C314_1", "C314_2", "C317_1", "C317_2", "C318_1", "C318_2", "C319_1", "C319_2", "C322_1", "C323_1", "C322_2", "C327_1", "C323_2", "C327_2", "C328_1", "C328_2", "C401_1", "C401_2", "C402_1", "C501_1", "C402_2", "C501_2", "Z698", "Z699", "BGQ", "DCDXXTM", "ZZJGDM", "DWMC", "TJJG", "TJJGJB", "A001", "A002", "A003", "A004", "A005", "A006", OperationType, MsgParam1, MsgParam2, MsgParam3, MsgServiceId, MsgTypeId, MsgId from "CJCL"."C2013_000000_F103_1" right outer join BCG_Msg on "BGQ" = MsgParam1 and "DCDXXTM" = MsgParam2 and "ZZJGDM" = MsgParam3 where MsgServiceId = (select MsgServiceId from BCG_MsgService where MsgServiceName='C2013_000000_F103_1_283c1206-f3fe-45d9-abad-663a6cb253be') order by MsgId asc

5brubmy7nj4kf select dwxtm, zzjgdm, dwmc, clientip from ( select bb.dwxtm, bb.zzjgdm, bb.dwmc, clientip, rownum as rows_1 from (select distinct tbjd.dwxtm, tbjd.zzjgdm, tbjd.dwmc from cjcl.CJ_CJ_TBJD tbjd, cjcl.GH_DX_DCDXRW dcdxrw where tbjd.dwxtm = dcdxrw.dwxtm and tbjd.rwid=dcdxrw.rwid and tbjd.rwid =:1 and tbjd.bh = 'B203' and tbjd.bgq = '201302MM' and dcdxrw.ZGTJJG like '120114002%' and rownum <= 500) bb LEFT JOIN CJCL.CJ_CJ_TBJD tt ON bb.dwxtm=tt.dwxtm AND bb.dwmc=tt.dwmc AND bb.zzjgdm=tt.zzjgdm AND tt.bgq='201302MM' AND tt.bh='B203' AND TT.RWID='000000000000_601') cc

5u06x1z3hrmnv select count(distinct tbjd.dwxtm) ROWCOUNTS from cjcl.CJ_CJ_TBJD tbjd, cjcl.GH_DX_DCDXRW dcdxrw where tbjd.dwxtm = dcdxrw.dwxtm and tbjd.rwid=dcdxrw.rwid and tbjd.rwid =:1 and tbjd.bh = '101-1' and tbjd.bgq = '201201YY' AND TBJD.TJZYDM IN (SELECT TJZY.TJZYDM FROM AQDB.ZK_JL_YH_TJZY TJZY WHERE TJZY.YHID='xdtfwy120113') and dcdxrw.ZGTJJG='120113111000'

5vvyt2upfvnw0 select "BGQ", "DCDXXTM", "ZZJGDM", "TJJG", "TJJGJB", "DWMC", "C101_1", "C101_2", "C209_1", "C209_2", "C211_1", "C211_2", "C213_1", "C213_2", "C217_1", "C217_2", "C218_1", "C218_2", "C301_1", "C301_2", "C302_1", "C302_2", "C307_1", "C307_2", "C308_1", "C308_2", "C309_1", "C309_2", "C310_1", "C310_2", "C312_1", "C312_2", "C313_1", "C313_2", "C314_1", "C314_2", "C317_1", "C317_2", "C318_1", "C318_2", "C319_1", "C319_2", "C322_1", "C323_1", "C322_2", "C327_1", "C323_2", "C327_2", "C328_1", "C328_2", "C401_1", "C401_2", "C402_1", "C501_1", "C402_2", "C501_2", "Z698", "A001", "Z699", "A002", "A003", "A004", "A005", "A006", OperationType, MsgParam1, MsgParam2, MsgParam3, MsgServiceId, MsgTypeId, MsgId from "CJCL"."C2013_000000_F203_1" right outer join BCG_Msg on "BGQ" = MsgParam1 and "DCDXXTM" = MsgParam2 and "ZZJGDM" = MsgParam3 where MsgServiceId = (select MsgServiceId from BCG_MsgService where MsgServiceName='C2013_000000_F203_1_beaa024e-82da-4053-968b-641250cb07d6') order by MsgId asc

6kcjx3mypknuh SELECT /*��λ��ģ*/ T12.MLMC as MLMC, T12.MLDM as MLDM, T12.TG1202 as TG1202 , T11.TG1102 as TG1102 , CasE WHEN T11.TG1102 = 0 THEN 0 ELSE T12.TG1202/T11.TG1102*100 -100 END as TG02 , T12.TG1203 as TG1203 , T11.TG1103 as TG1103 , CasE WHEN T11.TG1103 = 0 THEN 0 ELSE T12.TG1203/T11.TG1103*100 -100 END as TG03 , T12.TG1204 as TG1204 , T11.TG1104 as TG1104 , CasE WHEN T11.TG1104 = 0 THEN 0 ELSE T12.TG1204/T11.TG1104*100 -100 END as TG04 , T12.TG1205 as TG1205 , T11.TG1105 as TG1105 , CasE WHEN T11.TG1105 = 0 THEN 0 ELSE T12.TG1205/T11.TG1105*100 -100 END as TG05 , T12.TG1206 as TG1206 , T11.TG1106 as TG1106 , CasE WHEN T11.TG1106 = 0 THEN 0 ELSE T12.TG1206/T11.TG1106*100 -100 END as TG06 , T12.TG1207 as TG1207 , T11.TG1107 as TG1107 , CasE WHEN T11.TG1107 = 0 THEN 0 ELSE T12.TG1207/T11.TG1107*100 -100 END as TG07 , T12.TG1208 as TG1208 , T11.TG1108 as TG1108 , CasE WHEN T11.TG1108 = 0 THEN 0 ELSE T12.TG1208/T11.TG1108*100 -100 END as TG08 , T12.TG1209 as TG1209 , T11.TG1109 as TG1109 , CasE WHEN T11.TG1109 = 0 THEN 0 ELSE T12.TG1209/T11.TG1109*100 -100 END as TG09 , T12.TG1210 as TG1210 , T11.TG1110 as TG1110 , CasE WHEN T11.TG1110 = 0 THEN 0 ELSE T12.TG1210/T11.TG1110*100 -100 END as TG10 , T12.TG1211 as TG1211 , T11.TG1111 as TG1111 , CasE WHEN T11.TG1111 = 0 THEN 0 ELSE T12.TG1211/T11.TG1111*100 -100 END as TG11 , T12.TG1212 as TG1212 , T11.TG1112 as TG1112 , CasE WHEN T11.TG1112 = 0 THEN 0 ELSE T12.TG1212/T11.TG1112*100 -100 END as TG12 , T12.TG1213 as TG1213 , T11.TG1113 as TG1113 , CasE WHEN T11.TG1113 = 0 THEN 0 ELSE T12.TG1213/T11.TG1113*100 -100 END as TG13 , T12.TG1214 as TG1214 , T11.TG1114 as TG1114 , CasE WHEN T11.TG1114 = 0 THEN 0 ELSE T12.TG1214/T11.TG1114*100 -100 END as TG14 , T12.TG1215 as TG1215 , T11.TG1115 as TG1115 , CasE WHEN T11.TG1115 = 0 THEN 0 ELSE T12.TG1215/T11.TG1115*100 -100 END as TG15 , T12.TG1216 as TG1216 , T11.TG1116 as TG1116 , CasE WHEN T11.TG1116 = 0 THEN 0 ELSE T12.TG1216/T11.TG1116*100 -100 END as TG16 , T12.TG1217 as TG1217 , T11.TG1117 as TG1117 , CasE WHEN T11.TG1117 = 0 THEN 0 ELSE T12.TG1217/T11.TG1117*100 -100 END as TG17 , T12.TG1218 as TG1218 , T11.TG1118 as TG1118 , CasE WHEN T11.TG1118 = 0 THEN 0 ELSE T12.TG1218/T11.TG1118*100 -100 END as TG18 , T12.TG1219 as TG1219 , T11.TG1119 as TG1119 , CasE WHEN T11.TG1119 = 0 THEN 0 ELSE T12.TG1219/T11.TG1119*100 -100 END as TG19 , T12.TG1220 as TG1220 , T11.TG1120 as TG1120 , CasE WHEN T11.TG1120 = 0 THEN 0 ELSE T12.TG1220/T11.TG1120*100 -100 END as TG20 , T12.TG1221 as TG1221 , T11.TG1121 as TG1121 , CasE WHEN T11.TG1121 = 0 THEN 0 ELSE T12.TG1221/T11.TG1121*100 -100 END as TG21 , T12.TG1222 as TG1222 , T11.TG1122 as TG1122 , CasE WHEN T11.TG1122 = 0 THEN 0 ELSE T12.TG1222/T11.TG1122*100 -100 END as TG22 FROM ( /*��λ��ģ*/ SELECT * FROM ( SELECT FZ0002DM as MLDM, FZ0002MC as MLMC FROM CJCL.GY_ML_FZ0002 ML WHERE BB = '201107010' ) DWGM LEFT JOIN ( /*2012��ͳ��*/ SELECT T101.B191 as B191 , SUM(NVL(L506.C3 , 0)) as TG1202, SUM(NVL(L506.C4 , 0)) as TG1203, SUM(NVL(L506.C5 , 0)) as TG1204, SUM(NVL(L506.C6 , 0)) as TG1205, SUM(NVL(L506.C7 , 0)) as TG1206, SUM(NVL(L506.C8 , 0)) as TG1207, SUM(NVL(L506.C9 , 0))/10 as TG1208, SUM(NVL(L506.C10, 0))/10 as TG1209, SUM(NVL(L506.C11, 0))/10 as TG1210, SUM(NVL(L506.C12, 0))/10 as TG1211, SUM(NVL(L506.C13, 0))/10 as TG1212, SUM(NVL(L506.C14, 0))/10 as TG1213, SUM(NVL(L506.C15, 0))/10 as TG1214, SUM(NVL(L506.C16, 0))/10 as TG1215, SUM(NVL(L506.C17, 0))/10 as TG1216, SUM(NVL(L506.C18, 0))/10 as TG1217, SUM(NVL(L506.C19, 0))/10 as TG1218, SUM(NVL(L506.C20, 0))/10 as TG1219, SUM(NVL(L506.C21, 0))/10 as TG1220, SUM(NVL(L506.C22, 0)) as TG1221, SUM(NVL(L506.C23, 0))/10 as TG1222 FROM C2013_000000_107_2_1 L506, CJCL.C2013_000000_101_1_1 T101 WHERE L506.DCDXXTM IN (SELECT DWXTM FROM CJCL.GH_DX_DCDXRW dcdxrw WHERE TJJGDM IN ('000000000000') AND dcdxrw.TJZYDM IN (SELECT TJZYDM FROM AQDB.ZK_JL_YH_TJZY WHERE YHID = 'zdsj') AND dcdxrw.RWID = '000000000000_600') AND L506.BGQ = :1 AND T101.BGQ = L506.BGQ AND T101.DCDXXTM = L506.DCDXXTM AND L506.TJJG='000000000000' AND T101.TJJG='000000000000' /*20130308*/ AND T101.B191 IN (1, 2) GROUP BY T101.B191 ) DWGM12 ON DWGM12.B191 = DWGM.MLDM ) T12 , ( /*��λ��ģ*/ SELECT * FROM ( SELECT FZ0002DM as MLDM, FZ0002MC as MLMC FROM CJCL.GY_ML_FZ0002 ML WHERE BB = '201107010' ) DWGM LEFT JOIN ( /*2011��ͳ��*/ SELECT T101.B191 as B191, SUM(NVL(L5061.C3 , 0)) as TG1102, SUM(NVL(L5061.C4 , 0)) as TG1103, SUM(NVL(L5061.C5 , 0)) as TG1104, SUM(NVL(L5061.C6 , 0)) as TG1105, SUM(NVL(L5061.C7 , 0)) as TG1106, SUM(NVL(L5061.C8 , 0)) as TG1107, SUM(NVL(L5061.C9 , 0))/10 as TG1108, SUM(NVL(L5061.C10, 0))/10 as TG1109, SUM(NVL(L5061.C11, 0))/10 as TG1110, SUM(NVL(L5061.C12, 0))/10 as TG1111, SUM(NVL(L5061.C13, 0))/10 as TG1112, SUM(NVL(L5061.C14, 0))/10 as TG1113, SUM(NVL(L5061.C15, 0))/10 as TG1114, SUM(NVL(L5061.C16, 0))/10 as TG1115, SUM(NVL(L5061.C17, 0))/10 as TG1116, SUM(NVL(L5061.C18, 0))/10 as TG1117, SUM(NVL(L5061.C19, 0))/10 as TG1118, SUM(NVL(L5061.C20, 0))/10 as TG1119, SUM(NVL(L5061.C21, 0))/10 as TG1120, SUM(NVL(L5061.C22, 0)) as TG1121, SUM(NVL(L5061.C23, 0))/10 as TG1122 FROM C2013_000000_107_2_1 L5061, CJCL.C2013_000000_101_1_1 T101 WHERE L5061.DCDXXTM IN (SELECT DWXTM FROM CJCL.GH_DX_DCDXRW dcdxrw WHERE TJJGDM IN ('000000000000') AND dcdxrw.TJZYDM IN (SELECT TJZYDM FROM AQDB.ZK_JL_YH_TJZY WHERE YHID = 'zdsj') AND dcdxrw.RWID = '000000000000_600') AND L5061.BGQ = CJCL.CREATEBGQ( :2 , 3) AND T101.BGQ = L5061.BGQ AND T101.DCDXXTM = L5061.DCDXXTM AND L5061.TJJG='000000000000' AND T101.TJJG='000000000000' /*20130308*/ AND T101.B191 IN (1, 2) GROUP BY T101.B191 ) DWGM11 ON DWGM11.B191 = DWGM.MLDM ) T11 WHERE T12.MLDM = T11.MLDM ORDER BY T12.MLDM

6zpwu3y1x9psp SELECT DWXTM, ZZJGDM, DWMC, DHHM, YDDH, EMAIL from cj_dx_dcdxzc t WHERE DWYHID=:1

7ys1f51rrpxrg SELECT CWID FROM CJCL.CJ_CW_CWSJ WHERE RWID = :1 AND BH = :2 AND BGQ = :3 AND DWXTM = :4 AND XMID = :5

84p0m46r1y8zq SELECT ZZID FROM CJCL.CJ_CJ_TBJD A, (SELECT MIN(QYCKJZSJ) AS QYCKJZSJ, JD.REPORTID, JD.DWXTM, JD.RWID FROM CJCL.CJ_CJ_TBJD JD WHERE CBJZSJ IS NOT NULL AND SYSDATE <=QYCKJZSJ AND DWXTM = :1 AND (XMID IS NULL OR XMID = '-999') GROUP BY JD.REPORTID, JD.DWXTM, JD.RWID) B, CJCL.CJ_BB_YHTBFW FW, CJCL.GH_BB_BBZC BB , CJCL.GH_CJ_RWZC RW WHERE (A.XMID IS NULL OR A.XMID = '-999') AND A.REPORTID=B.REPORTID AND A.DWXTM=B.DWXTM AND A.QYCKJZSJ=B.QYCKJZSJ AND A.RWID=B.RWID AND (BB.BBZTDM = '4' OR BB.BBZTDM = '5') AND BB.SSRW=RW.RWID AND RW.RWZT = '1' AND (BB.SFGLB!='1' OR BB.SFGLB IS NULL ) AND RW.RWID=FW.RWID AND A.REPORTID = FW.REPORTID AND A.REPORTID = BB.REPORTID AND FW.DWXTM = A.DWXTM AND FW.YHID=:2 ORDER BY A.BH

85t04831hywhk DELETE FROM CJCL.CJ_CW_CWDW WHERE CWID = :B1

8g4p2van6nvnd SELECT /*+RULE */ v1.sid SID, count(v2.owner) ACCOBJECTS FROM v$session v1, v$access v2 WHERE v1.sid = v2.sid(+) AND v2.owner(+) NOT IN ('SYS', 'SYSTEM', 'PUBLIC') GROUP BY v1.sid

8kz5d4zkmhqpz SELECT /*��λ��ģ*/ T12.MLMC as MLMC, T12.MLDM as MLDM, T12.TG1202 as TG1202 , T11.TG1102 as TG1102 , CasE WHEN T11.TG1102 = 0 THEN 0 ELSE T12.TG1202/T11.TG1102*100 -100 END as TG02 , T12.TG1203 as TG1203 , T11.TG1103 as TG1103 , CasE WHEN T11.TG1103 = 0 THEN 0 ELSE T12.TG1203/T11.TG1103*100 -100 END as TG03 , T12.TG1204 as TG1204 , T11.TG1104 as TG1104 , CasE WHEN T11.TG1104 = 0 THEN 0 ELSE T12.TG1204/T11.TG1104*100 -100 END as TG04 , T12.TG1205 as TG1205 , T11.TG1105 as TG1105 , CasE WHEN T11.TG1105 = 0 THEN 0 ELSE T12.TG1205/T11.TG1105*100 -100 END as TG05 , T12.TG1206 as TG1206 , T11.TG1106 as TG1106 , CasE WHEN T11.TG1106 = 0 THEN 0 ELSE T12.TG1206/T11.TG1106*100 -100 END as TG06 , T12.TG1207 as TG1207 , T11.TG1107 as TG1107 , CasE WHEN T11.TG1107 = 0 THEN 0 ELSE T12.TG1207/T11.TG1107*100 -100 END as TG07 , T12.TG1208 as TG1208 , T11.TG1108 as TG1108 , CasE WHEN T11.TG1108 = 0 THEN 0 ELSE T12.TG1208/T11.TG1108*100 -100 END as TG08 , T12.TG1209 as TG1209 , T11.TG1109 as TG1109 , CasE WHEN T11.TG1109 = 0 THEN 0 ELSE T12.TG1209/T11.TG1109*100 -100 END as TG09 , T12.TG1210 as TG1210 , T11.TG1110 as TG1110 , CasE WHEN T11.TG1110 = 0 THEN 0 ELSE T12.TG1210/T11.TG1110*100 -100 END as TG10 , T12.TG1211 as TG1211 , T11.TG1111 as TG1111 , CasE WHEN T11.TG1111 = 0 THEN 0 ELSE T12.TG1211/T11.TG1111*100 -100 END as TG11 , T12.TG1212 as TG1212 , T11.TG1112 as TG1112 , CasE WHEN T11.TG1112 = 0 THEN 0 ELSE T12.TG1212/T11.TG1112*100 - 100 END as TG12 , T12.TG1213 as TG1213 , T11.TG1113 as TG1113 , CasE WHEN T11.TG1113 = 0 THEN 0 ELSE T12.TG1213/T11.TG1113*100 -100 END as TG13 , T12.TG1214 as TG1214 , T11.TG1114 as TG1114 , CasE WHEN T11.TG1114 = 0 THEN 0 ELSE T12.TG1214/T11.TG1114*100 -100 END as TG14 , T12.TG1215 as TG1215 , T11.TG1115 as TG1115 , CasE WHEN T11.TG1115 = 0 THEN 0 ELSE T12.TG1215/T11.TG1115*100 -100 END as TG15 , T12.TG1216 as TG1216 , T11.TG1116 as TG1116 , CasE WHEN T11.TG1116 = 0 THEN 0 ELSE T12.TG1216/T11.TG1116*100 -100 END as TG16 , T12.TG1217 as TG1217 , T11.TG1117 as TG1117 , CasE WHEN T11.TG1117 = 0 THEN 0 ELSE T12.TG1217/T11.TG1117*100 -100 END as TG17 , T12.TG1218 as TG1218 , T11.TG1118 as TG1118 , CasE WHEN T11.TG1118 = 0 THEN 0 ELSE T12.TG1218/T11.TG1118*100 -100 END as TG18 , T12.TG1219 as TG1219 , T11.TG1119 as TG1119 , CasE WHEN T11.TG1119 = 0 THEN 0 ELSE T12.TG1219/T11.TG1119*100 -100 END as TG19 , T12.TG1220 as TG1220 , T11.TG1120 as TG1120 , CasE WHEN T11.TG1120 = 0 THEN 0 ELSE T12.TG1220/T11.TG1120*100 -100 END as TG20 , T12.TG1221 as TG1221 , T11.TG1121 as TG1121 , CasE WHEN T11.TG1121 = 0 THEN 0 ELSE T12.TG1221/T11.TG1121*100 -100 END as TG21 , T12.TG1222 as TG1222 , T11.TG1122 as TG1122 , CasE WHEN T11.TG1122 = 0 THEN 0 ELSE T12.TG1222/T11.TG1122*100 -100 END as TG22 FROM ( /*��λ��ģ*/ SELECT * FROM ( SELECT FZ0002DM as MLDM, FZ0002MC as MLMC FROM CJCL.GY_ML_FZ0002 ML WHERE BB = '201107010' ) DWGM LEFT JOIN ( /*2012��ͳ��*/ SELECT T101.B191 as B191 , SUM(NVL(L506.C3 , 0)) as TG1202, SUM(NVL(L506.C4 , 0)) as TG1203, SUM(NVL(L506.C5 , 0)) as TG1204, SUM(NVL(L506.C6 , 0)) as TG1205, SUM(NVL(L506.C7 , 0)) as TG1206, SUM(NVL(L506.C8 , 0)) as TG1207, SUM(NVL(L506.C9 , 0))/10 as TG1208, SUM(NVL(L506.C10, 0))/10 as TG1209, SUM(NVL(L506.C11, 0))/10 as TG1210, SUM(NVL(L506.C12, 0))/10 as TG1211, SUM(NVL(L506.C13, 0))/10 as TG1212, SUM(NVL(L506.C14, 0))/10 as TG1213, SUM(NVL(L506.C15, 0))/10 as TG1214, SUM(NVL(L506.C16, 0))/10 as TG1215, SUM(NVL(L506.C17, 0))/10 as TG1216, SUM(NVL(L506.C18, 0))/10 as TG1217, SUM(NVL(L506.C19, 0))/10 as TG1218, SUM(NVL(L506.C20, 0))/10 as TG1219, SUM(NVL(L506.C21, 0))/10 as TG1220, SUM(NVL(L506.C22, 0)) as TG1221, SUM(NVL(L506.C23, 0))/10 as TG1222 FROM C2013_000000_107_2_1 L506, CJCL.C2013_000000_101_1_1 T101 WHERE L506.DCDXXTM IN (SELECT DWXTM FROM CJCL.GH_DX_DCDXRW dcdxrw WHERE TJJGDM IN ('000000000000') AND dcdxrw.TJZYDM IN (SELECT TJZYDM FROM AQDB.ZK_JL_YH_TJZY WHERE YHID = 'zdsj') AND dcdxrw.RWID = '000000000000_600') AND L506.BGQ = :1 AND T101.BGQ = L506.BGQ AND T101.DCDXXTM = L506.DCDXXTM AND L506.TJJG='000000000000' AND T101.TJJG='000000000000' GROUP BY T101.B191 ) DWGM12 ON DWGM12.B191 = DWGM.MLDM ) T12 , ( /*��λ��ģ*/ SELECT * FROM ( SELECT FZ0002DM as MLDM, FZ0002MC as MLMC FROM CJCL.GY_ML_FZ0002 ML WHERE BB = '201107010' ) DWGM LEFT JOIN ( /*2011��ͳ��*/ SELECT T101.B191 as B 191, SUM(NVL(L5061.C3 , 0)) as TG1102, SUM(NVL(L5061.C4 , 0)) as TG1103, SUM(NVL(L5061.C5 , 0)) as TG1104, SUM(NVL(L5061.C6 , 0)) as TG1105, SUM(NVL(L5061.C7 , 0)) as TG1106, SUM(NVL(L5061.C8 , 0)) as TG1107, SUM(NVL(L5061.C9 , 0))/10 as TG1108, SUM(NVL(L5061.C10, 0))/10 as TG1109, SUM(NVL(L5061.C11, 0))/10 as TG1110, SUM(NVL(L5061.C12, 0))/10 as TG1111, SUM(NVL(L5061.C13, 0))/10 as TG1112, SUM(NVL(L5061.C14, 0))/10 as TG1113, SUM(NVL(L5061.C15, 0))/10 as TG1114, SUM(NVL(L5061.C16, 0))/10 as TG1115, SUM(NVL(L5061.C17, 0))/10 as TG1116, SUM(NVL(L5061.C18, 0))/10 as TG1117, SUM(NVL(L5061.C19, 0))/10 as TG1118, SUM(NVL(L5061.C20, 0))/10 as TG1119, SUM(NVL(L5061.C21, 0))/10 as TG1120, SUM(NVL(L5061.C22, 0)) as TG1121, SUM(NVL(L5061.C23, 0))/10 as TG1122 FROM C2013_000000_107_2_1 L5061, CJCL.C2013_000000_101_1_1 T101 WHERE L5061.DCDXXTM IN (SELECT DWXTM FROM CJCL.GH_DX_DCDXRW dcdxrw WHERE TJJGDM IN ('000000000000') AND dcdxrw.TJZYDM IN (SELECT TJZYDM FROM AQDB.ZK_JL_YH_TJZY WHERE YHID = 'zdsj') AND dcdxrw.RWID = '000000000000_600') AND L5061.BGQ = CJCL.CREATEBGQ( :2 , 3) AND T101.BGQ = L5061.BGQ AND T101.DCDXXTM = L5061.DCDXXTM AND L5061.TJJG='000000000000' AND T101.TJJG='000000000000' GROUP BY T101.B191 ) DWGM11 ON DWGM11.B191 = DWGM.MLDM ) T11 WHERE T12.MLDM = T11.MLDM ORDER BY T12.MLDM

8qpwtrm143jkp SELECT /*+ USE_HASH(TBJD, GZ)*/TBJD.ZZJGDM, TBJD.DWMC, TBJD.XMID, TBJD.XMMC, CWSJ.GZCWXX, CWSJ.CWSM, substr(CWSJ.GZID, LENGTH(CWSJ.GZID)-6+1) AS SUBSORT, QZX.SHCWFLFH, TBJD.GLJG, TBJD.TJJGJBDM FROM CJCL.CJ_CJ_TBJD TBJD , CJCL.CJ_CW_CWSJ CWSJ, CJCL.CJ_ML_SHCWFL QZX, CJCL.GH_GZ_GZ GZ WHERE TBJD.BGQ = '201301SA' AND TBJD.BH = 'F203' AND TBJD.RWID = '000000000000_601' AND CWSJ.RWID = '000000000000_601' AND CWSJ.BH = 'F203' AND CWSJ.BGQ = '201301SA' AND CWSJ.DWXTM = TBJD.DWXTM AND CWSJ.XMID = TBJD.XMID AND CWSJ.QZXDM = QZX.SHCWFLDM AND CWSJ.GZID = GZ.GZID AND GZ.REPORTID = '95FF09450' AND TBJD.GLJG LIKE '12%' AND TBJD.SB_TJJGJBDM <= '02' AND TBJD.SJZTBM = '4' AND GZ.GLJG IN('000000000000', '120000000000') ORDER BY SUBSORT, TBJD.ZZJGDM

95uzxsm5j9r4j BEGIN "TISETUSETRIGER"('FALSE'); END;

9tgj4g8y4rwy8 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

a09y5t50r2z8c select dwxtm, zzjgdm, dwmc, clientip from ( select bb.dwxtm, bb.zzjgdm, bb.dwmc, clientip, rownum as rows_1 from (select distinct tbjd.dwxtm, tbjd.zzjgdm, tbjd.dwmc from cjcl.CJ_CJ_TBJD tbjd, cjcl.GH_DX_DCDXRW dcdxrw where tbjd.dwxtm = dcdxrw.dwxtm and tbjd.rwid=dcdxrw.rwid and tbjd.rwid =:1 and tbjd.bh = '201-1' and tbjd.bgq = '201302MM' AND TBJD.TJZYDM IN (SELECT TJZY.TJZYDM FROM AQDB.ZK_JL_YH_TJZY TJZY WHERE TJZY.YHID='xdtfwy120113') and dcdxrw.ZGTJJG='120113111000' and rownum <= 500) bb LEFT JOIN CJCL.CJ_CJ_TBJD tt ON bb.dwxtm=tt.dwxtm AND bb.dwmc=tt.dwmc AND bb.zzjgdm=tt.zzjgdm AND tt.bgq='201302MM' AND tt.bh='201-1' AND TT.RWID='000000000000_601') cc

aamqzv0c9n63a SELECT TS.NAME UTSNAME, TS.BLOCKSIZE * TS.DFLINIT INITEXTS, TS.BLOCKSIZE * TS.DFLINCR NEXTEXTS, TS.DFLMINEXT TSMINEXTS, TS.DFLMAXEXT TSMEXTS, TS.DFLEXTPCT TSPEXSIZI, DECODE(TS.ONLINE$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') TSSTAUS, TS.NAME MAXEXTSP, NVL(SUM(SEG.EXTENTS), 0) TSNEXTS, NVL(ROUND(SUM(SEG.EXTENTS) / DECODE(TS.DFLMAXEXT, 0, 1, TS.DFLMAXEXT) * 10000), 0) MAXEXTTS FROM SYS.TS$ TS, (SELECT * FROM SYS.DBA_SEGMENTS WHERE SEGMENT_NAME NOT LIKE 'BIN$%') SEG WHERE TS.NAME = SEG.TABLESPACE_NAME(+) GROUP BY TS.NAME, TS.BLOCKSIZE, TS.DFLMINEXT, TS.DFLMAXEXT, TS.DFLEXTPCT, TS.ONLINE$, TS.DFLINIT, TS.DFLINCR ORDER BY 1

b0mjdyk04c7hs SELECT 0 AS DM, T12.TG1202 AS TG1202 , T11.TG1102 AS TG1102 , CASE WHEN T11.TG1102 = 0 THEN 0 ELSE T12.TG1202/T11.TG1102*100 -100 END AS TG02 , T12.TG1203 AS TG1203 , T11.TG1103 AS TG1103 , CASE WHEN T11.TG1103 = 0 THEN 0 ELSE T12.TG1203/T11.TG1103*100 -100 END AS TG03 , T12.TG1204 AS TG1204 , T11.TG1104 AS TG1104 , CASE WHEN T11.TG1104 = 0 THEN 0 ELSE T12.TG1204/T11.TG1104*100 -100 END AS TG04 , T12.TG1205 AS TG1205 , T11.TG1105 AS TG1105 , CASE WHEN T11.TG1105 = 0 THEN 0 ELSE T12.TG1205/T11.TG1105*100 -100 END AS TG05 , T12.TG1206 AS TG1206 , T11.TG1106 AS TG1106 , CASE WHEN T11.TG1106 = 0 THEN 0 ELSE T12.TG1206/T11.TG1106*100 -100 END AS TG06 , T12.TG1207 AS TG1207 , T11.TG1107 AS TG1107 , CASE WHEN T11.TG1107 = 0 THEN 0 ELSE T12.TG1207/T11.TG1107*100 -100 END AS TG07 , T12.TG1208 AS TG1208 , T11.TG1108 AS TG1108 , CASE WHEN T11.TG1108 = 0 THEN 0 ELSE T12.TG1208/T11.TG1108*100 -100 END AS TG08 , T12.TG1209 AS TG1209 , T11.TG1109 AS TG1109 , CASE WHEN T11.TG1109 = 0 THEN 0 ELSE T12.TG1209/T11.TG1109*100 -100 END AS TG09 , T12.TG1210 AS TG1210 , T11.TG1110 AS TG1110 , CASE WHEN T11.TG1110 = 0 THEN 0 ELSE T12.TG1210/T11.TG1110*100 -100 END AS TG10 , T12.TG1211 AS TG1211 , T11.TG1111 AS TG1111 , CASE WHEN T11.TG1111 = 0 THEN 0 ELSE T12.TG1211/T11.TG1111*100 -100 END AS TG11 , T12.TG1212 AS TG1212 , T11.TG1112 AS TG1112 , CASE WHEN T11.TG1112 = 0 THEN 0 ELSE T12.TG1212/T11.TG1112*100 -100 END AS TG12 , T12.TG1213 AS TG12 13 , T11.TG1113 AS TG1113 , CASE WHEN T11.TG1113 = 0 THEN 0 ELSE T12.TG1213/T11.TG1113*100 -100 END AS TG13 , T12.TG1214 AS TG1214 , T11.TG1114 AS TG1114 , CASE WHEN T11.TG1114 = 0 THEN 0 ELSE T12.TG1214/T11.TG1114*100 -100 END AS TG14 , T12.TG1215 AS TG1215 , T11.TG1115 AS TG1115 , CASE WHEN T11.TG1115 = 0 THEN 0 ELSE T12.TG1215/T11.TG1115*100 -100 END AS TG15 , T12.TG1216 AS TG1216 , T11.TG1116 AS TG1116 , CASE WHEN T11.TG1116 = 0 THEN 0 ELSE T12.TG1216/T11.TG1116*100 -100 END AS TG16 , T12.TG1217 AS TG1217 , T11.TG1117 AS TG1117 , CASE WHEN T11.TG1117 = 0 THEN 0 ELSE T12.TG1217/T11.TG1117*100 -100 END AS TG17 , T12.TG1218 AS TG1218 , T11.TG1118 AS TG1118 , CASE WHEN T11.TG1118 = 0 THEN 0 ELSE T12.TG1218/T11.TG1118*100 -100 END AS TG18 , T12.TG1219 AS TG1219 , T11.TG1119 AS TG1119 , CASE WHEN T11.TG1119 = 0 THEN 0 ELSE T12.TG1219/T11.TG1119*100 -100 END AS TG19 , T12.TG1220 AS TG1220 , T11.TG1120 AS TG1120 , CASE WHEN T11.TG1120 = 0 THEN 0 ELSE T12.TG1220/T11.TG1120*100 -100 END AS TG20 , T12.TG1221 AS TG1221 , T11.TG1121 AS TG1121 , CASE WHEN T11.TG1121 = 0 THEN 0 ELSE T12.TG1221/T11.TG1121*100 -100 END AS TG21 , T12.TG1222 AS TG1222 , T11.TG1122 AS TG1122 , CASE WHEN T11.TG1122 = 0 THEN 0 ELSE T12.TG1222/T11.TG1122*100 -100 END AS TG22 FROM ( /*2012��ͳ��*/ SELECT SUM(NVL(L506.C3 , 0)) as TG1202, SUM(NVL(L506.C4 , 0)) as TG1203, SUM(NVL(L506.C5 , 0)) as TG1204, SUM(NVL(L506.C6 , 0)) as TG1205, SUM(NVL(L506.C7 , 0 )) as TG1206, SUM(NVL(L506.C8 , 0)) as TG1207, SUM(NVL(L506.C9 , 0))/10 as TG1208, SUM(NVL(L506.C10, 0))/10 as TG1209, SUM(NVL(L506.C11, 0))/10 as TG1210, SUM(NVL(L506.C12, 0))/10 as TG1211, SUM(NVL(L506.C13, 0))/10 as TG1212, SUM(NVL(L506.C14, 0))/10 as TG1213, SUM(NVL(L506.C15, 0))/10 as TG1214, SUM(NVL(L506.C16, 0))/10 as TG1215, SUM(NVL(L506.C17, 0))/10 as TG1216, SUM(NVL(L506.C18, 0))/10 as TG1217, SUM(NVL(L506.C19, 0))/10 as TG1218, SUM(NVL(L506.C20, 0))/10 as TG1219, SUM(NVL(L506.C21, 0))/10 as TG1220, SUM(NVL(L506.C22, 0)) as TG1221, SUM(NVL(L506.C23, 0))/10 as TG1222 FROM C2013_000000_107_2_1 L506 WHERE L506.DCDXXTM IN (SELECT DWXTM FROM CJCL.GH_DX_DCDXRW dcdxrw WHERE TJJGDM IN ('000000000000') AND dcdxrw.TJZYDM IN (SELECT TJZYDM FROM AQDB.ZK_JL_YH_TJZY WHERE YHID = 'zdsj') AND dcdxrw.RWID = '000000000000_600') AND L506.BGQ = :1 AND L506.TJJG='000000000000' ) T12 , ( /*2011��ͳ��*/ SELECT SUM(NVL(L5061.C3 , 0)) as TG1102, SUM(NVL(L5061.C4 , 0)) as TG1103, SUM(NVL(L5061.C5 , 0)) as TG1104, SUM(NVL(L5061.C6 , 0)) as TG1105, SUM(NVL(L5061.C7 , 0)) as TG1106, SUM(NVL(L5061.C8 , 0)) as TG1107, SUM(NVL(L5061.C9 , 0))/10 as TG1108, SUM(NVL(L5061.C10, 0))/10 as TG1109, SUM(NVL(L5061.C11, 0))/10 as TG1110, SUM(NVL(L5061.C12, 0))/10 as TG1111, SUM(NVL(L5061.C13, 0))/10 as TG1112, SUM(NVL(L5061.C14, 0))/10 as TG1113, SUM(NVL(L5061.C15, 0))/10 as TG1114, SUM(NVL(L5061.C16, 0))/10 as TG1115, SUM(NVL(L506 1.C17, 0))/10 as TG1116, SUM(NVL(L5061.C18, 0))/10 as TG1117, SUM(NVL(L5061.C19, 0))/10 as TG1118, SUM(NVL(L5061.C20, 0))/10 as TG1119, SUM(NVL(L5061.C21, 0))/10 as TG1120, SUM(NVL(L5061.C22, 0)) as TG1121, SUM(NVL(L5061.C23, 0))/10 as TG1122 FROM C2013_000000_107_2_1 L5061 WHERE L5061.DCDXXTM IN (SELECT DWXTM FROM CJCL.GH_DX_DCDXRW dcdxrw WHERE TJJGDM IN ('000000000000') AND dcdxrw.TJZYDM IN (SELECT TJZYDM FROM AQDB.ZK_JL_YH_TJZY WHERE YHID = 'zdsj') AND dcdxrw.RWID = '000000000000_600') AND L5061.BGQ = CJCL.CREATEBGQ( :2 , 3) AND L5061.TJJG='000000000000' ) T11

bp13rxpdavu5g SELECT ml.FZ0043DM as CODE, ml.FZ0043MC as ZL, ml.CJDM as CJDM, DWGS as DWGS /*��λ��*/ , t1.C211_1 as C211_1 /*��۾�1-��*/ , t1.C211_2 as C211_2 /*��۾��ͬ��*/ , t1.C310_1 as C310_1 /*��Ӫҵ��˰�𼰸��1-��*/ , t1.C310_2 as C310_2 /*��Ӫҵ��˰�𼰸��ͬ��*/ , t1.C314_1 as C314_1 /*��е�˰��1-��*/ , t1.C314_2 as C314_2 /*��е�˰��ͬ��*/ , t1.C323_1 as C323_1 /*Ӫҵ��1-��*/ , t1.C323_2 as C323_2 /*Ӫҵ��ͬ��*/ , t1.C401_1 as C401_1 /*Ӧ��ְ��н��(��ۼƷ��)1-��*/ , t1.C401_2 as C401_2 /*Ӧ��ְ��н��(��ۼƷ��)��ͬ��*/ , t1.C402_1 as C402_1 /*Ӧ��ֵ˰1-��*/ , t1.C402_2 as C402_2 /*Ӧ��ֵ˰��ͬ��*/ FROM ( SELECT /*+use_hash(B, T)*/ SUBSTR(ml.CJDM, 1, 1)||'0000' as CJDM, COUNT(distinct t.ZZJGDM) as DWGS , SUM(t.C211_1) as C211_1, SUM(t.C211_2) as C211_2, SUM(t.C310_1) as C310_1, SUM(t.C310_2) as C310_2, SUM(t.C314_1) as C314_1, SUM(t.C314_2) as C314_2, SUM(t.C323_1) as C323_1, SUM(t.C323_2) as C323_2, SUM(t.C401_1) as C401_1, SUM(t.C401_2) as C401_2, SUM(t.C402_1) as C402_1, SUM(t.C402_2) as C402_2 FROM CJCL.C2013_000000_F203_1 t JOIN CJCL.C2013_000000_201_1_1 b ON t.DCDXXTM = b.DCDXXTM AND B.TJJGJB<='04' AND CJCL.CREATEMMBGQ(t.BGQ, '1') = b.BGQ JOIN CJCL.GY_ML_FZ0043 ml ON b.B103B = ml.FZ0043DM WHERE t.BGQ = :1 AND T.TJJGJB<='04' AND B.DCDXXTM IN (SELECT * FROM ZDYHZ_jt120114_1303201001052) AND ml.BB = '201111010' GROUP BY SUBSTR(ml.CJDM, 1, 1) ) t1 JOIN CJCL.GY_ML_FZ0043 ml on t1.CJDM = ml.CJDM WHERE ml.BB = '201111010' AND ml.CJDM LIKE '_0000' ORDER BY CJDM

bs6ja4ccvvjmk SELECT DISTINCT AQDB.ZK_JL_GNQD.* FROM AQDB.ZK_JL_GNQD WHERE JDID IN (SELECT JDID FROM AQDB.ZK_JL_JSGNQXDZ WHERE JSID IN (SELECT JSID FROM AQDB.ZK_JL_YHJS WHERE YHID=:1))

bunvx480ynf57 SELECT 1 FROM DUAL

c60h9paz2fkp6 DELETE FROM CJCL.CJ_SJTB_JL WHERE ZZJGDM = :1 AND XMID = :2 AND BH = :3 AND BGQ = :4

cy4j4q092hxqr SELECT "ZZID" FROM "CJ_CJ_TBJD" WHERE "BH" = :1 AND "BGQ" = :2 AND "XMID" = :3

d9w357uw5y7wp INSERT INTO CJCL.CJ_SJTB_JL (ZZID, ZZJGDM, XMID, REPORTID, BH, BGQ, FSF, JSF, SFCG, CWXX, BCSJ) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)

dryt5ugs0j5hf select count(distinct tbjd.dwxtm) ROWCOUNTS from cjcl.CJ_CJ_TBJD tbjd, cjcl.GH_DX_DCDXRW dcdxrw where tbjd.dwxtm = dcdxrw.dwxtm and tbjd.rwid=dcdxrw.rwid and tbjd.rwid =:1 and tbjd.bh = '201-1' and tbjd.bgq = '201302MM' AND TBJD.TJZYDM IN (SELECT TJZY.TJZYDM FROM AQDB.ZK_JL_YH_TJZY TJZY WHERE TJZY.YHID='xdtfwy120113') and dcdxrw.ZGTJJG='120113111000'

g895wjrhjfun3 UPDATE "CJ_CJ_TBJD" SET "SJZTBM" = :1 , "CLIENTIP" = :2 , "SJDDFSDM" = :3 WHERE ( ( "BH" = :4 ) ) AND ( ( "BGQ" = :5 ) ) AND ( ( "SJZTBM" = :6 ) ) AND ( ( "DWXTM" = :7 ) )

Back to Supplemental Information
Back to Top

End of Report