In-Memory Parallel Execution (11.2)

In-Memory Parallel Execution in 11.2

Questions :

1.      Does In-Memory Parallel Execution work in a non-RAC environment ?
2.      In RAC does it HAVE to have PARALLEL_DEGREE_POLICY='AUTO' or does it work with MANUAL ?
3.      In  RAC does it still work if PARALLEL_FORCE_LOCAL is TRUE ?
4.      How do you determine if In-Memory Parallel Execution has been used ?
5.      Is there another switch (other than PARALLEL_DEGREE_POLICY) to disable it ?


For some tests I need to
a.      Determine if In-Memory Parallel Execution has been used
b.      Selectively disable it (or enable it :>)

Hemant K Chitale

This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html

--
http://www.freelists.org/webpage/oracle-l