This discussion is archived
1 Reply Latest reply: Jul 15, 2012 9:52 PM by Harsh_v RSS

extent size issue?

Harsh_v Newbie
Currently Being Moderated
SQL> create table my1
2 (OWNER VARCHAR2(30),
3 OBJECT_NAME VARCHAR2(30),
4 SUBOBJECT_NAME VARCHAR2(30),
5 OBJECT_ID NUMBER,
6 DATA_OBJECT_ID NUMBER,
7 OBJECT_TYPE VARCHAR2(19),
8 CREATED DATE,
9 LAST_DDL_TIME DATE,
10 TIMESTAMP VARCHAR2(19),
11 STATUS VARCHAR2(7),
12 TEMPORARY VARCHAR2(1),
13 GENERATED VARCHAR2(1),
14 SECONDARY VARCHAR2(1),
15 NAMESPACE NUMBER,
16 EDITION_NAME VARCHAR2(30))
*17 STORAGE (*
*18 INITIAL 1M*
*19 NEXT 2M*
*20 PCTINCREASE 10*
*21 MINEXTENTS 1*
*22 MAXEXTENTS 30 );*

Table created.

SQL> select bytes/1024/1024 from user_segments where segment_name='MY1';

BYTES/1024/1024
---------------
1

SQL> SELECT SEGMENT_NAME,TABLESPACE_NAME,EXTENT_ID,BYTES/1024/1024 FROM USER_EXTENTS WHERE SEGMENT_NAME='MY1';

SEGMENT_NAME TABLESPACE_NAME EXTENT_ID BYTES/1024/1024
--------------------------------------------------------------------------------- ------------------------------ ---------- ---------------
MY1 SYSTEM 0 1




SQL> insert into my1 select * from all_objects;

71185 rows created.


SQL> select bytes/1024/1024 from user_segments where segment_name='MY1';

BYTES/1024/1024
---------------
8

SQL> SELECT SEGMENT_NAME,TABLESPACE_NAME,EXTENT_ID,BYTES/1024/1024 FROM USER_EXTENTS WHERE SEGMENT_NAME='MY1';

SEGMENT_NAME TABLESPACE_NAME EXTENT_ID BYTES/1024/1024
--------------------------------------------------------------------------------- ------------------------------ ---------- ---------------
MY1 SYSTEM 0 1
MY1 SYSTEM 1 1
MY1 SYSTEM 2 1
MY1 SYSTEM 3 1
MY1 SYSTEM 4 1
MY1 SYSTEM 5 1
MY1 SYSTEM 6 1
MY1 SYSTEM 7 1







After these analysis i found extent has same size even i was give storage parameter -----
+19 NEXT 2M+
+20 PCTINCREASE 10+


Why extent is same size?


Regards,
Harshit DBA

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points