Purpose

The flashcachesize attribute defines a hard limit for space usage in Exadata Smart Flash Cache. The limit cannot be exceeded, even if the cache is not full.

Syntax

 ALTER IORMPLAN 
   dbplan=(( name=db_name, ... flashcachesize=number ... ) ... )

Usage Notes

• You specify the value for flashcachesize in bytes. You can also use the suffixes M (megabytes), G (gigabytes), or T (terabytes) to specify larger values. For example, 300M, 150G, or 1T.

• The value for flashcachesize must be at least 4 MB.

• The flashcachelimit and flashcachesize attributes cannot be specified in the same directive.

• The value for flashcachesize cannot be smaller than flashcachemin, if it is specified.

• In an IORM plan, if the size of Exadata Smart Flash Cache can accommodate all of the flashcachemin and flashcachesize allocations, then each flashcachesize definition represents a guaranteed space allocation.

  However, starting with Oracle Exadata System Software release 19.2.0 you can use the flashcachesize attribute to over-provision space in Exadata Smart Flash Cache. Consequently, if the size of Exadata Smart Flash Cache cannot accommodate all of the flashcachemin and flashcachesize allocations, then only flashcachemin is guaranteed.