Exadata Smart Flash Cache Statistics

There are two places you can get statistics regarding the use of the Exadata Smart Flash Cache. The first is by using the LIST METTRICCURRENT command of CellCLI, which is discussed later in this chapter, as partially shown in the following code:

CellCLI> LIST METRICCURRENT WHERE –
              objectType='FLASHCACHE'
      FC_BY_USED              72119 MB
      FC_IO_RQ_R           55395828 IO requests
      FC_IO_RQ_R_MISS           123184 IO requests

More than 30 statistics relating to the use of the Exadata Smart Flash Cache are available.

You can also use the FLASHCACHECONTENT object with CellCLI commands, described later in this chapter, to determine whether an object is currently being kept in the Exadata Smart Flash Cache. The following code shows an example of the type of information you can get about an object. Please note that you have to get the objectNumber for an object by querying the DBA_OBJECTS view for the object_id of the object.