ODTUG, Kscope22

About The Event

ODTUG Kscope is the premier educational conference for Oracle technology users, attracting Oracle experts from all over the globe. No other conference in the Oracle world features this kind of development-specific training and content, including lessons learned by other companies facing similar challenges and hundreds of opportunities to discover money-saving techniques. ODTUG Kscope offers a dynamic experience and a unique learning environment for attendees, with over 200 technical sessions, hands-on training, all-day symposiums, and networking with Oracle experts.

11:45 - 12:45 CT

Texas 4

The Future World Enters the Twilight Zone

This presentation will look at the current state of technology and how Machine Learning, AI, Mixed Reality, Robotics, Implants, and Quantum Computers will shape the future. For this, there is standing room only in the twilight zone.

REGISTER NOW!

EMERGING TECH by Rich NiemiecViscosity

13:00 - 14:00 CT

Dallas 6

Unfold Your Database's Swiss Army Knife: Autonomous Health Framework

You may know Autonomous Health Framework (AKA Trace File Analyzer) as that thing you have to run before Oracle will assign on your new service requests. Not ringing a bell? What if I said it's the tool that alerts about being over 180 days old every time you run it? Yup, that's it! Few may appreciate that AHF is more than a stepping stone to getting SRs assigned – it's the fast track for identifying and solving them! Fewer still realize that helping Oracle Support find and fix problems is a fraction of what it does (and an unimpressive piece at that). Simply put, using AHF only to generate diagnostics for service requests is like carrying a Swiss Army Knife just for the toothpick!

In this session I'll teach you how to use AHF like a pro – even ways it can help you escape disaster with McGyver-like ease. You'll learn:

Safety: Avoid injury with advice on setup and configuration, where to get help, and tips for avoiding frustration and problems.
Technique: Learn how to use each tool to manage, monitor, and maintain everything from individual databases to ASM, RAC, engineered systems, and beyond.
Maintenance and Sharpening: Take care of your tools and they'll take care of you. Install, patch, and customize AHF environments.

REGISTER NOW!

DATABASE by Sean ScottViscosity

16:15 - 17:15 CT

San Antonio 1

Using Machine Learning to Drive Business

This presentation will focus on what specific Algorithms that are inside Oracle can be applied to Business Problems. Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man's Mind to further replace man's most basic tasks. This session will focus on ML 101 and building the future ahead. Some business issues are seasonal, some relate to customers with certain attributes, some relate to customers we don't know exist, but all can be solved by using the correct algorithm to quickly prescribe a better corporate future.

REGISTER NOW!

EMERGING TECH by Rich NiemiecViscosity

10:15 - 11:15 CT

Texas C

Digital Twin for Finance: Automate 80% of Accounting with Low Code, AI, ML, RPA, and Fintech

This session is a crash course in modern finance and how to apply emerging technologies to your company’s accounting function. You’ll learn how we used intelligent character recognition to turn thousands of documents into data in seconds with accuracy rivaling human data entry.

You’ll see machine learning in action as we classify documents and route them for human-in-the-loop learning. Every document that goes into or out of accounting, from spreadsheets to checks, bank statements, ap/ar invoices, purchase orders is classified and reconciled in real time enabling a continuous close for financing.

At the center of this solution is Oracle Application Express with its REST web service engine to integrate services across banks, treasury management, AP, AR, Assets, and GL. REST functions allow robotic process automation of Oracle EPM and Fusion ERP low level tasks enabling a more SOX-able solution by eliminating manual process.

You’ll have a chance to put hands on the system as you snap a picture of a handwritten invoice and watch it fully account code in seconds from a mobile device.

REGISTER NOW!

EMERGING TECH by Jerry WardViscosity

14:30 - 15:30 CT

Texas 1

Digital Data Capture with APEX Mobile Apps

APEX is a fantastic tool for building mobile-friendly web applications. The templates look amazing, they adapt to different screen sizes. Overall it’s very easy to develop an application that looks and behaves properly on both desktop and mobile. However, there are limits to what you can do with JavaScript, due to security and privacy reasons. Overcome the limits of JavaScript by wrapping your APEX Application in a React Native frame to get access to Google’s ML Kit. It will allow you to use the camera on most mobile devices to scan and parse barcodes, Data Matrix and even do text recognition. Use this information embedded on 2D and 3D data structures to easily locate inventory, tie it to geolocations, attach photographs, and query all types of data.

REGISTER NOW!

APEX by Emanuel Cifuentes and Kevin HerrarteViscosity

