PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which Oracle database files are suitable to be placed on EFD drives?

A customer implemented an Oracle application on a VMAX with a mix of Enterprise Flash Drives
(EFD) and FC 15K drives. EFD are configured in RAID 5 and FC 15K both in RAID 5 and RAID 1.
The application is random read intensive. The customer has decided to place a portion of the
database in each tier.
Which Oracle database files are suitable to be placed on EFD drives?

What steps do you take to identify likely bottlenecks?

An existing 2-engine VMAX array has 192 x 450GB 15K Fibre Channel drives in a single Virtual
Provisioning pool. Two Linux database hosts are connected to the array and both are running
PowerPath.

Host oradb01 is connected to the E0 FA ports on each director and is meeting the customer
performance SLA. Host oradb02 is connected to the G0 FA ports on each director – and for the
past 3 days this host has been experiencing poor performance during peak activity in the
afternoons.
What steps do you take to identify likely bottlenecks?