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
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
