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

From: Francesco Principe <francesco.principe_at_gruppocm.it>
Date: Tue, 22 May 2001 16:24:30 +0200
Message-ID: <9edt18$em6$1@stargate1.inet.it>

You can know the physical space allocated by this select

select t.name, d.name, bytes
from v$datafile d, v$tablespace t
where d.ts#=t.ts#

this select give the name of the data file, the place where they are stored an the bytes allocated

"Sunil Dua" <sdua_at_solutionsny.com> ha scritto nel messaggio news:bc03ebd5.0105210936.70ac71f5_at_posting.google.com...
> 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
Received on Tue May 22 2001 - 09:24:30 CDT