You plan to migrate a database supporting an an OLTP workload to your Database Machine
This is part of a consolidation project and several other databases already exist on the Database
Machine.
Which three Exadata features may help to improve the performance of this OLTP workload?
A.
Hybrid Columnar Compression
B.
I/O Resource Manager
C.
Smart Flash Cache
D.
Smart Flash Log
E.
Smart Scan
F.
Storage Index
Explanation:
C:
OLTP performance benefits with Exadata
/(D)Smart flash log for low latency commits
/ (C)Smart flash cache for low latency reads. KEEP in Flash for
critical objects
A is wrong. HCC help to reduce size
B is right. IORM can ensure IO allocation for OLTP
C is right. Smart Flash Cache can reduce physical IO
D is right. Smart Flash LOG can make LGWR faster
E is wrong. smart scan requires full table scan and fast full index scan which usually not happening in OLTP
F is wrong. storage index works together with smart scan.
So B.C.D. are correct