what is parallel_enable in oracle

Lokesh A
Lokesh A Member Posts: 1 Green Ribbon

what is parallel_enable in oracle? What its use


  • berx
    berx Member, Orion GCS Customer Posts: 0 Green Ribbon

    If you set the PARALLEL_ENABLE clause for your Package / Function / Type, this object can be used in each parallel worker.

    Otherwise the worker need to aggregate their results and the Package / Function / Type is run in serial on th efull result set.