Re: More Memory the better ...Why not

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 26 Aug 2003 06:47:32 +0200
Message-ID: <icplkv08iskkuqhsgu55dcm97nlrku2ffe@4ax.com>

On Mon, 25 Aug 2003 21:10:14 -0400, Franklin <member29243_at_dbforums.com> wrote:

>
>Well, how about using a 10 gig db_cache_size?
>
>

Plain utter bs move
Do you understand anything at all about virtual memory? No, you don't

>
>Is there such a thing as too much data buffer RAM?
>
>

Sure there is.

>
>Actually, all data buffer RAM is hashed, so size is not an issue
>there, BUT you can degrade performance with a super-sized
>db_cache_size is when:
>
>
>
>1 - You have heavy use of temp tables, truncates or data purging -
>Oracle must sweep all blocks in the data buffer to clean-out
>inval;id blocks
>

Bullshit. Temp tables have NOTHING to do with it.
>
>
>2 - High updates - The DBWR must scan the whole data buffer looking for
>dirty blocks, causing high work for the DBWR process.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Aug 25 2003 - 23:47:32 CDT