Join Quest, Oracle experts, and your peers at Oracle OpenWorld, September 16 – 19, 2019, in San Francisco, California!

You can attend a Quest education session out of more than 2,000 unique sessions offered, mix and mingle with Oracle Product Team and end-users at a Quest reception, and stop by the Quest Kiosk in Moscone West Level 3, OUG-007 for a chance to win a $500 gift card!

Check out some of the education and receptions that Quest is offering at Oracle OpenWorld.

Quest Education at Oracle OpenWorld

Quest is excited to be hosting a variety of education sessions at Oracle OpenWorld. Join us in one of the many sessions offered for Database & Technology, Oracle Cloud Applications, JD Edwards, and PeopleSoft and add to your Oracle OpenWorld agenda today!

Database & Technology Education Sessions

Monday, September 16

Multitenant 12.1 to Multitenant 18c: Technical Deep Dive [CON4483]

9:00 am in Moscone West – Room 3007D

Presented by Anuj Mohan, Data Intensity LLC

Database 18c pluggable databases offer numerous options for the cloud. In this session walkthrough Exadata Multitenant for cloud/on-premises databases. Topics covered include container database (CDB)/pluggable database (PDB) concepts, PDB value, shared/exclusive components, and accessing CDBs/PDBs. The session briefly covers migration options to 12c/18c from previous versions and then delves into Oracle Database 12c R2/18c features including PDB relocate, lockdown profiles, system global area/program global area for PDB, memory I/O resource prioritization, snapshot carousel, dynamic lockdown profiles, CDB fleet management, and new features in Oracle Database 19c if time permits.

Oracle Cloud Infrastructure: Practical Tips from Experience [CON1963]

10:00 am in Moscone West – Room 3007D

Presented by Simon Pane and Nelson Calero, The Pythian Group Inc.

Oracle Cloud Infrastructure is gaining industry adoption at a rapid pace. And effort and issues can be minimized when the implementation is architected and designed optimally from the very beginning. This session covers many practical tips and recommendations to help organizations adopt Oracle Cloud Infrastructure in an optimal manner for security, performance, and resiliency. Topics covered include what a bastion host is and when one is needed, how to plan CIDR blocks and provide meaningful names for resources, and when to federate and what “break-glass” protection mechanisms are needed. These answers and more are addressed in this customer-experience-focused session offering practical tips and best practices from lessons learned.

Oracle Cloud Infrastructure: Practical Tips from Experience [CON1963]

11:15 am in Moscone West – Room 3016

Presented by Simon Pane, The Pythian Group Inc.

This is the year for Oracle Cloud Infrastructure: it’s ready for prime time with all critical features already available and many nice-to-have additions coming online throughout this year. But Oracle Cloud Infrastructure is a little different than the other clouds that you may already know, and some basic knowledge is required to get started efficiently. This session provides all the information needed to help anyone get up and running on Oracle Cloud Infrastructure. Whether you’re just starting and want to experiment or you have a plan for a full proof of concept for your business already in mind, this session gives you the essential fundamentals—tips, recommendations, explanations, cautions, and more.

Unduly Forgotten Performance-Tuning Hero: PL/SQL Hierarchical Profiler [CON2108]

2:45 pm in Moscone West – Room 3007E

Presented by Michael Rosenblum, Dulcian Inc.

A number of polls taken during various PL/SQL-related presentations paint a very strange picture: one of the most-critical FREE server-side performance-tuning tools is almost totally unknown! If you ask basic questions such as, “How much time is spent on routine A?” or “How often is function B called?” most developers would start to hand-code their own solutions instead of utilizing the Oracle PL/SQL hierarchical profiler (HProf). This is not because the provided functionality is disliked, but the fact is that most developers are simply not aware of its existence. This session is an attempt to alter this trend and re-introduce HProf to a wider audience.

Tuesday, September 17

It’s All in the Presentation of Data [CON2173]

