Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: I need to know the size of a database

Re: I need to know the size of a database

From: Kyoungrok, Lee <tunnel_at_hananet.net>
Date: Sat, 23 Oct 1999 01:04:33 +0900
Message-ID: <eS%P3.156$435.4023@news.hananet.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US