Re: Simple DBA Type Question

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