nerdexam
Oracle

1Z0-485 · Question #65

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…

The correct answer is E. Al = 5%, B2=10%, and C3=85%. IORM setup limits Database A to 5%, and Database B is limited to 10%, while Database C has Not that the resource groups are for CPU allocation.

I/O Resource Management (IORM)

Question

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?

Options

  • AAl = 36%, B2=18%, and C3=9%
  • BAl = 33%, B2=33%, and C3=33%
  • CAI = 10%, B2=5%, and C3=20%
  • DAl = 8%, B2=12%, and C3=5%
  • EAl = 5%, B2=10%, and C3=85%

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    15% (4)
  • D
    8% (2)
  • E
    73% (19)

Explanation

IORM setup limits Database A to 5%, and Database B is limited to 10%, while Database C has Not that the resource groups are for CPU allocation.

Topics

#IORM shares#DBRM resource groups#I/O allocation calculation#resource limits

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-485 Practice