Oakies Blog Aggregator

connor_mc_d's picture

Add ORDER BY to make ANY query faster

Yes it’s SCBT day here in Perth!

SCBT = Silly Click Bait Title Smile

This post is just a cautionary tale that it is easy to get caught up judging SQL performance solely on a few metrics rather than taking a more common sense approach of assessing performance based on the true requirements of the relevant component of the application.  I say “true requirements” because it may vary depending on what is important to the application for a particular component.

For the majority of the time, response time is most probably the thing you will care about most. Certainly for customer-facing components of an application, response time is likely to be the dominant factor in defining application “success”. But it does not necessarily always need to be response time. You might have a SQL statement that gets executed millions (or billions) of times, and hence perhaps parse time CPU or overall latching activity might be a critical factor.

My point is this: Not all SQL statements can be simply judged on a rule of “less consistent gets = a better SQL”. Here’s an example that came up on AskTOM recently, hence the click bait title. I’ll start with 100 copies of DBA_OBJECTS to be my source table.


SQL> create table t pctfree 0
  2  as select owner, object_id, subobject_name
  3  from dba_objects,
  4       ( select 1 from dual connect by level <= 100 );

Table created.

SQL>
SQL> exec dbms_stats.gather_table_stats('','t');

PL/SQL procedure successfully completed.

We’ll connect to SQL Plus and just run a simple SELECT to retrieve all of the rows.


SQL> set autotrace traceonly statistics
SQL> select * from t;

8350600 rows selected.


Statistics
------------------------------------------------------
         13  recursive calls
         17  db block gets
     849818  consistent gets
          1  physical reads
       3024  redo size
  294152578  bytes sent via SQL*Net to client
    9186257  bytes received via SQL*Net from client
     835061  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
    8350600  rows processed

Wow…that’s a lot of consistent gets. Here’s my simple solution to reduce that. We’ll just an ORDER BY clause!


SQL> select * from t order by object_id;

8350600 rows selected.


Statistics
-------------------------------------------------------
        170  recursive calls
          4  db block gets
      16469  consistent gets
      21597  physical reads
          0  redo size
  201757283  bytes sent via SQL*Net to client
    9186257  bytes received via SQL*Net from client
     835061  SQL*Net roundtrips to/from client
          0  sorts (memory)
          1  sorts (disk)
    8350600  rows processed

Woo hoo! Look how much I’ve dropped the consistent gets. Time for me to scream from the roof tops “I am a SQL tuning genius!” Smile

In reality, I don’t need an ORDER BY to improve the “consistent gets” number from the SELECT statement.  One of the governing factors for how many consistent gets we will need to do is the fetch size, and my original execution was performed with a fetch size (arraysize in SQL Plus) of just 10. Let’s bump that up and re-run the query:


SQL> set arraysize 1000
SQL> select * from t;

8350600 rows selected.


Statistics
------------------------------------------------------
          0  recursive calls
          0  db block gets
      24805  consistent gets
          0  physical reads
          0  redo size
  133771032  bytes sent via SQL*Net to client
      92458  bytes received via SQL*Net from client
       8352  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
    8350600  rows processed

Voila! An easy “fix” to consistent gets.  In reality, don’t forget that consistent gets is just one piece of the performance performance puzzle. If I throw in some response time metrics for the above queries, then (as an application user) I know which query I would prefer to have running!


SQL> set autotrace off
SQL> set timing on
SQL> set feedback only
SQL> select * from t;

8350600 rows selected.

Elapsed: 00:00:02.08
SQL> select * from t order by object_id;

8350600 rows selected.

Elapsed: 00:00:09.70
SQL>

So, click bait titles aside, make sure you don’t get too carried away just focussing on particular metrics (eg consistent gets) when assessing and tuning the performance of your SQL statements.

connor_mc_d's picture

Interval versus Range partitions

One of the nice things about partitioning in the database is that partition pruning can quickly eliminate the requirement to read large amounts of data when the partitioning key(s) are appropriately provided in your queries (and DML). This also extends to queries where the values provided do not map to any partitions.

Here’s a simple example of a range partitioned table which only cover the values from (less than) 1 to a ceiling of 6.



SQL> create table t
  2  partition by range(x)
  3  ( partition p0 values less than (1),
  4    partition p1 values less than (2),
  5    partition p2 values less than (3),
  6    partition p3 values less than (4),
  7    partition p4 values less than (5),
  8    partition p5 values less than (6)
  9  )
 10  as
 11  select rownum x from dual connect by level <= 5;

Table created.

Let’s see what happens when I run a query for a value that by definition cannot possibly exist in the table.



SQL> select * from t where x = 1235;

no rows selected

SQL> select * from table(dbms_xplan.display_cursor);

PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------------------
SQL_ID  auv890vfz95vu, child number 0
-------------------------------------
select * from t where x = 1235

Plan hash value: 4294331813

----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |       |       |     2 (100)|          |       |       |
|   1 |  PARTITION RANGE EMPTY|      |     1 |     3 |     2   (0)| 00:00:01 |INVALID|INVALID|
|*  2 |   TABLE ACCESS FULL   | T    |     1 |     3 |     2   (0)| 00:00:01 |INVALID|INVALID|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter("X"=1235)

That’s pretty cool. You can see that terms “EMPTY” and “INVALID” in the plan. The database knows from the dictionary definitions of the partitions that there is no possible data for X=1235 and hence the table partitions do not need to be accessed at all.

I’ll now repeat the example, but using an INTERVAL partitioned table. I only need to define the first partition, but since the interval size is 1, it will create partitions identical to the range example above.



SQL> create table t
  2  partition by range(x) interval(1)
  3  ( partition p0 values less than (1) )
  4  as
  5  select rownum x from dual connect by level <= 5;

Table created.

SQL>
SQL> select * from t where x = 1235;

no rows selected

SQL> select * from table(dbms_xplan.display_cursor);

PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------------------
SQL_ID  auv890vfz95vu, child number 0
-------------------------------------
select * from t where x = 1235

Plan hash value: 2931986080

-----------------------------------------------------------------------------------------------
| Id  | Operation              | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT       |      |       |       |     6 (100)|          |       |       |
|   1 |  PARTITION RANGE SINGLE|      |     1 |     3 |     6   (0)| 00:00:01 |  1236 |  1236 |
|*  2 |   TABLE ACCESS FULL    | T    |     1 |     3 |     6   (0)| 00:00:01 |  1236 |  1236 |
-----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter("X"=1235)

Notice that the results here are slightly different. Even though no partition exists for X=1235, for an interval partitioned table the optimizer suggests that it will scan the (fictitious) partition 1236. Is this a bug?

To explain this, I like to think of interval partitioning as an extension of the deferred segment implementation we already have in the database. The database can defer creating a physical segment when a table (or table partition) is created. The segment only needs to come into existence when the first row is created for that table. The way I interpret interval partitioning, is that it takes deferring segments to another level, namely deferring the dictionary metadata as well until it is needed. You can think of interval partition table DDL as creating all of the partitions in the table immediately (ie, they all exist) but the dictionary metadata to support them is deferred until required. Hence partition 1236 in the example does indeed exist – it is just that we have not yet created the dictionary entries for it yet – we won’t do so until the first row is created.

Based on this concept, you can still see the concept of EMPTY/INVALID partitions for a query on an interval partitioned table if you nominate a value that would yield a non-existent partition. You may be thinking “How can we have a non-existent partition for an interval partitioned table?”. Don’t forget that there is an upper limit on the number of partitions you can have for any partitioned table, so all I need do is nominate a value for X that would yield a partition above that upper bound.



SQL> select * from t where x = 1235123123;

no rows selected

SQL> select * from table(dbms_xplan.display_cursor);

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------
SQL_ID  dfthyzy792fah, child number 0
-------------------------------------
select * from t where x = 1235123123

Plan hash value: 4294331813

----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |       |       |     2 (100)|          |       |       |
|   1 |  PARTITION RANGE EMPTY|      |     1 |     3 |     2   (0)| 00:00:01 |INVALID|INVALID|
|*  2 |   TABLE ACCESS FULL   | T    |     1 |     3 |     2   (0)| 00:00:01 |INVALID|INVALID|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter("X"=1235123123)

Richard Foote's picture

FIRST_ROWS_10 CBO Is Hopeless, It’s Using The Wrong Index !! (Weeping Wall)

There’s an organisation I had been dealing with on and off over the years who were having all sorts of issues with their Siebel System and who were totally convinced their performance issues were due directly to being forced to use the FIRST_ROWS_10 optimizer. I’ve attempted on a number of occasions to explain that their […]

Jonathan Lewis's picture

UKOUG Tech 18

One month to go before the big event in Liverpool. so I’ve been browsing the agenda to get some idea of the talks I’ll probably go to. At present this is what my list looksl like:

Sunday

14:00	Database block checking - the unknown truth
15:00	TBD
16:10	Oracle Database 12c consolidation: why and how to manage CPU resources
17:10	Securefiles - the hidden storage organisation inside LOB segments

Monday

 9:00	The Optimizer & the road to the latest generation of the Oracle database
11:20	Making Materialized View great again	
11:50	Winning performance challenges in Oracle Multitenant
13:35	Struggling with Statistics (ME)
16:15	Constraint Optimization (or the difference one comma makes)
17:10	TBD

Tuesday

 9:00	The basics of understanding Execution Plans (ME - double session)
11:40	Dissecting SQL Plan Management Options
12:35	Cost Based Optimsation - The round table (ME)
14:25	Single Row vs. the Array Interface vs. Parallelism
15:20	Cost Based Optimisation - The Panel (ME & several others)
16:35	Declarative Constraints - Features and Performance impact
17:05	Oracle SQL Developer - Everything you need to know about tuning

Wednesday

 9:00	Successful Star Schemas
 9:55	Hardening the Oracle database
11:40	Tracing parallel execution
12:35	Advanced RAC programming features
14:25	TBD
15:20	Pitfalls and Surprises with dbms_stats; how to solve them

I reserve the right to change my mind on the day, of course, since the competition is strong – and I may get wrapped up in conversations with other attendees and not notice the time passing.

morten's picture

From production to test in a minute

How to create test data just like your production data without moving or copying your actual data.

morten's picture

From production to test in a minute

How to create test data just like your production data without moving or copying your actual data.

connor_mc_d's picture

The Openworld Mega-Download!

If you are sad and pathetic enthusiastic and interested in content like me, once a large conference like OpenWorld is over, I like to have the content (slides etc ) from not just the sessions I attended, but all of the sessions I could not attend. In fact, I typically would like to have any and all available content, because that is probably the next best thing to attending the conference.

In particular, now that many of the sessions are streamed and/or capture for on-demand replay, either on the OpenWorld site directly, or via the Oracle Developers Youtube channel, the slides can then be viewed along with the presentation that drove them.

Unfortunately, the session catalog does not really cater to that need. It is very much focussed along a mantra of “pick a single session”, and then you can download the content for just that session.

If you want lots of content, then no-one wants to click and expand and download, click and expand and download, click and expand and download, click and expand and download etc etc.

oow_download

So the full stack developer is back with a vengeance Smile to give you the full suite of content easily available at your fingertips!

I swept through the JSON and extracted all of the files I could find.

So here is a script that will use CURL to download all of the content, or you can pick and choose from the list below.

Enjoy!

OpenWorld (scroll down for CodeOne)

