Mushfique Khan
asked on
Exadata: best practice or best utilization
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.
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.
My understanding of Exadata, which is pretty minimal, is that you should be getting consulting hours from Oracle with the system. According to competitor literature, it takes a few days to get the system up and running with Oracle consulting in place. I would hope that some initial consulting of setting up a database would be included.
The architecture of these systems is very different than what most people are used to. Training is really a must to be able to work with them effectively.
The architecture of these systems is very different than what most people are used to. Training is really a must to be able to work with them effectively.
ASKER
folks, basically we already have quite some dbs running on Exadata, means this is not the first time, for my group, but for myself ... yes this is the first time, that's why asking, is there any special consideration, need to keep, while creating new db/schema/tables ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks btan ... much much appreciated :)
Sure hope it helps
Yes, you can get advice here, but what you get won't be anywhere near as in-depth as what you'd get in formal training.
Do you know best practices for backup?
Do you know best practices for high availability?
Do you know how to tune the engine and OS once you've implemented your database?
Do you know what to do to avoid trouble a month or six down the road?