8.7 V$INMEMORY_FASTSTART_AREA

V$INMEMORY_FASTSTART_AREA provides information about the In-Memory FastStart (IM FastStart) area.

Column	Datatype	Description
CON_ID	NUMBER	The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire multitenant container database (CDB). This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data
TABLESPACE_NAME	VARCHAR2(128)	IM FastStart tablespace name. When IM FastStart is not enabled, the value of TABLESPACE_NAME is INVALID_TABLESPACE and the value of STATUS is DISABLE.
STATUS	VARCHAR2(10)	IM FastStart status. Possible values include: ENABLE: An IM FastStart tablespace has been specified and the content of the IM column is being periodically checkpointed to disk. ENABLING: An IM FastStart tablespace has been specified and the database is creating the IM FastStart area. DISABLE: An IM FastStart tablespace has not been specified. This is the default. MIGRATING: A user has requested the IM FastStart area be migrated from one tablespace to another. DISABLING: A user has requested IM FastStart to be disabled.
ALLOCATED_SIZE	NUMBER	The allocated size of an IM FastStart tablespace in bytes
USED_SIZE	NUMBER	The currently used size of an IM FastStart area (in bytes) within the tablespace.
LAST_CHECKPOINT_TIME	TIMESTAMP(6)	The time when the last IMCU was checkpointed to the IM FastStart area
LAST_POPULATE_TIME	TIMESTAMP(6)	The time of the last population from the IM FastStart area
NUM_DEFERRED_WRITES	NUMBER	The number of pending deferred writes to the IM FastStart area

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).