This discussion is archived
5 Replies Latest reply: Feb 18, 2013 5:48 AM by user13809017 RSS

Graph for SGA/PGA

user13809017 Newbie
Currently Being Moderated
Hi,

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?

Thanks
  • 1. Re: Graph for SGA/PGA
    Fran Guru
    Currently Being Moderated
    no views, you can check it directly from Enterprise Manager.

    Go to "Memory Advisor" --> SGA (or PGA)
  • 2. Re: Graph for SGA/PGA
    Aman.... Oracle ACE
    Currently Being Moderated
    user13809017 wrote:
    Hi,

    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?
    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?

    Aman....
  • 3. Re: Graph for SGA/PGA
    user13809017 Newbie
    Currently Being Moderated
    Hi,

    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?

    or

    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');

    Is it right approach?

    Thanks

    Edited by: user13809017 on 18 Feb, 2013 5:31 AM
  • 4. Re: Graph for SGA/PGA
    Aman.... Oracle ACE
    Currently Being Moderated
    user13809017 wrote:
    Hi,

    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?

    or

    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');

    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?

    Aman....
  • 5. Re: Graph for SGA/PGA
    user13809017 Newbie
    Currently Being Moderated
    Hi,
     Did you get any such recommendation/observation from the database tools like ADDM  
    We don't get suggestions now,i don't about previous days.
    Did you try to see if there is anything running on the o/s which is eating the memory? 
    Os using less than 5%.

    Sga size is 105G
    Pga size is 60G.
    Swap space is 45 G.


    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points