BOF4977 A Cloud- and Container-Based Approach to Microservices-Powered Workflows,Lucas Jellema
BOF5232 Introducing Agile into the US Air Force in 12 Parsecs or Less,Bob Larsen
BOF5714 Istio and Envoy: Enabling Sidecars for Microservices,Angela Chin
BOF6086 Accelerating Big Data Analytics on Oracle Cloud,Khun Ban
BQS3994 Assessing the Security of the Cloud: What You Should Ask Your Vendors,Jari Peters
BQS4133 Burning Questions for PeopleSoft Executive Management,Marc Weintraub
BQS4730 Strategy and Insights from the Oracle Linux and Oracle VM Product Management Team,Avi Miller
BQS4900 How to Diagnose Issues in the Cloud,Scott Oaks
BQS5533 Hyperscale Oracle Database: Extreme Scaling without the Compromises,Tirthankar Lahiri
BQS6486 A Holistic Approach to Harnessing IoT, AI, and Blockchain Technologies for Retail,Anant Kadiyala
BQS6487 The Digital World Is Bigger Than You Think, and on Your Doorstep Right Now,Gerald Poncet
BQS6964 Your Finance Cloud End User Adoption and Enablement Starts Here ,D.J. Hoelscher
BQS6967 Your Finance Cloud End User Adoption and Enablement Starts Here,D.J. Hoelscher
BUS1145 Automate Fee Schedule Setup/Reduce Revenue Leakage: Oracle Revenue Management and Billing,Warren Elizer
BUS1179 Legal Requirements of Cloud Financials in Latin America,Gustavo Gonzalez
BUS1216 The Journey to Oracle Exadata and Oracle Autonomous Data Warehouse,Reiner Zimmermann
BUS1217 Customer Panel: Oracle Autonomous Data Warehouse,Reiner Zimmermann
BUS1224 DBA Does Docker,Timothy Hall
BUS1467 Demystifying Life Sciences and Healthcare Revenue Management in the Cloud Marketplace,Muhammad Ali Arshad
BUS1478 RE/MAX: A Real Estate Services Company Refines Business Processes with Oracle ERP Cloud,Sheri Ortlieb
BUS1801 Citi’s Nonstrategic Spend Optimization Utilizing Amazon Business,Yoim Kim
BUS1813 Implementing Highly Complex Supply Chain Planning Process at Bloom Energy,Manoj Rathi
BUS1845 Data and Application Modeling in the Brave New World of Oracle Sharding,John Kanagaraj
BUS1891 Using Deep Learning and Neural Networks in Oracle Database 18c,Brendan Tierney
BUS2002 Oracle Database Security in the Cloud,Michelle Malcher
BUS2099 Unleashing the Potential of the Digital Circular Economy Using Blockchain,Irina Hergenroether
BUS2128 Thrive with Microservices Using DevOps in Oracle Cloud,Sai Janakiram Penumuru
BUS2269 Award-Winning Cloud-Based Real-Time Tax Analytics Built on Oracle PaaS,Andrew Bohnet
BUS2272 Implementing a Low TCO Poly-Cloud Microservices Solution with Oracle Cloud,Lucas Jellema
BUS2470 Ignite Your Brand on Oracle Cloud,Mohamed Khairy
BUS2488 Making the Case for Oracle EPM Cloud and JD Edwards,David Spaker
BUS2668 Payments Transformation for Customer Centricity and Operational Efficiency,Tushar Chitra
BUS2703 Digital Collections: Reduce Costs, Retain Customers, and Maintain Compliance,Aubrey Hawes
BUS2708 Perfecting Digital Engagement and Defying Customer Attrition,Tushar Chitra
BUS2793 Real-World Cloud,Ron Zapar
BUS3017 Achieving Massive Scalability and Total Fault Isolation Through Oracle Sharding ,Tariq Farooq
BUS3231 Three Easy Ways to Migrate to the Cloud,Francisco Munoz Alvarez
BUS3400 Oracle Enterprise Data Management Cloud Service: The Master Data Solution,Tracy McMullen
BUS3411 Rise of the Bot Army with Oracle Mobile Cloud Enterprise,Jason Lamon
BUS3433 How Megaport and SmartDog Services Enable Oracle Network Cloud Service – FastConnect,Sushil Motwani
BUS3768 Maximize Database Performance and Efficiency on Oracle ZFS Storage Appliance,Scott Ledbetter
BUS3769 Engineering Insight into Accelerating Your Data Protection Strategy,Erik Benner
BUS3770 Transforming Data Management and Migration in the Global Data Center,Cindy Swearingen
BUS3771 Simplifying Multiple System Management in a Complex World,Joe Murphy
BUS3774 The State of Cloud Security: Keeping Pace at Scale,Greg Jensen
BUS3892 Going Beyond a Complete SaaS Suite: Why This Matters to Your Business,Yaldah Hakim Rashid
BUS3925 Improved Business Outcomes: Moving from Oracle Hyperion to Oracle EPM Cloud,Jennifer Toomey
BUS3927 The Future of Finance and How to Get Ahead of It with Oracle ERP Cloud,Lori Culp
BUS3928 Tomorrow’s ERP, Today: The Last Upgrade You’ll Ever Need ,Steve Cox
BUS3929 The Cloud Question Is How: Baby Steps Toward Transformation,Ankur Gupta
BUS3931 Better Together: Connect Front and Back Office to Run Tomorrow’s CX Today,Joe Fuster
BUS3937 Continuous Performance Management Using Oracle HCM Cloud,Christine Yokoi
BUS3974 Oracle’s Journey to the Cloud,Paolo Juvara
BUS3975 Oracle ERP Cloud at Oracle,Alex SanJuan
BUS3976 Oracle HCM Cloud at Oracle,Anje Dodson
BUS3999 Optimize Your Logistics with Oracle Cloud,Joan Lim
BUS4228 Fast-Track Your Business Transformation with Oracle Database Cloud Service,Sai Janakiram Penumuru
BUS4254 Use Data Science to Fight Fraud, Strengthen Security with ERP Advanced Controls,Siddharth Sinha
BUS4257 Deep Learning 101 for Non–Data Scientists,Peter Jeffcock
BUS4259 Streaming Data and Big Data Together to Discover, Predict, and Prescribe,Peter Jeffcock
BUS4264 Big Data, Personally Identifiable Information, GDPR, Machine Learning, and the Cloud ,Marcos Arancibia Coddou
BUS4585 Architecting Your Future: Planning Your Journey to the Cloud,John Hagerty
BUS4591 Making Enterprise Blockchain a Reality: Oracle Blockchain Cloud Service Use Cases ,Mark Rakhmilevich
BUS4593 Extend Enterprise Boundaries: Use Blockchain to Link Across Organizations,Deepak Goel
BUS4596 Why Oracle Applications Run Best on Oracle Cloud Infrastructure,Souji Madhurapantula
BUS4633 Enterprise IT Strategies: Supporting and Scaling AI Development,Colin Schmidt
BUS4826 Blockchain, IoT, and AI: Driving Business Value Across the Enterprise,Rajan Krishnan
BUS4927 Which Path is Right for You: Understanding Your Paths to Oracle Cloud,Mary Melgaard
BUS5494 Break Down Barriers with DevOps to Accelerate Innovation,Suraj Krishnan
BUS5498 Make the Most of Your Oracle Cloud at Customer Investment ,Nenad Rozic
BUS5514 Embrace Oracle Autonomous Database Cloud and Accelerate Adoption,Nenad Rozic
BUS5552 Protect Your Business and Your Data with Oracle Managed Security Services ,Joe Finlinson
BUS5558 The Forgotten Necessities: Complementing SaaS with PaaS,Srivatsan Santhanam
BUS5732 How to Successfully Navigate Your Path to SaaS in the Public Sector,Jeff Kane
BUS5737 Leverage Oracle Cloud Infrastructure, Applications, and Oracle Premier Support ,AJIT BARSODE
BUS5767 Oracle and Blockchain: Driving Innovation with Disruptive Technology ,Rajesh Dasari
BUS5771 Building Innovative Industry Solutions with Chatbots and Machine Learning,Edward Zou
BUS5833 Is Your Brand Safe?,Kurt Kratchman
BUS5869 Focus on What Matters Most for HR Professionals with Oracle Analytics,Manisha Gupta
BUS6207 The Future of AI in Marketing,Navin Boddu
BUS6248 The Next Generation of Citizen Experiences: Using Emerging Technologies,Franco Amalfi
BUS6291 IFRS 9: Moving Toward Business as Usual in the Postimplementation Era,Joseph Agius
BUS6444 Transitioning to the Digital World: Challenges and Opportunities,Brendan Logan
BUS6472 Grid Model Data Management in the New Distribution World,Brad Williams
BUS6488 In Consumer Markets, IoT, AI, and Blockchain Technologies Have Their Day: It’s NOW,C Prasanna Venkatesan
BUS6493 Automotive Suppliers Industry Maps Its Path to the Cloud,Pat Mariles
BUS6495 Lean Manufacturing for the Cloud,Scott Renner
BUS6496 Will Blockchain Transform Your Digital Supply Chain?,Swapan Ghosh
BUS6528 Improving Manufacturing Operations Through World-Class Partnerships,Eric Prevost
BUS6552 Managing Cloud and On-Premise ERP Fraud and Cyber Risk ,Nicholas Seeman
BUS6583 Oracle’s New SaaS Support Services Offering Is An Industry Game-Changer,Alex Steinhart
BUS6606 Milaha Adopts Oracle ERP Cloud for Digital Transformation ,Adnan Al Banna
BUS6607 Letting Intelligent Automation Take Flight,Marcus Murph
BUS6612 Business in Front, Party in Back: A Business Case for Success in the Cloud,Michael Windham
BUS6659 Conquer Challenges in Fleet Management with Oracle Internet of Things Cloud Service,Richard Laflamme
BUS6732 Secure Your IT Services with Oracle Managed Identity Cloud Service,Leonid Stavnitser
BUS6786 You’ve Implemented Oracle ERP Cloud: Now What?,Cameron Armbruster
BUS6809 Boost the Finance Organization’s Capability and Maturity with Digital Tools,Ralph Barone
BUS6873 How FinTechs Are Accelerating the Path to Digitization,Sanjay Mathew
BUS6901 Top three ways for modernizing Data workloads with Oracle and Lenovo,Michele Resta
BUS6944 The New IT Challenge: Adapting to a Hybrid, Multicloud Environment,Siddhartha Agarwal
CAS1065 Transform Your Business Applications with an Oracle E-Business Suite 12.2.6 Upgrade ,Mandar Ghosalkar
CAS1083 Automated Data Acquisition via JD Edwards EnterpriseOne Internet of Things Orchestrator,Wilker Costa
CAS1122 Enterprise Financial Planning with Oracle Enterprise Planning and Budgeting Cloud Service,Bill Roy
CAS1151 Next-Generation Oracle Platform for American Airlines Sales and Loyalty Systems,Reza Abouk
CAS1248 Oracle Application Express Applications on Oracle Database Exadata Express Cloud Service,Roel Hartman
CAS1257 A CX Worthy of Your Brand: Oracle Service Cloud/Oracle Field Service Cloud Service,Traci Scott
CAS1257 A CX Worthy of Your Brand: Oracle Service Cloud/Oracle Field Service Cloud Service,Traci Scott
CAS1300 Master Lock’s Success: Oracle E-Business Suite to Oracle Cloud Infrastructure,Shrikant Ektare
CAS1307 Wind Tre Unifies Business Processes and Ensures Efficient Finance Systems,ROBERT HENDRIK JOHANNES VISSER
CAS1315 Research Analytics at Scale: CERN’s Experience with Oracle’s Cloud Solutions,Eric Grancher
CAS1316 Security: Your Guide to Hardening Your Database Based on the CIS Standard,Joseph Testa
CAS1324 Implementing Driver-Based Rolling Forecasts at MD Anderson ,Nandini Nehru
CAS1385 Using Oracle Identity Cloud Service and Oracle API Platform Cloud Service at Co-op ,Luis Weir
CAS1395 Enabling Blockchain for Your Enterprise Apps: A Practical Guide,Moses Rajan
CAS1395 Enabling Blockchain for Your Enterprise Apps: A Practical Guide,Moses Rajan
CAS1395 Enabling Blockchain for Your Enterprise Apps: A Practical Guide,Moses Rajan
CAS1407 Customer Panel: How to Successfully Migrate to the Cloud ,Peter Schutt
CAS1437 Oracle Planning and Budgeting Cloud Service Revenue Forecasting by Cohorts,Cindy Eichner
CAS1438 Moving PeopleSoft to Oracle Cloud: A City’s Experience,Andrew Beck
CAS1449 Wells Fargo Bank: Protecting Data Using Oracle Database Vault,Michael Anderson
CAS1458 Happily Ever After: ODTUG and Oracle Planning and Budgeting Cloud Service,Gary Crisci
CAS1468 Oracle Cloud at Customer: Have It Your Way,Srini Chavali
CAS1470 Oracle Cloud at Customer: Hear from Customers,Alexander Doubek
CAS1525 Migrating from AWS to Oracle Cloud Infrastructure ,Phil Brown
CAS1575 T-Mobile’s Journey to Oracle Management Cloud,Sreekanth Chintala
CAS1575 T-Mobile’s Journey to Oracle Management Cloud,Sreekanth Chintala
CAS1628 Wells Fargo Streamlined Patching and Deployment with RHP Framework Automation,Michael Sukhenko
CAS1645 Successful Cloud Payroll Administration Dos and Don’ts,Rhonda Dixon
CAS1651 Oracle E-Business Suite on Oracle Cloud Infrastructure,Oleg Pyatnychko
CAS1664 Maritz Migration to Modernization: Oracle E-Business Suite from On-Premises to the Cloud,Alyssa Johnson
CAS1671 Moreton Bay Technology Migrates from MS SQL to Oracle Cloud,Peter Hawken
CAS1711 Charles Taylor Transforms a European Insurer’s Business Process with Oracle PaaS,Vikas Sharma
CAS1750 Cox Automotive Moves Mission-Critical Workloads to Oracle Cloud Infrastructure ,David Johnson
CAS1751 Cox Automotive Improves Hybrid and Multicloud Monitoring with Oracle Management Cloud,Maaz Anjum
CAS1751 Cox Automotive Improves Hybrid and Multicloud Monitoring with Oracle Management Cloud,Maaz Anjum
CAS1775 Maritz: Architecting an Oracle E-Business Suite Lift and Shift to Oracle Cloud,Todd Sheetz
CAS1896 Chatbots for Improving Communication Between Citizens and Public Services,Ruben Rodriguez Santiago
CAS1943 Best Practices for Oracle SaaS Upgrade: Capgemini ,Robert Barocas
CAS2016 Boosting Complex IoT Analysis with Oracle Autonomous Data Warehouse,Manuel Martin Marquez
CAS2017 Oracle E-Business Suite R12.2 on Oracle Database Exadata Cloud Service ,Manjunath Kempanna
CAS2041 Orange Embraces Digital Transformation, Powers Essentials 2020 with Oracle ERP Cloud,Elisabeth Landron
CAS2053 Gonzaga Moves Student Workloads to Oracle Cloud to Reduce Cost and Enable Agility,Santosh Bhatt
CAS2084 Delivering Private Database as a Service Using Oracle Exadata Cloud at Customer,John Andrew Prabaharan
CAS2125 Healthcare HCM Transformation: Led and Enabled by Disruptive Cloud Technology,Rattan Singh
CAS2133 Critical, Large-Scale Disaster Recovery with Oracle Cloud Infrastructure,Todd Sheetz
CAS2139 A JD Edwards EnterpriseOne UX One Case Study: The Perfect Partner to Classic Applications,Kyudong Shim
CAS2151 Nidec: Oracle E-Business Suite to Oracle Cloud to Prepare for a Single Global Instance,Rao Mettu
CAS2155 JD Edwards Platform Adoption Success Story for Growth and Unlocking Business Value,Nitin Narkhede
CAS2183 The American Red Cross: Architecting for Emergency Response,Ravi Mani
CAS2251 Proactively Resolving Postbank’s Private Cloud Issues Using Oracle Cluster Health Advisor,Jens-Christian Pokolm
CAS2309 No Cloud, No Gas or Hot Dogs,Olle Sundberg
CAS2349 Oracle Policy Automation: Changing the Sales and Services Landscape,Ashish Goyal
CAS2485 Oracle Fleet Management: Patch and Upgrade Your Database,Gary Henderson
CAS2518 Innovative Performance Management at Deutsche Bahn in a New Cloud Era,Roman Helmer
CAS2583 How Digital Transformation Elevates Human Capital Management,Eugenio Giannotte
CAS2618 How a Mobile Payment Company Profits from Oracle Autonomous Data Warehouse,Holger Friedrich
CAS2648 Truckloads of Compensation at Great Dane,Daniel Valencia
CAS2709 How to Build an Analytics (EPM/BI) Business Case When the Future Is Cloudy,Kirby Lunger
CAS2719 Integrating JD Edwards and Oracle Financial Consolidation and Close Cloud Service,Seth Chaikin
CAS2735 Reduce Oracle E-Business Suite 12.2 Upgrade Downtime with Performance Tuning,Ahmed Alomari
CAS2795 Park Hotels & Resorts’ Journey to the Cloud,Darren Robb
CAS2810 Leading Practices Out-of-the-Box: Oracle Enterprise Planning and Budgeting Cloud Service,James Kubik
CAS2839 Drive Benefits of Oracle E-Business Suite R12.2.6: Federal Health and Defense Sectors,Colin Hartnett
CAS2875 Robotic Process Automation: Bots Have Arrived, Are They Helping You?,Hrishikesh Valsangkar
CAS2924 Wells Enterprises’ Oracle HCM Cloud Transformation: Happy Birthday,Deron Stoecklein
CAS2953 Henkels & McCoy’s Journey to the Cloud,Ken Fontenot
CAS3011 Two Years into an Oracle Financial Consolidation and Close Cloud Service Implementation,Kevin Hebbel
CAS3087 Oracle EPM Cloud in Real Life: Four Real-World Cloud Migration Case Studies,Bobby Ellis
CAS3191 Acquisitions, Integration, and Growth: Transformation Driven by Oracle Cloud,Gregory Chandler
CAS3227 Vitamix: A Blend of Many Oracle EPM Cloud Applications and More to Come,Vatsal Gaonkar
CAS3428 Upgrading to Oracle Database 12.2 in the Cloud: Tales from the Battlefield,michael Gangler
CAS3517 The ARRIS Transformation Story: An HCM Journey to the Cloud,Heidi Yates
CAS3542 Active Directory Integration and Single Sign-On for Oracle Analytics Cloud,Becky Wagner
CAS3614 FedEx Hybrid Cloud Integration Strategy ,Michael Bunney
CAS3677 Autonomous Data Warehousing in the Real World: A Case Study,Dan Vlamis
CAS3705 The UK’S First Public Sector Complete Oracle Cloud Go-Live: ERPM, HCM, Payroll,Umang Nahata
CAS3707 Converting from PeopleSoft to the Cloud: The Yum! Brand’s Experience,Chris Costakes
CAS3749 Oracle Cloud Implementation Case Study for Oil and Gas Industry,Howard Glanville
CAS3811 Managing Product Lifecycle Complexities in Pharma,Subbu Panigrahi
CAS3845 Requirements to Configuration: A Step-by-Step Approach to Oracle HCM Cloud Security,Anthony Martelloni
CAS3896 DevOps: Oracle SOA, Oracle WebLogic, Oracle Integration Cloud, Oracle Java Cloud Service,Dan Goerdt
CAS3924 Guidewire: Oracle ERP Cloud Helps an Insurance Software Provider Streamline Operations ,Saket Srivastava
CAS3942 Using Oracle Cloud Applications to Augment On-Premises Applications,Karl Martineau
CAS3956 Case Study: Pegasus Airlines,Haluk YUZUCU
CAS3958 Exadata Emerges as a Key Element of Six Journeys to the Cloud: Customer Stories,David Sivick
CAS3959 Finding Success with Oracle Cloud at Customer: Key Customer Stories and Best Practices,Holger Mueller
CAS3960 Governments Adopt Oracle Cloud at Customer in Their Journey to the Cloud,Michael Sherwood
CAS3961 Unleash the Power of Your Data with Oracle Exadata Cloud at Customer ,Vishal Mehta
CAS3962 Customer Perspectives on Business Value Gains with Oracle Database Appliance,Nancy Swanson
CAS3986 Database Fleet Journey to the Cloud,Gary Gordhamer
CAS4007 Multitenant: Customer Panel,John Nagel
CAS4027 SAP on Oracle Cloud Infrastructure and Cintra deliver extreme performance for top retailer,Juergen Mueller
CAS4042 Zero Downtime Upgrade of Core Banking Systems with Edition-Based Redefinition,Martin Buechi
CAS4060 Oracle’s Data Platform: Customer Panel,Julien Testut
CAS4060 Oracle’s Data Platform: Customer Panel,Julien Testut
CAS4134 Oracle Cloud Infrastructure: A Platform and a Path to the Cloud for JD Edwards,Manish Somani
CAS4142 How Trek Bicycle Successfully Upgraded JD Edwards 9.1 to 9.2 in 100 Days,Joel Stewart
CAS4154 Customers Succeed with Oracle ERP Cloud,Kevin Johnson
CAS4157 IaaS Transforms JD Edwards Customers,Christina Yue
CAS4167 Textron Inc: An Advanced Technologies Conglomerate Integrates Oracle ERP Cloud,Steven Reeter
CAS4170 Oracle Cloud: The Who, What, When, Where, and Why ,Luke Hodges
CAS4171 Hindsight is 20/20: Insight from Oracle Cloud Customers ,Christina Yue
CAS4237 Customer-Centric Digital Transformation,Joe Fuster
CAS4276 Connect and Extend ERP and Supply Chain with Oracle Cloud Platform Services,Jon Huang
CAS4287 How to Become a Big Data Hero: Success Stories,Aali Masood
CAS4288 The Right Stuff: How to Manage Your Cloud Implementation,Nicole Oeser
CAS4312 185-Year-Old Startup,Ralf Dossmann
CAS4317 Customers Using Analytics and Insight in PeopleSoft ERP,Amira Morcos
CAS4318 Customers Using Personalization, Configuration, Customization in PeopleSoft ERP,Joe Willever
CAS4319 Customers Using Selective Adoption in PeopleSoft ERP,Joe Finlinson
CAS4322 Customers Using Personalization, Configuration, Customization in PeopleSoft HCM,Arkalgud Venkatesh
CAS4392 How OptumRX is Using Oracle API Platform Cloud Service to Achieve API Success,Murali Palanisamy
CAS4433 Customers Using the Modern User Experience of PeopleSoft,Matthew Haavisto
CAS4433 Customers Using the Modern User Experience of PeopleSoft,Matthew Haavisto
CAS4435 Customers Using Analytics and Insight in PeopleSoft,Matthew Haavisto
CAS4436 Customers Using Personalization, Configuration, Customization in PeopleSoft ,Greg Kelly
CAS4438 Customers Using Oracle Cloud for PeopleSoft,David Bain
CAS4461 Learn How to Fuel Growth with Successful Zero-Based Budgeting,Scott Leshinski
CAS4463 Migrating On-Premises Planning to the Cloud and Making It Look Easy,Scott Costello
CAS4501 How Rabobank Is Using Oracle API Platform Cloud Service to Achieve API Success,Deepak Arora
CAS4503 How RTD, Connexions, and Graco Are Using Oracle API Platform Cloud Service,Lonneke Dikmans
CAS4516 Business-Led Integration Is Finally Here with Self-Service Integration,Jonathan Hult
CAS4519 Oracle Managed File Transfer Overview, Customer Case Studies, and Best Practices,Scott Haaland
CAS4565 Customer Successes with Oracle Project Portfolio Management Cloud,Kazim Isfahani
CAS4602 MySQL at Booking.com,Simon Mudd
CAS4606 How Facebook Got Consistency with MySQL in the Cloud,Sam Dunster
CAS4607 MySQL at Github: Handling Schema Changes,Jonah Berquist
CAS4609 MySQL with ProxySQL at Shopify,Rene’ Cannao’
CAS4611 How Wells Fargo Accelerates HR Innovation and Compliance with the Cloud,Brian Boyd
CAS4636 Protect Cloud Data with Oracle CASB Cloud Service,Chet Sharrar
CAS4641 Develop Solutions with Oracle Content and Experience Cloud,Jason Stortz
CAS4677 Mutua Madrid Open and Its Oracle Intelligent Bots ,Gerard Tsobanian
CAS4728 Optimizing and Automating Your Oracle VM Deployments,John Priest
CAS4761 Choosing Your SaaS Path: Success Stories from City of Memphis and Choctaw Nation,Jeff Kane
CAS4767 Oracle Supply Chain Planning Cloud: Customer Leadership Panel,Moshin Lee
CAS4767 Oracle Supply Chain Planning Cloud: Customer Leadership Panel,Moshin Lee
CAS4785 Oracle Manufacturing Cloud and Oracle Maintenance Cloud Customer Panel,Adam Brooks
CAS4831 A CISO’s Path to Success in the Age of Cybersecurity,Fabio Gianotti
CAS4877 American Red Cross Modernizes Disaster Relief with Oracle Integration Cloud,Susan Gorecki
CAS4917 Get Started with Oracle Analytics Cloud,Jae Lee
CAS4919 Migrating Oracle E-Business Suite from AIX to Exadata in New Data Center in Seven Months,Chris Martin
CAS4919 Migrating Oracle E-Business Suite from AIX to Exadata in New Data Center in Seven Months,Chris Martin
CAS5088 Perform In-Place Upgrade for Large-Scale Cloud Infrastructure ,Jeff Savit
CAS5215 Oracle Integration Cloud Best Practices Panel: Transforming to Hybrid Cloud,Chad Ulland
CAS5230 Tips and Tricks for Oracle SOA Cloud Service Integration: Customer Panel,David VanWiggeren
CAS5457 Digital Supply Chain: Transportation and Global Trade Management ,Cormac Lynch
CAS5474 Digital Supply Chain: Oracle Warehouse Management Cloud Service,Dhruba Misra
CAS5476 Digital Supply Chain: Oracle’s Internal Order-to-Cash Digital Transformation,Rajat Bhargav
CAS5520 Seize the Day: Accelerate and Optimize Business Cloud Adoption,Phil Sidebotham
CAS5554 Oracle’s Applications Unlimited Products Are Thriving in the Cloud ,Neeraj Verma
CAS5560 Moving Siebel Loyalty to Oracle Cloud Infrastructure: A Smiles S.A. Case Study,Ana paula Mussel
CAS5562 Moving PeopleSoft to Oracle Cloud Infrastructure: A Vale S.A. Case Study,Ana paula Mussel
CAS5691 Oracle Integration Cloud Customer Panel: Real-World Digital Transformation Uses Cases ,Susan Gorecki
CAS5716 Oracle SOA Suite 12c: Customer Panel,Simone Geib
CAS5727 Kaiser Permanente Transformation: Enabling Business Capabilities with Oracle Cloud,Justin Knoerzer
CAS5743 Siebel CRM Customer Leadership Panel,George Jacob
CAS5744 A Start-to-Finish Case Study of Oracle Autonomous Data Warehouse,JAMES CZUPRYNSKI
CAS5745 Creating Meaningful Customer Experiences to Beat the Competition,Sonia Wadhwa
CAS5745 Creating Meaningful Customer Experiences to Beat the Competition,Sonia Wadhwa
CAS5745 Creating Meaningful Customer Experiences to Beat the Competition,Sonia Wadhwa
CAS5746 Migrate Any Database Workload to Oracle Cloud: Challenge Accepted,Alexis Kolak
CAS5747 Why You Need Manageability Now More than Ever and How to Get It,Gustavo Rene Antunez
CAS5749 The Art of the Possible: Create Your Own User Experience with Open UI,Marc Verbeek
CAS5750 Achieving Modern Agility and Continuous Delivery for Enterprise CRM,Nazeer Shaike
CAS5751 Gaining Industry Advantages with Siebel CRM Innovations,Sonia Wadhwa
CAS5818 Streamline SOX Compliance and Segregation of Duties Using Oracle ERP Cloud ,Aman Desouza
CAS5825 Implement Segregation of Duties Automation Within Weeks Using Oracle ERP Cloud,Barry Greenhut
CAS5827 Implement SOX Certifications Within Weeks Using Oracle ERP Cloud,Swarnali Bag
CAS5845 Vermont Country Store’s Journey to Oracle Commerce Cloud,John Spencer
CAS5847 Customers Present: Financial Close,Tim Gaumont
CAS5851 Customers Present: Performance Reporting,Al Marciante
CAS5853 The Modern Office of the CFO: Shared Tales from On-Premises to the Cloud ,Thomas Borgula
CAS5859 Integrated Business Planning,Hari Sankar
CAS5866 Tax Reform and Finance Transformations: Why CFOs and CIOs Should Pay Attention,Marc Seewald
CAS5868 Customers Present: Oracle Enterprise Planning ,Suren Seshadri
CAS5870 Customers Present: Oracle Profitability and Cost Management Cloud Service,Alecsandra Mlynarzek
CAS5876 Customers Present: EPM in the Public Sector,Al Marciante
CAS5882 Modern Healthcare in Oracle EPM Cloud,Stephen Bowden
CAS5887 Customers Present: Oracle Enterprise Data Management Cloud Service,Thomas Borgula
CAS5888 Customer Panel on Migrating to Oracle EPM Cloud,Al Marciante
CAS5909 High Performance Computing That’s Better Than On-Premises: Real-World Stories,Kash Iftikhar
CAS5910 Modernize Grow to Harvest with Oracle ERP Cloud and Oracle Cloud Platform,Jon Huang
CAS5977 State of Wisconsin Improves Customer Service Through Oracle Cloud at Customer,Gordon Klindt
CAS6164 Hybrid Cloud Deployments and Business Analytics on Oracle Private Cloud Appliance,Sean Donaldson
CAS6165 Oracle Private Cloud Appliance and Pure Storage: An Integrated Disaster Recovery Solution,Krishna Srinivasan
CAS6166 Oracle Private Cloud Appliance and Commvault: Integrated Backup,Sam K Tan
CAS6167 Oracle Private Cloud Appliance: Deploy Your Private Cloud IaaS Out-of-the-Box,Sam K Tan
CAS6178 Western Digital Drives Its Digital Future with Oracle Analytics Cloud,Mauricio Alvarado
CAS6195 Business Transformation Success Story: Oracle Cloud for Higher Education,John Kostecki
CAS6199 Strategic Procurement Case Study,Mike O’Connor
CAS6246 Improving Government Operations with the Cloud,Michael Jamison
CAS6249 Transforming Government Finance with Oracle ERP Cloud: A City of Atlanta Implementation Case Study,Nick Campisi
CAS6333 Journey to the Cloud: Enabling Oracle EPM Cloud for Hilton Grand Vacations ,Rich Wilkie
CAS6368 Driving Banking Digital Innovation with the Oracle Fintech Innovation Program,Sanjay Mathew
CAS6396 You Can Run a US$40 Billion Global Manufacturing/Software Services Company in the Cloud,Giovanni Schoordijk
CAS6397 Small Cities Drive Big Innovation,Celeste O’Dea
CAS6428 5G: How to Get There,Devesh Agarwal
CAS6431 Healthcare Payer Transformation to the Cloud,Thomas Borgula
CAS6443 Enterprise Security: Taming Managed Services,Douglas Tait
CAS6466 Realize Next-Generation EPM with Artificial Intelligence,Scott Rottmann
CAS6475 Accelerating IoT Research and Innovation with Smart Cloud Strategies,David Ebert
CAS6479 Customer Panel: Making Analytics Part of the Fabric of the Business,Jake Krakauer
CAS6547 Leverage Improvements in the Financial Aid Process to Meet Student Expectations ,Raghu Krishnaiah
CAS6556 Digital Supply Network of the Future Powered by Oracle Supply Chain Management Cloud,David St. Germain
CAS6563 Insights into an Integrated HCM Solution: Daimler’s Transformation,Erti Beydilli
CAS6569 IDB Invest Reduces Costs and Spurs Innovation with Oracle Cloud,Diogo Nunes
CAS6576 Network Connectivity: A Critical Success Factor in Enterprise Cloud Migrations,Jim Battenberg
CAS6605 How the Largest County Assessor in the US Is Driving Change with Oracle Cloud ,Kevin Lechner
CAS6610 Covanta Energy’s Successful Migration of PeopleSoft to Cloud Infrastructure,Rajesh Patel
CAS6611 Modern Cloud Analytics: Four Unique Customer Journeys,Jeffrey Jordan
CAS6623 Informatica’s Oracle ERP Cloud and Oracle EPM Cloud Deployment: 31 Countries in 12 Months,Vilma Ranoy
CAS6665 Precision DTMC Achieves Real-Time Manufacturing Using Oracle Cloud,Subhashish Panda
CAS6674 Success Implementing Oracle JavaScript Extension Toolkit, APIs, Microservices at Co-op,Luis Weir
CAS6677 Accelerated Deployment Strategy for Oracle SaaS Cloud,Robert Barocas
CAS6710 Oracle Cloud Infrastructure Hybrid/Multicloud Strategy on Steroids: Network with Equinix,Alex Striffler-Hernandez
CAS6711 Multicloud Applications with Oracle Cloud Infrastructure and Equinix,Bruce Burns
CAS6712 Big Data and Disaster Recovery Infrastructure with Equinix and Oracle Exadata,Claude Robinson III
CAS6956 How Proximus Transforms Sales Through UX Reimagination ,Kurt Van De Moortele
DEV4346 Top 10 Key Performance Techniques for Web and Hybrid Mobile Apps,Mohamed Taman
DEV4867 Serverless, the Future of the Cloud?,Bert Ertman
DEV5059 Using Machine Learning to Make DevSecOps a Reality,Vijay Tatkar
DEV5112 Three Recipes for Container-Native Development in Oracle Cloud,Arturo Viveros
DEV5158 Develop, Build, Deliver, and Run Microservices with Containers in the Cloud,Eugene Fedorenko
DEV5364 Continuous Delivery to Kubernetes with Jenkins and Helm,David Currie
DEV5390 How to Make MySQL Work with Raft,Lixun Peng
DEV5435 Diagnose Your Microservices: OpenTracing/Oracle Application Performance Monitoring Cloud,Marcus Hirt
DEV5541 Top Five MySQL Query Tuning Tips,Janis Griffin
DEV5564 Microservices: Ten Steps to Build, Manage, and Monitor Your Microservices,John Sullivan
DEV5600 Cloud Native Developer Panel: Innovative Startup Use Cases,Bob Quillin
DEV5948 How to Use JSON in MySQL Wrong,Bill Karwin
DEV5957 Develop Python Applications with MySQL Connector/Python,Jesper wisborg Krogh
DEV5959 Python and the MySQL Document Store,Jesper wisborg Krogh
DEV5981 Develop PHP Applications with MySQL X Dev API,David Stokes
DEV5985 MySQL Connector/Node.js and the X DevAPI,Rui Quelhas
DEV5986 Node.js and the MySQL Document Store,Rui Quelhas
DEV5992 How to Take Advantage of Optimizer Improvements in MySQL 8.0,Norvald Ryeng
DEV5994 MySQL at Uber: How to Stream Data with StorageTapper,Ovais Tariq
DEV6073 Modernize Your Existing Applications with Microservices,Sherwood Zern
DEV6078 Service Mesh Patterns on Oracle Cloud Infrastructure Container Engine for Kubernetes,Sherwood Zern
DEV6151 Monitoring Large-Scale Distributed Applications in Oracle Cloud,John Sullivan
GEN3833 Oracle E-Business Suite: Update, Strategy, and Roadmap,Clifford Godwin
GEN3893 Create Tomorrow, Today: Transform into a Connected and Intelligent Business,Mickey North Rizza
GEN3893 Create Tomorrow, Today: Transform into a Connected and Intelligent Business,Mickey North Rizza
GEN4141 PeopleSoft Update and Vision: Ongoing Investment and Long-Term Support,Marc Weintraub
GEN4220 It’s a Whole New World: How Cloud Confident Are You?,Beth Boettcher
GEN4563 Project Management in the Fast-Paced, Data-Driven Enterprise,David Werner
GEN4581 How Oracle Analytics Is Improving Your World,Rich Clayton
GEN4616 Oracle HCM Cloud Customer Panel,Gretchen Alarcon
GEN6198 Tomorrow’s Procurement, Today,Tom Anthony
GEN6212 Digital Marketing Innovations for Crafting Exceptional Experiences,Tony Castiglioni
GEN6251 Create Tomorrow’s Campus Today,Keith Rajecki
GEN6445 Oracle Communications General Session,Douglas Suriano
HOL1703 A Practical Introduction to the MySQL Document Store,Lig Isler-turmelle
HOL1706 Developing Modern Applications with the MySQL Document Store and NodeJS,Lig Isler-turmelle
HOL2986 Using MySQL Common Table Expressions and Window Functions,Lig Isler-turmelle
HOL2988 MySQL 8 High Availability with InnoDB Clusters,Alfredo Kojima
HOL3137 Build a High Availability Solution with Oracle Linux: Corosync/Pacemaker,Jeff Savit
HOL3353 How to Accelerate and Secure Oracle Database and Software Through Silicon,Martin Mueller
HOL3765 Oracle SuperCluster Virtual Assistant,Don O’Malley
HOL3797 The CAT Scan for Oracle Solaris: StatsStore and Web Dashboard,Joost Pronk Van Hoogeveen
HOL4799 Hands-on Lab: The Asynchronous Java Database Access Driver ,Jean De Lavarene
HOL5139 Infrastructure as Code on Oracle Cloud Infrastructure with Terraform,Christophe Pauliat
HOL6281 Design, Create, and Manage APIs for the Digital Economy,Kiran Prabhakar
HOL6283 Lifecycle of Deployments on Oracle WebLogic Server Running in Kubernetes,Maciej Gruszka
HOL6284 Increase the Elasticity of Oracle Java Cloud Service Through Autoscaling,Maciej Gruszka
HOL6285 Oracle Application Container Cloud Service 101 ,Maciej Gruszka
HOL6289 Assess Your Database Security,Judson Williford
HOL6298 Extending and Connecting Applications with Oracle Integration Cloud,Antony Reynolds
HOL6299 Enhance your CX Applications with Oracle Integration Cloud,Antony Reynolds
HOL6308 Enhanced Security for Oracle Cloud: Manage Risk for Oracle Cloud Infrastructure,Eugene Choi
HOL6310 Securing Data in the Cloud with Oracle CASB Cloud Service: Data Protection,Eugene Choi
HOL6312 Hands-on Lab: Oracle Database In-Memory ,Andy Rivenes
HOL6313 Audio Recognition on Oracle Data Science Cloud,Praveen Deshpande
HOL6317 Blazing Fast Interactive Analytics on Cloud Data Lakes ,Praveen Deshpande
HOL6319 Next-Generation OLTP: Oracle TimesTen Scaleout ,Jenny Bloom
HOL6325 Build a Web App with Oracle REST Data Services and Oracle JavaScript Extension Toolkit,Ashley Chen
HOL6329 Python and Oracle Database 18c: Scripting for the Future,Christopher Jones
HOL6332 Query Streams, Data Lakes, and Databases Using Oracle Big Data SQL ,Martin Gubar
HOL6339 Observing and Optimizing Your Application on Oracle Linux with DTrace,Jeff Savit
HOL6340 Provide Zero Downtime Update for Your Cloud Infrastructure ,Christophe Pauliat
HOL6348 Oracle Database 12c, Oracle Database 18c, Oracle Autonomous Database Cloud Performance ,Courtney Llamas
HOL6366 Monitor and Diagnose Your Oracle E-Business Suite Applications,Avi Huber
HOL6371 Oracle Essbase: Scenario and What-If Modeling Made Simple,Ashish Jain
HOL6375 Using Oracle Cloud Infrastructure Container Engine for Kubernetes,Christophe Pauliat
HOL6376 Using Terraform with Oracle Cloud Infrastructure,Christophe Pauliat
HOL6391 Oracle EPM Cloud for Financial Close,Rich Wilkie
HOL6394 Oracle Database 18c: Reliable DevOps with Vagrant, Oracle VM VirtualBox, and Oracle Linux,Gerald Venzl
HOL6448 Oracle EPM Cloud for Account Reconciliation ,Tim Gaumont
HOL6957 Oracle Database 12c, Oracle Database 18c, Oracle Autonomous Database Cloud Performance ,Sreeji Das
MYC6635 Platform/Tech Tools: Platform Enhancement, Testing, and Training Tools,Brian Owenson
MYC6802 Case Study: Migration from Blackline to Oracle Account Reconciliation Cloud Service,Ashwin Tandon
MYC6932 How Oracle ERP Cloud Is Enabling Tomorrow’s Exponential Growth,Gualtiero Biella
PRM3358 Oracle Solaris and SPARC Update: Security, Simplicity, Performance,Masood Heydari
PRM3936 Oracle HCM Cloud Talent Management Product Update,Christine Yokoi
PRM3939 Oracle Talent Acquisition Cloud: Strategy, Roadmap, and Latest Innovations,Ali Moosvi
PRM3963 Oracle Application Development Framework: What’s New and What’s Next,Shay Shmeltzer
PRM4012 Oracle Database In-Memory: Under the Hood, What’s New, What’s Coming,Tirthankar Lahiri
PRM4023 Oracle Real Application Clusters Roadmap for New Features,David Hickson
PRM4052 Hybrid Cloud Strategies for Big Data with Oracle Cloud and Engineered Systems,Marcos Arancibia Coddou
PRM4101 Roadmap: Innovations in Security and Compliance for Databases,Vipin Samar
PRM4102 Introducing Oracle’s Data Security Cloud Service for Oracle Databases,Vikram Pesati
PRM4108 Autonomous and Beyond: Security in the Age of the Autonomous Database,Russ Lowenthal
PRM4114 Oracle Exadata: Strategy and Roadmap for New Technologies, Cloud, and On-Premises,Juan Loaiza
PRM4124 JD Edwards Roadmap,Robert Monahan
PRM4144 Overall Applications Strategy and Roadmap for PeopleSoft,Rebekah Jackson
PRM4193 Oracle E-Business Suite Financials: Update, Strategy, and Roadmap,Helle Hennings
PRM4201 Oracle E-Business Suite: Digital Transformation Opportunities and Challenges,Paulo Back
PRM4202 Oracle E-Business Suite: Enterprise Asset Management Product Update and Roadmap,Lenore Siegler
PRM4216 Oracle Forms: Lifecycle Management and DevOps with Oracle Developer Cloud Service,Michael Ferrante
PRM4221 Oracle E-Business Suite: Human Capital Management Update, Strategy, and Roadmap,Subraya Yeltimar
PRM4222 Oracle E-Business Suite: Payroll and Benefits Updates and Roadmap,Subbu Kuttetira
PRM4235 Oracle’s Data Platform in the Cloud: Roadmap for Oracle Enterprise Data Quality,Mike Matthews
PRM4236 Oracle’s Data Platform in the Cloud: Strategy and Roadmap for Oracle GoldenGate,Chai Pydimukkala
PRM4236 Oracle’s Data Platform in the Cloud: Strategy and Roadmap for Oracle GoldenGate,Chai Pydimukkala
PRM4239 Oracle Data Platform: Strategy and Vision for Data Catalog,Mike Matthews
PRM4248 Oracle Advanced Procurement: Update, Strategy, and Roadmap,Paulo Back
PRM4277 Siebel CRM Strategy and Roadmap for Digital Transformation,George Jacob
PRM4300 PeopleSoft HCM Update and Roadmap: Innovative Solutions for Today’s HR,Robbin Velayedam
PRM4301 PeopleSoft Financials Update and Roadmap: Innovation Drives the Bottom Line,Amira Morcos
PRM4302 PeopleSoft Procurement: Innovative Solutions for Procurement Best Practices,Stephen Morgan
PRM4327 PeopleSoft Workforce Management Applications Update and Roadmap,Anne Leung
PRM4328 PeopleSoft Talent Management Applications Update and Roadmap,Tammy Boyles
PRM4400 Oracle WebLogic Server and Oracle Coherence Roadmap: On-Premises and in the Cloud,Monica Riccelli
PRM4423 Ongoing Investment in the PeopleSoft Modern User Experience ,Matthew Haavisto
PRM4424 Ongoing Investment in PeopleSoft Analytics and Insight,Matthew Haavisto
PRM4425 Ongoing Investment in PeopleSoft Personalization, Configuration, Customization ,Matthew Haavisto
PRM4553 Oracle Data Catalog: Enabling Data-Driven Organizations,Mike Matthews
PRM4556 Managing Development Projects Across Oracle Cloud Services: A Guide,Murtaza Amiji
PRM4583 Analytics Applications Roadmap: The Next Generation Is Near,Del Clark
PRM4603 Oracle Procurement Cloud: Overview, Strategy, and Roadmap,Tom Anthony
PRM4617 A Glimpse into the Future of B2C Marketing Orchestration and Mobile Marketing,Austin Miller
PRM4618 A Look Ahead at Marketing Automation and Content Marketing,Pierre Custeau
PRM4780 Tomorrow’s Manufacturing, Today,Andy Binsley
PRM5449 Tomorrow’s Supply Chain, Today: Transportation and Global Trade Management ,Srini Rajagopal
PRM5460 Tomorrow’s Supply Chain, Today: Inventory and Warehouse Management in the Cloud,Michael Lizio
PRM5789 Your Roadmap of the Future for Sales and Service,Krishna Mulukutla
PRM5871 Oracle Analytics Cloud: Oracle Essbase Capabilities and Roadmap,Kumar Ramaiyer
PRM6128 Roadmap to Modern 2.0.,Jp Saunders
PRM6267 ModelOps: Best Practices for Enterprise Model Operations and Management,JR Gauthier
PRM6544 Oracle Retail Cloud 201,Scott Kindred
PRO1294 Role-Based Access Control in Oracle E-Business Suite and in the Cloud,Susan Behn
PRO1409 How BYOL and Universal Credits Simplify Your Migration to the Cloud,Jon Williams
PRO1411 Moving Your Oracle Databases to the Oracle Cloud,Alex Zaballa
PRO1643 Oracle Database Exadata Cloud Service: From Provisioning to Migration,Nitin Vengurlekar
PRO1654 Oracle Autonomous Data Warehouse: Testing, Experiences, Results,Nitin Vengurlekar
PRO1696 MySQL 8.0 and InnoDB: Tablespace Management Best Practices,Sunny Bains
PRO1696 MySQL 8.0 and InnoDB: Tablespace Management Best Practices,Sunny Bains
PRO1702 Upgrading to MySQL 8.0 and a More Automated Upgrade Experience,Staale Deraas
PRO1778 Oracle Solaris: Secure, Simple, Cloud-Ready,Robert Milkowski
PRO1782 Oracle Solaris Application-Centric Lifecycle,Joost Pronk Van Hoogeveen
PRO1783 Oracle Solaris: Simple, Flexible, Fast Virtualization,Rudolf Rotheneder
PRO1784 Securing and Simplifying Data Management with Oracle Solaris and ZFS,Cindy Swearingen
PRO1787 Oracle Solaris: Simplifying Security and Compliance for On-Premises and the Cloud,Thorsten Muehlmann
PRO1788 Continuous Observability of Systems and Applications with Oracle Solaris 11.4,Jan Setje-Eilers
PRO2091 Running JavaScript Stored Programs Inside MySQL Server,Norvald Ryeng
PRO2469 Gaining Better User Adoption of Oracle HCM Cloud: Coexistence with Oracle E-Business Suite,Kathryn Koch
PRO2520 Migrating Your Database to Oracle Cloud: Exploring the Options,Simon Pane
PRO2816 10 Things You Should Know About Oracle and Kubernetes,Michel Schildmeijer
PRO2998 MySQL 8.0 Is Here,Mike Frank
PRO3008 MySQL 8.0: What Is New in Optimizer and Executor,Norvald Ryeng
PRO3056 Introduction to the MySQL Document Store,Mike Zinner
PRO3073 What’s New in MySQL 8.0 Security,Georgi Kodinov
PRO3176 Provide More for Less with Oracle Planning and Budgeting Cloud Service,Medik Ghazikhanian
PRO3761 Oracle SuperCluster Deep Dive: High Availability, Business Continuity for Private Cloud,Allan Packer
PRO3763 Oracle Enterprise Manager: Engineered Systems Management Deep Dive,Prasad Pai
PRO3814 Lower Archive Costs by Seamlessly Integrating On-Premises and Cloud Storage,Tom Wultich
PRO3815 Data Protection Seamlessly Integrated with the Cloud,Tom Wultich
PRO3836 Running Oracle E-Business Suite on Oracle Cloud Infrastructure: Why, What, and How,Nadia Bendjedou
PRO3920 Best Practices to Promote Employee Safety and OSHA Compliance Using Oracle HCM Cloud,Glen Walton
PRO3952 Optimizing Oracle HCM Cloud: Time and Labor, Absence, and Payroll ,Liz Bucko
PRO3953 Thrive with Oracle Workforce Management,Sherri Bartels
PRO3964 DevOps and Agile Methodology: Lessons Learned,Shay Shmeltzer
PRO3978 Oracle Autonomous Transaction Processing Overview and Roadmap,Maria Colgan
PRO3981 Making SaaS Your Own: Extending and Customizing with Low-Code JavaScript,JT Thomas
PRO3985 Build Mobile Apps Fast with Oracle Visual Builder Cloud Service,Laura Akel
PRO3996 Oracle NoSQL Database Cloud,Michael Brey
PRO4003 Oracle TimesTen Scaleout: A Cloud-Scale In-Memory Database for OLTP,Sam Drake
PRO4004 Multitenant: Best Practices for High Availability,Patrick Wheeler
PRO4015 Oracle TimesTen Scaleout: Getting Started,Chris Jenkins
PRO4035 Oracle Maximum Availability Architecture: Best Practices for the Cloud,Markus Michalewicz
PRO4036 Oracle Automatic Storage Management: Best Practices,Hanlin Chien
PRO4044 Using Oracle’s Analytics Views for Self-Service Business Intelligence,William Endress
PRO4045 Data Warehousing in a Heterogeneous World with Oracle,George Lumpkin
PRO4046 What Everyone Should Know About Oracle Partitioning,Hermann Baer
PRO4049 Oracle Autonomous Data Warehouse: Learn How to Build Interactive Notebooks ,Keith Laker
PRO4053 Learn How to Query Across Oracle, Data Lakes, Kafka with Oracle SQL Solutions,Martin Gubar
PRO4054 Machine Learning with R and Zeppelin on Oracle Big Data Solutions,Marcos Arancibia Coddou
PRO4055 Innovative Data Protection for Big Data: Tackling GDPR and Other Data Requirements,Jean-Pierre Dijcks
PRO4056 Querying Data Across Oracle Cloud the Easy Way,Martin Gubar
PRO4058 What’s New for Oracle SQL Developer,Jeff Smith
PRO4063 Oracle REST Data Services and REST APIs for Your Oracle Database,Colm Divilly
PRO4087 Make AppDev Fun Again, with the Oracle RAD Stack,Kris Rice
PRO4093 18(ish) Things Developers Will Love About Oracle Database 18c,Chris Saxon
PRO4110 Detecting and Blocking Attacks with Oracle Audit Vault and Database Firewall,Russ Lowenthal
PRO4111 Data Security in the GDPR Era,Joao Nunes
PRO4125 What’s New with JD Edwards EnterpriseOne Tools,Jeff Erickson
PRO4126 Transforming JD Edwards User Experience with UX One,Angela Enyeart
PRO4127 Implementing JD Edwards UX One,Angela Enyeart
PRO4128 JD Edwards: Available and Planned Features for the Global Lease Accounting Standard,David Scott
PRO4129 Introducing Joint Venture Management for JD Edwards,David Scott
PRO4130 Discover JD Edwards Orchestrator, Notifications, Application Interface Services Server,Jeff Erickson
PRO4131 JD Edwards on Oracle Cloud IaaS,Jeff Erickson
PRO4132 Oracle’s Ongoing Investment in Community and Economic Development,Rebekah Jackson
PRO4137 JD Edwards Practical Scenarios with Oracle SaaS Applications,Robert Monahan
PRO4139 JD Edwards and Oracle PaaS to Accelerate Innovation,Keith Sholes
PRO4140 Innovating Ahead of Your Competition with JD Edwards Labs,Manish Somani
PRO4146 PeopleSoft ERP Product Team Panel Discussion,Stephen Morgan
PRO4159 Fulfilling the Tall Order: Sustaining Branding Beyond Candidate Experience ,Laura Andrews
PRO4161 Introducing New AI Ops Innovations in Oracle Autonomous Health Framework,Mark Scardina
PRO4172 Planning Your Upgrade from Oracle E-Business Suite Release 12.1,J. Anne Carlson
PRO4173 Oracle E-Business Suite: User Experience and Mobile Update, Strategy, and Roadmap,Jeanne Lowell
PRO4174 Oracle E-Business Suite: What’s New in Release 12.2 Beyond Online Patching,Jeanne Lowell
PRO4179 Deploying Oracle E-Business Suite for On-Premises and Oracle Cloud,Santiago Bastidas
PRO4182 Technical Essentials for Running Oracle E-Business Suite on Oracle Cloud,Veshaal Singh
PRO4187 Securing Oracle E-Business Suite with the Latest Features and Tools,Eric Bing
PRO4192 What, Why, and How You Can Benefit from Oracle Cloud at Customer,Vasu Rao
PRO4194 Evolving with ASC 606 / IFRS Revenue Recognition Standard,Seamus Moran
PRO4196 Fulfill Performance Obligations with Effective Project Management,Lakshmana Ravula
PRO4203 Oracle E-Business Suite: Mobile Maintenance for Enterprise Asset Management,Lenore Siegler
PRO4204 Oracle E-Business Suite: New Age Asset Maintenance,Arunkumar Kaliappan
PRO4205 Oracle E-Business Suite: Warehouse Management Update, Strategy, and Roadmap,Bill Reilly
PRO4206 Getting the Most from Your Warehouse, Yard, and Transportation Management Systems,Bill Reilly
PRO4207 Oracle E-Business Suite: What’s New in Oracle Warehouse Management 12.2,Bill Reilly
PRO4208 Oracle Channel Revenue Management: Update, Strategy, and Roadmap,Earl Eldridge
PRO4209 Oracle E-Business Suite: Order Management Update, Strategy, and Roadmap,Earl Eldridge
PRO4211 Flexible Billing With Oracle Order Management,Shankar Bharadwaj
PRO4213 Oracle E-Business Suite: Service Update, Strategy and Roadmap,John Olszewski
PRO4223 How to Improve Employee Engagement with Mobile Applications ,Subbu Kuttetira
PRO4224 Data Privacy and Data Protection in Oracle E-Business Suite HCM,Subbu Kuttetira
PRO4226 Empowering the Oracle E-Business Suite User Experience: Data Discovery and Visualization,Muhannad Obeidat
PRO4233 Actionable Business Insights with Oracle Stream Analytics,Alex Kotopoulis
PRO4234 Stream Processing Enterprise Data with Oracle GoldenGate and Oracle Stream Analytics,Alex Kotopoulis
PRO4234 Stream Processing Enterprise Data with Oracle GoldenGate and Oracle Stream Analytics,Alex Kotopoulis
PRO4241 Oracle E-Business Suite: What’s New and What’s Coming in Oracle Manufacturing ,Abhay Satpute
PRO4249 Oracle E-Business Suite: Better Spend Management to Turbo-Charge Strategic Sourcing,Mark Peachey
PRO4250 Oracle E-Business Suite: Improving Collaboration and Reducing Risk for Your Suppliers,Preeti Venugopal
PRO4251 Better Purchasing and Category Management Through Operational Efficiency,Suresh Arunachalam
PRO4252 How Guided Buying Can Revolutionize Employee Shopping,Mark Peachey
PRO4258 Big Data Lab Powered by Data Science,Wes Prichard
PRO4270 Take Commerce to the Next Level with Artificial Intelligence and AI Apps for CX,Tara Roberts
PRO4271 Make Marketing More Rewarding with Artificial Intelligence and Data-Driven Apps,Jon Stanesby
PRO4272 Supercharge Sales Teams and Revolutionize Customer Service with AI-Powered Apps,Jon Stanesby
PRO4273 Artificial Intelligence Changes the Game in B2B and B2C CX,Tara Roberts
PRO4274 Turn ERP into a Strategic Business Function with Artificial Intelligence,Brian Pawlus
PRO4275 Transforming HR with Artificial Intelligence and Data-Driven Apps,Tara Roberts
PRO4280 Best Practices for Deploying Oracle Management Cloud ,Courtney Llamas
PRO4281 Getting More from Your Data with Oracle Enterprise Manager,Courtney Llamas
PRO4282 Autoremediation 101: Get Your Hands Free with Oracle Management Cloud,Erik Benner
PRO4305 Using the Modern User Experience of PeopleSoft ERP,Stephen Morgan
PRO4309 Using Personalization, Configuration, Customization in PeopleSoft ERP,Stephen Morgan
PRO4310 Using the Modern User Experience of PeopleSoft HCM,David Bain
PRO4311 Using Analytics and Insight in PeopleSoft HCM,John Robinson Jr.
PRO4314 Using Personalization, Configuration, Customization in PeopleSoft HCM,David Bain
PRO4329 PeopleSoft Supplier Solutions Manage Supplier Relationships and Reduce Costs,Stephen Morgan
PRO4330 Drive Efficiency in Your PeopleSoft Procure to Pay Business and Reduce Costs,Amira Morcos
PRO4332 Introducing the Latest PeopleSoft Innovations for Finance and Accounting,Amira Morcos
PRO4335 PeopleSoft Asset Management and Lease Administration: Adapting to Change,Kelly Mills
PRO4357 Customize and Extend Oracle SaaS with Oracle Java Cloud Service,Pyounguk Cho
PRO4358 Build Cloud-Native Applications on Oracle Cloud,Pyounguk Cho
PRO4359 Design and Build Microservices Architecture on the Cloud,Pyounguk Cho
PRO4368 New Tools and Techniques to Run High-Performance Databases ,Gp Gongloor
PRO4369 Improve Operational Efficiency of Oracle Cloud Infrastructure with Oracle Management Cloud,Debu Panda
PRO4371 Monitoring Across the Globe: Unifying IT Health Across Oracle Enterprise Manager Sites,Ana Maria Mccollum
PRO4372 Lift and Shift with Confidence to Oracle Autonomous Database Cloud,Naushad Bhamani
PRO4372 Lift and Shift with Confidence to Oracle Autonomous Database Cloud,Naushad Bhamani
PRO4374 Beyond SQL Tuning: Insider’s Guide to Maximizing SQL Performance,Ashish Agrawal
PRO4377 SQL Tuning Tips for Cloud Administrators ,Gp Gongloor
PRO4378 Extreme Database Optimization: Simple Steps to Maximize Performance,Kurt Engeleiter
PRO4402 Deploying Oracle WebLogic Server Applications in Kubernetes,Monica Riccelli
PRO4405 SAP on Oracle: Development Update,Christian Graf
PRO4441 PeopleSoft PeopleTools Platform and Infrastructure Overview,Ravi Shankar
PRO4443 Harden and Protect PeopleSoft On-Premises and in the Cloud,Greg Kelly
PRO4448 Getting Started with Oracle Management Cloud,Jeevan Joseph
PRO4450 Extending and Customizing Oracle Management Cloud,Nikhil Gupta
PRO4462 Connected Planning: Integrate Budgets and Capital to Drive Growth, Connect Strategy,Shankar Viswanathan
PRO4464 Leverage EPM Cloud to Address Upcoming Regulatory Mandates ,Rich Wilkie
PRO4465 Reimagine Your Financial Close in the Cloud,Rajesh Bhatia
PRO4466 Move Account Reconciliations to the Cloud ,Tim Gaumont
PRO4468 Oracle EPM Strategy and Roadmap,Hari Sankar
PRO4475 Upgrade Oracle Enterprise Manager to 13c with Level 4 Maximum Availability Architecture,Avi Huber
PRO4476 Oracle WebLogic Server Management and Diagnostics Made Simple,Dhiraj Chhabra
PRO4477 Transitioning to the Cloud: Don’t Forget the Management,Avi Huber
PRO4478 Get Insight into Oracle Integration Cloud/Oracle Java Cloud Service Performance,Avi Huber
PRO4481 Monitor and Diagnose Your PeopleSoft and Siebel Applications,Glen Hawkins
PRO4482 Unified Monitoring for On-Premises and the Cloud with Oracle Management Cloud,Erik Benner
PRO4483 Avoid Problems in Production Using Oracle Management Cloud Logs and Traces in Development,Jurgen Leijer
PRO4486 Big Data and Data Science Powering Smart Manufacturing,Gopal Ratnam
PRO4514 Introducing Oracle’s High Productivity Dev Platform for Mobile, Web, Progressive Web Apps,Srini Indla
PRO4518 Simplify and Accelerate Digital Transformation with Oracle Integration Cloud,Ramkumar Menon
PRO4529 Oracle SOA Suite Cloud Service: Customer Use Cases,Scott Haaland
PRO4532 CPQ Subscription Management Drives Evolution to the Modern Subscription Economy,Fadi Shamshikh
PRO4539 Simplify and Accelerate Digital Transformation with Oracle Integration Cloud,Nathan Angstadt
PRO4545 Supercharged Apache Spark SQL as a Service on Oracle Cloud ,Carter Shanklin
PRO4554 Visual JavaScript Development: How We Do It,Brian Fry
PRO4557 Loading Application Data in a Data Warehouse and a Data Lake in Batch and Real Time,Nishit Rao
PRO4564 Propelling Professional Services Projects to Success with Oracle Cloud,Simon Ball
PRO4574 Journey to the Cloud: Oracle Accounting Hub Cloud Service Adoption and Use Cases,Shyam Santhanam
PRO4601 Oracle MySQL Cloud Service,Airton Lastori
PRO4605 Oracle’s Supplier Management, Sourcing, and Contract Management Cloud Solutions,Mike O’Connor
PRO4638 Assemble and Manage Rich Content with Oracle’s Digital Asset Management Features,Igor Polyakov
PRO4639 Provide a Multichannel Customer Experience with Oracle Content and Experience Cloud,Igor Polyakov
PRO4640 Bring Order to Chaos and Efficiently Manage Your Organization’s Microsites ,Jason Stortz
PRO4643 Build Headless Composite Experiences: Oracle WebCenter/Oracle Content and Experience Cloud,Mandar Tengse
PRO4696 Gain Deeper Insights with Oracle Analytics for Supply Chain Management,Dhiraj Chhajer
PRO4721 Best Practices: Oracle Linux and Oracle VM in Oracle Cloud Infrastructure,Julie Wong
PRO4724 Oracle Linux and Oracle VM VirtualBox: The Enterprise Development Platform,Simon Coter
PRO4731 Accelerate Your Business with Machine Learning and Oracle Linux,Joost Pronk Van Hoogeveen
PRO4768 Sense, Predict, and Shape Demand with Oracle Demand Management Cloud,Kiran Saindane
PRO4769 Align Product, Demand, Supply, Financial Plans: Oracle Sales and Operations Planning Cloud,Vikash Goyal
PRO4770 Prevent Disruptions with Supply Planning and Collaboration in the Cloud,Moshin Lee
PRO4771 Extend Your Enterprise with Supply Chain Collaboration and Visibility in the Cloud,Matt Johnson
PRO4775 Quality 4.0:  Managing Risk with Oracle Quality Management Cloud ,Gayle Hayes
PRO4779 Tomorrow’s Maintenance, Today,Andy Binsley
PRO4781 Process Manufacturing in an Industry 4.0 World,Jung Ha
PRO4786 Building a Cost-Effective Cloud with Oracle OpenStack and Oracle’s x86 Servers,Joshua Rosen
PRO4899 Optimize SaaS Lifecycle Management: Provision, Patch, Upgrade, P2T, and More,Deb Bhattacharjee
PRO5115 Oracle Projects: Improve Accuracy and Completeness in Planning and Execution,Lakshmana Ravula
PRO5117 Data Privacy for Oracle E-Business Suite Customers,Eric Bing
PRO5179 Oracle Identity Governance Suite,Ravi Erukulla
PRO5475 Industry 4.0: Digital Logistics and Order Management with Disruptive Technology,Alison Schofield
PRO5726 Enterprise Agility with the Siebel CRM Continuous Release Model,Gregg Reno
PRO5733 The Security Value of Support,Bruce Lowenthal
PRO5734 Maximize Your Oracle E-Business Suite Investment with Oracle Support,J. Anne Carlson
PRO5735 Maximize Your PeopleSoft Investment with Oracle Support,Samuel Chan
PRO5736 Maximize the Value You Get from Your JD Edwards Investment with Oracle Support,Samuel Chan
PRO5748 Exciting Innovations in Siebel CRM to Enhance Agility and User Experience,Marc Verbeek
PRO5773 Reimagine Your Mobile Apps with Augmented Reality,Parvez Syed mohamed
PRO5788 How AI Is Transforming Sales and Service,Jon Stanesby
PRO5790 The Triple Play: Bringing Marketing, Sales, and Service Together,Michael Richter
PRO5791 Extending the Next Generation Engagement Platform with Partners,Michael Richter
PRO5796 Automating Workload Migration to Oracle Cloud Infrastructure,Simon Coter
PRO5797 Why Oracle Linux Is the Best Platform for Oracle Database and Oracle Cloud,Ravi Thammaiah
PRO5798 How Oracle Linux Delivers Superior Application Scalability for Exadata ,Swamy Kiran
PRO5815 Managing Identity Applications, Securing Databases with Oracle Management Cloud,Dan Koloski
PRO5842 Oracle EPM Cloud: What’s New, What’s Coming in Financial Close,Rich Wilkie
PRO5843 Fostering Lasting Loyalty Through Seamless Integration,Tasnia Khan
PRO5848 Overview and Update:  On-Premises EPM Applications and Roadmap,Rich Wilkie
PRO5858 IT Financial Management,Don Bean
PRO5860 Proactive Intelligence with Oracle Analytics Cloud,Jacques Vigeant
PRO5864 Analytics for Oracle SaaS Applications: From Data to Breakthrough Insights,Rohan Lobo
PRO5880 A Comprehensive Tour of Oracle Analytics Cloud ,John Hagerty
PRO5898 Oracle Cloud Infrastructure Security Architecture: Peek Under the Covers,Yuecel Karabulut
PRO5904 An Overview of Oracle Infrastructure Technologies in Oracle Cloud,Robert Shimp
PRO6175 Antipatterns for Integration: Common Pitfalls,Vikas Anand
PRO6181 Delivering Managed Cloud Services with Oracle Private Cloud Appliance,Steve Callahan
PRO6191 Financial Services: Successfully Acquiring and Retaining Customers,Michel Van Woudenberg
PRO6193 Powering Modern Project Financial Management: Oracle Project Portfolio Management Cloud,Simon Ball
PRO6194 Driving Innovation/Project Execution Excellence: Oracle Project Portfolio Management Cloud,Robert Barocas
PRO6197 Oracle Procure to Pay Cloud Solutions Overview,Nitin Katare
PRO6202 Drive Ongoing Customer Relationships with Oracle Subscription Management ,Chris Shutts
PRO6268 Injecting AI into Applications to Make Them Smarter,Elena Albright
PRO6395 A Risk-Based Approach to Manufacturing Regulations and Audits,Elaine Wan
PRO6435 Security in a 5G World: How to Protect Your Network Today and Tomorrow,Travis Russell
PRO6439 Accelerate Your Digital Business ,Elmar Rode
PRO6467 Journey to the Cloud,Rick Juneja
PRO6477 Choosing the Right Tools for the Job: Better, Faster Results,Nilesh Murthy
PRO6560 Enhancing Cloud Infrastructure Security: Live Patching and Workload Protection,Honglin Su
PRO6682 Boost Developer Productivity and Build Fast, Flexible, Secure Blockchain Apps ,Todd Little
PRO6683 Best Practices for Developing Advanced Blockchain Solutions,Todd Little
PRO6860 Audio Recognition Using Oracle Data Science Cloud Service,JR Gauthier
THT6571 Automate Your End-to-End Business Processes with Solutions Fully Integrated with Oracle,David Fullen
THT6579 Oracle Autonomous Data Warehouse and Data Intensity: A Customer Success Story,James Anthony
THT6580 How James Avery Saved Nearly a Million Dollars with Simple Process Changes,David Wright
THT6581 Digital Transformation: The Future of Business and IT,June Manley
THT6590 Accelerate DigitalOps with Oracle Integration Cloud and UiPath RPA,Boris Krumrey
THT6591 Bringing One-Click Simplicity to Running Oracle with Nutanix,MANDAR SURKUND
THT6592 Improving Business Outcomes with Oracle ERP Cloud and Enterprise Workload Automation,Tom O’Rourke
THT6596 Policy-Driven Data Protection for the Software-Defined Data Center,Rebecca Fitzhugh
THT6629 Synchronous Multimaster MySQL Clustering with Codership’s Galera Replication,Seppo Jaakola
THT6630 OPN: Digital Marketing Made Easy,Laurie Balcerak
THT6631 OPN: Marketing Tools and Resources: An Overview,Kelly Greenly
THT6641 Driving Oracle Cloud Implementation Success at GP Strategies with In-App Guides,Eric Bruner
THT6642 Driving Oracle Cloud Implementation Success at Westpac with In-App Guides,Eric Bruner
THT6643 Segregation of Duties and Audit Reporting for Oracle ERP Cloud and Oracle E-Business Suite,Mike Ward
THT6644 Segregation of Duties and Audit Reporting for Oracle ERP Cloud and Oracle E-Business Suite,Mike Ward
THT6654 OPN: Grow Your Business with Oracle PartnerNetwork Programs ,Pablo Hanono
THT6655 OPN: Harness the Power of Social Selling and Storytelling,Pablo Hanono
THT6668 How to Survive LATAM Complexities Across Tax, Legal, and Global Trade,Menotti Franceschini
THT6669 How Multinationals Get Indirect Taxes Right to Limit Tax Risk with ONESOURCE ,Stefan Blumer
THT6671 Technology Meets Disruption: The Impact of Government on Modern Business,Chris Carlstead
THT6673 Accelerate Oracle Warehouse Management in the Cloud or On-Premises Return on Investment,Kanakendu Chatterjee
THT6688 CX Digital and Virtual Assistants,Justin Grochoski
THT6696 Digital Transformation: Oracle Customer Experience Customer Case Study,Tarun Sharma
THT6703 NoSQL+SQL=MySQL,Jesper wisborg Krogh
THT6705 Boost Cloud Adoption with Business Help Desk for SaaS,Phil Sidebotham
THT6706 Get a Jump-Start with the DevOps Starter Pack,Ian Remedios
THT6707 Oracle Managed Identity Cloud Service: Unifying Access to Cloud/On-Premises Applications,Phil Sidebotham
THT6713 Infolob and Equinix Optimized Hybrid Cloud Solution for Oracle Cloud,Tim Fox
THT6714 Transform Digital Enterprise with Software-Defined Infrastructure and Equinix,Pragnesh Panchal
THT6717 Oracle Platinum Services: Roadmap and Latest Developments,Christiana Gwin
THT6718 Oracle Platinum Services: Roadmap and Latest Developments,Christiana Gwin
THT6719 Oracle Database Release Model: Magic with Numbers and the Latest News,Tamara Laborde
THT6720 Oracle Database Release Model: Magic with Numbers and the Latest News,Tamara Laborde
THT6723 Oracle Enabling FinTech Startups to Scale and Disrupt,Vishal Gupta
THT6726 Meet the Newest Disruptors: Startups at the Forefront of Innovation,Pranjal Prashar
THT6727 Startups Using AI to Disrupt Every Industry,Michal Meiri
THT6728 Startup Ingenuity Taking Customer Experience to the Next Level ,Ricardo Rodrigues
THT6729 Startup Solutions: Workplace Engagement and Learning for the New Age,Kevin Roe
THT6729 Startup Solutions: Workplace Engagement and Learning for the New Age,Kevin Roe
THT6733 Business Transformation with Industry 4.0,Scott Renner
THT6776 Turbo-Charge Mobile App Development with Oracle Visual Builder Cloud Service,John Ceccarelli
THT6777 AI for Manufacturing,Surya Kommareddy
THT6778 Simplified DevSecOps with Oracle Cloud,Murtaza Amiji
THT6780 Data Has Value: Is Your Business Realizing it?,Charles Garry
THT6782 Digital Store,Gerald Poncet
THT6783 Smart Labels and Product Transparency,Sandeep Rameja
THT6788 Smart Connected Warehouse,Eric Prevost
THT6792 Digital Fleet Management ,Kaushal Mehta
THT6795 The Future of Finance: Emerging Technology Reshaping the Finance Function ,Matt McGuinn
THT6796 Align Your Past Skills with the New Capabilities of Oracle Database 18c,Ron Soltani
THT6798 What Is Oracle Database Sharding and What Is It Used For?,Ron Soltani
THT6800 Automate Managing Oracle License Entitlements with Nlyte Software Asset Manager ,Gary Paquette
THT6804 Oracle Cloud Customer Hubs: Share Your Oracle Story,Paul Karlberg
THT6812 Running Microservices in Oracle Cloud,Maciej Gruszka
THT6814 Inside the Mind of a Database Hacker,Mark Fallon
THT6816 Database Security Assessment Tool,Pedro Lopes
THT6817 Database Security: Integration with Active Directory,Alan Williams
THT6818 Oracle Multitenant: Ask the Experts,Can Tuzla
THT6819 Oracle CASB Cloud Service: Securing Data in the Cloud,Adina Simu
THT6825 Supply Chain Orchestration: Troubleshooting Tips for SCM Cross-Functional Flows,Ashish Pachauri
THT6826 Key Considerations in User Lifecycle Management,Manish Patanker
THT6827 Oracle E-Business Suite Analyzer Diagnostics: Simply a MUST HAVE for All Companies,Nicholas Angelis
THT6829 Leverage the Virtual Team Using Oracle Support Communities,Phil Dixon-Patterson
THT6830 Database Upgrade Performance Tuning Tips,Soumendra Paik
THT6832 Retail Functional Help Desk Offering,Bob Johnson
THT6833 Oracle E-Business Suite’s Cloud Manager for Lift and Shift,Vasu Rao
THT6834 Running Oracle E-Business Suite on Oracle Cloud at Customer,Vasu Rao
THT6835 Oracle E-Business Suite Automation and Support in Oracle Cloud,Julio Maureira
THT6836 Maximize Your Investment in the Oracle Cloud Platform ,Paramita Chakraborty
THT6837 Oracle Support Accreditation: Take Your Expertise to the Next Level,Dave Muirhead
THT6839 The New Oracle Monitoring and Advisory Service for Applications Unlimited ,Michael Soulier
THT6841 Maximize Your Support Investment: It’s Time to Get Proactive,Dave Muirhead
THT6842 Reduce Resolution Time with Oracle Trace File Analyzer and the Support Tools Bundle,Bryan Vongray
THT6844 Repairing/Restoring Access to IaaS Linux Compute Instances on Oracle Cloud Infrastructure,Andrei Costache
THT6846 Accelerate Your Success on Oracle Cloud Infrastructure with Applications Unlimited Support,Viviana Tilita
THT6847 Oracle E-Business Suite Analyzer Diagnostics: Simply a MUST HAVE for All Companies,Nicholas Angelis
THT6850 How to Effectively Work with Oracle Support ,Bo Yu
THT6852 The New Oracle Monitoring and Advisory Service for Applications Unlimited ,Michael Soulier
THT6853 Maximize Your Investment in the Oracle Cloud Platform,Paramita Chakraborty
THT6880 The New Oracle Monitoring and Advisory Service for Applications Unlimited,Michael Soulier
THT6881 Database Cloud Services Lifecycle Management from the Command Line,Anandamai Singaraju
THT6885 Best Practices for Securing Access to Oracle Data,Manasa Anantharamaiah Nanjunda Swamy
THT6893 Instant Backup and Recovery of Oracle Databases On-Premises or in the Cloud,Jay Livens
THT6894 AskTOM Mini Lesson: Get the First Rows Faster,Connor Mcdonald
THT6895 AskTOM Mini Lesson: Tune ANY Query in 20 Minutes,Connor Mcdonald
THT6896 AskTOM Mini Lesson: The Dynamic Pivot Update ,Chris Saxon
THT6897 AskTOM Mini Lesson: The Magically Changing Data Type ,Chris Saxon
THT6900 Accelerate DevOps with Instant Oracle Database Clones,Jay Livens
THT6902 Secure and Manage Your Hybrid Cloud with Oracle Management Cloud,Dave Le Roy
THT6903 Operating Your Business with Subscription Management,Tapomoy Dey
THT6904 Managing Projects Is as Easy as 1-2-3 with Oracle Project Portfolio Management Cloud,Satya Anur
THT6905 AI for ERP: Intelligent Payments and Supplier Recommendations,Brian Pawlus
THT6912 Oracle Linux/Oracle VM VirtualBox: An Enterprise Development Platform for Oracle Cloud ,Simon Coter
THT6914 Oracle Infrastructure Technologies in Oracle Cloud,Karen Sigman
THT6926 Oracle Manufacturing Cloud: 10 Reasons You May Not Need a Manufacturing Execution System,Andy Binsley
THT6929 Oracle Data Science Cloud Service,Elena Albright
THT6941 Oracle Executive Focus: Rapid Decision-Making in a Complex World,Dave Granholm
THT6954 Revenue Best Practices Evolution After ASC 606 and IFRS 15,Seamus Moran
THT6958 Introducing DevOps Solutions on Oracle Cloud Infrastructure,Vyom Nagrani
THT6968 Cloud Migration 101 on Oracle Cloud Infrastructure,Rachna Thusoo
THT6974 Security 101 on Oracle Cloud Infrastructure,Yuecel Karabulut
THT6987 Cloud: Enabling the Supply Chain of the Future,Sean Elliott
THT6989 Getting the Global Payroll and HR Systems Relationship Right from the Start,Wanies Rihani
THT6990 The Data Center of Tomorrow, Today: Realize Your Hybrid Ambitions,David Robertson
THT7002 Speak and Sell: The Future of Voice and Commerce,Colleen Nagle
THT7003 Oracle E-Business Suite Cybersecurity Risks and Mitigation,Matias Mevied
THT7004 How to Implement Critical Patch Updates for Oracle E-Business Suite,Cristian Peque
THT7005 Elevate Your Enterprise Oracle Cloud with Robotic Process Automation,Tom Garland
THT7009 Enabling C-level financial insights with BI,Dixit Shah
TIP1094 The Oracle Self-Driving Database of the Future (or Present),Nitin Vengurlekar
TIP1153 Oracle Advanced Collections: Overview and Implementation,Mandar Kulkarni
TIP1247 3D: Docker for Database Developers,Roel Hartman
TIP1259 Multitenant Security Features Clarify DBA Role in DevOps Cloud,Franck Pachot
TIP1372 The Future of Integration with Machine Learning and Artificial Intelligence,Bruce Tierney
TIP1377 What Every DBA Needs to Know About Oracle Application Express,Francis Mignault
TIP1378 Key Audit and Compliance Advantages of Running in the Cloud,Matias Mevied
TIP1396 Server-Side Development for the Cloud,Michael Rosenblum
TIP1443 Banking on the Cloud,Mahesh Vallampati
TIP1454 How Oracle Business Intelligence Publisher Transforms Cloud ERP Reports,Mahesh Vallampati
TIP1837 Oracle Database Meets Docker: How to Get Started,Anton Els
TIP1989 Even the ACEs make Mistakes – What did they learn?”,Debra Lilley
TIP2118 Get Your Dockerized Oracle Sandbox Running in the Cloud or On-Premises,Martin Knazovicky
TIP2364 Oracle JavaScript Extension Toolkit Composite Components Bring Agility to App Development,Lucas Jellema
TIP2561 Develop, Deliver, Run Oracle Application Development Framework Applications with Docker,Eugene Fedorenko
TIP2578 Oracle Private Cloud Appliance Best Practices,Bob Bownes
TIP2994 Advanced PeopleSoft Administration Using the PeopleSoft Cloud Architecture,Dan Iverson
TIP3234 Performance Tuning Oracle Database 18c in Oracle Enterprise Manager Cloud Control 18c,Tariq Farooq
TIP3266 All You Need to Know About Backup and Recovery,Tariq Farooq
TIP3342 Deep Dive on Oracle’s Software in Silicon Breakthrough for Database and Security,Martin Mueller
TIP3344 Tips and Tricks to Build Software Leveraging Oracle Database and Applications,Martin Mueller
TIP3348 The Keys to Driving the Best Performance in Your Private Cloud Infrastructure,Martin Mueller
TIP3698 Oracle Data Integrator in the Cloud,Gürcan Orhan
TIP3970 Top 10 Database Compression Insights: What You Need to Know,Gregg Christman
TIP3992 The Emergence of New Threats: A Look at Spectre and Meltdown,Greg Marsden
TIP4006 Multitenant: Best Practices for Isolation,Ravi Thammaiah
TIP4028 Oracle Maximum Availability Architecture: Best Practices for Oracle Database 18c,Lawrence To
TIP4039 No Outages: Maintenance Operations Without Impact,Ian Cookson
TIP4059 Oracle SQL Developer Tips and Tricks,Jeff Smith
TIP4068 Optimizing the Performance and Scalability of Java Applications That Use an RDBMS,Jean De Lavarene
TIP4069 A Java Library for High-Speed Streaming Data into Your Database,Jean De Lavarene
TIP4071 Microservices, Containers, Databases, and Persistence Models,Kuassi Mensah
TIP4075 Performance and Scalability Techniques for Oracle Database Applications,Rajendra Pingte
TIP4076 Python and Oracle Database on the Table,Christopher Jones
TIP4080 Node.js: Async Data In and Data Out with Oracle Database,Christopher Jones
TIP4085 Accelerate Application Performance: Tips for Faster Oracle Database .NET Programs,Alex Keh
TIP4094 The Fast Lane to Database Success,Connor Mcdonald
TIP4104 Appdev: Building Secure Database Applications Quickly in the Cloud Era,Alan Williams
TIP4112 Recent Database Security Innovations You Might Not Be Using, but Should Be,Alan Williams
TIP4119 Data Security How-to for Oracle Exadata Cloud,Jeffrey Wright
TIP4119 Data Security How-to for Oracle Exadata Cloud,Jeffrey Wright
TIP4120 How to Architect and Implement DevOps in Oracle Exadata Cloud,Jeffrey Wright
TIP4183 Technical Upgrade Best Practices for Oracle E-Business Suite 12.2,Samer Barakat
TIP4185 Migrating and Managing Customization for Oracle E-Business Suite 12.2,Santiago Bastidas
TIP4186 Getting Optimal Performance from Oracle E-Business Suite,Samer Barakat
TIP4210 Tips and Tricks with Oracle Order Management,Subhra Datta
TIP4218 Zero Data Loss Recovery Appliance: Insider’s Guide to Architecture and Practices,Jony Safi
TIP4263 Do More with Data Lake in the Cloud: Solution Patterns,Wes Prichard
TIP4393 JD Edwards Support and Oracle Cloud Infrastructure: A Successful Path to Oracle Cloud,Viviana Tilita
TIP4394 Upgrading and Maintaining Siebel CRM in the Cloud or On-Premises,Patrick Flynn
TIP4395 Best Practices for Maximizing Your PeopleSoft Applications Investment,Sushma Patel
TIP4407 Best Practices for Managing Oracle Database Cloud Service on Oracle Cloud Infrastructure ,Madhu Hunasigi
TIP4409 Performance Considerations Before Upgrading to Oracle Database 18c,Soumendra Paik
TIP4411 DBaaS Backup Configuration, Known Glitches, and Best Practices ,Amaresh Padhi
TIP4412 Best Practices for Maintaining Oracle RAC/Single Instance Database Environments ,Bill Burton
TIP4413 Best Practices for Securing Access to Oracle Data ,Manasa Anantharamaiah Nanjunda Swamy
TIP4415 Best Practices for Linux and Windows IaaS Instances in Oracle Cloud Infrastructure,Andrei Costache
TIP4416 Oracle E-Business Suite Analyzer Diagnostics: A MUST HAVE for All Companies,Nicholas Angelis
TIP4418 The Ins and Outs of Oracle Transportation Management Cloud Service: Integration,Keith Wenyon
TIP4419 Oracle E-Business Suite Automation and Support in Oracle Cloud,Julio Maureira
TIP4421 User-Defined Attributes Framework: Extend Your Data Capturing in Oracle E-Business Suite,Kishor Genikala
TIP4429 Utilizing the Best from Oracle ZFS Storage Appliance,Madhusudhan Kondam
TIP4444 Getting the Most Out of PeopleSoft PeopleTools: Tips and Techniques,Jim Marion
TIP4449 Push 0 to Talk to a Human: The Best of Both Worlds; Robots and Humans in Service,Jonathan Bastow
TIP4452 Caring for Aging Systems,Tom Chalfant
TIP4454 Exceptional Service: Improving Your SR Experience in Global Systems Support,Laura-mihaela Volintiru
TIP4456 Boost ROI: Learn How to Identify the Oracle Support Resources for Your Business,Denise Charleston
TIP4530 Oracle SOA Suite Hybrid Options with Oracle Integration Cloud,Antony Reynolds
TIP4586 Best Practices for Highly Available Oracle Applications on Oracle Cloud,Larry Frank
TIP4599 Best Practices for Enterprise Workloads in Oracle Cloud Infrastructure,Edwin Flores
TIP4725 Maximize Performance with Oracle Linux and Oracle VM,Greg Marsden
TIP4727 Tips for Securing Your Cloud Infrastructure,Jan Hendrik Mangold
TIP4995 Database Release and Patching Strategies,Eleanor Meritt
TIP5526 The Changing Role of the DBA,Maria Colgan
TIP5719 Advanced Architectures for Oracle Applications on Oracle Cloud,Ronald Hunsaker
TIP5776 10 Keys to Successful Digital Assistant and Chatbot Implementations,Paul Isherwood
TIP5795 Embrace Open Source Projects on GitHub for Cloud Automation,Avi Miller
TIP5912 Analytics Applications Made Easy with Oracle Essbase,Kumar Ramaiyer
TIP5954 The Three Fundamental Principles of Real-Time Oracle Database Replication,Mike Donovan
TRN1263 Saving Your Database from Memory Loss: Oracle Database In-Memory Analytics Improvements,JAMES CZUPRYNSKI
TRN1553 Oracle Database 12c R1 and R2 Are Awesome, Now Meet Oracle Database 18c,Anuj Mohan
TRN1743 Do We Still Need to Design Databases?,Heli Helskyaho
TRN1795 Building Firewalls and Load Balancers on Oracle Private Cloud Appliance,Bob Bownes
TRN1918 How to Build a Decentralized Blockchain App with Oracle Blockchain Cloud Service,Robert van Molken
TRN3762 Oracle SuperCluster Best Practices, and What Happens When You Do Not Use Them,Don O’Malley
TRN3979 An Insider’s Guide to Oracle Autonomous Transaction Processing ,Maria Colgan
TRN4013 Oracle Database In-Memory: When to Use and Quick Start Guide,Raj Rathee
TRN4014 Oracle Database In-Memory: Implementation Best Practices and Deep Dive,Andy Rivenes
TRN4019 Oracle GoldenGate: Automating Failover Using Grid Infrastructure with Microservices,Stephan Haisley
TRN4022 Oracle Real Application Clusters 18c Internals,Anil Nair
TRN4025 Real-World Performance with Oracle Autonomous Data Warehouse,John Clarke
TRN4026 A Day in the Life of a Real-World Performance Engineer,Robert Carlin
TRN4034 How to Migrate to Oracle Autonomous Database Cloud ,Julian Dontcheff
TRN4040 Transparent High Availability for Your Applications,Ian Cookson
TRN4047 Oracle Autonomous Data Warehouse: A Step-by-Step Guide,Yasin Baskan
TRN4064 Kicking Mod_PLSQL to the Curb for a Modern REST-Driven Application,Colm Divilly
TRN4070 A Database Proxy for Transparent High Availability, Performance, Routing, and Security,Kuassi Mensah
TRN4072 Real-World Performance from Micro to Macro: Is a Spectre Looming?,Mike Hallas
TRN4078 Application High Availability Best Practices and New Features,Nancy Ikeda
TRN4081 Building Real-Time Data in Web Applications with Node.js,Christopher Jones
TRN4084 Using .NET Core and Entity Framework Core on Linux/Windows with Oracle Database,Alex Keh
TRN4086 Eliminate Application Downtime with Oracle Database and .NET,Alex Keh
TRN4089 Using Location in Cloud Applications with Python, Node.js, and More ,Siva Ravada
TRN4090 Oracle Application Express 18.1 New Features,Joel Kallman
TRN4092 Maximizing the Value of Municipal Open Data APIs with Low-Code Development Tools,Marc Sewtz
TRN4095 Geo-Tagging, Geo-Enrichment, Geo-Fencing, and Tracking for Location-Enabled Apps,Daniel Geringer
TRN4096 Developers: Don’t Be the Person Who Discombobulates Your Database,Connor Mcdonald
TRN4097 Why Isn’t My Query Using an Index? An Introduction to SQL Performance,Chris Saxon
TRN4098 Introduction to Graph Analytics and Oracle Graph Cloud Service,Jean Ihm
TRN4099 How to Analyze Data Warehouse Data as a Graph,Jayant Sharma
TRN4106 Encrypt Your Crown Jewels and Manage Keys Efficiently with Oracle Key Vault,Hamid Habet
TRN4107 Oracle Database Security Assessment Tool: Know Your Security Posture Before Hackers Do,Pedro Lopes
TRN4109 Inside the Head of a Database Hacker,Mark Fallon
TRN4116 Oracle Exadata Cloud at Customer Technical Deep Dive ,Manish Shah
TRN4162 Autonomous Database Diagnostics Through Applied Machine Learning,Bill Burton
TRN4163 Autonomous Health for Oracle RAC Continuous Availability: Best Practices,Mark Scardina
TRN4406 Managing Your Oracle Database Cloud Service Instance Through REST API,Madhu Hunasigi
TRN4410 Strategies for Migrating Your Database to Oracle Cloud,Kunka Krishnakumar
TRN4426 New Virtualization Features in Oracle Solaris 11.4,Chris Courtney
TRN4447 The Power of BI Visualization and How to Integrate with Oracle Analytics Cloud,Moustafa Morssy
TRN4546 Just Add Code: Run Apache Spark the Serverless Way,Praveen Deshpande
TRN4567 Best Practices for Diagnosing and Troubleshooting Oracle Java Cloud Service,Gautam Singh
TRN4568 Configure, Diagnose, Troubleshoot Security Assertion Markup Language in Oracle WebLogic,Ken Vincent
TRN4901 Oracle Cloud Performance Best Practices for IaaS and PaaS,Stevan Malesevic
TRN4907 Optimizing Spark and Hive Workloads in Oracle Big Data Cloud Service,Scott Oaks
TRN5157 Database Consolidation: Best Practices for Successful Resource Management,Sue Lee
TRN5515 Industrial-strength Microservice Architectures with Next-Generation Oracle Database,Dominic Giles
TRN5774 Build Mobile/Progressive Web Apps: Oracle Visual Builder Cloud Service/Oracle Mobile Cloud,JT Thomas
TRN5777 Build Multilingual Digital Assistants/Chatbots: Oracle Digital Assistant,Ruben Rodriguez Santiago
TRN5793 Real-Time Insights to Build Better Digital Assistants and Chatbots Faster,Matthew Wright
TRN5828 Oracle Linux and Oracle VM: Get Trained for Cloud, Hybrid, and On-Premises,Avi Miller
TRN6352 Application Integration on Oracle Cloud ,David Mills
TRN6358 Using Alert Composer to Simplify HCM Notifications,Amy Kust
TRN6359 Your BI for All Things: Business Intelligence on Oracle Cloud,Phil Scott
TRN6361 Who Wants to Be in DevOps?,David Mills
TRN6363 Oracle Internet of Things Cloud Service and Enterprise Applications: #relationshipgoals,David Mills
TRN6446 An Overview of Oracle Approvals Management Engine in Oracle E-Business Suite,Andrea Auld
TRN6447 Using Oracle Hyperion Financial Close Management to Automate Your Close Process,Andrea Auld
TRN6449 Providing High Availability of Data by Using Container Databases,Ron Soltani
TRN6450 Using an Oracle Database 18c Security Schema to Manage and Secure User Data,Ron Soltani
TRN6451 Develop, Implement, and Maintain Database RESTful Web Services Using Oracle Tools,Joe Greenwald
TRN6458 Deep Dive: Application Integration on Oracle Cloud ,David Mills
TRN6459 Deep Dive: Oracle HCM Cloud: Getting Started with the New Onboarding Experience,Amy Kust
TRN6460 Deep Dive: Oracle Big Data/Oracle Big Data Cloud: Run Your Big Data from Anywhere,Susan Jang
TRN6461 Deep Dive: An Introduction to Workflow Approval Processes in Financials Cloud,Cristian Ramirez
TRN6462 Deep Dive: Oracle Database 18c New Features: Continuing Database Innovations,Ron Soltani
TRN6501 HOW TO Redesign your Person Spotlight,Amy Kust
TRN6502 How to Use Oracle HCM Cloud’s News Feed Layout,Amy Kust
TRN6503 How to Utilize the Synchronization of Line Manager,Amy Kust
TRN6507 How to Set Up Revenue Price Profiles,Cristian Ramirez
TRN6509 How to Perform Basic Approval Configurations,David Mills
TRN6510 How to Manage Typical Workflows,David Mills
TRN6511 How to Apply Policies to an API,David Mills
TRN6513 How to Provision Oracle SOA Cloud Service,David Mills
TRN6515 How to Develop Simple Mobile Applications with Oracle Mobile Cloud Service,David Mills
TRN6516 How to Create Web Applications,David Mills
TRN6517 How to Develop Mobile Applications with Oracle Visual Builder Cloud Service,David Mills
TRN6518 How to Develop Applications Using Oracle SOA Cloud Service,David Mills
TRN6519 How to Get Value from Data in Oracle Analytics Cloud,Phil Scott
TRN6520 How to Combine Data from Source Sites,Phil Scott
TRN6521 How to Prepare Data from Oracle Business Intelligence Cloud Service,Phil Scott
TRN6522 How to Create a User-Managed Platform,Phil Scott
TRN6523 How to Provision a Compute Instance,Susan Jang
TRN6524 How to Understand the Components and Workflow of Oracle Blockchain Cloud Service,Susan Jang
TRN6526 How to Scale Oracle Autonomous Data Warehouse,Susan Jang
TRN6613 Using a Seeded System Template in Oracle Hyperion Financial Management,Andrea Auld
TRN6614 Using the Supporting References Functionality in Subledger Accounting,Andrea Auld
TRN6615 Create a Rule in Oracle E-Business Tax to Determine a Tax Rate for Tax Line,Andrea Auld
TRN6616 Create Database REST APIs for Mobile Apps Using Oracle Application Express,Joe Greenwald
TRN6617 Filter Big Data Streams Easily Using Java Streams,Joe Greenwald
TRN6618 Expose Enterprise Integration Services as Custom RESTful APIs ,Joe Greenwald
TRN6774 How to Cure Those Digital Adoption Blues: Oracle Guided Learning,D.J. Hoelscher
TRN6775 How to Increase Oracle HCM Cloud User Adoption with Oracle Guided Learning,Sofia Donello
TRN6963 Enhancing Oracle Fusion Applications Security with Oracle Identity Cloud Service,Atul Goyal

