Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - 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

Chains / Migrations Page

Row chaining occurs when a row cannot physically fit into an Oracle block, and another block is required to store the remainder of the row.

Migration of an Oracle row occurs when a row is updated in an Oracle block and the amount of free space in the block is not enough to store all of the row's data. The row is migrated to another physical block in the table, but the indexes that refer to the row still indicate the block where the row used to be.

To open the Chains / Migrations page

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

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

Fetch Rates Chart

Fetch Rates shows the rate of relevant row fetch operations.

  • By rowid indicates the number of rows fetched by ROWID address — this usually occurs when a row is accessed via an index lookup.
  • Continued Fetch indicates the number of these fetches that "continued" into another block because the row had migrated or chained.

Note that rows fetched by table can never chain and hence the rate of rows accessed via full table scan is not shown.

Segments With Chained Rows Grid

Segments with Chained Rows shows tables that are known to have chained or migrated rows.

Chained rows are noted when a table is analyzed using the ANALYZE command. Tables that have not been analyzed or have been analyzed via procedures in the DBMS_STATS package will not be displayed here, they will need to be analyzed with the ANALYZE command.

Column Description

Table Name

The name of the table under investigation.


The number of rows in the table.

Chained Rows

The number of chained rows in the table.

Pct Chained

The percentage of rows in the table that are chained.


The minimum percentage of a data block that is kept free to accommodate updates to rows that already exist in the block.

Sessions Experiencing Continued Fetch Grid

Sessions Experiencing Continued Fetch shows sessions that have experienced Continued Fetch operations as they accessed rows. The current SQL statement is also shown.

Column Description


Session ID.

Oracle User

The Oracle account name for the session.

Continued Fetches

Fetches from chained or migrated rows.

Logical Reads

Logical database reads for the session.

Physical Reads

Physical database reads for the session.

OS User

The operating system user that established the session.


The machine hosting the database under investigation.


The program causing the Continued Fetch operation.


The status of the session — for example, ACTIVE or INACTIVE.


The type of session — FOREGROUND or BACKGROUND.


The current SQL statement.

Process ID

Operating system process ID for the client program.


Serial number of the session. SIDs can be reused after the session disconnects, but the combination of SID and Serial number is always unique.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating