Oracle Scratchpad

November 5, 2018

UKOUG Tech 18

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

One month day [ed: updated 1st Dec] 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 after filling a couple of gaps left by my first attempt:


14:00	Database block checking - the unknown truth
15:00	You probably don't need to read a 10053 trace file (ME)
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	10 Behavior Changes in Oracle 12c/18c


 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 with 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	Maximum Availability Architecture (MAA) with Oracle 12cR2 & GoldenGate 12cR2/R3 : A Customer Case Study 
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.

Update 1st Dec 2018

An important part of attending conferences is the opportunity you get to talk to other people who do similar work. So if you see me standing around doing nothing (or even if I’m in conversation with someone else) feel free to come and talk to me. If you have a problem you want to discuss don’t be embarrassed about asking me about it – at best I might tell you that there’s a straight-forward and safe solution, at worst I might start asking you for important background details and end up telling you that the problem is too complex to resolve in a few minutes chat.



  1. interesting agenda

    Comment by emanueol — November 5, 2018 @ 10:49 am BST 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 BST 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 BST 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