cancel
Showing results for 
Search instead for 
Did you mean: 

Large LOB-Segments in Database

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member182657
Active Contributor
0 Kudos

Hi,

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

Hope this will help you.

Regards,

Gaurav

Answers (1)

Answers (1)

JamesZ
Advisor
Advisor
0 Kudos

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