ASA Database Administration Guide
  Database Options
    Alphabetical list of options

MAX_RECURSIVE_ITERATIONS [database]

Function 

Limits the maximum number of iterations a recursive common table expression can make.

Allowed values 

Integer, from 1 to [ UNDER CONSTRUCTION ]

Scope 

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately. DBA permissions are required to set this option for the PUBLIC group.

Default 

100

See also 

Common Table Expressions

Description 

Computation of a recursive common table expressions aborts and an error is generated if they fail to terminate within the specified number of iterations. Recursive subqueries often increase geometrically in the amount of resources required for each additional iteration. Set this option so as to limit the amount of time and resources that will be consumed before infinite recursion is detected, yet permit your recursive common table expressions to work as intended.