DATAVOLUMES

Prerequisites

Log on to the database instance DEMODB.

Examples

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

·        Displaying the description and size of the volume.

SELECT path, configuredsize
  FROM SYSINFO.DATAVOLUMES

·        Displaying the area available for data and the area used for data of the volume with ID 1.

SELECT usablesize, usedsize, usedsizepercentage
  FROM SYSINFO.DATAVOLUMES
    WHERE ID = 1