Hello
I came across this community recently and find it an excellent place. I recently have moved into oracle dev stuff and would need your expert help on the below topic.
Version : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
The alert mechanism on our production database generated alert for few of our queries saying that the execution time of these sql_id's have been greater than what has been in the past so may be a case of looking and analyzing further.
I would like to know how we can find some stats - execution plan, execution time of the previously run sql and check to see , if on that particular day/time, the sql has taken a new plan.
Thanks