Chained Row

How to Choose the Most Needed to be Reorganized Tables

by Ed Chen
May 20, 2016March 29, 2018

We all know that table reorganization could improve the performance of DML on the tables. Your supervisor might ask you to do this action more… Read More »

How to Reduce Chained Row

by Ed Chen
April 12, 2016March 29, 2018

The chained row is a row which is too large to fit into one single data block when it is first inserted. In row chaining,… Read More »

What is Difference Between PCT_FREE and PCT_USED

by Ed Chen
April 12, 2014January 23, 2021

For manual segment space management (MSSM), we have to define the two parameters in a table in order to meet our target space plan. Let… Read More »