Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How do you determine free space in DB files?
Check out these tables: DBA_DATA_FILES and DBA_FREE_SPACE and link these 2 by FILE_ID or TABLESPACE_NAME. Instead of bytes you can show as meg by bytes/1024/1024. HTH.
On Fri, 02 May 1997 20:09:24 GMT, dandrade_at_icao.org (Dalton M. de Andrade) wrote:
>
>I would like to know how to determine the following:
>
>1. How much space (in bytes) is allocated in the datafile(s) for a the
>database;
>
>2. How much of the allocated space is used/free;
>
>3. How much unallocated space there still is in the datafile(s).
>
>We're running Oracle 7.1.4 on a SCOUnix box.
>
>Any help will be appreciated.
>
>Pls e-mail me at dandrade_at_icao.org.
>
Carl Hoang choang_at_visi.com SofTech Systems, Inc. (612) 424-7886Received on Fri May 02 1997 - 00:00:00 CDT