How to list all PDBs and their open mode in Oracle

List the pluggable databases in the CDB with their open mode, restricted flag, and size. Run from the root container.

-- Open mode and size
SELECT con_id, name, open_mode, restricted,
       ROUND(total_size/1024/1024/1024, 2) AS size_gb
FROM   v$pdbs
ORDER  BY con_id;

-- Catalog view (status, creation SCN)
SELECT pdb_id, pdb_name, status, creation_scn
FROM   cdb_pdbs
ORDER  BY pdb_id;