Home » RDBMS Server » Performance Tuning » Expensive Hardware, not much faster!
Expensive Hardware, not much faster! [message #64825] Mon, 16 February 2004 04:48 Go to next message
justin
Messages: 10
Registered: November 2000
Junior Member
Hey all,

We have recently been working alot in Oracle and aquired a SunFire 240 box, 2 * 1Ghz 64-bit SPARC, and 2 GB of RAM.  We have been running sereral instances of oracle on Windows 2k machines of much lesser specs, the best being 500MHZ with 256 of ram.  My problem is that there is not much of a diffrence if ANY when it comes to the speed of the queries. 

One thing that I noticed is that only one of the cpus is pitching in (even one CPU should be blowing the W2k boxes out of the water!). If anyone has any suggestions I appreciate it! Thanks!

Justin
Re: Expensive Hardware, not much faster! [message #64829 is a reply to message #64825] Tue, 17 February 2004 07:34 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Hi,
the performance of the queries is dependent on so many factors such as its execution plan/run time statistics,optimizer settings,instance config etc, apart from the Server CPU/Ram/OS. For eg, the instance config (db_cache_size,pga_aggregate_target,shared_pool_size,db_file_multiblock_read_count etc) may need to be tweaked to make use of the increased Ram and different OS.

Oracle should make use of all the CPUs that the 'system' presents. Make sure all your CPUs are online by
>psrinfo -v
Status of processor 0 as of: 02/17/04 12:36:49
  Processor has been on-line since 10/16/03 17:42:28.
  The sparcv9 processor operates at 900 MHz,
        and has a sparcv9 floating point processor.
Status of processor 2 as of: 02/17/04 12:36:49
  Processor has been on-line since 10/16/03 17:42:27.
  The sparcv9 processor operates at 900 MHz,
        and has a sparcv9 floating point processor.

 #You can check the cpu usage with  mpstat,like this

>mpstat 5 5
CPU minf mjf xcal  intr ithr  csw icsw migr smtx  srw syscl  usr sys  wt idl
  0    3   0   28    18   14  233    2    4    0    0    82    1   4   1  94
  2    3   0   26   253  150  271    3    4    1    0    56    2   1   1  96
CPU minf mjf xcal  intr ithr  csw icsw migr smtx  srw syscl  usr sys  wt idl
  0    1   0    6     8    3 1781    5    5    0    0  2563    2   2   1  95
  2    0   0    8   282  179  521    3    6    0    0  2656    1   7   2  90
CPU minf mjf xcal  intr ithr  csw icsw migr smtx  srw syscl  usr sys  wt idl
  0    0   0   12    24    4 5162   18   15    0    0  9363   56   4   1  39
  2    0   0   23   232  127 3449   12   15    0    0  4645   38   3   1  58
...


-Thiru
Re: Expensive Hardware, not much faster! [message #64839 is a reply to message #64829] Wed, 18 February 2004 04:17 Go to previous message
justin
Messages: 10
Registered: November 2000
Junior Member
Thanks for your help Thiru!
-Justin
Previous Topic: Oracle 9i tuning self test wanted
Next Topic: How to create "stats$tab_stats" ?
Goto Forum:
  


Current Time: Wed Jan 27 14:05:41 CST 2021