Tuesday, April 5, 2022

PGA Historical Growth PDB

 sql> show pdbs

retrieve pdb con_id

set linesize 200
col begin_time for a30
col end_time for a30
select snap_id, CON_DBID, begin_time, end_time, pga_bytes/1024/1024/1024
from DBA_HIST_RSRC_PDB_METRIC
where con_id =4
order by 1;