Oracle教程 2023-02-24

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

本站中文解释

Oracle 视图 DBA_HIST_SERVICE_STAT 是Oracle中提供的一个动态性能视图，用于了解服务器执行服务或者任务的性能信息。它显示执行每项任务的平均响应时间，以及执行过程中是否有任何等待时间和出错信息。

使用此视图，DBA可以跟踪会话的性能状况，响应时间，错误和等待活动，以了解每个数据库服务期间的性能表现。

在Oracle中使用此视图，例如查询活动最慢的会话，DBA可以使用如下查询语句：

SELECT * FROM dba_hist_service_stat ORDER BY start_time DESC;

官方英文解释

DBA_HIST_SERVICE_STAT displays the history of important service statistics tracked by the Workload Repository.

The call rate statistics in this view can be used for making run-time routing decisions, for tracking service levels, and for per-instance diagnostics per call rate.

The elapsed timing for each call provides a relative value across instances for how well a node is processing SQL calls issued under a service name. When aggregation is enabled for the service name, this view provides historical data on the timing and work done for calls issued for the whole service. This view contains information from V$SERVICE_STATS.

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
`SERVICE_NAME_HASH`	`NUMBER`	`NOT NULL`	Hash of the service name
`SERVICE_NAME`	`VARCHAR2(64)`	`NOT NULL`	Name of the service
`STAT_ID`	`NUMBER`	`NOT NULL`	Statistic identifier
`STAT_NAME`	`VARCHAR2(64)`	`NOT NULL`	Statistic name
`VALUE`	`NUMBER`		Value of the statistic
`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

本站中文解释

官方英文解释

相关推荐