11:15 am in Moscone West – Room 3007E

Presented by Biju Thomas, OneNeck IT Solutions

DBAs usually collect a lot of data and present it in a tabular format, but management and users like and understand visual representation of data better. The tabular format does not make the impact or get the attention you desire. Attend this session to see how easily you can convert those tabular formats to pictures using the free and open source Google Charts. Google Charts is a pure JavaScript-based charting library to enhance web applications by adding interactive charting capability. This session includes two demos and is geared for DBAs, architects, and sysadmins who present data to end users or management.

The DBA’s Next Great Job [CON2719]

12:30 pm in Moscone West – Room 2010

Presented by Rich Niemiec, Viscosity North America

What’s the next role for the DBA as the autonomous database and Oracle enhancements free up time? This session explores the DBA role (managing more databases with autonomous database) and the integration of AI and machine learning. Topics covered include what’s next for the DBA with the autonomous database, important skills for the future such as machine learning and AI, how the merging of tech fields cause both pain and opportunity, and future jobs and the world ahead where Oracle will continue to lead.

Processing Data from Oracle Database in MapReduce [CON1418]

12:30 pm in Moscone West – Room 2011B

Presented by Eric Mader, Vertical Trail LLC

Hadoop is one of the fastest-growing platforms in the IT industry. Organizations are using Hadoop for many different applications, including marketing analytics, customer recommendations, and business trend reporting. MapReduce provides organizations with powerful tools and support for their big data operations—with workloads conducive to the elastic nature of the cloud. However, one of the big challenges for any Hadoop implementation is the ability to leverage existing data within Oracle Database. This session discusses strategies for implementing Apache Sqoop, a utility that allows for Oracle Database to be utilized as a data silo for a Hadoop environment.

Oracle Database Locking Mechanism Demystified [CON2935]

12:30 pm in Moscone West – Room 2004

Presented by Pini Dibask, Dell Inc.

Have you ever wondered what the purpose of the locking mechanism in Oracle Database is? Do you want to know how to avoid unnecessary performance issues due to lock waits both on-premises and in the cloud? In this session explore the locking mechanism in Oracle Database from A to Z. Topics covered include concepts of Oracle Database locking mechanism, advanced locking scenarios, ways to investigate lock issues using Oracle dictionary views, and simplifying the investigation of the root cause for the lock issues using database performance tools.

Achieving Massive Scalability and Total Fault Isolation with Oracle Sharding 19c [BUS1988]

4:15 pm in Moscone West – Room 3007E

Presented by Kai Yu and John Tao, Dell Inc., and Kurian Abraham, Oracle

Oracle Sharding was introduced in Oracle Database 12cR2, and was further improved in Oracle database 18c and 19c for linear scalability and complete fault isolation for OLTP workloads. With Oracle Sharding, data is horizontally partitioned across discrete Oracle Databases (shards) that collectively form a single logical database. Come to this session to learn about the latest sharding improvements in Oracle Database 18c and 19c, sharding on Oracle Database Cloud, and leveraging sharding for your business. Hear about the experience of using Oracle Sharding in Dell IT’s global geodistribution application, including what apps best fit to sharding, deployment of sharded databases with replication for massive scalability, and complete fault isolation. Lessons learned are also covered.

Wednesday, September 18

Scale Up Your Use of the Advisor Framework [CON2397]

10:00 am in Moscone West – Room 3018

Presented by Roger Cornejo, GlaxoSmithKline

Transform your ability to quickly respond to the challenge of ensuring high-performing databases. The key to this transformation is to expertly use the advisor framework that underlies tools such as Automatic Database Diagnostic Monitor, SQL Tuning Advisor, and Segment Tuning. These tools provide (and persist in the database) actionable advice to the DBA seeking to solve performance problems, but getting at this information can be painstaking. This session explores the many undocumented ways to proficiently use the underlying data to quickly get to tuning solutions. Leave this session with more confidence, and new tools and approaches for solving Oracle Database application performance problems.

