Database DataWarehousing (MOSC)

MOSC Banner

Set table level degree for partitioned table

edited Mar 23, 2011 9:15PM in Database DataWarehousing (MOSC) 11 commentsAnswered ✓
  Hi all,

Usually, we set degree 2 or 4 to big tables. In this case, CBO will choose parallel select for these tables if possible.
Let assume one case that is table1 joins table2. non-partitioned Table1 has 20m rows and has degree 2. partitioned table2 has 50m rows and has no parallel degree.

When I checked the execution plan, CBO uses parallel execution and uses PX BLOCK ITERATOR on table1 as expected. But I don't know whether table2 is selected in parallel, too.

I mean I am not sure whether CBO launches slave processes against table2 or just select table2 as a whole.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center