Which three types of classification can you use to prioritize I/O requests with IORM?
A.
Based on Database Manager Resource Groups
B.
Based on an Intradatabase Plan
C.
Based on a Category Plan
D.
Based on the priority of the background process
Explanation:
Exadata implements Smart I/O Resource management at three levels:
* Transaction Level
Ensures higher priority transactions get better throughput
*Database Level
Ensures each database gets fair share of disk bandwidth
*Usage Category Level
•Ensures interactive users are not slowed by reporting or batch
Note: IORM = I/O Resource manager
http://docs.google.com/viewer?a=v&q=cache:AJYTzdXgYd8J:ioug.itconvergence.com/pls/apex/w
wv_flow_file_mgr.get_file%3Fp_security_group_id%3D11353425782780285%26p_fname%3DEx
adataGROUG.pdf%26p_inline%3DNO+Exadata+implements+Smart+I/O+Resource+management+at+t
hree+levels&hl=en&gl=in&pid=bl&srcid=ADGEESi0ThAnQ7So0_rC3mvCRuc6YIgUnwgw9yivPNx
zOXHe727RJ8IT9tMIu2QFt3l3tBi3sRNQ33CaXheAY4BWWzdjnDlbvB_9hsk9WyubYUlHcqKUg9l
WELSXGwOGlLbKWUYxjo0o&sig=AHIEtbRbBfDrQN_qxwNqJCh5AXy1Ca9IKQ
The DBRM and I/O resource management capabilities of Exadata storage can prevent one class
of work, or one database, from monopolizing disk resources and bandwidth and ensures user
defined SLAs are met when using Exadata storage. The DBRM enables the coordination and
prioritization of I/O bandwidth consumed between databases, and between different users and
classes of work. By tightly integrating the database with the storage environment, Exadata is
aware of what types of work and how much I/O bandwidth is consumed. Users can therefore have
the Exadata system identify various types of workloads, assign priority to these workloads, and
ensure the most critical workloads get priority.
In data warehousing, or mixed workload environments, you may want to ensure different users
and tasks within a database are allocated the correct relative amount of I/O resources. For
example you may want to allocate 70% of I/O resources to interactive users on the system and
30% of I/O resources to batch reporting jobs. This is simple to enforce using the DBRM and I/Oresource management capabilities of Exadata storage.
Reference: A Technical Overview of the Sun Oracle Exadata Storage Server and Database
Machine