Re: Oracle security vulnerability, nuisance, or paranoia?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 11 Jan 2005 08:47:08 -0800
Message-ID: <41e401e2$1_2@127.0.0.1>

casey.kirkpatrick_at_gmail.com wrote:

> This leads me to another thought - wouldn't it be nice if Oracle
> offered another token "UNLOCKED ONLY", to be used like:
>
> CURSOR C1_CUR IS
> SELECT * FROM T1
> WHERE <conditions>
> FOR UPDATE
> UNLOCKED ONLY;
>
> where "UNLOCKED ONLY" is like a sister command to "NOWAIT" which simply
> ignores any rows which cannot be acquired without a NOWAIT violation?
> Or would there be data integrity violations down that road?

If I understand your intent it already exists.

SELECT ...
FROM ...
WHERE ...

FOR UPDATE NOWAIT SKIP LOCKED; It was created, as I recall, as part of Advanced Replication, and is not documented. Search the archives as Tom Kyte has posted some warnings with respect to its use. I can't find them right now and don't want to rely on my memory.

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


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Received on Tue Jan 11 2005 - 10:47:08 CST