Geek out with Martin Klier on AI and CBO

Martin Klier, Oracle ACE Director - will join us to share his wealth of knowledge about the Oracle database.

Join us for two great presentations.

1. Simple AI Use Cases for Oracle Database Professionals

This session highlights how to use Oracle’s native AI capabilities to forecast future workload behaviors in your database setups, providing a predictive advantage in performance management.

Additionally, we explore the role of Large Language Models (LLMs) in boosting Oracle Database Administrators' productivity. LLMs expedite the process of navigating extensive documentation and can auto-generate SQL statements for established schemas, requiring minimal SQL knowledge.

These AI use cases streamline operations and enhance decision-making, adding substantial value to database management.

2. Roam with the Beast: Let the Oracle Cost-Based Optimizer run!
In short:
Unleash the Oracle Database's potential! Free the Cost-Based Optimizer for optimal performance. Master strategic indexes, harness statistics, and turn 'bad' operations into triumphs. Rule less, optimize more – support, don't control, the CBO!

In more detail:
In this presentation, we delve into the heart of Oracle Database's Cost-Based Optimizer (CBO), and explore why allowing it to roam freely leads to optimal long-term query performance.

Discover why the key to unlocking the CBO's potential lies not in restraining it with hints or profiles but in empowering it with a wealth of knowledge. We'll explore the art of crafting strategic indexes, harnessing the power of statistics, and other ingenious meta-information techniques to guide the CBO's decision-making process. Learn how to keep the optimizer dynamic and responsive, adapting to evolving data landscapes without sacrificing performance.

Buckle up as we deal with 10 operations having a reputation of being "bad" or "slow" – from Hash Joins to Table Access Full – that might sound like performance pitfalls. But, in truth, they can be powerful allies when orchestrated under the right circumstances.

Join us on a journey where seemingly bad choices transform into performance triumphs, demonstrating that in the realm of Oracle optimization, knowledge is power, and the true mastery lies in understanding and supporting the CBO rather than attempting to control its every move. Rule less, optimize more!

In summary:
Most people think tricking the Oracle Optimizer is the key knowledge to make it stable and successful. I want to show how we can use the CBO to the best advantage, and use its dynamics (that we pay a lot of money for) to the benefit of our business cases.