Tag: Database & Technology

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.

Presented at INSYNC 21

Session ID: 101870

Databases running on the cloud are not exactly the same as on-premise databases. They have different deployment models and network architectures, the protocols for accessing them are strictly controlled, their configuration is locked down, and some administration commands are blocked. This raises a question on how to effectively monitor an Oracle Database cloud ecosystem. Join this session to learn practical examples of how to diagnose and resolve application problems using various tools that help DBAs with day-to-day tasks and master cloud database management.

Presented at INSYNC 21

Session ID: 101850

Oracle Data Safe is an exciting new service offering security capabilities for identifying and reducing risk in Oracle Databases. First introduced at Oracle Open World San Francisco in 2019, Data Safe has been continuously enhanced and is now available for all Oracle Databases, on-premises and in the cloud. Join us to learn how you can simplify managing the security of your databases. We will go through a real life use case to assess configuration risks, evaluate database users, manage audit settings, report on database activity, discover sensitive data, and remove sensitive data from non-production copies of the database. And the best part – no special expertise is needed to leverage the capabilities of Data Safe.