Re: Large Memory on other OS's

From: zhu chao <chao_ping_at_vip.163.com>
Date: Fri, 20 Feb 2004 23:52:56 +0800
Message-ID: <007201c3f7c9$9cef4700$562d5fd3@chaos>

hi, lisa:

We have linux 2.1/9204 running datawarehouse supporting tens of dw users and linux2.1/rac 920 support 400 connections.

We tried large sga on linux/dw with two method: 1. relink oracle with lower sga start address. We got 2.75GB sga and we did see performance gains. However, for some reason, the ETL process failed for ORA-4030 error and we reversed back to normal SGA. 2. Use shmfs and indirect data buffer. we increased sga to about 4gb and in our benchmark, we did not see any performance gains. We reverted back to 1.75GB sga.

Our server has 8GB memory.

New redhat 3 by nature support 2.75GB sga. You can try it. I have not tried it yet.

Regards
Zhu Chao.

Original Message ----- From: "Koivu, Lisa" <Lisa.Koivu_at_Cendant-TRG.com> To: <oracle-l_at_freelists.org> Sent: Friday, February 20, 2004 11:35 PM Subject: Large Memory on other OS's

> Hello everyone,=20
>
> Well, now I've got support working with me to try to address this
> Windows memory issue. But my question to all of you is, has anyone run
> a large sga (over 2GB) on Linux without any serious problems and seen a
> performance increase? My specific case is to be able to run several
> hundred very busy connections concurrently in a data warehouse load. =20
>
> Any horror stories or suggestions are appreciated. Thank you
>
> Lisa Koivu
> Orlando, FL, USA
>
>
> "The sender believes that this E-Mail and any attachments were free of =
> any virus, worm, Trojan horse, and/or malicious code when sent. This =
> message and its attachments could have been infected during =
> transmission. By reading the message and opening any attachments, the =
> recipient accepts full responsibility for taking proactive and remedial =
> action about viruses and other defects. The sender's business entity is =
> not liable for any loss or damage arising in any way from this message =
> or its attachments."
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Feb 20 2004 - 09:52:56 CST