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

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

select * from v$datafile;
select * from v$controlfile;
select * from v$logfile;
select * from v$tempfile;

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"