DEGREE requests

The DEGREE general request element can be used to override the setting of the DEGREE bind parameter, the value of the dft_degree database configuration parameter, or the result of a previous SET CURRENT DEGREE statement.

The DEGREE general request element is only considered if the instance is configured for intrapartition parallelism; otherwise, a warning is returned. It is defined by the complex type degreeType.

XML Schema

   <xs:simpleType name="intStringType">
            <xs:restriction base="xs:integer">
               <xs:minInclusive value="1"></xs:minInclusive>
               <xs:maxInclusive value="32767"></xs:maxInclusive>
            <xs:restriction base="xs:string">
               <xs:enumeration value="ANY"/>
               <xs:enumeration value="-1"/>

   <xs:complexType name="degreeType">
      <xs:attribute name="VALUE"


The DEGREE general request element has a required VALUE attribute that specifies the setting of the DEGREE option. The attribute can take an integer value from 1 to 32 767 or the string value -1 or ANY. The value -1 (or ANY) specifies that the degree of parallelism is to be determined by the data server. A value of 1 specifies that the query should not use intrapartition parallelism.