7.7.12.10 LIST FLASHCACHECONTENT

Purpose

The LIST FLASHCACHECONTENT command displays attributes for the Exadata Smart Flash Cache entries determined by the specified attributes.

Syntax

LIST FLASHCACHECONTENT [attribute_filters] [attribute_list] [DETAIL]

Usage Notes

You can use the DESCRIBE FLASHCACHECONTENT command to view the complete list of FLASHCACHECONTENT attributes.

Examples

Example 7-167 Listing Exadata Smart Flash Cache Content Attributes

This example shows the LIST command with the FLASHCACHECONTENT object, and the corresponding output.

  CellCLI> LIST FLASHCACHECONTENT DETAIL

           cachedKeepSize:             8192
           cachedSize:                 16384
           cachedWriteSize:            16384
           clusterName:                CLUSTER-C1
           columnarCacheSize:          0
           columnarKeepSize:           0
           dbID:                       3557170052
           dbUniqueName:               TEST1
           hitCount:                   4
           missCount:                    
           objectNumber:               23102
           tableSpaceNumber:           1

           cachedKeepSize:             0
           cachedSize:                 983040
           cachedWriteSize:            983040
           clusterName:                CLUSTER-C1
           columnarCacheSize:          0
           columnarKeepSize:           0
           dbID:                       4325252357
           dbUniqueName:               MYODB
           hitCount:                   1
           missCount:                  1
           objectNumber:               4294967295
           tableSpaceNumber:           4

Example 7-168 Listing Exadata Smart Flash Cache Content by Database Object

This example shows a database query for an object in a partitioned table, and then lists the flash cache for the same object. In the example, a partitioned table is created in the database, and then queried for the data object numbers of the partitions. The flash cache on Oracle Exadata Storage Server is then queried.

CREATE TABLE parttabl (c1 number) PARTITION BY RANGE(c1) 
(
  PARTITION partt1 VALUES LESS THAN (100), 
  PARTITION partt2 VALUES LESS THAN (200)
);
 
SQL> SELECT SUBSTR(OBJECT_NAME, 0 , 10) OBJ_NAME, SUBOBJECT_NAME, DATA_OBJECT_ID 
     FROM user_objects WHERE OBJECT_NAME LIKE ('PARTT%');
 
OBJ_NAME   SUBOBJECT_NAME                 DATA_OBJECT_ID
---------- ------------------------------ --------------
PARTTABL
PARTTABL   PARTT1                                  63197
PARTTABL   PARTT2                                  63198

CellCLI> LIST FLASHCACHECONTENT WHERE objectNumber=63197 DETAIL
           cachedKeepSize:             0
           cachedSize:                 983040
           cachedWriteSize:            983040
           clusterName:                CLUSTER-C1
           columnarCacheSize:          0
           columnarKeepSize:           0
           dbID:                       3557170052
           dbUniqueName:               TEST1
           hitCount:                   1
           missCount:                  1
           objectNumber:               63197
           tableSpaceNumber:           4

 
  CellCLI> LIST FLASHCACHECONTENT WHERE objectNumber=63198 DETAIL
         cachedKeepSize:             0
         cachedSize:                 16384
         cachedWriteSize:            16384
         clusterName:                CLUSTER-C1
         columnarCacheSize:          0
         columnarKeepSize:           0
         dbID:                       3557170052
         dbUniqueName:               TEST1
         hitCount:                   0
         missCount:                  2
         objectNumber:               63198
         tableSpaceNumber:           4

Example 7-169 Listing Exadata Smart Flash Cache Content for an ASMCLUSTER Client

Starting with Oracle Exadata System Software release 19.1.0, the dbUniqueName attribute is qualified with the ASMCLUSTER client name if ASM-scoped security is configured. This example shows the partial output of the LIST FLASHCACHECONTENT command for database instances associated with Oracle ASM clusters.

  CellCLI> LIST FLASHCACHECONTENT WHERE dbuniquename LIKE 'ASM.*' DETAIL

         cachedKeepSize:         0
         cachedSize:             65536
         cachedWriteSize:        65536
         columnarCacheSize:      0
         columnarKeepSize:       0
         dbID:                   3334479949
         dbUniqueName:           ASM1.DB1.CDB$ROOT
         hitCount:               0
         missCount:              0
         objectNumber:           75307
         tableSpaceNumber:       1

...

         cachedKeepSize:         0
         cachedSize:             2957312
         cachedWriteSize:        0
         columnarCacheSize:      0
         columnarKeepSize:       0
         dbID:                   1238079488
         dbUniqueName:           ASM1.DB1.PDB1
         hitCount:               4
         missCount:              47
         objectNumber:           4294967294
         tableSpaceNumber:       1

...

         cachedKeepSize:         0
         cachedSize:             17326080
         cachedWriteSize:        0
         columnarCacheSize:      0
         columnarKeepSize:       0
         dbID:                   1757889862
         dbUniqueName:           ASM2.DB2
         hitCount:               9
         missCount:              255
         objectNumber:           4294967294
         tableSpaceNumber:       5

Example 7-170 Listing Exadata Smart Flash Cache Content for Cached Redo Logs

Starting with Oracle Exadata System Software release 20.1.0, Exadata Smart Flash Cache can contain cached redo logs. Cached redo log entries are identified by objectNumber = 4294967293. This example shows a LIST FLASHCACHECONTENT command that displays details for cached redo logs.

  CellCLI> LIST FLASHCACHECONTENT -
           ATTRIBUTES dbUniqueName, dbID, tableSpaceNumber, objectNumber,  cachedSize -
           WHERE objectNumber = 4294967293

         ACME1           3557170052      0        4294967293      140795904
         MYODB           4325252357      0        4294967293      142036992