Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

LOB segment Large in size than Tables

Dear Experts,

I would like to know how to sort out the below issue.

The tables size is within a GB but those LOB segments are 17 or 15 GB in our server.

Tables are TST03,DYNPSOURCE,DWTREE,REPOSRC and etc.

The above four are top size LOB segments in the server.

Oracle release is 11.2.0.2.0

I had gone through  SNOTES and forums.

Still i need more clarifications on how to avoid the growth in feature and best way to compress the largest LOB segments.

Thanks a lot.

Best Regards,

Pradeep

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question