This article details the Oracle Database Administration steps taken to solve a performance issue at a previous client.
Overview: The client had an application in which much of the processing involved a parent and child table. The parent table had an “on delete cascade” constraint.
Problem: The pages in the client application were taking a long time to load and the delete function was taking minutes to finish what should have taken seconds to complete.
Relevant Topics: Dynamic Sampling, Statistics Generation, Locked Tables, Recursive SQL, Unindexed Foreign Keys, Oracle DBA, database systems, database management