Re: Block size qn

From: Neil Chandler <neil_chandler_at_hotmail.com>
Date: Wed, 10 Jun 2020 16:09:23 +0000
Message-ID: <DB7PR10MB2090736FB2C86C7756169BD685830_at_DB7PR10MB2090.EURPRD10.PROD.OUTLOOK.COM>

General rule of thumb: stick with 8k unless you have a very good reason, and have tested and proven that 16k provides tangible benefits over 8k.

Larger block sizes will increase index block contention but may reduce block chaining and is generally better for LOBs.

The overriding reason not to use 32K block sizes: Oracle standard regression tests do not test 32K block sizes. It mostly tests 8K with some 16K testing. For this reason alone, I'd avoid 32k block sizes - they aren't testing their code against it.

You probably shouldn't mix block sizes in the same database.

Of course, your milage may vary. Test test test. Then stick with 8k 🙂

Neil Chandler
Database Guy

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Orlando L <oralrnr_at_gmail.com> Sent: 10 June 2020 16:14
To: oracle-l_at_freelists.org <oracle-l_at_freelists.org> Subject: Block size qn

Hi,

We are in planning stages for a big DW. Do any of the listers have a block size bigger than the default 8k in their site? Is there a need for anything like that? Any advantages or pitfalls?

Thanks,
Orlando

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 10 2020 - 18:09:23 CEST