Re: Simple DBA Type Question

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Mon, 21 Aug 2000 11:55:41 -0700 (PDT)
Message-Id: <10596.115130@fatcity.com>

--0-424238335-966884141=:2482
Content-Type: text/plain; charset=us-ascii

This query will give you the approximate size. The only thing it doesn't account for is the size of the control files which as far as I know cannot be obtained via a database query.

select sum(bytes)/1048576 megabytes
from (select sum(bytes) bytes from v$datafile

      union all
      select sum(bytes*members) bytes from v$log);

  Peter Hazelton <peterhazelton_at_hotmail.com> wrote:

Hi guys

Real quick question here! Using SQL plus, how can I determine the physical size of my database? If that cannot be done, is there a way to see the size of individual tables?

Thanks a lot

Peter

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

-- 
Author: Peter Hazelton
INET: peterhazelton_at_hotmail.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).


---------------------------------
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
--0-424238335-966884141=:2482
Content-Type: text/html; charset=us-ascii



<P style="MARGIN-RIGHT: 0px"><FONT face="Courier New">This query will give you the approximate size. The only thing it doesn't account for is the size of the control files which as far as I know cannot be obtained via a database query.</FONT></P>

<P style="MARGIN-RIGHT: 0px"><FONT face="Courier New">select sum(bytes)/1048576 megabytes&nbsp;<BR>from (select sum(bytes) bytes from v$datafile<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; union all<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select sum(bytes*members) bytes from v$log);<BR></P></FONT>

<P>&nbsp; <B><I>Peter Hazelton &lt;peterhazelton_at_hotmail.com&gt;</I></B> wrote: <BR></P>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">Hi guys<BR><BR>Real quick question here! Using SQL plus, how can I determine the physical <BR>size of my database? If that cannot be done, is there a way to see the size <BR>of individual tables?<BR><BR>Thanks a lot<BR><BR>Peter<BR>________________________________________________________________________<BR>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com<BR><BR>-- <BR>Author: Peter Hazelton<BR>INET: peterhazelton@hotmail.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you w!

ant to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>


<a href="http://mail.yahoo.com/">Yahoo! Mail</a> - Free email you can access from anywhere!

Received on Mon Aug 21 2000 - 13:55:41 CDT