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.
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.
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.
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…
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.
My tweet few days ago – “Personally I don’t see the point building ASM on (d)NFS. ASM suppose to exclude unnecessary layers. In NAS case it adds an additional layer.” Since then Oracle people in my Social Media environment helped me to find several legitimate reasons to run ASM on NAS. Thank you folks very much. Now I am sharing our common thoughts with the rest of the community.
While Oracle tech folks doing their best to explain meaning of not so many DNFS configuration file (oranfstab) parameters I still find an official description a bit confusing. Therefore I decided to share my understanding of the DNFS configuration parameters in hope that it will help someone or if my understanding is wrong someone corrects me :) So, if I am wrong please please please feel free to leave comments.
In this guide assume we are migrating a single instance database HRDEV to a two node RAC database HRPRD with following specifications.