January 2008 Archives

Schedule everything from within

This little except from the 10g Top 20 Features for DBA's which shows very neatly, how you can use the built-in Oracle scheduler to control events outside the database as well.

There are some nice examples of how to setup tasks to run via the Oracle dbms_job package.

Tokenizer

Okay, so we all love to build tokenizer's but take a look at this one. It is really versatile. I used it to easily convert some very dynamic path information into individual catagories - works great.

Explain Plan reports wrong indentation

In Oracle 10g the indentation used to visualize the level of individual statements within the overall execution plan is sometimes reported incorrectly. This report by Jonathan Lewis gives an example of how the visualization under 10g compares with that of 9i.

The bug is apparently partly fixed in 11g but it would appear you shouldn't take what you see for granted and best display the "level" as well.