SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dba_data_files.increment_by: what kind of units?

161380May 5 2003 — edited May 6 2003

I'm confused about the result in the 'increment_by' column in dba_data_files. Can anyone tell me what units are used here? (below is what I did. I would expect a value of 16M/32M or something related...)

CREATE TABLESPACE sushi_data
DATAFILE 'f:\database\hiph\data\sdat01.DBF' SIZE 131136K --128Mb+64Kb bitmap
AUTOEXTEND ON NEXT 16M MAXSIZE 2048M,  --exactly 120 extents max
         'f:\database\hiph\data\sdat02.DBF' SIZE 131136K --128Mb+64Kb bitmap
AUTOEXTEND ON NEXT 16M MAXSIZE 2048M,  --exactly 120 extents max
         'f:\database\hiph\data\sdat03.DBF' SIZE 131136K --128Mb+64Kb bitmap
AUTOEXTEND ON NEXT 32M MAXSIZE 1024M  
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1M;

SQL> select * from dba_Data_files where file_name like '%\SDAT%';

FILE_NAME
--------------------------------------------------------------------------------

   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
F:\DATABASE\HIPH\DATA\SDAT01.DBF
        22 SUSHI_DATA                      134283264      16392 AVAILABLE
          22 YES 2147483648     262144         2048  134217728       16384

F:\DATABASE\HIPH\DATA\SDAT02.DBF
        23 SUSHI_DATA                      134283264      16392 AVAILABLE
          23 YES 2147483648     262144         2048  134217728       16384

F:\DATABASE\HIPH\DATA\SDAT03.DBF
        24 SUSHI_DATA                      134283264      16392 AVAILABLE
          24 YES 1073741824     131072         4096  134217728       16384


SQL> select * from dba_tablespaces where tablespace_name like 'SUSHI_DATA';

TABLESPACE_NAME                INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ -------------- ----------- -----------
MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS    CONTENTS  LOGGING   EXTENT_MAN
----------- ------------ ---------- --------- --------- --------- ----------
ALLOCATIO PLU
--------- ---
SUSHI_DATA                            1048576     1048576           1
 2147483645            0    1048576 ONLINE    PERMANENT LOGGING   LOCAL
UNIFORM   NO


SQL>

Thanx,
L

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2003

Added on May 5 2003

3 comments

2,042 views