Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out how how big a database is?
>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