Tag: DBA Lounge

Important Caveats When Using pt-online-schema-change

Using pt-online-schema-change is a great way to change a table without downtime or switching over to a secondary database first. While using it on production systems, we found some interesting issues to consider. 1) There were foreign_keys referencing the table…

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 >

The Magic of kSar for one-time system graphs

I forget from whom I first learned about kSar, but I am in debt to that person once again.  I first learned about it about a year ago, and it has been extremely useful whenever I am trying to debug…

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 >

Postgresql 9.1 – Part 1: General Features

General scope Postgresql 9.1 runs over the theme “features, innovation and extensibility” and it really does. This version was born to overcome Postgresql 9.0 ‘s limitations and known bugs in replication. If you are developing over 9.0, it’s time to…

Read More >

CanWIT Panel – CIO or CTO? The Path to Next Generation Technology Leadership

Last Thursday I was invited to the panel organized by Ottawa Chapter of Canadian Women In Technology (CanWIT). I wanted to mention it here as CanWIT sets up very interesting events for women in IT so if you are interested in progressing your IT career, definitely consider their events.

Read More >

Going Postal (with Dancer)

The Dancer plugin mechanism primary aims to provide a way to encapsulate pieces of functionality that can be re-used by different applications. But, it’s so light-weight and handy, that’s it’s easy to also use it to encapsulate parts of the application itself. In that way, it’s very reminescent of the concept of role. Let’s look at this example.

Read More >

A Wee Bit of Fun with Template::Declare

As I was crafting my Dancer presentation for Summercamp 2011, I noticed that there wasn’t a Dancer template for Template::Declare. Well, now there’s one, have a look.

Read More >
Page 21 of 68« First Page...10...1920212223...30...Last Page »