Re: Extent map block

Hi Jonathan,

I think you may have misunderstood the question. Your answer appears to address the amount of space needed the tablespace's bitmap blocks, whereas I think the question is about the extent map blocks needed within the segment itself.

Assuming an 8K block size, there would be 505 extents represented in the extent table in the segment header block and up to 1007 extents in each subsequent extent map block. So a 1G table in 64K extents would require 16 extent map blocks.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>

1Gb at 64K needs about 32K of map.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:                 Addison Wesley Longman
Book bound date:     8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i

cust102_at_my-deja.com wrote in message <8uf21u$ea8$1_at_nnrp1.deja.com>...


>Hi,

>   Does anyone know how many extents can an extent map block cover? For

>a locally managed tablespace with uniform extent size of 64k how many

>extent map blocks are needed for 1GB segment?

>

>

>raghuvir

>