Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    39

    Unanswered: Question on table extents

    I created one table as following in a new(empty) tablespace.
    Why it has created 16 extents ? I was expecting ONE extent.
    Thanks in advance.


    CREATE TABLE APPS (
    APP_ID VARCHAR2(60) NOT NULL,
    DESCRIPTION VARCHAR2(255) NULL)
    TABLESPACE TS1 STORAGE ( INITIAL 1M NEXT 1M PCTINCREASE 0) ;

    SQL>select SEGMENT_NAME , count(*) from dba_extents where TABLESPACE_NAME = 'TS1' group by SEGMENT_NAME ;

    SEGMENT_NAME COUNT(*)
    -------- --
    APPS 16


    SQL> select BLOCK_ID from dba_extents where TABLESPACE_NAME = 'TS1'
    2 ;

    BLOCK_ID
    ----------
    9
    17
    25
    33
    41
    49
    57
    65
    73
    81
    89
    97
    105
    113
    121
    129

    16 rows selected.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    what is your extent size choosen in the tablespace spec?
    supposed 64K though allocating 1M requires 16 extents

Posting Permissions

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