title: Building an sql execution plan history
body: <p>Using Oracle 11.2.</p>
  
  <p>Is there a standard approach to build an execution plan history like how an execution plan may change ofer time? I thought about tracking changes in dba_hist_sql_plan (plans are kept there for 10 days in our env.). But are all plans stored in dba_hist_sql_plan or does that depent on the awr config? Or is there a standard approach for doing that (may without dba_hist_sql_plan).
  I'm rather new to Oracle so every idea is welcomed.</p>