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
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
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.