-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|