Tag: Pythian

Great things always happen overnight. That’s probably the case for European Oracle Apps DBAs in the same situation, like myself. This morning I read Steven Chan’s latest blog post about Java Web Start certification with Oracle E-Business Suite and its…

No matter your industry, you must continually innovate and differentiate with software. Smart companies think like startups and use software to stay ahead.

Performance Schema (PS) has been the subject of many, many recent discussions, presentations, and articles.  After its release in MySQL 5.7, PS has become the main actor for people who want to take the further steps in MySQL monitoring. At…

Make sure you check out Pythian’s speakers at Collaborate 15. Stop by booth #1118 for a chance meet some of Pythian’s top Oracle experts, talk shop, and ask questions. This many Oracle experts in one place only happens once a…

Normally when using Avro files as input or output to a MapReduce job, you write a Java main[] method to set up the Job using AvroJob. That documentation page does a good job of explaining where to use AvroMappers, AvroReducers,…

Musings about expressing dates using MMDD or DDMM.

As most DBAs are aware, the clean deletion of the old statspack snaps is very difficult up to rdbms version 9i. Thanks to the statspack.purge procedure introduced by oracle from 10gR1 version, now it’s possible to purge un-referenced data too….

AWR report is a great source of aggregated information on top activities happening in our databases. I use data collected in AWR quite often, and obviously the easiest way of getting the data out from the AWR is by running the…

Today’s blog post will discuss how to recover a subset of an Oracle database. Many of you would have come across different recovery scenarios, but I’ll be talking about a very different one that happened to me. The following are…

I recently blogged about Playing with ASM Online Migration and still soul searching from not having jumped on the ASM band wagon. How can online storage migration be performed before ASM came about? One option is using Logical Volume Manager…