Feed items
A Look at SQL Plan Management
All of us have experienced times when the runtime of a regularly executed report or query changes and not always for the better, inexplicably. The impact of these runtime changes can range from a simple annoyance to something that may severely impact business-critical operations. An organization requires consistent behaviors from their systems with little to no regression in runtime.
The smallest details are the ones that make you better
One of the things I love about my career (Oracle DataBase Administrator) , is how fragile it is on a day in and day out basis. I can say with certainty , that every day I turn on my laptop to start working, it can probably be my last day working as a DBA, and this is not because I want it to be, it’s because unlike many jobs out there, the smallest mistake I make, can be my last mistake in my current job.
Log Buffer #314, A Carnival of the Vanities for DBAs
It is an industry norm, supported by analyst researches that blogs are the best informal medium to share the information. This unique medium provides readers with increased leverage in negotiating the hard turns in their technological lives. Log Buffer makes that leverage more powerful.
Oracle:
Alan Gardner is deploying Cloudera Impala on EC2 with Example Live Demo.
Which partitions does the SQL statement access?
This is a short blog post on how one can prove that a particular partition of the table or index is accessed by a specific query.
The solution to this question seemed interesting enough to share it with you all. Here’s a short description of what I had:
Deploying Cloudera Impala on EC2 – Tips and Traps
A little while ago I blogged about (and open sourced) an Impala-powered soccer visualization demo, designed to demonstrate just how responsive Impala queries can be. Since not everyone has the time or resources to run the project themselves, we’ve decided to host it ourselves on an EC2 instance.
COLLABORATE 13 à la Pythian …
As per many previous IOUG/OAUG/Quest shows, Pythian is will be in Denver next week! It was a sunny day in the fall of 1991 when I gave my first paper at International Oracle User Week (IOUW), a pre-cursor to COLLABORATE and a few earlier incarnations called IOUG-Live and IOUG-Alive! It has been a whirlwind of papers and sessions since then and I for one am still speaking mainly about the good old database. It is the heart of my skill set and always will be part of it.
Meet Pythian’s Oracle Apps Experts at Collaborate 13!
The stars have aligned
There’s a rare event happening next week: All three of Pythian’s Oracle Apps tech leads will be in the same place. Vasu Balla, Maris Elsins, and recently-minted Oracle Ace Director Yury Velikanov will all be at Collab 13 this year.
How I Put My Collaborate Agenda Together
It is less than a week before the Collaborate 2013 conference. Most of us are busy putting together our individual agendas for what is shaping up to be a very exciting week. There are so many interesting sessions to choose from! Conference organizers kindly introduced a Show Planner to make planning a bit easier, but in this blog post, I will share with you how I created my agenda for Collaborate.
How to Get the Most Out of Collaborate! Talking from Experience
First, the most important advice I can give you is to relax and have FUN!
Using Ansible to secure Cloudera Manager installation on a Hadoop cluster
Building a secure Hadoop cluster requires protecting a number of services which comprise Hadoop infrastructure. If you are using CDH distribution, then Cloudera Manager (CM) is one of the components that needs to be secured. CM consists of Server, Agents running on all cluster machines and web UI. CM provides you with 3 levels of securing (good/better/best) it’s communication:
