I am currently in Long Beach, California for the Kaleidoscope 2011 conference. I attended the Database Development Symposium today (Sunday), which Chet volunteered to put together. It was an all day event and it was great. Here is a very brief summary of the presentations:
Cary Millsap talked about performance and how you can measure it by analyzing throughput and response time. Sequence diagrams are a good performance analysis tool, Cary mentioned. He then demonstrated MR Trace, a very useful Oracle trace file collector extension for Oracle SQL Developer.
Sten Vesterli took the stage next and talked about what development tools are hot or not. He mentioned a few interesting points:
By the way, check out Sten’s OraToolWatch.com page.
Then Kris Rice and Sue Harper presented about SQL Developer 3.0 new features and SQL Developer Data Modeler 3.0 new features. It was nice to see that the data modeler is now tightly integrated with subversion. You could even merge data models. Later, Marc de Oliveira talked about how important it is to model your data and processes.
Then it was Tom kyte‘s turn. He talked about instrumentation, after all About 50% of oracle database code is debug code! Advice from Tom: use dbms_application_info, dbms_monitor and dbms_trace. Here is a quick tip: If you have a long running query and you do not see it in V$SESSION_LONGOPS, the query is probably not optimized.
Finally, Dominic Delmolino talked about agile development practices. Tip from Dominic’s presentation: Turn on auditing to track database changes and store the audit trail as XML on the operating system.
It was a very good first day. Looking forward to the next four days.
Thanks to Cary and Chet (pictured above) for hosting the DB dev symposium.
The Long Beach Convention Center is a great Kscope venue by the way, and most importantly, Wifi did not suck