Candido Dessanti <termy_at_blunet.it> wrote:
>xueyang wrote:
>> One simple question, Is it the larger the size of SGA is, the better
>> performance we get?
>
>
>Increasing the SGA normally makes the things going faster or at least
>going as before until the increase cause swap on the OS so the things
>could go slower.
If your entire database (or at least the data set being accessed by
common queries) already fits in the buffer cache, making the buffer
cache larger may slow you down since there is more management
overhead.
--
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
Received on Thu Sep 19 2002 - 07:29:58 CDT
