Database Administration (MOSC)

MOSC Banner

Re-org Table with LOB segment XML data

edited Feb 24, 2016 4:08AM in Database Administration (MOSC) 2 commentsAnswered

Hi all

I do have couple question -doubts about the re-org for tables with LOB segments XML data

i could identify the biggest segments

TABLESPACE_NAME           SEGMENT_NAME              SEGMENT_TYPE       OWNER                           MBYTES NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS

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

ECMX_DEF                  SYS_LOB0000079914C00006$$ LOBSEGMENT         ECOMEX                          269917                  1  2147483645

ECMX_DEF                  MSEG                      TABLE              ECOMEX                           31036                  1  2147483645

ECMX_DEF                  LIPS                      TABLE              ECOMEX                           19246                  1  2147483645

ECMX_DEF                  VBRP                      TABLE              ECOMEX                           17391                  1  2147483645

ECMX_DEF                  VBFA                      TABLE              ECOMEX                           16429                  1  2147483645

ECMX_DEF                  BKPF                      TABLE              ECOMEX                           15972                  1  2147483645

and for that biggest segment i could identified the table with that LOB segment

SQL> col COLUMN_NAME for a45

SQL> r

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