Search

Top 60 Oracle Blogs

Recent comments

March 2013

How can we make Oracle Database 12cR2 the best release ever?

Oracle will be releasing Oracle Database 12cR1 at some point this year. Many companies will avoid this release, opting to wait for 12cR2, their reasoning being it will be more stable and, as a terminal release, will have a longer support life-cycle. Since 12cR2 is what most businesses care about, what can we do to make it as good as it can possibly be? Here are a few thoughts…

Data integrity constraint classification

Before we start investigating the complexities involved in implementing data integrity constraints using database triggers, we will first introduce a classification schema for data integrity constraints. Agreeing upon a classification scheme for constraints, helps us a lot in implementing them: for we can then approach the problem area on a class-by-class basis.

A classification scheme needs to have a few properties:

My current love/hate relationship with working in IT…

I wrote the following tweet the other day.

I love technology, but hate working in IT. The politics and bullshit drag you down… :( #baddayatwork

— Tim Hall (@oraclebase) February 28, 2013

I’ve been known to say on numerous occasions,

“Sometimes, a bad decision is better than no decision at all!”

I’m currently reading God Emperor of Dune by Frank Herbert and I just read this passage, which is a conversation between Leto (The God Emperor) and an Ixian Ambassador.

Source Control

You may recall that I spent some time with the developers at the redgate offices in Cambridge (UK) a little while ago, looking at their Source Control for Oracle package. The product is about to go live, with a launch date of 12th March.

Because of the help I’ve given them they’ve offered my readers the chance of winning one of two 5-user licences for the product – provided I devise a strategy for picking the recipients.

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

Registration

Description

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 »