Re: SQL PROFILE IN ORACLE

Posted by ErmanArslansOracleBlog on Apr 03, 2017; 6:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/SQL-PROFILE-IN-ORACLE-tp2497p2511.html

The Total cost and IO cost of the new execution plan is lower than the original/current one.
I don't see the whole exeuction plan though ..The screenshot you provided is only a portion of it, but it can be seen that your query has a complex execution plan. I don't see the route cause of these big costs, it must be in other steps down there.. Anyways it seems acceptable. (low IO, low cost) At least give the suggestion a try.

On the other hand, the cost is really huge. Check with your developer to tune the sql statement if it can be tuned in somehow.. (less full tablescans, less loops etc...)