mirzabaig28 wrote:post SQL & results that would indicate any change would be appropriate.
Hello everyone,. I am currently working on Oracle 11g R2 on Red Hat Linux 5 System. My current RAM on the server is 48 Gb.
PGA has been assigned 10 Gb, SGA has been allocated with 30 Gb and rest 8 Gb is been used by Linux.
Is there any suggestion for increasing or decreasing either PGA or SGA Memory.