More Jonathan Lewis

Anton Scheffer

A little while ago, Jonathan Lewis presented a three day seminar in The Netherlands. You may have read other blogs on this site about this seminar. AMIS had sent six people to attend. And yes, I was one of the lucky ones too.
Although the seminar should be for developers and DBA’s, most of its content was aimed at DBA’s. As a developer I don’t think undo, redo and latches are very interesting. But there were enough nice things to make the seminar very useful. For instance

  • A nice example of how the way/order which records are inserted into a table can have impact on the performance of retrieving the data, due to differences in the clustering factor of the data/indexes.
  • An other example of querying simular datasets (in the same way), but with huge performance differences, if you are unlucky with some internal hash functions of Oracle.
  • A working example of the "go_faster" hint
  • A nice trick to get the DBA-role, see http://www.red-database-security.com/exploits/oracle_sql_injection_oracle_dbms_metadata.html
  • and much more

Anton

Next Post

JDeveloper and Subversion

Facebook0TwitterLinkedinI am happy to see that a subversion extension is available for JDeveloper (10.1.3). Although it is still an early access version, it seems to work properly. Currently it relies on an installed subversion client, hopefully it will be build in into JDeveloper in the future. Use the update manager […]