initial extent size of tablespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 15

Thread: initial extent size of tablespaces

Threaded View

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    initial extent size of tablespaces

    hi
    while creating tablespaces we can specify the default storage parameters.
    first tablespace app_data-
    when i give the initial size as 256k, next as 256k and pctincrease as 0. logically it means that the third extent would have 256k as its size.
    second tablespace app_data1
    if i change the pctincrease to 50% then why does it change the initial extent size as per the output that i received.
    ------------------------------------------------
    the first query is:
    create tablespace app_data
    datafile 'e:\oracle\oradata\db1\app_data.dbf' size 5m
    default storage( initial 20k next 20k minextents 2 pctincrease 0
    maxextents 20)
    blocksize 4k minimum extent 20k logging online permanent
    the output is:
    TABLESPACE_NAME | BLOCK_SIZE | INITIAL_EXTENT | NEXT_EXTENT| MIN_EXTENTS | MAX_EXTENTS| PCT_INCREASE | MIN_EXTLEN |STATUS CONTENTS | LOGGING | EXTENT_MAN | ALLOCATIO | PLU SEGMEN
    ------ ---------- --------- --- -------------------------------------
    APP_DATA | 4096 | 20480 | 20480 |
    1 | 2147483645| 0 | 20480 |ONLINE PERMANENT | LOGGING | LOCAL | UNIFORM | NO MANUAL
    --------------------------------------------------------------------
    the second query is:
    create tablespace app_data1
    datafile 'e:\oracle\oradata\db1\app_data1.dbf' size 5m
    default storage( initial 20k next 20k minextents 2 pctincrease 50
    maxextents 20)
    blocksize 4k minimum extent 20k logging online permanent
    the output is:
    TABLESPACE_NAME | BLOCK_SIZE | INITIAL_EXTENT | NEXT_EXTENT| MIN_EXTENTS | MAX_EXTENTS| PCT_INCREASE | MIN_EXTLEN |STATUS CONTENTS | LOGGING | EXTENT_MAN | ALLOCATIO | PLU SEGMEN
    ------ ---------- --------- --- -----------------------------------
    APP_DATA1 | 4096 | 65536 | |
    1 | 2147483645| | 65536 |ONLINE PERMANENT | LOGGING | LOCAL | SYSTEM | NO MANUAL
    -------------------------------------------------------------------

    why does the allocation change to system in the second case.
    thanks
    Last edited by ser; 05-29-2003 at 03:01 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width