|
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..
|
|
Cuba Street Fair, Wellington At the end of a few days here in Wellington, I am flying home today. This is one of my favorite cities in the world. It has been fabulous to see Neil and Amelia again, to go shopping (the US dollar is finally stronger after several years in the gutter), to go to art galleries and to walk up and down Cuba Street . Yesterday we braved the crowds at the Cuba Street Carnival, then came home and made dinne....
|
|
Cuba Street Fair, Wellington At the end of a few days here in Wellington, I am flying home today. This is one of my favorite cities in the world. It has been fabulous to see Neil and Amelia again, to go shopping (the US dollar is finally stronger after several years in the gutter), to go to art galleries and to walk up and down Cuba Street . Yesterday we braved the crowds at the Cuba Street Carnival, then came home and made dinne....
|
|
Cuba Street Fair, Wellington At the end of a few days here in Wellington, I am flying home today. This is one of my favorite cities in the world. It has been fabulous to see Neil and Amelia again, to go shopping (the US dollar is finally stronger after several years in the gutter), to go to art galleries and to walk up and down Cuba Street . Yesterday we braved the crowds at the Cuba Street Carnival, then came home and made dinne....
|
|
Welcome to my blog! Bear with us here, were just now getting the site set up, getting the kinks and the bugs out of the system.
|
|
In NAT mode (the default one), virtualbox does not give you the possibility to directly connect to your guest os. Here is how to configure your Virtualbox to simply ssh myguest For example my guest is called “Solaris10u6”, configured to used e1000 card, the default in solaris configuration, (The host os is a Mac). Type this command in terminal: `VBoxManage setextradata Solaris10u6 “VBoxInternal/Devices/e1000/0/LUN#0/Config/ssh/Protocol” TCP..
|
|
From the autodie manual : It is better to die() than to return() in failure. — Klingon programming proverb. (“die” in perl is like throwing an exception.) (via $foo magazin )
|
|
Monday morning and Jan, Timo and I are on the Northbound train from Christchurch to Picton. Outside, greens and browns of grasses, dry scrub, and trees blur together with grey skies, rain and the dun coats of sheep. It always seems to rain during my train trips here. It’s hard to believe that just Friday morning we were at the South Pole. Thursday night, having Bag Dragged and then sweated in the sauna ('Epic’ was how colleague St....
|
|
Monday morning and Jan, Timo and I are on the Northbound train from Christchurch to Picton. Outside, greens and browns of grasses, dry scrub, and trees blur together with grey skies, rain and the dun coats of sheep. It always seems to rain during my train trips here. It’s hard to believe that just Friday morning we were at the South Pole. Thursday night, having Bag Dragged and then sweated in the sauna ('Epic’ was how colleague St....
|
|
Monday morning and Jan, Timo and I are on the Northbound train from Christchurch to Picton. Outside, greens and browns of grasses, dry scrub, and trees blur together with grey skies, rain and the dun coats of sheep. It always seems to rain during my train trips here. It’s hard to believe that just Friday morning we were at the South Pole. Thursday night, having Bag Dragged and then sweated in the sauna ('Epic’ was how colleague St....
|
As part of my chess goal for 2009 I’m am working on entering as many tournaments as possible. My first one was a 6 round 25+5 at The Manukau Institute of Technology on the Saturday after Waitangi Day. The venue is close to the Otara Markets so my partner dropped me off and went shopping … Continue reading MIT Waitangi Rapid – 7 Feb 2009
|
|
Just a quick one-liner to let everyone know I’m safely in New Zealand enjoying oxygen- and moisture-rich air. Will post photos and more details tomorrow or as time allows.
|
|
This Thursday I attended a Twestival organized by jenleereeves and finally got to meet up with a ton of local “tweeters” I’ve followed for quite a while as well as meet several for the first time. In addition to finally meeting face to face, we also bid on auction items for charity:water. Good times plus helping support a good cause. I have to say it was a really awesome experience… an interesting mix of local tech heads, photographers, jou..
|
|
Just a quick one-liner to let everyone know I’m safely in New Zealand enjoying oxygen- and moisture-rich air. Will post photos and more details tomorrow or as time allows.
|
|
Just a quick one-liner to let everyone know I’m safely in New Zealand enjoying oxygen- and moisture-rich air. Will post photos and more details tomorrow or as time allows.
|
|
Performance Visualization, Capacity planning and Hotsos Symposium
-
tanelpoder.com
-
17 years ago
-
eng
I have slowly moved towards performance visualization and system capacity planning world. Or at least this is my main focus (in addition to deep Oracle internals of course ;) I’ve published an easy Oracle performance visualization tool, which is based on Excel and can visualize the resultset of any SQL query. It’s called PerfSheet (and I’ve blogged about it here ). Last December I spoke at CMG Conference in Las Vegas about a new method..
|
|
Performance Visualization, Capacity planning and Hotsos Symposium
-
tanelpoder.com
-
17 years ago
-
eng
I have slowly moved towards performance visualization and system capacity planning world. Or at least this is my main focus (in addition to deep Oracle internals of course ;) I’ve published an easy Oracle performance visualization tool, which is based on Excel and can visualize the resultset of any SQL query. It’s called PerfSheet (and I’ve blogged about it here ). Last December I spoke at CMG Conference in Las Vegas about a new method..
|
|
The hard choice between duplication, paralysis and chaos A common programmer credo is “Don’t Repeat Yourself” (Pragmatic Programmer) or “Once and only once” (Extreme Programming). Like all credos, we risk following it even when it is not appropriate. The larger truth is that we have choice between three evils: We can duplicate our code, thus duplicating effort, understanding and being forced to hunt down twice. We can share code and affect ..
|
|
Today is a special day in the I-don’t-have-a-life-and-can-prove-it-mathematically geek world…..for today, the epoch will be 1234567890 at precisely 6:31pm (and 30 seconds) Eastern time. UNIX (including Mac OS X) and Linux systems use an internal time called the epoch - it is the number of seconds since January 1st, 1970 (the “birth” of UNIX). This is also why UNIX and Linux geeks weren’t too concerned that their OS was going to blow up a..
|
|
Today is a special day in the I-don’t-have-a-life-and-can-prove-it-mathematically geek world…..for today, the epoch will be 1234567890 at precisely 6:31pm (and 30 seconds) Eastern time. UNIX (including Mac OS X) and Linux systems use an internal time called the epoch - it is the number of seconds since January 1st, 1970 (the “birth” of UNIX). This is also why UNIX and Linux geeks weren’t too concerned that their OS was going to blow up a..
|
|
South Pole Telescope Less than 30 hours to go before we leave, and time is whipping by so fast my ears are starting to ring. As always, the last few days are the big crunch time due to the fact that we have to wait for our holes to freeze completely before turning on new strings. Just a few hours ago we ran the first successful test with all 59 deployed strings. It was very touch and go for awhile since several things didn’t work pro....
|
|
South Pole Telescope Less than 30 hours to go before we leave, and time is whipping by so fast my ears are starting to ring. As always, the last few days are the big crunch time due to the fact that we have to wait for our holes to freeze completely before turning on new strings. Just a few hours ago we ran the first successful test with all 59 deployed strings. It was very touch and go for awhile since several things didn’t work pro....
|
|
South Pole Telescope Less than 30 hours to go before we leave, and time is whipping by so fast my ears are starting to ring. As always, the last few days are the big crunch time due to the fact that we have to wait for our holes to freeze completely before turning on new strings. Just a few hours ago we ran the first successful test with all 59 deployed strings. It was very touch and go for awhile since several things didn’t work pro....
|
|
Improving MapReduce Performance in Heterogeneous Environments](http://www.use nix.com/events/osdi08/tech/full_papers/zaharia/zaharia_html/index.html) " MapReduce is emerging as an important programming model for large-scale data-parallel applications such as web indexing, data mining, and scientific simulation. Hadoop is an open-source implementation of MapReduce enjoying wide adoption and is often used for short jobs where low response tim..
|
|
The following is a trick I don’t use very often, but when I do need it, it comes in very handy. It’s a trick that many developers aren’t aware of, even though it’s been possible to do with JUnit at least since version 3. Sometimes you want to have a lot of tests that are almost the same, but that contain different arguments. For example, for a yahtzee calculator, you might want to have the following tests:
|
|
"Annotations" That Only Appear When a Unit Test Fails
-
www.databasesandlife.com
-
17 years ago
-
eng
I use JUnit , PHPUnit and Perl’s Test::Unit . Perl’s version has a very cool feature. You can call annotate(string) at any point during the test, and this text will get recorded, and only outputted in the case of the test’s failure. sub test_foo { my $self = shift; my $value = setup_something(); $self->annotate("value = $value n"); $self->assert_equals(12, do_something($value)); } So you can just log arbitrary stuff during th..
|
|
If you ever talk to a group of people, you know that the art of presentation is one that requires a lifetime to master. But there are some dirt simple things you can do that will have a positive impact on your presentations. Here is my list of low hanging fruit for presenters: If you’re using a computer, use a presentation remote. This is a cheap and easy way to make your presentation style look a little more professional.
|
|
I frequently get a question about how to find out when was a table last modified. I’m talking about table data, not table structure, the latter would be detectable from dba_objects.last_ddl_time. Unless you have some table level DML auditing already turned on, then as one option you could use LogMiner and “just” work through the redo/archivelogs in the range of interest with it. This could be very time consuming (especially if the last ch....
|
|
I frequently get a question about how to find out when was a table last modified. I’m talking about table data, not table structure, the latter would be detectable from dba_objects.last_ddl_time. Unless you have some table level DML auditing already turned on, then as one option you could use LogMiner and “just” work through the redo/archivelogs in the range of interest with it. This could be very time consuming (especially if the last ch....
|
|
Station as seen through the window of IceCube's Ford "Gran Neutrino" truck Almost exactly one week to go, for me. It is sort of the end of the second act, when you think you know what is going to happen, but surprises can still occur, and the final conflict has yet to sort itself out. Things are going smoothly enough that we (the night crew) were able to watch “The Big Lebowski” in the B1 lounge after midnight. Those who got up early....
|
|
Station as seen through the window of IceCube's Ford "Gran Neutrino" truck Almost exactly one week to go, for me. It is sort of the end of the second act, when you think you know what is going to happen, but surprises can still occur, and the final conflict has yet to sort itself out. Things are going smoothly enough that we (the night crew) were able to watch “The Big Lebowski” in the B1 lounge after midnight. Those who got up early....
|
|
Station as seen through the window of IceCube's Ford "Gran Neutrino" truck Almost exactly one week to go, for me. It is sort of the end of the second act, when you think you know what is going to happen, but surprises can still occur, and the final conflict has yet to sort itself out. Things are going smoothly enough that we (the night crew) were able to watch “The Big Lebowski” in the B1 lounge after midnight. Those who got up early....
|
|
There is a short list of adventures one can have in the US Antarctic program. You can experience landing in the cockpit of a C-130 (done it). You can fly over the crater of Mt. Erebus (done it). You can go to 'Happy Camper’ school and learn how to sleep in your own snow- or ice-shelter (never done it). Here at Pole you can ski out to the 'Love Shack’ a few miles from the Station (never done it). You can do an outdoor hot tub in -30F and fee....
|
|
There is a short list of adventures one can have in the US Antarctic program. You can experience landing in the cockpit of a C-130 (done it). You can fly over the crater of Mt. Erebus (done it). You can go to 'Happy Camper’ school and learn how to sleep in your own snow- or ice-shelter (never done it). Here at Pole you can ski out to the 'Love Shack’ a few miles from the Station (never done it). You can do an outdoor hot tub in -30F and fee....
|
|
There is a short list of adventures one can have in the US Antarctic program. You can experience landing in the cockpit of a C-130 (done it). You can fly over the crater of Mt. Erebus (done it). You can go to 'Happy Camper’ school and learn how to sleep in your own snow- or ice-shelter (never done it). Here at Pole you can ski out to the 'Love Shack’ a few miles from the Station (never done it). You can do an outdoor hot tub in -30F and fee....
|
|
A while back I had to make a decision, as the most senior developer on a team, if we should stick with the Git version control system . Git is extremely popular these days in the open source community. It was developed by Linus Torvalds to manage the Linux source code. And everyone wants to be as cool as Linus. But hold on. Linux is not your average project. Certainly not the average project I work on. Linux is programmed by thousands of..
|
|
caption id="" align=“alignleft” width=“165” caption=“Unstructured picture”][/caption] I recently started on a new project. Looking over the code base, I saw the familiar structure of many projects: Definitions of classes goes here, persistence logic goes over there, interfaces to the persistence logic goes this other place, code for transforming from one structure to another in yet another place and so on. This is common, neat, and unfortun..
|
|
For the past three days I’ve been participating in Global Game Jam - an annual event where people interested in game development get together for 48 hours and make games fitting into a specfied theme in teams. This is the first time I’ve participated (local Game Jams are run regularly in Perth) and I wasn’t sure if I’d be useful at anything.
|
|
Timo and Jan arrived from Mainz today — the last arrivals for IceCube this season. They are working on a system within IceCube to detect stars which explode in or near our galaxy. Our nightshift roster is now complete. Night shift serenade The flight arrives OK, you can stop taxiing now (IceCube Laboratory in the background) Passengers from the Plane
|
|
Timo and Jan arrived from Mainz today — the last arrivals for IceCube this season. They are working on a system within IceCube to detect stars which explode in or near our galaxy. Our nightshift roster is now complete. Night shift serenade The flight arrives OK, you can stop taxiing now (IceCube Laboratory in the background) Passengers from the Plane
|
|
Timo and Jan arrived from Mainz today — the last arrivals for IceCube this season. They are working on a system within IceCube to detect stars which explode in or near our galaxy. Our nightshift roster is now complete. Night shift serenade The flight arrives OK, you can stop taxiing now (IceCube Laboratory in the background) Passengers from the Plane
|
|
Followup to yesterday’s post: then there are the times when you are quietly pedaling the stationary bike in the gym while your iPod plays your favorite audiobook, and a couple of lily-white guys (did I mention it’s mostly lily-white guys here?) come in and crank up some of the more vulgar and un-musical hip-hop on the gym stereo. This is a place of compromises.
|
|
Followup to yesterday’s post: then there are the times when you are quietly pedaling the stationary bike in the gym while your iPod plays your favorite audiobook, and a couple of lily-white guys (did I mention it’s mostly lily-white guys here?) come in and crank up some of the more vulgar and un-musical hip-hop on the gym stereo. This is a place of compromises.
|
|
Followup to yesterday’s post: then there are the times when you are quietly pedaling the stationary bike in the gym while your iPod plays your favorite audiobook, and a couple of lily-white guys (did I mention it’s mostly lily-white guys here?) come in and crank up some of the more vulgar and un-musical hip-hop on the gym stereo. This is a place of compromises.
|