Re: MTS and Memory

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Mon, 13 Sep 2004 19:13:25 +0200
Message-ID: <h5lbk0dnn645b9lbvn5j59ur2inbnj8rhd@4ax.com>

On 10 Sep 2004 08:09:05 -0700, "Dave" <david.best_at_gmail.com> wrote:

>Exactly where did I say I wanted to toss memory at Oracle, cross my
>fingers, do a little dance and hope performance gets better? I
>didn't. I asked for advice on how to tune the SGA in an MTS
>environment, more specifically I asked if anyone had any good
>formula's.

Quoting from your original post

Now my question is, since i'm using MTS how far can I bump up my SGA..

It appears you are just plain lying. You asked to 'toss memory at Oracle' from the outset, adhering to the 'More is better' philosophy preached by several 'gurus' in this forum. And, yes, that is 'voodoo tuning' and rightly so.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Sep 13 2004 - 12:13:25 CDT