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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
