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

Home -> Community -> Usenet -> c.d.o.misc -> What are these locks?

What are these locks?

From: Webster <paul_300_at_yahoo.com>
Date: 19 May 2004 07:59:59 -0700
Message-ID: <62f448f.0405190659.6fe097fb@posting.google.com>


In 9i, when you update a child record, the parent record gets a read lock. However, when we do it, we get read locks on records in the parent table and 70-100 other tables, none of which have referential constraints with the child table. What could cause that?

Thanks for any info. Received on Wed May 19 2004 - 09:59:59 CDT

Original text of this message

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