Best Practices for Maximizing Analytical SQL Performance with Oracle Database In-Memory [CAS2285]

11:15 am in Moscone West – Room 3007E

Presented by Arsalan Dehghanisariyarghan, IIC Corp.

Oracle Database In-Memory is a suite of features, first introduced in Oracle Database 12c, that greatly improves performance for real-time analytics and mixed workloads. This session outlines the steps to leverage these features with analytics applications. Topics covered include best practices for leveraging Oracle Database In-Memory to accelerate the query performance of analytics applications and how to determine the tables or segments that need to be populated into the Oracle Database In-Memory Column Store. Through a case study of a data warehouse/analytics project, see the configuration, best practices, and lessons learned about how these features help accelerate the performance of analytics applications and analytical SQL.

Histograms (In Oracle Database 11g to Oracle Database 19c) Could Be Your Friend [CON2934]

11:15 am in Moscone West – Room 3018

Presented by Anuj Mohan, Data Intensity LLC

In this session, learn what histograms are and how they can be useful to you. Topics covered for Oracle Database 11g histograms include frequency histograms and height-balanced histograms. Topics covered for Oracle Database 12c Histograms include challenges with Oracle Database 11g histograms, top frequency histograms, and hybrid histograms. The session also covers Oracle Database 18c histograms and Oracle Database 19c histograms.

Orchestrating Docker Containers with Kubernetes [CON1423]

12:30 pm in Moscone West – Room 3018

Presented by Eric Mader, Vertical Trail LLC

Docker has emerged as the de facto containerization leader, allowing both Linux and Windows workloads to be quickly and easily containerized and run on any platform, including laptops, servers, and private and public clouds. However, in enterprise environments, just running Docker containers is not sufficient—Oracle applications and services must be architected for availability, durability, and reliability. This session explores using images pulled directly from Oracle Container Cloud’s registry and stacks, and defined using Docker Compose, to quickly spin up single-instance Oracle services, then deploying it all to a Kubernetes Pod.

Reduce Application Downtime During Planned and Unplanned Outages [BUS3331]

12:30 pm in Moscone West – Room 3007D

Presented by Eric Siglin, Electric Reliability Council of Texas

Collaboration between Development and Operations teams can lead to amazing improvements in application stability. The Electric Reliability Council of Texas (ERCOT) harnessed the power of Oracle Database 12c and Universal Connection Pool to keep applications running during times of planned and unplanned infrastructure outages. Since implementing Universal Connection Pool, ERCOT has had several occasions where one of the nodes of the Oracle RAC cluster failed, and had to be restarted or patched. These activities occurred with virtually no application issues. This is an excellent first step in preparing applications for harnessing cloud databases when you’re not sure what will happen to your database service. Attend this session to learn more.

Gain Confidence with Upgrades and Migrations Through Oracle Data Guard [BUS3336]

3:45 pm in Moscone West – Room 3018

Presented by Eric Siglin, Electric Reliability Council of Texas

Ever hear the phrase, “When I test, I test in production?” It can be a great way to test an upgrade or migration before you take the outage on your production system. In this session learn how the Electric Reliability Council of Texas reduced its outage window and gained confidence in its migration to Oracle RAC and upgrade to Oracle Database 12c by using the power of Oracle Data Guard and its snapshot standby database. It was able to identify and correct any issues before the actual migration and upgrade day by performing the steps on an actual production database and converting it back to a physical standby when the test was complete.

Oracle Database 19c Best New Features Plus Oracle Database 18c/Oracle Database 12cR2 Tips [CON2729]

4:45 pm in Moscone West – Room 3016

Presented by Rich Niemiec, Viscosity North America

