2142497 - What to do for large lobsegment on Oracle database? | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2142497 - What to do for large lobsegment on Oracle database?

Symptom

In the DB02\DBACOCKPIT -> Space -> Segments -> Overview -> Tab Top Sizes, you notice the lobsegment is occupied a lot of database space and you want to reduce the lobsegment size.

temp1.jpg

Example:

Lobsegment SYS_LOB0000331264C00004$$


Read more...

Environment

  • SAP release independent
  • Oracle release independent

Keywords

large lobsegment, lobsegment, reduce logsegment size, lob, securefile, compression, securefile compression, table reorganization, housekeeping, growth of lobsegment, lob segment , KBA , BC-DB-ORA , Oracle , BC-DB-ORA-DBA , Database Administration with Oracle , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.