Oracle 视图 DBA_IM_EXPRESSIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_IM_EXPRESSIONS提供了有关Internet Directory 属性映射表达式的概况性信息，每一个表达式对应到一个登记的Internet Directory权限，用来检索出一个特定的Internet Directory属性的值，这些属性映射表达式可以通过Oracle Internet Directory的Directory Expression Editor来创建。
使用DBA_IM_EXPRESSIONS视图可以查询Internet Directory中的表达式信息，查询语句如下：
SELECT * FROM DBA_IM_EXPRESSIONS;
通过此视图查询的结果包括的列有：
EXPRESSION_OID: 用于标识特定的表达式的ID；
DESCRIPTION: 该表达式的描述；
EXPRESSION_TEXT: 表达式的具体内容；
CREATE_DATE：表达式创建的日期和时间；
PROPERTIES：该表达式的属性；
LANGUAGE：表达式所使用的编程语言类型，目前支持SQL，PL/SQL，JAVA；
ENABLED：表达式是否被启用。
官方英文解释
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 |
|---|---|---|---|
|
|
|
Table owner |
|
|
|
|
Table name |
|
|
|
|
Object number of the table |
|
|
|
|
|
Column name of the expression added to the table (with SYS_IME prefix) |
|
|
|
SQL representation of the expression |
See Also:
“USER_IM_EXPRESSIONS”
