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.
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.
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.
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.
There is a very strong Oracle Community in Perth, Australia. I admire many Perth based Oracle User Group volunteers who year from your organizing a great Oracle event. This year it isn’t an exception. I just spent 30 minutes going through the program and I should say the lineup of speakers is very impressive. Here’s the schedule.
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.