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
3015453842	SXGJJ	YES	8192	17097	17098	2	2	2	2	22.10	122.12

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	sxgjj1	sxgjj750	05-Jul-13 18:45	19-Sep-14 09:00	19-Sep-14 10:00	11.2.0.3.0	59.13	10.48	10,575.24	0.18	AIX-Based Systems (64-bit)
2	sxgjj2	sxgjj550	05-Jul-13 17:51	19-Sep-14 07:57	19-Sep-14 08:57	11.2.0.3.0	59.12	11.63	10,575.09	0.20	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		14,752	5,696	8,640	32	224	64	4,928	27.05
2		14,752	5,696	8,768	32	128	32	4,928	27.05
Avg		14,752	5,696	8,704	32	176	48	4,928	27.05
Min		14,752	5,696	8,640	32	128	32	4,928	27.05
Max		14,752	5,696	8,768	32	224	64	4,928	27.05

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	8	1.22	1.22	1.44	0.94	0.49	0.13	98.56	1,629.20	111,894.80	113,524.00	31,616.00
2	16	8	2.08	1.66	4.24	2.42	1.82	0.12	95.76	2,409.23	54,350.27	56,759.50	31,616.00
Sum										4,038.43	166,245.07	170,283.50

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	628.74	358.41	478.52	163.59	160.66	7.24	82.00	55.15
2	697.55	648.80	604.35	83.63	81.39	2.10	112.16	121.90
Sum	1,326.29	1,007.21	1,082.87	247.22	242.05	9.34	194.16	177.05
Avg	663.15	503.61	541.43	123.61	121.03	4.67	97.08	88.53
Std	48.65	205.33	88.97	56.54	56.05	3.63	21.32	47.19

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	47.41	57.00	76.11	26.02	25.55	42.23	67.26
2	52.59	93.01	86.64	11.99	11.67	57.77	108.68
Avg	50.00	75.01	81.37	19.00	18.61	50.00	87.97

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
	5.08	0.04	0.25	0.00	0.29	0.10	0.06	0.07	1.33	75.94

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	41.75	0.34	2.38	0.03	1.60	0.78	0.12	0.77	10.58	358.41	628.74
2	25.58	0.13	0.95	0.01	2.24	0.53	0.63	0.10	7.13	648.80	697.55
Sum	67.33	0.47	3.33	0.04	3.84	1.31	0.75	0.87	17.70	1,007.21	1,326.29
Avg	33.66	0.23	1.66	0.02	1.92	0.66	0.38	0.43	8.85	503.61	663.15
Std	11.44	0.15	1.01	0.01	0.45	0.17	0.36	0.47	2.44	205.33	48.65

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	Commit	Network	Concurcy	Config	Cluster	DB CPU	% Total DB time
1	6.64	0.05	0.38	0.25	0.12	0.02	0.12	1.68	57.00	47.41
2	3.67	0.02	0.14	0.32	0.08	0.09	0.01	1.02	93.01	52.59
Avg	5.15	0.04	0.26	0.29	0.10	0.05	0.07	1.35	75.01

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			1,007.21		75.94					2
*	User I/O	db file sequential read	19,777	0.00	61.67	3.12	4.65	3.04	2.73	3.35	0.44	2
*	Concurrency	os thread startup	190	0.00	14.19	74.66	1.07	85.58	64.83	106.32	29.34	2
*	System I/O	log file parallel write	20,642	0.00	10.70	0.52	0.81	0.52	0.50	0.54	0.03	2
*	Cluster	gc current block 2-way	21,200	0.00	10.22	0.48	0.77	0.45	0.36	0.54	0.13	2
*	System I/O	control file sequential read	29,431	0.00	5.51	0.19	0.42	0.19	0.15	0.23	0.06	2
*	User I/O	direct path read	1,956	0.00	4.60	2.35	0.35	2.35	2.35	2.35		2
*	Other	reliable message	2,688	0.11	4.35	1.62	0.33	5.73	1.43	10.02	6.07	2
*	Commit	log file sync	3,595	0.00	3.86	1.07	0.29	1.08	1.06	1.10	0.03	2
*	Cluster	gc cr multi block request	4,256	0.00	3.72	0.87	0.28	0.96	0.84	1.08	0.17	2
1		DB CPU			358.41		57.00
1	User I/O	db file sequential read	12,416	0.00	41.60	3.35	6.62
1	Concurrency	os thread startup	145	0.00	9.40	64.83	1.50
1	Cluster	gc current block 2-way	14,751	0.00	7.90	0.54	1.26
1	System I/O	log file parallel write	11,246	0.00	5.61	0.50	0.89
1	Other	reliable message	2,631	0.11	3.78	1.43	0.60
1	System I/O	control file sequential read	15,962	0.00	2.38	0.15	0.38
1	Commit	log file sync	1,462	0.00	1.60	1.10	0.25
1	Cluster	gc cr block 2-way	2,406	0.00	1.27	0.53	0.20
1	Other	ASM file metadata operation	1,088	0.00	1.24	1.14	0.20
2		DB CPU			648.80		93.01
2	User I/O	db file sequential read	7,361	0.00	20.06	2.73	2.88
2	System I/O	log file parallel write	9,396	0.00	5.09	0.54	0.73
2	Concurrency	os thread startup	45	0.00	4.78	106.32	0.69
2	User I/O	direct path read	1,956	0.00	4.60	2.35	0.66
2	Other	enq: WF - contention	22	0.00	3.67	166.90	0.53
2	System I/O	control file sequential read	13,469	0.00	3.13	0.23	0.45
2	Cluster	gc cr multi block request	3,710	0.00	3.13	0.84	0.45
2	Cluster	gc current block 2-way	6,449	0.00	2.31	0.36	0.33
2	Commit	log file sync	2,133	0.00	2.26	1.06	0.32

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			1,007.21		75.94					2
*	User I/O	db file sequential read	19,200	0.00	58.90	3.07	4.44	2.98	2.65	3.31	0.46	2
*	Cluster	gc current block 2-way	19,630	0.00	9.50	0.48	0.72	0.45	0.35	0.54	0.13	2
*	User I/O	direct path read	1,955	0.00	4.59	2.35	0.66	2.35	2.35	2.35		1
*	Commit	log file sync	3,593	0.00	3.84	1.07	0.29	1.07	1.05	1.10	0.03	2
*	Cluster	gc cr multi block request	4,246	0.00	3.71	0.87	0.28	0.96	0.84	1.08	0.17	2
*	User I/O	db file scattered read	2,259	0.00	1.82	0.81	0.14	0.90	0.76	1.04	0.20	2
*	Cluster	gc cr block 2-way	3,424	0.00	1.51	0.44	0.11	0.45	0.37	0.52	0.11	2
*	Cluster	gc cr grant 2-way	5,814	0.00	1.48	0.25	0.11	0.27	0.22	0.31	0.06	2
*	User I/O	db file parallel read	511	0.00	1.30	2.55	0.10	4.83	1.08	8.58	5.30	2
1		DB CPU			358.41		57.00
1	User I/O	db file sequential read	12,092	0.00	40.03	3.31	6.37
1	Cluster	gc current block 2-way	13,943	0.00	7.49	0.54	1.19
1	Commit	log file sync	1,461	0.00	1.60	1.10	0.25
1	Other	ASM file metadata operation	12	0.00	0.89	74.20	0.14
1	User I/O	db file parallel read	100	0.00	0.86	8.58	0.14
1	Cluster	gc cr block 2-way	1,587	0.00	0.83	0.52	0.13
1	Network	SQL*Net message from dblink	314	0.00	0.69	2.19	0.11
1	Cluster	gc cr grant 2-way	2,036	0.00	0.63	0.31	0.10
1	Cluster	gc cr multi block request	542	0.00	0.59	1.08	0.09
2		DB CPU			648.80		93.01
2	User I/O	db file sequential read	7,108	0.00	18.86	2.65	2.70
2	User I/O	direct path read	1,955	0.00	4.59	2.35	0.66
2	Cluster	gc cr multi block request	3,704	0.00	3.13	0.84	0.45
2	Commit	log file sync	2,132	0.00	2.24	1.05	0.32
2	Cluster	gc current block 2-way	5,687	0.00	2.01	0.35	0.29
2	User I/O	db file scattered read	1,898	0.00	1.44	0.76	0.21
2	Cluster	gc cr grant 2-way	3,778	0.00	0.84	0.22	0.12
2	Cluster	gc cr block 2-way	1,837	0.00	0.68	0.37	0.10
2	Configuration	undo segment extension	7	100.00	0.63	90.31	0.09

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)
*		background cpu time			177.05		91.19					2
*	Concurrency	os thread startup	190	0.00	14.19	74.66	7.31	85.58	64.83	106.32	29.34	2
*	System I/O	log file parallel write	20,642	0.00	10.70	0.52	5.51	0.52	0.50	0.54	0.03	2
*	System I/O	control file sequential read	25,975	0.00	5.05	0.19	2.60	0.19	0.16	0.23	0.06	2
*	Other	reliable message	327	0.92	3.89	11.90	2.00	11.96	11.88	12.04	0.11	2
*	Other	enq: WF - contention	33	0.00	3.68	111.39	1.89	83.64	0.37	166.90	117.75	2
*	User I/O	db file sequential read	573	0.00	2.74	4.79	1.41	4.78	4.73	4.83	0.07	2
*	System I/O	control file parallel write	7,403	0.00	2.72	0.37	1.40	0.37	0.32	0.41	0.06	2
*	Other	ges lms sync during dynamic remastering and reconfig	48	100.00	1.22	25.44	0.63	25.44	15.51	35.36	14.04	2
*	Other	CSS operation: data query	354	0.00	1.06	3.01	0.55	3.01	2.12	3.90	1.26	2
1		background cpu time			55.15		67.26
1	Concurrency	os thread startup	145	0.00	9.40	64.83	11.46
1	System I/O	log file parallel write	11,246	0.00	5.61	0.50	6.84
1	Other	reliable message	281	1.07	3.34	11.88	4.07
1	System I/O	control file sequential read	13,178	0.00	2.04	0.16	2.49
1	User I/O	db file sequential read	321	0.00	1.55	4.83	1.89
1	System I/O	control file parallel write	3,731	0.00	1.21	0.32	1.47
1	Cluster	gc cr block 2-way	821	0.00	0.44	0.53	0.53
1	System I/O	db file parallel write	1,882	0.00	0.43	0.23	0.52
1	Cluster	gc current block 2-way	803	0.00	0.41	0.51	0.50
2		background cpu time			121.90		108.68
2	System I/O	log file parallel write	9,396	0.00	5.09	0.54	4.54
2	Concurrency	os thread startup	45	0.00	4.78	106.32	4.27
2	Other	enq: WF - contention	22	0.00	3.67	166.90	3.27
2	System I/O	control file sequential read	12,797	0.00	3.00	0.23	2.68
2	System I/O	control file parallel write	3,672	0.00	1.51	0.41	1.35
2	User I/O	db file sequential read	252	0.00	1.19	4.73	1.06
2	Other	ges lms sync during dynamic remastering and reconfig	24	100.00	0.85	35.36	0.76
2	Other	CSS operation: data query	177	0.00	0.69	3.90	0.62
2	Other	reliable message	46	0.00	0.55	12.04	0.49

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	41,439,049	14,882	4,792	15,260	78,086	34,797	86,093	32,581	915	3,277
2	32,572,467	388,669	3,705	11,615	50,693	25,289	51,448	13,148	784	3,176
Sum	74,011,516	403,551	8,497	26,876	128,779	60,086	137,541	45,729	1,699	6,453
Avg	37,005,758	201,776	4,249	13,438	64,390	30,043	68,771	22,865	850	3,227
Std	6,269,620	264,307	769	2,577	19,370	6,723	24,498	13,741	93	71

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	11,681.12	4.20	1.35	4.30	22.01	9.81	24.27	9.18	0.26	0.92
2	9,181.83	109.56	1.04	3.27	14.29	7.13	14.50	3.71	0.22	0.90
Sum	20,862.95	113.76	2.40	7.58	36.30	16.94	38.77	12.89	0.48	1.82
Avg	10,431.47	56.88	1.20	3.79	18.15	8.47	19.39	6.45	0.24	0.91
Std	1,767.26	74.51	0.22	0.73	5.46	1.90	6.91	3.87	0.03	0.02

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	12,645.42	4.54	1.46	4.66	23.83	10.62	26.27	9.94	0.28
2	10,255.81	122.38	1.17	3.66	15.96	7.96	16.20	4.14	0.25
Avg	11,450.62	63.46	1.31	4.16	19.89	9.29	21.24	7.04	0.26

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	16,769	2,509	11,697	2,787	0	0	125,851	7,581	84,185	20,108	2,575	19,334	0	0
2	11,686	2,790	16,774	2,507	0	0	93,645	8,622	125,169	7,550	16,512	52,755	0	0
Sum	28,455	5,299	28,471	5,294	0	0	219,496	16,203	209,354	27,658	19,087	72,089	0	0
Avg	14,228	2,650	14,236	2,647	0	0	109,748	8,102	104,677	13,829	9,544	36,045	0	0
Std	3,594	199	3,590	198	0	0	22,773	736	28,980	8,880	9,855	23,632	0	0

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	4.73	0.71	3.30	0.79	0.00	0.00	35.48	2.14	23.73	5.67	0.73	5.45	0	0
2	3.29	0.79	4.73	0.71	0.00	0.00	26.40	2.43	35.28	2.13	4.65	14.87	0	0
Sum	8.02	1.49	8.03	1.49	0.00	0.00	61.87	4.57	59.01	7.80	5.38	20.32	0	0
Avg	4.01	0.75	4.01	0.75	0.00	0.00	30.94	2.28	29.51	3.90	2.69	10.16	0	0
Std	1.01	0.06	1.01	0.06	0.00	0.00	6.42	0.21	8.17	2.50	2.78	6.66	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	5.12	0.77	3.57	0.85	0.00	0.00	38.40	2.31	25.69	6.14	0.79	5.90	0.00	0.00
2	3.68	0.88	5.28	0.79	0.00	0.00	29.49	2.71	39.41	2.38	5.20	16.61	0.00	0.00
Avg	4.40	0.82	4.43	0.82	0.00	0.00	33.94	2.51	32.55	4.26	2.99	11.26	0.00	0.00

Back to Global Activity Load Profile
Back to Top

Global Cache and Enqueue Statistics Summary

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

Global Cache Efficiency Percentages

I#	Local %	Remote %	Disk %
	Buffer Access
1	99.92	0.05	0.04
2	99.81	0.04	0.15

Back to Global Cache and Enqueue Statistics Summary
Back to Top

Global Cache and Enqueue Workload Characteristics

I#	GE Get Time (ms)	Receive Time (ms)	Build Time (ms)	Send Time (ms)	Flush Time (ms)	Log Flush CR Srvd %	Receive Time (ms)	Pin Time (ms)	Send Time (ms)	Flush Time (ms)	Log Flush CU Srvd %
		CR Blocks					CU Blocks
