Author Archives: alesk
DebugDiag for Windows x64
DebugDiag is Microsoft diagnostic tool for troubleshooting process crashes, hangs and high memory usage.
See introduction article, written by Michael Morales (a senior escalation engineer for Microsoft’s Global Escalation Services team) in December 2008 issue of Windows IT Pro magazine, InstantDocID# 100577, for details on how to use this tool.
At the moment I’m investigating “weird” Oracle service crash on Windows 2003 x64 (hopefully non-production server) that occurs more or less at the same time every day. What makes troubleshooting this case interesting is a complete lack of any trace files by Oracle. Nothing in alert.log, bdum, udump etc.
I knew that using some OS debug tool is my only hope to narrow down the cause for the service crash.
As a longtime subscriber on Windows IT Pro Magazine, I was well aware of the great articles written by Mr. Morales, so it was not hard to find one with DebugDiag description.
The only version that I found on Microsoft site was Debug Diagnostic Tool v1.1, which unfortunately supports only Windows x86. Somehow discouraged I sent an email to Mr. Morales asking if there is any plans to port this tool to Windows x64. He made my day by promptly replying the link to IIS Diagnostic Toolkit 1.0, part of which is also DebugDiag. At the time of writing this note this is the latest release for Windows x64 and documentation can be found here.
Why Python?
The other day I was reading an August issue of my favorite magazine, Linux Journal. On page 17 there is a list of the ten most popular articles off all-time on LinuxJournal.com. At the #1 is article written by Eric Raymond, titled Why Python?.
I was pleasantly surprised. It’s precisely this article that ended my ultimate quest for scripting language back in 2004. Frankly, I was sick of Microsoft WSH that I was using back then; besides I needed scripting language that could run equally well on Windows & Linux (support for other major flavors of Unix would be a plus) and with solid support for various text processing/parsing functions, that could allow me to “glue” together some tasks related to ETL (mostly DBA stuff).
I spent considerable amount of the first half of year 2004 evaluating various scripting languages — somehow skipping python at first (can’t remember why I dismissed python so quickly). Since I knew that Perl has strong parsing capabilities (regular expressions etc.), it was this language that I used to “benchmark” all others against.
Perl could probably pass my evaluation if only the written code would not look so wacky (with all due respect to Perl community) – then one day Google returned link to the article written by Eric Raymond, “Why Python?”. It was revealing experience reading this article. I downloaded and installed python immediately after I finished with the article, browsed the manuals and when I saw some code examples, I thought: what a beauty (sorry if it sounds too geeky)! It was love at first sight, I knew I was hooked for life. Since then, I never looked back, python is my favorite scripting language. The only thing I really regret is that I didn’t “find” the python earlier in my career. What a pity!
Riding the cloud
I’m still fresh from yesterday second VMware mini-conference in Slovenia. Arguably it’s the largest event dedicated to virtualization in Slovenia (but don’t be fooled by that, we could probably hardly fill an average Irish pub in your corner of the World).
Before I continue, don’t get me wrong, I’m a big fan of VMWare products since day one. What bothers me is how easily our branch produces tons of acronyms, buzzwords and other fluffy words to promote “new” technology to us, tired, old consumers. We all know one such notorious hot buzzword was Web 2.0. I was told, not that long ago, how Web 2.0 is the next big thing that will change our lives. You can either join us or die as a dinosaur. No one could really explain to me what exactly Web 2.0 is or when we’ll see Web 3.0. A few years later (I hope), most of us are aware (ok, with the exception of most executive managers) that Web 2.0 as such doesn’t exist, never did, never will. It’s (was) just another buzzword to easy promotion and selling of some pretty much “old and boring” acronyms (such as Ajax, RSS, WS, SOA, Wiki, blogging, Tagging, podcast, mash-ups, “social” web, etc.), it’s much easier to pack everything in one big bag called Web 2.0, doesn’t it? Rarely people understood what lies behind Web 2.0, but it surely sounded cool to be able to discuss Web 2.0 at cocktail parties during IT conferences session breaks.
Roll forward…today Web 2.0 is a cold turkey (if you don’t believe me, I recommend reading a nice column written by Lance Ulanoff), our branch needed another buzzword to ride on. Welcome to cloud computing. It was just a matter of time when someone will go over the top and announce cloud Operating System (or cloud OS). VMWare did that when they announce the industry first cloud operating system. vSphere (successor of VMWare VI3) is the next big thing. New software category. Some bloggers went even further, calling vSphere a software mainframe. I’m not arguing if this is justifiable or not, neither I’m denying VMWare innovation effort and progress on the field of virtualization. Kudos to them! They’re kings of the hill, a clear industry leader. But, do we really need another frenzy buzzword polka in our industry?
I can vividly imagine Steve choking with the muffin at the breakfast, while browsing the press and seeing VMWare announcement…: WTF!? How come they’re first on the market? How come we didn’t see it first!? A hole new software category! Billions of new opportunities. Green ones! Hmm…could we call it Cloudy Windows 7 or at least bring back that trendy default desktop background picture from Windows XP!?
ORASRP – Oracle Session Resource Profiler
Thanks to the paper Oracle Analysis 101, written by Glenn Fawcett (Sun) I have a new Oracle performance troubleshooting tool on my USB key. It’s called orasrp (Oracle Session Resource Profiler), written by Egor Starostin. Basically it’s an Oracle trace file analyzer/profiler with a nice html based report that supports statement graph among other things. It’s written in D language with binaries available for Windows, Linux and Mac OS X. Supports trace files from Oracle 7.2 – 11g.
You can download orasrp from: http://www.oracledba.ru/orasrp/
klafr called
This note is more as a reminder to myself than anything else…perhaps, it’s time to phase out 9i clients at our site for good, at least on workstations used by our developers. Today, I found a bunch of trace files with:
... *** SERVICE NAME:(SYS$USERS) 2009-05-06 11:49:42.540 *** SESSION ID:(291.1143) 2009-05-06 11:49:42.540 klaflr called ...
Based on my past experience I knew that this kind of trace files containing klafrlr called are a direct consequence of running SQL*Loader 9.2.0.5 in direct path mode. No errors at the user side, thought. It’s just annoying to purge trace files. As a short-term solution I’ll ask part of our team that is still using 9i client to run SQL*Loader from our network based 10g client installation point, but the proper solution is to move on and replace all those old workstations with the ones that include 10g client.