Re: Q: I need to know the size of a database

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 23 Oct 1999 01:23:21 GMT
Message-ID: <387d0d98.443342070@netnews.worldnet.att.net>

On 22 Oct 1999 15:31:11 GMT, mau_at_kool.do.isst.fhg.de (Patrick Mau) wrote:

>I must admit that I'm a newbie.
>I have orcale 8.0.5 on solaris 2.7 and I need to know
>how much space is currently in use for a database.

To get space allocated to tables, query dba_extents.

select sum(bytes) from dba_extents;

To get unallocated space:

select sum(bytes) from dba_free_space;

Log in as SYSTEM, or some other privileged user, in order to execute these queries.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Fri Oct 22 1999 - 20:23:21 CDT