DBA_IM_EXPRESSIONS

5.103 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