Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: simple SELECT scales in a multi-processor env?
By default it will use 1 processor for this individual sql query. You can
set it up in the ini file to automatically use multiple processors. Not
every query do you want to try to multiprocess- it would slow down a lot of
queries.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Giovanni Azua" <bravegag_at_hotmail.com> wrote in message news:b309ai$1fnhtn$1_at_ID-114658.news.dfncis.de...Received on Wed Feb 19 2003 - 10:21:06 CST
> Hello all,
>
> Imagine you make a costly SELECT statement like this
> over more than 4 million transactions:
>
> select sum(to_number(amount)) over
> (
> partition by transaction_date
> order by rowid
> range between interval '10' day preceding and interval '10'
day
> following
> ) as highly_smoothed_amount
> from transaction
>
> Oracle implementation of this query is able to transparently spam
> several threads to execute it and hence use as many processors as
> possible or this is just executed in the session/connection "primary
> thread" and the scaling is given by several sessions/connections
> issuing statements like that...?
>
> My point is: is it paralelism achieved transparently or is something
> we have to configure and explicitly make happen e.g. creating transaction
> table as a partitioned table.
>
> Thanks in advance,
> Best Regards,
> Giovanni
>
>