Database Software

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!

parallel_min_time_threshold 12c pdb

user5692623Jul 23 2016 — edited Jul 23 2016

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

In Oracle 11g we could use parallel execution of an SQL statement by setting:

parallel_degree_policy=auto;

parallel_min_time_threshold = NUMBER

any statement taking longer in secs than NUMBER has been executed in parallel mode.

Now in Oracle 12c (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) setting the same parameters the same statement is executed in serial mode and the executions plan tells me: - automatic DOP: Computed Degree of Parallelism is 1 because of parallel threshold for the same statement against same table as in 11g with same number of rows.

do i have to set some more parallel parameters to a non default value can you please give me a hint why i don't get parallel execution in 12 c as in works in 11g

Thanks

Joachim

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2016

Added on Jul 23 2016

#database-key-features, #multitenant

1 comment

1,130 views