Save the date! RMOUG is extremely pleased to announce our RMOUG Training Days 2023, Hybrid Conference!
Linux containers are fast, flexible, portable solutions well known for running applications and services. Yet they remain less well-accepted in the database community. In this session, we shine a light on the myths surrounding the suitability of containers for running databases and demonstrate the unique advantages and capabilities containers have over physical and virtual hosts.
Go from "Zero to Hero" and learn how easy it is to run Oracle databases in containers, using nearly any hardware (even laptops) to test, practice, and perfect DR and HA procedures, prepare for certifications, and more. Participants in this workshop will go hands-on building and running Oracle databases in containers, gaining valuable insight into how containers work and interact with host systems.
Instead of TALKING about the two most common ML applications (anomaly detection and performance prediction), in this workshop we are going to build two simple but powerful Oracle Average Active Session (AAS) prediction systems.
After these two projects, you will be in a position to begin your ML journey, including what skills you need to develop, the resources available and how ML can be embedded into your systems.
All you need is a laptop, an internet connection, and a Gmail account. We will be working in the free Google Colab environment, so no software will be downloaded onto your system! Plus, OraPub will provide you with all the needed data. And most importantly, you DO NOT need to know Python! All the code has been written for you.
Room 200 B + VIRTUAL
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 basic ML 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.
Room 105 + VIRTUAL
Oracle Database 19c is the terminal release of Oracle Database 12c and is packed with hundreds of 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. Oracle DBAs/Developers can take immediate advantage of these new features. We will share all of the code from our presentation so that you can add them to your arsenal.
This session is not the traditional one about Oracle 12.2/18c/19c database features. Be prepared to experience mind overload.
Many DBA's want to be better DBA's, and many non-DBA's want to become DBA's. Often the primary training for this is in technical topics, memorizing tons of details, or being able to be the first to solve a technical issue. Yet some of the best DBA's I've known over the past 31 years start with "I don't know." So what 10 things do you need to do to be a great DBA that have nothing to do with databases? How you interact with others in writing, reading, communication, talking, presenting, being able to repeat things, and more are also important.
Room 200 B + VIRTUAL
When it comes to database infrastructure, it seems there's never enough to go around. Backup and recovery validation, patching, and performance tuning affect systems availability and function and don't coexist with business processes. Organizations usually prioritize the competitive needs of visible, customer-facing improvements over seemingly less-immediate backend testing. Cloud services change the equation. Cheap, virtually unlimited compute power and storage are there for the taking -- with one catch. Who sets it up? Navigating a cloud interface to create hosts, assign disks, and configure networking is tedious and time-consuming. Once that's done, you still have to install software and prepare the environment. Enter Terraform, an automation tool that streamlines and simplifies infrastructure builds.
In this session, database administrators learn the basics of provisioning a database and supporting infrastructure on Oracle Cloud with Terraform. No prior experience with Terraform or Oracle Cloud is required.
Key business SLA objectives were not being met. IT Operations was stuck in the middle of declining service levels, a tight labor force, and IT needed to be better aligned with business goals.
To be better aligned, the IT Operations capacity had to be increased by reducing costs of both IT and business operations. More specifically, IT Operations needed to better detect problem trends and unusual activity across all their Oracle systems. False alerts were a real problem wasting employee time and energy. A solid operations picture required Oracle's Active Workload Repository data for near real-time analysis, in conjunction with machine learning and artificial intelligence.
Join us for a key business goals-focused perspective into how a business problem was solved using a variety of Oracle products, machine learning and AI.
This is an intermediate look at the practical application of Machine Learning. Using Oracle Machine Learning, I'll show how to produce results quickly. The first key is Algorithmic Business Thinking to see where the biggest impact will be. 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 tech 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 & know what they want to buy first or second.
Whether you belong to a large enterprise or a one-man startup, cloud based databases are now a reality or part your short term technology roadmap. Like every major initiative, having a plan and executing to perfection is key to realizing the benefits offered by the cloud adoption, the absence of which could result in unplanned and unexpected downtime for your business critical applications.
Join us in this educational session as we help you navigate and plan moving your databases to Oracle Cloud, along with useful tips before considering database as a service, infrastructure as a service or platform as a service options for your critical applications.
Room 104 + VIRTUAL
Since Oracle 10g, SQL Profiles have been an integral SQL performance tuning feature. Profiles sometimes seem like magic, making a statement run faster. In this session we will dig into what a SQL Profile is, how it works, and some tips and procedures for everyday usage of profiles. Let's pull back the curtain and get to the details of how SQL Profiles really work.
In this session we will be providing details about Oracle SQL profiles. Utilizing trace data and some peeks at under the covers of the Optimizer we will describe how profiles impact the Optimizer. The session will also provide examples and commands on how to use profiles in a robust manner in daily operations of Oracle systems including lifecycle management.
As Oracle professionals we've been wrangling data for years, even decades, but how do we rebrand ourselves as an in-demand data engineer in 2022? A data engineer builds big data platforms, data pipelines, and data integrations as databases data warehouses and data lakes.
This session will take you through 8 short steps you can take today to tap into the red-hot field of data engineering. These include how to leverage your Oracle skills to cloud strategies, unstructured data, Apache Spark, Spark SQL, Python, R, and Scala. We explore the most marketable ways to solve data at scale, and how to transition your hard earned Oracle skills into this new area. Finally, the session is an invite to an eight-part hands-on series of training that we are launching.