Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Extent inffo does not match table size ?

Extent inffo does not match table size ?

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 10 Oct 2006 01:14:40 -0700
Message-ID: <1160468080.022026.197530@c28g2000cwb.googlegroups.com>


(O 9.2.0.1.0)

Ok, so obviously I haven't quite understood something here, hope s/o can help.

When I look at the Information on my table (using Toad), it reports: STORAGE (

            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )

However, it also reports:
Table Size = 128 MB
Number of Extents = 87

So how can a table of 128MB be made up of 87 x 64KB?

As I said, obviously I've either misunderstood something or look at the wrong information :-)

thanks,
Martin

p.s.:
Tablespace:

CREATE TABLESPACE "USERS"
    LOGGING
    DATAFILE '&2\ORADATA\&1\USERS01.DBF' SIZE 2048M     AUTOEXTEND
    ON NEXT 10240K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL     SEGMENT SPACE MANAGEMENT AUTO
/ Received on Tue Oct 10 2006 - 03:14:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US