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
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:
|
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:
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 |
|