TweetShareSharePin0 SharesI 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 benefit is that your messages are synchronized with your DML as both are committed in the same transaction. You can find the article here. […]
Author: Mathias
ROWID at Oracle’s Service
TweetShareSharePin0 SharesI 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 with a brief discussion on how ITL works on the block and the relation between ITL and locking on the original block a row was first […]
Speaking at Orcan Conference May 11-13
TweetShareSharePin0 SharesJust 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 general idea is to show more on what happens in the blocks and why and how the rowid a row first gets when it […]
Pro Oracle Application Express Sample Spreadsheet
TweetShareSharePin0 SharesThe 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 not very enjoyable. Since I created it with google docs it is easy to share it, so I figured I’d post a link here […]
Time to resurrect this blog
TweetShareSharePin0 SharesOK. 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, it is now at http://oradbdev.mathiasmagnusson.com and the same feed as before (http://feeds2.feedburner.com/OracleDbDevelopment). Assuming this works and it gets to the blog reader, next post […]
Oracle 11g Launch
TweetShareSharePin0 SharesOracle’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 things in 11g and with the things we’re disappointed to not get in this version. TweetShareSharePin0 Shares
Supported version of skip locked?
TweetShareSharePin0 SharesAs 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 the rowscn for the row/block NULL until the updating/locking transaction completes. That is, any kind of lock and update can be identified when retrieving […]
Rant about partitioning licensing
TweetShareSharePin0 SharesI’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 for the Enterprise Edition of the database at $40,000 per CPU and then pay an additional $10,000 for the partitioning option. That is a […]
Optimistic Locking with ORA_ROWSCN
TweetShareSharePin0 SharesAre 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 a, hopefully, quick example. Let’s first create a user with two tables and add the same data to both tables. Two tables with just […]
Who reads blogs
TweetShareSharePin0 SharesReading 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 average person in the same field. I think it is also something the more internet aware do. Everyone knows about the internet, but how […]