ALL POSTS

RMAN: Corrupt Block? Let’s Re-Read… Nope, It’s All Good

Just received a page about “Corrupt block”. From the first look it kind of scary to receive such page 40 minutes before your shift ends. Right?
After examining an alert.log (see below) and looking through knowledge bases found an explanation that it isn’t as bad as I thought. I liked the explanation I found therefore I decided to share it with rest of the world. Here you go folks

When Disaster Strikes: Hurricane Sandy

We devoted the Palomino Newsletter this month to the important topic of disaster recovery, in light of the challenges posed by Hurricane Sandy. If you’re not already receiving our newsletter, you can subscribe here. Hurricane Sandy has been on many people’s minds of late; mine not least.  Having lived the last 4 years of my life…

Webpage Time Zone Hopping

Timezones can be darn confusing. So I thought, wouldn’t be nice to be able to switch the times back and forth on a webpage, such that you don’t have to juggle the time differences in your head, but rather just see the full thing first from your timezone perspective, then from the other guy’s?

ShareDir Without the Leftover Blues

The trick is simple: bundle all the files to be shared into a tarball called shared-files.tar.gz. As there is now only that one file, which name always remains the same, any new install is conveniently clobbering the old version.

Analyzing SQL Server Data File Anatomy

In this post, I will explain a little more deeply the physical structure of a SQL Server data file. Unfortunately, I cannot write all the assumptions, behaviours and details about this theme, but you will read a good overview of a file structure and a good start point to understand, and read more, about indexes internals, file fragmentation, transaction log internals and so on… Before we start, let’s remember some vital concepts.

Log Buffer #293, A Carnival of the Vanities for DBAs

Like every year, Pythian is once again holding a company-wide charity campaign to raise funds and awareness for for men’s health, specifically prostate cancer and male mental health. Sporting and sprouting the mustaches has already begun at Pythian and the game is on. While that happens, blogging fanfare also continues and this Log Buffer Edition in its Log Buffer #293 covers that and more.

Chef Cookbooks for HBase on CentOS Released

At Palomino, we’ve been hard at work building the Palomino Cluster Tool. Its goal is to let you build realistically-sized[1] and functionally-configured[2] distributed databases in a matter of hours instead of days or weeks as it is at present. Today marks another milestone toward that goal as we release our Chef Cookbook for building HBase…

Pythian at Oracle with 20:20 Foresight Perth Australia

Perth is far from everywhere, but not far from the Oracle technologies. Passion, knowledge, and urge to share the experience, skills, tips and knowledge brought people from across the planet to gather under one roof and learn, educate and network under the banner of Oracle with 20:20 Foresight.

Select Statement Generating Redo and Other Mysteries of Exadata

Like many good stories, this one also started with an innocent question from customer: “I often check “SELECT COUNT(*) FROM TABLE;” on our old 10.2.0.4 cluster and the new Exadata. The Exadata is slower than our old cluster by few minutes. Exadata is not good at count(*) ? or other problem?” Here’s how I fixed it.

Page 59 of 276« First...102030...5758596061...708090...Last »