Code One
BOF4622 OpenMessaging: New Messaging Standard Under the Linux Foundation,Jia Feng
BOF4737 Designing APIs for Cloud Infrastructure with Embedded DSLs,Esteban Ginez
BOF4759 Writing Better Code (Faster) in the Apache NetBeans IDE,Mark Stephens
BOF4760 Hacking the NetBeans IDE,Mark Stephens
BOF4820 Got a Gig Teaching Java? You Should Be Using Apache NetBeans in the Classroom,Kenneth Fogel
BOF4909 API Evolution Challenges,Arash Shokoufandeh
BOF4967 Deep Learning for Application Performance Optimization,Zoran Sevarac
BOF4977 A Cloud- and Container-Based Approach to Microservices-Powered Workflows,Lucas Jellema
BOF4978 Implementing Microservices on Oracle Cloud: Open, Manageable, Polyglot, and Scalable ,Lucas Jellema
BOF4992 Using Type Annotations to Improve Your Code,Werner Dietl
BOF5037 Kotlin Back-End Services: What, Why, and How?,Chris Bailey
BOF5065 Let’s Be Honest: There Are More Java Villains Than Java Champions,Kenneth Fogel
BOF5096 Eclipse MicroProfile: What’s Next?,Ken Finnigan
BOF5129 How to Create a Fluent API DSL with Lambda Builders ,Ozan Gunalp
BOF5133 How to Start and Grow a Successful International Overseas Developer Community,ALBERTO SALAZAR
BOF5232 Introducing Agile into the US Air Force in 12 Parsecs or Less,Bob Larsen
BOF5314 Bytecode Manipulation with a Java Agent and Byte Buddy ,Koichi Sakata
BOF5326 MVC 1.0 Community BOF,Ivar Grimstad
BOF5341 How We Are Porting OpenJDK + Eclipse OpenJ9 to z/OS,Jason Yong
BOF5402 An Interactive Journey Through Data Science,Abraham Theodoor Miedema
BOF5501 Don’t Stay Restless; Enable Your Database for REST: A QuickStart Guide,Pieter Van Puymbroeck
BOF5511 There and Back Again, or How to Connect Oracle Database and Big Data,Gleb Otochkin
BOF5606 One Metadata to Rule Them All: Open Approach to Metadata for Better Releases,Baruch Sadogursky
BOF5640 Filling the Gap Between Web Standards and Simplified Development,AMahdy Abdelaziz
BOF5714 Istio and Envoy: Enabling Sidecars for Microservices,Angela Chin
BOF5923 Elastic JVM: Automatic Vertical Scaling of the Java Heap,Ruslan Synytsky
BOF5929 Kubernetes for Java Developers,Anthony Dahanne
BOF5949 Rapid, Iterative Kubernetes Development with Java, Using Visual Studio Code,Junyi Yi
BOF5952 How to Deal with Java Troubles on Microservices,Shinji Takao
BOF6086 Accelerating Big Data Analytics on Oracle Cloud,Khun Ban
BOF6120 The Journey of Rakuten, the Biggest Ecommerce Firm in Japan, from REST to GraphQL,Prithviraj Pawar
BUS1224 DBA Does Docker,Timothy Hall
BUS2128 Thrive with Microservices Using DevOps in Oracle Cloud,Sai Janakiram Penumuru
BUS2272 Implementing a Low TCO Poly-Cloud Microservices Solution with Oracle Cloud,Lucas Jellema
BUS4591 Making Enterprise Blockchain a Reality: Oracle Blockchain Cloud Service Use Cases ,Mark Rakhmilevich
CAS4602 MySQL at Booking.com,Simon Mudd
CAS4606 How Facebook Got Consistency with MySQL in the Cloud,Sam Dunster
CAS4607 MySQL at Github: Handling Schema Changes,Jonah Berquist
CAS4609 MySQL with ProxySQL at Shopify,Rene’ Cannao’
DEV4293 Machine Learning Applied: Contextual Chatbots Coding, Oracle JET, and TensorFlow,Andrejus Baranovskis
DEV4295 Reliable, Fast, Engaging Offline-First Architecture for JavaScript Applications,Andrejus Baranovskis
DEV4303 The Diamond Model: A Sane Approach to Microservices Testing,Asaf Mesika
DEV4326 Functional Exception Handling in Java,Grzegorz Piwowarek
DEV4338 Getting Hip with JHipster,Sendil Kumar
DEV4344 Microservices in Action at the Dutch National Police,Bert Jan Schrijver
DEV4345 Angular for Java Developers,Bert Jan Schrijver
DEV4346 Top 10 Key Performance Techniques for Web and Hybrid Mobile Apps,Mohamed Taman
DEV4349 Effective Design of RESTful APIs,Mohamed Taman
DEV4353 The Japanese Java Community and Engineers,Yoshitaka Takahashi
DEV4366 Ten Common Mistakes Made in Functional Java,Brian Vermeer
DEV4389 Cool Crypto Concepts,Roy Wasse
DEV4396 You Got Arrested by the CAP; You Have the Right to Remain Consistent,Aviran Mordo
DEV4396 You Got Arrested by the CAP; You Have the Right to Remain Consistent,Aviran Mordo
DEV4399 Multidevice Controls: A Different Approach to UX,Gerrit Grunwald
DEV4403 MicroProfile Metrics: Practical Use Cases,Jose Amadeo Martin Diaz Diaz
DEV4430 Write More Better: Tech Writing for Developers,Elliotte Harold
DEV4434 Effective Unit Testing,Elliotte Harold
DEV4451 Visualizing and Analyzing GC Logs with R,Poonam Parhar
DEV4506 Contributing to the Mission Control OpenJDK Project,Marcus Hirt
DEV4507 Production-Time Profiling and Diagnostics on the JVM,Marcus Hirt
DEV4512 Java Debugging Tips,Martin Skarsaune
DEV4528 What Is Open Data?,Scott Sosna
DEV4552 Troubleshooting Native Memory Leaks in Java Applications,Poonam Parhar
DEV4580 Always Be Running: Long-Running and Fault-Tolerant Java Services,Michael Duigou
DEV4624 Developing a Cohesive User Experience,Chris Couture
DEV4625 Hands-on with PWA and Web Components,Marcus Hellberg
DEV4655 Capitalizing on a Great IDEA: Becoming a Superuser with IntelliJ,Maxim Novak
DEV4679 Apache Spark Now Runs on Kubernetes!,Bob Treacy
DEV4698 Handle the Complexity of Migrating to Microservices from Monolithic 10-Year-Old Code,ALBERTO SALAZAR
DEV4702 Micro Front Ends for Microservices with Oracle JET,Vijay Nair
DEV4704 Let’s Build a Blockchain in Java…in 40 Minutes!,Michel Schudel
DEV4732 Ultralow Latency with Java 11 and Terabytes of Data,Per-Ake Minborg
DEV4736 Evaluation of Machine Learning in R and Python and In-Database Machine Learning,Brendan Tierney
DEV4740 Event-Driven Microservices with Jakarta EE,David Heffelfinger
DEV4748 Java in a Serverless World with the Fn Project,Vladimir Dejanovic
DEV4790 From Monolith to Microservice DB and Improving App and Database Performance in Projects,Vladimir Dejanovic
DEV4796 Incorporating the Database into Your Agile and DevOps Workflow with Open Source,Shay Shmeltzer
DEV4797 Simplifying Oracle JET Development with Visual Tooling,Shay Shmeltzer
DEV4798 Using Java CompletionStage in Asynchronous Programming,Kuassi Mensah
DEV4813 Smart Contracts on Ethereum: Unboxing Truffle Box for Oracle JET,Robert van Molken
DEV4819 Running Our Robot Overlords with Jakarta EE,Kenneth Fogel
DEV4834 Deep Dive into gRPC,Vladimir Dejanovic
DEV4835 Analyzing Blockchain and Bitcoin Transaction Data as Graphs,Julia Kindelsberger
DEV4836 Stop Using JSON Web Tokens,Randall Degges
DEV4847 What Is CQRS+Event Sourcing and Why Should Java Developers Care?,Reza Rahman
DEV4861 Building Evolutionary Architectures in Agile Environments,Xavier RENE-CORAIL
DEV4867 Serverless, the Future of the Cloud?,Bert Ertman
DEV4873 Hacking Java and Spring Boot Applications with Visual Studio Code,Junyi Yi
DEV4878 Java Modularity: The Year After,Sander Mak
DEV4879 Getting Started with GraphQL APIs on Oracle Database with Node.js,Christopher Jones
DEV4908 Evolutionary Tales of an API,Arash Shokoufandeh
DEV4921 The Seven Deadly Sins of API Design,Luis Weir
DEV4948 How Does Ruby on Rails Work with MySQL, Oracle Database, and Other Databases,Yasuo Honda
DEV4959 DevSecOps: The Java Developer’s Guide to Automating with Groovy,Jeanne Boyarsky
DEV4961 There and Back Again: A Microservices Tale,Mark Little
DEV4963 Building Fault-Tolerant Batch Systems with Enterprise Java,Hirofumi Iwasaki
DEV4970 Microservice Patterns: Implemented by Eclipse MicroProfile,Ivar Grimstad
DEV4976 50 Shades of Data: How, When, Why—Big, Relational, NoSQL, Elastic, Graph, Event,Lucas Jellema
DEV4988 Implement Your Own Type System in 45 Minutes,Werner Dietl
DEV4994 Build a Front-End Application in 45 Minutes,Alex Nuijten
DEV5002 Master the Concepts Behind the Java 10 Challenges and Eliminate Stressful Bugs,Rafael Chinelato Del Nero rafaDelNero
DEV5009 Firefighting Java Big Data Problems,Alex Holmes
DEV5024 Teaching the Next Generation of Kids to Program in Java, Using Greenfoot,Michael Kölling
DEV5025 Improving Editing in IDEs with Structured Program Editing via JavaFX,Michael Kölling
DEV5026 REST-Enabled Neural Networks in Oracle Database 18c,Brendan Tierney
DEV5029 Practical DevOps with Linux and Virtualization,Simon Coter
DEV5043 Dive into the Internet of Things with Java 9/10/11,Alexander Belokrylov
DEV5047 The Go Language: Principles and Practices for Oracle Database,Christopher Jones
DEV5048 Java on ARM: Theory, Applications, and Workloads,Aleksei Voitylov
DEV5049 Getting Started with R and ROracle for Data Science with Oracle Database,Rajendra Pingte
DEV5058 Programming Modern Storage Devices with JDK10,Yingqi Lu
DEV5059 Using Machine Learning to Make DevSecOps a Reality,Vijay Tatkar
DEV5064 Delivering Developer Tools at Scale: Microsoft Azure and Oracle Cloud Perspectives,Joe Levy
DEV5066 Coroutines for Microservices,Eugene Petrenko
DEV5074 Turning Maven into a Highly Scalable, Resource-Efficient, Cloud-Ready Microservice,Alex Porcelli
DEV5081 Vector API for Java,Kishor Kharbas
DEV5082 Oracle Database MLE: JavaScript, Python, and More in the Database,Matthias Brantner
DEV5090 Machine Learning for Software Developers in 45 Minutes,Zoran Sevarac
DEV5091 Up and Away: JDK Optimizations Beyond JDK 9,Vladimir Kozlov
DEV5091 Up and Away: JDK Optimizations Beyond JDK 9,Vladimir Kozlov
DEV5102 Mastering JPA Performance,Thomas Broell
DEV5103 Applying Enterprise Integration Patterns to Serverless Java Functions,Brian Benz
DEV5106 Chatbots Best Practices and Design Patterns,Ruben Rodriguez Santiago
DEV5112 Three Recipes for Container-Native Development in Oracle Cloud,Arturo Viveros
DEV5118 Better Software, Faster: Principles of Continuous Delivery and DevOps,Bert Jan Schrijver
DEV5121 Jakarta EE: What Is It and What Does It Mean for Enterprise Java?,Mark Little
DEV5122 The Diabolical Developer’s Intro to Function as a Service for Java Developers,Mercedes Wyss
DEV5123 Tracking Spare Parts with Blockchain Featuring COZMO,Heli Helskyaho
DEV5125 Which Java Version from Which Vendor with What Support?,Jeanne Boyarsky
DEV5158 Develop, Build, Deliver, and Run Microservices with Containers in the Cloud,Eugene Fedorenko
DEV5164 Migrate Early, Migrate Often! JDK Release Cadence Strategies,Dan Heidinga
DEV5168 Spark Streaming Versus Kafka Streams: Two Stream Processing Platforms Compared,Guido Schmutz
DEV5184 Hardware and JVM Design Trends? Those Don’t Affect Me! Or Do They?,Dan Heidinga
DEV5187 Going Beyond JVM with Kotlin,Victor Kropp
DEV5190 Sensibly Storing Sensitive Stuff,Gustavo Durand
DEV5199 Five Java Features You Didn’t Know About,Per-Ake Minborg
DEV5205 Fuzzy Plans and Other Test Integrations ,Adam Farley
DEV5214 Building a Fault-Tolerant Microservice in an Hour,Antoine Sabot-Durand
DEV5257 An Innovative Java Memory Analysis Tool at Alibaba,Sanhong Li
DEV5262 Exploring Java Heap Dumps,Ryan Cuprak
DEV5269 Adventures with Reactive Streams,Jo Voordeckers
DEV5277 Integrating Vert.x,Kirk Pepperdine
DEV5284 Don’t Go, Java,Christoph Engelbert
DEV5285 What to Do When Your Boss Needs a Native Mobile App in Less Than 24 Hours?,James Weaver
DEV5290 Fast Prototyping of Enterprise Cross-Platform Mobile Applications with Java,José Pereda
DEV5302 Serverless in Depth,Mercedes Wyss
DEV5306 Integration Reloaded: Integration Solutions Based on Reactive Principles,Sven Bernhardt
DEV5349 Continuous Delivery with Containers and Java: Lessons Learned and Mistakes Made,Daniel Bryant
DEV5350 Testing Java Microservices: From Development to Production,Abraham Marin-Perez
DEV5352 Are You Deploying and Operating with Security in Mind?,Daniel Bryant
DEV5355 Location-Based Tracking of Moving Objects with Apache Spark,Siva Ravada
DEV5364 Continuous Delivery to Kubernetes with Jenkins and Helm,David Currie
DEV5366 Fast and Furious: Java Flight Recorder and Flame Graphs,Leonardo Freitas Gomes
DEV5370 Practical Library Design: Lessons Learned from Twitter4J,Yusuke Yamamoto
DEV5371 Helidon Deep Dive: An Up-Close Look at the Helidon Java APIs for Microservices,Joe Dipol
DEV5372 Benefiting from Java 9 Improvements,Venkat Subramaniam
DEV5373 Type Inference: Friend or Foe,Venkat Subramaniam
DEV5374 Reactive APIs of Java 9,Venkat Subramaniam
DEV5375 CompletableFuture: The Promises of Java,Venkat Subramaniam
DEV5377 Twelve Ways to Make Code Suck Less,Venkat Subramaniam
DEV5390 How to Make MySQL Work with Raft,Lixun Peng
DEV5391 JVM.Languages.Compare (Java, Kotlin, Groovy, Scala),Leonardo Lima
DEV5396 Lessons from the Design and Optimization of a Scalable Java Connection Pool,Jean De Lavarene
DEV5397 Automate Anomaly Detection with Graph Analytics,Sungpack Hong
DEV5420 When Graphs Meet Machine Learning ,Sungpack Hong
DEV5422 Helidon Extensions: CDI Extensions for the Cloud,Laird Nelson
DEV5423 Excise Trade Licensing on Blockchain,Deji Soetan
DEV5427 Bank Instruments on the Blockchain,Deji Soetan
DEV5432 Writing Kubernetes Controllers with Java SE and CDI 2.0,Laird Nelson
DEV5435 Diagnose Your Microservices: OpenTracing/Oracle Application Performance Monitoring Cloud,Marcus Hirt
DEV5439 MicroProfile and Jakarta EE: What’s Next?,Ian Robinson
DEV5441 Skaffold for Java: Continuous Development for Java Kubernetes Applications,Qingyang Chen
DEV5442 Three Resilience Patterns Out of the Box with Twitter’s Finagle HTTP Client,Eggie van Buiten
DEV5447 Graph Query Language For Navigating Complex Data ,Sungpack Hong
DEV5452 Kotlin as a Modernized Java,Roman Elizarov
DEV5458 Parallel Universe: Java Developer’s Guide to Front-End Development,Kito Mann
DEV5459 No Need to Panic: Concurrency in Go with Goroutines and Channels,Paul Anderson
DEV5464 MicroProfile Reactive Streams: Control the Streams,Gordon Hutchison
DEV5465 HTML5 Web Components State of the Union,Kito Mann
DEV5468 Test Automation with Selenium WebDriver, Java, and JUnit,Kito Mann
DEV5479 Build Serverless Big Data and Graph Viz Web Apps with Spring Data and Core Java,Kevin Madden
DEV5479 Build Serverless Big Data and Graph Viz Web Apps with Spring Data and Core Java,Kevin Madden
DEV5486 Cloud-Native Is About Culture, Not Containers,Holly Cummins
DEV5492 Java with Node.js: Powering the Next Generation of Web Applications,Chris Bailey
DEV5503 Holistic Testing at LinkedIn,Sajid Topiwala
DEV5504 Microservices: Get Rid of Your DBA and Send the DB into Burnout,Franck Pachot
DEV5506 Working on the Chain Gang: Using Oracle as Off-Chain Storage for Blockchain,Michael Ault
DEV5516 JavaFX.next,Kevin Rushforth
DEV5524 Compiling Faster, Compiling Better with Falcon,Ivan Krylov
DEV5525 Serverless Java: Challenges and Triumphs,Shaun Smith
DEV5539 Helidon: Java Libraries for Writing Microservices,Joe Dipol
DEV5541 Top Five MySQL Query Tuning Tips,Janis Griffin
DEV5557 Talk to Me, Goose: Going Beyond Your Regular Chatbot,Luc Bors
DEV5561 Shenandoah GC: The Next Generation,Roman Kennke
DEV5564 Microservices: Ten Steps to Build, Manage, and Monitor Your Microservices,John Sullivan
DEV5569 Building Mobile Apps with Gluon and Java Revisited,José Pereda
DEV5570 Get Reactive! Programming, Systems, and Microservices,Jeremy Davis
DEV5572 From Zero to Back End in 45 Minutes with Eclipse Vert.x,Jeremy Davis
DEV5579 Beyond git add/commit/push,Jorge Vargas Garcia
DEV5593 GraphPipe: Blazingly Fast Machine Learning Inference,Vish Abrams
DEV5595 The Hacker’s Guide to NoSQL Injection,Patrycja Wegrzynowicz
DEV5596 Lazy Versus Eager Loading Strategies for JPA,Patrycja Wegrzynowicz
DEV5599 Operating a Global-Scale FaaS on Top of Kubernetes,Chad Arimura
DEV5600 Cloud Native Developer Panel: Innovative Startup Use Cases,Bob Quillin
DEV5629 Perfecting Reliable Code Delivery in the Cloud with OpenTracing,Brian Benz
DEV5633 Dataverse Application: Modular Storage and Migration to the Cloud,Gustavo Durand
DEV5636 Going Web-Native,Marcus Hellberg
DEV5652 Condy? NestMates? Understanding JDK11’s JVM Features,Dan Heidinga
DEV5654 Add Tests to Legacy Code with Approval Tests,Scott Wierschem
DEV5659 Functional Programming in Java, Groovy, and Kotlin,Kenneth Kousen
DEV5665 Turning Your Java EE App Cloud-Native,Rodrigo Cândido da Silva
DEV5668 Real-Life SQL Tuning: From Four Minutes to Eight Seconds in an Hour,Liron Amitzi
DEV5676 The Hacker’s Guide to XSS,Patrycja Wegrzynowicz
DEV5677 Introducing Mockito 3,Szczepan Faber
DEV5687 Your Next Chatbot, from Idea to Execution,Donna Scheele
DEV5692 Build, Test, and Deploy with Jenkins, Puppet, and Nexus,Erik Lidström
DEV5695 Serverless Kotlin in Action: A Black/Silver Combo?,David Delabassee
DEV5705 Instant Startup and Low Footprint for Java,Oleg Selajev
DEV5706 Yes, JavaScript Is Faster Than Java (When You Use GraalVM)!,Paulo Lopes
DEV5711 Distributed Reactive Streams with RSocket, Reactor, and Spring,Stephane Maldini
DEV5758 Developing Predictive Applications with Oracle’s Machine Learning,Charlie Berger
DEV5760 How Machines Learn to Code: Machine Learning on Source Code,Thomas Endres
DEV5765 Practical Security in a Modular World,Martin Toshev
DEV5916 JUnit 5: The Next Step in Automated Testing for Java,Billy Korando
DEV5920 Augmented Reality for the Masses,Siamak Ashrafi
DEV5933 Type-Safe Approach to Invoking RESTful Services with MicroProfile Rest Client,Cesar Hernandez Mendoza
DEV5935 Caching in Applications Still Matters,Henri Tremblay
DEV5937 Modular Development with JDK 9 and Beyond,Alex Buckley
DEV5938 What’s New in the Java Platform Language and Tooling Area,Michel Trudeau
DEV5945 Transport Layer Security (TLS) v1.3 support in Java,Bradford Wetmore
DEV5947 MySQL at Scale at Square,Bill Karwin
DEV5948 How to Use JSON in MySQL Wrong,Bill Karwin
DEV5951 The New HTTP Client API in Java 11,Sergey Kuksenko
DEV5957 Develop Python Applications with MySQL Connector/Python,Jesper wisborg Krogh
DEV5959 Python and the MySQL Document Store,Jesper wisborg Krogh
DEV5970 Serverless Java,Ivar Grimstad
DEV5974 Anatomy of a Git Project,Victor Grazi
DEV5981 Develop PHP Applications with MySQL X Dev API,David Stokes
DEV5982 Performance Story: How to Speed Up HTTP/2 Client,Sergey Kuksenko
DEV5985 MySQL Connector/Node.js and the X DevAPI,Rui Quelhas
DEV5986 Node.js and the MySQL Document Store,Rui Quelhas
DEV5987 MySQL Shell: The DevOps Tool for MySQL,Alfredo Kojima
DEV5990 Migrating Java UI Client Applications to OpenJDK 11,Philip Race
DEV5992 How to Take Advantage of Optimizer Improvements in MySQL 8.0,Norvald Ryeng
DEV5994 MySQL at Uber: How to Stream Data with StorageTapper,Ovais Tariq
DEV5996 High-Speed Cryptography in Java: X25519, Poly1305, and EdDSA,Adam Petcher
DEV6001 Chasing the RESTful Trinity: Client, CLI, and Docs,Roberto Cortez
DEV6003 Unknown PL/SQL Code? Use PL/Scope to Gain Control,Vidar Eidissen
DEV6005 Java Garbage Collectors’ Current Performance Impact,Sergey Kuksenko
DEV6007 Collections Refueled,Stuart Marks
DEV6012 Var with Style: Local Variable Type Inference in Java,Stuart Marks
DEV6016 GraalVM and MicroProfile: A Polyglot Microservices Solution,Roberto Cortez
DEV6021 The Future of JMS 3.0,David Blevins
DEV6028 ZGC: A Scalable Low-Latency Garbage Collector,Per Liden
DEV6032 A Thousand Things You Always Wanted to Know About SSO but Never Dared Ask,Luis Rodriguez Fernandez
DEV6043 Let’s Make Graph Databases Fun Again with Java,Otavio Santana
DEV6048 Java EE Monolith to Cloud-Ready Architecture: Lessons from the Drools/jBPM Ecosystem,Alex Porcelli
DEV6053 How to Create an Architecture for Web Test Automation,Elias Nogueira
DEV6058 Development Horror Stories,Roberto Cortez
DEV6060 JVM CPU and Memory Settings for Docker Containers in Production,Andreas Hochleitner
DEV6064 Improve Startup Performance and Reduce Footprint with Application Class Data Sharing,Ioi Lam
DEV6066 Hiding in Plain Sight: Real Problems Lurking in Open Source Projects,Tim Veil
DEV6070 Adding Geospatial Features to a Java Web App,Matti Tahvonen
DEV6072 Developing Java Applications with Visual Studio Code,Fred Bricon
DEV6073 Modernize Your Existing Applications with Microservices,Sherwood Zern
DEV6074 Incremental Improvements to the Java Platform,Paul Sandoz
DEV6075 Project Panama’s Foreign API,Maurizio Cimadamore
DEV6076 Running JavaFX 11 on Embedded Devices: Challenge Accepted!,José Pereda
DEV6078 Service Mesh Patterns on Oracle Cloud Infrastructure Container Engine for Kubernetes,Sherwood Zern
DEV6084 IoT Edge Security with Java Card 3.1,Saqib Ahmad
DEV6089 Robotics on Java Simplified,Marcus Hirt
DEV6103 Flight Recorder in OpenJDK,Erik Gahlin
DEV6109 Jakarta EE Meets NoSQL in the Cloud Age,Otavio Santana
DEV6110 Containerized MySQL,Patrick Galbraith
DEV6113 Building a Polyglot GraphQL Server,Jobinesh Purushothaman
DEV6123 Solving the N + 1 Query Problem for REST Microservices Without Any Framework,Sebastien Pelletier
DEV6129 Visualizing JavaScript Development: Making JS Approachable,Shay Shmeltzer
DEV6141 Microservices for the Masses with Spring Boot, Angular, and JHipster,Matt Raible
DEV6143 What the Heck Are OAuth and OIDC?,Matt Raible
DEV6151 Monitoring Large-Scale Distributed Applications in Oracle Cloud,John Sullivan
DEV6177 Serverless Observability: Next-Generation Monitoring,Mert Caliskan
DEV6233 Connector/J Beyond JDBC: The X DevAPI for Java and MySQL as a Document Store,Filipe Silva
DEV6242 Delivering Mobile Apps to the Field with Oracle JET,Simon Haslam
DEV6243 Cool New Features for Developers in Oracle Database 18c and Oracle Database 12c,Timothy Hall
DEV6244 Analytic Functions: A Developer’s Best Friend,Timothy Hall
DEV6258 SQL Tuning 101,Alex Zaballa
DEV6262 Full-Stack Reactive with Spring and Angular,Loiane Groner
DEV6276 Client-Driven APIs,Mark Foster
DEV6482 Oracle, Blockchains, and the Stateful Internet,John Wolpert
DEV6626 Seamless ERP Integration with Blockchain for Procurement Contracts,Vivek Ahuja
DEV6627 Reducing Counterfeit Products with Oracle Blockchain Technology,Gurdeep Kalra
DEV6628 Modernizing Freelancing Contracts with Oracle Blockchain in the Publishing Industry,Gurdeep Kalra
DEV6811 Introduction to Micronaut: Ultra-Lightweight Microservices ,Graeme Rocher
DEV6822 Jamming with a Quantum Computer: A Musical Journey into Quantum Computing,James Weaver
DEV6959 Invest in Your Java Katalogue,Donald Raab
DEV6975 Cloud Native Java with Eclipse OpenJ9: Fast, Lean, and Definitely Mean,Mark Stoodley
DEV6977 Extending Spring Boot for the Enterprise,Pratik Patel
DEV6980 A Java Space Odyssey: Fun with Saucers, Lasers, Raspberry Pi’s, and Arduino,Frank Ji
HOL1703 A Practical Introduction to the MySQL Document Store,Lig Isler-turmelle
HOL1706 Developing Modern Applications with the MySQL Document Store and NodeJS,Lig Isler-turmelle
HOL2986 Using MySQL Common Table Expressions and Window Functions,Lig Isler-turmelle
HOL4508 OpenJDK Mission Control: The Hands-on-Lab – BYOL,Jeff Dinkins
HOL4680 Hacking and Hardening Java Web Applications Workshop – BYOL,Christopher Judd
HOL4683 Docker for Devs Workshop – BYOL,Christopher Judd
HOL4766 From Monoliths to Pragmatic Microservices with Java EE – BYOL,Ivar Grimstad
HOL4799 Hands-on Lab: The Asynchronous Java Database Access Driver ,Jean De Lavarene
HOL4852 Jakarta EE Hands-on Lab – BYOL,David Heffelfinger
HOL4957 Automating Your CI/CD Stack with Java and Groovy – BYOL,Scott Selikoff
HOL4957 Automating Your CI/CD Stack with Java and Groovy – BYOL,Scott Selikoff
HOL4973 DApps, Chaincode, Smart Contracts: Get Decentralized, or We’ll Go Without You! – BYOL,Axel Bronder
HOL5060 Advanced Performance Security for Hybrid Clouds with Oracle Management Cloud – BYOL,Dave Le Roy
HOL5361 Reactive Java? Let Us Count the Ways – BYOL,Erin Schnabel
HOL5446 Getting Started with Functions and the Open Source Fn Project – BYOL,Shaun Smith
HOL5576 Ten Things You Can Do with GraalVM – BYOL,Chris Seaton
HOL5759 ML 101: Oracle Data Miner/Oracle Autonomous Data Warehouse Cloud Machine Learning Notebook – BYOL,Brendan Tierney
HOL5927 Container-Native Application Development – BYOL,Chip Baber
HOL5998 Eclipse JNoSQL: One API to Many NoSQL Databases – BYOL,Leonardo Lima
HOL6006 Lambda Programming Laboratory – BYOL,Jeff Dinkins
HOL6325 Build a Web App with Oracle REST Data Services and Oracle JavaScript Extension Toolkit,Ashley Chen
HOL6329 Python and Oracle Database 18c: Scripting for the Future,Christopher Jones
HOL6375 Using Oracle Cloud Infrastructure Container Engine for Kubernetes,Christophe Pauliat
HOL6376 Using Terraform with Oracle Cloud Infrastructure,Christophe Pauliat
HOL6600 Containerized Development with Docker – BYOL,Chip Baber
HOL6879 Accelerated Mobile Apps Development – BYOL,Shay Shmeltzer
IGN6874 Ignite Session,Roy van Rijn
MTE6735 .NET Development for Oracle Database,Alex Keh
MTE6748 GraphPipe: Blazingly Fast Machine Learning Inference,Vish Abrams
MTE6764 MySQL Python, MySQL PHP, and MySQL Java,Jesper wisborg Krogh
MTE6767 Oracle’s Machine Learning and Advanced Analytics,Charlie Berger
MTE6770 Project Helidon: Java Libraries for Microservices,Joe Dipol
PRM3963 Oracle Application Development Framework: What’s New and What’s Next,Shay Shmeltzer
PRM4556 Managing Development Projects Across Oracle Cloud Services: A Guide,Murtaza Amiji
PRO1696 MySQL 8.0 and InnoDB: Tablespace Management Best Practices,Sunny Bains
PRO1696 MySQL 8.0 and InnoDB: Tablespace Management Best Practices,Sunny Bains
PRO1702 Upgrading to MySQL 8.0 and a More Automated Upgrade Experience,Staale Deraas
PRO2091 Running JavaScript Stored Programs Inside MySQL Server,Norvald Ryeng
PRO2998 MySQL 8.0 Is Here,Mike Frank
PRO3008 MySQL 8.0: What Is New in Optimizer and Executor,Norvald Ryeng
PRO3056 Introduction to the MySQL Document Store,Mike Zinner
PRO3073 What’s New in MySQL 8.0 Security,Georgi Kodinov
PRO3964 DevOps and Agile Methodology: Lessons Learned,Shay Shmeltzer
PRO3981 Making SaaS Your Own: Extending and Customizing with Low-Code JavaScript,JT Thomas
PRO3985 Build Mobile Apps Fast with Oracle Visual Builder Cloud Service,Laura Akel
PRO4063 Oracle REST Data Services and REST APIs for Your Oracle Database,Colm Divilly
PRO4087 Make AppDev Fun Again, with the Oracle RAD Stack,Kris Rice
PRO4093 18(ish) Things Developers Will Love About Oracle Database 18c,Chris Saxon
PRO4233 Actionable Business Insights with Oracle Stream Analytics,Alex Kotopoulis
PRO4234 Stream Processing Enterprise Data with Oracle GoldenGate and Oracle Stream Analytics,Alex Kotopoulis
PRO4234 Stream Processing Enterprise Data with Oracle GoldenGate and Oracle Stream Analytics,Alex Kotopoulis
PRO4358 Build Cloud-Native Applications on Oracle Cloud,Pyounguk Cho
PRO4359 Design and Build Microservices Architecture on the Cloud,Pyounguk Cho
PRO4402 Deploying Oracle WebLogic Server Applications in Kubernetes,Monica Riccelli
PRO4514 Introducing Oracle’s High Productivity Dev Platform for Mobile, Web, Progressive Web Apps,Srini Indla
PRO4554 Visual JavaScript Development: How We Do It,Brian Fry
PRO4557 Loading Application Data in a Data Warehouse and a Data Lake in Batch and Real Time,Nishit Rao
PRO4601 Oracle MySQL Cloud Service,Airton Lastori
TIP1247 3D: Docker for Database Developers,Roel Hartman
TIP4059 Oracle SQL Developer Tips and Tricks,Jeff Smith
TIP4068 Optimizing the Performance and Scalability of Java Applications That Use an RDBMS,Jean De Lavarene
TIP4071 Microservices, Containers, Databases, and Persistence Models,Kuassi Mensah
TIP4075 Performance and Scalability Techniques for Oracle Database Applications,Rajendra Pingte
TIP4076 Python and Oracle Database on the Table,Christopher Jones
TIP4085 Accelerate Application Performance: Tips for Faster Oracle Database .NET Programs,Alex Keh
TIP4104 Appdev: Building Secure Database Applications Quickly in the Cloud Era,Alan Williams
TRN4019 Oracle GoldenGate: Automating Failover Using Grid Infrastructure with Microservices,Stephan Haisley
TRN4081 Building Real-Time Data in Web Applications with Node.js,Christopher Jones
TRN4084 Using .NET Core and Entity Framework Core on Linux/Windows with Oracle Database,Alex Keh
TRN4092 Maximizing the Value of Municipal Open Data APIs with Low-Code Development Tools,Marc Sewtz
TRN5774 Build Mobile/Progressive Web Apps: Oracle Visual Builder Cloud Service/Oracle Mobile Cloud,JT Thomas
TRN5777 Build Multilingual Digital Assistants/Chatbots: Oracle Digital Assistant,Ruben Rodriguez Santiago
TRN5793 Real-Time Insights to Build Better Digital Assistants and Chatbots Faster,Matthew Wright
TUT4348 Getting Started with Ethereum Private Blockchain,Mohamed Taman
TUT4487 Clouds in My Coffee: Java on Mobile for iOS and Android with Cloud Data,Paul Anderson
TUT4744 GraphQL in the Java World: Let’s Go for a Dive,Vladimir Dejanovic
TUT4828 Java 5, 6, 7, 8, 9, 10, 11: What Did You Miss?,Henri Tremblay
TUT4991 Preventing Errors Before They Happen: The Checker Framework,Werner Dietl
TUT5283 AdoptOpenJDK: Lessons Learned from the New Build Farm for Java Itself,Daniel Bryant
TUT5454 Query Real-Time Kafka Streams with Oracle SQL,Melliyal Annamalai
TUT5544 Setting Up Asynchronous Systems with Fn Flow,José Paumard
TUT5930 Kubernetes for Java Developers,Anthony Dahanne
TUT6265 Angular for Java Enterprise Developers,Loiane Groner
TUT6318 Using the MySQL Binary Log as a Change Stream ,Luis Soares

