SAP Note 1269911 - FAQ: Chained Rows

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/1269911 (SAP Service marketplace login required)

Summary :
Chained rows in Oracle databases, especially in SAP environments, are records that stretch over multiple blocks, linked through pointers. They typically occur when a record exceeds the block size, during data record expansion, or because of database updates that make existing blocks insufficient. This can increase data access time and even cause operational errors like ORA-30926. Using system views like V$SYSSTAT, DBMS_SPACE, or through ANALYZE TABLE commands, one can identify and quantitatively assess chained rows. Preventative or corrective actions include adjusting database configurations or reconstructing tables to better align with block sizes.

Key words :
set heading offset echo offset feedback offset linesize 200set pagesize 0set sqlprompt ''set trimspool onset verify offspool commandsanalyzetable, set heading offset echo offset feedback offset linesize 200set pagesize 0set sqlprompt ''set trimspool onset verify offspool commandslistchainedrows, sqlplus /nologconnect <sapuser>/<password>@commandsanalyzetable                        depending, sqlplus /nologconnect <sapuser>/<password>@commandslistchainedrows, connect <sapuser>/<password>truncate table chained_rows, sqlplus /nologconnect <sapuser>/<password>@generatelistchainedrows, sqlplus /nologconnect <sapuser>/<password>@generateanalyzetable, frequently asked questions solution 1, connect <sapuser>/<password>@, long raw fields exist

Related Notes :

1438410SQL: Script collection for Oracle
1295200Oracle 10g or higher: Space statistics based on DBMS_SPACE
1235952Minor functional enhancements in BR*Tools (2)
974876Oracle Transparent Data Encryption (TDE)
646681Reorganization of tables with BRSPACE
618868FAQ: Oracle performance