-
Show the output of a Query Plan to User
There is a query which takes more time in production, the user has reported the issue, and we have fine tuned the same and it is working fine now in testing environment, we need to explain the user the root cause and also we need to show the user the query is running fine in production. How to show the query performance upgrade to the user in production environment? For the same issue, we have fine...
-
Passing a Function name in Parameter
Can we pass a function name as a parameter value?? will it have any effect in performance degradation when used in a Large online transaction process?
-
Performance Tuning
My query was running fine till last month. the query will run for each month end. suddenly it is taking more than 20 minutes for running. the data is increased by 1 million. the index are all working fine . There is no cpu utilization time and also no memory blocks. What may be the reason?The increase in data has happened previous months also
-
Rectify Deadlock
If a deadlock has occured and if you have given with the dump, how will you identify that where the deadlock has occured, how the deadlock occured and how to rectify the same.