Top 60 Oracle Blogs

Recent comments


Oracle Exadata - Storage Indexes

Wow! - I was stunned a few days ago by Exadata’s Storage Indexes. I was doing a little testing to see what could be offloaded and what couldn’t (more on that later). I have a 384 million row table I was using on our Exadata Quarter Rack test system. A single threaded full scan with no where clause on the table takes about 24 seconds (ho hum - it’s amazing how quickly we become numbed to the outstanding performance ). So imagine my surprise when I decided to check and see how many nulls I had in a column and the result came back in .07 seconds. Wow! I thought it was a bug! Turns out it was the Storage Indexes. Alright already, I’ll show you some output from the system (by the way, as usual I used a couple of scripts: fsx.sql and mystats.sql):

Mister Trace

For the past several weeks, my team at Method R have been working hard on a new software tool that we released today. It is an extension for Oracle SQL Developer called Method R Trace. We call it MR Trace for short.

MR Trace is for SQL and PL/SQL developers who care about performance. Every time you execute code from a SQL Developer worksheet, MR Trace automatically copies a carefully scoped trace file to your SQL Developer workstation. There, you can open it with any application you want, just by clicking. You can tag it for easy lookup later. There’s a 3-minute video if you’re interested in seeing what it looks like.

Exadata has arrived, part 1

At the 5th of august, the database machine (half rack) has arrived at VX Company. The machine arrives wrapped (in plastic) on a pallet.

Because the whole rack is already assembled, which means all the parts are already in the rack, the machine is quite heavy (600 kilograms I’ve been told). After some pushing, pulling and lifting together, we arrived at our serverroom.

Next is the hardware configuration and attaching the network cables from the database machine to our network.

After the cables have been mounted and checked, the power is turned on, and all the database (4) and storage servers (7) are turned on!

The 9th of august we carry on configuring the machine with Oracle ‘ACS’ (Advanced Customer Support), to configure the database and storage servers.

Tagged: oracle database machine exadata

I am an ACE Director!

Yesterday I received a mail from the Oracle ACE team (Victoria and Lillian) telling me I was nominated for ACE Director, and that the nomination was accepted.

This means I am an ACE Director now!

Thanks to the Oracle ACE team and everybody who was involved and everybody who congratulated me!

Tagged: oracle ace aced director

Environment Variables in Grid Control User Defined Metrics

This post originally appeared at the Pythian blog.

Emerson wrote: “Foolish consistency is the hobgoblin of small minds”. I love this quote, because it allows me to announce a presentation titled “7 Sins of Concurrency” and then show up with only 5. There are places where consistency is indeed foolish, while other times I wish for more consistency.

Here is a nice story that illustrates both types of consistency, or lack of.

This customer Grid Control installed in their environment. We were asked to configure all kinds of metrics and monitors for several databases, and we decided to use the Grid Control for this. One of the things we decided to monitor is the success of the backup jobs.

Oracle’s next blockbuster deal…

I got an email today, which I think is for once a genuine one…beside that, just before Oracle Open World, its always interesting to guess about what Mr. Ellison is about to announce…

I have checked out the site/post and, besides the apparent ones (PR), I couldn’t find any hidden traps (always a bit, healthy I hope, paranoia on this kind of stuff).

From: Stephen Jannise
Sent: Tuesday 3 August 2010 19:57
To: Marco Gralike
Subject: Editorial question about your blog

Hi Marco,

I thought you would be interested in an article I’ve written about Oracle’s next blockbuster deal. The company’s surprising acquisition of Sun suggests that Oracle is willing and able to make major deals in unexpected areas. I’m interested to see where they go next, so I’m hosting a poll on my blog at:

I’ve presented a list of thirteen potential targets for readers to vote on. Rather than guess these targets at random, I’ve done some research into the past five years of Oracle acquisitions as well as studied the current market to make some educated suggestions about possible future acquisitions.

Responses are trickling in, so I’m reaching out to a few bloggers to spread the word and drive more responses. Would you mind posting a brief entry about this on your blog? I would really appreciate your help. Please let me know what you think.



Stephen said about his article in one of his emails to me:

Oracle 5 Installation Steps

While browsing my old pictures, I discovered two small directories with some installation snapshots I once made, because there is almost no info left about this topic (besides in people’s heads) I left it here for “past” reference…

Double click on it to go to the bigger “version” on Picassa.

Cloning Oracle Home from RAC to Stand-Alone

This post originally appeared over at Pythian. There are also some very smart comments over there that you shouldn’t miss, go take a look!

This should have been the easiest task on my todo list: Install Oracle EE standalone on a new Linux RHEL 5 server, later to be used as a standby for a production RAC system. This means 2 lines of “runinstall -silent …”, less than 5 minutes of DBA work and maybe 20 minutes of waiting. I did not expect to spend over 5 hours doing this.

Problems started when I discovered that I don’t have the patchset and another patch that exists on production and should be installed on the standby. I had to wait for my Metalink credentials to be approved for this customer CSI before I could download the patches for them.

“Why don’t you just clone the software from production?” asked a helpful colleague.

Exadata v2 Smart Scan Performance Troubleshooting article

I finally finished my first Exadata performance troubleshooting article.

This explains one bug I did hit when stress testing an Exadata v2 box, which caused smart scan to go very slow – and how I troubleshooted it:

Thanks to my secret startup company I’ve been way too busy to write anything serious lately, but apparently staying up until 6am helped this time! :-) Anyway, maybe next weekend I can repeat this and write Part 2 in the Exadata troubleshooting series ;-)

Enjoy! Comments are welcome to this blog entry as I haven’t figured out a good way to enable comments in the google sites page I’m using…


Dropping interval partitions – Revisited

In a previous posting about dropping interval partitions I explained how the transition point in an interval partitioned table can be moved up to be able to drop partitions. I explained that by temporarily converting the table from interval to range partitioning, all interval partitions are converted into range partitions. Last week I discovered, suggested […]