Weekend Learning: Creating statistics on global temporary tables

While the note "How to Create Statistics on Global Temporary Tables" on My Oracle Support from article ID 351190.1 is talking about post 9.2.0.6 Oracle databases, it also has specific information on how this is different for 12c and introduces the idea of dynamic sampling as well!  How does this apply to you?  Well, I have seen system generated global temporary tables perform badly where you really do not have any control over it, so this could possibly give you some kind of control!

Weekend Learning: 12c: Automatic Dynamic Statistics

Did you know that Oracle Database 12.1 introduces some new ways to sample dynamic statistics for query optimization?  You are probably familiar with setting this in the 11gR2 world but 12c allows us to set this at a more granular level so it can be done at a statement level and you can find all the details at "Automatic Dynamic Statistics" on My Oracle Support from note ID 2002108.1 to see what has to be enabled for this to work.

R12.2.3: Error when creating Receivables Customer

Keeping an eye on the future, the bug documented in MOS note 1635413.1 is an interesting one.  When upgrading to R12.2.3 you will need to be aware of an ORA-06508 error in the procedure sync_contact_point when trying to create a Customer in Receivables.  This is as a result of an INVALID HZ_STAGE_MAP_TRANSFORM package as this and other key packages are dynamically generated so they need to be re-generated after upgrades when there are changes made to them or their underlying packages.