Hi Greetings,
When users start complaining that a specific SQL command is working at slower pace, what are the sequence of steps to be taken to locate and rectify the defect??
Printable View
Hi Greetings,
When users start complaining that a specific SQL command is working at slower pace, what are the sequence of steps to be taken to locate and rectify the defect??
thanks for the feedback
What is slow slow? For all you know their pcs are slow!
Run a profiler tool
pick that query
run stats pack and see/identify the degeneration of the sql query over time
take the query and whack it to run in some similar test/dev environment
try to tune the query and see if you can
..This is no where close to any sequence. Pick up the perf manual from oracle.com and read it too :)
Thanks Mr Tarry.
When somebody is saying sql query is slow. u can follow these steps.
Take the trace of the sql and verify the xplain plan.
Queries can be tuned by checking if there is better path to follow, like is it picking the good index or no index at all, some times it can be tuned by rewriting the query.