Re: Database Size Question

From: Sanjay Kumar <ora_user_at_hotmail.com>
Date: Tue, 24 Oct 2000 14:47:27 -0700
Message-Id: <10659.120108@fatcity.com>

Yes Ari, Thanks very much. I wanted the physical size of the DB.

Sanjay

• Original Message ----- From: "Ari D Kaplan" <akaplan_at_interaccess.com> To: "jack zhang" <gbc9_at_hotmail.com> Cc: <ora_user_at_hotmail.com>; <oracledba_at_quickdoc.co.uk>; <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 24, 2000 12:25 PM Subject: 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
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.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 - 16:47:27 CDT