DW on Exadata Migration and db_block_size
Hi Exa gurus,
we are currently in the process of migrating a Data Warehouse database of total size around 25TB to
Half Exadata Database Machine with High Capacity Disks (3TB) and High Redundancy for DATA diskgroup
and Normal Redundancy for RECO diskgroup (using External Backup).
The current production database currently runs on HP-UX Itanium Supredome db version 10.2.0.5 and is build with DB_BLOCK_SIZE
of 32K.
We are plan to use HCC for Query High Compression for older Static Partitions/Subpartitions and OLTP Compression
for latest partitions.
Is this suggested to continue with the current db_block_size of 32K.