Exadata: best practice or best utilization
Posted on 2015-02-08
Hi, first time on Exadata machine, need to create a db and then create schema/tables for a brand new application.
Application is requesting 2 TB of space, my question is what should be my best practice in assigning the storage parameters, compression @table level and everything else, to get the maximum/optimal performance benefits.
Sorry creating 1st db @Exadata that's why would like to be more cautious and careful, as the application is very critical, I already have all the estimates of their storage requirements too, for each table, now my question is, how I can place them in the best possible manner; tablesspaces, extents, compression, stats gathering ... and the whole nine yards.
Thanks in advance.