Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Locks rows

Re: Locks rows

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Tue, 21 Jan 2003 10:37:52 -0000
Message-ID: <3q9X9.4292$V6.6525@news.indigo.ie>


And that, HJR should be stamped on every CD Oracle make. "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:AzXW9.28933$jM5.74796_at_newsfeeds.bigpond.com...
> No problem. What you do is uninstall Oracle completely. And then you
replace
> it with a product called SQL Server.
>
> SQL Server is well-known for the way somebody doing an update to a row
> causes all other people who are hoping to select from that table to grind
to
> a halt.
>
> Incidentally, I'm not joking when I say this
>
> But in Oracle, we NEVER do this. Readers don't block writers, and writers
> don't block readers. And readers most certainly never block other
readers!!
> And there is NO way around that. You can do a select which prevents anyone
> else from modifying a record (called a 'select...for update'), but that
> won't stop me *selecting* that record. In Oracle, selects never take locks
> (except for the special case of a 'for update' one) and so they can't
> themselves be in competition for a lock taken by someone else
updating -and
> hence a select can never be 'locked out'.
>
> Regards
> HJR
>
>
> "Francky" <fservantroumey_at_hotmail.com> wrote in message
> news:b0gl1d$119$1_at_news2.isdnet.net...
> > Hello,
> >
> > Sorry for my bad english... I'm French
> >
> > I would like lock rows in table with a select instruction because i dont
> > want that 2 user read simultaneous the data
> >
> >
> > Thank's
> >
> >
> >
>
>
Received on Tue Jan 21 2003 - 04:37:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US