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
Server Explain plan
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.
Thanks and Regards,
Lead Principal Software Engineer
Progress Software Development Private Ltd.
Thank you so much for your valuable information.