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
209455103	PROD	YES	8192	5680	5681	2	2	2	2	0.94	59.63

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	prod1	rac1	22-Mar-13 19:48	19-Jun-13 08:00	19-Jun-13 09:00	10.2.0.5.0	59.62	0.75	2,125.19	0.01
2	prod2	rac2	30-May-13 07:35	19-Jun-13 08:00	19-Jun-13 09:00	10.2.0.5.0	59.62	0.19	481.41	0.00

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		12,288	10,096	2,064	48	192		4,818	13.54
2		12,288	10,224	1,920	96	96		4,818	13.54
Avg		12,288	10,160	1,992	72	144		4,818	13.54
Min		12,288	10,096	1,920	48	96		4,818	13.54
Max		12,288	10,224	2,064	96	192		4,818	13.54

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 Sckts	Load Begin	Load End	% Busy	% Usr	% Sys	% WIO	% Idl	Busy Time (s)	Idle Time (s)	Total Time (s)	Memory (M)
1	24	2	0.08	0.09	0.10	0.06	0.04	0.02	99.90	89.81	85,752.86	85,842.67	64,433.82
2	24	2	0.04	0.04	0.08	0.05	0.03	0.01	99.92	70.14	85,782.18	85,852.32	64,433.82
Sum										159.95	171,535.04	171,694.99

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	45.16	15.60	13.73	0.39	0.02	1.38	232.90	5.87
2	11.21	4.86	2.43	0.09	0.03	0.10	182.77	4.48
Sum	56.37	20.45	16.16	0.49	0.05	1.48	415.66	10.34
Avg	28.19	10.23	8.08	0.24	0.03	0.74	207.83	5.17
Std	24.01	7.59	7.99	0.21	0.00	0.90	35.45	0.98

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	80.11	34.54	30.40	0.87	0.05	56.03	2.52
2	19.89	43.32	21.70	0.83	0.23	43.97	2.45
Avg	50.00	38.93	26.05	0.85	0.14	50.00	2.48

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
	0.19	1.25	120.80	0.08	61.24	0.11	-0.00	0.02	9.13	36.28

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	0.10	0.54	47.91	0.04	28.94	0.03		0.06	2.40	15.60	45.16
2	0.01	0.16	20.19	0.00	5.59	0.03	-0.00	-0.05	2.74	4.86	11.21
Sum	0.11	0.70	68.10	0.04	34.52	0.06	-0.00	0.01	5.15	20.45	56.37
Avg	0.05	0.35	34.05	0.02	17.26	0.03	-0.00	0.01	2.57	10.23	28.19
Std	0.06	0.27	19.60	0.03	16.51	0.00		0.08	0.24	7.59	24.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Classes - % of DB time

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

I#	User I/O	Sys I/O	Other	Applic	Commit	Network	Concurcy	Config	Cluster	DB CPU	% Total DB time
1	0.22	1.19	106.09	0.09	64.07	0.07		0.14	5.32	34.54	80.11
2	0.07	1.46	180.06	0.00	49.82	0.25	-0.00	-0.44	24.47	43.32	19.89
Avg	0.14	1.33	143.07	0.05	56.95	0.16	-0.00	-0.15	14.89	38.93

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)
*	Network	LGWR wait on LNS	2,868	0.03	56.54	19.71	100.30	19.42	18.59	20.25	1.17	2
	Other	LGWR-LNS wait on channel	7,045	54.55	56.50	8.02	100.22	8.00	7.94	8.05	0.08	2
	Network	LNS wait on SENDREQ	2,868	0.00	56.44	19.68	100.11	19.39	18.56	20.21	1.17	2
	Commit	log file sync	1,497	2.27	34.52	23.06	61.24	22.19	20.84	23.54	1.91	2
		DB CPU			20.45		36.28					2
	Other	reliable message	692	0.58	6.27	9.06	11.12	7.08	1.19	12.98	8.34	2
	System I/O	control file sequential read	24,224	0.00	6.05	0.25	10.72	0.25	0.23	0.26	0.02	2
	System I/O	control file parallel write	2,421	0.00	5.26	2.17	9.34	2.18	1.94	2.42	0.34	2
	System I/O	log file parallel write	2,868	0.00	5.16	1.80	9.16	1.86	1.70	2.01	0.22	2
	Other	gcs log flush sync	364	9.34	4.37	12.00	7.75	12.12	11.22	13.01	1.26	2
1	Network	LGWR wait on LNS	1,941	0.00	39.30	20.25	87.03
	Other	LGWR-LNS wait on channel	4,877	55.10	39.28	8.05	86.97
	Network	LNS wait on SENDREQ	1,941	0.00	39.23	20.21	86.87
	Commit	log file sync	1,229	2.60	28.94	23.54	64.07
		DB CPU			15.60		34.54
	Other	reliable message	462	0.87	6.00	12.98	13.28
	System I/O	control file sequential read	13,246	0.00	3.48	0.26	7.71
	System I/O	log file parallel write	1,941	0.00	3.30	1.70	7.31
	System I/O	control file parallel write	1,231	0.00	2.38	1.94	5.28
	Other	gcs log flush sync	157	10.19	2.04	13.01	4.52
2	Network	LGWR wait on LNS	927	0.11	17.24	18.59	153.75
	Other	LGWR-LNS wait on channel	2,168	53.32	17.22	7.94	153.61
	Network	LNS wait on SENDREQ	927	0.00	17.20	18.56	153.45
	Commit	log file sync	268	0.75	5.59	20.84	49.82
		DB CPU			4.86		43.32
	System I/O	control file parallel write	1,190	0.00	2.88	2.42	25.68
	System I/O	control file sequential read	10,978	0.00	2.57	0.23	22.88
	Other	gcs log flush sync	207	8.70	2.32	11.22	20.72
	System I/O	log file parallel write	927	0.00	1.86	2.01	16.62
	Cluster	gc cr block busy	93	0.00	1.85	19.88	16.49

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)
*	System I/O	RMAN backup & recovery I/O	791,126	0.00	2,876.15	3.64	6368.52	3.64	3.64	3.64		1
	Configuration	log file switch completion	2,137	61.44	1,512.96	707.98	2683.80	747.47	703.31	791.64	62.46	2
	Other	Streams AQ: qmn coordinator waiting for slave to start	103	95.15	535.13	5195.43	949.26	4978.08	4679.58	5276.58	422.14	2
	System I/O	log file sequential read	33,918	0.00	455.10	13.42	807.29	68.49	5.97	131.01	88.41	2
	Other	enq: TH - metric threshold evaluation	154	94.81	437.94	2843.74	776.84	1431.25	0.18	2862.32	2023.84	2
	Other	log switch/archive	130	0.00	422.78	3252.15	936.14	3252.15	3252.15	3252.15		1
	Cluster	gc cr failure	263	91.63	368.81	1402.32	654.22	703.92	0.17	1407.67	995.25	2
	Administrative	switch logfile command	161	1.24	231.25	1436.33	512.04	1436.33	1436.33	1436.33		1
	Cluster	gc current retry	199	97.49	200.57	1007.89	444.11	1007.89	1007.89	1007.89		1
	Cluster	gc cr disk read	917,836	0.00	178.23	0.19	316.16	0.19	0.19	0.20	0.00	2
1	System I/O	RMAN backup & recovery I/O	791,126	0.00	2,876.15	3.64	6368.52
	Configuration	log file switch completion	2,024	61.07	1,423.50	703.31	3151.99
	Other	Streams AQ: qmn coordinator waiting for slave to start	89	96.63	469.62	5276.58	1039.85
	Other	enq: TH - metric threshold evaluation	153	95.42	437.94	2862.32	969.70
	Other	log switch/archive	130	0.00	422.78	3252.15	936.14
	Cluster	gc cr failure	262	91.98	368.81	1407.67	816.64
	Administrative	switch logfile command	161	1.24	231.25	1436.33	512.04
	Cluster	gc current retry	199	97.49	200.57	1007.89	444.11
	System I/O	log file sequential read	31,898	0.00	190.47	5.97	421.74
	Other	enq: TC - contention	520	43.46	128.71	247.51	284.99
2	System I/O	log file sequential read	2,020	0.00	264.63	131.01	2360.33
	Cluster	gc cr disk read	612,161	0.00	118.48	0.19	1056.75
	Configuration	log file switch completion	113	68.14	89.45	791.64	797.88
	Other	Streams AQ: qmn coordinator waiting for slave to start	14	85.71	65.51	4679.58	584.34
	Other	name-service call wait	514	2.72	41.03	79.83	366.01
	Other	LGWR-LNS wait on channel	2,168	53.32	17.22	7.94	153.61
	Other	ARCH wait on c/f tx acquire 2	9	100.00	8.80	977.57	78.47
	Other	ASM background starting	4	75.00	5.91	1476.55	52.68
	Commit	log file sync	268	0.75	5.59	20.84	49.82
	Other	Wait on stby instance close	5	100.00	4.89	977.38	43.59

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)
*	Other	events in waitclass Other	87,450	92.09	67.48	0.77	16.23	0.76	0.48	1.04	0.40	2
	Network	LGWR wait on LNS	2,869	0.03	56.57	19.72	13.61	19.43	18.60	20.25	1.16	2
	Network	LNS wait on SENDREQ	2,868	0.00	56.42	19.67	13.57	19.38	18.57	20.20	1.15	2
		background cpu time			10.34		2.49					2
	System I/O	control file sequential read	21,190	0.00	5.34	0.25	1.29	0.25	0.23	0.27	0.03	2
	System I/O	control file parallel write	2,421	0.00	5.26	2.17	1.27	2.18	1.94	2.42	0.34	2
	System I/O	log file parallel write	2,868	0.00	5.16	1.80	1.24	1.85	1.70	2.01	0.22	2
	Concurrency	os thread startup	90	0.00	1.73	19.28	0.42	19.49	19.09	19.88	0.55	2
	Cluster	gc cr block 2-way	567	0.00	0.13	0.23	0.03	0.22	0.22	0.23	0.01	2
	Cluster	gc current block 2-way	421	0.00	0.10	0.23	0.02	0.23	0.22	0.23	0.01	2
1	Other	events in waitclass Other	45,948	89.48	47.75	1.04	20.50
	Network	LGWR wait on LNS	1,941	0.00	39.30	20.25	16.88
	Network	LNS wait on SENDREQ	1,940	0.00	39.19	20.20	16.83
		background cpu time			5.87		2.52
	System I/O	log file parallel write	1,940	0.00	3.30	1.70	1.42
	System I/O	control file sequential read	10,800	0.00	2.94	0.27	1.26
	System I/O	control file parallel write	1,231	0.00	2.38	1.94	1.02
	Concurrency	os thread startup	21	0.00	0.42	19.88	0.18
	Cluster	gc buffer busy	1	0.00	0.05	53.71	0.02
	Cluster	gc cr block 2-way	210	0.00	0.05	0.22	0.02
2	Other	events in waitclass Other	41,502	94.99	19.73	0.48	10.80
	Network	LGWR wait on LNS	928	0.11	17.26	18.60	9.45
	Network	LNS wait on SENDREQ	928	0.00	17.23	18.57	9.43
		background cpu time			4.48		2.45
	System I/O	control file parallel write	1,190	0.00	2.88	2.42	1.58
	System I/O	control file sequential read	10,390	0.00	2.40	0.23	1.31
	System I/O	log file parallel write	928	0.00	1.86	2.01	1.02
	Concurrency	os thread startup	69	0.00	1.32	19.09	0.72
	Cluster	gc cr block 2-way	357	0.00	0.08	0.23	0.05
	Cluster	gc cr block busy	2	0.00	0.07	32.61	0.04

Back to Wait Events Statistics
Back to Top

Global Activity Load Profile

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

System Statistics

I#	Logical Reads	Physical Reads	Physical Writes	Redo Size (k)	Block Changes	User Calls	Execs	Parses	Logons	Txns
1	1,739,749	320	8,575	14,384	92,938	25,199	35,804	13,552	261	2,061
2	302,690	60	723	1,707	7,349	5,696	6,889	3,241	222	411
Sum	2,042,439	380	9,298	16,090	100,287	30,895	42,693	16,793	483	2,472
Avg	1,021,220	190	4,649	8,045	50,144	15,448	21,347	8,397	242	1,236
Std	1,016,154	184	5,552	8,964	60,521	13,791	20,446	7,291	28	1,167

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	486.32	0.09	2.40	4.02	25.98	7.04	10.01	3.79	0.07	0.58
2	84.61	0.02	0.20	0.48	2.05	1.59	1.93	0.91	0.06	0.11
Sum	570.93	0.11	2.60	4.50	28.03	8.64	11.93	4.69	0.14	0.69
Avg	285.47	0.05	1.30	2.25	14.02	4.32	5.97	2.35	0.07	0.35
Std	284.06	0.05	1.55	2.51	16.92	3.86	5.72	2.04	0.01	0.33

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	844.13	0.16	4.16	6.98	45.09	12.23	17.37	6.58	0.13
2	736.47	0.15	1.76	4.15	17.88	13.86	16.76	7.89	0.54
Avg	790.30	0.15	2.96	5.57	31.49	13.04	17.07	7.23	0.33

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	546	1,343	735	1,370	1	0	9,074	3,583	9,362	3,658	3,451	2,225	0	0
2	801	1,401	578	1,358	1	0	9,532	3,682	9,323	3,615	2,251	3,522	0	0
Sum	1,347	2,744	1,313	2,728	1	0	18,606	7,265	18,685	7,273	5,702	5,747	0	0
Avg	674	1,372	657	1,364	1	0	9,303	3,633	9,343	3,637	2,851	2,874	0	0
Std	180	41	111	8	0	0	324	70	28	30	849	917	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	0.15	0.38	0.21	0.38	0.00	0.00	2.54	1.00	2.62	1.02	0.96	0.62	0	0
2	0.22	0.39	0.16	0.38	0.00	0.00	2.66	1.03	2.61	1.01	0.63	0.98	0	0
Sum	0.38	0.77	0.37	0.76	0.00	0.00	5.20	2.03	5.22	2.03	1.59	1.61	0	0
Avg	0.19	0.38	0.18	0.38	0.00	0.00	2.60	1.02	2.61	1.02	0.80	0.80	0	0
Std	0.05	0.01	0.03	0.00	0.00	0.00	0.09	0.02	0.01	0.01	0.24	0.26	0	0

Back to Global Activity Load Profile
Back to Top

SysStat and Global Messaging (per Tx)- RAC

I#	GC Current	GC CR	GC Current	GC CR	GC	IPC	GCS Received	GES Received	GCS Sent	GES Sent	Sent Direct	Sent Indir	Lost/Tx	Fail/Tx
	Blocks Received per Tx		Blocks Served		CPU (seconds) per Tx		Messages per Transaction						GC Blks	GC CR
1	0.26	0.65	0.36	0.66	0.00	0.00	4.40	1.74	4.54	1.77	1.67	1.08	0.00	0.00
2	1.95	3.41	1.41	3.30	0.00	0.00	23.19	8.96	22.68	8.80	5.48	8.57	0.00	0.00
Avg	1.11	2.03	0.88	1.98	0.00	0.00	13.80	5.35	13.61	5.29	3.58	4.82	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.87	0.11	0.02
2	99.25	0.73	0.02

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	1.17	0.02	0.03	25.52	4.89	1.43	0.01	0.01	21.05	2.59
2	0.02	1.50	0.01	0.01	18.81	4.93	0.90	0.03	0.03	14.20	8.65

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.02	0.09	0.01	0.01	0.01	43.15	27.82	29.02
2	0.01	0.09	0.01	0.01	0.01	30.27	47.36	22.36

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,348	22	1,348	0	2	1,318	0	52	0	0	320	0	0	67	0	0	0	0	0
2	1,310	48	1,310	0	13	1,303	0	55	0	0	104	0	0	67	0	0	0	0	0
Sum	2,658	70	2,658	0	15	2,621	0	107	0	0	424	0	0	134	0	0	0	0	0
Avg	1,329	35	1,329	0	8	1,311	0	54	0	0	212	0	0	67	0	0	0	0	0
Std	27	18	27	0	8	11	0	2	0	0	153	0	0	0	0	0	0	0	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	735	100.00	0.00	0.00	0.00	0.00	19	0.00	5.26	94.74	0.00	0.00	260	82.31	17.31	0.38	0.00	0.00
2	578	100.00	0.00	0.00	0.00	0.00	50	0.00	20.00	80.00	0.00	0.00	86	86.05	13.95	0.00	0.00	0.00
Sum	1,313						69						346
Avg	657						35						173
Std	111						22						123

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,308	94.95	5.05	0.00	511	90.61	9.39	0.00
	2	others	11	100.00	0.00	0.00	7	100.00	0.00	0.00
	2	undo header	2	50.00	50.00	0.00	1	0.00	100.00	0.00
2	1	data block	1,351	95.19	4.81	0.00	764	97.51	2.49	0.00
	1	others	48	97.92	2.08	0.00	35	100.00	0.00	0.00
	1	undo header	4	75.00	25.00	0.00	3	66.67	33.33	0.00

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			1,242			463
	2	others			11			7
	2	undo header			1			0
	2	undo block			0			0
2	1	data block			1,286			745
	1	others			47			35
	1	undo header			3			2
	1	undo block			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

No data exists for this section of the report.

Back to Interconnect Stats
Back to Top

Ping Statistics

No data exists for this section of the report.

Back to Interconnect Stats
Back to Top

Interconnect Client Statistics

No data exists for this section of the report.

Back to Interconnect Stats
Back to Top

Interconnect Client Statistics (per Second)

No data exists for this section of the report.

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

No data exists for this section of the report.

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics (per Second)

No data exists for this section of the report.

Back to Interconnect Stats
Back to Top

Dynamic Remastering Statistics - per Remaster Ops

