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: Oracle Memory Settings

Re: Oracle Memory Settings

From: <sybrandb_at_hccnet.nl>
Date: Sun, 17 Jun 2007 22:52:49 +0200
Message-ID: <rk7b731ibom7okcafdejlso4p70o0qurau@4ax.com>


On Sun, 17 Jun 2007 13:16:29 -0700, cablito <cablito_at_gmail.com> wrote:

>On another issue with DBA paradigms, I have strong reasons to believe
>that leaving the Oracle memory settings on "0", auto is not the ideal.
>
>We are having a high parse-to-execute ratio, and that is because the
>"0" auto setting has lead oracle to set, out of the already
>missconfigured memory usage( only 4GB out of 8 in the system) the
>buffer Cache is using 90% of memory.
>
>That is leaving only 500mb for the shared pool.
>
>Am I correct in believing this is the reason for the bad parse-to-
>execute ratio?

No, incorrect.
High parse to execute ratio is being caused by not using bind variables.
500 Mb shared pool should be sufficient. 90% of memory devoted to buffer cache is outrageous. I would recommend reading the concepts manual at once, and buy Tom Kytes books.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Sun Jun 17 2007 - 15:52:49 CDT

Original text of this message

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