Re: How to get the autoextend size?

Stephenie, Run the following script to id autoextend info.

rem THIS SCRIPT IS RUN AGAINST INSTANCES THAT HAVE AUTOEXTEND ON FOR TABLESPACES
rem THE sys.filext$ TABLE ONLY EXISTS AFTER YOU HAVE USED THE AUTOEXTEND OPTION
rem
ttitle "FILES THAT HAVE AUTOEXEND ENABLED" set linesize 100
col file_name format a45
select f.file_name file_name,e.maxextend,e.inc " 8 KB Increaments", round(sum(bytes/1024/1024),2) " MB ALLOCATED" from dba_data_files f,sys.filext$ e
where f.file_id=e.file#
group by f.file_name,e.maxextend,e.inc;

Cheers,
Dennis Buddenborg
OCP DBA - Valeo, Inc.

Stephanie Wood wrote:

> What table or view do I query to find out the autoextend size
> that is set on a datafile? I know that I can find this through
> the GUI storage manager. But I'd like to do it via
> SQL*PLUS. I have both Oracle 8.0.5 and 7.3.2 running.
>
> Thanks!
> Stephanie
Received on Fri Jan 22 1999 - 09:20:17 CST