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: cablito <cablito_at_gmail.com>
Date: Sun, 17 Jun 2007 13:58:04 -0700
Message-ID: <1182113884.574117.233450@o61g2000hsh.googlegroups.com>


Yes, I need to push this info to the dba.

I am just the developer, with some know-how on oracle, trying to get some more input for the dba.

> 90% of memory devoted to buffer cache is outrageous.
Lol.

Thanks for the reply.

On Jun 17, 5:52 pm, sybra..._at_hccnet.nl wrote:
> On Sun, 17 Jun 2007 13:16:29 -0700, cablito <cabl..._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:58:04 CDT

Original text of this message

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