Posts Categorized: Technical Blog

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 :)

My Pro-Tips for YAPC First-Comers

Woe, woe is me. After two years of YAPC, meddling circumstances force me to skip attendance this year. Still, I am extremely pleased to know that Pythian is still sending one of our young Padawans into the fray. Yesterday, he was asking me if I had any tips, survival strategies, or any words of wisdom…

EBS Forms Compilation Errors in Large Terminal Windows: Size Does Matter!

During a recent customer environment cloning activity, I got myself up to the point where CUSTOM.plx was required to be recompiled. Nothing difficult, you might say, right? I thought the same. But that activity just killed lots of troubleshooting hours for me. frmcmp_batch.sh call was just failing with “Terminal map initialization failed.” [oracle@appslab01 ~]$ frmcmp_batch.sh…

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/setupodaovm.sh 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.

How to Collect Cluster Information Using TSQL

Sometime back, I was involved in a project that consisted in collecting information for the servers we are supporting – creating an inventory of servers. Logging into each server and collecting information is a bit tedious when you have hundreds of servers in your environment.  I have spent sometime creating a script that does this…

MetaCPAN JavaScript API

Sometimes, it’s humongous revolutions. Most of the time, it’s itsy bitsy evolutionary steps. Today’s hack definitively sits in the second category, but I have the feeling that it’s a little dab of abstraction that is going to provide a lot of itch relief.

How Different Datatypes Affect Performance

When I was in high school, my practical arts teacher asked us to create a miniature of a structure. This meant looking at the blueprints of an existing structure and using it to create a small replica. I thought that this would be a great opportunity to learn more about reading blueprints and understanding what…

Page 14 of 60« First...1213141516...203040...Last »