HuckleberryDBA
database musings and other technical stuff.
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;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment