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…

With the recent release of Oracle Database 18c Express Edition (XE), a gap has been filled with Oracle's free set of Rapid Application Development (RAD) tools available for the developer to be able to create applications.  Now with Oracle Database 18c XE, Oracle SQL Developer, Oracle Application Express (APEX), and Oracle Rest Data Services (ORDS),…

Learn how to use simple algorithm analysis for Oracle performance tuning.  Finding the mathematical functions that describe the computational complexity of different operations can help us understand and predict performance.  This presentation will discuss common functions such as 1/N, LOG(N), N, N*LOG(N), N^2, and N!, and how they can help us understand operations such as…

Wikipedia defines infrastructure as code as "the process of managing and provisioning computer data centers through machine-readable definition files, rather than physical hardware configuration or interactive configuration tools." This principle greatly simplifies setting up and managing large server parks, it also helps with repeatability and auditability in all environments. In a traditional Oracle database world…

Oracle's Fusion Middleware SOA suite is one of the most useful yet underutilized set of tools available to developers. To offer better services, businesses are forced to grow in complexity. As a result, integration with heterogeneous data sources and cloud services becomes necessary.  The downside of this trend is that businesses loose ability to effectively…

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…

There’s an onslaught of Big Data coming to our IT shops - zettabytes of it! – but instead of your application developers struggling to learn new languages and techniques to analyze it, why not leverage Oracle Database 18c? This session will demonstrate how to tackle handling the coming Big Data tidal wave with the best…

The frenetic pace of application development in modern IT organizations means it’s not unusual to demand an application be built with minimal requirement gathering – literally, from a napkin-based sketch – to a working first draft of the app within extremely short time frames – even a weekend! – with production deployment to follow just…