Jonathan Lewis's picture

Join Cardinality – 5

So far in this series I’ve written about the way that the optimizer estimates cardinality for an equijoin where one end of the join has a frequency histogram and the other end has a histogram of type:

It’s now time to look at a join where the other end has a height-balanced histogram. Arguably it’s not sensible to spend time writing about this since you shouldn’t be creating them in 12c (depending, instead, on the hybrid histogram that goes with the auto_sample_size), and the arithmetic is different in 11g. However, there still seem to be plenty of people running 12c but not using the auto_sample_size and that means they could be generating some height-balanced histograms – so let’s generate some data and see what happens.


rem
rem     Script:         freq_hist_join_04a.sql
rem     Author:         Jonathan Lewis
rem     Dated:          Oct 2018
rem     Purpose:
rem
rem     Last tested
rem             18.3.0.0
rem             12.2.0.1
rem             12.1.0.2
rem             11.2.0.4        Different results
rem

drop table t2 purge;
drop table t1 purge;

set linesize 156
set trimspool on
set pagesize 60

set feedback off

execute dbms_random.seed(0)

create table t1(
        id              number(6),
        n04             number(6),
        n05             number(6),
        n20             number(6),
        j1              number(6)
)
;

create table t2(
        id              number(8,0),
        n20             number(6,0),
        n30             number(6,0),
        n50             number(6,0),
        j2              number(6,0)      
)
;

