Same Query taking different time on two different machine :

Posted by leviya on 03-Oct-2017 04:17

I have Oracle database schema on my local machine and same schema is present on server machine as well, but time taken to execute same Query by: Server Machine : 17.45 Seconds Local Machine : 3.05 Seconds P.S : Server configuration is far much better than local machine's Configuration

I have generated the explain plan from both schema's both giving almost same execution plan Explain plan

local Explain plan enter image description here

Server Explain plan enter image description here

Don't know if the issue is related to Disk,CPU,I/O management (Oracle DBA) of the server machine. Please provide me the inputs database tuning if there are any.

Thank You

All Replies

Posted by Avadhoot Kulkarni on 03-Oct-2017 07:18

Hi Leviya,
 
I guess this is happening because of the network latency. When you are testing with local Oracle Schema is your client and Server on same machine?
If that is the case; there is almost no time spend on the network data transfer. In case of server schema; I guess the client machine and server are different machines and hence it would take longer for the client to send the query to server and get the result back.
 
I hope this explains.
 
Regards,
 

Posted by leviya on 05-Oct-2017 00:17

Hi Avadhoot,

Thank you so much for your valuable information.

This thread is closed