We help IT Professionals succeed at work.

Do i need to increse the SGA memory based on this graph to increse database performance ?

deniro1974
deniro1974 used Ask the Experts™
on
Dear All,

Do i need to increse the SGA memory based on this graph to increse database performance ?

please find the attached graph snapshot, please note that i got this snapshot from oracle enterprise manager.

Best regards
SGA.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
No. According to the graph increasing the SGA size will not result in any performance improvement.

Author

Commented:
dear tosse,

OK but why it reaching 3000 MB ?

best regards
As far as I know the graph is designed to show SGA sizes below and above the current SGA size. In your case, the line is virtually flat for SGA sizes above the current size, meaning there will be virtually no improvement from increasing the SGA size.

The graph is simply intended to show what would happen if you increased or decreased the SGA size. The fact that the scale extends to 3 GB does not mean that it would make sense for you to increase the SGA to 3 GB.

Author

Commented:
thanks man i appreciate your help.