Note: Available for Oracle 11g and later.
To open the Statistics page
Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
Click SQL & Application Workload | Result Cache Page | Statistics.
Statistics
| Column | Description |
|---|---|
|
Name |
The name of the retrieved statistic. |
|
Value |
Its value the last time the Spotlight table was refreshed. |
|
Rate (value/s) |
(If appropriate) The rate at which the specified statistic occurs. |
Note: The Statistics table shows result cache statistics from Oracle's V$RESULT_CACHE_STATISTICS table.