Oracle 视图 ALL_XSTREAM_RULES 官方解释，作用，如何使用详细说明
本站中文解释
视图
Oracle XStream视图ALL_XSTREAM_RULES是Oracle数据库的另一个可用视图，用于查询当前用户可见的XStream规则。它可以用来查看正在处理的XStream规则，从而帮助Oracle DBA和开发人员更好地了解当前的XStream规则实现情况。
ALL_XSTREAM_RULES视图的主要内容包括：
Rule_name：规则的名称。
Object_name：规则操作的对象的名称。
Operation_name：对对象执行的操作的名称。
Stream_name：要使用的XStream的名称。
Status：规则的状态，当前规则的状态可以是“ ENABLED（启用）”，“ DISABLED（禁用）”或“ INACTIVE（不活动）”。
Rule_type：规则类型。
Object_type：规则操作的对象类型。
Object_owner：对象所有者。
Source_environment：表或表列的源环境。
Target_environment：表或表列的目标环境。
Source_client_name：源环境的XStream客户端的名称。
Target_client_name：目标环境的XStream客户端的名称。
Source_table_locator：按顺序包含源表的信息：
（1）源数据库名称
（2）源架构名称
（3）源表名称
Target_table_locator：按顺序包含目标表的信息：
（1）目标数据库名称
（2）目标架构名称
（3）目标表名称
To使用ALL_XSTREAM_RULES视图:
1.首先建立连接
sqlplus / as sysdba
2.查询ALL_XSTREAM_RULES表
SELECT * FROM ALL_XSTREAM_RULES;
3，根据需要设置过滤条件，来查询XStream规则使用情况
SELECT * FROM ALL_XSTREAM_RULES WHERE STATUS = ‘ENABLED’;
在Oracle数据库中使用ALL_XSTREAM_RULES视图可以很容易地查询出当前数据库中正在使用的XStream规则，查看当前的XStream规则实现情况。使用ALL_XSTREAM_RULES视图可以帮助更好的管理和处理XStream规则，从而提高Oracle数据库的性能。
官方英文解释
ALL_XSTREAM_RULES displays information about the XStream rules accessible to the current user.
Related View
DBA_XSTREAM_RULES displays information about all XStream server rules in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the XStream process |
|
|
|
|
Type of the XStream process:
|
|
|
|
|
The XStream type of the rule:
|
|
|
|
|
Owner of the rule set |
|
|
|
|
Name of the rule set |
|
|
|
|
Type of the rule set:
|
|
|
|
|
|
Owner of the rule |
|
|
|
|
Name of the rule |
|
|
|
The type of the rule:
|
|
|
|
|
Current rule condition |
|
|
|
|
For table and schema rules, the schema name |
|
|
|
|
For table rules, the table name |
|
|
|
|
Indicates whether to include tagged LCRs ( |
|
|
|
|
For subset rules, the type of operation:
|
|
|
|
|
For subset rules, the row subsetting condition |
|
|
|
|
The global name of the database where the LCRs originated. In a PDB, this is the global name of the PDB. |
|
|
|
|
For rules created by the XStream administrative APIs, the original rule condition when the rule was created |
|
|
|
|
For rules created by the XStream administrative APIs, indicates whether the current rule condition is the same as the original rule condition ( |
|
|
|
|
The global name of the source root database |
|
|
|
|
The container name of the database where the transactions originated |
See Also:
“DBA_XSTREAM_RULES”
