SHOW PLUGGABLE DATABASE

This command displays the information or property values of the specified pluggable database (PDB).

Format

SHOW PLUGGABLE DATABASE <pdb_name> AT <target_db_unique_name> [ALL];
SHOW ALL PLUGGABLE DATABASE AT <target_db_unique_name>

Command Parameters

pdb_name

Name of the PDB whose details must be displayed.

target_db_unique_name

Name of the database that contains the PDB specified in pdb_name. Include the ALL keyword to display information about all source PDBs and target PDBs at the database specified by database_name

Examples

Example 10-11 Displaying Details of a PDB

This example shows details about the PDB sales in an abbreviated format.

DGMGRL> SHOW PLUGGABLE DATABASE 'sales' AT boston;
Pluggable database 'sales' at database 'boston'
  Data Guard Role: Physical Standby
  Con_ID: 7
  Source: con_id 6 at newyork
  Transport Lag: +00 00:00:00 seconds
  Intended State: APPLY-ON
  Apply State: Running
  Apply Instance: boston
  Average Apply Rate: 16 KByte/s
  Real Time Query: OFF