DATASTATISTICS

Prerequisites

Log on to the database instance DEMODB.

Examples

You can use the system tableDATASTATISTICS to determine the following database information, among other things:

·        Displaying the fill level of the database instance

SELECT usablesize, usedsize, usedsizepercentage, datafull
  FROM SYSINFO.DATASTATISTICS

·        Displaying which part of the database instance is occupied with permanent and temporary data, respectively.

SELECT usedpermanentsize, usedtemporarysize
  FROM SYSINFO.DATASTATISTICS