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 -> Size of next extent

Size of next extent

From: <akkha_at_my-deja.com>
Date: Tue, 02 Nov 1999 06:55:32 GMT
Message-ID: <7vm1t3$ckv$1@nnrp1.deja.com>


Hi,

I have a simple question.

Following is the result of a query I done againt a certain segment. The query is :

select extent_id,blocks,bytes from user_extents   where segment_name= &some_segment_name   order by extent_id

The result is

EXTENT_ID BLOCKS BYTES
---------- ---------- ----------

         0          5      40960
         1          5      40960
         2         10      81920
         3         15     122880
         4         20     163840
         5         30     245760
         6         45     368640
         7         65     532480
         8         95     778240
         9        140    1146880
        10        210    1720320
        11        315    2580480
        12        475    3891200
        13        710    5816320
        14       1065    8724480
        15        505    4136960
        16        260    2129920
        17        285    2334720
        18          5      40960
        19        130    1064960

The table storage clause is something like (initial 40K next 80K pctincrease 50)

My question is : What does extent_id = 0 stands for. How is the size of next extents arrive at? I thought it is 50% than the last extent but I could not get the result correct. In particular, for extent 18, I allocate 40K and I thought extent 19 would be 60K. But it is not, instead it asks for 5394 blocks which is roughly is 1065 * 1.5 * 1.5 * 1.5 * 1.5, where 1065 is size of extent 14. What happens? Oracle just calculates the size of next extent based on some hidden formula? Do I miss anything?

Anthony

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 02 1999 - 00:55:32 CST

Original text of this message

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