Re: Another Oracle "Myth"?

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Fri, 21 Nov 2003 06:38:41 +0100
Message-ID: <r39rrv4c4ki9sn11ojfiockqpahgit1a0j@4ax.com>

On 20 Nov 2003 18:53:02 -0800, pharfromhome_at_hotmail.com (Geomancer) wrote:

>To me, this does not make any sense, because many well-tuned systems
>benefit from additional RAM. The v$db_cache_advice view was
>introduced in 9i for this very reason.
>
>Is this another Myth, or am I missing something?

You probably subscribe to the Burleson school of 'tune by hit ratio's' Millsap is advocating you should tune the SQL rather than just throwing memory at the problem.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Nov 20 2003 - 23:38:41 CST