Monitoring Memory Usage of PDBs

The following views to help you monitor the resource usage by PDBs:

  • V$RSRCPDBMETRIC
  • V$RSRCPDBMETRIC_HISTORY

The V$RSRCPDBMETRIC view provides current statistics on resource consumption for PDBs, including CPU usage, parallel execution, I/O generated, and memory usage. Historical statistics are available through the DBA_HIST_RSRC_PDB_METRIC view, which contains Automatic Workload Repository (AWR) snapshots.

COLUMN PDB_NAME FORMAT A10

SELECT r.CON_ID, p.PDB_NAME, 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;

  • SGA_BYTES – PDB’s current SGA usage
  • BUFFER_CACHE_BYTES – PDB’s current buffer cache usage
  • SHARED_POOL_BYTES – PDB’s current shared pool usage
  • PGA_BYTES – PDB’s current PGA usage