How to eliminate implicit share locking on a child table

[dba_admin]

How to eliminate implicit share locking on a child table when delete statements are issued against the parent table?

create index on Foreigh key in child? Is this true?

Why?

[chrisrlong]

Yes. This is a fairly well-known 'issue' (ie BUG in my book ) in Oracle.

Here is a link for you:

http://oradoc.photo.net/ora8doc/DOC/...1/ch6.htm#1574

...and here is a previous thread where we discussed the issue:

http://www.dbasupport.com/forums/sho...?threadid=7857

HTH,

- Chris

[cblanco_r]

>create index on Foreigh key in child? Is this true?
Yes this is true

Why?
Because when oracle delete a row it look for every child row.
If exist an index this is faster.

[dba_admin]

Thank you!
Chris, your links are very helpful!