nerdexam
Oracle

1Z0-027 · Question #46

Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?

The correct answer is C. If two consumer groups P and Q In the PROD database get 20% and 10% respectively of resource D. Log Writer I/O and Control File I/O are high priority I/O managed automatically by IORM. (not A, Not B) Rules in an interdatabase resource plan specify allocations to databases, not consumer groups. IORM is only "engaged" when needed. / (D) Redo and control file writes always take precedence. / (Not E) DBWR (database writer) writes are scheduled at the same…

Key Capabilities and Features

Question

Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?

Options

  • AIf two consumer groups A and B in the PROD database get 10% and 15% respectively of resource
  • BIf two consumer groups C and D In the PROD database get 10% and 15% respectively of resource
  • CIf two consumer groups P and Q In the PROD database get 20% and 10% respectively of resource
  • DLog Writer I/O and Control File I/O are high priority I/O managed automatically by IORM.
  • EDatabase Writer I/O is considered to be the highest priority I/O and is managed based on attributes of

How the community answered

(26 responses)
  • A
    12% (3)
  • B
    4% (1)
  • C
    81% (21)
  • E
    4% (1)

Explanation

*(not A, Not B) Rules in an interdatabase resource plan specify allocations to databases, not consumer groups. IORM is only "engaged" when needed. / (D) Redo and control file writes always take precedence. / (Not E) DBWR (database writer) writes are scheduled at the same priority as user IO. / IORM does not intervene if there is only one active consumer group on one database. / Any disk allocation that is not fully utilized is made available to other workloads in relation to the configured / Background IO is scheduled based on their priority relative to user IO. / For each cell disk, each database accessing the cell has one IO queue per consumer group and three background * Use IORM metrics to track / I/O load per Consumer Group (IOPS, MBPS, disk utilization %) / I/O throttling per Consumer

Topics

#IORM resource allocation#consumer groups#Log Writer I/O#Control File I/O

Community Discussion

No community discussion yet for this question.

Full 1Z0-027 Practice