Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Simple DBA Type Question

Re: Simple DBA Type Question

From: <sean.hull_at_pobox.com>
Date: Mon, 21 Aug 2000 10:46:11 -0400 (EDT)
Message-Id: <10596.115098@fatcity.com>


On Mon, 21 Aug 2000, Peter Hazelton wrote:

> 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?

Total size like this:

SQL> select sum(bytes)/1024 "K bytes" from dba_data_files;

   K bytes


    245760

Used size like this:

SQL> select sum(bytes)/1024 "K bytes" from dba_segments;

   K bytes


     69426 Received on Mon Aug 21 2000 - 09:46:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US