Oracle Scratchpad

November 5, 2018

UKOUG Tech 18

Filed under: Non-technical — Jonathan Lewis @ 10:46 am GMT Nov 5,2018

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:


14:00	Database block checking - the unknown truth
15:00	You probably don't need to read a 10053 trace file
16:10	Oracle Database 12c consolidation: why and how to manage CPU resources
17:10	Securefiles - the hidden storage organisation inside LOB segments


 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


 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


 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.


  1. interesting agenda

    Comment by emanueol — November 5, 2018 @ 10:49 am GMT Nov 5,2018 | Reply

  2. Hi Jonathan, This is a mouth-watering agenda. I am not a member of UKOUG. What would it cost to get my hands on these presentations?

    Regards, Amir

    Comment by Hameed, Amir — November 5, 2018 @ 3:33 pm GMT Nov 5,2018 | Reply

    • Amir,

      You would have to contact the UKOUG ( to find out if they have any plans for wider access than members only.

      Comment by Jonathan Lewis — November 5, 2018 @ 6:36 pm GMT Nov 5,2018 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by