RE: AutoExtend

From: Glenn Travis <c-glenn.travis_at_wcom.com>
Date: Fri, 20 Jul 2001 13:24:39 -0700
Message-ID: <F001.003506B0.20010720130050@fatcity.com>

Here is a very good script to show you alot about your datafiles. If Max Auto Extend is > 0, then autoextend is on. (All due credit to the author of the script, as it is unknown to me).

-start script
set linesize 132
set pagesize 59
column filename for a55
column tablespace for a15
column cur heading "Data|File|Size" justify right column used heading "Tot|Used|Space" justify right

column max heading "Max|Auto|Extend" justify right
column inc heading "Auto|Extend|Increm" justify right
column ext heading "No Of|Free|Extnts" justify right

column hifre heading "High|Free|Extent" justify right column totfre heading "Tot|Free|Space" justify right

select d.tablespace_name tablespace,

        d.file_name filename,
        to_char((d.blocks * 8192)       /1048576,'9,999')||'M'  cur,
        to_char( ((d.blocks *
8192)/1048576)-(sum(s.bytes/1048576)),'9,999' )||'M' used,
        to_char((decode(f.maxextend,null,0,f.maxextend) * 8192)


/1048576,'999,999')||'M'  max,

        to_char((decode(f.inc,null,0,f.inc) * 8192)


/1048576,'9,999')||'M'  inc,

        to_char(count(*),'9,999')                               ext,
        to_char(max(s.bytes)            /1048576,'9,999')||'M'  hifre,
        to_char(sum(s.bytes)            /1048576,'9,999')||'M'  totfre
from sys.dba_data_files d,sys.filext$ f,sys.dba_free_space s
where (d.file_id         = f.file#(+)
  and s.file_id      = d.file_id)

and not (d.blocks = f.maxextend(+))
group by d.tablespace_name,d.file_name,d.blocks,f.maxextend,f.inc
/

quit
-end script

-----Original Message-----
Cupp, Jr.
Sent: Friday, July 20, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L

How can I determine if tablespaces are set up in autoextend?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael E. Cupp, Jr.
  INET: mcupp_at_columbus.rr.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: Glenn Travis
  INET: c-glenn.travis_at_wcom.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).

Received on Fri Jul 20 2001 - 15:24:39 CDT