PDB入门

容器

show con_id con_name user

数据文件

select con_id, name from v$datafile;
select con_id, file_name from cdb_data_files;

CDB & PDB

select con_id, name, open_mode from v$pdbs;
select con_id, pdb_id, pdb_name, status from cdb_pdbs;

容器 & 数据库

select con_id, dbid, con_uid, guid, name from v$containers;
select dbid, name, open_mode, cdb, con_id from v$database;

参数

select name from v$system_parameter
where ispdb_modifiable = 'TRUE'
order by name;
select pdb_uid, name, value$ from pdb_spfile$;

REDO

select member from v$logfile;

归档

archive log list 

表空间

select con_id, name from v$tablespace order by con_id;