Re: how to figure out how much disk space is being used?

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Wed, 24 Oct 2001 10:21:12 -0400
Message-ID: <9r6iou$s11g3$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"oofoof" <oofoofoof_at_ureach.com> wrote in message news:894b11eb.0110240601.7270564b_at_posting.google.com...
> How do I figure out how much disk space is being used by a table
> in my database?

Tables don't really consume space on disk directly The reside in a tablespace that could also contain other objects. A tablespace in turn is made up of datafiles on the physical side and that's what actually takes up the disk space.

DBA_TABLES.BLOCKS tells you how many database blocks are used by the table. You first have to analyze the table to populate this column though. DBA_SEGMENTS.BYTES tells how many bytes are allocated in the tablespace for the table. To see how many bytes the tablespace is consuming in the filesystem you need to sum DBA_DATA_FILES.BLOCKS for the tablespace in question.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO9bOVWm5A4kkb4ZsEQIqKQCgrScmHBv/wasTwuwEyH9kVujN22gAoNS0 RrYUzj5cUaZQoJe8JEXomUJ8
=lD5x
-----END PGP SIGNATURE----- Received on Wed Oct 24 2001 - 09:21:12 CDT