Hyperthreading is a plus in 10g (my experience). One of my clients has seen a 70-80% improvement in their batch processing by using it with appropriate parallelism etc.
Setting the SGA to 2.5GB on a 4GB machine is well over the top. By the time you add in other memory components you'll be killing the OS. In 10g statspack was replaced with AWR. Regards. Nick Havard mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alex Turner Sent: 25 March 2006 16:19 To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Recommended Specs for Oracle 10g db server Turn off hyperthreading for starters. Oracle requires a minimum of 5 seperate logical disks to function at optimal in a production environment. You will need a good raid controller, and a good disk array to get any kind of decent insert speed. You will need to do some serious oracle tuning, there are some good books available out there for this. But at the very least you need to set the SGA to about 2.5 Gig, and tune the other memory usage things. Profile your database and find out which queries are running slow and why. Look at statspack (at least that's what we use in Oracle 9i) which can generate some good reports. Alex On 3/25/06, Mohan Wickramasinghe <[EMAIL PROTECTED]> wrote: > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