insert into t1
with generator as (
        select 
                rownum id
        from dual 
        connect by 
                level <= 1e4 -- > comment to avoid WordPress format issue
)
select
        rownum                                  id,
        mod(rownum,   4) + 1                    n04,
        mod(rownum,   5) + 1                    n05,
        mod(rownum,  20) + 1                    n20,
        trunc(2.5 * trunc(sqrt(v1.id*v2.id)))   j1
from
        generator       v1,
        generator       v2
where
        v1.id <= 10 -- > comment to avoid WordPress format issue
and     v2.id <= 10 -- > comment to avoid WordPress format issue
;

insert into t2
with generator as (
        select
                rownum id
        from dual
        connect by
                level <= 1e4 -- > comment to avoid WordPress format issue
)
select
        rownum                                  id,
        mod(rownum,   20) + 1                   n20,
        mod(rownum,   30) + 1                   n30,
        mod(rownum,   50) + 1                   n50,
        28 - round(abs(7*dbms_random.normal))   j2      
from
        generator       v1
where
        rownum <= 800 -- > comment to avoid WordPress format issue
;

commit;

prompt  ==========================================================
prompt  Using estimate_percent => 100 to get height-balanced in t2
prompt  ==========================================================

begin
        dbms_stats.gather_table_stats(
                ownname          => null,
                tabname          => 'T1',
                method_opt       => 'for all columns size 1 for columns j1 size 254'
        );
        dbms_stats.gather_table_stats(
                ownname          => null,
                tabname          => 'T2',
                estimate_percent => 100,
                method_opt       => 'for all columns size 1 for columns j2 size 20'
        );