This session explores Oracle Database 19c new features including automatic index creation. It also looks at some Oracle Database 18c new features such as snapshot carousel, PDB switchover, in-memory external tables, merge partition online, advances in the approximate query, polymorphic tables, standby nologging, and passwordless schema creation. See simple examples highlighting the basic functionality of the new features and get a look at the autonomous database and Oracle’s focus on the future of security.

Oracle Cloud Applications Education Sessions

Monday, September 16

Oracle Planning and Budgeting Cloud: Fast Budgeting Today, Better Planning for the Future [CAS2574]

9:00 am in Moscone West – Room 2020A

Presented by Cameron McClurg, SpearMC Consulting

Amid fast growth, Cupertino Electric Inc. (CEI), an engineering and construction firm, was stretching its planning processes and analytics systems to the limits. In this session learn how it worked with SpearMC to evaluate its infrastructure and implement Oracle Planning Budgeting Cloud. CEI now has a solution for planning, consolidation, reporting, and analytics that helps it move faster and make more informed decisions. SpearMC implemented a new budgeting system and modified processes to improve planning and forecasting. The new, cloud-based planning model uses Oracle Planning and Budgeting Cloud instead of Excel, providing better functionality, increased flexibility, deeper planning, and improved data integrity and accuracy.

Oracle HCM Cloud: Integration Methodologies at Yum! Brands

10:00 am in Moscone West, Room 3014

Presented by Sharon Perkins, Yum! Brands, and Chris Costakes, Elire Inc.

Oracle Cloud SaaS and PaaS offer myriad integration choices. In this session learn about the way Yum! Brands integrates with vendors and other internal systems using Oracle SOA Suite Cloud, Oracle Business Intelligence Publisher, REST APIs, ATOM feed, Oracle Visual Builder Cloud, Oracle Java Cloud, and DBaaS.

A Growing Up Year: Oracle Financial Consolidation and Close Cloud and TaylorMade [CAS3408]

11:15 am in Moscone West – Room 3007D

Presented by Pamela Stone, Grant Thornton LLP, and Lakshmi Devulapalli and Vanessa Koenig, Taylormade Golf

After separating from its parent company Adidas last year, iconic golf brand TaylorMade needed to establish its own financial reporting capabilities. Known for producing innovative and cutting-edge products, TaylorMade wanted the same from its back-office technology, so it chose Oracle Financial Consolidation and Close Cloud as the first tool in its Oracle EPM Cloud journey. Join this session to learn how TaylorMade has leveraged Oracle Financial Consolidation and Close Cloud to grow as an independent company while working with Oracle to improve the performance of the new application with extended dimensionality and custom business rules.

ATCO’s ERP/HCM Cloud Journey [CAS4223]

12:15 pm in Moscone West – Room 2020D

Presented by Sue Shaw, ATCO Group

ATCO Group is a US$21 billion enterprise with 6,000 staff worldwide in diverse industries such as gas, electricity, pipelines, liquids, energy, and construction. ATCO realized that in order to remain an industry leader, it had to embark on a transformative journey to simplify and standardize processes while also creating an efficient shared-services model. Join this session to trace ATCO’s journey through the deployment of the Oracle Cloud suite, and look at how strategic planning, rigorous mapping, and robust change management helped the company leverage synergies and improve customer service. ATCO also shares current cloud benefits and challenges after being live on Oracle ERP Cloud/Oracle HCM Cloud for almost a year. The session includes time for questions.

Tuesday, September 17

Customers Succeed with Oracle HCM Cloud [PAN4236]

12:30 pm in Moscone West – Room 2000

Presented by Jon Vaughn, Quest Oracle Community, and Wade Larson, Wagstaff Inc.

Oracle HCM Cloud users increase the value of their investment through learning from other users. Quest, a user-led and user-driven community, has created a vibrant community that allows users to drive business results and grow professionally from each other. In this session Join a panel of customers as they share their journey with Oracle HCM Cloud and learn how you can get the most of your investment.

JD Edwards Education Sessions

