8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Dba » Here

Script: pdb_spfiles.sql

( Download Script )

-- -----------------------------------------------------------------------------------
-- File Name    : https://oracle-base.com/dba/12c/pdb_spfiles.sql
-- Author       : Tim Hall
-- Description  : Displays information from the pdb_spfile$ table.
-- Requirements : Access to pdb_spfile$ and v$pdbs.
-- Call Syntax  : @pdb_spfiles
-- Last Modified: 04/05/2021
-- -----------------------------------------------------------------------------------
set linesize 120
column pdb_name format a10
column name format a30
column value$ format a30

select ps.db_uniq_name,
       ps.pdb_uid,
       p.name as pdb_name,
       ps.name,
       ps.value$
from   pdb_spfile$ ps
       join v$pdbs p on ps.pdb_uid = p.con_uid
order by 1, 2, 3;