Tag: IOUG

Do you need to add complex validations, dynamic actions and/or implement interactive grid customizations?  The interactive grid API is your friend. This session covers the essential elements of the APEX interactive grid API that most interactive grid developers need to know, or *should* know to build effective, customized interactive grids. We will detail and demonstrate…

Setting up an Oracle Analytics Cloud (OAC) instance can be a little tricky. Learn the ins and outs of this fairly new Oracle offering in this session. Topics covered will be OAC parts and pieces, how to navigate in the Cloud environment, creating the database and OAC instance, building out an application and analysis and…

Oracle Database In-Memory promises an incredible performance boost for analytic queries. But how do you determine if you have an analytic workload that will benefit from Database In-Memory? This presentation will review what Database In-Memory is and how it works, and then we will talk about what types of workload will benefit from Database In-Memory.…

One of the most common SQL Tuning problems is when the Oracle cost-based optimizer misestimates the expected number of rows that will be returned from an execution plan row source operation. This presentation delves into uncharted waters to help attendees understand strategies for dealing with cardinality misestimates.

With Oracle Database 19c a new tool will become available: The AutoUpgrade Tool will upgrade hundreds and thousands of databases or PDBs fully unattended automatically. You will only need one config file. And everything else, from preupgrade to fixups to upgrade and finally postupgrade and time zone adjustments, everything gets handled by the tool. Regardless…

Relational Databases are extremely sophisticated, but their extensive functionality makes it challenging for them to achieve hyperscale. Some have turned to alternative technologies such as key value stores, which exclude most of the functionality of Relational Databases in order to make scaling easier. However, increasingly more people are seeking a solution that achieves extreme scalability…

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,…

Data is the life blood of your company, and Oracle Data Guard and Oracle Active Data Guard have long been the answer for the real-time protection, availability, and usability of your Oracle data. Attend this session to get an in-depth look at several key new features that will make your life easier and protect your…

Learn from Oracle GoldenGate Product Management on the new GoldenGate 18c features, including a deeper dive into the new Microservices Architecture for automing Oracle GoldenGate.  And discuss enhancements related to Active-Active replication including the new Automatic Conflict Detection and Resolution features.

The most interesting new feature Oracle 18c introduces to Developers are Polymorphic Table Functions and Qualified Expressions. Polymorphic Table Functions finally allow the Developer to define the structure of the returned records at runtime. Qualified Expressions allows defining array- or record constructors that assign all values in a single statement. What looks at first sight…