end;
/

As in earlier examples I’ve created some empty tables, then inserted randomly generated data (after calling the dbms_random.seed(0) function to make the data reproducible). Then I’ve gathered stats, knowing that there will be 22 distinct values in t2 so forcing a height-balanced histogram of 20 buckets to appear.

When we try to calculate the join cardinality we’re going to need various details from the histogram information, such as bucket sizes, number of distinct values, and so on, so in the next few queries to display the histogram information I’ve captured a few values into SQL*Plus variables. Here’s the basic information about the histograms on the join columns t1.j1 and t2.j2:


column num_distinct new_value m_t2_distinct
column num_rows     new_value m_t2_rows
column num_buckets  new_value m_t2_buckets
column bucket_size  new_value m_t2_bucket_size

select  table_name, column_name, histogram, num_distinct, num_buckets, density
from    user_tab_cols
where   table_name in ('T1','T2')
and     column_name in ('J1','J2')
order by
        table_name
;

select  table_name, num_rows, decode(table_name, 'T2', num_rows/&m_t2_buckets, null) bucket_size
from    user_tables
where   table_name in ('T1','T2')
order by
        table_name
;

column table_name format a3 heading "Tab"
break on table_name skip 1 on report skip 1

with f1 as (
select
        table_name,
        endpoint_value                                                            value,
        endpoint_number - lag(endpoint_number,1,0) over(order by endpoint_number) row_or_bucket_count,
        endpoint_number
from
        user_tab_histograms
where
        table_name  = 'T1'
and     column_name = 'J1'
),
f2 as (
select
        table_name,
        endpoint_value                                                            value,
        endpoint_number - lag(endpoint_number,1,0) over(order by endpoint_number) row_or_bucket_count,
        endpoint_number
from
        user_tab_histograms
where
        table_name  = 'T2'
and     column_name = 'J2'
)
select f1.* from f1
union all
select f2.* from f2
order by 1,2
;


