You plan to migrate a database supporting an OLTP workload to your new X5 Database Machine.
The current database instance supports a large number of short duration sessions and a very high volume of
short transactions.
Which three X5 Database Machine features can improve performance for this type of workload?
A.
An improved highly efficient undo and redo architecture
B.
Faster optimization due to an Exadata-specific optimizer
C.
Reduced I/O latency for writes due to writeback flashcache on all Exadata X5 and later models
D.
Ultra high I/O performance for reads and writes when using Exadata Extreme Flash in X5 and later models
E.
Reduced I/O latency for reads due to read flashcache on all Exadata X5 and later models
Explanation:
A: To further accelerate OLTP workloads, the Exadata Smart Flash Cache also implements a special algorithm to reduce the latency of log write I/Os called Exadata Smart Flash Logging.
C: Use the Write-Back Flash Cache feature to leverage the Exadata Flash hardware and make Exadata Database Machine a faster system for Oracle Database Deployments.
D: Exadata X5-2 introduces Extreme Flash Storage Servers. Each Extreme Flash storage server contains eight 1.6 TB state-of-the-art PCI Flash drives. PCI flash delivers ultra-high performance by placing flash memory directly on the high speed PCI bus rather than behind slow disk controllers and directors.
References: http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds-2406241.pdf http://www.oracle.com/technetwork/articles/database/exadata-write-back-flash-2179184.html