Re: Tablespace 'autoextend' indication.

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 08 Oct 1998 18:06:14 GMT
Message-ID: <3627feaa.13536414@192.86.155.100>

A copy of this was sent to Mohammed Ghouse <ghouse_at_ginatech.com> (if that email address didn't require changing) On Wed, 07 Oct 1998 14:27:21 -0700, you wrote:

>When a tablespace is altered to 'autoextend', which Oracle view
>indicates and how does it indicate that a tablespace has 'autoextend'
>on?
>Mohammed
>
>

tablespaces don't have autoextend, files do.

In 7.3, the following query gives you what you want:

select a.file# "File#",

        a.name "File Name",
        initcap(status) || ' ' || initcap(enabled) "Status",
        round(bytes/1024/1024,1) "Curr",
        round(create_bytes/1024/1024,1) "Orig",
        round((bytes-create_bytes)/1024/1024,1) "Diff",
        round( (b.inc*to_number(c.value))/1024/1024, 1 ) "Inc",
        trunc( (b.maxextend*to_number(c.value))/1024/1024) "Max"

from v$datafile a, sys.filext$ b, v$parameter c where a.file# = b.file# (+)
and c.name= 'db_block_size'
/

in 8.0 its in dba_data_files...

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Oct 08 1998 - 13:06:14 CDT