Re: Oracle security vulnerability, nuisance, or paranoia?

Dave wrote:

> back up a sec, readers to not block supposed( in your case) writers in
> oracle

Not necessarily.

SELECT FOR UPDATE a bunch of rows is part of an external process.

What the OP wrote was: "We recently noticed that one of our  > internal processes, which processes and updates values in the staging  > table, was encountering some lock contention issues."

So it is the internal processes performing updates and deletes that are being blocked: Not the inserts.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)