How do I know if my database is PDB or CDB?

How can I tell if my Oracle database is PDB or CDB?

Starting Oracle 12.2 sys_context('USERENV','DB_NAME') will show the name of the Database in CDB$ROOT and the name of the PDB inside the PDB.

What is the difference between PDB and CDB?

A CDB includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and non-schema objects that appears to an Oracle Net client as a non-CDB . All Oracle databases before Oracle Database 12c were non-CDBs.

How do I know if PDB is running?

Check Startup, uptime and creation time of PDB database1Check startup time of PDB database. col name for a8. ... 2Check uptime of PDB database. col name for a8. ... 3Check creation time and status of PDBS. select pdb_name,creation_time,status from dba_pdbs; ... 4Check size of PDBS.

Can CDB and PDB have the same name?

The PDB name must be unique in the CDB, and it must be unique within the scope of all the CDBs whose instances are reached through a specific listener."