Managing performance on Exadata can be tricky, partly because you’re using a RAC environment with two or more database nodes managed using Database Resource Manager (DBRM), and partly because the storage cells in Exadata can be managed with the I/O Resource Manager (IORM). A new whitepaper from Oracle as of March 2024 helps you analyze performance using AWR reports which now include Exadata-specific metrics at the storage level.
The details are in the Oracle whitepaper here. You’ll need to run the AWR at the CDB level to get the details at the storage level. That detail has been invaluable for finding outlier disks, flash cache and PMEM performance or issues, I/O breakdown by database, cache hits at the storage layer, and a breakdown of how well your smart scans (offloads) are working.
Everything you need to know about overall system health is usually in an AWR report, including what’s happening at the Exadata storage level!
All Kinds of Exadata Stuff 