Spotlight on Oracle RAC Drilldowns
Spotlight on Oracle RAC Drilldowns
Once a problem is isolated you can display a drilldown page with charts and tables that provide a detailed breakdown of the underlying statistics.
| Drilldown | Click to open | Keyboard Shortcut | Drilldown Pages | Description |
|---|---|---|---|---|
| Top Sessions |  |
CTRL+S |
Top Sessions lists all users connected to the Oracle database. As per Spotlight on Oracle. | |
| SQL & Application Workload |  |
CTRL+Q | Top SQL Page | Array Fetch Page | Parse Activity Page | Sort Activity Page |
As per Spotlight on Oracle. The SQL & Application Workload drilldown in Spotlight on Oracle RAC does NOT contain the following pages:
|
| Activity |  |
CTRL+Y | Summary Page | Waits Page | Waiting Events Page | Blocking Locks Page | Latches Page | Transactions Page | Buffer Busy Waits Page |
As per Spotlight on Oracle. The Activity drilldown in Spotlight on Oracle RAC does NOT contain the following pages:
|
| I/O |  |
CTRL+I | Summary Page | Sessions Page | Tablespaces Page | Datafiles Page | Segment Page | Buffer Pool Page | Chains / Migrations Page |
As per Spotlight on Oracle. |
| Configuration & Memory |  |
CTRL+N | SGA Utilization Page | In-Memory Page | Oracle Parameters Page | Alert Log Page |
As per Spotlight on Oracle. The Configuration & Memory drilldown in Spotlight on Oracle RAC does NOT contain the following pages:
|
| Disk Storage |  |
CTRL+D | Archive Destinations Page | Tablespace Utilization Page |
The Disks drilldown displays detailed information about the logical and physical disks. As per Spotlight on Oracle. The Disk Storage drilldown in Spotlight on Oracle RAC does NOT contain the following pages:
|
| Cluster |  |
CTRL+U |
Latency Page | Balance Page | Miss Ratio Page | Corrupt/Lost Blocks Page |
The pages in the Cluster drilldown display information about the performance of the Oracle RAC cluster, including details on cluster latency, balance, overhead, miss ratios, and corrupt or lost blocks. |
| ASM |  |
CTRL+M | Diskgroups Page | Disks Page | Files Page | Storage Page | Operation Page |
Diagnose the performance of Automatic Storage Management (ASM) for the Oracle RAC cluster. As per Spotlight on Oracle. |
| Services |  |
CTRL+E | Services By Instance | Resources Page | Activity Page | Waits Page | Configuration Page |
The Services drilldown displays details of the services defined and deployed for the Oracle RAC cluster. Note: Available for Oracle 10.2 and later. |
| Predictive Diagnostics |  |
CTRL+G | Predictive Diagnostics |
Collect and analyze performance metrics in order to predict the future behavior of the Oracle database. As per Spotlight on Oracle. |
| Pluggable Databases |  |
CTRL+P | Resource Usage |
(Oracle 12c) View resource usage of pluggable databases. |
| Data Guard |  |
CTRL+W | Standby Connections Dialog |
Use to configure Spotlight to monitor Standby databases to this Primary database in an Oracle Data Guard environment. Note: The Data Guard icon is enabled when the current Spotlight on Oracle RAC connection is configured as a Primary database in an Oracle Data Guard environment. |
| Exadata |  |
CTRL+T |
Exadata Databases | Exadata ASM Groups | Exadata Cell Disks |Exadata Smart Flash Cache | Exadata Cell Balance | Exadata Cell Metrics |
Detect and help resolve performance issues on Oracle's Exadata machine. Note: Spotlight on Oracle RAC may include monitoring of Exadata systems depending on the license purchased. When licensed, the Exadata icon is enabled on connection to an Oracle Exadata system. |
| Alarm Log |  |
CTRL+L |
The Alarm Log drilldown displays information on the alarms associated with the Windows system, including the name of the component that issued the alarm, the date and time the alarm was logged, and the severity of the alarm. Note: The Alarm Log drilldown is common to all Spotlight applications. The alarms are specific to the current Spotlight connection. For more information, see Spotlight on Oracle RAC Alarms. |