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.
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.
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…
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.
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
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.
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.
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.
We’ve now received a response to the issue described in the previous entry. In short oui updates at install time are broken (apparently fixed in 18.104.22.168, but no updates are available for that release yet to check. Hi , The OUI looks for the metadata for the patches. There is an unpublished bug 11709996 on [...]
December 18, 2011 It seems that I have been quite busy lately with computer related tasks that are not associated with Oracle Database, making it difficult to slow down and focus on items that have a foundation in logic. Today I have had some spare time to dig further into the recently released “Oracle Core” [...]