Following up on my earlier webinar Implementing Oracle Exadata – Strategies for Success, I’ll be giving another webinar to present the results of the Exadata implementation at LinKShare. I’ll be talking about actual performance results, our zero-downtime go-live, compression experiences, and performance tuning in an Exadata environment.
There is a new tool came with Oracle 11g Rel.2 that helps to modify options in installed oracle home (Enabling and Disabling Database Options) It is very simple and straightforward utility that recompiles database kernel with different flags.
Oraenv is great utility that helps to control environment and to avoid exact use of ORACLE_… variables in scripts. With invention of ORACLE_BASE it was enhanced to change the variable and to print the value in the output. More interesting that behaviour of oraenv in 188.8.131.52 has been changed
and now it is able to switch oracle base variables but it does not show oracle home path in the output, only oracle base
If you ever had tried to switch Oracle net trace than you know that it is quite straight forward to switch it on. You would say that I need to set the following parameters in the sqlnet.ora file…
ourSquare, the location based social network, suffered from extended outage yesterday. They explained the causes in a blog post, which caused much discussion around the web. Here’s the gist of the analysis: FourSquare are using MongoDB, which is a sharded database. Data is split between nodes based on a shard key, usually the User ID or something similar. One of the shards became overly loaded. After failing to resolve the issue in other ways, FourSquare decided to add another shard to share the load. This caused the entire cluster to fail.
I was co-presenting recently at Sydney Oracle Meetup about Data Guard Compression and in preparation I did
some tests to see how it works for 184.108.40.206 (Linux x86-64). Here are my results.
I wrote my very first Catalyst plugin, and it’s going to be something useful for Galuga. As I don’t have a lot of time, I’ll be succint. As you’ve doubtlessly gathered by now, the name of the game is Catalyst::Plugin::Sitemap. It’s on Github, but it’s not CPANized yet. To use it, add the plugin to your Catalyst app main module
Being in the remote administration business is a strange beast and offers lots of challenges, but when you are working for multiple clients sometimes connecting to the servers can be challenging enough. Here’s a little idea that I had this morning that may save someone some grief, so I thought I would jot it down for all to see.
I’m giving a NoSQL overview presentation at MOTS in two days. The conference organizers didn’t ask me for a white paper, so I thought I could get away without writing one. But it turns out that I don’t really feel that I can speak confidently about a topic if I didn’t write the paper. I wonder if other presenters have this addiction too. So I’m posting the paper here for your enjoyment. Feedback is very welcome.