Afternoon All-
Dont forget the direct correlation between hyperthreading (vis-a-vis
cpu-count) affecting CPU cost (verified in plan table) for parallel tables
Tom kyte addressed this issue here
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:36798353051561
Good Stuff,
Martin--
----- Original Message -----
From: "Alex Turner" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <users@tomcat.apache.org>; <[EMAIL PROTECTED]>
Sent: Saturday, March 25, 2006 11:18 AM
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]
