Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> What are these locks?
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
![]() |
![]() |