I find myself forgetting on how to disable Oracle AUTO_TASKs on regular basis. Therefore I have decided to document it under this small blog post. As an additional bonus I may hear others experience in the area. So if you disagree or have some other experience please do not hesitate to comment under this post.
Log writer process of Oracle is one of the most revered background process, a real work horse, a real charming darling who keeps the whole Oracle database system consistent and humming beautifully and many technologies in Oracle sprout from this good old process. Consistency is the key in database systems, and so in the Log Buffer Editions, and this Log Buffer #294 continues it. And yes, the coolest 2012 PASS Summit is also there.
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
In this blog post I am publishing my SLOB tests results and conclusions testing Oracle database IO performance placing data files on NFS directly and on ASM disk group located on NFS.
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…
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?
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.
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.
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.
At Palomino, we’ve been hard at work building the Palomino Cluster Tool. Its goal is to let you build realistically-sized and functionally-configured 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…