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

本站中文解释

Oracle视图V$RSRC_PDB_HISTORY是一个数据字典视图,它可以用来查看由于资源限制影响而从现存的容器中驱逐的Pluggable Databases (PDBs)的历史信息。

V$RSRC_PDB_HISTORY视图拥有8列,包括:

RSRC_PDB_HISTORY_ID:PDB驱逐的唯一的ID;

CON_ID:PDB所在的容器的ID;

PDB_ID:PDB的ID;

PDB_NAME:PDB的名称;

START_TIMESTAMP:PDB驱逐开始的时间戳;

END_TIMESTAMP:PDB驱逐结束的时间戳;

RSRC_LIMIT:触发PDB驱逐的资源限制;

ERROR_MSG:驱逐导致的错误消息。

V$RSRC_PDB_HISTORY视图通过管理员查询历史资源限制侵入的PDB的时间起止,是一个非常有用的数据字典视图。

使用V$RSRC_PDB_HISTORY视图:

— 1. 查询Oracle中当前被暂时驱逐的PDB
SELECT pdb_name
FROM v$rsrc_pdb_history
WHERE end_timestamp IS NULL;

— 2. 查询指定日期范围内被驱逐暂时驱逐的PDB
SELECT pdb_name, start_timestamp
FROM v$rsrc_pdb_history
WHERE start_timestamp > = ‘&start_date’
AND start_timestamp

官方英文解释

V$RSRC_PDB_HISTORY displays a history of consumer group statistics for each entry in V$RSRC_PDB that has a non-NULL plan by pluggable database (PDB).

When the STATISTICS_LEVEL is set to TYPICAL or ALL, this view contains information about CPU utilization and wait times even when no Resource Manager plan is set or when the Resource Manager plan does not monitor CPU or session resources.

A new window is created in V$RSRC_PDB_HISTORY when a multitenant container database (CDB) changes its resource plan. The plan windows for the CDB are not impacted by a PDB resource plan change.

V$RSRC_PDB_HISTORY covers the same time period for all PDBs. This view is specifically designed for comparing statistics across different PDBs.

Since V$RSRC_PDB_HISTORY does not contain information at the consumer group level, it is not useful for comparing consumer groups inside a PDB.

Column Datatype Description

SEQUENCE#

NUMBER

A sequential counter that uniquely describes the V$RSRC_PDB entry to which these consumer group statistics apply. When the instance is restarted, this value is reset to zero.

PDB_NAME

VARCHAR2(32)

PBD name

CPU_WAIT_TIME

NUMBER

Cumulative amount of time that sessions waited for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on. When CPU resources are not being actively managed, this value is set to zero.

CPU_WAITS

NUMBER

Cumulative number of times all sessions in the consumer group had to wait for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on. When CPU resources are not being actively managed, this value is set to zero.

CONSUMED_CPU_TIME

NUMBER

Cumulative amount of CPU time consumed by all sessions in the consumer group (in milliseconds)

YIELDS

NUMBER

Cumulative number of times that sessions in the consumer group had to yield CPU to other sessions because of quantum expiration. When CPU resources are not being actively managed, this value is set to zero.

IO_SERVICE_TIME

NUMBER

Cumulative I/O wait time (in milliseconds)

IO_SERVICE_WAITS

NUMBER

Total number of wait requests

SMALL_READ_MEGABYTES

NUMBER

Number of single block megabytes read

SMALL_WRITE_MEGABYTES

NUMBER

Number of single block megabytes written

LARGE_READ_MEGABYTES

NUMBER

Number of multiblock megabytes read

LARGE_WRITE_MEGABYTES

NUMBER

Number of multiblock megabytes written

SMALL_READ_REQUESTS

NUMBER

Number of single block read requests

SMALL_WRITE_REQUESTS

NUMBER

Number of single block write requests

LARGE_READ_REQUESTS

NUMBER

Number of multiblock read requests

LARGE_WRITE_REQUESTS

NUMBER

Number of multiblock write requests

PQS_COMPLETED

NUMBER

Total number of completed parallel statements in the consumer group

PQ_SERVERS_USED

NUMBER

Total number of parallel servers used by completed parallel statements in the consumer group

PQS_QUEUED

NUMBER

Number of times that sessions in the consumer group were queued when trying to run parallel statements

PQ_ACTIVE_TIME

NUMBER

Cumulative sum of the parallel active times for all completed parallel statements in the consumer group (in milliseconds)

PQ_QUEUED_TIME

NUMBER

Total amount of time that sessions in the consumer group were queued when trying to run parallel statements (in milliseconds)

PQ_QUEUE_TIME_OUTS

NUMBER

Number of times that parallel statements from sessions in the consumer group timed out because their queue time exceeded the Resource Manager plan’s PARALLEL_QUEUE_TIMEOUT limit

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

See Also:

“V$RSRC_CONS_GROUP_HISTORY”


数据运维技术 » Oracle 视图 V$RSRC_PDB_HISTORY 官方解释,作用,如何使用详细说明