Tag: Database & Technology

Presented at INSYNC 21

Session ID: 100310

This session will introduce Oracle RAC in the context of Developers attempting to use Oracle Database. The session will cover tips and tricks to ensure that developers can benefit from features like session failover, load balancing with minimal effort.

Presented at INSYNC 21

Session ID: 101290

Nobody complains that the database is too fast.  But speeding up queries is often seen as a 'dark art' and a mysterious process.  You add an index but then things go slower. This workshop explains how indexes and histograms really work, how to use them efficient, and how to really speed up your MySQL queries.

Presented at INSYNC 21

Session ID: 100440

It seemed so simple—migrate a relatively small legacy database from DB2 to Oracle Autonomous Data Warehouse. Nobody knew the dark secrets this database was hiding before the SOW was signed and the project was underway, but by then it was too late! Follow along as a well-planned project grows from unassuming and ordinary into a monster, devouring everything in its path and tossing aside timelines! A twisting tale, full of wrong turns and peril, heroes and villains, challenge, failure, ultimately ending with... Wait, you didn't think I'd give away the ending, did you?

This session is not a reference or a how-to. It's more of a what-not-to-do, reflecting and laughing (in hindsight) at a series of unfortunate circumstances and mistakes. It's a set of lessons in resilience and determination. It's about overcoming technical obstacles and human objections, and leveraging the tools and features in OCI so they all lived... Well, let's not spoil things!

Presented at INSYNC 21

Session ID: 100680

We will look under the hood of a famous monolith: How does the Oracle Database really work? The RDBMS has to keep many promises to ensure consistent transactional operations. Most of them are found in the acronym "ACID".

We will hear explanations to terms like A in Archivelog or Alert Log or ASM, H as in High Availability, M like Multitenant, R like Redo Log, S as in spfile, T like Tablespace, and U like Undo.

Presented at INSYNC 21

Session ID: 100170

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.

Presented at INSYNC 21

Session ID: 100560

Enabling and sustaining the highest possible performance along with continued application availability is a major goal for all mission-critical applications in order to meet the demanding business SLA’s. Harnessing key features in the latest vSphere release 7.0 U1 including Persistent memory, Para Virtualized RDMA, 1GB Huge Pages, vNVME Controllers, Improved Distributed Resource Scheduler (DRS), Assignable Hardware, Refactored vMotion, etc helps achieve those stringent business goals. This session discusses accelerating Oracle Enterprise IO-intensive workloads with vSphere 7.0 new features enhancing high availability, faster data loading, etc, and share key considerations and lessons learned.

Presented at INSYNC 21

Session ID: 100350

Attend the first-ever Oracle Maximum Availability Architecture (MAA) Special Interest Group (SIG) meeting at Quest INSYNC 2021! The need to deliver increasing levels of availability continues to accelerate as enterprises reengineer their solutions. Given this fact, we will provide an update on the former Oracle RAC SIG along with an overview of the goals and objectives of the MAA SIG. Join this session to meet the new board and to learn about upcoming webinars as well as other activities going forward. The current Oracle Liaisons Anil and Markus will answer questions and receive feedback around topics such as Oracle MAA, HA and Scalability. Looking forward to virtually meeting you in our inaugural MAA SIG session!

Presented at INSYNC 21

Session ID: 100320 

Oracle Autonomous Database and its Oracle Machine Learning Environment

Based on Oracle Cloud Infrastructure (OCI), Oracle Autonomous Database cloud service is optimized for several workloads options: Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP), and Oracle Autonomous JSON Database.

This discussion will cover the Oracle Autonomous Database cloud service, its components, its provisioning process, and its free trial tier and always free offering. This session will also discuss the Oracle Machine Learning service that comes with Oracle Autonomous Database and how database professionals can take advantage of this environment to start learning Oracle machine learning.

Presented at INSYNC 21

Session ID: 100330

Top 10 Features & Services for Oracle DBA on Oracle Cloud, Plus Challenges.

The SIG session is planned to be interactive. If you are an Oracle Cloud Infrastructure (OCI) user with Oracle Database on IaaS, DBCS, ExaCS, or Autonomous DB, we want to hear from you about what you like and the challenges you face. If you are not running your database on OCI yet, come to this session to understand the benefits and discuss your concerns.

Presented at INSYNC 21

Session ID: 100130

Oracle has a history of delivering data management solutions of choice for managing customers’ operational and analytical workloads on-premises and in the cloud. Jenny Tsai-Smith, Vice President of Database Product Management, shares Oracle's strategy for continuing to deliver truly unique and innovative products and services to meet and exceed customers' requirements.