Database not using flashcache and IORM dbPlan is using profile
(Doc ID 2198539.1)
Last updated on APRIL 09, 2020
Applies to:
Oracle Exadata Storage Server Software - Version 12.1.2.1.0 and laterOracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
IORM interdatabase plans now support profiles that improve manageability of interdatabase plans for environments with many databases.
Minimum software: Exadata cell software release 12.1.2.1.0 running Oracle Database 12c Release 1 (12.1) release 12.1.0.2 Exadata Bundle Patch 4.
Symptoms
- Database performance is slow.
- AWR report shows "cell single block physical" Wait Avg & user/IO is high
- An inter-database IORM plan with profile directives is created on the cell.
- A database initialization parameter db_performance_profile is used as a requirement for use of IORM profiles see MOS Note - 1363188.1
AWR report shows Flash Cache Savings with little percentage on the Database Flash Cache but Cell usage is high:
Flash Cache Internal Reads also report no flashcache usage:
Changes
Upgraded to 12.1.0.2 Bundle Patch 4 or higher
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |