Month: June 2007

Oracle, SQL

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 […]