nerdexam
Oracle

1Z0-485 · Question #62

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…

The correct answer is D. IORM and DBRM. https://community.oracle.com/thread/3530815 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…

I/O Resource Management (IORM)

Question

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?

Options

  • ADBRM on the CC database
  • BDBRM on all the databases
  • CIORM, because DBRM cannot be changed for an existing session
  • DIORM and DBRM

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    7% (2)
  • C
    14% (4)
  • D
    76% (22)

Explanation

https://community.oracle.com/thread/3530815 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!

Topics

#IORM#DBRM#multi-database resource management#ASM diskgroup

Community Discussion

No community discussion yet for this question.

Full 1Z0-485 Practice