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