degree of parallelism

[DBA_Lisa]

Evaluate these commands:

CREATE TABLE storm_track
(storm_id NUMBER(8),
current_time DATE,
max_wind_speed NUMBER(3),
current_lat NUMBER(5,2),
current_long NUMBER(5,2)
PARALLEL (DEGREE 4);

UPDATE /*parallel (storm_track, 8) */ storm_track
SET current_time = SYSDATE;

When executing the UPDATE command, what is the degree of parallelism?

[stecal]

parallel (table_name, degree of parallelism, and optionally, the number of instances)

Answer: 8

[DBA_Lisa]

Why it's 8?

What about the "DEGREE 4" when creating the table?

[sreddy]

Originally posted by DBA_Lisa
When executing the UPDATE command, what is the degree of parallelism?

Its 8 cuz, you asked for degree of parllelism for Update not for create statement.

[stecal]

Using the hint overrides other behavior.

[yoda]

"Your chances of success are directly proportional to the degree of pleasure you desire from what you do. If you are in a job you hate, face the fact squarely and get out."
-- Michael Korda

[Mukobero]

Originally posted by yoda
"Your chances of success are directly proportional to the degree of pleasure you desire from what you do. If you are in a job you hate, face the fact squarely and get out."
-- Michael Korda

Thanks Yoda.

After 5 yrs in application development I think I've had enough of it. Thats why I'll give anything to become a Sys Admin/DBA