Posts Categorized: Pythian

Log Buffer #245, A Carnival of the Vanities for DBAs

Getting stuck on technical problems is a norm in the life of any IT professional and DBAs are no exception. With evolving databases and their streaming new features make it more challenging. Blogs often provide the Eureka moment for those problems. So sit back and enjoy this Log Buffer Edition, which is Log Buffer #245.

New & Improved: MooseX::Role::BuildInstanceOf

Okay, so MooseX::Role::BuildInstanceOf is not one of my modules. And while I submited the patch, the feature itself was born out of fREW’s DBIx::Class::DeploymentHandler. So, in all this, my role was at best to be the pollinator agent between two beautiful flowers. But, hey, it’s not like a little bit of noise is going to hurt any of the involved parties, sooo… let’s see what the buzz’s about.

RMAN Duplicate in Details

I took debug of duplication and figured out that RMAN internally executes procedure dbms_tts.transport_set_check preventing any further copy operations if tablespaces do not satisfy TTS requirements. Now the plot thickens and considering RMAN shows everything that it does in log file I decided to repeat the same steps but one by one and manually. Let’s get into it.

Log Buffer #244, A Carnival of the Vanities for DBAs

Managing the databases of any kind of any size in the production environment requires the administrators to remain up to date and on the toes every time. They need to learn fast and apply their knowledge fast. Keeping abreast of the newer features and the troubleshooting techniques is must for them and this Log Buffer Edition helps easing that task. Enjoy the Log Buffer #244.

Cluster Wide ASH Report

One of the most nice thing about the newer versions of Oracle is the advent of ASH and AWR as they provide awesome diagnostic information. Many customers at the Pythian use Real Application Cluster and having a cluster wide AWR report by using awrgrpt.sql script is very handy.

Log Buffer #243, A Carnival of the Vanities for DBAs

From Percona Live, London to TechEd Australia to Oracle Open World USA, the blogosphere of Oracle, MySQL, SQL Server and the related technologies is bustling with the eye witness accounts of these conferences, technical overviews, observations, predictions, and much more. This Log Buffer Edition covers all that and as usual more in Log Buffer #243.

Sydney Found Secret of Becoming RockStar DBA

Practice, Innovation, Learning, Positive Paranoia are few of the key factors which make a DBA rockstar. Paul Vallee, who is employing hundreds of top-notch DBAs from across the planet to service world’s busiest and critical databases nailed the concept down with a thud.

Taming Pod::Weaver, part 2

In our last episode, we began our journey into the wonderful and only slightly scary world of Pod::Weaver. By the end of the blog entry, we victorously managed to, hum, mimic perldoc -u. Not terribly impressive, maybe, but a necessary baseline for the upcoming niftiness. Niftiness that begins with today’s installment, as we are going to take a closer look at all the Pod::Weaver gnomes and fairies that we can enlist to help create our POD.

Page 62 of 202« First...102030...6061626364...708090...Last »