Re: what all physical space allocated to my DB's

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 21 May 2001 18:17:24 -0700
Message-ID: <3B09BE24.FE155579@exesolutions.com>

Sunil Dua wrote:

> I have my Oracle database 8.1.5 installed on a sun solaris machine
> some time ago... I just want to find out what all physical space
> allocated to the databases installed on it and wether they have
> sufficient space to continue ... I'll appreciate if you could guide me
> a bit.
>
> thanks a lot.
>
> Regards
> Sunil

Look at three things.

The current size of your datafiles - SELECT from DBA_DATA_FILES or DBA_TABLESPACES
The current amount of freespace in your tablespaces SELECT from DBA_FREE_SPACE
The available expansion room on your drives ... at the UNIX prompt: df -k

Then just do the math.

Daniel A. Morgan Received on Mon May 21 2001 - 20:17:24 CDT