5 Replies Latest reply: Feb 18, 2013 7:48 AM by user13809017 RSS

    Graph for SGA/PGA

    user13809017
      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
          no views, you can check it directly from Enterprise Manager.

          Go to "Memory Advisor" --> SGA (or PGA)
          • 2. Re: Graph for SGA/PGA
            Aman....
            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
              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....
                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
                  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