Posts Categorized: Technical Blog

A Web Log Analyzer Called DuckFeet

DuckFeet’s guts are SQLicious, and built as DBIx::Class classes, sprinkled with wonderfully tooth-decaying DBIx::Class::Candy on top. In the repo, it’s all under the DuckFeet::Schema namespace. For the time being, there is only a handful of tables (hits, uris, referers, agents and hosts), but it should be easily extendable to add any type of information we might desire to throw in, but it should be easily extendable to add any type of information we might desire to throw in.

Oracle Instance Memory Usage

How much memory does my Oracle instance use? How much memory do my database connections use? These are questions that can help with capacity planning of your server’s Physical and Virtual memory. There are several write ups out there on the web that attempt to address these questions. From what I could gather from them, there is only one truly good way to tell exactly how much memory is currently in use by an oracle instance, as well as the average memory usage for oracle dedicated connection processes. I explain it here.

Once again about innodb-concurrency-tickets

I had to refresh my knowledge on how InnoDB threads queue works the other day when debugging activity spikes on one of the customer’s production system and while I had general idea about InnoDB kernel and queue, thread concurrency and queue join delays I didn’t have a complete model of how InnoDB concurrency control works. So I started from manual…

UKOUG 2011 Conference OakTable Sunday by Alex Gorbachev

This year, there were ten Pythian folks attending UKOUG Conference and we did twelve sessions including multiple presentations, masterclass, RAC Attack workshop, round-table and 10 minutes OakTalk. I think it’s the record number of session Pythian folks did at a single UKOUG conference and the record number of Pythian peeps attending. A dozen of Pythian people in Europe and now even a sales guy in the UK mean that Pythian penetration in the UK database services business is close to the infliction point. This is ultimately a good news!

Deploying Stuff With Git

Somebody at $work asked me how I use Git to deploy stuff, probably working under the false hypothesis that wisdom is in any way, shape or form affiliated with yours truly. The fool…Yet, it is true that I had my share of tinkering with Git, and that I might have gleaned from my experience. So I sent him a couple of links leading to more wisdom-certified sources. They are listed at the end of this blog entry; if you have more good articles/blog posts that you’d like to add to the pile, please don’t be shy and mention them in the comments. But I can’t just stop there, really. So, if you allow me, I’ll dust off the good ol’ soap-box, hop on it, and share my thoughts on the subject.

Is GoldenGate the Golden Gate

I have experienced a handful of Oracle’s replication solutions as far back as version 5 of the database in the mid to late 1980′s. Will GoldenGate be the golden gate? If one ends up answering in the affirmative to most of the following questions, I think so.

Using NOLOCK Hint

Use NOLOCK hint to avoid block – this is what I have often heard/see in many forums I participate in, during local user group events and meetings. I have always advised that its not that good idea to use hints, as it may cause data corruption and blocking. And anyways, there are many things that you can do to avoid blocking, like:

Page 23 of 59« First...10...2122232425...304050...Last »