8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 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?
Thanks

Tim... said...

Hi.

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:

https://blogs.oracle.com/UPGRADE/entry/enabling_adaptive_features_of_oracle

Cheers

Tim...

@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...

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.