Re: Nuts and bolts about locking...
Date: 1995/11/29
Message-ID: <49hvgn$cuh_at_news.corpcomm.net>#1/1
wcurtis_at_mindspring.com (William Curtis) wrote:
> Can anyone give an indepth explanation of exclusive row locking, rollback
> segments and slots, latches that are acquired. The resource ID 1&2 refer
> to a rollback segment and slot. When a second resource is attempting to
> modify that same row, why does SQL*DBA indicated contention on the
> resource ID 1& 2 (rollback segment & slot information?)
> Thanks in advance,
> William
> wcurtis_at_mindspring.com
For what its worth, I believe that resource ID 1 (in v$locks) refers to the dba_objects (ie the table name)...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Chris Kasten
Programmer/Analyst (among others...)
#include <sys/std_disclaimer.h>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Wed Nov 29 1995 - 00:00:00 CET