Tag: DBA Lounge

The Importance of an Action Plan

When I started my work in IT, I used to be in a very small shop. And even though we had people in several places in the same state, everything used to be very centralized, and work was from 9…

Read More >

Opening the Door Without the Keys

This week, my DBA team fulfilled a request to restore 1 month old lost data.  A review of the RMAN backups showed that we indeed had a valid level 0 from the requested day, which was 33 days ago.  However,…

Read More >

The Undocumented Status “M” of an RMAN Backup

It is not uncommon for Oracle to have something undocumented , and this is just another case of this ailment. We have a database in which we have two copies of the same backup: one kept in the FRA and…

Read More >

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…

Read More >

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…

Read More >

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.

Read More >

COLLABORATE 13 à la Pythian

Like many previous IOUG/OAUG/Quest shows, Pythian will be in Denver next week!

Read More >

Meet Pythian’s Oracle Apps Experts at Collaborate 13!

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. Since we’re a globally distributed, round-the-clock team, this is not something that can happen very often.

Read More >

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.

Read More >

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!

Read More >