Oracle教程

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

本站中文解释

V$SERVICEMETRIC_HISTORY视图存储有关汇总的记录，时间戳与上一次采样持续的时间之间的每个服务的性能指标。这里的性能指标有CPU_TIME，ELAPSED_TIME，IO_INTERCONNECT_BYTES，LAUNCHES，DB_TIME等。

使用V$SERVICEMETRIC_HISTORY视图需要指定开始时间与结束时间的系统参数。请参考以下示例来查询受服务影响的性能指标：

SQL> SELECT * FROM v$servicemetric_history
WHERE start_time
AND end_time
AND service_name = ‘ServiceName’;

官方英文解释

V$SERVICEMETRIC_HISTORY displays a recent history of the metric values measured in predefined time interval periods for services executing inside the database. Service metrics are measured in 5-second and 1-minute intervals.
Column Datatype Description

BEGIN_TIME

DATE

Begin timestamp for the interval period

END_TIME

DATE

End timestamp for the interval period

INTSIZE_CSEC

NUMBER

Interval size (in hundredths of a second)

GROUP_ID

NUMBER

Group ID for the service metric group

SERVICE_NAME_HASH

NUMBER

Service name hash

SERVICE_NAME

VARCHAR2(64)

Service name

CTMHASH

NUMBER

Service create timestamp hash value

ELAPSEDPERCALL

NUMBER

Elapsed time per call (in microseconds). This column is deprecated in favor of the DBTIMEPERCALL column.

CPUPERCALL

NUMBER

CPU time per call (in microseconds)

DBTIMEPERCALL

NUMBER

Elapsed time per call (in microseconds)

CALLSPERSEC

NUMBER

Number of user calls per second

DBTIMEPERSEC

NUMBER

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

相关推荐