Re: Get the size of database

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Mon, 18 Jan 1999 07:12:09 -0500
Message-ID: <36a3252d.0@news.mountain.net>

If you are wanting physical space:

Space Allocated:
select tablespace_name, sum(bytes) total_size from dba_data_files
group by tablespace_name;

Free Space:
select tablespace_name, sum(bytes) total_free from dba_free_space
group by tablespace_name;

If you are wanting memory:
select * from v$sga;

Kenny Gump
OCP 7.3 DBA

---

paulinelam_at_poboxes.com wrote in message <36A06CDF.25D9_at_poboxes.com>...
>Hi All,
>
>How can I get the size of the database (allocated,occupied, free
>spaces)?
>
>Thanks.
>Pauline
Received on Mon Jan 18 1999 - 06:12:09 CST