Check Status of PDBs database in Multitenant environment Oracle

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.