This content has been marked as final. Show 4 replies
select col1,col2,col3 from table1 order by col1,col3
Though trace always provides best information
I would Check using
check v$pgastat OR AWR reports for multi passs execs happening. May need to increase PGA size
check if sort_area_size changed.
If you had a fat index (col1,col3,col2), you might had avoided sort all the way (fast full index) which might not be available now.