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

[Quoted] A copy of this was sent to sdua_at_solutionsny.com (Sunil Dua) (if that email address didn't require changing) On 21 May 2001 10:38:28 -0700, you 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

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:285415955510

has a script I use called free.sql. It'll show you want you need by tablespace.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp