Friday, October 07, 2011

Back from Open World...

I just returned home from Oracle Open World 2011.  It was good to meet some new faces and meet up with some old ones.

I had five sessions this year - one of them was a panel session (no content to post) - and all of them had good audiences and good questions at the end.  I've posted the materials I used here for download.  All of the powerpoints  plus the scripts I used to demonstrate what I was talking about are included.  It should all be on the Open World site as well (only the powerpoints, no separate scripts) as they collected all of the presentations from every session as it was happening and uploaded them.

Again - thanks to everyone that attended one of my sessions, I hope you got something useful out of it...


Anonymous Anonymous said....

Thanks Tom. Your presentation on 5 Things ... PL/SQL was really informative and entertaining.


Fri Oct 07, 12:59:00 PM EDT  

Blogger ? said....

Are you sure you want to distribute the ppt template?


Fri Oct 07, 04:42:00 PM EDT  

Blogger Thomas Kyte said....


I always do... (distribute the ppt's)

Fri Oct 07, 05:13:00 PM EDT  

Anonymous Doug Burns said....

Sorry we didn't get a chance to say hello, but you were surrounded by questioners at the end of the panel session I attended ;-) and we all know how chaotic it is meeting up with people there ...

Fri Oct 07, 10:33:00 PM EDT  

Blogger Stephen O'Donnell said....

5 things about SQL was excellent. Unfortunately I missed the 5 things about PLSQL.

I also caught your SQL tuning panel which was very good.

Thanks once again for the great work, I have seen you present quite a few times now, and I always get a lot out of the sessions.

Sat Oct 08, 12:24:00 AM EDT  

Blogger Stew Ashton said....

Nothing to do with Oracle Open World, sorry. The 11GR2 documentation library was updated yesterday, and as a result two links are broken in your most recent Oracle Magazine column. For example, try

Sat Oct 08, 12:12:00 PM EDT  

Anonymous Bruce Winters said....

I was fortunate to have attended 2 of your sessions. THANKS.

I was unable to replicate one of the examples you listed in your PLSQL session related to "implicit cursors are evil", until I upped the for i .. in 10 up several notches. My cpu work was showing 0 for both cases until I raised the value, then was able to observe the differences between the implicit conversion vs the non-conversion.

Also, I recompiled several procedures which are scheduled to go to production next Friday, using the PLSQL_Warnings to enable:all, and observed the PLW-07202 error all over the place.

That is going to become a standard requirement, for sure.

You should write books.

Sat Oct 08, 01:07:00 PM EDT  

Blogger smatta said....

Thank you Tom, I have attended couple of your sessions in Oracle Open world. Really informative. Thanks alot for the great work.

- Sobhan Matta, Ashburn, VA

Sat Oct 08, 10:26:00 PM EDT  

Blogger Thomas Kyte said....

@Stew, thanks, I've let the powers that be know about this.


It was "implicit CONVERSIONS" :) not cursors. Implicit cursor rock and roll, they are awesome. Implicit conversions on the other hand = evil.

As for the looping, I had 1,000,000 rows in my table - so that was 10,000,000 conversions.

Glad to hear about the new standard :)

(I have written a few books...)

Sun Oct 09, 10:46:00 AM EDT  

Anonymous Sokrates said....

Thanks for the ppts

- whats new in oracle app dev.pptx :
"Oh yes, it's free"
ASH AWR stuff and SQL tuning advisor included ?

Mon Oct 10, 02:44:00 AM EDT  

Blogger Thomas Kyte said....


the "it's free" was for the data modeler that comes with sql developer now.

The data modeler used to be a "for fee" option for sql developer, it is now "for free"

ASH and AWR require the optional license to access.

Mon Oct 10, 10:01:00 AM EDT  

Anonymous Chris Jones said....

Hi Tom,

It was great to have lunch with you at OOW. Thanks for posting your sessions materials.


Mon Oct 10, 07:10:00 PM EDT  

Blogger Thomas Kyte said....

@? Now I see what you meant - you are correct, thanks for the heads up!

Mon Oct 10, 07:54:00 PM EDT  

Anonymous Sokrates said....

I really thought that must have been an interesting presentation, pity that I missed you talking about Customized Arrows, Venn Diagrams (Four vs. Three Circles), Colour Palettes, Cropping Images and all this kind of stuff !

Tue Oct 11, 01:40:00 AM EDT  

Anonymous Anonymous said....

Great info. I attended two of your sessions last week.

BTW - I have not been able to find where to download the presentations on the OpenWorld web site. Can someone tell me where that is?


Tue Oct 11, 11:54:00 AM EDT  

Blogger Thomas Kyte said....


I just went to

and clicked on "content catalog" on the bottom of that page and from there I could search and see the pdfs.

I notice that my name only brings up two of my sessions though.. But they are all there if you search by venue/track/day etc...

Tue Oct 11, 12:03:00 PM EDT  

Anonymous Srini V said....

Tom - I was in your- 5 things on PL/SQL, very informative. This was my first session of yours. Greatly enjoyed it. Thank you!

Fri Oct 14, 03:06:00 PM EDT  


<< Home