I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?
Select all that apply, then click Submit answer.
-
○
OS I/O metrics using Enterprise Manager host pages for the storage servers
-
○
OS I/O metrics using OS tools such as iostat on the database servers
-
○
I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod
database instances using SQL *p1us -
○
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
-
○
OS I/O metrics using OS tools such as iostat on the storage servers