Consider the following setup:
User A1 belongs to resource group High on Database A.
User B2 belongs to resource group Low on Database B.
User C3 is a user on Database C without any DBRM setup.
DBRM setup:
Database A: Resource group High gets 80% and Low gets 20%.
Database B: Resource group High gets 60% and Low gets 40%.
IORM setup:
Database A: Share=20, limit=5
Database B: Share=30, limit=10
Database C: 5 shares
Total number of shares in the IORM setup = 100
What percent of I/O will each database user theoretically be using when the Exadata storage unit
I/O throughout is used 100% and no other databases but A, B, and C are running?
A.
Al = 36%, B2=18%, and C3=9%
B.
Al = 33%, B2=33%, and C3=33%
C.
AI = 10%, B2=5%, and C3=20%
D.
Al = 8%, B2=12%, and C3=5%
E.
Al = 5%, B2=10%, andC3=85%
Explanation:
IORM setup limits Database A to 5%, and Database B is limited to 10%, while
Database C has not IORM limit.
Notethat the resource groups are for CPU allocation.
E
Get latest certification materials from http://www.exadata-certification.com
E
Because limit is set to 5 for DBa and 10 for DBb
http://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/iorm.htm#SAGUG20424
The concept of maximum utilization limit (limit) is supported by I/O Resource Management. In addition to specifying the resource allocation values, you can also provide a maximum utilization limit for a given database.This directive ensures that the database never utilizes I/O resources beyond the specified limits. For example, if a production and test database are sharing the Exadata cell, then set a maximum utilization limit for the test database to limit the I/O utilization for the test database.