Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SGA

Re: SGA

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 19 Sep 2002 13:29:58 +0100 (BST)
Message-ID: <YPq*rdNyp@news.chiark.greenend.org.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US