Tab                  COLUMN_NAME          HISTOGRAM       NUM_DISTINCT NUM_BUCKETS    DENSITY
-------------------- -------------------- --------------- ------------ ----------- ----------
T1                   J1                   FREQUENCY                 10          10       .005
T2                   J2                   HEIGHT BALANCED           22          20 .052652266

Tab                    NUM_ROWS BUCKET_SIZE
-------------------- ---------- -----------
T1                          100
T2                          800          40

Tab      VALUE ROW_OR_BUCKET_COUNT ENDPOINT_NUMBER
--- ---------- ------------------- ---------------
T1           2                   5               5
             5                  15              20
             7                  15              35
            10                  17              52
            12                  13              65
            15                  13              78
            17                  11              89
            20                   7              96
            22                   3              99
            25                   1             100

T2           1                   0               0
            14                   1               1
            17                   1               2
            18                   1               3
            19                   1               4
            20                   1               5
            21                   2               7
            22                   1               8
            23                   1               9
            24                   2              11
            25                   2              13
            26                   3              16
            27                   2              18
            28                   2              20

As you can see, there is a frequency histogram on t1 reporting a cumulative total of 100 rows; and the histogram on t2 is a height-balanced histogram of 20 buckets, showing 21, 24, 25, 26, 27 and 28 as popular values with 2,2,2,2,3 and 2 endpoints (i.e. buckets) respectively. You’ll also note that the t2 histogram has 21 rows with row/bucket 0 showing us the minimum value in the column and letting us know that bucket 1 is not exclusively full of the value 14. (If 14 had been the minimum value for the column as well as an end point Oracle would not have created a bucket 0 – that may be a little detail that isn’t well-known – and will be the subject of a little follow-up blog note.)

