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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 12 Aug 1999 21:05:31 GMT
Message-ID: <37b3355e.11383668@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 - 16:05:31 CDT