RE: Oracle and Apache Web server bottleneck

Yes, that is autoraid. The db is not all that big yet, so the array stats show that db stuff is staying in RAID +1.

Glance is showing that the httpd processes are choking the CPUs, forcing other jobs to go to "sleep".

At 2/14/02, you wrote:
>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
>--------------------------------------------------------------------
>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: 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).