How to configure parallelism in Oracle 10g?
I have created a table with parallelism degree 2, h开发者_如何学Pythonowever it doesn't seem like it's actually working.
Post your SQL. You can add a parallel hint, something like:
select /*+ parallel(d, 2) */
from someTable d
where blah;
Note that you need to use any aliases you used in the query (d in this case). Typically the driving table of the query is used here. Use explain plan to see if it changes after adding this hint.
its appears the i should get a full licensed version of oralcle
精彩评论