0

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 (DBA) of the server machine. Please provide me the inputs database tuning if there are any.

Thanks in Advance.

S.G
  • 5
  • 1
  • 7
  • Is the amount of data comparable between your local machine and the server machine, please poste both explain plan in text format along with your query. – Cyrille MODIANO Sep 28 '17 at 07:50
  • The posted explain plan shows a full table s an of 115000 rows, taking 3 seconds. So I guess this is your Development run. Please post the production plan. Almost the same is not identical, and the difference may be crucial to understanding your question. – APC Sep 28 '17 at 08:24
  • @APC I have added snapshots for both explain plan – S.G Sep 28 '17 at 09:45

0 Answers0