AWR report analysis -- session blocked ?
User01Feb 3 2011 — edited Feb 3 2011Yesterday application folks kicked a job, it finished 3 hours more than usual time. I was told to investigate 6am -8:30 am yesterday i found the sql which took 2.5 hours with 1 execution, the same sql took 2.87 sec per execution which executed during that 3 hours from the AWR report. I guess the SQL is fine, i want to look at the blocking sessions during the above time. May be that SQL which took 2.5 hours is blocked by another session. Please let me know how to see which session blocked the other session during yesterday between 6am-8:30 am. Other top SQLs executed in very less time. What other areas i have to look in the AWR report to know why the app job is hanging. Please let me know. Thanks