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!

DOP at object level or not?

LauryMar 14 2017 — edited Mar 14 2017

Hi,

I am working with Oracle RDBMS 11g and 12c, with Exadata and not Exadata.

I understand that, when using the DOP, the better approach is to be deliberate about what you parallelize by specifying the DOP

(Degree of Parallelism) on the object itself, table or index, and/or at the statement level through hints.

Even if using hints, specifying the DOP for the objects in the statement - not the statement as a whole.

Is that a correct approach?

Furhermore, what does mean to specify the DOP on the object itself, when the object is involved in DML statement?

Thanks by advance for any tip.

Kind Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2017
Added on Mar 14 2017
#general-database-discussions
6 comments
496 views