Under the same assumption: install Mumbai (free) and play away with all the good info in Statspack. Or in AWR/ASH, depending on which release level you're on. -- Cheers Nuno Souto dbvision@xxxxxxxxxxxx On 7/10/2013 11:54 PM, Maaz Anjum wrote: > Assuming you have it set up, you could use Statspack as well. > > On Mon, Oct 7, 2013 at 8:25 AM, Storey, Robert (DCSO) < > RStorey@xxxxxxxxxxxxxxxxxx> wrote: > >> What's your preferred tool for after-the-fact diagnosis of the issue? >> This is on a 9i system but I don't have it hooked into grid or cloud >> control. >> >> -- //www.freelists.org/webpage/oracle-l