Determining available space for the database

Before resizing an existing datafile or adding a new one, determine how much space is available for the database on the hard drive.

To determine available space for the database on a Windows server

To determine available space for the database on a Solaris server

At the terminal window, type
df -k directory_path

For example:
$ df -k /usr/mvf/data/dbase/data1

The following information is displayed on-screen:

Filesystem	kbytes	used	avail	capacity	Mounted on
/dev/dsk/c0t0d0s7	1590199	960634	613664	62%	/exported

where:

Column	Description
Filesystem	The name and path
Kbytes	The total disk size
used	The amount of disk space already used
avail	The amount of disk space available for use
capacity	The percentage of the disk that is full
Mounted on	Where the file system is mounted