Solved

Autoextent in Oracle

Posted on 2004-03-22
7
556 Views
Last Modified: 2008-03-03
How to know that a table space is having a autoextent after the tablespace is created .

Can any one give me the solution . This is some thing urgent .

0
Comment
Question by:ratnapr4
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 8

Accepted Solution

by:
baonguyen1 earned 25 total points
ID: 10648645
YOu can try this:

select FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE from  dba_data_files ;

0
 
LVL 2

Expert Comment

by:CallumT
ID: 10656313
Maybe also include BYTES (to see how large data-file is) and MAXBYTES (how large data-file can grow to )

in the above query from baonguyen1
0
 
LVL 1

Expert Comment

by:balee
ID: 10666746
which version of oracle? In oracle 7.3 it is different.
0
 
LVL 2

Expert Comment

by:CallumT
ID: 10672211
In version 7 , you should query sys.filext$.

 desc sys.filext$ ;
 Name                            Null?    Type
 ------------------------------- -------- ----
 FILE#                           NOT NULL NUMBER
 MAXEXTEND                       NOT NULL NUMBER  (no of db_blocks that file can extend to
 INC                             NOT NULL NUMBER    (no. of db_blocks file will increment by)

If there are no rows, then no data-files are autoextensible.

Join FILE# with file_id in dba_data_files to get file_name.

select d.file_name, f.maxextend, f.inc
  2  from sys.filext$ f, dba_data_files d
  3* where f.file# = d.file_id
hord SQL> /

FILE_NAME                       MAXEXTEND        INC
------------------------------ ---------- ----------
/db/hord/data/ct_test_01.dbf        25600       2560
0
 
LVL 5

Expert Comment

by:fmonroy
ID: 10719214
the easies way is to use DBA Studio, goto Storage, then check datafiles for that tablespace (the autoextents are for datafiles not tablespaces)
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question