Tuesday, September 17

IaaS Transforms JD Edwards Solutions [CAS4235]

12:30 pm in Moscone West – Room 2024A

Presented by Christina Yue, Quest Oracle Community

There are numerous ways customers can journey to the cloud to transform their existing technology. In this session join a panel of customers as they share their journey of how they “lifted and shifted” their Oracle’s JD Edwards solutions to Oracle Cloud Infrastructure to get the best of both worlds.

Wednesday, September 18

JD Edwards: The Who, What, Where, and Why [CAS4248]

9:00 am in Moscone West – Room 3018

Presented by Jon Vaughn, Quest Oracle Community

In this session join Quest as it presents key findings from a recent community survey. Get an in-depth look at the Quest community landscape to understand where customers are with Oracle’s JD Edwards. Identify industry issues and learn about key findings including what the biggest challenge is, where others are in their technology journey, and why customers are seeing the value of JD Edwards.

PeopleSoft Education Sessions

Monday, September 16

IaaS Transforms PeopleSoft Solutions [CAS4222]

10:00 am in Moscone West – Room 2024D

Presented by Christina Yue, Quest Oracle Community

There are numerous ways customers can journey to the cloud to transform their existing technology. In this session join a panel of customers that share their journey of how they “lifted and shifted” their Oracle’s PeopleSoft solutions to Oracle Cloud Infrastructure to get the best of both worlds.

Tuesday, September 17

PeopleSoft: The Who, What, Where, and Why [CAS4247]

3:15 pm in Moscone West – Room 3018

Presented by Jon Vaugh, Quest Oracle Comunity

In this session join Quest as it presents key findings from a recent community survey. Get an in-depth look at the Quest community landscape to understand where customers are with Oracle’s PeopleSoft. Identify industry issues and learn about key findings including what the biggest challenge is, where others are in their technology journey, and why customers are seeing the value of PeopleSoft.

Quest Receptions at Oracle OpenWorld

Join us for one of our receptions at Oracle OpenWorld! Mix, mingle and build connections with your fellow Oracle users, Oracle Product Teams and others in the Quest Community. Enjoy delicious food and unparalleled views of the Bay Bridge lights at EPIC Steak, just a short walk from the Moscone.

It is important to note that networking receptions are for customer attendance only.

Cloud Reception

EPIC Steak – 369 The Embarcadero, San Francisco, CA 94105

Monday, September 16 from 6:30 pm – 8:30 pm

Register Now

PeopleSoft Reception

EPIC Steak – 369 The Embarcadero, San Francisco, CA 94105

Monday, September 16 from 6:30 pm – 8:30 pm

Sponsored by:

• Appsian
• Graviton Consulting Services
• Kastech Solutions LLC
• MIPRO Consulting
• Presence of IT
• SpearMC Consulting

Register Now

JD Edwards Reception

EPIC Steak – 369 The Embarcadero, San Francisco, CA 94105

Monday, September 16 from 6:30 pm – 8:30 pm

Sponsored by:

• ALLOut Security
• iLearnERP
• Surety Systems

Register Now

Additional Resources

COLLABORATE 20 will take place April 19-23, 2020 at the Mandala Bay Resort and Casino in Las Vegas, NV! Call for Presentations is now open. Don’t miss your chance to share your stories, insights, and advice with the Quest Oracle Community! Submit an abstract by October 11, 2019, to be considered to be a speaker at the conference.

If you’re looking for more PeopleSoft content, join us next year at RECONNECT 20, the premier deep-dive PeopleSoft focused event of the year! The event will take place July 21-23, 2020 in St. Louis, Missouri. Keep an eye out for more information on this event!

If you’re looking for more JD Edwards content, join us next year at INFOCUS 20, the premier deep-dive JD Edwards focused event of the year! The event will take place August 25-27, 2020 in Denver, Colorado. Keep an eye out for more information on this event!