Blog: Stewart Ashton


208 blogs updated: 73 min. ago
ODC Appreciation Day: Mike Hichwa's team #ThanksODC
I don't know Oracle's internal organization, but I get the impression that people like Joel Kallman, Jeff Smith and Kris Rice work for or wi...
12
10-10-2017 12:01:48 Stewart Ashton Oracle
Optimistic Locking 6: which ORA_ROWSCN?
Continuing my series on using ORA_ROWSCN to achieve optimistic locking, let's zoom in on ORA_ROWSCN itself. I've been asking myself this que...
6
12-09-2017 16:44:59 Stewart Ashton Oracle
Optimistic Locking 5: "Read-consistent" SCN
Continuing my series on using ORA_ROWSCN to achieve optimistic locking, let's zoom in on the query API and the "read-consistent" SCN of the ...
16
04-09-2017 08:18:40 Stewart Ashton Oracle
Optimistic Locking 4: the Good
After discussing lost updates, the SCN and my theoretical use case, here is my idea for doing SCN-based optimistic locking. I'm going to sim...
11
10-08-2017 18:53:32 Stewart Ashton Oracle
Optimistic ORA_ROWSCN 3: the Use Case
My goal is to show how ORA_ROWSCN can help deal with the problem of "lost updates". Before that, I need to explain the use case I have in mi...
12
31-07-2017 08:08:24 Stewart Ashton Oracle
Optimistic ORA_ROWSCN 2: the SCN
In my previous post, I covered lost updates. Before saying how ORA_ROWSCN can help avoid them, I need to talk about the SCN. It's hard to be...
18
17-07-2017 18:01:03 Stewart Ashton Oracle
Optimistic ORA_ROWSCN 1: Lost Updates
I've gotten lots of feedback about my proposal to use ORA_ROWSCN for optimistic locking. I'm going to start over in more detail and try to l...
9
10-07-2017 15:15:18 Stewart Ashton Oracle
Optimistic Locking with one Timestamp?
A reader called chris asked me a good question about optimistic locking: why not use a "user-defined" scn (e.g. timestamp) as an extra colum...
15
02-07-2017 12:18:30 Stewart Ashton Oracle
More on Optimistic Locking with ORA_ROWSCN
Thanks to comments by Tony Hasler and pingbacks from Jeff Kemp, here's more detail on how optimistic locking works with SCNs, especially wit...
16
22-06-2017 11:32:16 Stewart Ashton Oracle
Optimistic Locking: One SCN to rule them all
Previously I showed how to avoid lost updates with ORA_ROWSCN. Now let's create an API that avoids lost updates with just one SCN. What kind...
13
21-06-2017 16:51:10 Stewart Ashton Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.