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 Big is My database?

Re: How Big is My database?

From: Gary Assa <gsa_at_panix.com>
Date: 1997/07/25
Message-ID: <5ra8ev$ml6@panix.com>#1/1

>I am tryinr to figuire how much space does my Oracle 7.3 Database take up
>on my server. I am new to Oracle and I was wonderring if there was a View
>that displays that information. Please Help....My e-mail is
compute sum of bytes on report
break on report  

select * from dba_data_files;  

Now, if you really want ALL files in use, use these too, but they will be small:  

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

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html
Received on Fri Jul 25 1997 - 00:00:00 CDT

Original text of this message

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