Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Speed executing
There is still no way to know. You have to figure out where your bottleneck
is. Are you CPU bound? Are you IO bound? Adding a CPU may increase your
scalability (the ability to run more queries at the same time), but it may
not increase the speed of a particular query. What if you have a really
slow disk or disks; adding a CPU would do nothing to increase the speed of a
particular query. Also with multiple CPUs you can parallelism queries, but
that does not mean in all cases the query will be faster. You need to use
explain plan and tkprof to see where the bottleneck is.
You will probably get a big gain out of upgrading your software. It is no
longer supported.
Jim
"mm" <meisinger_co_at_hotmail.com> wrote in message
news:b5mgef$2rr0$1_at_as201.hinet.hr...
> For Jim Kennedy
>
>
> For example:
>
> 1. Case
> Query select * from product where name like 'PER%'
>
> machine 1GHz, NT 4.0, 256 MB RAM
> rows 500000
> time exec. 6 s
>
> 2. Case
> Query select * from product where name like 'PER%'
>
> machine 2x500 MHz, NT 4.0, 1 GB RAM
> rows 500000
> time exec. ???? (appr.)
>
> Thanks Jim
>
>
Received on Mon Mar 24 2003 - 08:51:13 CST