-
Supported version of skip locked?
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…
-
Rant about partitioning licensing
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…
-
Optimistic Locking with ORA_ROWSCN
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…