开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