Question

3
Replies
254
Views
SOURAVSG Member since 2009 2 posts
TD
Posted: September 30, 2016
Last activity: October 5, 2016
Closed

Unusual large DB table SYS_LOB0000063510C00085$$

Hi Team,

We are trying to understand why SYS_LOB0000063510C00085$$ is significantly huge?Is there any remediation to fix the size of this table? We are in the process of migration from 5.5 to 7.2 and would like to see if there is an opportunity to that this table can be skipped while exporting or could be reduced in size?

NBB_WORK is our work table. The  SYS_LOB0000063510C00085$$  table corresponding to it(last row below) is of very large size.

OWNER                          SEGMENT_NAME                   SEGMENT_TYPE S.BYTES/1024/1024 TABLE_NAME                     COLUMN_NAME

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

OSB_RULES_PRD  SYS_LOB0000063650C00049$$    LOBSEGMENT  115.1875 PC_ASSIGN_WORKLIST     PZPVSTREAM
OSB_RULES_PRD  SYS_LOB0000063890C00085$$    LOBSEGMENT  160 NBB_BRN_WORK                         PZPVSTREAM
OSB_RULES_PRD  SYS_LOB0000063728C00053$$    LOBSEGMENT  379.1875 PR4_RULE_PROPERTY      PZPVSTREAM
OSB_RULES_PRD  SYS_LOB0000063734C00039$$    LOBSEGMENT   396.1875 PR4_RULE_FILE                 PZPVSTREAM
OSB_RULES_PRD  SYS_LOB0000063725C00051$$    LOBSEGMENT   904.125 PR4_RULE_FLOW                PZPVSTREAM
OSB_RULES_PRD  SYS_LOB0000063722C00123$$    LOBSEGMENT   1984.125 PR4_RULE                           PZPVSTREAM
OSB_RULES_PRD  SYS_LOB0000087496C00085$$    LOBSEGMENT   2884.1875 NBB_RMT_WORK             PZPVSTREAM
OSB_RULES_PRD  SYS_LOB0000063510C00085$$    LOBSEGMENT  521128.125 NBB_WORK                    PZPVSTREAM

 

System Administration
Moderation Team has archived post
Share this page LinkedIn