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 | NULL | 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 AI Database 26ai.