Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: simple SELECT scales in a multi-processor env?

Re: simple SELECT scales in a multi-processor env?

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Wed, 19 Feb 2003 16:21:06 GMT
Message-ID: <S9O4a.180317$vm2.133927@rwcrnsc54>


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...

> 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
>
>
Received on Wed Feb 19 2003 - 10:21:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US