Re: Bigger block sizes

  • From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • To: oralrnr@xxxxxxxxx
  • Date: Wed, 30 Sep 2015 16:53:32 -0500

I haven't seen any advantages from using any larger block sizes. I also saw a
Tom Kyte article a while back that said they are only intended for use with
transportable table spaces, and oracle really only tests on the 8k block size.

Sent from my iPad

On Sep 30, 2015, at 4:29 PM, Orlando L <oralrnr@xxxxxxxxx> wrote:

List,

Does anyone in the list use non default blocksize of greater than 8K for your
oracle DBs; if so, is it for warehousing/OLAP type applications? What
advantages do you get with them; any disadvantage.

Orlando.
--
//www.freelists.org/webpage/oracle-l


Other related posts: