search

tanelpoder / tpt-oracle

Tanel Poder's Performance & Troubleshooting Tools for Oracle Databases
https://tanelpoder.com
Other
657 stars 312 forks source link

asqlmon.sql not finding some plans in v$sql_plan #27

Open PMichie opened 3 years ago

PMichie commented 3 years ago

v$active_session_history and v$sql_plan are not aged out in a coordinated way. Multiple times I had to join to dba_hist_sql_plan.