Oracle教程

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

本站中文解释

_MONITOR

Oracle视图V$SHARED_SERVER_MONITOR是一个系统视图，用于提供关于共享服务器的监控信息。该视图显示当前共享服务器中的活动会话和空闲进程的汇总数据，以及等效会话的日志记录数量。您可以使用V$SHARED_SERVER_MONITOR视图来监视和优化共享服务器池中的空闲回话和进程数。

使用方法：

1. 使用Oracle视图V$SHARED_SERVER_MONITOR来检查共享服务器池中的活动会话数。可以通过如下查询确定当前池中的活动会话数：

SELECT COUNT(*) FROM V$SHARED_SERVER_MONITOR;

2. 使用V$SHARED_SERVER_MONITOR视图，您可以检查共享服务器池中是否有足够的空闲进程供会话使用。可以通过以下查询确定空闲会话的数量：

SELECT COUNT(*) FROM V$SHARED_SERVER_MONITOR
WHERE BUSY_SESSIONS IS NULL;

3. 您还可以使用V$SHARED_SERVER_MONITOR视图检查共享服务器池中给定时间间隔内接收的请求数量。可以通过如下查询确定在给定时间间隔内接收的请求数量：

SELECT COUNT(*) FROM V$SHARED_SERVER_MONITOR
WHERE LAST_ACTIVITY_TIME > SYSDATE-1;

官方英文解释

V$SHARED_SERVER displays information on the shared server processes.

Column Datatype Description

NAME

VARCHAR2(4)

Name of the server

PADDR

RAW(4 | 8)

Server’s process address

STATUS

VARCHAR2(16)

Server status:

  • EXEC – Executing SQL

  • WAIT (ENQ) – Waiting for a lock

  • WAIT (SEND) – Waiting to send data to user

  • WAIT (COMMON) – Idle; waiting for a user request

  • WAIT (RECEIVE) – Waiting for records to be shown in the client application

  • WAIT (RESET) – Waiting for a circuit to reset after a break

  • QUIT – Terminating

MESSAGES

NUMBER

Number of messages processed

BYTES

NUMBER

Total number of bytes in all messages

BREAKS

NUMBER

Number of breaks

CIRCUIT

RAW(4 | 8)

Address of the circuit currently being serviced

IDLE

NUMBER

Total idle time (in hundredths of a second)

BUSY

NUMBER

Total busy time (in hundredths of a second)

IN_NET

NUMBER

Total incoming network wait time (in hundredths of a second)

OUT_NET

NUMBER

Total outgoing network wait time (in hundredths of a second)

REQUESTS

NUMBER

Total number of requests taken from the common queue in this server’s lifetime

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$SHARED_SERVER 官方解释，作用，如何使用详细说明
分享到：

相关推荐