16:00 - 17:00 CT

San Antonio 1

Case Study: Anomalous DB Activity Detection Using a Multi-cluster ML Model

Database activity is indeed a strange realm. There are temporal relationships, multiple intertwining trends, and bizarre business workloads. Trying to detect anomalous activity is like trying find an unusual grain of sand. They all look unusual!
Machine learning cluster models have the ability to quickly detect anomalous activity. This particular presentation is focused on the building, deployment, and operations of a multiple k-means cluster unsupervised learning model to detect anomalous Oracle DB activity for a company that manages large customer Oracle-based systems.
The underlying algorithms and how we apply them is fascinating. And, applying them to our work makes them come to life in very real and relevant ways.
All you need to do what I demonstrate, is a Gmail account! In fact, all the processing, software, and network activity is done in a cloud. OraPub will provide you with a live and active system that resides in an Oracle Cloud Autonomous database.
Join me on a fascinating journey as we explore how to use multiple cluster ML models to detect anomalous DB activity.

REGISTER NOW!

EMERGING TECH by Craig ShallahamerViscosity

13:00 - 14:15 CT

Texas 4

Lunch and Learn - Core Database Panel

If you’ve never participated in the ODTUG Kscope Lunch and Learn, here’s what you can expect. Duties for each role can be found below.

Moderators

Arrive early and be ready to start promptly at 1:00 p.m. Make sure the panel does not begin before 1:00 p.m.
Introduce yourself and your fellow panelists.
Thank the Oracle Developer Community for sponsoring the Lunch and Learn program.
Provide a quick introduction of the Oracle Developer Community ACE program and its various levels.
Start the panel off with a first question to get everyone involved.
Keep the panel moving during slow spots.
Try to avoid having a single panelist dominate the discussion.

Panelists:

Interact with other panelists and audience members, sharing knowledge and experiences.
Enjoy yourself!

All:

Pick up your lunch between 12:45 and 1:00 p.m. in the meal room, Longhorn F and then report to Texas 4 as the panel will start at 1:00 p.m. and finish at 2:15 p.m.
We will make sure to have someone staffing a hand-held microphone during your session, so the audience questions can be heard by everyone.

Thank you in advance for responding as soon as possible and for your willingness to help make the ODTUG Kscope22 Lunch and Learn better than ever!

REGISTER NOW!

EMERGING TECH by Rich NiemiecViscosity

10:15 - 11:15 CT

San Antonio 1

AAS Predictions Using Deep Learning Neural Networks with Sysmetric Data

Smooth database operations are hindered when unexpected performance incidents occur. What if we could predict an incident was likely to occur within the next sixty seconds? By using Oracle Sysmetric data with deep learning neural networks, this can be a reality.
This presentation will begin with recognizing patterns and how neural networks try to do the same. Then we’ll look at Sysmetric data, understanding and leveraging its time-series nature. Now we're ready to understand why neural networks and deep learning are sought after in performance prediction.
An Oracle Cloud Free Tier or Gmail account is enough for a mind-blowing graphical demonstration of making real-time performance predictions. You can download the single file necessary to replicate my demonstration enabling you to tinker and explore!
Once you get a glimpse of what is possible, a whole new world of performance monitoring and alerting will appear before you. Join me for a fascinating applied machine learning presentation for the Oracle DBA of the future.

REGISTER NOW!

EMERGING TECH by Craig ShallahamerViscosity - OraPub

11:45 - 12:45 CT

Dallas 5

How to Find the "Top Anything" Using Raw ASH Data

Have you ever been asked a "top anything" question? Questions like, "Hey Craig, what is the top [insert stat here]...?" For instance, the DB Time SQL by hour, top hour with the most active session, top CPU consuming execution plan, top module for this SQL_ID, top SQL_ID when waiting on db file sequential reads, top IO activity day of the week, top hard parse hour, top hard parse day last June, top hard parse force matching signature, and the top row lock hour regardless of the date or the day. This list goes on and on.
The SQL I'll use to demonstrate how to answer all these questions is simple and only eight short lines. It aggressively uses ASH's sample nature, SQL*Plus defines and your understanding of how Oracle works. The result is we can do deep analysis we normally would not think is possible...even with ASH. Truly, it's the most important SQL statement I have ever written.
Join me as we explore how to creatively and aggressively use raw ASH data to answer traditionally difficult but incredibly important Oracle and application performance questions.

REGISTER NOW!

DATABASE by Craig ShallahamerViscosity - OraPub

15:30 - 16:30 CT

Texas 1