Migrating to exadata - DB_BLOCK_SIZE
YoavNov 8 2011 — edited Jul 2 2012Hi,
We plan to move our DWH , 5 tera database 11gr2 running on linux machine to exadata 1/4 rac machine.
We are currently running with 32K block size.
Must of our statments are using FTS , and number of indexes is small.
We are to get your advice if we should stick with the 32K block size on the exadata machine , or install the databases on exadata machine with 8K block size.
Thanks