DBA AWR PGA History
Description
Categories: Diagnostic Pack, Enginatics, Kcapps, Toolkit - DBA
Repository: Github
Repository: Github
History of database PGA size and other statistics from v$pgastat in megabytes
select * from ( select xxen_util.client_time(dhs.end_interval_time) end_interval_time, dhs.instance_number, dhp.name, case when dhp.name in ( 'recompute count (total)', 'cache hit percentage', 'max processes count', 'process count' ) then dhp.value else dhp.value/1000000 end value_ from dba_hist_snapshot dhs, dba_hist_pgastat dhp where 1=1 and dhs.dbid=dhp.dbid and dhs.instance_number=dhp.instance_number and dhs.snap_id=dhp.snap_id ) pivot ( sum(value_) val for name in ( 'aggregate PGA target parameter' aggr_pga_target, 'aggregate PGA auto target' aggr_pga_auto_target, 'bytes processed' bytes_processed, 'global memory bound' glob_mem_bound, 'total PGA allocated' total_pga_alloc, 'maximum PGA allocated' max_pga_alloc, 'PGA memory freed back to OS' pga_freed_back, 'total PGA inuse' total_pga_inuse, 'total freeable PGA memory' total_freeable_pga, 'maximum PGA used for auto workareas' max_pga_used_auto_workareas, 'recompute count (total)' recompute_count, 'cache hit percentage' "CACHE_HIT_%", 'max processes count' max_process_count, 'process count' process_count ) ) order by end_interval_time desc, instance_number |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Date From |
|
LOV | |
Date To |
|
LOV | |
Diagnostic Pack enabled |
|
LOV | |
Container Data |
|
LOV |
Blitz Report™