sys vs. "normal " User 2007-09-04 - By Jared Still
Back
On 9/4/07, Jost, J?rg <Joerg.Jost@(protected)> wrote:
>
> At some important points this application locks rows with dbms_lock.
>
> The lockname is the rowid of the row. Sometimes an evil user stays
> forever at this row and other users are unable to change it.
>
>
Just curious - what's wrong with 'SELECT FOR UPDATE' ?
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 9/4/07, <b class="gmail_sendername">Jost, J?rg</b> <<a href="mailto:Joerg
.Jost@(protected)">Joerg.Jost@(protected)</a>> wrote:<div><span class=
"gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
At some important points this application locks rows with dbms_lock.<br><br>The
lockname is the rowid of the row. Sometimes an evil user stays<br>forever at
this row and other users are unable to change it.<br><br></blockquote>
</div><br>Just curious - what's wrong with 'SELECT FOR UPDATE' ?<br
><br clear="all"><br>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time
Perl Evangelist<br>
|
|
