Oracle教程 2023-02-24

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

本站中文解释

Oracle视图V$QMON_SERVER_STATS提供了一些关于QMON Server的统计信息，包括它的连接套接字及其他相关内容。

可以通过以下查询来使用这张视图：

SELECT *
FROM v$qmon_server_stats;

该查询将返回QMON服务器的数据，如服务器状态，连接套接字和连接状态。

使用这张视图意义重大，因为它可以让用户了解QMON服务器的运行状态和统计信息，以便对系统进行优化和修复。

官方英文解释

V$QMON_SERVER_STATS displays information and statistics about the active queue monitor server processes. There is one row per live queue monitor server process. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.

Column	Datatype	Description
`QMNC_PID`	`VARCHAR2(24)`	Non-sharded queue master process ID
`SERVER_PID`	`VARCHAR2(24)`	Process ID of the server
`SERVER_NAME`	`VARCHAR2(48)`	Name of the server
`STATUS`	`VARCHAR2(40)`	Current state of the server: `UNUSED` `RUNNING` `IDLE WAIT` `EXITING` `NOT ACTIVE`
`SERVER_START_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	Start time of the server
`TASK_NAME`	`VARCHAR2(32)`	Current executing task
`TASK_NUMBER`	`NUMBER`	Unique task number of the running task
`TASK_START_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	Start time of the running task
`LAST_WAIT_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	Time when the server last waited
`MAX_LATENCY`	`NUMBER`	Maximum task latency for this server (in seconds)
`MIN_LATENCY`	`NUMBER`	Minimum task latency for this server (in seconds)
`TOTAL_LATENCY`	`NUMBER`	Cumulative task latency for this server (in seconds)
`NUM_TASKS`	`NUMBER`	Number of tasks processed by the server
`LAST_FAILURE`	`VARCHAR2(128)`	Last failure encountered by the server
`LAST_FAILURE_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	Last failure time
`LAST_FAILURE_TASK`	`VARCHAR2(32)`	Task being run at the time of the last failure
`LAST_FAILURE_TASKNUM`	`NUMBER`	Unique task number of the failed task
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. The `CON_ID` value in this view is always 0. The rows pertain to the entire CDB or to the non-CDB.

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

分享到：

本站中文解释

官方英文解释

相关推荐