A customer has three databases named CC. FIN, and DW. The CC database is for their
CallCenter. Even a slight decrease in the response time of the database would mean more people
“on hold” in their data center. The orders received through the CallCenter are stored in the
Finance (FIN) database. Both databases, CC and FIN, serve as sources for the Data Warehouse
(DW) database. All databases use the same Automatic Storage Management (ASM) diskgroup
and therefore, the same physical disks on Exadata storage. The customer wants to dynamically
control the resources that are available for the CallCenter database because this has direct impact
on their operations?
Which option should be implemented?
A.
DBRMon the CC database
B.
DBRM on all the databases
C.
IORM, because DBRM cannot be changed for an existing session
D.
IORM and DBRM
Explanation:
The answer is B
I think answer should be C.
IORM can be used to allocate 80% or a higher percentage of I/O to CC database using category and interdatabase options.
Checked other sites and the answer is B
Customer wants to dynamically control the resources that are available to CC database so ans is A (enabling DBRM on CC database)
Correct Answer is Option D.
Its Exadata and to manage resources both IORM & DBRM should be implemented together.
The answer is is A.
Ans: A is correct “DBRM on the CC database” as customer wants to control resources within CC Database.
The answer is A
IORM is an integral software component of the Oracle Exadata Storage Server and runs within the Cell Services (Cellsrv) on each Cell.
Customer wants to dinamicaly control the resources that are available to CC database.
IORM => I/O – Exadata Storage Server
DBRM => CPU – Oracle Database Instance
Two Clues given
===============
1) databases use the same … physical disks => IORM
2) dynamically control the resources => DBRM
Answer: D
==================
Answer is A
D
https://community.oracle.com/thread/3530815
http://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/iorm.htm#SAGUG20423
For example, if a production database and test database are sharing Oracle Exadata Storage Server, you can configure resource plans that give priority to the production database. In this case, whenever the test database load would affect the production database performance, IORM schedules the I/O requests such that the production database I/O performance is not impacted. This means that the test database I/O requests are queued until they can be issued without disturbing the production database I/O performance. … and more read on!
Agree. The question is about a problem interdatabases then IORM is needed.
D is the right answer.
Two Clues given
===============
1) databases use the same … physical disks => IORM
2) dynamically control the resources on CC Database => DBRM
Answer: A
==================
Sorry, I meant “D”