Re: Oracle Manual Lock and blocking

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Jun 2006 07:03:38 -0700
Message-ID: <1149948218.827385.279800@i40g2000cwc.googlegroups.com>

ianal Vista wrote:
> "Mike" <n00spam_at_comcast.net> wrote in news:1149925909.348382.273640
> @h76g2000cwa.googlegroups.com:
>
> > Can someone please confirm that an Oracle manual lock only blocks
> > other's updates and inserts? That is, readers use mult-versioning and
> > therefore are never blocked.
> >
> > Thanks
> > Mike Jr
> >
> >
>
> you are correct
> writers never block readers
> and vice versa

ianal, is correct if the OP is referring to Oracle's default normal locking scheme when he said "manual locks". But these are automatic, implict, locks taken out by Oracle as part of DML processing. The term "manual lock" would seem to have to be either an explicit lock taken via LOCK TABLE commands or USER locks taken via dbms_lock.

Mike, it is important to always try to use official terminology when posting so that board readers properly understand the question and do not waste time posting the right answer to the wrong question.

IMHO -- Mark D Powell -- Received on Sat Jun 10 2006 - 09:03:38 CDT