Posts Categorized: Technical Blog

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:

UKOUG2011: E-Business Suite Concurrent Processing Performance Analysis

Another December has started and you know what it means right? It’s the Christmas time? NO! It’s time for UKOUG Technology and e-Business Suite 2011 conference! There are not many things that can make a passionate Apps DBA more excited than that. UKOUG Tech & eBS conferences are the only ones in Europe that have such a rich content for Application DBAs and this year it will not be different.

Troubleshooting SSPI handshake error

I have seen lots of questions floating in the msdn forums about SSPI Handshake error, the main question is around error code 0×80090311 which is indicative of the authentication failure error. Apart from this, there are many other reasons for SSPI Handshake error to appear in error logs. I cover them here.

Page 19 of 55« First...10...1718192021...304050...Last »