My Oracle Support Banner

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 later
Oracle 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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.