Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Outliers (Flash)

thrupassMay 3 2016 — edited May 4 2016

Hi, Experts

in [Outlier Summary] part

There are no disk outliers on flash disks

but

in [Exadata OS IO Statistics - Outlier Cells] part

It seems like there are outliers

which one is right ?

and if outlier exists what can I do to tune it ?

Thanks in advance

Exadata Storage Server Model

Model Information of Servers
Cpu Count refers to Logical CPUs, including Cores and HyperThreads

Model	CPU Count	Memory(GB)	# Cells	Cells
Oracle Corporation ORACLE SERVER X5-2L High Capacity	16/32	95	3	knkirbceladm01; knkirbceladm02; knkirbceladm03

Back to Exadata Server Configuration
Back to Top

Exadata Storage Server Version

Version Information of Packages on the Server

Package Type	Package Version	Cells
Kernel	2.6.39-400.276.1.el6uek.x86_64	All
Cell	cell-12.1.2.3.0_LINUX.X64_160207.3-1.x86_64	All
Offload	cellofl-12.1.2.3.0_LINUX.X64_160207.3	All
Offload	cellofl-11.2.3.3.1_LINUX.X64_150818	All

Back to Exadata Server Configuration
Back to Top

Exadata Storage Information

Storage Information of Servers

Flash cache size(GB)	Flash Log Size(GB)	Hard Disk	Flash	# Griddisks	Cells
		# Celldisks
2,980.22	0.50	6	2	16	All
8,940.66	1.50	18	6	48	Total

Back to Exadata Server Configuration
Back to Top

Exadata Griddisks

Griddisks on the Storage Servers
Disk Size indicates size of individual CellDisks in the cells, not total size.

Griddisk Name Prefix	# Griddisks	Griddisk Size(GB)	Type	Cells
DATA_DG	6	6,561.00	H/7.2T	All
DBFS_DG	4	33.80	H/7.2T	All
RECO_DG	6	729.06	H/7.2T	All

Back to Exadata Server Configuration
Back to Top

Exadata Celldisks

Celldisks on the Storage Servers
Disk Size indicates size of individual CellDisks in the cells, not total size.

Disk Type	CellDisk Size(GB)	# Disks	Cells
F/1.5T	1,490.41	2	All
H/7.2T	7,323.91	4	All
H/7.2T	7,290.11	2	All

Outlier Summary - Disk Level

Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 30.06 (1% of maximum capacity of 3,006)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 535.74 (1% of maximum capacity of 53,574)
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
A '*' and a dark red background indicates over maximum capacity
Maximum hard disk capacity: IOPS: H/7.2T: 167 | IO MB/s: H/7.2T: 111
Maximum flash disk capacity: IOPS: F/1.5T: 8,929 | IO MB/s: F/1.5T: 343
There are no disk outliers on flash disks
There are no disk outliers on hard disks

Back to Exadata Outlier Summary

Back to Exadata Resource Statistics

Exadata OS Statistics Outliers

Exadata OS IO Statistics

Exadata OS IO Latency
- Outlier Cells
- Outlier Disks
Exadata OS CPU Statistics - Outlier Cells

Exadata OS IO Statistics - Outlier Cells

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are cells whose average performance is outside the normal range, where normal range is -/+ 1 standard deviation
Outlier cells must have a mininum of 10 IOPs. Idle cells are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 30.06 (1% of maximum capacity of 3,006)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 535.74 (1% of maximum capacity of 53,574)
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
A '*' and a dark red background indicates over maximum capacity
%Total - Avg [IOPs |IO MB/s] of the cell as a percentage of total [IOPs | IO MB/s] for the disk type

Disk Type	Cell Name	# Cells	# Disks	Total	% Total	Average		Mean		Std Dev	Normal Range	Total	% Total	Average		Mean		Std Dev	Normal Range	Mean	Std Dev	Normal Range
				IOPs								IO MB/s								% Disk Utilization
				Total	% Total	Per Cell		Per Disk				Total	% Total	Per Cell		Per Disk				% Disk Utilization
F/1.5T	All	3	6	128,923.27		*	42,974.42	*	21,487.21	6,196.17	15,291.04 - 27,683.38	7,951.38		*	2,650.46	*	1,325.23	392.19	933.04 - 1,717.42	75.72	19.85	55.87 - 95.56
H/7.2T	All	3	18	312.97		104.32		17.39		21.68	0.00 - 39.06	19.58		6.53		1.09		4.00	0.00 - 5.09	0.12	0.40	0.00 - 0.51

Exadata OS IO Statistics - Outlier Disks

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 30.06 (1% of maximum capacity of 3,006)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 535.74 (1% of maximum capacity of 53,574)
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
A '*' and a dark red background indicates over maximum capacity
% Total - Avg [IOPs |IO MB/s] of the disk as a percentage of total [IOPs | IO MB/s] for the disk type

Disk Type	Cell Name	Disk Name	# Disks	% Total	Mean		Std Dev	Normal Range	% Total	Mean		Std Dev	Normal Range	Mean	Std Dev	Normal Range
				IOPs					IO MB/s					% Disk Utilization
F/1.5T	All	All	6		*	21,487.21	6,196.17	2,898.69 - 40,075.73		*	1,325.23	392.19	148.67 - 2,501.79	75.72	19.85	16.18 - 135.26
H/7.2T	All	All	18		17.39		21.68	0.00 - 82.42		1.09		4.00	0.00 - 13.09	0.12	0.40	0.00 - 1.31

Back to Exadata OS Statistics Outliers

Back to Exadata Resource Statistics

Exadata OS IO Latency - Outlier Cells

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are cells whose average performance is outside the normal range, where normal range is -/+ 1 standard deviation
Outlier cells must have a mininum of 10 IOPs. Idle cells are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 30.06 (1% of maximum capacity of 3,006)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 535.74 (1% of maximum capacity of 53,574)
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range

Disk Type	Cell Name	# Cells	# Disks	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range
				Avg Service Time (ms)			Avg Wait Time (ms)
F/1.5T	All	3	6	0.04	0.01	0.03 - 0.04	7.08	3.41	3.67 - 10.49
H/7.2T	All	3	18	0.39	0.96	0.00 - 1.35	0.75	2.72	0.00 - 3.47

Exadata OS IO Latency - Outlier Disks

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 30.06 (1% of maximum capacity of 3,006)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 535.74 (1% of maximum capacity of 53,574)
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range

Disk Type	Cell Name	Disk Name	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range
			Avg Service Time (ms)			Avg Wait Time (ms)
F/1.5T	All	All	0.04	0.01	0.02 - 0.05	7.08	3.41	0.00 - 17.30
H/7.2T	All	All	0.39	0.96	0.00 - 3.26	0.75	2.72	0.00 - 8.91

Back to Exadata OS Statistics Outliers

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2016

Added on May 3 2016

#exadata, #performance-availability

2 comments

1,351 views