Oracle教程 2023-04-08

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

Oracle 视图v$dispatcher_config 是用于管理Oracle用户进程之间的通信的配置视图，它表示的是一个集群的Oracle数据库实例的调度配置信息。此视图包括Oracle 用户连接主机上的派遣器服务器实例之间的日志文件路径及其他相关信息。

使用此视图可以检查当前包括服务器实例在内的用户连接的配置信息，并获取日志文件状态，包括每个用户连接的日志文件的当前累计大小，当前文件编号等。

使用方法：
SQL>select * from v$dispatcher_config;

ID NAME STATUS DESCRIPTION FILEPATH LOGFILE LOGFILE_SIZE LOGFILE_NUM

1 prdb ACTIVE Dispatcher Configuration /u01/oracle/log prdb_ora_9551_prnt 1024000 2 1

V$DISPATCHER_CONFIG displays information about the dispatcher configurations and their attributes.

Column	Datatype	Description
`CONF_INDX`	`NUMBER`	Zero-based index of the `DISPATCHERS` configuration
`NETWORK`	`VARCHAR2(1024)`	Network protocol or listening address of dispatchers (may be truncated)
`DISPATCHERS`	`NUMBER`	Number of dispatchers to maintain for the configuration
`CONNECTIONS`	`NUMBER`	Maximum number of concurrent connections per dispatcher
`SESSIONS`	`NUMBER`	Maximum number of concurrent sessions per dispatcher
`MULTIPLEX`	`VARCHAR2(4)`	Indicates whether Session Multiplexing is on: `IN` `OUT` `BOTH` `OFF`
`LISTENER`	`VARCHAR2(1200)`	Listeners to register dispatchers with (may be truncated)
`SERVICE`	`VARCHAR2(512)`	Service names supported (may be truncated)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：