Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: lock Oracle db objects, but only a lock for others?
Mark Townsend <markbtownsend_at_attbi.com> wrote in message news:<6LJoa.282556$OV.330727_at_rwcrnsc54>...
> > So, given that this is bad, I want to know how best to lock what needs to be
> > locked, if it needs to be locked at all (if not, I don't), in such a way as
> > to assure reasonable security (or concurrency, or whatever - you Oracle
> > types can help me out here) for the data while simplifying the code and code
> > maintenance until such time as this company Does The Right Thing and
> > rewrites the entire code base, carefully coached by duely qualified Oracle
> > gurus. That is all.
>
> Read up on DBMS_LOCK at tahiti.oracle.com. Be very careful with it's usage.
I will, Mark.
Thanks
Received on Mon Apr 21 2003 - 10:04:27 CDT
![]() |
![]() |