1 Reply Latest reply: Jul 15, 2012 11:52 PM by Harsh_v RSS

    extent size issue?

    Harsh_v
      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