Examine this IORM plan:
Which two are true concerning this plan?
A.
The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.
B.
I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand
exists, and a maximum of 60% of the I/O bandwidth even if no other databases are doing I/O to the cell, and
the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.
C.
If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.
D.
I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least
60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are
performing I/O to the cell.
E.
If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.
Explanation:
The IORM plan can be configured using the ALTER IORMPLAN command on command-line interface
(CellCLI) utility on each Exadata storage cell. It consists of two parameters – dbplan and catplan. While the
“dbplan” is used to create the I/O resource directives for the databases, the “catplan” is used to allocate resources by workload category consolidated on the target system.
allocation/share – Specify the resource allocation to a specific database in terms of percentage or shares.
limit – Specify maximum limit of disk utilization for a database.
Incorrect Answers:
A: IORM plans configures % I/O resources, not % of Flash Cache.
References: https://community.oracle.com/docs/DOC-998939