Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

Tablespaces Page

Use the Tablespaces Page, Datafiles Page, and Segment Page to view the logical and physical structures that have the highest rates of I/O activity in the database.

Tablespaces are the logical structures that contain the datafiles and segments that make up a database.

Data in this drilldown is derived from V$IOSTAT_FILE (Oracle 11g and later) or from V$FILESTAT and V$TEMPSTAT (Oracle 10g).

To open the Tablespaces page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.

  2. Click I/O | Tablespaces.

Space Manager

If Space Manager is installed on your system, you can click the Space Manager icon at the top of the page to open that application. Tools | Space Manager

Charts on the Tablespaces Page

Chart Description
Throughput - requests (Top 20)

Throughput—Requests shows the rate of I/O requests for the top 20 tablespaces (by total requests) in the database. The rate is measured by the number of physical I/O requests per second.

Values that are consistently high over the displayed period are those most likely to contribute to performance bottlenecks.

Latency (Top 20)

For the top 20 tablespaces (by total requests) with the highest rate of I/O requests, Latency shows the average time (in milliseconds) taken to process a physical I/O request on each tablespace.

Values that are consistently high over the displayed period are those most likely to contribute to performance bottlenecks.

The Tablespaces grid

The Tablespaces grid shows information about I/O activity on the tablespaces in the Oracle database.

By default, the grid is ordered by the Requests/s column to show which tablespaces are being used the most. High values in the Read latency (ms) column may indicate potential bottlenecks.

Note: Tablespaces contain the physical datafiles that make up an Oracle database. Any given datafile can belong to only one tablespace. To view details of the datafiles within a specified tablespace right-click a row in the Tablespaces grid and select Show Data Files to open the I/O | Datafiles Page.

Column Description

Tablespace name

The name of the tablespace.

Read Latency (ms)

The average time taken to perform a read request on the tablespace.

Note: A zero value in this column indicates a tablespace that is currently idle.

Requests/s

The rate of read requests on the tablespace.

Read Requests

The total number of read requests on the tablespace since instance startup.

Write Requests

The total number of write requests on the tablespace since instance startup.

Read Time (s)

The total time taken to perform read requests on the tablespace since instance startup.

Write Time (s)

The total time taken to perform write requests on the tablespace since instance startup.

Read Megabytes

The number of megabytes of data read from the tablespace since instance startup.

Write Megabytes

The number of megabytes of data written to the tablespace since instance startup.

Write Latency (ms)

The average time taken to perform a write request on the tablespace.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating