|
People sometimes ask how come I know so much about Oracle (and some Unix) internals and how do I have such a passion for these things. Also, another thing you may have noticed is that for some reason a large amount of hardcore computer hackers, low level troubleshooters and various internals experts happen to come from Russia. And I can answer why this is so! A little bit of history: I am an Estonian, was born in Estonia and lived ove..
|
|
People sometimes ask how come I know so much about Oracle (and some Unix) internals and how do I have such a passion for these things. Also, another thing you may have noticed is that for some reason a large amount of hardcore computer hackers, low level troubleshooters and various internals experts happen to come from Russia. And I can answer why this is so! A little bit of history: I am an Estonian, was born in Estonia and lived ove..
|
|
I redesigned the website of the first company I ever worked for: www.aaa-plus.com
-
www.databasesandlife.com
-
17 years ago
-
eng
Thanks the the internet archive I found one of the first (or one of the only?) websites I designed i.e. I did the graphics, did the “implementation” using a tool which produced HTML, etc. (Although the company logo etc already existed, I didn’t write the texts..) This was for AAA+ which was the first company I worked for in my life, which was also the company I worked for just after coming to Vienna, so has a lot of associations of newnes..
|
|
I came across this problem at work and also over on this www.stackoverflow.com thread . You have a directory and you want to recursively zip it up. Simple, right? The equivalent of the unix command "zip myDir.zip myDir". Should be like 5 lines of code? Python even has a built in zipfile module, sweet! Well, as is often the case (see urllib and friends), python's "batteries included" slogan is more like "enough batteries for 36 seconds incl....
|
|
SQL is a declarative language – in other words you just declare what needs to be done and Oracle takes care of the part how it’s done. However there’s nothing declarative about the actual SQL execution when it happens. SQL plan is just a tree of kernel rowsource functions executed in a specific order (defined in child cursor’s sql area). The root of SQL plan is where the fetch function (opifch2 for example) gets the rows for passi....
|
|
SQL is a declarative language – in other words you just declare what needs to be done and Oracle takes care of the part how it’s done. However there’s nothing declarative about the actual SQL execution when it happens. SQL plan is just a tree of kernel rowsource functions executed in a specific order (defined in child cursor’s sql area). The root of SQL plan is where the fetch function (opifch2 for example) gets the rows for passi....
|
|
In this era of massive government spending, a huge government deficit, untold amounts of consumer debt, and stories of layoffs after layoffs, some have come to wonder how those who have money achieved their wealth. Those some have come to the conclusion that the evil rich through trickery and deceit.
|
See the previous post for background and first few games. One thing I noticed about central Wellington is that nowhere at all does a show sell any sort of can or bottle of soft-drink for less than $2.50 , I suspect it’s some sort of cartel of shopkeepers agreeing not to compete on the price. … Continue reading North Island Champs – Easter 2009 – pt2
|
|
I’ve been busy with a series of seminars, so haven’t managed to blog much… Karl Arao has posted some feedback from my Singapore seminar and also the pictures we took with attendees. By the way, he has other good Oracle stuff in his blog so check it out here .
|
|
I’ve been busy with a series of seminars, so haven’t managed to blog much… Karl Arao has posted some feedback from my Singapore seminar and also the pictures we took with attendees. By the way, he has other good Oracle stuff in his blog so check it out here .
|
Over Easter 2009 I went to the North island Chess Championship in Wellington. The event was 8 games over 4 days ( Friday to Monday ) and a single Swiss draw of 31 players. The field was fairly strong with the top 7 players in the field being in the top 20 in New Zealand. … Continue reading North Island Champs – Easter 2009
|
|
So I had a chance to work in the Scrum methodology for about six months recently. I thought I'd write up some of my thoughts on the experience and the process. Please note that first, this is my first experience working in the Scrum process. I am sure as I use it more these opinions will change. Second, these are strictly my personal thoughts and opinions and in no way represent the experience of my team or anyone else. Third, my project ....
|
|
Great news people.. I had almost given up on getting any spam....
-
arnorhs.dev
-
17 years ago
-
eng
https://30.media.tumblr.com/BkkpWzjVDmcc4tce9aoYipp3o1_500.jpg) Great news people.. I had almost given up on getting any spam. Thought that the spammers would be afraid of anyt...
|
|
Great news people.. I had almost given up on getting any spam....
-
arnorhs.dev
-
17 years ago
-
eng
https://30.media.tumblr.com/BkkpWzjVDmcc4tce9aoYipp3o1_500.jpg) Great news people.. I had almost given up on getting any spam. Thought that the spammers would be afraid of anyt...
|
|
During my spring cleaning, I ended up getting rid of my AS/400 model 9404-D10 from 1991. Since the power supply is dead in it, I decided to disassemble and photograph the inside of this amazing machine. AS/400s are well known for their legendary uptimes, and were the “jewel” of IBM in the late 1980s to 1990s. In 1993, when IBM was close to splitting up their divisions into smaller companies, Bill Gates said that “the only part of IBM th..
|
|
During my spring cleaning, I ended up getting rid of my AS/400 model 9404-D10 from 1991. Since the power supply is dead in it, I decided to disassemble and photograph the inside of this amazing machine. AS/400s are well known for their legendary uptimes, and were the “jewel” of IBM in the late 1980s to 1990s. In 1993, when IBM was close to splitting up their divisions into smaller companies, Bill Gates said that “the only part of IBM th..
|
|
In this second podcast in the Oslo Developer Conversation series, I talk with Robert Martin about FitNesse. We discuss the origins of FitNesse and it’s relationship with Fit, the relationship between acceptance tests in FitNesse and unit tests and the new Slim-tables in FitNesse. See the (English language) podcast at ProgramUtvikling’s site. Comments: jhannes - May 26, 2009 In the PodCast, Bob mentions Parnas tables as an inspiration for Fi..
|
|
This is a test case from my current project: Scenario: Finish gathering information Given I have an open case And the case has a task "gather information from X" And the case has a task "gather information from Y" When the user confirms that task "gather information from X" is completed And the user confirms that task "gather information from Y" is completed Then the case should generate a new task "evaluate customer standing" It seems pret..
|
|
Been following along with Justin Chin about how to create posing rigs with SketchUp. Whereas he is using it to pose detailed 3D models (with an eye to making a comic and/or film using SketchUp), my interest relates more to orienting figures in space for paintings — placing the masses, in perspective. So far it seems promising, though I have yet to carry it through to a real painting. Posing rig example Though the tools are conte..
|
|
Been following along with Justin Chin about how to create posing rigs with SketchUp. Whereas he is using it to pose detailed 3D models (with an eye to making a comic and/or film using SketchUp), my interest relates more to orienting figures in space for paintings — placing the masses, in perspective. So far it seems promising, though I have yet to carry it through to a real painting. Posing rig example Though the tools are conte..
|
|
Doing the Code Dojo at Oslo XP meetup last Monday, I realized a new concept that I’ve been using unconsciously for a while: I only add to the structure of my system when I have a test that cannot be satisfied by the current design. The rules of test-driven development tells me to wait to create a more advanced design until I have a reason to do so. And that reason should be a failing test.
|
|
EMERGENCY - "This book has the slight possibility of maybe helping you to save your life one day."
-
liza.io
-
17 years ago
-
eng
I’m at C’s house, waiting for him to get back from work and doing a bit of work on other projects. I am also reading Emergency by Neil Strauss. Its catchy tagline is “This Book will Save your Life” is really very… optimistic.
|
|
Today is definitely a sad day - SGI announced their bankruptcy. SGI was once a great company - in the 1990s, they made the best computers ever, such as the Indigo2, O2, and Octane. The cases and designs looked awesome, and they had amazingly fast 64-bit MIPS RISC CPUs and stellar video cards! Plus, they made an excellent graphical UNIX operating system: IRIX. Although I am a Mac OS X UNIX user now, IRIX will always be my favourite UNIX...
|
|
Windows, Linux and OS X offer the ability to view the utilization of each CPU/core in the system. This is completely useless. On all these operating systems, tasks get switched from one core to another on a regular basis. (I don’t know why this happens, but I suppose there is no reason for it not to happen.) Here is my CPU-bound single-threaded program running on a dual-core computer. I suppose all one can really say is that if o..
|
|
Today is definitely a sad day - SGI announced their bankruptcy. SGI was once a great company - in the 1990s, they made the best computers ever, such as the Indigo2, O2, and Octane. The cases and designs looked awesome, and they had amazingly fast 64-bit MIPS RISC CPUs and stellar video cards! Plus, they made an excellent graphical UNIX operating system: IRIX. Although I am a Mac OS X UNIX user now, IRIX will always be my favourite UNIX...
|
|
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. ..
|