Your customer is moving their application to an Exadata environment from a standard Oracle
environment. What three changes might you expect to make to optimize performance and
resource usage in the new environment?
A.
You will add Indexes to your tables for better performance.
B.
You should consider implementing a different partitioning strategy.
C.
You should consider reducing the number of materialized views.
D.
You should make the extents larger, such as 8 MBs.
Explanation:
A: In Oracle Database 11gR2 a new feature called the Exadata Storage Index has
been introduced. The storage index contains a summary of the data distribution on the disk and
provides an additional method to eliminate unnecessary disk IO.
B: Make use of Exadata Storage Server Grid
http://docs.google.com/viewer?a=v&q=cache:wRYLeYKLMt8J:www.oracle.com/technetwork/datab
ase/features/availability/xmigration-11-133466.pdf+migrate+from+standard+Oracle+environment+to+Exadata+environment+add+Indexe
s,+different+partitioning+strategy&hl=en&gl=in&pid=bl&srcid=ADGEESgf0c36ot1GSJp5mlA0CHj
OB57wun8QRInHZga_F-Hx97x1yVTf-0Mx64X1MWZ6A-JzpnJmSzLV_8pSLqA2auNztoZS4SkNTMA92GnXM0IfInrnQyU5X5c_Yp8Sk2OtCgTwDm&sig=AHIEtbTxnH6hAhX3-DWEj4TbN82fmsx4oQ
slide 6