I am not sure, but here's what I learned from reading this forum.
Bec. the FK is not index, when you do a delete from the
parent table, oracle does a full tables scan on the child table for
data integrity purposes. You can truncate your child table or have FK on your child table index.

[Edited by tekion on 02-06-2002 at 02:02 PM]