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
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 Avadhoot,
Thank you so much for your valuable information.