Hi,

Is there any tool/procedure that would capture and save SQL execution plans? I want to do this in our batch processing database where same set of jobs run every day. It would be very helpful to diagnose any long running jobs for missing indexes or altered execution plans due to parameter changes etc. I tried to see if there is any in OEM but I couldn't find any.

Thanks
Manohar