Re: Simple DBA Type Question

You can determine the size of the whole database by using the following: SELECT (SUM(BLOCKS)*4096) DB_SIZE from dba_extents;

You can get the size of table by using this: SELECT (SUM(BLOCKS)*4096) DB_SIZE from dba_segments where segment_name='your_segment_name' and segment_type='TABLE';

Have a look at these two views to get variations on the theme.

HTH,
Ruth
----- Original Message -----
From: Peter Hazelton <peterhazelton_at_hotmail.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, August 21, 2000 10:44 AM
Subject: Simple DBA Type Question

> 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).
Received on Mon Aug 21 2000 - 09:45:49 CDT