Name

fs_space — report free, total, or used disk space for a file-system path

Synopsis

integer fs_space( in path varchar,
  in kind varchar);
 

Description

fs_space returns disk-space information for the file system containing path. The optional kind argument selects which quantity to return: 'free' (default), 'total', or 'used', in bytes.

Parameters

path

A path on the file system of interest.

kind

Optional: 'free' (default), 'total', or 'used'.

Return Types

An integer byte count.

Examples

Example 24.122. Free space on the database directory

SQL> select fs_space ('.', 'free');
      


© 1992 - OpenLink Software. All rights reserved.

Making Technology Work for You®