| Expensive Hardware, not much faster! [message #64825] |
Mon, 16 February 2004 04:48  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
