DBA Lounge

Repost: Oracle Protocol

Ian Redfern published a paper documenting the TNS protocol internals. The paper is titled “Oracle Protocol” and is clearly the result of painstaking research.. the paper became a classic in our field. Fortunately, it was released into the public domain, allowing me to reproduce it here in full, preventing it from disappearing forever.

DNFS: wtmax = /proc/fs/nfsd/max_block_size

This is one of those posts that you find via google using an error message for direct hit search. If you didn’t reach this post that way I would advise you to stop reading here. If you are still reading then you (as I did) faced error messages below and got frustrated as it isn’t obvious what exactly Oracle means by wtmax/fsinfo/rt/rtp/wt/wtp etc. It all has been very confusing to me as I am Oracle DBA and still need to learn a lot on system administration level side of things.

Mass-Testing Dancer’s Plugins

One of the items on the to-do list for Dancer 2 is to verify that most of the plugins already written for Dancer 1 will still work for Dancer 2. Well, I thought, that’s just like doing smoke testing for a small subset of Perl modules. How hard can it be? Lets get cracking…

It’s Your Fun, Not Your iPhone’s

I was thumbing through the photos in my iPhone from my Melbourne trip of August, where I went to present two sessions on Exadata in Insync12 from Pythian. I spent couple of hours on first and last day in sight-seeing or should I say my iPhone did the sight-seeing, and I nursed him. As I was going through the photos, I realized I was kind of watching those places first time. There were many things which were present in the photos, but I never saw them with my own eyes while walking or traveling in the trams or cabs.

Web Service One-Liners with Dancer

Today, I had some bit of fun and created a micro-web service as a one-liner. But then I thought that using almost 70 characters for a web service was awfully long-winded. Surely there was a way to make our Dancer more efficient. But how? How about… by getting a MC involved?

Productivity Squared: Character Graphs in-Terminal

In the course of a large cluster database administrator’s job, there are dozens of times a week it can be useful to visualise some data. You’re constantly working with machines that have hundreds of databases, directories, files, log files with often millions of entries each. Wouldn’t it be nice if you could visualise these situations?…

Page 12 of 67« First...1011121314...203040...Last »