Oracle教程

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

本站中文解释

Oracle视图V$SHARED_SERVER_MONITOR实时监视被管理的应用程序的共享服务器的运行情况。它提供了基于用户连接到共享服务器上的系统资源的实时统计信息，例如每小时连接的客户端的数量，服务的等待次数和时间，繁忙程度等。

使用Oracle视图V$SHARED_SERVER_MONITOR需要使用SQL语句，如：

SELECT * FROM V$SHARED_SERVER_MONITOR;

官方英文解释

V$SHARED_SERVER_MONITOR displays information for tuning the shared server.

Column Datatype Description

MAXIMUM_CONNECTIONS

NUMBER

Highest number of virtual circuits in use at one time since the instance started. If this value reaches the value set for the CIRCUITS initialization parameter, then consider raising the value of CIRCUITS.

See Also: “CIRCUITS”

MAXIMUM_SESSIONS

NUMBER

Highest number of shared server sessions in use at one time since the instance started. If this reaches the value set for the SHARED_SERVER_SESSIONS initialization parameter, then consider raising the value of SHARED_SERVER_SESSIONS.

See Also: “SHARED_SERVER_SESSIONS”

SERVERS_STARTED

NUMBER

Total number of shared servers started since the instance started (but not including those started during startup)

SERVERS_TERMINATED

NUMBER

Total number of shared servers stopped by Oracle since the instance started

SERVERS_HIGHWATER

NUMBER

Highest number of servers running at one time since the instance started. If this value reaches the value set for the MAX_SHARED_SERVERS initialization parameter, then consider raising the value of SHARED_SERVERS.

See Also: “SHARED_SERVERS”

DISPATCHERS_CPU

NUMBER

Total CPU time of all dispatchers since the instance started (in millionths of a second)

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

相关推荐