Top 60 Oracle Blogs

Recent comments

March 2013

Friday Philosophy – Do good DBAs need PL/SQL Skills?

This Friday Philosophy was prompted by a discusion between some OakTable people about did we think “good” DBAs should know PL/SQL? Not all the tricks, bulk processing, using all the built-ins, but able to write PL/SQL with cursor loops and some exception handling that could eg cycle thorough tables and archive off data or implement some logon trigger functionality.

My response was “that depends on the age of the DBA”.

If you had asked me that question 15 years ago I would have said Yes, a good DAB would and should know PL/SQL.
If you had asked me 10 years ago I would have said I’d hope they would and most DBAs I respected has some PL/SQL skills.
If you had asked me 5 years ago I would have sighed and had a little rant about how they should but the younger ones don’t and that is wrong.

Secret Hacking Session: Find Out How Oracle SQL Plans Are Really Executed!

Yes, I am going to run a yet another secret hacking session next week!

  • Title: Secret Hacking Session: How Oracle SQL Plans Are Really Executed!
  • Date: Tuesday, March 5, 2013
  • Time: 10:00 AM – 12:00 PM PST



This is not a yet another talk about how to extract and display execution plans.

It is also not a theoretical talk about how to read execution plans in general.

You should know this stuff already :)

Hotsos 2013 – From Unstructured to Structured…

It has been a while that I have been attending Hotsos, although that is how it feels. In 2011 I flew to Hotsos to see, among others presentations from Maria Colgan, but I ended up being sick the whole week while learning on my hotel room to enjoy American TV. In 2012 I skipped Hotsos …

Continue reading »