SGA & PGA -- Sizing/Increase/Decrease
Hello All,
I would like to see how much SGA & PGA is used in the oracle database versions 10gR2 and 11gR2. Based on the AWR reports and the paging done in the database and other factors i would like to size the SGA.
When i take the ADDM reports i see the SGA needs to be increased. We are also focusing on the queries and tuning them at the same time i wanted to see if we are really under SIZED or over sized with SGA & PGA.
As i cannot share any of the AWR reports could you please let me know the sql queries which help us in getting the details from historical views like DBA_HIST_SGASTAT & DBA_HIST_PGASTAT. Before i recommend to bump or lower any of the components i want to make sure and double confirm how much SGA/PGA used over the past 3-6 months.So please provide me if anyone has any Oracle queries? Thanks in advance!!
I would like to see how much SGA & PGA is used in the oracle database versions 10gR2 and 11gR2. Based on the AWR reports and the paging done in the database and other factors i would like to size the SGA.
When i take the ADDM reports i see the SGA needs to be increased. We are also focusing on the queries and tuning them at the same time i wanted to see if we are really under SIZED or over sized with SGA & PGA.
As i cannot share any of the AWR reports could you please let me know the sql queries which help us in getting the details from historical views like DBA_HIST_SGASTAT & DBA_HIST_PGASTAT. Before i recommend to bump or lower any of the components i want to make sure and double confirm how much SGA/PGA used over the past 3-6 months.So please provide me if anyone has any Oracle queries? Thanks in advance!!
2