lobs and chained rows
Hello,
I have done a table reorg and ended with chained rows! Table (partitioned) currently looks like this... (version 12.1)
Partitio Ave row Last Chain
OWNER TAB Temp NUM_ROWS Meg ned length Analysed EMPTY_BLOCKS Stale cnt
------------------ ------------------------------ ---- --------------- ---- ---- ------------ ----- ------- --------------------- ------------ ------ -------- ------------
HCP COVERAGE_DATA N 6,104290 36,472 YES 5033 2019-10-14 07:48:54 3611 NO 986,055
HCP COVERAGE_DATA N 34,363470 206,797 YES 5037 2019-10-14 07:45:13 3742 NO 5,570,677
HCP COVERAGE_DATA N 101,329100 608,714 YES 5029 2019-10-14 08:02:55 13097 NO 0
HCP COVERAGE_DATA N 27,241960 162,751 YES 5034 2019-10-14 07:48:09 4920 NO 4,821,589
HCP COVERAGE_DATA N 0 0 YES 0 2019-10-14 07:37:35 0 NO 0
HCP COVERAGE_DATA N 33,700380 202,695 YES 5019 2019-10-14 07:41:29 824 NO 5,560,560
--------------- ------------ ------------