Quote:
Originally posted by ovidius
If you have a good piece of hell of activity there, then your performance will increase, maybe dramatically if before the system was lacking in resources.
If your activity was not so large to "cover" your previously 512 Mb, then mainly nothing happens, because even if you will have a very very very bad SGA fragmentation after many many many time (the frag does not come instantaneously), the decrese of performance due to this is probably less than 1%.
This is my oppinion.
Any others?
So if this the scenario, there is no harm in increasing the SGA! Hmm...interesting. Rather really amusing cos after all Majority of the SGA tuning is solved by a simple resolution - increase SGA!! I am somehow skepitcal. We are for sure missing something...something very important.