Which data-dictionary store the 'AUTOEXTEND' size?

From: <dominica_at_gmail.com>
Date: 26 Sep 2005 18:55:05 -0700
Message-ID: <1127786105.330085.68530@g47g2000cwa.googlegroups.com>

Hi All,

I am running oracle 8.1.7.4 on Solaris 5.9 (os is 64 bits) and oracle is 32 bit.

I have this script:

spool create_small_tbsp.log
set echo on
create tablespace dom_small datafile
'/u08/oradata/dom10g/dom10g/dom_small01.dbf'

     size 256K
     autoextend on next 512K
     extent management local uniform size 128K

;
spool off
set echo off

1. I create this tablespase
2. I create my user domuser
3. I do "ls on the datafile".(and write down the datafile's size)
4. I create a test table (test1)
5. I insert a bunch of test data. Everything is good
6. I do ls on the same datafile again, it does autoextend correctly.

My question is which table/column show the autoextend's size? I have the following 2 query?
But I don't see the 512K for the "autoextend" value there??

Am I looking at the wrong tables ???

and I look at the data-dictionary tables:

  1 select * from dba_tablespaces
  2* where tablespace_name = 'DOM_SMALL' SQL> /

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT

MIN_EXTENTS
------------------------------ ---------- -------------- -----------

---

MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
----------- ------------ ---------- --------- --------- --------- ---

---

ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG --------- --- ------ -------- ----------- ---

DOM_SMALL                            8192         131072      131072
       1
 2147483645            0     131072 ONLINE    PERMANENT LOGGING   NO

LOCAL
UNIFORM NO MANUAL DISABLED NOT APPLY NO SQL> select * from dba_data_files where tablespace_name = 'DOM_SMALL'   2 ;

FILE_NAME

---

   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS


---------- ------------------------------ ---------- ----------

---

RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ----------

---

/u08/oradata/dom10g/dom10g/dom_small01.dbf

         6 DOM_SMALL                          786432         96
AVAILABLE
           6 YES 3.4360E+10    4194302           64     655360

80

Thanks,

Dominica Received on Mon Sep 26 2005 - 20:55:05 CDT