Re: Approximately sizing SGA

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 16 Dec 2004 08:31:40 +0100
Message-ID: <19e2s01kddv3s3u0q9h3n88qr6otc9gp77@4ax.com>

On 15 Dec 2004 20:04:02 -0800, "iloadmin" <ilo_at_ilo-infosystems.us> wrote:

>I am going to consider all written here. I will look at 'hit ratio
>tuning' and understand in practice as well as theory. I am not sure
>what you mean by application ?

any sql fired against the database

Are you clearly saying that front-end
>(website) needs to be designed in a specific way to enhance its'
>symbotic relationship with Oracle?

Sure. Those that don't either have been exposed to sqlserver or don't know how to write efficient sql, whether for sqlserver or Oracle, or blame invariably the database when the performance is bad. In almost all cases it can be demonstrated you can tune the server and database whatever you want, but you won't resolve it. Note: Generic frontends are a marketing hype. It won't work, ever.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Dec 16 2004 - 01:31:40 CST