A few weeks back I was copied on an email conversation about a important change with Global Temporary Tables (GTT) in Oracle Database 12c.
Something you need to be aware of when using GTTs in Oracle Database 18.104.22.168:
Prior to this release GTTs shared statistics between sessions. Statistics were SHARED between different sessions. Now since Oracle Database 12c this is different by default – statistics on GTTs are visible to the SESSION only.
This can be changed and altered of course. And there are pros and cons. But as I’m not an optimizer expert I’m glad that …Continue reading...