Chat now with support
Chat with Support

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

Disk IO Page

The charts and table on this page contain Disk I/O details on every Oracle session recorded by the Solaris operating system.

To open the Disk IO Page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click DTrace | Disk IO.

Notes:

  • Before you can capture the details of the interaction between Oracle and a Solaris operating system, you need follow some configuration steps. Install And Configure DTrace Scripts
  • When you open this page Spotlight launches a query to collect the relevant operating system data. Initially, Spotlight may take some seconds to return the required data.
  • When you have started one of the DTrace queries, it will keep running until you close the Spotlight connection.

Charts on the Disk IO Page

Chart

Description

IO Rates

When you open the Disk IO page, you start a Spotlight query that uses DTrace to identify when Oracle writes to, or reads from, files stored on disk.

IO Rates displays the rate of disk I/O (reads and writes) since the Spotlight query started.

Service Times

The data in this chart, like that in the IO Rates chart, is collected by the Spotlight query that starts when you open the Disk IO page.

Service Times displays the average time taken for Oracle to complete a single read from disk, or a single write to disk.

Grid on the Disk IO Page

Oracle Session IO returns information on disk I/O for Oracle processes that are performing tasks on behalf of Oracle sessions.

Note: The Spotlight query used to populate the Disk IO page starts when you open the page and continues until the end of the Spotlight connection, so the times shown in this table represent times since the query started.

Column

Description

Process ID

A unique identifier for an Oracle process that uses disk I/O.

Command

The Oracle command performed during the process.

Reads

The number of times data has been read from disk for the command.

Writes

The number of times data has been written to disk for the command.

IO/Sec

The rate at which data has been read from or written to disk.

Read Time (ms)

The total amount of time taken to read data from disk for the command.

Write Time (ms)

The total amount of time taken to write data to disk for the command.

IO Time (ms/s)

The rate at which elapsed time has been spent reading from or writing to disk.

Avg Read Time (ms)

The average time taken for a single read operation from disk.

Avg Write Time (ms)

The average time taken for a single write operation to disk.

KB/Read

The average number of kilobytes read from disk with each read.

KB/Write

The average number of kilobytes written to disk with each write.

Note: The information in this page is collected by Solaris, and may contain values that differ from those of similar metrics recorded by Oracle.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating