Hello Guys ,
I recently had one issue , where AWR showed most of time over 90% time was taken by the event "ENQ TM" and since this can caused by un-indexed primary key, but since we this has happened in past , we are not in a position of finding out the cause of it. I also tried to find out what tables , which got contended and saw there is no index problem. Now , I just like to use "dba_hist_active_sess_history to find out , what were the session being contended at that point of time and which caused them for wait and also what object.
I would appreciate , if you could give us the query to fetch out details and can pin-point the issue.
Thanks in advance
hare krishna