Which two types if metrics would help assess the impact of the intra-database plans on I/O to the storage servers?

You plan to monitor storage servers after configuring an I/O resource manager plan with directives
for inter-database plans and intra-database plans.
Which two types if metrics would help assess the impact of the intra-database plans on I/O to the
storage servers?

You plan to monitor storage servers after configuring an I/O resource manager plan with directives
for inter-database plans and intra-database plans.
Which two types if metrics would help assess the impact of the intra-database plans on I/O to the
storage servers?

A.
Category I/O

B.
Database I/O

C.
Resource Consumer Group I/O

D.
Smart Flash Log I/O

E.
Smart Flash Cache I/O

Explanation:
B:Database metrics provide information about the size of the I/O load from each

database specified in the interdatabase plan.
C:Consumer group metrics provide information about the size of the I/O load from each consumer
group specified in a database resource plan. Each database in the interdatabase plan has metrics
for each of its consumer groups.
Note:
*I/O Resource Manager (IROM) Settings
Incorrect:
Not A:Category metrics provide information about the size of the I/O load from each category
specified in the current IORM category plan.



Leave a Reply 6

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


UP

UP

A & C are correct

Sanjay Mevada

Sanjay Mevada

B and C is correct answer

L. Zhu

L. Zhu

Intra-DB plan on I/O is based on Category plan and Inter-DB plan
A is right.
B is right.
C is wrong. Resource Consumer Group is the intra-DB on I/O itself
D is wrong. IORM has no impact on Smart Flash Log I/O
E is wrong. IORM has no impact on Smart Flash Cache I/O

So A.B. are correct

Bruno

Bruno

A: Category I/O
B: Database I/O

Explanation:
http://www.centroid.com/blog/using-iorm-exadata
Category is the first stage
Interdatabase plan is the second stage that will verify how percentage of resources will be permited by database

Bruno

Bruno

CORRECTION:
A: Category I/O
C: Resource Consumer Group I/O

Explanation:
The question ask 2 types of metrics for INTRA-DATABASE plans.
http://www.centroid.com/blog/using-iorm-exadata
Category is the first stage
Resource Consumer Group I/O is a feature for INTRA-DATABASE that uses DBRM

Miskeen

Miskeen

it is B and C from the same link you provided

If you have multiple workloads within a database that you wish to control database resource usage with, you need to configure an intradatabase resource plan.