Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps with world-class features that can be deployed anywhere. In this lab learn how to convert a spreadsheet into a multiuser, web-based, responsive APEX application in minutes—no prior experience required.

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…

Oracle 12c and 18c Multitenant Container databases were designed to consolidate databases. The provisioning and management advantages of using pluggable databases greatly simplify database operations. However, the database security model becomes more complex to accommodate pluggable databases. This session will provide a deep dive into authentication and authorization when using the multitenant option, including users, roles, profiles, and privileges.  Challenges and nuances in managing the security of a multitenant database will be highlighted.

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…

Simply automating your business processes is not enough. You need processes that are dynamic, and change over time based on real-time data from many data sources. Predictive analytics, machine learning, self-documenting hardware, point and click integrations, and automated regression and performance testing is the future for ERP, EPM, analytics, and integration professionals. The future is…

This session will provide a blue print for customers to achieve Maximum Availability using  using Oracle RAC and Data Guard. We will go over the internals of the Architectures involved along with recommendations on each layer so Customers can attain maximum availabiliity.

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.

Reducing work done by the database is key to improving performance in Oracle-intensive applications. The Server Result Cache allows applications to virtually eliminate work done when processing repeated queries. For applications dealing with growing data sets, this ability can be very beneficial. The presentation will begin by focusing on SQL Query Result Cache and PL/SQL…

The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system.  A developer in cooperation with a DBA, or already granted DBA privileges can has a wide variety of tools and deep visibility.  However, a user with nothing more than CREATE SESSION and SELECT privileges can still make considerable headway into deciphering performance issues and correcting them.