pdb设置内存参数

查看pdb设置的参数

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;

查看当前pdb占用的内存

set linesize 150 column pdb_name format a10 column begin_time format a26 column end_time format a26 alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss'; alter session set nls_timestamp_format='dd-mon-yyyy hh24:mi:ss.ff'; -- Last sample per PDB. select r.con_id, p.pdb_name, r.begin_time, r.end_time, r.sga_bytes, r.pga_bytes, r.buffer_cache_bytes, r.shared_pool_bytes from v$rsrcpdbmetric r, cdb_pdbs p where r.con_id = p.con_id order by p.pdb_name;

相关参考：https://oracle-base.com/articles/12c/multitenant-memory-resource-management-for-pdbs-12cr2