Sorts (Oracle)

This section shows the total number of sort operations along with the number of sort operations performed in memory or on disk.

Sort operations take place if you use ORDER BY , GROUP BY or SORT MERGE JOIN SQL statements. Sorting is also done during index creation. Sorting can be a very expensive process and should be avoided whenever possible. It is generally better for performance if sorting is done in memory than on disk.