Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do you determine free space in DB files?

Re: How do you determine free space in DB files?

From: Carl Hoang <choang_at_visi.com>
Date: 1997/05/02
Message-ID: <336a651e.2430734@news.visi.com>#1/1

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-7886
Received on Fri May 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US