Let’s modify the code to join the two sets of hisogram data on data value – using a full outer join so we don’t lose any data but restricting ourselves to values where the histograms overlap. We’re going to follow the idea we’ve developed in earlier postings and multiply frequencies together to derive a join frequency, so we’ll start with a simple full outer join and assume that when we find a real match value we should behave as if the height-balanced buckets (t2) where the bucket count is 2 or greater represent completely full buckets and are popular values..

I’ve also included in this query (because it had a convenient full outer join) a column selection that counts how many rows there are in t1 with values that fall inside the range of the t2 histogram but don’t match a popular value in t2.


column unmatch_ct   new_value m_unmatch_ct
column product format 999,999.99

break on report skip 1
compute sum of product on report

with f1 as (
select 
        table_name,
        endpoint_value                                                            value, 
        endpoint_number - lag(endpoint_number,1,0) over(order by endpoint_number) frequency,
        endpoint_number
from 
        user_tab_histograms 
where 
        table_name  = 'T1' 
and     column_name = 'J1'
),
f2 as (
select 
        table_name,
        endpoint_value                                                            value, 
        endpoint_number - lag(endpoint_number,1,0) over(order by endpoint_number) frequency,
        endpoint_number
from 
        user_tab_histograms 
where 
        table_name  = 'T2' 
and     column_name = 'J2'
),
join1 as (
select
        f1.value t1_value, 
        f2.value t2_value, 
        f1.frequency t1_frequency, 
        f2.frequency t2_frequency, 
        sum(
                case
                        when f2.frequency > 1 and f1.frequency is not null
                                then 0
                                else f1.frequency
                end
        ) over()        unmatch_ct,
        f2.frequency * &m_t2_bucket_size *
        case
                when f2.frequency > 1 and f1.frequency is not null
                        then f1.frequency
        end     product
from
        f1
full outer join
        f2
on
        f2.value = f1.value
where
        coalesce(f1.value, f2.value) between 2 and 25
--      coalesce(f1.value, f2.value) between &m_low and &m_high
order by
        coalesce(f1.value, f2.value)
)
select  *
from    join1
;

  T1_VALUE   T2_VALUE T1_FREQUENCY T2_FREQUENCY UNMATCH_CT     PRODUCT
---------- ---------- ------------ ------------ ---------- -----------
	 2			 5			99
	 5			15			99
	 7			15			99
	10			17			99
	12			13			99
		   14			      1 	99
	15			13			99
	17	   17		11	      1 	99
		   18			      1 	99
		   19			      1 	99
	20	   20		 7	      1 	99
		   21			      2 	99
	22	   22		 3	      1 	99
		   23			      1 	99
		   24			      2 	99
	25	   25		 1	      2 	99	 80.00
							   -----------
sum								 80.00


We captured the bucket size (&m_bucket_size) for the t2 histogram as 40 in the earlier SQL, and we can see now that in the overlap range (which I’ve hard coded as 2 – 25) we have three buckets that identify popular values, but only one of them corresponds to a value in the frequency histogram on t1, so the Product column shows a value of 1 * 2 * 40 = 80. Unfortunately this is a long way off the prediction that the optimizer is going to make for the simple join. (Eventually we’ll see it’s 1,893 so we have a lot more rows to estimate for).

Our code so far only acounts for items that are popular in both tables. Previous experience tells us that when a popular value exists only at one end of the join predicate we need to derive a contribution to the total prediction through an “average selectivity” calculated for the other end of the join predicate. For frequency histograms we’ve seen that “half the number of the least frequently occuring value” seems to be the appropriate frequency estimate, and if we add that in we’ll get two more contributions to the total from the values 21 and 24 which appear in the height-balanced (t2) histogram as popular but don’t appear in the frequency (t1) histogram. Since the lowest frequency in t1 is 1 this would give us two contributions of 0.5 * 2 (buckets) * 40 (bucket size) viz: two contributions of 40 bringing our total to 160 – still a serious shortfall from Oracle’s prediction. So we need to work out how Oracle generates an “average frequency” for the non-popular values of t2 and then apply it to the 99 rows in t1 that haven’t yet been accounted for in the output above.

To calculate the “average selectivity” of a non-popular row in t2 I need a few numbers (some of which I’ve already acquired above). The total number of rows in the table (NR), the number of distinct values (NDV), and the number of popular values (NPV), from which we can derive the the number of distinct non-popular values and the number of rows for the non-popular values. The model that Oracle uses to derive these numbers is simply to assume that a value is popular if its frequency in the histogram is greater than one and the number of rows for that value is “frequency * bucket size”.

The first query we ran against the t2 histogram showed 6 popular values, accounting for 13 buckets of 40 rows each. We reported 22 distinct values for the column and 800 rows for the table so the optimizer assumes the non-popular values account for (22 – 6) = 16 distinct values and (800 – 13 * 40) = 280 rows. So the selectivity of non-popular values is (280/800) * (1/16) = 0.021875. This needs to be multiplied by the 99 rows in t1 which don’t match a popular value in t2 – so we now need to write some SQL to derive that number.

We could enhance our earlier full outer join and slot 0.5, 99, and 0.021875 into it as “magic” constants. Rather than do that though I’m going to write a couple of messy queries to derive the values (and the low/high range we’re interested in) so that I will be able to tweak the data later on and see if the formula still produces the right answer.


column range_low    new_value m_low
column range_high   new_value m_high
column avg_t1_freq  new_value m_avg_t1_freq
column new_density  new_value m_avg_t2_dens

with f1 as (
        select  endpoint_value ep_val,
                endpoint_number - lag(endpoint_number,1,0) over(order by endpoint_number) frequency
        from    user_tab_histograms
        where   table_name  = 'T1'
        and     column_name = 'J1'
),
f2 as (
        select  endpoint_value ep_val,
                endpoint_number ep_num,
                endpoint_number - lag(endpoint_number,1,0) over(order by endpoint_number) frequency
        from    user_tab_histograms
        where   table_name  = 'T2'
        and     column_name = 'J2'
)
select
        max(min_v) range_low, min(max_v) range_high, min(min_f)/2 avg_t1_freq, max(new_density) new_density
from    (
        select  min(ep_val) min_v, max(ep_val) max_v, min(frequency) min_f, to_number(null) new_density
        from f1
        union all
        select  min(ep_val) min_v, max(ep_val) max_v, null           min_f,
                (max(ep_num) - sum(case when frequency > 1 then frequency end)) /
                (
                        max(ep_num) *
                        (&m_t2_distinct - count(case when frequency > 1 then 1 end))
                )       new_density
        from    f2
        )
;

 RANGE_LOW RANGE_HIGH AVG_T1_FREQ NEW_DENSITY
---------- ---------- ----------- -----------
         2         25          .5     .021875


This query finds the overlap by querying the two histograms and reporting the lower high value and higher low value. It also reports the minimum frequency from the frequency histogram and divides by 2, and calculates the number of non-popular rows divided by the total number of rows and the number of distinct non-popular values. (Note that I’ve picked up the number of distinct values in t2.j2 as a substituion variable generated by one of my earlier queries.) In my full script this messy piece of code runs before the query that showed I showed earlier on that told us how well (or badly) the two histograms matched.

Finally we can use the various values we’ve picked up in a slightly more complex version of the full outer join – with a special row added through a union all to give us our the estimate:


break on report skip 1
compute sum of product on report

with f1 as (
select
        table_name,
        endpoint_value                                                            value,
        endpoint_number - lag(endpoint_number,1,0) over(order by endpoint_number) frequency,
        endpoint_number
from
        user_tab_histograms
where
        table_name  = 'T1'
and     column_name = 'J1'
),
f2 as (
select
        table_name,
        endpoint_value                                                            value,
        endpoint_number - lag(endpoint_number,1,0) over(order by endpoint_number) frequency,
        endpoint_number
from
        user_tab_histograms
where
        table_name  = 'T2'
and     column_name = 'J2'
),
join1 as (
select
        f1.value t1_value, f2.value t2_value,
        f1.frequency t1_frequency, f2.frequency t2_frequency,
        f2.frequency *
        case
                when f2.frequency > 1 and f1.frequency is not null
                        then f1.frequency
                when f2.frequency > 1 and f1.frequency is null
                        then &m_avg_t1_freq
        end *
        &m_t2_bucket_size        product
from
        f1
full outer join
        f2
on
        f2.value = f1.value
where
        coalesce(f1.value, f2.value) between &m_low and &m_high
order by
        coalesce(f1.value, f2.value)
)
select  *
from    join1
union all
select
        null,
        &m_avg_t2_dens,
        &m_unmatch_ct,
        &m_t2_rows * &m_avg_t2_dens,
        &m_t2_rows * &m_avg_t2_dens * &m_unmatch_ct
from
        dual
;


  T1_VALUE   T2_VALUE T1_FREQUENCY T2_FREQUENCY     PRODUCT
---------- ---------- ------------ ------------ -----------
         2                       5
         5                      15
         7                      15
        10                      17
        12                      13
                   14                         1
        15                      13
        17         17           11            1
                   18                         1
                   19                         1
        20         20            7            1
                   21                         2       40.00
        22         22            3            1
                   23                         1
                   24                         2       40.00
        25         25            1            2       80.00
              .021875           99         17.5    1,732.50
                                                -----------
sum                                                1,892.50


It remains only to check what the optimizer thinks the cardinality will be on a simple join, and then modify the data slightly to see if the string of queries continues to produce the right result. Here’s a starting test:


set serveroutput off

alter session set statistics_level = all;
alter session set events '10053 trace name context forever';
alter session set tracefile_identifier='BASELINE';

select
        count(*)
from
        t1, t2
where
        t1.j1 = t2.j2
;

select * from table(dbms_xplan.display_cursor(null,null,'allstats last'));

alter session set statistics_level = typical;
alter session set events '10053 trace name context off';


 COUNT(*)
----------
      1327


PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  f8wj7karu0hhs, child number 0
-------------------------------------
select         count(*) from         t1, t2 where         t1.j1 = t2.j2

Plan hash value: 906334482

-----------------------------------------------------------------------------------------------------------------
| Id  | Operation           | Name | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
-----------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT    |      |      1 |        |      1 |00:00:00.01 |      41 |       |       |          |
|   1 |  SORT AGGREGATE     |      |      1 |      1 |      1 |00:00:00.01 |      41 |       |       |          |
|*  2 |   HASH JOIN         |      |      1 |   1893 |   1327 |00:00:00.01 |      41 |  2545K|  2545K| 1367K (0)|
|   3 |    TABLE ACCESS FULL| T1   |      1 |    100 |    100 |00:00:00.01 |       7 |       |       |          |
|   4 |    TABLE ACCESS FULL| T2   |      1 |    800 |    800 |00:00:00.01 |       7 |       |       |          |
-----------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - access("T1"."J1"="T2"."J2")

The E-rows for the hash join operation reports 1893 – and a quick check of the 10053 trace file shows that this is 1892.500000 rounded – a perfect match for the result from my query. I’ve modified the data in various ways (notably updating the t1 table to change the value 25 (i.e. the current maximum value of j1) to other, lower, values) and the algorithm in the script seems to be sound – for 12c and 18c. I won’t be surprised, however, if someone comes up with a data pattern where the wrong estimate appears.

Don’t look back

Upgrades are a pain. With the same data set and same statistics on 11.2.0.4, running the same join query between t1 and t2, here’s the execution plan I got:


SQL_ID  f8wj7karu0hhs, child number 0
-------------------------------------
select         count(*) from         t1, t2 where         t1.j1 = t2.j2

Plan hash value: 906334482

-----------------------------------------------------------------------------------------------------------------
| Id  | Operation           | Name | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
-----------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT    |      |      1 |        |      1 |00:00:00.01 |      12 |       |       |          |
|   1 |  SORT AGGREGATE     |      |      1 |      1 |      1 |00:00:00.01 |      12 |       |       |          |
|*  2 |   HASH JOIN         |      |      1 |   1855 |   1327 |00:00:00.01 |      12 |  2440K|  2440K| 1357K (0)|
|   3 |    TABLE ACCESS FULL| T1   |      1 |    100 |    100 |00:00:00.01 |       6 |       |       |          |
|   4 |    TABLE ACCESS FULL| T2   |      1 |    800 |    800 |00:00:00.01 |       6 |       |       |          |
-----------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------
   2 - access("T1"."J1"="T2"."J2")

Notice that the E-rows value is different. The join cardinality algorithm seems to have changed in the upgrade from 11.2.0.4 to 12c. I haven’t quite figured out how to get to the 11g result, but I seem to get quite close most of the time by making a simple change to the final query that I used to predict the optimizer’s estimate. In the case expression that chooses between the actual t1.j1 frequency and the “average frequency” don’t choose, just use the latter:


        case
                when f2.frequency > 1 and f1.frequency is not null
                        -- then f1.frequency    -- 12c
                        then &m_avg_t1_freq     -- 11g
                when f2.frequency > 1 and f1.frequency is null
                        then &m_avg_t1_freq
        end *
 

As I modified the t1 row with the value 25 to hold other values this change kept producing results that were exactly 2, 2.5, or 3.0 different from the execution plan E-Rows – except in one case where the error was exactly 15.5 (which looks suspiciously like 17.5: the “average frequency in t2” minus 2). I’m not keen to spend time trying to work out exactly what’s going on but the takeaway from this change is that anyone upgrading from 11g to 12c may find that some of their queries change plans because they happen to match the type of example I’ve been working with in this post.

In some email I exchanged with Chinar Aliyev, he suggested three fix-controls that might be relevant. I’ve added these to an earlier posting I did when I first hit the anomaly a few days ago but I’ll repeat them here. I will be testing their effects at some point in the not too distant future:

14033181 1 QKSFM_CARDINALITY_14033181   correct ndv for non-popular values in join cardinality comp.         (12.1.0.1)
19230097 1 QKSFM_CARDINALITY_19230097   correct join card when popular value compared to non popular         (12.2.0.1)
22159570 1 QKSFM_CARDINALITY_22159570   correct non-popular region cardinality for hybrid histogram          (12.2.0.1)
Richard Foote's picture

“Hidden” Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part IV” (Hallo Spaceboy)

In Part I, Part II and Part III we looked at some advantages of Global Indexes that may not be obvious to some. One of the advantages of a Local Index vs. Non-Partitioned Global Index is that a Local Index being a smaller index structures may have a reduced BLEVEL in comparison. This can save […]

connor_mc_d's picture

The strange place for INHERIT PRIVILEGES

A while back in an Office Hours session, I touched on a relatively new privilege in the database called INHERIT PRIVILEGES which is designed to avoid erroneous privilege escalation via AUTHID CURRENT_USER routines.

You can watch the full video below

But in a nutshell, it protects against of the concept of a low privileged account “asking” a higher privileged account to run something in order to get access to those higher privileges. In human terms, this is a me phoning the DBA and saying: “Hi, could you run my procedure for me?” when deep down inside the code of that procedure I’ve embedded something nasty.

The INHERIT PRIVILEGES is a new privilege that can be used to guard against such scenarios, but we had a question on AskTOM on where to find such grants. Interestingly, even though it is a privilege given on a user to a user, if you need to find where the privileges are granted, you need to look in DBA_TAB_PRIVS, and the user that is the subject of the privilege will be found in the TABLE_NAME column. Go figure </p />
</p></div>
    <div class=»

To prevent automated spam submissions leave this field empty.