Consider the following setup: User A1 belongs to resource group High on Database

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?

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Jam IT Western Australia

Jam IT Western Australia

E

anonym

anonym

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.