Re: More Memory the better ...Why not

Well, how about using a 10 gig db_cache_size?

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

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

2 - High updates - The DBWR must scan the whole data buffer looking for dirty blocks, causing high work for the DBWR process.

--
Posted via http://dbforums.com