Re: Lock and latch

Can somone go into this in more detail? There is such a think in Oracle as latch
contention, for which I think you can increase the number of latches. Can someone
explain at what point you should increase the latches and what drawbacks there are?

Mark Powell wrote:

> 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 Tue Nov 10 1998 - 09:06:50 CST