(ycolin) As you may know, not indexing foreign key can have a huge impact on lock behavior and hurt database scalability (Not only with Oracle).
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help