Database Administration (MOSC)

MOSC Banner

lobs and chained rows

edited Oct 15, 2019 2:49AM in Database Administration (MOSC) 1 commentAnswered ✓

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

                                                       ---------------           ------------                                     ------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center