Hotsos Symposium Speaker – Jonathan Lewis

Jonathan Lewis is a returning Hotsos Symposium presenter.


Jonathan LewisJonathan Lewis is a well-known figure in the Oracle world with more than 24 years experience using the software. He has published three books about Oracle, the most recent of which was published in Nov 2011, and contributed to three others. He runs a couple of websites and contributes fairly regularly to newsgroups, forums, and User Group magazines and events around the world.

Jonathan has been self-employed for most of his time in the IT industry. For the last eighteen years, he has specialized in short-term assignments, typically of a design, review, or trouble-shooting nature - often spending no more than two or three days on a client site to address problems. He runs seminars about using Oracle all over the world and has visited 50 different countries (and a dozen states in the USA) to talk about, or trouble-shoot, Oracle systems.

Presentation Title

Session #1: The Beginner's Guide to Becoming an Expert

Session #2: Creating Tests


Session #1: The Beginner's Guide to Becoming an Expert — In this slide-free presentation, Jonathan Lewis will discuss and demonstrate what it takes to become an expert in areas relating to Oracle performance. There will be NO "rocket-science" in this presentation, just simple demonstration and discussion. There will be plenty of time for questions and answers – and Jonathan will be asking most of the questions.

Session #2: Creating Tests — How does Oracle work ? You're never going to be able to answer that question, but if you create a sensible strategy for testing you'll have fewer nasty surprises as you implement new features or design new systems.

In this presentation, we cover a few topics that you need to consider when setting up a framework for testing. First, how to generate large amounts of data quickly and repeatably; then how to ensure that the data content and pattern is a reasonable match to the system you want to emulate (and creating patterns is not very difficult). We'll examine a couple of cases to show that you can be caught out by such simple errors as creating indexes at the wrong point in your testing, and the differences between using CTAS (create table as select) and pl/sql loops (especially run concurrently) to generate data.

Although it takes a lot of effort to create realistic models of production activity, we'll also look at simple ways of modelling some aspects of concurrency, and show how concurrency can make a massive difference to what goes on inside the database - time permitting we will take a look at a few dumps of internal structures (disk and memory) to highlight some of the effects of concurrency.

Presentation Materials

Presentation materials are available online to attendees only.


The speaker schedule is as follows: