|
Hi Jackie. I had a wonderful time! And its always good to be in Knoydart - definitely one of my all-time favorite places. I'm not sure when I'll be back though. I read that you're having another music festival this year. I hope there'll be CD... Interesting to hear that you still have some snow - hopefully the hydro is more reliable than it was last Summer! If you give twitter a try then let me know your ID and I'll 'follow' you. All the be..
|
|
Agile development is easy to understand and hard to do. One of the hardest things to do is to base plans and actions on value instead of effort. An article by Alistair Cockburn includes a story that illustrates the point: A boy is behind on his German language home work. He now has to read ten stories and answer a set of question for each. He will be graded on the number of correct answers.
|
|
Check out this article by Vikram Das about how to read OS environment variables using PL/SQL . I did not know that!
|
|
Check out this article by Vikram Das about how to read OS environment variables using PL/SQL . I did not know that!
|
|
Many people have asked me that how come I’m not an Oracle ACE yet. From this week I am an Oracle ACE Director. Here’s a link to my profile . Its pretty big honor to be recognized by Oracle Corp at such high level. I started working with Oracle software in 1997 and got really interested in that stuff after realizing how powerful the database was and how complex some internal details could be. Lots of opportunities to learn and learn I..
|
|
Many people have asked me that how come I’m not an Oracle ACE yet. From this week I am an Oracle ACE Director. Here’s a link to my profile . Its pretty big honor to be recognized by Oracle Corp at such high level. I started working with Oracle software in 1997 and got really interested in that stuff after realizing how powerful the database was and how complex some internal details could be. Lots of opportunities to learn and learn I..
|
|
May 8th 1999 : The Midgard Project has finally released the first public version of Midgard Application Server Suite. The new release contains Midgard core libraries, a PHP3-based web application server for the Apache platform and the needed web-based administration tools. May 8th 2009 : It's time for celebration - Midgard CMS turns ten in May! The decade of Midgard will be celebrated with a guest gala that is to be held at re..
|
|
Thought while my code was compiling and being tested I would throw up some thoughts about it. For those who don’t know you should probably go and read something else, since what follows is going to be pretty technical. So LINQ to SQL. At first I was totally opposed to it. The idea of taking a language that most developers know (SQL) and morphing it into something that .NET can use and slightly resembles SQL didn’t really appeal to me. Sin..
|
|
Hi Andrew, just came across your blog, i know never late than never but im going to give twitter a tweet to!! Here on Knoydart, the snow is still on the tops, a wee bit colder than when you were last here but no midges...yet! Im just getting to grips with the tecno stuff now we have.....broadband sattelite thank the lord. Sounds like you had a great trip, maybe we will see you over the loch again soon. Have a great week Jackie (The Old Forg..
|
|
Hi Andrew, just came across your blog, i know never late than never but im going to give twitter a tweet to!! Here on Knoydart, the snow is still on the tops, a wee bit colder than when you were last here but no midges...yet! Im just getting to grips with the tecno stuff now we have.....broadband sattelite thank the lord. Sounds like you had a great trip, maybe we will see you over the loch again soon. Have a great week Jackie (The Old Forg..
|
|
Oracle has done some major improvements in the diagnosability infrastructure in version 11g. Here’s one little detail. Before Oracle 11g it is possible to access the alert log via SQL using an external table or a pipelined function which in turn uses utl_file. After reading the text you need to parse it to extract the information you need from there. Starting from 11g Oracle does all this work for you. There is a fixed table X$DBGALER....
|
|
Oracle has done some major improvements in the diagnosability infrastructure in version 11g. Here’s one little detail. Before Oracle 11g it is possible to access the alert log via SQL using an external table or a pipelined function which in turn uses utl_file. After reading the text you need to parse it to extract the information you need from there. Starting from 11g Oracle does all this work for you. There is a fixed table X$DBGALER....
|
|
Riyaj Shamsudeen wrote an excellent article about systematic latch contention troubleshooting. Especially if the latch contention problem is ongoing, looking into system wide stats (like v$latch.sleep columns) is not the best idea in busy systems. This may sometimes lead you to fixing the wrong problem. This is because sometimes the latch contention is not caused by some system wide inefficiency but rather by one or few sessions. ..
|
|
Riyaj Shamsudeen wrote an excellent article about systematic latch contention troubleshooting. Especially if the latch contention problem is ongoing, looking into system wide stats (like v$latch.sleep columns) is not the best idea in busy systems. This may sometimes lead you to fixing the wrong problem. This is because sometimes the latch contention is not caused by some system wide inefficiency but rather by one or few sessions. ..
|
|
I see why people get a bit upset about the privacy aspects of Google Streetview! On the other hand, it is rather amazing. To sit here in my office in Vienna and be able to walk around where I used to live at Southampton University. First house (where I lived Summer 1996 – Summer 1997) Second house (where I lived Summer 1997 – Summer 1998) In comparison to my first house, even the flat I’m living in now doesn’t look too bad :)
|
|
There is ample detailed information out there on installing wordpress. However, I wanted to just provide a small supplement about setting up two distinct wordpress blogs within a single apache2 web site. The system I am using is Ubuntu Linux 8.10, but other than the package installation, the configuration steps should be the same on other linux distributions. As a first step, read through the Wordpress Installation Instructions . You wil....
|
|
Flat fee music subscription service has changed my life. I wish there was some less dramatic way to put it, but it's the honest truth. I don't remember exactly when, but somewhere in late 2006 probably, after reading this Joel on Software - The infinite music collection article, I was intrigued by the idea and did a little shopping. I know I looked at Napster, Virgin, Yahoo, and Rhapsody at least. I think I initially went with Rhapsody be....
|
|
I have decided to start a "professional" blog. I use the word "professional" only in the sense of "not personal". I will post about software engineering, computers, consumer electronics, and music technology primarily. I hope you enjoy it and look forward to any conversations this generates.
|
|
Anyone who’s looked into Oracle X$ tables, knows that their names are really complicated and quite unreadable (and non-pronouncable), such X$KZSRT, X$KCPXPL, X$KQFSZ and so on. A few years ago at some conference someone came up with a thought that the reason why Oracle has so unreadable names for its X$ tables is that the leading edge database source code was actually stolen in the 80’s from a Soviet Union intelligence agency.
|
|
Anyone who’s looked into Oracle X$ tables, knows that their names are really complicated and quite unreadable (and non-pronouncable), such X$KZSRT, X$KCPXPL, X$KQFSZ and so on. A few years ago at some conference someone came up with a thought that the reason why Oracle has so unreadable names for its X$ tables is that the leading edge database source code was actually stolen in the 80’s from a Soviet Union intelligence agency.
|
|
When debugging, I often found that NSLog is really boring, here is an attempt to make it nicer: ` NSLog(@"mycar: %@",myCar); NSLog(@" I'M HERE "); ` NSLog doesn’t tell you where the call was made (which file or which method), so you end with a lot of: 2009-03-11 22:30:53.789 ObjCTest[1565:10b] mycar: Porsche 2009-03-11 22:30:53.791 ObjCTest[1565:10b] I’M HERE A better NSLog could tell us: 2009-03-11 22:32:25.823 ObjCTest[1581:10b] Car.m:32 ..
|
|
Today and tomorrow I am at an Ask Tom Live Seminar in Prague . Tom Kyte works for Oracle and has written many books on Oracle. For me he’s a bit of a “star”, so when I heard he was talking in Europe, I had to come. (But is that wrong? Normal people are in to stars like Robbie Williams surely, not Oracle experts.) Wow there is so much I don’t know about Oracle evidently. I mean the solutions that he is presenting concerning Oracle 11g, ar..
|
|
Yanko Design's You-SB concept : Jerry's real prosthetic USB finger storage : The story behind this is that Jerry had a motorcycle accident last May and lost a finger. When the doctor working on the artificial finger heard he is a hacker , the immediate suggestion was to embed a USB "finger drive" to the design. Now he carries a Billix Linux distribution and the Freddy Got Fingered movie as part of his hand. Yan..
|
|
I haven’t blogged for a while. This is partly because my daughter and I have been enjoying some major events in Toronto (Ontario Science Centre, ROM, shopping, more shopping, etc.), and not much has happened in the Geek world aside from the new Apple hardware updates and Firefox achieving 100% market share in Antarctica. However, the main reason I haven’t blogged is that I have been engrossed with reading the 10th Anniversary book from ..
|
|
I haven’t blogged for a while. This is partly because my daughter and I have been enjoying some major events in Toronto (Ontario Science Centre, ROM, shopping, more shopping, etc.), and not much has happened in the Geek world aside from the new Apple hardware updates and Firefox achieving 100% market share in Antarctica. However, the main reason I haven’t blogged is that I have been engrossed with reading the 10th Anniversary book from ..
|
|
I thought to post about another new interest of mine, TimestTen, as I’ve worked with it in past and I have become a fan of it, especially after Oracle bought the company. Oracle has announced that TimesTen in-memory database will support PL/SQL in the upcoming release. That’s in 11gR2, where TimesTen is named the “in-memory database cache”. I’m happy to see the deep level of integration Oracle is doing with it. It looks like both classi..
|
|
I thought to post about another new interest of mine, TimestTen, as I’ve worked with it in past and I have become a fan of it, especially after Oracle bought the company. Oracle has announced that TimesTen in-memory database will support PL/SQL in the upcoming release. That’s in 11gR2, where TimesTen is named the “in-memory database cache”. I’m happy to see the deep level of integration Oracle is doing with it. It looks like both classi..
|
|
If you read my previous blog on the economy, you’ll see how I explain recessions as part of the inherent flaw of capitalism. As a recap, it is essentially because business people need to earn more than their customers, and their customers need to make more than the business people. This concept would make one wonder how capitalism works at all.
|
|
The full power of Oracle’s diagnostic events, part 1: Syntax for KSD debug event handling
-
tanelpoder.com
-
17 years ago
-
eng
There’s a recent thread in Oracle-L about deadlocks and a recommendation to dump various instance information when the deadlock happens. A deadlock trace dumps some useful things automatically, but sometimes you want more, especially in RAC environment. So is it possible to make Oracle dump additional things when the deadlock event happens? Yes it is and it’s doable with Oracle diagnostic event handling infrastructure. First I’ll take....
|
|
The full power of Oracle’s diagnostic events, part 1: Syntax for KSD debug event handling
-
tanelpoder.com
-
17 years ago
-
eng
There’s a recent thread in Oracle-L about deadlocks and a recommendation to dump various instance information when the deadlock happens. A deadlock trace dumps some useful things automatically, but sometimes you want more, especially in RAC environment. So is it possible to make Oracle dump additional things when the deadlock event happens? Yes it is and it’s doable with Oracle diagnostic event handling infrastructure. First I’ll take....
|
|
Cool, just discovered: if you’re using the (UNIX command-line program) “less” to view a file, you can hit the “v” character to open the file in “vi”!
|
|
Being a geek, I’ve always liked the word 'metric.’ A metric is a number or other quantitative object (physicists like 'metric tensors’) which measures something. I have three paintings drying right now (i.e., too wet to work into without screwing up areas). A thought occurred to me as I was thinking about what to work on next, that the number of drying paintings could be a metric of how artistically busy you happen to be at the moment. C....
|
|
Being a geek, I’ve always liked the word 'metric.’ A metric is a number or other quantitative object (physicists like 'metric tensors’) which measures something. I have three paintings drying right now (i.e., too wet to work into without screwing up areas). A thought occurred to me as I was thinking about what to work on next, that the number of drying paintings could be a metric of how artistically busy you happen to be at the moment. C....
|
|
My friends at ProgramUtvikling just published the first PodCast in the series Oslo Developer Conversations. In this PodCast, yours truly interviews Uncle Bob about software craftsmanship. The podcast is still only available as video, but audio will come shortly. I had a great time doing this interview and I’m particularly happy that we managed to have a good combination of a technical discussion and an informal discussion. I’m looking forwa..
|
|
It might strike you odd that I’m libertarian - that is, I want government as small and harmless as possible - and that my political view is rooted deeply in my faith. You see, I believe God gave us a gift, a gift so very precious that we have created a government to protect it. The government has often mishandled this gift, and so have we. We don’t really deserve this gift, but we have it.
|
|
ZFS is all about performance (many levels of caching, pre-fetch, …) and memory consumption :-) Here are my last links about ZFS [internals](http://src.opensolaris.org/source/xref/onnv/onnv- gate/usr/src/cmd/mdb/common/modules/zfs/zfs.c#333), it’s worth a read if you plan to use ZFS on large productions : The slides of Adam Leventhal’s talk for the OpenSolaris Storage Summit : ZFS, Cache, and Flash c0t0d0s0.org : a very good explanation of t..
|
|
60000 bind variables?! Maybe it’s time to use a temporary table instead…
-
tanelpoder.com
-
17 years ago
-
eng
I just noticed a bug 8277300 filed in Metalink with following description: ORA-7445[XTYQBCB] OCCURS DURING EXECUTING SQL THAT USES 60000 BIND VARIABLES . Wow! That’s about 100 times more bind variables in a single query than what I’ve seen in past. And I thought that query was bad!!! :) I suspect this is a massive IN list passed to a query. Maybe it’s time to use a temporary table or a collection for passing in the IN values instead?
|
|
60000 bind variables?! Maybe it’s time to use a temporary table instead…
-
tanelpoder.com
-
17 years ago
-
eng
I just noticed a bug 8277300 filed in Metalink with following description: ORA-7445[XTYQBCB] OCCURS DURING EXECUTING SQL THAT USES 60000 BIND VARIABLES . Wow! That’s about 100 times more bind variables in a single query than what I’ve seen in past. And I thought that query was bad!!! :) I suspect this is a massive IN list passed to a query. Maybe it’s time to use a temporary table or a collection for passing in the IN values instead?
|
|
The sky is falling. Everyone’s losing their job. The dollar isn’t worth what it used to be. Everything’s doom and gloom. Yet economists and politicians seem to insist that this is all part of a cycle, which includes recessions, booms, depressions, bull markets, bear markets, and other mumbo jumbo.
|
|
We all know that cigarettes and alcohol can be expensive because states will tax the hell out of time. Currently, California has virtually no money, and one politician has come up with a solution: tax recreational marijuana.
|
|
Five unit testing tips #4: Don't mock your way into accidental complexity
-
jhannes.github.io
-
17 years ago
-
eng
I’ve all but stopped using mock objects in my tests. The reason is that mocking have had a detrimental effect on the design of my systems. I’ve often ended up having the mocks trick me into adding a needless layer of indirection that does nothing except delegate to the next layer, just to satisfy the mocks. For a while, I was wondering whether I was the only one with this problem, but then I saw this tutorial on JBehave, which so perfectly ..
|
|
Or in other words, how to translate SQL_ID to a hash value :) I once wrote a script to demo this in my Advanced Oracle Troubleshooting class. Check this, I’ll run a query and then check what is its SQL_ID and HASH_VALUE from V$SQL: SQL> select * from dual ; D - X SQL> select sql_id, hash_value from v$sql 2 where sql_text = ' select * from dual '; SQL_ID HASH_VALUE ------------- ---------- a5ks9fhw2v9s1 942515969 So, V$SQL..
|