Thursday , June 13 2024

Chained Row Analysis


A chained row is called a row that does not fit into a single database block. For example, when you try to add a 16K size row to a database that has a block size of 8KB, that record will use 3 blocks. This row is called a chained row because it does not fit into a block.

The tables that may contain a chained row are as follows:

  • If the row size exceeds the database block size in a table.
  • Tables with long and long raw columns.
  • Tables with more than 255 columns.

Chained row detection:

First, we create the required table as follows.

Then, the related table needs to be analyzed as follows.

After these operations, the chained_rows table will display the information if the corresponding table has a chained row.

We can also query tables with chained row with the following query.

When you receive an error such as the following during the analysis of the table, the chained_rows table does not exist in the user schema that you are running the analysis. In this case, you must run utlchain.sql and perform the analysis with the same user.

ORA-01495: specified chain row table not found


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *