Database Reference
In-Depth Information
I/O Resource Manager
The Exadata I/O Resource Manager (IORM) is another key capability of Oracle Exadata that guarantees a database
gets the minimal amount of I/O as defined in the resource plan at each storage server. Let's take an example of an
Exadata environment where multiple applications and databases are running.
Figure
8-18
shows the Exadata storage server grid view, where you can see that the IORM is not enabled and
the CRM database is not getting enough I/O resources since the DW database is hogging a lot of them. The DW
database is a legitimate database, and you can't simply kill the process because it's consuming a lot of resources.
You will need to find a more creative way to address the problem.
Figure 8-18.
Exadata storage server grid with IORM not enabled
In Exadata, you can manage the allocation of I/O resources by enabling the IORM. You could configure the I/O
allocation manually to allocate a fixed amount of I/O resources. You could also select predefined templates with fixed
I/O allocations.
As you can see in Figure
8-19
, we currently have IORM disabled; additionally, we do not have any internal
interdatabase plans or disk I/O objectives enabled. To enable IORM, you need to change the desired setting and then
click the Update All button. This enables all the changes selected, and the Exadata will start allocating resources by
the defined I/O resource plan. There are predefined I/O templates that can be implemented as well.
