Check Status of PDBs in Multitenant environment
col name for a15
select dbid,name,open_mode,TOTAL_SIZE/1024/1024 "Size MB" from v$pdbs;
DBID NAME OPEN_MODE Size MB
---------- --------------- ---------- ----------
3519455575 PDB$SEED MOUNTED 782
211227326 XEPDB1 MOUNTED 15299
1863750185 PDB1 MOUNTED 827
3687486700 PDB2 MOUNTED 1352
Check Status with show command
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 XEPDB1 MOUNTED
4 PDB1 MOUNTED
5 PDB2 MOUNTED
Check more details of PDBs from history table
col db_name for a7
col CLONED_FROM_PDB_NAME for a12
col pdb_name for a10
SELECT DB_NAME, CON_ID, PDB_NAME, OPERATION, OP_TIMESTAMP, CLONED_FROM_PDB_NAME FROM CDB_PDB_HISTORY;
DB_NAME CON_ID PDB_NAME OPERATION OP_TIMEST CLONED_FROM_
------- ---------- ---------- ---------------- --------- ------------
XE 1 PDB$SEED UNPLUG 04-FEB-19
XE 1 PDB$SEED DROP 04-FEB-19
XE 1 PDB$SEED PLUG 18-SEP-19 PDB$SEED
XE 1 XEPDB1 CREATE 18-SEP-19 PDB$SEED
XE 1 PDB1 CREATE 18-SEP-19 PDB$SEED
XE 1 PDB2 CREATE 20-SEP-19 PDB$SEED