Message Oracle ORA-30009 - Not enough memory for CONNECT BY operation

ERRORNot enough memory for CONNECT BY operation
CAUSEThe memory size was not sufficient to process all the levels of the hierarchy specified by the CONNECT BY clause.
ACTIONIn WORKAREA_SIZE_POLICY=AUTO mode, set PGA_AGGREGATE_TARGET to a reasonably larger value. Or, in WORKAREA_SIZE_POLICY=MANUAL mode, set SORT_AREA_SIZE to a reasonably larger value.