Welcome to Spotlight
Install Spotlight
Start Spotlight
Spotlight on Oracle now includes web based analytics
Get Spotlight on your favorite mobile device
User Experience Feedback
Authorize Spotlight
Spotlight on Oracle
Connect to an Oracle Database
Oracle User Wizard
Spotlight on Oracle Data Guard
DBA Connection Credentials
User Account
New Oracle User
Select Tablespace
Predictive Diagnostics
Ready To Configure Oracle User
End
Configuring Oracle User for Spotlight Dialog
Toad DBA Suite for Oracle
Oracle Architecture Overview
Spotlight on Oracle Home Page
Spotlight on Oracle Alarms
Spotlight on Oracle Drilldowns
Install And Configure DTrace Scripts
Tune Your Oracle Database
Predictive Diagnostics
Spotlight on Oracle Tools: Explain Plan, SQL Optimizer, Space Manager
Spotlight on your favorite mobile device
Standby Connections Dialog
Spotlight on Oracle Data Guard Home Page
Spotlight on Oracle Data Guard Alarms
Spotlight on Oracle RAC
Connect to Spotlight on Oracle RAC
Spotlight on Unix
Oracle RAC Connection Details
Verify Cluster Connection Details Dialog
Connect to an Exadata Storage Server (Cells)
Spotlight on Oracle RAC Home Page
Spotlight on Oracle RAC Alarms
Spotlight on Oracle RAC Drilldowns
Configure the Unix System
Connect to Unix Systems
Spotlight on Unix Home Page
Spotlight on Unix Alarms
Spotlight on Unix Drilldowns
Spotlight on Windows
Connect to Windows Systems
Spotlight on Windows Home Page
Spotlight on Windows Alarms
Spotlight on Windows Drilldowns
Spotlight on MySQL
Connect to a MySQL Database
Spotlight on MySQL Home Page
Spotlight on MySQL Alarms
Spotlight on MySQL Drilldowns
Troubleshooting: Connection Problems
Exadata Smart Flash Cache
This page shows usage of the Flash Cache.
The data is sourced from CellCLI where the objectType is FLASHCACHE.
Note: Spotlight on Oracle RAC may include monitoring of Exadata systems depending on the license purchased.
To open the Smart Flash Cache page
- Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
-
Click Exadata | Smart Flash Cache.
Smart Flash Cache Statistics Chart
Notes:
- Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on the chart.
- Click an item in the legend to highlight its series (line) in the chart. Click a second time to return the series to its normal appearance.
- Move the mouse pointer over an item in the legend to view the current value for that series within the chart.
| Data | Description |
|---|---|
| Inserts | The number of megabytes inserted into the flash cache. |
| Hits | The number of megabytes successfully found in the flash cache. |
| Evictions | The number of megabytes evicted from the flash cache to make room for other data. |
| Misses | The number of megabytes not found in the flash cache, that had to be retrieved from disk. |
| Skips | The number of megabytes retrieved from the Hard Disk (bypassing the Flash Cache). |
Smart Flash Cache Usage by Segments Grid
| Column | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Object Number | The object number. | ||||||||
| Object Name | The name of the object (available only for the currently connected database) | ||||||||
| ESFC Type |
| ||||||||
| Non ESFC IO (Miss Count) | The number of misses: requests for objects from the flash cache, not found in the flash cache. | ||||||||
| ESFC IO (Hit Count) | The number of hits: requests for objects from the flash cache successfully found in the flash cache. | ||||||||
| % ESFC Hits |
The proportion of Exadata Smart Flash Cache (ESFC) hits that are successful. Hits are successful when the requested data is found in the Smart Flash Cache. Hits are unsuccessful (Misses) if the requested data needs to be retrieved from the Exadata Storage Servers (Cells) because it cannot be found in the Smart Flash Cache. | ||||||||
| % ESFC Time Saved |
An indicator of the time saved by the Exadata Smart Flash Cache (ESFC). The proportion of:
over
| ||||||||
| Database ID | The database the object is from (database id) | ||||||||
| Database name | The database the object is from (database name) |
Smart Flash Cache Statistics Grid
Shows Cell Statistics relevant to the Flash Cache broken down by the Cell Host.
| Column | Description |
|---|---|
| Cell Host | The host name of the Exadata Storage Server (Cell). |
| Statistic Name | The name of the statistic. |
| Statistic Value | The statistical value. |
| Unit | The unit of measurement used in calculating the statistic. |