Re: who has LINUX - 9iR2 in production?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 12 Mar 2003 00:11:36 +1100
Message-ID: <pan.2003.03.11.13.11.35.932928@yahoo.com.au>

On Tue, 11 Mar 2003 13:56:37 +0100, Tomislav Sagrak wrote:

> Thanks,
>
> So, anyone whi is using a production database has probably tried to use the
> use_indirect_data_buffers="true"
> or larger pages?

I doubt it (or at least, I sincerely hope not). That parameter is used to make Oracle use more than 4GB of memory, so you'd only want to enable it under the most demanding of circumstances (since the total SGA size should not exceed 1/3rd to 1/2 of total physical RAM, it would imply you're running on a box with at least 8GB and probably 12GB of RAM before switching it on would make sense).

You'd have to question the efficiency of an SGA as big as that under most circumstances (though not all, I accept). On the principle that 'more means faster', I've seen such SGAs. They never actually needed to be that big in reality. Gets a bit embarrasing when you can take 16GB RAM and make it run in 2GB.

As for larger pages: do you mean bigger Oracle blocks, or are you talking about memory pages??

4K is right for a block size on Linux, unless you are using RAW.

Regards
HJR Received on Tue Mar 11 2003 - 07:11:36 CST