No data exists for this section of the report.

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 26.0% of Total DB Time (s): 56
Captured PL/SQL account for 7.2% of Total DB Time (s): 56

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
d24d700wvu8jv	3.93	4.02	0.00	1,175,024	0	3,192	0.00	12	0.33	0.33	0.00	97,918.67	0.00	266.00	0.00	6.96	19.65	0.00	57.53	0.00	0.00	0.03	UPDATE BS_PARKSITE SET(BERTHLE...
6gvch1xu9ca3g	1.81	1.62	0.08	46,408	248	60	0.17	60	0.03	0.03	0.00	773.47	4.13	1.00	0.00	3.21	7.92	0.79	2.27	65.26	2.99	0.14	DECLARE job BINARY_INTEGER := ...
bunssq950snhf	1.23	1.26	0.00	14	0	16	0.00	2	0.62	0.63	0.00	7.00	0.00	8.00	0.00	2.19	6.17	0.00	0.00	0.00	0.00	0.00	insert into wrh$_sga_target_ad...
8hk7xvhua40va	0.99	1.02	0.00	43,434	0	6,894	0.00	504	0.00	0.00	0.00	86.18	0.00	13.68	0.00	1.76	4.97	0.00	2.13	0.00	0.01	1.18	INSERT INTO MGMT_METRICS_RAW(C...
4xxfmvn2m75q4	0.96	0.98	0.00	0	0	24	0.00	24	0.04	0.04	0.00	0.00	0.00	1.00	0.00	1.71	4.79	0.00	0.00	0.00	0.00	0.06	/* OracleOEM / select from ...
cb75rw3w1tt0s	0.75	0.31	0.00	8,568	0	2,142	0.00	2,142	0.00	0.00	0.00	4.00	0.00	1.00	0.00	1.32	1.50	0.00	0.42	0.00	0.00	5.02	begin MGMT_JOB_ENGINE.get_sche...
84qubbrsr0kfn	0.71	0.67	0.00	251	0	790	0.06	2	0.36	0.33	0.00	125.50	0.00	395.00	0.03	1.27	3.27	0.00	0.01	0.00	1.11	0.00	insert into wrh$_latch (snap_i...
26zpagbuyygf9	0.65	0.65	0.00	0	0	0	0.00	12	0.05	0.05	0.00	0.00	0.00	0.00	0.00	1.15	3.17	0.00	0.00	0.00	0.00	0.03	/* OracleOEM */ SELECT blockin...
aykvshm7zsabd	0.42	0.42	0.00	0	0	4,998	0.00	238	0.00	0.00	0.00	0.00	0.00	21.00	0.00	0.75	2.04	0.00	0.00	0.00	0.00	0.56	select size_for_estimate, size...
gz6qtapr9u99d	0.39	0.18	0.00	0	0	12	0.00	12	0.03	0.02	0.00	0.00	0.00	1.00	0.00	0.70	0.89	0.00	0.00	0.00	0.00	0.03	/* OracleOEM */ DECLARE l_log_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time (Global)

Captured SQL account for 65.1% of Total CPU Time (s): 20
Captured PL/SQL account for 15.2% of Total CPU Time (s): 20

SQL Id	CPU (s)	IOWait (s)	Elapsed (s)	Gets	Reads	Rows	Cluster (s)	Execs	CPU (s)	IOWait (s)	Elapsed (s)	Gets	Reads	Rows	Cluster (s)	DB time	DB CPU	IO Wait	Gets	Reads	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
d24d700wvu8jv	4.02	3.93	0.00	1,175,024	0	3,192	0.00	12	0.33	0.00	0.33	97,918.67	0.00	266.00	0.00	19.65	0.00	6.96	57.53	0.00	0.00	0.03	UPDATE BS_PARKSITE SET(BERTHLE...
6gvch1xu9ca3g	1.62	1.81	0.08	46,408	248	60	0.17	60	0.03	0.00	0.03	773.47	4.13	1.00	0.00	7.92	78.69	3.21	2.27	65.26	2.99	0.14	DECLARE job BINARY_INTEGER := ...
bunssq950snhf	1.26	1.23	0.00	14	0	16	0.00	2	0.63	0.00	0.62	7.00	0.00	8.00	0.00	6.17	0.00	2.19	0.00	0.00	0.00	0.00	insert into wrh$_sga_target_ad...
8hk7xvhua40va	1.02	0.99	0.00	43,434	0	6,894	0.00	504	0.00	0.00	0.00	86.18	0.00	13.68	0.00	4.97	0.00	1.76	2.13	0.00	0.01	1.18	INSERT INTO MGMT_METRICS_RAW(C...
4xxfmvn2m75q4	0.98	0.96	0.00	0	0	24	0.00	24	0.04	0.00	0.04	0.00	0.00	1.00	0.00	4.79	0.00	1.71	0.00	0.00	0.00	0.06	/* OracleOEM / select from ...
84qubbrsr0kfn	0.67	0.71	0.00	251	0	790	0.06	2	0.33	0.00	0.36	125.50	0.00	395.00	0.03	3.27	0.00	1.27	0.01	0.00	1.11	0.00	insert into wrh$_latch (snap_i...
26zpagbuyygf9	0.65	0.65	0.00	0	0	0	0.00	12	0.05	0.00	0.05	0.00	0.00	0.00	0.00	3.17	0.00	1.15	0.00	0.00	0.00	0.03	/* OracleOEM */ SELECT blockin...
aykvshm7zsabd	0.42	0.42	0.00	0	0	4,998	0.00	238	0.00	0.00	0.00	0.00	0.00	21.00	0.00	2.04	0.00	0.75	0.00	0.00	0.00	0.56	select size_for_estimate, size...
91h2x42zqagcm	0.37	0.39	0.00	21,776	0	7,041	0.00	7,041	0.00	0.00	0.00	3.09	0.00	1.00	0.00	1.82	0.00	0.69	1.07	0.00	0.00	16.49	UPDATE MGMT_CURRENT_METRICS SE...
2b064ybzkwf1y	0.34	0.33	0.00	3,332	0	0	0.00	118	0.00	0.00	0.00	28.24	0.00	0.00	0.00	1.66	0.00	0.59	0.16	0.00	0.00	0.28	BEGIN EMD_NOTIFICATION.QUEUE_R...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Time (Global)

Captured SQL account for 22.8% of Total User I/O Wait Time (s): 0
Captured PL/SQL account for 78.7% of Total User I/O Wait Time (s): 0

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
6gvch1xu9ca3g	0.08	1.81	1.62	46,408	248	60	0.17	60	0.00	0.03	0.03	773.47	4.13	1.00	0.00	78.69	3.21	7.92	2.27	65.26	2.99	0.14	DECLARE job BINARY_INTEGER := ...
26zpagbuyygf9	0.00	0.65	0.65	0	0	0	0.00	12	0.00	0.05	0.05	0.00	0.00	0.00	0.00	0.00	1.15	3.17	0.00	0.00	0.00	0.03	/* OracleOEM */ SELECT blockin...
2b064ybzkwf1y	0.00	0.33	0.34	3,332	0	0	0.00	118	0.00	0.00	0.00	28.24	0.00	0.00	0.00	0.00	0.59	1.66	0.16	0.00	0.00	0.28	BEGIN EMD_NOTIFICATION.QUEUE_R...
4xxfmvn2m75q4	0.00	0.96	0.98	0	0	24	0.00	24	0.00	0.04	0.04	0.00	0.00	1.00	0.00	0.00	1.71	4.79	0.00	0.00	0.00	0.06	/* OracleOEM / select from ...
84qubbrsr0kfn	0.00	0.71	0.67	251	0	790	0.06	2	0.00	0.36	0.33	125.50	0.00	395.00	0.03	0.00	1.27	3.27	0.01	0.00	1.11	0.00	insert into wrh$_latch (snap_i...
8hk7xvhua40va	0.00	0.99	1.02	43,434	0	6,894	0.00	504	0.00	0.00	0.00	86.18	0.00	13.68	0.00	0.00	1.76	4.97	2.13	0.00	0.01	1.18	INSERT INTO MGMT_METRICS_RAW(C...
91h2x42zqagcm	0.00	0.39	0.37	21,776	0	7,041	0.00	7,041	0.00	0.00	0.00	3.09	0.00	1.00	0.00	0.00	0.69	1.82	1.07	0.00	0.00	16.49	UPDATE MGMT_CURRENT_METRICS SE...
aykvshm7zsabd	0.00	0.42	0.42	0	0	4,998	0.00	238	0.00	0.00	0.00	0.00	0.00	21.00	0.00	0.00	0.75	2.04	0.00	0.00	0.00	0.56	select size_for_estimate, size...
bunssq950snhf	0.00	1.23	1.26	14	0	16	0.00	2	0.00	0.62	0.63	7.00	0.00	8.00	0.00	0.00	2.19	6.17	0.00	0.00	0.00	0.00	insert into wrh$_sga_target_ad...
d24d700wvu8jv	0.00	3.93	4.02	1,175,024	0	3,192	0.00	12	0.00	0.33	0.33	97,918.67	0.00	266.00	0.00	0.00	6.96	19.65	57.53	0.00	0.00	0.03	UPDATE BS_PARKSITE SET(BERTHLE...

Back to SQL Statistics
Back to Top

SQL ordered by Gets (Global)

Total Buffer Gets: 2,042,439
Captured SQL account for 70.7% 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
d24d700wvu8jv	1,175,024	0	3.93	4.02	0.00	3,192	0.00	12	97,918.67	0.00	0.33	0.33	0.00	266.00	0.00	57.53	0.00	6.96	19.65	0.00	0.00	0.03	UPDATE BS_PARKSITE SET(BERTHLE...
6gvch1xu9ca3g	46,408	248	1.81	1.62	0.08	60	0.17	60	773.47	4.13	0.03	0.03	0.00	1.00	0.00	2.27	65.26	3.21	7.92	78.69	2.99	0.14	DECLARE job BINARY_INTEGER := ...
8hk7xvhua40va	43,434	0	0.99	1.02	0.00	6,894	0.00	504	86.18	0.00	0.00	0.00	0.00	13.68	0.00	2.13	0.00	1.76	4.97	0.00	0.01	1.18	INSERT INTO MGMT_METRICS_RAW(C...
6tw8sy94yu07v	32,585	0	0.20	0.20	0.00	37	0.00	37	880.68	0.00	0.01	0.01	0.00	1.00	0.00	1.60	0.00	0.35	0.98	0.00	0.00	0.09	INSERT INTO CG_BERTHTRACE(BERT...
6yz0qmw5ccwyt	25,014	0	0.16	0.16	0.00	1,308	0.00	12	2,084.50	0.00	0.01	0.01	0.00	109.00	0.00	1.22	0.00	0.28	0.78	0.00	0.00	0.03	UPDATE BS_PARKINGLOT SET(BERTH...
91h2x42zqagcm	21,776	0	0.39	0.37	0.00	7,041	0.00	7,041	3.09	0.00	0.00	0.00	0.00	1.00	0.00	1.07	0.00	0.69	1.82	0.00	0.00	16.49	UPDATE MGMT_CURRENT_METRICS SE...
f787fyhjmkp61	19,233	0	0.33	0.31	0.00	68	0.04	68	282.84	0.00	0.00	0.00	0.00	1.00	0.00	0.94	0.00	0.58	1.53	0.00	0.67	0.16	INSERT INTO MGMT_SEVERITY(ACTI...
12htg4r7zbtun	18,982	0	0.08	0.08	0.00	52	0.00	52	365.04	0.00	0.00	0.00	0.00	1.00	0.00	0.93	0.00	0.14	0.38	0.00	0.02	0.12	UPDATE BS_BERTH SET CURRUUID =...
6c8afgvwrvrk3	15,288	0	0.09	0.09	0.00	342	0.00	42	364.00	0.00	0.00	0.00	0.00	8.14	0.00	0.75	0.00	0.17	0.46	0.00	0.00	0.10	SELECT SITEID, BERTHNO, CURRUU...
072t81cu41xfj	13,652	0	0.14	0.15	0.00	34	0.00	34	401.53	0.00	0.00	0.00	0.00	1.00	0.00	0.67	0.00	0.25	0.72	0.00	0.00	0.08	SELECT DECODE(COUNT(*), 0, 1, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads (Global)

Total Disk Reads: 380
Captured SQL account for 37.9% of Total

SQL Id	Reads	Gets	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Execs	Reads	Gets	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Reads	Gets	DB time	DB CPU	IO Wait	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
6gvch1xu9ca3g	248	46,408	1.81	1.62	0.08	60	0.17	60	4.13	773.47	0.03	0.03	0.00	1.00	0.00	65.26	2.27	3.21	7.92	78.69	2.99	0.14	DECLARE job BINARY_INTEGER := ...
c4nhd1ntptxq7	116	234	0.04	0.02	0.01	4	0.01	230	0.50	1.02	0.00	0.00	0.00	0.02	0.00	30.53	0.01	0.07	0.10	12.19	0.19	0.54	select message_level, sequence...
8ca8v2jk772ps	28	498	0.19	0.08	0.01	0	0.12	12	2.33	41.50	0.02	0.01	0.00	0.00	0.01	7.37	0.02	0.34	0.40	10.66	2.08	0.03	DELETE MGMT_METRICS_1DAY WHERE...
00prz3j9n4gyj	0	783	0.12	0.12	0.00	1,137	0.00	12	0.00	65.25	0.01	0.01	0.00	94.75	0.00	0.00	0.04	0.20	0.58	0.00	0.01	0.03	SELECT METRIC_GUID, TRUNC(COLL...
05fm60344b7gf	0	0	0.33	0.30	0.00	12	0.00	12	0.00	0.00	0.03	0.03	0.00	1.00	0.00	0.00	0.00	0.58	1.48	0.00	0.00	0.03	/* OracleOEM / select from ...
072t81cu41xfj	0	13,652	0.14	0.15	0.00	34	0.00	34	0.00	401.53	0.00	0.00	0.00	1.00	0.00	0.00	0.67	0.25	0.72	0.00	0.00	0.08	SELECT DECODE(COUNT(*), 0, 1, ...
0b7dpytkua1uc	0	275	0.03	0.02	0.00	68	0.02	68	0.00	4.04	0.00	0.00	0.00	1.00	0.00	0.00	0.01	0.06	0.08	0.00	0.33	0.16	UPDATE MGMT_LAST_VIOLATION SET...
0cfuq7q5cwvpb	0	6	0.01	0.01	0.00	3	0.00	3	0.00	2.00	0.00	0.00	0.00	1.00	0.00	0.00	0.00	0.01	0.03	0.00	0.02	0.01	select program_oid, schedule_e...
0cn2wm9d7zq8d	0	4	0.00	0.00	0.00	1	0.00	1	0.00	4.00	0.00	0.00	0.00	1.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	SELECT decode(value, 'FATAL', ...
0h6b2sajwb74n	0	2,015	0.03	0.03	0.00	1,477	0.00	199	0.00	10.13	0.00	0.00	0.00	7.42	0.00	0.00	0.10	0.05	0.16	0.00	0.00	0.47	select privilege#, level from ...

Back to SQL Statistics
Back to Top

SQL ordered by UnOptimized Read Requests (Global)

Total Physical Read Requests: 110
Captured SQL account for % of Total
Total UnOptimized Read Requests: 1
Captured SQL account for % of Total
Total Optimized Read Requests: 1
Captured SQL account for % of Total

SQL Id	UnOptimized	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	Execs	UnOptimized	Reads	Elapsed (s)	CPU (s)	IOWait (s)	Rows	Cluster (s)	UnOptimized	Reads	DB time	DB CPU	IO Wait	Cluster	Execs	SQL Text
	Total								Per Execution							Percentage of Total
00prz3j9n4gyj		0	0.12	0.12	0.00	1,137	0.00	12		0.00	0.01	0.01	0.00	94.75	0.00		0.00	0.20	0.58	0.00	0.01	0.03	SELECT METRIC_GUID, TRUNC(COLL...
05fm60344b7gf		0	0.33	0.30	0.00	12	0.00	12		0.00	0.03	0.03	0.00	1.00	0.00		0.00	0.58	1.48	0.00	0.00	0.03	/* OracleOEM / select from ...
072t81cu41xfj		0	0.14	0.15	0.00	34	0.00	34		0.00	0.00	0.00	0.00	1.00	0.00		0.00	0.25	0.72	0.00	0.00	0.08	SELECT DECODE(COUNT(*), 0, 1, ...
0b7dpytkua1uc		0	0.03	0.02	0.00	68	0.02	68		0.00	0.00	0.00	0.00	1.00	0.00		0.00	0.06	0.08	0.00	0.33	0.16	UPDATE MGMT_LAST_VIOLATION SET...
0cfuq7q5cwvpb		0	0.01	0.01	0.00	3	0.00	3		0.00	0.00	0.00	0.00	1.00	0.00		0.00	0.01	0.03	0.00	0.02	0.01	select program_oid, schedule_e...
0cn2wm9d7zq8d		0	0.00	0.00	0.00	1	0.00	1		0.00	0.00	0.00	0.00	1.00	0.00		0.00	0.00	0.00	0.00	0.00	0.00	SELECT decode(value, 'FATAL', ...
0h6b2sajwb74n		0	0.03	0.03	0.00	1,477	0.00	199		0.00	0.00	0.00	0.00	7.42	0.00		0.00	0.05	0.16	0.00	0.00	0.47	select privilege#, level from ...
0hbv80w9ypy0n		0	0.09	0.08	0.00	1	0.00	1		0.00	0.09	0.08	0.00	1.00	0.00		0.00	0.16	0.38	0.00	0.00	0.00	/* OracleOEM */ SELECT end_tim...
0k8522rmdzg4k		0	0.02	0.02	0.00	199	0.00	106		0.00	0.00	0.00	0.00	1.88	0.00		0.00	0.04	0.09	0.00	0.00	0.25	select privilege# from sysauth...
0njp59jttu2z9		0	0.10	0.10	0.00	6,890	0.00	12		0.00	0.01	0.01	0.00	574.17	0.00		0.00	0.18	0.51	0.00	0.00	0.03	DELETE MGMT_METRICS_RAW WHERE ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions (Global)

Total Executions: 42,693
Captured SQL account for 57.7% 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
91h2x42zqagcm	7,041	0.39	0.37	0.00	21,776	0	7,041	0.00	0.00	0.00	0.00	3.09	0.00	1.00	0.00	16.49	0.69	1.82	0.00	1.07	0.00	0.00	UPDATE MGMT_CURRENT_METRICS SE...
3b3s1w98d2g81	2,350	0.09	0.09	0.00	0	0	2,349	0.00	0.00	0.00	0.00	0.00	0.00	1.00	0.00	5.50	0.15	0.44	0.00	0.00	0.00	0.00	select 5 from dual
6gh8gj9n09vr7	2,142	0.08	0.02	0.00	2,142	0	0	0.00	0.00	0.00	0.00	1.00	0.00	0.00	0.00	5.02	0.14	0.09	0.00	0.10	0.00	0.00	SELECT JOB_ID, EXECUTION_ID, S...
cb75rw3w1tt0s	2,142	0.75	0.31	0.00	8,568	0	2,142	0.00	0.00	0.00	0.00	4.00	0.00	1.00	0.00	5.02	1.32	1.50	0.00	0.42	0.00	0.00	begin MGMT_JOB_ENGINE.get_sche...
8cuu0uynbrhbn	1,430	0.26	0.00	0.00	4,290	0	60	0.04	0.00	0.00	0.00	3.00	0.00	0.04	0.00	3.35	0.46	0.00	0.00	0.21	0.00	0.73	select job, nvl2(last_date, 1,...
adngbhxx639tr	1,110	0.06	0.06	0.00	3,402	0	394	0.00	0.00	0.00	0.00	3.06	0.00	0.35	0.00	2.60	0.11	0.30	0.00	0.17	0.00	0.00	SELECT A.TUUID, A.TYPE, A.MANU...
8kyvv5knwptbf	714	0.09	0.05	0.00	2,142	0	714	0.03	0.00	0.00	0.00	3.00	0.00	1.00	0.00	1.67	0.16	0.26	0.00	0.10	0.00	0.46	select count(*) from sys.job$ ...
b0320g1xasbx7	568	0.02	0.02	0.00	1,136	0	568	0.00	0.00	0.00	0.00	2.00	0.00	1.00	0.00	1.33	0.04	0.08	0.00	0.06	0.00	0.08	SELECT TIMEZONE_REGION FROM MG...
8hk7xvhua40va	504	0.99	1.02	0.00	43,434	0	6,894	0.00	0.00	0.00	0.00	86.18	0.00	13.68	0.00	1.18	1.76	4.97	0.00	2.13	0.00	0.01	INSERT INTO MGMT_METRICS_RAW(C...
18naypzfmabd6	495	0.08	0.09	0.00	2,856	0	495	0.00	0.00	0.00	0.00	5.77	0.00	1.00	0.00	1.16	0.14	0.44	0.00	0.14	0.00	0.02	INSERT INTO MGMT_SYSTEM_PERFOR...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time (Global)

Total Cluster Wait Time (s): 6
Captured SQL account for 13.4% 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
6gvch1xu9ca3g	0.17	1.81	1.62	0.08	46,408	248	60	60	0.00	0.03	0.03	0.00	773.47	4.13	1.00	2.99	3.21	7.92	78.69	2.27	65.26	0.14	DECLARE job BINARY_INTEGER := ...
8ca8v2jk772ps	0.12	0.19	0.08	0.01	498	28	0	12	0.01	0.02	0.01	0.00	41.50	2.33	0.00	2.08	0.34	0.40	10.66	0.02	7.37	0.03	DELETE MGMT_METRICS_1DAY WHERE...
7g732rx16j8jc	0.09	0.11	0.02	0.00	34	0	140	1	0.09	0.11	0.02	0.00	34.00	0.00	140.00	1.55	0.20	0.12	0.00	0.00	0.00	0.00	insert into WRH$_SERVICE_STAT ...
fqmqh8vhs2mh5	0.07	0.08	0.00	0.00	74	0	122	3	0.02	0.03	0.00	0.00	24.67	0.00	40.67	1.30	0.14	0.02	0.00	0.00	0.00	0.01	insert into wrh$_sysmetric_his...
84qubbrsr0kfn	0.06	0.71	0.67	0.00	251	0	790	2	0.03	0.36	0.33	0.00	125.50	0.00	395.00	1.11	1.27	3.27	0.00	0.01	0.00	0.00	insert into wrh$_latch (snap_i...
d92h3rjp0y217	0.04	0.08	0.03	0.00	1,174	0	1	1	0.04	0.08	0.03	0.00	1,174.00	0.00	1.00	0.77	0.13	0.17	0.00	0.06	0.00	0.00	begin prvt_hdm.auto_execute( :...
8cuu0uynbrhbn	0.04	0.26	0.00	0.00	4,290	0	60	1,430	0.00	0.00	0.00	0.00	3.00	0.00	0.04	0.73	0.46	0.00	0.00	0.21	0.00	3.35	select job, nvl2(last_date, 1,...
76natvnhtqqhw	0.04	0.04	0.00	0.00	14	0	1	1	0.04	0.04	0.00	0.00	14.00	0.00	1.00	0.70	0.07	0.01	0.00	0.00	0.00	0.00	INSERT INTO SYS.WRI$_ADV_TASKS...
f787fyhjmkp61	0.04	0.33	0.31	0.00	19,233	0	68	68	0.00	0.00	0.00	0.00	282.84	0.00	1.00	0.67	0.58	1.53	0.00	0.94	0.00	0.16	INSERT INTO MGMT_SEVERITY(ACTI...
fdyupq2cqju26	0.03	0.07	0.04	0.00	616	0	56	56	0.00	0.00	0.00	0.00	11.00	0.00	1.00	0.49	0.12	0.22	0.00	0.03	0.00	0.13	BEGIN :1 := MGMT_BLACKOUT_ENGI...

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
CPU used by this session	2,202	0.62	0.89	0.31	0.21	0.16	0.45
CPU used when call started	1,851	0.52	0.75	0.26	0.18	0.13	0.39
CR blocks created	468	0.13	0.19	0.07	0.07	0.02	0.11
DB time	2,330,950	651.57	942.94	325.79	108.05	249.38	402.19
DBWR checkpoint buffers written	9,021	2.52	3.65	1.26	1.52	0.18	2.34
DBWR fusion writes	346	0.10	0.14	0.05	0.03	0.02	0.07
DBWR transaction table writes	186	0.05	0.08	0.03	0.01	0.02	0.03
DBWR undo block writes	1,041	0.29	0.42	0.15	0.15	0.04	0.25
DFO trees parallelized	141	0.04	0.06	0.02	0.00	0.02	0.02
PX local messages recv'd	856	0.24	0.35	0.12	0.02	0.11	0.13
PX local messages sent	856	0.24	0.35	0.12	0.02	0.11	0.13
PX remote messages recv'd	916	0.26	0.37	0.13	0.02	0.12	0.14
PX remote messages sent	916	0.26	0.37	0.13	0.02	0.12	0.14
Parallel operations not downgraded	141	0.04	0.06	0.02	0.00	0.02	0.02
RowCR - row contention	106	0.03	0.04	0.03		0.03	0.03
RowCR attempts	7,163	2.00	2.90	2.00		2.00	2.00
RowCR hits	7,057	1.97	2.85	1.97		1.97	1.97
SMON posted for undo segment shrink	2	0.00	0.00	0.00		0.00	0.00
SQL*Net roundtrips to/from client	21,978	6.14	8.89	3.07	2.88	1.03	5.11
active txn count during cleanout	276	0.08	0.11	0.04	0.04	0.01	0.07
application wait time	5	0.00	0.00	0.00	0.00	0.00	0.00
background timeouts	34,763	9.72	14.06	4.86	0.00	4.86	4.86
buffer is not pinned count	76,928	21.50	31.12	10.75	11.12	2.89	18.61
buffer is pinned count	27,946	7.81	11.31	3.91	4.66	0.61	7.20
bytes received via SQL*Net from client	5,919,064	1,654.59	2,394.44	827.29	941.44	161.59	1,493.00
bytes sent via SQL*Net to client	3,447,056	963.57	1,394.44	481.78	381.31	212.15	751.41
calls to get snapshot scn: kcmgss	100,565	28.11	40.68	14.06	14.05	4.12	23.99
calls to kcmgas	18,688	5.22	7.56	2.61	2.30	0.99	4.24
calls to kcmgcs	3,155	0.88	1.28	0.44	0.22	0.29	0.60
change write time	35	0.01	0.01	0.00	0.01	0.00	0.01
cleanout - number of ktugct calls	329	0.09	0.13	0.05	0.04	0.02	0.07
cleanouts and rollbacks - consistent read gets	170	0.05	0.07	0.02	0.03	0.00	0.05
cleanouts only - consistent read gets	4	0.00	0.00	0.00	0.00	0.00	0.00
cluster key scan block gets	12,259	3.43	4.96	1.71	0.65	1.25	2.17
cluster key scans	736	0.21	0.30	0.10	0.13	0.01	0.19
cluster wait time	521	0.15	0.21	0.07	0.00	0.07	0.08
commit batch/immediate performed	65	0.02	0.03	0.01	0.01	0.00	0.02
commit batch/immediate requested	65	0.02	0.03	0.01	0.01	0.00	0.02
commit cleanout failures: block lost	28	0.01	0.01	0.01		0.01	0.01
commit cleanout failures: callback failure	9	0.00	0.00	0.00	0.00	0.00	0.00
commit cleanout failures: cannot pin	2	0.00	0.00	0.00	0.00	0.00	0.00
commit cleanouts	15,010	4.20	6.07	2.10	2.20	0.54	3.66
commit cleanouts successfully completed	14,971	4.18	6.06	2.09	2.21	0.53	3.65
commit immediate performed	65	0.02	0.03	0.01	0.01	0.00	0.02
commit immediate requested	65	0.02	0.03	0.01	0.01	0.00	0.02
commit txn count during cleanout	131	0.04	0.05	0.02	0.00	0.02	0.02
concurrency wait time	181	0.05	0.07	0.03	0.02	0.01	0.04
consistent changes	711	0.20	0.29	0.10	0.06	0.06	0.14
consistent gets	1,962,004	548.45	793.69	274.22	271.16	82.49	465.96
consistent gets - examination	63,651	17.79	25.75	8.90	9.29	2.32	15.47
consistent gets from cache	1,962,004	548.45	793.69	274.22	271.16	82.49	465.96
cursor authentications	11	0.00	0.00	0.00	0.00	0.00	0.00
data blocks consistent reads - undo records applied	491	0.14	0.20	0.07	0.07	0.02	0.11
db block changes	100,287	28.03	40.57	14.02	16.92	2.05	25.98
db block gets	80,435	22.48	32.54	11.24	12.90	2.12	20.36
db block gets from cache	80,435	22.48	32.54	11.24	12.90	2.12	20.36
deferred (CURRENT) block cleanout applications	8,186	2.29	3.31	1.14	1.32	0.21	2.08
enqueue conversions	4,389	1.23	1.78	0.61	0.00	0.61	0.61
enqueue releases	110,099	30.78	44.54	15.39	1.85	14.08	16.70
enqueue requests	110,128	30.78	44.55	15.39	1.86	14.08	16.70
enqueue timeouts	29	0.01	0.01	0.00	0.01	0.00	0.01
enqueue waits	2,272	0.64	0.92	0.32	0.22	0.16	0.48
execute count	42,693	11.93	17.27	5.97	5.72	1.93	10.01
free buffer inspected	2	0.00	0.00	0.00		0.00	0.00
free buffer requested	12,578	3.52	5.09	1.76	0.92	1.11	2.41
gc CPU used by this session	120	0.03	0.05	0.02	0.00	0.02	0.02
gc cr block build time	5	0.00	0.00	0.00	0.00	0.00	0.00
gc cr block flush time	297	0.08	0.12	0.04	0.01	0.04	0.05
gc cr block receive time	367	0.10	0.15	0.05	0.01	0.04	0.06
gc cr block send time	6	0.00	0.00	0.00	0.00	0.00	0.00
gc cr blocks received	2,744	0.77	1.11	0.38	0.01	0.38	0.39
gc cr blocks served	2,728	0.76	1.10	0.38	0.00	0.38	0.38
gc current block flush time	111	0.03	0.04	0.02	0.01	0.01	0.02
gc current block pin time	3	0.00	0.00	0.00	0.00	0.00	0.00
gc current block receive time	150	0.04	0.06	0.02	0.00	0.02	0.02
gc current block send time	3	0.00	0.00	0.00	0.00	0.00	0.00
gc current blocks received	1,347	0.38	0.54	0.19	0.05	0.15	0.22
gc current blocks served	1,313	0.37	0.53	0.18	0.03	0.16	0.21
gc local grants	237	0.07	0.10	0.03	0.02	0.02	0.04
gc remote grants	350	0.10	0.14	0.05	0.03	0.03	0.07
gcs messages sent	18,685	5.22	7.56	2.61	0.01	2.61	2.62
ges messages sent	7,273	2.03	2.94	1.02	0.01	1.01	1.02
global enqueue get time	86	0.02	0.03	0.01	0.01	0.01	0.02
global enqueue gets async	443	0.12	0.18	0.06	0.00	0.06	0.06
global enqueue gets sync	41,660	11.65	16.85	5.82	3.72	3.19	8.45
global enqueue releases	38,277	10.70	15.48	5.35	3.69	2.74	7.96
heap block compress	88	0.02	0.04	0.01	0.01	0.01	0.02
immediate (CR) block cleanout applications	174	0.05	0.07	0.02	0.03	0.00	0.05
immediate (CURRENT) block cleanout applications	3,606	1.01	1.46	0.50	0.57	0.10	0.91
index crx upgrade (positioned)	9,333	2.61	3.78	1.30	1.77	0.06	2.55
index fast full scans (full)	52	0.01	0.02	0.01	0.01	0.00	0.01
index fetch by key	31,568	8.82	12.77	4.41	5.05	0.84	7.98
index scans kdiixs1	20,270	5.67	8.20	2.83	2.86	0.81	4.85
leaf node 90-10 splits	20	0.01	0.01	0.00	0.00	0.00	0.00
leaf node splits	40	0.01	0.02	0.01	0.00	0.00	0.01
lob reads	24	0.01	0.01	0.00	0.00	0.00	0.00
lob writes	26	0.01	0.01	0.00	0.00	0.00	0.00
lob writes unaligned	26	0.01	0.01	0.00	0.00	0.00	0.00
logons cumulative	483	0.14	0.20	0.07	0.01	0.06	0.07
messages received	9,891	2.76	4.00	1.38	0.95	0.71	2.05
messages sent	9,891	2.76	4.00	1.38	0.95	0.71	2.05
no work - consistent read gets	1,834,207	512.72	741.99	256.36	251.74	78.36	434.37
opened cursors cumulative	16,775	4.69	6.79	2.34	2.04	0.90	3.79
parse count (hard)	19	0.01	0.01	0.00	0.00	0.00	0.00
parse count (total)	16,793	4.69	6.79	2.35	2.04	0.91	3.79
parse time cpu	36	0.01	0.01	0.01	0.00	0.00	0.01
parse time elapsed	45	0.01	0.02	0.01	0.00	0.00	0.01
physical read IO requests	110	0.03	0.04	0.02	0.02	0.00	0.03
physical read bytes	3,112,960	870.18	1,259.29	435.09	421.01	137.39	732.79
physical read total IO requests	24,367	6.81	9.86	3.41	0.47	3.07	3.74
physical read total bytes	421,920,768	117,939.27	170,679.92	58,969.64	12,078.61	50,428.77	67,510.50
physical read total multi block requests	130	0.04	0.05	0.02	0.02	0.00	0.03
physical reads	380	0.11	0.15	0.05	0.05	0.02	0.09
physical reads cache	380	0.11	0.15	0.05	0.05	0.02	0.09
physical reads cache prefetch	270	0.08	0.11	0.04	0.04	0.01	0.06
physical reads prefetch warmup	270	0.08	0.11	0.04	0.04	0.01	0.06
physical write IO requests	3,962	1.11	1.60	0.55	0.53	0.18	0.93
physical write bytes	76,169,216	21,292.00	30,812.79	10,646.00	12,714.43	1,655.54	19,636.46
physical write total IO requests	14,554	4.07	5.89	2.03	0.95	1.36	2.71
physical write total bytes	191,264,768	53,464.71	77,372.48	26,732.35	18,475.45	13,668.24	39,796.47
physical write total multi block requests	5,367	1.50	2.17	0.75	0.75	0.22	1.28
physical writes	9,298	2.60	3.76	1.30	1.55	0.20	2.40
physical writes from cache	9,298	2.60	3.76	1.30	1.55	0.20	2.40
physical writes non checkpoint	554	0.15	0.22	0.08	0.05	0.04	0.11
queries parallelized	127	0.04	0.05	0.02	0.00	0.02	0.02
recursive calls	106,122	29.66	42.93	14.83	10.30	7.55	22.11
recursive cpu usage	810	0.23	0.33	0.11	0.06	0.07	0.16
redo blocks written	34,894	9.75	14.12	4.88	5.37	1.08	8.68
redo entries	57,460	16.06	23.24	8.03	9.27	1.48	14.58
redo ordering marks	847	0.24	0.34	0.12	0.14	0.02	0.21
redo size	16,476,404	4,605.73	6,665.21	2,302.87	2,565.91	488.49	4,117.24
redo subscn max counts	3,176	0.89	1.28	0.44	0.56	0.05	0.84
redo synch time	3,539	0.99	1.43	0.49	0.48	0.16	0.83
redo synch writes	1,452	0.41	0.59	0.20	0.18	0.07	0.33
redo wastage	786,516	219.86	318.17	109.93	41.60	80.51	139.34
redo write time	577	0.16	0.23	0.08	0.03	0.06	0.11
redo writes	2,867	0.80	1.16	0.40	0.20	0.26	0.54
rollback changes - undo records applied	119	0.03	0.05	0.02	0.02	0.00	0.03
rollbacks only - consistent read gets	298	0.08	0.12	0.04	0.04	0.01	0.07
rows fetched via callback	15,407	4.31	6.23	2.15	2.46	0.41	3.90
session cursor cache hits	8,289	2.32	3.35	1.16	1.01	0.44	1.87
session logical reads	2,042,439	570.93	826.23	285.47	284.06	84.61	486.32
shared hash latch upgrades - no wait	16,886	4.72	6.83	2.36	3.20	0.10	4.62
sorts (memory)	10,997	3.07	4.45	1.54	1.23	0.67	2.40
sorts (rows)	489,360	136.79	197.96	68.40	18.75	55.13	81.66
switch current to new buffer	1,785	0.50	0.72	0.25	0.30	0.04	0.46
table fetch by rowid	27,701	7.74	11.21	3.87	4.31	0.82	6.92
table fetch continued row	110	0.03	0.04	0.03		0.03	0.03
table scan blocks gotten	1,274,799	356.35	515.70	178.18	245.32	4.71	351.65
table scan rows gotten	25,954,280	7,255.17	10,499.30	3,627.59	4,958.63	121.30	7,133.87
table scans (short tables)	11,598	3.24	4.69	1.62	1.25	0.73	2.51
total number of times SMON posted	753	0.21	0.30	0.11	0.14	0.01	0.20
transaction rollbacks	65	0.02	0.03	0.01	0.01	0.00	0.02
undo change vector size	6,088,664	1,702.00	2,463.05	851.00	988.96	151.70	1,550.30
user I/O wait time	11	0.00	0.00	0.00	0.00	0.00	0.00
user calls	30,895	8.64	12.50	4.32	3.86	1.59	7.04
user commits	2,272	0.64	0.92	0.32	0.31	0.10	0.54
user rollbacks	200	0.06	0.08	0.03	0.01	0.02	0.04
workarea executions - optimal	8,787	2.46	3.55	1.23	1.15	0.42	2.04
write clones created in foreground	1	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)	2,850	0.80	1.15	0.40	0.20	0.26	0.54
acks for commit broadcast(logical)	2,864	0.80	1.16	0.40	0.20	0.26	0.54
broadcast msgs on commit(actual)	2,862	0.80	1.16	0.40	0.20	0.26	0.54
broadcast msgs on commit(logical)	2,865	0.80	1.16	0.40	0.20	0.26	0.54
broadcast msgs on commit(wasted)	29	0.01	0.01	0.00	0.00	0.00	0.01
gcs assume no cvt	605	0.17	0.24	0.08	0.01	0.08	0.09
gcs blocked converts	1,331	0.37	0.54	0.19	0.05	0.15	0.22
gcs blocked cr converts	2,733	0.76	1.11	0.38	0.20	0.24	0.52
gcs compatible cr basts (global)	185	0.05	0.07	0.03	0.03	0.00	0.05
gcs compatible cr basts (local)	212	0.06	0.09	0.03	0.01	0.02	0.04
gcs dbwr flush pi msgs	320	0.09	0.13	0.04	0.03	0.02	0.07
gcs dbwr write request msgs	208	0.06	0.08	0.03	0.00	0.03	0.03
gcs immediate (compatible) converts	42	0.01	0.02	0.01	0.00	0.00	0.01
gcs immediate (null) converts	112	0.03	0.05	0.02	0.01	0.01	0.02
gcs immediate cr (null) converts	134	0.04	0.05	0.02	0.02	0.01	0.03
gcs indirect ast	337	0.09	0.14	0.05	0.03	0.02	0.07
gcs lms write request msgs	116	0.03	0.05	0.02	0.01	0.01	0.02
gcs msgs process time(ms)	245	0.07	0.10	0.03	0.00	0.03	0.03
gcs msgs received	18,606	5.20	7.53	2.60	0.09	2.54	2.66
gcs pings refused	1	0.00	0.00	0.00		0.00	0.00
gcs retry convert request	306	0.09	0.12	0.04	0.00	0.04	0.05
gcs side channel msgs actual	1,518	0.42	0.61	0.21	0.02	0.20	0.23
gcs side channel msgs logical	4,361	1.22	1.76	0.61	0.01	0.60	0.62
gcs write notification msgs	42	0.01	0.02	0.01	0.00	0.00	0.01
ges msgs process time(ms)	77	0.02	0.03	0.01	0.00	0.01	0.01
ges msgs received	7,265	2.03	2.94	1.02	0.02	1.00	1.03
global posts queue time	154	0.04	0.06	0.02	0.00	0.02	0.02
global posts queued	67	0.02	0.03	0.01	0.01	0.01	0.01
global posts requested	67	0.02	0.03	0.01	0.01	0.01	0.01
global posts sent	67	0.02	0.03	0.01	0.01	0.01	0.01
implicit batch messages received	650	0.18	0.26	0.09	0.08	0.03	0.15
implicit batch messages sent	657	0.18	0.27	0.09	0.08	0.03	0.15
messages flow controlled	3,984	1.11	1.61	0.56	0.13	0.46	0.65
messages queue sent actual	10,733	3.00	4.34	1.50	0.09	1.44	1.56
messages queue sent logical	12,790	3.58	5.17	1.79	0.41	1.50	2.08
messages received actual	20,548	5.74	8.31	2.87	0.08	2.81	2.93
messages received logical	25,874	7.23	10.47	3.62	0.11	3.54	3.69
messages sent directly	5,702	1.59	2.31	0.80	0.24	0.63	0.96
messages sent indirectly	5,747	1.61	2.32	0.80	0.26	0.62	0.98
messages sent not implicit batched	10,076	2.82	4.08	1.41	0.01	1.40	1.41
messages sent pbatched	13,443	3.76	5.44	1.88	0.43	1.57	2.18
msgs causing lmd to send msgs	3,043	0.85	1.23	0.43	0.25	0.25	0.60
msgs causing lms(s) to send msgs	1,287	0.36	0.52	0.18	0.03	0.16	0.20
msgs received queue time (ms)	153	0.04	0.06	0.02	0.00	0.02	0.02
msgs received queued	25,873	7.23	10.47	3.62	0.11	3.54	3.69
msgs sent queue time (ms)	204	0.06	0.08	0.03	0.00	0.03	0.03
msgs sent queue time on ksxp (ms)	1,884	0.53	0.76	0.26	0.01	0.26	0.27
msgs sent queued	12,779	3.57	5.17	1.79	0.41	1.50	2.07
msgs sent queued on ksxp	20,576	5.75	8.32	2.88	0.01	2.87	2.88
process batch messages received	7,775	2.17	3.15	1.09	0.34	0.84	1.33
process batch messages sent	10,147	2.84	4.10	1.42	0.74	0.90	1.94

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	186	186	474	473	3,003,494	3,006,120
2	71	71	177	178	592,456	592,818
Sum	257	257	651	651	3,595,950	3,598,938
Avg	129	129	326	326	1,797,975	1,799,469
Std	81	81	210	209	1,704,861	1,706,462

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)

No data exists for this section of the report.

Back to I/O Statistics
Back to Top

IOStat by File Type (per Second)

No data exists for this section of the report.

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 96.9% of Total Logical Reads: 2,042,439
Captured Segments account for 95.8% of Total Physical Reads: 380
Captured Segments account for % of Total Physical Read Requests: 110
Captured Segments account for % of Total UnOptimized Read Requests: 1
Captured Segments account for % of Total Optimized Read Requests: 1
Captured Segments account for 0.0% of Total Direct Physical Reads: 1
Captured Segments account for 77.1% of Total Physical Writes: 9,298
Captured Segments account for % of Total Physical Write Requests: 3,962
Captured Segments account for 0.0% of Total Direct Physical Writes: 1
Captured Segments account for 5.8% of Total Table Scans: 52
Captured Segments account for 96.0% of Total CR Blocks Received: 2,744
Captured Segments account for 93.4% of Total Current Blocks Received: 1,347
Captured Segments account for 96.6% of Total CR Blocks Served: 2,728
Captured Segments account for 95.8% of Total Current Blocks Served: 1,313

Statistic	Owner	Tablespace Name	Object Name	Obj. Type	Value	%Total	%Capture
db block changes	SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	14,848		43.88
	SYSMAN	SYSAUX	MGMT_CURRENT_METRICS_PK	INDEX	7,504		22.17
	PARKINGAPP	PARKING_DATA	BS_PARKSITE	TABLE	6,480		19.15
	SYSMAN	SYSAUX	MGMT_METRICS_1HOUR_PK	INDEX	2,560		7.57
	PARKINGAPP	PARKING_DATA	BS_PARKINGLOT	TABLE	2,448		7.23
gc cr blocks received	SYS	SYSAUX	SYS_IOT_TOP_8857	INDEX	571	20.81	31.78
	SYSMAN	SYSAUX	MGMT_METRICS_1DAY_PK	INDEX	451	16.44	25.10
	PARKINGAPP	PARKING_DATA	CG_PAYMENT	TABLE	391	14.25	21.76
	SYS	SYSTEM	JOB$	TABLE	240	8.75	13.36
	SYSMAN	SYSAUX	MGMT_LAST_VIOLATION_PK	INDEX	144	5.25	8.01
gc cr blocks served	SYS	SYSAUX	SYS_IOT_TOP_8857	INDEX	571	20.93	31.78
	SYSMAN	SYSAUX	MGMT_METRICS_1DAY_PK	INDEX	451	16.53	25.10
	PARKINGAPP	PARKING_DATA	CG_PAYMENT	TABLE	391	14.33	21.76
	SYS	SYSTEM	JOB$	TABLE	240	8.80	13.36
	SYSMAN	SYSAUX	MGMT_LAST_VIOLATION_PK	INDEX	144	5.28	8.01
gc cu blocks received	SYS	SYSAUX	SYS_IOT_TOP_8857	INDEX	161	11.95	21.79
	SYS	SYSAUX	SYS_IOT_TOP_8850	INDEX	160	11.88	21.65
	PARKINGAPP	PARKING_DATA	CG_PAYMENT	TABLE	136	10.10	18.40
	SYS	SYSAUX	SYS_IOT_TOP_8852	INDEX	132	9.80	17.86
	SYS	SYSAUX	SYS_C001955	INDEX	75	5.57	10.15
	SYS	SYSAUX	ALERT_QT	TABLE	75	5.57	10.15
gc cu blocks served	SYS	SYSAUX	SYS_IOT_TOP_8857	INDEX	161	12.26	21.79
	SYS	SYSAUX	SYS_IOT_TOP_8850	INDEX	160	12.19	21.65
	PARKINGAPP	PARKING_DATA	CG_PAYMENT	TABLE	136	10.36	18.40
	SYS	SYSAUX	SYS_IOT_TOP_8852	INDEX	132	10.05	17.86
	SYS	SYSAUX	SYS_C001955	INDEX	75	5.71	10.15
	SYS	SYSAUX	ALERT_QT	TABLE	75	5.71	10.15
logical reads	PARKINGAPP	PARKING_DATA	BS_BERTH	TABLE	1,215,680	59.52	67.81
	SYS	SYSAUX	SYS_IOT_TOP_8857	INDEX	489,376	23.96	27.30
	PARKINGAPP	PARKING_DATA	BS_PARKSITE	TABLE	31,152	1.53	1.74
	SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	30,096	1.47	1.68
	PARKINGAPP	PARKING_DATA	CG_BERTHTRACE	TABLE	26,560	1.30	1.48
physical reads	SYSMAN	SYSAUX	CURRENT_SEVERITY_PRIMARY_KEY	INDEX	220	57.89	60.44
	SYS	SYSAUX	WRI$_ALERTS_OUTSTANDING_PK	INDEX	116	30.53	31.87
	SYSMAN	SYSAUX	MGMT_METRICS_1DAY_PK	INDEX	28	7.37	7.69
physical writes	SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	4,243		70.67
	SYSMAN	SYSAUX	MGMT_METRICS_1HOUR_PK	INDEX	1,329		22.14
	PARKINGAPP	PARKING_DATA	TM_TERMINALNETMONITOR	TABLE	231		3.85
	SYSMAN	SYSAUX	MGMT_CURRENT_METRICS_PK	INDEX	103		1.72
	PARKINGAPP	PARKING_DATA	CG_BERTHTRACE	TABLE	98		1.63
row lock waits	SYSMAN	SYSAUX	GEN_SNAP_PK	INDEX	1		50.00
	SYSMAN	SYSAUX	MGMT_HA_CLS_INTR_CONN_PK	INDEX	1		50.00
table scans	PARKINGAPP	PARKING_DATA	PK_CG_SORTING	INDEX	1		33.33
	SYSMAN	SYSAUX	MGMT_CURRENT_METRICS_PK	INDEX	1		33.33
	SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01	INDEX	1		33.33

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	GES Lock Requests	GES Pin Requests	GES Pin Releases	GES Inval Requests
BODY	1,368	0.00	12,140	0.00	0	0	0	0	0
SQL AREA	4,258	0.61	46,937	0.11	0	0	0	0	0
TABLE/PROCEDURE	387	0.00	18,513	0.02	4	3,958	17	3	13
TRIGGER	88	0.00	1,028	0.00	0	0	0	0	0

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,818.00	4,818.00	4,007.29	4,007.34	499.60	499.27	0.00	0.00	0.00	0.00	481.80	481.80
2	4,818.00	4,818.00	4,151.96	4,149.88	249.61	249.50	0.00	0.00	0.00	0.00	481.80	481.80

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	411.91	412.01			2.17	2.17	3.15	3.15	24.06	24.06	24.06	24.06	190	190	190	190
	Freeable	84.00	83.69	0.00	0.00	1.20	1.20	2.02	2.02	17.63	17.63			70	70	70	70
	PL/SQL	1.87	1.87	1.36	1.36	0.01	0.01	0.01	0.01	0.06	0.06	0.15	0.15	188	188	187	187
	SQL	1.89	1.76	1.34	1.22	0.01	0.01	0.03	0.03	0.19	0.19	229.67	229.67	164	164	156	156
2	Other	229.76	230.27			3.06	3.07	4.37	4.36	24.06	24.06	24.06	24.06	75	75	75	75
	Freeable	18.56	17.94	0.00	0.00	0.74	0.72	0.38	0.40	1.63	1.63			25	25	25	25
	SQL	0.89	0.90	0.51	0.52	0.02	0.02	0.03	0.03	0.08	0.08	229.76	229.76	47	47	45	45
	PL/SQL	0.42	0.42	0.21	0.21	0.01	0.01	0.01	0.01	0.08	0.08	0.08	0.08	73	73	72	72

Back to Memory Statistics
Back to Top

Supplemental Information

init.ora Parameters
Complete List of SQL Text

init.ora Parameters

'*' indicates same value across all instances

Parameter Name	I#	Begin value
audit_file_dest	*	/u01/app/oracle/admin/prod/adump
background_dump_dest	*	/u01/app/oracle/admin/prod/bdump
cluster_database	*	TRUE
cluster_database_instances	*	2
compatible	*	10.2.0.5.0
control_files	*	+DATA/prod/controlfile/current.260.797616767, +RECOVERY/prod/controlfile/current.256.797616767
core_dump_dest	*	/u01/app/oracle/admin/prod/cdump
db_block_size	*	8192
db_create_file_dest	*	+DATA
db_domain	*
db_file_multiblock_read_count	*	16
db_file_name_convert	*	+DATA/standby/, +DATA/prod/, +RECOVERY/standby, +RECOVERY/prod
db_name	*	prod
db_recovery_file_dest	*	+RECOVERY
db_recovery_file_dest_size	*	419430400000
dispatchers	*	(PROTOCOL=TCP) (SERVICE=prodXDB)
fal_client	1	prod1
	2	prod2
fal_server	*	standby
instance_number	1	1
	2	2
job_queue_processes	*	10
local_listener	1	(ADDRESS=(PROTOCOL=TCP)(HOST=172.18.6.8)(PORT=1521))
	2	(ADDRESS=(PROTOCOL=TCP)(HOST=172.18.6.9)(PORT=1521))
log_archive_config	*	dg_config= (prod, standby)
log_archive_dest_1	*	LOCATION=+ARCHIVE/
log_archive_dest_2	*	service=standby OPTIONAL LGWR SYNC AFFIRM valid_for=(online_logfiles, primary_role) db_unique_name=standby
log_archive_format	*	%t_%s_%r.dbf
log_file_name_convert	*	+DATA/standby/, +DATA/prod/, +RECOVERY/standby, +RECOVERY/prod
nls_territory	*	AMERICA
open_cursors	*	1000
pga_aggregate_target	*	5052039168
processes	*	1500
remote_listener	*	LISTENERS_PROD
remote_login_passwordfile	*	EXCLUSIVE
service_names	*	prod, PARKING
sga_max_size	*	17179869184
sga_target	*	12884901888
spfile	*	+DATA/prod/spfileprod.ora
standby_file_management	*	AUTO
thread	1	1
	2	2
undo_management	*	AUTO
undo_tablespace	1	UNDOTBS1
	2	UNDOTBS2
user_dump_dest	*	/u01/app/oracle/admin/prod/udump

Back to Supplemental Information
Back to Top

Complete List of SQL Text

SQL Id SQL Text

00prz3j9n4gyj SELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET_GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE, TRUNC(COLLECTION_TIMESTAMP, 'HH24')

05fm60344b7gf /* OracleOEM */ select * from (select sum(s.value*512/1000) REDO from gv$sysstat s where s.name='redo blocks written'), (select max(t.last_redo_time) LRT from v$thread t)

072t81cu41xfj SELECT DECODE(COUNT(*), 0, 1, 0) FROM MGMT_SEVERITY WHERE TARGET_GUID = :B3 AND METRIC_GUID = :B2 AND KEY_VALUE = :B1

0b7dpytkua1uc UPDATE MGMT_LAST_VIOLATION SET COLLECTION_TIMESTAMP = :B4 WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND KEY_VALUE = :B1

0cfuq7q5cwvpb select program_oid, schedule_expr, next_run_date, class_oid, comments, flags, schedule_limit, end_date, run_count, failure_count, last_enabled_time, number_of_args, max_failures, max_runs, job_weight, schedule_id, program_action, start_date, max_run_duration, priority, retry_count, running_instance, running_slave, job_status, last_start_date, last_end_date, user_callback, user_callback_ctx, creator, client_id, guid, nls_env, env, char_env, source, destination, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, owner_udn from sys.scheduler$_job where obj# = :1

0cn2wm9d7zq8d SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

0hbv80w9ypy0n /* OracleOEM */ SELECT end_time, status, session_key, session_recid, session_stamp, command_id, start_time, time_taken_display, input_type, output_device_type, input_bytes_display, output_bytes_display, output_bytes_per_sec_display FROM v$rman_backup_job_details WHERE end_time = (select max(end_time) from v$rman_backup_job_details)

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0njp59jttu2z9 DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1

12htg4r7zbtun UPDATE BS_BERTH SET CURRUUID = :1, CURRCARNO = :2, PARKSTATUS = :3, CHANGERESON = :4, CURRCARTYPE = :5, PARENTBERTHNO = :6, BERTHCHANGETIME = :7 WHERE SITEID = :8 AND BERTHNO = :9 AND NVL(BERTHCHANGETIME, TO_DATE('19900101', 'YYYYMMDD')) < :10

18naypzfmabd6 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))

26zpagbuyygf9 /* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name||'-'||l.sid, 2, i.instance_name||'-'||l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'

2b064ybzkwf1y BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;

3b3s1w98d2g81 select 5 from dual

4xxfmvn2m75q4 /* OracleOEM */ select * from (select instance_name c1 from v$instance), (select value from v$parameter where name like 'db_block_size'), (select value from v$sysstat where name='gc cr blocks received'), (select value from v$sysstat where name='gc current blocks received'), (select value from v$sysstat where name='gc cr blocks served'), (select value from v$sysstat where name='gc current blocks served'), (select value from V$dlm_misc where name='messages sent directly'), (select value from V$dlm_misc where name='messages sent indirectly'), (select value from V$dlm_misc where name='messages received actual')

6c8afgvwrvrk3 SELECT SITEID, BERTHNO, CURRUUID, CURRCARNO, NVL(PARKSTATUS, '00') PARKSTATUS, NVL(CHANGERESON, '00') CHANGERESON, NVL(CURRCARTYPE, '00') CURRCARTYPE, BERTHCHANGETIME, NVL(PREPAY, 0) PREPAY, NVL(PREDISPAY, 0) PREDISPAY, NVL(PREPAYTIME, 0) PREPAYTIME, PARENTBERTHNO FROM ( SELECT A.*, ROWNUM RN FROM (SELECT SITEID, BERTHNO, CURRUUID, CURRCARNO, PARKSTATUS, CHANGERESON, CURRCARTYPE, BERTHCHANGETIME, PREPAY, PREDISPAY, PREPAYTIME, PARENTBERTHNO FROM BS_BERTH WHERE SITEID = :1 AND STATUS = '0' ORDER BY BERTHNO) A WHERE ROWNUM < :2) B WHERE B.RN > :3 ORDER BY B.RN

6gh8gj9n09vr7 SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND STEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <= :B1

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6tw8sy94yu07v INSERT INTO CG_BERTHTRACE(BERTHDTLID, BERTHID, UUID, ORGID, ORGNAME, CONTRACTID, PARKINGLOTID, PARKINGLOTNAME, AREAID, AREANAME, BERTHNO, PARENTBERTHNO, BERTHSTATUS, CHANGEREASON, CHAGEDTIME, CARTYPE, CARNO, PARKDURATION, CREATETIME, POSNUM, POSUUID, TERMINALNO, BATCHNO, OPRATORNO, OPRATORNAME, OPRATORCARDNO, CONFIRMSTATUS, CONFIRMTIME, ISLEAVE, SHOULDPAY)(SELECT SEQ_CG_BERTHTRACE.NEXTVAL, BERTHID, :1 UUID, ORGID, ORGNAME, :2 CONTRACTID, PARKINGLOTID, PARKINGLOTNAME, SITEID AREAID, SITENAME AREANAME, BERTHNO, :3 PARENTBERTHNO, :4 BERTHSTATUS, :5 CHANGEREASON, :6 CHAGEDTIME, :7 CARTYPE, :8 CARNO, :9 PARKDURATION, SYSDATE, :10 POSNUM, :11 POSUUID, :12 TERMINALNO, :13 BATCHNO, :14 OPRATORNO, :15 OPRATORNAME, :16 OPRATORCARDNO, :17 CONFIRMSTATUS, :18 CONFIRMTIME, (CASE WHEN (SELECT COUNT(*) FROM CG_BERTHTRACE WHERE UUID = :19 AND BERTHSTATUS = '00') > 0 THEN 1 ELSE 0 END) ISLEAVE , :20 / 100.00 SHOULDPAY FROM BS_BERTH WHERE SITEID = :21 AND BERTHNO = :22)

6yz0qmw5ccwyt UPDATE BS_PARKINGLOT SET(BERTHLEFT, STATUSUPDATETIME)= (SELECT T.BERTHLEFT, SYSDATE FROM (SELECT A.PARKLOTID, SUM(NVL(B.BERTHLEFT, 0)) BERTHLEFT FROM BS_PARKINGLOT A LEFT JOIN BS_PARKSITE B ON A.PARKLOTID = B.PARKLOTID AND B.STATUS = '0' WHERE A.STATUS = '0' GROUP BY A.PARKLOTID ) T WHERE T.PARKLOTID = BS_PARKINGLOT.PARKLOTID) WHERE STATUS = '0'

76natvnhtqqhw INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )

7g732rx16j8jc insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash

84qubbrsr0kfn insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash

8ca8v2jk772ps DELETE MGMT_METRICS_1DAY WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1

8cuu0uynbrhbn 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

8hk7xvhua40va INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRING_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)

8kyvv5knwptbf select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))

91h2x42zqagcm UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRING_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4 AND COLLECTION_TIMESTAMP < :B3

adngbhxx639tr SELECT A.TUUID, A.TYPE, A.MANUFACTURENO, B.MERCHANTNO, A.STATUS, A.CONTRACTID FROM TM_TERMINAL A LEFT JOIN CT_CONTRACT B ON A.CONTRACTID = B.CONTRACTID WHERE A.TUUID = :1

aykvshm7zsabd select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'

b0320g1xasbx7 SELECT TIMEZONE_REGION FROM MGMT_TARGETS WHERE TARGET_GUID = :B1

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

c4nhd1ntptxq7 select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4

cb75rw3w1tt0s begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;

d24d700wvu8jv UPDATE BS_PARKSITE SET(BERTHLEFT, STATUSUPDATETIME)= (SELECT T.BERTHLEFT, SYSDATE FROM (SELECT A.SITEID, SUM(DECODE(NVL(B.PARKSTATUS, '01'), '01', 0, 1)) BERTHLEFT FROM BS_PARKSITE A LEFT JOIN BS_BERTH B ON A.SITEID = B.SITEID AND B.STATUS = '0' WHERE A.STATUS = '0' GROUP BY A.SITEID ) T WHERE T.SITEID = BS_PARKSITE.SITEID) WHERE STATUS = '0'

d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

f787fyhjmkp61 INSERT INTO MGMT_SEVERITY(ACTION_MESSAGE, ACTION_NLSID, ADVISORY_ID, COLLECTION_TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, METRIC_GUID, SEVERITY_CODE, TARGET_GUID) VALUES ( :1, :2, :3, :4, NVL(:5, ' '), :6, :7, :8, :9, :10, :11)

fdyupq2cqju26 BEGIN :1 := MGMT_BLACKOUT_ENGINE.get_blackout_windows(:2, :3); END;

fqmqh8vhs2mh5 insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv

gz6qtapr9u99d /* OracleOEM */ DECLARE l_log_mode VARCHAR2(32); l_flashback_on VARCHAR2(32); l_flash_recovery_area VARCHAR2(512); l_usable_area NUMBER; l_oldest_flashback_time VARCHAR2(512); TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_102 CONSTANT VARCHAR2(10) := '10.2.0.0.0'; BEGIN -- Database version SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; -- Log Mode, Flashback On SELECT log_mode, flashback_on INTO l_log_mode, l_flashback_on FROM v$database; -- Flash Recovery Area SELECT value INTO l_flash_recovery_area FROM v$parameter WHERE name='db_recovery_file_dest'; -- Usable Flash Recovery Area (10gR2) l_usable_area := NULL; IF (v_db_version >= db_version_102) THEN IF (length(l_flash_recovery_area) > 0) THEN EXECUTE IMMEDIATE 'SELECT (100 - sum(percent_space_used)) + sum(percent_space_reclaimable) FROM v$flash_recovery_area_usage' INTO l_usable_area; END IF; END IF; -- Oldest Flashback Time BEGIN SELECT to_char(oldest_flashback_time, 'YYYY-MM-DD HH24:MI:SS') INTO l_oldest_flashback_time FROM v$flashback_database_log; EXCEPTION WHEN OTHERS THEN l_oldest_flashback_time := ''; END; OPEN data_cursor FOR SELECT l_log_mode, l_flash_recovery_area, l_usable_area, l_flashback_on, l_oldest_flashback_time from dual; :1 := data_cursor; END;

SQL Id	SQL Text
00prz3j9n4gyj	SELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET_GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE, TRUNC(COLLECTION_TIMESTAMP, 'HH24')
05fm60344b7gf	/* OracleOEM / select from (select sum(s.value*512/1000) REDO from gv$sysstat s where s.name='redo blocks written'), (select max(t.last_redo_time) LRT from v$thread t)
072t81cu41xfj	SELECT DECODE(COUNT(*), 0, 1, 0) FROM MGMT_SEVERITY WHERE TARGET_GUID = :B3 AND METRIC_GUID = :B2 AND KEY_VALUE = :B1
0b7dpytkua1uc	UPDATE MGMT_LAST_VIOLATION SET COLLECTION_TIMESTAMP = :B4 WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND KEY_VALUE = :B1
0cfuq7q5cwvpb	select program_oid, schedule_expr, next_run_date, class_oid, comments, flags, schedule_limit, end_date, run_count, failure_count, last_enabled_time, number_of_args, max_failures, max_runs, job_weight, schedule_id, program_action, start_date, max_run_duration, priority, retry_count, running_instance, running_slave, job_status, last_start_date, last_end_date, user_callback, user_callback_ctx, creator, client_id, guid, nls_env, env, char_env, source, destination, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, owner_udn from sys.scheduler$_job where obj# = :1
0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0hbv80w9ypy0n	/* OracleOEM */ SELECT end_time, status, session_key, session_recid, session_stamp, command_id, start_time, time_taken_display, input_type, output_device_type, input_bytes_display, output_bytes_display, output_bytes_per_sec_display FROM v$rman_backup_job_details WHERE end_time = (select max(end_time) from v$rman_backup_job_details)
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0njp59jttu2z9	DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1
12htg4r7zbtun	UPDATE BS_BERTH SET CURRUUID = :1, CURRCARNO = :2, PARKSTATUS = :3, CHANGERESON = :4, CURRCARTYPE = :5, PARENTBERTHNO = :6, BERTHCHANGETIME = :7 WHERE SITEID = :8 AND BERTHNO = :9 AND NVL(BERTHCHANGETIME, TO_DATE('19900101', 'YYYYMMDD')) < :10
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
26zpagbuyygf9	/* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name\|\|'-'\|\|l.sid, 2, i.instance_name\|\|'-'\|\|l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
3b3s1w98d2g81	select 5 from dual
4xxfmvn2m75q4	/* OracleOEM / select from (select instance_name c1 from v$instance), (select value from v$parameter where name like 'db_block_size'), (select value from v$sysstat where name='gc cr blocks received'), (select value from v$sysstat where name='gc current blocks received'), (select value from v$sysstat where name='gc cr blocks served'), (select value from v$sysstat where name='gc current blocks served'), (select value from V$dlm_misc where name='messages sent directly'), (select value from V$dlm_misc where name='messages sent indirectly'), (select value from V$dlm_misc where name='messages received actual')
6c8afgvwrvrk3	SELECT SITEID, BERTHNO, CURRUUID, CURRCARNO, NVL(PARKSTATUS, '00') PARKSTATUS, NVL(CHANGERESON, '00') CHANGERESON, NVL(CURRCARTYPE, '00') CURRCARTYPE, BERTHCHANGETIME, NVL(PREPAY, 0) PREPAY, NVL(PREDISPAY, 0) PREDISPAY, NVL(PREPAYTIME, 0) PREPAYTIME, PARENTBERTHNO FROM ( SELECT A.*, ROWNUM RN FROM (SELECT SITEID, BERTHNO, CURRUUID, CURRCARNO, PARKSTATUS, CHANGERESON, CURRCARTYPE, BERTHCHANGETIME, PREPAY, PREDISPAY, PREPAYTIME, PARENTBERTHNO FROM BS_BERTH WHERE SITEID = :1 AND STATUS = '0' ORDER BY BERTHNO) A WHERE ROWNUM < :2) B WHERE B.RN > :3 ORDER BY B.RN
6gh8gj9n09vr7	SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND STEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <= :B1
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6tw8sy94yu07v	INSERT INTO CG_BERTHTRACE(BERTHDTLID, BERTHID, UUID, ORGID, ORGNAME, CONTRACTID, PARKINGLOTID, PARKINGLOTNAME, AREAID, AREANAME, BERTHNO, PARENTBERTHNO, BERTHSTATUS, CHANGEREASON, CHAGEDTIME, CARTYPE, CARNO, PARKDURATION, CREATETIME, POSNUM, POSUUID, TERMINALNO, BATCHNO, OPRATORNO, OPRATORNAME, OPRATORCARDNO, CONFIRMSTATUS, CONFIRMTIME, ISLEAVE, SHOULDPAY)(SELECT SEQ_CG_BERTHTRACE.NEXTVAL, BERTHID, :1 UUID, ORGID, ORGNAME, :2 CONTRACTID, PARKINGLOTID, PARKINGLOTNAME, SITEID AREAID, SITENAME AREANAME, BERTHNO, :3 PARENTBERTHNO, :4 BERTHSTATUS, :5 CHANGEREASON, :6 CHAGEDTIME, :7 CARTYPE, :8 CARNO, :9 PARKDURATION, SYSDATE, :10 POSNUM, :11 POSUUID, :12 TERMINALNO, :13 BATCHNO, :14 OPRATORNO, :15 OPRATORNAME, :16 OPRATORCARDNO, :17 CONFIRMSTATUS, :18 CONFIRMTIME, (CASE WHEN (SELECT COUNT(*) FROM CG_BERTHTRACE WHERE UUID = :19 AND BERTHSTATUS = '00') > 0 THEN 1 ELSE 0 END) ISLEAVE , :20 / 100.00 SHOULDPAY FROM BS_BERTH WHERE SITEID = :21 AND BERTHNO = :22)
6yz0qmw5ccwyt	UPDATE BS_PARKINGLOT SET(BERTHLEFT, STATUSUPDATETIME)= (SELECT T.BERTHLEFT, SYSDATE FROM (SELECT A.PARKLOTID, SUM(NVL(B.BERTHLEFT, 0)) BERTHLEFT FROM BS_PARKINGLOT A LEFT JOIN BS_PARKSITE B ON A.PARKLOTID = B.PARKLOTID AND B.STATUS = '0' WHERE A.STATUS = '0' GROUP BY A.PARKLOTID ) T WHERE T.PARKLOTID = BS_PARKINGLOT.PARKLOTID) WHERE STATUS = '0'
76natvnhtqqhw	INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )
7g732rx16j8jc	insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash
84qubbrsr0kfn	insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
8ca8v2jk772ps	DELETE MGMT_METRICS_1DAY WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1
8cuu0uynbrhbn	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
8hk7xvhua40va	INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRING_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)
8kyvv5knwptbf	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
91h2x42zqagcm	UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRING_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4 AND COLLECTION_TIMESTAMP < :B3
adngbhxx639tr	SELECT A.TUUID, A.TYPE, A.MANUFACTURENO, B.MERCHANTNO, A.STATUS, A.CONTRACTID FROM TM_TERMINAL A LEFT JOIN CT_CONTRACT B ON A.CONTRACTID = B.CONTRACTID WHERE A.TUUID = :1
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
b0320g1xasbx7	SELECT TIMEZONE_REGION FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c4nhd1ntptxq7	select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
cb75rw3w1tt0s	begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
d24d700wvu8jv	UPDATE BS_PARKSITE SET(BERTHLEFT, STATUSUPDATETIME)= (SELECT T.BERTHLEFT, SYSDATE FROM (SELECT A.SITEID, SUM(DECODE(NVL(B.PARKSTATUS, '01'), '01', 0, 1)) BERTHLEFT FROM BS_PARKSITE A LEFT JOIN BS_BERTH B ON A.SITEID = B.SITEID AND B.STATUS = '0' WHERE A.STATUS = '0' GROUP BY A.SITEID ) T WHERE T.SITEID = BS_PARKSITE.SITEID) WHERE STATUS = '0'
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
f787fyhjmkp61	INSERT INTO MGMT_SEVERITY(ACTION_MESSAGE, ACTION_NLSID, ADVISORY_ID, COLLECTION_TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, METRIC_GUID, SEVERITY_CODE, TARGET_GUID) VALUES ( :1, :2, :3, :4, NVL(:5, ' '), :6, :7, :8, :9, :10, :11)
fdyupq2cqju26	BEGIN :1 := MGMT_BLACKOUT_ENGINE.get_blackout_windows(:2, :3); END;
fqmqh8vhs2mh5	insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv
gz6qtapr9u99d	/* OracleOEM */ DECLARE l_log_mode VARCHAR2(32); l_flashback_on VARCHAR2(32); l_flash_recovery_area VARCHAR2(512); l_usable_area NUMBER; l_oldest_flashback_time VARCHAR2(512); TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_102 CONSTANT VARCHAR2(10) := '10.2.0.0.0'; BEGIN -- Database version SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; -- Log Mode, Flashback On SELECT log_mode, flashback_on INTO l_log_mode, l_flashback_on FROM v$database; -- Flash Recovery Area SELECT value INTO l_flash_recovery_area FROM v$parameter WHERE name='db_recovery_file_dest'; -- Usable Flash Recovery Area (10gR2) l_usable_area := NULL; IF (v_db_version >= db_version_102) THEN IF (length(l_flash_recovery_area) > 0) THEN EXECUTE IMMEDIATE 'SELECT (100 - sum(percent_space_used)) + sum(percent_space_reclaimable) FROM v$flash_recovery_area_usage' INTO l_usable_area; END IF; END IF; -- Oldest Flashback Time BEGIN SELECT to_char(oldest_flashback_time, 'YYYY-MM-DD HH24:MI:SS') INTO l_oldest_flashback_time FROM v$flashback_database_log; EXCEPTION WHEN OTHERS THEN l_oldest_flashback_time := ''; END; OPEN data_cursor FOR SELECT l_log_mode, l_flash_recovery_area, l_usable_area, l_flashback_on, l_oldest_flashback_time from dual; :1 := data_cursor; END;

Back to Supplemental Information
Back to Top

End of Report