Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Lock and latch
Latches and locks are both single threading mechanisms. From a high level
practical stand point a lock is associated with a database object obtained
by a user session and is held until a commit or rollback is issued. A
latch is an internal lock obtained by an Oracle background process on
behalf of a user session request and is held only for the duration of the
activity, such as locating an available free buffer for data to be read
into, then released.
Serge Montet <serge.montet_at_wanadoo.com> wrote in article
<71uflg$ija_at_work.wanadoo.com>...
> Hello,
>
> I can't see clearly what is a latch on Oracle, and what's the difference
> with a lock!
>
> Can someone explain to me ?
>
> Thanks.
>
>
>
Received on Fri Nov 06 1998 - 12:27:54 CST