UTOUG Training Days

As we move into the future, the efficiency of Oracle in using InMemory, MachineLearning, Exadata, Documents, JSON, XML...etc. will be their main strength.  Converged Database strategy makes it simple to satisfy these demands. Join ACE Directors Nitin Vengurlekar, Rich Niemiec and Jim Czuprynski as they explore the facets of Converged Database from the perspectives of CEO, CIO, and DBA, and what it means for your career's future path.

In the brave new digitally-driven world, IT organizations can no longer focus on internal-only RDBMS databases as the central pillar of their infrastructure; data must be accessed externally as well, regardless of format or location, with utmost security. Fortunately, Oracle's Converged Database strategy makes it simple to satisfy these demands. Join ACE Directors Nitin Vengurlekar, Rich Niemiec and Jim Czuprynski as they explore the facets of Converged Database from the perspectives of CEO, CIO, and DBA, and what it means for your career's future path.

New to tuning SQL, or maybe this is your 10th year?  In this session we will give a quick intro on SQL and Oracle Optimizer and then provide some specific examples and tips for multiple SQL tuning options and methods. The goal is for this session to be approachable by all levels of skill and provide some quick take aways without going too deep into any one area.  Example code will be provided, with some demonstrations.

Learning goals include: What is SQL tuning; What tools should I use; Explain Plan Lies; Statistics + Histograms = +1; Tuning Advisor + AWR top N SQL = +1; Why do SQL Profiles fail; Create a SQL Baseline from cursor cache; How to make a SQL Patch; Playing with Optimizer; Why is my index not being used? (Index clustering)

This presentation will look at which 19c new features (automatic indexing, Quarantine, JSON data, Three user-created PDBs, Read-mostly Standby, and Autonomous Databases) that should be investigated for use. This presentation will also have a few 21c & 23c new features such as AutoML, Standby Result Cache, and InMemory enhancements including Base Level. Some 23c features include True Cache, Locking Enhancements, Schema Level Privileges, Machine Learning Enhancements & more.   Many features covered will be related to the DBA, but there are also some that focus on the developer. There will be simple examples, where possible, to show the basic functionality of the new features. in. We will also look at the autonomous database and Oracle's focus on the future of security.

Rare, intense and random short-lived performance incidents present Oracle DBAs with a real challenge. AWR report analysis will likely be of little value. The analysis answer is to use raw ASH data.

In this presentation, I begin with why ASH (active session history) is so powerful, how it works and how we use ASH to solve complex performance incidents. Using only four free scripts, I will lead you step-by-step through an incident analysis process. Plus, I will show you how to visualize a complex performance incident using an interactive network graph.

Using Oracle Machine Learning, I'll show how to produce results quickly.  The first step is Algorithmic Business Thinking to see where the biggest impact will be for the business.  Next, applying the correct algorithm and understanding different settings will be important.  Then, training the model with either data that you have or data via Big Data opportunities will be key to teach a model.  

After all of that, you can then test your model against data that you understand well already to see if this is the best model or if a different algorithm might be better.  

Lastly, testing the model on NEW data that starts to prescribe what to do in the future.  Understanding which customers or potential customers are likely to buy.  Finding anomalies quicker to address as needed.  Knowing which product is the NEXT product a customer will buy.  Finding the attributes of great customers that you have within new customers that are opportunities & you'll know what they want to buy first or second.  This is an intermediate look at the practical application of Machine Learning.