ORA-30009: Not enough memory for string

admin

ORA-30009: Not enough memory for string operation
Cause: The memory size wasnot sufficient to process all the levels of the
hierarchy specified by the query.
Action: InWORKAREA_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.