Which of the following statements are true about sharing I/O resources with an Exadata Storage Server?
-
You can manage workloads within a database with Database Resource Manager.
-
You can manage workloads across multiple databases with Database Resource Manager.
-
You can manage workloads within a database with IO Resource Manager.
-
You can manage workloads across multiple databases with IO Resource Manager
Database Resource Manager manages workloads within a single database, making option A true. IO Resource Manager manages workloads across multiple databases at the storage level, making option D true. Option B is false because Database Resource Manager does not work across databases, and option C is false because IO Resource Manager operates at the inter-database level, not within a single database.
On Oracle Exadata, Database Resource Manager (DBRM) operates inside a single database instance, allocating CPU/other resources among consumer groups within that one database — it doesn't span multiple databases sharing the storage. IO Resource Manager (IORM), by contrast, operates at the storage-cell level and arbitrates I/O bandwidth across multiple databases (and their interdatabase plans) that share the same Exadata storage cells. So 'manage workloads within a database with DBRM' and 'manage workloads across multiple databases with IORM' are both true, while DBRM-across-databases and IORM-within-a-database (the cross-wired combinations) are false — matching the standard Exadata resource-management model.