9.8 V$INMEMORY_SIZE_ADVICE

V$INMEMORY_SIZE_ADVICE estimates usage and performance statistics for different simulated sizes of the In-Memory Column Store (IM Column Store).

Column	Datatype	Description
IM_POOL_SIZE_FOR_ESTIMATE	NUMBER	Simulated size of the IM Column Store (in megabytes)
SIZE_FACTOR	NUMBER	Size factor with respect to the current IM Column Store size
ESTD_IM_USED_SIZE	NUMBER	Estimated amount of space the IM Column Store would use for this simulation (in megabytes)
ESTD_IM_SCAN_TIME	NUMBER	Estimated in-memory scan time for this simulation (in seconds)
ESTD_TOTAL_DB_TIME	NUMBER	Estimated total database time for this simulation (in seconds) This value estimates the cumulative time spent by the database on processing user requests. It includes the wait time and CPU time of all non-idle user sessions.
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 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

Note:

This view is available starting with Oracle Database 23ai.