Originally posted by abhaysk
Well Well Plan will not tell you where your session is waiting on.. but you can suerly comprehend where the problem is ( in that tree structure ) provided you have analyzed your query throughly.. By doing so you can be sure that index used in that plan may worse or better things.. In this context i meant plan is enough to tell you where your problem lies.. not necessary to wait for your sessions to complete and then do a analysis..

Abhay.
Great. That's the way you do it. That's not the way I do it.