Tag: DBA Lounge

The Job Growth of a DBA or How I Learned to Stop Worrying and Love the Bomb

A couple of years ago, I wrote in my personal blog in Spanish that being a DBA (Database Administrator) was the 7th best job opportunity to have in America, with an expected growth rate of 20% over the next 10…

Read More >

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.

Read More >

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 >