Tag: Database

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…

Data Intensity decided to utilize the Oracle Autonomous Data Warehouse Cloud to solve a problem that they were facing around financial reporting. Before the decision to use Oracle Autonomous Data Warehouse Cloud, Data Intensity’s finance team was spending roughly 60 percent of its time just getting the data out of systems. Therefore, only the remaining 40 percent of the time was spent generating value back to the business.

Oracle Autonomous Database, the world’s first autonomous database, launched last year. This “self-driving” database has continuously been gaining interest in the business world. It eliminated complexity, human error, and manual management. This helps ensure higher reliability, security, and more operational efficiency at the lowest cost.

Is sometimes difficult to quickly identify the root cause of a performance issue in the database. Automatic workload Repository (AWR) contains most of the information needed to identify these issues, but it could be overwhelming due the amount of data and statistics. Then, there's a need of a method to quickly identify if the database…

Some might think Docker is for developers only, but this is not really the case. Docker is here to stay and there will be more and more of it in the future. In this session learn what Docker is and how it works.  This session will be covering core areas such as volumes, but also…

Have you ever wondered what is the purpose of the locking mechanism in Oracle Database and how to avoid unnecessary performance issues due to lock waits - whether on premise or in the cloud. In this session, we will explore the locking mechanism in Oracle Database from A to Z. You will learn the following…

Database security starts with a baseline and some basics in configuration. Planning security with database creation and a place to start is important when either starting to work with the databases or starting with security. Practical first steps along with a configuration baseline will be take aways from this session.