Oracle教程 2023-02-23

Oracle 视图 ALL_XSTREAM_ADMINISTRATOR 官方解释，作用，如何使用详细说明

本站中文解释

_SETTINGS

ALL_XSTREAM_ADMINISTRATOR_SETTINGS是一个只读的系统视图，提供了管理XStream管理器设置的信息。

XStream是Oracle基于数据流的技术，可以拓展将一个数据库中的数据发送到另一个数据库。它可以有助于实现两个数据库之间的增量数据共享，以及对数据库中的数据进行更新。XStream可以有助于实现两个数据库之间的物理共享，从而增加了数据库的工作能力。

ALL_XSTREAM_ADMINISTRATOR_SETTINGS视图提供了有关管理XStream管理器的设置的信息，简单来说，它提供了XStream管理器的拓展功能，它可以拓展：

– 数据发送的时间间隔
– 允许将数据发送到其他数据库的服务
– 在XSTREAM_QUEUE_PROCESSES中允许的情况下，数据发送的排队数
– 控制是否在数据发送期间使用保护表
– 在XSTREAM_CHANNEL_PROCESSES中允许的情况下，数据流处理进程的排队数

要使用ALL_XSTREAM_ADMINISTRATOR_SETTINGS视图，只需使用下面的查询：SELECT * FROM ALL_XSTREAM_ADMINISTRATOR_SETTINGS;这将返回XStream管理器设置的信息。

官方英文解释

ALL_XSTREAM_ADMINISTRATOR displays information about the current users’s granted privileges to be an XStream administrator by procedures in the DBMS_XSTREAM_AUTH package.

Related View

DBA_XSTREAM_ADMINISTRATOR displays information about the users who have been granted privileges to be XStream administrators by procedures in the DBMS_XSTREAM_AUTH package.

Column	Datatype	NULL	Description
`USERNAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the user who has been granted privileges to be an XStream administrator
`PRIVILEGE_TYPE`	`VARCHAR2(7)`		Type of privilege granted: `APPLY` `CAPTURE` `*` – Both `APPLY` and `CAPTURE`
`GRANT_SELECT_PRIVILEGES`	`VARCHAR2(3)`		Shows whether set of privileges granted to the user (grantee) includes the `SELECT_CATALOG_ROLE` role, which enables the user to manage other XStream servers that belong to other XStream users. Possible values: `YES`: The administrator has the `SELECT_CATALOG_ROLE` role and other privileges, is considered a full privilege administrator, and can manage other users’ XStream configuration `NO`: The administrator is considered a minimum privilege administrator, and can only manage XStream configurations where the apply_user or capture_user (based on the `PRIVILEGE_TYPE` column) matches the username.
`CREATE_TIME`	`TIMESTAMP(6)`		Time at which the privilege was granted
`LAST_MODIFIED`	`TIMESTAMP(6)`		Time at which the privilege was last modified

本站中文解释

官方英文解释

相关推荐