OraFAQ Forum: Performance Tuning » parallel hint/execution

Home » RDBMS Server » Performance Tuning » parallel hint/execution

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

parallel hint/execution [message #162535]

Fri, 10 March 2006 21:03

a_developer
Messages: 194
Registered: January 2006

Senior Member

If I have:

create table Mytable
parallel (degree 4)
as 
select /*+ parallel (tab, 4) */
  tab.start_dt,
  tab.end_dt
FROM 
  invoice tab;

How many processors does this use? How does this actually execute??

Report message to a moderator

Re: parallel hint/execution [message #162558 is a reply to message #162535]

Sat, 11 March 2006 04:26

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

a_developer wrote on Sat, 11 March 2006 08:33

How many processors does this use? How does this actually execute??

Do you really mean processors or processes??

Read the following thread....

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c20paral.htm#365

Report message to a moderator

Re: parallel hint/execution [message #162645 is a reply to message #162558]

Sun, 12 March 2006 16:16

a_developer
Messages: 194
Registered: January 2006

Senior Member

I guess, now, I mean 'processes'...
I've gone through the link. But there was nothing there that somehow discusses a kind of code wherein there are hints both in CREATE and SELECT, does it call for 8 processes or 4?

create table Mytable
parallel (degree 4)
as 
select /*+ parallel (tab, 4) */
  tab.start_dt,
  tab.end_dt
FROM 
  invoice tab;

or how about:

INSERT /*+ parallel (a, 3) */
  INTO tabA a
SELECT /*+ parallel (b, 3) */
       *
  FROM tabB b;

Report message to a moderator

Previous Topic:	Oracle 8 rebuild index
Next Topic:	Partitioned to Composite Partitioned

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:15:43 CDT 2024