Exadata Flash Cache Status Test

The Exadata Smart Flash Cache is a cache on the cell (storage) server for storing redo-data until this data can be safely written to disk. The Oracle Exadata storage server comes with a substantial amount of flash storage. A small amount is allocated for database logging, and the remainder is used for caching user data. Exadata Smart Flash Cache can intelligently determine the data that is most useful to cache based on data usage, access patterns, and hints from the database that indicate the type of data being accessed. The flash cache may lose data due to reasons such as frequent power failure, corruption of the cache, memory overflow of the cache etc. To avoid such loss of data from the flash cache, it is necessary to keep track on the status of the flash cache. The Exadata Flash Cache Status test helps administrators to keep a vigil on the cache!

This test auto-discovers the flash caches on the target storage server and for each flash cache reports the status. This test also reveals the cell disks that are allocated to each flash cache and those cell disks that are unavailable. In addition, this test also reveals the size of the flash cache that is available for use. Using this test, administrators can figure out those flash caches that are in a critical state, isolate them and fix issues proactively. Also, administrators can figure out the flash cache that is currently being most utilized.

Target of the test : Oracle Exadata Storage Server

Agent deploying the test : A remote agent

Outputs of the test : One set of the results for the target Oracle Exadata Storage Server that is being monitored

Configurable parameters for the test

Parameter	Description
Test period	How often should the test be executed
Host	The IP address of the host for which this test is to be configured.
Port	The port number at which the specified host listens. By default, this is NULL.
Username, Password and Confirm Password	By default, this test uses the Cell Control Command-Line Interface (CellCLI) to pull out the required metrics. To use the CLI, the test first needs to connect to the target storage server via SSH, and then run commands using CLI. For running the commands, this test requires the credentials of a cellmonitor user. Specify the login credentials of such a user in the Username and Password text boxes and confirm the Password by retyping it in the Confirm Password text box.
SSH Port	This test uses the Cell CLI to pull metrics from the target Oracle Exadata Storage Server. To run the CLI commands, this test first needs to establish an SSH connection with the target storage server. To enable the test to establish this connection, specify the SSH Port here.
Timeout	Specify the time duration for which this test should wait for a response from the storage system in the Timeout text box. By default, this is 120 seconds.
Detailed Diagnosis	To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option. The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled: The eG manager license should allow the detailed diagnosis capability Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Flash cache status	Indicates the current status of this flash cache.		The table below indicates the values that this measure can report and their corresponding numeric equivalents: Measure value Numeric Value Normal 100 Warning 90 Critical 50 Note: By default, this measure reports the above-mentioned Measure Values while indicating the current status of the flash cache. However, in the graph of this measure, the status of the flash cache will be represented using the corresponding numeric equivalents only.
Allocated cell disks	Indicates the number of cell disks allocated to this flash cache.	Number	The detailed diagnosis of this measure lists the names of the cell disks allocated to the flash cache.
Flash cache size	Indicates the total size of this flash cache.	TB
Usable flash cache size	Indicates the size of this flash cache that is available for use.	TB
Percentage of usable cache size	Indicates the size of this flash cache in terms of percentage, that is available for use.	Percent	A value close to 0 indicates that the flash cache is running out of space.
Unavailable cell disks	Indicates the number of cell disks that are currently unavailable for this flash cache.	Number