8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Automatic Column Group Detection in Oracle Database 12c Release 1 (12.1)

ManPau said...

Hello Tim,
is there a way to disable the automtic creation of column group statistics?

Tim... said...


There is a patch that back-ports the new control parameters from 12.2 to 12.1, which allows you to prevent them. Alternatively, set the equivalent underscore parameters. See:




@sqlchaser said...

Great write up Tim (as always). Kind of shocking to me that this solution changes your metadata/data definition to make things faster. I've seen this cause myriad issues for schema upgrades. I suppose it is arguable that the relationship should have been defined for Oracle ahead of time...

Sumeet said...

Thanks for sharing this article with all .. Well written and presented indeed for the benefit of the IT world..

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.