Re: Database Size Question

You are correct. Still, redo logs are usually much smaller than datafiles. I am still not sure if this is what Sanjay was asking.

Sanjay - were you looking for the physical disk size of the database, the memory size of the database, or the physical size of all of your tables/indexes/objects?

-Ari

On Tue, 24 Oct 2000, jack zhang wrote:

> ari,
>
> your query only includes one member size of each log group, try this below
> to include all member size of each log group.
>
> select sum(bytes/1048576) "MB"
> from v$log a, v$logfile b
> where a.group# = b.group#;
>
> jack
>
>
> >From: Ari D Kaplan <akaplan_at_interaccess.com>
> >To: Sanjay Kumar <ora_user_at_hotmail.com>
> >CC: Oracle Discussion List <oracledba_at_quickdoc.co.uk>, "Oracle List
> >\(Telelist\)" <ORACLE-L_at_fatcity.com>
> >Subject: Re: Database Size Question
> >Date: Tue, 24 Oct 2000 12:48:05 -0500 (CDT)
> >
> >If you want the physical size of all tablespaces:
> >
> >SELECT sum(bytes)/1048576 "Megs"
> >FROM dba_data_files;
> >
> >To this, add redo logs:
> >
> >SELECT sum(bytes)
> >FROM V$LOG;
> >
> >Control files are negligible compared to the above.
> >
> >Best regards,
> >
> >-Ari Kaplan
> >Independent Oracle DBA Consultant
> >
> ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> ><-> For 385+ Oracle tips, visit: <->
> ><-> <->
> ><-> www.arikaplan.com <->
> ><-> <->
> ><-> email: akaplan_at_interaccess.com <->
> ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> >
> >
> >On Tue, 24 Oct 2000, Sanjay Kumar wrote:
> >
> > > Hi,
> > >
> > >
> > > How do I find the size of my database. I run Oracle816 on Solaris.
> > >
> > >
> > > TIA
> > > Sanjay
> > >
> >
> >
> >--------
> >Think you know someone who can answer the above question? Forward it to
> >them!
> >to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> >to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> >
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
>
> --------
> Think you know someone who can answer the above question? Forward it to them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
Received on Tue Oct 24 2000 - 14:25:18 CDT