I was exploring the options get the resource usage statistics at the resource pool level and thats when I ended up with a set of these data collector tables, which I thought would collect the statistics by time slice as per its naming suffix. However, to my suprise, I could not find any of the resource pools in the system and I see two new entries called 'SAL' and 'Global'. Does anyone have any idea as to what thse pool names are?
Also, is there any system table which could give the historical memory usage statistics at each resource pool level throughout a 24 hour window?
Code: Select all
dbadmin=> select table_name,description from v_monitor.data_collector where component like 'AllocationPoolStatistics%';
table_name | description
-----------------------------------------+--------------------------------------------------------------------------------------------------------------------
dc_allocation_pool_statistics | Information about global memory pools, which generally cannot be recovered without restart
dc_allocation_pool_statistics_by_second | Information about global memory pools, which generally cannot be recovered without restart (historical, by second)
dc_allocation_pool_statistics_by_minute | Information about global memory pools, which generally cannot be recovered without restart (historical, by minute)
dc_allocation_pool_statistics_by_hour | Information about global memory pools, which generally cannot be recovered without restart (historical, by hour)
dc_allocation_pool_statistics_by_day | Information about global memory pools, which generally cannot be recovered without restart (historical, by day)
(5 rows)
dbadmin=>
dbadmin=> select pool_name from dc_allocation_pool_statistics_by_hour group by pool_name;
pool_name
-----------
Global
SAL
(2 rows)
dbadmin=>