Start of Content Area

This graphic is explained in the accompanying text DATASTATISTICS  Locate the document in its SAP Library structure

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

 

End of Content Area