Status of PDBS in multitenant - Oracle Database Script. SQL> SELECT dbid, name, open_mode, TOTAL_SIZE/1024/1024 FROM v$pdbs; DBID NAME OPEN_MODE TOTAL_SIZE/1024/1024 ---------- ------------------------------ ---------- -------------------- 3987628790 PDB$SEED READ ONLY 830 1360187792 PDB1 READ WRITE 905 3819422575 PDB2 MOUNTED 0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 MOUNTED
SQL> SELECT dbid, name, open_mode, TOTAL_SIZE/1024/1024 FROM v$pdbs; DBID NAME OPEN_MODE TOTAL_SIZE/1024/1024 ---------- ------------------------------ ---------- -------------------- 3987628790 PDB$SEED READ ONLY 830 1360187792 PDB1 READ WRITE 905 3819422575 PDB2 MOUNTED 0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 MOUNTED