user13809017 wrote:I don't think that there is any view that's going to contain information for such longer time. Why you want to use such long duration information?
I am asked to take a trend analysis(graph for a month) about sga and pga.
We using 11.2 on aix.
Is there any view to find?
user13809017 wrote:If you are on 11g, it's better to use the Memory Target than the SGA target. Other than this, the swap being used is on the o/s side. What really triggered you that the database is running out the memory ? Did you get any such recommendation/observation from the database tools like ADDM ? Did you try to see if there is anything running on the o/s which is eating the memory?
Due to check whether we have sufficient memory have or not.Because of Last 2 weeks we getting high SWAP utilization in the server.
We enabled only sga_target,not memory_target.
Can i use DBA_HIST_PGA_TARGET_ADVICE and DBA_HIST* tables?
select min(FINAL_SIZE) from DBA_HIST_MEMORY_RESIZE_OPS where COMPONENT='DEFAULT buffer cache' and
END_TIME between TO_DATE('07-02-2013 06:00','DD-MM-YYYY hh24:mi') and TO_DATE('07-02-2013 08:00','DD-MM-YYYY hh24:mi');
We don't get suggestions now,i don't about previous days.
Did you get any such recommendation/observation from the database tools like ADDM
Os using less than 5%.
Did you try to see if there is anything running on the o/s which is eating the memory?