Fixed Table x$ktfbue has not statistics

While playing around 12.1.0.2 db, I ran my usual script to check tablespace usage details and it took ~59 secs (Elapsed: 00:00:59.02), which was high. Ran the sql using "gather_plan_statistics" hint and below lines in the execution plan were of interest - | 34 | HASH GROUP BY | | 1 | 6 | 3 …

Advertisement