Hi Orlando,
it depends (as always).
Franck Pachot has written a great blog post with several demos about this
topic: http://blog.dbi-services.com/do-the-block-size-matter/
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
Orlando L <oralrnr@xxxxxxxxx> hat am 30. September 2015 um 23:29 geschrieben:
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.