Re: script taking time

Posted by ErmanArslansOracleBlog on Jun 05, 2018; 12:13pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/script-taking-time-tp6155p6162.html

Looking at the dbsessionWait.PNG , I can say that, that session is waiting for data from the db link.
This means, db link is involved.. This means network is involved..

Looking at the sarPROD.png, you have significant IO wait and also CPU wait. But IO wait is obvious..

You don't need to think about whether a query will force a full table scan or not.. You just need to check the explain plan of the query and it will tell you..