Overview

• Starting from ALTIBASE HDB version 5.3., the actual usage of the tablespace can be checked by using the TOTAL_USED_SIZE column information of X$SEGMENT.
• The TOTAL_USED_SIZE column of X$SEGMENT was added in BUG-31372.
• The version reflecting BUG-31372 is as follows.
  • ALTIBASE HDB 5.3.3.33
  • ALTIBASE HDB 5.3.5.15
  • ALTIBASE HDB 5.5.1.0.3
• Therefore, in ALTIBASE HDB 5.3.3, 5.3.5, 5.5.1 versions without BUG-31372 being modified, an error may occur when using the following query.
• The actual usage of undo tablespaces and temporary tablespaces is not available in this version.

Disk tablespace usage query