DBA_INMEMORY_ADVISOR_RECOMMENDATION

6.125 DBA_INMEMORY_ADVISOR_RECOMMENDATION

DBA_INMEMORY_ADVISOR_RECOMMENDATION displays In-Memory Advisor recommendations.

In-Memory Advisor simulates various Oracle Database In-Memory sizes and estimates the database time for a reference workload for each size. The results are displayed in this view.

Column	Datatype	Description
`TASK_ID`	`NUMBER`	In-Memory Advisor task ID
`INMEMORY_SIZE`	`NUMBER`	Simulated In-Memory size (in bytes)
`ESTIMATED_DB_TIME_LOW`	`NUMBER`	Low end of the predicted database time range (in seconds)
`ESTIMATED_DB_TIME_HIGH`	`NUMBER`	High end of the predicted database time range (in seconds)
`ESTIMATED_DB_TIME_ANALYTICS_LOW`	`NUMBER`	Low end of the predicted database analytical time range (in seconds)
`ESTIMATED_DB_TIME_ANALYTICS_HIGH`	`NUMBER`	High end of the predicted database analytical time range (in seconds)
`RECOMMENDED_OBJ_LIST`	`CLOB`	List of recommended objects for the simulated In-Memory size (`INMEMORY_SIZE`)

Note:

This view is available starting with Oracle Database 23ai.