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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out how how big a database is?

Re: How to find out how how big a database is?

From: L120bj <l120bj_at_aol.com>
Date: 1998/01/21
Message-ID: <19980121204300.PAA26550@ladder02.news.aol.com>#1/1

>Subject: How to find out how how big a database is?
>From: "Metrix" <sherryl_at_metrix-inc.com>
>Date: 1/19/98 7:13PM GMT
>Message-id: <01bd250e$22f20c60$1a0110ac_at_metrix4047.metrix-inc.com>
>
>In Oracle 7.2 how do I find out how big a database is, i.e. how much disk
>space it's used?
>
>Sherry Li
>
>
>
>
>
>
>
>

Try
select sum(bytes)
from sys.dba_data_files

depending on the size of your database you may need to use 'set numwidth' in sqlplus. This will not include the size of the redo logs or the control files. Also, if your database uses extendable datafiles, then this will not show how large the database may grow to.

Hope this helps

   Rob Received on Wed Jan 21 1998 - 00:00:00 CST

Original text of this message

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