Re: Get the size of database

From: John Koo <johnkoo_at_i-wave.net>
Date: Sun, 17 Jan 1999 18:02:14 -0800
Message-ID: <36A29626.41DB@i-wave.net>

paulinelam_at_poboxes.com wrote:
>
> Hi All,
>
> How can I get the size of the database (allocated,occupied, free
> spaces)?
>
> Thanks.
> Pauline

How ? you can look it up in the data dictionary if you have dba privilege!! The tables of interest include: DBA_FREE_SPACE, DBA_TABLESPACES, DBA_EXTENTS, DBA_SEGMENTS, DBA_DATA_FILES ... and many more !
It simply depends how you utilize all that data dictionary tables/views..

John Koo
johnkoo_at_i-wave.net Received on Sun Jan 17 1999 - 20:02:14 CST