Top 60 Oracle Blogs

Recent comments

November 2012

Exadata Storage Indexes Part IV – Fast Full Table Scans (Speed of Life)

OK, let’s look at Storage Indexes in action. But first, following is the setup for the various demos to come. I basically create one table called BIG_BOWIE that’s about 1GB in size and then simply create another table called DWH_BOWIE where the contents of this are re-insert into itself a few times to get to about […]

Facebook news feed performance

From the article “Facebook shares some secrets on making MySql scale

“800 million users and handling more than 60 million queries per second” …”4 million row changes per second.”

and that was almost a year ago. Think what it’s like now!

Ever wonder why Facebook limits your friends to 5000?  Does Facebook want to stop people from using it to promote themselves?

Ever see this message “There are no more posts to show right now” on Facebook?

Notice it says “There are no more posts to show right now.”

Movember Fakery

Tomorrow will be day 7 of Movember and so far my facial hair is not as noticeable as I would like. You can see my progress, or lack of, on my Movember page.

So tonight, I was cutting my hair and decided a bit of Movember fakery was in order. I took some of the hair that came off my head and arranged it on my face. It was pretty gross as it kept going up my nose as I was breathing. :)


Possibly an item to file under “philosophy”, but a question came up in the seminar I was presenting today that prompted me to say blog (very briefly) about why I manage to be so good at avoiding errors and inventing workarounds to problems. You probably know that you may see an execution plan change when you add a foreign key constraint to a table – but today someone in the class asked me if this would still work if the constraint were to disabled. The immediate response that sprang to my mind was “surely not” – but the second thought was that I didn’t really know the answer and would have to check; and the third thought was that maybe it wouldn’t if disabled, but what about novalidate; and the fourth thought was whether the setting for query_rewrite_integrity would make a difference; and the fifth thought was to wonder if there were other conditions that mattered.

Learning to learn…

One of the things that disappoints me about all my time in education is that nobody actually taught me how to learn. Instead I had to stumble along, gradually trying to pick up what works for me. I guess I finally discovered how to learn during my PhD. What did I discover? That I learn in pretty much the same way as everyone else. Pity someone didn’t save me a few years and give me the heads-up a bit earlier. I read this quote from Dune recently,

“… because his first training was in how to learn. It’s shocking to find how many people do not believe they can learn, and how many more believe learning to be difficult.”

It’s actually pretty simple to push stuff from your short term to long term memory. All you have to do is,

Oracle Exadata X3 Database In-Memory Machine: Timely Thoughtful Thoughts For The Thinking Technologist – Part I

This is part one in a series of analytical posts to help IT professionals discern what is behind the latest nickname Oracle has chosen for Exadata Database Machine. The series will consist of:

  1. Oracle Exadata X3 Database In-Memory Machine: An introductory post – Part I
  2. “There’s Still No Such Thing As Pure OLTP, But At Least We Are Forced To Pay For Maximum Intel Xeon Cores” – Part II
  3. Exadata X3: Who Needs Balanced Producer-Consumer Data Flow – Part III

Oracle Exadata X3 Database In-Memory Machine – An Introduction
On October 1, 2012 Oracle issued a press release announcing the Oracle Exadata X3 Database In-Memory Machine. Well-chosen words, Oracle marketing, surgical indeed.

Words matter.

System Architecture Series: Introduction to the Series and Licensing

This blog post is an introduction to a few posts that can be grouped together under the banner of 'System Architecture'. Specifically, I'm referring here to Oracle Database System Architecture, not system architecture in general nor 'Oracle architecture' in general, which is an ever-growing beast. In this series of posts, I will take at look […]