DBA_IM_EXPRESSIONS
DBA_IM_EXPRESSIONS provides information about the list of expressions (SYS_IME virtual columns) that are currently enabled for in-memory storage.
Related View
Typically, you can query this view after invoking the DBMS_INMEMORY_ADMIN.IME_CAPTURE_EXPRESSIONS PL/SQL procedure to see the list of hot expressions added to different tables across the database.
Based on this view, you can:
-
Populate expressions on a particular table immediately
-
Drop certain expressions that are marked for in-memory but not desired by users
USER_IM_EXPRESSIONS provides information about the list of expressions (SYS_IME virtual columns) that are currently enabled for in-memory storage in schemas owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(129) |
Table owner | |
TABLE_NAME |
VARCHAR2(129) |
Table name | |
OBJECT_NUMBER |
NUMBER |
Object number of the table | |
COLUMN_NAME |
VARCHAR2(128) |
NOT NULL |
Column name of the expression added to the table (with SYS_IME prefix) |
SQL_EXPRESSION |
LONG |
SQL representation of the expression |
See Also: “USER_IM_EXPRESSIONS”