1 数据库参数
select name, ispdb_modifiable, value from v$parameter
where ispdb_modifiable='TRUE'
order by name;;
select name from v$system_parameter
where ispdb_modifiable = 'TRUE'
order by name;
select pdb_uid, name, value$ from pdb_spfile$;
desc v$parameter -- 当前会话参数(内存中)
desc v$system_parameter -- 实例当前有效参数
2 PDB级别
alter system flush shared_pool
alter system flush buffer_cache
alter system enable restricted session
alter system kill session
3 CDB级别
alter system checkpoint