7.7.5.9 DESCRIBE FLASHCACHECONTENT

Purpose

The DESCRIBE FLASHCACHECONTENT command displays a list of attributes for the FLASHCACHECONTENT object type.

Syntax

DESCRIBE FLASHCACHECONTENT

Usage Notes

The attributes displayed by the DESCRIBE FLASHCACHECONTENT command can include:

• cachedKeepSize: Size, in bytes, cached in keep mode for this object.

• cachedSize: Size, in bytes, cached for this object.

• cachedWriteSize: Size, in bytes, of cached data for this object in write-back flash cache that has not yet been written to hard disk.

• columnarCacheSize: Size, in bytes, cached in Hybrid Columnar Compression (HCC) format for this object.

• columnarKeepSize: Size, in bytes, cached in Hybrid Columnar Compression (HCC) format that is in keep mode for this object.

• dbID: Database unique name identifier.

• dbUniqueName: Database unique name.

• hitCount: Number of I/Os which read data from flash cache for this object.

• hoursToExpiration: Time before this object is downgraded from keep section, if not accessed again.

• missCount: Number of I/Os which read data from disk for this object.

• objectNumber: Mostly specifies the Oracle Database dictionary object number of the database object (table, index, partition, and so on) that is associated with the FLASHCACHECONTENT object.

  Additionally, the following values have special meaning:

  • 0 (zero) indicates that the object number is undefined. This value is often used in conjunction with internal I/O performed by ASM.

  • 4294967292 indicates that the FLASHCACHECONTENT object contains ASM Dynamic Volume Manager (ADVM) data.

  • 4294967293 indicates cached redo log data.

  • 4294967294 and 4294967295 indicate data from internal database objects, such as temporary segments, rollback segments, control file data, and so on, which is not associated with a specific data object (table, index, partition, and so on).

• tableSpaceNumber: Tablespace number associated with the database object.

Examples

The following example shows the DESCRIBE command with the FLASHCACHECONTENT object.

Example 7-102 Describing the FLASHCACHECONTENT Object

CellCLI> DESCRIBE FLASHCACHECONTENT

         cachedKeepSize
         cachedSize
         cachedWriteSize
         columnarCacheSize
         columnarKeepSize
         dbID
         dbUniqueName
         hitcount
         hoursToExpiration
         missCount
         objectNumber
         tableSpaceNumber