I was just looking up a link to the original YAPP paper so that I could include it in the course notes and then noticed Anjo Kolk’s site is back online. I think it might be a little while before things are back to normal, though - sounds like there’s a bit of work to be done ….

Time for a quick break from the final push to complete the course slides. I’ve (probably foolishly) decided to apply the 10.2.0.4 patch to my test database.

As I was confirming the details of when Oracle starts to flush information from the ASH Buffer to the workload repository, I thought I’d check the value as it’s defined in a hidden parameter, _ash_eflush_trigger. The default is 66, which means that the flush begins whenever the circular buffer is 66% used, to stop it from wrapping around on itself, or filling up, whichever description you prefer.

Collaborate08, annual conference of the International Oracle User Group, and several other national and international user groups, will be held in Denver this year, from April 13th to the 16^th. I am going to present three papers, including (for the first time) Weird PL/SQL. I thought you might enjoy reading about some of the weirdnesses of PL/SQL in my ToadWorld blog, so here’s an excerpt from the beginning of my whitepaper.