Recently, I had a problem with accessing Active Session History being not fast enough on Oracle Database 11.2 and 12.1. Looking at the explain plan, wow, no doubt why: Accessing two fixed tables with TABLE ACCESS FULL and joining them with NESTED LOOP. This couldn’t have been “works as designed”, it would render gv$active_session_history nearly […]
About
Martin Klier
Troubleshooter, Database integration, performance and HA specialist with 15+ years of experience. Oracle ACE Director.
co-founder of performing databases.
Your data efficiency experts.
