Welcome to Spotlight
Install Spotlight
Start Spotlight
Spotlight on Oracle now includes web based analytics
Get Spotlight on your favorite mobile device
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
Disk Page
The Disk page contains several charts.
To open the Disk page
- Select the Spotlight on Unix connection in the Spotlight Browser.
-
Click Activity Summary | Disk.
To view charts on the Disk page
Right-click the Disk page and select View as 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.
| Chart | Description |
|---|---|
| Disk Reads | The Disk Reads chart shows the rate at which data is being read off each disk. |
| Service Time | The Service Time chart shows the sustained service time for all disks on the machine you are diagnosing. If the sustained service time of any of your disks exceeds 50 milliseconds, move your data onto the under-utilized disks. |
| Disk Writes | The Disk Writes chart shows the rate at which data is being written to each disk. |
| Queue Length | The Queue Length chart shows the average number of write operations waiting to be completed for each disk. |
| Wait Time | The Wait Time chart shows the amount of time that the queue for each disk is not empty. The time is expressed as a percentage of total time. |
| Busy | The Busy chart shows the amount of time each disk spends processing its transactions. The time is expressed as a percentage of total time. |
To view the Disk page as a table
Right-click the Disk page and select View as Grid.