Re: Size of Extents?

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Mon, 5 Nov 2001 11:52:35 -0500
Message-ID: <9s6g3t$115ud0$1@ID-85580.news.dfncis.de>

"jarom" <jarom_at_xotmail.com> wrote in message news:u5zF7.14$h3.106412_at_news.kpnqwest.ch...
> Thanks!
>
> I have a database with db_file_multiblock_read_count=32 and
> db_block_size=2048. Does this mean, I should not assign extents smaller
than
> 64MB (which seems quite large to me for some tables)?

No. It means that the extents should be a multiple of 64k. I don't believe this holds true however for segments that are smaller than 64k (block_size * multiblock_read_count).

-- Chuck Hamilton "Do not be deceived, God is not mocked; for whatever a man sows, this he will also reap. (Gal 6:7 NASB)

application/x-pkcs7-signature attachment: smime.p7s

Received on Mon Nov 05 2001 - 10:52:35 CST