In-Memory Parallel Execution (11.2)

  • From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Apr 2015 08:27:21 +0000

In-Memory Parallel Execution in 11.2

Questions :
1. Does In-Memory Parallel Execution work in a non-RAC environment ?
2. 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

Phone : +65-6596 3127
Email : Hemant-K.Chitale@xxxxxx
Fonenet : 652-63127





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

Other related posts: