View Current PDB Container in Oracle

2 years ago
Noah Thompson
1 minute

To take a closer look at the current PDB container, you can follow these steps:

  1. Connect to an Oracle database: use SQL*Plus, SQL Developer, or similar tools to connect to your Oracle database.
  2. Switch to the appropriate Container: If you are not in CDB$ROOT, first ensure you are in the correct Container. You can execute the following SQL statement to switch to the CDB$ROOT container:
  3. Change the session to use the root container.
  4. Check the current PDB container: Run the following SQL query to view the name of the PDB container currently in read-write mode:
  5. Retrieve the names and open modes of PDBs that are in the ‘READ WRITE’ state.

This will display the name and open mode of the current PDB being used. Make sure you have enough permissions to query the v$pdbs view.

bannerAds