Oracle 11g rel 2 :- How to know that same sql’s got executed multiple times
I am having dead lock in one of our Oracle 11g rel 2 Instance.
It looks like the same jobs being kicked off simultaneously and it is the cause of the dead lock.
How can I check yesterday’s sql’s from history or AWR that the same sql’s executed many times?
I also need how many times a particular sql got executed. Is there a way to get it ? Experts !