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

Home -> Community -> Usenet -> c.d.o.misc -> Re: lock Oracle db objects, but only a lock for others?

Re: lock Oracle db objects, but only a lock for others?

From: rprgrmr <rprgrmr_at_yahoo.com>
Date: 21 Apr 2003 08:04:27 -0700
Message-ID: <e66a157.0304210704.3f8e6b11@posting.google.com>


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

Original text of this message

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