Skip to Content
avatar image
Former Member

Large LOB-Segments in Database

Hello togehther,

we've a great amount of large LOBSEGMENTs in our Oracle Database.

For example

SYS_LOB0000013822C00007$$ Sizes: 53.942.464 KBytes

SYS_LOB0000013872C00006$$ Sizes: 15.286.464 KBytes

Question is:

How can I shrink (reduce space ) these Segements?

We have Oracle 12.1.0.2.0

Best regards,

Mathias Schneider

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 15, 2016 at 07:33 AM

    Hi,

    Have a look at SAP KBA 2142497 - What to do for large lobsegment on Oracle database?

    Hope this will help you.

    Regards,

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2016 at 07:33 AM

    Hi Mathias,

    You need to find the corresponding table or index from dic dba_lobs.

    Afterwards please table reorganize or index rebuild to shrink these segments.

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded