Re: tkprof

Posted by ErmanArslansOracleBlog on Apr 11, 2020; 9:28am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tkprof-tp8210p8223.html

Besides, you have ROWNUM<=:p_seats in your query.. When you have such rownum clauses in your query, it is normal and expected to see the operations like SORT ORDER BY STOPKEY and COUNT STOP KEY.

See my previous updates for the recommendations about this query's performance.