Hi Team,
Our system was written by plenty a lot of procedures, and one of them did not performance well.
This procedure includes tens of SQL statments, suppose that there's only 1 or 2 SQL statements in the procedure caused this problem. I mean, the rotten apple could injure its neighbours, how could I find out which SQL statement(s) is the rotten one.

And please notice that the procedure was executed and finished DAYS AGO, say, 3 days ago. I know I could make a test with 10046 events and find out the problem SQLs of my procedure, but it's not what I said 'DAYS AGO'. In other words, I want to find out which SQL was the trouble-maker for this procedure at that time, rather than in the future.
BTW, I could not find the SQL statements out from AWR, becuase the SQL statements did not elapse long enough to become the TOP SQL.

Any advice is appreciated.