alter session set sort_area_size

create index nologging, nosort, parallel