Thanks for the feedback...
“All about Binds” is currently my favorite technical session to deliver. It sounds like a really mundane topic that I’ve beaten totally to death – but it isn’t! Getting into SQL injection and showing it – I am totally amazed that on average less than 10% of the audiences I’ve polled (sometimes as low as 0%!) are familiar with SQL injection. That is scary to me. Demonstrating what this magic thing called “bind variable peeking” is (the part of my session where I “prove” that when it is raining on Monday mornings, you must restart Oracle twice… Not really – I demonstrate how easy it is to fall into false causality without a little research and knowledge…). And closing with the foibles of cursor_sharing = force or similar (and why you really don’t want to use them unless you are forced to – and even then, for as little as possible).
This year, based on inputs from that blog entry (and because they interest me as well!) I’m going to prepare these two new sessions:
- Performance Impact of the Log Errors Clause in 10gR2: This session will look at the new log errors clause available for use with BULK DML operations in the 10gR2 database. We will see what the clause does, investigate how it does what it does, explain limitations/restrictions inherent with using the clause and finally - compare the performance of slow by slow processing versus bulk DML with log errors - and maybe even compare bulk DML with and without log errors for performance
- Instrumentation 101: This session will talk about the importance of heavily instrumenting your code and explore the possible methods of instrumenting your code in an Oracle environment - concentrating on developed code both in the database (stored procedures) as well as outside the database (java, C, VB and the like).
These sessions always start as “one hour topics” but over the year will grow into 1 to 2 hour sessions if history is anything to judge by. When I first gave All about Binds – it took 1 hour. Now, I can still do the short version in one hour but really much prefer two hours to do it justice. Same with the SQL Techniques and in fact, most of the sessions. It seems every time I give a session, it gets a couple of minutes longer as I figure out better ways to explain the concept or better demos (based on the questions I get – I refine the material so that question doesn’t have to be asked again – I hope).
I will be referring back to that blog for the other ideas over time so some of the other topics will get included eventually.
On a related note, I was catching up on some blogs and saw this one from Pete_S. It reminded me once again of this blog entry I had a while ago. Design matters, really, it does.