Oracle Scratchpad

September 16, 2012


Filed under: Oracle — Jonathan Lewis @ 8:41 pm BST Sep 16,2012

I’m working on creating two new courses – one of them about Oracle structures (tables, indexes etc.) the other about Oracle mechanisms (undo, redo etc.). The aim of the courses is to help people do the right thing, avoid the wrong thing, and recognise the difference; the latter, as you might guess, is based loosely on my last book. The courses will probably be ready some time around March next year.

One of the problems of creating the content for courses like this is getting the balance between what people really need to know,  what they already know, and what they would really like to know (or know better); so I thought I’d throw the idea open to the public and ask the question: what would you like to learn (more) about if you came on one of these courses.

Generally I’m hoping for response like: “how Oracle does X”, “Why Oracle does Y”, “What’s the difference between A and B”, “When is P better than Q”, “Why would you use feature F “, but it would be particularly helpful if you could also include a comment about why you think the point ought to be included.



  1. Is there any plans for online courses? ‘Cause i would really like to attend one of this.

    Comment by steelrat (@stee1rat) — September 16, 2012 @ 8:51 pm BST Sep 16,2012 | Reply

    • Steelrat,

      Not at present, although Oracle University has asked me about working through their virtual learning system. So far I haven’t managed to fit in any dates to have a go with their technology, but in principal I’ve said we could try it.

      Tanel recently asked if I would join in an on-line event with him, Cary Millsap and Kerry Osborne some time in the next couple of months – so keep an eye on the blog for an announcement.

      Comment by Jonathan Lewis — September 17, 2012 @ 8:53 pm BST Sep 17,2012 | Reply

  2. I really like your session during AIOUG in 2010. I would like you to explain upon how compression saves space and how it will have affect on DML performance when used on tables and corresponding indexes.

    Comment by Satish — September 17, 2012 @ 7:14 am BST Sep 17,2012 | Reply

    • Satish,

      Thanks for the comment – if I can persuade the ACE director program to pay my air-fare for 2013 I’ll try to fit AIOUG into my calendar again.

      Compression (table and index) is on the agenda, both for space saving and for side effects – though I haven’t made up my mind whether or not to include EHCC (Exadata hybrid columnar compression) in any detail.

      Comment by Jonathan Lewis — September 17, 2012 @ 8:50 pm BST Sep 17,2012 | Reply

  3. A possibly very contentious one: how to avoid paying for Oracle Enterprise Edition… ie how to make do with features that are available in Standard Edition. Many clients I visit don’t want to pay for EE or don’t have a license for eg Partitioning.

    Comment by Colin 't Hart — September 17, 2012 @ 9:04 am BST Sep 17,2012 | Reply

    • Colin,

      That’s a good idea.
      I’ll have to highlight the possibilities for using partition views instead of partitioned tables, and cunning tricks with B-tree indexes to substitute for btree/bitmap conversion. At the moment I can’t think of any other good examples – so feel free to give me a few one-liners.

      Comment by Jonathan Lewis — September 17, 2012 @ 8:48 pm BST Sep 17,2012 | Reply

  4. “what would you like to learn (more) about”

    How do you do this in PostgressSQL?
    Licence policy and price is driving away my will to promote Oracle.

    Comment by B. Polarski — September 18, 2012 @ 10:18 am BST Sep 18,2012 | Reply

  5. In a forum post about histograms you mentioned “for systems where new data is sequence (or time) based, and the critical queries are always for the data that has arrived since the last stats collection…” How to deal with this without fighting against Oracle concurrency when that data is also being updated.

    Comment by jgarry — September 18, 2012 @ 7:57 pm BST Sep 18,2012 | 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