Oracle 视图 DBA_HIST_SHARED_SERVER_SUMMARY 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图DBA_HIST_SHARED_SERVER_SUMMARY提供了一个汇总的概述,展示了你的Oracle数据库中所有共享服务器的使用情况。通过该视图可以包括但不仅限于对每一个共享服务器分配的工作任务、每个周期内每个共享服务器运行的时间、每个共享服务器应答连接的次数、每个共享服务器处理的错误、以及每个共享服务器使用的存储过程等信息。

使用Oracle视图DBA_HIST_SHARED_SERVER_SUMMARY需要以sys用户或具有select_catalog_role权限的用户账户登录系统,然后使用下面的语句来查询Oracle数据库中所有共享服务器的使用概览:

SELECT * FROM DBA_HIST_SHARED_SERVER_SUMMARY;

当需要进一步查询指定共享服务器的概览时,可以使用WHERE子句来指定shared_server_name:

SELECT * FROM DBA_HIST_SHARED_SERVER_SUMMARY WHERE shared_server_name = ‘YourSharedServerName’;

官方英文解释

DBA_HIST_SHARED_SERVER_SUMMARY displays historical information for shared servers.

This includes information about shared server activity, the servers, common queues, and dispatcher queues. This view obtains information from V$SHARED_SERVER, V$DISPATCHER, V$CIRCUIT, and V$QUEUE, and is aggregated over all servers, dispatchers, queues, and circuits.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot ID

DBID

NUMBER

NOT NULL

Database ID for the snapshot

INSTANCE_NUMBER

NUMBER

NOT NULL

Instance number for the snapshot

NUM_SAMPLES

NUMBER

Total number of samples

SAMPLE_TIME

NUMBER

Last sample timestamp

SAMPLED_TOTAL_CONN

NUMBER

Cumulative sum of total number of connections over all samples. To determine the average number of connections between two snapshots, divide the difference in SAMPLED_TOTAL_CONN by the difference in NUM_SAMPLES.

SAMPLED_ACTIVE_CONN

NUMBER

Cumulative sum of active number of connections over all samples. To determine the average number of active connections between two snapshots, divide the difference in SAMPLED_ACTIVE_CONN by the difference in NUM_SAMPLES.

SAMPLED_TOTAL_SRV

NUMBER

Cumulative sum of total number of servers over all samples. To determine the average number of servers between two snapshots, divide the difference in SAMPLED_TOTAL_SRV by the difference in NUM_SAMPLES.

SAMPLED_ACTIVE_SRV

NUMBER

Cumulative sum of active number of servers over all samples. To determine the average number of active servers between two snapshots, divide the difference in SAMPLED_ACTIVE_SRV by the difference in NUM_SAMPLES.

SAMPLED_TOTAL_DISP

NUMBER

Cumulative sum of total number of dispatchers over all samples. To determine the average number of dispatchers between two snapshots, divide the difference in SAMPLED_TOTAL_DISP by the difference in NUM_SAMPLES.

SAMPLED_ACTIVE_DISP

NUMBER

Cumulative sum of active number of dispatchers over all samples. To determine the average number of active dispatchers between two snapshots, divide the difference in SAMPLED_ACTIVE_DISP by the difference in NUM_SAMPLES.

SRV_BUSY

NUMBER

Total shared server busy time (in hundredths of a second)

SRV_IDLE

NUMBER

Total shared server idle time (in hundredths of a second)

SRV_IN_NET

NUMBER

Total shared server incoming network wait time (in hundredths of a second). This includes waits for receives and resets. This time is also included in SRV_BUSY.

SRV_OUT_NET

NUMBER

Total shared server outgoing network wait time (in hundredths of a second). This includes waits for sends and outbound connection requests. This time is also included in SRV_BUSY.

SRV_MESSAGES

NUMBER

Number of messages processed

SRV_BYTES

NUMBER

Total number of bytes in all messages

CQ_WAIT

NUMBER

Total time that all items in the common queue have waited (in hundredths of a second)

CQ_TOTALQ

NUMBER

Total number of items that have ever been in the common queue

DQ_TOTALQ

NUMBER

Total number of items that have ever been in a dispatcher queue

CON_DBID

NUMBER

The database ID of the PDB for the sampled session

CON_ID

NUMBER

The ID of the container that CON_DBID identifies. 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

See Also:

  • “V$SHARED_SERVER”

  • “V$DISPATCHER”

  • “V$CIRCUIT”

  • “V$QUEUE”


数据运维技术 » Oracle 视图 DBA_HIST_SHARED_SERVER_SUMMARY 官方解释,作用,如何使用详细说明