RE: Oracle and Apache Web server bottleneck

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Thu, 14 Feb 2002 08:16:16 -0800
Message-ID: <F001.0040FC60.20020214074829@fatcity.com>

Hm...a 12x36 disk array. Is that an AutoRAID?

I had one of those hooked up to a 6-way K570 running PeopleSoft over Oracle 8.0.5. Yuck. P**s-poor performance all the way around. Especially when the disks started to fill up. The problem was that the array got so busy internally swapping stuff from the RAID 5 area to the RAID 0 area that it could not service the I/O requests from the database. We went to a fiber array and most of the problems disappeared.

If you are using an AutoRAID, check your internal statistics to see if you're swapping like mad in there.

HTH,
Mike

-----Original Message-----
Sent: Wednesday, February 13, 2002 6:38 PM To: Multiple recipients of list ORACLE-L

We have a single HP 9000 with 2-360Mhz CPU, 4G ram and a 12 x 36G disk array.

We were running Oracle Apps 11.0.3 on Oracle 8.0.5, but recently upgraded to Oracle 8.1.7.2 so that we could provide web access to purchasing (iProcurement) and later to HR (employee self service).

Oh, but do we have a problem.

In testing, with a single instance, we found that the Apache web server was able to service 1-10 users very well, 10 - 14 was poor with 1-3 minute response time, and above 16, the web browser sessions timed out after 10 minutes. The CPUs peg at 100% around the 12 user and stay there. With 150 Purchashing users, we have delayed go-live until we get this Apache bottleneck solved.

The boss is talking to HP about getting a second server. Server A will have the DB and server B will have apps, Oracle web server and Apache web servers.

I'm a thinking that we need to get that Apache web server onto a different box of some kind.

Any ideas on dealing with the Apache server problem?

Thx.

--

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

Author: Don
INET: dondealy_at_teleport.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

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

Author: Vergara, Michael (TEM)
INET: mvergara_at_guidant.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------