One Less Thing For DBAs to Worry About: Automatic Indexing

You’re a busy Oracle DBA. Your phone rings. It’s your most troublesome user, once again complaining that her query is running slow. You take a quick look at the execution plan, find a possible choice for a new index to improve its performance, and drop it in place: Problem solved. Or is it? Even an experienced DBA may not immediately realize the impact that new index will have on the performance of dozens of other queries and DML statements.

Finally, there’s a better way: Let the database decide.

This session will show how Automatic Indexing (AI) – one of the newest features of Oracle Database 19c – provides an intriguing alternative to reactive performance tuning methodologies for index creation. We’ll look at how AIC reacts to a heavy hybrid application workload and then holistically builds, tests, and implements the most appropriate secondary indexes needed to improve database performance.

What’s Your Super-Power? Mine is Machine Learning with Oracle Autonomous DB

Artificial Intelligence (AI) and Machine Learning (ML) are a lot like preserving the Earth’s environment: Almost everyone is talking about what should be done to save it, but very few people have committed to actually doing something about it.

This session demonstrates a few real-life opportunities to discover unseen patterns and relationships within sample financial and election data by leveraging the AI and ML capabilities already built into Oracle Autonomous Database.

New to APEX – please take a seat?

Okay you are new to using APEX as development tool this is great. Big and warm welcome to the best community in Oracle world.

What this sessions is about is giving an insight of how you can start, where to find information or fine tune your skills. Most important how to keep up to date with all the changes.

If you want to fast track your DEV skills by learning about APEX basics this is a perfect session for you.

We will go light but still reveal plenty of goodies you can start applying when you get back to the office.
After this session you should have a full confidence developing in APEX and venturing into world of possibilities.

Database Migration to Cloud

Database migration to the Cloud is one of the challenging tasks. People often ask, about prechecks,
To-Do List, different migration methods and their benefits; fastest way and less down time
method etc. Architects, DBAs/Developers have to do planning and pre-checks before actual
migration; this session helps to understand all aspect of DB migration strategy, planning and
different migration methods. Join me and let’s discuss various aspect of DB migration on Cloud
and its consideration. Here I will discuss about Zero Downtime Migration, Data Pump, RMAN,
Plug/Unplug, Remote Cloning etc.

Build & Deploy container databases using Oracle Container services (Kubernetes)

In this session, I will introduce oracle container services and kubernetes offering from Oracle. We will learn how to build kubernetes cluster and also deploy databases on it and also know about stateful and stateless sets to manage the databases effectively in the container world. Further more we will also see some operators in databases which helps to manage replica's & to manage backups etc of the databases in the kubernetes cluster. This session will help DBA to build and manage databases as containers using Kubernetes.

APEX Interactive Grids: Standardize for Productivity and Sanity

Interactive Grids have a myriad of customization options, some declarative, and most via JavaScript APIs. How does a developer, or an organization stay sane, organized and consistent with so many options? Standardize! Delivering clean, uniform, customized interactive grids within a single application, or across many developers and many applications is easier than you think.
This session demonstrates several options to standardize grid features within and across applications: plugins, common configuration files and CSS classes. These methods allow developers to reuse components and code as opposed to making declarative and/or code-based setting for every grid. The result is consistent, clean interactive grids, increased productivity and improved sanity. Better yet, not every developer needs to be a JavaScript expert to implement customized grid features.
The session promotes the value of having standards, and the concept of code once, then include and use everywhere. Attendees learn how to standardize grid configurations – which increases productivity and saves on sanity.

Get Ready For Brain OverLoad with Oracle Database 18c/19c/20c Features

Oracle Database 12 Release 2 is packed with enhancements for DBAs and Developers. Come listen to all the pertinent new features in Oracle 12.2/18c/19c that will change how you perform maintenance and tune the database. This session is not the traditional Oracle 12.2/18c/19c database features. Be prepared to have mind overloaded with the following focused areas:
1. Oracle 20c New Features
2. Oracle 19c New Features
1. Why do you need to go directly to Oracle Database 19c and skip Oracle Database 12.2/18c
3. Oracle 18c New Features
4. Upgrade to Oracle 12.2/18c/19c/20c
a. Upgrade considerations
b. Zero downtime upgrade options
5. Multi-Tenancy (PDB) Option
1. Elimination of support for non-container databases in Oracle 20c
2. Changes in Oracle licensing policy with Oracle19c
6. Online Improvements
7. Partitioning Option
8. Data Guard
10. General Database
11. RAC
13. In-Memory

Oracle DBAs/Developers can take immediate advantage of these new features. We will rapid fire all the new features to the audience. We will share all of the code from our presentation so that you can add them to your arsenal