Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How Big is My database?
>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.htmlReceived on Fri Jul 25 1997 - 00:00:00 CDT