新特性:CDB/PDB的维护命令:查看pdb信息的几种方法

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1_WHS MOUNTED

SQL> select con_id,name,open_mode from v$pdbs;

CON_ID NAME OPEN_MODE
---------- -------------------- ------------------------------
2 PDB$SEED READ ONLY
3 PDB1_WHS MOUNTED

SQL> col pdb_name format a8
SQL> col con_id format 999999
SQL> select pdb_id,pdb_name ,dbid,guid,con_id from cdb_pdbs;

PDB_ID PDB_NAME DBID GUID CON_ID
---------- -------- ---------- -------------------------------- -------
3 PDB1_WHS 3186594011 B4D31742116320ECE0532900A8C025DC 3
2 PDB$SEED 2917495253 B4D2EF8C057D02B6E0532900A8C05009 2

Related Posts