January 7, 2021 archive

GTT Table Stats and SYS.WRI$_OPTSTAT_TAB_HISTORY

Back in 2015, I upgraded our Oracle 11.2.0.4 databases to 12.1.0.2 and experienced some performance issues related to our use of GTTs. I blogged about those issues here. The crux of the issue I was trying to solve was that a behavior change in 12c lead to Oracle saving stats that the GTT has zero …

Continue reading