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

本站中文解释

-新镜像片

Oracle 视图 DBA_HIST_PDB_IN_SNAP 查看每一个快照中包含哪一个pluggable database(可插拔数据库)。它会显示每一个快照的PBD ID以及相应的时间。它还提供了Auto Service Request(ASR)的ID。使用特定的ASR ID,数据库管理员可以指定要使用的特定镜像片。

使用方法:

1. 首先,在Oracle终端中输入以下命令,以查看DBA_HIST_PDB_IN_SNAP视图:

SELECT * FROM DBA_HIST_PDB_IN_SNAP;

2. 使用ASR_ID过滤结果,以查看特定镜像片中包含的PDB:

SELECT * FROM DBA_HIST_PDB_IN_SNAP WHERE ASR_ID = ‘12345’;

官方英文解释

DBA_HIST_PDB_IN_SNAP captures a list of open pluggable databases (PDBs) at the time of the Automatic Workload Repository (AWR) snapshot. This view can be used with other DBA_HIST_ views to construct the number of opened PDBs at the time of the snapshot.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

AWR snapshot ID

DBID

NUMBER

NOT NULL

Database ID of the database that took this snapshot

INSTANCE_NUMBER

NUMBER

NOT NULL

Instance number of the instance that took this snapshot

CON_DBID

NUMBER

DBID of an open PDB at the time of the snapshot

FLAG

NUMBER

Flag field in capture properties of the PDB. Not used at this time.

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

OPEN_TIME_TZ

TIMESTAMP(3) WITH TIME ZONE

Time the PDB was last opened


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