Managing Oracle on Windows: Where’s my Oratab?

If you manage Oracle on Windows, you probably have wondered why it is so difficult to work out which Oracle instances are running and which ORACLE_HOMEs they use. On Unix or Linux, this is a very simple task.  Oracle services and their ORACLE_HOMEs are listed in the oratab file, located in /etc/ on most platforms…

Exadata Join Offloading in Action

One of the biggest selling features of Oracle’s flagship engineered system – Exadata – is the storage offloading capabilities. Storage offloading allows data to be filtered as soon as it is read from storage, reducing the amount of data that database hosts need to process. The storage layer is a shared-nothing MPP architecture and in…

Oracle Database Load Testing Tools – Overview

At Pythian’s internal forum, someone just asked the following question: “The team here is evaluating DB load testing tools (Hammerdb, Orion, SLOB, and Swingbench) and was wondering about our experience in using different tools and what is our opinion?” I have experience using some of the tools mentioned. Therefore, decided to answer using this public…

Hard Drive: Inner or Outer?

To be precise, I wonder if OUTERmost tracks of a spinning HDD are faster than INNERmost tracks. Should we put physical IO performance secretive data to OUTERmost parts of  the disk and less critical data to INNERmost parts as several vendors suggests? Well I couldn’t find a better solution than grabbing all HDDs I have and start testing :)

Thoughts on Intel’s Hadoop Distribution

When I heard that Intel announced their own Hadoop distribution, my first thought was “Why would they do that?”. This blog post is an attempt to explore why anyone would need their own Hadoop distribution, what Intel can gain by having their own and who is likely to adopt Intel’s distribution. Why does anyone need…

Pythian’s Third Annual Geek Pride Day


The day has arrived, and it’s probably one of our favorite days at Pythian – Geek Pride Day! Since May 25 (the “official” day according to Wikipedia) falls on Saturday, we celebrated it a day early so everyone could participate. For the third year in a row, our 250+ global Pythianites have had the opportunity…

ODA Re-imaging Could Take Anywhere Between 20 and 120 Minutes

This blog posts explains why Oracle Database Appliances re-imaging process timing may vary from 20 to 120 minutes. There are a check in the ISO:/Extras/ script that have an issue. Until the bug is fixed a) you may face different ODA nodes’ re-imaging times b) to be on the safe side check if md devices’ re-synchronization process is finished by running “cat /proc/mdstat” command before running any business critical processes on your ODA.

Page 8 of 42« First Page...678910...20...Last Page »