SAP Knowledge Base Article - Preview

3800526 - How to identify largest lob usage and per-column byte sizes in SAP HANA

Symptom

  • A large amount of LOB space is reported for the database schema in system health reports.
  • Users need to identify which tables and columns contain the largest LOB segments by disk size.
  • Users need row counts and min/max/avg byte length statistics for specific LOB columns.
  • No specific error messages are reported.


Read more...

Environment

  • SAP HANA Database

Product

SAP HANA, platform edition all versions

Keywords

hana, lob, large lob space, m_table_lob_statistics, disk size, memory size, binary size, clob, blob, row count, length, dbacockpit, column store, largest tables, space analysis , KBA , HAN-DB-PER , SAP HANA Database Persistence , How To

About this page

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

Search for additional results

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