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 |
---|---|---|---|
|
|
|
AWR snapshot ID |
|
|
|
Database ID of the database that took this snapshot |
|
|
|
Instance number of the instance that took this snapshot |
|
|
DBID of an open PDB at the time of the snapshot |
|
|
|
Flag field in capture properties of the PDB. Not used at this time. |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
|
Time the PDB was last opened |