Oracle教程 2023-03-28

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

本站中文解释

官方英文解释

相关推荐