Database Administration (MOSC)

MOSC Banner

Compress Segment LOB

edited Jul 4, 2012 5:12AM in Database Administration (MOSC) 5 comments
Hi, i need know the following topics:

I have a database with size 2.66 TB, this database have a table with segment LOB, this segment have:

OWNER                          SEGMENT_NAME                                                                       TBSIZE_MB
------------------------------ --------------------------------------------------------------------------------- ----------
WSPROVI                        SYS_LOB0000985181C00003$$                                                                  4
WK_TEST                        DR$WK$DOC_PATH_IDX$X                                                                       5
WK_TEST                        DR$WK$DOC_PATH_IDX$I                                                                       5
MDSYS                          SYS_LOB0000888580C00006$$                                                                  9
WSPROVI                        PRO_ERROR_APP                                                                             20
WSPROVI                        PRO_ARCHIVO_AUX_PK                                                                       128
WSPROVI                        PRO_ARCHIVO_AUX                                                                          272
WSPROVI                        SYS_C0038245                                                                             312
WSPROVI                        SYS_IL0000030523C00004$$                                                                 520
WSPROVI                        PRO_ARCHIVO_PK                                                                           704
WSPROVI                        PRO_ARCHIVO_NOMBRE_IND                                                                  1644

OWNER                          SEGMENT_NAME                                                                       TBSIZE_MB
------------------------------ --------------------------------------------------------------------------------- ----------
WSPROVI                        PRO_ARCHIVO                                                                             3968
WSPROVI                        SYS_LOB0000030523C00004$$                                                            2027967

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