Chatta subito con l'assistenza
Chat con il supporto

Spotlight on Oracle 10.7 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Track Session Page

The Track Session page allows you to track the session's resource usage.

To open the Track Session page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click I/O | Sessions Page.

  3. Select a Session in the Top Sessions grid.
  4. Click Track Session.

Note: Alternatively, you can track resource usage on the Top Sessions | Track Session Page.

Charts on the Track Session page

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
Wait events (ms/s) The rate at which waits for various Oracle resources are occurring. For more information about wait events, see Deal With Wait Events.
I/O history (IO/s)

The rate at which the session is performing database read I/O. The following information is displayed:

  • Consistent - The rate of logical I/O performed for query purposes.
  • Physical - Indicates the rate of physical disk reads.
  • Current - Gets obtained for update purposes.
CPU (ms/s) The rate at which CPU is consumed.
Call history (calls/s) The rate of database calls per second.

 

Related Topics

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione