Performance Problems In a RAC Database Using Smart Flash Cache
(Doc ID 1981471.1)
Last updated on FEBRUARY 27, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 12.1]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)
When performing a parallel Data Pump import in a RAC database using the 12c new 'smart flash cache' feature next symptoms were noticed in the database:
- high CPU usage
and following wait events:
- free buffer waits
- latch: cache buffers lru chain
- latch: cache buffers chains
If smart flash cache is disabled then there are no problems with database performance when performing the import.
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