Re: Where in DICT is AUTOEXTEND?

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Wed, 07 Apr 1999 17:52:51 -0700
Message-ID: <370BFDE3.CF09FEF0@earthlink.net>

You can use this query on Oracle 7.xxxxx

---

rem
rem Script: dbfile.sql
rem Created: Vitaliy Mogilevskiy
rem This script displays information about autoextending datafiles rem to turn the autoextend on use this command: rem SQL> alter database datafile '<data_file>' autoextend ON NEXT <integer>M MAXSIZE <integer>M;
rem make sure to specify NEXT and MAXSIZE !!! rem

clear computes
clear breaks

set pages 999
set lines 132
break on tabsp_name skip 1
col file_name format a35 heading "Data File Name" col tabsp_name format a15 heading "Tablespace Name"

col max_size format 999,999,999.99 heading "Max|Size MB"
col inc_by format 999,999.99 heading "Increment|By MB"
col cur_size format 999,999,999.99 heading "Current|Size MB"

-- compute sum of max_size cur_size on tabsp_name

select tn.name      tabsp_name


, fn.name      file_name

, ddf.bytes/1024/1024 cur_size
, nvl(fex.maxextend,0)*tn.blocksize/1024/1024 max_size
, nvl(fex.inc,0)*tn.blocksize/1024/1024 inc_by
from sys.v_$dbfile fn
, sys.ts$ tn
, sys.filext$ fex
, sys.file$ ft
, dba_data_files ddf

where fn.file# = ft.file#

and fn.file# = ddf.file_id
and tn.ts# = ft.ts#
and fn.file# = fex.file#(+)

order by tn.name
/

on Oracle 8 that info is in DBA_DATA_FILES view

+--------------------------------------------------------------------------+
| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
+--------------------------------------------------------------------------+

Jerry Coleman wrote:

> Can someone tell me what dictionary or performance view the autoextend > parameter/options of a datafile for a tablespace is stored? Received on Wed Apr 07 1999 - 19:52:51 CDT