Re: How Can I determine the size of My Oracle Database?

SatarNag (satarnag_at_aol.com) wrote:
: How Can I determine the size of my Oracle 7.3 Database? Is thier a
: dictionary view that I can look at? Please Help me by E-mailing me at
: SatarNag_at_aol.com
:
: Thank You in Advance for any help,
: Satar Naghshineh
:
The majority of the size comes from the datafiles. To find out how many megabytes are allocated by ALL tablespaces, type:

select sum(bytes)/1024/1024 from dba_data_files;

Add to this the size (in megabytes) of your redo logs:

select sum(bytes)/1024/1024 from v$log;

The above two queries will show you how large your database is. Also, if you are in archivelog mode, you will generate files in your archivelog destination. Issue the following query to see where your archived redo logs get placed:

select * from v$parameter where name = 'log_archive_dest';

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 90+ Oracle tips, visit my Web Page:                       <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->