Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: I need to know the size of a database
Patrick Mau <mau_at_kool.do.isst.fhg.de>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
news:940606413.267689_at_baguette.do.isst.fhg.de¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> Hallo all,
>
> I must admit that I'm a newbie.
> I have orcale 8.0.5 on solaris 2.7 and I need to know
> how much space is currently in use for a database.
>
> Can someone please tell me some sqlplus commands to
> get that information ?
>
> Please email me also,
> Thanks
>
Like this
sql> select sum(bytes) from v$datafile;
You can get the total size of all datafiles.
Received on Fri Oct 22 1999 - 11:04:33 CDT