Same Query taking different time on two different machine : Oracle - Forum - Community Groups - Progress Community

Same Query taking different time on two different machine : Oracle

 Forum

Same Query taking different time on two different machine : Oracle

  • 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

  • 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,
     
    Thanks and Regards,

    Avadhoot Kulkarni
    Lead Principal Software Engineer
    Progress Software Development Private Ltd.
  • Hi Avadhoot,

    Thank you so much for your valuable information.