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: Is "_db_block_cache_protect = true" killing my throughput?

Re: Is "_db_block_cache_protect = true" killing my throughput?

From: Christopher Allen <progplusSPAMBEGONE_at_gte.net>
Date: Thu, 12 Aug 1999 22:14:51 GMT
Message-ID: <vHHs3.720$Bt3.23168@dfiatx1-snr1.gtei.net>


Hundreds of them. I have the feeling you're about to tell me something really useful. *chuckle*

Christopher

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:37b3355e.11383668_at_newshost.us.oracle.com...
> A copy of this was sent to "Christopher Allen"
<progplusSPAMBEGONE_at_gte.net>
> (if that email address didn't require changing)
> On Thu, 12 Aug 1999 20:53:55 GMT, you wrote:
>
> do you see this lots "checkpoint cannot complete" in your alert file?
>
>
> >
> >I tried disabling the $ORACLE_HOME/dbs/init$ORACLE_SID.ora lines for
> >db_block_cache_protect and the four event lines. After bouncing the
> >database, performance was a touch better: 213 records per second, instead
of
> >200. Still, pretty poor. Even my laptop with Personal Oracle does
better.
> >
> >I appreciate all assistance with this!
> >
> >Christopher
> >
> >
>
>
> --
> See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to
Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June
21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle
Corporation Received on Thu Aug 12 1999 - 17:14:51 CDT

Original text of this message

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