PDB入门
容器show con_id con_name user数据文件select con_id, name from v$datafile;select con_id, file_name from cdb_data_files;CDB & PDBselect con_id, name, open_mode from v$pdbs;select con_id, pdb_id, pdb_name,
·
容器
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;
更多推荐
已为社区贡献3条内容
所有评论(0)