Posts Categorized: Technical Blog

Amazon Elastic Load Balancer with Oracle E-Business Suite

This blog post outlines a couple of issues we faced in our Oracle E-Business consulting group when configuring Amazon Elastic Load Balancer with Oracle E-Business Suite 11i. The current IT industry trend is to virtualize all servers, and Oracle E-Business Suite servers are no exception. Among current cloud operators, Amazon Cloud infrastructure is a favorite…

How to Install Oracle 12c RAC: a Step-by-Step Guide

Okay, back to school folks, back to school :). As with any new product, our long learning journey starts with an installation on a sandbox environment. To get you up to speed with Oracle 12c RAC and let you focus on important stuff (e.g. features research), I have put together detailed step-by-step installation instructions. You…

How Filtered Indexes Look Like (Part 1)

“During one of my SQL Server Index Internals presentation, an attendee asked me how filtered indexes look like and if they are stored exactly the way the traditional indexes are. I was tempted to show the internals of how filtered indexes looked like using DBCC PAGE during the presentation, but held back because it deserves…

Do You Know If Your Database Is Slow?

The time to respond There was a question at Pythian a while ago on how to monitor Oracle database instance performance and alert if there is significant degradation. That got me thinking, while there are different approaches that different DBAs would take to interactively measure current instance performance, here we would need something simple. It…

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

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…

Page 8 of 55« First...678910...203040...Last »