Thank you for the mind blowing scripts. When i run dashtop in one of our 19c database it runs for long time so i cancelled it and checked the Execution and found that WRH$_active_session_history (table access by index local row id) spends user io 90% of time and that table is in stale stats including index though 1week before we gathered stats after the upgrade to 19c. Please suggest to fix it
Hi Tanel,
Thank you for the mind blowing scripts. When i run dashtop in one of our 19c database it runs for long time so i cancelled it and checked the Execution and found that WRH$_active_session_history (table access by index local row id) spends user io 90% of time and that table is in stale stats including index though 1week before we gathered stats after the upgrade to 19c. Please suggest to fix it