Hi Have you tuned the database? Do you have DBA's that monitor the database etc. What is your storage sub-system? Most database performance issues come back to the application.
Run an AWR report against it from SQL*Plus and then get it analysed at http://www.oraperf.com (it's a free service you just need to register). Run the script ${ORACLE_HOME}/rdbms/admin/awrrpt.sql during your peak loads. Sizing a database machine is much more complex than you imply. I have a lot of databases that run on machines of that size and they are capable of a lot of transactions per second. Regards. Nick Havard mailto:[EMAIL PROTECTED] P.S. Remove xyz to reply direct. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mohan Wickramasinghe Sent: 25 March 2006 07:59 To: users@tomcat.apache.org Subject: Recommended Specs for Oracle 10g db server We have 12 jboss nodes using a single oracle 10g db server with following specs... 4GB RAM Dual CPU HT 3.2GHz Intel RHEL 4 smp We see load average going to 10 on a very regular basis and 30-90 during peak hours and see the database as the bottleneck to our application performance. We also had issue with c3p0 connections from nodes having issues and upgraded it. Can someone recommend machine (HW) specs for a oracle 10g database under these conditions please. regards mohan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
