Oracle 视图 V$SERVICEMETRIC 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$SERVICEMETRIC是在Oracle数据库中存储服务指标的一个动态视图，用于报告系统中每个服务和其服务水平指标(SLA)的遵守程度。可以按服务，开始时间，结束时间和指标项来查看视图中的数据。
例如，可以通过如下SQL语句来查询ORACLE实例中的某服务的不同指标项的指标值：
SELECT * FROM v$servicemetric
WHERE servicename = ‘myService’
AND start_time > sysdate – INTERVAL ‘1’ day
AND metricname IN (‘metric1’, ‘metric2’, ‘metric3’);
此外，还可以按照不同时间粒度(例如，小时，天，月等)来执行查询，以便得到指标值随时间变化的趋势。
官方英文解释
V$SERVICEMETRIC displays metric values measured on the most recent time interval period for services executing inside the database. Service metrics are measured in 5-second and 1-minute intervals.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Begin timestamp for the interval period |
|
|
|
End timestamp for the interval period |
|
|
|
Interval size (in hundredths of a second) |
|
|
|
Group ID for the service metric group |
|
|
|
Service name hash |
|
|
|
Service name |
|
|
|
Service create timestamp hash value |
|
|
|
Elapsed time per call (in microseconds). This column is deprecated in favor of the |
|
|
|
CPU time per call (in microseconds) |
|
|
|
Elapsed time per call (in microseconds) |
|
|
|
Number of user calls per second |
|
|
|
Database time per second |
|
|
|
Indicates how attractive a given instance is with respect to processing the workload that is presented to the service. A lower number is better. This number is internally computed based on the GOAL (LONG or SHORT) that is specified for the particular service. |
|
|
|
Indicates the predicted increase in the goodness for every additional session that is routed to this instance |
|
|
|
Flags that can be any of the following values:
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
