Performance Problems In a RAC Database Using Smart Flash Cache
(Doc ID 1981471.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
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!