Tag: Pythian

You work for a software company. You don’t? Think again.

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

Read More >

Part 1: How to Effectively Use a Performance Schema

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…

Read More >

Pythian at Collaborate 15

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…

Read More >

Avro MapReduce Jobs in Oozie

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,…

Read More >

MM-DD or DD-MM?

Musings about expressing dates using MMDD or DDMM.

Read More >

Purge statspack snaps of source db on test db having different DBID?

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….

Read More >

Do AWR Reports Show the Whole Picture?

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…

Read More >

How to recover a subset of an Oracle database

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…

Read More >

Online Storage Migration without ASM

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…

Read More >

How to move Oracle DB to New Oracle Home on Same Windows Server

I have been thinking about writing a Pythian blog for long time, and today I finally took the opportunity. In the DBA life, it’s common to get a request to move the database across servers due to a RDBMS upgrade…

Read More >
Page 1 of 4012345...10...Last Page »