|
Many people criticize Wal-Mart for the way they run their business. I personally find no problems with it, as their goal is simply to make prices competitive. If you care about the other details then either A. shop else where or B. donate to those causes you feel should be supported with the money you save. While sure some of these qualms may be justified I’d like to hint at another thought, of why people don’t take advantage of the same ap....
|
|
Case study on some rowcache internals, cached non-existent objects and a describe bug
-
tanelpoder.com
-
17 years ago
-
eng
I got a question regarding Metalink note 296235.1 about a describe bug which causes objects to “disappear” when they are described when database is not open. It was an interesting case involving a bug, so I wrote a quite long analysis with test cases today. However when posting the entry to wordpress, it managed to completely mess up the formatting. After wasting half an hour trying to get the formatting correct I gave up and saved the ar..
|
|
Case study on some rowcache internals, cached non-existent objects and a describe bug
-
tanelpoder.com
-
17 years ago
-
eng
I got a question regarding Metalink note 296235.1 about a describe bug which causes objects to “disappear” when they are described when database is not open. It was an interesting case involving a bug, so I wrote a quite long analysis with test cases today. However when posting the entry to wordpress, it managed to completely mess up the formatting. After wasting half an hour trying to get the formatting correct I gave up and saved the ar..
|
|
Live video streaming from your phone might just seem like another form of lifecasting, a video form of twitter, or even a mobile version of ustream.com or justin.tv, but it really is far more than that. A few people have taken these mobile streaming services such as Qik, Flixwagon, and Kyte and really used them to their fullest capacity. Sure you can go to an extreme like Robert Scoble, but admittedly most of his content from Qik can be pre....
|
|
Live video streaming from your phone might just seem like another form of lifecasting, a video form of twitter, or even a mobile version of ustream.com or justin.tv, but it really is far more than that. A few people have taken these mobile streaming services such as Qik, Flixwagon, and Kyte and really used them to their fullest capacity. Sure you can go to an extreme like Robert Scoble, but admittedly most of his content from Qik can be pre....
|
|
Why does even a small difference in SQL text cause a hard parse?
-
tanelpoder.com
-
17 years ago
-
eng
I just replied to an Oracle Forum Thread about why does even a small difference in SQL statement text cause it to be hard parsed and loaded as a different cursor. The reason is actually very simple – and I’m posting it into my blog too: — The reason why a statement with even a minor difference in text is parsed as a separate cursor is due how Oracle looks up statements from library cache.
|
|
Why does even a small difference in SQL text cause a hard parse?
-
tanelpoder.com
-
17 years ago
-
eng
I just replied to an Oracle Forum Thread about why does even a small difference in SQL statement text cause it to be hard parsed and loaded as a different cursor. The reason is actually very simple – and I’m posting it into my blog too: — The reason why a statement with even a minor difference in text is parsed as a separate cursor is due how Oracle looks up statements from library cache.
|
|
Script: Display valid values for multioption parameters (including hidden parameters)
-
tanelpoder.com
-
17 years ago
-
eng
I wrote a little script pvalid.sql for listing valid values for multioption parameters (the ones which are not string, number or boolean type, but accept a parameter from predetermined list, like optimizer_mode which can have values of ALL_ROWS, FIRST_ROWS, CHOOSE, FIRST_ROWS_1, etc). The script accepts a (part of) Oracle parameter name as first argument, for example the following output is from Oracle 10.2.0.3 database: SQL> @pvalid ....
|
|
Script: Display valid values for multioption parameters (including hidden parameters)
-
tanelpoder.com
-
17 years ago
-
eng
I wrote a little script pvalid.sql for listing valid values for multioption parameters (the ones which are not string, number or boolean type, but accept a parameter from predetermined list, like optimizer_mode which can have values of ALL_ROWS, FIRST_ROWS, CHOOSE, FIRST_ROWS_1, etc). The script accepts a (part of) Oracle parameter name as first argument, for example the following output is from Oracle 10.2.0.3 database: SQL> @pvalid ....
|
|
So traditionally I’ve been a very do it yourself person. I wanted to be the person that didn’t have to rely on anyone, and thus far it’s worked pretty well. I can handle my day to day chores, as well as do my job, and most any side project of venture I take on I feel like I can accomplish pretty well. However, I recently asked my question if that was the best approach. While it’s good to be self reliant, the people at the top seldom do ever....
|
|
So traditionally I’ve been a very do it yourself person. I wanted to be the person that didn’t have to rely on anyone, and thus far it’s worked pretty well. I can handle my day to day chores, as well as do my job, and most any side project of venture I take on I feel like I can accomplish pretty well. However, I recently asked my question if that was the best approach. While it’s good to be self reliant, the people at the top seldom do ever....
|
|
More cycling event photos - a bunch of images from the Rollapaluza XI race last night at the Kingpin Suite in Bloomsbury. Lycra skinsuits meets cycling campaigns meets drunken cyclists. Beer, rollers and endorphins - what more do you need? (Click the image for the full gallery ).
|
|
More cycling event photos - a bunch of images from the Rollapaluza XI race last night at the Kingpin Suite in Bloomsbury. Lycra skinsuits meets cycling campaigns meets drunken cyclists. Beer, rollers and endorphins - what more do you need? (Click the image for the full gallery ).
|
|
In the coming weeks I’m going to be working with a friend to help his venture in a new partnership that someone has approached him about. This partnership is rather large and I’m not at liberty to disclose details yet, and while this is indeed great news for the site, the great news for users is the site is already fully available. In short fotoviewr is one half of an online photo album, it doesn’t store your photos for you, but allows yo....
|
|
In the coming weeks I’m going to be working with a friend to help his venture in a new partnership that someone has approached him about. This partnership is rather large and I’m not at liberty to disclose details yet, and while this is indeed great news for the site, the great news for users is the site is already fully available. In short fotoviewr is one half of an online photo album, it doesn’t store your photos for you, but allows yo....
|
|
At a conversation today we got into a discussion about how ebay can compete with amazon. Which alone is enough content for an entire post, as they really aren’t playing the same game so not really competing. Instead I’d like to talk about where the conversation progressed to. To me the most interesting thing about ebay isn’t how they won the long tail, or how users are unhappy with the increasing costs placed on them. Instead its more at th....
|
|
At a conversation today we got into a discussion about how ebay can compete with amazon. Which alone is enough content for an entire post, as they really aren’t playing the same game so not really competing. Instead I’d like to talk about where the conversation progressed to. To me the most interesting thing about ebay isn’t how they won the long tail, or how users are unhappy with the increasing costs placed on them. Instead its more at th....
|
|
The simplest query for checking what’s happening in a database
-
tanelpoder.com
-
17 years ago
-
eng
Update: If you are able to download & run scripts, it’s probably better to use my Snapper and @ashtop.sql tools for performance analysis. Neither of these scripts require any installation, Ashtop requires Diagnostics Pack (as it uses ASH), Snapper doesn’t even need that - it can also run on Standard Edition! Search for them in my blog, or check an intro video in my YouTube channel . When someone asks you to take a quick look into d..
|
|
The simplest query for checking what’s happening in a database
-
tanelpoder.com
-
17 years ago
-
eng
Update: If you are able to download & run scripts, it’s probably better to use my Snapper and @ashtop.sql tools for performance analysis. Neither of these scripts require any installation, Ashtop requires Diagnostics Pack (as it uses ASH), Snapper doesn’t even need that - it can also run on Standard Edition! Search for them in my blog, or check an intro video in my YouTube channel . When someone asks you to take a quick look into d..
|
|
ETech 2009 , the O'Reilly conference on emerging technologies now has a call for papers . Here is my proposal for the "Nomadism & Shedworking" track: The recent direction of business applications has been centralization to web-based systems, easing deployment, upgrades and management of application security. However, at same time centralization provides new risks like the introduction of a single point of failure for application us....
|
|
As a frequent traveler , I've been long thinking about getting proper noise-cancelling headphones . Now, en-route to a Haedong Kumdo seminar in Ireland I managed to forget my usual headphones home, and so it was time to take the plunge. Here is a quick review: First impression: wow, quite a lot of cable to carry around. I got used to too good with the Bluetooth headphones which my iPhone 3G unfortunately doesn't support The no....
|
|
On Saturday I was in Ballina , Ireland, and a bit nervous : there was a Haedong Kumdo seminar in town, and I was scheduled to test for black belt . Behind this was years of different sword arts, like viking swordfighting , Iaido , Kendo , sabre fencing , and two years of quite intense Haedong Kumdo practice . We tested together with two Swedes who already held black belt in the other federation. All three passed . So what....
|
|
When you call us to have your computer moved, be sure to leave it buried under half a ton of postcards, baby pictures, stuffed animals, dried flowers, bowling trophies and children’s art. We don’t have a life, and we find it deeply moving to catch a fleeting glimpse of yours. Don’t write anything down. Ever. We can play back the error messages from here. When an IT person says he’s coming right over, go for coffee. That way you won’..
|
|
When you call us to have your computer moved, be sure to leave it buried under half a ton of postcards, baby pictures, stuffed animals, dried flowers, bowling trophies and children’s art. We don’t have a life, and we find it deeply moving to catch a fleeting glimpse of yours. Don’t write anything down. Ever. We can play back the error messages from here. When an IT person says he’s coming right over, go for coffee. That way you won’..
|
|
In Oracle 11g even more library cache operations have been changed to use KGX mutexes instead of latches. In Oracle 10.2.0.2+ the library cache pin latch usage was replaced with mutexes whenever _kks_use_mutex_pin was true, also few other things like V$SQLSTATS arrays and parent cursor examination were protected by mutexes. However the traversing of library cache hash chains (the right child cursor lookup using kksfbc()) was still pro....
|
|
In Oracle 11g even more library cache operations have been changed to use KGX mutexes instead of latches. In Oracle 10.2.0.2+ the library cache pin latch usage was replaced with mutexes whenever _kks_use_mutex_pin was true, also few other things like V$SQLSTATS arrays and parent cursor examination were protected by mutexes. However the traversing of library cache hash chains (the right child cursor lookup using kksfbc()) was still pro....
|
|
A couple of Sundays ago I went up to watch the grass track racing in Hackey, arranged by Hackney CC - finally got a moment to upload the photos! Full gallery is here , selected others below!
|
|
A couple of Sundays ago I went up to watch the grass track racing in Hackey, arranged by Hackney CC - finally got a moment to upload the photos! Full gallery is here , selected others below!
|
|
I’ve been working on a number of bits of code recently, and have found that it’s not entirely practical to check into RCS or SVN for every change that I’ve made. I really like to work by committing when I’ve finished adding a feature to a script, or a project. Hence, I’ve been using the vim “set backup” option. However, this has some limitations, and hence I decided to have a look at what .vimrc could do for me.
|
|
I’ve been working on a number of bits of code recently, and have found that it’s not entirely practical to check into RCS or SVN for every change that I’ve made. I really like to work by committing when I’ve finished adding a feature to a script, or a project. Hence, I’ve been using the vim “set backup” option. However, this has some limitations, and hence I decided to have a look at what .vimrc could do for me.
|
|
Looks like 2008 is forming up to be a quite busy conference year, at least looking at my Dopplr page . Here are the events I'm speaking (or performing as is the case with Haedong Kumdo ) in this fall: Aug 2nd: Haedong Kumdo Seminar in Mayo, Ireland: part of the Finnish team Aug 9th - 10th: aKademy in Sint-Katelijne-Waver, Belgium: Location-aware applications with GeoClue (Aug 10th at 10:45 in Room 1) Aug 23rd - 24th: F..
|
|
Stand up and be counted. Which one do you think is best of the following? Package by layer: com.app.controllers com.app.model com.app.repositories com.app.exception Or package by feature: com.app.orders com.app.invoices com.app.products I recently added a new site to my RSS reader. John O’Hanly just published a though provoking article about harmful java code idioms on JavaWorld. I don’t agree with everything he suggests, but I do find his ..
|
|
A reader wrote to me with the following question. It’s a topic I used to wonder about a lot too. I’m trying to write a 2D fillAntiAliasedTriangle() method in Java and trying to understand why everyone is using supersampling (that is, rendering at a higher resolution and then scaling down a grid of NxN subpixels into one pixel) rather than computing everything geometrically? (Say, your line cuts a triangle off a pixel to half its area, t..
|
|
Social advertising is a very different than traditional web advertising. The thing about social media advertisers, is users aren’t looking for a product. They’re already engaged in some activity, and don’t necessarily want to be drawn away from that. But that does not mean there isn’t value in it, it’s just a different form of value than search advertising. When a user is searching from google, they are actually looking for something. The....
|
|
Social advertising is a very different than traditional web advertising. The thing about social media advertisers, is users aren’t looking for a product. They’re already engaged in some activity, and don’t necessarily want to be drawn away from that. But that does not mean there isn’t value in it, it’s just a different form of value than search advertising. When a user is searching from google, they are actually looking for something. The....
|
|
Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX
-
tanelpoder.com
-
17 years ago
-
eng
In my last AOT post I published my LatchProf script which is able to sample detailed latchholder data from V$LATCHHOLDER. Latchprof allows you to drill down into your latching problems at session level (which V$LATCH, V$LATCH_PARENT and V$LATCH_CHILDREN can’t do). It allows you to get valuable details about individual sessions who are holding a latch the most, therefore likely contributing to the latch contention problem the most. ..
|
|
Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX
-
tanelpoder.com
-
17 years ago
-
eng
In my last AOT post I published my LatchProf script which is able to sample detailed latchholder data from V$LATCHHOLDER. Latchprof allows you to drill down into your latching problems at session level (which V$LATCH, V$LATCH_PARENT and V$LATCH_CHILDREN can’t do). It allows you to get valuable details about individual sessions who are holding a latch the most, therefore likely contributing to the latch contention problem the most. ..
|
|
This Norwegian languauge article pertains to an article in the Norwegian news magazine “Ny Tid” and my letter to the editor. (Dette er mitt debattinnlegg som ble publisert i Ny Tid 11. juli. Innlegget er oppfølging til Christian Lundestads veldig gode artikkel om åpen kildekode i ny tid 27. juni.) Som lead software arkitekt i Bankens [sic] Betalingssentral (BBS), leste jeg Christian Lundestads artikkel om åpen kildekode i Ny Tid 25/2008 med..
|
|
Anyone who has written any graphics or text manipulation software will know the following problem: Each character or object has a particular style, for example the size of the writing, the thickness of the stroke, etc. There is some user interface element e.g. a dialog or rollup where the user can view and edit the attribute of the currently selected object The user may select multiple objects And there we have it: the user selects two ..
|
|
I find it extremely amusing that Microsoft and Apple are in many senses the very same company, at least in their actions, yet people feel very different about the two. For the average person they aren’t really a fan of Microsoft, and many love Apple. While I’m not really suggesting anyone should love Microsoft, why are people such Apple fanboys. Apple makes the same bad moves as Microsoft, they control their software and limit functionality....
|
|
I find it extremely amusing that Microsoft and Apple are in many senses the very same company, at least in their actions, yet people feel very different about the two. For the average person they aren’t really a fan of Microsoft, and many love Apple. While I’m not really suggesting anyone should love Microsoft, why are people such Apple fanboys. Apple makes the same bad moves as Microsoft, they control their software and limit functionality....
|
|
Here’s an interesting issue I found when running a query using WITH subquery factoring when database was not open (it was in NOMOUNT mode in current case). As you probably know you can query DUAL table when database is not open, but in this case the actual query is made against X$DUAL as seen below: SQL> select * from dual; ADDR INDX INST_ID DUM -------- ---------- ---------- --- 051ED14C 0 1 X SQL> When you have above fields when ..
|
|
Here’s an interesting issue I found when running a query using WITH subquery factoring when database was not open (it was in NOMOUNT mode in current case). As you probably know you can query DUAL table when database is not open, but in this case the actual query is made against X$DUAL as seen below: SQL> select * from dual; ADDR INDX INST_ID DUM -------- ---------- ---------- --- 051ED14C 0 1 X SQL> When you have above fields when ..
|
|
Facebook applications to check out, Windows: Digsby - Facebook Im on your desktop Fonebook - sync outlook and facebook iDeskbook - Browse facebook on the desktop Photosaver - Friends photos as your screensaver OSx: Friend Photos Screensaver - Friend’s photos as your screensaver Facebook exporter for iphoto Adium - Chat with facebook support Photobook - Miss your camera at an event, just steal your friends album EventSync - Sync event ca..
|