Tag: DBA Lounge

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 >

mydumper & myloader : fast backup and restore

At PalominoDB we do not normally use mysqldump for regular backups, but only in some circumstances (for example MySQL upgrade). Lately we gave a try to mydumper as an alternative to mysqldump, and results are quite promising. We found that…

Read More >

Incident Notification – Pythian internal – Jul 29th 3PM EDT

We have incident reporting procedures at Pythian. This incident report was sent just recently internally at Pythian. We learned some good lessons from it so I hope it would be useful to the community as well – As part of our incident management process, you will find below a summary of the details from the incident that occurred on July 29th at 3PM EDT. Overview: Pythian employees were de-motivated by the lack of refreshments on Friday afternoon

Read More >

The DBD-Quest of Unknown Kadath

I already aluded to the fact in a few posts already, but just to make it a wee bit more public: a few weeks ago, someone had a lapse of common sense and knighted me Maintainer of DBD::Oracle. mouahahaha *ahem* I mean, I’m honored to be allowed to at the wheel of what is one of the most venerable battleships of the CPAN armada, and hereby swear to serve her at the best of my abilities.

Read More >

Swappiness

If we are observing more and more swapping in (ver frequent si in vmstat) then we could look at decreasing swappiness.
In order to play with the swappiness, you can temporarily set it by doing the following…

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