Subject: Re: How Can I determine the size of My Oracle Database?
Newsgroups: comp.databases.oracle.tools
References: <19970724172301.NAA16649@ladder01.news.aol.com>
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider
Reply-To: akaplan@interaccess.com
SatarNag (satarnag@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@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: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page