Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is using Parallel Hint /*+PARALLEL */ good or bad?

601989Jul 20 2009 — edited Jul 21 2009
Hi,

I am facing problem in using /*+ PARALLEL */ hint in SQL Query its taken long time to execute.

Is using PARALLEL Hint degrades performance?

The Table FCT_TABLE is having PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT ) clause.

We are using parallel hint as SELECT /*+ PARALLEL(FCT_TABLE 2)

Any help will be needful for me.

Thanks and Regards
This post has been answered by Billy Verreynne on Jul 20 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2009
Added on Jul 20 2009
#general-database-discussions
11 comments
3,960 views