0

I want to do do following set of operation.

execute immediate "alter session enable parallel query";

execute immediate "alter session enable parallel ddl";

execute immediate "alter session set parallel_force_local=false";

Is there any better way of doing in oracle 11g/12c?

Thanks in advance.

3
  • What do you mean with "any better way"? What are you trying to achieve? parallel_force_local is only meaningful if you are actually running this in a RAC environment.
    – user1822
    Sep 24, 2015 at 13:25
  • I am trying to enable parallel for ddl. If any oracle utility is there then i need not write this inside any procedure to use it. So if its the optimised way then please share. Sep 24, 2015 at 13:28
  • But parallel query and ddl are enabled by default (docs.oracle.com/cd/B28359_01/server.111/b28310/manproc006.htm) .
    – a1ex07
    Sep 24, 2015 at 15:04

1 Answer 1

1

You should alter your tables and indexes and specify the amount of parallel that you want.

How Parallel Execution Works

ALTER TABLES sales PARALLEL 8;
ALTER TABLE customers PARALLEL 4;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.