Oracle 视图 V$PDBS 官方解释,作用,如何使用详细说明
本站中文解释
V$PDBS视图是Oracle的一个动态系统视图,它提供容器数据库(CDB)包含的所有用户数据库(PDB)的当前信息。
它非常类似于V$DATABASE视图,但用于CDB环境和PDB。它可用于显示和监控正在运行的PDB,以及数据库关联的一些元数据,如服务名称、用户名、开放状态和对象字典状态等。
V$PDBS的使用方法:
1、查询所有打开的PDB:
SQL> SELECT CON_ID,NAME, OPEN_MODE
FROM V$PDBS
WHERE OPEN_MODE IN (‘READ WRITE’, ‘READ ONLY’);
2、查询某个PDB的状态:
SQL> SELECT CON_ID, NAME, OPEN_MODE
FROM V$PDBS
WHERE CON_ID = ;
官方英文解释
V$PDBS
displays information about PDBs associated with the current instance.
Column | Datatype | Description |
---|---|---|
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
PDB identifier calculated when the PDB is created and stored in all file headers associated with the PDB |
|
|
Unique identifier associated with the PDB |
|
|
Globally unique identifier (GUID) of this PDB |
|
|
Name of the PDB |
|
|
Open mode information. Possible values:
|
|
|
Indicates whether only users possessing
|
|
|
Date and time when the database was last opened |
|
|
System change number (SCN) for the creation of this PDB |
|
|
Shows the disk space (in bytes) used by the PDB, including both data and temp files. |
|
|
The current block size for the PDB |
|
|
Shows the recovery status for the PDB. Possible values:
|
|
|
This column shows the container ID of the master PDB that this PDB is a snapshot clone of. This column shows a nonzero value only if the PDB is a snapshot clone. For all other cases, it shows a value of 0. |
|
|
Indicates whether the PDB is an application root |
|
|
Indicates whether the PDB is an application PDB |
|
|
Indicates whether the PDB is an application seed (an application seed is also an application PDB) |
|
|
If this PDB is an application PDB, the container ID of an application root to which this application PDB belongs. If this PDB is an application root clone, the container ID of an application root to which this application root clone belongs. Otherwise, NULL. |
|
|
Indicates whether this PDB is an application root clone ( |
|
|
Indicates whether this PDB is a proxy PDB ( |
|
|
Shows whether the PDB is in local undo. Possible values:
This column is not relevant for CDB$ROOT. |
|
|
System change number (SCN) at which the PDB was last converted from shared to local undo, or from local to shared undo. This column is not relevant for CDB$ROOT. |
|
|
Date and time at which the PDB was last converted from shared to local undo, or from local to shared undo. This column is not relevant for CDB$ROOT. |
|
|
Date and time at which the PDB was created. |
|
|
Shows the current disk space usage (in bytes) of the diagnostic traces generated in the PDB, which is represented by the |
|
|
The number of user-created PDBs belonging to a given application root or CDB$ROOT. For all other containers, its value is 0. |
|
|
Shows the current disk space usage (in bytes) by Unified Audit files (.bin format) in the current PDB. |
|
|
Shows the maximum amount of disk space (in bytes) that can be used by data and temp files in the PDB |
|
|
Shows the maximum amount of disk space (in bytes) that can be used by diagnostic traces generated in the PDB |
|
|
Shows the maximum amount of disk space (in bytes) that can be used by Unified Audit files (.bin format) in the PDB |
|
|
Indicates what type of user last changed the PDB. Possible values:
|
|
|
For internal use only |
|
|
Pluggable database tenant key |
|
|
For internal use only |
|
|
The GUID of the PDB, encoded in base64 |
|
|
The incarnation number to which all datafiles belonging to the PDB would be recovered by the |
|
|
Cloud identifier for the PDB |
|
|
Date and time when the database was last closed |
Footnote 1 This column is available starting with Oracle Database 21c.