Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: who has LINUX - 9iR2 in production?

Re: who has LINUX - 9iR2 in production?

From: Tomislav Sagrak <tsagrak_at_opus.hr>
Date: Tue, 11 Mar 2003 17:19:41 +0100
Message-ID: <b4l2b0$t91$1@brown.net4u.hr>


Howard,

let me respond step by step...

> >
> > 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).

This might be so, but actually you cannot allocate more than 1,7GB SGA unless you go in
"use_indirect_data_buffers="true"" direction. On the other side, we have 6GB and want to do something with the RAM. All users are backed up
by 2GB, so we can play with the rest of RAM.

>
> 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.

From my experience it is so. We do not need more than 2GB - but we should be performance oriented
and if the system does not swap out we are in acceptable performance. And we would like to see if
larger SGA setting from practical experience would help.

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

Memory pages. It is possible under RHAT AS.2.1 and UL 1.0 to set kernel paging to large pages (I tking about 1MB).

Regards,

Tom Received on Tue Mar 11 2003 - 10:19:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US