Search

Top 60 Oracle Blogs

Recent comments

December 2011

Oracle Core: Essential Internals for DBAs and Developers book by Jonathan Lewis

In case you didn’t know, Jonathan Lewis’es new Oracle Core: Essential Internals for DBAs and Developers book is out (for a few weeks already).
I was the technical reviewer for that book and I can say it’s awesome! It will likely be the best Oracle internals book out there for the coming 10 years, just like Steve Adams’es Oracle Internal Services book was in the last decade :) 
Jonathan does a very good job explaining complex things in a simple enough way – and the book is not just dry listing of how things work inside Oracle database, but also why they work like they do and what are the benefits, limitations and side effects of the behavior.

Oracle Core: Essential Internals for DBAs and Developers book by Jonathan Lewis

In case you didn’t know, Jonathan Lewis’es new Oracle Core: Essential Internals for DBAs and Developers book is out (for a few weeks already).

I was the technical reviewer for that book and I can say it’s awesome! It will likely be the best Oracle internals book out there for the coming 10 years, just like Steve Adams’es Oracle Internal Services book was in the last decade :) 

Jonathan does a very good job explaining complex things in a simple enough way – and the book is not just dry listing of how things work inside Oracle database, but also why they work like they do and what are the benefits, limitations and side effects of the behavior.

Oracle Core: Essential Internals for DBAs and Developers book by Jonathan Lewis

In case you didn’t know, Jonathan Lewis’es new Oracle Core: Essential Internals for DBAs and Developers book is out (for a few weeks already).
I was the technical reviewer for that book and I can say it’s awesome! It will likely be the best Oracle internals book out there for the coming 10 years, just like Steve Adams’es Oracle Internal Services book was in the last decade :) 
Jonathan does a very good job explaining complex things in a simple enough way – and the book is not just dry listing of how things work inside Oracle database, but also why they work like they do and what are the benefits, limitations and side effects of the behavior.

DNS Config for RAC SCAN… Again…

Some time ago I wrote an article about configuring DNS for the SCAN address in Oracle 11gR2 RAC.

Over the last couple of days one of the Oakies has given me some feedback on the article based on his experiences with Oracle Linux 5.

For my virtual RAC installations I typically do the DNS configuration on the host machine, which is running Fedora. It seems Oracle Linux 5 is a little different. Just to make sure I ran through the setup on Oracle Linux 5 and 6 to see what the score was.

Visualizing Active Session History (ASH) Data With R

One of the easiest ways to understand something is to see a visualization. Looking at Active Session History (ASH) data is no exception and I’ll dive into how to do so with R and how I used R plots to visually present a problem and confirm a hypothesis. But first some background…

Background

Frequently DBAs use the Automatic Workload Repository (AWR) as an entry point for troubleshooting performance problems and in this case the adventure started the same way. In the AWR report Top 5 Timed Foreground Events, the log file sync event was showing up as the #3 event. This needed deeper investigation as often times the cause for longer log file sync times is related to longer log file parallel write times.

HOWTO: Using the Oracle XMLDB Repository to Automatically Shred Windows Office Documents (Part 1)

People who have attended the UKOUG presentation this year where Mark Drake, Sr. Product Manager XML Technologies / XMLDB, Oracle HQ, and I demonstrated the first principles of the XDB Repository, might have been impressed with its (GEO/KML Spatial, Image EXIF info) capabilities combined with Google Earth. This post will zoom in on how to

Read More…

VirtualBox 4.1.8 Released…

VirtualBox 4.1.8 is now available!

Happy upgrading… :)

Cheers

Tim…




Sherlock Holmes: A Game of Shadows…

Sherlock Holmes: A Game of Shadows is a worthy sequel to the previous film. I read a couple of reviews saying the plot was too complicated. This surprises me because I would have though most people who saw the first film would understand that you are not meant to be able to fathom the clues. The whole point is that he is so amazing he can string a bunch of trivial things together and come up with some outlandish conclusion. The more ridiculous the better as far as I’m concerned.

Return Of The Mack…

On my final day in Bulgaria I managed to leave my coat, hat and gloves in a restaurant about 2 hours away from Sofia. I realized when we were about 30 minutes from Sofia, but thought it was no point saying anything because we didn’t have time to go back and get them. When we arrived at the hotel someone else noticed I wasn’t wearing a coat and I explained my foolishness and thought no more of it.

A few days after I got home I got an email from Milena Gerova to say the coat had been located and she was going to post it back to me. A man in a van delivered it this morning, hence the title of the post, “Return of the mack”. Thanks very much Milena. :)

Correlation oddity

This one’s so odd I nearly posted it as a “Quiz Night” – but decided that it would be friendlier simply to demonstrate it. Here’s a simple script to create a couple of identical tables. It’s using my standard environment but, apart from fiddling with optimizer settings, I doubt if there’s any reason why you need to worry too much about getting the environment exactly right.