Originally posted by ovidius
Third time , I have to tell you. The issue when you tune the SGA is not the SGA itself. The SGA is as big as you can afford without entering in paging or swaping state. And no problem if you can afford a lot.
The issue is how you ORGANIZE your SGA, by this meaning shared pool, db buffer cache, log buffer, large pool, java pool etc. It is a relative issue. Tunning some of the parts is easy. Tunning other is not so easy. So...
I apologise ovidius. Somehow I am not conviced with answers such as "it depends...", "its relative...." etc etc.

I have a precise question with a precise scenario and example. The answer if not very precise will atleast have to be close. This is my understanding.