I have just uploaded an article I wrote almost five years ago to the day. It was my first attempt and I wrote about Oracle AQ which is Oracle version of a messaging product. AQ is included with the database and has a lot of nice features including full support for XML payloads. Another important…
I have just posted a lengthy article about how Oracle uses rowid. It starts with talking about blocks , and how they work. Then I discuss how rowid are used and represented in symbolic dumps. Normal uses such as index linking to a data segment as well as migrated and chained rows are discussed. The document finishes…
Just a quick note that I have accepted to speak at the conference the Swedish Oracle User Group Orcan will hold May 11-13. The subject will be on rowid, ITL, and row migration where I hope to show it both from the block level view and a little showing it from the OWI view. THe…
The excellent book Pro Oracle Application Express book by John Scott builds an application through the book and it starts with a sample spreadsheet showing a set of reported bugs. I was not able to find a downloadable version of this so I created it. Not much work and very easy to do, but also…
OK. This blog has been dormant for longer than what should have been possible. Having moved across the world, started a new job, and returned career focus to Oracle specialist (from more or less forced management roles) it’s definitely time to start writing again. The first step has been to move it to a proper blog platform,…
Oracle’s launch of database 11g will be webcasted. It starts at 10 AM ET. Unfortunately I’ll probably miss the live webcast as we’re wrapping up visits and packing today to fly out early tomorrow to return back to Colorado. I’m sure the coming week will be filled with blogs and articles about all the exciting…
As Pawel showed in his post some details about how the row scn technology works in specific situations isn’t as well documented as you’d wish. I asked Oracle development to clarify the questions I had and the answer back was both interesting and useful. Every kind of update and lock on a row will make…
I’ll give myself a quota for no more than one rant a month. However, one of my pet peeves is how Oracle licenses the database. I’l probably return to why I dislike the general model in a future rant, but this on e will be specific to partitioning. To use partitioning, you have to pay…
Are you using 9i/10G and still implement optimistic locking with your own column rather than through Oracle’s pseudo column? So am I, but I couldn’t really explain why. My main (defensive) argument would be that the system was built long before 9i. Still, it would make sense for us to change it. Let’s look at…
Reading this post about why the average Oracle IT worker doesn’t read blogs got me thinking. Does the average IT worker read blogs? I’m not sure. In what I have observed, it is something a segment does. I’d contend that the average blog reader is more advanced and more thirsty for more knowledge that the…
Sign up with your email address to receive our weekly news