Tag: DBA Lounge

Git::CPAN::Patch now detect repositories

Git::CPAN::Patch could already seed a local repository with the latest distribution of a module, or its whole BackPAN history, or its GitPAN mirror. But with version 0.7.0, it can now go straight for the meat and clone the distribution’s officil git repository, provided that it’s specified in its META.json or META.yml. Please allow me to demonstrate:

Read More >

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.

Read More >

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.

Read More >

In ‘Movember’, Mo Bros stand together to fight Prostate Cancer

The 60s are NOT back but during the month of November , some gents , including myself, will grow a stache to raise the awareness of prostate cancer, an insidious disease that afflicts one in seven males.

Read More >

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.

Read More >

Exporting the mysql.slow_log table into slow query log format

Using pt-query-digest is an excellent way to perform a SQL review. However, sometimes you don’t have access to the slow_query_log_file. For example, when MySQL runs on Amazon RDS, the slow_query_log_file is unavailable (see the RDS FAQ). To get around this,…

Read More >

Taming Pod::Weaver

Pod::Weaver, which does to POD what Dist::Zilla does to distribution files, is all that, only moreso. But it feels so powerful, holds so much promises to make my life easier once I manage to master it, that I won’t let the steep learning curve deter me. I’ll climb down my brain bicycle, and push it up that hill. And I’ll provide a running (well, walking slowly) commentary as I go along, in the hope that it’ll help other peeps who might want to venture is those exciting yet dark waters. Okay. Enough preamble. Let’s get cracking.

Read More >

Dear DBA_SCHEDULER_RUNNING_JOBS, where have you been?!

The following story about DBA_JOBS_RUNNING and DBA_SCHEDULER_RUNNING_JOBS is based on real events.

Read More >

Back to School: Elementary Physics for DBAs

A few days ago I was asked to estimate how much space needed to be added to the ASM diskgroup to handle the database growth for one year without additional need of adding disks. To do this I needed to calculate acceleration and assuming the acceleration stays the same I would be able to calculate the “distance” or (how much the DB would grow in one year). I used the following formulas…

Read More >

How to know if Automatic Memory Management is your Friend?

Common Cause for ORA-4031 in 10gR2, Excess “KGH: NO ACCESS” Memory Allocation [Video] [ID 801787.1] Don’t be misled by the title of the note. I think any Oracle DBA who switch on ASMM should read though this carefully. The note is full of significant technical details. I will leave it to you to read it carefully. In this blog post I would like to share with you the most important takeaway, from my point of view.

Read More >
Page 20 of 60« First Page...10...1819202122...30...Last Page »