Re: enque_resources

There's not much about enqueues and DML lock in the mainstream documentation, but if you look at the Oracle Tuning Guide, Release 8.0 (Part No. A58246-01) Chapter 19 you will see a short discourse on DML_LOCKS and ENQUEUE resources in the context of parallel DML ops.

The only other reference in the mainstream documentation is a summary of the above in the Oracle Concepts Guide, Release 8.0.

However, there is probably a good overlap with the user-operated queueing mechanism brought out with Oracle v. 8.X.X so it might be good to look there also.

David P.
Glasgow, Scotland.

Douglas Cowles wrote:
>
> Can you point me to the right Oracle manual for details?
>
> - Dc.
>
> DNP wrote:
>
> > It determines how much resources Oracle gives to the DML locking queue
> > (enqueue). This is a FIFO list of who's wanting locks, what types of
> > locks, on what the lock is requested, and lastly when it was requested.
> >
> > David P.
> >
> > -------------------------------------------------------------------
> >
> > Douglas Cowles wrote:
> > >
> > > WTF? What does this do? No real hits on metalink or technet..
> > >
> > > - Dc.
  Received on Mon Mar 20 2000 - 00:00:00 CST