The 2019 edition of “YOUR machine and MY database - a performing relationship!?” is intended to be an information for Oracle DBAs, DB developers and system administrators who want to learn more about how today's databases, modern operating systems, hypervisors and current hardware works together. Databases affect machines, machines affect databases. Optimizing one is pointless…

We know different IO types that are used by the database. The DB need them, to fullfill its tasks. This lecture shows how and where they are different, and explains the advantanges and disadvantages of each. We will talk about access to tablespaces, online/archived redo logs and different file types connected to the instance. I'll include…

An exciting new feature of Oracle Database 18c is "Centrally Managed Users" (CMU). This, for the first time, allows for simple and complete user management integration with Active Directory (AD). No additional licenses required! Previously, Oracle Enterprise User Security (EUS) was needed as an intermediate component bridging the Oracle Database to Active Directory. And while…

When databases get ever larger and larger, backing them up using traditional RMAN backupsets will quickly get unfeasible. Completing a backup requires too much time and resources, but more importantly the same also applies to restores. RMAN has always provided a solution as incrementally updated image copies, but they are much less manageable than backupsets.…

Providing the highest levels of availability is the main goal of Oracle’s Maximum Availability Architecture (MAA), which has been available for more than a decade. What started as a set of blueprints and best practices for high availability (HA) for the Oracle Database has evolved into the de-facto standard when it comes to operating the Oracle Database in the most resilient way on-premises, on Engineered Systems or in the Cloud. Consequently, most Oracle customers look at MAA as a database administrator (DBA) task to implement. This session looks at Oracle MAA from a slightly different angle, as MAA should really be considered by the DBA as well as by developers and even by non-Oracle customers. For DBAs, this session will explain the main aspects of how to ensure HA for the Oracle Database; developers will get to see how certain features can make an application more available when MAA standards are followed. Last but not least, for those looking at alternative database solutions, this session will provide an idea as to what failures and preventative measures need to be considered to make any database more available.

AWS engineers from the Relation Database Service (RDS)  will explain what you can do to make your Oracle database licenses go farther in AWS. Virtual Machine choices can make a large difference on how far your existing licenses will take you in the cloud. There are also EC2 and RDS configuration settings that will allow…

Stumped by how to implement least privileges model for your database and reduce your cyberattack surface?  You know it's something you're supposed to do, but how do you know which privileges and roles are needed by all your users and applications?  Too many roles and privileges make it easy for hackers to use a single…

Pre-reqs: Laptop with Internet connectivity Active AWS account with Admin privs. Oracle Database client, e.g., SQL Developer Attended Working with Relational Databases in the Cloud – Introductory Concepts HOL, or having an RDS for Oracle instance already created Get hands-on with the Amazon Relational Database Service (RDS), a managed cloud database platform from Amazon Web…