A Oracle 12c Database has a table with Chained rows:
select owner c1, table_name c2, pct_free c3, pct_used c4, avg_row_len c5, num_rows c6, chain_cnt c7, chain_cnt/num_rows c8 from dba_tables where owner not in ('SYS','SYSTEM') and table_name not in (select table_name from dba_tab_columns where data_type in ('RAW','LONG RAW','CLOB','BLOB','NCLOB') ) and chain_cnt > 0 order by chain_cnt desc ; RESULT: C1 C2 C3 C4 C5 C6 C7 C8 SCHEMA_XY PERSON 10 662 98.930 85.872 1
I understand that this table has 85.872 % Chained rows. I tried:
alter table SCHEMA_XY.PERSON move; alter table SCHEMA_XY.PERSON move pctfre 30; SELECT 'alter index '||OWNER||'.'||INDEX_NAME||' rebuild online ;'FROM DBA_INDEXES where TABLE_NAME='PERSON';
Chained Rows remain high. The table has 250 columns mostly varchar2 and number. How can I fix it?