Tag: Database & Technology

Quest Forum Digital Event 2020

For some, the word DevOps means a Lot, there have been many books written about it.  Yet, so many do not know what it is, what it stands for.  Let's take a look at the following key areas: What is DevOps?  Why is it so Important? How to get started!

Quest Forum Digital Event 2020

Amazon RDS Oracle Database service and Oracle Autonomous Database are DBaaS. They have similarities and differences. Come to this session to understand the features and contrasts of both services – not an attempt to show one is better than the other. Both have their use cases and advantages. Having a deep understanding of the capabilities and limitations will help you to understand the best and suitable service for your application.

Quest Forum Digital Event 2020

Powerful Machine Learning (ML) is now available to Oracle DBAs. Over the past few years, a number of changes have occurred making this possible. As Oracle DBAs, it is now our turn to leverage ML, enabling us to do things never before possible.

But there is a lot to learn. Everything from methodology to math to tools. And then the nagging question of, are there real machine learning use cases for the Oracle DBA?

In this presentation, I'm going to introduce you to the world of ML from a DBA perspective! This includes understanding what ML is, why use it, and why now. The ah-ha moment will occur when you realize many of our monitoring, alerting, diagnosis, and analysis skills are significantly enhanced with ML.

I will demonstrate a simple yet complete ML project using Python and the "Always Free" Oracle Autonomous Database with Oracle ML SQL Notebooks. All presentation slides, scripts, and a recording of the demonstration are available!

Quest Forum Digital Event 2020

Containers have been embraced by the developer community, but acceptance and adoption by DBAs is more... tepid. That's understandable--why would anyone want a database that's stateless and immutable?! I started using Docker under duress and had no idea what I was doing. Since then, I've learned that Docker elegantly addresses many situations faced by DBAs, including:
- Rapidly provisioning test and development environments
- Interacting with Oracle Cloud Infrastructure databases (including ATP and ADW)
- Preparing environments for performance testing
- Building Gold images
- Exploring new technologies and features
- Discovering and confirming bugs
- Preparing for certification exams

This session is a crash course in Docker covering the terminology, concepts, skills, and practical examples needed to begin using containers to support databases.

Quest Forum Digital Event 2020

Oracle Database and Oracle Enterprise Manager continuously introduce new and interesting features that help improve DBA productivity and maximize performance while reducing management costs. This session covers the theory behind performance diagnosis and tuning and the new capabilities in Oracle Database and Oracle Enterprise Manager, such as Performance Hub, Automatic Workload Repository, multitenant enhancements, and many others. This session provides practical recommendations and real-world best practices on when and how to best use which feature, helping DBAs with day-to-day tasks.

Quest Forum Digital Event 2020

Join Oracle development for the latest updates on high availability (HA) best practices in this well-established technical deep-dive session. Learn how to optimize all aspects of Oracle Active Data Guard 19c. See how to use session draining, transparent application continuity, Oracle RAC, and Oracle GoldenGate to mask outages and planned maintenance from users and to accelerate time to repair for single database or your fleet of databases. Hear about the latest HA best practices with Oracle Multitenant and understand how the new sharded architecture can achieve even higher levels of HA and fault isolation for OLTP applications. Find out how everything you know about Oracle Maximum Availability Architecture (MAA) on-premises can be deployed in the cloud.

Quest Forum Digital Event 2020

Learn how POWER9 with the Oracle 19c DB In Memory features can help you accelerates performance and reduce CPU use when performing simple and complex analytics queries. After an overview of the newest capabilities of Oracle Database In-Memory feature, we'll share our experiences testing DBIM with simple and complex queries on POWER9. We will share the speed ups achieved for a set of reporting queries run In-Memory compared to disk row format, as well as hints and tips for getting the best results with In-Memory.

Quest Forum Digital Event 2020

Do you know how a large and complex organization like LA Unified School District has successfully rolled out a comprehensive business intelligence application that is business-oriented and producing results with data-driven decisions!  LAUSD Enterprise Reporting uses Kafka, ODI and Oracle technology components to deal with never-ending streams of events, to use Real-time or near-real-time processing to detect patterns and trends,  to build a suite of interactive dashboards based on streaming data integration for district executives, principals, teachers, counselors, and families with over 300 K-12 metrics and KPIs that provide whole child, whole school, whole district insight.  The session is planned as an interactive one, with a real-time demo, presented by a senior leader of the School District who has played a key role in the planning and execution of the huge effort.

Quest Forum Digital Event 2020

Since 2016, Nationwide Insurance has leveraged Oracle Enterprise Manager's Fleet Maintenance capability to effectively and proactively patch our Oracle database environment to address critical vulnerabilities and maintain version currency.  Over three years, using EM capabilities, Nationwide has patched more than 7000 databases with a success rate exceeding 99%.  This session will talk about EM's Fleet Maintenance capabilities and impart some of the lessons we learned to achieve success.

With 19c we get the tiny little command line tool that will allow us to update our databases "hands free."  We can do all the prechecks, fix 99% of pre-update issues, and then do the update, and finally, the post-update, all without our manual little fingers on the keyboard, well almost no little fingers on the keyboard.  Wait there is more, it is not all for just Database 19c we can use this on prior versions like 18.5 and new as well as 12c Release 2 (12.2 + DBJAN2019RU and newer).