Oracle
1Z0-902 · Question #35
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…
Sign in or unlock 1Z0-902 to reveal the answer and full explanation for question #35. The question stem and answer options stay visible for context.
Exadata Monitoring and Troubleshooting
Question
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?
Options
- AOS I/O metrics using Enterprise Manager host pages for the storage servers
- BOS I/O metrics using OS tools such as iostat on the database servers
- CI/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and
- Dcellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk,
- EOS I/O metrics using OS tools such as iostat on the storage servers
Unlock 1Z0-902 to see the answer
You've previewed enough free 1Z0-902 questions. Unlock 1Z0-902 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Exadata I/O monitoring#IORM#Performance troubleshooting#Storage metrics