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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Actual size of database

Re: Actual size of database

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Tue, 01 May 2001 10:17:05 -0700
Message-ID: <F001.002F6915.20010501102617@fatcity.com>

set echo off
set pagesize 60
@my_tabs
spool sp_used
rem Calculate Percent of Space Used in Each Table Space rem
column tablespace_name format a20
column tablespace heading TSPACE_NAME
column megs_alloc format 999,999.99
column megs_free format 999,999.99
column pct_used format 999.99

column megs_used format 999,999.99
column free_extents format 999,999
column free_extents heading FREE_EXT

break on report
compute sum of megs_alloc on report
compute sum of megs_free on report
compute sum of megs_used on report

ttitle 'Space Used'
select a.tablespace_name, (a.bytes/1048576) megs_alloc,
    (b.bytes/1048576) megs_free, 
    ((a.bytes - b.bytes)/1048576) megs_used,
    (100 - ((b.bytes/a.bytes) * 100)) pct_used,
    b.free_extents
from tjs_allocated_space a, tjs_free_space b where a.tablespace_name = b.tablespace_name (+)

    order by a.tablespace_name;
spool off
set pagesize 20
set feedback off

drop table tjs_dba_extents;
drop table tjs_free_space;
drop table tjs_allocated_space ;

set feedback on
ttitle off

>>> RICHARD.T.CALE_at_saic.com 05/01/01 02:11PM >>>
Hi All,

Oracle 8.0.5 NT 4
Does anyone have a script they would share that can calculate the ACTUAL size of a database(space_used) not what has been allocated?

Thanks
Rick

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue May 01 2001 - 12:17:05 CDT

Original text of this message

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