Oracle教程 2023-04-03

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

本站中文解释

Oracle的V$CIRCUIT视图提供了关于与客户机和数据库服务器之间传输的连接状态和信息的查看，允许用户确定数据库服务器目前处于何种访问情况。它为 DBA 提供了一种监控接口，用来识别并跟踪服务器上的连接以及它们之间的可用资源。

V$CIRCUIT 既可以管理连接任务，也可以跟踪可用资源，以便防止服务器出现过载。它可以用来检查服务器上活动的会话，以及活动会话的详细信息，如连接状况、信息完整性、会话数量、会话超时等。

使用V$CIRCUIT视图的方法：

1.使用SQL命令 – 使用V$CIRCUIT视图可以使用以下SQL命令查看活动的连接和会话：

SELECT session_id, remote_ip_addr, module, command
FROM V$CIRCUIT;

2.使用Oracle Enterprise Manager（OEM）-使用Oracle Enterprise Manager（OEM），可以使用V$CIRCUIT视图查看和监控会话。转到EM Console，然后转到Development -> Database Connection -> Session History，然后查看数据库服务器上的活动会话。

官方英文解释

V$CIRCUIT contains information about virtual circuits, which are user connections to the database through dispatchers and servers.

Column	Datatype	Description
`CIRCUIT`	`RAW(4 \| 8)`	Circuit address
`DISPATCHER`	`RAW(4 \| 8)`	Current dispatcher process address
`SERVER`	`RAW(4 \| 8)`	Current server process address
`WAITER`	`RAW(4 \| 8)`	Address of the server process that is waiting for the (currently busy) circuit to become available
`SADDR`	`RAW(4 \| 8)`	Address of the session bound to the circuit
`STATUS`	`VARCHAR2(16)`	Status of the circuit: `BREAK` – currently interrupted `EOF` – about to be removed `OUTBOUND` – an outward link to a remote database `NORMAL` – normal circuit into the local database
`QUEUE`	`VARCHAR2(16)`	Queue the circuit is currently on: `COMMON` – on the common queue, waiting to be picked up by a server process `DISPATCHER` – waiting for the dispatcher `SERVER` – currently being serviced `NONE` – idle circuit
`MESSAGE0`	`NUMBER`	Size in bytes of the messages in the first message buffer
`MESSAGE1`	`NUMBER`	Size in bytes of the messages in the second message buffer
`MESSAGE2`	`NUMBER`	Size in bytes of the messages in the third message buffer
`MESSAGE3`	`NUMBER`	Size in bytes of the messages in the fourth message buffer
`MESSAGES`	`NUMBER`	Total number of messages that have gone through this circuit
`BYTES`	`NUMBER`	Total number of bytes that have gone through this circuit
`BREAKS`	`NUMBER`	Total number of breaks (interruptions) for this circuit
`PRESENTATION`	`VARCHAR2(257)`	Presentation protocol used by the client and server
`PCIRCUIT`	`RAW(4 \| 8)`	Address of the parent circuit
`BOUND_TIME`	`NUMBER`	Time that a circuit and shared server have been bound (in centiseconds)
`BOUND_REASON`	`VARCHAR2(32)`	Provides a reason (a short explanation) for why a shared server and circuit could not be unbound. This column is empty when a circuit is not bound to a server. When the server starts serving a circuit, `BOUND_REASON` is empty and remains empty unless the server tries unsuccessfully to unbind the circuit (after it finishes serving the current request). When this column is not empty, it will be cleared once the server and circuit are unbound (that is, once the resources preventing the session migration to another shared server are released).
`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

数据运维技术 » Oracle 视图 V$CIRCUIT 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