Oracle 视图 V$RSRC_PLAN_CPU_MTH 官方解释，作用，如何使用详细说明-云搜网

Oracle视图V$RSRC_PLAN_CPU_MTH是一个基于分层的汇总的实时性能视图，它可以用来查询资源计划下资源利用率按照每分钟、每小时和每天的统计总量。

通过视图V$RSRC_PLAN_CPU_MTH，可以查询每个资源计划的每小时使用量以及该小时内放大和分配的CPU时间等信息。

应用：

1. 通过查看V$RSRC_PLAN_CPU_MTH视图可以查看不同资源计划的详细使用情况，以及每个资源计划占用CPU时间的比例，从而帮助DBA及时并准确地进行性能分析及监控。

2. 可以查看某个资源计划在特定时间段内的使用量，从而识别资源消耗超标的资源计划。

使用方法：

使用V$RSRC_PLAN_CPU_MTH视图，可以使用以下SQL查询每个资源计划的每小时使用量：

SELECT plan_name, sum(amplification*(10*usertime+sys_time))/(10*36) AS HOURLY_CPU_USAGE
FROM V$RSRC_PLAN_CPU_MTH
GROUP BY plan_name;

V$RSRC_PLAN_CPU_MTH displays all available CPU resource allocation methods defined for resource plans.

Column Datatype Description

Column	Datatype	Description
`NAME`	`VARCHAR2(40)`	Name of the resource allocation method
`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

NAME

VARCHAR2(40)

Name of the resource allocation method

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$RSRC_PLAN_CPU_MTH 官方解释，作用，如何使用详细说明