Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: enqueue waits

Re: enqueue waits

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 2 Aug 2005 10:54:48 -0700
Message-ID: <bf4638050802105457b576e@mail.gmail.com>


The enqueues (locks) are occurring because another session has an incompatible lock mode.

A DELETE needs SX (sub exclusive lock) mode to perform the delete. Any session holding a higher mode lock (S, SSX, X) will block this operation.

Examine the DBA_LOCKS and DBA_WAITERS views to determine which sessions are blocking.

A good explanation is found in MetaLink note 15476.1, along with several scripts.

Also read the Concepts manual, as it goes into some detail on this. Data Concurrency and Consistency:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/consist.htm#g43931

HTH Jared

On 8/2/05, raja rao <raja4list_at_yahoo.com> wrote:
>
> Hi All,
> When i try to delete few rows (4 rows) from the table
> bom.cst_item_cost_details (oracle apps 11.5.9), i observed that the
> session is waitng on enqueues.
> (The above table is too big, it has 20 million records in it.)
> But could not get much info what is the child table on which it is
> serching.
> Can someone throw somelight how to understand and find the root cause of
> these enqueus.
> what even could help understand the root cause .
> Thanks,
> Raj
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 02 2005 - 12:57:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US