1	0.02	0.45	0.00	0.00	1.54	0.47	0.72	0.00	0.00	3.33	0.28
2	0.14	0.32	0.00	0.00	1.25	0.64	0.43	0.00	0.00	1.38	0.17

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.28	0.28	2.02	0.01	0.01	5.19	38.94	55.87
2	0.08	0.25	6.74	0.03	0.07	21.60	69.00	9.40

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	1,797	985	1,797	0	21	2,772	1	9	0	0	1,310	86	0	13	0	0	0	1	0
2	1,291	2,128	1,291	0	276	2,498	0	9	912	0	921	95	0	16	0	0	0	19	0
Sum	3,088	3,113	3,088	0	297	5,270	1	18	912	0	2,231	181	0	29	0	0	0	20	0
Avg	1,544	1,557	1,544	0	149	2,635	1	9	456	0	1,116	91	0	15	0	0	0	10	0
Std	358	808	358	0	180	194	1	0	645	0	275	6	0	2	0	0	0	13	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	0	0.00	0.00	0.00	0.00	0.00	33	75.76	15.15	9.09	0.00	0.00	675	90.07	8.89	0.15	0.30	0.59
2	1	100.00	0.00	0.00	0.00	0.00	29	62.07	34.48	3.45	0.00	0.00	540	67.41	30.93	0.56	0.00	1.11
Sum	1						62						1,215
Avg	1						31						608
Std	1						3						95

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	1,291	98.06	1.24	0.70	16,137	99.26	0.21	0.53	1	0.53	2.71	0.55	1	0.73	2.26	2.16
1	2	others	940	99.68	0.00	0.32	616	100.00	0.00	0.00	1	0.55		0.40	1	0.50
1	2	undo header	276	100.00	0.00	0.00	8	100.00	0.00	0.00	0	0.39			0	0.41
2	1	data block	1,799	99.28	0.61	0.11	11,083	99.42	0.27	0.31	0	0.44	1.53	0.39	0	0.44	3.66	0.92
2	1	others	961	99.90	0.00	0.10	569	99.82	0.00	0.18	0	0.36		0.32	0	0.34		0.18
2	1	undo header	20	95.00	5.00	0.00	6	66.67	33.33	0.00	0	0.28	0.86		1	0.29	0.99

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		1,266	100.00	0.00	16,017	100.00	0.00	0.53	0.53		0.73	0.73
1	2	others	0		937	100.00	0.00	616	100.00	0.00	0.55	0.55		0.50	0.50
1	2	undo header	0		276	100.00	0.00	8	100.00	0.00	0.39	0.39		0.41	0.41
1	2	undo block	0		0			0
2	1	data block	0		1,786	100.00	0.00	11,019	100.00	0.00	0.44	0.44		0.44	0.44
2	1	others	0		960	100.00	0.00	568	100.00	0.00	0.36	0.36		0.34	0.34
2	1	undo header	0		19	100.00	0.00	4	100.00	0.00	0.28	0.28		0.29	0.29
2	1	undo block	0		0			0

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

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

Cluster Interconnect

I#	NAME	IP Address	Pub	IP Address
		Begin		End (if different from Begin)
1	en2	169.254.101.86	N
2	en2	169.254.93.15	N

Back to Interconnect Stats
Back to Top

Ping Statistics

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

Instance#		500 bytes				8 Kbytes
Src	Target	Ping Count	Ping Time(s)	Avg Time(ms)	Std Dev	Ping Count	Ping Time(s)	Avg Time(ms)	Std Dev
1	1	282	0.06	0.22	0.01	282	0.06	0.21	0.01
1	2	282	0.10	0.34	0.31	282	0.16	0.55	0.39
2	1	282	0.10	0.34	0.07	282	0.12	0.43	0.14
2	2	282	0.09	0.34	0.08	282	0.09	0.32	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	154.16	100.51	3.61	20.42	4.73	24.88	305.80	135.01	11.11	28.23	4.73	126.72
2	299.25	135.21	11.11	21.47	4.73	126.72	151.52	99.78	3.61	18.52	4.73	24.88
Sum	453.41	235.73	14.72	41.90	9.46	151.60	457.32	234.79	14.72	46.75	9.46	151.60
Avg	226.70	117.86	7.36	20.95	4.73	75.80	228.66	117.40	7.36	23.37	4.73	75.80
Std	102.59	24.54	5.30	0.74	0.00	72.01	109.09	24.91	5.30	6.87	0.00	72.01

Back to Interconnect Stats
Back to Top

Interconnect Client Statistics (per Second)

I#	Total	Cache	IPQ	DLM	PNG	Misc	Total	Cache	IPQ	DLM	PNG	Misc
	Sent (MB/s)						Received (MB/s)
1	0.04	0.03	0.00	0.01	0.00	0.01	0.09	0.04	0.00	0.01	0.00	0.04
2	0.08	0.04	0.00	0.01	0.00	0.04	0.04	0.03	0.00	0.01	0.00	0.01
Sum	0.13	0.07	0.00	0.01	0.00	0.04	0.13	0.07	0.00	0.01	0.00	0.04
Avg	0.06	0.03	0.00	0.01	0.00	0.02	0.06	0.03	0.00	0.01	0.00	0.02
Std	0.03	0.01	0.00	0.00	0.00	0.02	0.03	0.01	0.00	0.00	0.00	0.02

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

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

I#	NAME	IP Address	IP Mask	MBytes	Packets	Errors	Packets Dropped	Buffer Ovrrun	Carrier Lost	MBytes	Packets	Errors	Packets Dropped	Buffer Ovrrun	Frame Errors
	Interface			Sent						Received
