Order by Slowing down

[tamilselvan]

For your query tuning sort_area_size parameters and temp tablespace initial and next extents' sizes will boost perf.