1	en0	192.168.100.21	255.255.255.0	14.02	34,200	0	0	0	0	8.18	54,880	0	0	0	0
1	en0	192.168.100.21	255.255.255.0	14.02	34,200	0	0	0	0	8.18	54,880	0	0	0	0
1	en0	192.168.100.21	255.255.255.0	14.02	34,200	0	0	0	0	8.18	54,880	0	0	0	0
1	en0	192.168.100.30	255.255.255.0	14.02	34,200	0	0	0	0	8.18	54,880	0	0	0	0
1	en0	192.168.100.30	255.255.255.0	14.02	34,200	0	0	0	0	8.18	54,880	0	0	0	0
1	en0	192.168.100.30	255.255.255.0	14.02	34,200	0	0	0	0	8.18	54,880	0	0	0	0
1	en0	192.168.100.32	255.255.255.0	14.02	34,200	0	0	0	0	8.18	54,880	0	0	0	0
1	en0	192.168.100.32	255.255.255.0	14.02	34,200	0	0	0	0	8.18	54,880	0	0	0	0
1	en0	192.168.100.32	255.255.255.0	14.02	34,200	0	0	0	0	8.18	54,880	0	0	0	0
1	en2	11.11.11.1	255.255.255.0	282.29	446,084	0	0	0	0	515.59	591,404	0	0	0	0
1	en2	11.11.11.1	255.255.255.0	282.29	446,084	0	0	0	0	515.59	591,404	0	0	0	0
1	en2	169.254.101.86	255.255.0.0	282.29	446,084	0	0	0	0	515.59	591,404	0	0	0	0
1	en2	169.254.101.86	255.255.0.0	282.29	446,084	0	0	0	0	515.59	591,404	0	0	0	0
1	lo0	127.0.0.1	255.0.0.0	854.70	211,130	0	0	0	0	854.69	211,128	0	0	0	0
2	en0	192.168.100.29	255.255.255.0	13.43	21,119	0	0	0	0	5.92	34,102	0	0	0	0
2	en0	192.168.100.29	255.255.255.0	13.43	21,119	0	0	0	0	5.92	34,102	0	0	0	0
2	en0	192.168.100.33	255.255.255.0	13.43	21,119	0	0	0	0	5.92	34,102	0	0	0	0
2	en0	192.168.100.33	255.255.255.0	13.43	21,119	0	0	0	0	5.92	34,102	0	0	0	0
2	en2	11.11.11.2	255.255.255.0	513.38	579,415	0	0	0	0	272.12	438,178	0	0	0	0
2	en2	11.11.11.2	255.255.255.0	513.38	579,415	0	0	0	0	272.12	438,178	0	0	0	0
2	en2	169.254.93.15	255.255.0.0	513.38	579,415	0	0	0	0	272.12	438,178	0	0	0	0
2	en2	169.254.93.15	255.255.0.0	513.38	579,415	0	0	0	0	272.12	438,178	0	0	0	0
2	lo0	127.0.0.1	255.0.0.0	61.67	285,235	0	0	0	0	61.67	285,238	0	0	0	0
Sum				4,278.98	4,990,637	0	0	0	0	4,164.56	5,245,022	0	0	0	0
Avg				186.04	216,984	0	0	0	0	181.07	228,044	0	0	0	0
Std				244.37	232,985	0	0	0	0	246.84	226,498	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	192.168.100.21	255.255.255.0	0.00	10	0	0	0	0	0.00	15	0	0	0	0
1	en0	192.168.100.21	255.255.255.0	0.00	10	0	0	0	0	0.00	15	0	0	0	0
1	en0	192.168.100.21	255.255.255.0	0.00	10	0	0	0	0	0.00	15	0	0	0	0
1	en0	192.168.100.30	255.255.255.0	0.00	10	0	0	0	0	0.00	15	0	0	0	0
1	en0	192.168.100.30	255.255.255.0	0.00	10	0	0	0	0	0.00	15	0	0	0	0
1	en0	192.168.100.30	255.255.255.0	0.00	10	0	0	0	0	0.00	15	0	0	0	0
1	en0	192.168.100.32	255.255.255.0	0.00	10	0	0	0	0	0.00	15	0	0	0	0
1	en0	192.168.100.32	255.255.255.0	0.00	10	0	0	0	0	0.00	15	0	0	0	0
1	en0	192.168.100.32	255.255.255.0	0.00	10	0	0	0	0	0.00	15	0	0	0	0
1	en2	11.11.11.1	255.255.255.0	0.08	126	0	0	0	0	0.15	167	0	0	0	0
1	en2	11.11.11.1	255.255.255.0	0.08	126	0	0	0	0	0.15	167	0	0	0	0
1	en2	169.254.101.86	255.255.0.0	0.08	126	0	0	0	0	0.15	167	0	0	0	0
1	en2	169.254.101.86	255.255.0.0	0.08	126	0	0	0	0	0.15	167	0	0	0	0
1	lo0	127.0.0.1	255.0.0.0	0.24	60	0	0	0	0	0.24	60	0	0	0	0
2	en0	192.168.100.29	255.255.255.0	0.00	6	0	0	0	0	0.00	10	0	0	0	0
2	en0	192.168.100.29	255.255.255.0	0.00	6	0	0	0	0	0.00	10	0	0	0	0
2	en0	192.168.100.33	255.255.255.0	0.00	6	0	0	0	0	0.00	10	0	0	0	0
2	en0	192.168.100.33	255.255.255.0	0.00	6	0	0	0	0	0.00	10	0	0	0	0
2	en2	11.11.11.2	255.255.255.0	0.14	163	0	0	0	0	0.08	124	0	0	0	0
2	en2	11.11.11.2	255.255.255.0	0.14	163	0	0	0	0	0.08	124	0	0	0	0
2	en2	169.254.93.15	255.255.0.0	0.14	163	0	0	0	0	0.08	124	0	0	0	0
2	en2	169.254.93.15	255.255.0.0	0.14	163	0	0	0	0	0.08	124	0	0	0	0
2	lo0	127.0.0.1	255.0.0.0	0.02	80	0	0	0	0	0.02	80	0	0	0	0
Sum				1.21	1,407	0	0	0	0	1.17	1,479	0	0	0	0
Avg				0.05	61	0	0	0	0	0.05	64	0	0	0	0
Std				0.07	66	0	0	0	0	0.07	64	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	1	1.00	0.00	11,519.00	0.00	1.49	0.16	0.01	0.15	0.08	0.13	0.93	181	180
2	1	1.00	11,519.00	0.00	0.00	1.49	0.41	0.03	0.10	0.46	0.28	0.17	43	44
Avg	1	1.00	5,759.50	5,759.50	0.00	1.49	0.29	0.02	0.13	0.27	0.21	0.55	112	112
Max			11,519.00	11,519.00	0.00	1.49	0.41	0.03	0.15	0.46	0.28	0.93	181	180

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 68.6% of Total DB Time (s): 1,326
Captured PL/SQL account for 37.6% of Total DB Time (s): 1,326

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
gdranhw0kcrd8	389.80	314.22	0.01	27,625,490	0	605	0.91	605	0.64	0.52	0.00	45,661.97	0.00	1.00	0.00	29.39	31.20	0.00	37.33	0.00	4.63	0.44	BEGIN p_dbsx_cx(:1 , :2 ); END...
9g6pks8j8brdx	195.53	159.85	0.00	17,593,482	0	4,109	0.27	4,127	0.05	0.04	0.00	4,263.02	0.00	1.00	0.00	14.74	15.87	0.00	23.77	0.00	1.37	3.00	SELECT COUNT(*) FROM GD_DK_ZZ ...
9m94fyzc4sgdm	91.05	73.71	0.00	4,987,745	0	4,127	0.00	4,127	0.02	0.02	0.00	1,208.56	0.00	1.00	0.00	6.87	7.32	0.00	6.74	0.00	0.00	3.00	SELECT COUNT(*) FROM GD_TX_YHM...
cq6fuzzct18gg	73.10	57.76	0.00	3,234,850	0	4,123	0.18	4,127	0.02	0.01	0.00	783.83	0.00	1.00	0.00	5.51	5.74	0.00	4.37	0.00	0.94	3.00	SELECT COUNT(*) FROM GD_DK_TX_...
670das7q4yjyu	45.09	43.89	0.00	2,423,432	0	1,804	0.00	82	0.55	0.54	0.00	29,554.05	0.00	22.00	0.00	3.40	4.36	0.00	3.27	0.00	0.00	0.06	select * from (select rownum r...
bauk8nf4grax0	42.45	40.53	0.36	2,574,250	44	451	0.04	451	0.09	0.09	0.00	5,707.87	0.10	1.00	0.00	3.20	4.02	0.01	3.48	0.01	0.19	0.33	BEGIN p_jnml_clyx_add(:1, :2, ...
7vt1711b4uaf4	39.76	38.70	0.00	2,421,788	0	82	0.00	82	0.48	0.47	0.00	29,534.00	0.00	1.00	0.00	3.00	3.84	0.00	3.27	0.00	0.00	0.06	select count(*) cnt from (SELE...
5sn8fz80rvbjr	31.48	30.42	0.00	1,683,276	0	513	0.00	57	0.55	0.53	0.00	29,531.16	0.00	9.00	0.00	2.37	3.02	0.00	2.27	0.00	0.00	0.04	select * from (select rownum r...
3rchqnwp893f4	31.41	21.33	0.20	5,659,454	54	20	0.19	15	2.09	1.42	0.01	377,296.93	3.60	1.33	0.01	2.37	2.12	0.00	7.65	0.01	0.98	0.01	select * from (select rownum r...
6d9f498u2axhm	29.40	20.04	0.00	5,331,316	0	15	0.01	15	1.96	1.34	0.00	355,421.07	0.00	1.00	0.00	2.22	1.99	0.00	7.20	0.00	0.06	0.01	select count(*) cnt, sum(g202)...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time (Global)

Captured SQL account for 73.7% of Total CPU Time (s): 1,007
Captured PL/SQL account for 37.6% of Total CPU Time (s): 1,007

SQL Id	CPU (s)	Elapsed (s)	IOWait (s)	Gets	Reads	Rows	Cluster (s)	Execs	CPU (s)	Elapsed (s)	IOWait (s)	Gets	Reads	Rows	Cluster (s)	DB CPU	DB time	IO Wait	Gets	Reads	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
gdranhw0kcrd8	314.22	389.80	0.01	27,625,490	0	605	0.91	605	0.52	0.64	0.00	45,661.97	0.00	1.00	0.00	31.20	29.39	0.01	37.33	0.00	4.63	0.44	BEGIN p_dbsx_cx(:1 , :2 ); END...
9g6pks8j8brdx	159.85	195.53	0.00	17,593,482	0	4,109	0.27	4,127	0.04	0.05	0.00	4,263.02	0.00	1.00	0.00	15.87	14.74	0.00	23.77	0.00	1.37	3.00	SELECT COUNT(*) FROM GD_DK_ZZ ...
9m94fyzc4sgdm	73.71	91.05	0.00	4,987,745	0	4,127	0.00	4,127	0.02	0.02	0.00	1,208.56	0.00	1.00	0.00	7.32	6.87	0.00	6.74	0.00	0.00	3.00	SELECT COUNT(*) FROM GD_TX_YHM...
cq6fuzzct18gg	57.76	73.10	0.00	3,234,850	0	4,123	0.18	4,127	0.01	0.02	0.00	783.83	0.00	1.00	0.00	5.74	5.51	0.00	4.37	0.00	0.94	3.00	SELECT COUNT(*) FROM GD_DK_TX_...
670das7q4yjyu	43.89	45.09	0.00	2,423,432	0	1,804	0.00	82	0.54	0.55	0.00	29,554.05	0.00	22.00	0.00	4.36	3.40	0.00	3.27	0.00	0.00	0.06	select * from (select rownum r...
bauk8nf4grax0	40.53	42.45	0.36	2,574,250	44	451	0.04	451	0.09	0.09	0.00	5,707.87	0.10	1.00	0.00	4.02	3.20	0.52	3.48	0.01	0.19	0.33	BEGIN p_jnml_clyx_add(:1, :2, ...
7vt1711b4uaf4	38.70	39.76	0.00	2,421,788	0	82	0.00	82	0.47	0.48	0.00	29,534.00	0.00	1.00	0.00	3.84	3.00	0.00	3.27	0.00	0.00	0.06	select count(*) cnt from (SELE...
5sn8fz80rvbjr	30.42	31.48	0.00	1,683,276	0	513	0.00	57	0.53	0.55	0.00	29,531.16	0.00	9.00	0.00	3.02	2.37	0.00	2.27	0.00	0.00	0.04	select * from (select rownum r...
50z38wp0k8y7b	27.25	28.03	0.00	1,682,530	0	57	0.00	57	0.48	0.49	0.00	29,518.07	0.00	1.00	0.00	2.71	2.11	0.00	2.27	0.00	0.00	0.04	select count(*) cnt from (SELE...
11npfymrgntdm	26.59	27.32	0.00	1,475,803	0	400	0.00	50	0.53	0.55	0.00	29,516.06	0.00	8.00	0.00	2.64	2.06	0.00	1.99	0.00	0.00	0.04	select * from (select rownum r...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Time (Global)

Captured SQL account for 30.5% of Total User I/O Wait Time (s): 70
Captured PL/SQL account for 35.2% of Total User I/O Wait Time (s): 70

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
bauk8nf4grax0	0.36	42.45	40.53	2,574,250	44	451	0.04	451	0.00	0.09	0.09	5,707.87	0.10	1.00	0.00	0.52	3.20	4.02	3.48	0.01	0.19	0.33	BEGIN p_jnml_clyx_add(:1, :2, ...
gdranhw0kcrd8	0.01	389.80	314.22	27,625,490	0	605	0.91	605	0.00	0.64	0.52	45,661.97	0.00	1.00	0.00	0.01	29.39	31.20	37.33	0.00	4.63	0.44	BEGIN p_dbsx_cx(:1 , :2 ); END...
9g6pks8j8brdx	0.00	195.53	159.85	17,593,482	0	4,109	0.27	4,127	0.00	0.05	0.04	4,263.02	0.00	1.00	0.00	0.00	14.74	15.87	23.77	0.00	1.37	3.00	SELECT COUNT(*) FROM GD_DK_ZZ ...
11npfymrgntdm	0.00	27.32	26.59	1,475,803	0	400	0.00	50	0.00	0.55	0.53	29,516.06	0.00	8.00	0.00	0.00	2.06	2.64	1.99	0.00	0.00	0.04	select * from (select rownum r...
50z38wp0k8y7b	0.00	28.03	27.25	1,682,530	0	57	0.00	57	0.00	0.49	0.48	29,518.07	0.00	1.00	0.00	0.00	2.11	2.71	2.27	0.00	0.00	0.04	select count(*) cnt from (SELE...
5sn8fz80rvbjr	0.00	31.48	30.42	1,683,276	0	513	0.00	57	0.00	0.55	0.53	29,531.16	0.00	9.00	0.00	0.00	2.37	3.02	2.27	0.00	0.00	0.04	select * from (select rownum r...
670das7q4yjyu	0.00	45.09	43.89	2,423,432	0	1,804	0.00	82	0.00	0.55	0.54	29,554.05	0.00	22.00	0.00	0.00	3.40	4.36	3.27	0.00	0.00	0.06	select * from (select rownum r...
7vt1711b4uaf4	0.00	39.76	38.70	2,421,788	0	82	0.00	82	0.00	0.48	0.47	29,534.00	0.00	1.00	0.00	0.00	3.00	3.84	3.27	0.00	0.00	0.06	select count(*) cnt from (SELE...
9m94fyzc4sgdm	0.00	91.05	73.71	4,987,745	0	4,127	0.00	4,127	0.00	0.02	0.02	1,208.56	0.00	1.00	0.00	0.00	6.87	7.32	6.74	0.00	0.00	3.00	SELECT COUNT(*) FROM GD_TX_YHM...
cq6fuzzct18gg	0.00	73.10	57.76	3,234,850	0	4,123	0.18	4,127	0.00	0.02	0.01	783.83	0.00	1.00	0.00	0.00	5.51	5.74	4.37	0.00	0.94	3.00	SELECT COUNT(*) FROM GD_DK_TX_...

Back to SQL Statistics
Back to Top

SQL ordered by Gets (Global)

Total Buffer Gets: 74,011,516
Captured SQL account for 84.3% of Total

SQL Id	Gets	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Execs	Gets	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Gets	Reads	DB time	DB CPU	IO Wait	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
gdranhw0kcrd8	27,625,490	0	389.80	314.22	0.01	605	0.91	605	45,661.97	0.00	0.64	0.52	0.00	1.00	0.00	37.33	0.00	29.39	31.20	0.01	4.63	0.44	BEGIN p_dbsx_cx(:1 , :2 ); END...
9g6pks8j8brdx	17,593,482	0	195.53	159.85	0.00	4,109	0.27	4,127	4,263.02	0.00	0.05	0.04	0.00	1.00	0.00	23.77	0.00	14.74	15.87	0.00	1.37	3.00	SELECT COUNT(*) FROM GD_DK_ZZ ...
3rchqnwp893f4	5,659,454	54	31.41	21.33	0.20	20	0.19	15	377,296.93	3.60	2.09	1.42	0.01	1.33	0.01	7.65	0.01	2.37	2.12	0.29	0.98	0.01	select * from (select rownum r...
6d9f498u2axhm	5,331,316	0	29.40	20.04	0.00	15	0.01	15	355,421.07	0.00	1.96	1.34	0.00	1.00	0.00	7.20	0.00	2.22	1.99	0.00	0.06	0.01	select count(*) cnt, sum(g202)...
9m94fyzc4sgdm	4,987,745	0	91.05	73.71	0.00	4,127	0.00	4,127	1,208.56	0.00	0.02	0.02	0.00	1.00	0.00	6.74	0.00	6.87	7.32	0.00	0.00	3.00	SELECT COUNT(*) FROM GD_TX_YHM...
cq6fuzzct18gg	3,234,850	0	73.10	57.76	0.00	4,123	0.18	4,127	783.83	0.00	0.02	0.01	0.00	1.00	0.00	4.37	0.00	5.51	5.74	0.00	0.94	3.00	SELECT COUNT(*) FROM GD_DK_TX_...
3fz7dvg64qdf8	2,945,402	0	16.58	10.08	0.00	0	0.00	11	267,763.82	0.00	1.51	0.92	0.00	0.00	0.00	3.98	0.00	1.25	1.00	0.00	0.01	0.01	select * from (select rownum r...
bauk8nf4grax0	2,574,250	44	42.45	40.53	0.36	451	0.04	451	5,707.87	0.10	0.09	0.09	0.00	1.00	0.00	3.48	0.01	3.20	4.02	0.52	0.19	0.33	BEGIN p_jnml_clyx_add(:1, :2, ...
670das7q4yjyu	2,423,432	0	45.09	43.89	0.00	1,804	0.00	82	29,554.05	0.00	0.55	0.54	0.00	22.00	0.00	3.27	0.00	3.40	4.36	0.00	0.00	0.06	select * from (select rownum r...
7vt1711b4uaf4	2,421,788	0	39.76	38.70	0.00	82	0.00	82	29,534.00	0.00	0.48	0.47	0.00	1.00	0.00	3.27	0.00	3.00	3.84	0.00	0.00	0.06	select count(*) cnt from (SELE...

Back to SQL Statistics
Back to Top

SQL ordered by Reads (Global)

Total Disk Reads: 403,551
Captured SQL account for 45.6% 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
38bm7px768j8k	177,172	177,199	5.03	1.98	3.02	21	0.00	2	88,586.00	88,599.50	2.52	0.99	1.51	10.50	0.00	43.90	0.24	0.38	0.20	4.31	0.00	0.00	select pzid, sjhm, dxnr, sffs,...
g13m4qh4k07x6	3,310	90,391	17.48	1.23	15.45	87	0.55	87	38.05	1,038.98	0.20	0.01	0.18	1.00	0.01	0.82	0.12	1.32	0.12	22.02	2.77	0.06	BEGIN P_GZ_GR_MX_CX_YD(:1, :2,...
5ssgkcutv4qk9	3,132	84,356	5.98	0.87	1.32	4,602	3.47	2	1,566.00	42,178.00	2.99	0.43	0.66	2,301.00	1.74	0.78	0.11	0.45	0.09	1.89	17.63	0.00	select a.a003 bm, max(b.mc) mc...
048671ycd5ww1	1,680	229,520	9.04	3.19	0.20	0	0.30	12	140.00	19,126.67	0.75	0.27	0.02	0.00	0.02	0.42	0.31	0.68	0.32	0.29	1.51	0.01	call wasys3_sxgjj.PKG_MH_SYSMO...
3tw70y4ujxqrq	1,302	4,987	6.47	0.09	6.24	72	0.13	72	18.08	69.26	0.09	0.00	0.09	1.00	0.00	0.32	0.01	0.49	0.01	8.89	0.66	0.05	SELECT NVL(SUM(P008-P009), 0)+...
aqh8wxctfu98y	1,299	73,831	9.52	0.62	8.02	173	0.57	173	7.51	426.77	0.06	0.00	0.05	1.00	0.00	0.32	0.10	0.72	0.06	11.43	2.89	0.13	BEGIN p_gz_gr_qclr_chk(:1, :2,...
d6kch59q9nvy0	1,012	4,466	4.84	0.08	4.53	437	0.21	72	14.06	62.03	0.07	0.00	0.06	6.07	0.00	0.25	0.01	0.37	0.01	6.46	1.08	0.05	INSERT INTO TMP_GZ_GR_MX_CX_YD...
f5yun5dynkskv	778	42,974	4.11	1.66	0.94	4,849	0.51	1	778.00	42,974.00	4.11	1.66	0.94	4,849.00	0.51	0.19	0.06	0.31	0.16	1.35	2.59	0.00	select s.synonym_name as obje...
3tffqzf3wagfk	737	7,956	5.22	0.07	4.98	246	0.15	246	3.00	32.34	0.02	0.00	0.02	1.00	0.00	0.18	0.01	0.39	0.01	7.10	0.76	0.18	SELECT NVL(SUM(P008-P009), 0) ...
0s8yg3vq85g1q	300	876,283	6.63	3.77	0.49	16	0.22	16	18.75	54,767.69	0.41	0.24	0.03	1.00	0.01	0.07	1.18	0.50	0.37	0.70	1.11	0.01	BEGIN p_gz_ywfl_cx(:1, :2, :3,...

Back to SQL Statistics
Back to Top

SQL ordered by UnOptimized Read Requests (Global)

Total Physical Read Requests: 40,374
Captured SQL account for 22.0% of Total
Total UnOptimized Read Requests: 40,374
Captured SQL account for 22.0% 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
048671ycd5ww1	4,356	4,356	1,680	9.04	3.19	0.20	0	0.30	12	363.00	363.00	140.00	0.75	0.27	0.02	0.00	0.02	10.79	10.79	0.42	0.68	0.32	0.29	1.51	0.01	call wasys3_sxgjj.PKG_MH_SYSMO...
g13m4qh4k07x6	3,310	3,310	3,310	17.48	1.23	15.45	87	0.55	87	38.05	38.05	38.05	0.20	0.01	0.18	1.00	0.01	8.20	8.20	0.82	1.32	0.12	22.02	2.77	0.06	BEGIN P_GZ_GR_MX_CX_YD(:1, :2,...
38bm7px768j8k	2,802	2,802	177,172	5.03	1.98	3.02	21	0.00	2	1,401.00	1,401.00	88,586.00	2.52	0.99	1.51	10.50	0.00	6.94	6.94	43.90	0.38	0.20	4.31	0.00	0.00	select pzid, sjhm, dxnr, sffs,...
5ssgkcutv4qk9	2,410	2,410	3,132	5.98	0.87	1.32	4,602	3.47	2	1,205.00	1,205.00	1,566.00	2.99	0.43	0.66	2,301.00	1.74	5.97	5.97	0.78	0.45	0.09	1.89	17.63	0.00	select a.a003 bm, max(b.mc) mc...
3tw70y4ujxqrq	1,302	1,302	1,302	6.47	0.09	6.24	72	0.13	72	18.08	18.08	18.08	0.09	0.00	0.09	1.00	0.00	3.22	3.22	0.32	0.49	0.01	8.89	0.66	0.05	SELECT NVL(SUM(P008-P009), 0)+...
aqh8wxctfu98y	1,299	1,299	1,299	9.52	0.62	8.02	173	0.57	173	7.51	7.51	7.51	0.06	0.00	0.05	1.00	0.00	3.22	3.22	0.32	0.72	0.06	11.43	2.89	0.13	BEGIN p_gz_gr_qclr_chk(:1, :2,...
d6kch59q9nvy0	1,012	1,012	1,012	4.84	0.08	4.53	437	0.21	72	14.06	14.06	14.06	0.07	0.00	0.06	6.07	0.00	2.51	2.51	0.25	0.37	0.01	6.46	1.08	0.05	INSERT INTO TMP_GZ_GR_MX_CX_YD...
3tffqzf3wagfk	737	737	737	5.22	0.07	4.98	246	0.15	246	3.00	3.00	3.00	0.02	0.00	0.02	1.00	0.00	1.83	1.83	0.18	0.39	0.01	7.10	0.76	0.18	SELECT NVL(SUM(P008-P009), 0) ...
f5yun5dynkskv	620	620	778	4.11	1.66	0.94	4,849	0.51	1	620.00	620.00	778.00	4.11	1.66	0.94	4,849.00	0.51	1.54	1.54	0.19	0.31	0.16	1.35	2.59	0.00	select s.synonym_name as obje...
0s8yg3vq85g1q	300	300	300	6.63	3.77	0.49	16	0.22	16	18.75	18.75	18.75	0.41	0.24	0.03	1.00	0.01	0.74	0.74	0.07	0.50	0.37	0.70	1.11	0.01	BEGIN p_gz_ywfl_cx(:1, :2, :3,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions (Global)

Total Executions: 137,541
Captured SQL account for 31.5% 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
9g6pks8j8brdx	4,127	195.53	159.85	0.00	17,593,482	0	4,109	0.27	0.05	0.04	0.00	4,263.02	0.00	1.00	0.00	3.00	14.74	15.87	0.00	23.77	0.00	1.37	SELECT COUNT(*) FROM GD_DK_ZZ ...
9m94fyzc4sgdm	4,127	91.05	73.71	0.00	4,987,745	0	4,127	0.00	0.02	0.02	0.00	1,208.56	0.00	1.00	0.00	3.00	6.87	7.32	0.00	6.74	0.00	0.00	SELECT COUNT(*) FROM GD_TX_YHM...
cq6fuzzct18gg	4,127	73.10	57.76	0.00	3,234,850	0	4,123	0.18	0.02	0.01	0.00	783.83	0.00	1.00	0.00	3.00	5.51	5.74	0.00	4.37	0.00	0.94	SELECT COUNT(*) FROM GD_DK_TX_...
0b9cd2mk761zn	4,124	17.17	13.40	0.00	927,601	0	4,126	0.00	0.00	0.00	0.00	224.93	0.00	1.00	0.00	3.00	1.29	1.33	0.00	1.25	0.00	0.02	SELECT COUNT(*) FROM GD_DK_ZZ ...
4vagx3sw24a7z	3,978	1.56	0.37	0.00	1,019	0	3,978	0.07	0.00	0.00	0.00	0.26	0.00	1.00	0.00	2.89	0.12	0.04	0.00	0.00	0.00	0.33	SELECT WASYS3_GUID.NEXTVAL FRO...
cm5vu20fhtnq1	3,963	1.38	1.02	0.00	23,375	0	12,618	0.00	0.00	0.00	0.00	5.90	0.00	3.18	0.00	2.88	0.10	0.10	0.00	0.03	0.00	0.00	select /*+ connect_by_filterin...
ftj9uawt4wwzb	2,160	0.14	0.10	0.00	4,320	0	2,160	0.00	0.00	0.00	0.00	2.00	0.00	1.00	0.00	1.57	0.01	0.01	0.00	0.01	0.00	0.00	select condition from cdef$ wh...
a6vnt8j5snyc4	1,556	0.22	0.21	0.00	23,301	0	1,556	0.00	0.00	0.00	0.00	14.97	0.00	1.00	0.00	1.13	0.02	0.02	0.00	0.03	0.00	0.01	SELECT COUNT(*) FROM GD_DK_ZZ ...
dha5nv6urcumf	1,120	0.17	0.15	0.00	2,240	0	1,120	0.00	0.00	0.00	0.00	2.00	0.00	1.00	0.00	0.81	0.01	0.01	0.00	0.00	0.00	0.00	select binaryDefVal, lengthb(b...
5ms6rbzdnq16t	708	0.10	0.06	0.00	1,416	0	65	0.00	0.00	0.00	0.00	2.00	0.00	0.09	0.00	0.51	0.01	0.01	0.00	0.00	0.00	0.00	select job, nvl2(last_date, 1,...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time (Global)

Total Cluster Wait Time (s): 20
Captured SQL account for 29.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
5ssgkcutv4qk9	3.47	5.98	0.87	1.32	84,356	3,132	4,602	2	1.74	2.99	0.43	0.66	42,178.00	1,566.00	2,301.00	17.63	0.45	0.09	1.89	0.11	0.78	0.00	select a.a003 bm, max(b.mc) mc...
gdranhw0kcrd8	0.91	389.80	314.22	0.01	27,625,490	0	605	605	0.00	0.64	0.52	0.00	45,661.97	0.00	1.00	4.63	29.39	31.20	0.01	37.33	0.00	0.44	BEGIN p_dbsx_cx(:1 , :2 ); END...
aqh8wxctfu98y	0.57	9.52	0.62	8.02	73,831	1,299	173	173	0.00	0.06	0.00	0.05	426.77	7.51	1.00	2.89	0.72	0.06	11.43	0.10	0.32	0.13	BEGIN p_gz_gr_qclr_chk(:1, :2,...
g13m4qh4k07x6	0.55	17.48	1.23	15.45	90,391	3,310	87	87	0.01	0.20	0.01	0.18	1,038.98	38.05	1.00	2.77	1.32	0.12	22.02	0.12	0.82	0.06	BEGIN P_GZ_GR_MX_CX_YD(:1, :2,...
f5yun5dynkskv	0.51	4.11	1.66	0.94	42,974	778	4,849	1	0.51	4.11	1.66	0.94	42,974.00	778.00	4,849.00	2.59	0.31	0.16	1.35	0.06	0.19	0.00	select s.synonym_name as obje...
048671ycd5ww1	0.30	9.04	3.19	0.20	229,520	1,680	0	12	0.02	0.75	0.27	0.02	19,126.67	140.00	0.00	1.51	0.68	0.32	0.29	0.31	0.42	0.01	call wasys3_sxgjj.PKG_MH_SYSMO...
9g6pks8j8brdx	0.27	195.53	159.85	0.00	17,593,482	0	4,109	4,127	0.00	0.05	0.04	0.00	4,263.02	0.00	1.00	1.37	14.74	15.87	0.00	23.77	0.00	3.00	SELECT COUNT(*) FROM GD_DK_ZZ ...
0s8yg3vq85g1q	0.22	6.63	3.77	0.49	876,283	300	16	16	0.01	0.41	0.24	0.03	54,767.69	18.75	1.00	1.11	0.50	0.37	0.70	1.18	0.07	0.01	BEGIN p_gz_ywfl_cx(:1, :2, :3,...
d6kch59q9nvy0	0.21	4.84	0.08	4.53	4,466	1,012	437	72	0.00	0.07	0.00	0.06	62.03	14.06	6.07	1.08	0.37	0.01	6.46	0.01	0.25	0.05	INSERT INTO TMP_GZ_GR_MX_CX_YD...
3rchqnwp893f4	0.19	31.41	21.33	0.20	5,659,454	54	20	15	0.01	2.09	1.42	0.01	377,296.93	3.60	1.33	0.98	2.37	2.12	0.29	7.65	0.01	0.01	select * from (select rownum r...

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	150	0.04	0.02	0.02	0.03	0.00	0.04
Batched IO block miss count	3,144	0.89	0.49	0.44	0.58	0.03	0.85
Batched IO buffer defrag count	13	0.00	0.00	0.00	0.00	0.00	0.00
Batched IO double miss count	37	0.01	0.01	0.01	0.00	0.00	0.01
Batched IO same unit count	1,543	0.43	0.24	0.22	0.30	0.00	0.43
Batched IO single block count	113	0.03	0.02	0.02	0.02	0.00	0.03
Batched IO slow jump count	68	0.02	0.01	0.02		0.02	0.02
Batched IO vector block count	1,486	0.42	0.23	0.21	0.25	0.03	0.39
Batched IO vector read count	48	0.01	0.01	0.01	0.01	0.00	0.01
Block Cleanout Optim referenced	254	0.07	0.04	0.04	0.05	0.00	0.07
CCursor + sql area evicted	19	0.01	0.00	0.00	0.00	0.00	0.00
CPU used by this session	115,542	32.57	17.91	16.28	7.11	11.25	21.32
CPU used when call started	103,854	29.28	16.09	14.64	6.32	10.17	19.11
CR blocks created	140	0.04	0.02	0.02	0.00	0.02	0.02
Cached Commit SCN referenced	11,760	3.32	1.82	1.66	0.92	1.01	2.31
Clusterwide global transactions	12	0.00	0.00	0.00		0.00	0.00
Commit SCN cached	89	0.03	0.01	0.01	0.01	0.01	0.02
DB time	562,675	158.61	87.20	79.31	54.93	40.46	118.15
DBWR checkpoint buffers written	7,564	2.13	1.17	1.07	0.21	0.92	1.21
DBWR checkpoints	15	0.00	0.00	0.00	0.00	0.00	0.00
DBWR fusion writes	1,219	0.34	0.19	0.17	0.03	0.15	0.19
DBWR object drop buffers written	16	0.00	0.00	0.00		0.00	0.00
DBWR tablespace checkpoint buffers written	16	0.00	0.00	0.00	0.00	0.00	0.00
DBWR transaction table writes	311	0.09	0.05	0.04	0.00	0.04	0.04
DBWR undo block writes	1,691	0.48	0.26	0.24	0.05	0.20	0.27
DFO trees parallelized	538	0.15	0.08	0.08	0.10	0.00	0.15
DX/BB enqueue lock background gets	24	0.01	0.00	0.01		0.01	0.01
DX/BB enqueue lock foreground requests	612	0.17	0.09	0.17		0.17	0.17
DX/BB enqueue lock foreground wait time	1	0.00	0.00	0.00		0.00	0.00
Effective IO time	4,592,312	1,294.52	711.66	1,294.52		1,294.52	1,294.52
HSC Heap Segment Block Changes	28,175	7.94	4.37	3.97	1.33	3.03	4.91
Heap Segment Array Inserts	1,369	0.39	0.21	0.19	0.10	0.12	0.27
Number of read IOs issued	5,415	1.53	0.84	1.53		1.53	1.53
PX local messages recv'd	1,816	0.51	0.28	0.26	0.35	0.01	0.51
PX local messages sent	1,816	0.51	0.28	0.26	0.35	0.01	0.51
PX remote messages recv'd	2,236	0.63	0.35	0.32	0.02	0.30	0.33
PX remote messages sent	2,236	0.63	0.35	0.32	0.02	0.30	0.33
Parallel operations not downgraded	538	0.15	0.08	0.08	0.10	0.00	0.15
Requests to/from client	35,632	10.04	5.52	5.02	1.47	3.98	6.06
RowCR attempts	707	0.20	0.11	0.10	0.10	0.03	0.17
RowCR hits	705	0.20	0.11	0.10	0.10	0.03	0.17
SMON posted for undo segment shrink	2	0.00	0.00	0.00	0.00	0.00	0.00
SQL*Net roundtrips to/from client	35,594	10.03	5.52	5.02	1.47	3.98	6.05
SQL*Net roundtrips to/from dblink	290	0.08	0.04	0.08		0.08	0.08
active txn count during cleanout	460	0.13	0.07	0.06	0.01	0.06	0.07
application wait time	4	0.00	0.00	0.00	0.00	0.00	0.00
background checkpoints completed	1	0.00	0.00	0.00		0.00	0.00
background checkpoints started	1	0.00	0.00	0.00		0.00	0.00
background timeouts	58,109	16.38	9.00	8.19	0.47	7.86	8.52
branch node splits	1	0.00	0.00	0.00		0.00	0.00
buffer is not pinned count	15,704,828	4,426.99	2,433.73	2,213.50	1,646.54	1,049.22	3,377.78
buffer is pinned count	103,598,888	29,203.24	16,054.38	14,601.62	7,423.43	9,352.46	19,850.78
bytes received via SQL*Net from client	10,587,282	2,984.42	1,640.68	1,492.21	613.53	1,058.38	1,926.04
bytes received via SQL*Net from dblink	127,703	36.00	19.79	36.00		36.00	36.00
bytes sent via SQL*Net to client	22,289,486	6,283.14	3,454.13	3,141.57	290.49	2,936.17	3,346.98
bytes sent via SQL*Net to dblink	134,179	37.82	20.79	37.82		37.82	37.82
calls to get snapshot scn: kcmgss	138,295	38.98	21.43	19.49	7.00	14.54	24.44
calls to kcmgas	34,491	9.72	5.34	4.86	0.95	4.19	5.53
calls to kcmgcs	251,038	70.76	38.90	35.38	10.10	28.24	42.52
cell physical IO interconnect bytes	4,215,290,880	1,188,243.87	653,229.64	594,121.93	607,244.60	164,735.16	1,023,508.71
change write time	150	0.04	0.02	0.02	0.01	0.02	0.03
cleanout - number of ktugct calls	889	0.25	0.14	0.13	0.03	0.11	0.14
cleanouts and rollbacks - consistent read gets	70	0.02	0.01	0.01	0.00	0.01	0.01
cleanouts only - consistent read gets	382	0.11	0.06	0.05	0.04	0.03	0.08
cluster key scan block gets	9,000	2.54	1.39	1.27	0.86	0.66	1.88
cluster key scans	7,231	2.04	1.12	1.02	0.97	0.33	1.70
cluster wait time	1,928	0.54	0.30	0.27	0.08	0.22	0.33
commit batch/immediate performed	59	0.02	0.01	0.02		0.02	0.02
commit batch/immediate requested	59	0.02	0.01	0.02		0.02	0.02
commit cleanout failures: block lost	422	0.12	0.07	0.06	0.04	0.03	0.09
commit cleanout failures: callback failure	14	0.00	0.00	0.00	0.00	0.00	0.00
commit cleanout failures: cannot pin	3	0.00	0.00	0.00		0.00	0.00
commit cleanouts	26,191	7.38	4.06	3.69	0.62	3.25	4.13
commit cleanouts successfully completed	25,752	7.26	3.99	3.63	0.58	3.22	4.04
commit immediate performed	59	0.02	0.01	0.02		0.02	0.02
commit immediate requested	59	0.02	0.01	0.02		0.02	0.02
commit txn count during cleanout	1,234	0.35	0.19	0.17	0.03	0.15	0.19
concurrency wait time	1,570	0.44	0.24	0.22	0.10	0.15	0.29
consistent changes	9,633	2.72	1.49	1.36	1.12	0.56	2.15
consistent gets	73,871,521	20,823.49	11,447.62	10,411.74	1,761.17	9,166.41	11,657.08
consistent gets - examination	6,620,435	1,866.22	1,025.95	933.11	917.88	284.07	1,582.15
consistent gets direct	340,789	96.06	52.81	96.06		96.06	96.06
consistent gets from cache	73,530,732	20,727.42	11,394.81	10,363.71	1,829.10	9,070.34	11,657.08
consistent gets from cache (fastpath)	66,669,846	18,793.43	10,331.60	9,396.71	882.82	8,772.46	10,020.96
cursor authentications	1,307	0.37	0.20	0.18	0.03	0.17	0.20
data blocks consistent reads - undo records applied	183	0.05	0.03	0.03	0.00	0.02	0.03
db block changes	128,779	36.30	19.96	18.15	5.46	14.29	22.01
db block gets	139,995	39.46	21.69	19.73	6.09	15.42	24.04
db block gets direct	21	0.01	0.00	0.00	0.00	0.00	0.00
db block gets from cache	139,974	39.46	21.69	19.73	6.10	15.42	24.04
db block gets from cache (fastpath)	29,934	8.44	4.64	4.22	2.05	2.77	5.67
deferred (CURRENT) block cleanout applications	10,651	3.00	1.65	1.50	0.28	1.31	1.70
dirty buffers inspected	18	0.01	0.00	0.00	0.00	0.00	0.00
enqueue conversions	5,945	1.68	0.92	0.84	0.37	0.58	1.10
enqueue releases	121,960	34.38	18.90	17.19	1.47	16.15	18.23
enqueue requests	124,241	35.02	19.25	17.51	1.46	16.48	18.54
enqueue timeouts	2,323	0.65	0.36	0.33	0.01	0.32	0.34
enqueue waits	3,827	1.08	0.59	0.54	0.47	0.21	0.87
execute count	137,541	38.77	21.31	19.39	6.91	14.50	24.27
file io wait time	65,603,974	18,492.95	10,166.43	9,246.47	4,065.51	6,371.72	12,121.22
free buffer inspected	95,085	26.80	14.74	13.40	5.78	9.31	17.49
free buffer requested	101,008	28.47	15.65	14.24	5.34	10.46	18.01
gc blocks compressed	7,730	2.18	1.20	1.09	0.15	0.98	1.19
gc cr block flush time	4	0.00	0.00	0.00	0.00	0.00	0.00
gc cr block receive time	204	0.06	0.03	0.03	0.00	0.03	0.03
gc cr blocks received	5,299	1.49	0.82	0.75	0.06	0.71	0.79
gc cr blocks served	5,294	1.49	0.82	0.75	0.06	0.71	0.79
gc current block flush time	15	0.00	0.00	0.00	0.00	0.00	0.00
gc current block receive time	1,706	0.48	0.26	0.24	0.14	0.14	0.34
gc current blocks received	28,455	8.02	4.41	4.01	1.01	3.29	4.73
gc current blocks served	28,471	8.03	4.41	4.01	1.01	3.30	4.73
gc kbytes saved	28,234	7.96	4.38	3.98	0.72	3.47	4.49
gc kbytes sent	241,886	68.18	37.48	34.09	6.93	29.20	38.99
gc local grants	14,486	4.08	2.24	2.04	1.51	0.97	3.11
gc read wait time	1	0.00	0.00	0.00		0.00	0.00
gc read waits	1	0.00	0.00	0.00		0.00	0.00
gc remote grants	52,364	14.76	8.11	7.38	7.96	1.75	13.01
gcs messages sent	209,354	59.01	32.44	29.51	8.17	23.73	35.28
ges messages sent	27,658	7.80	4.29	3.90	2.50	2.13	5.67
global enqueue get time	830	0.23	0.13	0.12	0.10	0.05	0.19
global enqueue gets async	1,265	0.36	0.20	0.18	0.09	0.12	0.24
global enqueue gets sync	129,361	36.47	20.05	18.23	6.58	13.58	22.89
global enqueue releases	122,403	34.50	18.97	17.25	6.46	12.68	21.82
heap block compress	520	0.15	0.08	0.07	0.00	0.07	0.07
hot buffers moved to head of LRU	10,431	2.94	1.62	1.47	1.60	0.34	2.60
immediate (CR) block cleanout applications	452	0.13	0.07	0.06	0.04	0.04	0.09
immediate (CURRENT) block cleanout applications	1,676	0.47	0.26	0.24	0.16	0.12	0.35
in call idle wait time	31,848,638	8,977.75	4,935.48	4,488.87	273.70	4,295.34	4,682.41
index crx upgrade (positioned)	474	0.13	0.07	0.07	0.07	0.02	0.12
index fast full scans (full)	9,459	2.67	1.47	1.33	0.62	0.89	1.77
index fetch by key	5,875,996	1,656.37	910.58	828.18	780.25	276.47	1,379.90
index scans kdiixs1	3,644,586	1,027.36	564.79	513.68	532.52	137.13	890.23
leaf node 90-10 splits	70	0.02	0.01	0.01	0.00	0.01	0.01
leaf node splits	108	0.03	0.02	0.02	0.00	0.01	0.02
lob reads	3	0.00	0.00	0.00		0.00	0.00
lob writes	121	0.03	0.02	0.02	0.01	0.01	0.02
lob writes unaligned	121	0.03	0.02	0.02	0.01	0.01	0.02
logical read bytes from cache	603,510,423,552	170,122,261.42	93,524,007.99	85,061,130.71	15,033,916.91	74,430,546.12	95,691,715.30
logons cumulative	1,699	0.48	0.26	0.24	0.03	0.22	0.26
max cf enq hold time	7	0.00	0.00	0.00		0.00	0.00
messages received	27,318	7.70	4.23	3.85	0.47	3.52	4.18
messages sent	27,318	7.70	4.23	3.85	0.47	3.52	4.18
no buffer to keep pinned count	3,615	1.02	0.56	0.51	0.55	0.12	0.90
no work - consistent read gets	66,851,977	18,844.77	10,359.83	9,422.38	811.62	8,848.48	9,996.28
non-idle wait count	546,403	154.02	84.67	77.01	3.67	74.42	79.61
non-idle wait time	14,727	4.15	2.28	2.08	0.45	1.75	2.40
opened cursors cumulative	142,479	40.16	22.08	20.08	7.03	15.11	25.05
parse count (describe)	30	0.01	0.00	0.00	0.00	0.00	0.00
parse count (failures)	3	0.00	0.00	0.00		0.00	0.00
parse count (hard)	4,382	1.24	0.68	0.62	0.12	0.53	0.70
parse count (total)	45,729	12.89	7.09	6.45	3.87	3.71	9.18
parse time cpu	16,431	4.63	2.55	2.32	0.12	2.23	2.40
parse time elapsed	22,086	6.23	3.42	3.11	1.13	2.31	3.91
physical read IO requests	40,374	11.38	6.26	5.69	2.47	3.94	7.44
physical read bytes	3,305,889,792	931,894.62	512,302.77	465,947.31	610,348.48	34,365.76	897,528.86
physical read total IO requests	69,858	19.69	10.83	9.85	1.98	8.45	11.25
physical read total bytes	3,811,427,840	1,074,399.71	590,644.33	537,199.86	606,807.55	108,122.12	966,277.59
physical read total multi block requests	5,876	1.66	0.91	0.83	1.17	0.00	1.65
physical reads	403,551	113.76	62.54	56.88	74.51	4.20	109.56
physical reads cache	62,734	17.68	9.72	8.84	6.57	4.20	13.49
physical reads cache prefetch	40,261	11.35	6.24	5.67	7.22	0.57	10.78
physical reads direct	340,817	96.07	52.82	96.07		96.07	96.07
physical write IO requests	6,545	1.84	1.01	0.92	0.17	0.80	1.04
physical write bytes	69,607,424	19,621.49	10,786.83	9,810.74	1,774.87	8,555.72	11,065.76
physical write total IO requests	62,666	17.66	9.71	8.83	0.93	8.17	9.49
physical write total bytes	403,863,040	113,844.15	62,585.32	56,922.08	437.05	56,613.03	57,231.12
physical write total multi block requests	90	0.03	0.01	0.01	0.00	0.01	0.02
physical writes	8,497	2.40	1.32	1.20	0.22	1.04	1.35
physical writes direct	39	0.01	0.01	0.01	0.01	0.00	0.01
physical writes direct (lob)	4	0.00	0.00	0.00		0.00	0.00
physical writes from cache	8,458	2.38	1.31	1.19	0.22	1.03	1.35
physical writes non checkpoint	4,138	1.17	0.64	0.58	0.14	0.49	0.68
pinned buffers inspected	1	0.00	0.00	0.00		0.00	0.00
prefetch clients - default	1	0.00	0.00	0.00		0.00	0.00
process last non-idle time	7,024	1.98	1.09	0.99	0.01	0.98	1.00
queries parallelized	502	0.14	0.08	0.07	0.10	0.00	0.14
recursive calls	385,368	108.63	59.72	54.32	22.81	38.18	70.45
recursive cpu usage	61,017	17.20	9.46	8.60	2.04	7.16	10.04
redo KB read	21,184	5.97	3.28	5.97		5.97	5.97
redo blocks checksummed by FG (exclusive)	8,725	2.46	1.35	1.23	0.13	1.14	1.32
redo blocks written	68,339	19.26	10.59	9.63	1.69	8.44	10.82
redo entries	82,969	23.39	12.86	11.69	2.87	9.66	13.73
redo ordering marks	1,541	0.43	0.24	0.22	0.05	0.18	0.25
redo size	27,520,548	7,757.71	4,264.77	3,878.85	743.86	3,352.87	4,404.84
redo size for direct writes	173,624	48.94	26.91	24.47	21.47	9.29	39.65
redo subscn max counts	1,441	0.41	0.22	0.20	0.02	0.19	0.22
redo synch long waits	12	0.00	0.00	0.00	0.00	0.00	0.00
redo synch time	370	0.10	0.06	0.05	0.01	0.04	0.06
redo synch time (usec)	3,921,875	1,105.53	607.76	552.77	136.00	456.60	648.93
redo synch writes	4,239	1.19	0.66	0.60	0.12	0.51	0.68
redo wastage	6,350,084	1,790.01	984.05	895.01	87.03	833.46	956.55
redo write broadcast ack count	3,711	1.05	0.58	0.52	0.43	0.22	0.83
redo write broadcast ack time	561,403	158.25	87.00	79.13	10.29	71.85	86.40
redo write time	1,295	0.37	0.20	0.18	0.00	0.18	0.19
redo writes	20,632	5.82	3.20	2.91	0.37	2.65	3.17
rollback changes - undo records applied	59	0.02	0.01	0.02		0.02	0.02
rollbacks only - consistent read gets	68	0.02	0.01	0.01	0.00	0.01	0.01
rows fetched via callback	1,166,021	328.69	180.69	164.34	115.23	82.87	245.82
session logical reads	74,011,516	20,862.95	11,469.32	10,431.47	1,767.26	9,181.83	11,681.12
shared hash latch upgrades - no wait	173,672	48.96	26.91	24.48	22.46	8.60	40.36
shared hash latch upgrades - wait	50	0.01	0.01	0.01		0.01	0.01
sorts (memory)	42,637	12.02	6.61	6.01	5.54	2.09	9.93
sorts (rows)	1,899,997	535.59	294.44	267.79	135.82	171.76	363.83
sql area evicted	3,750	1.06	0.58	0.53	0.10	0.46	0.60
sql area purged	272	0.08	0.04	0.04	0.03	0.02	0.06
summed dirty queue length	11	0.00	0.00	0.00	0.00	0.00	0.00
switch current to new buffer	2,267	0.64	0.35	0.32	0.12	0.24	0.40
table fetch by rowid	56,827,691	16,019.02	8,806.40	8,009.51	4,114.48	5,100.13	10,918.89
table fetch continued row	130,507	36.79	20.22	18.39	7.68	12.96	23.83
table scan blocks gotten	46,315,204	13,055.71	7,177.31	6,527.85	1,155.55	5,710.76	7,344.95
table scan rows gotten	1,499,050,328	422,564.78	232,302.86	211,282.39	71,494.43	160,728.19	261,836.59
table scans (direct read)	7	0.00	0.00	0.00		0.00	0.00
table scans (long tables)	1	0.00	0.00	0.00		0.00	0.00
table scans (short tables)	30,066	8.48	4.66	4.24	1.20	3.39	5.08
total cf enq hold time	202	0.06	0.03	0.03	0.01	0.02	0.04
total number of cf enq holders	101	0.03	0.02	0.01	0.01	0.01	0.02
total number of times SMON posted	1,429	0.40	0.22	0.20	0.00	0.20	0.20
transaction rollbacks	59	0.02	0.01	0.02		0.02	0.02
undo change vector size	9,230,968	2,602.10	1,430.49	1,301.05	413.17	1,008.90	1,593.20
user I/O wait time	6,993	1.97	1.08	0.99	0.33	0.75	1.22
user calls	60,086	16.94	9.31	8.47	1.90	7.13	9.81
user commits	5,976	1.68	0.93	0.84	0.11	0.76	0.92
user rollbacks	477	0.13	0.07	0.07	0.09	0.00	0.13
workarea executions - optimal	27,984	7.89	4.34	3.94	2.04	2.50	5.38
write clones created in background	6	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)	10,140	2.86	1.57	1.43	0.26	1.24	1.61
acks for commit broadcast(logical)	10,288	2.90	1.59	1.45	0.25	1.27	1.63
broadcast msgs on commit(actual)	10,289	2.90	1.59	1.45	0.25	1.27	1.63
broadcast msgs on commit(logical)	10,950	3.09	1.70	1.54	0.25	1.36	1.72
broadcast msgs on commit(wasted)	197	0.06	0.03	0.03	0.01	0.02	0.04
flow control messages received	28,275	7.97	4.38	3.99	0.00	3.98	3.99
flow control messages sent	28,274	7.97	4.38	3.99	0.01	3.98	3.99
gcs assume no cvt	20,303	5.72	3.15	2.86	0.72	2.35	3.37
gcs blocked converts	4,655	1.31	0.72	0.66	0.31	0.44	0.88
gcs blocked cr converts	5,294	1.49	0.82	0.75	0.28	0.55	0.95
gcs compatible basts	164	0.05	0.03	0.02	0.01	0.02	0.03
gcs compatible cr basts (global)	620	0.17	0.10	0.09	0.01	0.08	0.10
gcs compatible cr basts (local)	25,215	7.11	3.91	3.55	0.67	3.08	4.03
gcs dbwr flush pi msgs	887	0.25	0.14	0.13	0.02	0.11	0.14
gcs dbwr write request msgs	736	0.21	0.11	0.10	0.01	0.10	0.11
gcs force cr block only	30	0.01	0.00	0.00	0.00	0.00	0.01
gcs force cr grant	11	0.00	0.00	0.00		0.00	0.00
gcs immediate (compatible) converts	733	0.21	0.11	0.10	0.04	0.07	0.13
gcs immediate (null) converts	3,342	0.94	0.52	0.47	0.43	0.17	0.77
gcs immediate cr (compatible) converts	1	0.00	0.00	0.00		0.00	0.00
gcs immediate cr (null) converts	52,372	14.76	8.12	7.38	8.29	1.52	13.24
gcs indirect ast	7,914	2.23	1.23	1.12	0.35	0.87	1.36
gcs indirect fg ast	7,914	2.23	1.23	1.12	0.35	0.87	1.36
gcs lms write request msgs	371	0.10	0.06	0.05	0.01	0.05	0.06
gcs msgs process time(ms)	3,866	1.09	0.60	0.54	0.22	0.39	0.70
gcs msgs received	219,496	61.87	34.01	30.94	6.42	26.40	35.48
gcs new served by master	281	0.08	0.04	0.04	0.02	0.02	0.06
gcs out-of-order msgs	1	0.00	0.00	0.00		0.00	0.00
gcs pings refused	2	0.00	0.00	0.00		0.00	0.00
gcs queued converts	2	0.00	0.00	0.00		0.00	0.00
gcs side channel msgs actual	7,081	2.00	1.10	1.00	0.10	0.93	1.07
gcs side channel msgs logical	42,574	12.00	6.60	6.00	0.78	5.45	6.55
gcs stale cr	1,584	0.45	0.25	0.22	0.05	0.19	0.26
gcs write notification msgs	61	0.02	0.01	0.01	0.00	0.01	0.01
gcs writes refused	9	0.00	0.00	0.00	0.00	0.00	0.00
ges msgs process time(ms)	682	0.19	0.11	0.10	0.10	0.02	0.17
ges msgs received	16,203	4.57	2.51	2.28	0.21	2.14	2.43
global posts queue time	220	0.06	0.03	0.06		0.06	0.06
global posts queued	57	0.02	0.01	0.02		0.02	0.02
global posts requested	61	0.02	0.01	0.02		0.02	0.02
global posts sent	57	0.02	0.01	0.02		0.02	0.02
implicit batch messages received	7,942	2.24	1.23	1.12	1.33	0.18	2.06
implicit batch messages sent	7,827	2.21	1.21	1.10	1.31	0.18	2.03
messages flow controlled	34,926	9.85	5.41	4.92	4.10	2.03	7.82
messages queue sent actual	77,104	21.73	11.95	10.87	3.64	8.30	13.44
messages queue sent logical	51,494	14.52	7.98	7.26	8.52	1.23	13.28
messages received actual	132,333	37.30	20.51	18.65	0.73	18.13	19.17
messages received logical	235,706	66.44	36.53	33.22	6.21	28.83	37.61
messages sent directly	19,087	5.38	2.96	2.69	2.78	0.73	4.65
messages sent indirectly	72,089	20.32	11.17	10.16	6.66	5.45	14.87
messages sent not implicit batched	443	0.12	0.07	0.06	0.08	0.01	0.12
messages sent pbatched	123,289	34.75	19.11	17.38	2.25	15.79	18.97
msgs causing lmd to send msgs	6,147	1.73	0.95	0.87	0.58	0.46	1.27
msgs causing lms(s) to send msgs	7,522	2.12	1.17	1.06	0.73	0.54	1.58
msgs received queue time (ms)	958,173	270.10	148.48	135.05	83.75	75.83	194.27
msgs received queued	235,735	66.45	36.53	33.23	6.21	28.83	37.62
msgs sent queue time (ms)	18,953	5.34	2.94	2.67	1.65	1.51	3.83
msgs sent queue time on ksxp (ms)	34,872	9.83	5.40	4.91	0.12	4.83	5.00
msgs sent queued	113,880	32.10	17.65	16.05	3.44	13.62	18.48
msgs sent queued on ksxp	132,217	37.27	20.49	18.64	0.68	18.16	19.11
process batch messages received	28,500	8.03	4.42	4.02	0.11	3.94	4.09
process batch messages sent	29,675	8.37	4.60	4.18	0.06	4.14	4.22

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	228	206	451	402	89,306,031	89,315,329
2	226	208	467	429	24,899,557	24,902,899
Sum	454	414	918	831	114,205,588	114,218,228
Avg	227	207	459	416	57,102,794	57,109,114
Std	1	1	11	19	45,542,255	45,546,466

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.05	0.02	0.00	0.03	0.01	0.00	0.01	4.09	1.91	0.00	4.59	0.51	0.00	3.07
2	0.42	0.02	0.36	0.03	0.00	0.00	0.00	4.63	2.05	0.74	3.96	0.38	0.00	2.57
Sum	0.47	0.04	0.36	0.05	0.01	0.00	0.01	8.72	3.95	0.74	8.55	0.89	0.00	5.64
Avg	0.23	0.02	0.18	0.03	0.00	0.00	0.00	4.36	1.98	0.37	4.28	0.44	0.00	2.82

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.05	0.02	0.00	0.03	0.01	0.00	0.01	4.09	1.91	0.00	4.59	0.51	0.00	3.07
2	0.42	0.39	0.00	0.03	0.00	0.00	0.00	4.63	2.79	0.00	3.96	0.39	0.00	2.57
Sum	0.47	0.40	0.00	0.05	0.01	0.00	0.01	8.72	4.69	0.00	8.55	0.89	0.00	5.63
Avg	0.23	0.20	0.00	0.03	0.00	0.00	0.00	4.36	2.35	0.00	4.28	0.45	0.00	2.82

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 98.8% of Total Logical Reads: 74,011,516
Captured Segments account for 108.1% of Total Physical Reads: 403,551
Captured Segments account for 94.6% of Total Physical Read Requests: 40,374
Captured Segments account for 94.6% of Total UnOptimized Read Requests: 40,374
Captured Segments account for 0.0% of Total Optimized Read Requests: 1
Captured Segments account for 100.0% of Total Direct Physical Reads: 340,817
Captured Segments account for 30.2% of Total Physical Writes: 8,497
Captured Segments account for 33.2% of Total Physical Write Requests: 6,545
Captured Segments account for 53.8% of Total Direct Physical Writes: 39
Captured Segments account for 75.2% of Total Table Scans: 9,460
Captured Segments account for 79.7% of Total CR Blocks Received: 5,299
Captured Segments account for 91.7% of Total Current Blocks Received: 28,455
Captured Segments account for 79.8% of Total CR Blocks Served: 5,294
Captured Segments account for 91.6% of Total Current Blocks Served: 28,471

Statistic	Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Value	%Total	%Capture
buffer busy waits	WASYS3_SXGJJ	WASYS3	GD_DK_ZZ		TABLE	35		54.69
buffer busy waits	WASYS3_SXGJJ	WASYS3	GD_DK_TX_ZZ		TABLE	18		28.13
buffer busy waits	WADASX	WADASX	EF_DAJBXX		TABLE	4		6.25
buffer busy waits	SYS	SYSTEM	AUD$		TABLE	2		3.13
buffer busy waits	SYS	SYSTEM	SEG$		TABLE	1		1.56
buffer busy waits	WADASX	WADASX	EF_JNML_FILE		TABLE	1		1.56
buffer busy waits	WASYS3_SXGJJ	WASYS3	IDX_SOURCE_DATAID		INDEX	1		1.56
buffer busy waits	WASYS3_SXGJJ	WASYS3	GZ_GR_HB		TABLE	1		1.56
buffer busy waits	WASYS3_SXGJJ	WASYS3	GZ_GR_ZZ		TABLE	1		1.56
db block changes	SYS	SYSTEM	AUD$		TABLE	6,880		30.13
db block changes	WASYS3_SXGJJ	WASYS3	T_MK_SYS_MESSAGES		TABLE	5,264		23.06
db block changes	WASYS3_SXGJJ	TEMP	TMP_LXJS_BJ		INDEX	4,032		17.66
db block changes	WASYS3_SXGJJ	WASYS3	IDX_SOURCE_DATAID		INDEX	3,968		17.38
db block changes	SYS	SYSTEM	COL_USAGE$		TABLE	2,688		11.77
gc buffer busy	WASYS3_SXGJJ	WASYS3	CW_GR_PZ		TABLE	8		42.11
gc buffer busy	SYS	SYSTEM	AUD$		TABLE	4		21.05
gc buffer busy	WASYS3_SXGJJ	WASYS3	PK_GZ_GR_FZ		INDEX	2		10.53
gc buffer busy	WASYS3_SXGJJ	WASYS3	GZ_GR_HB		TABLE	2		10.53
gc buffer busy	WASYS3_SXGJJ	WASYS3	GZ_GR_HBJ		TABLE	2		10.53
gc buffer busy	WASYS3_SXGJJ	WASYS3	GZ_GR_ZZ		TABLE	1		5.26
gc cr blocks received	SYS	SYSTEM	SYS_FBA_BARRIERSCN		TABLE	710	13.40	28.45
gc cr blocks received	WASYS3_SXGJJ	WASYS3	T_MK_SYS_MESSAGES		TABLE	541	10.21	21.67
gc cr blocks received	WASYS3_SXGJJ	WASYS3	GZ_GR_ZZ		TABLE	447	8.44	17.91
gc cr blocks received	WASYS3_SXGJJ	WASYS3	GD_DK_ZZ		TABLE	420	7.93	16.83
gc cr blocks received	CACTI	OPTSOMETHING	MH_SYS_MON_STAT		TABLE	378	7.13	15.14
gc cr blocks served	SYS	SYSTEM	SYS_FBA_BARRIERSCN		TABLE	710	13.41	28.45
gc cr blocks served	WASYS3_SXGJJ	WASYS3	T_MK_SYS_MESSAGES		TABLE	541	10.22	21.67
gc cr blocks served	WASYS3_SXGJJ	WASYS3	GZ_GR_ZZ		TABLE	447	8.44	17.91
gc cr blocks served	WASYS3_SXGJJ	WASYS3	GD_DK_ZZ		TABLE	420	7.93	16.83
gc cr blocks served	CACTI	OPTSOMETHING	MH_SYS_MON_STAT		TABLE	378	7.14	15.14
gc cu blocks received	WASYS3_SXGJJ	WASYS3	GZ_GR_HBJ		TABLE	12,397	43.57	65.17
gc cu blocks received	WASYS3_SXGJJ	WASYS3	GZ_DW_JK		TABLE	4,025	14.15	21.16
gc cu blocks received	WASYS3_SXGJJ	WASYS3	CW_GR_PZ		TABLE	1,183	4.16	6.22
gc cu blocks received	SYS	SYSTEM	SYS_FBA_BARRIERSCN		TABLE	710	2.50	3.73
gc cu blocks received	WASYS3_SXGJJ	WASYS3	GZ_TX_TS_SJFS		TABLE	708	2.49	3.72
gc cu blocks served	WASYS3_SXGJJ	WASYS3	GZ_GR_HBJ		TABLE	12,397	43.54	65.17
gc cu blocks served	WASYS3_SXGJJ	WASYS3	GZ_DW_JK		TABLE	4,025	14.14	21.16
gc cu blocks served	WASYS3_SXGJJ	WASYS3	CW_GR_PZ		TABLE	1,183	4.16	6.22
gc cu blocks served	SYS	SYSTEM	SYS_FBA_BARRIERSCN		TABLE	710	2.49	3.73
gc cu blocks served	WASYS3_SXGJJ	WASYS3	GZ_TX_TS_SJFS		TABLE	708	2.49	3.72
logical reads	WASYS3_SXGJJ	WASYS3	GD_DK_ZZ		TABLE	19,633,616	26.53	40.67
logical reads	WADASX	WADASX	EF_DAJBXX		TABLE	12,348,752	16.68	25.58
logical reads	WASYS3_SXGJJ	WASYS3	GD_SQ_SQR_G000		INDEX	6,324,240	8.54	13.10
logical reads	WASYS3_SXGJJ	WASYS3	GD_SQ_SQR		TABLE	5,783,184	7.81	11.98
logical reads	WADASX	WADASX	EF_JNML_FILE		TABLE	4,191,072	5.66	8.68
physical reads	WASYS3_SXGJJ	WASYS3	SMS_DXDLB		TABLE	177,173	43.90	41.02
physical reads	WASYS3_SXGJJ	WASYS3	GZ_GR_HBJ		TABLE	87,662	21.72	20.30
physical reads	WASYS3_SXGJJ	WASYS3	T_WA_SYS_OPTLOG		TABLE	85,728	21.24	19.85
physical reads	WASYS3_SXGJJ	WASYS3	CW_DW_PZ		TABLE	77,910	19.31	18.04
physical reads	WASYS3_SXGJJ	WASYS3	GZ_DW_JK		TABLE	3,432	0.85	0.79
physical reads direct	WASYS3_SXGJJ	WASYS3	SMS_DXDLB		TABLE	177,172		51.99
physical reads direct	WASYS3_SXGJJ	WASYS3	T_WA_SYS_OPTLOG		TABLE	85,717		25.15
physical reads direct	WASYS3_SXGJJ	WASYS3	CW_DW_PZ		TABLE	77,910		22.86
physical read requests	WASYS3_SXGJJ	WASYS3	GZ_GR_HBJ		TABLE	25,703	63.66	74.13
physical read requests	WASYS3_SXGJJ	WASYS3	SMS_DXDLB		TABLE	2,803	6.94	8.08
physical read requests	WASYS3_SXGJJ	WASYS3	GZ_DW_JK		TABLE	2,710	6.71	7.82
physical read requests	WASYS3_SXGJJ	WASYS3	GZ_GR_HBJ_C013		INDEX	2,065	5.11	5.96
physical read requests	WASYS3_SXGJJ	WASYS3	T_WA_SYS_OPTLOG		TABLE	1,390	3.44	4.01
physical writes	WASYS3_SXGJJ	WASYS3	GZ_GR_ZZ		TABLE	229		30.99
physical writes	WASYS3_SXGJJ	WASYS3	T_MK_SYS_MESSAGES		TABLE	162		21.92
physical writes	SYS	SYSTEM	COL_USAGE$		TABLE	129		17.46
physical writes	WADASX	WADASX	EF_JNML		TABLE	124		16.78
physical writes	WASYS3_SXGJJ	WASYS3	GZ_GR_HBJ		TABLE	95		12.86
physical writes direct	SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_3015453842_17090	TABLE PARTITION	17		80.95
physical writes direct	SYS	SYSAUX	SYS_LOB0000006339C00038$$		LOB	4		19.05
physical write requests	WASYS3_SXGJJ	WASYS3	GZ_GR_ZZ		TABLE	227	3.47	32.47
physical write requests	WASYS3_SXGJJ	WASYS3	T_MK_SYS_MESSAGES		TABLE	157	2.40	22.46
physical write requests	WADASX	WADASX	EF_JNML		TABLE	118	1.80	16.88
physical write requests	SYS	SYSTEM	COL_USAGE$		TABLE	110	1.68	15.74
physical write requests	WASYS3_SXGJJ	WASYS3	CW_GR_PZ_A003		INDEX	87	1.33	12.45
row lock waits	SYS	SYSAUX	WRM$_SNAPSHOT_DETAILS_INDEX		INDEX	1		100.00
table scans	WASYS3_SXGJJ	WASYS3	IDX_YHHKZH		INDEX	3,554		49.99
table scans	WASYS3_SXGJJ	WASYS3	GD_DK_ZZ_E022		INDEX	3,551		49.94
table scans	WASYS3_SXGJJ	WASYS3	GD_SQ_SQR_G000		INDEX	4		0.06
table scans	WASYS3_SXGJJ	WASYS3	PK_GZ_GR_DCHDXX		INDEX	1		0.01

Back to I/O Statistics
Back to Top

Library Cache Activity

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

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations	GES Lock Requests	GES Pin Requests	GES Pin Releases
ACCOUNT_STATUS	852	0.00	0		0	0	852	0	0
BODY	6,255	0.00	8,343	0.01	1	0	0	8,210	8,210
CLUSTER	73	0.00	73	0.00	0	0	73	73	73
DBLINK	952	0.00	0		0	0	952	0	0
EDITION	531	0.00	1,036	0.00	0	0	531	545	545
INDEX	100	0.00	100	1.00	1	0	100	100	100
JAVA DATA	2	0.00	2	0.00	0	0	2	2	2
JAVA RESOURCE	2	50.00	2	50.00	0	0	2	2	2
JAVA SOURCE	2	0.00	2	0.00	0	0	2	2	2
QUEUE	775	0.00	1,045	0.00	0	0	360	1,045	1,045
SCHEMA	510	0.00	0		0	0	505	0	0
SQL AREA	24,195	13.50	171,689	7.36	761	282	0	0	0
SQL AREA BUILD	4,078	88.50	0		0	0	0	0	0
SQL AREA STATS	4,316	89.78	4,316	89.78	0	0	0	0	0
SUBSCRIPTION	13	0.00	13	0.00	0	0	0	13	13
TABLE/PROCEDURE	18,019	0.02	82,579	0.31	188	0	23,121	49,469	49,469
TRANSFORMATION	354	0.00	354	0.00	0	0	354	354	354
TRIGGER	1,799	0.00	1,844	0.00	0	0	2	1,844	1,844

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	4,915.00	4,915.00	3,787.85	3,816.00	1,123.41	1,065.87	1.49	1.49	0.00	0.00	491.49	491.49
2	4,915.00	4,915.00	3,798.89	3,820.37	1,098.56	1,058.71	0.00	0.00	0.00	0.00	491.49	491.49

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	855.43	816.08			3.72	3.92	7.08	7.35	58.78	58.78	58.78	58.78	230	208	230	208
1	Freeable	231.75	215.94	0.00	0.00	1.25	1.34	2.84	3.06	36.88	36.88			185	161	185	161
1	PL/SQL	58.45	57.36	14.26	12.80	0.26	0.28	2.23	2.35	33.69	33.69	33.69	33.69	229	207	229	207
1	SQL	8.79	7.49	1.69	1.41	0.04	0.04	0.10	0.10	1.17	1.17	88.13	88.13	198	176	189	166
2	Other	816.41	793.97			3.53	3.73	6.59	6.84	59.22	59.22	59.22	59.22	231	213	231	213
2	Freeable	236.13	220.94	0.00	0.00	1.38	1.45	3.40	3.60	36.88	36.88			171	152	171	152
2	PL/SQL	68.14	67.41	10.43	9.76	0.30	0.32	2.23	2.32	33.69	33.69	33.69	33.69	230	212	229	211
2	SQL	9.13	7.63	1.68	0.88	0.05	0.04	0.06	0.03	0.70	0.13	146.56	146.56	201	184	190	173

Back to Memory Statistics
Back to Top

Supplemental Information

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

init.ora Parameters

'*' indicates same value across all instances

Parameter Name	I#	Begin value
audit_file_dest	*	/oracle/oracle/admin/sxgjj/adump
audit_trail	*	DB
cluster_database	*	TRUE
compatible	*	11.2.0.0.0
control_files	*	+DATA/sxgjj/controlfile/current.260.795997971, +FASTRECOVER/sxgjj/controlfile/current.256.795997971
db_block_size	*	8192
db_create_file_dest	*	+DATA
db_domain	*
db_file_multiblock_read_count	*	64
db_name	*	sxgjj
db_recovery_file_dest	*	+FASTRECOVER
db_recovery_file_dest_size	*	96636764160
diagnostic_dest	*	/oracle/oracle
dispatchers	*	(PROTOCOL=TCP) (SERVICE=sxgjjXDB)
instance_number	1	1
instance_number	2	2
job_queue_processes	*	10
local_listener	1	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.32)(PORT=1521))))
local_listener	2	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.33)(PORT=1521))))
log_archive_dest_1	1	LOCATION=+ARCH/arch1
log_archive_dest_1	2	LOCATION=+ARCH/arch2
log_archive_format	*	arc_%t_%s_%r.log
open_cursors	*	2500
pga_aggregate_target	*	5153751040
processes	*	1000
remote_listener	*	rac-scan:1521
remote_login_passwordfile	*	EXCLUSIVE
service_names	*	sxgjj
sessions	*	1536
sga_target	*	15468593152
spfile	*	+DATA/sxgjj/spfilesxgjj.ora
thread	1	1
thread	2	2
undo_tablespace	1	UNDOTBS1
undo_tablespace	2	UNDOTBS2

Back to Supplemental Information
Back to Top

init.ora Multi-valued Parameters

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

Parameter Name	I#	Begin value	End value (if different)
control_files	*	+DATA/sxgjj/controlfile/current.260.795997971
control_files	*	+FASTRECOVER/sxgjj/controlfile/current.256.795997971

Back to Supplemental Information
Back to Top

Complete List of SQL Text

SQL Id SQL Text

048671ycd5ww1 call wasys3_sxgjj.PKG_MH_SYSMON.p_get_header ( )

0b9cd2mk761zn SELECT COUNT(*) FROM GD_DK_ZZ A WHERE NOT EXISTS(SELECT * FROM GD_DK_TX_ZZ WHERE YHHKZH=A.E022) AND P015=:B2 AND E051>=:B1

0s8yg3vq85g1q BEGIN p_gz_ywfl_cx(:1, :2, :3, :4, :5, :6); END;

11npfymrgntdm select * from (select rownum rn, a.* from (select * from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0101' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND to_char(A.TJRQ, 'yyyy-mm-dd') >= '2014-09-01' AND to_char(A.TJRQ, 'yyyy-mm-dd') <= '2014-09-19' AND TO_NUMBER(A.AJH) >= TO_NUMBER('1849') AND TO_NUMBER(A.AJH) <= TO_NUMBER('1856') order by A.SSND, TO_NUMBER(NVL(A.AJH, 9999999999999999))) where rownum<=30) a) b where b.rn>0

38bm7px768j8k select pzid, sjhm, dxnr, sffs, fszt from sms_dxdlb where sffs='0' and length(trim(sjhm))=11

3fz7dvg64qdf8 select * from (select rownum rn, a.* from (select * from (select e001 from gd_dk_zz a , gd_sq_sqr b where a.g000=b.g000 and b.g011='1' and ((upper(b.g013) like upper(:1) or decode(length(trim(b.g013)), 18, substr(b.g013, 1, 6 )||substr(b.g013, 9, 9), b.g013)=f_sfzto15(:2) ) or b.g000 in (select g000 from gd_sq_sqr where g011='2' and (upper(g013) like upper(:3) or decode(length(trim(g013)), 18, substr(g013, 1, 6 )||substr(g013, 9, 9), g013)=f_sfzto15(:4)) and g001 is not null)) and a.e043='00' order by id) where rownum<=100) a) b where b.rn>0

3rchqnwp893f4 select * from (select rownum rn, a.* from (select * from (select b.g010 as g010, j.mc as g118, i.mc as g140, c.g202, c.g203, g085, g074, g078, g080, g083, h.mc as gflx, h.bm as gflxbm, g.g071, f.g186, c.a073 , c.a075, d.mc as a076, e.mc as a074, f.id as id , a.a000 as a000 , a.g015 as g015 , a.g001 as a001 , a.g002 as a002, a.g004 as g004 , a.g000 as g000 , a.g011 as g011, a.g013 as a008, a.g003 as g003 , a.g254 as g254, b.a000 as a0002 , b.g015 as g0152 , b.g001 as a0012 , b.g002 as a0022, b.g004 as g0042 , b.g000 as g0002 , b.g011 as g0112, b.g013 as a0082, b.g003 as g0032 , b.g254 as g2542 , f.g198, f.g200, c.g539 from gd_sq_sqr a left join (select g010, g015, a000, g002, g004 , g000 , g001, g011, g013, g003, g254 from gd_sq_sqr a where g011 ='2' ) b on a.g000 = b.g000 , gd_sq_dk c, bm_a075 d , bm_a073 e , gd_sq_sh f, gd_sq_jb g, bm_g071 h , bm_dbfs i , bm_hkfs j where a.g011 ='1' and a.g000 =c.g000 and c.a075 = d.bm and e.bm = c.a073 and a.g000 = f.g000 and a.g000 = g.g000 and g.g071 = h.bm and c.a075=h.gjdbm and i.bm = c.g139 and i.gjdbm=c.a075 and j.bm = c.g118 and j.gjdbm=c.a075 and a.g000 between :1 and :2 and (a.g002 like :3 or a.g010 like :4) and a.g013 like :5 and c.a075 like :6 and c.a073 like :7 and g237 = '01' and g186 between :8 and :9 order by g000) where rownum<=20) a) b where b.rn>0

3tffqzf3wagfk SELECT NVL(SUM(P008-P009), 0) FROM CW_GR_PZ WHERE A000=:B3 AND P012 BETWEEN '01' AND '13' AND P002 BETWEEN :B2 AND :B1

3tw70y4ujxqrq SELECT NVL(SUM(P008-P009), 0)+:B3 FROM (SELECT * FROM CW_GR_PZ UNION ALL SELECT * FROM WASYS3_SXGJJ_LSND.CW_GR_PZ) WHERE A000=:B2 AND P002 <TO_DATE(:B1 ||'01', 'yyyymmdd') AND P012 BETWEEN '01' AND '13'

4vagx3sw24a7z SELECT WASYS3_GUID.NEXTVAL FROM DUAL

50z38wp0k8y7b select count(*) cnt from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0101' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND to_char(A.TJRQ, 'yyyy-mm-dd') >= '2014-09-01' AND to_char(A.TJRQ, 'yyyy-mm-dd') <= '2014-09-19' AND TO_NUMBER(A.AJH) >= TO_NUMBER('1839') AND TO_NUMBER(A.AJH) <= TO_NUMBER('1847') )

5ms6rbzdnq16t select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job

5sn8fz80rvbjr select * from (select rownum rn, a.* from (select * from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0101' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND to_char(A.TJRQ, 'yyyy-mm-dd') >= '2014-09-01' AND to_char(A.TJRQ, 'yyyy-mm-dd') <= '2014-09-19' AND TO_NUMBER(A.AJH) >= TO_NUMBER('1839') AND TO_NUMBER(A.AJH) <= TO_NUMBER('1847') order by A.SSND, TO_NUMBER(NVL(A.AJH, 9999999999999999))) where rownum<=30) a) b where b.rn>0

5ssgkcutv4qk9 select a.a003 bm, max(b.mc) mc, max(c.mc) wtmc, max(a.p001) jcyd, sum(a.p008) hjje, max(c.khyh) qyyh, max(c.yhzh) qyzh, max(a.p038) p038, max(a.sbyy) sbyy, max(e.c010) c010, a.p005 pzbh, max(a.p036) fsrq, max (case when a.p035=0 then 'δ��' when a.p035=1 then '�ѷ��δ��' when a.p035=2 then '�ɹ�' when a.p035=3 then 'ʧ��' else ' ' end) kkzt from gz_dw_jk a left join bm_a003 b on a.a003=b.bm left join gz_dw_wtxy c on a.a003=c.bm left join (select a003, nvl(sum(c010) , 0) c010, c013 from gz_gr_hbj where exists(select a001 from gz_gr_zz where a001=gz_gr_hbj.a001 and a070='03') and c004 is null group by a003, c013 ) e on e.a003=a.a003 and e.c013=a.p005 left join (select '102' yhlhh, '0021' yhbm from dual union all select '103' yhlhh, '0061' yhbm from dual union all select '105' yhlhh, '0012' yhbm from dual) f on substr(c.yhbm, 2, 2)=substr(f.yhbm, 2, 2)where a.a075 like '%0102%' and c.yhbm like '%1021%' and a.p005 is not null and a.p006 is not null and a.p012='ί��տ�' and a.p035 = '2' and a.p009 is not null and case when trim(c.yhlhh) is null then ' ' else substr(c.yhlhh, 1, 3) end <> nvl(f.yhlhh, 'null') and a.a003 between '0101001' and '0171051' and substr(a.p001, 1, 6) >= '201402' and substr(a.p001, -6)<= '201409' group by a.a003, a.p005 order by a.a003, a.p005

670das7q4yjyu select * from (select rownum rn, a.* from (select * from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0102' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND TO_NUMBER(A.AJH) >= TO_NUMBER('358') AND TO_NUMBER(A.AJH) <= TO_NUMBER('368') order by A.SSND, TO_NUMBER(NVL(A.AJH, 9999999999999999))) where rownum<=300) a) b where b.rn>0

6d9f498u2axhm select count(*) cnt, sum(g202) g202, sum(g015) g015, sum(g0152) g0152, sum(g085) g085, sum(g083) g083 from (select b.g010 as g010, j.mc as g118, i.mc as g140, c.g202, c.g203, g085, g074, g078, g080, g083, h.mc as gflx, h.bm as gflxbm, g.g071, f.g186, c.a073 , c.a075, d.mc as a076, e.mc as a074, f.id as id , a.a000 as a000 , a.g015 as g015 , a.g001 as a001 , a.g002 as a002, a.g004 as g004 , a.g000 as g000 , a.g011 as g011, a.g013 as a008, a.g003 as g003 , a.g254 as g254, b.a000 as a0002 , b.g015 as g0152 , b.g001 as a0012 , b.g002 as a0022, b.g004 as g0042 , b.g000 as g0002 , b.g011 as g0112, b.g013 as a0082, b.g003 as g0032 , b.g254 as g2542 , f.g198, f.g200, c.g539 from gd_sq_sqr a left join (select g010, g015, a000, g002, g004 , g000 , g001, g011, g013, g003, g254 from gd_sq_sqr a where g011 ='2' ) b on a.g000 = b.g000 , gd_sq_dk c, bm_a075 d , bm_a073 e , gd_sq_sh f, gd_sq_jb g, bm_g071 h , bm_dbfs i , bm_hkfs j where a.g011 ='1' and a.g000 =c.g000 and c.a075 = d.bm and e.bm = c.a073 and a.g000 = f.g000 and a.g000 = g.g000 and g.g071 = h.bm and c.a075=h.gjdbm and i.bm = c.g139 and i.gjdbm=c.a075 and j.bm = c.g118 and j.gjdbm=c.a075 and a.g000 between :1 and :2 and (a.g002 like :3 or a.g010 like :4) and a.g013 like :5 and c.a075 like :6 and c.a073 like :7 and g237 = '01' and g186 between :8 and :9 ) z

7vt1711b4uaf4 select count(*) cnt from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0102' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND TO_NUMBER(A.AJH) >= TO_NUMBER('358') AND TO_NUMBER(A.AJH) <= TO_NUMBER('368') )

9g6pks8j8brdx SELECT COUNT(*) FROM GD_DK_ZZ WHERE P015=:B1 AND E292=2

9m94fyzc4sgdm SELECT COUNT(*) FROM GD_TX_YHMX_WT WHERE YHBM=:B2 AND FHDATE IS NULL AND HKDATE>=:B1

a6vnt8j5snyc4 SELECT COUNT(*) FROM GD_DK_ZZ WHERE P015=:B1 AND E051 IS NULL AND E072=1 AND E292=0

aqh8wxctfu98y BEGIN p_gz_gr_qclr_chk(:1, :2, :3, :4); END;

bauk8nf4grax0 BEGIN p_jnml_clyx_add(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12); END;

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

cq6fuzzct18gg SELECT COUNT(*) FROM GD_DK_TX_ZZ A WHERE NOT EXISTS(SELECT * FROM GD_DK_ZZ WHERE E022=A.YHHKZH) AND YHBM=:B2 AND FFRQ>=:B1

d6kch59q9nvy0 INSERT INTO TMP_GZ_GR_MX_CX_YD(YWLSH, RQ, JFJE, DFJE, YE, JDFX, ZY, ID, DZSJ, B001, B002, B003, C001, C002, C003, A003) SELECT C013, C004, 0, C010, 0, ' ', CASE WHEN C006='01' THEN '��' ELSE CASE WHEN C006='98' THEN '��˽ɴ�' WHEN (C006='05' OR C025 LIKE '%һ��Բ��%') THEN '��һ��Բ��' WHEN C006='06' THEN '��³��ס��' ELSE '��' END END || CASE WHEN C008=C009 THEN SUBSTR(C008, 1, 4)||'��'||SUBSTR(C008, 5, 2)||'��' ELSE SUBSTR(C008, 1, 4)||'��'||SUBSTR(C008, 5, 2)||'��-'||SUBSTR(C009, 1, 4)||'��'||SUBSTR(C009, 5, 2)||'��' END, ID, C004, CASE WHEN (C006='05' OR C025 LIKE '%һ��Բ��%') THEN 0 ELSE C0101 END, CASE WHEN (C006='05' OR C025 LIKE '%һ��Բ��%') THEN C0101+C0102 ELSE C0102 END, C0103, 0, 0, 0, A003 FROM (SELECT * FROM GZ_GR_HBJ UNION ALL SELECT * FROM WASYS3_SXGJJ_LSND.GZ_GR_HBJ) WHERE A000=:B3 AND C004 BETWEEN TO_DATE(:B2 ||'01', 'yyyymmdd') AND LAST_DAY(TO_DATE(:B1 ||'01', 'yyyymmdd'))

dha5nv6urcumf select binaryDefVal, lengthb(binaryDefVal) from ecol$ where tabobj# = :1 and colnum = :2

f5yun5dynkskv select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

ftj9uawt4wwzb select condition from cdef$ where rowid=:1

g13m4qh4k07x6 BEGIN P_GZ_GR_MX_CX_YD(:1, :2, :3); END;

gdranhw0kcrd8 BEGIN p_dbsx_cx(:1 , :2 ); END;

Back to Supplemental Information
Back to Top

End of Report

SQL Id	SQL Text
048671ycd5ww1	call wasys3_sxgjj.PKG_MH_SYSMON.p_get_header ( )
0b9cd2mk761zn	SELECT COUNT() FROM GD_DK_ZZ A WHERE NOT EXISTS(SELECT FROM GD_DK_TX_ZZ WHERE YHHKZH=A.E022) AND P015=:B2 AND E051>=:B1
0s8yg3vq85g1q	BEGIN p_gz_ywfl_cx(:1, :2, :3, :4, :5, :6); END;
11npfymrgntdm	select * from (select rownum rn, a.* from (select * from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0101' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND to_char(A.TJRQ, 'yyyy-mm-dd') >= '2014-09-01' AND to_char(A.TJRQ, 'yyyy-mm-dd') <= '2014-09-19' AND TO_NUMBER(A.AJH) >= TO_NUMBER('1849') AND TO_NUMBER(A.AJH) <= TO_NUMBER('1856') order by A.SSND, TO_NUMBER(NVL(A.AJH, 9999999999999999))) where rownum<=30) a) b where b.rn>0
38bm7px768j8k	select pzid, sjhm, dxnr, sffs, fszt from sms_dxdlb where sffs='0' and length(trim(sjhm))=11
3fz7dvg64qdf8	select * from (select rownum rn, a.* from (select * from (select e001 from gd_dk_zz a , gd_sq_sqr b where a.g000=b.g000 and b.g011='1' and ((upper(b.g013) like upper(:1) or decode(length(trim(b.g013)), 18, substr(b.g013, 1, 6 )\|\|substr(b.g013, 9, 9), b.g013)=f_sfzto15(:2) ) or b.g000 in (select g000 from gd_sq_sqr where g011='2' and (upper(g013) like upper(:3) or decode(length(trim(g013)), 18, substr(g013, 1, 6 )\|\|substr(g013, 9, 9), g013)=f_sfzto15(:4)) and g001 is not null)) and a.e043='00' order by id) where rownum<=100) a) b where b.rn>0
3rchqnwp893f4	select * from (select rownum rn, a.* from (select * from (select b.g010 as g010, j.mc as g118, i.mc as g140, c.g202, c.g203, g085, g074, g078, g080, g083, h.mc as gflx, h.bm as gflxbm, g.g071, f.g186, c.a073 , c.a075, d.mc as a076, e.mc as a074, f.id as id , a.a000 as a000 , a.g015 as g015 , a.g001 as a001 , a.g002 as a002, a.g004 as g004 , a.g000 as g000 , a.g011 as g011, a.g013 as a008, a.g003 as g003 , a.g254 as g254, b.a000 as a0002 , b.g015 as g0152 , b.g001 as a0012 , b.g002 as a0022, b.g004 as g0042 , b.g000 as g0002 , b.g011 as g0112, b.g013 as a0082, b.g003 as g0032 , b.g254 as g2542 , f.g198, f.g200, c.g539 from gd_sq_sqr a left join (select g010, g015, a000, g002, g004 , g000 , g001, g011, g013, g003, g254 from gd_sq_sqr a where g011 ='2' ) b on a.g000 = b.g000 , gd_sq_dk c, bm_a075 d , bm_a073 e , gd_sq_sh f, gd_sq_jb g, bm_g071 h , bm_dbfs i , bm_hkfs j where a.g011 ='1' and a.g000 =c.g000 and c.a075 = d.bm and e.bm = c.a073 and a.g000 = f.g000 and a.g000 = g.g000 and g.g071 = h.bm and c.a075=h.gjdbm and i.bm = c.g139 and i.gjdbm=c.a075 and j.bm = c.g118 and j.gjdbm=c.a075 and a.g000 between :1 and :2 and (a.g002 like :3 or a.g010 like :4) and a.g013 like :5 and c.a075 like :6 and c.a073 like :7 and g237 = '01' and g186 between :8 and :9 order by g000) where rownum<=20) a) b where b.rn>0
3tffqzf3wagfk	SELECT NVL(SUM(P008-P009), 0) FROM CW_GR_PZ WHERE A000=:B3 AND P012 BETWEEN '01' AND '13' AND P002 BETWEEN :B2 AND :B1
3tw70y4ujxqrq	SELECT NVL(SUM(P008-P009), 0)+:B3 FROM (SELECT * FROM CW_GR_PZ UNION ALL SELECT * FROM WASYS3_SXGJJ_LSND.CW_GR_PZ) WHERE A000=:B2 AND P002 <TO_DATE(:B1 \|\|'01', 'yyyymmdd') AND P012 BETWEEN '01' AND '13'
4vagx3sw24a7z	SELECT WASYS3_GUID.NEXTVAL FROM DUAL
50z38wp0k8y7b	select count(*) cnt from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0101' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND to_char(A.TJRQ, 'yyyy-mm-dd') >= '2014-09-01' AND to_char(A.TJRQ, 'yyyy-mm-dd') <= '2014-09-19' AND TO_NUMBER(A.AJH) >= TO_NUMBER('1839') AND TO_NUMBER(A.AJH) <= TO_NUMBER('1847') )
5ms6rbzdnq16t	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
5sn8fz80rvbjr	select * from (select rownum rn, a.* from (select * from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0101' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND to_char(A.TJRQ, 'yyyy-mm-dd') >= '2014-09-01' AND to_char(A.TJRQ, 'yyyy-mm-dd') <= '2014-09-19' AND TO_NUMBER(A.AJH) >= TO_NUMBER('1839') AND TO_NUMBER(A.AJH) <= TO_NUMBER('1847') order by A.SSND, TO_NUMBER(NVL(A.AJH, 9999999999999999))) where rownum<=30) a) b where b.rn>0
5ssgkcutv4qk9	select a.a003 bm, max(b.mc) mc, max(c.mc) wtmc, max(a.p001) jcyd, sum(a.p008) hjje, max(c.khyh) qyyh, max(c.yhzh) qyzh, max(a.p038) p038, max(a.sbyy) sbyy, max(e.c010) c010, a.p005 pzbh, max(a.p036) fsrq, max (case when a.p035=0 then 'δ��' when a.p035=1 then '�ѷ��δ��' when a.p035=2 then '�ɹ�' when a.p035=3 then 'ʧ��' else ' ' end) kkzt from gz_dw_jk a left join bm_a003 b on a.a003=b.bm left join gz_dw_wtxy c on a.a003=c.bm left join (select a003, nvl(sum(c010) , 0) c010, c013 from gz_gr_hbj where exists(select a001 from gz_gr_zz where a001=gz_gr_hbj.a001 and a070='03') and c004 is null group by a003, c013 ) e on e.a003=a.a003 and e.c013=a.p005 left join (select '102' yhlhh, '0021' yhbm from dual union all select '103' yhlhh, '0061' yhbm from dual union all select '105' yhlhh, '0012' yhbm from dual) f on substr(c.yhbm, 2, 2)=substr(f.yhbm, 2, 2)where a.a075 like '%0102%' and c.yhbm like '%1021%' and a.p005 is not null and a.p006 is not null and a.p012='ί��տ�' and a.p035 = '2' and a.p009 is not null and case when trim(c.yhlhh) is null then ' ' else substr(c.yhlhh, 1, 3) end <> nvl(f.yhlhh, 'null') and a.a003 between '0101001' and '0171051' and substr(a.p001, 1, 6) >= '201402' and substr(a.p001, -6)<= '201409' group by a.a003, a.p005 order by a.a003, a.p005
670das7q4yjyu	select * from (select rownum rn, a.* from (select * from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0102' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND TO_NUMBER(A.AJH) >= TO_NUMBER('358') AND TO_NUMBER(A.AJH) <= TO_NUMBER('368') order by A.SSND, TO_NUMBER(NVL(A.AJH, 9999999999999999))) where rownum<=300) a) b where b.rn>0
6d9f498u2axhm	select count(*) cnt, sum(g202) g202, sum(g015) g015, sum(g0152) g0152, sum(g085) g085, sum(g083) g083 from (select b.g010 as g010, j.mc as g118, i.mc as g140, c.g202, c.g203, g085, g074, g078, g080, g083, h.mc as gflx, h.bm as gflxbm, g.g071, f.g186, c.a073 , c.a075, d.mc as a076, e.mc as a074, f.id as id , a.a000 as a000 , a.g015 as g015 , a.g001 as a001 , a.g002 as a002, a.g004 as g004 , a.g000 as g000 , a.g011 as g011, a.g013 as a008, a.g003 as g003 , a.g254 as g254, b.a000 as a0002 , b.g015 as g0152 , b.g001 as a0012 , b.g002 as a0022, b.g004 as g0042 , b.g000 as g0002 , b.g011 as g0112, b.g013 as a0082, b.g003 as g0032 , b.g254 as g2542 , f.g198, f.g200, c.g539 from gd_sq_sqr a left join (select g010, g015, a000, g002, g004 , g000 , g001, g011, g013, g003, g254 from gd_sq_sqr a where g011 ='2' ) b on a.g000 = b.g000 , gd_sq_dk c, bm_a075 d , bm_a073 e , gd_sq_sh f, gd_sq_jb g, bm_g071 h , bm_dbfs i , bm_hkfs j where a.g011 ='1' and a.g000 =c.g000 and c.a075 = d.bm and e.bm = c.a073 and a.g000 = f.g000 and a.g000 = g.g000 and g.g071 = h.bm and c.a075=h.gjdbm and i.bm = c.g139 and i.gjdbm=c.a075 and j.bm = c.g118 and j.gjdbm=c.a075 and a.g000 between :1 and :2 and (a.g002 like :3 or a.g010 like :4) and a.g013 like :5 and c.a075 like :6 and c.a073 like :7 and g237 = '01' and g186 between :8 and :9 ) z
7vt1711b4uaf4	select count(*) cnt from (SELECT A.ID AS ID, A.YGDH AS YGDH, B.ZGXM AS ZGXM, B.XB AS XB, B.ZJHM AS ZJHM, B.DW AS DW, A.GH AS GH, A.HH AS HH, A.BCNX AS BCNX, A.BMJB AS BMJB, A.CLFS AS CLFS, B.CBWD AS CBWD, B.GJD AS GJD, A.TJR AS TJR, to_char(A.TJRQ, 'yyyy-mm-dd') AS TJRQ, B.FKYH AS FKYH, to_char(A.QRQ, 'yyyy-mm-dd') AS QRQ, to_char(A.ZRQ, 'yyyy-mm-dd') AS ZRQ, to_char(B.FKRQ, 'yyyy-mm-dd') AS FKRQ, B.DKNX AS DKNX, B.GFLX AS GFLX, B.GFXXDZ AS GFXXDZ, B.DKJE, B.GJDBM, B.CBWDBM, A.F_CREATOR_NAME, A.F_CREATE_TIME, A.YWSXBH, A.SXH, C.F_TYPE AS F_TYPE, A.F_TYPE AS F_TYPEB, A.YWLSH AS YWLSH , A.GLBH, A.TM, B.AJH, A.ML, A.ML1, A.ML2, A.BGQX, A.SSND, A.JCR, A.LJR, A.YS AS AJYS, A.JS, to_char(A.JSRQ, 'yyyy-mm-dd') AS JSRQ , A.BZ, B.ZRZ, B.TM AS TM1, B.YS, B.RQ, B.DWBM, B.XH, B.MCOSFZH, B.TXT, A.F_GJD_CAPTION, A.F_GJD_CODES, B.POZH, B.POXM, B.POZJHM, B.PODWZH, B.PODW, B.DKJQZT, to_char(B.DKJQRQ, 'yyyy-mm-dd') DKJQRQ, to_char(B.DKSQRQ, 'yyyy-mm-dd') DKSQRQ, to_char(B.DKSPRQ, 'yyyy-mm-dd') DKSPRQ FROM EF_DAJBXX A, EF_DKDA B, EF_DALX C WHERE (A.F_STATE='Ԥ�鵵' and A.F_TYPE='4' AND A.F_GJD_CODES LIKE '0102' and A.YGDH=B.YGDH and A.YWLSH=B.YWLSH and C.ID=A.F_TYPE) AND TO_NUMBER(A.AJH) >= TO_NUMBER('358') AND TO_NUMBER(A.AJH) <= TO_NUMBER('368') )
9g6pks8j8brdx	SELECT COUNT(*) FROM GD_DK_ZZ WHERE P015=:B1 AND E292=2
9m94fyzc4sgdm	SELECT COUNT(*) FROM GD_TX_YHMX_WT WHERE YHBM=:B2 AND FHDATE IS NULL AND HKDATE>=:B1
a6vnt8j5snyc4	SELECT COUNT(*) FROM GD_DK_ZZ WHERE P015=:B1 AND E051 IS NULL AND E072=1 AND E292=0
aqh8wxctfu98y	BEGIN p_gz_gr_qclr_chk(:1, :2, :3, :4); END;
bauk8nf4grax0	BEGIN p_jnml_clyx_add(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12); END;
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cq6fuzzct18gg	SELECT COUNT() FROM GD_DK_TX_ZZ A WHERE NOT EXISTS(SELECT FROM GD_DK_ZZ WHERE E022=A.YHHKZH) AND YHBM=:B2 AND FFRQ>=:B1
d6kch59q9nvy0	INSERT INTO TMP_GZ_GR_MX_CX_YD(YWLSH, RQ, JFJE, DFJE, YE, JDFX, ZY, ID, DZSJ, B001, B002, B003, C001, C002, C003, A003) SELECT C013, C004, 0, C010, 0, ' ', CASE WHEN C006='01' THEN '��' ELSE CASE WHEN C006='98' THEN '��˽ɴ�' WHEN (C006='05' OR C025 LIKE '%һ��Բ��%') THEN '��һ��Բ��' WHEN C006='06' THEN '��³��ס��' ELSE '��' END END \|\| CASE WHEN C008=C009 THEN SUBSTR(C008, 1, 4)\|\|'��'\|\|SUBSTR(C008, 5, 2)\|\|'��' ELSE SUBSTR(C008, 1, 4)\|\|'��'\|\|SUBSTR(C008, 5, 2)\|\|'��-'\|\|SUBSTR(C009, 1, 4)\|\|'��'\|\|SUBSTR(C009, 5, 2)\|\|'��' END, ID, C004, CASE WHEN (C006='05' OR C025 LIKE '%һ��Բ��%') THEN 0 ELSE C0101 END, CASE WHEN (C006='05' OR C025 LIKE '%һ��Բ��%') THEN C0101+C0102 ELSE C0102 END, C0103, 0, 0, 0, A003 FROM (SELECT * FROM GZ_GR_HBJ UNION ALL SELECT * FROM WASYS3_SXGJJ_LSND.GZ_GR_HBJ) WHERE A000=:B3 AND C004 BETWEEN TO_DATE(:B2 \|\|'01', 'yyyymmdd') AND LAST_DAY(TO_DATE(:B1 \|\|'01', 'yyyymmdd'))
dha5nv6urcumf	select binaryDefVal, lengthb(binaryDefVal) from ecol$ where tabobj# = :1 and colnum = :2
f5yun5dynkskv	select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
ftj9uawt4wwzb	select condition from cdef$ where rowid=:1
g13m4qh4k07x6	BEGIN P_GZ_GR_MX_CX_YD(:1, :2, :3); END;
gdranhw0kcrd8	BEGIN p_dbsx_cx(:1 , :2 ); END;